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
11363 IN 2020/11/28 29 133 2 40 122 2 6 162 18599 164 11827 164 3383 162 399 164 294 162 3 162 10 162 1637 164 780 162 700 164 3352 162 2784 164 31 162 15 162 2217 164 0.635894402924888 164 11827 18599 0.288381212172875 162 3383 11731 0.183320689281457 162 3383 18454 0.359778597785978 162 780 2168 0.738385205232296 164 1637 2217   1 164 8 164 15 164 31 164 71 164 62 164 120 164 87 164 4 164 3 162 13 162 14 162 18 162 29 162 57 162 79 162 66 162 15 162 42 162             1 141 0 141 0 141 6 140 4 11 140 141 1014 162 1666 162   0   0   0   0   0 270 162 424 162
28293 OK 2021/12/30 44 102 3 46 100 3 16 147 10251 149 7882 149 1081 147 215 149 64 147 7 147 3 147 873 149 268 147 274 149 1037 147 1004 149 44 147 41 147 997 149 0.768900595063896 149 7882 10251 0.139682129474092 147 1081 7739 0.10718889439762 147 1081 10085 0.280628272251309 147 268 955 0.875626880641926 149 873 997   1 149 20 146 18 146 30 146 29 146 37 146 46 146 31 146 3 149 0 147 6 144 2 144 3 144 7 144 20 144 12 144 13 144 1 147 17 147 2360 1723 1545 870 16 448 9 134 21 134 1 134 6 134 52 7 134 134 781 79 881 79   0   0   0   0   0 300 79 385 79
18356 MD 2022/09/29 12 22 18 14 20 18 20 51 10824 52 8984 52 641 51 49 52 153 51 4 51 14 51 876 52 56 51 45 52 604 51 439 52 37 51 11 51 1284 52 0.830007390983001 52 8984 10824 0.071917423987434 51 641 8913 0.059755756502284 51 641 10727 0.044943820224719 51 56 1246 0.682242990654206 52 876 1284   0 52 4 51 5 51 6 51 5 50 10 50 6 50 13 50 0 52 1 51 17 50 20 50 12 50 14 49 20 49 39 49 30 49 0 51 0 28 1597 365 1670 3 0 0 0 51 1 51 0 21 6 21 4 0 21 51 373 51 543 51 1 51 3 49 0 49 0 44 2 51 18 51 19 51
18967 MD 2022/09/24 12 20 20 14 20 18 18 51 10769 52 8698 52 638 51 62 52 150 51 0 51 26 51 844 52 69 51 44 52 592 51 442 52 46 51 10 51 1275 52 0.807688736187204 52 8698 10769 0.073936724997103 51 638 8629 0.05979381443299 51 638 10670 0.055825242718447 51 69 1236 0.661960784313726 52 844 1275   0 52 7 51 4 51 7 50 1 50 13 50 11 50 19 50 0 52 2 51 15 50 13 50 18 49 18 49 34 49 25 49 25 49 0 51 1 29 1480 365 1003 3 0 0 0 51 1 51 0 21 6 22 4 0 22 51 357 51 535 51 0 51 0 49 0 49 0 44 1 50 17 51 7 51
19465 MD 2022/09/22 12 22 18 14 21 17 19 51 10850 52 9105 52 691 51 76 52 165 51 2 51 18 51 881 52 70 51 50 52 646 51 472 52 45 51 14 51 1280 52 0.839170506912442 52 9105 10850 0.076514228767578 51 691 9031 0.064261136427044 51 691 10753 0.056360708534622 51 70 1242 0.68828125 52 881 1280   0 52 5 51 7 51 4 50 8 50 17 50 16 50 19 50 0 52 1 51 15 50 18 50 13 49 21 49 29 49 36 49 32 49 0 51 1 29 1536 365 1042 0 0 0 0 51 0 51 0 21 6 22 5 0 22 51 364 51 541 51 2 51 0 49 0 49 0 44 3 50 15 51 19 51
29827 PR 2022/05/02 0 16 49 2 14 49 9 64 8654 64 5577 65 279 64 24 65 18 62 17 64 8 62 459 65 22 64 15 65 213 64 183 65 66 64 55 64 657 64 0.626184423388029 64 5419 8654 0.051230260741829 64 279 5446 0.032790752535975 63 278 8478 0.035031847133758 63 22 628 0.698630136986301 64 459 657   0 64 2 63 0 63 1 62 4 63 4 62 4 63 8 63 1 65 0 62 2 60 0 60 1 60 2 60 3 60 5 60 4 60 1 62 0 10 60 10 66 0 5 0 1 62 5 62 0 8 6 8 53 0 8 62 542 64 1253 63 14 64 1 61 1 63 1 64 1 64 38 64 82 63
28228 CA 2022/01/30 17 130 269 152 227 37 234 408 66995 416 52785 416 14070 408 1415 416 418 408 58 399 20 407 6012 416 2495 408 2495 416 13677 408 13346 416 393 408 358 407 7280 416 0.787894619001418 416 52785 66995 0.269504089489915 408 14070 52207 0.212518502854726 408 14070 66206 0.351260030972828 408 2495 7103 0.825824175824176 416 6012 7280   23 410 123 401 145 399 119 400 180 398 275 397 263 397 282 398 5 407 6 404 29 394 31 392 39 391 65 390 78 390 86 389 84 390 0 408 49 150 8839 891 3490 394 0 16 5 402 6 402 6 364 6 364 44 9 363 402 829 119 3400 343 18 330 26 330 11 330 3 355 78 340 564 342 848 342
Powered by Datasette · Queries took 30.205ms · Data source: U.S. Department of Health & Human Services