Connecticut COVID-19 Cases Deaths and Tests by Day

Daily records from the beginning of the pandemic through at least June 2022 provide COVID-19 metrics for Connecticut. The dataset includes confirmed and probable cases and deaths, hospitalizations, and tests, broken down by age group and date. It is published by the Connecticut Department of Public Health on data.ct.gov.

Use Cases

• Model daily Total cases or Total deaths from age-stratified case counts (e.g., cases_age70_79) and COVID-19 tests reported using time-series forecasting.
• Analyze age-specific attack rates by calculating the proportion of Total cases represented by columns like cases_age0_9 or cases_age80_Older.
• Assess case fatality rates over time by joining Confirmed deaths and Confirmed cases on the Date column.
• Track hospitalization burden by analyzing the Hospitalized cases metric alongside case and death trends.
• Investigate reporting differences between Confirmed cases/Deaths and Probable cases/Deaths across the pandemic timeline.

Strengths

• Contains over 93 columns in the related State Metrics table.
• Includes age-stratified case data across 9 distinct age groups (e.g., cases_age0_9, cases_age80_Older).
• Provides multiple metrics: cases, deaths, tests, and hospitalizations for comprehensive analysis.

Limitations

• Town-level data suppresses records for towns with fewer than 5 cases or positive tests over 7 days, limiting granular analysis.
• Data is described as preliminary and subject to revision, introducing potential label noise for recent dates.
• Specific row counts and complete temporal coverage for the primary table are not provided.

Provenance

Source

Connecticut Department of Public Health and Connecticut Hospital Association.

Collection Method

Aggregated from state death registry, case reports, and hospital association data.

Time Range

From the beginning of the pandemic through at least June 2022, with some tables starting June 2022.

Freshness

Updated daily, with archive last updated August 2023.

Geography

State of Connecticut, with some data available at county and town levels.