LWS - United kingdom 2009 : household file Codebook generated: 2016-04-12 ------------------------------------------------------------------------------------------------------------------------------------------------ IDENTIFIERS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hid unique unit identifier 20165 1 20165 10083 5821.28 did unique country/year number -------------------------------------------------- N value 20165 329 dname country/year identifier -------------------------------------------------- N value 20165 "uk09" cname country name -------------------------------------------------- N value 20165 "United Kingdom" iso2 2-letter country abbreviation -------------------------------------------------- N value 20165 "uk" year reference year -------------------------------------------------- N value 20165 2009 wave data wave -------------------------------------------------------------------------------- N code label 20165 8 Wave VIII ------------------------------------------------------------------------------------------------------------------------------------------------ FILE INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hwgt household weight (normalised) 20165 0.04 1.5 0.5 0.28 hpopwgt household weight (inflated) 20165 105.82 3700 1225.75 687.25 inum implicate number 20165 1 1 1 0 svyunit survey unit -------------------------------------------------------------------------------- N code label 20165 1 household ------------------------------------------------------------------------------------------------------------------------------------------------ GEOGRAPHICAL CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ DWELLING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ own owned/rented housing -------------------------------------------------------------------------------- N code label 7991 110 owned outright 6880 120 owned with mortgage 5054 210 rented 2 220 free housing 71 221 employer provided housing 2 222 government/public provided housing 165 223 provided by others dweltyp type of dwelling -------------------------------------------------------------------------------- N code label 1 100 house 5687 110 detached house 11423 120 non-detached house 2962 210 apartment/flat 24 220 other multi-unit 12 300 other type of dwelling 54 310 movable dwelling 2 . ------------------------------------------------------------------------------------------------------------------------------------------------ FARMING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ HOUSEHOLD COMPOSITION ------------------------------------------------------------------------------------------------------------------------------------------------ hhtype household composition -------------------------------------------------------------------------------- N code label 5860 100 one person household 6465 210 couple without children 5081 220 couple with children 1845 230 one parent with children 110 310 couple without children and relatives 199 320 couple with children and relatives 114 330 one parent with children and relatives 244 400 relatives living together (no family nucleus) 22 510 couple without children and nonrelatives 25 520 couple with children and nonrelatives 10 530 one parent with children and nonrelatives 3 610 couple without children and relatives and nonrelatives 10 700 relatives and nonrelatives living together (no family nucleus) 176 800 nonrelatives living together 1 . hpartner head living with partner -------------------------------------------------------------------------------- N code label 9 100 head living with partner 10284 110 married couple 1612 120 non-married cohabiting couple 8260 200 head not living with partner nhhmem number of household members -------------------------------------------------------------------------------- N code label 5860 1 1 hh member 7789 2 2 hh members 2818 3 3 hh members 2537 4 4 hh members 832 5 5 hh members 245 6 6 hh members 57 7 7 hh members 19 8 8 hh members 8 9 9 hh members nhhmem65 number of household members 65 or older -------------------------------------------------------------------------------- N code label 13146 0 no hh members 65 or older 4357 1 1 hh member 65 or older 2653 2 2 hh members 65 or older 9 3 3 hh members 65 or older nearn number of household members with labour income -------------------------------------------------------------------------------- N code label 1 0 no hh members with labour income 5856 1 1 hh member with labour income 7721 2 2 hh members with labour income 2778 3 3 hh members with labour income 2498 4 4 hh members with labour income 826 5 5 hh members with labour income 241 6 6 hh members with labour income 56 7 7 hh members with labour income 18 8 8 hh members with labour income 8 9 9 hh members with labour income 162 . ------------------------------------------------------------------------------------------------------------------------------------------------ CURRENT INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hi total income, household 19913 -49 2946965 37125.2 55574.8 hil labour income, household 20003 -56 2891965 24227.6 43430.5 hile paid employment income, household 11274 0 2891965 39135 48093.1 hils self-employment income, household 20084 0 1200000 2224.51 15291 hic capital income, household 20115 0 1027500 3315.67 20955.1 hicid interest and dividends, household 20165 0 705000 1641.08 8832.67 hicvip voluntary individual pensions, household 20165 0 960000 740.99 13497.9 hicren rental income, household 20120 0 972000 877.04 9569.53 hicroy royalties, household 20160 0 960000 61.61 6784.6 hit transfer income, household 20118 0 2654960 9543.57 28592 hits social security transfers, household 20142 0 2654960 9400.34 28568.2 hitsi work-related insurance transfers, household 20157 0 2654960 7664.64 28664 hitsu universal benefits, household 20158 0 24019 794.43 1588.23 hitsa assistance benefits, household 20157 0 32916 937.14 2397.38 hitp private transfers, household 20141 0 70800 139.14 1412.56 hitped merit-based education transfers, household 20151 0 60000 41.77 811.63 hitpih inter-household transfers, household 20154 0 70800 97.29 1139.76 hiatold old-age transfers, household 20164 0 52208 3007.98 4333.73 hiatdis disability transfers, household 20158 0 25927 550.85 1808.34 hiatsur survivors transfers, household 20165 0 100788 272.09 1967.56 hiatfam family/children transfers, household 20159 0 40456 1165.82 2728.32 hiatune unemployment transfers, household 20160 0 12480 89.27 583.44 hiap total pension income, household 20160 0 2654960 8384.79 32577 hiapprv private pensions and annuities, household 20161 0 2650800 5338.31 31754.2 hiapprvi individual pensions/annuities, household 20165 0 960000 795.13 15096.6 hiapprvo occupational pensions, household 20161 0 2650800 4543.02 27863.2 hiappub public pensions, household 20164 0 52208 3046.34 4362.38 ------------------------------------------------------------------------------------------------------------------------------------------------ WINDFALL INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hwl windfall labour income, household 20165 0 150000 92.94 1752.92 hwc windfall capital income, household 20165 0 195000 147.29 2388.11 hwcic insurance compensations, household 20165 0 195000 147.29 2388.11 hwt windfall transfer income, household 20165 0 492000 359.28 5223.51 hwtlo lottery winnings, household 20165 0 492000 32.98 3490.41 hwtrc lump-sum retirement compensations, household 20165 0 202500 272.93 3625.16 ------------------------------------------------------------------------------------------------------------------------------------------------ NON-CONSUMPTION EXPENDITURE ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hxit income taxes and social contributions, household 20081 -747072 2411200 8727.5 31664.5 ------------------------------------------------------------------------------------------------------------------------------------------------ CONSUMPTION ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS - LIABILITIES TRANSACTIONS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- htol outflows from loans, household 20165 0 3495900 8015.67 41340.8 htolm mortgage repayments, household 20165 0 3495900 7567.51 41204.2 htolo other loans repayments, household 20165 0 72000 430.06 1563.55 htolb borrowings, household 20165 0 8700 18.1 235.75 ------------------------------------------------------------------------------------------------------------------------------------------------ MAJOR AGGREGATES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- dhi disposable household income 19913 -49 1733965 28400.8 38012.3 ------------------------------------------------------------------------------------------------------------------------------------------------ ADDITIONAL INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ currency currency units -------------------------------------------------------------------------------- N code label 20165 826 GBP - Pound Sterling Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- deflator deflation factor 20165 1 1 1 0 grossnet gross/net income information -------------------------------------------------------------------------------- N code label 20165 100 gross, taxes and contributions fully captured ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS ------------------------------------------------------------------------------------------------------------------------------------------------ NOTES: hafi: 1. [uk09] It includes endowment policies that have an insurance component. Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- ha total assets 18399 2500 95315192 457014 1200000 han non-financial assets 18399 2500 92573000 249118 807346 hanr real estate 20165 0 11400000 196913 269833 hanrp principal residence 20165 0 7e+06 178472 203681 hanro other real estate 20165 0 10300000 18440.5 138895 hann non-housing assets 18399 2500 81173000 64430 680502 hannb business equity 18399 0 8e+07 20482 668805 hannc consumer goods 20165 2500 10308000 46329.6 89881.3 hanncv vehicles 20165 0 301750 6800.99 11502.7 hanncd other durables and valuables 20165 2500 10300000 39528.6 87506 haf financial assets (excluding pensions) 20165 0 21774250 70430.2 250816 hafc deposit accounts and cash 20165 0 3974250 26650 64651.2 hafi financial investments 20165 0 7800000 38004.4 150842 hafib bonds and other debt securities 20165 0 5183000 11867.7 61033.8 hafis stocks and other equity 20165 0 6500000 10383 90659.2 hafii investment funds and alternative investments 20165 0 1600000 10337 49313.4 hafo other non-pension financial assets 20165 0 10015000 5061.65 108630 has pension assets and other long-term savings 20165 0 60710880 142285 681137 hasi life insurance and voluntary individual pensions 20165 0 2535000 12105.5 62027 hasil life insurance accounts 20165 0 5e+05 1295.78 15115.7 hasip individual voluntary pension accounts 20165 0 2535000 10809.7 59910.3 haso occupational pensions 20165 0 1602000 3843.67 29691.6 hasodc occupational pensions (DC schemes) 20165 0 1602000 3843.67 29691.6 hass social security pension entitlements 20165 0 3913211 22306.1 125958 hassdb social security (DB schemes) 20165 0 3776161 14865.9 96746.5 hassdc social security (DC schemes) 20165 0 3900000 7440.15 78764.6 ------------------------------------------------------------------------------------------------------------------------------------------------ LIABILITIES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hl total liabilities 20165 0 2e+06 39813.1 84984.3 hlr real estate liabilities 20165 0 2e+06 36361.2 82390.3 hlrp principal residence loans 20165 0 2e+06 30391.5 64032.4 hlro other real estate loans 20165 0 1220000 5969.61 41113.4 hln non-housing liabilities 20165 0 244030 3230.88 8867.61 hlnc consumer goods loans 20165 0 238530 2823.95 7874.42 hlncv vehicle loans 20165 0 39540 345.98 1826.5 hlncd other loans for goods and consumption 20165 0 232450 2477.97 7529.81 hlne education loans 20165 0 90000 330.55 2450.47 hlno other non-housing liabilities 20165 0 100155 58.61 1315.43 hlsr institutional loans secured by real estate 20165 0 2e+06 36797.5 82912.4 hlsrp secured by principal residence 20165 0 2e+06 34941.1 78147 hlsro secured by other real estate 20165 0 720000 1856.37 18534.8 hlsn loans not secured by real estate 20165 0 190304 3036.73 7943.55 hlsng guaranteed institutional loans 20165 0 185000 1421.4 5541.44 hlsnn non-guaranteed institutional loans 20165 0 135500 1510.85 4380.56 hlsni informal (non-institutional) loans 20165 0 100155 104.48 1478.4 ------------------------------------------------------------------------------------------------------------------------------------------------ HOUSEHOLD NET WORTH ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- dnw disposable net worth 18399 -497771 94375000 280943 893609 anw adjusted disposable net worth 18399 -497771 94375000 290859 900367 tnw total net worth 18399 -497771 95315192 420856 1200000 ------------------------------------------------------------------------------------------------------------------------------------------------ CONTINGENT ASSETS, LIABILITIES AND RELATED VARIABLES ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS ACQUIRED IN THE PAST AND RELATED VARIABLES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- ppr purchase price of principal residence 289 1000 1e+06 164869 138407 ppy year of purchase of principal residence 296 1962 2010 2005 7.59 pir inheritance/gift received (dummy) -------------------------------------------------------------------------------- N code label 17599 0 did not receive inheritance/gift 2541 1 received inheritance/gift 25 . NOTES: 1. [uk09] Scope limitation: it includes inheritances valued at least £1000 received in the last 5 years and gifts valued at least £500 received in the last 2 years. Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- pia1 amount of inheritance/gift received,(1) 20129 0 5e+06 4114.03 49949.5 pia2 amount of inheritance/gift received,(2) 20155 0 230000 246.02 4169.02 pia3 amount of inheritance/gift received,(3) 20165 0 175000 26.87 1428.68 pia4 amount of inheritance/gift received,(4) 20164 0 75000 5.72 542.24 piy1 year inheritance/gift received,(1) 2538 2006 2008 2006.96 1 piy2 year inheritance/gift received,(2) 522 2006 2008 2007.31 0.95 piy3 year inheritance/gift received,(3) 73 2006 2008 2007.15 1 piy4 year inheritance/gift received,(4) 16 2006 2008 2007 1.03 pit1 type of inheritence/gift received,(1) -------------------------------------------------------------------------------- N code label 281 11 real estate 1 12 family business 29 13 valuables and durables 992 21 cash 8 22 cash-equivalent capital investments 1227 40 unspecified 17627 . pit2 type of inheritence/gift received,(2) -------------------------------------------------------------------------------- N code label 17 11 real estate 3 13 valuables and durables 155 21 cash 5 22 cash-equivalent capital investments 342 40 unspecified 19643 . pit3 type of inheritence/gift received,(3) -------------------------------------------------------------------------------- N code label 2 11 real estate 29 21 cash 42 40 unspecified 20092 . pit4 type of inheritence/gift received,(4) -------------------------------------------------------------------------------- N code label 1 11 real estate 7 21 cash 8 40 unspecified 20149 . piw1 from whom inheritance/gift received,(1) -------------------------------------------------------------------------------- N code label 208 1 grandparent(s)(incl in-laws) 677 2 parent(s)(incl in-laws) 53 3 sibling(s)(incl in-laws) 307 5 other relative(s) 74 6 non-relative(s) 18846 . piw2 from whom inheritance/gift received,(2) -------------------------------------------------------------------------------- N code label 52 1 grandparent(s)(incl in-laws) 73 2 parent(s)(incl in-laws) 1 3 sibling(s)(incl in-laws) 45 5 other relative(s) 10 6 non-relative(s) 19984 . piw3 from whom inheritance/gift received,(3) -------------------------------------------------------------------------------- N code label 15 1 grandparent(s)(incl in-laws) 9 2 parent(s)(incl in-laws) 6 5 other relative(s) 1 6 non-relative(s) 20134 . piw4 from whom inheritance/gift received,(4) -------------------------------------------------------------------------------- N code label 3 1 grandparent(s)(incl in-laws) 3 2 parent(s)(incl in-laws) 2 5 other relative(s) 20157 . pim1 household member who received inheritance/gift,(1) -------------------------------------------------------------------------------- N code label 1546 10 head of household 842 20 spouse 113 31 head's child(ren)(incl in-laws) 4 33 head's parent(s)/grandparent(s)(incl in-laws) 10 34 head's sibling(s)(incl in-laws) 3 35 other relative(s) of head 19 36 non-relative(s) 17628 . pim2 household member who received inheritance/gift,(2) -------------------------------------------------------------------------------- N code label 259 10 head of household 216 20 spouse 39 31 head's child(ren)(incl in-laws) 2 34 head's sibling(s)(incl in-laws) 5 36 non-relative(s) 19644 . pim3 household member who received inheritance/gift,(3) -------------------------------------------------------------------------------- N code label 25 10 head of household 30 20 spouse 10 31 head's child(ren)(incl in-laws) 3 34 head's sibling(s)(incl in-laws) 5 36 non-relative(s) 20092 . pim4 household member who received inheritance/gift,(4) -------------------------------------------------------------------------------- N code label 10 10 head of household 2 20 spouse 3 31 head's child(ren)(incl in-laws) 1 36 non-relative(s) 20149 . ------------------------------------------------------------------------------------------------------------------------------------------------ OTHER BEHAVIOURAL VARIABLES ------------------------------------------------------------------------------------------------------------------------------------------------ bopc possession of credit cards (dummy) -------------------------------------------------------------------------------- N code label 3647 0 does not have credit cards 6148 1 has credit cards 10370 . bonc_c number of credit cards -------------------------------------------------------------------------------- N code label 3647 0 none 1215 1 1 card 1548 2 2 cards 1102 3 3 cards 835 4 4 cards 520 5 5 cards 345 6 6 cards 192 7 7 cards 127 8 8 cards 82 9 9 cards 65 10 10 cards 38 11 11 cards 30 12 12 cards 14 13 13 cards 14 14 14 cards 7 15 15 cards 6 16 16 cards 1 17 17 cards 2 18 18 cards 1 20 20 cards 1 21 21 cards 2 23 23 cards 1 24 24 cards 10370 . bolc loan consolidation (dummy) -------------------------------------------------------------------------------- N code label 19592 0 did not consolidate loan(s) 573 1 consolidated loan(s) ------------------------------------------------------------------------------------------------------------------------------------------------ ADDITIONAL INFORMATION (WEALTH) ------------------------------------------------------------------------------------------------------------------------------------------------ bus1_c ownership - first business -------------------------------------------------------------------------------- N code label 18390 0 does not own a business 5 1 partly owned, 1% of the business 2 2 partly owned, 2% of the business 1 3 partly owned, 3% of the business 1 4 partly owned, 4% of the business 2 5 partly owned, 5% of the business 1 6 partly owned, 6% of the business 2 7 partly owned, 7% of the business 2 8 partly owned, 8% of the business 11 10 partly owned, 10% of the business 3 12 partly owned, 12% of the business 1 13 partly owned, 13% of the business 3 14 partly owned, 14% of the business 1 15 partly owned, 15% of the business 1 16 partly owned, 16% of the business 2 17 partly owned, 17% of the business 3 18 partly owned, 18% of the business 1 19 partly owned, 19% of the business 11 20 partly owned, 20% of the business 1 22 partly owned, 22% of the business 2 23 partly owned, 23% of the business 2 24 partly owned, 24% of the business 24 25 partly owned, 25% of the business 4 26 partly owned, 26% of the business 5 30 partly owned, 30% of the business 32 33 partly owned, 33% of the business 1 34 partly owned, 34% of the business 2 35 partly owned, 35% of the business 1 36 partly owned, 36% of the business 8 40 partly owned, 40% of the business 2 42 partly owned, 42% of the business 2 45 partly owned, 45% of the business 1 47 partly owned, 47% of the business 3 48 partly owned, 48% of the business 1 49 partly owned, 49% of the business 252 50 partly owned, 50% of the business 7 51 partly owned, 51% of the business 2 52 partly owned, 52% of the business 2 55 partly owned, 55% of the business 9 60 partly owned, 60% of the business 1 66 partly owned, 66% of the business 1 67 partly owned, 67% of the business 3 70 partly owned, 70% of the business 7 75 partly owned, 75% of the business 6 80 partly owned, 80% of the business 1 85 partly owned, 85% of the business 4 90 partly owned, 90% of the business 1 95 partly owned, 95% of the business 1 98 partly owned, 98% of the business 3 99 partly owned, 99% of the business 329 100 business entirely owned 1002 200 owned, unspecified percentage bus2_c ownership - second business -------------------------------------------------------------------------------- N code label 20002 0 does not own a business 1 3 partly owned, 3% of the business 1 10 partly owned, 10% of the business 1 25 partly owned, 25% of the business 1 30 partly owned, 30% of the business 5 33 partly owned, 33% of the business 1 40 partly owned, 40% of the business 18 50 partly owned, 50% of the business 1 51 partly owned, 51% of the business 1 60 partly owned, 60% of the business 1 75 partly owned, 75% of the business 1 90 partly owned, 90% of the business 20 100 business entirely owned 111 200 owned, unspecified percentage bus3_c ownership - third business -------------------------------------------------------------------------------- N code label 20146 0 does not own a business 3 50 partly owned, 50% of the business 2 100 business entirely owned 14 200 owned, unspecified percentage