Thank you for your question. I have successfully helped to solve a
similar problem before, you are welcome to have a look at it here :
The data you are looking for can be found at this site :
World Gazetteer : population figures for cities, towns and places
"This site provides statistics about current population of countries,
their administrative divisions, cities and towns as well as images of
the current national flags."
I downloaded the file TSV (tab-separated values) file to be found at
http://www.gazetteer.de/st/cities.zip and have removed irrelevant
fields (columns), and filtered for geographical place names with
populations of 100,000 and greater. There are 3850 records (out of
I have provided this file (1MB) for your download at :
This file is in Excel spreadsheet format, and can be exported in TSV
format to be imported into a database. You can and should "normalize"
the data so that countries and states are represented by codes, which
are referenced to records in their respective tables.
Here is an explanation of the columns (fields) in the file :
place name - most atomic unit (town, city), in HTML-friendly format
basic place name - same as above, in regular text (ASCII) format
administrative division - state/province, in HTML-friendly format
basic administrative division - same as above, in regular text (ASCII)
country - self explanatory
admin.center of country/region/both/none - this describes the place
current population - self explanatory
I hope this is the answer you are looking for. If you have any
questions or need further information, please do not hesitate to ask.
Thank you for using Google Answers and I wish you all the best on your