About this Dataset

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.
Organization: City of Baton Rouge
Last updated: 2020-11-12T15:00:12.811419
Tags: checkbook, expenditures, expenses, open-checkbook, open-checkbook-br, spending

Tables

Table 1

@usgov.city_of_baton_rouge_city_parish_expenditures.table_1

64.11 MB
1075222 rows
55 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "fund_id" BIGINT,
  "fund" VARCHAR,
  "department_id" BIGINT,
  "department" VARCHAR,
  "function_id" BIGINT,
  "function" VARCHAR,
  "division_id" BIGINT,
  "division" VARCHAR,
  "program_id" BIGINT,
  "program" VARCHAR,
  "subprogram_id" VARCHAR,
  "subprogram" VARCHAR,
  "journal_entry_period" BIGINT,
  "invoice_status" VARCHAR,
  "check_number" BIGINT,
  "check_date" TIMESTAMP,
  "invoice_number" VARCHAR,
  "line_number" BIGINT,
  "invoice_date" TIMESTAMP,
  "invoice_line_item_amount" DOUBLE,
  "invoice_line_item_description" VARCHAR,
  "source_document_number" DOUBLE,
  "source_document_type" VARCHAR,
  "source_document_description" VARCHAR,
  "expense_category_id" BIGINT,
  "expense_category" VARCHAR,
  "purchasing_department_id" DOUBLE,
  "purchasing_department" VARCHAR,
  "commodity_code" DOUBLE,
  "commodity_description" VARCHAR,
  "payment_type" VARCHAR,
  "payment_status" VARCHAR,
  "vendor_name_1" VARCHAR,
  "vendor_name_2" VARCHAR,
  "vendor_city" VARCHAR,
  "vendor_state" VARCHAR,
  "vendor_zip" VARCHAR,
  "vendor_type" VARCHAR,
  "gender" VARCHAR,
  "ethnicity" VARCHAR,
  "status" VARCHAR,
  "class" VARCHAR,
  "geographic_area" VARCHAR,
  "independent_contractor" VARCHAR,
  "minority" VARCHAR,
  "disadvantaged" VARCHAR,
  "disabled_veteran" VARCHAR,
  "sb_disabled_vet" VARCHAR,
  "sb_minority" VARCHAR,
  "sb_minority_woman" VARCHAR,
  "sb_non_minority" VARCHAR,
  "sb_disadvantaged" VARCHAR,
  "sb_veteran" VARCHAR,
  "sb_woman" VARCHAR
);