NPA NXX Database - Standard Edition

The Standard Edition is our basic NPA NXX data package 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.

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 four 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