query-8c035f6dd2d09367eaaab4b878a99d5c
Importing US census population contains fields for all censuses since 1790. Of course, not all are filled always, but it’s still a vast amount of data on more than 30,000 pages. A random selection of 500 pages from the last 5000 of this 30,000 shows that currently 404 out of 500 have no population data at all: w:Template:US Census populationThe enwiki template
Use at
- https://query.wikidata.org/sparql
PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item WHERE {
SERVICE wikibase:mwapi {
bd:serviceParam wikibase:endpoint "en.wikipedia.org";
wikibase:api "Generator";
wikibase:limit 500;
mwapi:generator "transcludedin";
mwapi:gticontinue 6616366;
mwapi:titles "Template:US Census population".
?item wikibase:apiOutputItem mwapi:item.
}
MINUS { ?item wdt:P1082 []. }
}
Query found at
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?item"):::projected
a1((" "))
c16(["mwapi:item"]):::iri
c14(["Template:US Census population"]):::literal
c12(["6616366^^xsd:integer"]):::literal
c4(["en.wikipedia.org"]):::literal
c2(["bd:serviceParam"]):::iri
c8(["500^^xsd:integer"]):::literal
c6(["Generator"]):::literal
c10(["transcludedin"]):::literal
subgraph s1["http://wikiba.se/ontology#mwapi"]
style s1 stroke-width:4px;
c2 --"mwapi:endpoint"--> c4
c2 --"mwapi:api"--> c6
c2 --"mwapi:limit"--> c8
c2 --"mwapi:generator"--> c10
c2 --"mwapi:gticontinue"--> c12
c2 --"mwapi:titles"--> c14
v1 --"mwapi:apiOutputItem"--> c16
end
subgraph minus0["MINUS"]
style minus0 stroke-width:6px,fill:pink,stroke:red;
v1 --"wdt:P1082"--> a1
end