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.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"datahub-austintexas-gov/purchase-order-quantity-price-detail-for-3ebq-e9iz\".\"purchase_order_quantity_price_detail_for\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.