North American Telephone NPA NXX Area Code and Prefix Location

Overview - AreaCodeWorld™ Area Code NPA NXX Premium Edition

Product Summary: AreaCodeWorld™ Premium Edition - Complete telecommunications database targeted specifically toward disseminating all valid NPA/NXX combinations in the North American Numbering Plan. It covers all active North American NPA/NXX assignments including the United States and Canada. Included in this database is NPA (area code), NXX (exchange), country, state, county, latitude, longitude, LATA, timezone, day light saving, population, FIPS, MSA, PMSA, CBSA and ZIP code.

Sample database and full database are available to download separately. Order your AreaCodeWorld™ database today. Your computer-generated account will be delivered to your email address immediately once the order has been approved. Redistribution license is also available for developers to distribute the database together with their software.

All products are available for the Internet download only. This allows us to keep the lowest prices and pass the savings along to you.

Subscription Period One Month One Year

List Price ~~$199.95~~ ~~$399.95~~

Sale Price $149.95 $299.95

Order Now

Latest Edition October-December 2009

Free Demo
Area Code () -XXXX

View Sample Database [ View ] Comma-delimited ASCII

Download Sample Database [ Download ] ASCII Text, Microsoft® Excel and Microsoft® Access samples in a ZIP file

Database Specification [ Download ] ZIP Codes Database Columns Definition

Database Comparison [ View ]

You can request for a comprehensive sample database for evaluation purpose. Please fill up the form below to receive the sample via email.

Email:

Name:

Order

AreaCodeWorld™ Package	Price (US$)	Order Now
AreaCodeWorld™ Premium Edition - 1-Month Subcription	$149.95
AreaCodeWorld™ Premium Edition - 1-Year Subscription w/ Quarterly Update	$299.95

Download (Subscription Required)

Format	Extension	Download Size	Download (Complete)	Download (Sample)
Microsoft® Access	MDB	10.1 MB	[ Download ]	[ Download ]
Microsoft® Excel	XLS	12.6 MB	[ Download ]
Comma-delimited ASCII	CSV	3.67 MB	[ Download ]

Product Features & Benefits

Low Price - Get More Value, Pay Less
30-Day Money Back Guarantee - No Risk, Satisfaction Guarantee
Monthly Update - 100% Accurate Data
Free Customer Service - Good After Sales Service
Single Download and Subscription Available - Pay Only What You Need
Corporate Site License - Free Distribution Within An Organization
Available in Different Formats - Save Conversion Time
Thousands of Happy Customers - 3M Company, Apple Computer, AT&T, BASF, Deloitte & Touche, Department of Justice, FedEx, IBM, Microsoft, Nortel Networks, Procter & Gamble, Samsung, Walmart, Well Fargo and many more.

Technical Specification

i. Database Fields

Field#	Field Name	Data Type	Field Description
1	NPA	nchar(3)	Three-digit North American Numbering Plan Area Code.
2	NXX	nchar(3)	Three digit local telephone number exchange.
3	COUNTRY	char(2)	Two character ISO 3166-1 country code.
4	STATE	char(2)	Two letter USPS state abbreviation.
5	CITY	vchar(35)	Name of city.
6	COUNTY	vchar(25)	Name of county.
7	LATITUDE	numeric	Latitude of city.
8	LONGITUDE	numeric	Longitude of city.
9	LATA	nchar(3)	Local Access Transport Area.
10	TIMEZONE	nchar(1)	Offset from GMT.
11	OBSERVES_DST	nchar(1)	Daylight Saving Time.
12	COUNTY_POPULATION	nchar(8)	Estimation of county population.
13	FIPS_COUNTY_CODE	nchar(5)	Federal Information Processing System (FIPS) county code.
14	MSA_COUNTY_CODE	numeric	Metropolitan Statistical Area.
15	PMSA_COUNTY_CODE	numeric	Primary Metropolitan Statistical Area.
16	CBSA_COUNTY_CODE	numeric	Core Based Statistical Area.
17	ZIPCODE_POSTALCODE	nchar(7)	ZIP code or postal code.
18	ZIPCODE_COUNT	nchar(3)	Approximate ZIP code occurrences.
19	ZIPCODE_FREQUENCY	nchar(4)	Percent frequency of ZIP code occurrence.
20	NEW_NPA	nchar(3)	New area code.