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 Jan 25, 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
55818 NC 2021/07/18 4 116 12 4 116 12 22 128 23670 132 17577 132 602 128 86 132 90 128 0 128 4 128 1778 132 196 128 183 132 581 128 532 132 21 128 8 128 2370 132 0.742585551330798 132 17577 23670 0.034526267492544 128 602 17436 0.025722098786532 128 602 23404 0.084995663486557 128 196 2306 0.750210970464135 132 1778 2370   0 132 6 132 9 132 13 132 14 132 16 132 22 132 6 132 0 132 0 128 2 128 5 128 7 128 24 128 18 128 17 128 17 128 0 128 10 128 1126 1948 190 53 0 3 3 128 2 128 0 128 20 128 9 4 128 128 1496 128 2662 128   0   0   0   0   0 287 128 388 128
Powered by Datasette · Queries took 32.159ms · Data source: U.S. Department of Health & Human Services