As you probably know, the federal agency NANPA (North American
Numbering Plan Administration) metes out area codes for the United
States and keeps track of all routing information regarding area
codes, dialing prefixes, etc.
They provide their information to a company known as Telecordia who
aggregates the information and markets it to customers who need
up-to-date details regarding NANPA's activities, including information
on area codes (NPAs), dialing prefixes, localities, and even time
associated time zones.)
[more info: http://www.trainfo.com/]
One such Telecordia report, known as the LERG Report (Local Exchange
Routing Guide) provides many details in an Access database format
about each locality including (but definitely not limited to) the area
codes used and the requirement of 7-digit or 10-digit dialing.
[more info:http://www.trainfo.com/products_services/tra/catalog_details.html#Telcordia%20LERG%20Routing%20Guide]
From the above link, scroll below the detail text and click "Sample
Available". Download this file and open it. It is a "self-expanding"
compressed file (meaning it's compressed many files together into one
to save space and to make it easier to transfer.) When you open it,
it will provide you with several files, one of which is another
self-extracting EXE file. Open that file and it will produce twenty
or so more files.
Double-click the "LERGDATA.MDB" file (you must have Access installed).
If it gives you any warning messages, this is because you are running
Access 2000, and it was saved in an Access 97 format. Just choose to
"open" the file instead of "converting" it.
Once opened, double-click on the table called "LERG6".
In the column marked "LOC NAME" (column 15), you'll see listed the
locality name. Two columns to the right (column 17, "LOC STATE") is
the state name for each entry. The column marked "NPA" (column 5) is
the area code for each locality, and the column marked "TD-EO" (column
10) provides the 7/10-digit dialing designation (7 =
"7-digit-dialing", 10 = "10-digit-dialing".) According to a
Telecordia rep, make sure you look in the TD-EO column, not the TD-AT
column.
Prices for the entire database (not just this sample) are somewhat
steep, and vary depending on your purpose for the data (your industry,
etc.) and the range for the prices is as follows:
monthly: $13500 - $270000 a year
quarterly: $4000 - $80000 a year
Now, it's possible that if you need this for educational or
economic-study reasons, etc., they may be able to provide you with the
information cheaper. Additionally, you may want to check with them to
see if you could get just a subset of the database (e.g. the four or
five columns you need) for a smaller price.
If you would like to contact them about ordering or have any
questions, their contact information is available at:
[http://www.trainfo.com/products_services/tra/contact.html]
They can be reached by phone or by email. I talked to one of their
reps by phone, and she was very helpful.
I hope this works out for you!
--Joey |
