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
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,
"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,
"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_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_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.