Database Specs & Features
- Immediate Download
Download is available immediately upon purchase and for the duration of the annual subscription.
- Monthly Updates
We update our database monthly and recommend that you download monthly as well.
- Free FTP (upon request)
To update your database without human intervention, we can provide you will your own FTP site that you can write a script to access. Just request it after purchase.
- Data Format - CSV
Comma-Separated Values (CSV) Text File
- Canadian Area Code
All standard area codes are listed. Toll-free Area codes such as 800, 866, 877 and other specialty area codes are not included. The first digit is in the range of 2-9, the second digit can be a 0-8, and the third digit can be a 0-9.
The prefix (also called the Exchange or Central Office Code) is next. This is referred to as the ‘NXX’. The first digit is in the range of 2-9, the second and third digits can be a 0-9.
- Province Abbreviation
This is the 2-character standard (Canada Post) province abbreviation. We also include a file called, ‘states.txt’ which will list the province name for each abbreviation.
- Time Zone
Canadian Time Zones are in a standard format which is the number of hours from Coordinated Universal Time (UTC) which was formerly called Greenwich Mean Time (GMT). Greenwich is where the Royal Observatory is located (Southeast London). West of UTC is negative and so all records have negative numbers. The zones range from -3:30 (Newfoundland Standard Time) to -8 (Pacific Standard Time).
- Daylight Savings Flag
If the area covered by this area code / prefix observes Daylight Saving Time, then the last field will be ‘Y’, otherwise ‘N.’
Our Canadian Area Code Database provides a list of all active area codes and prefixes (NPA/NXX)*. It includes highly accurate Time Zones and Daylight Saving Time information.
This product is updated regularly as codes are added and is released monthly. The price includes an initial download and any updates made available throughout your subscription period.
*NPA/NXX - NPA stands for Numbering Plan Area Code
. It is simply the Area Code most are familiar with. The NXX stands for Exchange or Central Office Code
. It is often referred to as an Area Codes prefix.