ZIPList Canada TM (June 2017)
Canadian Postal CodeOM data file with city, province, area code, time zone and daylight saving time information for all of Canada!
Description
This data file lists every active Postal CodeOM for all of Canada, as well as the city, province, telephone area code, time zone, and daylight saving time. This database includes all recent area code changes. Search this 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. You can also incorporate this data into your own applications to look up the city and province based on Postal CodeOM or city.
- More than 820,000 records
- Covers all thirteen provinces and territories, including Nunavut
- Updated monthly
Note: Canadian Postal CodeOMs and US ZIP codes are also available in one combined file, ZIPList Can-USA.
Record Layout
| Field | Type | Length | ||
|---|---|---|---|---|
| City Name | Variable length | 30 maximum | ||
| Province Code | Fixed length | 2 | ||
| Postal CodeOM | Fixed length | 6 alphanumeric characters, plus embedded space | ||
| Preferred? | Fixed length | 1 ("P", or "A") | ||
| Area Code | Fixed length | 3 numeric characters | ||
| Time zone | Fixed length | 5 ("NST", "EST", "EST+1", "CST", "MST", "PST") | ||
| DST | Fixed length | 1 ("Y" or "N") |
The City Name field identifies the city associated with that Postal CodeOM. There may be several different city names associated with a particular Postal CodeOM. If so, the same Postal CodeOM will appear in several different records, each with a different city name. You can use the Preferred? field to find the best city name to use with the Postal CodeOM in this case. City names include special French characters where appropriate.
The Postal CodeOM field contains only valid 6-character Canadian Postal CodeOMs currently defined by Canada Post Corporation (CPC). Obsolete Postal CodeOMs which have been "retired" from service by CPC are not included in this database. A particular Postal CodeOM may appear in more than one record if the Postal CodeOM crosses the boundary between two cities.
The Preferred? flag can have one of two states, which indicate whether or not the Postal CodeOM exists in more than one city (very few do), and which of those city names is the best to use with this Postal CodeOM. The two states are:
- P - This record contains the primary city name for this Postal CodeOM
- A - This record contains an alternate city name for this Postal CodeOM
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 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".
Sample Records
| City Name |
|---|
| Aspen |
| Chester |
| Beaupré |
| Cap-Santé |
| Château-Richer |
| Saint-Jean-d'Orléans |
| Province Code |
|---|
| NS |
| NS |
| QC |
| QC |
| QC |
| QC |
| Postal CodeOM |
|---|
| B0H 1E0 |
| B0J 1J0 |
| G0A 1E0 |
| G0A 1L0 |
| G0A 1N0 |
| G0A 3W0 |
| Pref Code |
|---|
| P |
| P |
| P |
| P |
| P |
| P |
| Area Code |
|---|
| 902 |
| 902 |
| 418 |
| 418 |
| 418 |
| 418 |
| Time Zone |
|---|
| EST+1 |
| EST+1 |
| EST |
| EST |
| EST |
| EST |
| DST Flag |
|---|
| Y |
| 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 (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 Canada:
- Workstation License - single-user, single workstation
- Enterprise License - unlimited users on unlimited sites within one company
Prices
| June 2017 data | Quarterly* Subscription save up to 59% |
Monthly** Subscription save up to 66% |
|
|---|---|---|---|
| Workstation License: | $39.95 | $119.95 | $299.00 |
| Enterprise License: | $99.95 | $239.95 | $599.00 |
* Quarterly subscription: Annual fee. You'll receive the latest ZIPList Canada data every three months for a full year, starting with the June 2017 version.
** Monthly subscription: Annual fee. You'll receive the latest ZIPList Canada data every month for a full year, starting with the June 2017 version.
Prices subject to change without notice.
Delivery
| Internet: | Download ZIPList Canada 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: | ||||||
|
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 Canada with our 30-Day Money-Back Guarantee. If you are not satisfied with ZIPList Canada we will cheerfully refund the purchase price of the product.
What our Customers say about our Database Products and about us
ZIP code databases -
Postal Codes databases -
ZIP/Postal Code databases -
About Us -
Contact Us -
Home
Postal CodeOM is an official mark of Canada Post Corporation.