COVID-19 Case Surveillance Public Use Data with Geography

<b>Note:</b>

Authorizations to collect certain public health data expired at the end of the U.S. public health emergency declaration on May 11, 2023. The following jurisdictions discontinued COVID-19 case notifications to the CDC: Iowa (4/28/22), Kansas (5/12/23), New Hampshire (5/23/23), and Oklahoma (5/2/23). Please note that these jurisdictions will not routinely send new case data after the dates indicated. As of 7/13/23, case notifications from Oregon will only include cases resulting in death.

This case surveillance public use dataset has 19 elements for all COVID-19 cases shared with CDC and includes demographics, geography (county and state of residence), any exposure history, disease severity indicators and outcomes, and presence of any underlying medical conditions and risk behaviors.

Currently, CDC provides the public with three versions of COVID-19 case surveillance line-listed data: this <a href="https://data.cdc.gov/Case-Surveillance/COVID-19-Case-Surveillance-Public-Use-Data-with-Ge/n8mc-b4w4">19 data element dataset with geography</a>, a <a href="https://data.cdc.gov/Case-Surveillance/COVID-19-Case-Surveillance-Public-Use-Data/vbim-akqf">12 data element public use dataset</a>, and a <a href="https://data.cdc.gov/Case-Surveillance/COVID-19-Case-Surveillance-Restricted-Access-Detai/mbd7-r32t">33 data element restricted access dataset</a>.

The following apply to the public use datasets and the restricted access dataset:

• Data elements can be found on the COVID-19 case report form located at <a href="https://www.cdc.gov/coronavirus/2019-ncov/downloads/pui-form.pdf">www.cdc.gov/coronavirus/2019-ncov/downloads/pui-form.pdf</a>.

• 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 will include all cases with the earliest date available in each record (date received by CDC or date related to illness/specimen collection) at least 14 days prior to the creation of the current datasets. This 14-day lag allows case reporting to be stabilized and ensure that time-dependent outcome data are accurately captured.

• Datasets are updated monthly. <br>

• 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> and include protections designed to protect individual privacy.

• For more information about data collection and reporting, please see <a href="https://www.cdc.gov/coronavirus/2019-ncov/covid-data/about-us-cases-deaths.html">https://www.cdc.gov/coronavirus/2019-ncov/covid-data/about-us-cases-deaths.html.</a><br>

• For more information about the COVID-19 case surveillance data, please see <a href="https://www.cdc.gov/coronavirus/2019-ncov/covid-data/faq-surveillance.html"> https://www.cdc.gov/coronavirus/2019-ncov/covid-data/faq-surveillance.html</a><br>

<b>Overview</b>

The COVID-19 case surveillance database includes patient-level data reported by U.S. states and autonomous reporting entities, including New York City and the District of Columbia (D.C.), as well as U.S. territories and affiliates. On April 5, 2020, COVID-19 was added to the <a href="https://ndc.services.cdc.gov/search-results-year/"> Nationally Notifiable Condition List </a> and classified as "immediately notifiable, urgent (within 24 hours)" by a Council of State and Territorial Epidemiologists (CSTE) Interim Position Statement (<a href="https://www.cste.org/resource/resmgr/ps/positionstatement2020/Interim-20-ID-01_COVID-19_NO.pdf">Interim-20-ID-01</a>). CSTE updated the position statement on August 5, 2020 to clarify the interpretation of antigen detection tests and serologic test results within the case classification (<a href="https://www.cste.org/resource/resmgr/ps/positionstatement2020/Interim-20-ID-02_COVID-19.pdf">Interim-20-ID-02</a>). The statement also re

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/covid19-case-surveillance-public-use-data-with-n8mc-b4w4\".\"covid19_case_surveillance_public_use_data_with\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.