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.
|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|
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.
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.
|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|
|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|
|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|
|black_or_african_american||Black or African American population|
|american_indian_or_alaskan_native||American Indian 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.|
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.
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.
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_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.