City Budget and Actual Revenue

This dataset contains the budget and actual revenue self-reported by each city via their yearly budget forms filed with the Department of Management. Actual revenue 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-revenue-bzed-t5zc\".\"city_budget_and_actual_revenue\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.