City-Parish Expense Budget

The operating budget portion of Open Budget BR allows users to drill down into spending categories such as department-level and service-specific budgets. Browse the budget based on the fund or department and drill down to each spending category to better understand departmental expenses and revenue sources along with budgeted versus actual expenses incurred throughout the year, which can be viewed in greater detail at checkbook.brla.gov.

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-expense-budget-5emz-4788\".\"cityparish_expense_budget\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.