I'm building a visualisation with cities' population around the globe for a website. I found the MaxMind free database that includes most cities around the globe with coordinates and population, which is awesome.

What I'd like to do is have something like a timeline, to show which cities have increased their population in the last years (even from 2005-ish to 2012 would be great).

To do so I would need the same database, but of previous years.

I looked at the Maxmind site, but couldn't find any older versions of their database.

Do you know a place where I can find such a database?

up vote 7 down vote accepted

The United Nation Statistics Division publishes population totals and by demographics per country on an annual basis. This is called the UN Demographic Yearbook. It is normally in PDF format, but there are various areas on the unstats.un.org site that you can download EXCEL and CSV files.

A good start is here. This has downloadable tables between 2007 and present.

http://unstats.un.org/unsd/demographic/products/dyb/dybcensusdata.htm

  • thanks, I believe this is as close as I can get to what I need (even tho I'll have to add coordinates for the cities) – tomtomtom Jun 25 '14 at 8:03
  • you can use google's geolocation API to add lat/long for each city: gist.github.com/philshem/10017416 – philshem Jun 25 '14 at 10:15
  • 1
    You can get the area centroid for each city from my compilation of the Cities of the World dataset (CSV). I compiled it from the USGS and NGA geographic name servers: opengeocode.org/download.php#cities – Andrew - OpenGeoCode Jun 25 '14 at 15:40

http://citypopulation.de provides this population data for cities, but as best I can tell, there is no bulk download facility, and the specific years for which historic data is available varies widely from country to country.

They don't seem to provide latitude/longitude data directly alongside their city population statistics, although they use maps heavily on the site, so the data may be in the pages.

Try Geonames such as http://download.geonames.org/export/dump/

I am mobile so can't double check but quote sure they have top line population information

  • thanks for the reply! this one has some information about cities and population but unfortunately it doesn't have information about past years, that's what I was kind of looking for – tomtomtom Jun 24 '14 at 15:20
  • @tomtomtom you might consider using Wolfram Alpha (eg: m.wolframalpha.com/input/?i=population+of+london+in+2004) and use the API to automate things. Just an idea if youre willing to trust their data sources – Mark Silverberg Jun 24 '14 at 15:53

Your Answer

 

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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