mydata-iowa-gov/city-budget-and-actual-expenditures-jy6h-2e5x
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 7 months ago
Indexed 1 month ago

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.

 
Preview
  • city_budget_and_actual_expenditures
     
     
     
     
     
Upstream Metadata