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 4 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
7618 SD 2021/01/03 1 61 3 1 61 3 46 62 2836 65 1546 65 273 62 23 65 16 62 0 62 2 62 147 65 55 62 50 65 273 62 247 65 0 62 0 62 245 65 0.545133991537377 65 1546 2836 0.179133858267717 62 273 1524 0.099272727272727 62 273 2750 0.235042735042735 62 55 234 0.6 65 147 245   0 65 0 65 2 65 0 65 5 65 5 65 5 65 5 65 1 65 0 62 1 62 0 62 2 62 2 62 3 62 6 62 2 62 0 62 4 62 237 672   52 98   0 62 0 62 0 62 10 62 2 0 62 62 257 62 379 62   0   0   0   0   0 32 62 83 62
48664 WA 2021/01/16 10 93 2 11 92 2 27 103 13594 105 9740 105 962 103 71 105 66 103 0 103 16 103 966 105 212 103 200 105 948 103 865 105 14 103 9 103 1346 105 0.716492570251582 105 9740 13594 0.09957561329055 103 962 9661 0.071508213781313 103 962 13453 0.16012084592145 103 212 1324 0.717682020802377 105 966 1346   1 105 1 104 5 104 9 104 10 104 21 104 6 104 18 104 0 105 0 103 2 102 6 102 3 102 5 102 14 102 12 101 3 102 21 103 10 103 255 476   0 22   1 103 0 103 0 103 10 103 2 2 103 103 853 102 2429 102   0   0   0   0   0 217 102 392 102
24947 NE 2022/04/08 17 69 13 24 73 2 3 98 4569 99 3297 99 73 98 3 99 13 98 0 98 2 98 347 99 4 98 4 99 71 98 51 99 2 98 0 98 479 99 0.721602101116218 99 3297 4569 0.022351500306185 98 73 3266 0.016168327796235 98 73 4515 0.008565310492505 98 4 467 0.724425887265136 99 347 479   0 99 0 91 0 91 0 91 0 91 1 91 1 91 3 91 0 99 0 98 3 90 0 90 1 90 1 90 3 90 3 90 2 90 0 98 0 80 756 20 737 0 0 0 0 98 8 98 0 80 10 80 19 0 80 98 307 98 373 98 0 98 0 90 0 90 0 98 0 98 125 98 153 98
25767 CA 2022/02/02 14 142 259 160 225 30 181 407 67660 415 54708 415 13322 407 1533 415 472 407 62 398 25 405 6187 415 2318 407 2319 415 12859 407 12598 415 402 407 375 406 7399 415 0.808572273130358 415 54708 67660 0.246329647572205 407 13322 54082 0.199207476635514 407 13322 66875 0.320874861572536 407 2318 7224 0.836194080281119 415 6187 7399   14 413 129 408 179 406 118 405 208 404 276 403 289 404 315 404 5 408 1 404 27 398 51 396 41 396 74 396 90 396 86 396 102 397 0 407 54 130 11094 1499 4597 335 0 43 6 407 3 407 10 360 10 359 46 5 358 407 2295 403 3650 405 26 394 19 392 17 392 0 397 88 404 596 405 916 405
Powered by Datasette · Queries took 49.687ms · Data source: U.S. Department of Health & Human Services