Does anyone have the NPA NXX list for North America in comma delimited file? Only looking for: NPA, NXX, City, State Just seems it should be available free somewhere? Then comes the next step, the setting callerid name based on the NPANXX to city, state -Mark -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 3/25/2005
Here is the tab delimited you can import this into excel than export it as coma. http://www.areacode-info.com/COC/codedownload.htm ----- Original Message ----- From: "Mark Halverson" <mark@opbx.com> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" <asterisk-users@lists.digium.com> Sent: Sunday, March 27, 2005 2:14 AM Subject: [Asterisk-Users] NPA NXX Does anyone have the NPA NXX list for North America in comma delimited file? Only looking for: NPA, NXX, City, State Just seems it should be available free somewhere? Then comes the next step, the setting callerid name based on the NPANXX to city, state -Mark -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 3/25/2005 _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Actually they have excel formatted files already and access database on that site. Henry ----- Original Message ----- From: "Mark Halverson" <mark@opbx.com> To: "'Asterisk Users Mailing List - Non-Commercial Discussion'" <asterisk-users@lists.digium.com> Sent: Sunday, March 27, 2005 2:14 AM Subject: [Asterisk-Users] NPA NXX Does anyone have the NPA NXX list for North America in comma delimited file? Only looking for: NPA, NXX, City, State Just seems it should be available free somewhere? Then comes the next step, the setting callerid name based on the NPANXX to city, state -Mark -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 3/25/2005 _______________________________________________ Asterisk-Users mailing list Asterisk-Users@lists.digium.com http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
I'm already doing the cid-lookup usnig telcodata.us -- http://muware.com/asterisk> -----Original Message----- > From: Mark Halverson [mailto:mark@opbx.com] > Sent: Sunday, March 27, 2005 2:14 AM > To: 'Asterisk Users Mailing List - Non-Commercial Discussion' > Subject: [Asterisk-Users] NPA NXX > > > Does anyone have the NPA NXX list for North America in comma > delimited file? > > Only looking for: > > NPA, NXX, City, State > > Just seems it should be available free somewhere. > > Then comes the next step, the setting callerid name based on > the NPANXX to city, state > > -Mark > > -- > No virus found in this outgoing message. > Checked by AVG Anti-Virus. > Version: 7.0.308 / Virus Database: 266.8.3 - Release Date: 3/25/2005 > > > _______________________________________________ > Asterisk-Users mailing list > Asterisk-Users@lists.digium.com > http://lists.digium.com/mailman/listinfo/asterisk-users > To > UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > > >
Everything you need is on the North American Numbering Planing. http://www.nanpa.com/ Mark Halverson wrote:>Does anyone have the NPA NXX list for North America in comma delimited file? > >Only looking for: > >NPA, NXX, City, State > >Just seems it should be available free somewhere? > >Then comes the next step, the setting callerid name based on the NPANXX to >city, state > >-Mark > > >
> > Does anyone have the NPA NXX list for North America in > comma delimited > > file? > > > > Only looking for: > > > > NPA, NXX, City, State > > > > Just seems it should be available free somewhere. > > > > Then comes the next step, the setting callerid name based on the > > NPANXX to city, state > > > > -Mark > >NPA-NXX does not correspond to a city/state. NPA-NXX correspond to switches in central offices, known by CLLI codes. You might find what your are looking for if you search for a CLLI code listing, the listing should have the location (city state) of the the switch and the NPA-NXX's it serves. Be aware thought, that with local number poratability the NPA NXX can actually point to any switch in the LATA and beyond with cellular and VoIP.
> Everything you need is on the North American Numbering Planing. > > http://www.nanpa.com/ >Can you get a csv npa-nxx file from there? If not you can get it here; http://www.telcodata.us/telcodata/downloads $5.00/mo fee, regualarly updated data The file that contains npa-nxx by clli is clli-npa-nxx The clli to city/state cross reference is first6-city.csv Link the two by clli in a database and you will have the location of the CO that servers each npa-nxx Again, LNP messes this up, the NPA NXX could actually be anywhere in the LATA.