NALENND™
North American Local Exchange NPA NXX Database - Standard Edition

NPA NXX Data Products

The Standard Edition is a basic NPA NXX database and provides a basic geography of the North American Public Switched Telephone Network.

You can use this data to identify all active NPA NXX combinations at the 10,000 block level, what the basic line type is, and what local exchanges they are being used for.

This data set is suitable for any application that needs to determine if an NPA NXX combination is valid and where it is being used.

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


NPA NXX Master Assignments File

FieldData TypeField Description
NPACHAR (3)Numbering Plan Area code, the first three digits of a 10 digit North American Numbering Plan (NANP) number, commonly called the Area Code.
NXXCHAR (3)Central Office Code, the first three digits following the Area Code in a 10 digit NANP number, commonly called the telephone exchange or prefix.
LTYPECHAR (1)Identifies whether the primary use of the NPA NXX is wireless or landline based on its initial assignment.
STATECHAR (2)State or province postal abbreviation of the Rate Center locale.
COUNTRYCHAR (2)ISO 3166-1 Country Code of the Rate Center locale.
RCVARCHAR (128)Full name of the geographical Rate Exchange Area, commonly referred to as the Rate Center. A Rate Exchange Area identifies the geographic area (i.e. locality, town, or city) served by a particular NPA NXX combination.
ZIPVARCHAR (5)5-digit United States ZIP or 3-character Canadian Forward Sortation Area code for the Rate Center locale.
ZIP2VARCHAR (5)Second possible ZIP or FSA code
ZIP3VARCHAR (5)Third possible ZIP or FSA code
ZIP4VARCHAR (5)Fourth possible ZIP or FSA code
FIPSCHAR (5)United States FIPS county code or Canadian Census Division code.
FIPS2CHAR (5)Second possible FIPS or Census Division code
FIPS3CHAR (5)Third possible FIPS or Census Division code
FieldData TypeField Description
CountyCodeCHAR (5)Five-digit U.S. FIPS county code or four-digit Statistics Canada Census Division code.
CountryCHAR (2)Two character country abbreviation
StateCHAR (2)Two character state, province, or territory abbreviation
NameVARCHAR (128)Name of the county or division
TypeVARCHAR (80)Organizational recognition of the county or division
LandAreaNUMBERCounty or Census Division land area in square miles
Pop2006NUMBERU.S. Census Bureau, Population Division or Statistics Canada reported 2006 population

SQL Table Definitions

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

DROP TABLE IF EXISTS `npanxx`;
CREATE TABLE `npanxx` 
	(
	`NPA` CHAR(3) NOT NULL,
	`NXX` CHAR(3) NOT NULL,
	`LTYPE` CHAR(1) DEFAULT NULL,
	`STATE` CHAR(2) DEFAULT NULL,
	`COUNTRY` CHAR(2) DEFAULT NULL,
	`RC` VARCHAR(128) DEFAULT NULL,
	`ZIP` VARCHAR(7) DEFAULT NULL,
	`ZIP2` VARCHAR(7) DEFAULT NULL,
	`ZIP3` VARCHAR(7) DEFAULT NULL,
	`ZIP4` VARCHAR(7) DEFAULT NULL,
	`FIPS` CHAR(5) DEFAULT NULL,
	`FIPS2` CHAR(5) DEFAULT NULL,
	`FIPS3` CHAR(5) DEFAULT NULL,
	`CITY` VARCHAR(128) DEFAULT NULL,
	`COUNTY` VARCHAR(128) DEFAULT NULL,
	PRIMARY KEY (`NPA`,`NXX`)
	) 
ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `county`;
CREATE TABLE `county` 
	(
	`CountyCode` CHAR(5) NOT NULL,
	`Country` CHAR(2) DEFAULT NULL,
	`State` CHAR(2) DEFAULT NULL,
	`Name` VARCHAR(128) DEFAULT NULL,
	`Type` VARCHAR(80) DEFAULT NULL,
	`LandArea` INT(11) DEFAULT NULL,
	`Pop2006` INT(11) DEFAULT NULL,
	PRIMARY KEY (`CountyCode`)
	) 
ENGINE=MyISAM DEFAULT CHARSET=utf8;