Lifetime updates. Come back once in a while to stay updated of new versions of this database.

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:

MySQL Database: 42,741 United States Zip Codes Database with Latitude, Longitude and Area Code for Sale

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)



Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.

Instant download upon payment success, just press return button on PayPal website after finishing payment.

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

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.