COVID-19 Data

Given the open data sources for COVID data and the increasing cases over the past few weeks, I wanted to see if I could find any free/open data sources that are easy to use, and if combined might provide some unique insights. My goal was to combine two different data sources that might provide greater insight into the recent increases into COVID cases for NC and in turn the country. I am not qualified to come to any conclusions or confirm any correlation between the recent spikes and reopening of many public places but hopefully this is interesting if only from a technology point of view. What I found was unsurprising but interesting indeed.

The two data sources I used were from The COVID Tracking Project (https://covidtracking.com/api) and Google Mobility Data (https://www.google.com/covid19/mobility/). Both of these datasets seem to be trustworthy and were very easy to use and combine the data. Below is a gist containing the python code used to pull down the data sources and combine them using the date and state fields.

I found the most insight after dropping this combined data into Tableau. I am happy Tableau provides a free version if you don't mind your data and dashboards being publicly available. On the tabs with the mobility data and case data I have defaulted to NC and put the Phase I and Phase II dates as distinct markers on the chart so you can see clearly when those phases began in North Carolina. Links to the Tableau dashbord below.

Sources and Tools:

• gist
• python
• Tableau Public
• Google Mobility Data (https://www.google.com/covid19/mobility/)
• COVID Tracking Project (https://covidtracking.com/api)