Brittany and I work at the CDC and wanted to use our platform to put together a meaningful project through which we could learn through contributing to the Covid19 response.
What it does
2 part dashboard:
1) takes in hospital information such as beds available, capacity status, ventilators available to be stored in a database.
2) outputs a map and table displaying this information for every US hospital with >150 beds (including all hospitals made the app run extremely slowly). Allows for filtering by capacity status and could be used for informing doctors on which hospitals to send patients to, as well as which hospitals are in need of what supplies.
How I built it
Framework is in R Shiny, map built using the leaflet package. Database is through sql and aws.
Challenges I ran into
Struggling with feeding in user input into the database. Still not fully functional in that regard. Also could not include all hospitals from data.gov due to how slow the app ran.
Accomplishments that I'm proud of
I've never created a map in shiny before and Brittany had never used R Shiny or created databases in aws. Despite it not being perfect, we were both very happy with the outcome and think it at least gets the idea across.
What I learned
I've never created a map in shiny before and Brittany had never used R Shiny or created databases in aws.
What's next for Health Systems Tracking
finish linking user input to the sql database
security: check to make sure we've removed sql injection possibilities add authentication for hospitals to enter information
usability: concentrate points until map is zoomed in
additional functionality: add a map of count of beds, negative pressure rooms, etc. by county or state to compare hospital availability on a wider scale