query-25367b2f9217e69e54f0b3cddd1874e5

rq turtle/ttl

request to find references for novalue statements in "spouse" (P26) (2021-10-31) Jura1: Request date: 31 October 2021, byTask description, these tend to get additional statements and identifiers fairly frequently.Wikidata:Database reports/top missing properties by number of sitelinks/P26 at (P26)spouse After creating new items for missing 12:57, 31 October 2021 (UTC) JuraThe proposed task is to find a suitable source and added references to such statements. --- Maybe there is a way to reference them with one or the other source. .(Q12325)James Buchanan for Q12325#P26This is less so for novalue statements. Sample: Discussion12:03, 27 November 2021 (UTC) Jura), but it's generally not filled. I think that for readers this is visible by the absence of spouse unknown (even if the person has no spouse). --- User:Lesko987aApparently Wikitree has a flag "no more marriages" for this (according to Request process(1) Query to find them:

Use at

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wdno: <http://www.wikidata.org/prop/novalue/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT
  ?item ?itemLabel ?itemDescription
WHERE
{
  ?st a wdno:P26 .
  ?item p:P26 ?st .
  OPTIONAL { ?st prov:wasDerivedFrom ?source . 
            FILTER NOT EXISTS { ?source pr:P143 [] } 
           } 
  FILTER(!bound(?source)) 
  ?item wdt:P31 wd:Q5 ; wdt:P570 ?d . 
  FILTER ( YEAR(?d) > 1600 ) 
  FILTER NOT EXISTS { ?item wdt:P106 wd:Q1469535 }
  FILTER NOT EXISTS { ?item wdt:P26 []  }  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
LIMIT 100

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v2("?d") v1("?item"):::projected v3("?source") v4("?st") a2((" ")) a1((" ")) c3(["wd:Q1469535"]):::iri c14(["bd:serviceParam"]):::iri c7(["p:novalue/P26"]):::iri c11(["wd:Q5"]):::iri c16(["#91;AUTO_LANGUAGE#93;,en"]):::literal f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"p:direct/P26"--> e0a1 e0v1("?item"):::projected e0a1((" ")):::projected end f0--EXISTS--> f0e0 f0 --> v1 f0 --> c1 f0 --> a1 v1 --"p:direct/P26"--> a1 f1[["not "]] subgraph f1e1["Exists Clause"] e1v1 --"p:direct/P106"--> e1c2 e1v1("?item"):::projected e1c2(["wd:Q1469535"]):::iri end f1--EXISTS--> f1e1 f1 --> v1 f1 --> c2 f1 --> c3 v1 --"p:direct/P106"--> c3 f2[["year-from-dateTime(?d) > '1600^^xsd:integer'"]] f2 --> v2 f3[["not bound(?source)"]] f3 --> v3 v4 --"a"--> c7 v1 --"p:P26"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."prov:wasDerivedFrom".-> v3 end v1 --"p:direct/P31"--> c11 v1 --"p:direct/P570"--> v2 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c14 --"wikibase:language"--> c16 end