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* 06/08/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,507	966	208	139	213	130	215	43	172	36	284	0	26	48	43
Region 2N	5,025	4,799	3,224	517	363	348	164	618	148	469	76	638	0	72	76	178
Region 2S	7,245	6,450	4,594	993	691	502	164	1,273	484	786	97	759	13	121	48	400
Region 3	2,917	2,460	1,687	354	292	249	128	324	129	201	77	582	1	124	23	82
Region 5	2,127	1,518	1,123	180	118	268	138	220	57	163	65	411	5	49	71	34
Region 6	2,681	2,307	1,544	411	271	230	90	449	90	359	82	553	34	72	18	113
Region 7	1,001	975	468	176	98	173	123	93	17	76	38	320	0	27	12	30
Region 8	670	563	228	82	37	109	89	96	3	93	37	265	22	47	17	31
Total	23,367	20,579	13,834	2,921	2,009	2,092	1,026	3,288	971	2,319	508	3,812	75	538	313	911

*93% 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	51	54	128	36	33	89	16	9	416
# In Critical Care	7	70	94	37	9	33	3	0	253
# on Ventilators	11	35	59	20	6	19	0	0	150
# of Inpatients	13	92	179	70	27	69	1	0	451

Statewide Hospital Available PPE Tracking for COVID-19* 06/08/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	48,620	103	47	128,640	1,348,966	5,534	119,494	214	411	137	20,830	151,636	1,005,723
Region 2N	185	8,833	24	73	162,477	5,669,357	22,196	211,674	336	601	337	69,755	231,659	437,908
Region 2S	109	28,818	44	1,875	255,650	3,342,673	17,184	426,517	806	1,292	1,074	44,327	368,681	1,834,866
Region 3	235	3,351	8	12	97,826	7,265,176	33,615	193,916	209	406	158	20,829	248,834	881,699
Region 5	157	1,900	23	64	22,621	1,291,647	8,239	45,507	258	314	178	12,812	55,234	139,655
Region 6	136	1,679	14	36	116,791	20,434,570	42,603	374,078	401	915	381	83,055	52,084	1,803,521
Region 7	46	3,389	0	0	94,981	4,819,269	10,549	55,280	390	455	310	24,533	24,894	609,288
Region 8	4	2,824	45	190	31,482	2,282,991	1,040	90,929	153	391	155	11,269	265,376	485,106
Total	922	99,414	261	2,297	910,468	46,454,649	140,960	1,517,395	2,767	4,785	2,730	287,410	1,398,398	7,197,766

*73% 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 06/08/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	7-14 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	21+ days	21+ days	21+ days	21+ days	Independent
Detroit Medical Center	21+ days	15-21 days	21+ days	21+ days	7-14 days	Health System
Dickinson Memorial Health Care System	21+ days	21+ days	21+ 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	15-21 days	7-14 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	21+ days	15-21 days	21+ days	21+ days	21+ days	Independent
Holland Community Hospital	21+ days	21+ days	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	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	7-14 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	0-6 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	21+ days	21+ days	Independent
Pontiac General Hospital	21+ days	0-6 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	21+ 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	15-21 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	15-21 days	21+ days	21+ days	7-14 days	Health System
UP Health	21+ days	21+ 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 06/08/2020**
Health System/Hospital	COVID-19 Patients	COVID-19 Patients in ICU	Bed Occupancy
Ascension	72	16	70%
Aspirus	1	0	24%
Baraga County Memorial Hospital	0	0	27%
Beaumont	130	54	55%
Bronson	13	3	73%
Covenant	32	9	80%
Deckerville Community Hospital	0	0	8%
Detroit Medical Center	50	31	98%
Dickinson Memorial Health Care System	0	0	45%
Eaton Rapids Medical Center	0	0	10%
Harbor Beach Community Hospital	0	0	13%
Helen Newberry Joy Hospital	0	0	28%
Henry Ford Health System	49	40	64%
Hills and Dales General Hospital	0	0	19%
Hillsdale Hospital	0	0	33%
Holland Community Hospital	5	3	72%
Hurley Medical Center	9	8	82%
Kalkaska Memorial Health Center	0	0	0%
Mackinac Straits Hospital	0	0	45%
Marlette Regional Hospital	0	0	20%
McKenzie Memorial Hospital	0	0	20%
McLaren	78	18	67%
Memorial Healthcare	1	0	30%
Metro	12	2	51%
Michigan Medicine	24	15	78%
MidMichigan Health	26	1	49%
Munising Memorial Hospital	0	0	14%
Munson Health System	3	1	55%
North Ottawa Community Hosp	0	0	9%
Oaklawn Hospital	2	0	34%
OSF St. Francis Hospital	0	0	9%
Pontiac General Hospital	0	0	11%
Prime Health	7	3	58%
ProMedica	8	4	57%
Scheurer Hospital	0	0	15%
Schoolcraft Memorial Hospital	0	0	17%
Sheridan Community Hospital	0	0	0%
Sparrow Health System	21	0	64%
Spectrum	43	19	58%
Straith Hospital	0	0	8%
Sturgis Hospital	4	0	25%
Three Rivers Health	2	0	30%
Trinity	67	22	77%
UP Health	2	0	53%
War Memorial Hospital	0	0	27%
Grand Total	661	249	64%

The data reflects the status in health systems and hospitals 48 hours prior to the time that the data was posted to this website.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.

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