Legacy Purchase Orders

***On September 15, 2017, the City-Parish switched to a new system to track all purchase order processing. This dataset contains data through 9/14/2017. For data from 9/15/2017 onward visit: https://data.brla.gov/Government/Purchase-Orders-and-Contracts/2ung-w7t4

Listing of all purchase orders issued to procure goods and/or services within City-Parish.

In the City-Parish Purchasing system, a purchase order (PO) is made up of two components: a header and one or many detail items that comprise the overarching PO. The header contains information that pertains to the entire PO. This includes, but is not limited to, the total amount of the PO, the department requesting the purchase and the vendor providing the goods or services. The detail item(s) contain information that is specific to the individual item ordered or service procured through the Purchase Order. The item/service description, item/service quantity and the cost of the item is located within the Purchase Order details. There may be one or many detail items on an individual Purchase Order. For example, a Purchase Order for a computer equipment may include three items: the computer, the monitor and the base software package.

Both header information and detail item information are included in this dataset in order to provide a comprehensive view of the purchase order data. The Record Type field indicates whether the record is a header record (H) or detail item record (D). In the computer purchase example from above, the system would display 4 records – one header record and 3 detail item records.

It should be noted header information will be duplicated on all detail items. No detail item information will be displayed on the header record.

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 \"brla-gov/legacy-purchase-orders-54bn-2sqf\".\"legacy_purchase_orders\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.