USAID Activity Locations - Activity Descriptions

The USAID Activities dataset is a snapshot of activities supported by USAID including their geographical locations within countries at the time of the snapshot. The data were used to create the map.usaid.gov web site on the Where We Work page. Only a subset of USAID's field offices provided data and many provided data on only a part of their portfolios. Efforts are underway to harmonize the way data are collected by USAID missions which, when completed, will facilitate the display of a comprehensive portfolio of USAID activities. The geographic names and boundaries in this dataset may not reflect the views of the United States Government on the sovereignty over geographic features. This spreadsheet contains descriptions of activities.

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/usaid-activity-locations-activity-descriptions-jusn-k97d\".\"usaid_activity_locations_activity_descriptions\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.