City of Providence Operating Budget

This dataset contains annual operating budgets, per department, beginning in FY2012. The data includes Recommended Amounts from the Mayor's budget, as well as City Council Approved Amounts.

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 \"providenceri-gov/city-of-providence-operating-budget-su69-jatv\".\"city_of_providence_operating_budget\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.