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 9 rows (show)

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
25832 TX 2022/07/04 5 77 420 10 72 420 95 497 57098 502 42523 502 3070 497 424 502 228 497 50 497 65 497 4884 502 408 497 365 502 2869 497 2555 502 201 497 127 497 5749 502 0.744737118638131 502 42523 57098 0.073123094512195 497 3070 41984 0.054470289739359 497 3070 56361 0.072753209700428 497 408 5608 0.849539050269612 502 4884 5749   1 500 28 497 30 497 35 497 37 497 76 497 95 497 109 497 20 502 1 495 18 492 19 492 25 493 34 493 51 492 44 492 31 492 5 497 11 491 328 0 85 0 0 0 2 497 8 497 0 89 2 89 75 10 89 497 3290 497 3878 497 29 495 7 492 14 492 0 497 26 497 881 497 1061 497
29092 TX 2022/08/26 6 84 493 9 81 493 116 578 63964 583 49599 583 3163 578 420 583 279 578 31 578 80 578 5222 583 447 578 407 583 2920 578 2584 583 230 578 167 578 5989 583 0.775420549058846 583 49599 63964 0.064562878896124 578 3163 48991 0.050013440222633 578 3163 63243 0.076384142173616 578 447 5852 0.871931875104358 583 5222 5989   7 582 20 579 23 578 40 578 53 578 77 577 96 577 99 577 22 583 3 577 20 574 32 573 25 573 31 573 49 572 59 572 49 572 11 578 12 574 370 0 114 0 0 0 12 578 15 578 0 94 0 94 100 9 94 578 3802 578 4265 578 20 577 7 573 14 574 0 578 27 578 898 578 1035 578
31240 TX 2022/07/06 6 108 480 11 103 480 147 589 64222 594 48545 594 3211 589 548 594 297 589 56 589 95 589 5067 594 427 589 394 594 3011 589 2746 594 209 589 127 589 5902 594 0.755893619009062 594 48545 64222 0.066994930000626 589 3211 47929 0.050574097116127 589 3211 63491 0.07411907654921 589 427 5761 0.858522534733988 594 5067 5902   3 594 35 593 37 593 35 593 55 593 88 593 115 593 126 593 66 594 3 589 17 588 30 588 24 588 33 588 45 588 56 587 46 588 43 589 20 585 2042 660 737 0 0 0 2 589 9 589 0 107 0 107 32 9 107 589 3678 589 4258 589 31 589 11 587 14 587 0 589 25 589 898 589 1064 589
32702 TX 2022/07/08 6 107 481 8 105 481 182 589 65537 594 50293 594 3467 589 632 594 331 589 63 589 85 589 5295 594 486 589 444 594 3267 589 2942 594 225 589 146 589 6030 594 0.767398568747425 594 50293 65537 0.069793658782084 589 3467 49675 0.053501435140891 589 3467 64802 0.0825267447784 589 486 5889 0.878109452736318 594 5295 6030   6 592 41 588 48 588 38 588 72 588 89 588 128 588 141 588 83 594 5 587 24 584 25 583 32 583 41 583 59 583 46 582 45 583 54 589 19 582 356 0 148 0 0 0 3 589 16 589 0 105 0 105 106 9 105 589 3940 589 4525 589 32 587 17 582 14 582 0 589 35 589 943 589 1084 589
33851 TX 2022/07/12 6 82 416 9 79 416 141 499 58953 504 45982 504 3733 499 617 504 221 499 64 499 79 499 5203 504 502 499 452 504 3475 499 3149 504 258 499 171 499 5911 504 0.779977270028667 504 45982 58953 0.082277225540544 499 3733 45371 0.064106747265202 499 3733 58231 0.087001733102253 499 502 5770 0.88022331246828 504 5203 5911   3 502 44 499 50 499 53 499 76 499 101 500 138 499 128 499 28 504 3 497 18 494 22 494 13 495 37 494 45 494 41 494 36 494 6 499 24 494 330 0 85 0 0 0 6 499 12 499 0 93 0 93 113 11 93 499 3563 499 4202 499 34 497 16 494 14 494 0 499 33 499 913 499 1063 499
25723 TX 2022/06/30 7 105 483 9 103 483 142 590 65299 595 50252 595 2937 590 508 595 263 590 51 590 78 590 5306 595 405 590 364 595 2737 590 2445 595 200 590 136 590 5986 595 0.769567680975206 595 50252 65299 0.059175531914894 590 2937 49632 0.045492565055762 590 2937 64560 0.06928999144568 590 405 5845 0.886401603742065 595 5306 5986   3 593 39 590 37 590 40 590 59 590 87 590 105 590 116 590 28 595 2 588 19 585 22 585 30 586 42 585 54 585 52 585 36 585 6 590 13 581 356 1 114 0 0 0 7 590 19 590 0 103 0 103 90 13 103 590 3848 590 4386 590 21 588 16 584 14 584 0 590 31 590 922 590 1061 590
27811 TX 2022/06/27 7 78 417 9 76 417 108 497 58044 502 44090 502 2718 497 357 502 218 497 41 497 61 497 5016 502 393 497 341 502 2524 497 2197 502 194 497 116 497 5837 502 0.759596168423954 502 44090 58044 0.0625057492411 497 2718 43484 0.047431243892224 497 2718 57304 0.06900790166813 497 393 5695 0.85934555422306 502 5016 5837   3 500 26 497 27 497 35 497 47 497 55 497 76 497 85 497 13 502 1 495 19 492 27 492 18 492 35 492 33 492 51 492 30 492 4 497 19 491 323 0 85 0 0 0 7 497 15 497 0 91 0 91 103 10 91 497 3321 497 3881 497 18 495 9 492 14 492 0 497 27 497 892 497 1046 497
37401 FL 2022/02/05 8 191 72 40 170 61 253 265 60540 271 47761 271 7366 265 1028 271 302 265 58 265 24 265 5368 271 1136 265 1118 271 7181 265 6803 271 185 265 160 265 6587 271 0.788916418896597 271 47761 60540 0.156660073587273 265 7366 47019 0.123538784067086 265 7366 59625 0.176891933976954 265 1136 6422 0.814938515257325 271 5368 6587   4 260 39 255 92 256 63 257 109 259 204 259 233 262 255 261 29 271 0 260 18 248 30 249 29 249 48 249 49 249 58 248 59 251 11 265 43 148 3993 69 3281 1582 237 318 9 265 14 265 0 134 0 134 81 10 134 265 1731 265 2813 265 11 263 25 252 14 250 8 265 24 264 566 265 867 265
46002 TX 2022/02/19 10 108 477 14 104 477 130 590 66961 595 51374 595 6127 590 576 595 368 590 45 590 108 590 5989 595 1445 590 1406 595 5881 590 5375 595 246 590 197 590 6598 595 0.767222711727722 595 51374 66961 0.120610236220472 590 6127 50800 0.09256125932864 590 6127 66194 0.225007785736531 590 1445 6422 0.907699302819036 595 5989 6598   3 592 38 588 52 588 52 588 72 588 116 588 106 588 101 588 36 595 3 587 25 583 23 583 44 584 60 584 52 583 68 583 49 583 44 590 90 581 362 1 35 2 0 0 20 590 51 590 0 107 0 107 171 8 107 590 3901 590 4468 590 15 587 16 582 14 582 0 590 43 589 1001 590 1157 590
Powered by Datasette · Queries took 44.523ms · Data source: U.S. Department of Health & Human Services