LIS - Colombia 2007 : household file Codebook generated: 2015-12-18 ------------------------------------------------------------------------------------------------------------------------------------------------ IDENTIFIERS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hid unique unit identifier 17545 1 17545 8773 5064.95 did unique country/year number -------------------------------------------------- N value 17545 243 dname country/year identifier -------------------------------------------------- N value 17545 "co07" cname country name -------------------------------------------------- N value 17545 "Colombia" iso2 2-letter country abbreviation -------------------------------------------------- N value 17545 "co" year reference year -------------------------------------------------- N value 17545 2007 wave data wave -------------------------------------------------------------------------------- N code label 17545 7 Wave VII ------------------------------------------------------------------------------------------------------------------------------------------------ FILE INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hwgt household weight (normalised) 17545 0.02 10.16 0.57 0.91 hpopwgt household weight (inflated) 17545 19.55 11577.57 649.47 1033.91 svyunit survey unit -------------------------------------------------------------------------------- N code label 17545 1 household npers number of persons in survey unit -------------------------------------------------------------------------------- N code label 1837 1 1 person 2894 2 2 persons 3821 3 3 persons 3855 4 4 persons 2486 5 5 persons 1280 6 6 persons 639 7 7 persons 345 8 8 persons 160 9 9 persons 105 10 10 persons 57 11 11 persons 31 12 12 persons 9 13 13 persons 11 14 14 persons 5 15 15 persons 4 16 16 persons 4 17 17 persons 2 21 21 persons ------------------------------------------------------------------------------------------------------------------------------------------------ GEOGRAPHICAL CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ region_c Geographical region and administrative district (departamentos) -------------------------------------------------------------------------------- N code label 943 108 Atlantic region, Atlántico 719 113 Atlantic region, Bolívar 822 120 Atlantic region, Cesar 579 123 Atlantic region, Córdoba 468 144 Atlantic region, La Guajira 693 147 Atlantic region, Magdalena 674 170 Atlantic region, Sucre 634 215 Oriental region, Boyacá 187 225 Oriental region, Cundinamarca 620 250 Oriental region, Meta 922 254 Oriental region, Norte de Santander 834 268 Oriental region, Santander 959 305 Central region, Antioquia 932 317 Central region, Caldas 490 318 Central region, Caquetá 930 341 Central region, Huila 1178 363 Central region, Quindio 828 366 Central region, Risaralda 618 373 Central region, Tolima 744 419 Pacific region, Cauca 411 427 Pacific region, Chocó 731 452 Pacific region, Nariño 870 476 Pacific region, Valle del Cauca 759 511 Bogotá, Distrito Capital rural rural area (dummy) -------------------------------------------------------------------------------- N code label 15940 0 not rural area 1605 1 rural area ------------------------------------------------------------------------------------------------------------------------------------------------ DWELLING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ own owned/rented housing -------------------------------------------------------------------------------- N code label 8098 110 owned outright 710 120 owned with mortgage 5925 210 rented 2374 220 free housing 438 224 illegal occupation dweltyp type of dwelling -------------------------------------------------------------------------------- N code label 10815 100 house 5358 210 apartment/flat 545 220 other multi-unit 5 300 other type of dwelling 822 . Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- dwelval value of dwelling 7560 10000 8.5e+08 4.5e+07 5.5e+07 ------------------------------------------------------------------------------------------------------------------------------------------------ FARMING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ HOUSEHOLD COMPOSITION ------------------------------------------------------------------------------------------------------------------------------------------------ hhtype household composition -------------------------------------------------------------------------------- N code label 1881 100 one person household 1256 210 couple without children 6180 220 couple with children 2544 230 one parent with children 318 310 couple without children and relatives 2146 320 couple with children and relatives 1696 330 one parent with children and relatives 832 400 relatives living together (no family nucleus) 45 510 couple without children and nonrelatives 159 520 couple with children and nonrelatives 64 530 one parent with children and nonrelatives 14 610 couple without children and relatives and nonrelatives 147 620 couple with children and relatives and nonrelatives 115 630 one parent with children and relatives and nonrelatives 43 700 relatives and nonrelatives living together (no family nucleus) 105 800 nonrelatives living together hpartner head living with partner -------------------------------------------------------------------------------- N code label 84 100 head living with partner 5464 110 married couple 4717 120 non-married cohabiting couple 7280 200 head not living with partner nhhmem number of household members -------------------------------------------------------------------------------- N code label 1881 1 1 hh member 2929 2 2 hh members 3843 3 3 hh members 3847 4 4 hh members 2453 5 5 hh members 1247 6 6 hh members 625 7 7 hh members 336 8 8 hh members 160 9 9 hh members 101 10 10 hh members 57 11 11 hh members 31 12 12 hh members 9 13 13 hh members 11 14 14 hh members 5 15 15 hh members 4 16 16 hh members 4 17 17 hh members 2 21 21 hh members nhhmem65 number of household members 65 or older -------------------------------------------------------------------------------- N code label 13665 0 no hh members 65 or older 2973 1 1 hh member 65 or older 855 2 2 hh members 65 or older 47 3 3 hh members 65 or older 5 4 4 hh members 65 or older nhhmem17 number of household members 17 or younger -------------------------------------------------------------------------------- N code label 6345 0 no hh members 17 or younger 4708 1 1 hh member 17 or younger 3651 2 2 hh member 17 or younger 1787 3 3 hh member 17 or younger 630 4 4 hh member 17 or younger 236 5 5 hh member 17 or younger 111 6 6 hh member 17 or younger 41 7 7 hh member 17 or younger 25 8 8 hh member 17 or younger 4 9 9 hh member 17 or younger 4 10 10 hh member 17 or younger 3 11 11 hh member 17 or younger nhhmem13 number of household members 13 or younger -------------------------------------------------------------------------------- N code label 7900 0 no hh members 13 or younger 4903 1 1 hh member 13 or younger 2951 2 2 hh member 13 or younger 1224 3 3 hh member 13 or younger 351 4 4 hh member 13 or younger 136 5 5 hh member 13 or younger 47 6 6 hh member 13 or younger 18 7 7 hh member 13 or younger 12 8 8 hh member 13 or younger 1 9 9 hh member 13 or younger 2 10 10 hh member 13 or younger nhhmem5 number of household members 5 or younger -------------------------------------------------------------------------------- N code label 12205 0 no hh members 5 or younger 4070 1 1 hh member 5 or younger 1021 2 2 hh member 5 or younger 210 3 3 hh member 5 or younger 29 4 4 hh member 5 or younger 8 5 5 hh member 5 or younger 1 6 6 hh member 5 or younger 1 7 7 hh member 5 or younger Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- ageymem age of youngest household member 17545 0 99 18.61 19.73 nearn number of household members with labour income -------------------------------------------------------------------------------- N code label 2208 0 no hh members with labour income 7559 1 1 hh member with labour income 4788 2 2 hh members with labour income 1423 3 3 hh members with labour income 422 4 4 hh members with labour income 96 5 5 hh members with labour income 22 6 6 hh members with labour income 6 7 7 hh members with labour income 3 8 8 hh members with labour income 1 9 9 hh members with labour income 1017 . ------------------------------------------------------------------------------------------------------------------------------------------------ CURRENT INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hi total income, household 16370 0 1.495e+09 1.5e+07 2.5e+07 hmi total income, household, monetary 16392 0 1.495e+09 1.5e+07 2.5e+07 hni total income, household, non-monetary 17502 0 7.8e+07 224663 1500000 hil labour income, household 16579 0 1.495e+09 1.1e+07 2.2e+07 hmil labour income, household, monetary 16605 0 1.495e+09 1.1e+07 2.2e+07 hnil labour income, household, non-monetary 17502 0 7.8e+07 224663 1500000 hile paid employment income, household 17116 0 1.495e+09 6400000 1.8e+07 hmile paid employment income, household, monetary 17147 0 1.495e+09 6200000 1.8e+07 hnile paid employment income, household, non-monetary 17502 0 7.8e+07 224663 1500000 hils self-employment income, household 16991 0 3.9e+08 4800000 1.3e+07 hmils self-employment income, household, monetary 16991 0 3.9e+08 4800000 1.3e+07 hic capital income, household 17498 0 417600000 749638 6200000 hmic capital income, household , monetary 17498 0 417600000 749638 6200000 hicid interest and dividends, household 17531 0 1.45e+08 118726 2300000 hmicid interest and dividends, household, monetary 17531 0 1.45e+08 118726 2300000 hicren rental income, household 17512 0 417600000 633919 5600000 hmicren rental income, household, monetary 17512 0 417600000 633919 5600000 hit transfer income, household 17258 0 5e+08 2900000 8800000 hmit transfer income, household, monetary 17258 0 5e+08 2900000 8800000 hits social security transfers, household 17425 0 3.6e+08 2e+06 7300000 hmits social security transfers, household, monetary 17425 0 3.6e+08 2e+06 7300000 hitsi work-related insurance transfers, household 17425 0 3.6e+08 2e+06 7300000 hmitsi work-related insurance transfers, household, monetary 17425 0 3.6e+08 2e+06 7300000 hitsil long-term insurance transfers, household 17487 0 3.6e+08 1700000 7300000 hmitsil long-term insurance transfers, household, monetary 17487 0 3.6e+08 1700000 7300000 hitp private transfers, household 17366 0 5e+08 846622 5e+06 hmitp private transfers, household, monetary 17366 0 5e+08 846622 5e+06 hitped merit-based education transfers, household 17534 0 2.5e+07 17660.2 337312 hmitped merit-based education transfers, household, monetary 17534 0 2.5e+07 17660.2 337312 hitpnp transfers from non-profit institutions, household 17545 0 1e+07 3867.14 138399 hmitpnp transfers from non-profit institutions, household, monetary 17545 0 1e+07 3867.14 138399 hitpih inter-household transfers, household 17376 0 5e+08 825179 4900000 hmitpih inter-household transfers, household, monetary 17376 0 5e+08 825179 4900000 hitpiha alimony/child support, household 17543 0 129600000 72216.8 1500000 hmitpiha alimony/child support, household, monetary 17543 0 129600000 72216.8 1500000 hitpihft other family transfers, household 17377 0 5e+08 752363 4700000 hmitpihft other family transfers, household, monetary 17377 0 5e+08 752363 4700000 ------------------------------------------------------------------------------------------------------------------------------------------------ WINDFALL INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hwl windfall labour income, household 17527 0 6.7e+07 34630 764339 hmwl windfall labour income, household, monetary 17527 0 6.7e+07 34630 764339 hwle windfall employee income, household 17527 0 6.7e+07 34630 764339 hmwle windfall employee income, household, monetary 17527 0 6.7e+07 34630 764339 ------------------------------------------------------------------------------------------------------------------------------------------------ NON-CONSUMPTION EXPENDITURE ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hxit income taxes and social contributions, household 16698 0 251900000 1800000 4300000 hmxit income taxes and social contributions, household, monetary 16698 0 251900000 1800000 4300000 hxiti income taxes, household 17545 0 461400000 1300000 5200000 hmxiti income taxes, household, monetary 17545 0 461400000 1300000 5200000 hxits social security contributions, household 16698 0 6e+07 515466 1300000 hmxits social security contributions, household, monetary 16698 0 6e+07 515466 1300000 ------------------------------------------------------------------------------------------------------------------------------------------------ CONSUMPTION ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hchous housing and utilities, household 17379 0 1.08e+09 3300000 1.4e+07 hmchous housing and utilities, household, monetary 17529 0 6e+08 953101 4900000 hnchous housing and utilities, household, non-monetary 17395 0 1.08e+09 2300000 1.3e+07 hchousa actual rent, household 17529 0 6e+08 953101 4900000 hmchousa actual rent, household, monetary 17529 0 6e+08 953101 4900000 hchousi imputed rent, household 17395 0 1.08e+09 2300000 1.3e+07 hnchousi imputed rent, household, non-monetary 17395 0 1.08e+09 2300000 1.3e+07 ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS - LIABILITIES TRANSACTIONS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- htol outflows from loans, household 17527 0 7.2e+07 199681 1400000 hmtol outflows from loans, household, monetary 17527 0 7.2e+07 199681 1400000 htolm mortgage repayments, household 17527 0 7.2e+07 199681 1400000 hmtolm mortgage repayments, household, monetary 17527 0 7.2e+07 199681 1400000 ------------------------------------------------------------------------------------------------------------------------------------------------ MAJOR AGGREGATES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- dhi disposable household income 15847 -25200000 570600000 1.3e+07 2e+07 dpi cash disposable household income 15866 -25200000 570600000 1.3e+07 2e+07 factor factor income 16548 0 1.495e+09 1.2e+07 2.3e+07 socred social security redistribution 17425 0 3.6e+08 2e+06 7300000 privred private redistribution 17366 0 5e+08 846622 5e+06 pension total pension income 17487 0 3.6e+08 1700000 7300000 ------------------------------------------------------------------------------------------------------------------------------------------------ ADDITIONAL INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ currency currency units -------------------------------------------------------------------------------- N code label 17545 170 COP - Colombian Peso Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- deflator deflation factor 17545 1 1 1 0 grossnet gross/net income information -------------------------------------------------------------------------------- N code label 17545 310 mixed, total income account for full taxes and contributions, subcomponents do not