COVID-Like Illness (CLI) and COVID-19 Diagnosis Emergency Department Visits

NOTE, 6/23/2021: New columns have been added to this dataset and some existing columns will no longer be updated. The dataset has also been renamed. See the text below and http://dev.cityofchicago.org/open%20data/data%20portal/2021/06/23/covid-ed-visits-change.html for specifics. -- This is the place to look for important information about how to use this dataset, so please expand this box and read on!

This is the source data for some of the metrics available at https://www.chicago.gov/city/en/sites/covid-19/home/reopening-chicago.html#reopeningmetrics.

For all datasets related to COVID-19, see https://data.cityofchicago.org/browse?limitTo=datasets&sortBy=alpha&tags=covid-19.

The National Syndromic Surveillance Program (NSSP), a collaboration among CDC, federal partners, local and state health departments, and academic and private sector partners, is used to capture information during an Emergency Department (ED) visit. ED data can include information that are collected before cases are diagnosed or laboratory results are confirmed, providing an early warning system for infections, like COVID-19.

This dataset includes reports of COVID-19-Like illness (CLI) and COVID-19 diagnosed during an ED visit. CLI is defined as fever and cough or shortness of breath or difficulty breathing with or without the presence of a coronavirus diagnosis code. Visits meeting the CLI definition that also have mention of flu or influenza are excluded.

This dataset also includes ED visits among persons who have been diagnosed or laboratory confirmed to have COVID-19. During the initial months of the COVID-19 pandemic COVID-19 diagnoses counts are artificially low, due to varying eligibility requirements and availability of testing.

Over the course of the COVID-19 pandemic, public health best practices migrated from focusing on CLI to focusing on diagnosed cases. This dataset originally contained only CLI columns. In June 2021, the diagnosis columns were added, back filled to the start of the pandemic but with the caveat noted above. Roughly simultaneously, updating of the CLI columns was discontinued, although previously existing data were kept. Reflecting the new columns, the name of the dataset was changed from “COVID-Like Illness (CLI) Emergency Department Visits” to “COVID-Like Illness (CLI) and COVID-19 Diagnosis Emergency Department Visits” at the same time.

Data Source: Illinois Hospital Emergency Departments reporting to CDPH through the National Syndromic Surveillance Project (NSSP)

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 \"cityofchicago/covidlike-illness-cli-and-covid19-diagnosis-qwib-edaw\".\"covidlike_illness_cli_and_covid19_diagnosis\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.