We have always wanted to take on a data visualization project and now seems like the right time and place with Covid-19. Especially so, since there are so many different lenses that we can apply, analyze, and learn from.
What it does
C-19 is a data aggregation and analysis tool that provides insights into the evolution of Covid-19 within the state of Tennessee. It utilizes many different lenses such as: news sources, demographics, mobility reports, and time series data. Not only is it a great place to learn more about Covid-19 and how it is spreading within the state of Tennessee but also it may be used as a tool for potential policy-related decisions.
How we built it
We used many tools to build C-19. The dashboard was built using Angular framework with a back-end consisting of Firebase and Express.js. An integral part of our website’s functionality comes from many useful APIs. One such API was the RDS API, which allowed us to interact with a multitude of datasets (Google Mobility Reports, Tennessee Health Department data, and Knoxville Health Department data) with ease. Furthermore, Google Maps API combined with the power of OpenStreetMaps allowed us to construct a custom GIS experience. Last but not least, we utilized News API to easily query Covid-19 related data in JSON.
Other than the tools -- a restless night with a steady supply of caffeine helped us pull through!
Challenges we ran into
Accomplishments that we're proud of
Ankush: Personally, my proudest moment during the whole experience was converting over 100,000 geographic coordinates into polygons and sticking it onto a map! It was really satisfying being able to design county boundaries with a fine granularity and to be able to interact with each individual county.
Vijay: The proudest moment for me would be when all of the database we had been requesting from RDS seamlessly flowed into our Firebase database. It was made even better by the fact that we formatted the data in a way so it was incredibly easy to visualize the data with the graphing library we were using (Chart.js)!
What we learned
Ankush: More than I wanted to about handling asynchronous data.
Vijay: I learned a lot about Express.js as well as how to deal with Angular imports (struggled to install Chart.js)
What's next for C-19
After the competition is over, we want to go back and polish up C-19 because the insights and experiences that we gained from designing this tool were invaluable. Hopefully, we can keep our tool running for others to see and use!