LIS - Egypt 2012 : household file Codebook generated: 2015-09-26 ------------------------------------------------------------------------------------------------------------------------------------------------ IDENTIFIERS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hid unique unit identifier 12060 1 12060 6030.5 3481.57 did unique country/year number -------------------------------------------------- N value 12060 291 dname country/year identifier -------------------------------------------------- N value 12060 "eg12" cname country name -------------------------------------------------- N value 12060 "Egypt" iso2 2-letter country abbreviation -------------------------------------------------- N value 12060 "eg" year reference year -------------------------------------------------- N value 12060 2012 wave data wave -------------------------------------------------------------------------------- N code label 12060 9 Wave IX ------------------------------------------------------------------------------------------------------------------------------------------------ FILE INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hwgt household weight (normalised) 12060 0.05 9.66 0.83 0.57 hpopwgt household weight (inflated) 12060 92.63 18950.18 1627.11 1127.79 svyunit survey unit -------------------------------------------------------------------------------- N code label 12060 1 household npers number of persons in survey unit -------------------------------------------------------------------------------- N code label 726 1 1 person 1791 2 2 persons 2290 3 3 persons 2783 4 4 persons 2198 5 5 persons 1189 6 6 persons 563 7 7 persons 247 8 8 persons 139 9 9 persons 52 10 10 persons 28 11 11 persons 18 12 12 persons 12 13 13 persons 7 14 14 persons 6 15 15 persons 3 16 16 persons 4 17 17 persons 1 18 18 persons 1 20 20 persons 2 21 21 persons ------------------------------------------------------------------------------------------------------------------------------------------------ GEOGRAPHICAL CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ region_c Region -------------------------------------------------------------------------------- N code label 1525 1 Greater Cairo 1073 2 Alexandria, Suez Canal 1463 3 Urban Lower Egypt 1638 4 Urban Upper Egypt 3406 5 Rural Lower Egypt 2955 6 Rural Upper Egypt rural rural area (dummy) -------------------------------------------------------------------------------- N code label 5681 0 not rural area 6379 1 rural area area_c type of area (urban/rural) -------------------------------------------------------------------------------- N code label 5681 1 urban 6379 2 rural ------------------------------------------------------------------------------------------------------------------------------------------------ DWELLING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ own owned/rented housing -------------------------------------------------------------------------------- N code label 7269 100 owned 2145 210 rented 2646 220 free housing dweltyp type of dwelling -------------------------------------------------------------------------------- N code label 678 100 house 2260 110 detached house 8356 210 apartment/flat 756 220 other multi-unit 9 300 other type of dwelling 1 320 informal dwelling ------------------------------------------------------------------------------------------------------------------------------------------------ FARMING CHARACTERISTICS ------------------------------------------------------------------------------------------------------------------------------------------------ farm farm household (dummy) -------------------------------------------------------------------------------- N code label 10084 0 not farm household 1976 1 farm household agriland ownership of agricultural land -------------------------------------------------------------------------------- N code label 1821 100 owns or rents agricultural land 10239 200 does not own nor rent agricultural land farming farming activity -------------------------------------------------------------------------------- N code label 1192 110 grows crops, owns livestock 629 120 grows crops, does not own livestock 155 130 owns livestock, does not grow crops 10084 200 does not run a farming activity ------------------------------------------------------------------------------------------------------------------------------------------------ HOUSEHOLD COMPOSITION ------------------------------------------------------------------------------------------------------------------------------------------------ hhtype household composition -------------------------------------------------------------------------------- N code label 728 100 one person household 1305 210 couple without children 7119 220 couple with children 1219 230 one parent with children 88 310 couple without children and relatives 971 320 couple with children and relatives 443 330 one parent with children and relatives 160 400 relatives living together (no family nucleus) 3 510 couple without children and nonrelatives 6 520 couple with children and nonrelatives 5 530 one parent with children and nonrelatives 2 610 couple without children and relatives and nonrelatives 4 620 couple with children and relatives and nonrelatives 4 630 one parent with children and relatives and nonrelatives 1 700 relatives and nonrelatives living together (no family nucleus) 2 800 nonrelatives living together hpartner head living with partner -------------------------------------------------------------------------------- N code label 9497 110 married couple 2563 200 head not living with partner nhhmem number of household members -------------------------------------------------------------------------------- N code label 728 1 1 hh member 1791 2 2 hh members 2291 3 3 hh members 2784 4 4 hh members 2195 5 5 hh members 1188 6 6 hh members 563 7 7 hh members 247 8 8 hh members 139 9 9 hh members 52 10 10 hh members 28 11 11 hh members 18 12 12 hh members 12 13 13 hh members 7 14 14 hh members 6 15 15 hh members 3 16 16 hh members 4 17 17 hh members 1 18 18 hh members 1 20 20 hh members 2 21 21 hh members nhhmem65 number of household members 65 or older -------------------------------------------------------------------------------- N code label 9894 0 no hh members 65 or older 1775 1 1 hh member 65 or older 387 2 2 hh members 65 or older 4 3 3 hh members 65 or older nhhmem17 number of household members 17 or younger -------------------------------------------------------------------------------- N code label 3686 0 no hh members 17 or younger 2571 1 1 hh member 17 or younger 2760 2 2 hh member 17 or younger 1903 3 3 hh member 17 or younger 759 4 4 hh member 17 or younger 241 5 5 hh member 17 or younger 93 6 6 hh member 17 or younger 29 7 7 hh member 17 or younger 13 8 8 hh member 17 or younger 2 9 9 hh member 17 or younger 1 10 10 hh member 17 or younger 1 12 12 hh member 17 or younger 1 13 13 hh member 17 or younger nhhmem13 number of household members 13 or younger -------------------------------------------------------------------------------- N code label 4526 0 no hh members 13 or younger 2602 1 1 hh member 13 or younger 2638 2 2 hh member 13 or younger 1620 3 3 hh member 13 or younger 481 4 4 hh member 13 or younger 130 5 5 hh member 13 or younger 40 6 6 hh member 13 or younger 12 7 7 hh member 13 or younger 7 8 8 hh member 13 or younger 1 9 9 hh member 13 or younger 2 10 10 hh member 13 or younger 1 12 12 hh member 13 or younger nhhmem5 number of household members 5 or younger -------------------------------------------------------------------------------- N code label 6458 0 no hh members 5 or younger 3168 1 1 hh member 5 or younger 2033 2 2 hh member 5 or younger 348 3 3 hh member 5 or younger 36 4 4 hh member 5 or younger 11 5 5 hh member 5 or younger 3 6 6 hh member 5 or younger 2 7 7 hh member 5 or younger 1 8 8 hh member 5 or younger Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- ageymem age of youngest household member 12060 0 95 14.8 19.09 nearn number of household members with labour income -------------------------------------------------------------------------------- N code label 4162 0 no hh members with labour income 5877 1 1 hh member with labour income 1637 2 2 hh members with labour income 299 3 3 hh members with labour income 64 4 4 hh members with labour income 7 5 5 hh members with labour income 2 6 6 hh members with labour income 12 . ------------------------------------------------------------------------------------------------------------------------------------------------ CURRENT INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- hi total income, household 12040 -9760 1890600 22809.6 48502.1 hmi total income, household, monetary 12043 -9760 1875600 22499.9 47860.7 hni total income, household, non-monetary 12057 0 80000 173.03 1521.02 hil labour income, household 12046 -9760 1838800 16798.4 35135.2 hmil labour income, household, monetary 12046 -9760 1838800 16648.9 35056.8 hnil labour income, household, non-monetary 12060 0 44800 15.5 495.44 hile paid employment income, household 12048 0 420000 11182 17639.1 hmile paid employment income, household, monetary 12048 0 420000 11166.5 17631.3 hnile paid employment income, household, non-monetary 12060 0 44800 15.5 495.44 hiler regular paid employment income, household 12059 0 420000 9132.21 17555.9 hmiler regular paid employment income, household, monetary 12059 0 420000 9132.21 17555.9 hilerb basic wages and salaries, household 12060 0 420000 7893.55 15721.3 hmilerb basic wages and salaries, household, monetary 12060 0 420000 7893.55 15721.3 hilers wage supplements, household 12059 0 219000 1238.25 5864.45 hmilers wage supplements, household, monetary 12059 0 219000 1238.25 5864.45 hilec casual paid employment income, household 12060 0 76320 1838.73 5134.42 hmilec casual paid employment income, household, monetary 12060 0 76320 1823.23 5085.09 hnilec casual paid employment income, household, non-monetary 12060 0 44800 15.5 495.44 hils self-employment income, household 12058 -10700 1825000 5614.22 31212.5 hmils self-employment income, household, monetary 12058 -10700 1825000 5480.35 31164.6 hilsf farm self-employment income, household 12059 -10700 840000 1527.55 11085.4 hmilsf farm self-employment income, household, monetary 12059 -45000 840000 1381.19 10955 hilsn non-farm self-employment income, household 12059 0 1825000 4086.8 29294.3 hmilsn non-farm self-employment income, household, monetary 12059 0 1825000 4086.8 29294.3 hic capital income, household 12059 0 1860000 2398.26 29533.2 hmic capital income, household , monetary 12059 0 1860000 2398.26 29533.2 hicid interest and dividends, household 12059 0 480000 357.53 6442.24 hmicid interest and dividends, household, monetary 12059 0 480000 357.53 6442.24 hicren rental income, household 12060 0 1800000 2040.56 28080.6 hmicren rental income, household, monetary 12060 0 1800000 2040.56 28080.6 hit transfer income, household 12055 0 809440 3579.58 12915.1 hmit transfer income, household, monetary 12058 0 808640 3422.84 12715.2 hnit transfer income, household, non-monetary 12057 0 80000 157.53 1439 hits social security transfers, household 12059 0 180000 2430.83 6770.18 hmits social security transfers, household, monetary 12059 0 180000 2430.83 6770.18 hitsi work-related insurance transfers, household 12059 0 180000 2217.93 6766.75 hmitsi work-related insurance transfers, household, monetary 12059 0 180000 2217.93 6766.75 hitsil long-term insurance transfers, household 12059 0 180000 2217.93 6766.75 hmitsil long-term insurance transfers, household, monetary 12059 0 180000 2217.93 6766.75 hitsa assistance benefits, household 12060 0 28800 212.89 910.87 hmitsa assistance benefits, household, monetary 12060 0 28800 212.89 910.87 hitsap old-age/disability/survivors assistance pensions, household 12060 0 28800 96.83 599.51 hmitsap old-age/disability/survivors assistance pensions, household, monetary 12060 0 28800 96.83 599.51 hitp private transfers, household 12056 0 800800 1147.94 10960.4 hmitp private transfers, household, monetary 12059 0 8e+05 991.81 10714.7 hnitp private transfers, household, non-monetary 12057 0 80000 157.53 1439 hitpnp transfers from non-profit institutions, household 12060 0 14400 18.6 260.93 hmitpnp transfers from non-profit institutions, household, monetary 12060 0 14400 18.6 260.93 hitpih inter-household transfers, household 12056 0 800800 1129.33 10958.7 hmitpih inter-household transfers, household, monetary 12059 0 8e+05 973.21 10712.7 hnitpih inter-household transfers, household, non-monetary 12057 0 80000 157.53 1439 hitpiha alimony/child support, household 12060 0 40000 25.6 608.93 hmitpiha alimony/child support, household, monetary 12060 0 40000 21.85 559.4 hnitpiha alimony/child support, household, non-monetary 12060 0 5000 3.75 108.95 hitpihr remittances, household 12056 0 240000 482.65 5563.48 hmitpihr remittances, household, monetary 12059 0 240000 453.27 5401.81 hnitpihr remittances, household, non-monetary 12057 0 60000 30.43 767.57 hitpihft other family transfers, household 12060 0 800800 412.63 8335.77 hmitpihft other family transfers, household, monetary 12060 0 8e+05 289.31 8119.25 hnitpihft other family transfers, household, non-monetary 12060 0 80000 123.32 1215.26 ------------------------------------------------------------------------------------------------------------------------------------------------ WINDFALL INCOME ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ NON-CONSUMPTION EXPENDITURE ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ CONSUMPTION ------------------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------------------ ASSETS - LIABILITIES TRANSACTIONS ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- htil inflows from loans, household 12019 0 145000 1467.48 6667.49 hmtil inflows from loans, household, monetary 12019 0 145000 1467.48 6667.49 htolm mortgage repayments, household 1 22800 22800 22800 NA hmtolm mortgage repayments, household, monetary 1 22800 22800 22800 NA htolo other loans repayments, household 14 360 48000 6973.71 12364 hmtolo other loans repayments, household, monetary 14 360 48000 6973.71 12364 ------------------------------------------------------------------------------------------------------------------------------------------------ MAJOR AGGREGATES ------------------------------------------------------------------------------------------------------------------------------------------------ Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- dhi disposable household income 12040 -9760 1890600 22809.6 48502.1 dpi cash disposable household income 12043 -9760 1875600 22499.9 47860.7 factor factor income 12045 -9760 1875000 19199.1 46941.6 socred social security redistribution 12059 0 180000 2430.83 6770.18 privred private redistribution 12056 0 800800 1147.94 10960.4 pension total pension income 12059 0 180000 2314.76 6763.74 ------------------------------------------------------------------------------------------------------------------------------------------------ ADDITIONAL INFORMATION ------------------------------------------------------------------------------------------------------------------------------------------------ currency currency units -------------------------------------------------------------------------------- N code label 12060 818 EGP - Egyptian Pound Variable Description N Min. Max. Mean SD ----------------------------------------------------------------------------------------------------------------------------------------------- deflator deflation factor 12060 1 1 1 0 grossnet gross/net income information -------------------------------------------------------------------------------- N code label 12060 200 net, taxes and contributions not captured