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 2 rows (hide)

select rowid, state, date, critical_staffing_shortage_today_yes, critical_staffing_shortage_today_no, critical_staffing_shortage_today_not_reported, critical_staffing_shortage_anticipated_within_week_yes, critical_staffing_shortage_anticipated_within_week_no, critical_staffing_shortage_anticipated_within_week_not_reported, hospital_onset_covid, hospital_onset_covid_coverage, inpatient_beds, inpatient_beds_coverage, inpatient_beds_used, inpatient_beds_used_coverage, inpatient_beds_used_covid, inpatient_beds_used_covid_coverage, previous_day_admission_adult_covid_confirmed, previous_day_admission_adult_covid_confirmed_coverage, previous_day_admission_adult_covid_suspected, previous_day_admission_adult_covid_suspected_coverage, previous_day_admission_pediatric_covid_confirmed, previous_day_admission_pediatric_covid_confirmed_coverage, previous_day_admission_pediatric_covid_suspected, previous_day_admission_pediatric_covid_suspected_coverage, staffed_adult_icu_bed_occupancy, staffed_adult_icu_bed_occupancy_coverage, staffed_icu_adult_patients_confirmed_and_suspected_covid, staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage, staffed_icu_adult_patients_confirmed_covid, staffed_icu_adult_patients_confirmed_covid_coverage, total_adult_patients_hospitalized_confirmed_and_suspected_covid, total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage, total_adult_patients_hospitalized_confirmed_covid, total_adult_patients_hospitalized_confirmed_covid_coverage, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid, total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage, total_pediatric_patients_hospitalized_confirmed_covid, total_pediatric_patients_hospitalized_confirmed_covid_coverage, total_staffed_adult_icu_beds, total_staffed_adult_icu_beds_coverage, inpatient_beds_utilization, inpatient_beds_utilization_coverage, inpatient_beds_utilization_numerator, inpatient_beds_utilization_denominator, percent_of_inpatients_with_covid, percent_of_inpatients_with_covid_coverage, percent_of_inpatients_with_covid_numerator, percent_of_inpatients_with_covid_denominator, inpatient_bed_covid_utilization, inpatient_bed_covid_utilization_coverage, inpatient_bed_covid_utilization_numerator, inpatient_bed_covid_utilization_denominator, adult_icu_bed_covid_utilization, adult_icu_bed_covid_utilization_coverage, adult_icu_bed_covid_utilization_numerator, adult_icu_bed_covid_utilization_denominator, adult_icu_bed_utilization, adult_icu_bed_utilization_coverage, adult_icu_bed_utilization_numerator, adult_icu_bed_utilization_denominator, geocoded_state, [previous_day_admission_adult_covid_confirmed_18-19], [previous_day_admission_adult_covid_confirmed_18-19_coverage], [previous_day_admission_adult_covid_confirmed_20-29], [previous_day_admission_adult_covid_confirmed_20-29_coverage], [previous_day_admission_adult_covid_confirmed_30-39], [previous_day_admission_adult_covid_confirmed_30-39_coverage], [previous_day_admission_adult_covid_confirmed_40-49], [previous_day_admission_adult_covid_confirmed_40-49_coverage], [previous_day_admission_adult_covid_confirmed_50-59], [previous_day_admission_adult_covid_confirmed_50-59_coverage], [previous_day_admission_adult_covid_confirmed_60-69], [previous_day_admission_adult_covid_confirmed_60-69_coverage], [previous_day_admission_adult_covid_confirmed_70-79], [previous_day_admission_adult_covid_confirmed_70-79_coverage], [previous_day_admission_adult_covid_confirmed_80+], [previous_day_admission_adult_covid_confirmed_80+_coverage], previous_day_admission_adult_covid_confirmed_unknown, previous_day_admission_adult_covid_confirmed_unknown_coverage, [previous_day_admission_adult_covid_suspected_18-19], [previous_day_admission_adult_covid_suspected_18-19_coverage], [previous_day_admission_adult_covid_suspected_20-29], [previous_day_admission_adult_covid_suspected_20-29_coverage], [previous_day_admission_adult_covid_suspected_30-39], [previous_day_admission_adult_covid_suspected_30-39_coverage], [previous_day_admission_adult_covid_suspected_40-49], [previous_day_admission_adult_covid_suspected_40-49_coverage], [previous_day_admission_adult_covid_suspected_50-59], [previous_day_admission_adult_covid_suspected_50-59_coverage], [previous_day_admission_adult_covid_suspected_60-69], [previous_day_admission_adult_covid_suspected_60-69_coverage], [previous_day_admission_adult_covid_suspected_70-79], [previous_day_admission_adult_covid_suspected_70-79_coverage], [previous_day_admission_adult_covid_suspected_80+], [previous_day_admission_adult_covid_suspected_80+_coverage], previous_day_admission_adult_covid_suspected_unknown, previous_day_admission_adult_covid_suspected_unknown_coverage, deaths_covid, deaths_covid_coverage, on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses, on_hand_supply_therapeutic_b_bamlanivimab_courses, on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses, previous_week_therapeutic_a_casirivimab_imdevimab_courses_used, previous_week_therapeutic_b_bamlanivimab_courses_used, previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used, icu_patients_confirmed_influenza, icu_patients_confirmed_influenza_coverage, previous_day_admission_influenza_confirmed, previous_day_admission_influenza_confirmed_coverage, previous_day_deaths_covid_and_influenza, previous_day_deaths_covid_and_influenza_coverage, previous_day_deaths_influenza, previous_day_deaths_influenza_coverage, total_patients_hospitalized_confirmed_influenza, total_patients_hospitalized_confirmed_influenza_and_covid, total_patients_hospitalized_confirmed_influenza_and_covid_coverage, total_patients_hospitalized_confirmed_influenza_coverage, all_pediatric_inpatient_bed_occupied, all_pediatric_inpatient_bed_occupied_coverage, all_pediatric_inpatient_beds, all_pediatric_inpatient_beds_coverage, previous_day_admission_pediatric_covid_confirmed_0_4, previous_day_admission_pediatric_covid_confirmed_0_4_coverage, previous_day_admission_pediatric_covid_confirmed_12_17, previous_day_admission_pediatric_covid_confirmed_12_17_coverage, previous_day_admission_pediatric_covid_confirmed_5_11, previous_day_admission_pediatric_covid_confirmed_5_11_coverage, previous_day_admission_pediatric_covid_confirmed_unknown, previous_day_admission_pediatric_covid_confirmed_unknown_coverage, staffed_icu_pediatric_patients_confirmed_covid, staffed_icu_pediatric_patients_confirmed_covid_coverage, staffed_pediatric_icu_bed_occupancy, staffed_pediatric_icu_bed_occupancy_coverage, total_staffed_pediatric_icu_beds, total_staffed_pediatric_icu_beds_coverage from hospitals_state where "previous_day_admission_pediatric_covid_confirmed_5_11" = :p0 and "staffed_pediatric_icu_bed_occupancy_coverage" = :p1 order by total_pediatric_patients_hospitalized_confirmed_covid limit 101

Query parameters

This data as json, CSV

rowid	state	date	critical_staffing_shortage_today_yes	critical_staffing_shortage_today_no	critical_staffing_shortage_today_not_reported	critical_staffing_shortage_anticipated_within_week_yes	critical_staffing_shortage_anticipated_within_week_no	critical_staffing_shortage_anticipated_within_week_not_reported	hospital_onset_covid	hospital_onset_covid_coverage	inpatient_beds	inpatient_beds_coverage	inpatient_beds_used	inpatient_beds_used_coverage	inpatient_beds_used_covid	inpatient_beds_used_covid_coverage	previous_day_admission_adult_covid_confirmed	previous_day_admission_adult_covid_confirmed_coverage	previous_day_admission_adult_covid_suspected	previous_day_admission_adult_covid_suspected_coverage	previous_day_admission_pediatric_covid_confirmed	previous_day_admission_pediatric_covid_confirmed_coverage	previous_day_admission_pediatric_covid_suspected	previous_day_admission_pediatric_covid_suspected_coverage	staffed_adult_icu_bed_occupancy	staffed_adult_icu_bed_occupancy_coverage	staffed_icu_adult_patients_confirmed_and_suspected_covid	staffed_icu_adult_patients_confirmed_and_suspected_covid_coverage	staffed_icu_adult_patients_confirmed_covid	staffed_icu_adult_patients_confirmed_covid_coverage	total_adult_patients_hospitalized_confirmed_and_suspected_covid	total_adult_patients_hospitalized_confirmed_and_suspected_covid_coverage	total_adult_patients_hospitalized_confirmed_covid	total_adult_patients_hospitalized_confirmed_covid_coverage	total_pediatric_patients_hospitalized_confirmed_and_suspected_covid	total_pediatric_patients_hospitalized_confirmed_and_suspected_covid_coverage	total_pediatric_patients_hospitalized_confirmed_covid	total_pediatric_patients_hospitalized_confirmed_covid_coverage	total_staffed_adult_icu_beds	total_staffed_adult_icu_beds_coverage	inpatient_beds_utilization	inpatient_beds_utilization_coverage	inpatient_beds_utilization_numerator	inpatient_beds_utilization_denominator	percent_of_inpatients_with_covid	percent_of_inpatients_with_covid_coverage	percent_of_inpatients_with_covid_numerator	percent_of_inpatients_with_covid_denominator	inpatient_bed_covid_utilization	inpatient_bed_covid_utilization_coverage	inpatient_bed_covid_utilization_numerator	inpatient_bed_covid_utilization_denominator	adult_icu_bed_covid_utilization	adult_icu_bed_covid_utilization_coverage	adult_icu_bed_covid_utilization_numerator	adult_icu_bed_covid_utilization_denominator	adult_icu_bed_utilization	adult_icu_bed_utilization_coverage	adult_icu_bed_utilization_numerator	adult_icu_bed_utilization_denominator	geocoded_state	previous_day_admission_adult_covid_confirmed_18-19	previous_day_admission_adult_covid_confirmed_18-19_coverage	previous_day_admission_adult_covid_confirmed_20-29	previous_day_admission_adult_covid_confirmed_20-29_coverage	previous_day_admission_adult_covid_confirmed_30-39	previous_day_admission_adult_covid_confirmed_30-39_coverage	previous_day_admission_adult_covid_confirmed_40-49	previous_day_admission_adult_covid_confirmed_40-49_coverage	previous_day_admission_adult_covid_confirmed_50-59	previous_day_admission_adult_covid_confirmed_50-59_coverage	previous_day_admission_adult_covid_confirmed_60-69	previous_day_admission_adult_covid_confirmed_60-69_coverage	previous_day_admission_adult_covid_confirmed_70-79	previous_day_admission_adult_covid_confirmed_70-79_coverage	previous_day_admission_adult_covid_confirmed_80+	previous_day_admission_adult_covid_confirmed_80+_coverage	previous_day_admission_adult_covid_confirmed_unknown	previous_day_admission_adult_covid_confirmed_unknown_coverage	previous_day_admission_adult_covid_suspected_18-19	previous_day_admission_adult_covid_suspected_18-19_coverage	previous_day_admission_adult_covid_suspected_20-29	previous_day_admission_adult_covid_suspected_20-29_coverage	previous_day_admission_adult_covid_suspected_30-39	previous_day_admission_adult_covid_suspected_30-39_coverage	previous_day_admission_adult_covid_suspected_40-49	previous_day_admission_adult_covid_suspected_40-49_coverage	previous_day_admission_adult_covid_suspected_50-59	previous_day_admission_adult_covid_suspected_50-59_coverage	previous_day_admission_adult_covid_suspected_60-69	previous_day_admission_adult_covid_suspected_60-69_coverage	previous_day_admission_adult_covid_suspected_70-79	previous_day_admission_adult_covid_suspected_70-79_coverage	previous_day_admission_adult_covid_suspected_80+	previous_day_admission_adult_covid_suspected_80+_coverage	previous_day_admission_adult_covid_suspected_unknown	previous_day_admission_adult_covid_suspected_unknown_coverage	deaths_covid	deaths_covid_coverage	on_hand_supply_therapeutic_a_casirivimab_imdevimab_courses	on_hand_supply_therapeutic_b_bamlanivimab_courses	on_hand_supply_therapeutic_c_bamlanivimab_etesevimab_courses	previous_week_therapeutic_a_casirivimab_imdevimab_courses_used	previous_week_therapeutic_b_bamlanivimab_courses_used	previous_week_therapeutic_c_bamlanivimab_etesevimab_courses_used	icu_patients_confirmed_influenza	icu_patients_confirmed_influenza_coverage	previous_day_admission_influenza_confirmed	previous_day_admission_influenza_confirmed_coverage	previous_day_deaths_covid_and_influenza	previous_day_deaths_covid_and_influenza_coverage	previous_day_deaths_influenza	previous_day_deaths_influenza_coverage	total_patients_hospitalized_confirmed_influenza	total_patients_hospitalized_confirmed_influenza_and_covid	total_patients_hospitalized_confirmed_influenza_and_covid_coverage	total_patients_hospitalized_confirmed_influenza_coverage	all_pediatric_inpatient_bed_occupied	all_pediatric_inpatient_bed_occupied_coverage	all_pediatric_inpatient_beds	all_pediatric_inpatient_beds_coverage	previous_day_admission_pediatric_covid_confirmed_0_4	previous_day_admission_pediatric_covid_confirmed_0_4_coverage	previous_day_admission_pediatric_covid_confirmed_12_17	previous_day_admission_pediatric_covid_confirmed_12_17_coverage	previous_day_admission_pediatric_covid_confirmed_5_11	previous_day_admission_pediatric_covid_confirmed_5_11_coverage	previous_day_admission_pediatric_covid_confirmed_unknown	previous_day_admission_pediatric_covid_confirmed_unknown_coverage	staffed_icu_pediatric_patients_confirmed_covid	staffed_icu_pediatric_patients_confirmed_covid_coverage	staffed_pediatric_icu_bed_occupancy	staffed_pediatric_icu_bed_occupancy_coverage	total_staffed_pediatric_icu_beds	total_staffed_pediatric_icu_beds_coverage
24074	TX	2022/07/27	7	105	482	10	102	482	155	589	64773	594	50499	594	3970	589	596	594	271	589	50	589	61	589	5411	594	615	589	573	594	3722	589	3490	594	234	589	176	589	6069	594	0.779630401556204	594	50499	64773	0.079595805681978	589	3970	49877	0.061986697061487	589	3970	64046	0.103744939271255	589	615	5928	0.891580161476355	594	5411	6069		7	593	48	591	41	590	40	591	63	590	124	590	127	590	137	591	24	594	3	588	9	586	26	585	28	586	32	585	57	585	52	585	58	586	6	589	30	583	1987	660	692	0	0	0	5	589	11	589	0	105	0	105	35	11	105	589	3779	589	4324	589	40	589	7	584	13	584	0	589	33	589	921	589	1069	589
22220	TX	2022/07/29	6	104	484	10	100	484	148	589	65100	594	50609	594	4046	589	582	594	268	589	52	589	69	589	5373	594	601	589	561	594	3756	589	3497	594	268	589	196	589	6052	594	0.777403993855607	594	50609	65100	0.080913526917847	589	4046	50004	0.062853414528056	589	4046	64372	0.101657645466847	589	601	5912	0.887805684071381	594	5373	6052		4	591	40	589	49	587	43	588	74	587	94	587	140	587	145	588	28	594	5	586	23	584	24	582	26	584	36	583	60	582	53	582	38	583	3	589	31	581	327	0	114	0	0	0	7	589	13	589	0	105	0	105	73	9	105	589	3868	589	4373	589	39	587	12	581	13	582	0	589	46	589	940	589	1081	589