|Excel (xls) Format||
|CSV Format||Download Sample||Download Sample|
|Download available||90 days||Unlimited|
|Personal / Educational Use||Yes||Yes|
|Lookup tool on commercial website||Yes||No|
|All ZIP Codes||Yes||Yes|
|Cities Used by USPS||Yes||Yes|
|Timezone and area code||Yes||Yes|
|General Latitude / Longitude||Yes||Yes|
|Precise Latitude / Longitude||Yes||No|
|Age, Gender, and Race Stats||Yes||No|
We've been providing data to our clients for years and over 225,000 different individuals, organizations, and corporations of all sizes have trusted us to provide them with the high quality data that they need. We don't just tell you about the quality, we show you the results of our verification and research (see below) and make sure you can quickly understand the most accurate ways to use the data we provide. All data is consistently labeled, there are no duplicates, quality data sources minimize any inaccuracies, and multiple data sources verify accuracy. We've done the work to combine data from multiple sources to make sure you have all of the fields you need. Plus, we haven't included dozens of fields that you will never use and only slow you down.
You may make unlimited copies as long as each copy you make is for internal company use only. For example, you are allowed to make copies for backups as long as those backups are not publicly available. You may also make copies for each workstation for each employee. You may not make the data set publicly available for download over the internet or distribute the complete data set as part of an application provided to customers. However, you may use on public networks such as the internet if used within a lookup application such as a "nearest store lookup" where the data set is not distributed to end users. If you would like to redistribute the data or have a question about acceptable usage, please contact us for further clarification and pricing options.
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.
|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|
|percent_population_in_poverty||Percent of the population living below the poverty level|
|median_earnings_past_year||Median individual earnings within past year|
|median_income||Median household income within past year|
|median_gross_rent||For renters, median gross rent paid per month|
|median_home_value||Median owner occupied home value|
|percent_high_school_graduate||Percent of population with at least a high school diploma|
|percent_bachelors_degree||Percent of population with at least a bachelors degree|
|percent_graduate_degree||Percent of population with a graduate degree|
|* 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.
When addressing mail, the USPS prefers everyone use the primary city whenever possible. However, we realize that there are many other uses for this data set so we have included lists of other cities that are recognized by USPS. Acceptable cities are recognized by the USPS and should not result in delivery delays. As you will learn below, certain geographic areas are frequently referred to by multiple names. The boundaries of a ZIP code generally have nothing to do with city limits. ZIP boundaries are set to aid mail delivery. As a result, the USPS may refer to an area by a name which may be inside an incorporated city's city limits that uses another name and still have other names that are used in common conversation. The list of unaccpetable cities may be fine for everyday conversation. However, using them when addressing mail will likely result in delivery delays.
One of the most frequent questions we get is related to matching ZIPs to cities. Remember that the boundaries of a ZIP code generally have nothing to do with city limits. ZIP boundaries are set to aid mail delivery. City limits are not.
Generally, USPS determines a mail route that best suites their needs, they assign a ZIP to that area, and they name the "city" of the ZIP after the post office(s) in that ZIP. As you can see from the example image, about the only time the city limits and ZIP boundaries match up are across state lines and that isn't even universally true. Many ZIPs cross state boundaries.
Think of it this way: if the postal carrier is driving down a road delivering mail and happens to cross the city limits, it makes little sense to have them stop delivering for the rest of the houses on the street simply because the city limits changed. Instead, they'll keep delivering along the street to the next intersection or some other boundary that makes more sense to allocating their available resources (aka drivers).
Futher, USPS does not always use the name of the incorporated city in which the ZIP code is located. The assignment of cities to ZIP codes is more general. The city is usually the name of the main post office.
The image example of New York, NY illustrates this point. The black outline shows the area of the official city limits. Every color coded region within is a different ZIP code. ZIPs with the same city according to USPS have the same color. To avoid overcrowding, only a few labels are shown.
As you can see, the area inside New York city is actually split into many ZIP codes that are each named after different places. Staten Island, Brooklyn, and Bronx are all famous parts of NYC that can easily be picked out in the example. None of them are actually an incorporated city. However, USPS uses those names to indicate the city for the ZIP codes located in those areas. Because the area is so densely populated, many different areas within NYC are given names that are not "New York." Only a small subset of ZIPs in Manhattan use the designation "New York" even though many others exist within the city limits.
Remember that people in rural areas outside of city limits still need to receive mail. So, ZIP codes cover a much larger portion of the land area in the US than city limits.
This coverage is easily seen in the image examples shown for the area around Memphis, TN. One map shows the color coded areas that make up the official city limits for the various cities in the region. The second map shows all ZIP codes with the same primary city shaded using the same color. Notice how many rural areas are grouped with nearby cities because they share delivery resources.
The latitude and longitude coordinates that are rounded to 2 decimal places should be sufficient for many use cases. 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, the lack of precision due to rounding to two decimal places is insignificant when compared to the reduction in precision caused by reducing a complex shape to a single point. Many of these coordinates have been hand chosen. The lack of additional digits after the decimal 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.