query-296a94c29d6e0de056485da2ba087cab

rq turtle/ttl

Cities by population SELECT ?item ?cityLabel ?countryLabel ?population WHERE { ?city wdt:P31 wd:Q515 . # is a city ?city wdt:P17 ?country . # show me country ?city wdt:P17 wd:Q212 . # let is be Ukraine ?city wdt:P1082 ?population . # and get me population FILTER (?population >= 1000000) # remove cities with population less than one million SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } ORDER BY DESC(?population)

Use at

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

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#>
# Cities by population
SELECT ?item ?cityLabel ?countryLabel ?population
WHERE
{
    ?city wdt:P31 wd:Q515 . # is a city
    ?city wdt:P17 ?country . # show me country
    ?city wdt:P17 wd:Q212 . # let is be Ukraine
    ?city wdt:P1082 ?population . # and get me population
    FILTER (?population >= 1000000) # remove cities with population less than one million
    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY DESC(?population)

Query found at

• https://www.wikidata.org/wiki/Wikidata:Project_chat/Archive/2017/06