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']))