North American Telephone Area Code, Exchange and Prefix Location Database, Premium Edition
Workstation License
Price: $99.95 USD
Corporate License *
Price: $879.95 USD
Distribution License *
Price: $1,639.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

Complete 10,000 block level NPA/NXX assignments for every active telephone NPA/NXX area code and exchange combination in use for the United States, Canada and most of the Caribbean.

The data includes place names with geographic latitude and longitude to identify and locate the basic exchange area served by the NPA/NXX. These coordinates may be used for general positioning and distance calculations between exchanges but should not be confused with the exchange's more exact wire and rate center V&H coordinates.

Additional NPA-NXX related data includes: NXX type (wireless, landline, pager, etc.), Local Access and Transport Area (LATA) assignments, Numbering Plan Area (NPA) assignments with area code overlay/split cross reference, United States demographic metropolitan statistical area associations.

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

  • Local Access and Transport Area LATA - contains LATA number to name cross-references.
  • United States FIPS county cross-reference - contains FIPS state and county number, county name and type, and county seat.
  • Core Based Statistical Area CBSA - contains CBSA code, Combined Statistical Area CSA code, CBSA name-location, and statistical area type.
  • United States Metropolitan Statistical Area cross-reference - contains MSA code, type, name-location, CMSA, and year 2000 population.

There are approximately 143,580 records in this database. Internet download size of this product is approximately 1.32MB as a zip format compressed file and will require approximately 13MB 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, Premium Edition Record Layout
FieldField Description
NPAThree-digit Numbering Plan Area code.
NXXThree-digit Central Office Code (COC), i.e. telephone exchange number.
LATAThree-digit number that represents the geographical Local Access and Transport Area (LATA) for the NPA NXX. This value is the LATA associated with the exchange's rate center and represents the predefined boundary for local toll calls.

See cross-reference data file lata.csv (provided).
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.
STATE 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. 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.
FIPS 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.

See cross-reference data file county.csv (provided).
United States exchanges only.
CBSA Five-digit Core Based Statistical Area Code of the Metropolitan or Micropolitan Statistical Area the exchange's rate center is located in. This field may contain multiple CBSA codes for a particular rate center. When multiple codes are present they are semi-colon separated. CBSA codes are defined by the Office of Management and Budget and supersede previous MSA codes and definitions.

See cross-reference data file cbsa.csv (provided).
United States exchanges only.
MSA Four-digit code of the Metropolitan Statistical Area (MSA) the rate center is located in if any. This field is maintained for cross-reference. MSA codes have been replaced with the five-digit CBSA code.

See cross-reference data file msa.csv (provided).
United States exchanges only.
PMSAFour-digit code of the Primary Metropolitan Statistical Area (PMSA) the rate center is located in if any. If a PMSA code is present then the MSA code is recognized as a Consolidated Metropolitan Statistical Area (CMSA) code. This field is maintained for cross-reference. MSA codes have been replaced with the five-digit CBSA code.

See cross-reference data file msa.csv (provided).
United States exchanges only.
LATITUDELatitude in decimal degrees of the general exchange location.
LONGITUDELongitude in decimal degrees of the general exchange location.
DERIVED_FROM_NPAIndicates the previous NPA that existed in the area covered by a given NPA. In cases of overlays, some or all of the previous NPAs may still cover the area. The OVERLAY field should be referenced to determine how to interpret this field.
  • Splits - this field specifies the original NPA that this NPA was created from via a geographic split.
  • Overlays - this field specifies the original NPA that this NPA now overlays.
  • If this field is empty or specifies the current NPA then the current NPA is the original or parent NPA.
NEWNPASpecifies the new area code to be used with the NXX or new area code(s) created in the same coverage area as the current area code. The OVERLAY field should be referenced to determine how to interpret this field.
  • Splits - if not empty or the value specified is different than the current NPA then this field specifies the new area code that should be used with the current NXX.
  • Overlay - if present, specifies one or more semi-colon separated area codes that occupy the same coverage area as the current NPA. The area code for the current NXX remains the same.
OVERLAYSingle character field to determine how the DERIVED_FROM_NPA and NEWNPA fields should be interpreted.
  • O - the NPA is overlaid by one or more NPAS or this NPA overlays one or more NPAS. The DERIVED_FROM_NPA field may be used to determine the overlay direction.
  • P - the NPA is involved in a DERIVED_FROM_NPA split and the exchange is being moved from the NEWNPA parent. If the NEWNPA field is empty, the exchange is remaining in the current NPA and is protected from re-assignment during the split.
  • S - the NPA is being split and the exchange is moving from the current NPA to the NEWNPA
  • empty - if DERIVED_FROM_NPA is not empty then NPA was created from a geographic split of DERIVED_FROM_NPA.
top