brla-gov/cityparish-expenditures-vwa8-ps2a
Icon for Socrata external plugin
Open repository in Console
 
Readme
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 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.

 
Preview
  • cityparish_expenditures
     
     
     
     
     
Upstream Metadata