ITED™ is a comprehensive International Telephone Exchange Database providing full coverage of the National Numbering Plans of the more than 249 countries and regions of the world within the ITU-T Recommendation E.164 PSTN numbering space.
Identify International Direct Dialing (IDD) codes, country codes, city codes, area codes, and national destination codes for wireless, fixed line, premium rate, voip, freephone, toll-free and other telephone numbers for all countries. Identify recognized time zones based upon geographic area codes and national destination codes.
The ITED™ data files are UTF-8, comma separated value (CSV) text files with no Byte Order Mark signature. Each file contains a single header row followed by multiple data rows. Each row is terminated with a carriage return line feed character pair. Each data field is separated with a single comma character. If the field data contains one or more commas then the field is encapsulated with an opening and closing double quote character.
Produced: on or before 5th calendar day monthly
Current Release: February 2, 2024
Distribution Frequency: monthly or quarterly (issue date: January, April, July, October)
Distribution Format: Internet download
ITED™ supports the entire ITU E.164 telephone numbering space and provides coverage of the National Telephone Numbering Plans for the following countries and regions of the world.
AG Antigua and Barbuda
BO Bolivia, Plurinational State of
BA Bosnia and Herzegovina
IO British Indian Ocean Territory
BN Brunei Darussalam
BF Burkina Faso
CV Cape Verde
KY Cayman Islands
CF Central African Republic
CD Congo, Democratic Republic of the
CK Cook Islands
CR Costa Rica
CI Cote d'Ivoire
CZ Czech Republic
DO Dominican Republic
SV El Salvador
GQ Equatorial Guinea
FK Falkland Islands (Malvinas)
FO Faroe Islands
GF French Guiana
PF French Polynesia
HK Hong Kong
IR Iran, Islamic Republic of
KP Korea, Democratic People's Republic of
KR Korea, Republic of
LA Lao People's Democratic Republic
LY Libyan Arab Jamahiriya
MK Macedonia, The Former Yugoslav Republic of
MH Marshall Islands
FM Micronesia, Federated States of
MD Moldova, Republic of
NC New Caledonia
NZ New Zealand
NF Norfolk Island
PG Papua New Guinea
RU Russian Federation
|BL Saint Barthelemy
SH Saint Helena
KN Saint Kitts and Nevis
LC Saint Lucia
MF Saint Martin
PM Saint Pierre and Miquelon
VC Saint Vincent and the Grenadines
SM San marino
ST Sao Tome and Principe
SA Saudi Arabia
SL Sierra Leone
SB Solomon Islands
ZA South Africa
LK Sri Lanka
SY Syrian Arab Republic
TW Taiwan, Province of China
TZ Tanzania, United Republic of
TT Trinidad and Tobago
TC Turks and Caicos Islands
AE United Arab Emirates
GB United Kingdom
US United States
VE Venezuela, Bolivarian Republic of
VN Viet Nam
VG Virgin Islands, British
WF Wallis and Futuna
AC Ascension Island
AS American Samoa
AX Aland Islands
CC Cocos (Keeling) Islands
CX Christmas Island
DG Diego Garcia
EH Western Sahara
GS South Georgia and the South Sandwich Islands
IM Isle of Man
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.
|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.
|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.
|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.
|Dialing prefix that must prepend the National Significant Number for inbound international calls to cellular and\or wireless numbers. This prefix appears between the international Country Code and the National Destination Code in normal dialing procedures.
|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.
|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.
|Subscriber's Number (SN) ending range (high range) in this block assignment.
|Length of the National Destination Code or significant leading digits of the national (significant) number.
|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.
|Length of the National (Significant) Number
|Type of service. associated with the particular telephone exchange or number.
|Name of primary telecom carrier or service provider name the numbering block is assigned to.
|ISO 639 language code identifying the predominate language within the service area or territory.
|ISO 3166-1 numeric country code
|ISO 3166-1 alpha 2 country code
|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.
|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.
|Name of the geographic area, locale, city, municipality, or service type identified by the national (significant) number.
|Time zone of the general geographic service area specified using Olson Time Zone Database time zone ID.
|Time zone of the general geographic service area specified as Coordinated Universal Time (UTC) offset. Format is +/-hh:mm
|Y/N flag indicating whether daylight savings time is recognized at the general geographic service area.
|Latitude in decimal degree format of the locale, city, municipality, or other geographically identifiable service area of the exchange.
|Longitude in decimal degree format of the locale, city, municipality, or other geographically identifiable service area of the exchange.
|Minimum length of the National (Significant) Number (NSN).
CREATE DATABASE if not exists `ited`;
DROP TABLE IF EXISTS `ited`;
CREATE TABLE `ited`
`CC` CHAR(3) NOT NULL,
`InternationalPrefix` VARCHAR(26) DEFAULT NULL,
`NationalPrefix` VARCHAR(26) DEFAULT NULL,
`CellPrefix` CHAR(3) DEFAULT NULL,
`NDC` VARCHAR(15) NOT NULL,
`SN_From` VARCHAR(15) NOT NULL,
`SN_To` VARCHAR(15) NOT NULL,
`NDC_Length` INT(11) NOT NULL,
`Uses_NDC` CHAR(1) NOT NULL,
`NSN_Length` INT(11) NOT NULL,
`NumberType` CHAR(1) NOT NULL,
`CarrierName` VARCHAR(128) DEFAULT NULL,
`Language` CHAR(3) NOT NULL,
`Country` INT(3) DEFAULT NULL,
`ISO` CHAR(2) NOT NULL,
`RegionCode` VARCHAR(10) DEFAULT NULL,
`RegionName` VARCHAR(128) DEFAULT NULL,
`City` VARCHAR(128) DEFAULT NULL,
`TimeZone` VARCHAR(128) NOT NULL,
`UTC` CHAR(6) NOT NULL,
`DST` CHAR(1) NOT NULL,
`Latitude` DOUBLE NOT NULL DEFAULT '0',
`Longitude` DOUBLE NOT NULL DEFAULT '0',
`NSN_Min_Length` INT(11) NOT NULL DEFAULT '0',
KEY `exchange` (`CC`,`NDC`,`SN_From`)
ENGINE=MyISAM DEFAULT CHARSET=utf8;