The NALENND® NPA NXX to Zip Code Database provides the coverage required to identify which telephone area codes and exchanges are used in a particular Zip Code as well as what Zip Codes are in use within a particular telephone area code and exchange.
This mapping is based on the geography of the NPA NXX Rate Center and the ZIP Code boundaries which yields a true representation of the coverage areas.
Produced: on or before 5th calendar day monthly
Current Release: November 3, 2024
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
NALENND® NPA NXX to Zip Code Standard Edition Reference Manual
NALENND® NPA NXX to Zip Code Standard EditionSample Data
NPA NXX to ZIP Codes File
| Field | Data Type | Field Description |
|---|---|---|
| NPA | CHAR (3) | The 3-Digit area code. |
| NXX | CHAR (3) | The 3-digit exchange prefix. |
| ZIP | CHAR (5) | 5-Digit United States ZIP Code. |
| STATE | CHAR (2) | Two character state abbreviation. |
| CITY | VARCHAR (128) | Name of city or locale identified by the 5-digit Zip code. |
| RC | CHAR (10) | 10-character Rate Center abbreviated name identifying local service area where the NPA NXX is assigned. |
SQL Table Definitions
CREATE DATABASE if not exists `nalennd`;
USE `nalennd`;
DROP TABLE IF EXISTS `npanxx2zip`;
CREATE TABLE `npanxx2zip`
(
`NPA` CHAR(3) NOT NULL,
`NXX` CHAR(3) NOT NULL,
`ZIP` CHAR(5) NOT NULL,
`STATE` CHAR(2) NOT NULL,
`CITY` VARCHAR(128) NOT NULL,
`RC` VARCHAR(128) NOT NULL,
PRIMARY KEY (`NPA`,`NXX`,`ZIP`)
)
ENGINE=MYISAM DEFAULT CHARSET=utf8;