Property talk:P650

Documentation

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

RKDartists ID
identifier in the RKDartists database (Rijksbureau voor Kunsthistorische Documentatie)

Description	ID of a person in the RKDartists (Q17299517) database, by Netherlands Institute for Art History (Q758610)
Associated item	Netherlands Institute for Art History (Q758610), Netherlands Institute for Art History (Q758610)
Applicable "stated in" value	RKDartists (Q17299517)
Data type	External identifier
Corresponding template	no label (Q6062290)
Domain	According to this template: artists, mostly Dutch According to statements in the property: human (Q5), group of humans (Q16334295), art gallery (Q1007870) or organization (Q43229) When possible, data should only be stored as statements
Allowed values	[1-9]\d{0,5}
Example	Rembrandt (Q5598) → 66219 (RDF) Piet Mondrian (Q151803) → 56854 (RDF) Peter Paul Rubens (Q5599) → 68737 (RDF) Anthony van Dyck (Q150679) → 25230 (RDF)
Source	https://rkd.nl/artists
Formatter URL	https://rkd.nl/artists/$1 https://rkd.nl/nl/explore/artists/$1 https://rkd.nl/en/explore/artists/$1 https://api.rkd.nl/api/record/artists/$1?format=json
Tracking: usage	Category:Pages with RKDartists identifiers (Q19328865)
Related to country	Netherlands (Q55) (See 108 others)
See also	RKDimages ID (P350), Biografisch Portaal van Nederland ID (P651), RKDlibrary ID (P4989), artist-info curator ID (P5488), artist-info artist ID (P5489), artist-info location ID (P5490), RKD thesaurus ID (P8519)
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 Mix'n'match (Report) Database reports/Complex constraint violations/P650 Database reports/Humans with missing claims/P650 Database reports/Constraint violations/P650 Map Random list
Proposal discussion	Proposal discussion
Current uses	Total 179,197 Main statement 113,562 out of 379,787 (30% complete) 63.4% of uses Qualifier 11 <0.1% of uses Reference 65,624 36.6% of uses
Search for values

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

Format “[1-9]\d{0,5}”: value must be formatted using this pattern (PCRE syntax). (Help)

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

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

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Master of 1518 (Q328571), Jan van Dornicke (Q1398277), Robert Campin (Q80442), Master of Flémalle (Q653719), Lancelot Volders (Q2195865), Johann Georg Fischer (Q6215854), Georg Vischer (Q43189023), Master of the Parlement de Paris (Q46999168), André d’Ypres (Q523603)
List of violations of this constraint: Database reports/Constraint violations/P650#Unique value, SPARQL (every item), SPARQL (by value)

Single best value: this property generally contains a single value. If there are several, one would have preferred rank (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/P650#single best value, 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/P650#Entity types

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

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

Type “human (Q5), group of humans (Q16334295), art gallery (Q1007870), organization (Q43229)”: item must contain property “instance of (P31)” with classes “human (Q5), group of humans (Q16334295), art gallery (Q1007870), organization (Q43229)” or their subclasses (defined using subclass of (P279)). (Help)

List of violations of this constraint: Database reports/Constraint violations/P650#Type Q5, Q16334295, Q1007870, Q43229, hourly updated report, SPARQL

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

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Q1099678, Q13573743, Q13574446, Q14228508, Q1439475, Q14634037, Q15493945, Q15526397, Q15875480, Q1589850, Q15943341, Q15991773, Q16069188, Q16993773, Q17142911, Q1748346, Q1797744, Q18071292, Q1822197, Q38467310, Q18822434, Q1888416, Q18919067, Q1926163, Q19299031, Q19666471, Q19803414, Q1993919, Q20638632, Q20870811, Q21005079, Q21544562, Q21645267, Q217816, Q2209240, Q22236673, Q22237065, Q21000609, Q22237359, Q2388211, Q24073737, Q24203923, Q24203929, Q2526104, Q2545734, Q2626152, Q2627891, Q2663996, Q27077632, Q2707765, Q27077687, Q283498, Q2914571, Q308776, Q3089480, Q3100287, Q316015, Q3198515, Q3214462, Q3959046, Q4797215, Q479864, Q5073315, Q5094263, Q515658, Q558276, Q574985, Q6038716, Q605786, Q6177802, Q6486180, Q6800851, Q684974, Q705085, Q754070, Q7761662, Q7795856, Q7918004, Q7983071, Q8071084, Q818259, Q871395, Q89727, Q953124, Q867205, Q1490083, Q7088410, Q29556914, Q2189769, Q2352911, Q2073589, Q47460178, Q27897924, Q1260224, Q38489267, Q1881793, Q207445, Q1238892, Q29557089, Q29048221, Q29554378, Q38297879, Q29554100, Q826482, Q27926150, Q29939454, Q2892413, Q30303390, Q29386526, Q27571, Q731126, Q49655, Q29436129, Q2180083, Q1865768, Q2243734, Q903805, Q29428495, Q29053201, Q2074726, Q23305659, Q40315207, Q29574211, Q1333026, Q42623606, Q6682566, Q29574870, Q29554392, Q20857976, Q29556272, Q2739861, Q29939705, Q27489, Q2915356, Q29414882, Q29554521, Q44253877, Q2738000, Q41881733, Q24962958, Q6914781, Q2343811, Q27503770, Q32860543, Q25859566, Q55965, Q21996840, Q29553994, Q29552551, Q1299, Q42304504, Q29436272, Q31407686, Q38482157, Q41598502, Q214480, Q2250620, Q51473493, Q29554535, Q2061432, Q327570, Q27518065, Q29554374, Q812285, Q29413991, Q29554029, Q1149137, Q7628200, Q21287805, Q850181, Q29551841, Q932801, Q40903591, Q241338, Q29554517, Q32933803, Q23076, Q29019701, Q29422228, Q42424625, Q29405771, Q29436149, Q29436301, Q29436304, Q33196083, Q21469865, Q27508473, Q29884436, Q19862319, Q29221787, Q52557282, Q4517304, Q29045171, Q54002344, Q56259116, Q56606033, Q18821838, Q55891030, Q317616, Q28872849, Q55847926, Q21936832, Q29557121, Q29554171, Q55631253, Q21557453, Q56685452, Q56290869, Q55791862, Q47163, Q2133205, Q55064710, Q2014154, Q56493121, Q28846440, Q49801778, Q56739569, Q55747372, Q5042800, Q15450975, Q17112425, Q2708181, Q58230433, Q54914116, Q2699506, Q55602908, Q2460608
List of violations of this constraint: Database reports/Constraint violations/P650#Item P106, search, SPARQL

Item “sex or gender (P21)”: Items with this property should also have “sex or gender (P21)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Q1099678, Q13573743, Q13574446, Q14228508, Q1439475, Q14634037, Q15493945, Q15526397, Q15875480, Q1589850, Q15943341, Q15991773, Q16069188, Q16993773, Q17142911, Q1748346, Q1797744, Q18071292, Q1822197, Q18774717, Q18822434, Q1888416, Q18919067, Q1926163, Q19299031, Q19666471, Q19803414, Q1993919, Q20638632, Q20870811, Q21005079, Q21544562, Q21645267, Q217816, Q2209240, Q22236673, Q22237065, Q21000609, Q22237359, Q2388211, Q24073737, Q24203923, Q24203929, Q2526104, Q2545734, Q2626152, Q2627891, Q2663996, Q27077632, Q2707765, Q27077687, Q283498, Q2914571, Q308776, Q3089480, Q3100287, Q316015, Q3198515, Q3214462, Q3959046, Q4797215, Q479864, Q5073315, Q5094263, Q515658, Q558276, Q574985, Q6038716, Q605786, Q6177802, Q6486180, Q6800851, Q684974, Q705085, Q754070, Q7761662, Q7795856, Q7918004, Q7983071, Q8071084, Q818259, Q871395, Q89727, Q953124, Q867205, Q1490083, Q7088410, Q826482, Q850181, Q903805, Q932801, Q1149137, Q1238892, Q1260224, Q1865768, Q1881793, Q2061432, Q2073589, Q2074726, Q2180083, Q2189769, Q2250620, Q2738000, Q2892413, Q2915356, Q6682566, Q21469865, Q1333026, Q25859566, Q29048221, Q29053201, Q29386526, Q29413991, Q29556914, Q2352911, Q47460178, Q27897924, Q38489267, Q207445, Q29557089, Q29554378, Q38297879, Q29554100, Q27926150, Q29939454, Q30303390, Q27571, Q731126, Q49655, Q29436129, Q2243734, Q29428495, Q23305659, Q40315207, Q29574211, Q42623606, Q29574870, Q29554392, Q38467310, Q20857976, Q29556272, Q2739861, Q29939705, Q27489, Q29414882, Q29554521, Q44253877, Q41881733, Q24962958, Q6914781, Q2343811, Q27503770, Q32860543, Q55965, Q21996840, Q29553994, Q29552551, Q1299, Q42304504, Q29436272, Q31407686, Q38482157, Q41598502, Q214480, Q51473493, Q29554535, Q327570, Q27518065, Q29554374, Q812285, Q29554029, Q7628200, Q21287805, Q29551841, Q40903591, Q241338, Q29554517, Q32933803, Q23076, Q29019701, Q29422228, Q42424625, Q29405771, Q29436149, Q29436301, Q29436304, Q33196083, Q27508473, Q29884436, Q19862319, Q29221787, Q52557282, Q4517304, Q29045171, Q54002344, Q56259116, Q56606033, Q18821838, Q55891030, Q317616, Q28872849, Q55847926, Q21936832, Q29557121, Q29554171, Q55631253, Q21557453, Q56685452, Q56290869, Q55791862, Q47163, Q2133205, Q55064710, Q2014154, Q56493121, Q28846440, Q49801778, Q56739569, Q55747372, Q5042800, Q15450975, Q17112425, Q2708181, Q58230433, Q54914116, Q2699506, Q55602908, Q2460608, Q101208458
List of violations of this constraint: Database reports/Constraint violations/P650#Item P21, search, SPARQL

Item “date of birth (P569)”: Items with this property should also have “date of birth (P569)”. (Help)

Exceptions are possible as rare values may exist. Exceptions can be specified using exception to constraint (P2303). Known exceptions: Q1099678, Q13573743, Q13574446, Q14228508, Q1439475, Q14634037, Q15493945, Q15526397, Q15875480, Q1589850, Q15943341, Q15991773, Q16069188, Q16993773, Q17142911, Q1748346, Q1797744, Q18071292, Q1822197, Q18774717, Q18822434, Q1888416, Q18919067, Q1926163, Q19299031, Q19666471, Q19803414, Q1993919, Q20638632, Q20870811, Q21005079, Q21544562, Q21645267, Q217816, Q2209240, Q22236673, Q22237065, Q21000609, Q22237359, Q2388211, Q24073737, Q24203923, Q24203929, Q2526104, Q2545734, Q2626152, Q2627891, Q2663996, Q27077632, Q2707765, Q27077687, Q283498, Q2914571, Q308776, Q3089480, Q3100287, Q316015, Q3198515, Q3214462, Q3959046, Q4797215, Q479864, Q5073315, Q5094263, Q515658, Q558276, Q574985, Q6038716, Q605786, Q6177802, Q6486180, Q6800851, Q684974, Q705085, Q754070, Q7761662, Q7795856, Q7918004, Q7983071, Q8071084, Q818259, Q871395, Q89727, Q953124, Q867205, Q1490083, Q7088410, Q29556914, Q2189769, Q2352911, Q2073589, Q47460178, Q27897924, Q1260224, Q38489267, Q1881793, Q207445, Q1238892, Q29557089, Q29048221, Q29554378, Q38297879, Q29554100, Q826482, Q27926150, Q29939454, Q2892413, Q30303390, Q29386526, Q27571, Q731126, Q49655, Q29436129, Q2180083, Q1865768, Q2243734, Q903805, Q29428495, Q29053201, Q2074726, Q23305659, Q40315207, Q29574211, Q1333026, Q42623606, Q6682566, Q29574870, Q29554392, Q38467310, Q20857976, Q29556272, Q2739861, Q29939705, Q27489, Q2915356, Q29414882, Q29554521, Q44253877, Q2738000, Q41881733, Q24962958, Q6914781, Q2343811, Q27503770, Q32860543, Q25859566, Q55965, Q21996840, Q29553994, Q29552551, Q1299, Q42304504, Q29436272, Q31407686, Q38482157, Q41598502, Q214480, Q2250620, Q51473493, Q29554535, Q2061432, Q327570, Q27518065, Q29554374, Q812285, Q29413991, Q29554029, Q1149137, Q7628200, Q21287805, Q850181, Q29551841, Q932801, Q40903591, Q241338, Q29554517, Q32933803, Q23076, Q29019701, Q29422228, Q42424625, Q29405771, Q29436149, Q29436301, Q29436304, Q33196083, Q21469865, Q27508473, Q29884436, Q19862319, Q29221787, Q52557282, Q4517304, Q29045171, Q54002344, Q56259116, Q56606033, Q18821838, Q55891030, Q317616, Q28872849, Q55847926, Q21936832, Q29557121, Q29554171, Q55631253, Q21557453, Q56685452, Q56290869, Q55791862, Q47163, Q2133205, Q55064710, Q2014154, Q56493121, Q28846440, Q49801778, Q56739569, Q55747372, Q5042800, Q15450975, Q17112425, Q2708181, Q58230433, Q54914116, Q2699506, Q55602908, Q2460608, Q101208458
List of violations of this constraint: Database reports/Constraint violations/P650#Item P569, SPARQL

Conflicts with “RKDimages ID (P350)”: this property must not be used with the listed properties and values. (Help)

List of violations of this constraint: Database reports/Constraint violations/P650#Conflicts with P350, hourly updated report, search, SPARQL

Conflicts with “RKDlibrary ID (P4989)”: this property must not be used with the listed properties and values. (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/P650#Conflicts with P4989, search, SPARQL

Label required in languages: en: Entities using this property should have labels in one of the following languages: en (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/P650#Label in 'en' language, search, SPARQL

Label required in languages: nl: Entities using this property should have labels in one of the following languages: nl (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/P650#Label in 'nl' language, search, SPARQL

Label required in languages: de: Entities using this property should have labels in one of the following languages: de (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/P650#Label in 'de' language, search, SPARQL

Label required in languages: fr: Entities using this property should have labels in one of the following languages: fr (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/P650#Label in 'fr' language, search, SPARQL

Label required in languages: es: Entities using this property should have labels in one of the following languages: es (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/P650#Label in 'es' language, search, SPARQL

Description required in languages: nl: Entities using this property should have descriptions in one of the following languages: nl (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/P650#Description in 'nl' language, search, SPARQL

Label required in languages: pt: Entities using this property should have labels in one of the following languages: pt (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/P650#Label in 'pt' language, search, SPARQL

Label required in languages: it: Entities using this property should have labels in one of the following languages: it (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/P650#Label in 'it' language, search, SPARQL

Works with creator missing link
List of works that have RKDimages ID (P350) set, but that creator doesn't have a RKDartists ID (P650) link (Help)
Violations query: SELECT ?item ?creator { ?item p:P350 []. ?item wdt:P170/wdt:P31 wd:Q5 . FILTER NOT EXISTS { ?item wdt:P170/wdt:P650 [] } } ORDER BY ?creator
List of this constraint violations: Database reports/Complex constraint violations/P650#Works with creator missing link

Probably death
People with RKDartists ID (P650) born before the year 1900, but no date of death (P570) (Help)
Violations query: SELECT DISTINCT ?item WHERE { ?item wdt:P650 [] . ?item p:P569 ?birthclaim . MINUS { ?item p:P570 [] } ?birthclaim ps:P569 ?birth . FILTER(?birth < "+1900-00-15T00:00:00Z"^^xsd:dateTime) . } ORDER BY ?birth LIMIT 1000
List of this constraint violations: Database reports/Complex constraint violations/P650#Probably death

Biografisch Portaal artists without RKDartists
People with Biografisch Portaal van Nederland ID (P651) and occupation (P106) (or subclass) visual artist (Q3391743), but no RKDartists ID (P650) (Help)
Violations query: SELECT DISTINCT ?item WHERE { ?item wdt:P651 [] . { ?item wdt:P106/wdt:P279* wd:Q3391743 . } UNION { ?item wdt:P106/wdt:P279* wd:Q5322166 } MINUS {?item wdt:P650 [] . } . # This is the exceptions list MINUS {VALUES ?item {wd:Q84841 wd:Q968254 wd:Q1433073 wd:Q2010943 wd:Q2094344 wd:Q2161324} } }
List of this constraint violations: Database reports/Complex constraint violations/P650#Biografisch Portaal artists without RKDartists

20th-century artists without nationality
People with RKDartists ID (P650) born after 1900, but no country of citizenship (P27) (Help)
Violations query: SELECT DISTINCT ?item WHERE { ?item wdt:P650 [] . ?item p:P569 ?birthclaim . MINUS { ?item p:P27 [] } ?birthclaim ps:P569 ?birth . FILTER(?birth > "+1900-00-00T00:00:00Z"^^xsd:dateTime) . } ORDER BY ?birth LIMIT 1000
List of this constraint violations: Database reports/Complex constraint violations/P650#20th-century artists without nationality

No profession in visual art or design
People with occupation (P106) but without a visual artist (Q3391743) or designer (Q5322166) profession (Help)
Violations query: SELECT DISTINCT ?item { ?item p:P650 []. ?item p:P106 []. ?item wdt:P31 wd:Q5. MINUS { VALUES ?occ { wd:Q3391743 wd:Q5322166 } ?item wdt:P106/wdt:P279* ?occ }. } LIMIT 1000
List of this constraint violations: Database reports/Complex constraint violations/P650#No profession in visual art or design

Possible disambiguation in key language label
Items with RKDartists ID (P650) with a label in either Dutch, English, German or French that looks like a disambiguation. (Help)
Violations query: SELECT DISTINCT ?item ?label WHERE { VALUES ?lang { "de" "en" "fr" "nl" } . ?item wdt:P650 ?rkdid . ?item rdfs:label ?label . FILTER (REGEX(STR(?label), ".*\\(.*") && (!(REGEX(STR(?label), ".*\\(I.*")))) . FILTER( LANG( ?label ) = ?lang ) . } ORDER BY ?label LIMIT 1000
List of this constraint violations: Database reports/Complex constraint violations/P650#Possible disambiguation in key language label

This property is being used by: ar:قالب:ضبط استنادي eo:Ŝablono:Bibliotekoj nl:Sjabloon:Infobox kunstenaar, nl:Sjabloon:Infobox architect, nl:Sjabloon:Infobox architectenbureau, nl:Sjabloon:Infobox artiest, nl:Sjabloon:Infobox kunstenaar voor 1800, nl:Sjabloon:Infobox band, nl:Sjabloon:Infobox fotograaf, nl:Sjabloon:Link RKD, nl:Sjabloon:Infobox componist q:nl:Sjabloon:Externe bronnen, q:nl:Sjabloon:Koppelingen nds-nl:Mal:Infobox artyst ko:틀:위키데이터 속성 추적 Please notify projects that use this property before big changes (renaming, deletion, merge with another property, etc.)

Duplicates

I contacted the Netherlands Institute for Art History (Q758610) and they are going to work on resolving a number of duplicates in their collection. Multichill (talk) 12:50, 4 April 2015 (UTC)

Starting in November 2015, an IP located at the Dutch National Library is taking care of the duplicates roughly once a week. Usually the here happen some hours (up to a couple of days) before they are reflected in the RKDartists web database. Our remaining task here is to remove the associations in Mix'n'Match by setting them to "n/a" and keep the duplicates indicated on the Mix'n'match sync page in close sync with those reported here (Keep the duplicates in exact alignment before attempting to sync Wikidata and Mix'n'match!). -- Gymel (talk) 07:42, 29 January 2016 (UTC)

I didn't notice that ip yet Gymel. That's so nice that they're doing this on a regular basis now! Multichill (talk) 18:24, 2 February 2016 (UTC)

Constraints restored

I restored the contraints for occupation (P106), sex or gender (P21), date of birth (P569) & place of birth (P19) that were removed by Matěj Suchánek. We have 41612 items with a RKD link of which 41540 (99,83%) are humans. Only 72 items (0,17%) are not humans. That makes the human constraints quite applicable. I'm not a big fan of false positives so I added the 72 items as exceptions. I hope everyone agrees and is happy with this solution. Multichill (talk) 18:45, 2 February 2016 (UTC)

No problem, maybe I was lazy to do this like you did. Matěj Suchánek (talk) 19:22, 2 February 2016 (UTC)

For future reference: Download a fresh list, do a regex replace "\r\nQ" -> "]], [[Q", fix the first and last entry and paste it here.

I also imported gender so that list should drop from about 3300 to about 330. Multichill (talk) 13:34, 7 February 2016 (UTC)

@Multichill: What about removing item-requires-statement constraint (Q21503247): sex or gender (P21) and date of birth (P569) now that BotMultichill adds those? I guess (most of) the remaining ~2.5k simply don't have that data given at RKDartists? And those cases spam Wikidata:Database reports/Constraint violations/P650 and impede the display of labels. What do you think? --Marsupium (talk) 00:42, 11 September 2017 (UTC)

Reports for sex or gender (P21) and date of birth (P569) are available at Wikidata:Database reports/Humans with missing claims/P650, so I have removed them as constraints what will hopefully bring the use of {{Q}} to Wikidata:Database reports/Constraint violations/P650. But feel free revert me! --Marsupium (talk) 17:03, 23 October 2017 (UTC)

Restored it. I generally clean it up every once in a while and keep it to zero. Some of the big imports seem to have increased the numbers a bit. I'll do some clean up in the next couple of weeks. Multichill (talk) 17:01, 24 October 2017 (UTC)

Ok, I didn't that know you are using it actively … --Marsupium (talk) 17:02, 24 October 2017 (UTC)

Haven't really done it for a while, User:Multichill/Humans no gender used to be empty ;-) Multichill (talk) 17:12, 24 October 2017 (UTC)

@Marsupium: I believe this query gives the missing exceptions for sex or gender (P21):

SELECT ?item ?itemLabel ?itemDescription ?value ?valueLabel
WHERE
{
	?item wdt:P650 ?value .
	FILTER NOT EXISTS { ?item wdt:P21 [] } .
    FILTER NOT EXISTS { ?item wdt:P31 wd:Q5 } . 
    FILTER NOT EXISTS {
      SELECT ?item WHERE {
  wd:P650 p:P2302 ?propertyconstraint .
  ?propertyconstraint ps:P2302 wd:Q21503247 .
  ?propertyconstraint pq:P2306 wd:P21 .
  ?propertyconstraint pq:P2303 ?item .
  }
      }
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
LIMIT 1000

Try it!

and this one for date of birth (P569):

SELECT ?item ?itemLabel ?itemDescription ?value ?valueLabel
WHERE
{
	?item wdt:P650 ?value .
	FILTER NOT EXISTS { ?item wdt:P569 [] } .
    FILTER NOT EXISTS { ?item wdt:P31 wd:Q5 } . 
    FILTER NOT EXISTS {
      SELECT ?item WHERE {
  wd:P650 p:P2302 ?propertyconstraint .
  ?propertyconstraint ps:P2302 wd:Q21503247 .
  ?propertyconstraint pq:P2306 wd:P569 .
  ?propertyconstraint pq:P2303 ?item .
  }
      }
	SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
LIMIT 1000

Try it!

Can you double check? I wonder if quickstatements works on properties too. If that's the case we could just have these queries output something we can throw in quickstatements. Also shouldn't be too hard to create queries to find exceptions that no longer need to be an exception. Multichill (talk) 17:25, 24 October 2017 (UTC)

@Multichill: The queries look fine for me!

Help:QuickStatements doesn't say anything about it explicitly.

Which items do you have in mind with "exceptions that no longer need to be an exception"? --Marsupium (talk) 17:39, 24 October 2017 (UTC)

See for example RKDimages ID (P350) for some exceptions that are actually redirects now (you might need to copy User:Multichill/common.css to see them easily) Multichill (talk) 18:43, 24 October 2017 (UTC)

Ah, redirects, yes I see them, but there aren't any here and just two at RKDimages ID (P350). --Marsupium (talk) 00:39, 25 October 2017 (UTC)

@Multichill: I'd still prefer to use Wikidata:Database reports/Humans with missing claims/P650 and bring back {{Q}}s to Wikidata:Database reports/Constraint violations/P650. item-requires-statement constraint (Q21503247)s are a critical thing. :-) --Marsupium (talk) 10:24, 28 April 2018 (UTC)

You're more than welcome to help reduce the number of violations. Multichill (talk) 10:37, 28 April 2018 (UTC)

https instead of http

After consulting the RKD I have changed the access mechanism from http to https. Although both work, https is the preferred one. --HarmN (talk) 12:10, 8 December 2016 (UTC)

Good improvement. We prefer https over http too. I vaguely remember something with broken https, but all seems good now. RKDimages ID (P350) has been https for quite some time, I guess we just never switched this one. Multichill (talk) 12:40, 8 December 2016 (UTC)

Error reports removed

@Marsupium: I removed the error reports. You seem to have created the system and the only one using them. It gave the false impression that someone was actually looking at it, but it was actually not reported to anyone. If you found something in one of the RKD databases you should either report it on their site or leave a note on User talk:RKDdata. Multichill (talk) 21:55, 18 March 2018 (UTC)

@Multichill: I think it would have been kind to discuss this beforehand or at least transfer the information for it not to get lost, I've done that now. Indeed here User talk:RKDdata can be used as well. However, I disagree on some points:

• It's perhaps mainly, but still not exclusively me who created and uses the system. And I don't see a problem in that, in fact it should be used more widely to help improve quality of external sources.
• There are the columns "Reported" etc. indicating if the data maintainer has been informed yet. I admit all those columns are all but perfect, but I'm not aware of an established better way of keeping track of issues and their processing status.
• I use the reports exactly for "report it on their site". For Getty and Sandrart.net at least it turned out it is helpful to collect the issues and not to send an email for every single one. As the issues get collected publicly and the status is noted everyone can write such an email! Feel free!
• Having the issues collected at one point helps estimating the data quality of the source of a property.

As with RKDdata there is an account onwiki as an exception and the talk page is a viable way I don't revert the removal, still even for this case the use of the table by those finding the issues and RKDdata together appeared to me at least for some aspects superior to the talk page. I don't set my heart on those reports in that form. They are actually quite flawed. I'd be open and happy to improve the handling of issues in external sources! It would be preferable to store that information in the database directly, that might require additional properties though. Sorry for the long writing, thanks for reading and in advance for possible further input! Cheers, --Marsupium (talk) 01:52, 19 March 2018 (UTC)

Artists with multiple names (and multiple RKDartists records)

Q1392811 links to two RKDartists IDs, one of which is just a different name for the other. What would be the best way to handle this in WD? Add a single value constraint exception for this item to P650, just remove the ID that only contains the different name, or change the rank of the actual RKD artists record to preferred rank? Best,--RKDdata (talk) 12:00, 24 December 2019 (UTC)

• @RKDdata: Indeed, https://rkd.nl/nl/explore/artists/246022 is a mere redirect. Therefore this ID should be deleted from WD (RKDartists IDs is for people not redirects), and such entries should not be included in Mix-n-Match. Is there a way to recognize such entries in the RKDartists API/data export? --Vladimir Alexiev (talk) 07:01, 15 July 2020 (UTC)

• https://api.rkd.nl/api/record/artists/246022?format=json shows this. I think "label": "Zie voorkeursnaam" ("label": "See preferred name") is the signal --Vladimir Alexiev (talk) 07:09, 15 July 2020 (UTC)

          "hoofdTitel": {
            "kunstenaarsnaam": {
              "label": "Naam",
              "contents": "Joaquim Sunyer Miró"
            },
            "voorkeursnaam_naam": {
              "label": "Zie voorkeursnaam",
              "contents": "Sunyer Miró, Joaquín"
            },

Single value constraint and deprecated rank

@Multichill: It seems that the single value constraint report ignores deprecated ranks (see for example Q6539264). Is there a way to fix this? --RKDdata (talk) 07:54, 27 February 2020 (UTC)

I replaced here the constraint single-value constraint (Q19474404) with single-best-value constraint (Q52060874), that constraint checks for one best value. --Hannolans (talk) 19:56, 27 February 2020 (UTC)

@Hannolans: Thanks for updating the constraint. However, the report still includes items where one value of P650 is set to deprecated while the other is ranked normal (see for example Q6539264 which is still in the report). Is there a way to exclude those from these reports? Best, --RKDdata (talk) 09:12, 27 May 2020 (UTC)

languages

fr was a required label language since a few days, but RKDartists website is available in english and dutch as far as I know. so removed the requirement. But RKD is not really bilingual. Names are not translated. For example "Uitgeverij Artimo" is in the english version https://rkd.nl/en/explore/artists/425067 'Uitgeverij Artimo' and not 'Artimo publishers'. Hannolans (talk) 06:14, 19 August 2022 (UTC)

@Hannolans: this property is used 105,693 times

• 105,446 (99,8%) with a Dutch label
• 105,673 (99,9%) with an English label
• 102,647 (97,1%) with a German label
• 102,763 (97,2%) with a French label

The coverage of all of these is high enough to set up a constraint. The majority of items is about humans and a small part about organizations. These are all given names where unless a commonly used name exists, the label just get copied. It's not that we call the Rijksmuseum (Q190804) the "empire museum" or "state museum". I'll restore the last two as suggestions. Multichill (talk) 09:19, 21 August 2022 (UTC)

9000 verweesde personen

Mijn bot die personen voorziet van meer informatie gebaseerd op RKDartists had al een tijdje niet goed gelopen. Toen ik daarnaar keek viel met me op dat we meer dan 9000 personen hebben die alleen deze identifier hebben en geen binnenkomende link (van in totaal 104030 personen). Ik ben wel benieuwd hoe dit aantal gaat veranderen door de tijd bijvoorbeeld door het importeren van collecties die we nu nog niet hebben. Multichill (talk) 09:51, 3 September 2022 (UTC)

De focus van collecties op Wikidata plaatsen ligt bij schilderijen. De eerste die ik klikte was een keramist. Ik ben zelf wat terughoudend om van reproducties individuele prenten en tegels etc op Wikidata te plaatsen, 'werken in collectie' is wellicht voorlopig voldoende. Binnenkort ga ik met LIMA, ZKM en IFFR aan de slag om videokunstenaars verder op Wikidata aan te vullen, ik zie dat er 900 in staan in de query. Videokunstenaars zitten echter weer niet altijd in collecties, omdat ze als filmregisseur of televisieproducent actief kunnen zijn. --Hannolans (talk) 07:28, 6 September 2022 (UTC)

434,316 records?

@RPI2026F1: 434,316 records is complete nonsense. The current number is 381608 records. You probably incorrectly included redirects. Please correct and also check other properties for which you did the same change. Multichill (talk) 21:48, 16 January 2023 (UTC)

I'm pulling the data from the number of entries from Mix'n'Match. RPI2026F1 (talk) 00:46, 17 January 2023 (UTC)

@RPI2026F1: I guess the number of entries contains more that just the records. Thanks for fixing it. Multichill (talk) 20:32, 18 January 2023 (UTC)

I added a new condition where if previous entries for number of records exist and they use any source that isn't Mix'n'Match the bot won't touch those. RPI2026F1 (talk) 22:26, 18 January 2023 (UTC)

vervangen door RKD research

Vandaag is RKDartists vervangen door RKD-research, de links blijken gelukkig nog gewoon te werken. Zie https://www.rkd.nl/rkd-research-is-gelanceerd Hannolans (talk) 16:24, 14 December 2023 (UTC)