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 Oct 12, 2022.

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 7 rows (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
24439 IN 2021/12/09 25 139 4 23 142 3 2 166 19179 168 13740 168 2790 166 376 168 133 166 6 166 5 166 1819 168 696 166 667 168 2747 166 2559 168 43 166 26 166 2274 168 0.716408571875489 168 13740 19179 0.204710543693595 166 2790 13629 0.146572104018913 166 2790 19035 0.31266846361186 166 696 2226 0.799912049252419 168 1819 2274   1 167 20 168 26 168 39 168 78 168 80 168 85 168 44 168 3 168 1 166 8 166 7 166 7 166 24 166 30 166 21 166 16 166 19 166 29 166 2860 1076 3846 1797 99 1509 3 164 6 164 0 164 5 164 24 3 165 164 365 48 576 48   0   0   0   0   0 12 48 19 48
39878 OK 2021/07/06 31 93 11 32 92 11 7 133 9491 135 6149 135 277 133 50 135 51 133 0 133 7 133 713 135 73 133 64 135 251 133 209 135 26 133 24 133 994 135 0.647876936044674 135 6149 9491 0.04592175066313 133 277 6032 0.02970827970828 133 277 9324 0.076680672268908 133 73 952 0.717303822937626 135 713 994   0 135 2 132 5 132 8 132 12 132 8 132 11 132 3 132 1 135 0 133 8 130 6 130 3 130 6 130 11 130 10 130 7 130 0 133 1 133 1977 2806 1432 24 11 22 1 123 1 123 0 123 5 123 6 28 123 123 534 71 770 71   0   0   0   0   0 290 71 379 71
44483 OR 2021/05/30 3 54 7 3 54 7 13 62 7076 64 4938 64 306 62 20 64 38 62 0 62 4 62 506 64 73 62 59 64 296 62 252 64 10 62 4 62 907 64 0.697851893725269 64 4938 7076 0.063053781166289 62 306 4853 0.044322132097335 62 306 6904 0.082672706681767 62 73 883 0.557883131201764 64 506 907   0 64 2 63 1 63 0 63 4 63 5 63 6 62 2 62 0 64 0 62 2 60 3 60 2 60 5 60 9 60 9 60 8 60 0 62 4 62 105 120 89 7 273 281 0 62 0 62 0 62 5 62 0 0 62 62 301 50 462 50   0   0   0   0   0 75 50 123 50
14397 MD 2022/09/02 6 30 18 10 27 17 23 53 11066 54 9257 54 690 53 79 54 160 53 2 53 9 52 866 54 77 53 51 54 662 53 502 54 28 53 11 53 1258 54 0.836526296764865 54 9257 11066 0.074894171279713 53 690 9213 0.062875888463641 53 690 10974 0.062908496732026 53 77 1224 0.688394276629571 54 866 1258   0 53 5 49 4 48 8 48 10 48 10 48 21 48 21 48 0 54 2 50 16 47 21 46 10 47 26 46 30 47 26 47 29 47 0 53 4 25 1551 365 1060 0 0 0 2 53 0 53 0 17 5 18 5 0 18 53 403 53 638 53 2 52 0 46 0 47 0 46 2 52 17 53 19 53
17474 MD 2022/08/16 8 27 18 10 26 17 27 52 10435 53 8529 53 800 52 75 53 153 52 3 52 7 52 845 53 76 52 58 53 769 52 602 53 31 52 20 52 1268 53 0.817345471969334 53 8529 10435 0.094551471457275 52 800 8461 0.07735447689035 52 800 10342 0.061788617886179 52 76 1230 0.666403785488959 53 845 1268   2 51 4 49 14 50 5 49 3 50 11 49 23 50 12 49 1 53 4 51 16 48 22 48 9 48 23 49 25 49 24 48 30 48 0 52 2 27 1495 365 971 0 0 0 1 52 1 52 0 18 5 19 6 0 19 52 324 52 527 52 2 52 0 48 1 48 0 45 4 52 18 52 19 52
32141 KY 2022/01/23 34 79 4 50 63 4 91 115 11519 117 8960 117 2594 115 264 117 102 115 6 115 10 114 1242 117 452 115 454 117 2515 115 2335 117 79 115 44 115 1421 117 0.7778452990711 117 8960 11519 0.294037633189753 115 2594 8822 0.228767968956698 115 2594 11339 0.329206117989803 115 452 1373 0.874032371569317 117 1242 1421   2 115 20 115 27 115 30 114 63 114 77 114 79 114 68 114 211 117 3 113 11 113 11 113 13 112 18 112 21 112 22 112 17 112 2 115 29 108 44 0 0 0 0 0 5 115 3 115 2 108 5 64 28 4 108 115 354 110 627 109 2 109 1 109 3 109 0 112 4 108 31 109 63 109
22958 FL 2022/06/21 6 159 75 34 145 61 125 234 55469 240 43513 240 3646 234 633 240 231 234 29 234 16 234 4728 240 382 234 365 240 3563 234 3307 240 83 234 69 234 6533 240 0.784456182732698 240 43513 55469 0.085133210357952 234 3646 42827 0.066763106333889 234 3646 54611 0.059921568627451 234 382 6375 0.723710393387418 240 4728 6533   1 233 25 229 52 230 31 230 77 232 111 232 145 230 158 233 33 240 0 232 19 223 17 223 23 223 35 225 49 224 36 223 44 224 8 234 26 128 4127 0 2767 1184 0 233 27 234 44 234 0 122 5 122 224 17 125 234 1750 234 2618 234 13 234 7 224 7 224 2 232 17 234 672 234 918 234
Powered by Datasette · Queries took 29.374ms · Data source: U.S. Department of Health & Human Services