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* 07/10/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,736	1,485	1,115	192	166	197	102	202	155	32	222	0	23	51	43	20
Region 2N	5,097	4,966	3,614	498	393	332	166	536	384	76	504	0	71	80	178	119
Region 2S	7,366	6,482	5,191	913	725	483	140	1142	714	112	461	8	102	51	276	176
Region 3	3,222	2,557	1,961	406	322	266	137	309	216	78	519	1	72	15	74	65
Region 5	2,104	1,486	1,208	182	113	266	113	228	191	63	279	5	57	79	34	31
Region 6	2,679	2,332	1,557	405	287	229	86	429	342	113	378	19	58	10	108	87
Region 7	1,011	985	593	198	128	173	123	98	81	38	235	0	24	9	30	30
Region 8	704	581	291	77	48	101	69	96	86	37	197	0	20	11	31	30
Total	23,919	20,874	15,530	2,871	2,182	2,047	936	3,040	2,169	549	2,795	33	427	306	774	558

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

**COVID-19 Metrics 07/10/2020**
HCC Region	Region 1	Region 2 North	Region 2 South	Region 3	Region 5	Region 6	Region 7	Region 8	Total
# of ED Discharges	116	97	163	90	15	206	31	74	792
# In Critical Care	15	42	62	27	14	15	6	1	182
# on Ventilators	11	39	34	7	1	7	0	0	99
# of Inpatients	7	103	133	43	34	38	6	2	366

Statewide Hospital Available PPE Tracking for COVID-19* 07/10/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,330	97	35	141,063	1,075,661	5,239	121,912	214	411	137	23,842	152,702	1,070,756
Region 2N	185	7,800	24	73	111,477	5,019,546	21,640	220,824	366	719	374	79,639	232,825	342,131
Region 2S	112	29,674	44	1,875	200,400	3,430,522	18,071	411,346	804	1,292	517	37,462	384,996	1,402,873
Region 3	235	3,731	28	52	95,284	6,128,065	23,134	188,110	244	406	163	21,927	445,725	1,152,211
Region 5	154	1,924	23	64	25,979	1,369,574	8,331	46,985	268	330	209	13,290	56,909	133,825
Region 6	134	1,709	214	436	113,781	17,384,059	44,983	420,724	692	1,217	669	81,979	83,117	3,261,582
Region 7	46	3,127	0	0	78,729	4,845,425	10,165	46,333	389	455	310	26,535	21,024	1,374,957
Region 8	4	2,415	72	204	33,046	2,327,163	1,156	82,624	182	423	185	9,841	55,397	346,618
Total	920	98,710	502	2,739	799,759	41,580,015	132,719	1,538,858	3,159	5,253	2,564	294,515	1,432,695	9,084,953

*79% 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 07/10/2020**
Health System/Hospital	COVID-19 Patients	COVID-19 Patients in ICU	Bed Occupancy
Ascension	54	10	77%
Aspirus	2	1	29%
Baraga County Memorial Hospital	0	0	33%
Beaumont	124	45	71%
Bronson	16	4	75%
Covenant	12	7	78%
Deckerville Community Hospital	0	0	0%
Detroit Medical Center	47	26	84%
Dickinson Memorial Health Care System	2	1	39%
Eaton Rapids Medical Center	2	0	15%
Harbor Beach Community Hospital	0	0	27%
Helen Newberry Joy Hospital	0	0	48%
Henry Ford Health System	73	33	73%
Hills and Dales General Hospital	1	0	35%
Hillsdale Hospital	0	0	25%
Holland Community Hospital	2	0	67%
Hurley Medical Center	3	2	92%
Kalkaska Memorial Health Center	0	0	50%
Mackinac Straits Hospital	0	0	27%
Marlette Regional Hospital	0	0	16%
McKenzie Memorial Hospital	0	0	28%
McLaren	62	8	73%
Memorial Healthcare	0	0	50%
Metro	4	1	50%
Michigan Medicine	9	4	85%
MidMichigan Health	7	0	51%
Munising Memorial Hospital	0	0	7%
Munson Health System	7	6	62%
North Ottawa Community Hosp	0	0	29%
Oaklawn Hospital	3	0	39%
OSF St. Francis Hospital	0	0	9%
Pontiac General Hospital	1	0	9%
Prime Health	7	2	66%
ProMedica	6	1	64%
Scheurer Hospital	0	0	33%
Schoolcraft Memorial Hospital	0	0	58%
Sheridan Community Hospital	0	0	10%
Sparrow Health System	15	2	81%
Spectrum	31	12	62%
Straith Hospital	0	0	13%
Sturgis Hospital	5	0	88%
Three Rivers Health	0	0	34%
Trinity	66	15	77%
UP Health	2	1	73%
War Memorial Hospital	2	1	34%
Grand Total	565	182	71%

**Patient Census as of 07/06/2020**
Health System/Hospital	COVID-19 Patients	COVID-19 Patients in ICU	Bed Occupancy
Ascension	54	14	75%
Aspirus	2	1	24%
Baraga County Memorial Hospital	0	0	40%
Beaumont	115	45	61%
Bronson	12	3	64%
Covenant	13	7	73%
Deckerville Community Hospital	0	0	0%
Detroit Medical Center	46	27	78%
Dickinson Memorial Health Care System	1	1	33%
Eaton Rapids Medical Center	2	0	15%
Harbor Beach Community Hospital	0	0	27%
Helen Newberry Joy Hospital	0	0	36%
Henry Ford Health System	49	26	68%
Hills and Dales General Hospital	0	0	26%
Hillsdale Hospital	0	0	22%
Holland Community Hospital	2	0	57%
Hurley Medical Center	2	2	91%
Kalkaska Memorial Health Center	0	0	25%
Mackinac Straits Hospital	0	0	55%
Marlette Regional Hospital	0	0	16%
McKenzie Memorial Hospital	0	0	24%
McLaren	58	13	68%
Memorial Healthcare	0	0	42%
Metro	3	2	44%
Michigan Medicine	8	2	79%
MidMichigan Health	3	0	48%
Munising Memorial Hospital	0	0	7%
Munson Health System	5	5	50%
North Ottawa Community Hosp	0	0	29%
Oaklawn Hospital	0	0	31%
OSF St. Francis Hospital	0	0	18%
Pontiac General Hospital	1	0	9%
Prime Health	9	4	58%
ProMedica	6	0	53%
Scheurer Hospital	0	0	24%
Schoolcraft Memorial Hospital	0	0	17%
Sheridan Community Hospital	0	0	7%
Sparrow Health System	17	2	74%
Spectrum	34	13	56%
Straith Hospital	0	0	8%
Sturgis Hospital	5	0	63%
Three Rivers Health	0	0	43%
Trinity	57	7	68%
UP Health	1	0	68%
War Memorial Hospital	0	0	37%
Grand Total	505	174	65%

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