COVID-19 Daily Counts of Cases, Hospitalizations, and Deaths

Daily count of NYC residents who tested positive for SARS-CoV-2, who were hospitalized with COVID-19, and deaths among COVID-19 patients.

Note that this dataset currently pulls from https://raw.githubusercontent.com/nychealth/coronavirus-data/master/trends/data-by-day.csv on a daily basis.

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-daily-counts-of-cases-hospitalizations-and-rc75-m7u3\".\"covid19_daily_counts_of_cases_hospitalizations_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.