About this Dataset

Contracts

Information about City's authorized spending limit, contract lifetime (called inception-to-date) ordering and spending. Contracts are visible only while active. For the purposes of this data set, a contract is a long-term (multi-year) contract for goods and services, and contracts for construction activity. Within the City, these are referred to as Master Agreements and Purchase Contracts.
Organization: City of Austin
Last updated: 2020-11-12T13:23:18.272299
Tags: austin, central-texas, city-of-austin, commodities-contracts, construction-contracts, contract, finance, financial, financial-services, master-agreement, procurement, professional-services-contracts, purchase, purchase-order, purchasing-office, rotational, service-agreement, sole-source-contracts, texas, transparency

Tables

Table 1

@usgov.city_of_austin_contracts_d35f9.table_1

76.14 kB
625 rows
28 columns

CREATE TABLE table_1 (
  "doc_cd" VARCHAR,
  "doc_dept_cd" BIGINT,
  "doc_id" VARCHAR,
  "doc_vers_no" BIGINT,
  "doc_dscr" VARCHAR,
  "contract_synopsis" VARCHAR,
  "contract_contact_nm" VARCHAR,
  "contract_contact_voice_ph_no" VARCHAR,
  "contract_contact_email_ad" VARCHAR,
  "ma_prch_lmt_am" DOUBLE,
  "ma_itd_ord_am" DOUBLE,
  "ma_do_rfed_am" DOUBLE,
  "efbgn_dt" TIMESTAMP,
  "efend_dt" TIMESTAMP,
  "gnrc_po_rpt_1" BIGINT,
  "rpt_dscr" VARCHAR,
  "brd_awd_dt" VARCHAR,
  "brd_awd_no" VARCHAR,
  "cat_dscr" VARCHAR,
  "doc_vend_ln_no" BIGINT,
  "vend_cust_cd" VARCHAR,
  "lgl_nm" VARCHAR,
  "alias_nm" VARCHAR,
  "so_doc_cd" VARCHAR,
  "so_doc_dept_cd" BIGINT,
  "so_doc_id" VARCHAR,
  "today" TIMESTAMP,
  "row_key" VARCHAR
);