DATA - THE MOST OVERWHELMED HOSPITALS IN THE US STATES JANUARY 2026.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1					Staffing Pressure			Bed Capacity and Saturation			Patient Volume and Churn	Clinical Complexity and Intensity
3	State	State Abbreviation	Total Population 2024	Total Hospital Beds	Registered Nurse Shortage (Demand - Supply, HRSA, 2024)	Registered Nurses per Hospital Bed	Patients per Registered Nurse (Care Load)	Beds per 10 k population	Admissions per Hospital Bed (Bed Turnover Pressure)	Average Length of Hospital Stay (days per admission)	Medicare Admissions per Hospital (Operational Throughput)	Average Patient Risk Score (HCC Severity Index)	Average Patient Risk Score (out of 10)	Hospital Overwhelm Index (Score out of 10)
4	Maryland	MD	6,263,220	11,236	12,860	4.0	2.9	17.9	15.0	6.1	3,839	2.12	8.8	9.12
5	Virginia	VA	8,811,195	17,554	28,720	3.1	2.8	19.9	11.6	5.0	2,870	1.94	5.5	8.79
6	South Carolina	SC	5,478,831	11,315	11,350	3.7	2.3	20.7	11.3	5.0	2,458	1.93	4.9	8.18
7	Florida	FL	23,372,215	56,303	10,500	3.7	2.0	24.1	10.4	5.0	3,473	2.34	9.6	8.16
8	Pennsylvania	PA	13,078,751	34,208	20,880	3.4	2.0	26.2	9.3	5.2	2,377	1.96	6.1	8.11
9	North Carolina	NC	11,046,024	21,921	16,010	4.1	1.7	19.8	9.4	5.6	2,459	1.98	6.7	8.11
10	California	CA	39,431,263	74,227	34,380	3.9	1.6	18.8	8.5	5.5	2,257	2.35	9.8	8.09
11	New Jersey	NJ	9,500,851	21,797	-420	3.8	1.9	22.9	10.4	5.8	3,609	2.29	9.4	8.01
12	New Hampshire	NH	1,409,032	2,870	1,820	4.1	2.3	20.4	12.6	5.6	2,772	1.80	2.4	7.90
13	Missouri	MO	6,245,466	17,687	8,920	3.1	2.0	28.3	8.5	5.3	2,286	2.03	7.7	7.81
14	Delaware	DE	1,051,917	2,534	-1,460	4.7	1.9	24.1	12.7	6.1	5,354	2.08	8.2	7.75
15	Washington	WA	7,958,180	12,358	7,210	5.0	1.5	15.5	9.8	6.0	2,571	1.89	4.3	7.73
16	Michigan	MI	10,140,459	24,095	13,440	3.7	1.6	23.8	8.3	5.2	2,222	2.09	8.4	7.68
17	Arizona	AZ	7,582,384	14,900	13,530	3.6	2.0	19.7	9.0	4.7	2,104	1.82	3.1	7.66
18	West Virginia	WV	1,769,979	6,319	4,940	2.5	2.4	35.7	8.4	5.3	2,117	1.90	4.5	7.65
19	Tennessee	TN	7,227,750	18,938	11,220	3.2	2.1	26.2	8.6	5.2	2,061	1.94	5.3	7.61
20	New York	NY	19,867,248	49,604	-700	3.8	1.7	25.0	8.6	6.5	3,239	2.24	9.0	7.58
21	Nevada	NV	3,267,467	6,397	240	4.2	1.7	19.6	9.5	5.4	2,752	2.12	8.6	7.56
22	Massachusetts	MA	7,136,171	15,657	-11,980	5.0	2.1	21.9	14.6	5.5	4,224	1.98	7.1	7.49
23	Oklahoma	OK	4,095,393	11,169	11,650	2.6	2.6	27.3	9.0	4.7	1,338	1.81	2.8	7.46
24	North Dakota	ND	796,568	3,257	-1,120	2.6	2.1	40.9	7.3	5.3	3,391	2.01	7.5	7.31
25	Iowa	IA	3,241,488	8,703	7,060	2.8	2.1	26.8	7.6	5.2	2,136	1.77	2.2	7.30
26	Georgia	GA	11,180,878	24,629	9,180	3.7	1.5	22.0	7.5	5.7	1,949	2.06	7.8	7.28
27	New Mexico	NM	2,130,256	3,516	5,690	3.7	1.9	16.5	8.7	5.1	1,056	1.87	3.9	7.15
28	Mississippi	MS	2,943,045	11,380	4,350	2.4	2.1	38.7	7.0	5.2	1,395	1.98	6.9	7.06
29	Kentucky	KY	4,588,372	14,336	11,010	2.9	1.9	31.2	7.3	5.2	1,694	1.96	5.9	7.05
30	Arkansas	AR	3,088,354	9,419	5,490	2.8	2.2	30.5	8.4	4.7	1,762	1.86	3.5	7.01
31	Nebraska	NE	2,005,465	6,737	1,760	2.5	2.2	33.6	7.2	5.2	2,024	1.73	1.6	6.92
32	Idaho	ID	2,001,619	3,643	7,190	2.8	2.0	18.2	7.1	4.5	1,722	1.59	0.8	6.91
33	Texas	TX	31,290,831	65,613	10,250	3.6	1.5	21.0	7.3	5.0	1,718	1.99	7.3	6.90
34	Connecticut	CT	3,675,069	7,565	-6,920	5.8	1.2	20.6	10.2	5.8	2,960	2.08	8.0	6.88
35	Louisiana	LA	4,597,740	14,247	12,480	2.5	1.9	31.0	6.6	5.0	1,118	1.96	6.3	6.86
36	Colorado	CO	5,957,493	11,247	11,320	3.3	1.6	18.9	6.9	4.9	1,556	1.74	1.8	6.73
37	Illinois	IL	12,710,158	30,464	-14,040	4.4	1.6	24.0	10.1	5.1	2,613	2.26	9.2	6.70
38	Kansas	KS	2,970,606	9,164	3,540	2.6	2.4	30.8	8.0	4.7	1,532	1.67	1.2	6.69
39	Indiana	IN	6,924,275	17,747	1,560	3.8	1.7	25.6	8.9	4.8	1,956	1.90	4.7	6.52
40	Alaska	AK	740,133	1,422	-3,630	7.1	1.2	19.2	10.7	7.0	1,895	1.58	0.6	6.42
41	Vermont	VT	648,493	1,308	-3,030	7.2	1.0	20.2	10.3	6.1	2,235	1.62	1.0	6.42
42	Ohio	OH	11,883,304	31,570	2,960	3.9	1.5	26.6	8.1	4.8	2,144	1.98	6.5	6.42
43	Wisconsin	WI	5,960,975	10,748	-3,740	5.6	1.3	18.0	9.9	5.2	1,582	1.96	5.7	6.33
44	Rhode Island	RI	1,112,308	2,144	-1,220	5.8	1.3	19.3	9.5	4.9	2,048	1.87	3.7	6.15
45	South Dakota	SD	924,669	4,085	-1,390	2.5	2.2	44.2	7.1	4.9	1,701	1.56	0.4	6.13
46	Maine	ME	1,405,012	3,466	1,550	3.8	1.3	24.7	6.6	6.1	1,348	1.82	2.9	6.10
47	Minnesota	MN	5,793,151	13,534	-4,890	4.4	1.3	23.4	7.5	5.6	2,221	1.93	5.1	6.09
48	Oregon	OR	4,272,371	7,086	-3,330	6.1	1.1	16.6	8.2	5.6	1,761	1.88	4.1	5.99
49	Montana	MT	1,137,233	3,667	-340	3.0	1.7	32.2	6.6	5.1	2,010	1.67	1.4	5.89
50	Hawaii	HI	1,446,146	2,780	-4,380	5.9	0.9	19.2	6.6	6.8	1,518	1.80	2.6	5.26
51	Utah	UT	3,503,613	5,823	1,010	4.3	1.2	16.6	6.5	4.2	1,184	1.76	2.0	5.00
52	Alabama	AL	5,157,699	15,509	-6,960	3.9	1.3	30.1	6.9	5.5	1,332	1.83	3.3	4.97
53	Wyoming	WY	587,618	1,901	-6,160	6.0	0.7	32.4	5.5	4.5	1,049	1.50	0.2	2.34
54
55	National Median			11,242	3,250	3.7	1.8	23.6	8.5	5.2	2,083	1.93
56
57	District of Columbia	DC	702,250	3,349	-5,080	3.3	1.6	47.7	6.7	7.6	3,725	2.45	#N/A	#N/A
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101