COVID-19 DPH Reports Library - Archive

A library of reports produced by the Department of Public Health on COVID-19 data in Connecticut, starting on March 21, 2020. Reports are published to https://portal.ct.gov/Coronavirus/COVID-19-Data-Tracker and to https://portal.ct.gov/Coronavirus/Nursing-Homes-and-Assisted-Living-Facilities

Note: As of June 1, 2023 regular reporting on COVID-19 ended and will transition to align with the seasonal respiratory surveillance reporting program in October 2023. More details on the changes in reporting and end of the public health emergency can be found <a href'"https://portal.ct.gov/Office-of-the-Governor/News/Press-Releases/2023/05-2023/Governor-Lamont-Coronavirus-Update-May-11">here</a>. National data on COVID-19, including state and county-level data for Connecticut can also be found directly via the <a href="https://covid.cdc.gov/covid-data-tracker/#datatracker-home"> CDC COVID Data Tracker</a>.

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-dph-reports-library-archive-bqve-e8um\".\"covid19_dph_reports_library_archive\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.