Data visualisation and storytelling


Finding climate change buried in 500 million data points

This interactive Flourish map, made by trawling a huge database of daily weather records, puts 2018’s freezing winter in the context of global warming

The winter of 2018 has seen some extreme cold. When the polar vortex froze the US east coast, some people took this as evidence that global warming is a myth. Something similar is now happening as the “Beast from the East” grips Europe. But analysing hundreds of millions of weather records to look for all-time high and low temperatures tells a different story.

Click the arrow button to begin

Feel free to embed this map on your own site. Grab the embed code at the bottom of the post.

How we made it

The visualisation was created from a single spreadsheet of data using the Flourish “Time map” template. The template takes data with columns for time, latitute, longitude (plus optionally catgory, size, name and more) and visualises them over a three-dimensional map.

In this case, the spreadsheet consists of all-time min and max temperatures extracted from GHCN-Daily. This massive dataset, maintained by the US National Oceanic and Atmospheric Administration, consists of hundreds of millions of daily highs and lows recorded at more than 100,000 weather stations around the world, a few of which have records strectching right back to the 1700s.

Having downloaded the raw data, we analysed it to pull out the highest and lowest temperatures ever recorded at each weather station. As you’d expect, the resulting spreadsheet had an equal number of highs and lows. We then filtered out just the last twenty years to see how highs compare to lows in recent decades. This revealed the strong trend towards hot records over cold ones, and also reduced the data sheet to around 40,000 rows, a small enough file to visualise even on a mobile phone.

Once the data was ready, making the map was quick and easy, requiring little more than choosing the right template, uploading the spreadsheet and changing the colour scheme to blue and red to fit with the hot/cold topic. The final step was to load the visualisation in the Flourish story editor to make the guided tour.

Embed the map in your own site

To embed the map in your site, go here and click the embed icon top-right to grab an embed code.

Alternatively you can embed a video version using Vimeo. Here’s how it looks: