Google Answers Logo
View Question
 
Q: List of US cities, sorted by population. ( Answered 5 out of 5 stars,   2 Comments )
Question  
Subject: List of US cities, sorted by population.
Category: Reference, Education and News > General Reference
Asked by: mediahound-ga
List Price: $15.50
Posted: 23 Jan 2005 20:40 PST
Expires: 22 Feb 2005 20:40 PST
Question ID: 462272
I need a list of all the United States cities, sorted by population at last count. 
Where may I find such a resource? Can Google Answers either A. point
me in the right direction, or B. provide the list to me?
I have searched the census.gov site, and cannot find this exact information. 
Your help is much appreciated.
Answer  
Subject: Re: List of US cities, sorted by population.
Answered By: pafalafa-ga on 24 Jan 2005 20:02 PST
Rated:5 out of 5 stars
 
mediahound-ga,


You're right...this information was buried pretty deeply at the
Census.gov site, but with enough rooting around, I was able to unearth
it.  You can find it here:


http://www.census.gov/popest/cities/tables/SUB-EST2003-01.xls


This Excel table provides a list of the 245 cities in the US with
populations of 100,000 or more.  The same information can be found in
PDF format here:


http://www.census.gov/popest/cities/tables/SUB-EST2003-01.pdf



I trust this meets your needs, but if not, please let me know BEFORE
rating this answer.  Just post a Request for Clarification to let me
know how I can help you further, and I'm at your service.


Cheers,

pafalafa-ga

Request for Answer Clarification by mediahound-ga on 24 Jan 2005 21:56 PST
Pafalafa, 
 Thank you for your reply. 
I need an exhaustive list of all the cities in the US, as I had requested. 
This list of 245 will barely make an impact for the project at hand. 
Thank you once again, your help is appreciated.

Clarification of Answer by pafalafa-ga on 25 Jan 2005 04:42 PST
mediahound-ga,

Can you tell me what you have in mind when you ask for all the
"cities" in the US?  Is there a distinction between a city and, say, a
town or village?  Is a place with a population of 1,000 considered a
city for your purposes?

I'll be glad to dig further for you on this...I just want to get a bit
clearer as to what you're after.

Thanks.

paf

Clarification of Answer by pafalafa-ga on 25 Jan 2005 10:59 PST
Hello again,


The absence of a longer national list at the Census Bureau site was
bugging me, so I finally called them, and got some assistance from a
very knowledgable and helpful federal bureaucrat.

Indeed, the list you are looking for does not exist in any neat sort
of list, but it can be created from existing files at:


http://www.census.gov/popest/cities/


by selecting the "Download Entire Data Set" option, and working with
the so-called "sub-county" files to create the full list of
incorporated cities/towns/villages/etc in the US.

It's not easy, since the master file is pretty opaque, but you needn't
do it yourself.  The list has been created for you by the friendly
researchers at Google Answers, with an assist from the Census Bureau.


So, herewith a list of more than 19,000 cities and towns in the US,
from NYC with its 8 million+ population, right down to Lost Springs,
WY (pop 1) and SNPJ Borough, PA (pop 0):


https://s20.yousendit.com/d.aspx?id=0LA9UKDFMI3N5325373N5FX1YK


This is a 1.5MB spreadsheet file, so it may take a bit of time to
download.  Please save it to your local computer, as the file is only
temporarily stored at the above link.

Hope that does the trick, but as always, let me know if there's
anything else I can do for you.


paf
mediahound-ga rated this answer:5 out of 5 stars and gave an additional tip of: $7.00
Sent from g-d. What a persistant individual. 
Called the census bureau? My goodness. 
Thank you ever so much. Truly appreciated! 
Tip forthcoming.

Comments  
Subject: Re: List of US cities, sorted by population.
From: marketingdude-ga on 12 Feb 2005 22:01 PST
 
Hi paf,

I'd like to get a hold of your collated list but the file expired. How
can I grab your list?

Thanks,
Bob
Subject: Re: List of US cities, sorted by population.
From: mediahound-ga on 21 Feb 2005 00:48 PST
 
Hi, The file didn't expire, it was removed. 
You'll need to post your question in a new thread. 
Thanks.

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 answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


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