you're reading...
Data journalism, Data visualisation, Google data

Building an Alternative Olympic Medal Table

Since the modern Olympics began nearly 120 years ago, they have been dissected and evaluated through every possible angle. But data journalism is about looking at the world anew through the fresh lens of facts and numbers.

With the Games in full swing, all eyes are on the medal table: who’s winning and which countries have the most gold medals? What if data journalism could give us a new way to see these staples of Olympic reporting?

Every four years we see similar trends — the most populous countries and those that invest most heavily in their programs taking the top slots. But what if you could look at the medal table in another way? What if a small, less populous country, with fewer resources wins a large number of medals? How can we compensate for the size by using data? We wanted to apply the techniques of data journalism to this idea, which is how the Alternative Medal Table interactive was born.

Alternative Medal Table homepage


How the alternative Olympic medal table came to be

This experiment is based on an exercise I took part in for London’s 2012 games with statistician Christoforos Anagnostopoulos, then of London’s Imperial College. In 2012, we used data on population, GDP and team size to model what would happen if all the teams had equal resources. We wanted to show how small countries can really punch above their weight when it comes to being the best in sport.

For 2016, I got to work with Anagnostopoulos again, who is now co-founder of Mentat. And this time we wanted to look at a whole new set of data. We wanted to see which teams in 2016 were beating the average to overperform against a whole new set of variables, including how people search on Google. In particular:

  • Population size (fueled by data from the World Bank)
  • Gross Domestic Product (GDP) — this is the size of a country’s economic output, traditionally used to show how large an economy is. (World Bank)
  • Google Search interest in the Olympics in 2016
  • Google Search interest in sport participation
  • Google Search interest in healthy eating

Why include Google Search interest in the analysis? Everyday I get to work with a dataset which provides a unique insight into the things we really care about around the world (and you can read more about this here). What if caring a lot about the Olympics — as represented in Search interest — was how we determined the winner?

So Anagnostopoulos created this dataset, which allows us to weigh all the factors and create new ways to rank the countries.

Anagnostopoulos says the data presents unique challenges: “Collecting national statistics on all 206 National Olympic Committees (NOCs) is a strong reminder of how uniquely global the Olympics are: even the World’s Bank’s famously comprehensive data banks weren’t sufficient! “

Why the alternative Olympic medal table matters

The big question is: why bother doing this? My answer is this: the sheer volume of data we have out in the world makes this worthwhile. If there is an opportunity to tell new stories around an event as familiar as the Olympics, then we should do it.

Anagnostopoulos also points out how the table touches on notions of fairness. “Shouldn’t excellence be calibrated to take into account available resources? Life might not be fair enough to ensure that competition takes place ‘all other things being equal’, but thankfully we can use data science to make it so!”

And we can think about those issues tangibly. As Anagnostopoulos continues: “The beauty of data science is that we can produce answers to hypotheticals: what could Jamaican athletes achieve if they had the financial resources of the United States? In this sense, the alternative medal count is a measure not of realised skill, but of potential.”

The interactive itself was built and designed with Greg Calvert, Katherine Walker and Jacques Bruwer. The team has worked hard to create a visual that works well across mobile and desktop and shows complex data in a simple, clear way.

It’s available in English, Portuguese for Brazil and Spanish and is embeddable on any website or blog (click the share button at the top right).

Calvert says it’s all about making it simple but easy to understand. “The site has to display a lot of fairly complex information, so it was important to communicate what this thing is clearly and concisely, and get folks into the experience with as little learning curve as possible,” he explained.

“The beauty of this thing is it’s immediacy — that simple, quick moment of discovery, and being surprised by unexpected results. You shouldn’t have to be a statistician to understand or enjoy this.”

So, how does it work? Click on each of the factors at the top of the table to see the ranking reorder itself; click on a country to see how it ranks across all the variables.

Click on a country to see where they fit

You can download the initial dataset here (which doesn’t have real medal data in) to create your own alternative medal index. We would love to find out if you do — email us at newslabtrends@google.com to let us know what you do with it.

The exciting thing is, we have no idea what this data will show by the end of the games. Will the small Caribbean islands triumph in track and field when you take population into account? Will the countries with high Search interest also be those where the medals come rolling in? While we might not know the winners just yet, we’re just as excited as the millions watching around the world to find out.

About Simon Rogers

Data journalist, writer, speaker. Author of 'Facts are Sacred', from Faber & Faber and a range of infographics for children books from Candlewick. Edited and launched the Guardian Datablog. Now works for Google in California as Data Editor and is Director of the Sigma awards for data journalism.



  1. Pingback: The Olympics Of Olympics Graphics | Tera News - August 26, 2016

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

About me

Data journalist, writer, speaker. Author of 'Facts are Sacred', published by Faber & Faber and a new range of infographics for children books from Candlewick. Data editor at Google, California. Formerly at Twitter, San Francisco. Created the Guardian Datablog. All opinions on this site are mine, not my employers'. Read more >>

Free to share

Creative commons

Please share me around. Everything here is free to use under a Creative Commons Attribution-NonCommercial 3.0 Unported License

Follow me on Twitter

%d bloggers like this: