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.
Countries 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: September 3, 2023
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
NALENND® United States, Canada, Mexico Combined Database Reference Manual
NALENND® United States, Canada, Mexico Combined Database Sample Data
Record Layout and Field Descriptions
| Field | Data Type | Field Description |
|---|---|---|
| CC | CHAR (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. |
| NPA | CHAR (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. |
| NXX | CHAR (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_From | CHAR (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_To | CHAR (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_Type | CHAR (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.
|
| Carrier | VARCHAR (128) | Name of telephone carrier providing service for the particular number range. |
| Country | CHAR (2) | 2-character ISO 3166 Country Code (ISO 3166-1:2006 2006) of the telephone exchange location. |
| State | VARCHAR (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. |
| Location | VARCHAR (128) | The city, town, village, community, zone or similar name identifying the telephone exchange service type or area. |
| TimeZone | VARCHAR (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. |
| UTC | CHAR (6) | Coordinated Universal Time (UTC) offset for the Rate Center geographic location. Format is +\-HH:MM. |
| DST | CHAR (1) | Specifies whether daylight savings time is recognized. |
| Latitude | DOUBLE | Latitude in decimal degrees locating the general telephone exchange service area. |
| Longitude | DOUBLE | Longitude 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;