World city database (with longitude, latitude) and population per year

Question

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?

score 8 · Accepted Answer · answered Jun 24 '14 at 16:09

8

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

answered Jun 24 '14 at 16:09

Andrew - OpenGeoCode

8,657
17
28

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 08:03
you can use google's geolocation API to add lat/long for each city: https://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: http://www.opengeocode.org/download.php#cities – Andrew - OpenGeoCode Jun 25 '14 at 15:40

Joe Germuska · Answer 2 · 2014-06-24T15:42:58.063

5

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.

edited Jun 24 '14 at 15:42

answered Jun 24 '14 at 15:34

Joe Germuska

5,488
20
46

score 3 · Answer 3 · edited Aug 27 '19 at 08:19

3

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

edit: more info here: https://opendata.stackexchange.com/a/13081/1511

edited Aug 27 '19 at 08:19

philshem

17,647
7
68
170

answered Jun 24 '14 at 13:37

Mark Silverberg

5,184
14
25

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: http://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

score 0 · Answer 4 · answered Nov 12 '22 at 11:50

Geonames is the way to go. Its huge data and updates are available for download daily. But the processing and cleaning the data is a humongous task. You can try writing to world cities database as well to see how they manage updates and you can leverage the same for your experiment. Do note its a paid subscription for the latter suggested site.

score -1 · Answer 5 · edited Mar 16 '23 at 03:25

-1

Check this link, the late comers https://public.opendatasoft.com/explore/dataset/geonames-all-cities-with-a-population-1000/export/?disjunctive.cou_name_en&sort=name

As a sample, a few rows of data:

2639792;Queensbury;Queensbury;Queensbury;P;PPL;GB;United Kingdom;;ENG;B4;;;8912;;347;Europe/London;2019-05-09;United Kingdom;53.76657   -1.84912
2639897;Prestwich;Prestwich;Prestwich;P;PPL;GB;United Kingdom;;ENG;C1;;;32125;;97;Europe/London;2013-08-05;United Kingdom;53.53333  -2.28333
2639962;Pott Shrigley;Pott Shrigley;;P;PPLA3;GB;United Kingdom;;ENG;Z7;00EQ106;;0;;198;Europe/London;2011-07-31;United Kingdom;53.30957 -2.08405
2639969;Potterspury;Potterspury;Potterspury;P;PPL;GB;United Kingdom;;ENG;J1;34UG;34UG052;1453;;91;Europe/London;2018-07-03;United Kingdom;52.08288  -0.89676

edited Mar 16 '23 at 03:25

Nicolas Raoul

8,426
5
28
61

answered Mar 15 '23 at 17:16

binrebin

101
1

It is just a list of cities, and does not contain contain population data for each year, right? – Nicolas Raoul Mar 16 '23 at 03:23
@NicolasRaoul, Oh sorry I didnt notice that per year condition. Anyway, yearly population everywhere is calculated. Actual head counts only in every 5 or 10years. – binrebin Mar 16 '23 at 14:16

World city database (with longitude, latitude) and population per year

5 Answers5

Linked

Related