Iowa Board of Regents' Vendor Payments by Institution, Fiscal Year And Vendor

The dataset provides aggregate payments made Iowa Board of Regents to vendors by institution and fiscal year starting with FY 2012. Payments made by the Board of Regents are assigned to fiscal years that run from July 1 to the following June 30, and are numbered for the calendar year in which they end (e.g. FY 2014 is July 1, 2013 – June 30, 2014).

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 \"mydata-iowa-gov/iowa-board-of-regents-vendor-payments-by-y3id-d73d\".\"iowa_board_of_regents_vendor_payments_by\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.