What it does
PPETrackr allows government agencies at all levels to oversee PPE inventory across healthcare facilities in their communities. Healthcare providers record daily inventory on PPE, which is provided to their local government. PPETrackr provides both governments and healthcare facilities with a variety of data visualization tools to help them best understand their inventory changes and make decisions. The goal is to collect data over time, allowing for robust modeling of PPE burn rate and supply management.
This project is designed to prevent catastrophic failure at medical provision facilities in municipalities by augmenting the ability of local leaders to forecast critical shortfalls in the personal protective equipment (PPE) used daily by first responders. Specifically, this means expendable but essential items that generally are single-use before needing to be replaced: masks, gloves, aprons, and the like, for a total of six critical items. Due to the nature of the pandemic, hospitals, first responders, and subsequent supply lines are being taxed in ways that are unprecedented. An aspect of this being that there is no standardized means of recording, and when necessary, sharing data related to the use of PPE.
Current practices within hospitals and medical facilities entail little more than the ability to understand how much of each of these supply items they expend daily. This has resulted in the formation of a secondary industry for PPE in an attempt to allocate necessary resources, an unintended consequence of which is bottlenecks in this vital supply line. Our tool will allow municipalities to draw in data from every medical facility in their jurisdictions to understand daily expenditures, stock on hand, and forecasted dates of depletion. This information in turn will allow local municipal leaders to intelligently adjudicate PPE resupply and distribution throughout their jurisdictions to keep first responders in the fight. Absent this system, there is a significant likelihood that first responders themselves will become infected by COVID-19, thereby exacerbating an already-critical situation.
How we built it
Our small development team built a Django web app with Python. We're using Postgres for the backend, as well as Python's Dash library to build a dashboard where a municipality administrator can access information about healthcare services in their region only.
What's next for PPETrackr
PPETrackr is going live in US states and cities. We hope that this app can be distributed as soon as possible to help cities that are affected by COVID-19. We need assistance from global partners who can help bring this project to scale to help communities get the resources they need to protect their healthcare workers.