Feed the Future Malawi Interim Survey in the Zone of Infuence, Non-Food Expenditures Over the Past 7 Days

This dataset contains data from sub-Module E2: Non-Food Expenditures over Past 7 Days. 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. Each household with data for non-food expenditures over the past week has multiple records (for the 10 non-food items in sub-Module E2). (10,210 records ÷ 10 non-food items = 1,021 Module E households with sub-Module E2 data.) The unique identifiers in this long file are pbs_id + e201.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"usaid-gov/feed-the-future-malawi-interim-survey-in-the-zone-cy6p-mumr\".\"feed_the_future_malawi_interim_survey_in_the_zone\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.