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:

Place	Country	G	S	B	Total	Pop. (M)	Ratio
1	Grenada	1	0	0	1	0.105	9.52
2	Jamaica	4	4	4	12	2.71	4.43
3	Trinidad and Tobago	1	0	3	4	1.32	3.04
4	NZ	6	2	5	13	4.43	2.93
10	Denmark	2	4	3	9	5.58	1.61
14	Australia	7	16	12	35	22.7	1.54
18	Netherlands	6	6	8	20	16.7	1.20
21	Ireland	1	1	3	5	4.59	1.09
23	GB	29	17	19	65	62.3	1.04
24	Latvia	1	0	1	2	2.07	0.97
25	Czech Republic	4	3	3	10	10.5	0.95
33	South Korea	13	8	7	28	48.6	0.58
34	Russia	24	26	32	82	143	0.57
35	Moldova	0	0	2	2	3.56	0.56
38	Germany	11	19	14	44	81.9	0.54
40	France	11	11	12	34	65.3	0.52
41	Canada	1	5	12	18	34.9	0.52
42	Switzerland	2	2	0	4	7.95	0.50
45	Italy	8	9	11	28	60.8	0.46
46	Ukraine	6	5	9	20	45.6	0.44
47	Singapore	0	0	2	2	5.18	0.39
49	USA	46	29	29	104	313	0.33
50	Japan	7	14	17	38	127	0.30
53	Belgium	0	1	2	3	11	0.27
55	Poland	2	2	6	10	38.5	0.26
66	Brazil	3	5	9	17	192	0.09
71	China	38	27	23	88	1347	0.07
72	Mexico	1	3	3	7	112	0.06
82	India	0	2	4	6	1210	0.00
-	Pakistan	0	0	0	0	180	0.00
-	Philippines	0	0	0	0	92.3	0.00
-	Israel	0	0	0	0	7.88	0.00

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

Place	Country	G	S	B	Total	Team Size	Ratio
1	Botswana	0	1	0	1	4	0.25
2	Jamaica	4	4	4	12	50	0.24
3	Kenya	2	4	5	11	47	0.23
4	China	38	27	23	88	386	0.23
7	USA	46	29	29	104	530	0.20
9	Russia	24	26	32	82	436	0.19
13	Japan	7	14	17	38	293	0.13
17	GB	29	17	19	65	542	0.12
19	South Korea	13	8	7	28	245	0.11
21	Netherlands	6	6	8	20	178	0.11
22	Germany	11	19	14	44	392	0.11
24	France	11	11	12	34	333	0.10
26	Italy	8	9	11	28	284	0.10
29	Moldova	0	0	2	2	22	0.09
31	Singapore	0	0	2	2	23	0.09
33	Australia	7	16	12	35	410	0.09
35	Ukraine	6	5	9	20	240	0.08
38	Denmark	2	4	3	9	113	0.08
41	Ireland	1	1	3	5	66	0.08
42	Czech Republic	4	3	3	10	133	0.08
43	India	0	2	4	6	81	0.07
47	NZ	6	2	5	13	184	0.07
48	Mexico	1	3	3	7	102	0.07
50	Brazil	3	5	9	17	259	0.07
51	Canada	1	5	12	18	277	0.06
65	Poland	2	2	6	10	217	0.05
67	Latvia	1	0	1	2	46	0.04
70	Switzerland	2	2	0	4	102	0.04
76	Belgium	0	1	2	3	115	0.03
-	Pakistan	0	0	0	0	21	0.00
-	Philippines	0	0	0	0	11	0.00
-	Israel	0	0	0	0	37	0.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: