Survey of Consumer Finances, Inheritance Extract

An Extract from the survey of consumer finances for studying networth and ineritance, from multiple years

federalreserve.gov-consumer_finances-2016e2019-inherit-1.2.3. Modified 2020-11-14T20:15:25

Resources | Packages | Documentation| Contacts| References| Data Dictionary

Resources

Documentation

This is an extract of the 2016 and 2019 Survey of Consumer Finances, with extracted variables and recoded variables oriented toward studying inheritance.

Images

  • Net Worth by Income Percentile and Race

Contacts

Data Dictionary

inherit_scf_16_19

inherit_scf_16_19

Column NameData TypeDescription
yearintegerYear of the SCL reelase the record was drawn from
case_idinteger
record_idinteger
implicate_idintegerImpicate number, 1 to 5
age_1integerAge of first household adult
age_2integerAge of second household adult.
hispintegerIs the HH Hispanic
racestringSimpified race for HH
addtional_raceinteger
unusual_incomeinteger
ed_1string
ed_2string
ed_mother_1string
ed_father_1string
ed_mother_2string
ed_father_2string
occ_1integer
occ_2integer
gi_other_valueinteger
fin_riskinteger
shop_creditinteger
shop_credit_2integer
fin_knowinteger
borrow_vacationinteger
plan_horizoninteger
spend_exceedsinteger
spend_exceeds_excl_houseinteger
wt0numberHH weight
gi_type_1string
gi_value_1integer
gi_year_1integer
gi_from_1integer
gi_type_2string
gi_value_2integer
gi_year_2integer
gi_from_2integer
gi_type_3string
gi_value_3integer
gi_year_3integer
gi_from_3integer
networthnumber
incomenumber
nwcatinteger
nwpctlecatinteger
normincnumber
ninccatinteger
ninc2catinteger
nincpctlecatinteger
occat1integer
occat2integer
edclstring
lifeclinteger
famstructinteger
marriedinteger
ageclstring
houseclinteger
raceclinteger
racecl4integer
assetnumber
liqnumber
bondnumber
finnumber
nfinnumber
debtnumber
indcatinteger
equitynumber
homeeqnumber
revpaynumber
bnkruplast5integer
debt2incnumber
hsavinginteger
savedinteger
educationstring
occinteger
lt_plannerinteger
nincpctleinteger
nincinteger
nwpctleinteger
gi_sumintegerSum of the value of gift, trust or inheritance transfers
n_giftintegerNumber of gift transfers
n_inheritintegerNumber of inheritance transfers
n_trustintegerNumber of trust transfers
n_transferintegerNumber of gift, trust or inheritance transfers
any_transferintegerHas HH recieved any transfer?
any_inheritintegerHas HH recieved and inheritance?
hhsizeintegerHousehold size. Actually the number of financially contributing adults in the analysis unit, either 1 or 2.
networthpcnumberNetworth divided by hhsize
assetpcnumberAssets divided by hhsize
gi_pv_10numberValue of each gift or transfer, compounded ot the present at 10%
gi_pv_7numberValue of each gift or transfer, compounded ot the present at 7%
gi_pv_5numberValue of each gift or transfer, compounded ot the present at 5%
gi_value_cdnumberSum of transfers, with each transfer inflated to current dollars

References

Urls used in the creation of this data package.

  • metapack+http://library.metatab.org/federalreserve.gov-consumer_finances-1.1.1.csv. Survey of consumer finances data packages
  • cpi. Consumer Price Index

Packages

Accessing Data in Vanilla Pandas

import pandas as pd


inherit_scf_16_19_df =  pd.read_csv('http://library.metatab.org/federalreserve.gov-consumer_finances-2016e2019-inherit-1.2.3/data/inherit_scf_16_19.csv')

Accessing Package in Metapack

import metapack as mp
pkg = mp.open_package('http://library.metatab.org/federalreserve.gov-consumer_finances-2016e2019-inherit-1.2.3.csv')

# Create Dataframes
inherit_scf_16_19_df = pkg.resource('inherit_scf_16_19').dataframe()