User:MisterSynergy/rowing/P214 for rowers

Background edit

Entries in the VIAF database (see VIAF ID (P214) property) are typically not about sportspersons. However, some sportspersons are covered by this database.

VIAF & English Wikipedia have performed automatic matching of Wikipedia articles and VIAF entries repeatedly since 2012 (see en:Wikipedia:Authority control integration proposal). This means that Wikipedia articles were linked from VIAF entries, and Wikipedia articles linked to VIAF entries via the {{Authority control}} template. Details can be found at en:User:VIAFbot in English Wikipedia. The links to Wikipedia within VIAF have later been translated to Wikidata items, and inversely imported to Wikidata as well by several users.

Although details about the matching are not known to me, I suspect that they matched based on identical names and years of birth. This yields a lot of matches, but mistakes are unavoidable and VIAF ID (P214) claims in sportsperson items should be used very carefully. The same applies for identifiers that have been imported from VIAF. This page tries to rate and repair all affected items about rowers.

The ISNI database (International Standard Name Identifier (Q423048) with ISNI (P213)) has similar problems with lots of crappy entries. Maybe another page will be set up in future for them as well if it turns out that they actually care about Wikidata.

Useful tools edit

Identifier resolver

Blacklist edit

(There is also a #Whitelist).

Items that likely need to be fixed edit

Items that definitely need to be fixed edit

Items that need review in future edit

Brenda Taylor (Q276131)
Franz Held (Q532334)
Brad Alan Lewis (Q4953772)
Christian Hansen (Q1806150)
Hugo Waser (Q5934588) ([1] and [2])
Grzegorz Nowak (Q3118308) ([3])
Rune Andersson (Q9324017)
Hans Homberger (Q452821) (only GND name entry)
Friedrich Eduard Keller (Q1458919) (only GND name entry)
Vyacheslav Ivanov (Q521844)
William Stevenson (Q8018807)
Barbara Müller (Q47259337)
Wolfgang Groß (Q47455016)
Roland Opfer (Q47469682)
Karl Müller (Q47470773)
Kim Jeong-nam (Q56488638)
Michael Pedersen (Q61715666)
Katharina Fricke (Q61740830)
Katja Rügner (Q61740993)

ISNI repairs edit

Per Andersson (Q47492207)
Jan Hansen (Q45169016)
Roland Opfer (Q47469682)
Tamás Varga (Q1401848)
Paul Tessier (Q47468926)
Matthew Collins (Q43380460)
Muhammad Akram (Q47491933)
Jens Jensen (Q47482064) (different date of birth)
John Hudson (Q47466474) (different second name)
Robert Southey (Q20642555) (different second initial)
Karl Müller (Q47470773) (very likely different)
Aukje Zuidema (Q47358688) (no idea, only little information available)
Rob Williams (Q42435291) (different date of birth)
Colin Porter (Q47467005) (difficult; date of birth seems to match, but everything else not)
Jim Walker (Q47430749) (clearly different)
Hedi Poot (Q47359802) (sparse information)
Brian Doyle (Q4963614) (different person)
Eva Hengst (Q9256475) (sparse information)
Li Yang (Q47482688) (different person)
Bill Mason (Q21063782) (very likely different)
Andrew Lonmon-Davis (Q47491648) (different person)
Katherine Jones (Q47431807) (different person)
Jan Müller (Q11718472) (very likely different)
James Brown (Q47414128) (very likely different)
Geoffrey Stewart (Q5534915) (different person)

ISNI completely unchecked edit

…

Solved cases edit

VIAF seems to crawl Wikidata roughly monthly and adjusts identifiers on their side based on our P214 statements.
See also: #Whitelist of items where the P214 property has been used properly in rowing person items.

Changes not (yet) recognized by VIAF edit

Dealt with by removal of VIAF identifier, which is ignored by VIAF edit

Tamás Varga (Q1401848) and 33144713

Set to deprecated rank edit

Dealt with by creation of new items edit

Fernando Molina (Q43058691) moved 61059434 to Fernando Molina (Q116881271)
Andrew Lonmon-Davis (Q47491648) moved 117053635 to Andy Davis (Q116881493)
Lennart Andersson (Q11754141) moved 4152975 to Lennart Andersson (Q116882006)
Moritz Koch (Q11785559) moved 170693638 to Moritz Koch (Q116883911)
Wiebke Petersen (Q81550282) moved 121650702 to Wiebke Petersen (Q116886699)

Changes recognized by VIAF edit

Query edit

SELECT
  (COUNT(?viaf) AS ?cnt)
  (GROUP_CONCAT(?raw_viaf; separator='<br />') AS ?viaf_ids)
  ?item
  ?itemDescription
WITH {
  SELECT
    DISTINCT ?item
  WHERE {
    ?item p:P106/ps:P106/wdt:P279* wd:Q26270618; p:P214 [] .
    FILTER(?item NOT IN ( wd:Q52679, wd:Q52680, wd:Q70521, wd:Q77792, wd:Q78343, wd:Q86299, wd:Q90339, wd:Q90367, wd:Q91303, wd:Q91305, wd:Q92441, wd:Q98971, wd:Q99345, wd:Q99411, wd:Q107700, wd:Q102457, wd:Q109259, wd:Q129679, wd:Q169044, wd:Q173328, wd:Q177039, wd:Q198021, wd:Q210852, wd:Q274232, wd:Q310694, wd:Q333887, wd:Q349970, wd:Q373892, wd:Q377053, wd:Q433309, wd:Q435707, wd:Q438702, wd:Q457058, wd:Q475791, wd:Q505165, wd:Q509774, wd:Q512148, wd:Q512638, wd:Q520395, wd:Q522909, wd:Q527992, wd:Q529946, wd:Q530559, wd:Q530803, wd:Q532644, wd:Q534063, wd:Q563810, wd:Q598182, wd:Q674112, wd:Q685669, wd:Q699844, wd:Q704436, wd:Q771696, wd:Q775598, wd:Q785494, wd:Q819948, wd:Q822490, wd:Q823476, wd:Q827878, wd:Q830003, wd:Q831193, wd:Q831655, wd:Q870752, wd:Q887087, wd:Q930268, wd:Q940463, wd:Q948287, wd:Q970076, wd:Q1026509, wd:Q1068577, wd:Q1078933, wd:Q1099445, wd:Q1104100, wd:Q1123980, wd:Q1222490, wd:Q1236699, wd:Q1304236, wd:Q1351518, wd:Q1369135, wd:Q1369693, wd:Q1388615, wd:Q1462959, wd:Q1506667, wd:Q1521436, wd:Q1532332, wd:Q1538010, wd:Q1545412, wd:Q1559066, wd:Q1580073, wd:Q1600812, wd:Q1603859, wd:Q1629733, wd:Q1680215, wd:Q1682360, wd:Q1682727, wd:Q1754999, wd:Q1804470, wd:Q1948441, wd:Q1962463, wd:Q1974390, wd:Q2007313, wd:Q2040195, wd:Q2077287, wd:Q2140399, wd:Q2143706, wd:Q2146223, wd:Q2176533, wd:Q2231989, wd:Q2338109, wd:Q2429244, wd:Q2447527, wd:Q2469697, wd:Q2479548, wd:Q2546191, wd:Q2546830, wd:Q2678718, wd:Q2741085, wd:Q2835412, wd:Q2836621, wd:Q2837163, wd:Q2849386, wd:Q2863319, wd:Q2959331, wd:Q3072258, wd:Q3079136, wd:Q3109829, wd:Q3129842, wd:Q3181856, wd:Q3353094, wd:Q3353097, wd:Q3419243, wd:Q3433775, wd:Q3441227, wd:Q3505507, wd:Q3505616, wd:Q3505706, wd:Q3508391, wd:Q3569517, wd:Q3655327, wd:Q3701746, wd:Q3750942, wd:Q3837055, wd:Q4101599, wd:Q4196418, wd:Q4314049, wd:Q4493831, wd:Q4684912, wd:Q4717717, wd:Q4727079, wd:Q4762703, wd:Q4773386, wd:Q4786402, wd:Q4898905, wd:Q4945362, wd:Q5056340, wd:Q5075547, wd:Q5077072, wd:Q5081739, wd:Q5134482, wd:Q5214413, wd:Q5234612, wd:Q5248512, wd:Q5290604, wd:Q5344452, wd:Q5346263, wd:Q5490368, wd:Q5492580, wd:Q5538488, wd:Q5546052, wd:Q5667943, wd:Q5719475, wd:Q5728455, wd:Q5769054, wd:Q6131978, wd:Q6182404, wd:Q6198070, wd:Q6226243, wd:Q6231235, wd:Q6235627, wd:Q6254892, wd:Q6287965, wd:Q6348919, wd:Q6383802, wd:Q6526356, wd:Q6699144, wd:Q6742179, wd:Q6765753, wd:Q6769287, wd:Q6775232, wd:Q6780285, wd:Q6820893, wd:Q6835229, wd:Q6836986, wd:Q6985998, wd:Q7036768, wd:Q7141742, wd:Q7146258, wd:Q7153995, wd:Q7273520, wd:Q7323790, wd:Q7341229, wd:Q7358397, wd:Q7375304, wd:Q7422665, wd:Q7702006, wd:Q7789938, wd:Q7790851, wd:Q7803375, wd:Q7803521, wd:Q7809280, wd:Q7818478, wd:Q7851269, wd:Q7878908, wd:Q7926895, wd:Q7965254, wd:Q8007298, wd:Q8020115, wd:Q9152652, wd:Q9191156, wd:Q9368612, wd:Q9388286, wd:Q11730933, wd:Q11973447, wd:Q12025112, wd:Q12025260, wd:Q12369736, wd:Q13424191, wd:Q13578750, wd:Q14291996, wd:Q14545273, wd:Q15043735, wd:Q15070053, wd:Q15070966, wd:Q15441916, wd:Q15460907, wd:Q15974165, wd:Q15978553, wd:Q15989862, wd:Q15996947, wd:Q16008101, wd:Q16031643, wd:Q16066519, wd:Q16107501, wd:Q16115555, wd:Q16196573, wd:Q16556667, wd:Q16944187, wd:Q17217406, wd:Q17421365, wd:Q18027097, wd:Q18608890, wd:Q18642000, wd:Q18752972, wd:Q19826246, wd:Q20712225, wd:Q21183725, wd:Q21605386, wd:Q23683405, wd:Q24192149, wd:Q24540136, wd:Q24545965, wd:Q24546031, wd:Q26267171, wd:Q28870200, wd:Q29429584, wd:Q30083528, wd:Q47452757, wd:Q47454902, wd:Q47455082, wd:Q55426206, wd:Q56085746, wd:Q61721789, wd:Q61740974, wd:Q81550282 )) . # whitelist, comma-separated Q-items with wd: prefix
    FILTER(?item NOT IN ( wd:Q7351155, wd:Q16105518, wd:Q1444024, wd:Q1901850, wd:Q827116, wd:Q8048499, wd:Q3503152, wd:Q119685, wd:Q4760368, wd:Q276131, wd:Q532334, wd:Q4953772, wd:Q1806150, wd:Q2146223, wd:Q5934588, wd:Q3118308, wd:Q9324017 )) . # blacklist, comma-separated Q-items with wd: prefix
  }
} AS %subquery
WHERE {
  INCLUDE %subquery 
  ?item p:P214 [ ps:P214 ?viaf; wikibase:rank ?rank ] .
  BIND(CONCAT(SUBSTR(STR(?rank), 27), ': [https://viaf.org/viaf/', STR(?viaf), '/ ', STR(?viaf), ']') AS ?raw_viaf) .
  BIND(xsd:integer(SUBSTR(STR(?item), 33)) AS ?num_id).
  SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' }
}
GROUP BY ?item ?itemDescription
ORDER BY ASC(?num_id)

Try it!

Static worklist edit

Last update: 2018-06-17; generated from the SPARQL query listed above.

cnt_P214	viaf_ids	item	description
none at the moment

Whitelist edit

(Items with checked VIAF ID)

Q52679
Q52680
Q70521
Q77792
Q78343
Q86299
Q90339
Q90367
Q91303
Q91305
Q92441
Q98971
Q99345
Q99411
Q107700
Q102457
Q109259
Q129679
Q169044
Q173328
Q177039
Q198021
Q210852
Q274232
Q310694
Q333887
Q349970
Q373892
Q377053
Q433309
Q435707
Q438702
Q457058
Q475791
Q505165
Q509774
Q512148
Q512638
Q520395
Q522909
Q527992
Q529946
Q530559
Q530803
Q532644
Q534063
Q563810
Q598182
Q674112
Q685669
Q699844
Q704436
Q771696
Q775598
Q785494
Q819948
Q822490
Q823476
Q827878
Q830003
Q831193
Q831655
Q870752
Q887087
Q930268
Q940463
Q948287
Q970076
Q1026509
Q1068577
Q1078933
Q1099445
Q1104100
Q1123980
Q1222490
Q1236699
Q1304236
Q1351518
Q1369135
Q1369693
Q1388615
Q1462959
Q1506667
Q1521436
Q1532332
Q1538010
Q1545412
Q1559066
Q1580073
Q1600812
Q1603859
Q1629733
Q1680215
Q1682360
Q1682727
Q1754999
Q1804470
Q1948441
Q1962463
Q1974390
Q2007313
Q2040195
Q2077287
Q2140399
Q2143706
Q2146223
Q2176533
Q2231989
Q2338109
Q2429244
Q2447527
Q2469697
Q2479548
Q2546191
Q2546830
Q2678718
Q2741085
Q2835412
Q2836621
Q2837163
Q2849386
Q2863319
Q2959331
Q3072258
Q3079136
Q3109829
Q3129842
Q3181856
Q3353094
Q3353097
Q3419243
Q3433775
Q3441227
Q3505507
Q3505616
Q3505706
Q3508391
Q3569517
Q3655327
Q3701746
Q3750942
Q3837055
Q4101599
Q4196418
Q4314049
Q4493831
Q4684912
Q4717717
Q4727079
Q4762703
Q4773386
Q4786402
Q4898905
Q4945362
Q5056340
Q5075547
Q5077072
Q5081739
Q5134482
Q5214413
Q5234612
Q5248512
Q5290604
Q5344452
Q5346263
Q5490368
Q5492580
Q5538488
Q5546052
Q5667943
Q5719475
Q5728455
Q5769054
Q6131978
Q6182404
Q6198070
Q6226243
Q6231235
Q6235627
Q6254892
Q6287965
Q6348919
Q6383802
Q6526356
Q6699144
Q6742179
Q6765753
Q6769287
Q6775232
Q6780285
Q6820893
Q6835229
Q6836986
Q6985998
Q7036768
Q7141742
Q7146258
Q7153995
Q7273520
Q7323790
Q7341229
Q7358397
Q7375304
Q7422665
Q7702006
Q7789938
Q7790851
Q7803375
Q7803521
Q7809280
Q7818478
Q7851269
Q7878908
Q7926895
Q7965254
Q8007298
Q8020115
Q9152652
Q9191146
Q9191156
Q9368612
Q9388286
Q11730933
Q11973447
Q12025112
Q12025260
Q12369736
Q12372773
Q13424191
Q13578750
Q14291996
Q14545273
Q15043735
Q15070053
Q15070966
Q15441916
Q15460907
Q15974165
Q15978553
Q15989862
Q15996947
Q16008101
Q16031643
Q16066519
Q16107501
Q16115555
Q16196573
Q16404117
Q16556667
Q16944187
Q17217406
Q17421365
Q18027097
Q18608890
Q18642000
Q18752972
Q19826246
Q20712225
Q21183725
Q21605386
Q23683405
Q24192149
Q24540136
Q24545965
Q24546031
Q26267171
Q28870200
Q29429584
Q30083528
Q43086871
Q47452757
Q47454147
Q47454902
Q47455082
Q47467005
Q47467085
Q47482524
Q55426206
Q56085746
Q61721789
Q61740974
Q63977199
Q81550282

User:MisterSynergy/rowing/P214 for rowers

Background edit

Useful tools edit

Blacklist edit

Items that likely need to be fixed edit

Items that definitely need to be fixed edit

Items that need review in future edit

ISNI repairs edit

ISNI completely unchecked edit

Solved cases edit

Changes not (yet) recognized by VIAF edit

Dealt with by removal of VIAF identifier, which is ignored by VIAF edit

Set to deprecated rank edit

Dealt with by creation of new items edit

Changes recognized by VIAF edit

Dealt with by creation of new items edit

Dealt with by moving to other item edit

Dealt with by replacing with another VIAF ID edit

Query edit

Static worklist edit

Whitelist edit