Icon for Socrata external plugin
Open repository in Console
Updated 15 days ago
Indexed 5 hours ago

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 \
    -H "Content-Type: application/json" \
{"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 

See the Splitgraph documentation for more information.

  • payments_to_school_districts_by_state_of_iowa
Upstream Metadata