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
