North American Telephone Area Code, Exchange and Prefix Location Database, Standard Edition
Workstation License
Price: $69.95 USD
Corporate License *
Price: $799.95 USD
Distribution License *
Price: $1,499.95 USD
* Includes quarterly updates for one year
Platform: All Platforms
License: Overview, which license do you need?
Media: Internet download
Format:  Zip compressed CSV data file
Updated: July 2, 2010

Basic NPA/NXX data ... our most economical North American telephone data product. This data includes every active telephone NPA/NXX area code and exchange combination in use for the United States, Canada and most of the Caribbean.

Data includes 10,000 block level NPA/NXX assignments, the exchange general service area or location name, and basic line type identification.

Supplemental cross-reference data files included with this product...

  • United States FIPS county cross-reference - contains FIPS state and county number, county name and type, and county seat.

There are approximately 143,580 records in this database. Each record contains the data fields described below.

Internet download size of this product is approximately 1.0MB as a zip format compressed file and will require approximately 7MB free space on your hard drive when decompressed.

Questions about NPA NXX dataFrequently Asked Questions about our NPA/NXX data
Sample NPA NXX dataSample data. (Displayed in a Javascript popup window).

 Get Acrobat Reader PDF Formatted Document Read the manual...

North American Telephone Area Code and Prefix Location NPA/NXX Data, Standard Edition Record Layout
FieldField Description
NPAThree-digit Numbering Plan Area code.
NXXThree-digit Central Office Code (COC), i.e. telephone exchange number.
LTYPESingle character alphanumeric value identifying the basic line type of the NPA NXX.
  • S - Wireline, non-wireless service including POTS, Broadband etc.
  • C - Wireless type service including PCS, Cellular, GSM, etc.
  • P - Paging and other Messaging services.
  • M - Multiple carriers are associated with the NPA NXX at either the 10,000-block or 1,000-block levels and type of service could not be determined.
STATETwo-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. The exceptions are as follows with the COMMON LANGUAGE® values parenthesized next to the location name.
  • AS - American Somoa (AM)
  • MP - Northern Mariana Islands (NN)
  • NL - Newfoundland Labrador (NF)
  • QC - Quebec (PQ)
  • NU - Nunavut Territory (VU)
COUNTRYTwo-character ISO 3166-1 Country Code of the exchange's rate center country location. Note telecommunications industry specific databases normally use abbreviations based on COMMON LANGUAGE® assignments. The COMMON LANGUAGE® country codes are those parenthesized values next to the country name.
  • US - United States (US)
  • CA - Canada (CA)
  • BS - Bahamas (BA)
  • BB - Barbados (BD)
  • AI - Anguilla (AI)
  • AG - Antigua and Barbuda (AN)
  • VG - Virgin Islands, British (BV)
  • KY - Cayman Islands (CQ)
  • BM - Bermuda (BM)
  • GD - Grenada (GN)
  • TC - Turks and Caicos Islands (TC)
  • MS - Montserrat (RT)
  • LC - Saint Lucia (SA)
  • DM - Dominica (DM)
  • VC - Saint Vincent and the Grenadines (ZF)
  • DO - Dominican Republic (DR)
  • TT - Trinidad and Tobago (tr)
  • KN - Saint Kitts and Nevis (KA)
  • JM - Jamaica (JM)
RCName of rate center (city, town, or location) serving the exchange.
ZIP
  • 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.
FIPSFive-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.

See cross-reference data file county.csv (provided).
United States exchanges only.
top