Property talk:P3940

Documentation

• Start a query
• Current uses
• Statistics by class
• String length
• List of qualifiers
• Count

OlimpBase Chess Olympiad player ID
identifier for a player at www.olimpbase.org who took part in the Chess Olympiad

Applicable "stated in" value	OlimpBase (Q631396)
Data type	External identifier
Corresponding template	Template:OlimpBase player (Q108939927)
Template parameter	Template:Chess Links (Q14339495)
Allowed values	[a-z0-9]+
Example	Garry Kasparov (Q28614) → ssimw2af Judit Polgár (Q183250) → d131h7xd
Source	http://www.olimpbase.org/players2.html
Formatter URL	http://www.olimpbase.org/players/$1.html
Tracking: usage	Category:Pages using Wikidata property P3940 (Q52623052)
Related to country	Poland (Q36) (See 67 others)
See also	OlimpBase Women's Chess Olympiad player ID (P5224)
Lists	Items with the most statements of this property Count of items by number of statements (chart) Items with the most statements Items with the fewest statements Count of items by number of sitelinks (chart) Items with the most sitelinks Items with the most sitelinks, but no link to one Wikipedia (sample: Welsh Wikipedia, cywiki) Items with the fewest sitelinks Most linked wikis Items with the most identifier properties Items with no other external identifier Items with no other statements Most recently created items Items with novalue claims Items with unknown value claims Usage history (total) Usage history (main statement) Chart by item creation date Map of people by place values: place of birth educated at work location residence place of death place of burial January 1st dates People with date of birth on January 1 People with date of death on January 1 People with both dates on January 1 Database reports/Constraint violations/P3940 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 7,412 Main statement 3,052 41.2% of uses Qualifier 2 <0.1% of uses Reference 4,358 58.8% of uses
Search for values

[create Create a translatable help page (preferably in English) for this property to be included here]

Single value: this property generally contains a single value. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3940#Single value, SPARQL

Distinct values: this property likely contains a value that is different from all other items. (Help)

List of violations of this constraint: Database reports/Constraint violations/P3940#Unique value, hourly updated report, SPARQL (every item), SPARQL (by value)

Format “[a-z0-9]{8}”: value must be formatted using this pattern (PCRE syntax). (Help)

List of violations of this constraint: Database reports/Constraint violations/P3940#Format, hourly updated report, SPARQL

Item “instance of (P31): human (Q5)”: Items with this property should also have “instance of (P31): human (Q5)”. (Help)

List of violations of this constraint: Database reports/Constraint violations/P3940#Item P31, hourly updated report, search, SPARQL

Item “occupation (P106): chess player (Q10873124)”: Items with this property should also have “occupation (P106): chess player (Q10873124)”. (Help)

List of violations of this constraint: Database reports/Constraint violations/P3940#Item P106, hourly updated report, search, SPARQL

Item “participant in (P1344)”: Items with this property should also have “participant in (P1344)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3940#Item P1344, search, SPARQL

Item “country for sport (P1532)”: Items with this property should also have “country for sport (P1532)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3940#Item P1532, search, SPARQL

Allowed entity types are Wikibase item (Q29934200): the property may only be used on a certain entity type (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3940#Entity types

Scope is as main value (Q54828448), as reference (Q54828450): the property must be used by specified way only (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3940#Scope, SPARQL

Item “sport (P641): chess (Q718)”: Items with this property should also have “sport (P641): chess (Q718)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303).
List of violations of this constraint: Database reports/Constraint violations/P3940#Item P641, search, SPARQL

This property is being used by: it:Template:Collegamenti esterni ru:Шаблон:OlimpBaseID eo:Ŝablono:365chess/dokumentado, eo:Ŝablono:OlimpBase, eo:Ŝablono:OlimpBase/dokumentado en:Template:OlimpBase player ca:Plantilla:OlimpBase jugador zh-yue:Template:OlimpBase player zh:Template:OlimpBase player yue:Template:OlimpBase player bn:টেমপ্লেট:অলিম্পবেস দাবাড়ু vi:Bản mẫu:OlimpBase player Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Discussion

Problem with female players

This property can not be used for female players (at least not in the configuration at the moment). Female players have a different url in front of their ID. For example, at Anja Hegeler (Q551113), the link leads to http://www.olimpbase.org/players/8y00oauf.html , which gives a 404. Correct would be "http://www.olimpbase.org/playersw/8y00oauf.html" ([1]). At the moment, 226 items have this wrong link:

SELECT ?players ?playersLabel
WHERE
{
    ?players wdt:P106 wd:Q10873124 .
    ?players wdt:P21 wd:Q6581072 .
    ?players wdt:P3940 ?olimpbase.
    
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}

Try it!

Any suggestions how to solve this?Steak (talk) 13:19, 5 June 2017 (UTC)

@MisterSynergy, Wesalius, Edgars2007: Any suggestions?? Steak (talk) 19:18, 16 June 2017 (UTC)

Thanks for ping. The external database has a strange design. We have a couple of options:

• Change formatter url to http://www.olimpbase.org/players$1.html and include the slash and all other extra letters before the slash in the identifier. This would mean that we have to update all identifiers. Should be possible automatically.
• Propose for another identifier for women. However, there are more tokens in use other than '' (male elite) and 'w' (female elite), so I don’t know how many properties we would actually need.

I am in favor of the first option. —MisterSynergy (talk) 19:28, 16 June 2017 (UTC)

Updating the identifier is the way to go. Wesalius (talk) 06:28, 17 June 2017 (UTC)

Ok. Who can change the property and subsequently the items? Steak (talk) 07:40, 21 June 2017 (UTC)

All uses can be found here:

SELECT ?item ?olimpbase ?snak { 
  { ?item p:P3940/ps:P3940 ?olimpbase . BIND('mainsnak' AS ?snak) } UNION 
  { ?item ?anyprop [ pq:P3940 ?olimpbase ] . BIND('qualifier' AS ?snak) } UNION
  { ?item ?anyprop [ prov:wasDerivedFrom [ pr:P3940 ?olimpbase ] ] . BIND('reference' AS ?snak) }
}

Try it!

@Wesalius: do you mean that the formatter url should be changed to http://www.olimpbase.org/players$1.html and the identifier would be whatever should replace $1? This seems doable to be replaced automatically. However, it requires some coding. —MisterSynergy (talk) 15:51, 22 June 2017 (UTC)

yes, that is what I mean. Thanks for your effort on the topic so far. Wesalius (talk) 19:27, 23 June 2017 (UTC)

Okay, I put this to my worklist—which is a bit crowded right now, but it will not get lost. —MisterSynergy (talk) 21:54, 23 June 2017 (UTC)

@Steak, Wesalius: I have meanwhile looked at the identifiers and created a list of new identifier values. Before I can update them, there needs to be some manual work done. First of all there are a couple of items with OlimpBase Chess Olympiad player ID (P3940) links that I cannot find in the index page of the external database:

1. Dinara Saduakassova (Q18388576) -- [2]
2. Hans-Ulrich Grünberg (Q1578225) -- works
3. Hichem Hamdouchi (Q1617234) -- works
4. Hiong Liong Tan (Q2227116) -- [3]
5. Rinat Jumabayev (Q4181620) -- works
6. Ruslan Ponomariov (Q207723) -- [4], [5], [6], [7], [8]
7. Cristhian Cruz Sánchez (Q11691651) -- works

Whether the values given in those items work or not was not yet tested by me. Furthermore, there are 63 items with more that one match for the new identifier. Which one to chose?

1. Sergey Karjakin (Q217198) -- /isk2qyyg, t/isk2qyyg
2. Ticia Gara (Q519335) -- w/91n1zhlb, jg/91n1zhlb
3. Sébastien Mazé (Q1658816) -- /v1b7xnnf, uk/v1b7xnnf
4. Éric Prié (Q2027217) -- /zlj1175a, k/zlj1175a
5. Josif Dorfman (Q1385250) -- e/x51ft55e, /x51ft55e
6. Monika Soćko (Q261896) -- w/6a40wsed, j/6a40wsed
7. Andrei Istrățescu (Q502088) -- e/6ymcq4gi, /6ymcq4gi
8. Bela Soos (Q4526117) -- /4864acga, eq/4864acga
9. Mihai Suba (Q1367139) -- /nrnftvdb, e/nrnftvdb
10. Grażyna Szmacińska (Q9276105) -- w/goc46q0j, to/goc46q0j
11. Anda Šafranska (Q2600515) -- w/2ow6uc4f, v/2ow6uc4f
12. Dario Alzate (Q21088289) -- k/ssssyccd, /ssssyccd
13. Mikhail Tal (Q102664) -- /o8maieuc, st/o8maieuc
14. Bela Toth (Q326562) -- c/zrrl57ba, /zrrl57ba
15. Itchak Radashkovich (Q15820515) -- st/37ldvrdk, /37ldvrdk
16. Igors Rausis (Q1657802) -- c/zzphf9jd, /zzphf9jd
17. Antonio Palacios Lanza (Q18407267) -- /w0e6iykh, cc/w0e6iykh
18. Ángel Martín González (Q1443466) -- c/4c46o04m, /4c46o04m
19. Vlasta Maček (Q9369035) -- w/omaucswd, u/omaucswd
20. Liutsko, Igor (Q4272437) -- c/3t3lflnc, st/3t3lflnc
21. Jiří Lechtýnský (Q1689797) -- /wsm4eeyg, sk/wsm4eeyg
22. Julia Lebel-Arias (Q11728960) -- w/i4e4m6si, /i4e4m6si
23. Gerardo Lebredo Zarragoitia (Q5878310) -- /9hlz5drg, y/9hlz5drg
24. Franciscus Kuijpers (Q2619178) -- k/iuaom22k, /iuaom22k
25. Turhan Yılmaz (Q18408659) -- e/0use4gge, /0use4gge
26. Pavlos Gesos (Q18405467) -- /ugg2w82d, y/ugg2w82d
27. Antonina Dragašević (Q9157822) -- w/ljbz91jj, b/ljbz91jj
28. Jana Maskova (Q11719702) -- u/ln1njz9l, w/ln1njz9l
29. Abdullah Al-Rakib (Q317565) -- k/wksgqqki, /wksgqqki
30. Evgeny Agrest (Q975861) -- /yeuy4wof, st/yeuy4wof
31. Guillermo Estévez Morales (Q5888524) -- /xnjjxnjq, cc/xnjjxnjq
32. Davit Shengelia (Q439610) -- /0osq0mgg, ch/0osq0mgg
33. Slavko Cicak (Q362649) -- /n1rpb9vd, cz/n1rpb9vd
34. Alexander Chernin (Q957014) -- t/zr7fpnhj, /zr7fpnhj
35. Robert Cvek (Q360261) -- /b71r93rc, sk/b71r93rc
36. Ádám Horváth (Q249547) -- c/r5tdrxzd, /r5tdrxzd
37. Vladimir Tukmakov (Q650941) -- /zd7h95nj, t/zd7h95nj
38. Gennadi Timoshchenko (Q363218) -- /k6mi0qck, c/k6mi0qck
39. André Diamant (Q81759) -- /80e68k6e, p/80e68k6e
40. Salvador Gabriel Del Río Angelis (Q3820787) -- /oemwy4qx, c/oemwy4qx
41. John Paul Gomez (Q11727893) -- /j9l1hbdg, ag/j9l1hbdg
42. Ivan Buljovcic (Q17426674) -- e/zbr79d3f, mm/zbr79d3f
43. Alexandru Segal (Q9602520) -- y/okssqucg, /okssqucg
44. Kateryna Rohonyan (Q527815) -- w/pdnbh7pi, eg/pdnbh7pi
45. Andrés Rodríguez Vila (Q9154377) -- /c4agyoum, om/c4agyoum
46. İlhan Onat (Q18406798) -- /y80i46wb, x/y80i46wb
47. Nguyen Duc Hoa (Q18634656) -- /w48me0yf, ag/w48me0yf
48. László Navarovszky (Q17427694) -- e/vjj9793j, y/vjj9793j
49. Willem Muhring (Q4310118) -- x/d51znp9g, /d51znp9g
50. Adrian Mikhalchishin (Q373570) -- /3xht511l, y/3xht511l
51. Evgeny Sveshnikov (Q675955) -- e/622g4ksi, /622g4ksi
52. Vladimir Bagirov (Q944442) -- e/u6qcoagh, /u6qcoagh
53. Aivars Gipslis (Q303455) -- t/hhp3h3rf, e/hhp3h3rf
54. Vladimir Malaniuk (Q586778) -- sc/3zdvndfj, /3zdvndfj
55. Martín Lorenzini (Q6002751) -- /t95ztrnh, cn/t95ztrnh
56. Bogdan Lalić (Q2137386) -- /wgw0o24d, e/wgw0o24d
57. Edvīns Ķeņģis (Q495696) -- /640usyce, k/640usyce
58. Ketino Kachiani (Q89044) -- u/ai8wkacg, w/ai8wkacg
59. Ketevan Arakhamia-Grant (Q451654) -- w/awg64aio, /awg64aio
60. Miodrag Todorcevic (Q2667844) -- e/p9hnp19j, /p9hnp19j
61. Jānis Klovāns (Q495713) -- /fb9bx7ne, y/fb9bx7ne
62. Khayala Abdulla (Q27559787) -- w/kegwk4es, eb/kegwk4es
63. Irina Ionescu (Q11714000) -- sw/55x9pt9e, u/55x9pt9e, w/55x9pt9e

Regards, MisterSynergy (talk) 17:15, 25 June 2017 (UTC)

Some of the given IDs work, for the other I added next to the link above the correct link(s). Sometimes there are quite a lot of profiles. I think this was not considered in the proposal. At the moment the whole property is a bit questionable. Steak (talk) 17:53, 25 June 2017 (UTC)

Thanks; I suggest to update the links manually checked by you manually as well in the items, once we changed the formatter URL. The external database has indeed some flaws, but I’d still consider it valuable. There will be some single value constraints, but this is the case for most external id properties. —MisterSynergy (talk) 18:00, 25 June 2017 (UTC)

One should have always only one link, namely that one to the Olympiads Statistics. All others can be reached via the dropdown menu on each profile page. If there are then still two different proile pages, this is a database duplicate (two spellings, marriage,....). Steak (talk) 18:23, 25 June 2017 (UTC)

I tried to identify the ones to use then. There are still some duplicates due to players who apparently attended male (open) and female olimpiads; there are also a couple of new players which need to be looked up manually. —MisterSynergy (talk) 18:30, 25 June 2017 (UTC)

Something has to happen here, the problem still exists. Steak (talk) 13:05, 16 December 2017 (UTC)

I agree. It is still on my worklist, but apparently not with high priority :-) —MisterSynergy (talk) 08:28, 17 December 2017 (UTC)

May 2018

To make progress here, there is a now a section in the Con-Vio list that lists all female players with the non-working link. Steak (talk) 14:15, 17 May 2018 (UTC)

After having looked at the problem once again, I tend to propose for a new property for Women's Olympiad participants, in contrast to this Open Olympiad property. The new property would have its own formatter URL (including the w), and this property P3940 could also be used for women who participated in the open Olympiad. —MisterSynergy (talk) 07:21, 20 May 2018 (UTC)

Right, I forgot about the female players taking part at the open event, for which the link works. I agree that under this circumstances, a new property would be the best solution. Steak (talk) 08:33, 21 May 2018 (UTC)

The website has information about other competitions beyond Open and Women Olympiads as well. Do you think we should consider them to be relevant for Wikidata, or can we just ignore them? —MisterSynergy (talk) 09:06, 21 May 2018 (UTC)

I would ignore them, at least for the moment. This website has a crappy URL and ID system, so we should not invest too much time in it. Steak (talk) 09:41, 21 May 2018 (UTC)

Okay. One could use described at URL (P973) for players that have an entry in that database, but didn’t compete at the Open or Women’s Olympiad.
Are you going to propose a new property, or shall I? We also need to adjust labels of this one, I think. —MisterSynergy (talk) 10:31, 21 May 2018 (UTC)

I would be grateful if you could do it :) Steak (talk) 13:46, 21 May 2018 (UTC)

Here we go: Wikidata:Property proposal/OlimpBase Women's Chess Olympiad player ID —MisterSynergy (talk) 14:56, 21 May 2018 (UTC)

Thanks! Steak (talk) 18:45, 21 May 2018 (UTC)

OlimpBase Women's Chess Olympiad player ID (P5224)

There is now a new property OlimpBase Women's Chess Olympiad player ID (P5224) for the participants of the Women's Chess Olympiad. If noone else does, I’ll move the affected claim to that property soon. —MisterSynergy (talk) 13:56, 31 May 2018 (UTC)

All invalid P3940 suitable for the new property have now been moved. The old ever invalid ones with P3940 have been removed. —MisterSynergy (talk) 19:36, 31 May 2018 (UTC)

Thank you! So this issue has finally been resolved after less than one year ;) Steak (talk) 10:55, 1 June 2018 (UTC)

Mix'n'Match

There is a Mix-n-match catalog with all olimpbase IDs to match to items. Steak (talk) 21:40, 9 October 2019 (UTC)