NYC COVID 19 Spending by Agency by Expense Description

Aggregation of all city-funded encumbrances coded by agencies as being related to the COVID-19 pandemic, allocated to FMS defined expense types.

This data was collected from March 10, 2020 through June 29, 2021 and is no longer being updated.

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/nyc-covid-19-spending-by-agency-by-expense-duk5-k5fk\".\"nyc_covid_19_spending_by_agency_by_expense\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.