query-36dd2f82a8e80ee6403e7ef1073b110d
français morts sans "fichier des personnes décédées ID"
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 wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?human ?humanLabel ?nom_de_familleLabel ?prenomLabel ?prenoms_num ?prenomsLabel ?nom_de_naissance ?pseudo ?date_de_naissance ?lieu_de_naissanceLabel ?date_de_mort ?lieu_de_mortLabel WHERE {
?human wdt:P31 wd:Q5.
MINUS { ?human wdt:P9058 _:b8. }
?human wdt:P27 wd:Q142;
(p:P570/psv:P570) _:b9.
_:b9 wikibase:timePrecision ?precision;
wikibase:timeValue ?date_de_mort.
BIND(CONCAT(STR(YEAR(?date_de_mort)), "-", STR(MONTH(?date_de_mort))) AS ?yearmonth)
FILTER(?date_de_mort >= "2010-01-01T00:00:00"^^xsd:dateTime)
FILTER(?date_de_mort < "2010-02-28T00:00:00"^^xsd:dateTime)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
OPTIONAL { ?human wdt:P734 ?nom_de_famille. }
OPTIONAL { ?human wdt:P735 ?prenom. }
OPTIONAL { ?human p:P735 [pq:P1545 ?prenoms_num;
ps:P735 ?prenoms;
]. }
OPTIONAL { ?human wdt:P569 ?date_de_naissance. }
OPTIONAL { ?human wdt:P19 ?lieu_de_naissance. }
OPTIONAL { ?human wdt:P20 ?lieu_de_mort. }
OPTIONAL { ?human wdt:P1477 ?nom_de_naissance. }
OPTIONAL { ?human wdt:P742 ?pseudo. }
}
LIMIT 10000
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?date_de_mort"):::projected
v9("?date_de_naissance"):::projected
v2("?human"):::projected
v11("?lieu_de_mort")
v10("?lieu_de_naissance")
v5("?nom_de_famille")
v12("?nom_de_naissance"):::projected
v3("?precision")
v6("?prenom")
v8("?prenoms")
v7("?prenoms_num"):::projected
v13("?pseudo"):::projected
v4("?yearmonth")
a1((" "))
a3((" "))
a2((" "))
a4((" "))
c13(["bd:serviceParam"]):::iri
c4(["wd:Q5"]):::iri
c15(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c7(["wd:Q142"]):::iri
f0[["?date_de_mort < '2010-02-28T00:00:00^^xsd:dateTime'"]]
f0 --> v1
f1[["?date_de_mort >= '2010-01-01T00:00:00^^xsd:dateTime'"]]
f1 --> v1
v2 --"p:direct/P31"--> c4
subgraph minus2["MINUS"]
style minus2 stroke-width:6px,fill:pink,stroke:red;
v2 --"p:direct/P9058"--> a1
end
v2 --"p:direct/P27"--> c7
v2 --"p:P570"--> a2
a2 --"p:statement/value/P570"--> a3
a3 --"wikibase:timePrecision"--> v3
a3 --"wikibase:timeValue"--> v1
bind3[/"concat(str(year-from-dateTime(?date_de_mort)),'-',str(month-from-dateTime(?date_de_mort)))"/]
v1 --o bind3
bind3 --as--o v4
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c13 --"wikibase:language"--> c15
end
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P734".-> v5
end
subgraph optional1["(optional)"]
style optional1 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P735".-> v6
end
subgraph optional2["(optional)"]
style optional2 fill:#bbf,stroke-dasharray: 5 5;
a4 -."p:qualifier/P1545".-> v7
a4 --"p:statement/P735"--> v8
v2 --"p:P735"--> a4
end
subgraph optional3["(optional)"]
style optional3 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P569".-> v9
end
subgraph optional4["(optional)"]
style optional4 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P19".-> v10
end
subgraph optional5["(optional)"]
style optional5 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P20".-> v11
end
subgraph optional6["(optional)"]
style optional6 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P1477".-> v12
end
subgraph optional7["(optional)"]
style optional7 fill:#bbf,stroke-dasharray: 5 5;
v2 -."p:direct/P742".-> v13
end