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.
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.
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.
We're hosting the final app on AWS, where cities can join us!
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.
amazon-web-services, dash, django, postgresql, python