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 7 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_coverage 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	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
25162	TX	2022/08/21	5	96	485	8	93	485	124	581	62857	586	47229	586	3352	581	397	586	301	581	49	581	70	581	4967	586	566	581	480	586	3132	581	2780	586	220	581	152	581	5825	586	0.75137216220946	586	47229	62857	0.071798826200574	581	3352	46686	0.053947050776535	581	3352	62135	0.09959528418089	581	566	5683	0.852703862660944	586	4967	5825	7	584	32	581	29	580	27	580	47	580	78	580	80	580	101	580	16	586	2	579	19	576	29	575	27	576	31	575	53	575	43	575	37	575	60	581	22	574	344	0	114	0	13	581	11	581	97	97	94	8	97	581	3563	581	4127	581	30	579	9	574	18	575	581	27	581	865	581	1039	581
29679	TX	2022/08/07	6	104	482	9	101	482	119	587	63268	592	47624	592	3835	587	496	592	278	587	40	587	66	587	4988	592	551	587	499	592	3582	587	3261	592	253	587	194	587	5815	592	0.752734399696529	592	47624	63268	0.081554100034025	587	3835	47024	0.061318793770586	587	3835	62542	0.097092511013216	587	551	5675	0.857781599312124	592	4988	5815	6	590	30	587	26	586	38	586	59	586	85	586	112	586	110	586	72	592	1	585	10	582	12	581	28	582	41	581	48	581	51	581	38	581	49	587	20	582	333	0	85	0	8	587	7	587	102	102	83	6	102	587	3678	586	4313	586	19	585	12	580	18	581	587	43	587	924	587	1103	586
28171	TX	2022/08/05	5	107	481	10	102	481	126	588	64828	593	50159	593	3924	588	597	593	350	588	42	588	84	588	5222	593	565	588	519	593	3650	588	3372	593	274	588	204	588	5940	593	0.773724316653298	593	50159	64828	0.079221513365097	588	3924	49532	0.061220668996505	588	3924	64096	0.09743059148129	588	565	5799	0.879124579124579	593	5222	5940	10	591	38	588	42	588	41	588	81	588	102	587	129	587	123	587	68	593	3	586	14	582	34	582	32	582	52	582	54	582	57	582	56	582	48	588	23	582	333	0	85	0	6	588	12	588	103	103	81	6	103	588	3826	587	4383	587	26	586	12	581	18	581	588	40	588	930	588	1097	587
28801	TX	2022/08/04	5	107	481	8	104	481	156	588	65026	593	50539	593	3926	588	583	593	318	588	55	588	92	588	5318	593	543	588	516	593	3656	588	3365	593	270	588	193	588	6030	593	0.777212192046258	593	50539	65026	0.078664743127354	588	3926	49908	0.061067039975113	588	3926	64290	0.092205807437596	588	543	5889	0.881923714759536	593	5318	6030	8	591	43	588	32	588	44	588	60	588	99	588	149	587	142	587	69	593	3	586	15	583	20	582	26	582	34	582	55	582	59	582	60	582	46	588	18	581	333	0	85	0	6	588	14	588	104	104	80	8	104	588	3821	587	4397	587	39	586	13	581	18	582	588	36	588	912	588	1085	587
36179	TX	2022/02/10	14	110	472	15	109	472	142	591	67217	596	52994	596	9563	591	1126	596	396	591	86	591	132	591	6462	596	2196	591	2195	596	9157	591	8786	596	353	591	297	591	6870	596	0.788401743606528	596	52994	67217	0.18267779709259	591	9563	52349	0.143891062293109	591	9563	66460	0.328300194348931	591	2196	6689	0.94061135371179	596	6462	6870	4	595	74	593	69	593	78	593	133	594	252	593	221	593	218	593	77	596	4	590	34	588	47	588	37	588	50	589	85	588	67	588	65	588	7	591	131	585	4067	702	2107	31	20	591	23	591	114	114	106	18	114	591	3755	591	4291	591	41	591	27	588	18	588	591	61	591	955	591	1101	591
40126	TX	2022/02/09	14	110	472	15	109	472	142	591	67217	596	52994	596	9563	591	1126	596	396	591	86	591	132	591	6462	596	2196	591	2195	596	9157	591	8786	596	353	591	297	591	6870	596	0.788401743606528	596	52994	67217	0.18267779709259	591	9563	52349	0.143891062293109	591	9563	66460	0.328300194348931	591	2196	6689	0.94061135371179	596	6462	6870	4	595	74	593	69	593	78	593	133	594	252	593	221	593	218	593	77	596	4	590	34	588	47	588	37	588	50	589	85	588	67	588	65	588	7	591	131	585	4067	702	2107	31	20	591	23	591	114	114	106	18	114	591	3755	591	4291	591	41	591	27	588	18	588	591	61	591	955	591	1101	591
43824	TX	2022/02/18	12	108	476	13	107	476	115	591	68042	596	53394	596	6475	591	621	596	386	591	58	591	115	591	6185	596	1518	591	1473	596	6216	591	5667	596	259	591	212	591	6749	596	0.78472120161077	596	53394	68042	0.12267439657459	591	6475	52782	0.09624531779535	591	6475	67276	0.230804318078151	591	1518	6577	0.916432064009483	596	6185	6749	3	594	38	590	44	590	48	590	67	590	120	590	123	590	121	590	57	596	3	589	35	585	32	585	38	586	54	586	48	585	86	585	69	585	21	591	77	582	300	1	74	1	25	591	50	591	108	108	191	8	108	591	3981	591	4557	591	17	589	23	584	18	584	591	43	591	944	591	1108	591