Statewide Available PPE and Bed Tracking

Statewide Available PPE and Bed Tracking

• 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.

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.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

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