FTF "Don't Lose the Plot" Impact Assessment: Kenya Dataset

Dataset file can be found in the metadata below under "Attachments".

Feed the Future’s Africa Lead II project partnered with The Mediae Company, a Kenya-based media education company, to develop a pilot season of Africa’s first agriculture-focused reality TV program: Don’t Lose the Plot (DLTP). Targeting youth in Kenya and Tanzania, the show aired in Kenya and Tanzania between May and July 2017. The program’s objectives were to encourage youth to consider farming as a lucrative career choice, provide information on how to start agribusinesses, and share useful agronomic information. Africa Lead commissioned Kantar Public East Africa to evaluate the impact of DLTP on knowledge, attitudes, and behavior, or intention to change behavior, related to farming and agribusiness practices.

This data asset includes quantitative data collected through a cross-sectional household survey in Kenya and Tanzania. Data collection took place between August and December 2017 and targeted both viewers and non-viewers of DLTP aged 18 to 35 years. A total sample of 3,737 target individuals were interviewed in Kenya, including 406 verified viewers. In Tanzania, 3,383 target individuals were interviewed, including 527 verified viewers.

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/ftf-dont-lose-the-plot-impact-assessment-kenya-jh27-jpa9\".\"ftf_dont_lose_the_plot_impact_assessment_kenya\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.