query-c8550c0d8164429b24fcd7853cbccfd0

rq turtle/ttl

Norwegians not having deathdate

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?itemDescription ?dob
WHERE
{
    ?item wdt:P27 wd:Q20 . 
    ?item wdt:P569 ?dob .  FILTER ( ?dob < "1920-00-00"^^xsd:date )
    FILTER NOT EXISTS { ?item wdt:P570 [] }
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],nn,nb,en". }
}
ORDER BY (?idLabel)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v3("?dob"):::projected v1("?idLabel") v2("?item"):::projected a1((" ")) c7(["bd:serviceParam"]):::iri c9(["#91;AUTO_LANGUAGE#93;,nn,nb,en"]):::literal c4(["wd:Q20"]):::iri f0[["not "]] subgraph f0e0["Exists Clause"] e0v1 --"wdt:P570"--> e0a1 e0v1("?item"):::projected e0a1((" ")):::projected end f0--EXISTS--> f0e0 f0 --> v2 f0 --> c1 f0 --> a1 v2 --"wdt:P570"--> a1 f1[["?dob < '1920-00-00^^xsd:date'"]] f1 --> v3 v2 --"wdt:P27"--> c4 v2 --"wdt:P569"--> v3 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c7 --"wikibase:language"--> c9 end