ZIPList5 Plus TM (May 2008 data)
Up-to-date ZIP code data file with area code, county name, county FIPS code, ZIP code type, city and state information for every 5-digit ZIP code in the entire USA plus time zone, and daylight saving time data!
Description
ZIPList5 Plus is a database of every city in the United States and its territories to which the US Postal Service delivers mail. The database contains the 5-digit ZIP code, city name, state abbreviation, county name and county FIPS code, ZIP code type, primary telephone area code, time zone, and daylight saving time flag for each of the nearly 42,700 ZIP code defined by the USPS.
Search this comma delimited ASCII text file with your favorite text editor or import the file into any database program, such as MS Access, dBase, Paradox, FoxPro, etc. Also available in native Access, dBase, and Paradox formats. Other file formats are available upon request. You can also incorporate this data into your own applications to look up the city and state based on ZIP code or area code.
Record Layout
"City Name","State Code","ZIP code","Area code","County FIPS code","County Name","Preferred flag","Time zone","DST","ZIP Code Type"CRLF
The fields are defined as follows:
We update every record in ZIPList5 Plus 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 include the most recent area code changes in every update. We license our ZIP code data directly from the US Postal Service, and collect and cross-check all the other data continuously from a variety of sources, including NANPA, the telephone companies, and maps.
The data records of the ZIPList5 Plus file consist of ten quote-delimited, comma-separated, ASCII text fields, arranged as follows:
| Field | Type | Length | ||
|---|---|---|---|---|
| City Name | Variable length ASCII | 28 maximum | ||
| State Code | Fixed length ASCII | 2 | ||
| ZIP code | Fixed length ASCII | 5 numeric characters | ||
| Area code | Fixed length ASCII | 3 numeric characters | County FIPS | Fixed length ASCII | 5 numeric characters |
| County Name | Variable length ASCII | 25 maximum | ||
| Preferred? | Fixed length ASCII | 1 ("P","A", or "N") | ||
| Time zone | Variable length ASCII | 5 maximum | ||
| DST | Fixed length ASCII | 1 ("Y" or "N") | ||
| ZIP code type | Fixed length ASCII | 1 character (P, U, M, or blank) |
The City Name field identifies a city name associated with the ZIP code by the USPS. There may be several different city names associated with a particular ZIP code. If so, the ZIP code will appear in several different records, each with a different city name.
The ZIP code field lists only valid 5-digit ZIP codes currently defined by the USPS. Obsolete ZIP codes which have been "retired" from service by the USPS are not included in this database. A particular ZIP code may appear in more than one record if the USPS has defined more than one city name for that ZIP code.
The area code is the "most prevalent" area code for that one ZIP code. If multiple area codes apply to that one ZIP code, only the primary area code is listed. Overlay area codes are not listed.
The County FIPS code is a 5-digit numeric field containing a unique numeric identification assigned to that county by the US government. The County FIPS code field and the County Name field identify the "most prevalent" county for the 5-digit ZIP code listed in a given record.
The Preferred? flag can have one of three states, which indicate how that name can be used for delivery of mail to the associated ZIP code. The three states are:
- P - This is the preferred city name for this ZIP code
- A - This city name is approved (but NOT preferred) for this ZIP code
- N - The city name is NOT approved for mail delivery to this ZIP code
The one preferred name record has the preferred field set to "P", while all alias name records have the preferred field set to "A" or "N". Note that in some cases a particular name may be preferred for some ZIP codes but an alias name for other ZIP codes. This frequently occurs when the exact political boundary between adjacent cities is obscure, leading people to use the two city names interchangeably within the boundary area.
The time zone field always contains the standard time zone designation for a particular ZIP code. If that ZIP code falls within a political entity which participates in Daylight Saving Time (DST) during the summer months, the DST field is set to "Y". Otherwise the DST field is set to "N".
The ZIP Code type field identifies special ZIP codes used for PO Boxes, companies, or the military.
Sample Records
"Key West","FL","33040","305","12087","Monroe","P","EST","Y",
"Stock Island","FL","33040","305","12087","Monroe","A","EST","Y",
"Raccoon Key","FL","33040","305","12087","Monroe","N","EST","Y",
"Agoura","CA","91376","818","06037","Los Angeles","A","PST","Y","P"
Click here to download a self-extracting file containing sample records in Access 97 format (about 26 KB).
Click here to download a self-extracting file containing sample records in comma-delimited ASCII format (about 17 KB).
Available File Formats
| Format | Compression | Download Size | ||
|---|---|---|---|---|
| Comma-delimited ASCII | self-extracting | 1.0 MB | ||
| Microsoft Access 2000 | self-extracting | 1.5 MB | ||
| Microsoft Access 97 | self-extracting | 1.3 MB | ||
| Paradox 9.0 | self-extracting | 1.0 MB | ||
| dBase | self-extracting | 1.0 MB | ||
| Comma-delimited ASCII | PKZip | 1.0 MB | ||
| Comma-delimited ASCII | uncompressed | 4.7 MB |
Licenses
We offer the following licenses for ZIPlist5 Plus:
- Workstation License - single-user, single workstation
- Enterprise License - unlimited users on unlimited sites within one company
- Duplication Addendum - Addendum to Enterprise or Workstation License for redistributing the data of ZIPList5 Plus outside your company.
Prices
| May 2008 data | Quarterly* Subscription save up to 39% |
Monthly** Subscription save up to 50% |
|
|---|---|---|---|
| Workstation License: | $39.95 | $119.95 | $299.00 |
| Enterprise License: | $99.95 | $239.95 | $599.00 |
| Duplication Addendum: up to 100 copies unlimited copies |
$199.00 $399.00 |
$479.00 $959.00 |
$1,199.00 $2,399.00 |
* Quarterly subscription: Annual fee. You'll receive the latest ZIPList5 Plus data every three months for a full year, starting with May 2008.
** Monthly subscription: Annual fee. You'll receive the latest ZIPList5 Plus data every month for a full year, starting with May 2008.
Prices subject to change without notice.
Delivery
| Internet: | Download ZIPList5 Plus 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, fax 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: | ||||||||||||||||||
|
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 800-571-3914 or 281-292-3270 to place your order. We will prepare a pro forma invoice and send it to you via email, fax, 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 fax a tax exemption certificate to us at 281-292-3608 and should contact us at 800-571-3914 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 ZIPList5 Plus with our 30-Day Money-Back Guarantee. If you are not satisfied with ZIPList5 Plus we will cheerfully refund the purchase price of the product.
What our Customers say about our Database Products and about us
Other ZIP code Products - ZIP code Product Search - About Us - Home
Sales: sales@zipinfo.com
Support: support@zipinfo.com
Mail: CD Light, LLC, 230 N Tranquil Path Dr, The Woodlands TX 77380-2758
Voice: 800-571-3914 or 281-292-3270
Fax: 281-292-3608