COVID-19 Cases, Deaths, and Tests by Day - Archived

COVID-19 Cases, Deaths, and Tests by Day

As of 6/1/2023 this data set is no longer being updated.

The COVID-19 Data Report is posted on the Open Data Portal every day at 3pm. The report uses data from multiple sources, including external partners; if data from external partners are not received by 3pm, they are not available for inclusion in the report and will not be displayed. Data that are received after 3pm will still be incorporated and published in the next report update.

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 \"ct-gov/covid19-cases-deaths-and-tests-by-day-archived-g9vi-2ahj\".\"covid19_cases_deaths_and_tests_by_day_archived\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.