Dataset: Purchase Order Quantity Price Detail For Commodity/Goods Procurements

About this Dataset

Purchase Order Quantity Price Detail For Commodity/Goods Procurements

Purchase Order commodity line level detail for City of Austin Commodities/Goods purchases dating back to October 1st, 2009. Each line includes the NIGP Commodity Code/COA Inventory Code, commodity description, quantity, unit of measure, unit price, total amount, referenced Master Agreement if applicable, the contract name, purchase order, award date, and vendor information. The data contained in this data set is for informational purposes only. Certain Austin Energy transactions have been excluded as competitive matters under Texas Government Code Section 552.133 and City Council Resolution 20051201-002.
Organization: City of Austin
Last updated: 2020-11-12T13:21:07.151729
Tags: austin, austin-finance-online, buying, central-texas, city-of-austin, commodities, commodity, financial, financial-services, goods, open-data, price, procure, procurement, purchasing, texas, transparency

Tables

Table 1

@usgov.city_of_austin_purchase_order_quantity_price_detail_fo_ccc67425.table_1

29.62 MB
303315 rows
21 columns


CREATE TABLE table_1 (
  "commodity" VARCHAR,
  "commodity_description" VARCHAR,
  "extended_description" VARCHAR,
  "quantity" DOUBLE,
  "unit_of_measure" VARCHAR,
  "unit_of_meas_desc" VARCHAR,
  "unit_price" DOUBLE,
  "itm_tot_am" DOUBLE,
  "master_agreement" VARCHAR,
  "contract_name" VARCHAR,
  "purchase_order" VARCHAR,
  "award_date" TIMESTAMP,
  "vendor_code" VARCHAR,
  "lgl_nm" VARCHAR,
  "ad_ln_1" VARCHAR,
  "ad_ln_2" VARCHAR,
  "city" VARCHAR,
  "st" VARCHAR,
  "zip" VARCHAR,
  "ctry" VARCHAR,
  "data_build_date" TIMESTAMP
);