State Agency Amazon Spend Fiscal Year 19

DES is publishing the Amazon spend for state agencies collected through the Washington State Amazon Business account. The data set only includes closed orders. Any orders that are still in process or have been cancelled are not included. This data is for Fiscal Year 19 (July 1, 2018 to June 30, 2019).

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 \"wa-gov/state-agency-amazon-spend-fiscal-year-19-msv2-8gcv\".\"state_agency_amazon_spend_fiscal_year_19\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.