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: November 3, 2024
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
NALENND® NPA NXX to Zip Code UTC Edition Reference Manual
NALENND® NPA NXX to Zip Code UTC Edition Sample 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. |
| UTC | CHAR (6) | The standard time Coordinated Universal Time (UTC) offset at this location. Format is +\-HH:MM. |
| DST | CHAR (1) | Single character Y/N value indicating whether daylight saving time is observed at this location. |
SQL Table Definitions
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;