Wikidata:Property proposal/Olympedia ID

Olympedia identifier edit

Originally proposed at Wikidata:Property proposal/Authority control

Done: Olympedia people ID (P8286) (Talk and documentation)

Description	identifier for an athlete at www.olympedia.org
Represents	Olympedia (Q95606922)
Data type	External identifier
Domain	human (Q5) with possibly very few exceptions (<5)
Allowed values	[1-9]\d{0,6}
Example 1	Laura Dahlmeier (Q4980869) → 127804
Example 2	Steve Redgrave (Q52679) → 37440
Example 3	Miriam Welte (Q65733) → 125466
Source	https://www.olympedia.org/athletes
External links	Use in sister projects: [ar] • [de] • [en] • [es] • [fr] • [he] • [it] • [ja] • [ko] • [nl] • [pl] • [pt] • [ru] • [sv] • [vi] • [zh] • [commons] • [species] • [wd] • [en.wikt] • [fr.wikt].
Planned use	import ~130k values based on a mapping table sent by the Olympedia team (User:MisterSynergy)
Number of IDs in source	164962 (2020-05-27)
Expected completeness	eventually complete (Q21873974)
Formatter URL	https://www.olympedia.org/athletes/$1
See also	Sports-Reference.com Olympic athlete ID (archived) (P1447) in particular, but also Olympic.org athlete ID (archived) (P3171), databaseOlympics.com athlete ID (archived) (P3520), The-Sports.org athlete ID (P4391), and Olympics.com athlete ID (P5815)

Motivation edit

In the past, the database at www.sports-reference.com/olympics has been pretty much the gold standard of Olympic participation data in all Wikimedia projects. We have Sports-Reference.com Olympic athlete ID (archived) (P1447) for this site, but recently the data was removed from the Sports-Reference.com servers. This had been announced to happen eventually almost 4 years ago.

The original source for the data has always been www.olympedia.org, but that site was not publicly available until recently. The Olympedia team is currently working with a new hosting provider to set up a new public site to host their data, but the site is not expected to go public anytime soon. In the meantime, the Olympedia has been opened for the public [1]. It is not yet clear whether Olympedia will be a public database forever, but based on conversations with Olympedia team, it will likely be available for a considerable time.

In the past weeks, there have been email conversations between Wikimedians (particularly User:RonaldH from German Wikipedia, and me), the Olympedia team, and staffers of their new hosting provider. We have received a complete mapping table (Sports-Reference-URL <-> Olympedia ID) that we can directly import to Wikidata based on our well-maintained Sports-Reference.com Olympic athlete ID (archived) (P1447) identifiers—there is a 1:1 correspondence for both sites. I would offer to import the mapping table to Wikidata in case this property will be created.

Wikipedias would also be potentially be interested in this data, as they could relatively easily switch their Sports-Reference.com weblinks to Olympedia.org without having to look up all identifiers manually.

Interested users: @Avilena, Lugnuts, RonaldH, Edgars2007, Zyxw, Rashinseita (and possibly others);

Notified participants of WikiProject Olympics

—MisterSynergy (talk) 09:12, 27 May 2020 (UTC)[reply]

I've also dropped a note at the Olympic Project on EN WP. Lugnuts (talk) 09:24, 27 May 2020 (UTC)[reply]

Discussion edit

Support (as proposer) —MisterSynergy (talk) 09:12, 27 May 2020 (UTC)[reply]
Support Makes sense now SR has gone Lugnuts (talk) 09:25, 27 May 2020 (UTC)[reply]
Support Best possible solution --RonaldH (talk) 10:05, 27 May 2020 (UTC)[reply]
Support for both the property and the mass import of IDs, now that SR is gone. --Sannita - not just another it.wiki sysop 10:08, 27 May 2020 (UTC)[reply]
Support -- Steak (talk) 15:08, 27 May 2020 (UTC)[reply]
Support - a highly important data source for Olympics-related material. Sillyfolkboy (talk) 16:28, 27 May 2020 (UTC)[reply]
Support --Avilena (talk) 16:49, 27 May 2020 (UTC)[reply]
Support - Migrant (talk) 20:09, 27 May 2020 (UTC)[reply]
Support -- Also, the property Sports-Reference.com Olympic athlete ID (archived) (P1447) should be kept since most of those pages remain available via web.archive.org, similar to how there is still a property for databaseOlympics.com athlete ID (archived) (P3520). -- Zyxw (talk) 23:23, 27 May 2020 (UTC)[reply]
Support --- Løken (talk) 23:40, 27 May 2020 (UTC)[reply]
Support, of course. And the provided mapping also warms up my heart :) That means that SR import and data fixing wasn't meaningless. --Edgars2007 (talk) 16:20, 28 May 2020 (UTC)[reply]
Support, as it makes perfect sense. Schwede66 (talk) 00:52, 29 May 2020 (UTC)[reply]
Support -- Slangore (talk) 06:53, 29 May 2020 (UTC)[reply]
Support --Rashinseita (talk) 09:42, 30 May 2020 (UTC)[reply]
Support It is necessary and indispensable. --Kasper2006 (talk) 06:04, 1 June 2020 (UTC)[reply]
Support - it would be a pity not to have this property Robby (talk) 16:25, 4 June 2020 (UTC)[reply]
Support - Knuteinar2309 (talk) 22:50, 5 June 2020 (UTC)[reply]

Comments edit

Just for information: This database also includes referees and judges alongside all the other athletes and also the youth olympics athletes aswell. It is also a source for family relation between the includeds that are in family with eachother. So I guess it would be okay to also add the ID's of notables that was refereeing in the olympics. PS. This athlete profile (https://www.olympedia.org/athletes/86236 – Yevgeny Grishin) is mixing two different persons see the death date and the time of his coach participations, so all is not well yet. --Migrant (talk) 19:18, 3 June 2020 (UTC)[reply]

Yes, Olympedia has more profiles (~165k) than SportsReference had (133k); the OlympicChannel database, for which we have Olympics.com athlete ID (P5815) and which is supposed to publish Olympedia data at an undefined time in the future, currently has somewhat over 180k profiles. There is an Olympedia ID for every SportsReference ID, but not vice versa.
I have send a bug report to them regarding Grishin. Seems they have just entered a wrong ID somewhere, as the actual Swedish head coach was Bengt-Åke Gustafsson with ID 86326. —MisterSynergy (talk) 20:23, 3 June 2020 (UTC)[reply]

@Lugnuts, MisterSynergy, RonaldH, Sannita, Steak, Sillyfolkboy: @Avilena, Migrant, Zyxw, Løken, Edgars2007, Schwede66: @Slangore, Rashinseita, Kasper2006, Robby: Olympedia people ID (P8286) is now available. Pamputt (talk) 17:29, 4 June 2020 (UTC)[reply]

mmm from External links use {{sports links}} still links to SR archive. --Kasper2006 (talk) 17:35, 4 June 2020 (UTC)[reply]

@Kasper2006: I've added Olympedia links to the Sports Links module on en.wiki. The Sports Reference ones now lead to an archived version. Thanks for pointing it out. Sillyfolkboy (talk) 18:17, 4 June 2020 (UTC)[reply]

Is not the same thing. The situation will be resolved when all the old SR links inserted in Wikidata willl be link to Olympedia. --Kasper2006 (talk) 02:15, 5 June 2020 (UTC)[reply]

@Pamputt: - thanks for setting up the ID. @MisterSynergy: - Looks like this will pass, what would be the timescales to import the IDs? Thanks. Lugnuts (talk) 07:32, 5 June 2020 (UTC)[reply]

The import of ~130,000 identifiers is already running and currently roughly 50% complete. It will likely finish today. ---MisterSynergy (talk) 07:42, 5 June 2020 (UTC)[reply]

Superb! Thanks for your work on this. Lugnuts (talk) 09:31, 5 June 2020 (UTC)[reply]

┌────────────────────────────────────────────────────────────────────────────────────────────────────┘In my opinion, now that the Wikidata ID is working for all athletes, the old SR ID (archived) has no reason to exist and should be deleted. --Kasper2006 (talk) 04:43, 8 June 2020 (UTC)[reply]

It is absolutely usual that we keep such identifiers after the external database has disappeared. In fact, even dead links are still extremely useful for identification. I guess many of them are also still in use at Wikipedias. ---MisterSynergy (talk) 11:58, 8 June 2020 (UTC)[reply]

I understand, but so if you use {{sports links}} on an athlete's External links, you get a double link, to SR and Olympedia, absolutely useless. --Kasper2006 (talk) 13:58, 8 June 2020 (UTC)[reply]

Well yes, I sort of agree. However, this is not being discussed or managed on Wikidata; you need to invoke such a discussion on the corresponding Wikipedia language edition. —MisterSynergy (talk) 19:28, 8 June 2020 (UTC)[reply]