About this Dataset

OFFICIAL DIR Cooperative Contract Sales Data Fiscal 2010 To Present

Optimized version of DIR Cooperative Contract Sales Data Fiscal 2010 To Present. This dataset was made active 09072018 and include data going back to 2010 within the dataset. For a complete dataset history of downloads, visits, rows and columns refer to ARCHIVE DIR Cooperative Contract Sales Data Fiscal 2010 for a complete history of statistics regarding the dataset (downloads, visits, rows, etc.)
Organization: City of Austin
Last updated: 2023-08-25T23:42:33.697424

Tables

Table 1

@usgov.city_of_austin_official_dir_cooperative_contract_sales_678f9912.table_1

324.2 MB
10,430,367 rows
49 columns

CREATE TABLE table_1 (
  "fiscal_year" BIGINT,
  "customer_name" VARCHAR,
  "vendor_name" VARCHAR,
  "purchase_amount" DOUBLE,
  "contract_number" VARCHAR,
  "rfo_description" VARCHAR,
  "rfo_number" VARCHAR,
  "customer_type" VARCHAR,
  "customer_contact" VARCHAR,
  "customer_address" VARCHAR,
  "customer_city" VARCHAR,
  "customer_state" VARCHAR,
  "customer_zip" VARCHAR,
  "vendor_contact" VARCHAR,
  "vendor_hub_type" VARCHAR,
  "vendor_address" VARCHAR,
  "vendor_city" VARCHAR,
  "vendor_state" VARCHAR,
  "vendor_zip" VARCHAR,
  "reseller_name" VARCHAR,
  "reseller_hub_type" VARCHAR,
  "reseller_address" VARCHAR,
  "reseller_city" VARCHAR,
  "reseller_state" VARCHAR,
  "reseller_zip" DOUBLE,
  "reseller_phone" VARCHAR,
  "report_received_month" BIGINT,
  "purchase_month" BIGINT,
  "brand_name" VARCHAR,
  "order_quantity" DOUBLE,
  "unit_price" DOUBLE,
  "invoice_number" VARCHAR,
  "po_number" VARCHAR,
  "order_date" TIMESTAMP,
  "shipped_date" TIMESTAMP,
  "dir_contract_mgr" VARCHAR,
  "contract_type" VARCHAR,
  "contract_subtype" VARCHAR,
  "contract_start_date" TIMESTAMP,
  "contract_end_date" TIMESTAMP,
  "contract_termination_date" TIMESTAMP,
  "staffing_contractor_name" VARCHAR,
  "staffing_technology" VARCHAR,
  "staffing_title" VARCHAR,
  "staffing_level" VARCHAR,
  "staffing_technology_type" VARCHAR,
  "staffing_start_date" TIMESTAMP,
  "staffing_acquistion_type" VARCHAR,
  "sales_fact_number" BIGINT
);