State of Iowa Budget Appropriations

This dataset provides information on budget appropriations in State of Iowa for each fiscal year starting in FY 2010. The data provides granular detail down to the budget organizational unit and and object class for the department request, the Governor's recommendation, and the adopted budget.

The state fiscal year runs from July 1 to the following June 30 and is numbered for the calendar year in which it ends. The State of Iowa operates on a modified accrual basis which provides that encumbrances on June 30 must be paid within 60 days after year end. The Legislature may enact exceptions to this statute and usually do so for capital items which may run for several years.

Department names and budget units for FY 2010 - 2015 are based on names used in FY 2016.

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/state-of-iowa-budget-appropriations-ai8x-sahe\".\"state_of_iowa_budget_appropriations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.