Feed the Future Malawi Interim Survey in the Zone of Infuence, Household Consumption Expenditures
data.usaid.gov | Last Updated 12 Nov 2018This dataset contains variables from Module E, the Household Consumption Expenditures module used to calculate the poverty and expenditure indicators. It is part of the 2015 Feed the Future Malawi Interim Survey in the Zone of Influence. The survey was designed to monitor program performance by periodic assessments of a number of standardized indicators. A total of 1,021 households were interviewed, which provided data for the target sample size of 1,007 households and ensured the sample is representative of the seven districts covered in the interim assessment. This dataset includes household-level derived variables (including the expenditure and poverty indicator variables), as well as variables from sub-Module E6: Housing Expenditures. The unique identifier in this household-level file is pbs_id.
This dataset has the following 73 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| country | country | text | These data were collected in Malawi | Malawi view top 100 |
| survey | survey | text | Two surveys were administered. This variable identifies whether the survey was the Interim Feed the Future survey or the Baseline Food for Peace survey. | 2015 Interim Feed the Future survey 2015 Baseline Food for Peace survey view top 100 |
| zoi | zoi | text | Was the data collected by Westat or ICF? | data collected by westat data collected by icf view top 100 |
| cluster | cluster | number | Cluster number | 241 14 187 193 269 view top 100 |
| project | project | text | Identifies whether the record is used to report on Feed the Future (FTF), Food for Peace (FFP), Catholic Relief Services (CRS), or Project Concern International (PCI) programming. Due to coordinated survey collection, the same record may be used to evalu | FTF FTF-FFP-PCI view top 100 |
| pbs_id | pbs_id | number | Administrative variable for identifying households | 10011 10015 10037 10042 10050 view top 100 |
| subgroup3 | subgroup3 | checkbox | The 7-district FTF FEEDBACK ZOI which will include district level data from rural areas only of Michinji, Lilongwe, Dedza, Mangochi, Ntcheu, Balaka, Machinga. | true view top 100 |
| strata3 | strata3 | text | Stratification for subgroup 3 | lilongwe ftf mangochi ftf dedza ftf mchinji ftf ntcheu ftf view top 100 |
| urbrur | urbrur | text | Location type (urban rural) | rural view top 100 |
| ghht | ghht | text | Derived gendered household type | male and female adults female adult(s) only male adult(s) only view top 100 |
| today | today | text | The day of interview as a string variable, MM-DD-YYYY | 09-05-2015 09-22-2015 09-29-2015 09-28-2015 09-30-2015 view top 100 |
| s_hh_wt3 | s_hh_wt3 | number | Household weights, adjusted for non-response, subgroup 3 | 0.0094811329 0.0104571835 467.8575688073 0.0105915493 0.0105180625 view top 100 |
| pcc_wt3 | pcc_wt3 | number | Per capita consumption and poverty weight, subgroup 3 | 3292.9606933594 0.0391493179 4125.4106445313 0.0568867959 0.0383005813 view top 100 |
| e108 | e108 | checkbox | Over the past 7 days, did any people who are not members of your household eat any meals in your household? | true false view top 100 |
| e109 | e109 | number | Over the past 7 days, how many people who are not members of your household ate meals in your household? | 2.0 1.0 3.0 4.0 5.0 view top 100 |
| e110 | e110 | number | Over the past 7 days, what was the total number of days in which any meal was shared with people who are not members of your household? | 1.0 2.0 3.0 7.0 4.0 view top 100 |
| e111 | e111 | number | Over the past 7 days, what was the total number of meals that were shared with people who are not members of your household? | 1.0 2.0 3.0 4.0 6.0 view top 100 |
| e112 | e112 | checkbox | Over the past 7 days, did your household purchase pet food for family pets like a cat or a dog? | false true view top 100 |
| e113 | e113 | text | How much did you spend on pet food last week? | 200 500 150 1800 20 view top 100 |
| e114 | e114 | text | Over the past 7 days, were there any other expenditures on pets? | no yes don't know view top 100 |
| e115 | e115 | text | How much did you spend on their purchases for pets last week? | 100.0 300.0 50.0 500.0 view top 100 |
| e601 | e601 | text | Do you own or are purchasing this household, is it provided to you by an employer, do you use it for free, or do you rent this house? | own free rented employer provides view top 100 |
| e602 | e602 | number | If you sold this dwelling today, how much would you receive for it? | 50000.0 100000.0 99999991.0 10000.0 20000.0 view top 100 |
| e603 | e603 | text | How old is this house, in years? | 3 2 5 4 7 view top 100 |
| e604a | e604a | number | If you rented this dwelling out today, how much rent would you receive? Local amount | 1000.0 1500.0 2000.0 5000.0 500.0 view top 100 |
| e604b | e604b | text | If you rented this dwelling out today, how much rent would you receive? Unit | month don't know/non-response/na year view top 100 |
| e605a | e605a | number | How much do you pay to rent this dwelling? Local amount | 5000.0 3000.0 2000.0 1500.0 1000.0 view top 100 |
| e605b | e605b | text | How much do you pay to rent this dwelling? Unit | month week view top 100 |
| e606 | e606 | checkbox | Do you pay a mortgage on this house, that is, a regular payment towards purchasing the house? | false true view top 100 |
| e607 | e607 | text | How often do you make mortgage payments? | don't know view top 100 |
| e608 | e608 | text | How much do you pay each time you make a payment on your mortgage? | view top 100 |
| e609 | e609 | number | In the past month, how much did you spent on repairs maintenance to this house? | 0.0 2000.0 3000.0 5000.0 1500.0 view top 100 |
| price_index | price_index | number | Spatial price index | 86.69 110.67 view top 100 |
| hhexp_cat01 | hhexp_cat01 | number | Food Bev, real daily consumption | 7000.0 716.8399716560001 894.8140335844 2487.4528687701 993.463395621 view top 100 |
| hhexp_cat02 | hhexp_cat02 | number | Alc Tobacco, real daily consumption | 0.0 300.0 16.479079808199998 49.4372394246 32.958159616399996 view top 100 |
| hhexp_cat03 | hhexp_cat03 | number | Clothing Footwear, real daily consumption | 0.0 6.3207429401 4.9511629663 20.226377408399998 5.9413955595 view top 100 |
| hhexp_cat04 | hhexp_cat04 | number | Housing Utilities, real daily consumption | 800.0 87.28387529 86.9786688773 90.2768640465 90.4569136559 view top 100 |
| hhexp_cat05 | hhexp_cat05 | number | Furnishings, real daily consumption | 0.0 7.584891528200001 22.7546745845 15.169783056300002 18.9622288204 view top 100 |
| hhexp_cat06 | hhexp_cat06 | number | Health, real daily consumption | 0.0 7.584891528200001 3.7924457641 2.2754674584 2.9706977798 view top 100 |
| hhexp_cat07 | hhexp_cat07 | number | Transport, real daily consumption | 0.0 10.1293957374 7.157011975 11.198860957 8.5202500787 view top 100 |
| hhexp_cat08 | hhexp_cat08 | number | Communication, real daily consumption | 0.0 11.3773372922 7.584891528200001 5.6886686461 3.7924457641 view top 100 |
| hhexp_cat09 | hhexp_cat09 | number | Recreation, real daily consumption | 0.0 4.3894048195 8.7788096391 5.785326292100001 3.1603714701 view top 100 |
| hhexp_cat10 | hhexp_cat10 | number | Education, real daily consumption | 0.0 0.948111441 9.4811144102 1.896222882 1.580185735 view top 100 |
| hhexp_cat11 | hhexp_cat11 | number | Hotels and restaurants, real daily consumption | 0.0 16.479079808199998 12.9083891621 6.5916319233000005 24.7186197123 view top 100 |
| hhexp_cat12 | hhexp_cat12 | number | Misc Goods Services, real daily consumption | 0.0 18.9622288204 13.368140009000001 11.8827911191 24.650897466500002 view top 100 |
| hhexp_total | hhexp_total | number | Derived daily total HH expenditures in 2015 Kwacha | 9649.5377917163 6037.2172164633985 6230.4685087963 325.82229669459997 609.2277900938 view top 100 |
| povthres_125 | povthres_125 | number | The poverty threshold of 1.25 2005 PPP per person per day in constant 2015 Kwacha | 272.4546813965 view top 100 |
| povthres_nat | povthres_nat | number | The national poverty threshold of 1.25 2005 PPP per person per day in constant 2015 Kwacha | 348.0657348633 view top 100 |
| povthres_ext | povthres_ext | number | The extreme poverty threshold of 1.25 2005 PPP per person per day in constant 2015 Kwacha | 215.9336395264 view top 100 |
| povthres_190 | povthres_190 | number | The poverty threshold of 1.90 2011 PPP per person per day in constant 2015 Kwacha | 338.5909729004 view top 100 |
| usdconversion | usdconversion | number | Conversion factor transforming 2015 Kwacha into 2010 USD, adjusting for 2005 PPP. | 0.0051224115 view top 100 |
| pcc | pcc | number | Derived daily per capita consumption in 2015 Kwacha | 1072.8956410633 252.5655522423 655.0254406244001 203.41430310540002 829.2949957371001 view top 100 |
| pcc_usd | pcc_usd | number | Derived daily per capita consumption in 2010 US dollars, adjusted for 2005 PPP | 0.6716052294 1.9964487553 2.2130343914 0.9055538774 1.5395025015 view top 100 |
| pov | pov | text | Poverty status at the poverty threshold of less than 1.25 per person per day in 2005 PPP | not in poverty in poverty view top 100 |
| gap | gap | number | Poverty gap at the poverty threshold of less than 1.25 per person per day in 2005 PPP. Value is normalized to the poverty threshold, such that values are expressed as a proportion of the poverty line, and households with consumption at the threshold or h | 0.0 0.0083216457 0.0091217067 0.0098785646 0.0101710511 view top 100 |
| shortfall | shortfall | number | Consumption shortfall of the poor at the poverty threshold of less than 1.25 per person per day in 2005 PPP. Value is normalized to the poverty threshold and households, such that values are expressed as a proportion of the poverty line, with consumptio | 0.0083216457 0.009121706700000001 0.0098785646 0.0101710511 0.0111500341 view top 100 |
| pov_nat | pov_nat | text | Poverty status at the national poverty threshold of 350.51 2015 Kwacha. | in poverty not in poverty view top 100 |
| gap_nat | gap_nat | number | Poverty gap at the national poverty threshold. Value is normalized to the poverty threshold, such that values are expressed as a proportion of the poverty line, and households with consumption at the threshold or higher are set to missing. | 0.0 0.0048706746 0.008883547 0.0109631261 0.0138537623 view top 100 |
| shortfall_nat | shortfall_nat | number | Consumption shortfall of the poor at the national poverty threshold. Value is normalized to the poverty threshold and households, such that values are expressed as a proportion of the poverty line, with consumption at the threshold or higher are set to m | 0.5617666841 0.0454217866 0.8662722111 0.191686511 0.4034173787 view top 100 |
| pov_ext | pov_ext | text | Poverty status at the national extreme poverty threshold of 217.45 2015 Kwacha. | not in poverty in poverty view top 100 |
| gap_ext | gap_ext | number | Poverty gap at the national extreme poverty threshold. Value is normalized to the poverty threshold, such that values are expressed as a proportion of the poverty line, and households with consumption at the threshold or higher are set to missing. | 0.0 0.0008000089 0.0060837925 0.0071501276 0.009008985 view top 100 |
| shortfall_ext | shortfall_ext | number | Consumption shortfall of the poor at the national extreme poverty threshold. Value is normalized to the poverty threshold and households, such that values are expressed as a proportion of the poverty line, with consumption at the threshold or higher are | 0.0008000089 0.0060837925 0.0071501276 0.009008985 0.0093276408 view top 100 |
| pov_190 | pov_190 | text | Poverty status at the poverty threshold of less than 1.90 per person per day in 2011 PPP | in poverty not in poverty view top 100 |
| gap_190 | gap_190 | number | Poverty gap at the poverty threshold of less than 1.90 per person per day in 2011 PPP. Value is normalized to the poverty threshold, such that values are expressed as a proportion of the poverty line, and households with consumption at the threshold or h | 0.0 0.5747036934 0.6258462071 0.8388326764 0.524248302 view top 100 |
| shortfall_190 | shortfall_190 | number | Consumption shortfall of the poor at the poverty threshold of less than 1.90 per person per day in 2011 PPP. Value is normalized to the poverty threshold and households, such that values are expressed as a proportion of the poverty line, with consumptio | 0.0 0.20202417670000003 0.2026679665 0.20327697690000002 0.20351234079999997 view top 100 |
| ppp | ppp | number | 2005 PPP | 56.9199981689 view top 100 |
| ppp2011 | ppp2011 | number | 2011 PPP | 78.0199966431 view top 100 |
| uscpi10 | uscpi10 | number | US 2010 CPI. 2005 100 | 111.6500015259 view top 100 |
| uscpi05 | uscpi05 | number | US 2005 CPI. 2005 100 | 100 view top 100 |
| mwicpi05 | mwicpi05 | number | Malawi 2005 CPI. 2005 100 | 100 view top 100 |
| mwicpi11 | mwicpi11 | number | Malawi 2011 CPI. 2005 100 | 167.6499938965 view top 100 |
| mwicpi13 | mwicpi13 | number | Malawi 2013 CPI. 2005 100 | 258.7699890137 view top 100 |
| mwicpi15 | mwicpi15 | number | Malawi 2015 CPI. Average monthly CPI for July to October, months of data collection. 2005 100 | 382.9299926758 view top 100 |