USAID Public-Private Partnerships Database - Data FY 2001 to FY 2014

This spreadhseet contains historical information regarding public-private partnerships from FY 2001 to FY 2014. It is part of the data asset that brings together information collected since 2001 on Public Private Partnerships (PPPs) that have been supported by USAID. For the purposes of this dataset a PPP is defined as a USAID-supported development project or initiative which engages the private sector (including corporations, foundations, and other non-governmental actors) as a core resource partner. Due to changes in Agency data collection systems, standards, and internal organization, the data has been collected according to different mechanisms, definitions, and timeframes from 2001-2016, and therefore cannot be considered to be comprehensive of all PPPs during this period.

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-publicprivate-partnerships-database-data-fy-w37i-bxwn\".\"usaid_publicprivate_partnerships_database_data_fy\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.