Data source: U.S. Department of Health & Human Services
This data as json, CSV (advanced)
JSON shape: default, array, newline-delimited
CREATE TABLE hospitals_state ( "state" TEXT, "date" TEXT, "critical_staffing_shortage_today_yes" INTEGER, "critical_staffing_shortage_today_no" INTEGER, "critical_staffing_shortage_today_not_reported" INTEGER, "critical_staffing_shortage_anticipated_within_week_yes" INTEGER, "critical_staffing_shortage_anticipated_within_week_no" INTEGER, "critical_staffing_shortage_anticipated_within_week_not_reported" INTEGER, "hospital_onset_covid" INTEGER, "hospital_onset_covid_coverage" INTEGER, "inpatient_beds" INTEGER, "inpatient_beds_coverage" INTEGER, "inpatient_beds_used" INTEGER, "inpatient_beds_used_coverage" INTEGER, "inpatient_beds_used_covid" INTEGER, "inpatient_beds_used_covid_coverage" INTEGER, "previous_day_admission_adult_covid_confirmed" INTEGER, "previous_day_admission_adult_covid_confirmed_coverage" INTEGER, "previous_day_admission_adult_covid_suspected" INTEGER, "previous_day_admission_adult_covid_suspected_coverage" INTEGER, "previous_day_admission_pediatric_covid_confirmed" INTEGER, "previous_day_admission_pediatric_covid_confirmed_coverage" INTEGER, "previous_day_admission_pediatric_covid_suspected" INTEGER, "previous_day_admission_pediatric_covid_suspected_coverage" INTEGER, "staffed_adult_icu_bed_occupancy" INTEGER, "staffed_adult_icu_bed_occupancy_coverage" INTEGER, "staffed_icu_adult_patients_confirmed_and_suspected_covid" INTEGER, "staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage" INTEGER, "staffed_icu_adult_patients_confirmed_covid" INTEGER, "staffed_icu_adult_patients_confirmed_covid_coverage" INTEGER, "total_adult_patients_hospitalized_confirmed_and_suspected_covid" INTEGER, "total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage" INTEGER, "total_adult_patients_hospitalized_confirmed_covid" INTEGER, "total_adult_patients_hospitalized_confirmed_covid_coverage" INTEGER, "total_pediatric_patients_hospitalized_confirmed_and_suspected_covid" INTEGER, "total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage" INTEGER, "total_pediatric_patients_hospitalized_confirmed_covid" INTEGER, "total_pediatric_patients_hospitalized_confirmed_covid_coverage" INTEGER, "total_staffed_adult_icu_beds" INTEGER, "total_staffed_adult_icu_beds_coverage" INTEGER, "inpatient_beds_utilization" INTEGER, "inpatient_beds_utilization_coverage" INTEGER, "inpatient_beds_utilization_numerator" INTEGER, "inpatient_beds_utilization_denominator" INTEGER, "percent_of_inpatients_with_covid" INTEGER, "percent_of_inpatients_with_covid_coverage" INTEGER, "percent_of_inpatients_with_covid_numerator" INTEGER, "percent_of_inpatients_with_covid_denominator" INTEGER, "inpatient_bed_covid_utilization" INTEGER, "inpatient_bed_covid_utilization_coverage" INTEGER, "inpatient_bed_covid_utilization_numerator" INTEGER, "inpatient_bed_covid_utilization_denominator" INTEGER, "adult_icu_bed_covid_utilization" INTEGER, "adult_icu_bed_covid_utilization_coverage" INTEGER, "adult_icu_bed_covid_utilization_numerator" INTEGER, "adult_icu_bed_covid_utilization_denominator" INTEGER, "adult_icu_bed_utilization" INTEGER, "adult_icu_bed_utilization_coverage" INTEGER, "adult_icu_bed_utilization_numerator" INTEGER, "adult_icu_bed_utilization_denominator" INTEGER, "geocoded_state" INTEGER, "previous_day_admission_adult_covid_confirmed_18-19" INTEGER, "previous_day_admission_adult_covid_confirmed_18-19_coverage" INTEGER, "previous_day_admission_adult_covid_confirmed_20-29" INTEGER, "previous_day_admission_adult_covid_confirmed_20-29_coverage" INTEGER, "previous_day_admission_adult_covid_confirmed_30-39" INTEGER, "previous_day_admission_adult_covid_confirmed_30-39_coverage" INTEGER, "previous_day_admission_adult_covid_confirmed_40-49" INTEGER, "previous_day_admission_adult_covid_confirmed_40-49_coverage" INTEGER, "previous_day_admission_adult_covid_confirmed_50-59" INTEGER, "previous_day_admission_adult_covid_confirmed_50-59_coverage" INTEGER, "previous_day_admission_adult_covid_confirmed_60-69" INTEGER, "previous_day_admission_adult_covid_confirmed_60-69_coverage" INTEGER, "previous_day_admission_adult_covid_confirmed_70-79" INTEGER, "previous_day_admission_adult_covid_confirmed_70-79_coverage" INTEGER, "previous_day_admission_adult_covid_confirmed_80+" INTEGER, "previous_day_admission_adult_covid_confirmed_80+_coverage" INTEGER, "previous_day_admission_adult_covid_confirmed_unknown" INTEGER, "previous_day_admission_adult_covid_confirmed_unknown_coverage" INTEGER, "previous_day_admission_adult_covid_suspected_18-19" INTEGER, "previous_day_admission_adult_covid_suspected_18-19_coverage" INTEGER, "previous_day_admission_adult_covid_suspected_20-29" INTEGER, "previous_day_admission_adult_covid_suspected_20-29_coverage" INTEGER, "previous_day_admission_adult_covid_suspected_30-39" INTEGER, "previous_day_admission_adult_covid_suspected_30-39_coverage" INTEGER, "previous_day_admission_adult_covid_suspected_40-49" INTEGER, "previous_day_admission_adult_covid_suspected_40-49_coverage" INTEGER, "previous_day_admission_adult_covid_suspected_50-59" INTEGER, "previous_day_admission_adult_covid_suspected_50-59_coverage" INTEGER, "previous_day_admission_adult_covid_suspected_60-69" INTEGER, "previous_day_admission_adult_covid_suspected_60-69_coverage" INTEGER, "previous_day_admission_adult_covid_suspected_70-79" INTEGER, "previous_day_admission_adult_covid_suspected_70-79_coverage" INTEGER, "previous_day_admission_adult_covid_suspected_80+" INTEGER, "previous_day_admission_adult_covid_suspected_80+_coverage" INTEGER, "previous_day_admission_adult_covid_suspected_unknown" INTEGER, "previous_day_admission_adult_covid_suspected_unknown_coverage" INTEGER, "deaths_covid" INTEGER, "deaths_covid_coverage" INTEGER, "on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses" INTEGER, "on_hand_supply_therapeutic_b_bamlanivimab_courses" INTEGER, "on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses" INTEGER, "previous_week_therapeutic_a_casirivimab_imdevimab_courses_used" INTEGER, "previous_week_therapeutic_b_bamlanivimab_courses_used" INTEGER, "previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used" INTEGER, "icu_patients_confirmed_influenza" INTEGER, "icu_patients_confirmed_influenza_coverage" INTEGER, "previous_day_admission_influenza_confirmed" INTEGER, "previous_day_admission_influenza_confirmed_coverage" INTEGER, "previous_day_deaths_covid_and_influenza" INTEGER, "previous_day_deaths_covid_and_influenza_coverage" INTEGER, "previous_day_deaths_influenza" INTEGER, "previous_day_deaths_influenza_coverage" INTEGER, "total_patients_hospitalized_confirmed_influenza" INTEGER, "total_patients_hospitalized_confirmed_influenza_and_covid" INTEGER, "total_patients_hospitalized_confirmed_influenza_and_covid_coverage" INTEGER, "total_patients_hospitalized_confirmed_influenza_coverage" INTEGER, "all_pediatric_inpatient_bed_occupied" INTEGER, "all_pediatric_inpatient_bed_occupied_coverage" INTEGER, "all_pediatric_inpatient_beds" INTEGER, "all_pediatric_inpatient_beds_coverage" INTEGER, "previous_day_admission_pediatric_covid_confirmed_0_4" INTEGER, "previous_day_admission_pediatric_covid_confirmed_0_4_coverage" INTEGER, "previous_day_admission_pediatric_covid_confirmed_12_17" INTEGER, "previous_day_admission_pediatric_covid_confirmed_12_17_coverage" INTEGER, "previous_day_admission_pediatric_covid_confirmed_5_11" INTEGER, "previous_day_admission_pediatric_covid_confirmed_5_11_coverage" INTEGER, "previous_day_admission_pediatric_covid_confirmed_unknown" INTEGER, "previous_day_admission_pediatric_covid_confirmed_unknown_coverage" INTEGER, "staffed_icu_pediatric_patients_confirmed_covid" INTEGER, "staffed_icu_pediatric_patients_confirmed_covid_coverage" INTEGER, "staffed_pediatric_icu_bed_occupancy" INTEGER, "staffed_pediatric_icu_bed_occupancy_coverage" INTEGER, "total_staffed_pediatric_icu_beds" INTEGER, "total_staffed_pediatric_icu_beds_coverage" INTEGER );