Jan
22
2009

SQL Tips – List of International Dialling Codes (IDC's)

I’ve been working on a new project and needed a list of International Dialling Codes to insert into my database.

Here are the results of my work for all to use.
The list is supplied as SQL and then tab delimited.

Note that Côte d’Ivoire (Ivory Coast) contains a single quote and as such needs escaping properly. The SQL is escaped, but the tab delimited version is not.

The original list was sourced from Wikipedia.

Please post a comment if you find this useful.

Here is the SQL:

INSERT INTO mytable(location, locationFull, idc)
VALUES
('Afghanistan','Afghanistan (+93)','+93'),
('Albania','Albania (+355)','+355'),
('Algeria','Algeria (+213)','+213'),
('American Samoa','American Samoa (+1)','+1'),
('Andorra','Andorra (+376)','+376'),
('Angola','Angola (+244)','+244'),
('Anguilla','Anguilla (+1)','+1'),
('Antigua','Antigua (+1)','+1'),
('Argentina','Argentina (+54)','+54'),
('Armenia','Armenia (+374)','+374'),
('Aruba','Aruba (+297)','+297'),
('Ascension','Ascension (+247)','+247'),
('Australia','Australia (+61)','+61'),
('Australian External Territories','Australian External Territories (+672)','+672'),
('Austria','Austria (+43)','+43'),
('Azerbaijan','Azerbaijan (+994)','+994'),
('Bahamas','Bahamas (+1)','+1'),
('Bahrain','Bahrain (+973)','+973'),
('Bangladesh','Bangladesh (+880)','+880'),
('Barbados','Barbados (+1)','+1'),
('Barbuda','Barbuda (+1)','+1'),
('Belarus','Belarus (+375)','+375'),
('Belgium','Belgium (+32)','+32'),
('Belize','Belize (+501)','+501'),
('Benin','Benin (+229)','+229'),
('Bermuda','Bermuda (+1)','+1'),
('Bhutan','Bhutan (+975)','+975'),
('Bolivia','Bolivia (+591)','+591'),
('Bosnia and Herzegovina','Bosnia and Herzegovina (+387)','+387'),
('Botswana','Botswana (+267)','+267'),
('Brazil','Brazil (+55)','+55'),
('British Virgin Islands','British Virgin Islands (+1)','+1'),
('Brunei Darussalam','Brunei Darussalam (+673)','+673'),
('Bulgaria','Bulgaria (+359)','+359'),
('Burkina Faso','Burkina Faso (+226)','+226'),
('Burundi','Burundi (+257)','+257'),
('Cambodia','Cambodia (+855)','+855'),
('Cameroon','Cameroon (+237)','+237'),
('Canada','Canada (+1)','+1'),
('Cape Verde Islands','Cape Verde Islands (+238)','+238'),
('Cayman Islands','Cayman Islands (+1)','+1'),
('Central African Republic','Central African Republic (+236)','+236'),
('Chad','Chad (+235)','+235'),
('Chatham Island (New Zealand)','Chatham Island (New Zealand) (+64)','+64'),
('Chile','Chile (+56)','+56'),
('China (PRC)','China (PRC) (+86)','+86'),
('Christmas Island','Christmas Island (+618)','+618'),
('Cocos-Keeling Islands','Cocos-Keeling Islands (+61)','+61'),
('Colombia','Colombia (+57)','+57'),
('Comoros','Comoros (+269)','+269'),
('Congo','Congo (+242)','+242'),
('Congo, Dem. Rep. of (Zaire)','Congo, Dem. Rep. of (Zaire) (+243)','+243'),
('Cook Islands','Cook Islands (+682)','+682'),
('Costa Rica','Costa Rica (+506)','+506'),
('Côte d''Ivoire (Ivory Coast)','Côte d''Ivoire (Ivory Coast) (+225)','+225'),
('Croatia','Croatia (+385)','+385'),
('Cuba','Cuba (+53)','+53'),
('Cuba (Guantanamo Bay)','Cuba (Guantanamo Bay) (+5399)','+5399'),
('Curaçao','Curaçao (+599)','+599'),
('Cyprus','Cyprus (+357)','+357'),
('Czech Republic','Czech Republic (+420)','+420'),
('Denmark','Denmark (+45)','+45'),
('Diego Garcia','Diego Garcia (+246)','+246'),
('Djibouti','Djibouti (+253)','+253'),
('Dominica','Dominica (+1)','+1'),
('Dominican Republic','Dominican Republic (+1)','+1'),
('East Timor','East Timor (+670)','+670'),
('Easter Island','Easter Island (+56)','+56'),
('Ecuador','Ecuador (+593)','+593'),
('Egypt','Egypt (+20)','+20'),
('El Salvador','El Salvador (+503)','+503'),
('Ellipso (Mobile Satellite service)','Ellipso (Mobile Satellite service) (+881)','+881'),
('EMSAT (Mobile Satellite service)','EMSAT (Mobile Satellite service) (+88213)','+88213'),
('Equatorial Guinea','Equatorial Guinea (+240)','+240'),
('Eritrea','Eritrea (+291)','+291'),
('Estonia','Estonia (+372)','+372'),
('Ethiopia','Ethiopia (+251)','+251'),
('Falkland Islands','Falkland Islands (+500)','+500'),
('Faroe Islands','Faroe Islands (+298)','+298'),
('Fiji Islands','Fiji Islands (+679)','+679'),
('Finland','Finland (+358)','+358'),
('France','France (+33)','+33'),
('French Antilles','French Antilles (+596)','+596'),
('French Guiana','French Guiana (+594)','+594'),
('French Polynesia','French Polynesia (+689)','+689'),
('Gabonese Republic','Gabonese Republic (+241)','+241'),
('Gambia','Gambia (+220)','+220'),
('Georgia','Georgia (+995)','+995'),
('Germany','Germany (+49)','+49'),
('Ghana','Ghana (+233)','+233'),
('Gibraltar','Gibraltar (+350)','+350'),
('Global Mobile Satellite System (GMSS)','Global Mobile Satellite System (GMSS) (+881)','+881'),
('Globalstar (Mobile Satellite Service)','Globalstar (Mobile Satellite Service) (+881)','+881'),
('Greece','Greece (+30)','+30'),
('Greenland','Greenland (+299)','+299'),
('Grenada','Grenada (+1)','+1'),
('Guadeloupe','Guadeloupe (+590)','+590'),
('Guam','Guam (+1)','+1'),
('Guantanamo Bay','Guantanamo Bay (+5399)','+5399'),
('Guatemala','Guatemala (+502)','+502'),
('Guinea','Guinea (+224)','+224'),
('Guinea-Bissau','Guinea-Bissau (+245)','+245'),
('Guyana','Guyana (+592)','+592'),
('Haiti','Haiti (+509)','+509'),
('Honduras','Honduras (+504)','+504'),
('Hong Kong','Hong Kong (+852)','+852'),
('Hungary','Hungary (+36)','+36'),
('Iceland','Iceland (+354)','+354'),
('ICO Global (Mobile Satellite Service)','ICO Global (Mobile Satellite Service) (+881)','+881'),
('India','India (+91)','+91'),
('Indonesia','Indonesia (+62)','+62'),
('Inmarsat (Atlantic Ocean - East)','Inmarsat (Atlantic Ocean - East) (+871)','+871'),
('Inmarsat (Atlantic Ocean - West)','Inmarsat (Atlantic Ocean - West) (+874)','+874'),
('Inmarsat (Indian Ocean)','Inmarsat (Indian Ocean) (+873)','+873'),
('Inmarsat (Pacific Ocean)','Inmarsat (Pacific Ocean) (+872)','+872'),
('Inmarsat SNAC','Inmarsat SNAC (+870)','+870'),
('International Freephone Service','International Freephone Service (+800)','+800'),
('International Shared Cost Service (ISCS)','International Shared Cost Service (ISCS) (+808)','+808'),
('Iran','Iran (+98)','+98'),
('Iraq','Iraq (+964)','+964'),
('Ireland','Ireland (+353)','+353'),
('Iridium (Mobile Satellite service)','Iridium (Mobile Satellite service) (+881)','+881'),
('Israel','Israel (+972)','+972'),
('Italy','Italy (+39)','+39'),
('Jamaica','Jamaica (+1)','+1'),
('Japan','Japan (+81)','+81'),
('Jordan','Jordan (+962)','+962'),
('Kazakhstan','Kazakhstan (+7)','+7'),
('Kenya','Kenya (+254)','+254'),
('Kiribati','Kiribati (+686)','+686'),
('Korea (North)','Korea (North) (+850)','+850'),
('Korea (South)','Korea (South) (+82)','+82'),
('Kuwait','Kuwait (+965)','+965'),
('Kyrgyz Republic','Kyrgyz Republic (+996)','+996'),
('Laos','Laos (+856)','+856'),
('Latvia','Latvia (+371)','+371'),
('Lebanon','Lebanon (+961)','+961'),
('Lesotho','Lesotho (+266)','+266'),
('Liberia','Liberia (+231)','+231'),
('Libya','Libya (+218)','+218'),
('Liechtenstein','Liechtenstein (+423)','+423'),
('Lithuania','Lithuania (+370)','+370'),
('Luxembourg','Luxembourg (+352)','+352'),
('Macao','Macao (+853)','+853'),
('Macedonia','Macedonia (+389)','+389'),
('Madagascar','Madagascar (+261)','+261'),
('Malawi','Malawi (+265)','+265'),
('Malaysia','Malaysia (+60)','+60'),
('Maldives','Maldives (+960)','+960'),
('Mali Republic','Mali Republic (+223)','+223'),
('Malta','Malta (+356)','+356'),
('Marshall Islands','Marshall Islands (+692)','+692'),
('Martinique','Martinique (+596)','+596'),
('Mauritania','Mauritania (+222)','+222'),
('Mauritius','Mauritius (+230)','+230'),
('Mayotte Island','Mayotte Island (+262)','+262'),
('Mexico','Mexico (+52)','+52'),
('Micronesia, (Federal States of)','Micronesia, (Federal States of) (+691)','+691'),
('Midway Island','Midway Island (+1)','+1'),
('Moldova','Moldova (+373)','+373'),
('Monaco','Monaco (+377)','+377'),
('Mongolia','Mongolia (+976)','+976'),
('Montenegro','Montenegro (+382)','+382'),
('Montserrat','Montserrat (+1)','+1'),
('Morocco','Morocco (+212)','+212'),
('Mozambique','Mozambique (+258)','+258'),
('Myanmar','Myanmar (+95)','+95'),
('Namibia','Namibia (+264)','+264'),
('Nauru','Nauru (+674)','+674'),
('Nepal','Nepal (+977)','+977'),
('Netherlands','Netherlands (+31)','+31'),
('Netherlands Antilles','Netherlands Antilles (+599)','+599'),
('Nevis','Nevis (+1)','+1'),
('New Caledonia','New Caledonia (+687)','+687'),
('New Zealand','New Zealand (+64)','+64'),
('Nicaragua','Nicaragua (+505)','+505'),
('Niger','Niger (+227)','+227'),
('Nigeria','Nigeria (+234)','+234'),
('Niue','Niue (+683)','+683'),
('Norfolk Island','Norfolk Island (+672)','+672'),
('Northern Marianas Islands (Saipan, Rota, and Tinian)','Northern Marianas Islands (Saipan, Rota, and Tinian) (+1)','+1'),
('Norway','Norway (+47)','+47'),
('Oman','Oman (+968)','+968'),
('Pakistan','Pakistan (+92)','+92'),
('Palau','Palau (+680)','+680'),
('Palestinian Settlements','Palestinian Settlements (+970)','+970'),
('Panama','Panama (+507)','+507'),
('Papua New Guinea','Papua New Guinea (+675)','+675'),
('Paraguay','Paraguay (+595)','+595'),
('Peru','Peru (+51)','+51'),
('Philippines','Philippines (+63)','+63'),
('Poland','Poland (+48)','+48'),
('Portugal','Portugal (+351)','+351'),
('Puerto Rico','Puerto Rico (+1)','+1'),
('Qatar','Qatar (+974)','+974'),
('Réunion Island','Réunion Island (+262)','+262'),
('Romania','Romania (+40)','+40'),
('Russia','Russia (+7)','+7'),
('Rwandese Republic','Rwandese Republic (+250)','+250'),
('St. Helena','St. Helena (+290)','+290'),
('St. Kitts/Nevis','St. Kitts/Nevis (+1)','+1'),
('St. Lucia','St. Lucia (+1)','+1'),
('St. Pierre and Miquelon','St. Pierre and Miquelon (+508)','+508'),
('St. Vincent and Grenadines','St. Vincent and Grenadines (+1)','+1'),
('Samoa','Samoa (+685)','+685'),
('San Marino','San Marino (+378)','+378'),
('São Tomé and Principe','São Tomé and Principe (+239)','+239'),
('Saudi Arabia','Saudi Arabia (+966)','+966'),
('Senegal','Senegal (+221)','+221'),
('Serbia','Serbia (+381)','+381'),
('Seychelles Republic','Seychelles Republic (+248)','+248'),
('Sierra Leone','Sierra Leone (+232)','+232'),
('Singapore','Singapore (+65)','+65'),
('Slovak Republic','Slovak Republic (+421)','+421'),
('Slovenia','Slovenia (+386)','+386'),
('Solomon Islands','Solomon Islands (+677)','+677'),
('Somali Democratic Republic','Somali Democratic Republic (+252)','+252'),
('South Africa','South Africa (+27)','+27'),
('Spain','Spain (+34)','+34'),
('Sri Lanka','Sri Lanka (+94)','+94'),
('Sudan','Sudan (+249)','+249'),
('Suriname','Suriname (+597)','+597'),
('Swaziland','Swaziland (+268)','+268'),
('Sweden','Sweden (+46)','+46'),
('Switzerland','Switzerland (+41)','+41'),
('Syria','Syria (+963)','+963'),
('Taiwan','Taiwan (+886)','+886'),
('Tajikistan','Tajikistan (+992)','+992'),
('Tanzania','Tanzania (+255)','+255'),
('Thailand','Thailand (+66)','+66'),
('Thuraya (Mobile Satellite service)','Thuraya (Mobile Satellite service) (+88216)','+88216'),
('Timor Leste','Timor Leste (+670)','+670'),
('Togolese Republic','Togolese Republic (+228)','+228'),
('Tokelau','Tokelau (+690)','+690'),
('Tonga Islands','Tonga Islands (+676)','+676'),
('Trinidad and Tobago','Trinidad and Tobago (+1)','+1'),
('Tunisia','Tunisia (+216)','+216'),
('Turkey','Turkey (+90)','+90'),
('Turkmenistan','Turkmenistan (+993)','+993'),
('Turks and Caicos Islands','Turks and Caicos Islands (+1)','+1'),
('Tuvalu','Tuvalu (+688)','+688'),
('Uganda','Uganda (+256)','+256'),
('Ukraine','Ukraine (+380)','+380'),
('United Arab Emirates','United Arab Emirates (+971)','+971'),
('United Kingdom','United Kingdom (+44)','+44'),
('United States of America','United States of America (+1)','+1'),
('Universal Personal Telecommunications (UPT)','Universal Personal Telecommunications (UPT) (+878)','+878'),
('Uruguay','Uruguay (+598)','+598'),
('US Virgin Islands','US Virgin Islands (+1)','+1'),
('Uzbekistan','Uzbekistan (+998)','+998'),
('Vanuatu','Vanuatu (+678)','+678'),
('Vatican City','Vatican City (+379)','+379'),
('Venezuela','Venezuela (+58)','+58'),
('Vietnam','Vietnam (+84)','+84'),
('Wake Island','Wake Island (+808)','+808'),
('Wallis and Futuna Islands','Wallis and Futuna Islands (+681)','+681'),
('Yemen','Yemen (+967)','+967'),
('Zambia','Zambia (+260)','+260'),
('Zanzibar','Zanzibar (+255)','+255'),
('Zimbabwe','Zimbabwe (+263)','+263');

Here is the list tab delimited for editing yourself:

+93	Afghanistan
+355	Albania
+213	Algeria
+1	American Samoa
+376	Andorra
+244	Angola
+1	Anguilla
+1	Antigua
+54	Argentina
+374	Armenia
+297	Aruba
+247	Ascension
+61	Australia
+672	Australian External Territories
+43	Austria
+994	Azerbaijan
+1	Bahamas
+973	Bahrain
+880	Bangladesh
+1	Barbados
+1	Barbuda
+375	Belarus
+32	Belgium
+501	Belize
+229	Benin
+1	Bermuda
+975	Bhutan
+591	Bolivia
+387	Bosnia and Herzegovina
+267	Botswana
+55	Brazil
+1	British Virgin Islands
+673	Brunei Darussalam
+359	Bulgaria
+226	Burkina Faso
+257	Burundi
+855	Cambodia
+237	Cameroon
+1	Canada
+238	Cape Verde Islands
+1	Cayman Islands
+236	Central African Republic
+235	Chad
+64	Chatham Island (New Zealand)
+56	Chile
+86	China (PRC)
+618	Christmas Island
+61	Cocos-Keeling Islands
+57	Colombia
+269	Comoros
+242	Congo
+243	Congo, Dem. Rep. of (Zaire)
+682	Cook Islands
+506	Costa Rica
+225	Côte d'Ivoire (Ivory Coast)
+385	Croatia
+53	Cuba
+5399	Cuba (Guantanamo Bay)
+599	Curaçao
+357	Cyprus
+420	Czech Republic
+45	Denmark
+246	Diego Garcia
+253	Djibouti
+1	Dominica
+1	Dominican Republic
+670	East Timor
+56	Easter Island
+593	Ecuador
+20	Egypt
+503	El Salvador
+881	Ellipso (Mobile Satellite service)
+88213	EMSAT (Mobile Satellite service)
+240	Equatorial Guinea
+291	Eritrea
+372	Estonia
+251	Ethiopia
+500	Falkland Islands
+298	Faroe Islands
+679	Fiji Islands
+358	Finland
+33	France
+596	French Antilles
+594	French Guiana
+689	French Polynesia
+241	Gabonese Republic
+220	Gambia
+995	Georgia
+49	Germany
+233	Ghana
+350	Gibraltar
+881	Global Mobile Satellite System (GMSS)
+881	Globalstar (Mobile Satellite Service)
+30	Greece
+299	Greenland
+1	Grenada
+590	Guadeloupe
+1	Guam
+5399	Guantanamo Bay
+502	Guatemala
+224	Guinea
+245	Guinea-Bissau
+592	Guyana
+509	Haiti
+504	Honduras
+852	Hong Kong
+36	Hungary
+354	Iceland
+881	ICO Global (Mobile Satellite Service)
+91	India
+62	Indonesia
+871	Inmarsat (Atlantic Ocean - East)
+874	Inmarsat (Atlantic Ocean - West)
+873	Inmarsat (Indian Ocean)
+872	Inmarsat (Pacific Ocean)
+870	Inmarsat SNAC
+800	International Freephone Service
+808	International Shared Cost Service (ISCS)
+98	Iran
+964	Iraq
+353	Ireland
+881	Iridium (Mobile Satellite service)
+972	Israel
+39	Italy
+1	Jamaica
+81	Japan
+962	Jordan
+7	Kazakhstan
+254	Kenya
+686	Kiribati
+850	Korea (North)
+82	Korea (South)
+965	Kuwait
+996	Kyrgyz Republic
+856	Laos
+371	Latvia
+961	Lebanon
+266	Lesotho
+231	Liberia
+218	Libya
+423	Liechtenstein
+370	Lithuania
+352	Luxembourg
+853	Macao
+389	Macedonia
+261	Madagascar
+265	Malawi
+60	Malaysia
+960	Maldives
+223	Mali Republic
+356	Malta
+692	Marshall Islands
+596	Martinique
+222	Mauritania
+230	Mauritius
+262	Mayotte Island
+52	Mexico
+691	Micronesia, (Federal States of)
+1	Midway Island
+373	Moldova
+377	Monaco
+976	Mongolia
+382	Montenegro
+1	Montserrat
+212	Morocco
+258	Mozambique
+95	Myanmar
+264	Namibia
+674	Nauru
+977	Nepal
+31	Netherlands
+599	Netherlands Antilles
+1	Nevis
+687	New Caledonia
+64	New Zealand
+505	Nicaragua
+227	Niger
+234	Nigeria
+683	Niue
+672	Norfolk Island
+1	Northern Marianas Islands (Saipan, Rota, and Tinian)
+47	Norway
+968	Oman
+92	Pakistan
+680	Palau
+970	Palestinian Settlements
+507	Panama
+675	Papua New Guinea
+595	Paraguay
+51	Peru
+63	Philippines
+48	Poland
+351	Portugal
+1	Puerto Rico
+974	Qatar
+262	Réunion Island
+40	Romania
+7	Russia
+250	Rwandese Republic
+290	St. Helena
+1	St. Kitts/Nevis
+1	St. Lucia
+508	St. Pierre and Miquelon
+1	St. Vincent and Grenadines
+685	Samoa
+378	San Marino
+239	São Tomé and Principe
+966	Saudi Arabia
+221	Senegal
+381	Serbia
+248	Seychelles Republic
+232	Sierra Leone
+65	Singapore
+421	Slovak Republic
+386	Slovenia
+677	Solomon Islands
+252	Somali Democratic Republic
+27	South Africa
+34	Spain
+94	Sri Lanka
+249	Sudan
+597	Suriname
+268	Swaziland
+46	Sweden
+41	Switzerland
+963	Syria
+886	Taiwan
+992	Tajikistan
+255	Tanzania
+66	Thailand
+88216	Thuraya (Mobile Satellite service)
+670	Timor Leste
+228	Togolese Republic
+690	Tokelau
+676	Tonga Islands
+1	Trinidad and Tobago
+216	Tunisia
+90	Turkey
+993	Turkmenistan
+1	Turks and Caicos Islands
+688	Tuvalu
+256	Uganda
+380	Ukraine
+971	United Arab Emirates
+44	United Kingdom
+1	United States of America
+878	Universal Personal Telecommunications (UPT)
+598	Uruguay
+1	US Virgin Islands
+998	Uzbekistan
+678	Vanuatu
+379	Vatican City
+58	Venezuela
+84	Vietnam
+808	Wake Island
+681	Wallis and Futuna Islands
+967	Yemen
+260	Zambia
+255	Zanzibar
+263	Zimbabwe
Written by John in: SQL Tips,Tips |

No Comments »

RSS feed for comments on this post. TrackBack URL

Leave a comment