CorStat - Budget to Actual Capital Projects

Explore the City of Corona’s revenue sources which provide the funding for the operating activities and capital projects. Revenue can be viewed by fund type, fund name, or revenue categories (property taxes, sales tax, utility service charges, etc.).

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-budget-to-actual-capital-projects-k6jx-g3jt\".\"corstat_budget_to_actual_capital_projects\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.