Google Answers Logo
View Question
Q: Population breakdown of US, Canada, Europe, and other significant world regions ( Answered,   0 Comments )
Subject: Population breakdown of US, Canada, Europe, and other significant world regions
Category: Business and Money > Advertising and Marketing
Asked by: jsumpton-ga
List Price: $20.00
Posted: 09 Dec 2002 17:45 PST
Expires: 08 Jan 2003 17:45 PST
Question ID: 122116
I require a table of areas of the US, Canada, and parts of the world
where it is logical and possible to breakdown regions or cities into
smaller areas. I would prefer the areas to be about 100,000
populations, but realize how inconsistent this is between areas of
small populations, or numerous small communities and large population
centers. For example, based on
I end up with numerous towns in the 10,000 range and I don't have Cook
County smaller than 5,376,741.

Request for Question Clarification by ragingacademic-ga on 09 Dec 2002 17:53 PST
jsumpton - 

Can you clarify what exactly you are expecting as a deliverable?
The entire population of the world divided into 100k population segments...or...?


Clarification of Question by jsumpton-ga on 09 Dec 2002 18:10 PST
Something like that, but I can be flexible. I have a website project
where users will select their local area from a table as a means to
filter out data that is pertinent to them. On a given topic, their
interests may be global, like movie or music releases, regional like
weekend activities, or local, like amateur sports, local services or
dining. I realize that this is hugely different between small
communities and the major cities, but I would like a good starting
Subject: Re: Population breakdown of US, Canada, Europe, and other significant world regions
Answered By: kyrie26-ga on 14 Dec 2002 22:02 PST
Hello jsumpton-ga!

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 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
7196 total).

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 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

Best regards,

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy