Data.CDC.gov

Close
Author
Brian Lee
Description
This public use dataset has 7 data elements reflecting historical data for community transmission levels for all available counties. This dataset contains historical data for the county level of community transmission and includes updated data submitted by states and jurisdictions. Each day, the dataset is appended to contain the most recent day's data. This dataset includes data from January 1, 2021. Transmission level is set to low, moderate, substantial, or high using the calculation rules below. Currently, CDC provides the public with two versions of COVID-19 county-level community transmission level data: this dataset with the levels for each county from January 1, 2021 (<a href="https://data.cdc.gov/Public-Health-Surveillance/United-States-COVID-19-County-Level-of-Community-T/nra9-vzzn">Historical Changes dataset</a>) and a dataset with the levels as originally posted (<a href="https://data.cdc.gov/Public-Health-Surveillance/United-States-COVID-19-County-Level-of-Community-T/8396-v7yb">Originally Posted dataset</a>), updated daily with the most recent day’s data. <b>Methods for calculating county level of community transmission indicator</b> The County Level of Community Transmission indicator uses two metrics: (1) total new COVID-19 cases per 100,000 persons in the last 7 days and (2) percentage of positive SARS-CoV-2 diagnostic nucleic acid amplification tests (NAAT) in the last 7 days. For each of these metrics, CDC classifies transmission values as low, moderate, substantial, or high (below and <a href="https://www.cdc.gov/mmwr/volumes/70/wr/mm7030e2.htm?s_cid=mm7030e2_w#T1_down">here</a>). If the values for each of these two metrics differ (e.g., one indicates moderate and the other low), then the higher of the two should be used for decision-making. <b>CDC core metrics of and thresholds for community transmission levels of SARS-CoV-2</b> <b>Total New Case Rate Metric</b>: "New cases per 100,000 persons in the past 7 days" is calculated by adding the number of new cases in the county (or other administrative level) in the last 7 days divided by the population in the county (or other administrative level) and multiplying by 100,000. "New cases per 100,000 persons in the past 7 days" is considered to have transmission level of Low (0-9.99); Moderate (10.00-49.99); Substantial (50.00-99.99); and High (greater than or equal to 100.00). <b>Test Percent Positivity Metric</b>: "Percentage of positive NAAT in the past 7 days" is calculated by dividing the number of positive tests in the county (or other administrative level) during the last 7 days by the total number of tests resulted over the last 7 days. "Percentage of positive NAAT in the past 7 days" is considered to have transmission level of Low (less than 5.00); Moderate (5.00-7.99); Substantial (8.00-9.99); and High (greater than or equal to 10.00). If the two metrics suggest different transmission levels, the higher level is selected. If one metric is missing, the other metric is used for the indicator. Transmission categories include: Low Transmission Threshold: Counties with fewer than 10 total cases per 100,000 population in the past 7 days, and a NAAT percent test positivity in the past 7 days below 5%; Moderate Transmission Threshold: Counties with 10-49 total cases per 100,000 population in the past 7 days or a NAAT test percent positivity in the past 7 days of 5.0-7.99%; Substantial Transmission Threshold: Counties with 50-99 total cases per 100,000 population in the past 7 days or a NAAT test percent positivity in the past 7 days of 8.0-9.99%; High Transmission Threshold: Counties with 100 or more total cases per 100,000 population in the past 7 days or a NAAT test percent positivity in the past 7 days of 10.0% or greater. Blank : total new cases in the past 7 days are not reported (county data known to be unavailable) and the percentage of positive NAATs tests during the past 7 days (blank) are not reported. <b>Data Suppression</b> To prevent the release of data that could be used to identify people, data cells are suppressed for low frequency. When the <b>total new case rate metric</b> ("cases_per_100K_7_day_count_change") is greater than zero and less than 10, this metric is set to "suppressed" rather than including its value to protect individual privacy. 0 values are still displayed. <b>Related data</b> For originally posted levels of county community transmission, visit <a href="https://data.cdc.gov/Public-Health-Surveillance/United-States-COVID-19-County-Level-of-Community-T/8396-v7yb">United States COVID-19 County Level of Community Transmission as Originally Posted</a>, where each report date's original values are stored for each county. The following apply to these datasets: data are considered provisional by CDC and are subject to change until the data are reconciled and verified with the state and territorial data providers; some data are suppressed to protect individual privacy; datasets are updated daily; and datasets are created using CDC’s <a href="https://www.cdc.gov/maso/policy/policy385.pdf">Policy on Public Health Research and Nonresearch Data Management and Access</a>. <b>Duplicate Records Issue</b> A bug was found on 12/28/2021 that caused many records in the dataset to be duplicated. This issue was resolved on 01/06/2022.
Category
Public Health Surveillance
Tags
covid-19, coronavirus, laboratory, cases, county, community transmission
Rating
Current value: 0 out of 5
Data Provided By
CDC COVID-19 Response
Source Link
https://covid.cdc.gov/covid-data-tracker/#county-view
License
Public Domain U.S. Government
This view cannot be displayed
This view is currently private. You can preview it, but you will need to make it public before people will be able to see it.
Size
  • 500x425

  • 760x646

  • 950x808

Custom Size

425x425 is the minimum size

The Socrata Open Data API (SODA) provides programmatic access to this dataset including the ability to filter, query, and aggregate data. For more more information, view the API docs for this dataset or visit our developer portal

API Endpoint:

Field Names:

state_name
state_name
county_name
county_name
fips_code
fips_code
date
date
cases_per_100K_7_day_count_change
cases_per_100k_7_day_count
percent_test_results_reported_positive_last_7_days
percent_test_results_reported
community_transmission_level
community_transmission_level

Use OData to open the dataset in tools like Excel or Tableau. This provides a direct connection to the data that can be refreshed on-demand within the connected application.

Socrata OData documentation

Tableau users should select the OData v2 endpoint option.

OData V4 Endpoint:

OData V2 Endpoint:

You are viewing a mobile version of this dataset. To access the full dataset, tap here.