The NALENND™ NPA NXX to Zip Code Database provides the coverage required to determine what 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: March 4, 2018
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
|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.|
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;