-
-
Save koffisani/e976749deb69c809ee6622d12b2d172f to your computer and use it in GitHub Desktop.
MySQL Dump - continents and countries with 2 and 3 char codes, names and full names - Braintree compatible as of Dec 2011
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/** | |
* 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', | |
`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', 'AND', '020', 'EU', '7'); | |
INSERT INTO `countries` VALUES ('2', 'AE', 'United Arab Emirates', 'United Arab Emirates', 'ARE', '784', 'AS', '232'); | |
INSERT INTO `countries` VALUES ('3', 'AF', 'Afghanistan', 'Islamic Republic of Afghanistan', 'AFG', '004', 'AS', '3'); | |
INSERT INTO `countries` VALUES ('4', 'AG', 'Antigua and Barbuda', 'Antigua and Barbuda', 'ATG', '028', 'NA', '11'); | |
INSERT INTO `countries` VALUES ('5', 'AI', 'Anguilla', 'Anguilla', 'AIA', '660', 'NA', '9'); | |
INSERT INTO `countries` VALUES ('6', 'AL', 'Albania', 'Republic of Albania', 'ALB', '008', 'EU', '4'); | |
INSERT INTO `countries` VALUES ('7', 'AM', 'Armenia', 'Republic of Armenia', 'ARM', '051', 'AS', '13'); | |
INSERT INTO `countries` VALUES ('8', 'AN', 'Netherlands Antilles', 'Netherlands Antilles', 'ANT', '530', 'NA', '157'); | |
INSERT INTO `countries` VALUES ('9', 'AO', 'Angola', 'Republic of Angola', 'AGO', '024', 'AF', '8'); | |
INSERT INTO `countries` VALUES ('10', 'AQ', 'Antarctica', 'Antarctica (the territory South of 60 deg S)', 'ATA', '010', 'AN', '10'); | |
INSERT INTO `countries` VALUES ('11', 'AR', 'Argentina', 'Argentine Republic', 'ARG', '032', 'SA', '12'); | |
INSERT INTO `countries` VALUES ('12', 'AS', 'American Samoa', 'American Samoa', 'ASM', '016', 'OC', '6'); | |
INSERT INTO `countries` VALUES ('13', 'AT', 'Austria', 'Republic of Austria', 'AUT', '040', 'EU', '16'); | |
INSERT INTO `countries` VALUES ('14', 'AU', 'Australia', 'Commonwealth of Australia', 'AUS', '036', 'OC', '15'); | |
INSERT INTO `countries` VALUES ('15', 'AW', 'Aruba', 'Aruba', 'ABW', '533', 'NA', '14'); | |
INSERT INTO `countries` VALUES ('16', 'AX', 'Åland', 'Åland Islands', 'ALA', '248', 'EU', '246'); | |
INSERT INTO `countries` VALUES ('17', 'AZ', 'Azerbaijan', 'Republic of Azerbaijan', 'AZE', '031', 'AS', '17'); | |
INSERT INTO `countries` VALUES ('18', 'BA', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina', 'BIH', '070', 'EU', '29'); | |
INSERT INTO `countries` VALUES ('19', 'BB', 'Barbados', 'Barbados', 'BRB', '052', 'NA', '21'); | |
INSERT INTO `countries` VALUES ('20', 'BD', 'Bangladesh', 'People\'s Republic of Bangladesh', 'BGD', '050', 'AS', '20'); | |
INSERT INTO `countries` VALUES ('21', 'BE', 'Belgium', 'Kingdom of Belgium', 'BEL', '056', 'EU', '23'); | |
INSERT INTO `countries` VALUES ('22', 'BF', 'Burkina Faso', 'Burkina Faso', 'BFA', '854', 'AF', '37'); | |
INSERT INTO `countries` VALUES ('23', 'BG', 'Bulgaria', 'Republic of Bulgaria', 'BGR', '100', 'EU', '36'); | |
INSERT INTO `countries` VALUES ('24', 'BH', 'Bahrain', 'Kingdom of Bahrain', 'BHR', '048', 'AS', '19'); | |
INSERT INTO `countries` VALUES ('25', 'BI', 'Burundi', 'Republic of Burundi', 'BDI', '108', 'AF', '38'); | |
INSERT INTO `countries` VALUES ('26', 'BJ', 'Benin', 'Republic of Benin', 'BEN', '204', 'AF', '25'); | |
INSERT INTO `countries` VALUES ('27', 'BL', 'Saint Barthélemy', 'Saint Barthelemy', 'BLM', '652', 'NA', '185'); | |
INSERT INTO `countries` VALUES ('28', 'BM', 'Bermuda', 'Bermuda', 'BMU', '060', 'NA', '26'); | |
INSERT INTO `countries` VALUES ('29', 'BN', 'Brunei Darussalam', 'Brunei Darussalam', 'BRN', '096', 'AS', '35'); | |
INSERT INTO `countries` VALUES ('30', 'BO', 'Bolivia', 'Republic of Bolivia', 'BOL', '068', 'SA', '28'); | |
INSERT INTO `countries` VALUES ('31', 'BR', 'Brazil', 'Federative Republic of Brazil', 'BRA', '076', 'SA', '32'); | |
INSERT INTO `countries` VALUES ('32', 'BS', 'Bahamas', 'Commonwealth of the Bahamas', 'BHS', '044', 'NA', '18'); | |
INSERT INTO `countries` VALUES ('33', 'BT', 'Bhutan', 'Kingdom of Bhutan', 'BTN', '064', 'AS', '27'); | |
INSERT INTO `countries` VALUES ('34', 'BV', 'Bouvet Island', 'Bouvet Island (Bouvetoya)', 'BVT', '074', 'AN', '31'); | |
INSERT INTO `countries` VALUES ('35', 'BW', 'Botswana', 'Republic of Botswana', 'BWA', '072', 'AF', '30'); | |
INSERT INTO `countries` VALUES ('36', 'BY', 'Belarus', 'Republic of Belarus', 'BLR', '112', 'EU', '22'); | |
INSERT INTO `countries` VALUES ('37', 'BZ', 'Belize', 'Belize', 'BLZ', '084', 'NA', '24'); | |
INSERT INTO `countries` VALUES ('38', 'CA', 'Canada', 'Canada', 'CAN', '124', 'NA', '2'); | |
INSERT INTO `countries` VALUES ('39', 'CC', 'Cocos (Keeling) Islands', 'Cocos (Keeling) Islands', 'CCK', '166', 'AS', '48'); | |
INSERT INTO `countries` VALUES ('40', 'CD', 'Congo (Kinshasa)', 'Democratic Republic of the Congo', 'COD', '180', 'AF', '51'); | |
INSERT INTO `countries` VALUES ('41', 'CF', 'Central African Republic', 'Central African Republic', 'CAF', '140', 'AF', '43'); | |
INSERT INTO `countries` VALUES ('42', 'CG', 'Congo (Brazzaville)', 'Republic of the Congo', 'COG', '178', 'AF', '52'); | |
INSERT INTO `countries` VALUES ('43', 'CH', 'Switzerland', 'Swiss Confederation', 'CHE', '756', 'EU', '214'); | |
INSERT INTO `countries` VALUES ('44', 'CI', 'Côte d\'Ivoire', 'Republic of Cote d\'Ivoire', 'CIV', '384', 'AF', '55'); | |
INSERT INTO `countries` VALUES ('45', 'CK', 'Cook Islands', 'Cook Islands', 'COK', '184', 'OC', '53'); | |
INSERT INTO `countries` VALUES ('46', 'CL', 'Chile', 'Republic of Chile', 'CHL', '152', 'SA', '45'); | |
INSERT INTO `countries` VALUES ('47', 'CM', 'Cameroon', 'Republic of Cameroon', 'CMR', '120', 'AF', '40'); | |
INSERT INTO `countries` VALUES ('48', 'CN', 'China', 'People\'s Republic of China', 'CHN', '156', 'AS', '46'); | |
INSERT INTO `countries` VALUES ('49', 'CO', 'Colombia', 'Republic of Colombia', 'COL', '170', 'SA', '49'); | |
INSERT INTO `countries` VALUES ('50', 'CR', 'Costa Rica', 'Republic of Costa Rica', 'CRI', '188', 'NA', '54'); | |
INSERT INTO `countries` VALUES ('51', 'CU', 'Cuba', 'Republic of Cuba', 'CUB', '192', 'NA', '57'); | |
INSERT INTO `countries` VALUES ('52', 'CV', 'Cape Verde', 'Republic of Cape Verde', 'CPV', '132', 'AF', '41'); | |
INSERT INTO `countries` VALUES ('53', 'CX', 'Christmas Island', 'Christmas Island', 'CXR', '162', 'AS', '47'); | |
INSERT INTO `countries` VALUES ('54', 'CY', 'Cyprus', 'Republic of Cyprus', 'CYP', '196', 'AS', '58'); | |
INSERT INTO `countries` VALUES ('55', 'CZ', 'Czech Republic', 'Czech Republic', 'CZE', '203', 'EU', '59'); | |
INSERT INTO `countries` VALUES ('56', 'DE', 'Germany', 'Federal Republic of Germany', 'DEU', '276', 'EU', '82'); | |
INSERT INTO `countries` VALUES ('57', 'DJ', 'Djibouti', 'Republic of Djibouti', 'DJI', '262', 'AF', '61'); | |
INSERT INTO `countries` VALUES ('58', 'DK', 'Denmark', 'Kingdom of Denmark', 'DNK', '208', 'EU', '60'); | |
INSERT INTO `countries` VALUES ('59', 'DM', 'Dominica', 'Commonwealth of Dominica', 'DMA', '212', 'NA', '62'); | |
INSERT INTO `countries` VALUES ('60', 'DO', 'Dominican Republic', 'Dominican Republic', 'DOM', '214', 'NA', '63'); | |
INSERT INTO `countries` VALUES ('61', 'DZ', 'Algeria', 'People\'s Democratic Republic of Algeria', 'DZA', '012', 'AF', '5'); | |
INSERT INTO `countries` VALUES ('62', 'EC', 'Ecuador', 'Republic of Ecuador', 'ECU', '218', 'SA', '64'); | |
INSERT INTO `countries` VALUES ('63', 'EE', 'Estonia', 'Republic of Estonia', 'EST', '233', 'EU', '69'); | |
INSERT INTO `countries` VALUES ('64', 'EG', 'Egypt', 'Arab Republic of Egypt', 'EGY', '818', 'AF', '65'); | |
INSERT INTO `countries` VALUES ('65', 'EH', 'Western Sahara', 'Western Sahara', 'ESH', '732', 'AF', '242'); | |
INSERT INTO `countries` VALUES ('66', 'ER', 'Eritrea', 'State of Eritrea', 'ERI', '232', 'AF', '68'); | |
INSERT INTO `countries` VALUES ('67', 'ES', 'Spain', 'Kingdom of Spain', 'ESP', '724', 'EU', '207'); | |
INSERT INTO `countries` VALUES ('68', 'ET', 'Ethiopia', 'Federal Democratic Republic of Ethiopia', 'ETH', '231', 'AF', '70'); | |
INSERT INTO `countries` VALUES ('69', 'FI', 'Finland', 'Republic of Finland', 'FIN', '246', 'EU', '74'); | |
INSERT INTO `countries` VALUES ('70', 'FJ', 'Fiji', 'Republic of the Fiji Islands', 'FJI', '242', 'OC', '73'); | |
INSERT INTO `countries` VALUES ('71', 'FK', 'Falkland Islands', 'Falkland Islands (Malvinas)', 'FLK', '238', 'SA', '71'); | |
INSERT INTO `countries` VALUES ('72', 'FM', 'Micronesia', 'Federated States of Micronesia', 'FSM', '583', 'OC', '144'); | |
INSERT INTO `countries` VALUES ('73', 'FO', 'Faroe Islands', 'Faroe Islands', 'FRO', '234', 'EU', '72'); | |
INSERT INTO `countries` VALUES ('74', 'FR', 'France', 'French Republic', 'FRA', '250', 'EU', '75'); | |
INSERT INTO `countries` VALUES ('75', 'GA', 'Gabon', 'Gabonese Republic', 'GAB', '266', 'AF', '79'); | |
INSERT INTO `countries` VALUES ('76', 'GB', 'United Kingdom', 'United Kingdom of Great Britain & Northern Ireland', 'GBR', '826', 'EU', '233'); | |
INSERT INTO `countries` VALUES ('77', 'GD', 'Grenada', 'Grenada', 'GRD', '308', 'NA', '87'); | |
INSERT INTO `countries` VALUES ('78', 'GE', 'Georgia', 'Georgia', 'GEO', '268', 'AS', '81'); | |
INSERT INTO `countries` VALUES ('79', 'GF', 'French Guiana', 'French Guiana', 'GUF', '254', 'SA', '76'); | |
INSERT INTO `countries` VALUES ('80', 'GG', 'Guernsey', 'Bailiwick of Guernsey', 'GGY', '831', 'EU', '91'); | |
INSERT INTO `countries` VALUES ('81', 'GH', 'Ghana', 'Republic of Ghana', 'GHA', '288', 'AF', '83'); | |
INSERT INTO `countries` VALUES ('82', 'GI', 'Gibraltar', 'Gibraltar', 'GIB', '292', 'EU', '84'); | |
INSERT INTO `countries` VALUES ('83', 'GL', 'Greenland', 'Greenland', 'GRL', '304', 'NA', '86'); | |
INSERT INTO `countries` VALUES ('84', 'GM', 'Gambia', 'Republic of the Gambia', 'GMB', '270', 'AF', '80'); | |
INSERT INTO `countries` VALUES ('85', 'GN', 'Guinea', 'Republic of Guinea', 'GIN', '324', 'AF', '92'); | |
INSERT INTO `countries` VALUES ('86', 'GP', 'Guadeloupe', 'Guadeloupe', 'GLP', '312', 'NA', '88'); | |
INSERT INTO `countries` VALUES ('87', 'GQ', 'Equatorial Guinea', 'Republic of Equatorial Guinea', 'GNQ', '226', 'AF', '67'); | |
INSERT INTO `countries` VALUES ('88', 'GR', 'Greece', 'Hellenic Republic Greece', 'GRC', '300', 'EU', '85'); | |
INSERT INTO `countries` VALUES ('89', 'GS', 'South Georgia and South Sandwich Islands', 'South Georgia and the South Sandwich Islands', 'SGS', '239', 'AN', '206'); | |
INSERT INTO `countries` VALUES ('90', 'GT', 'Guatemala', 'Republic of Guatemala', 'GTM', '320', 'NA', '90'); | |
INSERT INTO `countries` VALUES ('91', 'GU', 'Guam', 'Guam', 'GUM', '316', 'OC', '89'); | |
INSERT INTO `countries` VALUES ('92', 'GW', 'Guinea-Bissau', 'Republic of Guinea-Bissau', 'GNB', '624', 'AF', '93'); | |
INSERT INTO `countries` VALUES ('93', 'GY', 'Guyana', 'Co-operative Republic of Guyana', 'GUY', '328', 'SA', '94'); | |
INSERT INTO `countries` VALUES ('94', 'HK', 'Hong Kong', 'Hong Kong Special Administrative Region of China', 'HKG', '344', 'AS', '99'); | |
INSERT INTO `countries` VALUES ('95', 'HM', 'Heard and McDonald Islands', 'Heard Island and McDonald Islands', 'HMD', '334', 'AN', '96'); | |
INSERT INTO `countries` VALUES ('96', 'HN', 'Honduras', 'Republic of Honduras', 'HND', '340', 'NA', '98'); | |
INSERT INTO `countries` VALUES ('97', 'HR', 'Croatia', 'Republic of Croatia', 'HRV', '191', 'EU', '56'); | |
INSERT INTO `countries` VALUES ('98', 'HT', 'Haiti', 'Republic of Haiti', 'HTI', '332', 'NA', '95'); | |
INSERT INTO `countries` VALUES ('99', 'HU', 'Hungary', 'Republic of Hungary', 'HUN', '348', 'EU', '100'); | |
INSERT INTO `countries` VALUES ('100', 'ID', 'Indonesia', 'Republic of Indonesia', 'IDN', '360', 'AS', '103'); | |
INSERT INTO `countries` VALUES ('101', 'IE', 'Ireland', 'Ireland', 'IRL', '372', 'EU', '106'); | |
INSERT INTO `countries` VALUES ('102', 'IL', 'Israel', 'State of Israel', 'ISR', '376', 'AS', '108'); | |
INSERT INTO `countries` VALUES ('103', 'IM', 'Isle of Man', 'Isle of Man', 'IMN', '833', 'EU', '107'); | |
INSERT INTO `countries` VALUES ('104', 'IN', 'India', 'Republic of India', 'IND', '356', 'AS', '102'); | |
INSERT INTO `countries` VALUES ('105', 'IO', 'British Indian Ocean Territory', 'British Indian Ocean Territory (Chagos Archipelago)', 'IOT', '086', 'AS', '33'); | |
INSERT INTO `countries` VALUES ('106', 'IQ', 'Iraq', 'Republic of Iraq', 'IRQ', '368', 'AS', '105'); | |
INSERT INTO `countries` VALUES ('107', 'IR', 'Iran', 'Islamic Republic of Iran', 'IRN', '364', 'AS', '104'); | |
INSERT INTO `countries` VALUES ('108', 'IS', 'Iceland', 'Republic of Iceland', 'ISL', '352', 'EU', '101'); | |
INSERT INTO `countries` VALUES ('109', 'IT', 'Italy', 'Italian Republic', 'ITA', '380', 'EU', '109'); | |
INSERT INTO `countries` VALUES ('110', 'JE', 'Jersey', 'Bailiwick of Jersey', 'JEY', '832', 'EU', '112'); | |
INSERT INTO `countries` VALUES ('111', 'JM', 'Jamaica', 'Jamaica', 'JAM', '388', 'NA', '110'); | |
INSERT INTO `countries` VALUES ('112', 'JO', 'Jordan', 'Hashemite Kingdom of Jordan', 'JOR', '400', 'AS', '113'); | |
INSERT INTO `countries` VALUES ('113', 'JP', 'Japan', 'Japan', 'JPN', '392', 'AS', '111'); | |
INSERT INTO `countries` VALUES ('114', 'KE', 'Kenya', 'Republic of Kenya', 'KEN', '404', 'AF', '115'); | |
INSERT INTO `countries` VALUES ('115', 'KG', 'Kyrgyzstan', 'Kyrgyz Republic', 'KGZ', '417', 'AS', '120'); | |
INSERT INTO `countries` VALUES ('116', 'KH', 'Cambodia', 'Kingdom of Cambodia', 'KHM', '116', 'AS', '39'); | |
INSERT INTO `countries` VALUES ('117', 'KI', 'Kiribati', 'Republic of Kiribati', 'KIR', '296', 'OC', '116'); | |
INSERT INTO `countries` VALUES ('118', 'KM', 'Comoros', 'Union of the Comoros', 'COM', '174', 'AF', '50'); | |
INSERT INTO `countries` VALUES ('119', 'KN', 'Saint Kitts and Nevis', 'Federation of Saint Kitts and Nevis', 'KNA', '659', 'NA', '187'); | |
INSERT INTO `countries` VALUES ('120', 'KP', 'Korea, North', 'Democratic People\'s Republic of Korea', 'PRK', '408', 'AS', '117'); | |
INSERT INTO `countries` VALUES ('121', 'KR', 'Korea, South', 'Republic of Korea', 'KOR', '410', 'AS', '118'); | |
INSERT INTO `countries` VALUES ('122', 'KW', 'Kuwait', 'State of Kuwait', 'KWT', '414', 'AS', '119'); | |
INSERT INTO `countries` VALUES ('123', 'KY', 'Cayman Islands', 'Cayman Islands', 'CYM', '136', 'NA', '42'); | |
INSERT INTO `countries` VALUES ('124', 'KZ', 'Kazakhstan', 'Republic of Kazakhstan', 'KAZ', '398', 'AS', '114'); | |
INSERT INTO `countries` VALUES ('125', 'LA', 'Laos', 'Lao People\'s Democratic Republic', 'LAO', '418', 'AS', '121'); | |
INSERT INTO `countries` VALUES ('126', 'LB', 'Lebanon', 'Lebanese Republic', 'LBN', '422', 'AS', '123'); | |
INSERT INTO `countries` VALUES ('127', 'LC', 'Saint Lucia', 'Saint Lucia', 'LCA', '662', 'NA', '188'); | |
INSERT INTO `countries` VALUES ('128', 'LI', 'Liechtenstein', 'Principality of Liechtenstein', 'LIE', '438', 'EU', '127'); | |
INSERT INTO `countries` VALUES ('129', 'LK', 'Sri Lanka', 'Democratic Socialist Republic of Sri Lanka', 'LKA', '144', 'AS', '208'); | |
INSERT INTO `countries` VALUES ('130', 'LR', 'Liberia', 'Republic of Liberia', 'LBR', '430', 'AF', '125'); | |
INSERT INTO `countries` VALUES ('131', 'LS', 'Lesotho', 'Kingdom of Lesotho', 'LSO', '426', 'AF', '124'); | |
INSERT INTO `countries` VALUES ('132', 'LT', 'Lithuania', 'Republic of Lithuania', 'LTU', '440', 'EU', '128'); | |
INSERT INTO `countries` VALUES ('133', 'LU', 'Luxembourg', 'Grand Duchy of Luxembourg', 'LUX', '442', 'EU', '129'); | |
INSERT INTO `countries` VALUES ('134', 'LV', 'Latvia', 'Republic of Latvia', 'LVA', '428', 'EU', '122'); | |
INSERT INTO `countries` VALUES ('135', 'LY', 'Libya', 'Libyan Arab Jamahiriya', 'LBY', '434', 'AF', '126'); | |
INSERT INTO `countries` VALUES ('136', 'MA', 'Morocco', 'Kingdom of Morocco', 'MAR', '504', 'AF', '150'); | |
INSERT INTO `countries` VALUES ('137', 'MC', 'Monaco', 'Principality of Monaco', 'MCO', '492', 'EU', '146'); | |
INSERT INTO `countries` VALUES ('138', 'MD', 'Moldova', 'Republic of Moldova', 'MDA', '498', 'EU', '145'); | |
INSERT INTO `countries` VALUES ('139', 'ME', 'Montenegro', 'Republic of Montenegro', 'MNE', '499', 'EU', '148'); | |
INSERT INTO `countries` VALUES ('140', 'MF', 'Saint Martin (French part)', 'Saint Martin', 'MAF', '663', 'NA', '189'); | |
INSERT INTO `countries` VALUES ('141', 'MG', 'Madagascar', 'Republic of Madagascar', 'MDG', '450', 'AF', '132'); | |
INSERT INTO `countries` VALUES ('142', 'MH', 'Marshall Islands', 'Republic of the Marshall Islands', 'MHL', '584', 'OC', '138'); | |
INSERT INTO `countries` VALUES ('143', 'MK', 'Macedonia', 'Republic of Macedonia', 'MKD', '807', 'EU', '131'); | |
INSERT INTO `countries` VALUES ('144', 'ML', 'Mali', 'Republic of Mali', 'MLI', '466', 'AF', '136'); | |
INSERT INTO `countries` VALUES ('145', 'MM', 'Myanmar', 'Union of Myanmar', 'MMR', '104', 'AS', '152'); | |
INSERT INTO `countries` VALUES ('146', 'MN', 'Mongolia', 'Mongolia', 'MNG', '496', 'AS', '147'); | |
INSERT INTO `countries` VALUES ('147', 'MO', 'Macau', 'Macao Special Administrative Region of China', 'MAC', '446', 'AS', '130'); | |
INSERT INTO `countries` VALUES ('148', 'MP', 'Northern Mariana Islands', 'Commonwealth of the Northern Mariana Islands', 'MNP', '580', 'OC', '165'); | |
INSERT INTO `countries` VALUES ('149', 'MQ', 'Martinique', 'Martinique', 'MTQ', '474', 'NA', '139'); | |
INSERT INTO `countries` VALUES ('150', 'MR', 'Mauritania', 'Islamic Republic of Mauritania', 'MRT', '478', 'AF', '140'); | |
INSERT INTO `countries` VALUES ('151', 'MS', 'Montserrat', 'Montserrat', 'MSR', '500', 'NA', '149'); | |
INSERT INTO `countries` VALUES ('152', 'MT', 'Malta', 'Republic of Malta', 'MLT', '470', 'EU', '137'); | |
INSERT INTO `countries` VALUES ('153', 'MU', 'Mauritius', 'Republic of Mauritius', 'MUS', '480', 'AF', '141'); | |
INSERT INTO `countries` VALUES ('154', 'MV', 'Maldives', 'Republic of Maldives', 'MDV', '462', 'AS', '135'); | |
INSERT INTO `countries` VALUES ('155', 'MW', 'Malawi', 'Republic of Malawi', 'MWI', '454', 'AF', '133'); | |
INSERT INTO `countries` VALUES ('156', 'MX', 'Mexico', 'United Mexican States', 'MEX', '484', 'NA', '143'); | |
INSERT INTO `countries` VALUES ('157', 'MY', 'Malaysia', 'Malaysia', 'MYS', '458', 'AS', '134'); | |
INSERT INTO `countries` VALUES ('158', 'MZ', 'Mozambique', 'Republic of Mozambique', 'MOZ', '508', 'AF', '151'); | |
INSERT INTO `countries` VALUES ('159', 'NA', 'Namibia', 'Republic of Namibia', 'NAM', '516', 'AF', '153'); | |
INSERT INTO `countries` VALUES ('160', 'NC', 'New Caledonia', 'New Caledonia', 'NCL', '540', 'OC', '158'); | |
INSERT INTO `countries` VALUES ('161', 'NE', 'Niger', 'Republic of Niger', 'NER', '562', 'AF', '161'); | |
INSERT INTO `countries` VALUES ('162', 'NF', 'Norfolk Island', 'Norfolk Island', 'NFK', '574', 'OC', '164'); | |
INSERT INTO `countries` VALUES ('163', 'NG', 'Nigeria', 'Federal Republic of Nigeria', 'NGA', '566', 'AF', '162'); | |
INSERT INTO `countries` VALUES ('164', 'NI', 'Nicaragua', 'Republic of Nicaragua', 'NIC', '558', 'NA', '160'); | |
INSERT INTO `countries` VALUES ('165', 'NL', 'Netherlands', 'Kingdom of the Netherlands', 'NLD', '528', 'EU', '156'); | |
INSERT INTO `countries` VALUES ('166', 'NO', 'Norway', 'Kingdom of Norway', 'NOR', '578', 'EU', '166'); | |
INSERT INTO `countries` VALUES ('167', 'NP', 'Nepal', 'State of Nepal', 'NPL', '524', 'AS', '155'); | |
INSERT INTO `countries` VALUES ('168', 'NR', 'Nauru', 'Republic of Nauru', 'NRU', '520', 'OC', '154'); | |
INSERT INTO `countries` VALUES ('169', 'NU', 'Niue', 'Niue', 'NIU', '570', 'OC', '163'); | |
INSERT INTO `countries` VALUES ('170', 'NZ', 'New Zealand', 'New Zealand', 'NZL', '554', 'OC', '159'); | |
INSERT INTO `countries` VALUES ('171', 'OM', 'Oman', 'Sultanate of Oman', 'OMN', '512', 'AS', '167'); | |
INSERT INTO `countries` VALUES ('172', 'PA', 'Panama', 'Republic of Panama', 'PAN', '591', 'NA', '171'); | |
INSERT INTO `countries` VALUES ('173', 'PE', 'Peru', 'Republic of Peru', 'PER', '604', 'SA', '174'); | |
INSERT INTO `countries` VALUES ('174', 'PF', 'French Polynesia', 'French Polynesia', 'PYF', '258', 'OC', '77'); | |
INSERT INTO `countries` VALUES ('175', 'PG', 'Papua New Guinea', 'Independent State of Papua New Guinea', 'PNG', '598', 'OC', '172'); | |
INSERT INTO `countries` VALUES ('176', 'PH', 'Philippines', 'Republic of the Philippines', 'PHL', '608', 'AS', '175'); | |
INSERT INTO `countries` VALUES ('177', 'PK', 'Pakistan', 'Islamic Republic of Pakistan', 'PAK', '586', 'AS', '168'); | |
INSERT INTO `countries` VALUES ('178', 'PL', 'Poland', 'Republic of Poland', 'POL', '616', 'EU', '177'); | |
INSERT INTO `countries` VALUES ('179', 'PM', 'Saint Pierre and Miquelon', 'Saint Pierre and Miquelon', 'SPM', '666', 'NA', '190'); | |
INSERT INTO `countries` VALUES ('180', 'PN', 'Pitcairn', 'Pitcairn Islands', 'PCN', '612', 'OC', '176'); | |
INSERT INTO `countries` VALUES ('181', 'PR', 'Puerto Rico', 'Commonwealth of Puerto Rico', 'PRI', '630', 'NA', '179'); | |
INSERT INTO `countries` VALUES ('182', 'PS', 'Palestine', 'Occupied Palestinian Territory', 'PSE', '275', 'AS', '170'); | |
INSERT INTO `countries` VALUES ('183', 'PT', 'Portugal', 'Portuguese Republic', 'PRT', '620', 'EU', '178'); | |
INSERT INTO `countries` VALUES ('184', 'PW', 'Palau', 'Republic of Palau', 'PLW', '585', 'OC', '169'); | |
INSERT INTO `countries` VALUES ('185', 'PY', 'Paraguay', 'Republic of Paraguay', 'PRY', '600', 'SA', '173'); | |
INSERT INTO `countries` VALUES ('186', 'QA', 'Qatar', 'State of Qatar', 'QAT', '634', 'AS', '180'); | |
INSERT INTO `countries` VALUES ('187', 'RE', 'Reunion', 'Reunion', 'REU', '638', 'AF', '181'); | |
INSERT INTO `countries` VALUES ('188', 'RO', 'Romania', 'Romania', 'ROU', '642', 'EU', '182'); | |
INSERT INTO `countries` VALUES ('189', 'RS', 'Serbia', 'Republic of Serbia', 'SRB', '688', 'EU', '197'); | |
INSERT INTO `countries` VALUES ('190', 'RU', 'Russian Federation', 'Russian Federation', 'RUS', '643', 'EU', '183'); | |
INSERT INTO `countries` VALUES ('191', 'RW', 'Rwanda', 'Republic of Rwanda', 'RWA', '646', 'AF', '184'); | |
INSERT INTO `countries` VALUES ('192', 'SA', 'Saudi Arabia', 'Kingdom of Saudi Arabia', 'SAU', '682', 'AS', '195'); | |
INSERT INTO `countries` VALUES ('193', 'SB', 'Solomon Islands', 'Solomon Islands', 'SLB', '090', 'OC', '203'); | |
INSERT INTO `countries` VALUES ('194', 'SC', 'Seychelles', 'Republic of Seychelles', 'SYC', '690', 'AF', '198'); | |
INSERT INTO `countries` VALUES ('195', 'SD', 'Sudan', 'Republic of Sudan', 'SDN', '736', 'AF', '209'); | |
INSERT INTO `countries` VALUES ('196', 'SE', 'Sweden', 'Kingdom of Sweden', 'SWE', '752', 'EU', '213'); | |
INSERT INTO `countries` VALUES ('197', 'SG', 'Singapore', 'Republic of Singapore', 'SGP', '702', 'AS', '200'); | |
INSERT INTO `countries` VALUES ('198', 'SH', 'Saint Helena', 'Saint Helena', 'SHN', '654', 'AF', '186'); | |
INSERT INTO `countries` VALUES ('199', 'SI', 'Slovenia', 'Republic of Slovenia', 'SVN', '705', 'EU', '202'); | |
INSERT INTO `countries` VALUES ('200', 'SJ', 'Svalbard and Jan Mayen Islands', 'Svalbard & Jan Mayen Islands', 'SJM', '744', 'EU', '211'); | |
INSERT INTO `countries` VALUES ('201', 'SK', 'Slovakia', 'Slovakia (Slovak Republic)', 'SVK', '703', 'EU', '201'); | |
INSERT INTO `countries` VALUES ('202', 'SL', 'Sierra Leone', 'Republic of Sierra Leone', 'SLE', '694', 'AF', '199'); | |
INSERT INTO `countries` VALUES ('203', 'SM', 'San Marino', 'Republic of San Marino', 'SMR', '674', 'EU', '193'); | |
INSERT INTO `countries` VALUES ('204', 'SN', 'Senegal', 'Republic of Senegal', 'SEN', '686', 'AF', '196'); | |
INSERT INTO `countries` VALUES ('205', 'SO', 'Somalia', 'Somali Republic', 'SOM', '706', 'AF', '204'); | |
INSERT INTO `countries` VALUES ('206', 'SR', 'Suriname', 'Republic of Suriname', 'SUR', '740', 'SA', '210'); | |
INSERT INTO `countries` VALUES ('207', 'ST', 'Sao Tome and Principe', 'Democratic Republic of Sao Tome and Principe', 'STP', '678', 'AF', '194'); | |
INSERT INTO `countries` VALUES ('208', 'SV', 'El Salvador', 'Republic of El Salvador', 'SLV', '222', 'NA', '66'); | |
INSERT INTO `countries` VALUES ('209', 'SY', 'Syria', 'Syrian Arab Republic', 'SYR', '760', 'AS', '215'); | |
INSERT INTO `countries` VALUES ('210', 'SZ', 'Swaziland', 'Kingdom of Swaziland', 'SWZ', '748', 'AF', '212'); | |
INSERT INTO `countries` VALUES ('211', 'TC', 'Turks and Caicos Islands', 'Turks and Caicos Islands', 'TCA', '796', 'NA', '228'); | |
INSERT INTO `countries` VALUES ('212', 'TD', 'Chad', 'Republic of Chad', 'TCD', '148', 'AF', '44'); | |
INSERT INTO `countries` VALUES ('213', 'TF', 'French Southern Lands', 'French Southern Territories', 'ATF', '260', 'AN', '78'); | |
INSERT INTO `countries` VALUES ('214', 'TG', 'Togo', 'Togolese Republic', 'TGO', '768', 'AF', '221'); | |
INSERT INTO `countries` VALUES ('215', 'TH', 'Thailand', 'Kingdom of Thailand', 'THA', '764', 'AS', '219'); | |
INSERT INTO `countries` VALUES ('216', 'TJ', 'Tajikistan', 'Republic of Tajikistan', 'TJK', '762', 'AS', '217'); | |
INSERT INTO `countries` VALUES ('217', 'TK', 'Tokelau', 'Tokelau', 'TKL', '772', 'OC', '222'); | |
INSERT INTO `countries` VALUES ('218', 'TL', 'Timor-Leste', 'Democratic Republic of Timor-Leste', 'TLS', '626', 'AS', '220'); | |
INSERT INTO `countries` VALUES ('219', 'TM', 'Turkmenistan', 'Turkmenistan', 'TKM', '795', 'AS', '227'); | |
INSERT INTO `countries` VALUES ('220', 'TN', 'Tunisia', 'Tunisian Republic', 'TUN', '788', 'AF', '225'); | |
INSERT INTO `countries` VALUES ('221', 'TO', 'Tonga', 'Kingdom of Tonga', 'TON', '776', 'OC', '223'); | |
INSERT INTO `countries` VALUES ('222', 'TR', 'Turkey', 'Republic of Turkey', 'TUR', '792', 'AS', '226'); | |
INSERT INTO `countries` VALUES ('223', 'TT', 'Trinidad and Tobago', 'Republic of Trinidad and Tobago', 'TTO', '780', 'NA', '224'); | |
INSERT INTO `countries` VALUES ('224', 'TV', 'Tuvalu', 'Tuvalu', 'TUV', '798', 'OC', '229'); | |
INSERT INTO `countries` VALUES ('225', 'TW', 'Taiwan', 'Taiwan', 'TWN', '158', 'AS', '216'); | |
INSERT INTO `countries` VALUES ('226', 'TZ', 'Tanzania', 'United Republic of Tanzania', 'TZA', '834', 'AF', '218'); | |
INSERT INTO `countries` VALUES ('227', 'UA', 'Ukraine', 'Ukraine', 'UKR', '804', 'EU', '231'); | |
INSERT INTO `countries` VALUES ('228', 'UG', 'Uganda', 'Republic of Uganda', 'UGA', '800', 'AF', '230'); | |
INSERT INTO `countries` VALUES ('229', 'UM', 'United States Minor Outlying Islands', 'United States Minor Outlying Islands', 'UMI', '581', 'OC', '234'); | |
INSERT INTO `countries` VALUES ('230', 'US', 'United States of America', 'United States of America', 'USA', '840', 'NA', '1'); | |
INSERT INTO `countries` VALUES ('231', 'UY', 'Uruguay', 'Eastern Republic of Uruguay', 'URY', '858', 'SA', '236'); | |
INSERT INTO `countries` VALUES ('232', 'UZ', 'Uzbekistan', 'Republic of Uzbekistan', 'UZB', '860', 'AS', '237'); | |
INSERT INTO `countries` VALUES ('233', 'VA', 'Vatican City', 'Holy See (Vatican City State)', 'VAT', '336', 'EU', '97'); | |
INSERT INTO `countries` VALUES ('234', 'VC', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'VCT', '670', 'NA', '191'); | |
INSERT INTO `countries` VALUES ('235', 'VE', 'Venezuela', 'Bolivarian Republic of Venezuela', 'VEN', '862', 'SA', '239'); | |
INSERT INTO `countries` VALUES ('236', 'VG', 'Virgin Islands, British', 'British Virgin Islands', 'VGB', '092', 'NA', '34'); | |
INSERT INTO `countries` VALUES ('237', 'VI', 'Virgin Islands, U.S.', 'United States Virgin Islands', 'VIR', '850', 'NA', '235'); | |
INSERT INTO `countries` VALUES ('238', 'VN', 'Vietnam', 'Socialist Republic of Vietnam', 'VNM', '704', 'AS', '240'); | |
INSERT INTO `countries` VALUES ('239', 'VU', 'Vanuatu', 'Republic of Vanuatu', 'VUT', '548', 'OC', '238'); | |
INSERT INTO `countries` VALUES ('240', 'WF', 'Wallis and Futuna Islands', 'Wallis and Futuna', 'WLF', '876', 'OC', '241'); | |
INSERT INTO `countries` VALUES ('241', 'WS', 'Samoa', 'Independent State of Samoa', 'WSM', '882', 'OC', '192'); | |
INSERT INTO `countries` VALUES ('242', 'YE', 'Yemen', 'Yemen', 'YEM', '887', 'AS', '243'); | |
INSERT INTO `countries` VALUES ('243', 'YT', 'Mayotte', 'Mayotte', 'MYT', '175', 'AF', '142'); | |
INSERT INTO `countries` VALUES ('244', 'ZA', 'South Africa', 'Republic of South Africa', 'ZAF', '710', 'AF', '205'); | |
INSERT INTO `countries` VALUES ('245', 'ZM', 'Zambia', 'Republic of Zambia', 'ZMB', '894', 'AF', '244'); | |
INSERT INTO `countries` VALUES ('246', 'ZW', 'Zimbabwe', 'Republic of Zimbabwe', 'ZWE', '716', 'AF', '245'); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment