provided by Star2Billing S.L.

All success here... Would be happy to help out with advice... I also have all the north America Area codes and prefixes with detail info about it and a complete database of over 100 million records listing all areas local to any given NPA or NNX (area code and prefix) in North America.

why not submit it to be included with the project? perhaps a csv file so one can import it to the ratecards?


KM

If you are looking only for all the NPA and NXX in north America to put them in your ratecard table cc_ratecard. I can do this for you by adding it directly into your database for around $50 however if you are looking for the additional info that comes with these area codes (NPA) and prefixes (NXX) that is $100. Total records for your rate cards without duplicates are around 156,730 NPA and NXX. To get the additional info for these NPA and NXX its around 400 thousand records.

The the local to local database giving all areas Local to any given NPA NXX in north America is around $5,000 on most sites selling it. When I first got these records it was over 4 GB of data with 110 million records. After changing data types to proper format in my data base and removing duplicate this was reduced to 2 GB and 91 million records. And after grouping NPA and NXX to like NPA and NXX that’s in or has the same local calling to the same areas this database is now under 12 MB. I am not interested in selling this data outright as I am more interested in trading it work in different areas such as coding , web design and the such. I will come off of it for $500 if someone was interested but had no expertise which I need.

First, this is the wrong topic for what you are talking about. And second, on the official Web site of the NANPA (North American Numbering Plan Administration), you can find and download for fee what prefixes and other informations about aread codes in North America. The site is
http://www.nanpa.com/area_codes/index.html

Also, many providers allows to freely download the Numberplan (dialprefixes) and A to Z rates in the same document (Usually Excel document)

Here is an example: http://www.voicetrading.com/en/rates.html

Asiby thanks for your response and your advice. I will try to keep things more on topic.
Hummm Interesting. I can’t seem to find anything even remotely the same as what I am offering that what is listed on those reference links you posted. I MUST not be doing something right. Can you be so kind as to tell me where to get the data in a similar format as I am posting below? Keep in mind I and many others need all the NXXes in north America with town and city names as well as state. The data I am offering for the cc_ratecard table has both rate center, state or city or town names so you can use that in your CDRs for customers who want to know what town they called to. If you don’t care about giving this to customers then only the NPA and NNX is fine. Below is the sample format what I am offering. If you find a place to get this data from for free and is reliable data please let me know. This will save me a lot of time and money from having to buy this data. Below is sample of data for the format to use in the cc_ratecard if you want to have professional CDR that customers are used to getting from their local LEC. Let me know if you can get this free.

I work a great deal with databases and data and know to properly set up the cc_ratecard for some its very difficult. One must keep in mind not to over look toll free numbers or other special numbers like directory assistance and other extra cost numbers. Many times data offered by whole sale providers is not complete nor do they have names for city or rate center and when they do many times you will find its not compiled right or even up-to-date.



dialprefix destination
1201200 Jersey City NJ
1201202 Hackensack NJ
1201203 Hackensack NJ
1201204 Jersey City NJ
1201206 Hackensack NJ
1201207 Newark NJ
1201208 Jersey City NJ
1201209 Jersey City NJ
1201210 Union City NJ
1201212 Leonia NJ
1201213 Morristown NJ
1201214 Hackensack NJ
1201215 Bayonne NJ
1201216 Jersey City NJ
1201217 Jersey City NJ
1201218 Hackensack NJ
1201219 Jersey City NJ
1201220 Hackensack NJ
1201221 Hackensack NJ
1201222 Jersey City NJ
1201223 Union City NJ
1201224 Cliffside NJ
1201225 Oradell NJ
1203201 New Haven CT
1203202 Darien CT
1203204 Guilford CT
1203205 Danbury CT
1203206 Waterbury CT
1203207 Danbury CT
1203208 Branford CT
1203209 Bridgeport CT
1203210 Wilton CT
1203213 Meriden CT
1203214 New Haven CT
1203215 New Haven CT
1203216 Westport CT
1203217 Waterbury CT
1203218 Bridgeport CT
1203219 Stamford CT
1203220 Trumbull CT

dialprefix destination
12015551212 Dir Assistant
12035551212 Dir Assistant
12055551212 Dir Assistant
12065551212 Dir Assistant
12125551212 Dir Assistant
12135551212 Dir Assistant
12145551212 Dir Assistant
12155551212 Dir Assistant
12165551212 Dir Assistant
12175551212 Dir Assistant
12185551212 Dir Assistant

Unfortunately, it won't give you any city name. The second link will be able to do this for you depending on what is supported by the provider. At the 1st link, there is a Microsoft Access Database that contents lots of informations about NANP number. Personally, I thing that 110 million records for just North America is an gynormous number. And if you add the rest of the world, if will be a database that will eat up lots of server resources. Almost worth putting up a separate DB server for reporting.

There are less then 157,000 NPA and NXX in North America far as I know of and not 110 million NPA and NXXs . You must of misunderstood me or I wrote it wrong. The 110 million records I was referring to is a database that shows what areas NXX are local to what areas NXX. It wasn’t grouped right as I already stated. For an example New York might have 1,500 NPA and NXX that is local to each other and if improper grouping is done this alone will take up 2,250,000 records as it did when I first got these records before I grouped the areas local to eachother. So each NPA NXX is listed 1500 times on the left column for each NPA NXX its local to on the right column. So if you multiply like 1500 X 1500 since all 1,500 NPA NXX is listed 1,500 times on left column you get 2,250,000 and this was how it was done when i got the data. I hope this clears things up.

It did. Thanks. It makes a lot more sense ow

Sam, anyway, this is NOT right place for making any business here. keep in mind please.

If I stepped out of line here on this forum I sincerely apologize. I see people offering routes and such here on this very part of the forum to those not requesting it. This guy did make a request for a solution that works. having the poperdata could be a great help.



The Man was asking for implementation which really works and being new here there is a good chance he doesn’t have Data that could be useful to him.
When I first started I would have gladly paid $50 to have such data dropped into my database and to be honest I doubt it would be very easy to quickly find a MYSQL expert to put my own data in my database for $50 this doesn’t count for the fact I am already the owner of the data.

I would like anyone on this forum who is upset with my post and don’t think it belongs here to find data like what I have with 156,730 records of area codes and prefixes with rate center, city and state for North America for under $200 OR FREE and not a copy that originated from me and be willing to copy if from whatever site and put it in my Database on my server for $50. I highly doubt there is anyone here willing to do this and the fact is i have paid a lot more then $200 for this data.

So with this in mind it should be clear what I was offering would probably do a lot more good to anyone needed this data then what the sale would benefits me since this is a give away price. Its my understanding this forum is all about getting help as well as helping others and supporting the application.

Nearly giving away such valuable data and willing to put it in ones database for hardly nothing with the amount of time and money I have tied up in it is giving more then receiving and falls well with in the proper use of this forum in my opinion.

If I am wrong may one of the admins speak up and inform me of such. So if someone wants to complain about something then, find someone spamming their routes or something else commonly done on these forums and on this part of the forum. You don’t find everyday someone willing to come off of such data and including help setting up ones cc_ratecard table for low as $50.

I should have probably just dropped this but I am not shy about pleading my case. I would be glad to make this data open source if I could and if I thought people would pitch in and help me keep it up-to-date. This would save me mega bucks and time. But come on, is there such a thing as making data open source? Ok now I am done babbling. Sue me if you don’t like it..