COVID-19 State-Level Metrics with Demographic and Vaccination Data

State-level COVID-19 metrics archived from data.ct.gov, last updated on August 7, 2023. The dataset includes cumulative cases and deaths, 7-day case counts, and vaccination metrics broken down by age, gender, and race/ethnicity. Daily reporting ceased on June 1, 2023, following the end of the federal public health emergency.

Use Cases

• Analyze weekly case trends by demographic group using case_rate_weekly, cases_hisp_race_Hispanic_7days, and cases_age_group_40-49_7days (from 35 available columns).
• Model demographic risk factors for mortality using cumulative_deaths_agegroup_60-69, cumulative_deaths_gender_Female, and cumulative_deaths_hisp_race_NH Asian or Pacific Islander (from 35 available columns).
• Track vaccination progress over time using adddose_today and census_today columns (from 35 available columns).
• Compare testing and positivity metrics for different test types using tests_naat_7days, positive_naat_7days, and positive_ag_7days (from 35 available columns).

Strengths

• Includes 35 columns providing detailed demographic breakdowns for cases and deaths.
• Data is sourced from a state public health department (DPH) via the Socrata platform.
• Documentation explains key metrics like cumulative_cases and cases_7days, including reporting caveats.

Limitations

• Data is archived and no longer updated as of June 1, 2023.
• Row count and total dataset size are unknown, limiting suitability assessment.
• The description notes potential data lags and corrections that can affect 7-day reporting windows.

Provenance

Source

data.ct.gov (Connecticut Open Data Portal via Socrata).

Collection Method

Daily state-level reports compiled from multiple sources, including external partners, by the Department of Public Health (DPH).

Time Range

Covers the pandemic period up to the archive date; specific start date is not provided.

Freshness

Last updated 2023-08-07 17:32:50; data collection is archived and static.

Geography

State-level data; the specific state is implied as Connecticut by the source domain (data.ct.gov).