ZIPList Can-USA TM (October 2017)

This database conveniently combines two of our other products, ZIPList5 Plus and ZIPList Canada, into a single ZIP code database which covers both the USA and Canada in a single product.

Download Canadian postal code, city, province, area code, time zone and daylight saving time information immediately!

Description
This data file lists every city and ZIP or Postal CodeOM for all of the USA and Canada, as well as telephone area codes, time zone and daylight saving time. This database includes all recent area code changes. Use this database with popular commercial database programs such as MS Access, dBase, Paradox, FoxPro, etc. Available for immediate download in native Access, dBase, and Paradox formats. You can also incorporate this data into your own applications to look up the city and state/province based on ZIP/Postal CodeOM or area code.

  • More than 890,000 records
  • Covers all 50 states and all 13 provinces and territories, including Nunavut
  • Updated monthly
We update every ZIP code record in ZIPList Can-USA monthly, so you always receive the latest and most up-to-date data. You can't get more accurate and timely Postal CodeOM data from any other source! We include the most recent area code changes in every update. Our data comes directly from the US Postal Service and Canada Post Corporation. We collect and cross-check all the other data continuously from a variety of sources, including NANPA, the telephone companies, and maps.

Record Layout
Field Type Length
City Name Variable length 30 maximum
State/Province Code Fixed length 2
ZIP/Postal CodeOM Fixed length 6 alphanumeric characters, plus embedded space
Area Code Fixed length 3 numeric characters
County Name (USA only) Variable length 25 maximum
Time zone Variable length 5 maximum (EST, CST, MST, etc.)
DST Fixed length 1 ("Y" or "N")
Country Fixed length 1 ("C", or "U")
ZIP code type (USA only) Fixed length 1 character (P, U, M, or blank)
Preferred Fixed length 1 ("P","A", or "N")
County FIPS (USA only) Fixed length 5 numeric characters

The City field identifies a city name associated with the ZIP/Postal CodeOM. There can be several different city names associated with a particular ZIP or postal code. If so, that ZIP/Postal CodeOM may appear in several different records, each with a different city name. The Preferred field (described below) identifies whether the city name in this record is the primary city name or an alias (alternate) city name for this ZIP/Postal CodeOM.

Note that some city names in Quebec contain special diacritical marks. The character set employed for these characters is ISO-8859-1. An English-only version of this product is available for those applications which cannot use the French spellings.

The State/Province field contains the standard 2-character abbreviation for the state or province.

The ZIP/Postal CodeOM field contains only valid ZIP/Postal CodeOMs currently defined by the US Postal Service or Canada Post Corporation (CPC). Obsolete ZIP/Postal CodeOMs which have been "retired" from service are not included in this database.

The Area code is the "most prevalent" area code for that one Postal CodeOM. If multiple area codes apply to that one Postal CodeOM, only the primary area code is listed. Overlay area codes are not listed.

The County Name field identifies the "most prevalent" county for the 5-digit ZIP code listed in a given record. Note: This field applies to ZIP code (USA) records only. In all Canadian records this field is empty.

The Time zone field always contains the standard time zone designation for a particular Postal CodeOM. If that Postal CodeOM 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 Country field contains a single character which identifies whether the record is a USA record ("U") or a Canadian record ("C").

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

The Preferred flag can have one of three states, which indicate how that city name can be used for delivery of mail to the associated ZIP/Postal CodeOM. The three states are:

  • P - This is the preferred city name for this ZIP/Postal CodeOM
  • A - This city name is approved (but NOT preferred) for this ZIP/Postal CodeOM
  • N - The city name is NOT approved for mail delivery to this ZIP/Postal CodeOM
Some people object to using the "preferred" city name specified by the US Postal Service; these people may instead use some other, locally preferred name. This can be quite confusing. Accordingly, we have included in the database these "alias" city names, along with the ZIP/Postal CodeOMs to which they apply. This means that a particular ZIP code may exist in a "preferred name" record and again in one or more "alias name" records.

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 County FIPS code (USA only) 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.

Sample Records
City Name
Aurora
Denver
Austin
Sandy
Aspen
Chester
Province Code
CO
CO
TX
UT
NS
NS
Postal CodeOM
80010
80203
78701
84070
B0H 1E0
B0J 1J0
Area Code
303
303
512
801
902
902
County Name
Arapahoe
Denver
Travis
Salt Lake
 
 
Time Zone
MST
MST
CST
MST
EST+1
EST+1
DST Flag
Y
Y
Y
Y
Y
Y
US Can
U
U
U
U
C
C
ZIP Type
Pref Code
P
P
P
P
P
P
Cnty FIPS
08005
08031
48453
49035
 
 

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 (selected at time of download)
Comma-delimited ASCII (CSV)
Microsoft Excel 2007, 2010, 2013
Microsoft Access 2007, 2010, 2013
Microsoft Access 2003
Paradox 9.0
dBase IV, Visual FoxPro

Licenses
We offer these licenses for ZIPList Can-USA:

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


Prices
October 2017 data Annual Subscription
Quarterly* updates

save up to 59%
Annual Subscription
Monthly** updates

save up to 66%
Workstation License: $79.95 $239.00 $549.00
Enterprise License: $199.00 $479.00 $949.00

*Quarterly updates: Pay this fee one time. You'll receive the latest ZIPList Can-USA data every three months for a full year (a total of four versions), starting with the October 2017 version.
**Monthly updates: Pay this fee one time. You'll receive the latest ZIPList Can-USA data every month for a full year (a total of 12 versions), starting with the October 2017 version.
Prices subject to change without notice.

Delivery
Internet: Download ZIPList Can-USA immediately after you place your order online via our secure server. After we check your credit card (which usually takes only a few seconds) we'll return an order confirmation page to your browser containing the information you need to download the data from our server. We'll also include an invoice which states what you ordered and paid. Please print out a copy of this invoice for your records!

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 ZIPList Can-USA with our 30-Day Money-Back Guarantee. If you are not satisfied with ZIPList Can-USA 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 postal code, city, province, area code, time zone and daylight saving time information



Postal code, city, province, area code, time zone and daylight saving time


ZIP code databases - Postal Codes databases - ZIP/Postal Code databases - About Us - Contact Us - Home

Postal code, city, province, area code, time zone and daylight saving time

Copyright © 2017 CD Light, LLC

Postal CodeOM is an official mark of Canada Post Corporation.