Generating a List of Country/Regions

  • Hi I was wondering if anyone has an Idea where I can find a table or listing of Country/Regions Phone Codes? I'm looking for a list that contains say +1 for USA and ever other country.

  • Try:

    http://www.lincmad.com/countrycodes.html

    James.

  • I'll second that on LincMad... been using his stuff for years and is one of the best places to find this type of free info.

    If you need something to pay for in a more download friendly format, check out CCMI.com ... been using them for a long time, too.  The International City file is what you'd be looking for... get's it right down to the nads (1-3 digits for Country Code, 0 to 4 digits for City Code, only includes "1" for US and Canada).  Wrote lot's of SQL to support that stuff (2 world-wide call accounting packages).  Their Master Rate Center file gives you a lot more info for US and Canada, as well (including "Douglas" coordinates for calculating distances without having to do curvature of the Earth calcs).

    For simple U.S. NPA/NXX information, you can get a downloadable, tab delimited from NANPA (North American Numbering Plan Association) at the following URL (use the download for "All States" to import into a database). 

    http://www.nanpa.com/reports/reports_cocodes_assign.html

    That site also has a link for the Canadian information (saw it once, somewhere, on that site... I'll let you dig it out)

    You can also check out a product called "Maponics"... their file also includes Zip Codes for US and postal codes for Canada (although a lot of the Canada postal codes are simply missing).

    Hope that helps...

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Oh, yeah... if you want the actual "Region ID", you'll need to get Telcordia's "NNACL"... but I think that's only for the US and Canada.  Prepare to pay some $$ for that!  It's been a long time but I think it's actually an extract from LERG 7 and shouldn't be as expensive as buying the actual LERG itself.

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply