query-dec5eae05611ec8542f2e56aaed04d20
Odia people died in 2022
source: Wikidata:Request_a_query#People_that_died_on_January_2021 @11JAN2021
SELECT ?item ?itemLabel ?itemDescription ?dateOfDeath WHERE { ?item wdt:P103 wd:Q33810. ?item wdt:P31 wd:Q5. ?item wdt:P570 ?dateOfDeath. hint:Prior hint:rangeSafe true. FILTER("2021-12-31"^^xsd:dateTime < ?dateOfDeath && ?dateOfDeath < "2022-12-31"^^xsd:dateTime) SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". } } order by ?dateOfDeath ?itemLabel
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 bd: <http://www.bigdata.com/rdf#>
# Odia people died in 2022
# source: Wikidata:Request_a_query#People_that_died_on_January_2021 @11JAN2021
SELECT ?item ?itemLabel ?itemDescription ?dateOfDeath WHERE {
?item wdt:P103 wd:Q33810.
?item wdt:P31 wd:Q5.
?item wdt:P570 ?dateOfDeath.
FILTER("2021-12-31"^^xsd:date < ?dateOfDeath &&
?dateOfDeath < "2022-12-31"^^xsd:dat)
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
order by ?dateOfDeath ?itemLabel
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?dateOfDeath"):::projected
v3("?item"):::projected
v2("?itemLabel"):::projected
c9(["bd:serviceParam"]):::iri
c6(["wd:Q5"]):::iri
c11(["#91;AUTO_LANGUAGE#93;,en"]):::literal
c4(["wd:Q33810"]):::iri
f0[["'2021-12-31^^xsd:date' < ?dateOfDeath?dateOfDeath < s2022-12-31^^<http://www.w3.org/2001/XMLSchema#dat>'"]]
f0 --> v1
v3 --"wdt:P103"--> c4
v3 --"wdt:P31"--> c6
v3 --"wdt:P570"--> v1
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c9 --"wikibase:language"--> c11
end