Free Zip code Database

Having a non-profit requirement for zip code information, I was dishearten by the offerings on the Internet. I eventually found the 2000 U.S. Census Bureau data and some other free stuff, so I cooked up a database.

While this is free for the taking, keep in mind it is not the most current available. Also, there are a few zip codes without city names. Hey, it's better than spewing $150 a year to someone you don't even know!. So, just unzip this Zip Zip and get to work!

Download the gzipped tar: zipcode_db.tar.gz (581K), or get the individual files below.

The MySQL Table Definition is:

CREATE TABLE ZIPCODE (
        zipcode char(5) PRIMARY KEY NOT NULL,
        state   char(2),
        city    char(30),
        lon     float(4,6),
        lat     float(4,6)
)

The Insert Statements look like this:

INSERT INTO ZIPCODE VALUES ('85750','AZ','TUCSON',-110.843840, 32.292078)\g

If want to lookup zipcodes or calculate distances, feel free to use this tool.

Contact Info   Home