xref: /plugin/geonav/continents.sql

# SQLiteManager Dump
# Version: 1.2.4
# http://www.sqlitemanager.org/
#
# Host: test.glocalfocal.com
# Generation Time: Thursday 21st 2013f November 2013 03:19 pm
# SQLite Version: 2.8.17
# PHP Version: 5.3.27
# Database: test.sqlite
# --------------------------------------------------------

#
# Table structure for table: continents
#
CREATE TABLE continents (Id INT UNIQUE PRIMARY KEY, continent char(2) NOT NULL, code_2 char(2) NOT NULL, code_3 char(3) NOT NULL, ctry_num int NOT NULL, name text NOT NULL, short_name text NOT NULL );

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