Skip to content

Instantly share code, notes, and snippets.

@phreakin

phreakin/continents_and countries.sql

Created July 8, 2022 04:01
Show Gist options
  • Save phreakin/7f18b2ab8921c188579bdf4956df0e24 to your computer and use it in GitHub Desktop.
Save phreakin/7f18b2ab8921c188579bdf4956df0e24 to your computer and use it in GitHub Desktop.
Download ZIP
continents_and countries.sql
Raw
continents_and countries.sql
# ----------------------------------------------------------------------------------------------------------------------
# Create the continense table
# ----------------------------------------------------------------------------------------------------------------------
DROP TABLE IF EXISTS `continents`;
CREATE TABLE `continents`
(
'global_id' int NOT NULL AUTO_INCREMENT DEFAULT '0' COMMENT 'Global ID',
'code' char(2) NOT NULL DEFAULT '' COMMENT 'Code',
'name' varchar(255) DEFAULT '' COMMENT 'Name',
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created at',
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated at',
deleted_at timestamp NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Deleted at',
PRIMARY KEY (`code`)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8
DEFAULT COLLATE = utf8_general_ci
ROW_FORMAT = COMPACT
COMMENT = 'Continents';
# ----------------------------------------------------------------------------------------------------------------------
# Insert data into the continense table
# ----------------------------------------------------------------------------------------------------------------------
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', '', '', '');
# ----------------------------------------------------------------------------------------------------------------------
# Create the countries table
# ----------------------------------------------------------------------------------------------------------------------
DROP TABLE IF EXISTS `countries`;
CREATE TABLE `countries`
(
'global_id' int NOT NULL AUTO_INCREMENT DEFAULT '0' COMMENT 'Global ID',
'country_id' int(11) NOT NULL DEFAULT '0' COMMENT 'Country ID',
'code' char(2) NOT NULL DEFAULT '' COMMENT 'Two-letter country code (ISO 3166-1 alpha-2)',
'name' varchar(64) NOT NULL DEFAULT '' COMMENT 'English country name',
'full_name' varchar(128) NOT NULL DEFAULT '' COMMENT 'Full English country name',
'iso3' char(3) NOT NULL DEFAULT '' COMMENT 'Three-letter country code (ISO 3166-1 alpha-3)',
'number' smallint(3) unsigned zerofill NOT NULL DEFAULT '' COMMENT 'Three-digit country number (ISO 3166-1 numeric)',
'continent_code' char(2) NOT NULL DEFAULT '' COMMENT 'Two-letter continent code (ISO 3166-1 alpha-2)',
'display_order' int(3) NOT NULL DEFAULT '900' COMMENT 'Display order',
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created at',
updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated at',
deleted_at timestamp NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Deleted at',
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
DEFAULT COLLATE = utf8_general_ci
ROW_FORMAT = COMPACT
COMMENT = 'Countries';
# ----------------------------------------------------------------------------------------------------------------------
# Insert data into the countries table
# ----------------------------------------------------------------------------------------------------------------------
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