Building a simple overview of Covid 19 exposure in Norway over time
Getting the data
Infection data:
vg.no/spesial/2020/corona/ provides the best (in my view) overview of Covid-19 data for Norway. I was looking at the XHR back-end and came across this API the website is connecting to. The API provides data for each day of each municipality (kommune) since the first case back in March. Perfect for what I wanted to do.
Population data:
Next step was to get the population data of each municipality. SSB is the place for this, and I picked this table as a starting point.
Geospatial data:
Kartverket provides the downloadable chart from here. Now, even though the geodata was already at a upscaled level, I really did not need all the details, so I put the data through mapshaper.org to simplify the borders even further and export the data with WGS84 projection which is the standard for most visualization tools.
Visualizing the data
The infection data was ran through Python to get a 14 day moving sum, and then I joined the 3 different data sources in Tableau which I chose for visualizing the data. For the video, I ran the viz in Tableau and then speeded it up 7x to get the final video published.
Feel free to download the workbook yourself to take a closer look.
No responses yet