cdc-gov/weekly-covid19-county-level-of-community-dt66-w6m6
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 2 months ago
Indexed 2 hours ago

Weekly COVID-19 County Level of Community Transmission as Originally Posted - ARCHIVED

Reporting of Aggregate Case and Death Count data was discontinued May 11, 2023, with the expiration of the COVID-19 public health emergency declaration. Although these data will continue to be publicly available, this dataset will no longer be updated.

Weekly COVID-19 Community Levels (CCLs) have been replaced with levels of COVID-19 hospital admission rates (low, medium, or high) which demonstrate <a href="https://www.cdc.gov/mmwr/volumes/72/wr/mm7219e1.htm">>99% concordance</a> by county during February 2022–March 2023. For more information on the latest COVID-19 status levels in your area and hospital admission rates, visit <a href="https://covid.cdc.gov/covid-data-tracker/#cases_new-admissions-rate-county">United States COVID-19 Hospitalizations, Deaths, and Emergency Visits by Geographic Area.</a>

This archived public use dataset contains historical case and percent positivity data updated weekly for all available counties and jurisdictions. Each week, the dataset was refreshed to capture any historical updates. Please note, percent positivity data may be incomplete for the most recent time period.

This archived public use dataset contains weekly community transmission levels data for all available counties and jurisdictions since October 20, 2022. The dataset was appended to contain the most recent week's data as originally posted on COVID Data Tracker. Historical corrections are not made to these data if new case or testing information become available. A separate archived file is made available here (<a href="https://data.cdc.gov/Public-Health-Surveillance/Weekly-COVID-19-County-Level-of-Community-Transmis/jgk8-6dpn">: Weekly COVID-19 County Level of Community Transmission Historical Changes</a>) if historically updated data are desired.

<b>Related data</b>

CDC provides the public with two active versions of COVID-19 county-level community transmission level data: this dataset with the levels as originally posted (<a href="https://data.cdc.gov/Public-Health-Surveillance/Weekly-COVID-19-County-Level-of-Community-Transmis/dt66-w6m6">Weekly Originally Posted dataset</a>), updated weekly with the most recent week’s data since October 20, 2022, and a historical dataset with the county-level transmission data from January 22, 2020 (<a href="https://data.cdc.gov/Public-Health-Surveillance/Weekly-COVID-19-County-Level-of-Community-Transmis/jgk8-6dpn">Weekly Historical Changes dataset</a>).

<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 a 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 conducted

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"cdc-gov/weekly-covid19-county-level-of-community-dt66-w6m6\".\"weekly_covid19_county_level_of_community\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • weekly_covid19_county_level_of_community
     
     
     
     
     
Upstream Metadata