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 10 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
4325 ID 2021/02/12 5 39 8 5 39 8 1 51 3691 52 2111 52 168 51 18 52 5 51 1 51 0 51 197 52 38 51 36 52 166 51 156 52 2 51 2 51 305 52 0.571931725819561 52 2111 3691 0.080924855491329 51 168 2076 0.046014790468365 51 168 3651 0.127090301003344 51 38 299 0.645901639344262 52 197 305   0 52 1 52 0 52 2 52 3 52 4 52 8 52 0 52 0 52 0 51 0 51 0 51 0 51 0 51 1 51 3 51 1 51 0 51 4 51 387 1294   6 62   0 51 0 51 0 51 77 51 0 0 51 51 241 30 707 30   0   0   0   0   0 64 30 228 30
6843 ID 2021/02/14 5 39 8 5 39 8 1 51 3680 52 1972 52 177 51 18 52 6 51 0 51 1 51 169 52 41 51 40 52 173 51 162 52 4 51 2 51 305 52 0.535869565217391 52 1972 3680 0.091190108191654 51 177 1941 0.048639736191261 51 177 3639 0.137123745819398 51 41 299 0.554098360655738 52 169 305   0 52 0 51 2 51 4 51 2 51 3 51 4 51 3 51 0 52 0 51 0 50 0 50 0 50 2 50 1 50 3 50 0 50 0 51 0 51 312 884   5 24   0 51 0 51 0 51 77 51 0 0 51 51 247 35 715 35   0   0   0   0   0 67 35 227 35
7448 ID 2021/02/11 5 39 8 5 39 8 1 51 3705 52 2179 52 171 51 25 52 3 51 0 51 0 51 206 52 39 51 39 52 169 51 162 52 2 51 2 51 304 52 0.588124156545209 52 2179 3705 0.079646017699115 51 171 2147 0.046683046683047 51 171 3663 0.130872483221477 51 39 298 0.677631578947368 52 206 304   0 52 2 52 3 52 2 52 1 52 6 52 8 52 2 52 1 52 0 51 0 51 1 51 0 51 0 51 0 51 1 51 1 51 0 51 1 51 321 916   6 46   0 51 0 51 0 51 77 51 0 0 51 51 257 30 710 30   0   0   0   0   0 68 30 228 30
6117 ID 2021/02/13 5 39 8 5 39 8 1 51 3649 52 1997 52 178 51 30 52 7 51 1 51 0 51 180 52 41 51 38 52 176 51 165 52 2 51 2 51 284 52 0.547273225541244 52 1997 3649 0.090631364562118 51 178 1964 0.049321141590468 51 178 3609 0.147482014388489 51 41 278 0.633802816901408 52 180 284   1 52 2 52 2 52 1 52 6 52 7 52 7 52 4 52 0 52 0 51 1 51 0 51 3 51 1 51 0 51 1 51 1 51 0 51 2 51 320 900   9 56   0 51 0 51 0 51 77 51 0 0 51 51 237 35 706 35   0   0   0   0   0 62 35 225 35
5095 ID 2021/02/10 5 46 1 5 46 1 1 51 3705 52 2222 52 180 51 21 52 3 51 0 51 0 51 210 52 47 51 45 52 176 51 167 52 4 51 3 51 306 52 0.599730094466937 52 2222 3705 0.082379862700229 51 180 2185 0.049113233287858 51 180 3665 0.156666666666667 51 47 300 0.686274509803922 52 210 306   0 52 2 52 1 52 0 52 4 52 4 52 8 52 2 52 0 52 0 51 0 51 0 51 0 51 0 51 0 51 2 51 1 51 0 51 1 51 702 2239   31 96   0 51 0 51 0 51 77 51 0 0 51 51 259 30 709 30   0   0   0   0   0 72 30 227 30
6798 ID 2021/02/07 4 40 8 4 40 8 1 51 3675 52 1981 52 174 51 24 52 2 51 0 51 0 51 178 52 36 51 36 52 171 51 168 52 3 51 3 51 307 52 0.539047619047619 52 1981 3675 0.088957055214724 51 174 1956 0.047920683007436 51 174 3631 0.12 51 36 300 0.579804560260586 52 178 307   0 52 0 52 0 52 3 52 3 52 2 52 9 52 6 52 1 52 0 51 0 51 0 51 0 51 0 51 0 51 0 51 0 51 2 51 1 51 318 919   5 58   0 51 0 51 0 51 77 51 1 0 51 51 256 34 722 34   0   0   0   0   0 72 34 225 34
5019 ID 2021/02/06 5 39 8 5 39 8 1 51 3688 52 2012 52 179 51 22 52 4 51 1 51 0 51 179 52 40 51 39 52 176 51 170 52 3 51 3 51 287 52 0.545553145336226 52 2012 3688 0.090312815338042 51 179 1982 0.049108367626886 51 179 3645 0.142348754448399 51 40 281 0.623693379790941 52 179 287   0 52 1 52 5 52 1 51 4 52 7 52 3 51 1 52 0 52 0 51 0 51 0 51 0 51 0 51 1 50 3 51 0 51 0 51 1 51 321 904   7 61   0 51 0 51 0 51 77 51 2 1 51 51 255 33 745 33   0   0   0   0   0 78 33 229 33
5877 ID 2021/02/04 5 39 8 5 39 8 2 51 3698 52 2210 52 196 51 18 52 6 51 0 51 0 51 194 52 42 51 40 52 193 51 174 52 3 51 3 51 305 52 0.597620335316387 52 2210 3698 0.090197883110907 51 196 2173 0.053610503282276 51 196 3656 0.140468227424749 51 42 299 0.636065573770492 52 194 305   0 52 0 52 0 52 1 52 4 52 3 52 4 52 6 52 0 52 0 51 0 51 0 51 2 51 0 51 2 51 2 51 0 51 0 51 2 51 324 929   7 59   0 51 0 51 0 51 77 51 2 1 51 51 306 29 716 29   0   0   0   0   0 90 29 230 29
8216 ID 2021/02/05 5 39 8 5 39 8 1 51 3702 52 2119 52 188 51 32 52 4 51 0 51 0 51 192 52 45 51 43 52 185 51 178 52 3 51 3 51 304 52 0.572393300918422 52 2119 3702 0.089952153110048 51 188 2090 0.051366120218579 51 188 3660 0.151006711409396 51 45 298 0.631578947368421 52 192 304   0 52 0 52 0 52 0 52 5 52 2 52 13 52 12 52 0 52 0 51 0 51 1 51 0 51 0 51 1 51 1 51 1 51 0 51 2 51 321 939   7 61   0 51 0 51 0 51 77 51 2 1 51 51 272 30 717 30   0   0   0   0   0 80 30 228 30
3531 ID 2021/02/03 5 46 1 5 46 1 1 51 3709 52 2256 52 207 51 20 52 4 51 0 51 0 51 201 52 43 51 41 52 204 51 193 52 3 51 3 51 302 52 0.608250202210838 52 2256 3709 0.093159315931593 51 207 2222 0.056403269754768 51 207 3670 0.14527027027027 51 43 296 0.665562913907285 52 201 302   0 52 1 52 2 52 1 52 4 52 4 52 3 52 5 52 0 52 0 51 0 51 0 51 0 51 0 51 2 51 1 51 1 51 0 51 4 51 719 2319   93 101   0 51 0 51 0 51 77 51 2 1 51 51 279 29 710 29   0   0   0   0   0 83 29 230 29
Powered by Datasette · Queries took 100.172ms · Data source: U.S. Department of Health & Human Services