About this Dataset

COVID-19 Hospital Data Coverage Detail

After May 3, 2024, this dataset and webpage will no longer be updated because hospitals are no longer required to report data on COVID-19 hospital admissions, and hospital capacity and occupancy data, to HHS through CDC’s National Healthcare Safety Network. Data voluntarily reported to NHSN after May 1, 2024, will be available starting May 10, 2024, atCOVID Data Tracker Hospitalizations.

This shows the facilities details.

01/05/2024 – As of FAQ 6, the following optional fields have been added to this report:

total_adult_patients_hospitalized_confirmed_influenza
total_pediatric_patients_hospitalized_confirmed_influenza
previous_day_admission_adult_influenza_confirmed
previous_day_admission_pediatric_influenza_confirmed
staffed_icu_adult_patients_confirmed_influenza
staffed_icu_pediatric_patients_confirmed_influenza
total_adult_patients_hospitalized_confirmed_rsv
total_pediatric_patients_hospitalized_confirmed_rsv
previous_day_admission_adult_rsv_confirmed
previous_day_admission_pediatric_rsv_confirmed
staffed_icu_adult_patients_confirmed_rsv
staffed_icu_pediatric_patients_confirmed_rsv"

6/17/2023 - With the new 28-day compliance reporting period, CoP reports will be posted every 4 weeks.

9/12/2021 - To view other COVID-19 Hospital Data Coverage datasets, follow this link to view summary page: https://healthdata.gov/stories/s/ws49-ddj5

08/10/2022 - As of FAQ3, the following field are federally inactive and will no longer be included in this report:

previous_week_personnel_covid_vaccinated_doses_administered
total_personnel_covid_vaccinated_doses_none
total_personnel_covid_vaccinated_doses_one
total_personnel_covid_vaccinated_doses_all
total_personnel
previous_week_patients_covid_vaccinated_doses_one
previous_week_patients_covid_vaccinated_doses_all
Organization: U.S. Department of Health & Human Services
Last updated: 2021-09-14T08:03:39.141237
Tags: covid, covid-19, hhs-covid-19

Tables

Table 1

@usgov.hhs_gov_covid_19_hospital_data_coverage_detail.table_1

632.32 kB
4,852 rows
109 columns

CREATE TABLE table_1 (
  "state" VARCHAR,
  "ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "zip_code" BIGINT,
  "fips_county" BIGINT,
  "provider_subtype" VARCHAR,
  "reporting_source" VARCHAR,
  "dates_with_missing_data" VARCHAR,
  "certified_bed_count" BIGINT,
  "component_hospitals" DOUBLE,
  "week_ending" VARCHAR,
  "days_at_100" BIGINT  -- Days At 100%,
  "percentage_of_required_fields_reported" DOUBLE,
  "hospital_required_to_report_wed_only" BOOLEAN,
  "total_beds" BIGINT,
  "all_adult_hospital_beds" BIGINT,
  "inpatient_beds" BIGINT,
  "all_adult_hospital_inpatient_beds" BIGINT,
  "inpatient_beds_used" BIGINT,
  "all_adult_hospital_inpatient_bed_occupied" BIGINT,
  "total_icu_beds" BIGINT,
  "total_staffed_adult_icu_beds" BIGINT,
  "icu_beds_used" BIGINT,
  "staffed_adult_icu_bed_occupancy" BIGINT,
  "total_ventilators" BIGINT,
  "ventilators_used" BIGINT,
  "total_adult_patients_hospitalized_confirmed_and_suspected_covid" BIGINT,
  "total_adult_patients_hospitalized_confirmed_covid" BIGINT,
  "total_pediatric_patients_hospitalized_confirmed_and_su_7b73e128" BIGINT  -- Total Pediatric Patients Hospitalized Confirmed And Suspected Covid,
  "total_pediatric_patients_hospitalized_confirmed_covid" BIGINT,
  "inpatient_ventilators_used_covid" BIGINT,
  "staffed_icu_adult_patients_confirmed_and_suspected_covid" BIGINT,
  "staffed_icu_adult_patients_confirmed_covid" BIGINT,
  "hospital_onset_covid" BIGINT,
  "overflow_covid" BIGINT,
  "overflow_ventilators_used_covid" BIGINT,
  "deaths_covid" BIGINT,
  "previous_day_admission_adult_covid_confirmed" BIGINT,
  "previous_day_admission_adult_covid_suspected" BIGINT,
  "previous_day_admission_adult_covid_suspected_all" BIGINT,
  "previous_day_admission_adult_covid_confirmed_all" BIGINT,
  "previous_day_admission_pediatric_covid_confirmed" BIGINT,
  "previous_day_admission_pediatric_covid_suspected" BIGINT,
  "previous_day_total_ed_visits" BIGINT,
  "previous_day_covid_ed_visits" BIGINT,
  "total_patients_hospitalized_confirmed_influenza" BIGINT,
  "previous_day_admission_influenza_confirmed" BIGINT,
  "icu_patients_confirmed_influenza" BIGINT,
  "total_patients_hospitalized_confirmed_influenza_and_covid" BIGINT,
  "previous_day_deaths_influenza" BIGINT,
  "previous_day_deaths_covid_and_influenza" BIGINT,
  "previous_day_remdesivir_used" BIGINT,
  "on_hand_supply_remdesivir_vials" BIGINT,
  "critical_staffing_shortage_today" BIGINT,
  "critical_staffing_shortage_anticipated_within_week" BIGINT,
  "ppe_supply_management_source" BIGINT,
  "on_hand_ventilator_supplies_in_days" BIGINT,
  "n95_respirators_days_available" BIGINT,
  "on_hand_supply_of_surgical_masks_in_days" BIGINT,
  "on_hand_supply_of_eye_protection_in_days" BIGINT,
  "on_hand_supply_of_single_use_surgical_gowns_in_days" BIGINT,
  "on_hand_supply_of_gloves_in_days" BIGINT,
  "able_to_obtain_ventilator_supplies" BIGINT,
  "able_to_obtain_ventilator_medications" BIGINT,
  "able_to_obtain_n95_masks" BIGINT,
  "able_to_obtain_paprs" BIGINT,
  "able_to_obtain_surgical_masks" BIGINT,
  "able_to_obtain_eye_protection" BIGINT,
  "able_to_obtain_single_use_gowns" BIGINT,
  "able_to_obtain_gloves" BIGINT,
  "able_to_maintain_ventilator_supplies" BIGINT,
  "able_to_maintain_ventilator_medications" BIGINT,
  "able_to_maintain_n95_masks" BIGINT,
  "able_to_maintain_paprs" BIGINT,
  "able_to_maintain_surgical_masks" BIGINT,
  "able_to_maintain_eye_protection" BIGINT,
  "able_to_maintain_single_use_gowns" BIGINT,
  "able_to_maintain_gloves" BIGINT,
  "able_to_maintain_lab_nasal_pharyngeal_swabs" BIGINT,
  "able_to_maintain_lab_nasal_swabs" BIGINT,
  "able_to_maintain_lab_viral_transport_media" BIGINT,
  "on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses" VARCHAR,
  "previous_week_therapeutic_a_casirivimab_imdevimab_courses_used" VARCHAR,
  "on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses" VARCHAR,
  "previous_week_therapeutic_c_bamlanivimab_etesevimab_co_f2ad3485" VARCHAR  -- Previous Week Therapeutic C Bamlanivimab Etesevimab Courses Used,
  "on_hand_supply_therapeutic_b_bamlanivimab_courses" VARCHAR,
  "previous_week_therapeutic_b_bamlanivimab_courses_used" VARCHAR,
  "previous_week_personnel_covid_vaccinated_doses_administered" VARCHAR,
  "total_personnel_covid_vaccinated_doses_none" VARCHAR,
  "total_personnel_covid_vaccinated_doses_one" VARCHAR,
  "total_personnel_covid_vaccinated_doses_all" VARCHAR,
  "total_personnel" VARCHAR,
  "previous_week_patients_covid_vaccinated_doses_one" VARCHAR,
  "previous_week_patients_covid_vaccinated_doses_all" VARCHAR,
  "total_adult_patients_hospitalized_confirmed_influenza" BIGINT,
  "total_pediatric_patients_hospitalized_confirmed_influenza" BIGINT,
  "previous_day_admission_adult_influenza_confirmed" BIGINT,
  "previous_day_admission_pediatric_influenza_confirmed" BIGINT
);