Coronavirus - Statewide Available PPE and Bed Tracking

Statewide Available PPE and Bed Tracking

Note: Data on this page will now be updated Monday - Friday due to furloughs.

Statewide Available Bed Tracking for COVID-19* 05/19/2020**
	Total Number of Hospital Beds	Hospital Inpatient Beds	Hospital Inpatient Bed Occupied	ICU Beds	ICU Bed Occupied	Negative Pressure Isolation Total	Negative Pressure Isolation Available	Total Ventilators	Available Ventilators	Available Operating Room	Available Adult Med/Surg	Available Burn Care	Available Pediatric	Available Psych.	Total Morgue Capacity	Morgue Available
Region 1	1,701	1,523	935	204	133	212	143	222	43	179	32	261	0	31	48	43
Region 2N	5,161	4,947	3,342	536	358	366	149	657	198	450	75	677	0	75	89	212
Region 2S	7,268	6,309	4,700	1,031	680	565	134	1,261	496	789	85	797	4	88	51	471
Region 3	2,971	2,469	1,649	370	261	262	128	346	124	224	74	619	1	125	26	112
Region 5	2,127	1,518	1,105	182	119	269	136	224	56	168	45	403	10	53	79	34
Region 6	2,678	2,320	1,508	411	253	219	109	450	96	356	112	544	48	87	25	113
Region 7	1,001	975	470	107	67	172	130	93	27	67	38	333	0	27	11	30
Region 8	674	567	251	59	38	109	78	94	6	89	37	253	13	37	20	31
Total	23,581	20,628	13,960	2,900	1,909	2,174	1,007	3,347	1,046	2,322	498	3,887	76	523	349	1,046

*95% response rate
** Data is preliminary and subject to change.

**COVID-19 Metrics**
HCC Region	Region 1	Region 2 North	Region 2 South	Region 3	Region 5	Region 6	Region 7	Region 8	Total
# of ED Discharges	107	90	151	56	46	102	17	11	580
# In Critical Care	21	125	202	58	27	48	7	4	492
# on Ventilators	18	89	144	34	14	29	3	1	332
# of Inpatients	42	272	450	118	61	119	4	0	1066

Statewide Hospital Available PPE Tracking for COVID-19* 05/19/2020**
	CAPRs	Coveralls	Elastomeric Respirator	Elastomeric Respirator Filters	Face Shields	Gloves	Goggles	N95 Respirator Masks	PAPR Batteries	PAPR Filters	PAPRs	Surgical Gowns	Surgical Isolation Gowns	Surgical Masks/ Facemasks
Region 1	50	49,879	77	21	131,639	1,583,380	5,656	107,153	214	411	112	21,491	104,622	1,089,357
Region 2N	145	10,397	24	73	141,875	6,640,351	20,355	214,703	341	602	318	77,027	213,305	483,188
Region 2S	109	29,245	2	1,815	275,349	3,859,755	19,938	527,688	806	1,293	869	45,134	297,798	1,717,189
Region 3	235	3,219	8	12	95,017	4,875,166	33,991	196,446	209	406	158	19,025	262,053	902,122
Region 5	157	1,895	23	40	22,913	1,427,868	8,346	64,261	258	314	179	10,892	49,040	134,804
Region 6	136	1,695	14	36	139,230	22,956,306	41,471	311,877	401	915	371	73,186	51,934	4,399,445
Region 7	46	3,440	0	0	93,026	4,787,874	9,090	57,156	290	264	210	26,280	27,153	613,526
Region 8	4	2,027	45	197	30,189	2,058,629	1,159	83,348	146	351	153	9,491	41,394	259,271
Total	882	101,797	193	2,194	929,238	48,189,329	140,006	1,562,632	2,665	4,556	2,370	282,526	1,047,299	9,598,902

*84% Reporting

**Data is preliminary and subject to change
.

Data is self-reported by hospitals daily to the EM Resource System per MDHHS Director Robert Gordon’s Emergency Order.
Changes in inventory numbers have likely occurred since reporting was completed.
This information will be updated daily by 7 p.m.
Information about Healthcare Coalition Regions is available on the MDHHS website.

Region1 – Clinton, Eaton, Gratiot, Hillsdale, Ingham, Jackson, Lenawee, Livingston and Shiawassee counties.
Region 2S – City of Detroit and Monroe, Washtenaw and Wayne counties.
Region 2N - Macomb, Oakland and St. Clair counties.
Region 3 - Saginaw, Alcona, Iosco, Ogemaw, Arenac, Gladwin, Midland, Bay, Genesee, Tuscola, Lapeer, Sanilac and Huron counties.
Region 5 - Allegan, Barry, Calhoun, Branch, St. Joseph, Cass, Berrien, Van Buren and Kalamazoo counties.
Region 6 - Clare, Ionia, Isabella, Kent, Lake, Mason, Mecosta, Montcalm, Muskegon, Newaygo, Oceana, Osceola and Ottawa counties.
Region 7 - Manistee, Wexford, Missaukee, Roscommon, Benzie, Leelanau, Grand Traverse, Kalkaska, Crawford, Oscoda, Antrim, Otsego, Montmorency, Alpena, Presque Ilse, Cheboygan, Emmet and Charlevoix counties.
Region 8 - Chippewa, Mackinac, Luce, Schoolcraft, Delta, Alger, Marquette, Dickinson, Menominee, Baraga, Iron, Gogebic, Ontonagon, Houghton and Keweenaw counties.

**PPE Days On Hand as of 05/18/2020**
Health System/Hospital	N95 Masks	Surgical Masks	Surgical Gowns	Shields	Gloves	System/Independent
Ascension	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
Aspirus	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
Baraga County Memorial Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Beaumont	21+ days	0-6 days	7-14 days	21+ days	15-21 days	Health System
Bronson	21+ days	7-14 days	21+ days	21+ days	7-14 days	Health System
Covenant	21+ days	21+ days	21+ days	21+ days	15-21 days	Health System
Deckerville Community Hospital	21+ days	15-21 days	21+ days	21+ days	21+ days	Independent
Detroit Medical Center	21+ days	7-14 days	21+ days	21+ days	7-14 days	Health System
Dickinson Memorial Health Care System	21+ days	21+ days	7-14 days	21+ days	21+ days	Independent
Eaton Rapids Medical Center	21+ days	15-21 days	15-21 days	21+ days	21+ days	Independent
Harbor Beach Community Hospital	21+ days	15-21 days	21+ days	21+ days	21+ days	Independent
Helen Newberry Joy Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Henry Ford Health System	21+ days	7-14 days	21+ days	21+ days	7-14 days	Health System
Hills and Dales General Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Hillsdale Hospital	15-21 days	15-21 days	21+ days	21+ days	21+ days	Independent
Holland Community Hospital	21+ days	21+ days	15-21 days	21+ days	21+ days	Independent
Hurley Medical Center	21+ days	0-6 days	0-6 days	21+ days	21+ days	Health System
Kalkaska Memorial Health Center	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Mackinac Straits Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Marlette Regional Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
McKenzie Memorial Hospital	21+ days	21+ days	15-21 days	21+ days	21+ days	Independent
McLaren	21+ days	15-21 days	21+ days	21+ days	21+ days	Health System
Memorial Healthcare	15-21 days	7-14 days	15-21 days	21+ days	21+ days	Independent
Metro	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
Michigan Medicine	21+ days	21+ days	15-21 days	7-14 days	0-6 days	Health System
MidMichigan Health	7-14 days	0-6 days	15-21 days	21+ days	0-6 days	Health System
Munising Memorial Hospital	21+ days	0-6 days	21+ days	21+ days	21+ days	Independent
Munson Health System	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
North Ottawa Community Hosp	21+ days	7-14 days	15-21 days	21+ days	21+ days	Independent
OSF St. Francis Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Oaklawn Hospital	21+ days	15-21 days	21+ days	0-6 days	21+ days	Independent
Pontiac General Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Prime Health	21+ days	15-21 days	21+ days	21+ days	7-14 days	Health System
ProMedica	21+ days	15-21 days	15-21 days	21+ days	7-14 days	Health System
Scheurer Hospital	21+ days	0-6 days	21+ days	21+ days	21+ days	Independent
Schoolcraft Memorial Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Sheridan Community Hospital	21+ days	0-6 days	7-14 days	21+ days	7-14 days	Independent
Sparrow Health System	21+ days	21+ days	21+ days	21+ days	7-14 days	Health System
Spectrum	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
Straith Hospital	7-14 days	7-14 days	21+ days	21+ days	21+ days	Independent
Sturgis Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Three Rivers Health	0-6 days	15-21 days	21+ days	21+ days	21+ days	Independent
Trinity	21+ days	7-14 days	21+ days	21+ days	15-21 days	Health System
UP Health	21+ days	7-14 days	21+ days	21+ days	21+ days	Health System
War Memorial Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent

Patient Census as of 05/18/2020
Health System/Hospital	COVID-19 Patients	COVID-19 Patients in ICU	Bed Occupancy
Ascension	144	45	64%
Aspirus	0	0	24%
Baraga County Memorial Hospital	0	0	20%
Beaumont	283	84	71%
Bronson	19	10	60%
Covenant	4	11	64%
Deckerville Community Hospital	0	0	0%
Detroit Medical Center	122	53	84%
Dickinson Memorial Health Care System	1	1	35%
Eaton Rapids Medical Center	0	0	5%
Harbor Beach Community Hospital	0	0	0%
Helen Newberry Joy Hospital	0	0	12%
Henry Ford Health System	143	63	59%
Hills and Dales General Hospital	1	0	26%
Hillsdale Hospital	3	2	31%
Holland Community Hospital	12	3	59%
Hurley Medical Center	17	12	67%
Kalkaska Memorial Health Center	0	0	25%
Mackinac Straits Hospital	0	0	7%
Marlette Regional Hospital	0	0	20%
McKenzie Memorial Hospital	0	0	8%
McLaren	107	42	64%
Memorial Healthcare	3	0	34%
Metro	9	4	53%
Michigan Medicine	52	38	80%
MidMichigan Health	38	9	44%
Munising Memorial Hospital	0	0	21%
Munson Health System	2	2	48%
North Ottawa Community Hosp	0	0	20%
Oaklawn Hospital	0	0	27%
OSF St. Francis Hospital	0	0	12%
Pontiac General Hospital	0	0	5%
Prime Health	18	4	41%
ProMedica	6	6	53%
Scheurer Hospital	0	0	15%
Schoolcraft Memorial Hospital	0	0	42%
Sheridan Community Hospital	0	0	7%
Sparrow Health System	26	6	58%
Spectrum	78	23	56%
Straith Hospital	1	0	21%
Sturgis Hospital	4	0	0%
Three Rivers Health	4	0	32%
Trinity	189	48	74%
UP Health	2	1	68%
War Memorial Hospital	0	0	25%
Grand Total	1,288	467	62%

This information has been compiled by the Michigan Health & Hospital Association (MHA) on behalf of the Michigan Department of Health & Human Services (MDHHS). The data is from the state of Michigan's EMResource data system. Hospitals are required to enter data into EMResource. The data reflects the status in the hospital or health system from the previous 48 hour period.General Information:Tableau Dashboard of Health System/Hospital Data

The information is aggregated by health system for those hospitals that are part of a health system. This is because systems are centrally tracking and distributing personal protection equipment (PPE) amongst their various facilities and looking at patient surge and load from a system perspective. Non-system hospitals are identified as individual hospitals.

The data reflects the status in health systems and hospitals 48 hours prior to the time that the data was posted to this website.

Data Dictionary:

PPE Days on Hand - This is a calculation based on a number of factors including the amount of PPE, the number of COVID-19 patients, beds, industry standard usage and conservation techniques.

COVID-19 Patients – Confirmed positive patients, as well as patients who are currently pending and under investigation (PUI). This includes COVID-19 patients in the ICU.

COVID-19 Patients in ICU - Confirmed postive patients and suspected patients in intensive care unit (ICU).

Bed Occupancy - The percentage of staffed inpatient beds occupied by any patient regardless of COVID-19 status. This includes surge or overlow beds.

Navigation:

There are three data tabs that display information:

Dashboard - PPE status and Patient Census for a specific health system or hospital

Patient Census - Patient census for all health systems/hospitals in Michigan

PPE - Personal protective equipment status for all health systems/hospitals in Michigan