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.

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	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
26788	CA	2022/12/19	8	91	261	94	202	64	87	351	62625	359	48440	359	4937	351	601	360	343	360	22	352	16	350	4996	359	532	351	491	359	4797	351	4301	359	140	351	112	351	6565	359	0.773493013972056	359	48440	62625	0.103286679637649	351	4937	47799	0.079789898989899	351	4937	61875	0.083086053412463	351	532	6403	0.761005331302361	359	4996	6565	1	358	31	356	48	355	29	355	66	355	77	355	147	355	198	356	6	360	5	359	20	355	24	355	36	355	36	355	71	355	68	355	79	355	6	347	12	97	2152	1187	506	0	200	357	242	357	0	72	13	288	1373	92	288	356	2698	351	3815	351	8	351	5	348	8	347	2	351	29	351	751	351	1016	351
36855	CA	2022/02/16	11	129	275	137	243	35	104	407	66986	415	53840	415	7768	407	769	415	407	407	35	399	6	404	5710	415	1440	407	1422	415	7584	407	7202	415	214	407	196	406	7201	415	0.803750037321231	415	53840	66986	0.14599857158967	407	7768	53206	0.117344934892293	407	7768	66198	0.204894706886739	407	1440	7028	0.792945424246632	415	5710	7201	7	411	63	405	80	405	67	405	127	404	124	403	142	403	156	403	3	412	4	404	25	397	35	397	26	397	68	397	99	397	81	397	69	396	0	406	32	127	10797	1647	4421	321	5	407	2	407	13	354	13	354	47	3	354	407	2455	404	3733	404	18	397	10	393	7	392	0	398	45	403	655	404	961	404
37366	KY	2022/03/11	22	91	4	29	85	3	2	115	12033	117	8782	117	577	115	55	117	63	115	1	115	9	115	1164	117	102	115	95	117	554	115	473	117	23	115	9	115	1412	117	0.729826310978143	117	8782	12033	0.066658964879852	115	577	8656	0.048585382283597	115	577	11876	0.074670571010249	115	102	1366	0.824362606232295	117	1164	1412	0	116	2	114	5	114	6	114	12	114	27	114	26	114	13	114	9	117	2	114	4	112	6	112	7	112	14	112	17	112	16	112	12	112	0	115	8	105	24	0	50	0	5	115	6	115	0	105	13	75	24	3	105	115	494	115	695	115	0	114	1	112	0	112	0	115	3	115	46	115	62	115
46526	KY	2022/02/06	37	76	4	44	70	3	59	115	11819	117	8577	117	2327	115	188	117	90	115	5	115	13	115	1226	117	417	115	407	117	2276	115	2131	117	51	115	22	115	1415	117	0.725695913359844	117	8577	11819	0.275319451017511	115	2327	8452	0.199931265572644	115	2327	11639	0.3050475493782	115	417	1367	0.86643109540636	117	1226	1415	1	117	12	116	16	116	17	116	38	116	75	116	71	116	49	116	178	117	3	115	10	114	6	114	10	114	10	114	22	114	25	114	17	114	0	115	47	107	25	0	40	0	0	115	3	115	0	107	13	70	20	1	107	115	336	115	646	115	2	115	3	114	0	114	0	115	1	115	37	115	57	115

COVID-19 Reported Patient Impact and Hospital Capacity by State

Custom SQL query returning 4 rows (show)

Query parameters