The NALENND® NPA NXX to Canadian Postal Code Database provides the coverage required to identify which telephone area codes and exchanges are used in a particular Postal Code as well as what Postal Codes are in use within a particular telephone area code and exchange.
This mapping is based on the geography of the NPA NXX Rate Center and the Postal Code boundaries which yields a true representation of the coverage areas.
Produced: on or before 5th calendar day monthly
Current Release: November 3, 2024
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
NALENND® NPA NXX to Postal Code Database Reference Manual
NALENND® NPA NXX to Postal Code Database Sample Data
NPA NXX to ZIP Codes File
| Field | Data Type | Field Description |
|---|---|---|
| NPA | CHAR (3) | The 3-digit area code. |
| NXX | CHAR (3) | The 3-digit exchange prefix. |
| ZIP | CHAR (7) | 7-character alpha numeric Canada Postal Code. Format is A1A 1A1, where A is a letter and 1 is a digit, with a space separating the third and fourth characters. For those exchanges and/or services that are not geographically associated with a postal code area (e.g. 211, 411, 811, 911 etc.) or when a postal code cannot be identified, this field will be populated with the value Q0Q 0Q0. |
| STATE | CHAR (2) | Two character province or territory abbreviation. |
| CITY | VARCHAR (128) | Name of city or locale identified by the current postal code. |
| RC | CHAR (10) | 10-character Rate Center abbreviated name identifying local service area where the NPA NXX is assigned. |
SQL Table Definitions
CREATE DATABASE if not exists `nalennd`;
USE `nalennd`;
DROP TABLE IF EXISTS `npanxx2postal`;
CREATE TABLE `npanxx2postal`
(
`NPA` CHAR(3) NOT NULL,
`NXX` CHAR(3) NOT NULL,
`ZIP` CHAR(7) NOT NULL,
`STATE` CHAR(2) NOT NULL,
`CITY` VARCHAR(128) NOT NULL,
`RC` VARCHAR(128) NOT NULL,
PRIMARY KEY (`NPA`,`NXX`,`ZIP`)
)
ENGINE=MYISAM DEFAULT CHARSET=utf8;