COVID-19 State Level Data - Archive by US Government | Healthcare

About this Dataset

COVID-19 State Level Data - Archive

State level COVID-19 metrics.

As of 6/1/2023 this data set is no longer being updated.

The COVID-19 Data Report is posted on the Open Data Portal every day at 3pm. The report uses data from multiple sources, including external partners; if data from external partners are not received by 3pm, they are not available for inclusion in the report and will not be displayed. Data that are received after 3pm will still be incorporated and published in the next report update.

The cumulative number of COVID-19 cases (cumulative_cases) includes all cases of COVID-19 that have ever been reported to DPH. The cumulative number of COVID_19 cases in the last 7 days (cases_7days) only includes cases where the specimen collection date is within the past 7 days. While most cases are reported to DPH within 48 hours of specimen collection, there are a small number of cases that routinely are delayed, and will have specimen collection dates that fall outside of the rolling 7 day reporting window. Additionally, reporting entities may submit correction files to contribute historic data during initial onboarding or to address data quality issues; while this is rare, these correction files may cause a large amount of data from outside of the current reporting window to be uploaded in a single day; this would result in the change in cumulative_cases being much larger than the value of cases_7days.

On June 4, 2020, the US Department of Health and Human Services issued guidance requiring the reporting of positive and negative test results for SARS-CoV-2; this guidance expired with the end of the federal PHE on 5/11/2023, and negative SARS-CoV-2 results were removed from the List of Reportable Laboratory Findings. DPH will no longer be reporting metrics that were dependent on the collection of negative test results, specifically total tests performed or percent positivity. Positive antigen and PCR/NAAT results will continue to be reportable.
Organization: State of Connecticut
Last updated: 2022-06-30T01:42:37.829541
Tags: covid-19, covid-archive, covid-epi-data

Tables

Table 1

@usgov.state_of_connecticut_covid_19_state_level_data.table_1

185.81 KB
343 rows
94 columns


CREATE TABLE table_1 (
  "report_date" TIMESTAMP,
  "cumulative_cases" BIGINT,
  "cumulative_cases_confirmed" BIGINT,
  "cumulative_cases_probable" BIGINT,
  "cumulative_tests_reportable" BIGINT,
  "cumulative_deaths" BIGINT,
  "cases_7days" BIGINT,
  "confirmed_cases_7days" BIGINT,
  "probable_cases_7days" BIGINT,
  "tests_reportable_7days" BIGINT,
  "newly_reported_deaths" BIGINT,
  "positive_naat_7days" BIGINT,
  "tests_naat_7days" BIGINT,
  "naat_positivity_7days" DOUBLE,
  "cumulative_positive_naat" BIGINT,
  "cumulative_tests_naat" BIGINT,
  "positive_ag_7days" BIGINT,
  "census_today" BIGINT,
  "fullyvax_today" BIGINT,
  "partialvax_today" BIGINT,
  "nonvax_today" BIGINT,
  "adddose_today" BIGINT,
  "census_7days_ago" BIGINT,
  "census_change" BIGINT,
  "census_not_fully_vax" BIGINT,
  "census_pct_not_fully_vax" DOUBLE,
  "cases_age_group_0_9_7days" BIGINT,
  "cases_age_group_10_19_7days" BIGINT,
  "cases_age_group_20_29_7days" BIGINT,
  "cases_age_group_30_39_7days" BIGINT,
  "cases_age_group_40_49_7days" BIGINT,
  "cases_age_group_50_59_7days" BIGINT,
  "cases_age_group_60_69_7days" BIGINT,
  "cases_age_group_70_79_7days" BIGINT,
  "cases_age_group_80_7days" BIGINT,
  "cases_age_group_unknown_7days" BIGINT,
  "cumulative_cases_agegroup_0_9" BIGINT,
  "cumulative_cases_agegroup_10_19" BIGINT,
  "cumulative_cases_agegroup_20_29" BIGINT,
  "cumulative_cases_agegroup_30_39" BIGINT,
  "cumulative_cases_agegroup_40_49" BIGINT,
  "cumulative_cases_agegroup_50_59" BIGINT,
  "cumulative_cases_agegroup_60_69" BIGINT,
  "cumulative_cases_agegroup_70_79" BIGINT,
  "cumulative_cases_agegroup_80" BIGINT,
  "cumulative_cases_agegroup_unknown" BIGINT,
  "cases_hisp_race_hispanic_7days" BIGINT,
  "cases_hisp_race_nh_american_indian_or_alaskan_native_7days" BIGINT,
  "cases_hisp_race_nh_asian_or_pacific_islander_7days" BIGINT,
  "cases_hisp_race_nh_black_7days" BIGINT,
  "cases_hisp_race_nh_multiracial_7days" BIGINT,
  "cases_hisp_race_nh_white_7days" BIGINT,
  "cases_hisp_race_unknown_7days" BIGINT,
  "cumulative_cases_hisp_race_hispanic" BIGINT,
  "cumulative_cases_hisp_race_nh_american_indian_or_alaskan_native" BIGINT,
  "cumulative_cases_hisp_race_nh_asian_or_pacific_islander" BIGINT,
  "cumulative_cases_hisp_race_nh_black" BIGINT,
  "cumulative_cases_hisp_race_nh_multiracial" BIGINT,
  "cumulative_cases_hisp_race_nh_white" BIGINT,
  "cumulative_cases_hisp_race_unknown" BIGINT,
  "cases_gender_female_7days" BIGINT,
  "cases_gender_male_7days" BIGINT,
  "cases_gender_other_7days" BIGINT,
  "cases_gender_unknown_7days" BIGINT,
  "cumulative_cases_gender_female" BIGINT,
  "cumulative_cases_gender_male" BIGINT,
  "cumulative_cases_gender_other" BIGINT,
  "cumulative_cases_gender_unknown" BIGINT,
  "cumulative_cases_gender_na" BIGINT,
  "case_rate_weekly" DOUBLE,
  "state_population" BIGINT,
  "cumulative_deaths_agegroup_0_9" BIGINT,
  "cumulative_deaths_agegroup_10_19" BIGINT,
  "cumulative_deaths_agegroup_20_29" BIGINT,
  "cumulative_deaths_agegroup_30_39" BIGINT,
  "cumulative_deaths_agegroup_40_49" BIGINT,
  "cumulative_deaths_agegroup_50_59" BIGINT,
  "cumulative_deaths_agegroup_60_69" BIGINT,
  "cumulative_deaths_agegroup_70_79" BIGINT,
  "cumulative_deaths_agegroup_80" BIGINT,
  "cumulative_deaths_agegroup_unknown" BIGINT,
  "cumulative_deaths_hisp_race_hispanic" BIGINT,
  "cumulative_deaths_hisp_race_nh_american_indian_or_alas_966f5d5f" BIGINT,
  "cumulative_deaths_hisp_race_nh_asian_or_pacific_islander" BIGINT,
  "cumulative_deaths_hisp_race_nh_black" BIGINT,
  "cumulative_deaths_hisp_race_nh_multiracial" BIGINT,
  "cumulative_deaths_hisp_race_nh_white" BIGINT,
  "cumulative_deaths_hisp_race_unknown" BIGINT,
  "cumulative_deaths_gender_female" BIGINT,
  "cumulative_deaths_gender_male" BIGINT,
  "cumulative_deaths_gender_other" BIGINT,
  "cumulative_deaths_gender_unknown" BIGINT,
  "fips" BIGINT,
  "data_updated" TIMESTAMP
);