|
Overview - AreaCodeWorld Area Code NPA NXX Gold Edition
|
 |
| |
Product Summary: AreaCodeWorld Gold 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, ZIP code, Operating Company Number, use type, rate center, COMMON LANGUAGE® identifier and V&H.
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 | $399.95 | $799.95 |
| Sale Price | $299.95 | $599.95 |
| Order Now | 
 | 
 |
| Latest Edition | October-December 2009 |
| Free Demo | |
| 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.
|
|
|
Order
| AreaCodeWorld Package |
Price (US$) |
Order Now |
| AreaCodeWorld Gold Edition - 1-Month Subcription |
$299.95 |
 |
| AreaCodeWorld Gold Edition - 1-Year Subscription w/ Quarterly Update |
$599.95 |
 |
|
Download (Subscription Required)
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. |
| 21 |
NXX_USE_TYPE |
char(1) |
Primary use designation. |
| 22 |
NXX_INTRO_VERSION |
nchar(10) |
Version of this product that NXX first appeared. |
| 23 |
OVERLAY |
nchar(1) |
Overlay. |
| 24 |
OCN |
char(4) |
Telephone Operating Company Number. |
| 25 |
COMPANY |
char(30) |
Name of the telephone company. |
| 26 |
RATE_CENTER |
char(10) |
Rate Center name. |
| 27 |
SWITCH_CLLI |
char(11) |
COMMON LANGUAGE® identifier. |
| 28 |
RC_VERTICAL |
nchar(5) |
V&H Coordinate system vertical coordinate. |
| 29 |
RC_HORIZONTAL |
nchar(5) |
V&H Coordinate system horizontal coordinate. |
ii. Required Disk Space
| Format |
Size |
| Microsoft® Access |
157.6 MB |
| Microsoft® Excel |
123.6 MB |
| Comma-delimited ASCII |
91.4 MB |
iii. References
|
Copyright © 2001-2010. Hexa Software Development Center. All Rights Reserved. |
|