Produced: on or before 5th calendar day monthly
Current Release: March 2, 2023
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
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.
| Field | Data Type | Field Description |
|---|---|---|
| NPA | CHAR (3) | Numbering Plan Area code, the first three digits of a 10 digit North American Numbering Plan (NANP) number, commonly called the Area Code. |
| NXX | CHAR (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. |
| BLOCK | CHAR (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_FROM | CHAR (4) | The 4-digit number identifying the starting value of line numbers served by the particular 1,000 or 10,000 numbering block. |
| LINE_TO | CHAR (4) | The 4-digit number identifying the ending value of line numbers served by the particular 1,000 or 10,000 numbering block. |
| LTYPE | CHAR (1) | Identifies whether the primary use of the NPA NXX is wireless or landline based on its initial assignment. |
| LATA | CHAR (5) | Local Access and Transport Area (LATA), or LATA-like code of the Rate Center. |
| OCN | CHAR (4) | 4-character Operating Company Number (OCN) also known as a NECA Company Code, identifying the NPA NXX code-holder or block-holder. |
| RATECENTER | VARCHAR (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. |
| CITY | VARCHAR (128) | Name of city, town, or locale within the Rate Center. There may be multiple cities within a given Rate Center. |
| FIPS | CHAR (5) | United States FIPS county code or Canadian Census Division code. |
| STATE | CHAR (2) | State or province postal abbreviation of the Rate Center locale. |
| COUNTRY | CHAR (2) | ISO 3166-1 Country Code of the Rate Center locale. |
| CBSA | CHAR (5) | United States Core Based Statistical Area (CBSA) or Canadian Census Metropolitan Area (CMA) code. |
| OLSON | VARCHAR (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. |
| UTC | CHAR (6) | Coordinated Universal Time (UTC) offset for the Rate Center geographic location. Format is +\-HH:MM. |
| DST | CHAR (1) | Specifies whether daylight savings time is recognized. |
| Field | Data Type | Field Description |
|---|---|---|
| CountyCode | CHAR (5) | Five-digit U.S. FIPS county code or four-digit Statistics Canada Census Division code. |
| Country | CHAR (2) | Two character country abbreviation |
| State | CHAR (2) | Two character state, province, or territory abbreviation |
| Name | VARCHAR (128) | Name of the county or division |
| Type | VARCHAR (80) | Organizational recognition of the county or division |
| LandArea | NUMBER | County or Census Division land area in square miles |
| Pop2010 | NUMBER | U.S. Census Bureau, Population Division or Statistics Canada reported 2010 population |
| Field | Data Type | Field Description |
|---|---|---|
| LATA | NUMBER (5) | The Local Access Transport Area code. |
| STATE | CHAR (2) | Two character state, province, or territory abbreviation of the NPA/NXX Service Center location. |
| COUNTRY | CHAR (2) | This two character field is the ISO 3166 Country Code for LATA location |
| LOCATION | VARCHAR (64) | Generalized name defining the LATA location |
| Field | Data Type | Field Description |
|---|---|---|
| OCN | CHAR (4) | 4-character state or regional Operating Company Number (OCN) also known as a NECA Company Code. |
| TYPE | VARCHAR (8) | Type of carrier or service provider |
| COMPANY | VARCHAR (128) | The legal or generally formal name of the service provider. |
| DBA | VARCHAR (128) | The commonly recognized business name of the service provider. |
| CommonName | VARCHAR (128) | The common consumer recognized trade name of the service provider. |
| Field | Data Type | Field Description |
|---|---|---|
| CBSA | CHAR (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). |
| CSA | CHAR (3) | Three-digit Combined Statistical Area code if the CBSA is part of a larger statistical area. |
| AREA_NAME | VARCHAR (64) | Official name of the statistical area. |
| STATE | VARCHAR (20) | Abbreviated state code(s) for the statistical area. |
| AREA_TYPE | VARCHAR (64) | Metropolitan or Micropolitan statistical area. |