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

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"mydata-iowa-gov/city-budget-and-actual-revenue-bzed-t5zc\".\"city_budget_and_actual_revenue\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • city_budget_and_actual_revenue
Upstream Metadata