I have this query to get the population of cities and the country they belong to:

SELECT ?city (?population as ?city_pop) ?country ?countryLabel ?continent ?continentLabel ?cityLabel
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
  ?city wdt:P31 wd:Q515.
  OPTIONAL { ?city wdt:P1082 ?population. }
  OPTIONAL { ?city wdt:P17 ?country. }
  OPTIONAL { ?city wdt:P30 ?continent. }

But how can I expand this query to also return the population of the entire country?

I've added this statement to the query

OPTIONAL { ?country wdt:P17 ?population. }

but then I get timeouts.

Bonus: I think getting the continent name for "country" instead of "city" would be more reliable, too.

Actually, my final query will be to return the most-populated city in each country, with the following structure:

city_name, city_population, country_name, country_population, continent_name

Here's a query from the tutorial that gives the max populated city in a country, but similar issues expanding to get the entire country's population in the same row

SELECT ?country (MAX(?population) AS ?maxPopulation)
  ?city wdt:P31/wdt:P279* wd:Q515;
        wdt:P17 ?country;
        wdt:P1082 ?population.
GROUP BY ?country

For the record, I've tried the downloads at Geonames but I find some inconsitencies: for example, "city" population of Singapore varies from "country" population of Singapore when there is only one city in Singapore (from two files, perhaps from two sources).

  • 2
    Like this: tinyurl.com/y6lres9o Note that max population is not the latest population, former countries are not filtered out etc. You could also ask here: wikidata.org/wiki/Wikidata:Request_a_query Feb 25, 2019 at 20:34
  • great! why not post as an answer? (one question - what do you mean by max population is not the latest?)
    – philshem
    Feb 25, 2019 at 21:06
  • weird, it's showing Antofagasta instead of Santiago as the most populous city in Chile.
    – philshem
    Feb 25, 2019 at 21:11
  • 1
    Santiago was a capital. See stackoverflow.com/a/47100906/7879193 I've fixed that, check the query later. As for population, it may decrease, see e.g. Q858. Feb 25, 2019 at 21:46
  • 1
    posted to the Wikidata "Request a query" and will add an answer here if it's solved. Thanks @StanislavKralin !
    – philshem
    Feb 26, 2019 at 14:55

1 Answer 1


This query was answered on Wikidata's great "Request a query"


solution one

solution two

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.