Vendor Payments - New Arrivals

The expenditures reported here reflect payments that have been made for Migrant-related response costs as of the upload date. The City has implemented a coordinated response to track expenditures related to Migrants. Additional expenditures may have been incurred that are in the process of being paid and/or reconciled. These expenditures may be reported at a later date and will be captured in future iterations of this dataset.

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 \"cityofchicago/vendor-payments-new-arrivals-gxzc-43gg\".\"vendor_payments_new_arrivals\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.