City Budget and Actual Expenditures
The budget and actual expenditures self-reported by each city via their yearly budget forms filed with the Department of Management. Actual expenditure data lags budget expenditures by a couple of fiscal years.
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/city-budget-and-actual-expenditures-jy6h-2e5x\".\"city_budget_and_actual_expenditures\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.