Name: Annual Contracts
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Annual Contracts

Listing of all annual contracts issued to procure goods and/or services within City-Parish.
Organization: City of Baton Rouge
Last updated: 2020-11-12T15:00:09.736784
Tags: annual-contracts, contracts, procurement

Tables

Table 1

@usgov.city_of_baton_rouge_annual_contracts.table_1

34.15 KB
48 rows
46 columns


CREATE TABLE table_1 (
  "record_type" VARCHAR,
  "document_number" BIGINT,
  "document_description" VARCHAR,
  "requisition_number" BIGINT,
  "purchase_orders" VARCHAR,
  "input_date" TIMESTAMP,
  "department_number" BIGINT,
  "department_name" VARCHAR,
  "cost_center" BIGINT,
  "cost_center_name" VARCHAR,
  "document_status_code" BIGINT,
  "document_status_description" VARCHAR,
  "vouched_amount" DOUBLE,
  "start_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "extension_date" TIMESTAMP,
  "total_items" BIGINT,
  "item_number" BIGINT,
  "item_description" VARCHAR,
  "item_quantity" DOUBLE,
  "item_unit_cost" DOUBLE,
  "item_unit_of_measure" VARCHAR,
  "commodity_code" DOUBLE,
  "commodity_description" VARCHAR,
  "vendor_name_1" VARCHAR,
  "vendor_name_2" VARCHAR,
  "vendor_city" VARCHAR,
  "vendor_state" VARCHAR,
  "vendor_zip" BIGINT,
  "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
);