COVID-19 Hospital Data Coverage Report
U.S. Department of Health & Human Services
@usgov.hhs_gov_covid_19_hospital_data_coverage_report_8e5a8
U.S. Department of Health & Human Services
@usgov.hhs_gov_covid_19_hospital_data_coverage_report_8e5a8
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 data completeness information on data submitted by hospitals for the previous week, from Friday to Thursday. The U.S. Department of Health and Human Services requires all hospitals licensed to provide 24-hour care to report certain data necessary to the all-of-America COVID-19 response. The report includes the following information for each hospital:
Hospitals are key partners in the Federal response to COVID-19, and this report is published to increase transparency into the type and amount of data being successfully reported to the U.S. Government.
Source:HHS Protect, U.S. Department of Health & Human Services
Organization: U.S. Department of Health & Human Services
Last updated: 2022-05-24T01:38:49.800020
Tags: covid, covid-19, hhs-covid-19
CREATE TABLE table_1 (
"state" VARCHAR,
"ccn" BIGINT,
"facility_name" VARCHAR,
"street_address" VARCHAR,
"city" VARCHAR,
"zip_code" BIGINT,
"fips_code" DOUBLE,
"provider_subtype" VARCHAR,
"reporting_source" VARCHAR,
"dates_with_missing_data" VARCHAR,
"certified_bed_count" BIGINT,
"component_hospitals" DOUBLE,
"week_ending" TIMESTAMP,
"days_at_100" BIGINT -- Days At 100%,
"percentage_of_required_fields_reported" DOUBLE,
"hospital_required_to_report_wed_only" VARCHAR,
"county" VARCHAR,
"inpatient_beds" BIGINT,
"all_adult_hospital_inpatient_beds" BIGINT,
"all_pediatric_inpatient_beds" BIGINT,
"inpatient_beds_used" BIGINT,
"all_adult_hospital_inpatient_bed_occupied" BIGINT,
"all_pediatric_inpatient_bed_occupied" BIGINT,
"total_icu_beds" BIGINT,
"total_staffed_adult_icu_beds" BIGINT,
"total_staffed_pediatric_icu_beds" BIGINT,
"icu_beds_used" BIGINT,
"staffed_adult_icu_bed_occupancy" BIGINT,
"staffed_pediatric_icu_bed_occupancy" BIGINT,
"total_adult_patients_hospitalized_confirmed_covid" BIGINT,
"total_pediatric_patients_hospitalized_confirmed_covid" BIGINT,
"staffed_icu_adult_patients_confirmed_covid" BIGINT,
"staffed_icu_pediatric_patients_confirmed_covid" BIGINT,
"previous_day_admission_adult_covid_confirmed" BIGINT,
"previous_day_admission_adult_covid_confirmed_all" BIGINT,
"previous_day_admission_pediatric_covid_confirmed" BIGINT,
"previous_day_admission_peds_covid_confirmed_all" BIGINT,
"total_patients_hospitalized_confirmed_influenza" BIGINT,
"previous_day_admission_influenza_confirmed" BIGINT,
"icu_patients_confirmed_influenza" 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_maintain_n95_masks" 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,
"total_adult_patients_hospitalized_confirmed_and_suspected_covid" BIGINT,
"total_pediatric_patients_hospitalized_confirmed_and_su_7b73e128" BIGINT -- Total Pediatric Patients Hospitalized Confirmed And Suspected Covid,
"inpatient_ventilators_used_covid" BIGINT,
"staffed_icu_adult_patients_confirmed_and_suspected_covid" BIGINT,
"hospital_onset_covid" BIGINT,
"previous_day_admission_adult_covid_suspected" BIGINT,
"previous_day_admission_adult_covid_suspected_all" BIGINT,
"previous_day_admission_pediatric_covid_suspected" BIGINT,
"previous_day_total_ed_visits" BIGINT,
"previous_day_covid_ed_visits" BIGINT,
"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,
"staffed_icu_adult_patients_confirmed_influenza" BIGINT,
"staffed_icu_pediatric_patients_confirmed_influenza" BIGINT,
"total_adult_patients_hospitalized_confirmed_rsv" BIGINT,
"total_pediatric_patients_hospitalized_confirmed_rsv" BIGINT,
"previous_day_admission_adult_rsv_confirmed" BIGINT,
"previous_day_admission_pediatric_rsv_confirmed" BIGINT,
"staffed_icu_adult_patients_confirmed_rsv" BIGINT,
"staffed_icu_pediatric_patients_confirmed_rsv" BIGINT,
"critical_staffing_shortage_anticipated_within_week" BIGINT,
"previous_day_admission_adult_covid_suspected_18_19" BIGINT,
"previous_day_admission_adult_covid_suspected_20_29" BIGINT,
"previous_day_admission_adult_covid_suspected_30_39" BIGINT,
"previous_day_admission_adult_covid_suspected_40_49" BIGINT,
"previous_day_admission_adult_covid_suspected_50_59" BIGINT,
"previous_day_admission_adult_covid_suspected_60_69" BIGINT,
"previous_day_admission_adult_covid_suspected_70_79" BIGINT,
"previous_day_admission_adult_covid_suspected_80" BIGINT -- Previous Day Admission Adult Covid Suspected 80+,
"previous_day_admission_adult_covid_suspected_unknown" BIGINT,
"previous_day_admission_adult_covid_confirmed_18_19" BIGINT,
"previous_day_admission_adult_covid_confirmed_20_29" BIGINT,
"previous_day_admission_adult_covid_confirmed_30_39" BIGINT,
"previous_day_admission_adult_covid_confirmed_40_49" BIGINT,
"previous_day_admission_adult_covid_confirmed_50_59" BIGINT,
"previous_day_admission_adult_covid_confirmed_60_69" BIGINT,
"previous_day_admission_adult_covid_confirmed_70_79" BIGINT,
"previous_day_admission_adult_covid_confirmed_80" BIGINT -- Previous Day Admission Adult Covid Confirmed 80+,
"previous_day_admission_adult_covid_confirmed_unknown" BIGINT,
"previous_day_admission_pediatric_covid_confirmed_0_4" BIGINT,
"previous_day_admission_pediatric_covid_confirmed_5_11" BIGINT,
"previous_day_admission_pediatric_covid_confirmed_12_17" BIGINT,
"previous_day_admission_pediatric_covid_confirmed_unknown" BIGINT,
"total_beds" BIGINT,
"all_adult_hospital_beds" BIGINT,
"total_ventilators" BIGINT,
"ventilators_used" BIGINT,
"overflow_covid" BIGINT
);Anyone who has the link will be able to view this.