Google Answers Logo
View Question
 
Q: List of all USA counties ( Answered 5 out of 5 stars,   0 Comments )
Question  
Subject: List of all USA counties
Category: Reference, Education and News
Asked by: ralphnap-ga
List Price: $50.00
Posted: 22 Nov 2005 19:48 PST
Expires: 22 Dec 2005 19:48 PST
Question ID: 596559
I need a list of all USA county names and I want it delivered in two
forms: one without states appended and one with the states appended.

On the one without states, if a county name exists in more than one
state, just list the county name once.

On the one with the states, if a county name exists in more than one
state, include each occurence (please do not include a comma between
county and state names).

For both types, the format I need is ONE PER LINE as shown in the
examples (preferably in alphabetical order):

With State appended:

Dutchess County New York
Orange County New York
Orange County California
Westchester County New York

Without state appended:

Dutchess County
Orange County
Westchester County

Request for Question Clarification by pafalafa-ga on 22 Nov 2005 20:07 PST
Ralph,

I have a list of all counties in the US (about 3,100) and their state.
 I'd be glad to provide two copies -- one as is, and one with the
states, and any duplicate county names, removed.

However, the states are in two-letter abbreviation format:

Dutchess County NY

rather than

Dutchess County New York  



Will that be OK for your needs?


pafalafa-ga

Clarification of Question by ralphnap-ga on 22 Nov 2005 20:54 PST
The abbreviated state should be fine, thank you for asking.
Answer  
Subject: Re: List of all USA counties
Answered By: palitoy-ga on 23 Nov 2005 03:03 PST
Rated:5 out of 5 stars
 
Hello ralphnap-ga

Thank-you for your question.

I have compiled the lists that you requested from the following sources:
http://www.ng3k.com/Misc/usc_a-c.html (and links from this page)
http://en.wikipedia.org/wiki/Category:Lists_of_U.S._counties

Due to the length of the lists I have posted them online.  Please go
to the following locations and download the files (they will only be
available online for 14 days after which time they will be deleted).

Alphabetical with no states:
http://www.sendmefile.com/00151599

Alphabetical with states:
http://www.sendmefile.com/00151600

Should you require any further information on this subject please do
not hesitate to ask for clarification.

Clarification of Answer by palitoy-ga on 23 Nov 2005 03:42 PST
Please ignore the previous results, I accidentally pointed you to my
work-in-progress files instead of the completed files.  The links you
require are in fact the following ones.

Alphabetical with no states:
http://www.sendmefile.com/00151617

Alphabetical with states:
http://www.sendmefile.com/00151618

Sorry again for the confusion.

Request for Answer Clarification by ralphnap-ga on 23 Nov 2005 05:46 PST
Nice job. You did it so well I have another request and hope it does
not affect the price. I know I can pretty easily do this myself, it
would just be nice to have it already done. Actually, I hadn't thought
of this until I saw your completed list.

Can you also provide the state list with the state name abbreviated
instead of spelled out (NY instead of New York, etc.)?

Can you also separate the documents with state names (both abbreviated
and spelled out) into separate folders?

That would be a total of 5 iterations of the list, 

-One with county names, one with county names and state names spelled
out (these are already completed)

-Two with county names spelled out and state name abbreviated (one
run-on document and one in a folder of state name folders),

-One with county AND state names spelled out in a folder of state name folder.

Please advise.

Thank you.

Ralph

Clarification of Answer by palitoy-ga on 23 Nov 2005 06:11 PST
This will be quite a bit of extra work but I should be able to complete it today.

I am a little confused at the extras you require, one is simple but I
am not sure about the others... The simple one is the abbreviations of
the State Names in the list.

What are the other two you require?  Is it a folder containing one
text file per state?  Each text file would contain the county names
within that state.

Clarification of Answer by palitoy-ga on 23 Nov 2005 06:23 PST
Here is the list with the abbreviated state names:
http://www.sendmefile.com/00151760

Please let me know what the other variations were that you required.

Request for Answer Clarification by ralphnap-ga on 23 Nov 2005 08:48 PST
Thank you for already doing the abbreviations.

Yes, what I need next is the text file for each state in a separate
folder for each state.

If possible I wanted that for both the spelled out state names and the
abbreviated state names. One master folder for each, as such:

Counties with state names spelled out folder> inside is a folder for each state

Counties with state names abbreviated folder> inside is a folder for each state

So, that means just two more iterations.

Is another $10 adequate?

Clarification of Answer by palitoy-ga on 23 Nov 2005 09:02 PST
Thank-you for the 5-star rating and tip.  They are both appreciated.

I am still not 100% sure what the additional requirements are that you
require so before I continue I would like to clarify once more.

You require a folder or directory named STATE which contains a text
file with all the COUNTY NAMES in it.

Is this correct?  And you require it for Long State Names and
Abbreviated State Names.

Clarification of Answer by palitoy-ga on 23 Nov 2005 11:02 PST
This took quite a while to sort out so hopefully it is what you
require, if not please let me know.  I wanted to post these now as I
will be offline for approximately 15 hours and unable to answer your
questions until I return.

With Long State Name Folders
http://www.sendmefile.com/00152072

With Short State Name Folders
http://www.sendmefile.com/00152074

Request for Answer Clarification by ralphnap-ga on 23 Nov 2005 11:29 PST
When in doubt you overdelivered. I really appreciate this and will
keep your info for future questions.

Thanks again.

Ralph

Clarification of Answer by palitoy-ga on 24 Nov 2005 01:28 PST
Thank-you once again for the kind comments; I hope you will use Google
Answers again in the future and you were happy with the answer. 
Should you wish to direct a question straight for me to answer you can
put my username (palitoy-ga) in the question title.  Thanks again.
ralphnap-ga rated this answer:5 out of 5 stars and gave an additional tip of: $10.00
Fast, accurate, responsive and helpful.

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