2009-07-02T20:01:02+00:002009-07-02T20:01:02+00:00Soon after the Beijing 2008 Olympics commenced, I began regularly updating this <a href='http://www.swivel.com/data_sets/show/1016370'>Beijing 2008 Olympic Medal Count</a> data set. The <a href='http://www.swivel.com/graphs/show/29155577'>tally chart</a> proved very popular and has seen more than 10,000 views, but then I thought I'd add another slant to the data by looking at the results in terms of the size of each country's population or economy.
So, I tracked down some <a href='http://en.wikipedia.org/wiki/List_of_countries_by_population'>population data</a> on wikipedia, correcting a few of the figures with reference to the <a href='https://www.cia.gov/library/publications/the-world-factbook/'>CIA World Factbook</a> (I'd have taken it all from there if I could work out an easy way to download all the data). I found <a href='http://www.google.com.au/url?sa=t&ct=res&cd=2&url=http%3A%2F%2Fsiteresources.worldbank.org%2FDATASTATISTICS%2FResources%2FGDP.pdf&ei=j6uvSPDPNaG2sAP8kt2EAQ&usg=AFQjCNFmQtrmmFhCeki-CiYwJWsLlpmvpA&sig2=1uICIEpYxhn6HNf-yaMopg'>world gross domestic product (GDP) data</a> provided by the world bank, and <a href='http://www.swivel.com/data_sets/show/1016460'>uploaded the results to Swivel</a>. Shortly afterwards, I created a second data set which included medals per million population and medals per trillion US dollars GDP. This is one of the charts based on that data set.
After a bit of jostling, exchanging places with the Bahamas, Jamaica came out third in the ranking of medals per capita and second in terms of medals per trillion dollars of GDP. It would be first if Zimbabwe's economy wasn't such a basket case! So, in the adjusted Olympic medal tally, I'd nominate Jamaica as the clear winner.
For more charts and more discussion, read <a href='http://www.stubbornmule.net/2008/08/olympics-by-gdp/'>this blog post</a>. (Note that the GDP data is in US dollars.)2360Beijing Olympics 2008: Medals per mil. Population by Country{"format":{"series.default_0.stroke":{"color":"rgb(59, 171, 101)","width":2},"series.default_0.fill":"rgb(59, 171, 101)","series.default_0.format":{"precedence":1,"format":{"c":true,"ns":true,"p":-1,"t":"n"}},"axis.y.format":{"c":true,"ns":true,"p":-1,"t":"n"},"axis.x.format":{"ns":true,"p":-1,"t":"t"},"series-manager.0.dimension-order":{"reverse":true,"series":"default_0","type":"series","custom":[14,13,12,11,10,9,8,7,6,5,4,3,2,1,0]}}}lFOKGK73z++J7EMrnTG/fg==Beijing Olympics 2008 - Medals per Capita and GDP http://www.swivel.com/data_sets/show/1016477Beijing Olympics 2008: Medals per mil. Population by Country294298952010-01-08T23:21:58+00:00Soon after the Beijing 2008 Olympics commenced, I began regularly updating this <a href='http://www.swivel.com/data_sets/show/1016370'>Beijing 2008 Olympic Medal Count</a> data set. The <a href='http://www.swivel.com/graphs/show/29155577'>tally chart</a> proved very popular and has seen more than 10,000 views, but then I thought I'd add another slant to the data by looking at the results in terms of the size of each country's population or economy.
So, I tracked down some <a href='http://en.wikipedia.org/wiki/List_of_countries_by_population'>population data</a> on wikipedia, correcting a few of the figures with reference to the <a href='https://www.cia.gov/library/publications/the-world-factbook/'>CIA World Factbook</a> (I'd have taken it all from there if I could work out an easy way to download all the data). I found <a href='http://www.google.com.au/url?sa=t&ct=res&cd=2&url=http%3A%2F%2Fsiteresources.worldbank.org%2FDATASTATISTICS%2FResources%2FGDP.pdf&ei=j6uvSPDPNaG2sAP8kt2EAQ&usg=AFQjCNFmQtrmmFhCeki-CiYwJWsLlpmvpA&sig2=1uICIEpYxhn6HNf-yaMopg'>world gross domestic product (GDP) data</a> provided by the world bank, and <a href='http://www.swivel.com/data_sets/show/1016460'>uploaded the results to Swivel</a>. Shortly afterwards, I created a second data set which included medals per million population and medals per trillion US dollars GDP. This is one of the charts based on that data set.
After a bit of jostling, exchanging places with the Bahamas, Jamaica came out third in the ranking of medals per capita and second in terms of medals per trillion dollars of GDP. It would be first if Zimbabwe's economy wasn't such a basket case! So, in the adjusted Olympic medal tally, I'd nominate Jamaica as the clear winner.
For more charts and more discussion, read <a href='http://www.stubbornmule.net/2008/08/olympics-by-gdp/'>this blog post</a>. (Note that the GDP data is in US dollars.)