query-146fbb76ef0f201ae5afcb9a55c12735
All inhabited revenue villages with population data in Andhra Pradesh SELECT DISTINCT ?village ?villageLabel ?censuscode ?totpopulation ?malepopulation ?femalepopulation ?households WHERE { hint:Query hint:optimizer "None". ?village (wdt:P131) wd:Q1159; (wdt:P31/(wdt:P279)) wd:Q56436498; wdt:P5578 ?censuscode. OPTIONAL { ?village p:P1082 ?totpopnode. ?totpopnode ps:P1082 ?totpopulation; pq:P585 ?totdate; pq:P459 ?totdetmethod. FILTER(?totdetmethod = wd:Q1861882||||
Use at
- https://query.wikidata.org/sparql
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#All inhabited revenue villages with population data in Andhra Pradesh
SELECT DISTINCT ?village ?villageLabel ?censuscode ?totpopulation ?malepopulation ?femalepopulation ?households WHERE {
hint:Query hint:optimizer "None".
?village (wdt:P131*) wd:Q1159;
(wdt:P31/(wdt:P279*)) wd:Q56436498;
wdt:P5578 ?censuscode.
OPTIONAL {
?village p:P1082 ?totpopnode.
?totpopnode ps:P1082 ?totpopulation;
pq:P585 ?totdate;
pq:P459 ?totdetmethod.
FILTER(?totdetmethod = wd:Q1861882||||