Warning: Table './wcdrupal/watchdog' is marked as crashed and last (automatic?) repair failed query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead</em> in <em>/home/rcousine/wiredcola.com/includes/unicode.inc</em> on line <em>311</em>.', 2, '', 'http://wiredcola.com/content/olympic-medal-counts-and-stats-fiddling', '', '64.62.252.164', 1492648144) in /home/rcousine/wiredcola.com/includes/database.mysql.inc on line 172
Olympic Medal Counts and stats fiddling | Wired Cola

Olympic Medal Counts and stats fiddling

: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /home/rcousine/wiredcola.com/includes/unicode.inc on line 311.

I got interested in Olympic medal counts measured various ways, and ended up with this partly-complete spreadsheet.

Among other things, I've compiled medals by national population, and medals by athletes sent, at least for the top teams. I also put in some weighted stats where a Gold = 3, Silver = 2, and Bronze = 1.

Maybe most interestingly, I painfully went through EVERY country's "athletes awarded" counts, by hand-counting it off the pretty good CTV medal-count pages. "Athletes Awarded" is my own count of the number of each type of medal actually handed to competing athletes. This accounts for the fact that if you win the 4-man bobsled gold, four men actually get gold medals.

As far as I can tell, coaches do not get a medal in any sport, and the rules for which participating athletes get a medal can vary from sport to sport. Two notable examples are that Marc-Andre Fleury, Canada's third goalie, got a gold (I don't know if he dressed for any of the games) and the Martin curling rink had five awarded medalists (an alternate played in at least one game, I assume).

If you want to clean up the data or add some columns, drop me a line and I'll give you access to the sheet. Or you can make your own copy of the data. If you do anything interesting with the data I hand-compiled or the columns I synthesized, be kind and link back to this page.

Update: Michael Coyle has compiled a more rigorous analysis of Canada's results at his amusingly-named blog.