COVID-19 Reported Patient Impact and Hospital Capacity by State

This dataset provides state-level data for hospital utilization overall, and for COVID patients, on a weekly basis (Friday to Thursday) since July 31, 2020. The data come directly from the U.S. Department of Health and Human Services. We have not reviewed the data for accuracy.

This data was updated Feb 22, 2023.

Numbers smaller than 4 have been replaced, by HHS, with the value -999999. See the data dictionary for more details.

Data source: U.S. Department of Health & Human Services

This database can be queried directly using Structured Query Language (SQL) supported by SQLite. For more on that syntax, see here. Read more about datasette, the technology powering these interactive queries.

Custom SQL query returning 1 row (hide)

Query parameters

rowidstatedatecritical_staffing_shortage_today_yescritical_staffing_shortage_today_nocritical_staffing_shortage_today_not_reportedcritical_staffing_shortage_anticipated_within_week_yescritical_staffing_shortage_anticipated_within_week_nocritical_staffing_shortage_anticipated_within_week_not_reportedhospital_onset_covidhospital_onset_covid_coverageinpatient_bedsinpatient_beds_coverageinpatient_beds_usedinpatient_beds_used_coverageinpatient_beds_used_covidinpatient_beds_used_covid_coverageprevious_day_admission_adult_covid_confirmedprevious_day_admission_adult_covid_confirmed_coverageprevious_day_admission_adult_covid_suspectedprevious_day_admission_adult_covid_suspected_coverageprevious_day_admission_pediatric_covid_confirmedprevious_day_admission_pediatric_covid_confirmed_coverageprevious_day_admission_pediatric_covid_suspectedprevious_day_admission_pediatric_covid_suspected_coveragestaffed_adult_icu_bed_occupancystaffed_adult_icu_bed_occupancy_coveragestaffed_icu_adult_patients_confirmed_and_suspected_covidstaffed_icu_adult_patients_confirmed_and_suspected_covid_coveragestaffed_icu_adult_patients_confirmed_covidstaffed_icu_adult_patients_confirmed_covid_coveragetotal_adult_patients_hospitalized_confirmed_and_suspected_covidtotal_adult_patients_hospitalized_confirmed_and_suspected_covid_coveragetotal_adult_patients_hospitalized_confirmed_covidtotal_adult_patients_hospitalized_confirmed_covid_coveragetotal_pediatric_patients_hospitalized_confirmed_and_suspected_covidtotal_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coveragetotal_pediatric_patients_hospitalized_confirmed_covidtotal_pediatric_patients_hospitalized_confirmed_covid_coveragetotal_staffed_adult_icu_bedstotal_staffed_adult_icu_beds_coverageinpatient_beds_utilizationinpatient_beds_utilization_coverageinpatient_beds_utilization_numeratorinpatient_beds_utilization_denominatorpercent_of_inpatients_with_covidpercent_of_inpatients_with_covid_coveragepercent_of_inpatients_with_covid_numeratorpercent_of_inpatients_with_covid_denominatorinpatient_bed_covid_utilizationinpatient_bed_covid_utilization_coverageinpatient_bed_covid_utilization_numeratorinpatient_bed_covid_utilization_denominatoradult_icu_bed_covid_utilizationadult_icu_bed_covid_utilization_coverageadult_icu_bed_covid_utilization_numeratoradult_icu_bed_covid_utilization_denominatoradult_icu_bed_utilizationadult_icu_bed_utilization_coverageadult_icu_bed_utilization_numeratoradult_icu_bed_utilization_denominatorgeocoded_stateprevious_day_admission_adult_covid_confirmed_18-19previous_day_admission_adult_covid_confirmed_18-19_coverageprevious_day_admission_adult_covid_confirmed_20-29previous_day_admission_adult_covid_confirmed_20-29_coverageprevious_day_admission_adult_covid_confirmed_30-39previous_day_admission_adult_covid_confirmed_30-39_coverageprevious_day_admission_adult_covid_confirmed_40-49previous_day_admission_adult_covid_confirmed_40-49_coverageprevious_day_admission_adult_covid_confirmed_50-59previous_day_admission_adult_covid_confirmed_50-59_coverageprevious_day_admission_adult_covid_confirmed_60-69previous_day_admission_adult_covid_confirmed_60-69_coverageprevious_day_admission_adult_covid_confirmed_70-79previous_day_admission_adult_covid_confirmed_70-79_coverageprevious_day_admission_adult_covid_confirmed_80+previous_day_admission_adult_covid_confirmed_80+_coverageprevious_day_admission_adult_covid_confirmed_unknownprevious_day_admission_adult_covid_confirmed_unknown_coverageprevious_day_admission_adult_covid_suspected_18-19previous_day_admission_adult_covid_suspected_18-19_coverageprevious_day_admission_adult_covid_suspected_20-29previous_day_admission_adult_covid_suspected_20-29_coverageprevious_day_admission_adult_covid_suspected_30-39previous_day_admission_adult_covid_suspected_30-39_coverageprevious_day_admission_adult_covid_suspected_40-49previous_day_admission_adult_covid_suspected_40-49_coverageprevious_day_admission_adult_covid_suspected_50-59previous_day_admission_adult_covid_suspected_50-59_coverageprevious_day_admission_adult_covid_suspected_60-69previous_day_admission_adult_covid_suspected_60-69_coverageprevious_day_admission_adult_covid_suspected_70-79previous_day_admission_adult_covid_suspected_70-79_coverageprevious_day_admission_adult_covid_suspected_80+previous_day_admission_adult_covid_suspected_80+_coverageprevious_day_admission_adult_covid_suspected_unknownprevious_day_admission_adult_covid_suspected_unknown_coveragedeaths_coviddeaths_covid_coverageon_hand_supply_therapeutic_a_casirivimab_imdevimab_courseson_hand_supply_therapeutic_b_bamlanivimab_courseson_hand_supply_therapeutic_c_bamlanivimab_etesevimab_coursesprevious_week_therapeutic_a_casirivimab_imdevimab_courses_usedprevious_week_therapeutic_b_bamlanivimab_courses_usedprevious_week_therapeutic_c_bamlanivimab_etesevimab_courses_usedicu_patients_confirmed_influenzaicu_patients_confirmed_influenza_coverageprevious_day_admission_influenza_confirmedprevious_day_admission_influenza_confirmed_coverageprevious_day_deaths_covid_and_influenzaprevious_day_deaths_covid_and_influenza_coverageprevious_day_deaths_influenzaprevious_day_deaths_influenza_coveragetotal_patients_hospitalized_confirmed_influenzatotal_patients_hospitalized_confirmed_influenza_and_covidtotal_patients_hospitalized_confirmed_influenza_and_covid_coveragetotal_patients_hospitalized_confirmed_influenza_coverageall_pediatric_inpatient_bed_occupiedall_pediatric_inpatient_bed_occupied_coverageall_pediatric_inpatient_bedsall_pediatric_inpatient_beds_coverageprevious_day_admission_pediatric_covid_confirmed_0_4previous_day_admission_pediatric_covid_confirmed_0_4_coverageprevious_day_admission_pediatric_covid_confirmed_12_17previous_day_admission_pediatric_covid_confirmed_12_17_coverageprevious_day_admission_pediatric_covid_confirmed_5_11previous_day_admission_pediatric_covid_confirmed_5_11_coverageprevious_day_admission_pediatric_covid_confirmed_unknownprevious_day_admission_pediatric_covid_confirmed_unknown_coveragestaffed_icu_pediatric_patients_confirmed_covidstaffed_icu_pediatric_patients_confirmed_covid_coveragestaffed_pediatric_icu_bed_occupancystaffed_pediatric_icu_bed_occupancy_coveragetotal_staffed_pediatric_icu_bedstotal_staffed_pediatric_icu_beds_coverage
26788 CA 2022/12/19 8 91 261 94 202 64 87 351 62625 359 48440 359 4937 351 601 360 343 360 22 352 16 350 4996 359 532 351 491 359 4797 351 4301 359 140 351 112 351 6565 359 0.773493013972056 359 48440 62625 0.103286679637649 351 4937 47799 0.079789898989899 351 4937 61875 0.083086053412463 351 532 6403 0.761005331302361 359 4996 6565   1 358 31 356 48 355 29 355 66 355 77 355 147 355 198 356 6 360 5 359 20 355 24 355 36 355 36 355 71 355 68 355 79 355 6 347 12 97 2152 1187 506 0 0 0 200 357 242 357 0 72 13 288 1373 92 288 356 2698 351 3815 351 8 351 5 348 8 347 2 351 29 351 751 351 1016 351
Powered by Datasette · Queries took 37.616ms · Data source: U.S. Department of Health & Human Services