I have found myself in the daily routine of checking the numbers on COVID19. The go to is usually the Johns Hopkins COVID 19 data dashboard, and the Spin Off’s daily update for NZ data (pity it isn’t live data and you need to keep going to a new page each day) but also this Interactive graph of the logarithmic scale of COVID 19 cases has been intriguing.
But I got to thinking about the effect on population density and COVID19 spread. Surely in a more dense country with people living closer together would have higher number of cases. Could I find a quick answer to this query? No, so using a few recently gained Sheet and Data Studio skills I DIY’d!
Step 1: pull live data using the =IMPORTHTML function from Worldmeter COVID 19 data set and population & land area data from Wikipedia.
Step 2: Combine these two data sets using the MATCH and INDEX function (heaps better than a VLOOKUP). See this tutorial by my Innovator project mentor – Richard Poth.
Step 3: Use Google Data studio to play with the data! Shout out to Chris Smith and the Data Chat webinar he hosted.
Link to my Data Studio COVID19 Data Wall
So some insights from the data so far. Europe is being affected most – Belgium has been particularly hard hit with a high rate of deaths per million in a relatively dense population. Great using the interactivity of Data Studio to just play with the data.
