ZIPList5 Plus (May 2012 data)

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 zipcode or areacode.

The most up-to-date 5-digit zipcode database available, this file includes all recent areacode changes.

• About 71,500 records (42,700 "preferred" records plus 28,800 "alias" records)
• Includes common local city names
• Updated monthly

"City Name","State Code","Zipcode","Areacode","County FIPS code","County Name","Preferred flag","Timezone","DST"CRLF

The fields are defined as follows:

Field		Type		Length
City Name		Variable length ASCII		28 maximum
State Code		Fixed length ASCII		2
Zipcode		Fixed length ASCII		5 numeric characters
Areacode		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")
Timezone		Variable length ASCII		5 maximum
DST		Fixed length ASCII		1 ("Y" or "N")

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 zipcode 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 zipcode. The three states are:

• P - This is the preferred city name for this zipcode
• A - This city name is approved (but NOT preferred) for this zipcode
• N - The city name is NOT approved for mail delivery to this zipcode

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 zipcodes but an alias name for other zipcodes. 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 timezone field always contains the standard timezone designation for a particular zipcode. If that zipcode 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".

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"

Click here to download a self-extracting file containing sample records in Access 2003 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 2.0		self-extracting		1.4 MB
Microsoft Access 2003		self-extracting		1.2 MB
Paradox 9.0		self-extracting		1.0 MB
dBase		self-extracting		1.0 MB
Comma-delimited ASCII		WinZip		0.9 MB
Comma-delimited ASCII		uncompressed		4.6 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.

	May 2012 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 more than 100 copies	$199.00 $399.00	$479.00 $959.00	$1,199.00 $2,399.00

* Quarterly subscription: You'll receive the latest ZIPList5 Plus data every three months for a full year, starting with May 2012.
** Monthly subscription: You'll receive the latest ZIPList5 Plus data every month for a full year, starting with May 2012.
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:	Normally we process and ship all orders within 1 business day using the shipping method you chose. The following shipping and handling charges apply:
	USA: Surface: $6.00 2nd Day Air: $10.00 Overnight: $15.00 International: $10.00

Payment
All orders must be prepaid. We accept Visa, MasterCard, Discover Card and American Express. We also accept checks and money orders in US funds drawn on a US bank. The payment must include sales tax for Texas residents and shipping and handling charges if applicable.

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

Order Information - Product Catalog - Product Search - About Us - Contact Us - Home