About this Dataset

Open Checkbook BR

Dataset used to support the Open Checkbook BR web portal (http://checkbook.brla.gov). This data set contains department level City-Parish spending. Some expenditures are not included as they are not tied to a particular department.

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.

To see all expenditures please visit the City-Parish Expenditures data set (https://data.brla.gov/Government/City-Parish-Expenditures/vwa8-ps2a)
Organization: City of Baton Rouge
Last updated: 2020-11-12T14:59:54.396245
Tags: checkbook, expenditures, open-checkbook-br

Tables

Table 1

@usgov.city_of_baton_rouge_open_checkbook_br.table_1

38.62 MB
686504 rows
29 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,
  "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,
  "commodity_code" DOUBLE,
  "commodity_code_description" VARCHAR,
  "vendor_name" VARCHAR,
  "vendor_zip" VARCHAR,
  "payment_type" VARCHAR,
  "payment_status" VARCHAR
);