COVID-19 Expenditures Report

This dataset is made up of expenditure transactions incurred by City agencies and recorded to a “CV” or “CR” expense budget code in the City's Financial Management System (FMS). The dataset includes accounting entries such as automated accruals and journals. Dollar amounts are in actual dollars. This dataset will be refreshed four times a year and is inclusive of older datasets. To access the most current information, please refer to the most recent “Publication Date.”

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 \"cityofnewyork-us/covid19-expenditures-report-thut-5mdg\".\"covid19_expenditures_report\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.