DHHS - COVID 19 Reported Patient Impact and Hospital Capacity by Facility

fusioncenter.nhit.org | Last Updated 1 Aug 2021

The following dataset provides facility-level data for hospital utilization aggregated on a weekly basis (Friday to Thursday). These are derived from reports with facility-level granularity across two main sources: (1) HHS TeleTracking, and (2) reporting provided directly to HHS Protect by state/territorial health departments on behalf of their healthcare facilities. The hospital population includes all hospitals registered with Centers for Medicare & Medicaid Services (CMS) as of June 1, 2020. It includes non-CMS hospitals that have reported since July 15, 2020. It does not include psychiatric, rehabilitation, Indian Health Service (IHS) facilities, U.S. Department of Veterans Affairs (VA) facilities, Defense Health Agency (DHA) facilities, and religious non-medical facilities. For a given entry, the term “collection_week” signifies the start of the period that is aggregated. For example, a “collection_week” of 2020-11-20 means the average/sum/coverage of the elements captured from that given facility starting and including Friday, November 20, 2020, and ending and including reports for Thursday, November 26, 2020. Reported elements include an append of either “_coverage”, “_sum”, or “_avg”. A “_coverage” append denotes how many times the facility reported that element during that collection week. A “_sum” append denotes the sum of the reports provided for that facility for that element during that collection week. A “_avg” append is the average of the reports provided for that facility for that element during that collection week. The file will be updated weekly. No statistical analysis is applied to impute non-response. For averages, calculations are based on the number of values collected for a given hospital in that collection week. Suppression is applied to the file for sums and averages less than four (4). In these cases, the field will be replaced with “-999,999”. This data is preliminary and subject to change as more data become available. Data is available starting on July 31, 2020. Sometimes, reports for a given facility will be provided to both HHS TeleTracking and HHS Protect. When this occurs, to ensure that there are not duplicate reports, deduplication is applied according to prioritization rules within HHS Protect. For influenza fields listed in the file, the current HHS guidance marks these fields as optional. As a result, coverage of these elements are varied.

This dataset has the following 94 columns:

Column NameAPI Column NameData TypeSample Values
hospital_pkhospital_pktext
collection_weekcollection_weekcalendar_date
statestatetext
ccnccntext
hospital_namehospital_nametext
addressaddresstext
citycitytext
zipzipnumber
hospital_subtypehospital_subtypetext
fips_codefips_codenumber
is_metro_microis_metro_microcheckbox
total_beds_7_day_avgtotal_beds_7_day_avgnumber
all_adult_hospital_beds_7_day_avgall_adult_hospital_beds_7number
all_adult_hospital_inpatient_beds_7_day_avgall_adult_hospital_inpatientnumber
inpatient_beds_used_7_day_avginpatient_beds_used_7_daynumber
all_adult_hospital_inpatient_bed_occupied_7_day_avgall_adult_hospital_inpatient_1number
total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_avgtotal_adult_patientsnumber
total_adult_patients_hospitalized_confirmed_covid_7_day_avgtotal_adult_patients_1number
total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_avgtotal_pediatric_patientsnumber
total_pediatric_patients_hospitalized_confirmed_covid_7_day_avgtotal_pediatric_patients_1number
inpatient_beds_7_day_avginpatient_beds_7_day_avgnumber
total_icu_beds_7_day_avgtotal_icu_beds_7_day_avgnumber
total_staffed_adult_icu_beds_7_day_avgtotal_staffed_adult_icu_bedsnumber
icu_beds_used_7_day_avgicu_beds_used_7_day_avgnumber
staffed_adult_icu_bed_occupancy_7_day_avgstaffed_adult_icu_bednumber
staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_avgstaffed_icu_adult_patientsnumber
staffed_icu_adult_patients_confirmed_covid_7_day_avgstaffed_icu_adult_patients_1number
total_patients_hospitalized_confirmed_influenza_7_day_avgtotal_patients_hospitalizednumber
icu_patients_confirmed_influenza_7_day_avgicu_patients_confirmednumber
total_patients_hospitalized_confirmed_influenza_and_covid_7_day_avgtotal_patients_hospitalized_1number
total_beds_7_day_sumtotal_beds_7_day_sumnumber
all_adult_hospital_beds_7_day_sumall_adult_hospital_beds_7_1number
all_adult_hospital_inpatient_beds_7_day_sumall_adult_hospital_inpatient_2number
inpatient_beds_used_7_day_suminpatient_beds_used_7_day_1number
all_adult_hospital_inpatient_bed_occupied_7_day_sumall_adult_hospital_inpatient_3number
total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_sumtotal_adult_patients_2number
total_adult_patients_hospitalized_confirmed_covid_7_day_sumtotal_adult_patients_3number
total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_sumtotal_pediatric_patients_2number
total_pediatric_patients_hospitalized_confirmed_covid_7_day_sumtotal_pediatric_patients_3number
inpatient_beds_7_day_suminpatient_beds_7_day_sumnumber
total_icu_beds_7_day_sumtotal_icu_beds_7_day_sumnumber
total_staffed_adult_icu_beds_7_day_sumtotal_staffed_adult_icu_beds_1number
icu_beds_used_7_day_sumicu_beds_used_7_day_sumnumber
staffed_adult_icu_bed_occupancy_7_day_sumstaffed_adult_icu_bed_1number
staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_sumstaffed_icu_adult_patients_2number
staffed_icu_adult_patients_confirmed_covid_7_day_sumstaffed_icu_adult_patients_3number
total_patients_hospitalized_confirmed_influenza_7_day_sumtotal_patients_hospitalized_2number
icu_patients_confirmed_influenza_7_day_sumicu_patients_confirmed_1number
total_patients_hospitalized_confirmed_influenza_and_covid_7_day_sumtotal_patients_hospitalized_3number
total_beds_7_day_coveragetotal_beds_7_day_coveragenumber
all_adult_hospital_beds_7_day_coverageall_adult_hospital_beds_7_2number
all_adult_hospital_inpatient_beds_7_day_coverageall_adult_hospital_inpatient_4number
inpatient_beds_used_7_day_coverageinpatient_beds_used_7_day_2number
all_adult_hospital_inpatient_bed_occupied_7_day_coverageall_adult_hospital_inpatient_5number
total_adult_patients_hospitalized_confirmed_and_suspected_covid_7_day_coveragetotal_adult_patients_4number
total_adult_patients_hospitalized_confirmed_covid_7_day_coveragetotal_adult_patients_5number
total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_7_day_coveragetotal_pediatric_patients_4number
total_pediatric_patients_hospitalized_confirmed_covid_7_day_coveragetotal_pediatric_patients_5number
inpatient_beds_7_day_coverageinpatient_beds_7_day_coveragenumber
total_icu_beds_7_day_coveragetotal_icu_beds_7_day_coveragenumber
total_staffed_adult_icu_beds_7_day_coveragetotal_staffed_adult_icu_beds_2number
icu_beds_used_7_day_coverageicu_beds_used_7_day_coveragenumber
staffed_adult_icu_bed_occupancy_7_day_coveragestaffed_adult_icu_bed_2number
staffed_icu_adult_patients_confirmed_and_suspected_covid_7_day_coveragestaffed_icu_adult_patients_4number
staffed_icu_adult_patients_confirmed_covid_7_day_coveragestaffed_icu_adult_patients_5number
total_patients_hospitalized_confirmed_influenza_7_day_coveragetotal_patients_hospitalized_4number
icu_patients_confirmed_influenza_7_day_coverageicu_patients_confirmed_2number
total_patients_hospitalized_confirmed_influenza_and_covid_7_day_coveragetotal_patients_hospitalized_5number
previous_day_admission_adult_covid_confirmed_7_day_sumprevious_day_admission_adultnumber
previous_day_admission_adult_covid_confirmed_18-19_7_day_sumprevious_day_admission_adult_1number
previous_day_admission_adult_covid_confirmed_20-29_7_day_sumprevious_day_admission_adult_2number
previous_day_admission_adult_covid_confirmed_30-39_7_day_sumprevious_day_admission_adult_3number
previous_day_admission_adult_covid_confirmed_40-49_7_day_sumprevious_day_admission_adult_4number
previous_day_admission_adult_covid_confirmed_50-59_7_day_sumprevious_day_admission_adult_5number
previous_day_admission_adult_covid_confirmed_60-69_7_day_sumprevious_day_admission_adult_6number
previous_day_admission_adult_covid_confirmed_70-79_7_day_sumprevious_day_admission_adult_7number
previous_day_admission_adult_covid_confirmed_80+_7_day_sumprevious_day_admission_adult_8number
previous_day_admission_adult_covid_confirmed_unknown_7_day_sumprevious_day_admission_adult_9number
previous_day_admission_pediatric_covid_confirmed_7_day_sumprevious_day_admissionnumber
previous_day_covid_ED_visits_7_day_sumprevious_day_covid_ed_visitsnumber
previous_day_admission_adult_covid_suspected_7_day_sumprevious_day_admission_adult_10number
previous_day_admission_adult_covid_suspected_18-19_7_day_sumprevious_day_admission_adult_11number
previous_day_admission_adult_covid_suspected_20-29_7_day_sumprevious_day_admission_adult_12number
previous_day_admission_adult_covid_suspected_30-39_7_day_sumprevious_day_admission_adult_13number
previous_day_admission_adult_covid_suspected_40-49_7_day_sumprevious_day_admission_adult_14number
previous_day_admission_adult_covid_suspected_50-59_7_day_sumprevious_day_admission_adult_15number
previous_day_admission_adult_covid_suspected_60-69_7_day_sumprevious_day_admission_adult_16number
previous_day_admission_adult_covid_suspected_70-79_7_day_sumprevious_day_admission_adult_17number
previous_day_admission_adult_covid_suspected_80+_7_day_sumprevious_day_admission_adult_18number
previous_day_admission_adult_covid_suspected_unknown_7_day_sumprevious_day_admission_adult_19number
previous_day_admission_pediatric_covid_suspected_7_day_sumprevious_day_admission_1number
previous_day_total_ED_visits_7_day_sumprevious_day_total_ed_visitsnumber
previous_day_admission_influenza_confirmed_7_day_sumprevious_day_admission_2number
geocoded_hospital_addressgeocoded_hospital_addresspoint