-- phpMyAdmin SQL Dump
-- version 3.5.8.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Nov 23, 2014 at 06:18 PM
-- Server version: 5.6.11
-- PHP Version: 5.5.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `flying_rabbits`
--

-- --------------------------------------------------------

--
-- Table structure for table `country`
--

CREATE TABLE IF NOT EXISTS `country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(44) DEFAULT NULL,
  `alt_name` varchar(132) DEFAULT NULL,
  `2_char_code` varchar(2) DEFAULT NULL,
  `3_char_code` varchar(3) DEFAULT NULL,
  `number_code` int(3) DEFAULT NULL,
  `fips_code` varchar(5) DEFAULT NULL,
  `fips_name` varchar(44) DEFAULT NULL,
  `un_region` varchar(8) DEFAULT NULL,
  `un_sub_region` varchar(25) DEFAULT NULL,
  `cdh_id` int(3) DEFAULT NULL,
  `lat` varchar(20) DEFAULT NULL,
  `long` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=250 ;

--
-- Dumping data for table `country`
--

INSERT INTO `country` (`id`, `name`, `alt_name`, `2_char_code`, `3_char_code`, `number_code`, `fips_code`, `fips_name`, `un_region`, `un_sub_region`, `cdh_id`, `lat`, `long`) VALUES
(1, 'Afghanistan', 'Afghanistan, Afganistán', 'AF', 'AFG', 4, 'AF', 'Afghanistan', 'Asia', 'Southern Asia', 2, '33 00 N', '65 00 E'),
(2, 'Albania', 'Albania, Albanien, Albanie', 'AL', 'ALB', 8, 'AL', 'Albania', 'Europe', 'Southern Europe', 4, '41 00 N', '20 00 E'),
(3, 'Algeria', 'Algeria, Algerien, Algérie, Argelia', 'DZ', 'DZA', 12, 'AG', 'Algeria', 'Africa', 'Northern Africa', 5, '28 00 N', '3 00 E'),
(4, 'American Samoa', 'American Samoa, Amerikanisch-Samoa, Samoa américaines, Samoa Americana', 'AS', 'ASM', 16, 'AQ', 'American Samoa', 'Oceania', 'Polynesia', 6, '14 20 S', '170 00 W'),
(5, 'Andorra', 'Andorre, Andorra', 'AD', 'AND', 20, 'AN', 'Andorra', 'Europe', 'Southern Europe', 7, '42 30 N', '1 30 E'),
(6, 'Angola', ' Angola', 'AO', 'AGO', 24, 'AO', 'Angola', 'Africa', 'Middle Africa', 8, '12 30 S', '18 30 E'),
(7, 'Anguilla', ' Anguilla', 'AI', 'AIA', 660, 'AV', 'Anguilla', 'Americas', 'Caribbean', 9, '18 15 N', '63 10 W'),
(8, 'Antarctica', 'Antarctica, Antarktis, Antarctique, Antártida', 'AQ', 'ATA', 10, 'AY', 'Antarctica', '', '', 10, '90 00 S', '0 00 E'),
(9, 'Antigua and Barbuda', 'Antigua and Barbuda, Antigua und Barbuda, Antigua et Barbuda, Antigua y Barbuda', 'AG', 'ATG', 28, 'AC', 'Antigua and Barbuda', 'Americas', 'Caribbean', 11, '17 03 N', '61 48 W'),
(10, 'Argentina', 'Argentina, Argentinien, Argentine', 'AR', 'ARG', 32, 'AR', 'Argentina', 'Americas', 'South America', 12, '34 00 S', '64 00 W'),
(11, 'Armenia', 'Armenia, Armenien, Arménie', 'AM', 'ARM', 51, 'AM', 'Armenia', 'Asia', 'Western Asia', 13, '40 00 N', '45 00 E'),
(12, 'Aruba', 'Aruba', 'AW', 'ABW', 533, 'AA', 'Aruba', 'Americas', 'Caribbean', 14, '12 30 N', '69 58 W'),
(13, 'Australia', 'Australien, Australie, Australia', 'AU', 'AUS', 36, 'AS', 'Australia', 'Oceania', 'Australia and New Zealand', 15, '27 00 S', '133 00 E'),
(14, 'Austria', 'Österreich, Autriche, Austria', 'AT', 'AUT', 40, 'AU', 'Austria', 'Europe', 'Western Europe', 16, '47 20 N', '13 20 E'),
(15, 'Azerbaijan', 'Azerbaijan, Aserbaidschan, Azerbaïdjan, Azerbaiyán', 'AZ', 'AZE', 31, 'AJ', 'Azerbaijan', 'Asia', 'Western Asia', 17, '40 30 N', '47 30 E'),
(16, 'Bahamas', 'Bahamas', 'BS', 'BHS', 44, 'BF', 'Bahamas', 'Americas', 'Caribbean', 18, '24 15 N', '76 00 W'),
(17, 'Bahrain', 'Bahrain, Bahreïn, Bahrein', 'BH', 'BHR', 48, 'BA', 'Bahrain', 'Asia', 'Western Asia', 21, '26 00 N', '50 33 E'),
(18, 'Bangladesh', 'Bangladesh, Bangladesch', 'BD', 'BGD', 50, 'BG', 'Bangladesh', 'Asia', 'Southern Asia', 22, '24 00 N', '90 00 E'),
(19, 'Barbados', 'Barbade, Barbados', 'BB', 'BRB', 52, 'BB', 'Barbados', 'Americas', 'Caribbean', 23, '13 10 N', '59 32 W'),
(20, 'Belarus', 'Belarus, Weißrussland, Biélorussie, Bielorrusia', 'BY', 'BLR', 112, 'BO', 'Belarus', 'Europe', 'Eastern Europe', 24, '53 00 N', '28 00 E'),
(21, 'Belgium', 'Belgium, Belgien, Belgique, Bélgica', 'BE', 'BEL', 56, 'BE', 'Belgium', 'Europe', 'Western Europe', 25, '50 50 N', '4 00 E'),
(22, 'Belize', 'Belize, Belice', 'BZ', 'BLZ', 84, 'BH', 'Belize', 'Americas', 'Central America', 26, '17 15 N', '88 45 W'),
(23, 'Benin', 'Benin, Bénin', 'BJ', 'BEN', 204, 'BN', 'Benin', 'Africa', 'Western Africa', 27, '9 30 N', '2 15 E'),
(24, 'Bermuda', 'Bermuda, Bermudes, Bermudas', 'BM', 'BMU', 60, 'BD', 'Bermuda', 'Americas', 'Northern America', 28, '32 20 N', '64 45 W'),
(25, 'Bhutan', 'Bhutan, Bhoutan, Bután', 'BT', 'BTN', 64, 'BT', 'Bhutan', 'Asia', 'Southern Asia', 29, '27 30 N', '90 30 E'),
(26, 'Bolivia, Plurinational State Of', 'Bolivia, Bolivien, Bolivie', 'BO', 'BOL', 68, 'BL', 'Bolivia', 'Americas', 'South America', 30, '17 00 S', '65 00 W'),
(27, 'Bonaire, Sint Eustatius and Saba', 'Bonaire, Sint Eustatius en\r\nSaba', 'BQ', 'BES', 535, '', '', '', '', 700, '', ''),
(28, 'Bosnia and Herzegovina', 'Bosnia and Herzegovina, Bosnien und Herzegowina, Bosnie et Herzégovine, Bosnia y Herzegovina', 'BA', 'BIH', 70, 'BK', 'Bosnia and Herzegovina', 'Europe', 'Southern Europe', 31, '44 00 N', '18 00 E'),
(29, 'Botswana', 'Botswana', 'BW', 'BWA', 72, 'BC', 'Botswana', 'Africa', 'Southern Africa', 32, '22 00 S', '24 00 E'),
(30, 'Bouvet Island', '', 'BV', 'BVT', 74, 'BV', 'Bouvet Island', '', '', 33, '54 26 S', '3 24 E'),
(31, 'Brazil', 'Brazil, Brasilien, Brésil, Brasil', 'BR', 'BRA', 76, 'BR', 'Brasil ', 'Americas', 'South America', 34, '10 00 S', '55 00 W'),
(32, 'British Indian Ocean Territory', '', 'IO', 'IOT', 86, 'IO', 'British Indian Ocean Territory', 'Africa', 'Eastern Africa', 35, '6 00 S', '71 30 E'),
(33, 'Brunei Darussalam', 'Brunei', 'BN', 'BRN', 96, 'BX', 'Brunei', 'Asia', 'South-Eastern Asia', 36, '4 30 N', '114 40 E'),
(34, 'Bulgaria', 'Bulgaria, Bulgarien, Bulgarie', 'BG', 'BGR', 100, 'BU', 'Bulgaria', 'Europe', 'Eastern Europe', 37, '43 00 N', '25 00 E'),
(35, 'Burkina Faso', 'Burkina Faso', 'BF', 'BFA', 854, 'UV', 'Burkina Faso', 'Africa', 'Western Africa', 38, '13 00 N', '2 00 W'),
(36, 'Burundi', 'Burundi', 'BI', 'BDI', 108, 'BY', 'Burundi', 'Africa', 'Eastern Africa', 39, '3 30 S', '30 00 E'),
(37, 'Cambodia', 'Cambodia, Kambodscha, Cambodge, Camboya', 'KH', 'KHM', 116, 'CB', 'Cambodia', 'Asia', 'South-Eastern Asia', 40, '13 00 N', '105 00 E'),
(38, 'Cameroon', 'Cameroon, Kamerun, Cameroun, Camerún', 'CM', 'CMR', 120, 'CM', 'Cameroon', 'Africa', 'Middle Africa', 41, '6 00 N', '12 00 E'),
(39, 'Canada', 'Canada, Kanada, Canadá', 'CA', 'CAN', 124, 'CA', 'Canada', 'Americas', 'Northern America', 42, '60 00 N', '95 00 W'),
(40, 'Cape Verde', 'Cape Verde, Kap Verde, Cap Vert, Cabo Verde', 'CV', 'CPV', 132, 'CV', 'Cape Verde', 'Africa', 'Western Africa', 43, '16 00 N', '24 00 W'),
(41, 'Cayman Islands', 'Cayman Islands, Cayman-Inseln, Îles Caïmans, Islas Caimán', 'KY', 'CYM', 136, 'CJ', 'Cayman Islands', 'Americas', 'Caribbean', 44, '19 30 N', '80 30 W'),
(42, 'Central African Republic', 'Central African Republic, Zentralafrikanische Republik, République Centrafricaine, República Centroafricana', 'CF', 'CAF', 140, 'CT', 'Central African Republic', 'Africa', 'Middle Africa', 45, '7 00 N', '21 00 E'),
(43, 'Chad', 'Chad, Tschad, Tchad', 'TD', 'TCD', 148, 'CD', 'Chad', 'Africa', 'Middle Africa', 46, '15 00 N', '19 00 E'),
(44, 'Chile', 'Chile', 'CL', 'CHL', 152, 'CI', 'Chile', 'Americas', 'South America', 47, '30 00 S', '71 00 W'),
(45, 'China', 'China, Chine', 'CN', 'CHN', 156, 'CH', 'People''s Republic of China', 'Asia', 'Eastern Asia', 48, '35 00 N', '105 00 E'),
(46, 'Christmas Island', '', 'CX', 'CXR', 162, 'KT', 'Christmas Island', 'Oceania', 'Australia and New Zealand', 49, '10 30 S', '105 40 E'),
(47, 'Cocos (Keeling) Islands', '', 'CC', 'CCK', 166, 'CK', 'Cocos (Keeling) Islands', 'Oceania', 'Australia and New Zealand', 50, '12 30 S', '96 50 E'),
(48, 'Colombia', 'Colombia, Kolumbien, Colombie', 'CO', 'COL', 170, 'CO', 'Colombia', 'Americas', 'South America', 51, '4 00 N', '72 00 W'),
(49, 'Comoros', 'Comoros, Komoren, Comores', 'KM', 'COM', 174, 'CN', 'Comoros', 'Africa', 'Eastern Africa', 52, '12 10 S', '44 15 E'),
(50, 'Congo', 'Congo, Kongo', 'CG', 'COG', 178, 'CF', 'Republic of the Congo', 'Africa', 'Middle Africa', 53, '1 00 S', '15 00 E'),
(51, 'Congo, The Democratic Republic Of The', 'Congo (Dem. Rep.), Kongo (Dem. Rep.), Congo (Rep. Dem.), Congo (Rep. Dem.)', 'CD', 'COD', 180, 'CG', 'Democratic Republic of the Congo', 'Africa', 'Middle Africa', 54, '0 00 N', '25 00 E'),
(52, 'Cook Islands', 'Cook Islands, Cookinseln, Îles Cook, Islas Cook', 'CK', 'COK', 184, 'CW', 'Cook Islands', 'Oceania', 'Polynesia', 55, '21 14 S', '159 46 W'),
(53, 'Costa Rica', 'Costa Rica', 'CR', 'CRI', 188, 'CS', 'Costa Rica', 'Americas', 'Central America', 56, '10 00 N', '84 00 W'),
(54, 'Croatia', 'Croatia, Kroatien, Croatie, Croacia', 'HR', 'HRV', 191, 'HR', 'Croatia', 'Europe', 'Southern Europe', 58, '45 10 N', '15 30 E'),
(55, 'Cuba', 'Cuba, Kuba', 'CU', 'CUB', 192, 'CU', 'Cuba', 'Americas', 'Caribbean', 59, '21 30 N', '80 00 W'),
(56, 'Curaçao', 'Curaçao; Curaçao; Kòrsou', 'CW', 'CUW', 531, '', '', '', '', 701, '', ''),
(57, 'Cyprus', 'Cyprus, Zypern, Chypre, Chipre', 'CY', 'CYP', 196, 'CY', 'Cyprus', 'Asia', 'Western Asia', 60, '35 00 N', '33 00 E'),
(58, 'Czech Republic', 'Czech Republic, Tschechische Republik, République Tchèque, República Checa', 'CZ', 'CZE', 203, 'EZ', 'Czech Republic', 'Europe', 'Eastern Europe', 61, '49 45 N', '15 30 E'),
(59, 'Côte D''Ivoire', '', 'CI', 'CIV', 384, 'IV', 'Côte D''Ivoire', 'Africa', 'Western Africa', 57, '8 00 N', '5 00 W'),
(60, 'Denmark', 'Denmark, Dänemark, Danemark, Dinamarca', 'DK', 'DNK', 208, 'DA', 'Denmark', 'Europe', 'Northern Europe', 62, '56 00 N', '10 00 E'),
(61, 'Djibouti', 'Djibouti', 'DJ', 'DJI', 262, 'DJ', 'Djibouti', 'Africa', 'Eastern Africa', 63, '11 30 N', '43 00 E'),
(62, 'Dominica', 'Dominica', 'DM', 'DMA', 212, 'DO', 'Dominica', 'Americas', 'Caribbean', 64, '15 25 N', '61 20 W'),
(63, 'Dominican Republic', 'Dominican Republic, Dominikanische Republik, République Dominicaine, República Dominicana', 'DO', 'DOM', 214, 'DR', 'Dominican Republic', 'Americas', 'Caribbean', 65, '19 00 N', '70 40 W'),
(64, 'Ecuador', 'Équateur, Ecuador', 'EC', 'ECU', 218, 'EC', 'Ecuador', 'Americas', 'South America', 66, '2 00 S', '77 30 W'),
(65, 'Egypt', 'Egypt, Ägypten, Égypte, Egipto', 'EG', 'EGY', 818, 'EG', 'Egypt', 'Africa', 'Northern Africa', 67, '27 00 N', '30 00 E'),
(66, 'El Salvador', 'Salvador, El Salvador', 'SV', 'SLV', 222, 'ES', 'El Salvador', 'Americas', 'Central America', 68, '13 50 N', '88 55 W'),
(67, 'Equatorial Guinea', 'Equatorial Guinea, Äquatorial-Guinea, Guinée Équatoriale, Guinea Ecuatorial', 'GQ', 'GNQ', 226, 'EK', 'Equatorial Guinea', 'Africa', 'Middle Africa', 69, '2 00 N', '10 00 E'),
(68, 'Eritrea', 'Érythrée, Eritrea', 'ER', 'ERI', 232, 'ER', 'Eritrea', 'Africa', 'Eastern Africa', 70, '15 00 N', '39 00 E'),
(69, 'Estonia', 'Estland, Estonie, Estonia', 'EE', 'EST', 233, 'EN', 'Estonia', 'Europe', 'Northern Europe', 71, '59 00 N', '26 00 E'),
(70, 'Ethiopia', 'Ethiopia, Äthiopien, Éthiopie, Etiopía', 'ET', 'ETH', 231, 'ET', 'Ethiopia', 'Africa', 'Eastern Africa', 73, '8 00 N', '38 00 E'),
(71, 'Falkland Islands  (Malvinas)', 'Falkland Islands, Falklandinseln, Îles Malouines, Islas Malvinas', 'FK', 'FLK', 238, 'FK', 'Falkland Islands/Islas Malvinas', 'Americas', 'South America', 74, '51 45 S', '59 00 W'),
(72, 'Faroe Islands', 'Faroe Islands, Färöer-Inseln, Îles Féroé, Islas Faroe', 'FO', 'FRO', 234, 'FO', 'Faroe Islands', 'Europe', 'Northern Europe', 75, '62 00 N', '7 00 W'),
(73, 'Fiji', 'Fiji, Fidschi, Fidji', 'FJ', 'FJI', 242, 'FJ', 'Fiji', 'Oceania', 'Melanesia', 76, '18 00 S', '175 00 E'),
(74, 'Finland', 'Finland, Finnland, Finlande, Finlandia', 'FI', 'FIN', 246, 'FI', 'Finland', 'Europe', 'Northern Europe', 77, '64 00 N', '26 00 E'),
(75, 'France', 'France, Frankreich, Francia, the French Republic', 'FR', 'FRA', 250, 'FR', 'France', 'Europe', 'Western Europe', 78, '46 00 N', '2 00 E '),
(76, 'French Guiana', 'French Guiana, Französisch Guyana, Guyane française, Guayana Francesa', 'GF', 'GUF', 254, 'FG', 'French Guiana', 'Americas', 'South America', 80, '4 00 N', '53 00 W '),
(77, 'French Polynesia', 'French Polynesia, Französisch-Polynesien, Polynésie Française, Polinesia Francesa', 'PF', 'PYF', 258, 'FP', 'French Polynesia', 'Oceania', 'Polynesia', 81, '15 00 S', '140 00 W'),
(78, 'French Southern Territories', 'French Southern Territories, Französische Südgebiete, Terres Australes Françaises, Territorios Franceses del Sur', 'TF', 'ATF', 260, 'FS', 'French Southern Territories', '', '', 82, '', ''),
(79, 'Gabon', 'Gabon, Gabun, Gabón', 'GA', 'GAB', 266, 'GB', 'Gabon', 'Africa', 'Middle Africa', 83, '1 00 S', '11 45 E'),
(80, 'Gambia', 'Gambia', 'GM', 'GMB', 270, 'GA', 'The Gambia', 'Africa', 'Western Africa', 84, '13 28 N', '16 34 W'),
(81, 'Georgia', 'Georgien, Géorgie, Georgia', 'GE', 'GEO', 268, 'GG', 'Georgia', 'Asia', 'Western Asia', 1, '42 00 N', '43 30 E'),
(82, 'Germany', 'Germany, Deutschland, Allemagne, Alemania', 'DE', 'DEU', 276, 'GM', 'Germany', 'Europe', 'Western Europe', 85, '51 00 N', '9 00 E'),
(83, 'Ghana', 'Ghana', 'GH', 'GHA', 288, 'GH', 'Ghana', 'Africa', 'Western Africa', 86, '8 00 N', '2 00 W'),
(84, 'Gibraltar', 'Gibraltar', 'GI', 'GIB', 292, 'GI', 'Gibraltar', 'Europe', 'Southern Europe', 87, '36 08 N', '5 21 W'),
(85, 'Greece', 'Greece, Griechenland, Grèce, Grecia', 'GR', 'GRC', 300, 'GR', 'Greece', 'Europe', 'Southern Europe', 88, '39 00 N', '22 00 E'),
(86, 'Greenland', 'Greenland, Grönland, Groenland, Groenlandia', 'GL', 'GRL', 304, 'GL', 'Greenland', 'Americas', 'Northern America', 89, '72 00 N', '40 00 W'),
(87, 'Grenada', 'Grenada', 'GD', 'GRD', 308, 'GJ', 'Grenada', 'Americas', 'Caribbean', 90, '12 07 N', '61 40 W'),
(88, 'Guadeloupe', 'Guadeloupe, Guadalupe', 'GP', 'GLP', 312, 'GP', 'Guadeloupe', 'Americas', 'Caribbean', 91, '', ''),
(89, 'Guam', 'Guam', 'GU', 'GUM', 316, 'GQ', 'Guam', 'Oceania', 'Micronesia', 92, '13 28 N', '144 47 E'),
(90, 'Guatemala', 'Guatemala', 'GT', 'GTM', 320, 'GT', 'Guatemala', 'Americas', 'Central America', 93, '15 30 N', '90 15 W'),
(91, 'Guernsey', 'Guernsey and Alderney, Guernsey und Alderney, Guernsey et Alderney, Guernsey y Alderney', 'GG', 'GGY', 831, 'GK', 'Guernsey', 'Europe', 'Northern Europe', 94, '49 28 N', '2 35 W'),
(92, 'Guinea', 'Guinea, Guinea, Guinée, Guinea', 'GN', 'GIN', 324, 'GV', 'Guinea', 'Africa', 'Western Africa', 95, '11 00 N', '10 00 W'),
(93, 'Guinea-Bissau', 'Guinea-Bissau, Guinée-Bissau', 'GW', 'GNB', 624, 'PU', 'Guinea-Bissau', 'Africa', 'Western Africa', 96, '12 00 N', '15 00 W'),
(94, 'Guyana', 'Guyana', 'GY', 'GUY', 328, 'GY', 'Guyana', 'Americas', 'South America', 97, '5 00 N', '59 00 W'),
(95, 'Haiti', 'Haiti', 'HT', 'HTI', 332, 'HA', 'Haiti', 'Americas', 'Caribbean', 98, '19 00 N', '72 25 W'),
(96, 'Heard Island and McDonald Islands', '', 'HM', 'HMD', 334, 'HM', 'Heard Island and McDonald Islands', '', '', 99, '53 06 S', '72 31 E'),
(97, 'Holy See (Vatican City State)', 'Vatican City, Vatikan, Cité du Vatican, Ciudad del Vaticano', 'VA', 'VAT', 336, 'VT', 'Vatican City', 'Europe', 'Southern Europe', 100, '41 54 N', '12 27 E'),
(98, 'Honduras', 'Honduras', 'HN', 'HND', 340, 'HO', 'Honduras', 'Americas', 'Central America', 101, '15 00 N', '86 30 W'),
(99, 'Hong Kong', '', 'HK', 'HKG', 344, 'HK', 'Hong Kong', 'Asia', 'Eastern Asia', 102, '22 15 N', '114 10 E'),
(100, 'Hungary', 'Hungary, Ungarn, Hongrie, Hungría', 'HU', 'HUN', 348, 'HU', 'Hungary', 'Europe', 'Eastern Europe', 103, '47 00 N', '20 00 E'),
(101, 'Iceland', 'Iceland, Island, Islande, Islandia', 'IS', 'ISL', 352, 'IC', 'Iceland', 'Europe', 'Northern Europe', 104, '65 00 N', '18 00 W'),
(102, 'India', 'India, Indien, Inde', 'IN', 'IND', 356, 'IN', 'India', 'Asia', 'Southern Asia', 105, '20 00 N', '77 00 E'),
(103, 'Indonesia', 'Indonesia, Indonesien, Indonésie', 'ID', 'IDN', 360, 'ID', 'Indonesia', 'Asia', 'South-Eastern Asia', 106, '5 00 S', '120 00 E'),
(104, 'Iran, Islamic Republic Of', 'Iran, Irán', 'IR', 'IRN', 364, 'IR', 'Iran', 'Asia', 'Southern Asia', 107, '32 00 N', '53 00 E'),
(105, 'Iraq', 'Iraq, Irak', 'IQ', 'IRQ', 368, 'IZ', 'Iraq', 'Asia', 'Western Asia', 108, '33 00 N', '44 00 E'),
(106, 'Ireland', 'Ireland, Irland, Irlande, Irlanda', 'IE', 'IRL', 372, 'EI', 'Republic of Ireland', 'Europe', 'Northern Europe', 109, '53 00 N', '8 00 W'),
(107, 'Isle of Man', 'Isle of Man, Man, Île de Man, Isla de Man', 'IM', 'IMN', 833, 'IM', 'Isle of Man', 'Europe', 'Northern Europe', 110, '54 15 N', '4 30 W'),
(108, 'Israel', 'Israël, Israel', 'IL', 'ISR', 376, 'IS', 'Israel', 'Asia', 'Western Asia', 111, '31 30 N', '34 45 E'),
(109, 'Italy', 'Italy, Italien, Italie, Italia', 'IT', 'ITA', 380, 'IT', 'Italy', 'Europe', 'Southern Europe', 112, '42 50 N', '12 50 E'),
(110, 'Jamaica', 'Jamaica, Jamaika, Jamaïque', 'JM', 'JAM', 388, 'JM', 'Jamaica', 'Americas', 'Caribbean', 113, '18 15 N', '77 30 W'),
(111, 'Japan', 'Japan, Japan, Japon, Japón', 'JP', 'JPN', 392, 'JA', 'Japan', 'Asia', 'Eastern Asia', 114, '36 00 N', '138 00 E'),
(112, 'Jersey', 'Jersey', 'JE', 'JEY', 832, 'JE', 'Jersey', 'Europe', 'Northern Europe', 115, '49 15 N', '2 10 W'),
(113, 'Jordan', 'Jordan, Jordanien, Jordanie, Jordania', 'JO', 'JOR', 400, 'JO', 'Jordan', 'Asia', 'Western Asia', 116, '31 00 N', '36 00 E'),
(114, 'Kazakhstan', 'Kazakhstan, Kasachstan, Kazakhstan, Kazajistán', 'KZ', 'KAZ', 398, 'KZ', 'Kazakhstan', 'Asia', 'Central Asia', 117, '48 00 N', '68 00 E'),
(115, 'Kenya', 'Kenya, Kenia, Kenya, Kenia', 'KE', 'KEN', 404, 'KE', 'Kenya', 'Africa', 'Eastern Africa', 118, '1 00 N', '38 00 E'),
(116, 'Kiribati', 'Kiribati, Kiribati, Kiribati, Kiribati', 'KI', 'KIR', 296, 'KR', 'Kiribati', 'Oceania', 'Micronesia', 119, '1 25 N', '173 00 E'),
(117, 'Korea, Democratic People''s Republic Of', 'Korea (North), Nordkorea, Corée du Nord, Corea del Norte', 'KP', 'PRK', 408, 'KN', 'North Korea', 'Asia', 'Eastern Asia', 121, '40 00 N', '127 00 E'),
(118, 'Korea, Republic of', 'Korea (South), Südkorea, Corée du Sud, Corea del Sur', 'KR', 'KOR', 410, 'KS', 'South Korea', 'Asia', 'Eastern Asia', 120, '37 00 N', '127 30 E'),
(119, 'Kuwait', 'Koweït, Kuwait', 'KW', 'KWT', 414, 'KU', 'Kuwait', 'Asia', 'Western Asia', 122, '29 30 N', '45 45 E'),
(120, 'Kyrgyzstan', 'Kyrgyzstan, Kirgisistan, Kirghizistan, Kirguizistán', 'KG', 'KGZ', 417, 'KG', 'Kyrgyzstan', 'Asia', 'Central Asia', 123, '41 00 N', '75 00 E'),
(121, 'Lao People''s Democratic Republic', 'Laos, Laos, Laos, Laos', 'LA', 'LAO', 418, 'LA', 'Laos', 'Asia', 'South-Eastern Asia', 124, '18 00 N', '105 00 E'),
(122, 'Latvia', 'Latvia, Lettland, Lettonie, Letonia', 'LV', 'LVA', 428, 'LG', 'Latvia', 'Europe', 'Northern Europe', 125, '57 00 N', '25 00 E'),
(123, 'Lebanon', 'Lebanon, Libanon, Liban, Líbano', 'LB', 'LBN', 422, 'LE', 'Lebanon', 'Asia', 'Western Asia', 126, '33 50 N', '35 50 E'),
(124, 'Lesotho', 'Lesotho, Lesotho, Lesotho, Lesotho', 'LS', 'LSO', 426, 'LT', 'Lesotho', 'Africa', 'Southern Africa', 127, '29 30 S', '28 30 E'),
(125, 'Liberia', 'Liberia, Liberia, Liberia, Liberia', 'LR', 'LBR', 430, 'LI', 'Liberia', 'Africa', 'Western Africa', 128, '6 30 N', '9 30 W'),
(126, 'Libya', 'Libya, Libyen, Libye, Libia', 'LY', 'LBY', 434, 'LY', 'Libya', 'Africa', 'Northern Africa', 129, '25 00 N', '17 00 E'),
(127, 'Liechtenstein', 'Liechtenstein', 'LI', 'LIE', 438, 'LS', 'Liechtenstein', 'Europe', 'Western Europe', 130, '47 16 N', '9 32 E'),
(128, 'Lithuania', 'Lithuania, Litauen, Lituanie, Lituania', 'LT', 'LTU', 440, 'LH', 'Lithuania', 'Europe', 'Northern Europe', 131, '56 00 N', '24 00 E'),
(129, 'Luxembourg', 'Luxembourg, Luxemburg, Luxembourg, Luxemburgo', 'LU', 'LUX', 442, 'LU', 'Luxembourg', 'Europe', 'Western Europe', 132, '49 45 N', '6 10 E'),
(130, 'Macao', '', 'MO', 'MAC', 446, 'MC', 'Macau', 'Asia', 'Eastern Asia', 133, '22 10 N', '113 33 E'),
(131, 'Macedonia, the Former Yugoslav Republic Of', 'Macedonia, Mazedonien, Macédoine, Macedonia', 'MK', 'MKD', 807, 'MK', 'Republic of Macedonia', 'Europe', 'Southern Europe', 134, '41 50 N', '22 00 E'),
(132, 'Madagascar', 'Madagascar, Madagaskar, the Republic of Madagascar', 'MG', 'MDG', 450, 'MA', 'Madagascar', 'Africa', 'Eastern Africa', 135, '20 00 S', '47 00 E'),
(133, 'Malawi', 'Malawi', 'MW', 'MWI', 454, 'MI', 'Malawi', 'Africa', 'Eastern Africa', 136, '13 30 S', '34 00 E'),
(134, 'Malaysia', 'Malaysia, Malaisie, Malasia', 'MY', 'MYS', 458, 'MY', 'Malaysia', 'Asia', 'South-Eastern Asia', 137, '2 30 N', '112 30 E'),
(135, 'Maldives', 'Maldives, Malediven, Maldivas', 'MV', 'MDV', 462, 'MV', 'Maldives', 'Asia', 'Southern Asia', 138, '3 15 N', '73 00 E'),
(136, 'Mali', 'Mali', 'ML', 'MLI', 466, 'ML', 'Mali', 'Africa', 'Western Africa', 139, '17 00 N', '4 00 W'),
(137, 'Malta', 'Malta, Malta, Malte, Malta', 'MT', 'MLT', 470, 'MT', 'Malta', 'Europe', 'Southern Europe', 140, '35 50 N', '14 35 E'),
(138, 'Marshall Islands', 'Marshall Islands, Marshall-Inseln, Îles Marshall, Islas Marshall', 'MH', 'MHL', 584, 'RM', 'Marshall Islands', 'Oceania', 'Micronesia', 141, '9 00 N', '168 00 E'),
(139, 'Martinique', 'Martinique, Martinique, Martinique, Martinica', 'MQ', 'MTQ', 474, 'MB', 'Martinique', 'Americas', 'Caribbean', 142, '', ''),
(140, 'Mauritania', 'Mauritania, Mauretanien, Mauritanie, Mauritania', 'MR', 'MRT', 478, 'MR', 'Mauritania', 'Africa', 'Western Africa', 143, '20 00 N', '12 00 W'),
(141, 'Mauritius', 'Mauritius, Mauritius, Île Maurice, Mauricio', 'MU', 'MUS', 480, 'MP', 'Mauritius', 'Africa', 'Eastern Africa', 144, '20 17 S', '57 33 E'),
(142, 'Mayotte', 'Mayotte, Mayotte, Mayotte, Mayotte', 'YT', 'MYT', 175, 'MF', 'Mayotte', 'Africa', 'Eastern Africa', 145, '12 50 S', '45 10 E'),
(143, 'Mexico', 'Mexico, Mexiko, Mexique, México', 'MX', 'MEX', 484, 'MX', 'Mexico', 'Americas', 'Central America', 146, '23 00 N', '102 00 W'),
(144, 'Micronesia, Federated States Of', 'Micronesia, Mikronesien, Micronésie, Micronesia', 'FM', 'FSM', 583, 'FM', 'Federated States of Micronesia', 'Oceania', 'Micronesia', 147, '6 55 N', '158 15 E'),
(145, 'Moldova, Republic of', 'Moldova, Moldawien, Moldavie, Moldavia, the Republic of Moldova', 'MD', 'MDA', 498, 'MD', 'Moldova', 'Europe', 'Eastern Europe', 148, '47 00 N', '29 00 E'),
(146, 'Monaco', 'Monaco, Mónaco', 'MC', 'MCO', 492, 'MN', 'Monaco', 'Europe', 'Western Europe', 149, '43 44 N', '7 24 E'),
(147, 'Mongolia', 'Mongolei, Mongolie, Mongolia', 'MN', 'MNG', 496, 'MG', 'Mongolia', 'Asia', 'Eastern Asia', 150, '46 00 N', '105 00 E'),
(148, 'Montenegro', 'Crna Gora, Montenegro', 'ME', 'MNE', 499, 'MJ', 'Montenegro', 'Europe', 'Southern Europe', 151, '42 30 N', '19 18 E'),
(149, 'Montserrat', 'Montserrat, Montserrat, Montserrat, Montserrat', 'MS', 'MSR', 500, 'MH', 'Montserrat', 'Americas', 'Caribbean', 152, '16 45 N', '62 12 W'),
(150, 'Morocco', 'Morocco, Marokko, Maroc, Marruecos', 'MA', 'MAR', 504, 'MO', 'Morocco', 'Africa', 'Northern Africa', 153, '32 00 N', '5 00 W'),
(151, 'Mozambique', 'Mozambique, Mosambik, Mozambique, Mozambique', 'MZ', 'MOZ', 508, 'MZ', 'Mozambique', 'Africa', 'Eastern Africa', 154, '18 15 S', '35 00 E'),
(152, 'Myanmar', 'Myanmar, Myanmar, Myanmar, Myanmar', 'MM', 'MMR', 104, 'BM', 'Myanmar', 'Asia', 'South-Eastern Asia', 155, '22 00 N', '98 00 E'),
(153, 'Namibia', 'Namibia, Namibia, Namibie, Namibia', 'NA', 'NAM', 516, 'WA', 'Namibia', 'Africa', 'Southern Africa', 156, '22 00 S', '17 00 E'),
(154, 'Nauru', 'Nauru, Nauru, Nauru, Nauru', 'NR', 'NRU', 520, 'NR', 'Nauru', 'Oceania', 'Micronesia', 157, '0 32 S', '166 55 E'),
(155, 'Nepal', 'Nepal, Nepal, Népal, Nepal, the Federal Democratic Republic of Nepal', 'NP', 'NPL', 524, 'NP', 'Nepal', 'Asia', 'Southern Asia', 158, '28 00 N', '84 00 E'),
(156, 'Netherlands', 'Netherlands, Niederlande, Pays-Bas, Países Bajos', 'NL', 'NLD', 528, 'NL', 'Netherlands', 'Europe', 'Western Europe', 159, '52 30 N', '5 45 E'),
(157, 'New Caledonia', 'New Caledonia, Neukaledonien, Nouvelle Calédonie, Nueva Caledonia', 'NC', 'NCL', 540, 'NC', 'New Caledonia', 'Oceania', 'Melanesia', 161, '21 30 S', '165 30 E'),
(158, 'New Zealand', 'New Zealand, Neuseeland, Nouvelle ZÃ©lande, Nueva Zelanda', 'NZ', 'NZL', 554, 'NZ', 'New Zealand', 'Oceania', 'Australia and New Zealand', 162, '41 00 S', '174 00 E'),
(159, 'Nicaragua', 'Nicaragua, Nicaragua, Nicaragua, Nicaragua', 'NI', 'NIC', 558, 'NU', 'Nicaragua', 'Americas', 'Central America', 163, '13 00 N', '85 00 W'),
(160, 'Niger', 'Níger', 'NE', 'NER', 562, 'NG', 'Niger', 'Africa', 'Western Africa', 164, '16 00 N', '8 00 E'),
(161, 'Nigeria', 'Nigeria, Nigéria, the Federal Republic of Nigeria', 'NG', 'NGA', 566, 'NI', 'Nigeria', 'Africa', 'Western Africa', 165, '10 00 N', '8 00 E'),
(162, 'Niue', 'Niue', 'NU', 'NIU', 570, 'NE', 'Niue', 'Oceania', 'Polynesia', 166, '19 02 S', '169 52 W'),
(163, 'Norfolk Island', 'Norfolk Island, Norfolk Island, Île de Norfolk, Isla de Norfolk', 'NF', 'NFK', 574, 'NF', 'Norfolk Island', 'Oceania', 'Australia and New Zealand', 167, '29 02 S', '167 57 E'),
(164, 'Northern Mariana Islands', 'Northern Mariana Islands, Nördliche Marianen, Mariannes du Nord, Islas Marianas del Norte', 'MP', 'MNP', 580, 'CQ', 'Northern Mariana Islands', 'Oceania', 'Micronesia', 168, '15 12 N', '145 45 E'),
(165, 'Norway', 'Norway, Norwegen, Norvège, Noruega', 'NO', 'NOR', 578, 'NO', 'Norway', 'Europe', 'Northern Europe', 169, '62 00 N', '10 00 E'),
(166, 'Oman', 'Oman, Omán', 'OM', 'OMN', 512, 'MU', 'Oman', 'Asia', 'Western Asia', 170, '21 00 N', '57 00 E'),
(167, 'Pakistan', 'Pakistan, Paquistán', 'PK', 'PAK', 586, 'PK', 'Pakistan', 'Asia', 'Southern Asia', 171, '30 00 N', '70 00 E'),
(168, 'Palau', 'Palau', 'PW', 'PLW', 585, 'PS', 'Palau', 'Oceania', 'Micronesia', 172, '7 30 N', '134 30 E'),
(169, 'Palestinian Territory, Occupied', 'Palestine, Palästina, Palestine, Palestina, the Occupied Palestinian Territory', 'PS', 'PSE', 275, 'WE/GZ', 'West Bank and Gaza Strip', 'Asia', 'Western Asia', 173, '', ''),
(170, 'Panama', 'Panama, Panamá', 'PA', 'PAN', 591, 'PM', 'Panama', 'Americas', 'Central America', 175, '9 00 N', '80 00 W'),
(171, 'Papua New Guinea', 'Papua New Guinea, Papua-Neuguinea, Papouasie Nouvelle-Guinée, Papúa Nueva Guinea', 'PG', 'PNG', 598, 'PP', 'Papua New Guinea', 'Oceania', 'Melanesia', 176, '6 00 S', '147 00 E'),
(172, 'Paraguay', 'Paraguay', 'PY', 'PRY', 600, 'PA', 'Paraguay', 'Americas', 'South America', 177, '23 00 S', '58 00 W'),
(173, 'Peru', 'Peru, Pérou, Perú', 'PE', 'PER', 604, 'PE', 'Peru', 'Americas', 'South America', 178, '10 00 S', '76 00 W'),
(174, 'Philippines', 'Philippinen, Philippines, Filipinas', 'PH', 'PHL', 608, 'RP', 'Philippines', 'Asia', 'South-Eastern Asia', 180, '13 00 N', '122 00 E'),
(175, 'Pitcairn', '', 'PN', 'PCN', 612, 'PC', 'Pitcairn Islands', 'Oceania', 'Polynesia', 182, '25 04 S', '130 06 W'),
(176, 'Poland', 'Poland, Polen, Pologne, Polonia', 'PL', 'POL', 616, 'PL', 'Poland', 'Europe', 'Eastern Europe', 183, '52 00 N', '20 00 E'),
(177, 'Portugal', 'Portugal', 'PT', 'PRT', 620, 'PO', 'Portugal', 'Europe', 'Southern Europe', 184, '39 30 N', '8 00 W'),
(178, 'Puerto Rico', 'Puerto Rico', 'PR', 'PRI', 630, 'RQ', 'Puerto Rico', 'Americas', 'Caribbean', 185, '18 15 N', '66 30 W'),
(179, 'Qatar', 'Qatar, Katar', 'QA', 'QAT', 634, 'QA', 'Qatar', 'Asia', 'Western Asia', 186, '25 30 N', '51 15 E'),
(180, 'Romania', 'Romania, Rumänien, Roumanie, Rumania', 'RO', 'ROU', 642, 'RO', 'Romania', 'Europe', 'Eastern Europe', 189, '46 00 N', '25 00 E'),
(181, 'Russian Federation', 'Russia, Russland, Russie, Rusia', 'RU', 'RUS', 643, 'RS', 'Russia', 'Europe', 'Eastern Europe', 190, '60 00 N', '100 00 E'),
(182, 'Rwanda', 'Rwanda, Ruanda', 'RW', 'RWA', 646, 'RW', 'Rwanda', 'Africa', 'Eastern Africa', 191, '2 00 S', '30 00 E'),
(183, 'Réunion', 'Réunion, Réunion, Réunion, Reunión', 'RE', 'REU', 638, 'RE', 'Réunion', 'Africa', 'Eastern Africa', 187, '', ''),
(184, 'Saint Barthélemy', '', 'BL', 'BLM', 652, 'TB', 'Saint Barthelemy', 'Americas', 'Caribbean', 300, '17 90 N', '62 85 W'),
(185, 'Saint Helena, Ascension and Tristan Da Cunha', 'Saint Helena, Sankt Helena, Sainte Hélène, Santa Helena', 'SH', 'SHN', 654, 'SH', 'Saint Helena', 'Africa', 'Western Africa', 192, 'Saint Helena: 15 57 ', 'Saint Helena: 5 42 W'),
(186, 'Saint Kitts And Nevis', 'Saint Kitts and Nevis, Saint Kitts et Nevis, Saint Kitts y Nevis', 'KN', 'KNA', 659, 'SC', 'Saint Kitts and Nevis', 'Americas', 'Caribbean', 193, '17 20 N', '62 45 W'),
(187, 'Saint Lucia', 'Saint Lucia, Saint-Lucie, Santa Lucía', 'LC', 'LCA', 662, 'ST', 'Saint Lucia', 'Americas', 'Caribbean', 194, '13 53 N', '60 58 W'),
(188, 'Saint Martin (French Part)', '', 'MF', 'MAF', 663, 'RN', 'Saint Martin', 'Americas', 'Caribbean', 301, '18 05 N', '63 57 W'),
(189, 'Saint Pierre And Miquelon', 'Saint Pierre and Miquelon, Saint-Pierre-et-Miquelon, Saint-Pierre-et-Miquelon, San Pedro y Miquelón', 'PM', 'SPM', 666, 'SB', 'Saint Pierre and Miquelon', 'Americas', 'Northern America', 181, '46 50 N', '56 20 W'),
(190, 'Saint Vincent And The Grenadines', 'Saint Vincent and the Grenadines, Saint Vincent und die Grenadinen, Saint-Vincent et les Grenadines, San Vicente y Granadinas', 'VC', 'VCT', 670, 'VC', 'Saint Vincent and the Grenadines', 'Americas', 'Caribbean', 195, '13 15 N', '61 12 W'),
(191, 'Samoa', 'Samoa', 'WS', 'WSM', 882, 'WS', 'Samoa', 'Oceania', 'Polynesia', 196, '13 35 S', '172 20 W'),
(192, 'San Marino', 'San Marino, Saint-Marin', 'SM', 'SMR', 674, 'SM', 'San Marino', 'Europe', 'Southern Europe', 197, '43 46 N', '12 25 E'),
(193, 'Sao Tome and Principe', 'São Tomé and Príncipe, São Tomé und Príncipe, São Tomé et Príncipe, Santo Tomé y Príncipe', 'ST', 'STP', 678, 'TP', 'São Tomé and Príncipe', 'Africa', 'Middle Africa', 198, '1 00 N', '7 00 E'),
(194, 'Saudi Arabia', 'Saudi Arabia, Saudi-Arabien, Arabie Saoudite, Arabia Saudí', 'SA', 'SAU', 682, 'SA', 'Saudi Arabia', 'Asia', 'Western Asia', 199, '25 00 N', '45 00 E'),
(195, 'Senegal', 'Senegal,  Sénégal', 'SN', 'SEN', 686, 'SG', 'Senegal', 'Africa', 'Western Africa', 200, '14 00 N', '14 00 W'),
(196, 'Serbia', 'Serbia, Serbien, Serbie, Serbia', 'RS', 'SRB', 688, 'RI', 'Serbia', 'Europe', 'Southern Europe', 201, '44 00 N', '21 00 E'),
(197, 'Seychelles', 'Seychelles', 'SC', 'SYC', 690, 'SE', 'Seychelles', 'Africa', 'Eastern Africa', 202, '4 35 S', '55 40 E'),
(198, 'Sierra Leone', 'Sierra Leone', 'SL', 'SLE', 694, 'SL', 'Sierra Leone', 'Africa', 'Western Africa', 203, '8 30 N', '11 30 W'),
(199, 'Singapore', 'Singapore, Singapur, Singapour, Singapur', 'SG', 'SGP', 702, 'SN', 'Singapore', 'Asia', 'South-Eastern Asia', 205, '1 22 N', '103 48 E'),
(200, 'Sint Maarten (Dutch part)', '', 'SX', 'SXM', 534, '', '', '', '', 702, '', ''),
(201, 'Slovakia', 'Slovakia, Slowakei, Slovaquie, República Eslovaca', 'SK', 'SVK', 703, 'LO', 'Slovakia', 'Europe', 'Eastern Europe', 206, '48 40 N', '19 30 E'),
(202, 'Slovenia', 'Slovenia, Slowenien, Slovénie, Eslovenia', 'SI', 'SVN', 705, 'SI', 'Slovenia', 'Europe', 'Southern Europe', 207, '46 07 N', '14 49 E'),
(203, 'Solomon Islands', 'Solomon Islands, Salomonen, Îles Salomon, Islas Salomón', 'SB', 'SLB', 90, 'BP', 'Solomon Islands', 'Oceania', 'Melanesia', 208, '8 00 S', '159 00 E'),
(204, 'Somalia', 'Somalia', 'SO', 'SOM', 706, 'SO', 'Somalia', 'Africa', 'Eastern Africa', 209, '10 00 N', '49 00 E'),
(205, 'South Africa', 'South Africa, Republik Südafrika, Afrique du Sud, República de Sudáfrica', 'ZA', 'ZAF', 710, 'SF', 'South Africa', 'Africa', 'Southern Africa', 210, '29 00 S', '24 00 E'),
(206, 'South Georgia and the South Sandwich Islands', '', 'GS', 'SGS', 239, 'SX', 'South Georgia and the South Sandwich Islands', 'Americas', 'South America', 211, '54 30 S', '37 00 W'),
(207, 'South Sudan', '', 'SS', 'SSD', 728, 'OD', '', '', '', 703, '', ''),
(208, 'Spain', 'Spain, Spanien, Espagne, España', 'ES', 'ESP', 724, 'SP', 'Spain', 'Europe', 'Southern Europe', 212, '40 00 N', '4 00 W'),
(209, 'Sri Lanka', 'Sri Lanka', 'LK', 'LKA', 144, 'CE', 'Sri Lanka', 'Asia', 'Southern Asia', 213, '7 00 N', '81 00 E'),
(210, 'Sudan', 'Sudan, Soudan, Sudán', 'SD', 'SDN', 729, 'SU', 'Sudan', 'Africa', 'Northern Africa', 214, '15 00 N', '30 00 E'),
(211, 'Suriname', 'Suriname, Surinam', 'SR', 'SUR', 740, 'NS', 'Suriname', 'Americas', 'South America', 215, '4 00 N', '56 00 W'),
(212, 'Svalbard And Jan Mayen', 'Svalbard and Jan Mayen, Svalbard und Jan Mayen, Îles Svalbard et Jan Mayen, Islas Svalbard y Jan Mayen', 'SJ', 'SJM', 744, 'SV', 'Svalbard', 'Europe', 'Northern Europe', 216, '78 00 N', '20 00 E'),
(213, 'Swaziland', 'Swaziland, Swasiland, Swaziland, Suazilandia', 'SZ', 'SWZ', 748, 'WZ', 'Swaziland', 'Africa', 'Southern Africa', 217, '26 30 S', '31 30 E'),
(214, 'Sweden', 'Sweden, Schweden, Suède, Suecia', 'SE', 'SWE', 752, 'SW', 'Sweden', 'Europe', 'Northern Europe', 218, '62 00 N', '15 00 E'),
(215, 'Switzerland', 'Switzerland, Schweiz, Suisse, Suiza', 'CH', 'CHE', 756, 'SZ', 'Switzerland', 'Europe', 'Western Europe', 219, '47 00 N', '8 00 E'),
(216, 'Syrian Arab Republic', 'Syria, Syrien, Syrie, Siria', 'SY', 'SYR', 760, 'SY', 'Syria', 'Asia', 'Western Asia', 220, '35 00 N', '38 00 E'),
(217, 'Taiwan, Province Of China', 'Taiwan, Taiwán', 'TW', 'TWN', 158, 'TW', 'Republic of China Taiwan', 'Asia', 'Eastern Asia', 221, '23 30 N', '121 00 E'),
(218, 'Tajikistan', 'Tajikistan, Tadschikistan, Tajikistan, Tayikistán', 'TJ', 'TJK', 762, 'TI', 'Tajikistan', 'Asia', 'Central Asia', 222, '39 00 N', '71 00 E'),
(219, 'Tanzania, United Republic of', 'Tanzania, Tansania, Tanzanie', 'TZ', 'TZA', 834, 'TZ', 'Tanzania', 'Africa', 'Eastern Africa', 223, '6 00 S', '35 00 E'),
(220, 'Thailand', 'Thailand, Thailand, Thaïlande, Tailandia', 'TH', 'THA', 764, 'TH', 'Thailand', 'Asia', 'South-Eastern Asia', 224, '15 00 N', '100 00 E'),
(221, 'Timor-Leste', 'East Timor, Ost-Timor, Timor oriental, Timor Oriental', 'TL', 'TLS', 626, 'TT', 'Timor-Leste', 'Asia', 'South-Eastern Asia', 226, '8 50 S', '125 55 E'),
(222, 'Togo', 'Togo', 'TG', 'TGO', 768, 'TO', 'Togo', 'Africa', 'Western Africa', 227, '8 00 N', '1 10 E'),
(223, 'Tokelau', 'Tokelau, Tokelau, Îles Tokelau, Islas Tokelau', 'TK', 'TKL', 772, 'TL', 'Tokelau', 'Oceania', 'Polynesia', 228, '9 00 S', '172 00 W'),
(224, 'Tonga', 'Tonga', 'TO', 'TON', 776, 'TN', 'Tonga', 'Oceania', 'Polynesia', 229, '20 00 S', '175 00 W'),
(225, 'Trinidad and Tobago', 'Trinidad and Tobago, Trinidad und Tobago, Trinité et Tobago, Trinidad y Tobago', 'TT', 'TTO', 780, 'TD', 'Trinidad and Tobago', 'Americas', 'Caribbean', 230, '11 00 N', '61 00 W'),
(226, 'Tunisia', 'Tunisia, Tunesien, Tunisie, Túnez', 'TN', 'TUN', 788, 'TS', 'Tunisia', 'Africa', 'Northern Africa', 231, '34 00 N', '9 00 E'),
(227, 'Turkey', 'Turkey, Türkei, Turquie, Turquía', 'TR', 'TUR', 792, 'TU', 'Turkey', 'Asia', 'Western Asia', 232, '39 00 N', '35 00 E'),
(228, 'Turkmenistan', 'Turkmenistan, Turkmenistan, Turkménistan, Turkmenistán', 'TM', 'TKM', 795, 'TX', 'Turkmenistan', 'Asia', 'Central Asia', 233, '40 00 N', '60 00 E'),
(229, 'Turks and Caicos Islands', 'Turks and Caicos Islands, Turks- und Caicosinseln, Îles Turks et Caïcos, Islas Turks y Caicos', 'TC', 'TCA', 796, 'TK', 'Turks and Caicos Islands', 'Americas', 'Caribbean', 234, '21 45 N', '71 35 W'),
(230, 'Tuvalu', 'Tuvalu, Tuvalu, Tuvalu, Tuvalu', 'TV', 'TUV', 798, 'TV', 'Tuvalu', 'Oceania', 'Polynesia', 235, '8 00 S', '178 00 E'),
(231, 'Uganda', 'Uganda', 'UG', 'UGA', 800, 'UG', 'Republic of Uganda', 'Africa', 'Eastern Africa', 236, '1 00 N', '32 00 E'),
(232, 'Ukraine', 'Ukraine, Ukraine, Ukraine, Ucrania', 'UA', 'UKR', 804, 'UP', 'Ukraine', 'Europe', 'Eastern Europe', 237, '49 00 N', '32 00 E'),
(233, 'United Arab Emirates', 'United Arab Emirates, Vereinigte Arabische Emirate, Émirats Arabes Unis, Emiratos Árabes Unidos', 'AE', 'ARE', 784, 'AE', 'United Arab Emirates', 'Asia', 'Western Asia', 238, '24 00 N', '54 00 E'),
(234, 'United Kingdom', 'United Kingdom, GroÃÂbritannien, Royaume-Uni, Reino Unido', 'GB', 'GBR', 826, 'UK', 'United Kingdom', 'Europe', 'Northern Europe', 239, '54 00 N', '2 00 W'),
(235, 'United States', 'United States of America, Vereinigte Staaten von Amerika, États-Unis, Estados Unidos', 'US', 'USA', 840, 'US', 'United States', 'Americas', 'Northern America', 240, '38 00 N', '97 00 W'),
(236, 'United States Minor Outlying Islands', 'United States Minor Outlying Islands, US-Amerikanische Hoheitsgebiete, Dépendances américaines, Islas menores de Estados Unidos', 'UM', 'UMI', 581, '', '', 'Americas', 'Northern America', 241, '', ''),
(237, 'Uruguay', 'Uruguay', 'UY', 'URY', 858, 'UY', 'Uruguay', 'Americas', 'South America', 242, '33 00 S', '56 00 W'),
(238, 'Uzbekistan', 'Uzbekistan, Usbekistan, Ouzbékistan, Uzbekistán', 'UZ', 'UZB', 860, 'UZ', 'Uzbekistan', 'Asia', 'Central Asia', 243, '41 00 N', '64 00 E'),
(239, 'Vanuatu', 'Vanuatu', 'VU', 'VUT', 548, 'NH', 'Vanuatu', 'Oceania', 'Melanesia', 244, '16 00 S', '167 00 E'),
(240, 'Venezuela, Bolivarian Republic of', 'Venezuela', 'VE', 'VEN', 862, 'VE', 'Venezuela', 'Americas', 'South America', 245, '8 00 N', '66 00 W'),
(241, 'Viet Nam', 'Vietnam', 'VN', 'VNM', 704, 'VM', 'Vietnam', 'Asia', 'South-Eastern Asia', 247, '16 10 N', '107 50 E'),
(242, 'Virgin Islands, British', 'British Virgin Islands, Britische Jungferninseln, Îles Vierges britanniques, Islas Vírgenes del Reino Unido', 'VG', 'VGB', 92, 'VI', 'British Virgin Islands', 'Americas', 'Caribbean', 248, '', ''),
(243, 'Virgin Islands, U.S.', 'Virgin Islands of the United States, Amerikanische Jungferninseln, Îles Vierges américaines, Islas Vírgenes de los Estados Unidos', 'VI', 'VIR', 850, 'VQ', 'U.S. Virgin Islands', 'Americas', 'Caribbean', 249, '', ''),
(244, 'Wallis and Futuna', 'Wallis and Futuna, Wallis und Futuna, Wallis et Futuna, Wallis y Futuna', 'WF', 'WLF', 876, 'WF', 'Wallis and Futuna', 'Oceania', 'Polynesia', 250, '13 18 S', '176 12 W'),
(245, 'Western Sahara', 'Western Sahara, Westsahara, Sahara Occidental, Sahara Occidental', 'EH', 'ESH', 732, 'WI', 'Western Sahara', 'Africa', 'Northern Africa', 251, '24 30 N', '13 00 W'),
(246, 'Yemen', 'Yemen, Jemen, Yémen', 'YE', 'YEM', 887, 'YM', 'Yemen', 'Asia', 'Western Asia', 252, '15 00 N', '48 00 E'),
(247, 'Zambia', 'Zambia, Sambia, Zambie', 'ZM', 'ZMB', 894, 'ZA', 'Zambia', 'Africa', 'Eastern Africa', 255, '15 00 S', '30 00 E'),
(248, 'Zimbabwe', 'Zimbabwe, Simbabwe, Zimbabue', 'ZW', 'ZWE', 716, 'ZI', 'Zimbabwe', 'Africa', 'Eastern Africa', 256, '20 00 S', '30 00 E'),
(249, 'Åland Islands', '', 'AX', 'ALA', 248, '', '', 'Europe', 'Northern Europe', 3, '', '');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
