Skip to content

Instantly share code, notes, and snippets.

@dhernandez
Forked from kamermans/mysql_countries.sql
Last active March 1, 2018 10:34
Show Gist options
  • Save dhernandez/9d2d3b629874c7b1e48559939c899fb4 to your computer and use it in GitHub Desktop.
Save dhernandez/9d2d3b629874c7b1e48559939c899fb4 to your computer and use it in GitHub Desktop.
MySQL Dump - continents and countries with 2 and 3 char codes, names and full names - Spanish and English - Braintree compatible as of Dec 2011
/**
*
* Added spanish language by Daniel Hernández.
*
* Continents and Countries MySQL Tables compiled from Wikipedia, Braintree Payments documentation
* and a couple other places I don't recall at the moment. This data is compatible with the Braintree
* Payment API as of Dec 2011
*
* Compiled by Steve Kamerman, 2011
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `continents`
-- ----------------------------
DROP TABLE IF EXISTS `continents`;
CREATE TABLE `continents` (
`code` char(2) NOT NULL COMMENT 'Continent code',
`name` varchar(255) DEFAULT NULL,
PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of continents
-- ----------------------------
INSERT INTO `continents` VALUES ('AF', 'Africa');
INSERT INTO `continents` VALUES ('AN', 'Antarctica');
INSERT INTO `continents` VALUES ('AS', 'Asia');
INSERT INTO `continents` VALUES ('EU', 'Europe');
INSERT INTO `continents` VALUES ('NA', 'North America');
INSERT INTO `continents` VALUES ('OC', 'Oceania');
INSERT INTO `continents` VALUES ('SA', 'South America');
DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries` (
`country_id` int(11) NOT NULL AUTO_INCREMENT,
`code` char(2) NOT NULL COMMENT 'Two-letter country code (ISO 3166-1 alpha-2)',
`name` varchar(64) NOT NULL COMMENT 'English country name',
`full_name` varchar(128) NOT NULL COMMENT 'Full English country name',
`spanish_name` varchar(255) NOT NULL COMMENT 'Spanish country name',
`iso3` char(3) NOT NULL COMMENT 'Three-letter country code (ISO 3166-1 alpha-3)',
`number` smallint(3) unsigned zerofill NOT NULL COMMENT 'Three-digit country number (ISO 3166-1 numeric)',
`continent_code` char(2) NOT NULL,
`display_order` int(3) NOT NULL DEFAULT '900',
PRIMARY KEY (`country_id`),
UNIQUE KEY `idx_code` (`code`) USING BTREE,
KEY `idx_continent_code` (`continent_code`) USING BTREE,
CONSTRAINT `countries_ibfk_1` FOREIGN KEY (`continent_code`) REFERENCES `continents` (`code`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of countries
-- ----------------------------
INSERT INTO `countries` VALUES(1, 'AD', 'Andorra', 'Principality of Andorra', 'Andorra', 'AND', 020, 'EU', 7);
INSERT INTO `countries` VALUES(2, 'AE', 'United Arab Emirates', 'United Arab Emirates', 'Emiratos Árabes Unidos', 'ARE', 784, 'AS', 232);
INSERT INTO `countries` VALUES(3, 'AF', 'Afghanistan', 'Islamic Republic of Afghanistan', 'Afganistán', 'AFG', 004, 'AS', 3);
INSERT INTO `countries` VALUES(4, 'AG', 'Antigua and Barbuda', 'Antigua and Barbuda', 'Antigua y Barbuda', 'ATG', 028, 'NA', 11);
INSERT INTO `countries` VALUES(5, 'AI', 'Anguilla', 'Anguilla', 'Anguila', 'AIA', 660, 'NA', 9);
INSERT INTO `countries` VALUES(6, 'AL', 'Albania', 'Republic of Albania', 'Albania', 'ALB', 008, 'EU', 4);
INSERT INTO `countries` VALUES(7, 'AM', 'Armenia', 'Republic of Armenia', 'Armenia', 'ARM', 051, 'AS', 13);
INSERT INTO `countries` VALUES(8, 'AN', 'Netherlands Antilles', 'Netherlands Antilles', 'Antillas Neerlandesas', 'ANT', 530, 'NA', 157);
INSERT INTO `countries` VALUES(9, 'AO', 'Angola', 'Republic of Angola', 'Angola', 'AGO', 024, 'AF', 8);
INSERT INTO `countries` VALUES(10, 'AQ', 'Antarctica', 'Antarctica (the territory South of 60 deg S)', 'Antártida', 'ATA', 010, 'AN', 10);
INSERT INTO `countries` VALUES(11, 'AR', 'Argentina', 'Argentine Republic', 'Argentina', 'ARG', 032, 'SA', 12);
INSERT INTO `countries` VALUES(12, 'AS', 'American Samoa', 'American Samoa', 'Samoa Americana', 'ASM', 016, 'OC', 6);
INSERT INTO `countries` VALUES(13, 'AT', 'Austria', 'Republic of Austria', 'Austria', 'AUT', 040, 'EU', 16);
INSERT INTO `countries` VALUES(14, 'AU', 'Australia', 'Commonwealth of Australia', 'Australia', 'AUS', 036, 'OC', 15);
INSERT INTO `countries` VALUES(15, 'AW', 'Aruba', 'Aruba', 'Aruba', 'ABW', 533, 'NA', 14);
INSERT INTO `countries` VALUES(16, 'AX', 'Åland', 'Åland Islands', 'Islas Åland', 'ALA', 248, 'EU', 246);
INSERT INTO `countries` VALUES(17, 'AZ', 'Azerbaijan', 'Republic of Azerbaijan', 'Azerbaiyán', 'AZE', 031, 'AS', 17);
INSERT INTO `countries` VALUES(18, 'BA', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'Bosnia-Herzegovina', 'BIH', 070, 'EU', 29);
INSERT INTO `countries` VALUES(19, 'BB', 'Barbados', 'Barbados', 'Barbados', 'BRB', 052, 'NA', 21);
INSERT INTO `countries` VALUES(20, 'BD', 'Bangladesh', 'People''s Republic of Bangladesh', 'Bangladés', 'BGD', 050, 'AS', 20);
INSERT INTO `countries` VALUES(21, 'BE', 'Belgium', 'Kingdom of Belgium', 'Bélgica', 'BEL', 056, 'EU', 23);
INSERT INTO `countries` VALUES(22, 'BF', 'Burkina Faso', 'Burkina Faso', 'Burkina Faso', 'BFA', 854, 'AF', 37);
INSERT INTO `countries` VALUES(23, 'BG', 'Bulgaria', 'Republic of Bulgaria', 'Bulgaria', 'BGR', 100, 'EU', 36);
INSERT INTO `countries` VALUES(24, 'BH', 'Bahrain', 'Kingdom of Bahrain', 'Baréin', 'BHR', 048, 'AS', 19);
INSERT INTO `countries` VALUES(25, 'BI', 'Burundi', 'Republic of Burundi', 'Burundi', 'BDI', 108, 'AF', 38);
INSERT INTO `countries` VALUES(26, 'BJ', 'Benin', 'Republic of Benin', 'Benín', 'BEN', 204, 'AF', 25);
INSERT INTO `countries` VALUES(27, 'BL', 'Saint Barthélemy', 'Saint Barthelemy', 'San Bartolomé', 'BLM', 652, 'NA', 185);
INSERT INTO `countries` VALUES(28, 'BM', 'Bermuda', 'Bermuda', 'Bermudas', 'BMU', 060, 'NA', 26);
INSERT INTO `countries` VALUES(29, 'BN', 'Brunei Darussalam', 'Brunei Darussalam', 'Brunéi', 'BRN', 096, 'AS', 35);
INSERT INTO `countries` VALUES(30, 'BO', 'Bolivia', 'Republic of Bolivia', 'Bolivia', 'BOL', 068, 'SA', 28);
INSERT INTO `countries` VALUES(31, 'BR', 'Brazil', 'Federative Republic of Brazil', 'Brasil', 'BRA', 076, 'SA', 32);
INSERT INTO `countries` VALUES(32, 'BS', 'Bahamas', 'Commonwealth of the Bahamas', 'Bahamas', 'BHS', 044, 'NA', 18);
INSERT INTO `countries` VALUES(33, 'BT', 'Bhutan', 'Kingdom of Bhutan', 'Bután', 'BTN', 064, 'AS', 27);
INSERT INTO `countries` VALUES(34, 'BV', 'Bouvet Island', 'Bouvet Island (Bouvetoya)', 'Isla Bouvet', 'BVT', 074, 'AN', 31);
INSERT INTO `countries` VALUES(35, 'BW', 'Botswana', 'Republic of Botswana', 'Botsuana', 'BWA', 072, 'AF', 30);
INSERT INTO `countries` VALUES(36, 'BY', 'Belarus', 'Republic of Belarus', 'Bielorrusia', 'BLR', 112, 'EU', 22);
INSERT INTO `countries` VALUES(37, 'BZ', 'Belize', 'Belize', 'Belice', 'BLZ', 084, 'NA', 24);
INSERT INTO `countries` VALUES(38, 'CA', 'Canada', 'Canada', 'Canadá', 'CAN', 124, 'NA', 2);
INSERT INTO `countries` VALUES(39, 'CC', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', 'Islas Cocos', 'CCK', 166, 'AS', 48);
INSERT INTO `countries` VALUES(40, 'CD', 'Congo (Kinshasa)', 'Democratic Republic of the Congo', 'República Democrática del Congo', 'COD', 180, 'AF', 51);
INSERT INTO `countries` VALUES(41, 'CF', 'Central African Republic', 'Central African Republic', 'República Centroafricana', 'CAF', 140, 'AF', 43);
INSERT INTO `countries` VALUES(42, 'CG', 'Congo (Brazzaville)', 'Republic of the Congo', 'República del Congo', 'COG', 178, 'AF', 52);
INSERT INTO `countries` VALUES(43, 'CH', 'Switzerland', 'Swiss Confederation', 'Suiza', 'CHE', 756, 'EU', 214);
INSERT INTO `countries` VALUES(44, 'CI', 'Côte d''Ivoire', 'Republic of Cote d''Ivoire', 'Côte d’Ivoire', 'CIV', 384, 'AF', 55);
INSERT INTO `countries` VALUES(45, 'CK', 'Cook Islands', 'Cook Islands', 'Islas Cook', 'COK', 184, 'OC', 53);
INSERT INTO `countries` VALUES(46, 'CL', 'Chile', 'Republic of Chile', 'Chile', 'CHL', 152, 'SA', 45);
INSERT INTO `countries` VALUES(47, 'CM', 'Cameroon', 'Republic of Cameroon', 'Camerún', 'CMR', 120, 'AF', 40);
INSERT INTO `countries` VALUES(48, 'CN', 'China', 'People''s Republic of China', 'China', 'CHN', 156, 'AS', 46);
INSERT INTO `countries` VALUES(49, 'CO', 'Colombia', 'Republic of Colombia', 'Colombia', 'COL', 170, 'SA', 49);
INSERT INTO `countries` VALUES(50, 'CR', 'Costa Rica', 'Republic of Costa Rica', 'Costa Rica', 'CRI', 188, 'NA', 54);
INSERT INTO `countries` VALUES(51, 'CU', 'Cuba', 'Republic of Cuba', 'Cuba', 'CUB', 192, 'NA', 57);
INSERT INTO `countries` VALUES(52, 'CV', 'Cape Verde', 'Republic of Cape Verde', 'Cabo Verde', 'CPV', 132, 'AF', 41);
INSERT INTO `countries` VALUES(53, 'CX', 'Christmas Island', 'Christmas Island', 'Isla de Navidad', 'CXR', 162, 'AS', 47);
INSERT INTO `countries` VALUES(54, 'CY', 'Cyprus', 'Republic of Cyprus', 'Chipre', 'CYP', 196, 'AS', 58);
INSERT INTO `countries` VALUES(55, 'CZ', 'Czech Republic', 'Czech Republic', 'Chequia', 'CZE', 203, 'EU', 59);
INSERT INTO `countries` VALUES(56, 'DE', 'Germany', 'Federal Republic of Germany', 'Alemania', 'DEU', 276, 'EU', 82);
INSERT INTO `countries` VALUES(57, 'DJ', 'Djibouti', 'Republic of Djibouti', 'Yibuti', 'DJI', 262, 'AF', 61);
INSERT INTO `countries` VALUES(58, 'DK', 'Denmark', 'Kingdom of Denmark', 'Dinamarca', 'DNK', 208, 'EU', 60);
INSERT INTO `countries` VALUES(59, 'DM', 'Dominica', 'Commonwealth of Dominica', 'Dominica', 'DMA', 212, 'NA', 62);
INSERT INTO `countries` VALUES(60, 'DO', 'Dominican Republic', 'Dominican Republic', 'República Dominicana', 'DOM', 214, 'NA', 63);
INSERT INTO `countries` VALUES(61, 'DZ', 'Algeria', 'People''s Democratic Republic of Algeria', 'Argelia', 'DZA', 012, 'AF', 5);
INSERT INTO `countries` VALUES(62, 'EC', 'Ecuador', 'Republic of Ecuador', 'Ecuador', 'ECU', 218, 'SA', 64);
INSERT INTO `countries` VALUES(63, 'EE', 'Estonia', 'Republic of Estonia', 'Estonia', 'EST', 233, 'EU', 69);
INSERT INTO `countries` VALUES(64, 'EG', 'Egypt', 'Arab Republic of Egypt', 'Egipto', 'EGY', 818, 'AF', 65);
INSERT INTO `countries` VALUES(65, 'EH', 'Western Sahara', 'Western Sahara', 'Sáhara Occidental', 'ESH', 732, 'AF', 242);
INSERT INTO `countries` VALUES(66, 'ER', 'Eritrea', 'State of Eritrea', 'Eritrea', 'ERI', 232, 'AF', 68);
INSERT INTO `countries` VALUES(67, 'ES', 'Spain', 'Kingdom of Spain', 'España', 'ESP', 724, 'EU', 207);
INSERT INTO `countries` VALUES(68, 'ET', 'Ethiopia', 'Federal Democratic Republic of Ethiopia', 'Etiopía', 'ETH', 231, 'AF', 70);
INSERT INTO `countries` VALUES(69, 'FI', 'Finland', 'Republic of Finland', 'Finlandia', 'FIN', 246, 'EU', 74);
INSERT INTO `countries` VALUES(70, 'FJ', 'Fiji', 'Republic of the Fiji Islands', 'Fiyi', 'FJI', 242, 'OC', 73);
INSERT INTO `countries` VALUES(71, 'FK', 'Falkland Islands', 'Falkland Islands (Malvinas)', 'Islas Malvinas', 'FLK', 238, 'SA', 71);
INSERT INTO `countries` VALUES(72, 'FM', 'Micronesia', 'Federated States of Micronesia', 'Micronesia', 'FSM', 583, 'OC', 144);
INSERT INTO `countries` VALUES(73, 'FO', 'Faroe Islands', 'Faroe Islands', 'Islas Feroe', 'FRO', 234, 'EU', 72);
INSERT INTO `countries` VALUES(74, 'FR', 'France', 'French Republic', 'Francia', 'FRA', 250, 'EU', 75);
INSERT INTO `countries` VALUES(75, 'GA', 'Gabon', 'Gabonese Republic', 'Gabón', 'GAB', 266, 'AF', 79);
INSERT INTO `countries` VALUES(76, 'GB', 'United Kingdom', 'United Kingdom of Great Britain & Northern Ireland', 'Reino Unido', 'GBR', 826, 'EU', 233);
INSERT INTO `countries` VALUES(77, 'GD', 'Grenada', 'Grenada', 'Granada', 'GRD', 308, 'NA', 87);
INSERT INTO `countries` VALUES(78, 'GE', 'Georgia', 'Georgia', 'Georgia', 'GEO', 268, 'AS', 81);
INSERT INTO `countries` VALUES(79, 'GF', 'French Guiana', 'French Guiana', 'Guayana Francesa', 'GUF', 254, 'SA', 76);
INSERT INTO `countries` VALUES(80, 'GG', 'Guernsey', 'Bailiwick of Guernsey', 'Guernesey', 'GGY', 831, 'EU', 91);
INSERT INTO `countries` VALUES(81, 'GH', 'Ghana', 'Republic of Ghana', 'Ghana', 'GHA', 288, 'AF', 83);
INSERT INTO `countries` VALUES(82, 'GI', 'Gibraltar', 'Gibraltar', 'Gibraltar', 'GIB', 292, 'EU', 84);
INSERT INTO `countries` VALUES(83, 'GL', 'Greenland', 'Greenland', 'Groenlandia', 'GRL', 304, 'NA', 86);
INSERT INTO `countries` VALUES(84, 'GM', 'Gambia', 'Republic of the Gambia', 'Gambia', 'GMB', 270, 'AF', 80);
INSERT INTO `countries` VALUES(85, 'GN', 'Guinea', 'Republic of Guinea', 'Guinea', 'GIN', 324, 'AF', 92);
INSERT INTO `countries` VALUES(86, 'GP', 'Guadeloupe', 'Guadeloupe', 'Guadalupe', 'GLP', 312, 'NA', 88);
INSERT INTO `countries` VALUES(87, 'GQ', 'Equatorial Guinea', 'Republic of Equatorial Guinea', 'Guinea Ecuatorial', 'GNQ', 226, 'AF', 67);
INSERT INTO `countries` VALUES(88, 'GR', 'Greece', 'Hellenic Republic Greece', 'Grecia', 'GRC', 300, 'EU', 85);
INSERT INTO `countries` VALUES(89, 'GS', 'South Georgia and South Sandwich Islands', 'South Georgia and the South Sandwich Islands', 'Islas Georgia del Sur y Sandwich del Sur', 'SGS', 239, 'AN', 206);
INSERT INTO `countries` VALUES(90, 'GT', 'Guatemala', 'Republic of Guatemala', 'Guatemala', 'GTM', 320, 'NA', 90);
INSERT INTO `countries` VALUES(91, 'GU', 'Guam', 'Guam', 'Guam', 'GUM', 316, 'OC', 89);
INSERT INTO `countries` VALUES(92, 'GW', 'Guinea-Bissau', 'Republic of Guinea-Bissau', 'Guinea-Bisáu', 'GNB', 624, 'AF', 93);
INSERT INTO `countries` VALUES(93, 'GY', 'Guyana', 'Co-operative Republic of Guyana', 'Guyana', 'GUY', 328, 'SA', 94);
INSERT INTO `countries` VALUES(94, 'HK', 'Hong Kong', 'Hong Kong Special Administrative Region of China', 'RAE de Hong Kong (China)', 'HKG', 344, 'AS', 99);
INSERT INTO `countries` VALUES(95, 'HM', 'Heard and McDonald Islands', 'Heard Island and McDonald Islands', 'Islas Heard y McDonald', 'HMD', 334, 'AN', 96);
INSERT INTO `countries` VALUES(96, 'HN', 'Honduras', 'Republic of Honduras', 'Honduras', 'HND', 340, 'NA', 98);
INSERT INTO `countries` VALUES(97, 'HR', 'Croatia', 'Republic of Croatia', 'Croacia', 'HRV', 191, 'EU', 56);
INSERT INTO `countries` VALUES(98, 'HT', 'Haiti', 'Republic of Haiti', 'Haití', 'HTI', 332, 'NA', 95);
INSERT INTO `countries` VALUES(99, 'HU', 'Hungary', 'Republic of Hungary', 'Hungría', 'HUN', 348, 'EU', 100);
INSERT INTO `countries` VALUES(100, 'ID', 'Indonesia', 'Republic of Indonesia', 'Indonesia', 'IDN', 360, 'AS', 103);
INSERT INTO `countries` VALUES(101, 'IE', 'Ireland', 'Ireland', 'Irlanda', 'IRL', 372, 'EU', 106);
INSERT INTO `countries` VALUES(102, 'IL', 'Israel', 'State of Israel', 'Israel', 'ISR', 376, 'AS', 108);
INSERT INTO `countries` VALUES(103, 'IM', 'Isle of Man', 'Isle of Man', 'Isla de Man', 'IMN', 833, 'EU', 107);
INSERT INTO `countries` VALUES(104, 'IN', 'India', 'Republic of India', 'India', 'IND', 356, 'AS', 102);
INSERT INTO `countries` VALUES(105, 'IO', 'British Indian Ocean Territory', 'British Indian Ocean Territory (Chagos Archipelago)', 'Territorio Británico del Océano Índico', 'IOT', 086, 'AS', 33);
INSERT INTO `countries` VALUES(106, 'IQ', 'Iraq', 'Republic of Iraq', 'Irak', 'IRQ', 368, 'AS', 105);
INSERT INTO `countries` VALUES(107, 'IR', 'Iran', 'Islamic Republic of Iran', 'Irán', 'IRN', 364, 'AS', 104);
INSERT INTO `countries` VALUES(108, 'IS', 'Iceland', 'Republic of Iceland', 'Islandia', 'ISL', 352, 'EU', 101);
INSERT INTO `countries` VALUES(109, 'IT', 'Italy', 'Italian Republic', 'Italia', 'ITA', 380, 'EU', 109);
INSERT INTO `countries` VALUES(110, 'JE', 'Jersey', 'Bailiwick of Jersey', 'Jersey', 'JEY', 832, 'EU', 112);
INSERT INTO `countries` VALUES(111, 'JM', 'Jamaica', 'Jamaica', 'Jamaica', 'JAM', 388, 'NA', 110);
INSERT INTO `countries` VALUES(112, 'JO', 'Jordan', 'Hashemite Kingdom of Jordan', 'Jordania', 'JOR', 400, 'AS', 113);
INSERT INTO `countries` VALUES(113, 'JP', 'Japan', 'Japan', 'Japón', 'JPN', 392, 'AS', 111);
INSERT INTO `countries` VALUES(114, 'KE', 'Kenya', 'Republic of Kenya', 'Kenia', 'KEN', 404, 'AF', 115);
INSERT INTO `countries` VALUES(115, 'KG', 'Kyrgyzstan', 'Kyrgyz Republic', 'Kirguistán', 'KGZ', 417, 'AS', 120);
INSERT INTO `countries` VALUES(116, 'KH', 'Cambodia', 'Kingdom of Cambodia', 'Camboya', 'KHM', 116, 'AS', 39);
INSERT INTO `countries` VALUES(117, 'KI', 'Kiribati', 'Republic of Kiribati', 'Kiribati', 'KIR', 296, 'OC', 116);
INSERT INTO `countries` VALUES(118, 'KM', 'Comoros', 'Union of the Comoros', 'Comoras', 'COM', 174, 'AF', 50);
INSERT INTO `countries` VALUES(119, 'KN', 'Saint Kitts and Nevis', 'Federation of Saint Kitts and Nevis', 'San Cristóbal y Nieves', 'KNA', 659, 'NA', 187);
INSERT INTO `countries` VALUES(120, 'KP', 'Korea, North', 'Democratic People''s Republic of Korea', 'Corea del Norte', 'PRK', 408, 'AS', 117);
INSERT INTO `countries` VALUES(121, 'KR', 'Korea, South', 'Republic of Korea', 'Corea del Sur', 'KOR', 410, 'AS', 118);
INSERT INTO `countries` VALUES(122, 'KW', 'Kuwait', 'State of Kuwait', 'Kuwait', 'KWT', 414, 'AS', 119);
INSERT INTO `countries` VALUES(123, 'KY', 'Cayman Islands', 'Cayman Islands', 'Islas Caimán', 'CYM', 136, 'NA', 42);
INSERT INTO `countries` VALUES(124, 'KZ', 'Kazakhstan', 'Republic of Kazakhstan', 'Kazajistán', 'KAZ', 398, 'AS', 114);
INSERT INTO `countries` VALUES(125, 'LA', 'Laos', 'Lao People''s Democratic Republic', 'Laos', 'LAO', 418, 'AS', 121);
INSERT INTO `countries` VALUES(126, 'LB', 'Lebanon', 'Lebanese Republic', 'Líbano', 'LBN', 422, 'AS', 123);
INSERT INTO `countries` VALUES(127, 'LC', 'Saint Lucia', 'Saint Lucia', 'Santa Lucía', 'LCA', 662, 'NA', 188);
INSERT INTO `countries` VALUES(128, 'LI', 'Liechtenstein', 'Principality of Liechtenstein', 'Liechtenstein', 'LIE', 438, 'EU', 127);
INSERT INTO `countries` VALUES(129, 'LK', 'Sri Lanka', 'Democratic Socialist Republic of Sri Lanka', 'Sri Lanka', 'LKA', 144, 'AS', 208);
INSERT INTO `countries` VALUES(130, 'LR', 'Liberia', 'Republic of Liberia', 'Liberia', 'LBR', 430, 'AF', 125);
INSERT INTO `countries` VALUES(131, 'LS', 'Lesotho', 'Kingdom of Lesotho', 'Lesoto', 'LSO', 426, 'AF', 124);
INSERT INTO `countries` VALUES(132, 'LT', 'Lithuania', 'Republic of Lithuania', 'Lituania', 'LTU', 440, 'EU', 128);
INSERT INTO `countries` VALUES(133, 'LU', 'Luxembourg', 'Grand Duchy of Luxembourg', 'Luxemburgo', 'LUX', 442, 'EU', 129);
INSERT INTO `countries` VALUES(134, 'LV', 'Latvia', 'Republic of Latvia', 'Letonia', 'LVA', 428, 'EU', 122);
INSERT INTO `countries` VALUES(135, 'LY', 'Libya', 'Libyan Arab Jamahiriya', 'Libia', 'LBY', 434, 'AF', 126);
INSERT INTO `countries` VALUES(136, 'MA', 'Morocco', 'Kingdom of Morocco', 'Marruecos', 'MAR', 504, 'AF', 150);
INSERT INTO `countries` VALUES(137, 'MC', 'Monaco', 'Principality of Monaco', 'Mónaco', 'MCO', 492, 'EU', 146);
INSERT INTO `countries` VALUES(138, 'MD', 'Moldova', 'Republic of Moldova', 'Moldavia', 'MDA', 498, 'EU', 145);
INSERT INTO `countries` VALUES(139, 'ME', 'Montenegro', 'Republic of Montenegro', 'Montenegro', 'MNE', 499, 'EU', 148);
INSERT INTO `countries` VALUES(140, 'MF', 'Saint Martin (French part)', 'Saint Martin', 'San Martín', 'MAF', 663, 'NA', 189);
INSERT INTO `countries` VALUES(141, 'MG', 'Madagascar', 'Republic of Madagascar', 'Madagascar', 'MDG', 450, 'AF', 132);
INSERT INTO `countries` VALUES(142, 'MH', 'Marshall Islands', 'Republic of the Marshall Islands', 'Islas Marshall', 'MHL', 584, 'OC', 138);
INSERT INTO `countries` VALUES(143, 'MK', 'Macedonia', 'Republic of Macedonia', 'Macedonia', 'MKD', 807, 'EU', 131);
INSERT INTO `countries` VALUES(144, 'ML', 'Mali', 'Republic of Mali', 'Mali', 'MLI', 466, 'AF', 136);
INSERT INTO `countries` VALUES(145, 'MM', 'Myanmar', 'Union of Myanmar', 'Myanmar (Birmania)', 'MMR', 104, 'AS', 152);
INSERT INTO `countries` VALUES(146, 'MN', 'Mongolia', 'Mongolia', 'Mongolia', 'MNG', 496, 'AS', 147);
INSERT INTO `countries` VALUES(147, 'MO', 'Macau', 'Macao Special Administrative Region of China', 'RAE de Macao (China)', 'MAC', 446, 'AS', 130);
INSERT INTO `countries` VALUES(148, 'MP', 'Northern Mariana Islands', 'Commonwealth of the Northern Mariana Islands', 'Islas Marianas del Norte', 'MNP', 580, 'OC', 165);
INSERT INTO `countries` VALUES(149, 'MQ', 'Martinique', 'Martinique', 'Martinica', 'MTQ', 474, 'NA', 139);
INSERT INTO `countries` VALUES(150, 'MR', 'Mauritania', 'Islamic Republic of Mauritania', 'Mauritania', 'MRT', 478, 'AF', 140);
INSERT INTO `countries` VALUES(151, 'MS', 'Montserrat', 'Montserrat', 'Montserrat', 'MSR', 500, 'NA', 149);
INSERT INTO `countries` VALUES(152, 'MT', 'Malta', 'Republic of Malta', 'Malta', 'MLT', 470, 'EU', 137);
INSERT INTO `countries` VALUES(153, 'MU', 'Mauritius', 'Republic of Mauritius', 'Mauricio', 'MUS', 480, 'AF', 141);
INSERT INTO `countries` VALUES(154, 'MV', 'Maldives', 'Republic of Maldives', 'Maldivas', 'MDV', 462, 'AS', 135);
INSERT INTO `countries` VALUES(155, 'MW', 'Malawi', 'Republic of Malawi', 'Malaui', 'MWI', 454, 'AF', 133);
INSERT INTO `countries` VALUES(156, 'MX', 'Mexico', 'United Mexican States', 'México', 'MEX', 484, 'NA', 143);
INSERT INTO `countries` VALUES(157, 'MY', 'Malaysia', 'Malaysia', 'Malasia', 'MYS', 458, 'AS', 134);
INSERT INTO `countries` VALUES(158, 'MZ', 'Mozambique', 'Republic of Mozambique', 'Mozambique', 'MOZ', 508, 'AF', 151);
INSERT INTO `countries` VALUES(159, 'NA', 'Namibia', 'Republic of Namibia', 'Namibia', 'NAM', 516, 'AF', 153);
INSERT INTO `countries` VALUES(160, 'NC', 'New Caledonia', 'New Caledonia', 'Nueva Caledonia', 'NCL', 540, 'OC', 158);
INSERT INTO `countries` VALUES(161, 'NE', 'Niger', 'Republic of Niger', 'Níger', 'NER', 562, 'AF', 161);
INSERT INTO `countries` VALUES(162, 'NF', 'Norfolk Island', 'Norfolk Island', 'Isla Norfolk', 'NFK', 574, 'OC', 164);
INSERT INTO `countries` VALUES(163, 'NG', 'Nigeria', 'Federal Republic of Nigeria', 'Nigeria', 'NGA', 566, 'AF', 162);
INSERT INTO `countries` VALUES(164, 'NI', 'Nicaragua', 'Republic of Nicaragua', 'Nicaragua', 'NIC', 558, 'NA', 160);
INSERT INTO `countries` VALUES(165, 'NL', 'Netherlands', 'Kingdom of the Netherlands', 'Países Bajos', 'NLD', 528, 'EU', 156);
INSERT INTO `countries` VALUES(166, 'NO', 'Norway', 'Kingdom of Norway', 'Noruega', 'NOR', 578, 'EU', 166);
INSERT INTO `countries` VALUES(167, 'NP', 'Nepal', 'State of Nepal', 'Nepal', 'NPL', 524, 'AS', 155);
INSERT INTO `countries` VALUES(168, 'NR', 'Nauru', 'Republic of Nauru', 'Nauru', 'NRU', 520, 'OC', 154);
INSERT INTO `countries` VALUES(169, 'NU', 'Niue', 'Niue', 'Niue', 'NIU', 570, 'OC', 163);
INSERT INTO `countries` VALUES(170, 'NZ', 'New Zealand', 'New Zealand', 'Nueva Zelanda', 'NZL', 554, 'OC', 159);
INSERT INTO `countries` VALUES(171, 'OM', 'Oman', 'Sultanate of Oman', 'Omán', 'OMN', 512, 'AS', 167);
INSERT INTO `countries` VALUES(172, 'PA', 'Panama', 'Republic of Panama', 'Panamá', 'PAN', 591, 'NA', 171);
INSERT INTO `countries` VALUES(173, 'PE', 'Peru', 'Republic of Peru', 'Perú', 'PER', 604, 'SA', 174);
INSERT INTO `countries` VALUES(174, 'PF', 'French Polynesia', 'French Polynesia', 'Polinesia Francesa', 'PYF', 258, 'OC', 77);
INSERT INTO `countries` VALUES(175, 'PG', 'Papua New Guinea', 'Independent State of Papua New Guinea', 'Papúa Nueva Guinea', 'PNG', 598, 'OC', 172);
INSERT INTO `countries` VALUES(176, 'PH', 'Philippines', 'Republic of the Philippines', 'Filipinas', 'PHL', 608, 'AS', 175);
INSERT INTO `countries` VALUES(177, 'PK', 'Pakistan', 'Islamic Republic of Pakistan', 'Pakistán', 'PAK', 586, 'AS', 168);
INSERT INTO `countries` VALUES(178, 'PL', 'Poland', 'Republic of Poland', 'Polonia', 'POL', 616, 'EU', 177);
INSERT INTO `countries` VALUES(179, 'PM', 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon', 'San Pedro y Miquelón', 'SPM', 666, 'NA', 190);
INSERT INTO `countries` VALUES(180, 'PN', 'Pitcairn', 'Pitcairn Islands', 'Islas Pitcairn', 'PCN', 612, 'OC', 176);
INSERT INTO `countries` VALUES(181, 'PR', 'Puerto Rico', 'Commonwealth of Puerto Rico', 'Puerto Rico', 'PRI', 630, 'NA', 179);
INSERT INTO `countries` VALUES(182, 'PS', 'Palestine', 'Occupied Palestinian Territory', 'Territorios Palestinos', 'PSE', 275, 'AS', 170);
INSERT INTO `countries` VALUES(183, 'PT', 'Portugal', 'Portuguese Republic', 'Portugal', 'PRT', 620, 'EU', 178);
INSERT INTO `countries` VALUES(184, 'PW', 'Palau', 'Republic of Palau', 'Palaos', 'PLW', 585, 'OC', 169);
INSERT INTO `countries` VALUES(185, 'PY', 'Paraguay', 'Republic of Paraguay', 'Paraguay', 'PRY', 600, 'SA', 173);
INSERT INTO `countries` VALUES(186, 'QA', 'Qatar', 'State of Qatar', 'Catar', 'QAT', 634, 'AS', 180);
INSERT INTO `countries` VALUES(187, 'RE', 'Reunion', 'Reunion', 'Reunión', 'REU', 638, 'AF', 181);
INSERT INTO `countries` VALUES(188, 'RO', 'Romania', 'Romania', 'Rumanía', 'ROU', 642, 'EU', 182);
INSERT INTO `countries` VALUES(189, 'RS', 'Serbia', 'Republic of Serbia', 'Serbia', 'SRB', 688, 'EU', 197);
INSERT INTO `countries` VALUES(190, 'RU', 'Russian Federation', 'Russian Federation', 'Rusia', 'RUS', 643, 'EU', 183);
INSERT INTO `countries` VALUES(191, 'RW', 'Rwanda', 'Republic of Rwanda', 'Ruanda', 'RWA', 646, 'AF', 184);
INSERT INTO `countries` VALUES(192, 'SA', 'Saudi Arabia', 'Kingdom of Saudi Arabia', 'Arabia Saudí', 'SAU', 682, 'AS', 195);
INSERT INTO `countries` VALUES(193, 'SB', 'Solomon Islands', 'Solomon Islands', 'Islas Salomón', 'SLB', 090, 'OC', 203);
INSERT INTO `countries` VALUES(194, 'SC', 'Seychelles', 'Republic of Seychelles', 'Seychelles', 'SYC', 690, 'AF', 198);
INSERT INTO `countries` VALUES(195, 'SD', 'Sudan', 'Republic of Sudan', 'Sudán', 'SDN', 736, 'AF', 209);
INSERT INTO `countries` VALUES(196, 'SE', 'Sweden', 'Kingdom of Sweden', 'Suecia', 'SWE', 752, 'EU', 213);
INSERT INTO `countries` VALUES(197, 'SG', 'Singapore', 'Republic of Singapore', 'Singapur', 'SGP', 702, 'AS', 200);
INSERT INTO `countries` VALUES(198, 'SH', 'Saint Helena', 'Saint Helena', 'Santa Elena', 'SHN', 654, 'AF', 186);
INSERT INTO `countries` VALUES(199, 'SI', 'Slovenia', 'Republic of Slovenia', 'Eslovenia', 'SVN', 705, 'EU', 202);
INSERT INTO `countries` VALUES(200, 'SJ', 'Svalbard and Jan Mayen Islands', 'Svalbard & Jan Mayen Islands', 'Svalbard y Jan Mayen', 'SJM', 744, 'EU', 211);
INSERT INTO `countries` VALUES(201, 'SK', 'Slovakia', 'Slovakia (Slovak Republic)', 'Eslovaquia', 'SVK', 703, 'EU', 201);
INSERT INTO `countries` VALUES(202, 'SL', 'Sierra Leone', 'Republic of Sierra Leone', 'Sierra Leona', 'SLE', 694, 'AF', 199);
INSERT INTO `countries` VALUES(203, 'SM', 'San Marino', 'Republic of San Marino', 'San Marino', 'SMR', 674, 'EU', 193);
INSERT INTO `countries` VALUES(204, 'SN', 'Senegal', 'Republic of Senegal', 'Senegal', 'SEN', 686, 'AF', 196);
INSERT INTO `countries` VALUES(205, 'SO', 'Somalia', 'Somali Republic', 'Somalia', 'SOM', 706, 'AF', 204);
INSERT INTO `countries` VALUES(206, 'SR', 'Suriname', 'Republic of Suriname', 'Surinam', 'SUR', 740, 'SA', 210);
INSERT INTO `countries` VALUES(207, 'ST', 'Sao Tome and Principe', 'Democratic Republic of Sao Tome and Principe', 'Santo Tomé y Príncipe', 'STP', 678, 'AF', 194);
INSERT INTO `countries` VALUES(208, 'SV', 'El Salvador', 'Republic of El Salvador', 'El Salvador', 'SLV', 222, 'NA', 66);
INSERT INTO `countries` VALUES(209, 'SY', 'Syria', 'Syrian Arab Republic', 'Siria', 'SYR', 760, 'AS', 215);
INSERT INTO `countries` VALUES(210, 'SZ', 'Swaziland', 'Kingdom of Swaziland', 'Suazilandia', 'SWZ', 748, 'AF', 212);
INSERT INTO `countries` VALUES(211, 'TC', 'Turks and Caicos Islands', 'Turks and Caicos Islands', 'Islas Turcas y Caicos', 'TCA', 796, 'NA', 228);
INSERT INTO `countries` VALUES(212, 'TD', 'Chad', 'Republic of Chad', 'Chad', 'TCD', 148, 'AF', 44);
INSERT INTO `countries` VALUES(213, 'TF', 'French Southern Lands', 'French Southern Territories', 'Territorios Australes Franceses', 'ATF', 260, 'AN', 78);
INSERT INTO `countries` VALUES(214, 'TG', 'Togo', 'Togolese Republic', 'Togo', 'TGO', 768, 'AF', 221);
INSERT INTO `countries` VALUES(215, 'TH', 'Thailand', 'Kingdom of Thailand', 'Tailandia', 'THA', 764, 'AS', 219);
INSERT INTO `countries` VALUES(216, 'TJ', 'Tajikistan', 'Republic of Tajikistan', 'Tayikistán', 'TJK', 762, 'AS', 217);
INSERT INTO `countries` VALUES(217, 'TK', 'Tokelau', 'Tokelau', 'Tokelau', 'TKL', 772, 'OC', 222);
INSERT INTO `countries` VALUES(218, 'TL', 'Timor-Leste', 'Democratic Republic of Timor-Leste', 'Timor-Leste', 'TLS', 626, 'AS', 220);
INSERT INTO `countries` VALUES(219, 'TM', 'Turkmenistan', 'Turkmenistan', 'Turkmenistán', 'TKM', 795, 'AS', 227);
INSERT INTO `countries` VALUES(220, 'TN', 'Tunisia', 'Tunisian Republic', 'Túnez', 'TUN', 788, 'AF', 225);
INSERT INTO `countries` VALUES(221, 'TO', 'Tonga', 'Kingdom of Tonga', 'Tonga', 'TON', 776, 'OC', 223);
INSERT INTO `countries` VALUES(222, 'TR', 'Turkey', 'Republic of Turkey', 'Turquía', 'TUR', 792, 'AS', 226);
INSERT INTO `countries` VALUES(223, 'TT', 'Trinidad and Tobago', 'Republic of Trinidad and Tobago', 'Trinidad y Tobago', 'TTO', 780, 'NA', 224);
INSERT INTO `countries` VALUES(224, 'TV', 'Tuvalu', 'Tuvalu', 'Tuvalu', 'TUV', 798, 'OC', 229);
INSERT INTO `countries` VALUES(225, 'TW', 'Taiwan', 'Taiwan', 'Taiwán', 'TWN', 158, 'AS', 216);
INSERT INTO `countries` VALUES(226, 'TZ', 'Tanzania', 'United Republic of Tanzania', 'Tanzania', 'TZA', 834, 'AF', 218);
INSERT INTO `countries` VALUES(227, 'UA', 'Ukraine', 'Ukraine', 'Ucrania', 'UKR', 804, 'EU', 231);
INSERT INTO `countries` VALUES(228, 'UG', 'Uganda', 'Republic of Uganda', 'Uganda', 'UGA', 800, 'AF', 230);
INSERT INTO `countries` VALUES(229, 'UM', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', 'Islas menores alejadas de EE. UU.', 'UMI', 581, 'OC', 234);
INSERT INTO `countries` VALUES(230, 'US', 'United States of America', 'United States of America', 'Estados Unidos', 'USA', 840, 'NA', 1);
INSERT INTO `countries` VALUES(231, 'UY', 'Uruguay', 'Eastern Republic of Uruguay', 'Uruguay', 'URY', 858, 'SA', 236);
INSERT INTO `countries` VALUES(232, 'UZ', 'Uzbekistan', 'Republic of Uzbekistan', 'Uzbekistán', 'UZB', 860, 'AS', 237);
INSERT INTO `countries` VALUES(233, 'VA', 'Vatican City', 'Holy See (Vatican City State)', 'Ciudad del Vaticano', 'VAT', 336, 'EU', 97);
INSERT INTO `countries` VALUES(234, 'VC', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'San Vicente y las Granadinas', 'VCT', 670, 'NA', 191);
INSERT INTO `countries` VALUES(235, 'VE', 'Venezuela', 'Bolivarian Republic of Venezuela', 'Venezuela', 'VEN', 862, 'SA', 239);
INSERT INTO `countries` VALUES(236, 'VG', 'Virgin Islands, British', 'British Virgin Islands', 'Islas Vírgenes Británicas', 'VGB', 092, 'NA', 34);
INSERT INTO `countries` VALUES(237, 'VI', 'Virgin Islands, U.S.', 'United States Virgin Islands', 'Islas Vírgenes de EE. UU.', 'VIR', 850, 'NA', 235);
INSERT INTO `countries` VALUES(238, 'VN', 'Vietnam', 'Socialist Republic of Vietnam', 'Vietnam', 'VNM', 704, 'AS', 240);
INSERT INTO `countries` VALUES(239, 'VU', 'Vanuatu', 'Republic of Vanuatu', 'Vanuatu', 'VUT', 548, 'OC', 238);
INSERT INTO `countries` VALUES(240, 'WF', 'Wallis and Futuna Islands', 'Wallis and Futuna', 'Wallis y Futuna', 'WLF', 876, 'OC', 241);
INSERT INTO `countries` VALUES(241, 'WS', 'Samoa', 'Independent State of Samoa', 'Samoa', 'WSM', 882, 'OC', 192);
INSERT INTO `countries` VALUES(242, 'YE', 'Yemen', 'Yemen', 'Yemen', 'YEM', 887, 'AS', 243);
INSERT INTO `countries` VALUES(243, 'YT', 'Mayotte', 'Mayotte', 'Mayotte', 'MYT', 175, 'AF', 142);
INSERT INTO `countries` VALUES(244, 'ZA', 'South Africa', 'Republic of South Africa', 'Sudáfrica', 'ZAF', 710, 'AF', 205);
INSERT INTO `countries` VALUES(245, 'ZM', 'Zambia', 'Republic of Zambia', 'Zambia', 'ZMB', 894, 'AF', 244);
INSERT INTO `countries` VALUES(246, 'ZW', 'Zimbabwe', 'Republic of Zimbabwe', 'Zimbabue', 'ZWE', 716, 'AF', 245);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment