About this Dataset

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.
Organization: City of Baton Rouge
Last updated: 2021-08-07T13:26:11.591289
Tags: budget, expenses-operating, open-budget, open-budget-br

Tables

Table 1

@usgov.city_of_baton_rouge_city_parish_expense_budget.table_1

6.72 MB
232,379 rows
28 columns

CREATE TABLE table_1 (
  "unique_id" VARCHAR,
  "account_id" BIGINT,
  "character_code" BIGINT,
  "character_code_description" VARCHAR,
  "object_code" BIGINT,
  "object_description" VARCHAR,
  "project_code" VARCHAR,
  "project_description" VARCHAR,
  "full_account_number" VARCHAR,
  "fund_id" VARCHAR,
  "fund" VARCHAR,
  "department_id" VARCHAR,
  "department" VARCHAR,
  "function_id" BIGINT,
  "function" VARCHAR,
  "division_id" VARCHAR,
  "division" VARCHAR,
  "program_id" BIGINT,
  "program" VARCHAR,
  "subprogram_id" BIGINT,
  "subprogram" VARCHAR,
  "account_description" VARCHAR,
  "account_status" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_month" VARCHAR,
  "original_budget" BIGINT,
  "revised_budget" DOUBLE,
  "ytd_actual" DOUBLE
);