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. Additionally this version of the data identifies the standard time zone in Coordinated Universal Time (UTC) format and whether or not daylight savings time is recognized in the coverage area.
Produced: on or before 5th calendar day monthly
Current Release: December 3, 2023
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.|
|UTC||CHAR (6)||Standard Coordinated Universal Time (UTC) time zone offset for this location. Formatted +/-HH:MM|
|DST||CHAR (1)||Y / N field indicating whether Daylight Savings Time is recognized at this location.|
CREATE DATABASE if not exists `nalennd`; USE `nalennd`; DROP TABLE IF EXISTS `npanxx2ziputc`; CREATE TABLE `npanxx2ziputc` ( `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` CHAR(10) NOT NULL, `UTC` CHAR(6) NOT NULL, `DST` CHAR(1) NOT NULL, PRIMARY KEY (`NPA`,`NXX`,`ZIP`) ) ENGINE=MYISAM DEFAULT CHARSET=utf8;