Advanced City and County Zip Code Database

This advanced zip code dataset allows you to link zip codes to every city and county name recognized by the USPS. This database builds on the Basic City and County Zip Code Database, and lists every single city and county associated with a zip code. The preferred city name for each zip code is also identified. Since thousands of zip-codes overlap city boundaries, this is the most accurate file for address verification. This zip code datatabase allows you to:

• Find out every city name used in a zip codes
• Find out all zip codes associated with a county (and visa versa)
• Find out what FIPs / ANSI codes are associated with each zip code
• Find out what zip codes are in each state
• Find out what the primary city is for each zip code
• Build robust address verification tools
• Create customized, zip code level demographic files

Our Advanced City and County Zip Code Database has over 80 thousand records and available for instant download in a simple .CSV file which can be imported into virtually every database available.

Data fields and definitions

The following are the fields included in the Advanced City and County Zip Code Database.   The rows are unique by 5 digit zip code, City Name and County.  The database contains over 80 thousand records.

Example layout and records

Each zip code database comes in a flat file layout in .CSV (comma separated values.)  The first row is the header row.  The table below is an example of a few rows of the data.

About our zip code data

We are zip code data specialists licensed to sell zip code data by the USPS.  We update every record in our zip code databases monthly.  You will always receive the latest and most up-to-date zip code data - guaranteed. Every file is hand edited to create the most accurate zip code data available.

We’ve built our 5 digit zip code database from data we receive under license from the United States Postal Service.  Just like the postal service, we start from the bottom up with detailed, house level Zip+4 data. The zip code datasets we receive from the postal service contain over 80 million rows of data. As our IT guy said, to paraphrase the immortal words of Roy Scheider as Brody in Jaws, "I think you'll need a bigger computer!"

Because of the detailed nature of the USPS zip code data, we have to conduct an exhaustive analysis of the data to get it into a format which is actually usable for everyone who is not a mailman. (In layman's terms, we "crunch" the database.) This produces a set of files which are actually manageable and extract the most useful data elements you would want to use from zip code data to link to your datasets or use in your applications.

And because all of this changes so frequently, we do all our analysis each month to ensure that we are delivering the best quality data in the easiest to use format straight to you.

Our guarantee

We believe our zip code data is best in the business and stand by it unconditionally. We are licensed by the USPS to sell their zip code datasets. We have a rigorous process to scrub the zip code data and make it usable in a business and programming context. We offer a satisfaction guarantee on all our products, no questions asked. We are proud of what we do and hope our efforts help you get to insight faster and more accurately.