About this Dataset

COVID-19 Hospital Data Coverage For Hospital In Suspense

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 report shows facilities currently in suspense regarding CoP requirements due to being in a work plan or other related reasons is shown if any facilities are currently in suspense. These CCNs will not be included in the tab listing all other hospitals or included in any summary counts while in suspense.
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
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:02:59.837342
Tags: covid, covid-19, hhs-covid-19

Tables

Table 1

@usgov.hhs_gov_covid_19_hospital_coverage_for_hospital_in_suspense.table_1

115.42 kB
90 rows
110 columns

CREATE TABLE table_1 (
  "state" VARCHAR,
  "ccn" BIGINT,
  "facility_name" VARCHAR,
  "street_address" VARCHAR,
  "city" VARCHAR,
  "zip_code" BIGINT,
  "fips_county" DOUBLE,
  "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" VARCHAR,
  "suspend_reason" VARCHAR,
  "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
);