United States NPA NXX to ZIP Codes Cross-Reference Database - FIPS Edition

Corporate License

Single Release - no updates
$54995

Annual subscription - quarterly updates
$78995

Annual subscription - monthly updates
$1,79995

Distribution License

Annual subscription - quarterly updates
$118995

Annual subscription - monthly updates
$2,19995

FIPS Edition

Produced: on or before 5th calendar day monthly
Current Release: October 3, 2020
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download

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 both the FIPS county and place codes which may be used as an aid in determining certain types of local jurisdictions.

NPA NXX numbering resources are assigned by Rate Centers. Rate Centers are the regulated geographic service areas that telecom carriers provide service to and because their boundaries are relatively stable it is possible to compare them to USPS postal carrier routes to determine what NPA NXX combinations are used in specific Zip Codes.


NPA NXX to ZIP Code Cross-reference
FieldData TypeField Description
NPACHAR (3)Numbering Plan Area (NPA) Code. An NPA, also known as a telephone area code, is the first three digits of a 10-digit North American Numbering Plan (NANP) telephone number in the form NXX-NXX-XXXX, where N represents any one of the numbers 2 through 9 and X represents any one of the numbers 0 through 9. Valid numeric range for NPA codes is 200 through 999.
NXXCHAR (3)Central Office Code (COC). The COC, commonly called the telephone exchange or prefix, is the second three digits (NXX) of a 10-digit NANP telephone number in the form NXX-NXX-XXXX, where N represents any one of the numbers 2 through 9and X represents any one of the numbers 0 through 9. Valid numeric range for NXX codes is 200 through 999.
ZIPCHAR (5)5-digit United States ZIP Code.
STATECHAR (2)2-character United States Postal Service abbreviation for the state, or territory of the city and Rate Center location.
FIPSCOUNTYCHAR (5)5-digit code commonly referred to as the FIPS county code. The first two digits of this code are the unique 2-digit numeric code for a U.S. state as specified in Ansi INCITS 38:200x (formerly FIPS 5-2) followed by the 3-digit numeric code that uniquely identifies the county or equivalent division as specified in Ansi INCITS 31:200x (formerly FIPS 6-4).
FIPSPLACECHAR (5)5-digit code commonly referred to as the FIPS Place Code. Formerly the FIPS 55 Place Code, this code is being replaced by the newer Ansi INCITS 446-2008 feature code but continues to be used to uniquely identify locations within the United States.
CITYVARCHAR (128)United States Postal Service recognized name for the city or locale identified by the current ZIP code.
RCCHAR (10)10-character industry standard abbreviated name of the Rate Center (or service) where the NPA NXX is assigned.
MTAINTEGERThe Major Trading Area the Rate Center is located in. MTAs are used by the FCC to defined coverage of spectrum licenses for certain services.