COVID-19 Town-Level Case and Test Positivity Rates for Connecticut

Connecticut town-level data on COVID-19 cases and test positivity, archived after October 15, 2020. The dataset includes weekly counts and rates per 100,000 population, focusing on community settings and excluding congregate care facilities. It was published by the Connecticut Department of Public Health via data.ct.gov and uses a 7-day MMWR week reporting period.

Use Cases

• Modeling the relationship between New COVID-19 Cases per 100k Population per Day and Percent Test Positivity across different towns.
• Analyzing temporal trends in New COVID-19 Cases Over 7-Day Period and New Tests Over 7-Day Period using the Reporting Period column.
• Comparing COVID-19 burden between towns (City column) based on case rates and test positivity metrics.
• Assessing data completeness and reporting delays, as noted for specific towns like Mansfield and Middletown.

Strengths

• Provides granular data at the town level (City column), allowing for intra-county analysis.
• Explicitly documents data exclusions, such as cases from congregate settings, clarifying the population scope.
• Includes multiple key public health metrics: case counts, case rates, test counts, and percent positivity.

Limitations

• Dataset is archived and no longer updated after October 15, 2020, limiting analysis to the early pandemic period.
• Row count and total data size are unknown, which may complicate suitability assessment for large-scale analysis.
• Contains noted data gaps, such as missing records for Mansfield and Middletown for the week of September 13-19, 2020.

Provenance

Source

Connecticut Department of Public Health, published via data.ct.gov.

Collection Method

Weekly aggregation of COVID-19 PCR diagnostic test results and case counts based on specimen collection date, following MMWR week definitions.

Time Range

Covers the period up to October 15, 2020, using 7-day reporting periods.

Freshness

Last updated 2023-08-02 16:11:04; data collection ended on 2020-10-15.

Geography

Towns within the state of Connecticut, USA.