NALENND™
North American Local Exchange NPA NXX Database
United States, Canada, Mexico Combined Edition

The NALENND™ United States, Canada, Mexico Combined database provides a uniform presentation of the telephone numbering plans and exchange areas for those countries participating in the North American Numbering Plan and Mexico.

NALENND NPA NXX Database

Counties participating in the North American Numbering Plan (NANP) include the United States and its territories, Canada, Bermuda, Anguilla, Antigua & Barbuda, the Bahamas, Barbados, the British Virgin Islands, the Cayman Islands, Dominica, the Dominican Republic, Grenada, Jamaica, Montserrat, Sint Maarten, St. Kitts and Nevis, St. Lucia, St. Vincent and the Grenadines, Trinidad and Tobago, and Turks & Caicos.

Produced: on or before 5th calendar day monthly
Current Release: August 2, 2017
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download


Record Layout and Field Descriptions

FieldData TypeField Description
CCCHAR (3)International Telephone Union ITU-T Recommendation E.164 numeric country code. Commonly referred to as IDD (International Direct Dialing) or ISD (International Subscriber Dialing) code, this code is the combination of one, two or three digits identifying a specific country, countries in an integrated numbering plan, or a specific geographic area.
NPACHAR (3)Commonly referred to as Area Code or National Destination Code; for United States and Canadian entries this field represents the North American Numbering Plan Area (NPA) Code, for Mexico this field represents the Region Identification Number (NIR). For those countries participating in the North American Numbering Plan, country code 1, NPA is always 3-digits; for Mexico, country code 52, NPA is 2-digits for metropolitan areas Mexico City, Guadalajara and Monterrey for all other areas NPA is 3-digits.
NXXCHAR (4)This 3 or 4-digit field further defines specific geographic service areas or service type within a particular Area Code. Commonly called the telephone exchange or prefix code, within the North American Numbering Plan it is also referred to as the Central Office Code.
Line_FromCHAR (4)The first 4-digits identifying the starting number in the block of numbers served by the particular carrier, service type or switching entity associated with the NPA NXX.
Line_ToCHAR (4)The last 4-digits identifying the ending number in the block of numbers served by the particular carrier, service type or switching entity associated with the NPA NXX.
Line_TypeCHAR (1)Line or service type associated with the particular telephone exchange or number range. Line type identification is based on original carrier assignments within their particular numbering plan.
  • G - Geographic land line or fixed service, includes POTS, WLL etc.
  • V - VoIP or location independent fixed land line
  • M - Mobile, includes cellular, PCS, GSM, etc.
  • F - Toll free also known as Freephone
  • S - Special (premium service, data, internet access, etc. which all incur a higher charge rate).
CarrierVARCHAR (128)Name of telephone carrier providing service for the particular number range.
CountryCHAR (2)2-character ISO 3166 Country Code (ISO 3166-1:2006 2006) of the telephone exchange location.
StateVARCHAR (5)Postal abbreviation or code of the state, province, department, territory, or similar division within the country associated with the telephone exchange if any. If a standard national abbreviation does not exist for the region the value will be that specified in International Standard ISO 3166-2:2007 Codes for the representation of names of countries and their subdivisions.
LocationVARCHAR (128)The city, town, village, community, zone or similar name identifying the telephone exchange service type or area.
TimeZoneVARCHAR (128)Internet Assigned Numbers Authority (IANA) time zone database time zone identifier or time zone name for the Rate Center geographic location. The IANA time zone database is also referred to as the tz database, the zoneinfo database, and the Olson database.
UTCCHAR (6)Coordinated Universal Time (UTC) offset for the Rate Center geographic location. Format is +\-HH:MM.
DSTCHAR (1)Specifies whether daylight savings time is recognized.
LatitudeDOUBLELatitude in decimal degrees locating the general telephone exchange service area.
LongitudeDOUBLELongitude in decimal degrees locating the general telephone exchange service area.

SQL Table Definitions


CREATE DATABASE if not exists `nalennd_uscamx`;
USE `nalennd_uscamx`;

DROP TABLE IF EXISTS `npanxx`;
CREATE TABLE `npanxx` (
	`CC` char(3) NOT NULL,
	`NPA` char(3) NOT NULL,
	`NXX` char(4) NOT NULL,
	`Line_From` char(4) NOT NULL,
	`Line_To` char(4) NOT NULL,
	`Line_Type` char(1) DEFAULT NULL,
	`Carrier` varchar(128) DEFAULT NULL,
	`Country` char(2) DEFAULT NULL,
	`State` varchar(5) DEFAULT NULL,
	`Location` varchar(128) DEFAULT NULL,
	`TimeZone` varchar(128) DEFAULT NULL,
	`UTC` char(6) DEFAULT NULL,
	`DST` char(1) DEFAULT NULL,
	`Latitude` double NOT NULL DEFAULT '0',
	`Longitude` double NOT NULL DEFAULT '0',
	PRIMARY KEY (`CC`,`NPA`,`NXX`,`Line_From`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8;