Summary: Olympic medals by nation AND gender?

[Will Hopkins]

I got three replies to my request for lists of Olympics medals by nation and gender at  Tokyo and Sochi (I meant Pyeongchang--duh!). The response was like the good old days of the Sportscience mailing list. There are far fewer people on this list now, but quality is more important than quality. Thanks, guys.

I needed the data for an analysis I am doing with several colleagues on predictors of nations' medal winning, using Poisson regression for the counts, with predictors population, GDP and latitude, and with interactions for gender. My colleagues haven't found any previous analyses like this, but if anyone on this list knows of anything, please get back to me.

You've seen the reply from Jeff Rothschild for Sochi, which included a nice graphical summary. He got back to me directly with "a partial data set for Pyeongchang 2018, but there are a number of missing results (three events I think) - https://github.com/MrGeislinger/2018-olympics-pyeongchang-data)". He also found a JSON file of about 800 MB in size that apparently contains every imaginable statistic from Tokyo at  https://www.kaggle.com/llui85/tokyo-2021-olympics-complete-grouped-by-type/code. He wasn't able to import it into R, but I found the code to import it into SAS. Unfortunately I got an "insufficient memory" error when I tried it with SAS in the cloud (see my article Mixed models in SAS). I might have solved that problem by importing it into the full SAS package on my laptop, which I could install via my host institution (Victoria University), but I didn't need to, because...

Hartmut Sandner replied directly as follows... "We (a group of enthusiasts) have been running a comprehensive result database in all Olympic sports since the year 2000 which is called BIKILA. The results can be split into men, women and mixed for the Tokyo 2020 Olympics. The database, in this version, is in German, but it is easy to find the three split results with the Medaillenspiegel (medal ranking) where you have total, women, men and mixed as options." He included a link, and explained how to change the link to access the Pyeongchang data. Google translated it in the Chrome browser, and eventually I was able to create spreadsheets with the medal counts for females, males, mixed and total, which I can now import into SAS for further analysis.

Will