Procurement Report for Local Authorities

Public authorities are required by Section 2800 of Public Authorities Law to submit annual reports to the Authorities Budget Office that includes procurement contracts data. The dataset consists of procurement contracts data reported by Local Authorities that covers 8 fiscal years, which includes fiscal years ending in the most recently completed calendar year. Authorities are required to report procurement transactions that have an actual, estimated, or cumulative value of $5,000 or more, annually.

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 \"ny-gov/procurement-report-for-local-authorities-8w5p-k45m\".\"procurement_report_for_local_authorities\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.