COVID-19 Cases, Hospitalizations, and Deaths by Connecticut County

25 columns of data track COVID-19 metrics at the county level in Connecticut, including Confirmed cases, Probable cases, Hospitalized cases, Total deaths, Confirmed deaths, and Probable deaths. The dataset is published by data.ct.gov and was last updated on August 2, 2023. It contains information starting from June 16, 2022, and is updated daily.

Use Cases

• Modeling the relationship between Confirmed cases and Hospitalized cases to forecast hospital bed demand.
• Analyzing temporal trends in Total deaths and Probable deaths by County to assess pandemic severity.
• Comparing Total case rates across different County codes to identify regional hotspots.

Strengths

• Daily update frequency provides near-real-time tracking.
• Contains 25 specific columns for detailed county-level analysis, including case, death, and hospitalization metrics.
• Data is sourced from official state health authorities and the Connecticut Hospital Association.

Limitations

• Row count is unknown, which may limit suitability assessment.
• Data for towns with fewer than 5 recent cases is suppressed to protect confidentiality, potentially creating gaps.
• Description metadata is limited; actual data quality requires manual inspection after download.

Provenance

Source

data.ct.gov, Connecticut Department of Public Health (DPH), Connecticut Hospital Association.

Collection Method

Case and test data by date of sample submission; death data by date of death; hospitalization data collected by Connecticut Hospital Association.

Time Range

From June 16, 2022, onward (daily updates).

Freshness

Updated daily; last updated 2023-08-02 15:01:42.

Geography

Connecticut, United States, at the county level.