ITED Java Library

ITED™

International Telephone Exchange Database - Standard Edition


Produced: on or before 5th calendar day monthly
Current Release: June 5, 2013
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download

ITED™(International Telephone Exchange Database) provides global dialing data covering the numbering plans of the more than 230 countries and regions of the world within the ITU-T Recommendation E.164 assigned country codes numbering space.

Compiled from authoritative sources, this global data contains international dialing codes with assigned carrier, service type, time zone, language, and geographical locations or service names in a normalized format.

This product is delivered in UTF-8 CSV text format, it contains more than 1,622,065 records and requires basic data processing/management skills to effectively integrate into your development or processing environment.

 
International Telephone Exchange Master Assignments File
FieldData TypeField Description
CCCHAR (3)International Telephone Union ITU-T Recommendation E.164 numeric country code.
Commonly referred to as IDD (International Direct Dialling) or ISD (International Subscriber Dialling) codes, this code is the combination of one, two or three digits identifying a specific country, countries in an integrated numbering plan, or a specific geographic area.
InternationalPrefixVARCHAR (26)International prefix. The international prefix is the digit, or combination of digits, that must be dialed before a country code when dialing a call to a country other than the one from which the call is being placed.
NationalPrefixVARCHAR (26)National (trunk) prefix. The national (trunk) prefix is the digit, or combination of digits, which must be dialed before an area (city) code when dialing a call to a subscriber from inside his own country but outside his own numbering area.
NDCVARCHAR (15)National Destination Code (NDC) or significant leading digits of national (significant) number. The NDC can be a decimal digit or a combination of decimal digits (not including any prefix) identifying a numbering area within a country (or group of countries included in one integrated numbering plan or a specific geographic area) and/or network/services.
Commonly referred to as an International City Code or (Numbering Plan) Area Code, the NDC is a nationally optional code field, which - combined with the Subscriber's Number (SN) - will constitute the national (significant) number of the international E.164-number for geographic areas.
SN_FromVARCHAR (15)Subscriber's Number (SN) beginning range (low range) in this block assignment.
In many numbering plans the subscriber number contains significant leading digits that (in addition to the NDC) further define the local exchange area and/or service. For example in the North American Numbering Plan the first 3-digits of the subscriber number are known as the Central Office Code or telephone exchange prefix and identify the local (city) level service area.
SN_ToVARCHAR (15)Subscriber's Number (SN) ending range (high range) in this block assignment.
NDC_LengthINT (11)Length of the National Destination Code or significant leading digits of the national (significant) number.
Uses_NDCCHAR (1)Y/N field identifying whether the current country defines geographic area codes in their National Numbering Plan. If "Y" then the values specified in the NDC field are area codes as defined in the National Numbering Plan. If "N", geographic area codes are not defined in the National Numbering Plan and the values specified in the NDC field are the significant leading digits of national (significant) number.
NSN_LengthINT (11)Length of the National (Significant) Number
NumberTypeCHAR (1)Type of service. associated with the particular telephone exchange or number.
  • G - Geographic land line, fixed, includes POTS, WLL etc.
  • V - VoIP or location independent fixed land line
  • M - mobile, includes cellular, PCS, GSM, etc.
  • F - Freephone (toll-free services)
  • S - Special (premium service, data, internet access, etc. which all incur a higher charge rate).
CarrierNameVARCHAR (128)Name of primary telecom carrier or service provider name the numbering block is assigned to.
LanguageCHAR (3)ISO 639 language code identifying the predominate language within the service area or territory.
CountryINT (3)ISO 3166-1 numeric country code
ISOCHAR (2)ISO 3166-1 alpha 2 country code
RegionCodeVARCHAR (10)Postal abbreviation or code of the state, province, department, territory, or similar division within the country associated with the National Destination Code if any.
If a standard national abbreviation does not exist for the region the value will be that specified in International Standard ISO 3166-2:2007 Codes for the representation of names of countries and their subdivisions.
ISO2RegionName (128)Common name of the state, province, department, territory, or similar division, if any, identified by the National Destination Code and/or National (Significant) Number.
When present, RegionName agrees with those values specified in the International Standard ISO 3166-2:2007 Codes for the representation of names of countries and their subdivisions.
CityVARCHAR (128)Name of the geographic area, locale, city, municipality, or service type identified by the national (significant) number.
TimeZoneVARCHAR (128)Time zone of the general geographic service area specified using Olson Time Zone Database time zone ID.
UTCCHAR (6)Time zone of the general geographic service area specified as Coordinated Universal Time (UTC) offset. Format is +/-hh:mm
DSTCHAR (1)Y/N flag indicating whether daylight savings time is recognized at the general geographic service area.
LatitudeDOUBLELatitude in decimal degree format of the locale, city, municipality, or other geographically identifiable service area of the exchange.
LongitudeDOUBLELongitude in decimal degree format of the locale, city, municipality, or other geographically identifiable service area of the exchange.

ITED™ coverage includes the following countries and regions of the world:

  • AF AFGHANISTAN
  • AL ALBANIA
  • DZ ALGERIA
  • AD ANDORRA
  • AO ANGOLA
  • AI ANGUILLA
  • AQ ANTARCTICA
  • AG ANTIGUA AND BARBUDA
  • AR ARGENTINA
  • AM ARMENIA
  • AW ARUBA
  • AU AUSTRALIA
  • AT AUSTRIA
  • AZ AZERBAIJAN
  • BS BAHAMAS
  • BH BAHRAIN
  • BD BANGLADESH
  • BB BARBADOS
  • BY BELARUS
  • BE BELGIUM
  • BZ BELIZE
  • BJ BENIN
  • BM BERMUDA
  • BT BHUTAN
  • BO BOLIVIA, PLURINATIONAL STATE OF
  • BA BOSNIA AND HERZEGOVINA
  • BW BOTSWANA
  • BR BRAZIL
  • IO BRITISH INDIAN OCEAN TERRITORY
  • BN BRUNEI DARUSSALAM
  • BG BULGARIA
  • BF BURKINA FASO
  • BI BURUNDI
  • KH CAMBODIA
  • CM CAMEROON
  • CA CANADA
  • CV CAPE VERDE
  • KY CAYMAN ISLANDS
  • CF CENTRAL AFRICAN REPUBLIC
  • TD CHAD
  • CL CHILE
  • CN CHINA
  • CO COLOMBIA
  • KM COMOROS
  • CG CONGO
  • CD CONGO, THE DEMOCRATIC REPUBLIC OF THE
  • CK COOK ISLANDS
  • CR COSTA RICA
  • CI COTE D'IVOIRE
  • HR CROATIA
  • CU CUBA
  • CY CYPRUS
  • CZ CZECH REPUBLIC
  • DK DENMARK
  • DJ DJIBOUTI
  • DM DOMINICA
  • DO DOMINICAN REPUBLIC
  • EC ECUADOR
  • EG EGYPT
  • SV EL SALVADOR
  • GQ EQUATORIAL GUINEA
  • ER ERITREA
  • ET ETHIOPIA
  • FK FALKLAND ISLANDS (MALVINAS)
  • FO FAROE ISLANDS
  • FJ FIJI
  • FI FINLAND
  • FR FRANCE
  • GF FRENCH GUIANA
  • PF FRENCH POLYNESIA
  • GA GABON
  • GM GAMBIA
  • GE GEORGIA
  • DE GERMANY
  • GH GHANA
  • GI GIBRALTAR
  • GR GREECE
  • GL GREENLAND
  • GD GRENADA
  • GP GUADELOUPE
  • GT GUATEMALA
  • GN GUINEA
  • GW GUINEA-BISSAU
  • GY GUYANA
  • HT HAITI
  • HN HONDURAS
  • HK HONG KONG
  • HU HUNGARY
  • IS ICELAND
  • IN INDIA
  • IR IRAN, ISLAMIC REPUBLIC OF
  • IQ IRAQ
  • IE IRELAND
  • IL ISRAEL
  • IT ITALY
  • JM JAMAICA
  • JP JAPAN
  • JO JORDAN
  • KZ KAZAKHSTAN
  • KE KENYA
  • KI KIRIBATI
  • KP KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF
  • KR KOREA, REPUBLIC OF
  • KW KUWAIT
  • KG KYRGYZSTAN
  • LA LAO PEOPLE'S DEMOCRATIC REPUBLIC
  • LV LATVIA
  • LB LEBANON
  • LS LESOTHO
  • LR LIBERIA
  • LY LIBYAN ARAB JAMAHIRIYA
  • LI LIECHTENSTEIN
  • LT LITHUANIA
  • LU LUXEMBOURG
  • MO MACAO
  • MK MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF
  • MG MADAGASCAR
  • MW MALAWI
  • MY MALAYSIA
  • MV MALDIVES
  • ML MALI
  • MT MALTA
  • MH MARSHALL ISLANDS
  • MQ MARTINIQUE
  • MR MAURITANIA
  • MU MAURITIUS
  • YT MAYOTTE
  • MX MEXICO
  • FM MICRONESIA, FEDERATED STATES OF
  • MD MOLDOVA, REPUBLIC OF
  • MC MONACO
  • MN MONGOLIA
  • ME MONTENEGRO
  • MS MONTSERRAT
  • MA MOROCCO
  • MZ MOZAMBIQUE
  • MM MYANMAR
  • NA NAMIBIA
  • NR NAURU
  • NP NEPAL
  • NL NETHERLANDS
  • AN NETHERLANDS ANTILLES
  • NC NEW CALEDONIA
  • NZ NEW ZEALAND
  • NI NICARAGUA
  • NE NIGER
  • NG NIGERIA
  • NU NIUE
  • NF NORFOLK ISLAND
  • NO NORWAY
  • OM OMAN
  • PK PAKISTAN
  • PW PALAU
  • PA PANAMA
  • PG PAPUA NEW GUINEA
  • PY PARAGUAY
  • PE PERU
  • PH PHILIPPINES
  • PL POLAND
  • PT PORTUGAL
  • QA QATAR
  • RE REUNION
  • RO ROMANIA
  • RU RUSSIAN FEDERATION
  • RW RWANDA
  • BL SAINT BARTHELEMY
  • SH SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA
  • KN SAINT KITTS AND NEVIS
  • LC SAINT LUCIA
  • MF SAINT MARTIN
  • PM SAINT PIERRE AND MIQUELON
  • VC SAINT VINCENT AND THE GRENADINES
  • WS SAMOA
  • SM SAN MARINO
  • ST SAO TOME AND PRINCIPE
  • SA SAUDI ARABIA
  • SN SENEGAL
  • RS SERBIA
  • SC SEYCHELLES
  • SL SIERRA LEONE
  • SG SINGAPORE
  • SK SLOVAKIA
  • SI SLOVENIA
  • SB SOLOMON ISLANDS
  • SO SOMALIA
  • ZA SOUTH AFRICA
  • ES SPAIN
  • LK SRI LANKA
  • SD SUDAN
  • SR SURINAME
  • SZ SWAZILAND
  • SE SWEDEN
  • CH SWITZERLAND
  • SY SYRIAN ARAB REPUBLIC
  • TW TAIWAN, PROVINCE OF CHINA
  • TJ TAJIKISTAN
  • TZ TANZANIA, UNITED REPUBLIC OF
  • TH THAILAND
  • TL TIMOR-LESTE
  • TG TOGO
  • TK TOKELAU
  • TO TONGA
  • TT TRINIDAD AND TOBAGO
  • TN TUNISIA
  • TR TURKEY
  • TM TURKMENISTAN
  • TC TURKS AND CAICOS ISLANDS
  • TV TUVALU
  • UG UGANDA
  • UA UKRAINE
  • AE UNITED ARAB EMIRATES
  • GB UNITED KINGDOM
  • US UNITED STATES
  • UY URUGUAY
  • UZ UZBEKISTAN
  • VU VANUATU
  • VE VENEZUELA, BOLIVARIAN REPUBLIC OF
  • VN VIET NAM
  • VG VIRGIN ISLANDS, BRITISH
  • WF WALLIS AND FUTUNA
  • YE YEMEN
  • ZM ZAMBIA
  • ZW ZIMBABWE
  • AC Ascension Island
  • AS AMERICAN SAMOA
  • AX ALAND ISLANDS
  • CC COCOS (KEELING) ISLANDS
  • CX CHRISTMAS ISLAND
  • DG Diego Garcia
  • EE ESTONIA
  • EH WESTERN SAHARA
  • GG GUERNSEY
  • GS SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS
  • GU GUAM
  • ID INDONESIA
  • IM ISLE OF MAN
  • JE JERSEY
  • MP NORTHERN MARIANA ISLANDS
  • PR PUERTO RICO
  • SJ SVALBARD AND JAN MAYEN
  • TA Tristan da Cunha
  • TF FRENCH SOUTHERN TERRITORIES
  • UM UNITED STATES MINOR OUTLYING ISLANDS
  • VA HOLY SEE (VATICAN CITY STATE)
  • VI VIRGIN ISLANDS, U.S.

Corporate License
Single release
$1,299.95 USD


Corporate License
Annual subscription - quarterly updates
$2,899.95 USD


Data format:CSV formatted UTF-8 text
Record count:1,622,065+/-

Download size:12.6 MB
Download format:zip compressed
Disk space required:226 MB+/-