This project is designed to forestall 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.
Immediately, we want this system to go into effect at the municipal level (City of New Haven) by Monday at the latest. That entails having it work across a city with approximately 100 different facilities that provide some degree of medical care, but only one major hospital.
What it does
PPETrackr allows local governments 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.
How we built it
Our small development team built a Flask web app with Python. We're using SQLAlchemy for the backend, basic Python forms for healthcare facilities to submit their inventory, 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.
We're hosting the final app on AWS, where cities can join us!
What's next for PPETrackr
PPETrackr is going live in New Haven and other local cities. We hope to add more features and design with the help of more developers.