query-033f9144b55c6d9f3396a5a5ec7d1e5c
People who died before independence of India but erroneously tagged as citizen of Republic of India SELECT ?item ?itemLabel ?deathLabel WHERE { ?item wdt:P31 wd:Q5 . # all humans ?item wdt:P27 wd:Q668. # tagged as Indian citizen ?item wdt:P570 ?death. # who died FILTER (?death <= "1947-08-16T00:00:00Z"^^xsd:dateTime) . # before 16 August 1947
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,bn,hi,mr,gu,pa,ta,te,ml,as,or".}
} ORDER BY (?deathLabel)
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#>
# People who died before independence of India but erroneously tagged as citizen of Republic of India
SELECT ?item ?itemLabel ?deathLabel
WHERE
{
?item wdt:P31 wd:Q5 . # all humans
?item wdt:P27 wd:Q668. # tagged as Indian citizen
?item wdt:P570 ?death. # who died
FILTER (?death <= "1947-08-16T00:00:00Z"^^xsd:dateTime) . # before 16 August 1947
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,bn,hi,mr,gu,pa,ta,te,ml,as,or".}
}
ORDER BY (?deathLabel)
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v2("?death")
v1("?deathLabel"):::projected
v3("?item"):::projected
c8(["bd:serviceParam"]):::iri
c5(["wd:Q668"]):::iri
c3(["wd:Q5"]):::iri
c10(["#91;AUTO_LANGUAGE#93;,en,bn,hi,mr,gu,pa,ta,te,ml,as,or"]):::literal
f0[["?death <= '1947-08-16T00:00:00Z^^xsd:dateTime'"]]
f0 --> v2
v3 --"wdt:P31"--> c3
v3 --"wdt:P27"--> c5
v3 --"wdt:P570"--> v2
subgraph s1["http://wikiba.se/ontology#label"]
style s1 stroke-width:4px;
c8 --"wikibase:language"--> c10
end