About this Dataset

COVID-19 Community Profile Report - County-Level

After over two years of public reporting, the Community Profile Report County-Level dataset will no longer be produced and distributed after the end of the public health emergency declaration. The final release will be on May 15, 2023. We want to thank everyone who contributed to the design, production, and review of this report and we hope that it provided insight into the data trends throughout the COVID-19 pandemic.

Effective June 22, 2021, the Community Profile Report will only be updated twice a week, on Tuesdays and Fridays. The Community Profile Report (CPR) – County-Level is generated by the Data Strategy and Execution Workgroup in the Joint Coordination Cell, under the White House COVID-19 Team. It is managed by an interagency team with representatives from multiple agencies and offices (including the United States Department of Health and Human Services, the Centers for Disease Control and Prevention, the Assistant Secretary for Preparedness and Response, and the Indian Health Service). This data table provides county-level information. It is a daily snapshot in time that focuses on recent COVID-19 outcomes in the last seven days and changes relative to the week prior. Data in this report may differ from data on state and local websites. This may be due to differences in how data were reported (e.g., date specimen obtained, or date reported for cases) or how the metrics are calculated. Historical data may be updated over time due to delayed reporting.
Organization: U.S. Department of Health & Human Services
Last updated: 2021-03-29T23:33:52.665771
Tags: covid-19

Tables

Table 1

@usgov.hhs_gov_covid_19_community_profile_report_county_level.table_1

292.12 kB
3,294 rows
39 columns

CREATE TABLE table_1 (
  "fips" BIGINT,
  "county" VARCHAR,
  "state" VARCHAR,
  "fema_region" DOUBLE,
  "date" VARCHAR,
  "cases_last_7_days" DOUBLE,
  "cases_per_100k_last_7_days" DOUBLE,
  "total_cases" DOUBLE,
  "cases_pct_change_from_prev_week" DOUBLE,
  "deaths_last_7_days" DOUBLE,
  "deaths_per_100k_last_7_days" DOUBLE,
  "total_deaths" DOUBLE,
  "deaths_pct_change_from_prev_week" DOUBLE,
  "test_positivity_rate_last_7_days" DOUBLE,
  "total_positive_tests_last_7_days" DOUBLE,
  "total_tests_last_7_days" DOUBLE,
  "total_tests_per_100k_last_7_days" DOUBLE,
  "test_positivity_rate_pct_change_from_prev_week" DOUBLE,
  "total_tests_pct_change_from_prev_week" DOUBLE,
  "confirmed_covid_hosp_last_7_days" DOUBLE,
  "confirmed_covid_hosp_per_100_beds_last_7_days" DOUBLE,
  "confirmed_covid_hosp_per_100_beds_pct_change_from_prev_week" DOUBLE,
  "suspected_covid_hosp_last_7_days" DOUBLE,
  "suspected_covid_hosp_per_100_beds_last_7_days" DOUBLE,
  "suspected_covid_hosp_per_100_beds_pct_change_from_prev_week" DOUBLE,
  "pct_inpatient_beds_used_avg_last_7_days" DOUBLE,
  "pct_inpatient_beds_used_abs_change_from_prev_week" DOUBLE,
  "pct_inpatient_beds_used_covid_avg_last_7_days" DOUBLE,
  "pct_inpatient_beds_used_covid_abs_change_from_prev_week" DOUBLE,
  "pct_icu_beds_used_avg_last_7_days" DOUBLE,
  "pct_icu_beds_used_abs_change_from_prev_week" DOUBLE,
  "pct_icu_beds_used_covid_avg_last_7_days" DOUBLE,
  "pct_icu_beds_used_covid_abs_change_from_prev_week" DOUBLE,
  "pct_vents_used_avg_last_7_days" VARCHAR,
  "pct_vents_used_abs_change_from_prev_week" VARCHAR,
  "pct_vents_used_covid_avg_last_7_days" VARCHAR,
  "pct_vents_used_covid_abs_change_from_prev_week" VARCHAR,
  "pct_fully_vacc_total_pop" DOUBLE,
  "pct_fully_vacc_65_and_older" DOUBLE
);