[Asterisk-Users] Billing Fun - anybody know where to get aNPA/NXX db?

Scott Lykens slykens at gmail.com
Thu Sep 23 19:32:20 MST 2004


The NANPA maintains this database and the full database is available
in 8 files. I have imported this into a MySQL table and can query
based on rate center and npa-nxx.

I use wget -a using a file containing the following:

http://www.nanpa.com/nanp1/cnutlzd.zip
http://www.nanpa.com/nanp1/csutlzd.zip
http://www.nanpa.com/nanp1/eautlzd.zip
http://www.nanpa.com/nanp1/enutlzd.zip
http://www.nanpa.com/nanp1/esutlzd.zip
http://www.nanpa.com/nanp1/wnutlzd.zip
http://www.nanpa.com/nanp1/wputlzd.zip
http://www.nanpa.com/nanp1/wsutlzd.zip

Then I have a perl script that reads each file in and puts them into a
MySQL table.

I hope this helps with that you are looking for.

sl



More information about the asterisk-users mailing list