CorStat - Finance Budget to Actual
The City of Corona's 'Open Budget' is part of a citywide coordinated effort to provide greater transparency and foster an environment of openness in regards to the inner-workings of local government. The 'actuals' information is updated weekly on Saturday morning, after the accounts payable check run is complete.
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 \"corstat-coronaca-gov/corstat-finance-budget-to-actual-xrws-rgcj\".\"corstat_finance_budget_to_actual\"
LIMIT 100
"}
EOFSee the Splitgraph documentation
for more information.
