Feed the Future Malawi Interim Survey in the Zone of Infuence, Construction Expenditures Over Past 12 Months

This dataset contains data from sub-Module E5 regarding non-food items that may or may not have been purchased (e.g., construction items such as wood/bamboo poles and thatching grass). 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 these 2-3 construction items over the past 12 months has multiple records. (Note that there is an “other” category of construction items for records from the harmonized FFP Baseline Survey data.) The unique identifiers in this long file are pbs_id + e504.

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-dwab-pz6j\".\"feed_the_future_malawi_interim_survey_in_the_zone\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.