LWS - United kingdom 2007 : household file Codebook generated: 2016-04-12 ------------------------------------------------------------------------------------------------------------------------------------------------ IDENTIFIERS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hid unique unit identifier 30587 1 30587 15294 8829.85 did unique country/year number -------------------------------------------------- N value 30587 328 dname country/year identifier -------------------------------------------------- N value 30587 "uk07" cname country name -------------------------------------------------- N value 30587 "United Kingdom" iso2 2-letter country abbreviation -------------------------------------------------- N value 30587 "uk" year reference year -------------------------------------------------- N value 30587 2007 wave data wave -------------------------------------------------------------------------------- N code label 30587 7 Wave VII ------------------------------------------------------------------------------------------------------------------------------------------------ FILE INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hwgt household weight (normalised) 30587 0.05 0.91 0.33 0.11 hpopwgt household weight (inflated) 30587 132.51 2245.08 803.49 272.37 inum implicate number 30587 1 1 1 0 svyunit survey unit -------------------------------------------------------------------------------- N code label 30587 1 household ------------------------------------------------------------------------------------------------------------------------------------------------ GEOGRAPHICAL CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ DWELLING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ own owned/rented housing -------------------------------------------------------------------------------- N code label 10689 110 owned outright 10988 120 owned with mortgage 8523 210 rented 1 220 free housing 106 221 employer provided housing 4 222 government/public provided housing 271 223 provided by others 2 224 illegal occupation 3 . dweltyp type of dwelling -------------------------------------------------------------------------------- N code label 8115 110 detached house 17372 120 non-detached house 4900 210 apartment/flat 86 220 other multi-unit 33 300 other type of dwelling 81 310 movable dwelling ------------------------------------------------------------------------------------------------------------------------------------------------ FARMING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ HOUSEHOLD COMPOSITION ------------------------------------------------------------------------------------------------------------------------------------------------ hhtype household composition -------------------------------------------------------------------------------- N code label 8711 100 one person household 9471 210 couple without children 7844 220 couple with children 3359 230 one parent with children 1202 900 head and other NOTES: 1. [uk07] Mixed categories: category 'head and other' (code 900) includes also couples living with other relatives/non-relatives. hpartner head living with partner -------------------------------------------------------------------------------- N code label 15280 110 married couple 2554 120 non-married cohabiting couple 12753 200 head not living with partner nhhmem number of household members -------------------------------------------------------------------------------- N code label 8711 1 1 hh member 11642 2 2 hh members 4409 3 3 hh members 3952 4 4 hh members 1308 5 5 hh members 410 6 6 hh members 105 7 7 hh members 33 8 8 hh members 17 9 9 hh members nhhmem65 number of household members 65 or older -------------------------------------------------------------------------------- N code label 21261 0 no hh members 65 or older 5980 1 1 hh member 65 or older 3339 2 2 hh members 65 or older 4 3 3 hh members 65 or older 2 4 4 hh members 65 or older 1 5 5 hh members 65 or older nearn number of household members with labour income -------------------------------------------------------------------------------- N code label 11268 0 no hh members with labour income 9157 1 1 hh member with labour income 8536 2 2 hh members with labour income 1100 3 3 hh members with labour income 245 4 4 hh members with labour income 26 5 5 hh members with labour income 7 6 6 hh members with labour income 248 . ------------------------------------------------------------------------------------------------------------------------------------------------ CURRENT INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hi total income, household 30199 -10325 4802000 34934.4 61754.9 hil labour income, household 30339 -18000 4800000 24344.4 52742.9 hile paid employment income, household 30339 0 1889200 21662.7 40591.6 hils self-employment income, household 30587 -24000 4800000 2671.62 34004.6 hic capital income, household 30530 0 1627306 3428.28 22012.6 hicid interest and dividends, household 30587 0 999997 1844.77 12832.4 hicvip voluntary individual pensions, household 30587 0 1608000 644.75 12853.9 hicren rental income, household 30543 0 6e+05 910.24 9782.57 hicroy royalties, household 30574 0 480000 38.8 3471.84 hit transfer income, household 30504 0 1501800 7100.12 22263.5 hits social security transfers, household 30558 0 1501800 6910.63 22203.7 hitsi work-related insurance transfers, household 30568 0 1501800 5799.31 22198 hitsu universal benefits, household 30586 0 29307 306.95 1199.08 hitsa assistance benefits, household 30578 0 26832 802.96 2089.29 hitp private transfers, household 30533 0 180000 181.53 1920.15 hitped merit-based education transfers, household 30561 0 180000 67.92 1473.72 hitpih inter-household transfers, household 30558 0 84000 113.82 1212.56 hiatold old-age transfers, household 30585 0 51584 2173.56 3603.92 hiatdis disability transfers, household 30583 0 26681 445.41 1548.39 hiatsur survivors transfers, household 30586 0 432000 292.99 3446.29 hiatfam family/children transfers, household 30579 0 26832 713.76 2059.49 hiatune unemployment transfers, household 30582 0 144000 56.92 936.29 hiap total pension income, household 30575 0 1617298 6358.35 26015.6 hiapprv private pensions and annuities, household 30578 0 1608000 4146.61 25167.1 hiapprvi individual pensions/annuities, household 30587 0 1608000 650.04 12857.8 hiapprvo occupational pensions, household 30578 0 1483548 3496.72 21349.8 hiappub public pensions, household 30584 0 51584 2212 3630.57 ------------------------------------------------------------------------------------------------------------------------------------------------ WINDFALL INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hwl windfall labour income, household 30587 0 125000 153.78 1959.7 hwc windfall capital income, household 30587 0 850000 249.18 5586.73 hwcic insurance compensations, household 30587 0 850000 249.18 5586.73 hwt windfall transfer income, household 30587 0 1e+06 424.5 6976.27 hwtlo lottery winnings, household 30587 0 1e+06 51.05 5765.59 hwtrc lump-sum retirement compensations, household 30587 0 175000 306.52 3632.98 ------------------------------------------------------------------------------------------------------------------------------------------------ NON-CONSUMPTION EXPENDITURE ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hxit income taxes and social contributions, household 30339 -508275 967200 6694.5 19545.7 ------------------------------------------------------------------------------------------------------------------------------------------------ CONSUMPTION ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS - LIABILITIES TRANSACTIONS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- htol outflows from loans, household 30587 0 3840000 8400.35 37851.2 htolm mortgage repayments, household 30587 0 3840000 7952.96 37593.9 htolo other loans repayments, household 30587 0 333600 423.59 3189.64 htolb borrowings, household 30587 0 180000 23.8 1080.82 ------------------------------------------------------------------------------------------------------------------------------------------------ MAJOR AGGREGATES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- dhi disposable household income 30199 -12000 4802000 28235.5 51347.7 ------------------------------------------------------------------------------------------------------------------------------------------------ ADDITIONAL INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ currency currency units -------------------------------------------------------------------------------- N code label 30587 826 GBP - Pound Sterling Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- deflator deflation factor 30587 1 1 1 0 grossnet gross/net income information -------------------------------------------------------------------------------- N code label 30587 100 gross, taxes and contributions fully captured ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS ------------------------------------------------------------------------------------------------------------------------------------------------ NOTES: hanncv: 1. [uk07] Scope limitation: vehicles collected for about half of the sample only. hanncd: 1. [uk07] Scope limitation: durables and valuables collected for about half of the sample only. hafi: 1. [uk07] It includes endowment policies that have an insurance component. Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- ha total assets 15703 2500 26075800 419131 812457 han non-financial assets 15880 2500 25810000 257652 521146 hanr real estate 30587 0 11999997 211022 346844 hanrp principal residence 30587 0 9999997 176472 217141 hanro other real estate 30587 0 11999997 34550.2 233680 hann non-housing assets 15880 2500 25060000 58944.7 326198 hannb business equity 27990 0 2.5e+07 17738.4 298048 hannc consumer goods 17312 2500 807000 42421.8 47340 hanncv vehicles 17316 0 660000 6890.24 14564.6 hanncd other durables and valuables 18094 1054 8e+05 35212 41886.9 haf financial assets (excluding pensions) 30225 0 10868988 60056.9 191867 hafc deposit accounts and cash 30520 0 6069000 23670.4 77304.1 hafi financial investments 30587 0 5576048 32954.2 128097 hafib bonds and other debt securities 30587 0 2530000 7712.16 45509.5 hafis stocks and other equity 30587 0 4149988 13412.1 84742.3 hafii investment funds and alternative investments 30587 0 2e+06 7352.72 41518.7 hafo other non-pension financial assets 30587 0 5e+06 2895.65 56158.8 has pension assets and other long-term savings 30587 0 28677908 104280 453627 hasi life insurance and voluntary individual pensions 30587 0 6155635 11892.2 66946.2 hasil life insurance accounts 30587 0 1999994 768.74 17240.6 hasip individual voluntary pension accounts 30587 0 6155635 11123.4 63857.5 haso occupational pensions 30587 0 2e+06 4700.87 39012.6 hasodc occupational pensions (DC schemes) 30587 0 2e+06 4700.87 39012.6 hass social security pension entitlements 30587 0 12072264 11834.3 128789 hassdb social security (DB schemes) 30587 0 12072264 8536.01 121709 hassdc social security (DC schemes) 30587 0 4e+06 3298.25 41569.5 ------------------------------------------------------------------------------------------------------------------------------------------------ LIABILITIES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hl total liabilities 30587 0 3528000 41404.6 98499.3 hlr real estate liabilities 30587 0 3528000 37911.4 95871.2 hlrp principal residence loans 30587 0 1200000 31628.7 64306 hlro other real estate loans 30587 0 3208000 6282.73 60621.1 hln non-housing liabilities 30587 0 676300 3212.72 12469.4 hlnc consumer goods loans 30587 0 676300 2953.68 12202.3 hlncv vehicle loans 30587 0 334500 462.27 3581.37 hlncd other loans for goods and consumption 30587 0 676300 2491.41 11591.4 hlne education loans 30587 0 53500 200.92 1738.87 hlno other non-housing liabilities 30587 0 84500 37.99 982.83 hlsr institutional loans secured by real estate 30587 0 3528000 38383.8 96482.7 hlsrp secured by principal residence 30587 0 1200000 32101 65084.3 hlsro secured by other real estate 30587 0 3208000 6282.73 60621.1 hlsn loans not secured by real estate 30587 0 676300 3012.9 11210 hlsng guaranteed institutional loans 30587 0 672000 1198.15 7230.21 hlsnn non-guaranteed institutional loans 30587 0 635000 1724.95 7975.06 hlsni informal (non-institutional) loans 30587 0 84500 89.79 1190.32 ------------------------------------------------------------------------------------------------------------------------------------------------ HOUSEHOLD NET WORTH ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- dnw disposable net worth 15703 -461960 25941732 279159 589300 anw adjusted disposable net worth 15703 -461960 26071732 289102 605766 tnw total net worth 15703 -450881 26071732 382077 797114 ------------------------------------------------------------------------------------------------------------------------------------------------ CONTINGENT ASSETS, LIABILITIES AND RELATED VARIABLES ------------------------------------------------------------------------------------------------------------------------------------------------ NOTES: cia1: 1. [uk07] Definitional deviation: all the expected inheritances are lumped together. cig: 1. [uk07] Scope limitation: it only includes households in which at least one member made a will. Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- cir expects to receive inheritance/gift 29528 0 2 0.94 0.91 cia1 amount of expected inheritance/gift,(1) 10046 500 1250000 135496 157540 cig expects to give inheritance/gift 14605 1 1 1 0 ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS ACQUIRED IN THE PAST AND RELATED VARIABLES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- ppr purchase price of principal residence 20989 1 5e+06 98956.3 127400 ppy year of purchase of principal residence 21626 1900 2008 1991.47 13.28 pir inheritance/gift received (dummy) -------------------------------------------------------------------------------- N code label 19615 0 did not receive inheritance/gift 10873 1 received inheritance/gift 99 . NOTES: 1. [uk07] Scope limitation: it includes inheritances valued at least £1000 received in the last 5 years, large inheritances received previously 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) 26669 0 9999997 9517.07 85143.7 pia2 amount of inheritance/gift received,(2) 29348 0 9999997 1725.56 59331 pia3 amount of inheritance/gift received,(3) 30190 0 280000 234.65 3636.32 pia4 amount of inheritance/gift received,(4) 30485 0 285000 63.34 2277.31 piy1 year inheritance/gift received,(1) 10037 1940 2006 1999.63 8.5 piy2 year inheritance/gift received,(2) 3210 1945 2006 1998 10.17 piy3 year inheritance/gift received,(3) 873 1936 2006 1997.2 11.08 piy4 year inheritance/gift received,(4) 239 1945 2006 1996.85 11.82 pit1 type of inheritence/gift received,(1) -------------------------------------------------------------------------------- N code label 490 10 non-financial 198 11 real estate 2 12 family business 4 13 valuables and durables 1709 20 financial 336 21 cash 3 22 cash-equivalent capital investments 194 30 both non-financial and financial 3015 40 unspecified 24636 . pit2 type of inheritence/gift received,(2) -------------------------------------------------------------------------------- N code label 126 10 non-financial 42 11 real estate 9 13 valuables and durables 473 20 financial 321 21 cash 8 22 cash-equivalent capital investments 60 30 both non-financial and financial 730 40 unspecified 28818 . pit3 type of inheritence/gift received,(3) -------------------------------------------------------------------------------- N code label 20 10 non-financial 6 11 real estate 5 13 valuables and durables 109 20 financial 120 21 cash 4 22 cash-equivalent capital investments 7 30 both non-financial and financial 207 40 unspecified 30109 . pit4 type of inheritence/gift received,(4) -------------------------------------------------------------------------------- N code label 5 10 non-financial 3 11 real estate 36 20 financial 39 21 cash 2 30 both non-financial and financial 42 40 unspecified 30460 . piw1 from whom inheritance/gift received,(1) -------------------------------------------------------------------------------- N code label 56 1 grandparent(s)(incl in-laws) 321 2 parent(s)(incl in-laws) 23 3 sibling(s)(incl in-laws) 122 5 other relative(s) 26 6 non-relative(s) 3010 7 unspecified 27029 . piw2 from whom inheritance/gift received,(2) -------------------------------------------------------------------------------- N code label 47 1 grandparent(s)(incl in-laws) 175 2 parent(s)(incl in-laws) 10 3 sibling(s)(incl in-laws) 113 5 other relative(s) 35 6 non-relative(s) 730 7 unspecified 29477 . piw3 from whom inheritance/gift received,(3) -------------------------------------------------------------------------------- N code label 21 1 grandparent(s)(incl in-laws) 44 2 parent(s)(incl in-laws) 1 3 sibling(s)(incl in-laws) 50 5 other relative(s) 19 6 non-relative(s) 207 7 unspecified 30245 . piw4 from whom inheritance/gift received,(4) -------------------------------------------------------------------------------- N code label 13 1 grandparent(s)(incl in-laws) 10 2 parent(s)(incl in-laws) 16 5 other relative(s) 3 6 non-relative(s) 42 7 unspecified 30503 . pim1 household member who received inheritance/gift,(1) -------------------------------------------------------------------------------- N code label 7224 10 head of household 3210 20 spouse 416 30 others 19737 . pim2 household member who received inheritance/gift,(2) -------------------------------------------------------------------------------- N code label 2130 10 head of household 1274 20 spouse 231 30 others 26952 . pim3 household member who received inheritance/gift,(3) -------------------------------------------------------------------------------- N code label 555 10 head of household 373 20 spouse 98 30 others 29561 . pim4 household member who received inheritance/gift,(4) -------------------------------------------------------------------------------- N code label 152 10 head of household 124 20 spouse 31 30 others 30280 . ------------------------------------------------------------------------------------------------------------------------------------------------ OTHER BEHAVIOURAL VARIABLES ------------------------------------------------------------------------------------------------------------------------------------------------ bopc possession of credit cards (dummy) -------------------------------------------------------------------------------- N code label 6844 0 does not have credit cards 21079 1 has credit cards 2664 . bonc_c number of credit cards -------------------------------------------------------------------------------- N code label 6844 0 none 5889 1 1 card 5492 2 2 cards 3125 3 3 cards 2441 4 4 cards 1360 5 5 cards 969 6 6 cards 567 7 7 cards 436 8 8 cards 247 9 9 cards 172 10 10 cards 99 11 11 cards 66 12 12 cards 48 13 13 cards 25 14 14 cards 24 15 15 cards 22 16 16 cards 9 17 17 cards 9 18 18 cards 3 19 19 cards 6 20 20 cards 2 21 21 cards 3 22 22 cards 3 23 23 cards 2 24 24 cards 1 27 27 cards 1 32 32 cards 1 34 34 cards 1 54 54 cards 2720 . bolc loan consolidation (dummy) -------------------------------------------------------------------------------- N code label 29992 0 did not consolidate loan(s) 595 1 consolidated loan(s) ------------------------------------------------------------------------------------------------------------------------------------------------ ADDITIONAL INFORMATION (WEALTH) ------------------------------------------------------------------------------------------------------------------------------------------------ bus1_c ownership - first business -------------------------------------------------------------------------------- N code label 27814 0 does not own a business 12 1 partly owned, 1% of the business 3 2 partly owned, 2% of the business 5 3 partly owned, 3% of the business 4 4 partly owned, 4% of the business 7 5 partly owned, 5% of the business 1 6 partly owned, 6% of the business 2 7 partly owned, 7% of the business 1 9 partly owned, 9% of the business 9 10 partly owned, 10% of the business 2 11 partly owned, 11% of the business 2 13 partly owned, 13% of the business 1 14 partly owned, 14% of the business 5 15 partly owned, 15% of the business 7 16 partly owned, 16% of the business 3 17 partly owned, 17% of the business 1 18 partly owned, 18% of the business 24 20 partly owned, 20% of the business 2 21 partly owned, 21% of the business 1 22 partly owned, 22% of the business 55 25 partly owned, 25% of the business 4 26 partly owned, 26% of the business 2 27 partly owned, 27% of the business 15 30 partly owned, 30% of the business 53 33 partly owned, 33% of the business 1 35 partly owned, 35% of the business 1 36 partly owned, 36% of the business 2 37 partly owned, 37% of the business 1 38 partly owned, 38% of the business 18 40 partly owned, 40% of the business 1 42 partly owned, 42% of the business 5 45 partly owned, 45% of the business 2 47 partly owned, 47% of the business 6 49 partly owned, 49% of the business 434 50 partly owned, 50% of the business 14 51 partly owned, 51% of the business 1 52 partly owned, 52% of the business 1 54 partly owned, 54% of the business 6 55 partly owned, 55% of the business 1 57 partly owned, 57% of the business 15 60 partly owned, 60% of the business 1 64 partly owned, 64% of the business 1 65 partly owned, 65% of the business 1 67 partly owned, 67% of the business 12 70 partly owned, 70% of the business 22 75 partly owned, 75% of the business 1 79 partly owned, 79% of the business 8 80 partly owned, 80% of the business 2 87 partly owned, 87% of the business 2 90 partly owned, 90% of the business 2 98 partly owned, 98% of the business 8 99 partly owned, 99% of the business 513 100 business entirely owned 1470 200 owned, unspecified percentage bus2_c ownership - second business -------------------------------------------------------------------------------- N code label 30292 0 does not own a business 1 1 partly owned, 1% of the business 1 12 partly owned, 12% of the business 1 14 partly owned, 14% of the business 1 17 partly owned, 17% of the business 3 20 partly owned, 20% of the business 7 25 partly owned, 25% of the business 7 33 partly owned, 33% of the business 2 35 partly owned, 35% of the business 4 40 partly owned, 40% of the business 1 45 partly owned, 45% of the business 2 49 partly owned, 49% of the business 40 50 partly owned, 50% of the business 2 51 partly owned, 51% of the business 2 60 partly owned, 60% of the business 1 80 partly owned, 80% of the business 1 99 partly owned, 99% of the business 29 100 business entirely owned 190 200 owned, unspecified percentage bus3_c ownership - third business -------------------------------------------------------------------------------- N code label 30558 0 does not own a business 1 30 partly owned, 30% of the business 1 33 partly owned, 33% of the business 5 50 partly owned, 50% of the business 1 51 partly owned, 51% of the business 1 80 partly owned, 80% of the business 20 200 owned, unspecified percentage