USAID Public-Private Partnerships Database - Partnerships Active in 2015

This spreadsheet contains detailed information regarding active public-private partnerships in FY 2015. This dataset 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-274m-paee\".\"usaid_publicprivate_partnerships_database\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.