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

NALENND NPA NXX Database

NPA NXX resources are assigned by Rate Center which can cover large geographic areas and may include multiple communities, towns or "cities". The City Edition helps decode multiple locations served within a single Rate Center by identifying NPA NXX usage at the "city" level.

This data set is suitable for call routing, compliance and similar type applications that need to identify valid NPA NXX combinations, determine their city, county, Rate Center and LATA geographic associations, time zones, whether the service is land line, wireless, VoIP and the carrier providing service.

Produced: on or before 5th calendar day monthly
Current Release: October 3, 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.
BLOCKCHAR (1)Block identifier. Implies, represents, or identifies either the entire group of 10,000 numbers or a specific group of 1,000 numbers within the NPA NXX.
LINE_FROMCHAR (4)The 4-digit number identifying the starting value of line numbers served by the particular 1,000 or 10,000 numbering block.
LINE_TOCHAR (4)The 4-digit number identifying the ending value of line numbers served by the particular 1,000 or 10,000 numbering block.
LTYPECHAR (1)Identifies whether the primary use of the NPA NXX is wireless or landline based on its initial assignment.
LATACHAR (5)Local Access and Transport Area (LATA), or LATA-like code of the Rate Center.
OCNCHAR (4)4-character Operating Company Number (OCN) also known as a NECA Company Code, identifying the NPA NXX code-holder or block-holder.
RATECENTERVARCHAR (128)Full name of the geographical Rate Exchange Area, commonly referred to as the Rate Center. A Rate Center identifies the geographic area (i.e. locality, town, or city) served by a particular NPA NXX combination.
CITYVARCHAR (128)Name of city, town, or locale within the Rate Center. There may be multiple cities within a given Rate Center.
FIPSCHAR (5)United States FIPS county code or Canadian Census Division code.
STATECHAR (2)State or province postal abbreviation of the Rate Center locale.
COUNTRYCHAR (2)ISO 3166-1 Country Code of the Rate Center locale.
CBSACHAR (5)United States Core Based Statistical Area (CBSA) or Canadian Census Metropolitan Area (CMA) code.
OLSONVARCHAR (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.

County Codes File

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
Pop2010NUMBERU.S. Census Bureau, Population Division or Statistics Canada reported 2010 population

LATA Codes File

FieldData TypeField Description
LATANUMBER (5)The Local Access Transport Area code.
STATECHAR (2)Two character state, province, or territory abbreviation of the NPA/NXX Service Center location.
COUNTRYCHAR (2)This two character field is the ISO 3166 Country Code for LATA location
LOCATIONVARCHAR (64)Generalized name defining the LATA location

NECA OCN (Carrier) Codes File

FieldData TypeField Description
OCNCHAR (4)4-character state or regional Operating Company Number (OCN) also known as a NECA Company Code.
TYPEVARCHAR (8)Type of carrier or service provider
COMPANYVARCHAR (128)The legal or generally formal name of the service provider.
DBAVARCHAR (128)The commonly recognized business name of the service provider.
CommonNameVARCHAR (128)The common consumer recognized trade name of the service provider.

Metropolitan Area Codes File

FieldData TypeField Description
CBSACHAR (5)5-digit Core Based Statistical Area code (United States) or 3-digit Statistics Canada Census Metropolitan Area (CMA) or Census Agglomeration (CA) code (Canada).
CSACHAR (3)Three-digit Combined Statistical Area code if the CBSA is part of a larger statistical area.
AREA_NAMEVARCHAR (64)Official name of the statistical area.
STATEVARCHAR (20)Abbreviated state code(s) for the statistical area.
AREA_TYPEVARCHAR (64)Metropolitan or Micropolitan statistical area.

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,
	`BLOCK` char(1) NOT NULL,
	`LINE_FROM` char(4) NOT NULL,
	`LINE_TO` char(4) NOT NULL,
	`LTYPE` char(1) DEFAULT NULL,
	`LATA` char(5) DEFAULT NULL,
	`OCN` char(4) DEFAULT NULL,
	`RATECENTER` varchar(128) DEFAULT NULL,
	`CITY` varchar(128) DEFAULT NULL,
	`FIPS` char(5) DEFAULT NULL,
	`STATE` char(2) DEFAULT NULL,
	`COUNTRY` char(2) DEFAULT NULL,
	`CBSA` char(5) DEFAULT NULL,
	`OLSON` varchar(128) DEFAULT NULL,
	`UTC` char(6) DEFAULT NULL,
	`DST` char(1) DEFAULT NULL,
	PRIMARY KEY (`NPA`,`NXX`,`BLOCK`),
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `lata`;
CREATE TABLE `lata` (
	`LATA` CHAR(5) NOT NULL,
	`STATE` CHAR(2) DEFAULT NULL,
	`COUNTRY` CHAR(2) DEFAULT NULL,
	`LOCATION` VARCHAR(128) DEFAULT NULL,
	PRIMARY KEY (`LATA`)
) 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,
	`Pop2010` INT(11) DEFAULT NULL,
	PRIMARY KEY (`CountyCode`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `cbsa`;
CREATE TABLE `cbsa` (
	`CBSA` CHAR(5) NOT NULL,
	`CSA` CHAR(3) DEFAULT NULL,
	`AREA_NAME` VARCHAR(128) DEFAULT NULL,
	`STATE` VARCHAR(20) DEFAULT NULL,
	`AREA_TYPE` VARCHAR(128) DEFAULT NULL,
	PRIMARY KEY (`CBSA`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `ocn`;
CREATE TABLE `ocn`(
	`OCN` `char`(4) NOT NULL,
	`TYPE` `varchar`(8) default NULL,
	`COMPANY` `varchar`(128) default NULL,
	`DBA` `varchar`(128) default NULL,
	`CommonName` VARCHAR(128) DEFAULT NULL,
	PRIMARY KEY  (`OCN`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;