County - ZIP Code Database TM (August 2014 data)

The County - ZIP Code Database lists every county-ZIP code combination in the USA and its territories!

Download ZIP code, county, county FIPS code, city and state information immediately!

Description
The County - ZIP Code Database lists all ZIP codes and counties in the United States and its territories to which the US Postal Service (USPS) delivers mail. What makes this database unique is that it lists every county-ZIP code combination which exists in the real world. Other databases list only a single county for each ZIP code.

In the real world, ZIP code boundaries often cross county boundaries. This means that a particular ZIP code may lie in several counties. In fact more than 20 percent of all ZIP codes lie in more than one county. For example, ZIP code 38583 covers portions of five different counties! Clearly, you cannot assume that a particular ZIP code lies completely within the one county listed by other ZIP code databases.

This means that you cannot determine the correct county with 100 percent accuracy using only the 5-digit ZIP code. If you want to find the correct county with 100 percent accuracy for a given address, you must use an address matching product, such as our product Perfect Address, which can find the correct county for every address to which the USPS delivers mail.

Using the County - ZIP Code Database, you can find every ZIP code which lies partially or completely within a given county. Or you can find all counties which contain some portion of a particular ZIP code. You also can find the preferred city name associated with any ZIP code, and the county FIPS code associated with any county.

The database contains approximately 55,000 records.

We update every record in County - ZIP Code Database monthly, so you always receive the latest and most up-to-date data. You can't get more accurate and timely ZIP code data from any other source! We license our ZIP code data directly from the US Postal Service.

Record Layout
Field Type Length
County Name Variable length 25 alpha maximum, mixed case
ZIP code Fixed length 5 numeric characters
ZIP code type Fixed length 1 character (P, U, M, or blank)
County FIPS Code Fixed length 5 (2 + 3) numeric characters
City Name Variable length 28 alpha maximum, mixed case
State Code Fixed length 2
Address Record Count Variable length 5 numeric characters
Prevalent-County Flag Fixed length 1 char (Y or blank)
Multiple-County Flag Fixed length 1 char (Y or blank)

The County Name field identifies a county which contains some or all of the ZIP code identified by the ZIP code field.

The ZIP Code field identifies one ZIP code which lies at least partially within the boundaries of the county identified by the County Name field. Note that portions of this ZIP code may also lie within the boundaries of other counties. The ZIP code field is treated as a text field, not a numeric field. This is to prevent the loss of the leading zeroes in certain ZIP codes when the data is imported into a database program.

The ZIP Code type field identifies special ZIP codes used for PO Boxes, companies, or the military.

The County FIPS Code is a 5-digit field containing a unique numeric identification assigned to each county in a given state by the US government. We have combined the 2-digit state FIPS code with the 3-digit county FIPS code to yield a 5-digit code which can be used to uniquely identify each county in the USA. The County FIPS field is also treated as a text field to prevent the loss of leading zeroes.

The City Name field identifies the one city associated with that particular ZIP code (and NOT necessarily the County) by the USPS. Note that, in some cases, the city may actually reside in a different county. This apparent error exists because the USPS associates a ZIP code with one "preferred" city name, even if that city is physically in a different county. This city name is the name preferred by the USPS for use on mail sent to that one ZIP code.

The State Code is the USPS 2-character state abbreviation, such as CA for California.

The Address Record Count field identifies the number of ZIP+4 address records that list both that one particular County and that one particular 5-digit ZIP code. This field provides a method of determining the relative portion of a given ZIP code which lies within a given county. Note, however, that this number is not based on area or population, but on actual ZIP+4 address records in the USPS ZIP+4 address database (not included with this database).

The Prevalent-County flag is set to "Y" if that county countains the largest portion (or all) of the ZIP code. For each ZIP code there should be only one record containing a "Y" in this field. If the ZIP code lies in more than one county, there will be multiple records containing this ZIP code, but only one record will have the Prevalent-County flag set to "Y".

The Multiple-County flag is set to "Y" if the ZIP lies in more than one county. If this flag is set to blank, the ZIP code lies completely within the boundaries of the specified county.

Sample Records

This is an example of a ZIP code that lies in five different counties:

County Name
Cumberland
Dekalb
Putnam
Van Buren
White
ZIP Code
38583
38583
38583
38583
38583
ZIP Type
 
 
 
 
 
Cnty FIPS
47035
47041
47141
47175
47185
City Name
Sparta
Sparta
Sparta
Sparta
Sparta
ST Code
TN
TN
TN
TN
TN
Address Records
153
325
126
84
4213
Prevalent County
 
 
 
 
Y
Multi-County
Y
Y
Y
Y
Y

Click here to download sample records in comma-delimited ASCII (CSV) format.

Click here to download sample records in comma-delimited ASCII (CSV) format, compressed with WinZip.

Available File Formats
Format Compression Download Size
Comma-delimited ASCII self-extracting 666 KB
Microsoft Access 2007 self-extracting 1.1 MB
Microsoft Excel 2007 self-extracting 1.1 MB
Microsoft Access 2000 self-extracting 1.0 MB
Microsoft Access 2003 self-extracting 930 KB
Paradox 9.0 self-extracting 721 KB
dBase self-extracting 698 KB
Comma-delimited ASCII WinZip 650 KB
Comma-delimited ASCII uncompressed 3.1 MB

Licenses
We offer the following licenses for the County - ZIP Code Database:

Please read our License Overview to determine which license you need.


Prices
August 2014
data
Quarterly*
Subscription

save up to 62%
Monthly**
Subscription

save up to 68%
Workstation License: $99.95 $199.95 $499.00
Enterprise License: $199.95 $299.95 $749.00
Duplication Addendum:
up to 100 copies
unlimited copies

$399.00
$799.00

$599.00
$1,199.00

$1,499.00
$2,999.00

* Quarterly subscription: Annual fee. You'll receive the latest County - ZIP Code Database data every three months for a full year, starting with August 2014.
** Monthly subscription: Annual fee. You'll receive the latest County - ZIP Code Database data every month for a full year, starting with August 2014.
Prices subject to change without notice.

Delivery
Internet: Download County - ZIP Code Database immediately after you place your order online via our secure server. We'll include an invoice which states what you ordered and paid.

If you place your order via phone or mail we will process your order usually within 1 business day. After we process your order we will send you an email message with the download information. We'll include an invoice which states what you ordered and paid.

No shipping and handling charges for Internet delivery.

CDROM: We'll process and ship your order within one business day. The following shipping and handling charges apply to delivery on CDROM:
Surface (USA, First Class) $8.00
International (Air Mail) $20.00

Payment
All orders must be prepaid. We do not accept Purchase Orders. We accept Visa, MasterCard, Discover Card and American Express for online or telephone orders.

We also accept checks and money orders in US funds drawn on a US bank. The payment must include shipping and handling charges, if applicable. Orders which do not include appropriate shipping and handling charges will be delayed. If you need an invoice to submit to your accounting department to have a check cut please contact us at 866-256-2042 or 281-292-3270 to place your order. We will prepare a pro forma invoice and send it to you via email or snail mail. However, your order will not be shipped until we receive payment in full.

Attention Texas residents: Orders for delivery to a Texas address, whether downloaded via the Internet or delivered on CDROM, must include sales tax of 8.25% on the total amount of the order, including shipping and handling, if any. A sales tax of 8.25% of the order total will automatically be added to all Texas orders processed through our online ordering system. Tax exempt organizations in Texas must send a tax exemption certificate to sales@zipinfo.com and should contact us at 866-256-2042 to place their orders. Orders which do not include appropriate sales tax or a valid tax exemption certificate will be delayed.

30-Day Money-Back Guarantee
We back County - ZIP Code Database with our 30-Day Money-Back Guarantee. If you are not satisfied with County - ZIP Code Database we will cheerfully refund the purchase price of the product.

What our Customers say about
our Database Products and about us

Yes, I want to order the ZIP code database with city and state



ZIP code, county, county FIPS code, city and state


Other ZIP code Products - ZIP code Product Comparison - About Us - Contact Us - Home


ZIP code, county, county FIPS code, city and state

Copyright © 2014 CD Light, LLC