Skip to content

Instantly share code, notes, and snippets.

@mattfawcett
Created November 10, 2009 10:04
Show Gist options
  • Save mattfawcett/230783 to your computer and use it in GitHub Desktop.
Save mattfawcett/230783 to your computer and use it in GitHub Desktop.
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
-- --------------------------------------------------------
--
-- Table structure for table `dialing_codes`
--
CREATE TABLE IF NOT EXISTS `dialing_codes` (
`Country` varchar(128) NOT NULL,
`Code` varchar(64) NOT NULL,
PRIMARY KEY (`Country`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `dialing_codes`
--
INSERT INTO `dialing_codes` (`Country`, `Code`) VALUES
('Afghanistan', '+93'),
('Albania', '+355'),
('Algeria', '+213'),
('Andorra ', '+376'),
('Angola ', '+244'),
('Antarctica', '+672'),
('Argentina', '+54'),
('Armenia ', '+374'),
('Aruba', '+297'),
('Ascension', '+247'),
('Australia ', '+61'),
('Australian External Territories', '+672'),
('Austria', '+43'),
('Azerbaijan', '+994'),
('Bahrain', '+973'),
('Bangladesh', '+880'),
('Belarus', '+375'),
('Belgium', '+32'),
('Belize', '+501'),
('Benin', '+229'),
('Bhutan', '+975'),
('Bolivia ', '+591'),
('Bosnia & Herzegovina ', '+387'),
('Botswana ', '+267'),
('Brazil ', '+55'),
('Brunei Darussalam', '+673'),
('Bulgaria', '+359'),
('Burkina Faso ', '+226'),
('Burundi', '+257'),
('Cambodia', '+855'),
('Cameroon', '+237'),
('Canada', '+1'),
('Cape Verde Islands', '+238'),
('Central African Republic', '+236'),
('Chad ', '+235'),
('Chatham Island (New Zealand)', '+64'),
('Chile ', '+56'),
('China (PRC)', '+86'),
('Christmas Island', '+61-8'),
('Cocos-Keeling Islands', '+61'),
('Colombia ', '+57'),
('Comoros', '+269'),
('Congo', '+242'),
('Congo, Dem. Rep. of? (former Zaire) ', '+243'),
('Cook Islands', '+682'),
('Costa Rica', '+506'),
('Cote d''Ivoire (Ivory Coast)', '+225'),
('Croatia', '+385'),
('Cuba', '+53'),
('Cuba (Guantanamo Bay)', '+5399'),
('Curacao', '+599'),
('Cyprus', '+357'),
('Czech Republic', '+420'),
('Denmark', '+45'),
('Diego Garcia', '+246'),
('Djibouti', '+253'),
('East Timor', '+670'),
('Easter Island', '+56'),
('Ecuador ', '+593'),
('Egypt', '+20'),
('El Salvador', '+503'),
('Equatorial Guinea', '+240'),
('Eritrea', '+291'),
('Estonia', '+372'),
('Ethiopia', '+251'),
('Falkland Islands (Malvinas)', '+500'),
('Faroe Islands', '+298'),
('Fiji Islands', '+679'),
('Finland', '+358'),
('France', '+33'),
('French Antilles', '+596'),
('French Guiana', '+594'),
('French Polynesia', '+689'),
('Gabonese Republic', '+241'),
('Gambia', '+220'),
('Georgia', '+995'),
('Germany', '+49'),
('Ghana ', '+233'),
('Gibraltar ', '+350'),
('Greece ', '+30'),
('Greenland ', '+299'),
('Guadeloupe', '+590'),
('Guantanamo Bay', '+5399'),
('Guatemala ', '+502'),
('Guinea-Bissau ', '+245'),
('Guinea', '+224'),
('Guyana', '+592'),
('Haiti ', '+509'),
('Honduras', '+504'),
('Hong Kong', '+852'),
('Hungary ', '+36'),
('Iceland', '+354'),
('India', '+91'),
('Indonesia', '+62'),
('Iran', '+98'),
('Iraq', '+964'),
('Ireland', '+353'),
('Israel ', '+972'),
('Italy ', '+39'),
('Japan ', '+81'),
('Jordan', '+962'),
('Kazakhstan', '+7'),
('Kenya', '+254'),
('Kiribati ', '+686'),
('Korea (North)', '+850'),
('Korea (South)', '+82'),
('Kuwait ', '+965'),
('Kyrgyz Republic', '+996'),
('Laos', '+856'),
('Latvia ', '+371'),
('Lebanon', '+961'),
('Lesotho', '+266'),
('Liberia', '+231'),
('Libya', '+218'),
('Liechtenstein', '+423'),
('Lithuania ', '+370'),
('Luxembourg', '+352'),
('Macao', '+853'),
('Macedonia (Former Yugoslav Rep of.)', '+389'),
('Madagascar', '+261'),
('Malawi ', '+265'),
('Malaysia', '+60'),
('Maldives', '+960'),
('Mali Republic', '+223'),
('Malta', '+356'),
('Marshall Islands', '+692'),
('Martinique', '+596'),
('Mauritania', '+222'),
('Mauritius', '+230'),
('Mayotte Island', '+269'),
('Mexico', '+52'),
('Micronesia, (Federal States of)', '+691'),
('Moldova ', '+373'),
('Monaco', '+377'),
('Mongolia ', '+976'),
('Montenegro', '+382'),
('Morocco', '+212'),
('Mozambique', '+258'),
('Myanmar', '+95'),
('Namibia', '+264'),
('Nauru', '+674'),
('Nepal ', '+977'),
('Netherlands', '+31'),
('Netherlands Antilles', '+599'),
('New Caledonia', '+687'),
('New Zealand', '+64'),
('Nicaragua', '+505'),
('Niger', '+227'),
('Nigeria', '+234'),
('Niue', '+683'),
('Norfolk Island', '+672'),
('Norway ', '+47'),
('Oman', '+968'),
('Pakistan', '+92'),
('Palau', '+680'),
('Palestinian Settlements', '+970'),
('Panama', '+507'),
('Papua New Guinea', '+675'),
('Paraguay', '+595'),
('Peru', '+51'),
('Philippines', '+63'),
('Poland', '+48'),
('Portugal', '+351'),
('Qatar', '+974'),
('R?union Island', '+262'),
('Romania', '+40'),
('Russia', '+7'),
('Rwandese Republic', '+250'),
('St. Helena', '+290'),
('St. Pierre & Miquelon', '+508'),
('Samoa', '+685'),
('San Marino', '+378'),
('S?o Tom? and Principe', '+239'),
('Saudi Arabia', '+966'),
('Senegal ', '+221'),
('Serbia', '+381'),
('Seychelles Republic', '+248'),
('Sierra Leone', '+232'),
('Singapore', '+65'),
('Slovak Republic', '+421'),
('Slovenia ', '+386'),
('Solomon Islands', '+677'),
('Somali Democratic Republic', '+252'),
('South Africa', '+27'),
('Spain', '+34'),
('Sri Lanka', '+94'),
('Sudan', '+249'),
('Suriname ', '+597'),
('Swaziland', '+268'),
('Sweden', '+46'),
('Switzerland', '+41'),
('Syria', '+963'),
('Taiwan', '+886'),
('Tajikistan', '+992'),
('Tanzania', '+255'),
('Thailand', '+66'),
('Timor Leste', '+670'),
('Togolese Republic', '+228'),
('Tokelau', '+690'),
('Tonga Islands', '+676'),
('Tunisia', '+216'),
('Turkey', '+90'),
('Turkmenistan ', '+993'),
('Tuvalu', '+688'),
('Uganda', '+256'),
('Ukraine', '+380'),
('United Arab Emirates', '+971'),
('United Kingdom', '+44'),
('United States of America', '+1'),
('Universal Personal Telecommunications (UPT)', '+878'),
('Uruguay', '+598'),
('Uzbekistan', '+998'),
('Vanuatu', '+678'),
('Vatican City', '+39'),
('Venezuela', '+58'),
('Vietnam', '+84'),
('Wake Island', '+808'),
('Wallis and Futuna Islands', '+681'),
('Yemen', '+967'),
('Zambia ', '+260'),
('Zanzibar', '+255'),
('Zimbabwe ', '+263');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment