NALENND™

The Standard Edition is a basic telephone Area Code and Exchange database. It contains all active NPA NXX listings for the United States, Canada, and most of the Caribbean. Telephone exchange details are at the 10,000-block level.

The coverage area for an exchange is identified by its Rate Center name. A Rate Center may be a town, city, or geographic area. The line type for an NPA NXX is the original LERG™ assignee's or CO code holder's reported use.

NPA NXX Standard Edition Database Fields

NPA NXX master file		NPA NXX data samples
Field Name	Data Type	Description
NPA	NUMBER (3)	Three-digit Numbering Plan Area code.
NXX	NUMBER (3)	Three-digit Central Office Code (COC), i.e. telephone exchange number.
LTYPE	CHAR (1)	Single character alphanumeric value identifying the basic line type of the NPA NXX.
STATE	CHAR (2)	Two-character state or province abbreviation of the exchange's rate center location. These are standard postal abbreviations which differ from the same COMMON LANGUAGE® assignments.
COUNTRY	CHAR (2)	Two-character ISO 3166-1 Country Code of the exchange's rate center country location.
RC	VARCHAR (255)	Name of rate center (city, town, or location) serving the exchange.
ZIP	MEMO	United States - contains the first five-digit ZIP code found for the exchange locality within the rate center. This field is not intended to provide comprehensive ZIP to NPA NXX cross-reference. Canada - contains all Forward Sortation Area codes for the exchange within the rate center. This is a comprehensive list of FSA codes for the exchange and can be large for certain locations. Multiple values within this field are semi-colon separated.
FIPS	NUMBER (5)	Five-digit United States Federal Information Processing System (FIPS) County Code identifying the county (or primary county) the exchange's rate center is located in. This value is the concatenation of the two-digit FIPS state code and the three-digit county code.
County data file		FIPS code data samples
Field Name	Data Type	Description
FIPS	CHAR (5)	Five-digit Federal Information Processing System (FIPS) county code. This field is actually the concatenation of the two digit FIPS state code and the three-digit FIPS county code.
COUNTY	VARCHAR (32)	County or entity name
STATE	CHAR (2)	Two character state or territory abbreviation
COUNTY_TYPE	CHAR (1)	Single character county type code
COUNTY_SEAT	VARCHAR (32)	Name of county government center
NAME_TYPE	CHAR (1)	County or entity type described by county name

Workstation License
Current Release
$69.95 USD

Standard License
1-year subscription with quarterly updates
$799.95 USD

Distribution License
1-year subscription with quarterly updates
$1499.95 USD