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 8 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 inpatient_beds_used_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	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
25206	TX	2022/08/28	6	83	494	8	81	494	108	578	62563	583	47484	583	3059	578	359	583	237	578	47	578	110	578	5039	583	427	578	390	583	2790	578	2485	583	274	578	166	578	5868	583	0.758978949219187	583	47484	62563	0.065212756885819	578	3059	46908	0.049467164734229	578	3059	61839	0.074507066829524	578	427	5731	0.858725289706885	583	5039	5868	5	582	23	579	21	578	36	578	33	578	65	577	67	577	98	577	22	583	3	577	22	574	23	573	26	573	27	573	38	572	46	572	45	572	7	578	16	574	370	0	114	0	0	0	11	578	25	578	0	93	0	93	107	7	93	578	3820	578	4275	578	28	577	12	573	15	574	0	578	34	578	941	578	1070	578
24169	TX	2022/08/25	6	84	493	8	82	493	115	578	64238	583	49938	583	3220	578	424	583	229	578	46	578	91	578	5282	583	461	578	418	583	2961	578	2618	583	246	578	178	578	6063	583	0.777390329711386	583	49938	64238	0.065289239441189	578	3220	49319	0.050695887650356	578	3220	63516	0.07779277759028	578	461	5926	0.871185881576777	583	5282	6063	4	582	37	578	29	578	40	578	46	578	76	577	86	577	103	577	18	583	2	577	16	573	21	573	25	573	31	573	47	572	39	572	42	572	6	578	13	574	370	0	114	0	0	0	9	578	25	578	0	96	0	96	104	10	96	578	3700	578	4198	578	33	577	7	573	15	573	0	578	30	578	897	578	1045	578
30016	TX	2022/08/13	7	103	482	8	102	482	136	587	64356	592	48829	592	3437	587	512	592	298	587	35	587	74	587	5121	592	511	587	465	592	3194	587	2869	592	213	587	161	587	5898	592	0.758732674498104	592	48829	64356	0.071243496465808	587	3437	48243	0.054011157381944	587	3437	63635	0.088715277777778	587	511	5760	0.868260427263479	592	5121	5898	3	589	29	586	44	585	35	585	36	585	81	585	128	586	122	585	51	592	1	584	11	581	29	580	31	580	33	580	47	580	63	581	32	580	51	587	25	579	413	0	35	0	0	0	9	587	19	587	0	105	0	105	79	9	105	587	3716	587	4322	587	20	585	8	580	15	581	0	587	28	587	917	587	1081	587
30315	TX	2022/07/11	7	79	417	9	77	417	120	498	58133	503	44219	503	3561	498	508	503	208	498	62	498	71	498	5069	503	509	498	442	503	3334	498	3038	503	227	498	153	498	5783	503	0.760652297318219	503	44219	58133	0.081629378323858	498	3561	43624	0.062026440925955	498	3561	57411	0.090216235377526	498	509	5642	0.876534670586201	503	5069	5783	2	501	37	497	41	497	33	497	49	497	93	497	108	497	119	497	32	503	2	496	16	492	20	492	32	493	24	492	41	492	36	492	30	492	7	498	17	492	330	0	85	0	0	0	2	498	15	498	0	93	0	93	100	9	93	498	3375	498	4045	498	32	496	15	492	15	492	0	498	35	498	886	498	1046	498
36364	TX	2022/02/21	10	80	414	12	78	414	108	499	60008	504	46392	504	5570	499	427	504	348	499	46	499	77	499	5818	504	1324	499	1270	504	5419	499	4954	504	219	499	177	499	6497	504	0.773096920410612	504	46392	60008	0.121570596066962	499	5570	45817	0.094005265645042	499	5570	59252	0.209394274869524	499	1324	6323	0.895490226258273	504	5818	6497	4	502	27	500	36	500	30	500	45	500	82	500	77	500	92	500	34	504	4	497	37	495	32	495	32	496	60	496	57	495	60	495	48	495	18	499	68	494	313	0	6	2	0	0	24	499	49	499	0	96	0	96	187	8	96	499	3392	499	3990	499	17	497	14	495	15	495	0	499	46	499	899	499	1060	499
40965	FL	2022/02/07	9	161	72	41	140	61	247	236	57001	242	45754	242	7334	236	831	242	242	236	62	236	24	236	5266	242	1142	236	1135	242	7164	236	6812	242	170	236	157	236	6617	242	0.802687672146103	242	45754	57001	0.16295967114765	236	7334	45005	0.130763470384766	236	7334	56086	0.176971951030528	236	1142	6453	0.795828925494937	242	5266	6617	1	234	38	231	52	232	54	232	97	232	153	236	197	233	192	234	47	242	4	234	16	225	16	225	26	225	30	226	44	224	46	225	45	225	15	236	51	133	4235	69	3771	1546	237	318	10	236	10	236	1	123	1	123	78	9	123	236	1726	236	2629	236	21	236	23	225	15	227	3	236	30	236	590	236	876	236
45430	TX	2022/02/06	12	109	474	17	104	474	202	590	65002	595	49313	595	10591	590	1111	595	371	590	80	589	109	589	6186	595	2360	590	2350	595	10177	590	9658	595	368	590	295	590	6655	595	0.758638195747823	595	49313	65002	0.217393981690546	590	10591	48718	0.164855862026026	590	10591	64244	0.364591379576703	590	2360	6473	0.929526671675432	595	6186	6655	9	592	70	590	74	590	78	590	128	590	228	591	227	590	218	590	79	595	7	588	18	585	23	585	39	585	43	585	56	585	73	585	55	585	57	590	152	579	314	1	114	0	0	0	17	590	19	590	0	182	0	182	146	16	182	590	3434	590	3997	590	32	588	33	584	15	584	0	589	58	589	941	590	1103	590
39396	CA	2022/02/01	15	84	277	152	185	39	175	368	64853	376	52070	376	13529	368	1544	376	488	368	62	362	21	368	6133	376	2397	368	2400	376	13163	368	12836	376	366	368	341	367	7377	376	0.802892695788938	376	52070	64853	0.26299010555372	368	13529	51443	0.211146486874551	368	13529	64074	0.332593312057722	368	2397	7207	0.831367764673987	376	6133	7377	19	375	133	372	160	373	121	372	218	370	297	371	301	370	283	373	12	369	5	368	33	365	45	365	38	365	74	364	102	365	79	365	112	365	0	368	56	113	8808	581	3527	352	0	16	7	365	7	365	2	341	2	341	47	4	340	365	754	104	3367	338	18	331	26	331	15	330	3	336	67	334	590	336	908	338