query-3db0ca5fd24e9f7fc28586ccf917b831

rq turtle/ttl

Einwohnerzahl von Dresden

Use at

• https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
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/>
PREFIX bd: <http://www.bigdata.com/rdf#>
#---------------------------------------------------------------------------------------
# Einwohnerzahl von Dresden
#---------------------------------------------------------------------------------------
# Einwohnerzahl von Dresden
#defaultView:AreaChart;table;
SELECT ?date (SAMPLE(?population) AS ?pop)
WHERE 
{
  BIND(wd:Q1731 AS ?item) .                        # Dresden
  ?item p:P1082 ?populationStatement .             # Statement für Eigenschaft Einwohnerzahl (p:P...)
  ?populationStatement ps:P1082 ?population .      # Property Statement Value
  ?populationStatement pq:P585  ?date .            # property qualifier
  FILTER (YEAR(?date) >= 1850)                     # Begin Zeitachse
  FILTER (YEAR(?date) <= 2100)                     # Ende  Zeitachse
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
group by ?date                                     # Gruppieren, weil 1945 drei Werte drin stehen
#order by (?date)

Query found at

• https://www.wikidata.org/wiki/User:Stefan_K%C3%BChn/Dresden