dbWriter Home
IP to Country Look up
Site Map

IP to Country DB

Free Databases:

ASP Code

ASP Links

VB Script functions:
Array
Case/Select
In String (inStr)
Replace

HTML code:
SELECT Color
SELECT Countries
SELECT Language
SELECT State/Province

SQL:

SQL Functions:
Delete leading Char
Get Browser
Long number from IP

Stored Procedures:

SQL Tricks:
Delete ALL duplicates
Delete dup records

MISC
IP Address Owner
MS SQL Server

Mortgage Calcs:
how much is my payment
Loan Amortization
Loan Calculator
Mortgage Calculator
Motrgage Pay Off

dbWriter License

Link to US

Links

Contact US
 

Free area code access database by NANPA: North American Numbering Plan Administration.

The area served by the NANP is divided into smaller Numbering Plan Areas (NPAs), each identified by a three-digit NPA code, commonly called an area code.

For quick information about a specific area code, use the area code search. You can also find the area code for a city or town with population greater than 20,000. The site also provides area code maps.

NANPA provides a variety of NPA Reports. These reports include identification of geographic area codes (i.e., area codes that designate specific geographic areas) and non-geographic area codes (i.e., designate specific services such as "toll-free"). In addition, there is a report that identifies those planned area codes not yet in service. It lists anticipated in-service dates if they are known. The "status" column provides additional information. A status of "suspended" indicates that the state public utility commission has suspended introduction of the new area code.

To download a MS Access  area code database 

sample data with only the first 13 fields

 
NPA Type of Code Assignable Explanation Reserved Assigned? Asgt Date Use Service Location Country In Service? In Svc Date
200 Easily Recognizable Code Yes
 
No No
 
N
 

 

 
No
 
201 General Purpose Code Yes
 
No Yes 1/1/1947 G
 
NJ US Yes 1/1/1947
202 General Purpose Code Yes
 
No Yes 1/1/1947 G
 
DC US Yes 1/1/1947
203 General Purpose Code Yes
 
No Yes 1/1/1947 G
 
CT US Yes 1/1/1947
204 General Purpose Code Yes
 
No Yes 1/1/1947 G
 
Manitoba CANADA Yes 1/1/1947
205 General Purpose Code Yes
 
No Yes 1/1/1947 G
 
AL US Yes 1/1/1947
206 General Purpose Code Yes
 
No Yes 1/1/1947 G
 
WA US Yes 1/1/1947
207 General Purpose Code Yes
 
No Yes 1/1/1947 G
 
ME US Yes 1/1/1947
208 General Purpose Code Yes
 
No Yes 1/1/1947 G
 
ID US Yes 1/1/1947
209 General Purpose Code Yes
 
No Yes
 
G
 
CA US Yes 1/1/1958
210 General Purpose Code Yes
 
No Yes
 
G
 
TX US Yes 11/1/1992
211 Easily Recognizable Code No N11 Code No No
 

 

 

 

 
No
 
212 General Purpose Code Yes
 
No Yes 1/1/1947 G
 
NY US Yes 1/1/1947
213 General Purpose Code Yes
 
No Yes
 
G
 
CA US Yes 1/1/1947
214 General Purpose Code Yes
 
No Yes 1/1/1947 G
 
TX US Yes 1/1/1947
Partners/Links © 2005 - 2008 dbWriter.com All Rights Reserved
This site is protected by the dbWriter IPtoCountry MS/SQL database!!
Site map | Link to US
Contact Us

Sign up for PayPal and start accepting credit card payments instantly.