Payments to School Districts by State of Iowa

This dataset provides payment transactions to Iowa School Districts recorded in the State of Iowa’s central accounting system for the Executive Branch. Data has been enhanced by the Iowa Department of Management to only return records associated with school districts by joining the <a href="/d/cyqb-8ina">State of Iowa Checkbook data</a> to a <a href="/d/eckk-n7mf">crosswalk dataset</a> that relates vendor numbers to district numbers assigned by the Iowa Department of Education. It also highlights payments related to the Local Option Sales Tax that are corrected to be attributed to the prior fiscal year.

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/payments-to-school-districts-by-state-of-iowa-cv3q-vr69\".\"payments_to_school_districts_by_state_of_iowa\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.