query-91bd1e3121f16da72174102e48fadfc3
Sourcing RKDartists. It will source existing dates when it's the same as RKDartists and it will replaced unsourced years with more precise dates sourced from RKDartists. I'm going to leave it running to clear out the first backlog. Next step is to tackle the items that have imported from as a source. This query currently returns 36754 results now, let's see how many can be removed. first part worksHi Jarek, as always it was a nice to meet you in person. The
Use at
- https://query.wikidata.org/sparql
PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT ?item ?birthvalue ?birth WHERE {
?item wdt:P650 [] .
?item p:P569 ?birthclaim .
?birthclaim psv:P569 ?birthvalue .
{ ?birthvalue wikibase:timePrecision "9"^^xsd:integer } UNION {
?birthvalue wikibase:timePrecision "10"^^xsd:integer } UNION {
?birthvalue wikibase:timePrecision "11"^^xsd:integer }
?birthvalue wikibase:timeValue ?birth .
MINUS { ?birthclaim prov:wasDerivedFrom ?provenance .
MINUS { ?provenance pr:P143 [] }
}
} ORDER BY DESC(?birth) LIMIT 40000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?birth"):::projected
v3("?birthclaim")
v4("?birthvalue"):::projected
v2("?item"):::projected
v5("?provenance")
a1((" "))
a2((" "))
c7(["11^^xsd:integer"]):::literal
c5(["9^^xsd:integer"]):::literal
c6(["10^^xsd:integer"]):::literal
v2 --"p:direct/P650"--> a1
v2 --"p:P569"--> v3
v3 --"p:statement/value/P569"--> v4
subgraph union0[" Union "]
subgraph union0l[" "]
style union0l fill:#abf,stroke-dasharray: 3 3;
subgraph union1[" Union "]
subgraph union1l[" "]
style union1l fill:#abf,stroke-dasharray: 3 3;
v4 --"wikibase:timePrecision"--> c7
end
subgraph union1r[" "]
style union1r fill:#abf,stroke-dasharray: 3 3;
v4 --"wikibase:timePrecision"--> c6
end
union1r <== or ==> union1l
end
end
subgraph union0r[" "]
style union0r fill:#abf,stroke-dasharray: 3 3;
v4 --"wikibase:timePrecision"--> c5
end
union0r <== or ==> union0l
end
v4 --"wikibase:timeValue"--> v1
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v3 --"prov:wasDerivedFrom"--> v5
subgraph minus1["MINUS"]
style minus1 stroke-width:6px,fill:pink,stroke:red;
v5 --"p:reference/P143"--> a2
end
end