US ZIP Code Database

Posted On 2009-06-13 by FortyPoundHead
Keywords: Free Stuff for Webmasters
Tags: Webmaster Related Free Stuff 
Views: 2815

I've seen this database for sale by unscrupulous individuals who do nothing more than try to con you out of your hard earned cash.

Did you know this data is free?

MS Access version

MySQL Dump version

This archive even includes a simple ASP/VBSCript demo, with CSS goodness.

This free Access database of ZIP codes provides database designers with a valuable tool to assist in mapping ZIP codes to a city/state pair and even provides the latitude and longitude of that location. The database contains three tables: the ZIP Code table, the Class table and the State table.

The ZIP Code table contains six fields:

  1. ZIP Code is the five digit ZIP code and is the primary key of this table.

  2. Latitude is the latitude of the location, to five decimal places.

  3. Longitude is the longitude of the location, to five decimal places.

  4. Class is the class of the ZIP code. This field is a foreign key to the Class table.

  5. City is the name of the post office serving this ZIP code.

  6. State Code is the two-digit state code, as defined by the Federal Information Processing Standards. It is a foreign key to the States table

The States table contains three fields:

  1. State Code is the two-digit state code, as defined by the Federal Information Processing Standards.

  2. State Abbreviation is the commonly accepted postal abbreviation for the state.

  3. State Name is the full name of the state.

The Class table contains two fields:

  1. Class is the one character class code.

  2. Descripton is a text field describing the class in further detail.

About the Author

FortyPoundHead has posted a total of 1974 articles.


Comments On This Post

No comments on this post yet!

Do you have a thought relating to this post? You can post your comment here. If you have an unrelated question, you can use the Q&A section to ask it.

Or you can drop a note to the administrators if you're not sure where you should post.

Your IP address is:

Before you can post, you need to prove you are human. If you log in, this test goes away.

Recent Forum Posts

Advanced search added
dwirch posted on September 23, 2017 at about 13:44 in Site News

Job Spammer: Gaurav Mehta - AgreeYa Solutions
dwirch posted on September 22, 2017 at about 10:35 in Spammers

Job Spammer: Prutha Siri - Javelin Systems
dwirch posted on September 10, 2017 at about 6:15 in Spammers

New security implemented
dwirch posted on September 7, 2017 at about 7:16 in Site News

Malicious IP Checker Companion Tool
dwirch posted on August 12, 2017 at about 20:24 in Site News

Job Spammer: Steve Adams
dwirch posted on August 8, 2017 at about 7:44 in Spammers