City-Parish Expenditures
This expenditures dataset includes a listing and description of City-Parish department-level spending. Data is captured from January 1, 2018 to present as any data prior to this date resides in multiple disparate systems in various formats, which were subsequently streamlined through the implementation of the City-Parish's enterprise resource planning system financial module in late 2017.
In an effort to protect certain information telephone numbers and account numbers are masked with X's. Also, the Check Number field only includes the last 4 digits of the check number.
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 \"brla-gov/cityparish-expenditures-vwa8-ps2a\".\"cityparish_expenditures\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.