42,741 United States Zip Codes Database with Latitude, Longitude and Area Code

Database Description:

With 42,741 unique USPS zip codes of United States, this database comes with city, county, state / territory / military, latitude, longitude, telephone area code, time zone and DST (Daylight Saving Time) for each of the zip codes.

There are 4 different types of zip codes: Military, P.O. Box Only, Standard, and Unique.

There are 62 different states / territories / armed forces: Armed Forces Americas (except Canada), Armed Forces (Europe, Canada, Middle East, Africa), Alaska, Alabama, Armed Forces Pacific, Arkansas, American Samoa, Arizona, California, Colorado, Connecticut, District of Columbia, Delaware, Florida, Federated States of Micronesia, Georgia, Guam, Hawaii, Iowa, Idaho, Illinois, Indiana, Kansas, Kentucky, Louisiana, Massachusetts, Maryland, Maine, Marshall Islands, Michigan, Minnesota, Missouri, Northern Mariana Islands, Mississippi, Montana, North Carolina, North Dakota, Nebraska, New Hampshire, New Jersey, New Mexico, Nevada, New York, Ohio, Oklahoma, Oregon, Pennsylvania, Puerto Rico, Palau, Rhode Island, South Carolina, South Dakota, Tennessee, Texas, Utah, Virginia, Virgin Islands, Vermont, Washington, Wisconsin, West Virginia, Wyoming

Database Meta:

• Size: 6.0 MB
• Last updated: June 20th, 2011
• Formats Included: MySQL dump .sql text file, CSV, MS Excel
• Tables: 3

Buy Now & Download: $99.00 (USD)

phpMyAdmin Screenshots:

Table Details (Data Structure / Schema):

• city

  Records:42,741

  All cities / towns / places / zip code areas of United States.

  Data fields

  1. id: int(11)
  2. zip_code: varchar(255)
  3. city: varchar(40)
  4. state_abbreviation: char(2)
  5. county: varchar(40)
  6. zip_code_type: varchar(255)
  7. latitude: varchar(255)
  8. longitude: varchar(255)
  9. area_code: varchar(255)
  10. time_zone: varchar(255)
  11. DST: varchar(255)

• state

  Records:62

  All states / territories / armed forces.

  Data fields

  1. id: int(11)
  2. abbreviation: char(2)
  3. title: varchar(255)

• zip_code_type

  Records:4

  All the 4 different types of zip codes.

  Data fields

  1. id: int(11)
  2. zip_code_type: varchar(255)

Buy Now & Download: $99.00 (USD)

Potential Applications / Usage:

• US postal information site
• City-related guides
• City zipcode lookup / search engine
• National / local information site
• Place names lists / postcode drop-downs for HTML forms

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

• Plain CSV
• CSV for Microsoft Excel
• Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
• Microsoft Word .DOC file (2008, 2007, 2003, 2000)
• LaTeX
• Open Document Spreadsheet
• Open Document Text
• PDF
• XML
• YAML
• WordPress Category / Post Database
• Single Table Format