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
12611 TX 2022/08/21 5 96 485 8 93 485 124 581 62857 586 47229 586 3352 581 397 586 301 581 49 581 70 581 4967 586 566 581 480 586 3132 581 2780 586 220 581 152 581 5825 586 0.75137216220946 586 47229 62857 0.071798826200574 581 3352 46686 0.053947050776535 581 3352 62135 0.09959528418089 581 566 5683 0.852703862660944 586 4967 5825   7 584 32 581 29 580 27 580 47 580 78 580 80 580 101 580 16 586 2 579 19 576 29 575 27 576 31 575 53 575 43 575 37 575 60 581 22 574 344 0 114 0 0 0 13 581 11 581 0 97 0 97 94 8 97 581 3563 581 4127 581 30 579 9 574 18 575 0 581 27 581 865 581 1039 581
14981 TX 2022/08/07 6 104 482 9 101 482 119 587 63268 592 47624 592 3835 587 496 592 278 587 40 587 66 587 4988 592 551 587 499 592 3582 587 3261 592 253 587 194 587 5815 592 0.752734399696529 592 47624 63268 0.081554100034025 587 3835 47024 0.061318793770586 587 3835 62542 0.097092511013216 587 551 5675 0.857781599312124 592 4988 5815   6 590 30 587 26 586 38 586 59 586 85 586 112 586 110 586 72 592 1 585 10 582 12 581 28 582 41 581 48 581 51 581 38 581 49 587 20 582 333 0 85 0 0 0 8 587 7 587 0 102 0 102 83 6 102 587 3678 586 4313 586 19 585 12 580 18 581 0 587 43 587 924 587 1103 586
12062 TX 2022/08/04 5 107 481 8 104 481 156 588 65026 593 50539 593 3926 588 583 593 318 588 55 588 92 588 5318 593 543 588 516 593 3656 588 3365 593 270 588 193 588 6030 593 0.777212192046258 593 50539 65026 0.078664743127354 588 3926 49908 0.061067039975113 588 3926 64290 0.092205807437596 588 543 5889 0.881923714759536 593 5318 6030   8 591 43 588 32 588 44 588 60 588 99 588 149 587 142 587 69 593 3 586 15 583 20 582 26 582 34 582 55 582 59 582 60 582 46 588 18 581 333 0 85 0 0 0 6 588 14 588 0 104 0 104 80 8 104 588 3821 587 4397 587 39 586 13 581 18 582 0 588 36 588 912 588 1085 587
13916 TX 2022/08/05 5 107 481 10 102 481 126 588 64828 593 50159 593 3924 588 597 593 350 588 42 588 84 588 5222 593 565 588 519 593 3650 588 3372 593 274 588 204 588 5940 593 0.773724316653298 593 50159 64828 0.079221513365097 588 3924 49532 0.061220668996505 588 3924 64096 0.09743059148129 588 565 5799 0.879124579124579 593 5222 5940   10 591 38 588 42 588 41 588 81 588 102 587 129 587 123 587 68 593 3 586 14 582 34 582 32 582 52 582 54 582 57 582 56 582 48 588 23 582 333 0 85 0 0 0 6 588 12 588 0 103 0 103 81 6 103 588 3826 587 4383 587 26 586 12 581 18 581 0 588 40 588 930 588 1097 587
26510 TX 2022/02/10 14 110 472 15 109 472 142 591 67217 596 52994 596 9563 591 1126 596 396 591 86 591 132 591 6462 596 2196 591 2195 596 9157 591 8786 596 353 591 297 591 6870 596 0.788401743606528 596 52994 67217 0.18267779709259 591 9563 52349 0.143891062293109 591 9563 66460 0.328300194348931 591 2196 6689 0.94061135371179 596 6462 6870   4 595 74 593 69 593 78 593 133 594 252 593 221 593 218 593 77 596 4 590 34 588 47 588 37 588 50 589 85 588 67 588 65 588 7 591 131 585 4067 702 2107 31 0 0 20 591 23 591 0 114 0 114 106 18 114 591 3755 591 4291 591 41 591 27 588 18 588 0 591 61 591 955 591 1101 591
26650 TX 2022/02/09 14 110 472 15 109 472 142 591 67217 596 52994 596 9563 591 1126 596 396 591 86 591 132 591 6462 596 2196 591 2195 596 9157 591 8786 596 353 591 297 591 6870 596 0.788401743606528 596 52994 67217 0.18267779709259 591 9563 52349 0.143891062293109 591 9563 66460 0.328300194348931 591 2196 6689 0.94061135371179 596 6462 6870   4 595 74 593 69 593 78 593 133 594 252 593 221 593 218 593 77 596 4 590 34 588 47 588 37 588 50 589 85 588 67 588 65 588 7 591 131 585 4067 702 2107 31 0 0 20 591 23 591 0 114 0 114 106 18 114 591 3755 591 4291 591 41 591 27 588 18 588 0 591 61 591 955 591 1101 591
26675 TX 2022/02/18 12 108 476 13 107 476 115 591 68042 596 53394 596 6475 591 621 596 386 591 58 591 115 591 6185 596 1518 591 1473 596 6216 591 5667 596 259 591 212 591 6749 596 0.78472120161077 596 53394 68042 0.12267439657459 591 6475 52782 0.09624531779535 591 6475 67276 0.230804318078151 591 1518 6577 0.916432064009483 596 6185 6749   3 594 38 590 44 590 48 590 67 590 120 590 123 590 121 590 57 596 3 589 35 585 32 585 38 586 54 586 48 585 86 585 69 585 21 591 77 582 300 1 74 1 0 0 25 591 50 591 0 108 0 108 191 8 108 591 3981 591 4557 591 17 589 23 584 18 584 0 591 43 591 944 591 1108 591
Powered by Datasette · Queries took 28.661ms · Data source: U.S. Department of Health & Human Services