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 5 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 order by previous_day_admission_influenza_confirmed 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	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	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_coverage	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_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
25594	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	3	589	10	589	105	105	97	8	105	589	3790	589	4408	589	22	587	9	582	16	582	589	40	589	916	589	1056	589
29797	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	8	589	11	589	104	104	74	10	104	589	3619	589	4241	589	33	587	8	581	16	582	589	44	589	893	589	1079	589
27070	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	10	495	20	495	91	91	108	7	91	495	3637	495	4157	495	31	494	15	490	16	491	495	30	495	930	495	1080	495
31021	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	4	590	22	590	105	105	105	8	105	590	3881	590	4455	590	38	588	9	583	16	584	590	30	590	913	590	1066	590
45444	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	19	591	32	591	111	111	107	12	111	591	3837	591	4402	591	34	591	11	587	16	587	591	45	591	953	591	1111	591