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 5 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
13546 TX 2022/08/29 6 78 416 8 76 416 102 495 57944 500 44669 500 3074 495 367 500 198 495 54 495 92 495 5064 500 400 495 360 500 2791 495 2530 500 283 495 173 495 5885 500 0.77089948916195 500 44669 57944 0.069763747361732 495 3074 44063 0.053724352476493 495 3074 57218 0.069601531233687 495 400 5747 0.860492778249788 500 5064 5885   5 499 19 496 23 495 40 495 32 495 69 494 87 494 92 494 17 500 3 494 18 491 23 490 23 490 23 490 42 489 33 489 29 489 4 495 16 492 259 0 85 0 0 0 10 495 20 495 0 91 0 91 108 7 91 495 3637 495 4157 495 31 494 15 490 16 491 0 495 30 495 930 495 1080 495
12637 TX 2022/07/31 6 104 484 9 101 484 144 589 63993 594 48292 594 3899 589 519 594 225 589 41 589 65 589 5015 594 573 589 532 594 3646 589 3335 594 253 589 187 589 5851 594 0.754645039301174 594 48292 63993 0.081714345593629 589 3899 47715 0.061633549896461 589 3899 63261 0.10031512605042 589 573 5712 0.857118441292087 594 5015 5851   6 591 33 589 31 587 39 588 63 587 101 587 131 587 120 588 26 594 5 586 16 584 18 582 24 583 29 582 45 582 41 582 44 583 3 589 22 580 349 0 114 0 0 0 8 589 11 589 0 104 0 104 74 10 104 589 3619 589 4241 589 33 587 8 581 16 582 0 589 44 589 893 589 1079 589
26331 TX 2022/07/09 7 104 483 9 102 483 144 589 64618 594 49195 594 3358 589 643 594 360 589 47 589 74 589 5180 594 460 589 402 594 3150 589 2873 594 208 589 131 589 5983 594 0.761320375127673 594 49195 64618 0.06908185726923 589 3358 48609 0.05256155399377 589 3358 63887 0.078740157480315 589 460 5842 0.865786394785225 594 5180 5983   5 592 43 589 41 588 45 588 55 588 96 588 141 588 148 588 86 594 2 587 17 583 16 583 28 583 37 583 53 583 55 582 48 583 104 589 15 583 356 0 114 0 0 0 3 589 10 589 0 105 0 105 97 8 105 589 3790 589 4408 589 22 587 9 582 16 582 0 589 40 589 916 589 1056 589
25642 TX 2022/07/15 6 108 481 11 103 481 169 590 64989 595 50349 595 3836 590 532 595 260 590 51 590 64 590 5080 595 510 590 469 595 3552 590 3200 595 246 590 169 590 5822 595 0.774731108341412 595 50349 64989 0.077153603250266 590 3836 49719 0.059696847085188 590 3836 64258 0.089741333802569 590 510 5683 0.872552387495706 595 5080 5822   1 593 34 589 38 589 47 589 57 589 81 589 111 589 147 589 30 595 3 588 13 583 26 584 26 584 44 584 49 584 51 584 44 584 4 590 17 581 353 0 114 0 0 0 4 590 22 590 0 105 0 105 105 8 105 590 3881 590 4455 590 38 588 9 583 16 584 0 590 30 590 913 590 1066 590
27538 TX 2022/02/16 12 108 476 14 106 476 139 591 67514 596 53121 596 7001 591 773 596 387 591 61 591 88 591 6203 596 1644 591 1606 596 6738 591 6296 596 263 591 215 591 6742 596 0.78681458660426 596 53121 67514 0.133446428911804 591 7001 52463 0.104899610428529 591 7001 66740 0.250647964628754 591 1644 6559 0.920053396618214 596 6203 6742   5 596 43 593 56 593 74 593 113 593 139 593 157 593 124 593 62 596 5 591 29 588 34 588 40 588 52 588 83 588 68 588 56 588 20 591 84 586 3319 701 1990 0 0 0 19 591 32 591 0 111 0 111 107 12 111 591 3837 591 4402 591 34 591 11 587 16 587 0 591 45 591 953 591 1111 591
Powered by Datasette · Queries took 29.529ms · Data source: U.S. Department of Health & Human Services