COVID-19 Hospitalization by Facility

This data source is a mirror of the “COVID-19 Reported Patient Impact and Hospital Capacity by Facility” dataset provided by the US Department of Health & Human Services via healthdata.gov.

HHS performs up to four days of forward-fill for missing values.

Starting October 1, 2022, some facilities are only required to report annually.

See the official description and data dictionary at healthdata.gov for more information. The data elements, cadence, and how the data are being used in the federal response are documented in a FAQ published by Health & Human Services.

General topics not specific to any particular data source are discussed in the API overview. Such topics include: contributing and citing.

Metadata

This data source provides various measures of COVID-19 burden on patients and healthcare in the US.

  • Data source: US Department of Health & Human Services (HHS)
  • Geographic resolution: healthcare facility (address, city, zip, fips)
  • Temporal resolution: weekly (Friday – Thursday)
  • First week: 2020-07-31
  • Open Access: Public Domain US Government
  • Versioned by Delphi according to the date that the dataset was published by HHS. New versions are expected to be published roughly weekly.

The API

The base URL is: https://api.delphi.cmu.edu/epidata/covid_hosp_facility/

See this documentation for details on specifying locations and dates.

Parameters

Required

Parameter Description Type
hospital_pks facility unique identifiers list of identifiers
collection_weeks dates list of dates or date ranges

NOTE: The companion covid_hosp_facility_lookup endpoint can be used to lookup facility identifiers in a variety of ways.

NOTE: A collection week spans Friday – Thursday, and weeks are identified by the date corresponding to the Friday at the start of the week. Therefore, the collection_weeks parameter is formatted as a YYYYMMDD date (or list of dates) rather than an “epiweek” as in other endpoints.

Optional

Parameter Description Type
publication_dates date of publication list of “issue” dates or date ranges

If publication_dates is not specified, then the most recent issue is used by default.

NOTE: The publication_dates parameter is semantically equivalent to the issues parameter in the related covid_hosp endpoint. It has been renamed here for clarity.

Response

Field Description Type
result result code: 1 = success, 2 = too many results, -2 = no results integer
epidata list of results array of objects
epidata[].hospital_pk facility identified by this row string
epidata[].collection_week Friday’s date in the week pertaining to this row integer
epidata[].publication_date the date on which the dataset containing this row was published integer
epidata[].* see the data dictionary  
message success or error message string

Example URLs

Moses Taylor Hospital (Scranton, PA) on the first collection week of December 2020 (per most recent issue)

https://api.delphi.cmu.edu/epidata/covid_hosp_facility/?hospital_pks=390119&collection_weeks=20201201-20201207

{
    "result": 1,
    "epidata": [
        {
            "hospital_pk": "390119",
            "state": "PA",
            "ccn": "390119",
            "hospital_name": "MOSES TAYLOR HOSPITAL",
            "address": "700 QUINCY AVENUE",
            "city": "SCRANTON",
            "zip": "18510",
            "hospital_subtype": "Short Term",
            "fips_code": "42069",
            "publication_date": 20201221,
            "collection_week": 20201204,
            "is_metro_micro": 1,
            "total_beds_7_day_sum": 860,
            "all_adult_hospital_beds_7_day_sum": 734,
            "all_adult_hospital_inpatient_beds_7_day_sum": 734,
            "inpatient_beds_used_7_day_sum": 807,
            "all_adult_hospital_inpatient_bed_occupied_7_day_sum": 727,
            "total_adult_patients_hosp_confirmed_suspected_covid_7d_sum": -999999,
            "total_adult_patients_hospitalized_confirmed_covid_7_day_sum": 0,
            "total_pediatric_patients_hosp_confirmed_suspected_covid_7d_sum": -999999,
            "total_pediatric_patients_hospitalized_confirmed_covid_7_day_sum": 0,
            "inpatient_beds_7_day_sum": 860,
            "total_icu_beds_7_day_sum": 116,
            "total_staffed_adult_icu_beds_7_day_sum": 48,
            "icu_beds_used_7_day_sum": 94,
            "staffed_adult_icu_bed_occupancy_7_day_sum": 46,
            "staffed_icu_adult_patients_confirmed_suspected_covid_7d_sum": 0,
            "staffed_icu_adult_patients_confirmed_covid_7_day_sum": 0,
            "total_patients_hospitalized_confirmed_influenza_7_day_sum": 0,
            "icu_patients_confirmed_influenza_7_day_sum": 0,
            "total_patients_hosp_confirmed_influenza_and_covid_7d_sum": 0,
            "total_beds_7_day_coverage": 7,
            "all_adult_hospital_beds_7_day_coverage": 7,
            "all_adult_hospital_inpatient_beds_7_day_coverage": 7,
            "inpatient_beds_used_7_day_coverage": 7,
            "all_adult_hospital_inpatient_bed_occupied_7_day_coverage": 7,
            "total_adult_patients_hosp_confirmed_suspected_covid_7d_cov": 7,
            "total_adult_patients_hospitalized_confirmed_covid_7_day_coverage": 7,
            "total_pediatric_patients_hosp_confirmed_suspected_covid_7d_cov": 7,
            "total_pediatric_patients_hosp_confirmed_covid_7d_cov": 7,
            "inpatient_beds_7_day_coverage": 7,
            "total_icu_beds_7_day_coverage": 7,
            "total_staffed_adult_icu_beds_7_day_coverage": 7,
            "icu_beds_used_7_day_coverage": 7,
            "staffed_adult_icu_bed_occupancy_7_day_coverage": 7,
            "staffed_icu_adult_patients_confirmed_suspected_covid_7d_cov": 7,
            "staffed_icu_adult_patients_confirmed_covid_7_day_coverage": 7,
            "total_patients_hospitalized_confirmed_influenza_7_day_coverage": 7,
            "icu_patients_confirmed_influenza_7_day_coverage": 7,
            "total_patients_hosp_confirmed_influenza_and_covid_7d_cov": 7,
            "previous_day_admission_adult_covid_confirmed_7_day_sum": -999999,
            "previous_day_admission_adult_covid_confirmed_18_19_7_day_sum": 0,
            "previous_day_admission_adult_covid_confirmed_20_29_7_day_sum": -999999,
            "previous_day_admission_adult_covid_confirmed_30_39_7_day_sum": 0,
            "previous_day_admission_adult_covid_confirmed_40_49_7_day_sum": 0,
            "previous_day_admission_adult_covid_confirmed_50_59_7_day_sum": 0,
            "previous_day_admission_adult_covid_confirmed_60_69_7_day_sum": 0,
            "previous_day_admission_adult_covid_confirmed_70_79_7_day_sum": 0,
            "previous_day_admission_adult_covid_confirmed_80plus_7_day_sum": 0,
            "previous_day_admission_adult_covid_confirmed_unknown_7_day_sum": 0,
            "previous_day_admission_pediatric_covid_confirmed_7_day_sum": -999999,
            "previous_day_covid_ed_visits_7_day_sum": 62,
            "previous_day_admission_adult_covid_suspected_7_day_sum": 0,
            "previous_day_admission_adult_covid_suspected_18_19_7_day_sum": 0,
            "previous_day_admission_adult_covid_suspected_20_29_7_day_sum": 0,
            "previous_day_admission_adult_covid_suspected_30_39_7_day_sum": 0,
            "previous_day_admission_adult_covid_suspected_40_49_7_day_sum": 0,
            "previous_day_admission_adult_covid_suspected_50_59_7_day_sum": 0,
            "previous_day_admission_adult_covid_suspected_60_69_7_day_sum": 0,
            "previous_day_admission_adult_covid_suspected_70_79_7_day_sum": 0,
            "previous_day_admission_adult_covid_suspected_80plus_7_day_sum": 0,
            "previous_day_admission_adult_covid_suspected_unknown_7_day_sum": 0,
            "previous_day_admission_pediatric_covid_suspected_7_day_sum": 0,
            "previous_day_total_ed_visits_7_day_sum": 495,
            "previous_day_admission_influenza_confirmed_7_day_sum": 0,
            "total_beds_7_day_avg": 122.9,
            "all_adult_hospital_beds_7_day_avg": 104.9,
            "all_adult_hospital_inpatient_beds_7_day_avg": 104.9,
            "inpatient_beds_used_7_day_avg": 115.3,
            "all_adult_hospital_inpatient_bed_occupied_7_day_avg": 103.9,
            "total_adult_patients_hosp_confirmed_suspected_covid_7d_avg": -999999,
            "total_adult_patients_hospitalized_confirmed_covid_7_day_avg": 0,
            "total_pediatric_patients_hosp_confirmed_suspected_covid_7d_avg": -999999,
            "total_pediatric_patients_hospitalized_confirmed_covid_7_day_avg": 0,
            "inpatient_beds_7_day_avg": 122.9,
            "total_icu_beds_7_day_avg": 16.6,
            "total_staffed_adult_icu_beds_7_day_avg": 6.9,
            "icu_beds_used_7_day_avg": 13.4,
            "staffed_adult_icu_bed_occupancy_7_day_avg": 6.6,
            "staffed_icu_adult_patients_confirmed_suspected_covid_7d_avg": 0,
            "staffed_icu_adult_patients_confirmed_covid_7_day_avg": 0,
            "total_patients_hospitalized_confirmed_influenza_7_day_avg": 0,
            "icu_patients_confirmed_influenza_7_day_avg": 0,
            "total_patients_hosp_confirmed_influenza_and_covid_7d_avg": 0
        }
    ],
    "message": "success"
}

Code Samples

Libraries are available for JavaScript, Python, and R. The following sample shows how to import the library and fetch Moses Taylor Hospital (Scranton, PA) on the first collection week of December 2020 (per most recent issue).

Python

Optionally install the package using pip(env):

pip install delphi-epidata

Otherwise, place delphi_epidata.py from this repo next to your python script.

# Import
from delphi_epidata import Epidata
# Fetch data
res = Epidata.covid_hosp_facility('390119', Epidata.range(20201201, 20201207))
print(res['result'], res['message'], len(res['epidata']))