NALENND™
NPA NXX to Canada Postal Code Database - Standard Edition

NALENND NPA NXX Database 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: September 2, 2020
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download


NPA NXX to ZIP Codes File

FieldData TypeField Description
NPACHAR (3)The 3-digit area code.
NXXCHAR (3)The 3-digit exchange prefix.
ZIPCHAR (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.
STATECHAR (2)Two character province or territory abbreviation.
CITYVARCHAR (128)Name of city or locale identified by the current postal code.
RCCHAR (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;