Google Answers Logo
View Question
 
Q: Where can I get a (free) list of all valid US zipcodes (5-digit)? ( Answered 5 out of 5 stars,   3 Comments )
Question  
Subject: Where can I get a (free) list of all valid US zipcodes (5-digit)?
Category: Reference, Education and News > General Reference
Asked by: davidfilmer-ga
List Price: $3.50
Posted: 09 Aug 2003 01:34 PDT
Expires: 08 Sep 2003 01:34 PDT
Question ID: 241703
I'm looking for a (free) list of all valid five-digit US zipcodes that
I can access in electronic form over the web.  Just the zipcodes - I
don't care what city/state they refer to (but I wouldn't object to
having that also - I could easily filter out just the zipcodes). My
goal is to have a plain ASCII textfile, but I could convert HTML, PDF,
or just about any other source format.
Answer  
Subject: Re: Where can I get a (free) list of all valid US zipcodes (5-digit)?
Answered By: sgtcory-ga on 10 Aug 2003 10:59 PDT
Rated:5 out of 5 stars
 
Hello David,

I'm glad I was able to assist you. As noted in the comments, you can
download the information here :

MYSQL Zip Code Database 
http://www.darkshire.org/~jhkim/programming/zipcodes/

To find this answer, I simply pointed you to the same files I have
used in the past. If you would like to find similar sites/projects
like this, you can search Google for :


Mysql zip code database
://www.google.com/search?q=mysql+zip+code+database


Thanks for the great question! Should you have any further questions,
do no hesitate to ask. I will do all I can to help.

SgtCory
davidfilmer-ga rated this answer:5 out of 5 stars

Comments  
Subject: Re: Where can I get a (free) list of all valid US zipcodes (5-digit)?
From: sgtcory-ga on 09 Aug 2003 05:59 PDT
 
Hello davidfilmer,

I think finding a free database is going to prove be to be the
toughest challenge. This may suit your needs: (it is stored in MYSQL
dump format)

MYSQL Zip Code Database
http://www.darkshire.org/~jhkim/programming/zipcodes/

All you would need to do is 'strip' out the extras you don't need, and
you will have a near complete list. Let me know if this meets your
needs, as I was unable to locate a complete 'free' resource.

Thanks and good luck!
SgtCory
Subject: Re: Where can I get a (free) list of all valid US zipcodes (5-digit)?
From: sublime1-ga on 09 Aug 2003 13:13 PDT
 
davidfilmer-ga...

You might be able to extract the data you need from the state
listings here:
http://www.ip2location.com/zipcodes/
Subject: Re: Where can I get a (free) list of all valid US zipcodes (5-digit)?
From: davidfilmer-ga on 09 Aug 2003 15:25 PDT
 
Greetings. Sublime1's comment was of interest, but the information
presented on that website was only a small sample of a commercial
product.

SgtCory's link gave more complete information, and reading a little on
that website led me to the author's sorce data at the Census Bureau,
   http://www.census.gov/geo/www/tiger/zip1999.html
I was easily able to extract the 42,000+ zipcodes from this database
dump.

SgtCory, your information proved most useful.  Would you please mark
this question as closed? Thanks!

(It seems odd to me that USPS doesn't just publish this data. But, no,
you gotta go to Census Bureau of all places! go figure)

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