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/21/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	1630	1537	995	206	144	212	122	222	175	37	234	0	27	54	43	22
Region 2N	5058	4845	3106	522	369	366	150	630	429	75	691	0	67	93	212	159
Region 2S	7273	6386	4585	1025	712	565	146	1259	756	85	732	3	87	53	471	329
Region 3	2855	2421	1462	352	249	253	112	347	226	75	739	1	114	13	104	63
Region 5	2127	1518	1133	182	118	269	139	219	157	46	389	10	54	80	34	25
Region 6	2678	2320	1601	411	266	219	93	450	356	108	501	32	71	23	113	85
Region 7	1001	975	511	106	63	173	122	93	77	38	293	0	25	7	30	27
Region 8	674	567	267	59	37	109	81	94	88	37	262	13	33	15	31	31
Total	23296	20569	13660	2863	1958	2166	965	3314	2264	501	3841	59	478	338	1038	741

*89% 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	98	96	117	34	55	110	22	11	543
# In Critical Care	27	111	194	61	23	43	8	3	470
# on Ventilators	20	81	164	33	15	32	3	0	348
# of Inpatients	39	230	397	103	58	125	3	0	955

Statewide Hospital Available PPE Tracking for COVID-19* 05/21/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,660	77	21	131,729	1,302,181	5,954	110,072	214	411	112	19,847	129,499	1,106,773
Region 2N	145	10,177	24	73	142,565	6,421,066	20,255	214,833	341	602	318	74,583	215,195	457,046
Region 2S	109	29,222	2	1,815	281,615	3,817,276	18,081	526,622	806	1,293	850	46,393	301,683	1,763,005
Region 3	235	3,344	8	12	95,363	4,798,210	34,016	188,007	209	406	158	18,814	255,067	925,420
Region 5	157	1,893	23	40	23,315	1,435,687	8,314	62,069	258	314	179	11,958	50,317	131,037
Region 6	136	1,695	14	36	138,866	22,679,731	41,273	329,349	401	915	371	81,647	50,906	2,056,796
Region 7	46	3,440	0	0	93,281	4,703,832	9,245	56,876	290	264	206	26,517	27,485	608,593
Region 8	4	2,935	45	197	32,253	2,060,338	1,209	83,589	146	351	153	9,982	49,504	334,476
Total	882	102,366	193	2,194	938,987	47,218,321	138,347	1,571,417	2,665	4,556	2,347	289,741	1,079,656	7,383,146

*81% 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/21/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	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	7-14 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	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	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	21+ 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	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 05/21/2020**
Health System/Hospital	Posting Date	COVID-19 Patients	COVID-19 Patients in ICU	Bed Occupancy
Ascension	5/21/2020	144	43	67%
Aspirus	5/21/2020	0	1	35%
Baraga County Memorial Hospital	5/21/2020	0	0	33%
Beaumont	5/21/2020	255	75	76%
Bronson	5/21/2020	29	15	68%
Covenant	5/21/2020	35	12	69%
Deckerville Community Hospital	5/21/2020	0	0	17%
Detroit Medical Center	5/21/2020	113	48	89%
Dickinson Memorial Health Care System	5/21/2020	5	1	55%
Eaton Rapids Medical Center	5/21/2020	1	0	5%
Harbor Beach Community Hospital	5/21/2020	0	0	33%
Helen Newberry Joy Hospital	5/21/2020	0	0	24%
Henry Ford Health System	5/21/2020	176	67	67%
Hills and Dales General Hospital	5/21/2020	0	0	26%
Hillsdale Hospital	5/21/2020	1	0	33%
Holland Community Hospital	5/21/2020	9	3	81%
Hurley Medical Center	5/21/2020	18	9	79%
Kalkaska Memorial Health Center	5/21/2020	0	0	25%
Mackinac Straits Hospital	5/21/2020	0	0	7%
Marlette Regional Hospital	5/21/2020	0	0	20%
McKenzie Memorial Hospital	5/21/2020	0	0	8%
McLaren	5/21/2020	96	45	67%
Memorial Healthcare	5/21/2020	4	0	32%
Metro	5/21/2020	10	2	67%
Michigan Medicine	5/21/2020	52	44	89%
MidMichigan Health	5/21/2020	23	3	42%
Munising Memorial Hospital	5/21/2020	0	0	21%
Munson Health System	5/21/2020	3	3	55%
North Ottawa Community Hosp	5/21/2020	0	0	17%
Oaklawn Hospital	5/21/2020	2	0	44%
OSF St. Francis Hospital	5/21/2020	3	2	21%
Pontiac General Hospital	5/21/2020	0	0	14%
Prime Health	5/21/2020	17	3	49%
ProMedica	5/21/2020	14	7	61%
Scheurer Hospital	5/21/2020	0	0	12%
Schoolcraft Memorial Hospital	5/21/2020	0	0	58%
Sheridan Community Hospital	5/21/2020	0	0	7%
Sparrow Health System	5/21/2020	14	4	64%
Spectrum	5/21/2020	86	29	63%
Straith Hospital	5/21/2020	0	0	4%
Sturgis Hospital	5/21/2020	3	0	88%
Three Rivers Health	5/21/2020	3	0	34%
Trinity	5/21/2020	198	49	75%
UP Health	5/21/2020	1	0	63%
War Memorial Hospital	5/21/2020	0	0	24%
Grand Total	Total	1,315	465	68%

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