NALENND™
NPA NXX to Zip Code Database - Standard Edition

NALENND NPA NXX Database 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: June 3, 2017
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download


NPA NXX to ZIP Codes File

FieldData TypeField Description
NPACHAR (3)The 3-Digit area code.
NXXCHAR (3)The 3-digit exchange prefix.
ZIPCHAR (5)5-Digit United States ZIP Code.
STATECHAR (2)Two character state abbreviation.
CITYVARCHAR (128)Name of city or locale identified by the 5-digit Zip code.
RCCHAR (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;