We have historical data for every Olympics delegation, but this is not at Wikidata. We should add the number of medals by delegation by year. I pretend to do this work using OpenRefine.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Resolved | Theklan | T288171 [Session] Olympics data-thon and edit-a-thon | |||
| Resolved | Theklan | T288173 Add medal count for delegations by year |
Event Timeline
Comment Actions
I have scheduled a session at 10:00 UTC to show how to use OpenRefine to upload this.
https://wikimania.wikimedia.org/wiki/2021:Hackathon/Schedule
Comment Actions
I'm adding the 2020 results from the medal table as a test (I don't want to go blind tomorrow) and everything seems ok: #temporary_batch_1628757207022
Take the United States as an example: https://www.wikidata.org/wiki/Q42914289
Comment Actions
I have started the upload. Can anyone (cc @Fuzheado) make a query for gold medals won by the United States by year? This would be a good showcase.
Comment Actions
the useful kaggle link:
https://www.kaggle.com/heesoo37/120-years-of-olympic-history-athletes-and-results
Comment Actions
All Summer and Winter delegations medal's have been uploaded.
Now is time for the cool queries!