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 (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_deaths_influenza" = :p0 order by inpatient_beds_utilization 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_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	previous_week_therapeutic_a_casirivimab_imdevimab_courses_used	previous_week_therapeutic_b_bamlanivimab_courses_used	icu_patients_confirmed_influenza_coverage	previous_day_admission_influenza_confirmed_coverage	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	staffed_pediatric_icu_bed_occupancy	staffed_pediatric_icu_bed_occupancy_coverage	total_staffed_pediatric_icu_beds	total_staffed_pediatric_icu_beds_coverage
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	51	0	50	0	50	0	50	2	50	1	50	3	50	0	50	0	51	0	51	312	884	5	24	51	51	51	77	51	0	0	51	51	247	35	715	35	67	35	227	35
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	51	0	51	0	51	0	51	0	51	0	51	0	51	0	51	2	51	1	51	318	919	5	58	51	51	51	77	51	1	0	51	51	256	34	722	34	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	51	0	51	0	51	0	51	0	51	1	50	3	51	0	51	0	51	1	51	321	904	7	61	51	51	51	77	51	2	1	51	51	255	33	745	33	78	33	229	33
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	51	1	51	0	51	3	51	1	51	0	51	1	51	1	51	0	51	2	51	320	900	9	56	51	51	51	77	51	0	0	51	51	237	35	706	35	62	35	225	35
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	51	0	51	0	51	0	51	0	51	1	51	3	51	1	51	0	51	4	51	387	1294	6	62	51	51	51	77	51	0	0	51	51	241	30	707	30	64	30	228	30
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	51	0	51	1	51	0	51	0	51	1	51	1	51	1	51	0	51	2	51	321	939	7	61	51	51	51	77	51	2	1	51	51	272	30	717	30	80	30	228	30
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	51	0	51	1	51	0	51	0	51	0	51	1	51	1	51	0	51	1	51	321	916	6	46	51	51	51	77	51	0	0	51	51	257	30	710	30	68	30	228	30
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	51	0	51	0	51	2	51	0	51	2	51	2	51	0	51	0	51	2	51	324	929	7	59	51	51	51	77	51	2	1	51	51	306	29	716	29	90	29	230	29
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	51	0	51	0	51	0	51	0	51	0	51	2	51	1	51	0	51	1	51	702	2239	31	96	51	51	51	77	51	0	0	51	51	259	30	709	30	72	30	227	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	51	0	51	0	51	0	51	0	51	2	51	1	51	1	51	0	51	4	51	719	2319	93	101	51	51	51	77	51	2	1	51	51	279	29	710	29	83	29	230	29