I found a response to question 462272 posed and answered about one
year ago, which seemed to have exactly what I was looking for. |
Request for Question Clarification by
scriptor-ga
on
16 Jan 2006 14:09 PST
Dear daisydoodles,
As I know from earlier research, a such list with zip codes seems not
to be available anywhere. But I can offer you a complete Excel list of
all 19465 cities and towns in the USA, with state and population.
Would that also be useful for you?
Regards,
Scriptor
|
Clarification of Question by
daisydoodles-ga
on
16 Jan 2006 14:16 PST
Dear Scriptor,
I don't need population but I think the rest of the info would work.
Before saying definitvely yes, pls allow me to ask three clarifying
questions.
(1) Does the 19465 cities represent all the cities/towns in the US?
(2) what's the source of the data?
(3) what's the file format, column heads within the file.
Thank You!
|
Request for Question Clarification by
scriptor-ga
on
16 Jan 2006 14:33 PST
Dear daisydoodles,
-The 19465 cities and towns are all incorporated places in the United States.
-The source of this data is the U.S. Census Bureau.
-The file is a simple Excel table, with three columns. I compiled the
table myself from the Census Bureau's data for each of the 50 states,
and I did not create specific column heads.
Greetings,
Scriptor
|
Clarification of Question by
daisydoodles-ga
on
16 Jan 2006 15:53 PST
Ok - assuming that the incorporated cities/towns are listed in alpha
order by state, that works for me. Thanks!!
|
Request for Question Clarification by
pafalafa-ga
on
20 Jan 2006 12:31 PST
diasydoodles-ga,
I'm the fellow who posted the answer to Q 462272 that you mentioned.
That dataset did not include zip codes, and also had only 19,000 or so
names -- the same number as were included in the previous answer to
this question that has since been removed.
I am aware of a much larger database of about 200,000 cities, towns,
villages, etc in the US. But again, there is no zip code information
included.
Also, a list of 200,000+ names is generally too large for Excel to
handle, though there may be some workarounds to that.
Let me know your thoughts on this.
pafalafa-ga
|
