Google Answers Logo
View Question
Q: Need a list of cities and counties in all states in U.S. ( Answered 5 out of 5 stars,   1 Comment )
Subject: Need a list of cities and counties in all states in U.S.
Category: Reference, Education and News
Asked by: geoffreyf67-ga
List Price: $30.00
Posted: 20 Sep 2004 04:57 PDT
Expires: 20 Oct 2004 04:57 PDT
Question ID: 403630
I need a free list of all of the cities broken down by county in the
united states.  If I could get it in the format of:

city, county, state

that would be most excellent.  I tried some of the other solutions I
saw in the google answers but wasn't able to get this information
precisely.  one solution I saw in google answers gave a list of all
kinds of extraneous information and didn't really list the cities very

Here's one answer I liked a lot:

But this answer doesn't give the county the cities are in which I need.

Clarification of Question by geoffreyf67-ga on 20 Sep 2004 05:45 PDT
Incidentally, I just used that list that was in the other answer and
it doesn't, unfortunately, provide a list of all of the cities in all
of the states.

The clarification is just to point out I want a list of all cities (or
at least ones with a population of 10k or more) broken down by county
and state.

Single links to 50 different state sites won't help me much as I've
found that all over the place and could put the data together if I had
enough time.

I want a single source for the data.  $15 tip if you can get it to me
today :) (20 sep 2004).

If you can't find it broken down with counties, I would settle for
just city/state but there's no tip for that. :)

Request for Question Clarification by jackburton-ga on 20 Sep 2004 11:37 PDT
Hi Geoffrey,
You can obtain this information from the National Association of
counties website. I am not sure whether you have tried this solution.
1. Go to the "Find a County" page
2. Select a state from drop-down menu, e.g. Alabama. 
3. You will then see a list of counties (67 counties for Alabama).
Click on one of the county names, e.g. "Autauga County".
4. Then click on the link "Cities in Autauga County, AL". You should
then see a listing of 6 cities for Autauga County, AL. The listing
includes cities, towns, boroughs and communities based on the US
Postal Service mail delivery.
Is this solution acceptable for you?

Clarification of Question by geoffreyf67-ga on 20 Sep 2004 11:51 PDT
LIke I said, I'm hoping to get it in ONE file.  The answer is
partially helpful but it's like most stuff I've found where I can only
get part of the data and then have to put it all together.  With the
link you provided I'd have to go to a lot of work to put it all into a
usable format.

There's got to be a list of the data out there somewhere that I can
get all at once without having to massage the data a bunch.

Request for Question Clarification by jackburton-ga on 20 Sep 2004 12:22 PDT
I'll leave the question open in case another researcher can help.
In the meantime, here's another solution you may wish to consider:
The "U.S. Cities Galore" is a downloadable program which contains
193,000 cities, towns, and townships by county and state versus 40,000
in atlases or gazetteers. One of the program's functions titled
"Lookup County" provides genealogy researchers or hobbyists with the
ability to quickly access a comprehensive database which includes more
than 193,000 locations, i.e., (boroughs, townships, towns, and cities)
in the United States with their associated county. By typing in the
state and the city, the county is quickly identified. With the "Lookup
List of Cities within a County" function, This the user is prompted to
enter the state and county. A list of all the boroughs, townships,
towns, and cities within the county are shown and can be selected for
copying. Price: $19.95
Subject: Re: Need a list of cities and counties in all states in U.S.
Answered By: pafalafa-ga on 20 Sep 2004 12:50 PDT
Rated:5 out of 5 stars
Hello geoffrey67-ga.

Here's a link to a file that should do the trick:

This is an Excel spreadsheet file that lists more than 28,000 cities
in the US in the format:

city name / state / county

Please download and save this file to your local system, as it will
not be stored permanently at the above link.

The original source for the information is the USGS "US Concise" file
from the geonames site at:

This is a great geographical may want to explore some
of the other information sources available at this site.

I trust this file should fully meet your needs.  

However, before rating this answer, please let me know if you need any
additional information or explanations.  Just post a Request for
Clarification, and I'll be happy to assist your further.



search strategy:  Used bookmarked sites for US gazetteers

Request for Answer Clarification by geoffreyf67-ga on 20 Sep 2004 14:03 PDT
That is fantastic!!!  One last clarification - I tried that site but
didn't see any way to get the data in the format you provided to me. 
How did you do it???

Clarification of Answer by pafalafa-ga on 20 Sep 2004 14:38 PDT
Hi...glad to hear this was what you needed.

In order to create the data set, I downloaded the US Concise file from
USGS, and imported it into an Excel spreadsheet.

Once in Excel, I sorted the file based on the type-of-location column
that includes the designation "ppl", which stands for "populated
place" and indicates the cities.  Once I had these sorted, I deleted
all the non-ppl designations, and I then deleted all the columns
except for the three you needed.

Hope that's clear, but let me know if you need any additional information.  

geoffreyf67-ga rated this answer:5 out of 5 stars and gave an additional tip of: $20.00
Exactly what I needed.  Thanks!!!

Subject: Re: Need a list of cities and counties in all states in U.S.
From: pafalafa-ga on 20 Sep 2004 14:39 PDT
P.S.  And thanks for the stars and the tip....much appreciated!


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