PMI_DELIVER_dataset

The President’s Malaria Initiative (PMI) is a U.S. Government initiative designed to reduce malaria deaths and illnesses in target countries in sub-Saharan Africa with a long-term vision of a world without malaria.

This dataset contains information on commodity shipments from April 2012 to February 2017. These data include among other things the following important data elements: Order#, Country, Product name, Manufacturer, Mode of transport, delivery status and date, and quantity.

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/pmideliverdataset-k8ym-fihd\".\"pmideliverdataset\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.