I wanted to update the geocode information because someone (can't remember who) said that the info was out of date. So I poke around and stumble across the motherload. These guys are the real deal source for this kind of information. So, naturally, I download it all and start hacking.
I built an extended NPA-NXX database and updated my NPA page. I just realized that the UI changes from the previous version broke the command line client so I fixed that too. The older command line clients will need to be updated... actually, I could fix that, but I suppose it's no big deal for everyone to grab the new script since it has added functionality anyway.
So, if you check out my NPA page you'll notice the NXX box. If you only enter the NPA it uses the same database as before. If you enter NPA and NXX you'll get all kinds of neat info that you didn't get before (phreaks will recognize it, it's all magic to me).
For example I tried a random NPA-NXX (702-543). Apparently it's in Nevada. The script returns the following:
NPA-NXX: 702-543 State: NV UseCode: AS OCN: 2817 Company: PAC - WEST TELECOMM, INC. - NV RC: LAUGHLIN Switch: LSVKNV97DS0 IG: I
As before all the information is available for download. I converted their MDB to a MySQL friendly schema and table info (in one file), modified all the scripts and posted the source, and that's that.
Lemme know if anyone finds it useful (or anyone finds bugs of course). Oh, I'll update the use codes tomorrow so they're human readable.