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 8 rows (hide)

Query parameters

This data as json, CSV

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
34094 TX 2022/08/27 6 83 494 9 80 494 107 578 63201 583 48643 583 3057 578 406 583 288 578 56 578 103 578 5220 583 436 578 399 583 2796 578 2504 583 248 578 165 578 5932 583 0.769655543424946 583 48643 63201 0.063617255946559 578 3057 48053 0.048932355860038 578 3057 62474 0.07526324874849 578 436 5793 0.879973027646662 583 5220 5932   6 582 23 579 29 578 36 578 57 578 69 577 84 577 91 577 22 583 3 577 21 574 34 573 37 573 34 573 57 572 53 572 40 572 9 578 11 574 370 0 114 0 0 0 12 578 22 578 0 93 0 93 103 9 93 578 3805 578 4264 578 34 577 11 573 19 574 0 578 28 578 924 578 1053 578
24151 TX 2022/07/10 7 104 483 9 102 483 161 589 63728 594 47765 594 3388 589 549 594 334 589 63 589 80 589 4979 594 493 589 431 594 3176 589 2911 594 227 589 146 589 5812 594 0.749513557619884 594 47765 63728 0.071790307884644 589 3388 47193 0.053776924175807 589 3388 63001 0.086933521424793 589 493 5671 0.856675843083276 594 4979 5812   4 592 28 588 35 588 48 588 48 588 93 588 112 588 120 588 79 594 2 587 20 583 22 584 26 583 29 583 41 583 37 582 37 583 120 589 17 583 335 0 114 0 0 0 2 589 10 589 0 105 0 105 95 7 105 589 3668 589 4350 589 32 587 12 582 19 582 0 589 34 589 878 589 1044 589
22477 TX 2022/07/14 5 108 482 11 102 482 154 590 65067 595 50707 595 3811 590 589 595 241 590 56 590 73 590 5285 595 508 590 472 595 3555 590 3233 595 256 590 170 590 5944 595 0.779304409301182 595 50707 65067 0.076099762375447 590 3811 50079 0.059238648904917 590 3811 64333 0.087525844245348 590 508 5804 0.889131897711978 595 5285 5944   8 593 34 589 53 589 52 589 55 589 116 589 113 589 136 589 34 595 3 588 10 584 32 584 26 584 28 584 45 584 48 584 44 584 5 590 15 581 358 0 114 0 0 0 5 590 15 590 0 104 0 104 104 8 104 590 3942 590 4490 590 34 588 14 583 19 584 0 590 28 590 930 590 1080 590
31035 TX 2022/07/26 7 79 416 10 76 416 118 497 58808 502 46418 502 4157 497 608 502 331 497 61 497 76 497 5386 502 606 497 568 502 3910 497 3583 502 247 497 181 497 6080 502 0.789314378996055 502 46418 58808 0.090772119835794 497 4157 45796 0.071579853637538 497 4157 58075 0.102054563826204 497 606 5938 0.885855263157895 502 5386 6080   7 500 46 497 44 497 43 496 69 496 102 496 136 496 153 496 22 502 8 495 30 492 28 492 26 492 53 492 63 491 56 491 62 491 5 497 31 492 330 0 85 0 0 0 3 497 10 497 0 92 0 92 72 8 92 497 3454 497 4052 497 38 495 14 491 19 492 0 497 32 497 915 497 1080 497
41069 CA 2022/01/27 34 137 245 159 220 37 201 408 68135 416 55219 416 15370 408 1733 416 548 408 78 397 28 407 6212 416 2536 408 2549 416 14913 408 14619 416 457 408 412 407 7427 416 0.810435165480296 416 55219 68135 0.281677234908185 408 15370 54566 0.228231171299596 408 15370 67344 0.349744862777548 408 2536 7251 0.836407701629191 416 6212 7427   21 411 135 404 189 401 152 401 239 402 330 401 315 401 343 401 9 405 4 402 42 397 47 395 41 394 61 393 90 392 88 392 175 393 0 408 68 144 8909 585 3523 392 0 16 3 404 6 404 0 369 0 368 51 7 368 404 722 73 3060 301 37 289 14 289 19 288 8 312 75 300 547 301 758 299
35663 TX 2022/02/02 10 114 472 16 108 472 207 591 67351 596 53627 596 12508 591 1595 596 413 591 69 591 158 591 6522 596 2593 591 2622 596 11898 591 11578 596 469 591 385 591 6882 596 0.796231681786462 596 53627 67351 0.236245160071773 591 12508 52945 0.187878332707473 591 12508 66575 0.386957170571556 591 2593 6701 0.94768962510898 596 6522 6882   15 596 88 594 104 594 135 594 217 594 298 594 320 594 304 594 114 596 5 591 29 589 37 589 34 589 49 589 82 589 79 589 65 589 33 591 180 585 3623 701 1976 598 0 0 11 591 16 591 0 586 0 586 89 39 586 591 3649 591 4206 591 34 591 16 588 19 588 0 591 75 591 945 591 1092 591
44866 TX 2022/02/17 11 108 477 14 105 477 131 591 68461 596 53988 596 6859 591 716 596 415 591 55 591 99 591 6256 596 1587 591 1556 596 6591 591 6035 596 268 591 214 591 6736 596 0.788594966477264 596 53988 68461 0.128590176227972 591 6859 53340 0.101322106507128 591 6859 67695 0.241736481340442 591 1587 6565 0.92874109263658 596 6256 6736   2 594 52 590 59 590 59 590 78 590 136 590 156 590 121 590 53 596 5 589 37 585 42 585 56 586 57 586 63 585 68 585 70 585 17 591 97 582 300 0 35 0 0 0 20 591 47 591 0 107 0 107 178 7 107 591 3995 591 4591 591 20 589 16 584 19 584 0 591 47 591 941 591 1099 591
43189 TX 2022/02/07 12 81 413 15 78 413 155 501 59934 506 46686 506 10378 501 1007 506 326 501 69 501 107 501 6174 506 2320 501 2304 506 9989 501 9472 506 342 501 288 501 6628 506 0.778956852537792 506 46686 59934 0.225265899717821 501 10378 46070 0.17536922504985 501 10378 59178 0.359913124418244 501 2320 6446 0.931502715751358 506 6174 6628   5 504 63 502 59 502 77 502 111 502 218 502 193 502 210 502 71 506 2 499 22 497 30 497 28 498 52 497 59 497 60 497 61 497 12 501 142 494 265 0 85 0 0 0 17 501 17 501 0 95 0 95 142 18 95 501 3160 501 3769 501 30 499 20 497 19 497 0 501 60 501 881 501 1056 501
Powered by Datasette · Queries took 33.3ms · Data source: U.S. Department of Health & Human Services