Monday 13 August 2012

Olympic tables

G'day
Right, so that's the main Olympics over and done with, so I'll get rid of the medal tables from the right-hand-side of the blog page, and will just post them here for posterity.

Below are all the countries my readership comes from (with the top three placings for the given metric as well), with their total Olympic medal tally, adjusted for population:



PlaceCountry G  S  B TotalPop. (M)Ratio
1Grenada10010.1059.52
2Jamaica444122.714.43
3Trinidad and Tobago10341.323.04
4NZ625134.432.93
10Denmark24395.581.61
14Australia716123522.71.54
18Netherlands6682016.71.20
21Ireland11354.591.09
23GB2917196562.31.04
24Latvia10122.070.97
25Czech Republic4331010.50.95
33South Korea13872848.60.58
34Russia242632821430.57
35Moldova00223.560.56
38Germany1119144481.90.54
40France1111123465.30.52
41Canada15121834.90.52
42Switzerland22047.950.50
45Italy89112860.80.46
46Ukraine6592045.60.44
47Singapore00225.180.39
49USA4629291043130.33
50Japan71417381270.30
53Belgium0123110.27
55Poland2261038.50.26
66Brazil359171920.09
71China3827238813470.07
72Mexico13371120.06
82India024612100.00
-Pakistan00001800.00
-Philippines000092.30.00
-Israel00007.880.00

And this one is arranged relative to team size, rather than national population:

PlaceCountry G  S  B TotalTeam SizeRatio
1Botswana010140.25
2Jamaica44412500.24
3Kenya24511470.23
4China382723883860.23
7USA4629291045300.20
9Russia242632824360.19
13Japan71417382930.13
17GB291719655420.12
19South Korea1387282450.11
21Netherlands668201780.11
22Germany111914443920.11
24France111112343330.10
26Italy8911282840.10
29Moldova0022220.09
31Singapore0022230.09
33Australia71612354100.09
35Ukraine659202400.08
38Denmark24391130.08
41Ireland1135660.08
42Czech Republic433101330.08
43India0246810.07
47NZ625131840.07
48Mexico13371020.07
50Brazil359172590.07
51Canada1512182770.06
65Poland226102170.05
67Latvia1012460.04
70Switzerland22041020.04
76Belgium01231150.03
-Pakistan0000210.00
-Philippines0000110.00
-Israel0000370.00

I was pleased with New Zealand's results in the "by population" table, especially as we ranked higher than Australia (the only country I really feel competitive with). Not so impressed with how the team did, compared to other teams.  One thing that occurs to me is we sent 36 football (read: soccer) players - both a men's and women's team - and neither team had any chance of winning anything (maybe the women, as an outsider).  Had we not sent all of them, the team ratio would have been substantially better.  But I'm sure a few countries could make the same claim.

All in all, I found the whole thing pretty interesting, despite not having any interest in any of the sports in competition.  I only really follow rugby and cricket.  That said, I went to see some boxing, and that was pretty fun.

Tami Burke (@HHWDbuzz) and I had a bet as to who would rank higher on the official table: USA or the UK, and I shall be sending her some of London's finest beer as soon as I liaise with her and find out how to get it to her.

The code for scraping the official medal table and generating the tables - should anyone be interested - is here: