Icon for Socrata external plugin
Open repository in Console
Updated 1 day ago
Indexed 1 hour ago

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"brla-gov/cityparish-expenditures-vwa8-ps2a\".\"cityparish_expenditures\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • cityparish_expenditures
Upstream Metadata