Baseline Study of Food for Peace Title II Development Food Assistance Program in Karamoja, Uganda--Asset Value and Consumption: Section 1

This dataset contains the value of household assets and includes derived measures of daily per capita consumption. This file has 206 columns and 4,723 rows. It corresponds to Module H5 of the questionnaire. In fiscal year 2012, USAID's Office of Food for Peace (FFP) awarded funding to private voluntary organizations (PVOs) to design and implement a multi-year Title II development food assistance program in Uganda. The main purpose of the Title II program is to improve long-term food security of chronically food insecure population in the target regions. FFP contracted a firm, ICF International to conduct a baseline study in targeted areas of the country prior to the start of the new program. The purpose of the study was to assess the current status of key indicators, have a better understanding of prevailing conditions and perceptions of the population in the implementation areas, and serve as a point of comparison for future final evaluations. Results would also be used to further refine program targeting and, where possible, to understand the relationship between variables to inform program design. The study was conducted in 2013, while FFP expects to conduct final evaluations as close as possible to the end of the program five years later. The data asset is comprised of six datasets: 1) a description of all members of the households surveyed, 2) data on maternal health and sanitation practices, 3) data about the children in the household, 4) data describing the agricultural practices of the household, 5) data describing the food consumption of the household (broken into 4 smaller spreadsheets), and 6) and a description of the weights that should be applied during the analysis of the other datasets. In the process of migrating data to the current DDL platform, datasets with a large number of variables required splitting into multiple spreadsheets. They should be reassembled by the user to understand the data fully.

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/baseline-study-of-food-for-peace-title-ii-jn7r-kht7\".\"baseline_study_of_food_for_peace_title_ii\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.