Archived: ORPIN - Expired Contracts - Multi-Year Report

This dataset contains a list of "archived" ORPIN contracts that expired between July 1, 2014 to June 30, 2021 (sort by agency number). Starting July 1st, 2021 Oregon transitioned into the new statewide procurement system called OregonBuys. For this dataset, the contract start date may be different than the contract issued date, or date the data entry was completed, and the contract was entered into ORPIN system. For more information visit the ORPIN website https://orpin.oregon.gov/open.dll/welcome or, Oregon Transparency https://www.oregon.gov/transparency/Pages/index.aspx.

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 \"oregon-gov/archived-orpin-expired-contracts-multiyear-report-8izy-bwhd\".\"archived_orpin_expired_contracts_multiyear_report\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.