LWS - United States 2007 : household file Codebook generated: 2016-06-24 ------------------------------------------------------------------------------------------------------------------------------------------------ IDENTIFIERS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hid unique unit identifier 22085 1 4423 2212.97 1276.5 did unique country/year number -------------------------------------------------- N value 22085 207 dname country/year identifier -------------------------------------------------- N value 22085 "us07" cname country name -------------------------------------------------- N value 22085 "United States" iso2 2-letter country abbreviation -------------------------------------------------- N value 22085 "us" year reference year -------------------------------------------------- N value 22085 2007 wave data wave -------------------------------------------------------------------------------- N code label 22085 7 Wave VII ------------------------------------------------------------------------------------------------------------------------------------------------ FILE INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hwgt household weight (normalised) 22085 0 6.44 2.26 1.47 hpopwgt household weight (inflated) 22085 3.71 74773.26 26286.5 17078.5 inum implicate number 22085 1 5 3 1.41 svyunit survey unit -------------------------------------------------------------------------------- N code label 22085 2 economic family ------------------------------------------------------------------------------------------------------------------------------------------------ GEOGRAPHICAL CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ DWELLING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ own owned/rented housing -------------------------------------------------------------------------------- N code label 20 100 owned 6243 110 owned outright 10212 120 owned with mortgage 5285 210 rented 320 220 free housing 5 . dweltyp type of dwelling -------------------------------------------------------------------------------- N code label 14400 100 house 1465 200 multi-unit residential building 825 310 movable dwelling 5395 . NOTES: 1. [us07] Missings (.) represents those who live in a house/townhouse/apartment and pay rent. ------------------------------------------------------------------------------------------------------------------------------------------------ FARMING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ farm farm household (dummy) -------------------------------------------------------------------------------- N code label 21530 0 not farm household 555 1 farm household agriland ownership of agricultural land -------------------------------------------------------------------------------- N code label 555 100 owns or rents agricultural land 21530 200 does not own nor rent agricultural land farming farming activity -------------------------------------------------------------------------------- N code label 220 100 runs a farming activity 21865 200 does not run a farming activity ------------------------------------------------------------------------------------------------------------------------------------------------ HOUSEHOLD COMPOSITION ------------------------------------------------------------------------------------------------------------------------------------------------ hhtype household composition -------------------------------------------------------------------------------- N code label 5210 100 one person household 7310 210 couple without children 6880 220 couple with children 1720 230 one parent with children 225 310 couple without children and relatives 245 320 couple with children and relatives 130 330 one parent with children and relatives 225 400 relatives living together (no family nucleus) 25 510 couple without children and nonrelatives 45 520 couple with children and nonrelatives 15 530 one parent with children and nonrelatives 5 610 couple without children and relatives and nonrelatives 10 620 couple with children and relatives and nonrelatives 35 800 nonrelatives living together 5 . hpartner head living with partner -------------------------------------------------------------------------------- N code label 5 100 head living with partner 13370 110 married couple 1370 120 non-married cohabiting couple 7335 200 head not living with partner 5 . nhhmem number of household members -------------------------------------------------------------------------------- N code label 5215 1 1 hh member 8340 2 2 hh members 3405 3 3 hh members 3005 4 4 hh members 1360 5 5 hh members 530 6 6 hh members 135 7 7 hh members 55 8 8 hh members 25 9 9 hh members 10 10 10 hh members 5 13 13 hh members nhhmem65 number of household members 65 or older -------------------------------------------------------------------------------- N code label 16960 0 no hh members 65 or older 3190 1 1 hh member 65 or older 1925 2 2 hh members 65 or older 5 3 3 hh members 65 or older 5 . nhhmem17 number of household members 17 or younger -------------------------------------------------------------------------------- N code label 14380 0 no hh members 17 or younger 3030 1 1 hh member 17 or younger 2940 2 2 hh member 17 or younger 1165 3 3 hh member 17 or younger 420 4 4 hh member 17 or younger 95 5 5 hh member 17 or younger 20 6 6 hh member 17 or younger 20 7 7 hh member 17 or younger 10 8 8 hh member 17 or younger 5 . ------------------------------------------------------------------------------------------------------------------------------------------------ CURRENT INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ NOTES: hiap: 1. [us07] the amounts refer to net income from Social Security or other pensions, annuities, or other disability or retirement programs(IRS form 1040 line number 16a,20a). Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hi total income, household 21970 -1543000 1.82e+08 833307 5e+06 hil labour income, household 22035 -910000 29750000 206502 1100000 hile paid employment income, household 22085 0 3e+07 161657 924779 hils self-employment income, household 22035 -1e+06 28370000 44505.3 667155 hic capital income, household 22015 -840000 181700000 613337 4800000 hicid interest and dividends, household 22085 0 43856000 151162 1200000 hit transfer income, household 22085 0 2560000 10103.7 51267.3 hits social security transfers, household 22085 0 1350000 9234.72 34054.3 hitsi work-related insurance transfers, household 22085 0 1350000 8914.93 34085.7 hitsa assistance benefits, household 22085 0 27000 319.79 1619.89 hitp private transfers, household 22085 0 2560000 868.95 38518.6 hitpih inter-household transfers, household 22085 0 2560000 868.95 38518.6 hiap total pension income, household 22085 0 1350000 8755.85 34085.9 ------------------------------------------------------------------------------------------------------------------------------------------------ WINDFALL INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hwc windfall capital income, household 22085 -1e+06 64960000 236326 2100000 hwcg capital gains, household 22085 -1e+06 64960000 236326 2100000 ------------------------------------------------------------------------------------------------------------------------------------------------ NON-CONSUMPTION EXPENDITURE ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hxit income taxes and social contributions, household 22085 -3197 70836752 317468 1900000 hxiti income taxes, household 22085 -5654 70816808 307354 1900000 hxits social security contributions, household 22085 0 881681 10113.9 28193.6 hxot other taxes, household 22085 0 466000 5898.14 14693.1 hxotp property taxes, household 22085 0 466000 5898.14 14693.1 hxih inter-household transfers paid, household 22085 0 52680000 23939.8 797739 hxch donations to charity, household 22085 0 34930000 72950.8 766380 ------------------------------------------------------------------------------------------------------------------------------------------------ CONSUMPTION ------------------------------------------------------------------------------------------------------------------------------------------------ NOTES: hcresto: 1. [us07] includes only amounts spend on food delivered to the customer's home as well as eating out. Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hcfood food and non-alcoholic beverages, household 22085 0 104000 6692.11 5477.62 hchous housing and utilities, household 22085 0 252000 2338.44 8159.58 hchousa actual rent, household 22085 0 252000 2338.44 8159.58 hcresto restaurants and hotels, household 3272 0 126800 6284.96 8936.09 ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS - LIABILITIES TRANSACTIONS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hts proceeds from sales, household 22085 0 1540000 3676.42 35496.4 htsf sales of financial products, household 22085 0 1540000 3676.42 35496.4 htil inflows from loans, household 22070 0 21560000 68524.8 567017 htilm mortgage, household 22085 0 4200000 28192.6 180681 htilo other loans, household 22085 0 21560000 42560 573039 htilr repayments from borrowings, household 22070 0 1210000 1053.53 21354.5 htp purchases, household 22085 0 5200000 21195.6 182427 htpr purchases of real estate, household 22085 0 5200000 21195.6 182427 htol outflows from loans, household 21710 0 9304000 37712.5 244578 htolm mortgage repayments, household 22065 0 360000 11767.5 26439.1 htolo other loans repayments, household 21730 0 9304000 26123.4 240786 ------------------------------------------------------------------------------------------------------------------------------------------------ MAJOR AGGREGATES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- dhi disposable household income 21970 -13280526 111200000 514604 3100000 ------------------------------------------------------------------------------------------------------------------------------------------------ ADDITIONAL INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ currency currency units -------------------------------------------------------------------------------- N code label 22085 840 USD - US Dollar Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- deflator deflation factor 22085 1 1 1 0 grossnet gross/net income information -------------------------------------------------------------------------------- N code label 22085 120 gross, taxes and contributions imputed ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- han non-financial assets 22085 0 1.375e+09 7500000 4.1e+07 hanr real estate 22085 0 312700000 1900000 8200000 hanrp principal residence 22085 0 158900000 809423 3100000 hanro other real estate 22085 0 261900000 1100000 6500000 hann non-housing assets 22085 0 1.337e+09 5500000 3.7e+07 hannb business equity 22085 0 1.327e+09 5300000 3.6e+07 hannc consumer goods 22085 0 1e+08 250651 2600000 hanncv vehicles 22085 0 89030000 113934 1500000 hanncd other durables and valuables 22085 0 1e+08 136717 2100000 hanno other non-financial assets 22085 0 6.3e+07 30429 1e+06 haf financial assets (excluding pensions) 22085 0 730900000 4800000 2.7e+07 hafc deposit accounts and cash 22085 0 100100000 401941 2800000 hafi financial investments 22085 0 712800000 4300000 2.5e+07 hafib bonds and other debt securities 22085 0 2.06e+08 531867 5200000 hafis stocks and other equity 22085 0 712800000 2300000 1.8e+07 hafii investment funds and alternative investments 22085 0 5e+08 1500000 1.1e+07 hafo other non-pension financial assets 22085 0 5e+07 73877.8 1100000 hasi life insurance and voluntary individual pensions 22085 0 5e+07 315965 1400000 hasil life insurance accounts 22085 0 2e+07 60179.9 530929 hasip individual voluntary pension accounts 22085 0 5e+07 255785 1200000 hasodc occupational pensions (DC schemes) 22085 0 53550000 66871.9 862616 ------------------------------------------------------------------------------------------------------------------------------------------------ LIABILITIES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hl total liabilities 22085 0 59746000 287839 1500000 hlr real estate liabilities 22085 0 20910000 171828 581528 hlrp principal residence loans 22085 0 5840000 119650 308051 hlro other real estate loans 22085 0 20910000 52178.1 432562 hln non-housing liabilities 22085 0 57370000 116011 1300000 hlni investment loans 22085 0 5e+07 76197.2 1200000 hlnc consumer goods loans 22085 0 13750000 33202 309689 hlncv vehicle loans 22085 0 13750000 17024.6 298921 hlncd other loans for goods and consumption 22085 0 2090000 16177.4 82559.9 hlne education loans 22085 0 250000 2721.22 12383.9 hlno other non-housing liabilities 22085 0 6e+06 3890.43 111809 hlsr institutional loans secured by real estate 22085 0 20910000 197048 670674 hlsrp secured by principal residence 22085 0 19880000 144870 446816 hlsro secured by other real estate 22085 0 20910000 52178.1 432562 hlsn loans not secured by real estate 22085 0 7.87e+08 682649 1.3e+07 hlsng guaranteed institutional loans 22085 0 7.87e+08 652877 1.3e+07 hlsnn non-guaranteed institutional loans 22085 0 6e+06 7985.33 112848 hlsni informal (non-institutional) loans 22085 0 1900000 885.88 31205.7 ------------------------------------------------------------------------------------------------------------------------------------------------ HOUSEHOLD NET WORTH ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- dnw disposable net worth 22085 -513700 1.412e+09 1.2e+07 5.6e+07 anw adjusted disposable net worth 22085 -473700 1.412e+09 1.2e+07 5.6e+07 ------------------------------------------------------------------------------------------------------------------------------------------------ CONTINGENT ASSETS, LIABILITIES AND RELATED VARIABLES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- cir expects to receive inheritance/gift 22085 0 1 0.15 0.36 cia1 amount of expected inheritance/gift,(1) 22085 0 174500000 326859 4400000 cig expects to give inheritance/gift 22085 0 2 0.85 0.72 chc home equity line of credit (dummy) 22085 0 1 0.16 0.36 cha amount of home equity line of credit 22081 0 8840000 27557.5 169984 cnc non-home equity lines of credit (dummy) 22085 0 1 0.05 0.22 cna amount of non-home equity lines of credit 22082 0 2.4e+07 39659.3 618002 ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS ACQUIRED IN THE PAST AND RELATED VARIABLES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- ppr purchase price of principal residence 22085 0 32660000 354443 1200000 ppy year of purchase of principal residence 16455 1947 2008 1993.43 12.21 pir inheritance/gift received (dummy) -------------------------------------------------------------------------------- N code label 16333 0 did not receive inheritance/gift 5752 1 received inheritance/gift Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- pia1 amount of inheritance/gift received,(1) 22085 0 5e+07 127726 1300000 pia2 amount of inheritance/gift received,(2) 22085 0 7500000 15399.7 190790 pia3 amount of inheritance/gift received,(3) 22085 0 4500000 3582.56 79932.2 pia4 amount of inheritance/gift received,(4) 22085 0 4600000 2345.93 73546.6 piy1 year inheritance/gift received,(1) 5757 1945 2005 1994.67 11.82 piy2 year inheritance/gift received,(2) 1687 1945 2005 1991.99 13.04 piy3 year inheritance/gift received,(3) 427 1945 2005 1989.19 14.25 pit1 type of inheritence/gift received,(1) -------------------------------------------------------------------------------- N code label 4689 20 financial 1068 30 both non-financial and financial 16328 . pit2 type of inheritence/gift received,(2) -------------------------------------------------------------------------------- N code label 1366 20 financial 321 30 both non-financial and financial 20398 . pit3 type of inheritence/gift received,(3) -------------------------------------------------------------------------------- N code label 309 20 financial 118 30 both non-financial and financial 21658 . piw1 from whom inheritance/gift received,(1) -------------------------------------------------------------------------------- N code label 866 1 grandparent(s)(incl in-laws) 4081 2 parent(s)(incl in-laws) 143 3 sibling(s)(incl in-laws) 5 4 child(ren)(incl in-laws) 572 5 other relative(s) 90 6 non-relative(s) 16328 . piw2 from whom inheritance/gift received,(2) -------------------------------------------------------------------------------- N code label 230 1 grandparent(s)(incl in-laws) 1158 2 parent(s)(incl in-laws) 31 3 sibling(s)(incl in-laws) 11 4 child(ren)(incl in-laws) 219 5 other relative(s) 38 6 non-relative(s) 20398 . piw3 from whom inheritance/gift received,(3) -------------------------------------------------------------------------------- N code label 109 1 grandparent(s)(incl in-laws) 238 2 parent(s)(incl in-laws) 27 3 sibling(s)(incl in-laws) 53 5 other relative(s) 21658 . ------------------------------------------------------------------------------------------------------------------------------------------------ OTHER BEHAVIOURAL VARIABLES ------------------------------------------------------------------------------------------------------------------------------------------------ bopc possession of credit cards (dummy) -------------------------------------------------------------------------------- N code label 4595 0 does not have credit cards 17490 1 has credit cards bonc_c number of credit cards -------------------------------------------------------------------------------- N code label 4595 0 no credit cards 2340 1 1 card 2823 2 2 cards 2695 3 3 cards 2123 4 4 cards 1868 5 5 cards 1438 6 6 cards 964 7 7 cards 828 8 8 cards 564 9 9 cards 513 10 10 cards 322 11 11 cards 282 12 12 cards 205 13 13 cards 141 14 14 cards 127 15 15 cards 91 16 16 cards 73 17 17 cards 16 18 18 cards 20 19 19 cards 30 20 20 cards 10 21 21 cards 6 22 22 cards 11 23 23 cards Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- boue amount needed to cover unexpected expenses 22085 0 1e+08 284224 2500000 boea ability to get emergency financial aid (dummy) -------------------------------------------------------------------------------- N code label 6019 0 not able to get emergency financial aid 16066 1 able to get emergency financial aid bolc loan consolidation (dummy) -------------------------------------------------------------------------------- N code label 22030 0 did not consolidate loan(s) 55 1 consolidated loan(s) bocc1_c objective credit constraints,(1) -------------------------------------------------------------------------------- N code label 11178 110 applied and got what asked for 157 121 applied for mortgage and got less what asked for 93 122 applied for car/other vehicle loan and got less what asked for 35 123 applied for other loans for consumer goods and consumption and got less what asked for 20 124 applied for business/investment loan and got less what asked for 6 125 applied for student loan and got less what asked for 436 131 applied for mortgage and was rejected 648 132 applied for car/other vehicle loan and was rejected 2018 133 applied for other loans for consumer goods and was rejected 52 134 applied for business/investment loan and was rejected 30 135 applied for student loan and and was rejected 7412 200 did not apply NOTES: 1. [us07] refers to application for any type of credit or loan in the last five years bocc2_c objective credit constraints,(2) -------------------------------------------------------------------------------- N code label 305 111 reapplied for mortgage and got what asked for 448 112 reapplied for car/other vehicle loan and got what asked for 101 113 reapplied for other loans for consumer goods and consumption and got what asked for 46 114 reapplied for business/investment loan and got what asked for 16 115 reapplied for student loan and got what asked for 122 121 reapplied for mortgage and did not get what asked for 163 122 reapplied for car/other vehicle loan and did not get what asked for 1846 123 reapplied for other loans for consumer goods and consumption and did not get what asked for 15 124 reapplied for business/investment loan and did not get what asked for 5 125 reapplied for student loan and did not get what asked for 428 200 did not reapply 18590 . NOTES: 1. [us07] refers to those who applied for loan and were rejected, and then re-applied again or did not re-apply bocs_c subjective credit constraints -------------------------------------------------------------------------------- N code label 19494 0 no, did not fear to be turned down 78 1 fear of being turned down because personal characteristics, family background/life history of borrower 348 2 fear of being turned down because credit rating service/credit bureau reports 789 3 fear of being turned down because credit records/history from other institution; other loans; previous payment records; bankruptcy 257 4 fear of being turned down because amount of debt; size of other payments; ability to repay loan 298 5 fear of being turned down because insufficient credit history/references 5 6 fear of being turned down because lack of/not enough assets to secure the loan, size of down payment, or financial status 319 7 fear of being turned down because bad credit, n.e.c. 67 8 fear of being turned down because employment activity, intensity, and characteristics 232 9 fear of being turned down because of income 198 10 fear of being turned down because of other reasons NOTES: 1. [us07] refers to those who did not re-apply for a loan after after they got rejected ------------------------------------------------------------------------------------------------------------------------------------------------ ADDITIONAL INFORMATION (WEALTH) ------------------------------------------------------------------------------------------------------------------------------------------------ bus1_c type of first actively managed business -------------------------------------------------------------------------------- N code label 15000 0 does not own a business 1719 11 LLP/LLC (include professional LLC) 848 12 partnership/cooperative 1629 13 subchapter S corporation 495 14 other corporation (including C chapter corps) 1719 15 sole proprietorship 675 20 does not have actively managed business NOTES: 1. [us07] codes 11-17 refer to the legal form of the first actively managed business owned by anyone in the household. bus2_c type of second actively managed business -------------------------------------------------------------------------------- N code label 15000 0 does not own a business 4405 10 owns only one business 781 11 LLP/LLC (include professional LLC) 250 12 partnership/cooperative 491 13 subchapter S corporation 172 14 other corporation (including C chapter corps) 311 15 sole proprietorship 675 20 does not have actively managed business NOTES: 1. [us07] codes 11-15 refer to the legal form of the second actively managed business owned by anyone in the household. bus3_c number of actively managed businesses -------------------------------------------------------------------------------- N code label 15000 0 does not own a business 4405 1 owns 1 actively managed business 1190 2 owns 2 actively managed businesses 350 3 owns 3 actively managed businesses 465 4 owns 4 or more actively managed businesses 675 20 does not have actively managed business