ZIP Code Database

Our ZIP Code Database can be downloaded in both Microsoft Excel and CSV formats and easily opened in most spreadsheet applications or imported into the database software of your choosing. The data comes from authoritative sources such as the United States Postal Service (2011), US Census Bureau (2010), the Internal Revenue Service (2008), and Yahoo. For more information on data accuracy, please see the discussion of ZIP codes. Click here to download a sample database in CSV format.

Choose Your License

Download available Unlimited 90 days
Personal / Educational Use Yes Yes
Use on Commercial Site No Yes
Use on Multiple Sites No Yes
Precise Latitude / Longitude No Yes
Demographics No Yes
Download Now

Sample Downloads

Sample in Excel (xls) Format Sample in CSV Format

Existing Orders

If you have already submitted payment for the commercial version or filled out the questionnaire for the free version, you can look up your download links by entering your email address.

Benefits of the Commercial Version

The commercial file contains precise latitude and longitude as well as minimum and maximum longitude and latitude, allowing you to choose the geo location method that best fits your needs. More Info

The commercial file also contains a great deal of data from the 2010 Census including land area, population, households, ratial breakdown, and age breakdown.

ZIP Code Database Schema

Field Comment
zip ZIP Code
type Military, PO Box, Standard, or Unique
primary_city Primary City of ZIP code
acceptable_cities Acceptable Cities for ZIP code
unacceptable_cities Unacceptable Cities for ZIP code
state U.S. State Abbreviation
county County within State
timezone Timezone Name
area_codes Telephone Area Codes within this ZIP
latitude Latitude, precise to approximately 1 mile radius
longitude Longitude, precise to approximately 1 mile radius
precise_latitude Latitude centered within largest section of ZIP code
precise_longitude Longitude centered within largest section of ZIP code
latitude_min The min latitude to determine ZIP code bounding box
latitude_max The max latitude to determine ZIP code bounding box
longitude_min The min longitude to determine ZIP code bounding box
longitude_max The max longitude to determine ZIP code bounding box
world_region World Region
country Alpha-2 Country Code
decommissioned Whether this zip has been decommissioned
estimated_population Estimated population using IRS data
notes Notes about this ZIP code
area_land Land area in square meters (divide by 2589988.110336 for square miles)
population_count_100 Total population count using Census data
housing_unit_count_100 Number of housing units
white White population
black_or_african_american Black or African American population
american_indian_or_alaskan_native American Indian population
asian Asian population
native_hawaiian_and_other_pacific_islander Native Hawaiian population
other_race Other race population
two_or_more_races Two or more race population
total_male_population Total male population
total_female_population Total female population
pop_under_10 Population under 10 years old
pop_10_to_19 Population 10 to 19 years old
pop_20_to_29 Population 20 to 29 years old
pop_30_to_39 Population 30 to 39 years old
pop_40_to_49 Population 40 to 49 years old
pop_50_to_59 Population 50 to 59 years old
pop_60_to_69 Population 60 to 69 years old
pop_70_to_79 Population 70 to 79 years old
pop_80_plus Population 80 years or older
* Columns in bold are only available in commercial version.

Data Statistics

  • Total ZIP Codes: 42,522
  • 41,859 active and 663 decommissioned ZIP codes
  • ZIP code types:
    • 29,971 STANDARD
    • 9,465 PO BOX
    • 2,437 UNIQUE
    • 649 MILITARY
  • ZIP code locations:
    • 41,366 from the 50 US states
    • 7 AF
    • 81 AS
    • 6 AU
    • 8 CA
    • 146 EU
    • 80 ME
    • 823 NA
    • 4 SA
    • 1 WW
  • Excel file size: 8.65MB
  • CSV file size: 4.30MB

Data Sources

  • Current ZIP codes
    • ZIP code, type, cities: USPS
    • Military place names: MPSA Election Ballot
    • Estimated population: IRS
    • Latitude/longitude: National Weather Service
    • County, time zone, area codes, and country: Yahoo
  • Decommissioned ZIP codes
    • Usually quality sources but not verifiable

How long is my download available, and how often should I make a purchase to stay up to date?

For the commercial version, the data file is available for download up to 90 days after the date of purchase. In general, we recommend users purchase another copy and update their systems on a roughly annual basis to stay reasonably current/accurate.

Matching to States, Counties, and Cities

If you are trying to use the product to match ZIPs to other geographic boundaries, we highly recommend that you read the discussion on our home page.

GeoLocation Information

ZIP coordinate explanation

We suggest you use the latitude and longitude coordinates that are rounded to 2 decimal places. Remember that a ZIP code often covers a large geographic area and that very precise latitude and longitude coordinates may be precise down to a very small radius - down to very small fractions of a mile which is much smaller than the geographic area covered by a ZIP code. Changing the latitude or longitude coordinate by a single hundredth of a decimal place results in a shift of approximately 1 mile in any direction. The radius of this shift is shown in the graphic in green. As you can see, any rounding error or lack of precision from only including 2 decimal places is far more precise than the actual size of the ZIP code. Many of these coordinates have been hand chosen. Only including precision to 2 decimal points serves as a reminder to keep precision in mind when performing any calculations.

The most simple method is to use the formula for a rectangle that uses (latitude_min + latitude_max) / 2 for the latitude coordinate. This method is shown in the example graphic in red. As you can see, this can frequently result in coordinates that do not actually lie within the region covered by the ZIP code. The point chosen using this method is actually located within a small area that is not covered by the ZIP code.

The final method for calculating the ZIP coordinates involves complex shape analysis of the polygon that represents the ZIP code. The result is a coordinate that will be within the largest section of the ZIP code. As you can see from the image where this method is shown in black, this may be significantly different from the other two calculation methods. It can also result in a point that is a much more significant distance from some sections of the ZIP code. For instance, the example has a point that is very far from the south west portion of the ZIP.

When doing any type of calculation from these coordinates, it is important to consider that one is trying to describe a large shape by a single point. Please take the above into consideration when choosing which set of coordinates to use. Each can be useful in different types of situations.