COVID-19 Hospital Capacity Metrics - Historical

NOTE: This dataset is historical-only as of 5/10/2023. All data currently in the dataset will remain, but new data will not be added. The recommended alternative dataset for similar data beyond that date is  https://healthdata.gov/Hospital/COVID-19-Reported-Patient-Impact-and-Hospital-Capa/anag-cw7u. (This is not a City of Chicago site. Please direct any questions or comments through the contact information on the site.)

During the COVID-19 pandemic, the Chicago Department of Public Health (CDPH) required EMS Region XI (Chicago area) hospitals to report hospital capacity and patient impact metrics related to COVID-19 to CDPH through the statewide EMResource system. This requirement has been lifted as of May 9, 2023, in alignment with the expiration of the national and statewide COVID-19 public health emergency declarations on May 11, 2023. However, all hospitals will still be required by the U.S. Department of Health and Human Services (HHS) to report COVID-19 hospital capacity and utilization metrics into the HHS Protect system through the CDC’s National Healthcare Safety Network until April 30, 2024. Facility-level data from the HHS Protect system can be found at healthdata.gov.

Until May 9, 2023, all Chicago (EMS Region XI) hospitals (n=28) were required to report bed and ventilator capacity, availability, and occupancy to the Chicago Department of Public Health (CDPH) daily. A list of reporting hospitals is included below. All data represent hospital status as of 11:59 pm for that calendar day. Counts include Chicago residents and non-residents.

ICU bed counts include both adult and pediatric ICU beds. Neonatal ICU beds are not included. Capacity refers to all staffed adult and pediatric ICU beds. Availability refers to all available/vacant adult and pediatric ICU beds. Hospitals began reporting COVID-19 confirmed and suspected (PUI) cases in ICU on 03/19/2020. Hospitals began reporting ICU surge capacity as part of total capacity on 5/18/2020.

Acute non-ICU bed counts include burn unit, emergency department, medical/surgery (ward), other, pediatrics (pediatric ward) and psychiatry beds. Burn beds include those approved by the American Burn Association or self-designated. Capacity refers to all staffed acute non-ICU beds. An additional 500 acute/non-ICU beds were added at the McCormick Place Treatment Facility on 4/15/2020. These beds are not included in the total capacity count. The McCormick Place Treatment Facility closed on 05/08/2020. Availability refers to all available/vacant acute non-ICU beds. Hospitals began reporting COVID-19 confirmed and suspected (PUI) cases in acute non-ICU beds on 04/03/2020.

Ventilator counts prior to 04/24/2020 include all full-functioning mechanical ventilators, with ventilators with bilevel positive airway pressure (BiPAP), anesthesia machines, and portable/transport ventilators counted as surge. Beginning 04/24/2020, ventilator counts include all full-functioning mechanical ventilators, BiPAP, anesthesia machines and portable/transport ventilators. Ventilators are counted regardless of ability to staff. Hospitals began reporting COVID-19 confirmed and suspected (PUI) cases on ventilators on 03/19/2020. CDPH has access to additional ventilators from the EAMC (Emergency Asset Management Center) cache. These ventilators are included in the total capacity count.

Chicago (EMS Region 11) hospitals: Advocate Illinois Masonic Medical Center, Advocate Trinity Hospital, AMITA Resurrection Medical Center Chicago, AMITA Saint Joseph Hospital Chicago, AMITA Saints Mary & Elizabeth Medical Center, Ann & Robert H Lurie Children's Hospital, Comer Children's Hospital, Community First Medical Center, Holy Cross Hospital, Jackson Park Hospital & Medical Center, John H. Stroger Jr. Hospital of Cook County, Loretto Hospital, Mercy Hospital and Medical Center, , Mount Sinai Hospital, Northwestern Memorial Hospital, Norwegian American Hospital, Roseland Community Hospital, Rush University M

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/covid19-hospital-capacity-metrics-historical-f3he-c6sv\".\"covid19_hospital_capacity_metrics_historical\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.