LIS - Germany 2007 : household file Codebook generated: 2016-09-06 ------------------------------------------------------------------------------------------------------------------------------------------------ IDENTIFIERS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hid unique unit identifier 10921 1 10921 5461 3152.77 did unique country/year number -------------------------------------------------- N value 10921 221 dname country/year identifier -------------------------------------------------- N value 10921 "de07" cname country name -------------------------------------------------- N value 10921 "Germany" iso2 2-letter country abbreviation -------------------------------------------------- N value 10921 "de" year reference year -------------------------------------------------- N value 10921 2007 wave data wave -------------------------------------------------------------------------------- N code label 10921 7 Wave VII ------------------------------------------------------------------------------------------------------------------------------------------------ FILE INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hwgt household weight (normalised) 10921 0.01 4.92 0.92 0.89 hpopwgt household weight (inflated) 10921 31.12 19955.26 3713.28 3606.56 svyunit survey unit -------------------------------------------------------------------------------- N code label 10921 1 household npers number of persons in survey unit -------------------------------------------------------------------------------- N code label 3058 1 1 person 4223 2 2 persons 1734 3 3 persons 1394 4 4 persons 401 5 5 persons 86 6 6 persons 16 7 7 persons 5 8 8 persons 2 10 10 persons 1 11 11 persons 1 13 13 persons ------------------------------------------------------------------------------------------------------------------------------------------------ GEOGRAPHICAL CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ region_c region of residence, Federal States - NUTS1 -------------------------------------------------------------------------------- N code label 1301 1 DE1 - Baden-Wuerttemberg 1551 2 DE2 - Bavaria 452 3 DE3 - Berlin 474 4 DE4 - Brandenburg 84 5 DE5 - Bremen 188 6 DE6 - Hamburg 741 7 DE7 - Hesse 280 8 DE8 - Mecklenburg-Western Pomerania 974 9 DE9 - Lower Saxony 2193 10 DEA - North Rhine-Westphalia 496 11 DEB - Rhineland-Palatinate 128 12 DEC - Saarland 803 13 DED - Saxony 442 14 DEE - Saxony-Anhalt 334 15 DEF - Schleswig-Holstein 480 16 DEG - Thuringia rural rural area (dummy) -------------------------------------------------------------------------------- N code label 8244 0 not rural area 2677 1 rural area locsz_c population size of the locality of residence -------------------------------------------------------------------------------- N code label 682 1 less than 2,000 inhabitants 987 2 [2,000 ; 5,000) inhabitants 2730 3 [5,000 ; 20,000) inhabitants 2079 4 [20,000 ; 50,000) inhabitants 954 5 [50,000 ; 100,000) inhabitants 1878 6 [100,000 ; 500,000) inhabitants 1611 7 500,000 or more inhabitants area_c structure of urban development -------------------------------------------------------------------------------- N code label 1694 1 large density region, very high density county, metropolitan municpality >500,000 975 2 large density region, very high density county, metropolitan municpality <500,000 1073 3 large density region, high density county, middle/upper size municpality 552 4 large density region, high density county, other size municpality 468 5 large density region, medium density county, middle/upper size municpality 482 6 large density region, medium density county, other size municpality 194 7 large density region, low density (rural) county, middle/upper size municpality 306 8 large density region, low density (rural) county, other size municpality 752 9 medium density region, very high density county, metropolitan municpality 941 10 medium density region, medium density county, middle/upper size municpality 1035 11 medium density region, medium density county, other size municpality 405 12 medium density region, low density (rural) county, middle/upper size municpality 596 13 medium density region, low density (rural) county, other size municpality 404 14 low density (rural) region, medium density county, middle/upper size municpality 497 15 low density (rural) region, medium density county, other size municpality 226 16 low density (rural) region, low density (rural) county, middle/upper size municpality 321 17 low density (rural) region, low density (rural) county, other size municpality ------------------------------------------------------------------------------------------------------------------------------------------------ DWELLING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ own owned/rented housing -------------------------------------------------------------------------------- N code label 37 100 owned 2772 110 owned outright 2572 120 owned with mortgage 44 200 not owned 41 210 rented 4612 211 rented at market price 497 212 subsidised rent 346 220 free housing dweltyp type of dwelling -------------------------------------------------------------------------------- N code label 4022 110 detached house 1733 120 non-detached house 4834 210 apartment/flat 84 220 other multi-unit 7 300 other type of dwelling 241 . Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- dwelval value of dwelling 10532 0 4300000 111399 171311 ------------------------------------------------------------------------------------------------------------------------------------------------ FARMING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ HOUSEHOLD COMPOSITION ------------------------------------------------------------------------------------------------------------------------------------------------ hhtype household composition -------------------------------------------------------------------------------- N code label 3058 100 one person household 3757 210 couple without children 3256 220 couple with children 672 230 one parent with children 28 310 couple without children and relatives 53 320 couple with children and relatives 25 330 one parent with children and relatives 38 400 relatives living together (no family nucleus) 2 510 couple without children and nonrelatives 7 520 couple with children and nonrelatives 6 530 one parent with children and nonrelatives 1 610 couple without children and relatives and nonrelatives 2 620 couple with children and relatives and nonrelatives 2 630 one parent with children and relatives and nonrelatives 14 800 nonrelatives living together hpartner head living with partner -------------------------------------------------------------------------------- N code label 1121 100 head living with partner 5985 110 married couple 3815 200 head not living with partner nhhmem number of household members -------------------------------------------------------------------------------- N code label 3058 1 1 hh member 4223 2 2 hh members 1734 3 3 hh members 1394 4 4 hh members 401 5 5 hh members 86 6 6 hh members 16 7 7 hh members 5 8 8 hh members 2 10 10 hh members 1 11 11 hh members 1 13 13 hh members nhhmem65 number of household members 65 or older -------------------------------------------------------------------------------- N code label 7543 0 no hh members 65 or older 1909 1 1 hh member 65 or older 1318 2 2 hh members 65 or older 2 3 3 hh members 65 or older 149 . nhhmem17 number of household members 17 or younger -------------------------------------------------------------------------------- N code label 7999 0 no hh members 17 or younger 1367 1 1 hh member 17 or younger 1084 2 2 hh member 17 or younger 259 3 3 hh member 17 or younger 44 4 4 hh member 17 or younger 13 5 5 hh member 17 or younger 4 6 6 hh member 17 or younger 1 7 7 hh member 17 or younger 1 8 8 hh member 17 or younger 149 . nhhmem13 number of household members 13 or younger -------------------------------------------------------------------------------- N code label 8560 0 no hh members 13 or younger 1233 1 1 hh member 13 or younger 778 2 2 hh member 13 or younger 163 3 3 hh member 13 or younger 31 4 4 hh member 13 or younger 2 5 5 hh member 13 or younger 4 6 6 hh member 13 or younger 1 7 7 hh member 13 or younger 149 . nhhmem5 number of household members 5 or younger -------------------------------------------------------------------------------- N code label 9722 0 no hh members 5 or younger 815 1 1 hh member 5 or younger 215 2 2 hh member 5 or younger 16 3 3 hh member 5 or younger 4 4 4 hh member 5 or younger 149 . Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- ageymem age of youngest household member 10772 0 95 39.77 25.44 nearn number of household members with labour income -------------------------------------------------------------------------------- N code label 3145 0 no hh members with labour income 3389 1 1 hh member with labour income 3570 2 2 hh members with labour income 654 3 3 hh members with labour income 154 4 4 hh members with labour income 7 5 5 hh members with labour income 1 6 6 hh members with labour income 1 7 7 hh members with labour income ------------------------------------------------------------------------------------------------------------------------------------------------ CURRENT INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ NOTES: hmitsaun: 1. [de07] Content: child allowances received on top of unemployment assistance are included. hmiatune: 1. [de07] Content: child allowances received on top of unemployment assistance are included. Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hi total income, household 10918 -125202 3020018 48113 55492 hmi total income, household, monetary 10918 -125202 3020018 48113 55492 hil labour income, household 10921 0 906996 34337.1 40641.5 hmil labour income, household, monetary 10921 0 906996 34337.1 40641.5 hile paid employment income, household 9861 0 512620 28185.2 34999.5 hmile paid employment income, household, monetary 9861 0 512620 28185.2 34999.5 hiler regular paid employment income, household 9861 0 512620 27676.7 34609.3 hmiler regular paid employment income, household, monetary 9861 0 512620 27676.7 34609.3 hilerb basic wages and salaries, household 9861 0 360000 25825.2 30711.7 hmilerb basic wages and salaries, household, monetary 9861 0 360000 25825.2 30711.7 hilers wage supplements, household 9861 0 334157 1851.56 7277.96 hmilers wage supplements, household, monetary 9861 0 334157 1851.56 7277.96 hilec casual paid employment income, household 9861 0 130608 508.46 3122.43 hmilec casual paid employment income, household, monetary 9861 0 130608 508.46 3122.43 hils self-employment income, household 9861 0 9e+05 4554.29 22224 hmils self-employment income, household, monetary 9861 0 9e+05 4554.29 22224 hilsf farm self-employment income, household 9861 0 341118 148.93 4265.46 hmilsf farm self-employment income, household, monetary 9861 0 341118 148.93 4265.46 hilsn non-farm self-employment income, household 9861 0 9e+05 4405.37 21828.4 hmilsn non-farm self-employment income, household, monetary 9861 0 9e+05 4405.37 21828.4 hic capital income, household 10921 -136648 2898971 3359.46 36979.7 hmic capital income, household , monetary 10921 -136648 2898971 3359.46 36979.7 hicid interest and dividends, household 10921 0 2598971 2029.93 30974 hmicid interest and dividends, household, monetary 10921 0 2598971 2029.93 30974 hicvip voluntary individual pensions, household 10921 0 75600 96.75 1510.05 hmicvip voluntary individual pensions, household, monetary 10921 0 75600 96.75 1510.05 hicren rental income, household 10775 0 864000 1370.09 13837.1 hmicren rental income, household, monetary 10775 0 864000 1370.09 13837.1 hit transfer income, household 10918 0 207600 10406.3 12610.6 hmit transfer income, household, monetary 10918 0 207600 10406.3 12610.6 hits social security transfers, household 10918 0 207600 10170.6 12573.4 hmits social security transfers, household, monetary 10918 0 207600 10170.6 12573.4 hitsi work-related insurance transfers, household 10918 0 207600 8011.08 12923.7 hmitsi work-related insurance transfers, household, monetary 10918 0 207600 8011.08 12923.7 hitsil long-term insurance transfers, household 10918 0 207600 7607.46 12963.1 hmitsil long-term insurance transfers, household, monetary 10918 0 207600 7607.46 12963.1 hitsilo ccupational pensions, household 9861 0 180000 731.93 4861.41 hmitsilo occupational pensions, household, monetary 9861 0 180000 731.93 4861.41 hitsilep employment-related public pensions, household 9861 0 107294 6944.53 11107.8 hmitsilep employment-related public pensions, household, monetary 9861 0 107294 6944.53 11107.8 hitsileps survivors insurance public pensions, household 9861 0 38491 779.62 2738.73 hmitsileps survivors insurance public pensions, household, monetary 9861 0 38491 779.62 2738.73 hitsilwi work-injury pensions, household 9861 0 25608 73.43 811.06 hmitsilwi work-injury pensions, household, monetary 9861 0 25608 73.43 811.06 hitsis short-term insurance transfers, household 10921 0 28800 403.51 1766.19 hmitsis short-term insurance transfers, household, monetary 10921 0 28800 403.51 1766.19 hitsisma maternity/parental wage replacement, household 10921 0 21500 117.81 847.3 hmitsisma maternity/parental wage replacement, household, monetary 10921 0 21500 117.81 847.3 hitsisun unemployment wage replacement, household 10921 0 28800 285.7 1543.54 hmitsisun unemployment wage replacement, household, monetary 10921 0 28800 285.7 1543.54 hitsu universal benefits, household 10921 0 30600 1391.88 2215.09 hmitsu universal benefits, household, monetary 10921 0 30600 1391.88 2215.09 hitsudi disability universal benefits, household 10921 0 21057 121.64 862.64 hmitsudi disability universal benefits, household, monetary 10921 0 21057 121.64 862.64 hitsufa family/child universal benefits, household 10921 0 21600 1044.81 1688.79 hmitsufa family/child universal benefits, household, monetary 10921 0 21600 1044.81 1688.79 hitsufaca child allowances, household 10921 0 21600 1044.81 1688.79 hmitsufaca child allowances, household, monetary 10921 0 21600 1044.81 1688.79 hitsa assistance benefits, household 10921 0 33432 753.67 2533.44 hmitsa assistance benefits, household, monetary 10921 0 33432 753.67 2533.44 hitsagen general social assistance, household 10921 0 16716 57.69 602.72 hmitsagen general social assistance, household, monetary 10921 0 16716 57.69 602.72 hitsap old-age/disability/survivors assistance pensions, household 10921 0 11040 29.76 427.07 hmitsap old-age/disability/survivors assistance pensions, household, monetary 10921 0 11040 29.76 427.07 hitsaun unemployment assistance, household 10921 0 22043 525.27 2042.31 hmitsaun unemployment assistance, household, monetary 10921 0 22043 525.27 2042.31 hitsaed education assistance, household 10921 0 14400 74.64 619.64 hmitsaed education assistance, household, monetary 10921 0 14400 74.64 619.64 hitsaho housing assistance, household 10921 0 10800 66.31 459.05 hmitsaho housing assistance, household, monetary 10921 0 10800 66.31 459.05 hitp private transfers, household 10921 0 50000 236.05 1521.91 hmitp private transfers, household, monetary 10921 0 50000 236.05 1521.91 hitpih inter-household transfers, household 10921 0 50000 236.05 1521.91 hmitpih inter-household transfers, household, monetary 10921 0 50000 236.05 1521.91 hitpiha alimony/child support, household 10921 0 24000 91.29 863.83 hmitpiha alimony/child support, household, monetary 10921 0 24000 91.29 863.83 hitpihft other family transfers, household 10921 0 50000 144.76 1256.84 hmitpihft other family transfers, household, monetary 10921 0 50000 144.76 1256.84 hiatsur survivors transfers, household 9861 0 58800 855.68 3040.85 hmiatsur survivors transfers, household, monetary 9861 0 58800 855.68 3040.85 hiatfam family/children transfers, household 10921 0 27044 1162.62 1989.05 hmiatfam family/children transfers, household, monetary 10921 0 27044 1162.62 1989.05 hiatedu education transfers, household 10921 0 14400 74.64 619.64 hmiatedu education transfers, household, monetary 10921 0 14400 74.64 619.64 hiatune unemployment transfers, household 10921 0 40172 810.97 2704.3 hmiatune unemployment transfers, household, monetary 10921 0 40172 810.97 2704.3 hiathou housing transfers, household 10921 0 10800 291.74 907.61 hmiathou housing transfers, household, monetary 10921 0 10800 291.74 907.61 hiatcsp civil servants pensions, household 9861 0 107294 1473.5 7229.15 hmiatcsp civil servants pensions, household, monetary 9861 0 107294 1473.5 7229.15 hiatwic work-injury compensation, household 9861 0 25608 73.43 811.06 hmiatwic work-injury compensation, household, monetary 9861 0 25608 73.43 811.06 hiatcar care benefits, household 10921 0 21057 121.64 862.64 hmiatcar care benefits, household, monetary 10921 0 21057 121.64 862.64 hiatvet war victim/veterans benefits, household 10921 0 14400 13.36 277.45 hmiatvet war victim/veterans benefits, household, monetary 10921 0 14400 13.36 277.45 ------------------------------------------------------------------------------------------------------------------------------------------------ WINDFALL INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hwl windfall labour income, household 10921 0 192000 197.15 3713.14 hmwl windfall labour income, household, monetary 10921 0 192000 197.15 3713.14 hwle windfall employee income, household 10921 0 192000 197.15 3713.14 hmwle windfall employee income, household, monetary 10921 0 192000 197.15 3713.14 hwt windfall transfer income, household 10921 0 5e+05 1032.7 13217.2 hmwt windfall transfer income, household, monetary 10921 0 5e+05 1032.7 13217.2 ------------------------------------------------------------------------------------------------------------------------------------------------ NON-CONSUMPTION EXPENDITURE ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hxit income taxes and social contributions, household 10921 0 1069027 13084.5 20859.2 hmxit income taxes and social contributions, household, monetary 10921 0 1069027 13084.5 20859.2 hxiti income taxes, household 10921 0 1069027 7570.89 18509.1 hmxiti income taxes, household, monetary 10921 0 1069027 7570.89 18509.1 hxits social security contributions, household 10921 0 32317 5513.62 5084.4 hmxits social security contributions, household, monetary 10921 0 32317 5513.62 5084.4 hxitss social security contributions, self-paid, household 10921 0 32317 5513.62 5084.4 hmxitss social security contributions, self-paid, household, monetary 10921 0 32317 5513.62 5084.4 hxih inter-household transfers paid, household 10814 0 4e+05 1044.07 6556.59 hmxih inter-household transfers paid, household, monetary 10814 0 4e+05 1044.07 6556.59 hxiha alimony/child support paid, household 10836 0 4e+05 913.29 6470.15 hmxiha alimony/child support paid, household, monetary 10836 0 4e+05 913.29 6470.15 hxihft other family transfers paid, household 10892 0 40000 129.79 929.14 hmxihft other family transfers paid, household, monetary 10892 0 40000 129.79 929.14 ------------------------------------------------------------------------------------------------------------------------------------------------ CONSUMPTION ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hchous housing and utilities, household 10066 0 250800 7807.3 6332.18 hmchous housing and utilities, household, monetary 10066 0 250800 6113.32 6022.21 hnchous housing and utilities, household, non-monetary 10921 0 33284 1796.19 2836.86 hchousa actual rent, household 10921 0 87816 2580.73 3394.58 hmchousa actual rent, household, monetary 10921 0 87816 2580.73 3394.58 hchousi imputed rent, household 10921 0 33284 1796.19 2836.86 hnchousi imputed rent, household, non-monetary 10921 0 33284 1796.19 2836.86 ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS - LIABILITIES TRANSACTIONS ------------------------------------------------------------------------------------------------------------------------------------------------ NOTES: hmtolm: 1. [de07] Content: includes also interest payments for mortgage. hmtolo: 1. [de07] Content: includes also interest payments. Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- htol outflows from loans, household 10621 0 435760 3377.56 9616.65 hmtol outflows from loans, household, monetary 10621 0 435760 3377.56 9616.65 htolm mortgage repayments, household 10641 0 435760 2687.81 9156.31 hmtolm mortgage repayments, household, monetary 10641 0 435760 2687.81 9156.31 htolo other loans repayments, household 10889 0 84000 685.54 2287.92 hmtolo other loans repayments, household, monetary 10889 0 84000 685.54 2287.92 ------------------------------------------------------------------------------------------------------------------------------------------------ MAJOR AGGREGATES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- dhi disposable household income 10918 -127670 1950991 35025 35998.2 dpi cash disposable household income 10918 -127670 1950991 35025 35998.2 factor factor income 10921 -125202 3020018 37696.5 57474.8 socred social security redistribution 10918 0 207600 10170.6 12573.4 privred private redistribution 10921 0 50000 236.05 1521.91 pension total pension income 10918 0 240000 7747.37 13181.6 ------------------------------------------------------------------------------------------------------------------------------------------------ ADDITIONAL INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ currency currency units -------------------------------------------------------------------------------- N code label 10921 978 EUR - Euro Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- deflator deflation factor 10921 1 1 1 0 grossnet gross/net income information -------------------------------------------------------------------------------- N code label 10921 120 gross, taxes and contributions imputed fhimpu household partial income imputation (dummy) -------------------------------------------------------------------------------- N code label 9861 0 no household member with full income imputation 1060 1 one or more household members with full income imputation