Mapping Olympic Medals

Back in January, I answered a number of graphics-related questions in the Talk to the Newsroom feature on nytimes.com, including one about our Map of Olympic Medals:

Q. I was very impressed by the Olympic-by-Olympic medal counts you ran during the Summer Games; the bubbles representing the biggest hauls of each Olympiad were a microcosm of 20th-century political and economic power. Can you walk us through the birth of something like this? Did someone browse through the medal counts and see trends — the rise of the U.S. and, later, China, the unnatural power of East Germany, e.g. — or is this something that becomes clear after you’ve finished the graphics?
— John Dillon

A. I’m glad you enjoyed the “Map of Olympic Medals.” We were looking for an interesting way to show trends in the medal count, and a quick glance at the data revealed how the counts were affected by the cold war boycotts in 1980 and 1984, the fall of the Soviet Union and the recent growth in China, so it seemed like a geographic representation might be the way to go.

The next question was the form that the map should take. A constant challenge with data-driven maps is the presentation of data on top of the geographic areas that differ vastly in size. For example, Canada and The Netherlands won about the same number of medals in Beijing, but Canada occupies more than 200 times the land area of The Netherlands.

There are a number of ways to attack this problem, each with pluses and minuses:

If you were to do a traditional map where the countries were colored by the number of medals won, Canada and the Netherlands would have the same color, but Canada would be far more prominent on the map simply because of its size.

A proportional symbols map — what we informally call a “bubble” map — places a circle, scaled in proportion to the data, on top of each country. It can give you a better representation of the data, but in places like Europe, where the countries are so close together, you can end up with so many overlapping circles that you can’t tell countries apart. For an example, check out our county-by-county presidential election bubble map.

A contiguous cartogram rescales each country so that its area on the map is proportional to the data.. It can be extraordinarily effective in some cases, but other times it ends up distorting the countries so much that it’s hard to recognize them. Mark Newman’s site at the University of Michigan has a number of examples, on topics ranging from population to greenhouse gas emissions.

The form we chose was similar to a Dorling cartogram, which removes all references to the shape of the country and replaces them all with a symbol like a circle. The goal was to try to keep the countries’ relative positions loosely correct — Canada north of the United States, and Mexico to the south — and have the countries remain in roughly the same spots from year to year. Using this style of map can give you a better presentation of the countries with the highest medal count — you don’t have to worry about circles overlapping or shapes being distorted — at the expense of the ones with a low count, which are too small to be labeled. But when looking at medal counts, you’re usually more interested in who did well, so it seemed an acceptable trade-off.

The idea to use this style was loosely inspired by a terrific cartogram by John Tomanio in Fortune magazine in 2001 that showed the largest 500 companies in the world and the countries they were based in. (Sadly, I can’t find it online anymore.)

In the past, we’d done similar cartograms a number of times — check out our 2003 California recall election graphic, done with squares — but in every case, a graphics editor had gone in and positioned the countries by hand. The tricky thing in this case was generating the cartogram dynamically, since the data would change throughout the Olympics, and we wouldn’t have the time to update it each time a medal was awarded.

So Lee Byron, one of our summer interns and a terrific programmer, came up with an algorithm to position the countries automatically in Flash using a “force-directed graph using a particle system.” Countries try to locate themselves near where they are geographically located as well as close to geographically neighboring countries. The algorithm required a number of rounds of tweaking — for a while, New Zealand kept appearing west of Australia — but by the end, it was doing a remarkably good job of generating a map on the fly.

At which point, we hooked it up to a live data feed of the Olympic results and let it roll.

Leave a Reply

Your email address will not be published. Required fields are marked *