query-3169cc888a551a24c58f25ec061a69fc

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 ?personne ?age ?citoyenLabel
WHERE { 
?personne wdt:P31 wd:Q5; wdt:P569 ?birth; wdt:P509 wd:Q84263196 ; wdt:P570 ?died.   
BIND(FLOOR((?died - ?birth)/365.2425) AS ?age). 
BIND((YEAR(?died)-2020)*12 + MONTH(?died) AS ?mthn). 
?personne wdt:P27 ?citoyen.  
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr". }
} 
ORDER BY DESC(?age) 
LIMIT 10000

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v5("?age"):::projected v3("?birth") v6("?citoyen") v4("?died") v5("?mthn") v2("?personne"):::projected c5(["wd:Q84263196"]):::iri c9(["bd:serviceParam"]):::iri c11(["#91;AUTO_LANGUAGE#93;,fr"]):::literal c2(["wd:Q5"]):::iri v2 --"wdt:P31"--> c2 v2 --"wdt:P569"--> v3 v2 --"wdt:P509"--> c5 v2 --"wdt:P570"--> v4 bind0[/"numeric-floor(?died - ?birth / '365.2425^^xsd:decimal')"/] v4 --o bind0 v3 --o bind0 bind0 --as--o v5 bind1[/"year-from-dateTime(?died) + '-2020^^xsd:integer' * '12^^xsd:integer' + month-from-dateTime(?died)"/] v4 --o bind1 bind1 --as--o v5 v2 --"wdt:P27"--> v6 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c9 --"wikibase:language"--> c11 end