access f

profilepd535402620
nations.sql
CREATE TABLE `nations` (
`Code` CHAR(3) NOT NULL DEFAULT ''
`Name` CHAR(52) NOT NULL DEFAULT ''
`Continent` enum('Asia' 'Europe' 'North America' 'Africa' 'Oceania' 'Antarctica' 'South America') NOT NULL DEFAULT 'Asia'
`Region` CHAR(26) NOT NULL DEFAULT ''
`SurfaceArea` FLOAT(10 2) NOT NULL DEFAULT '0.00'
`IndepYear` SMALLINT(6) DEFAULT NULL
`Population` INT(11) NOT NULL DEFAULT '0'
`LifeExpectancy` FLOAT(3 1) DEFAULT NULL
`GNP` FLOAT(10 2) DEFAULT NULL
`GNPOld` FLOAT(10 2) DEFAULT NULL
`LocalName` CHAR(45) NOT NULL DEFAULT ''
`GovernmentForm` CHAR(45) NOT NULL DEFAULT ''
`HeadOfState` CHAR(60) DEFAULT NULL
`Capital` INT(11) DEFAULT NULL
`Code2` CHAR(2) NOT NULL DEFAULT ''
PRIMARY KEY (`Code`)
)
--
-- import data for table `nations`
--
INSERT INTO `nations` VALUES ('ABW' 'Aruba' 'North America' 'Caribbean' 193.00 NULL 103000 78.4 828.00 793.00 'Aruba' 'Nonmetropolitan Territory of The Netherlands' 'Beatrix' 129 'AW');
INSERT INTO `nations` VALUES ('AFG' 'Afghanistan' 'Asia' 'Southern and Central Asia' 652090.00 1919 22720000 45.9 5976.00 NULL 'Afganistan/Afqanestan' 'Islamic Emirate' 'Mohammad Omar' 1 'AF');
INSERT INTO `nations` VALUES ('AGO' 'Angola' 'Africa' 'Central Africa' 1246700.00 1975 12878000 38.3 6648.00 7984.00 'Angola' 'Republic' 'José Eduardo dos Santos' 56 'AO');
INSERT INTO `nations` VALUES ('AIA' 'Anguilla' 'North America' 'Caribbean' 96.00 NULL 8000 76.1 63.20 NULL 'Anguilla' 'Dependent Territory of the UK' 'Elisabeth II' 62 'AI');
INSERT INTO `nations` VALUES ('ALB' 'Albania' 'Europe' 'Southern Europe' 28748.00 1912 3401200 71.6 3205.00 2500.00 'Shqipëria' 'Republic' 'Rexhep Mejdani' 34 'AL');
INSERT INTO `nations` VALUES ('AND' 'Andorra' 'Europe' 'Southern Europe' 468.00 1278 78000 83.5 1630.00 NULL 'Andorra' 'Parliamentary Coprincipality' '' 55 'AD');
INSERT INTO `nations` VALUES ('ANT' 'Netherlands Antilles' 'North America' 'Caribbean' 800.00 NULL 217000 74.7 1941.00 NULL 'Nederlandse Antillen' 'Nonmetropolitan Territory of The Netherlands' 'Beatrix' 33 'AN');
INSERT INTO `nations` VALUES ('ARE' 'United Arab Emirates' 'Asia' 'Middle East' 83600.00 1971 2441000 74.1 37966.00 36846.00 'Al-Imarat al-´Arabiya al-Muttahida' 'Emirate Federation' 'Zayid bin Sultan al-Nahayan' 65 'AE');
INSERT INTO `nations` VALUES ('ARG' 'Argentina' 'South America' 'South America' 2780400.00 1816 37032000 75.1 340238.00 323310.00 'Argentina' 'Federal Republic' 'Fernando de la Rúa' 69 'AR');
INSERT INTO `nations` VALUES ('ARM' 'Armenia' 'Asia' 'Middle East' 29800.00 1991 3520000 66.4 1813.00 1627.00 'Hajastan' 'Republic' 'Robert Kotšarjan' 126 'AM');
INSERT INTO `nations` VALUES ('ASM' 'American Samoa' 'Oceania' 'Polynesia' 199.00 NULL 68000 75.1 334.00 NULL 'Amerika Samoa' 'US Territory' 'George W. Bush' 54 'AS');
INSERT INTO `nations` VALUES ('ATA' 'Antarctica' 'Antarctica' 'Antarctica' 13120000.00 NULL 0 NULL 0.00 NULL '–' 'Co-administrated' '' NULL 'AQ');
INSERT INTO `nations` VALUES ('ATF' 'French Southern territories' 'Antarctica' 'Antarctica' 7780.00 NULL 0 NULL 0.00 NULL 'Terres australes françaises' 'Nonmetropolitan Territory of France' 'Jacques Chirac' NULL 'TF');
INSERT INTO `nations` VALUES ('ATG' 'Antigua and Barbuda' 'North America' 'Caribbean' 442.00 1981 68000 70.5 612.00 584.00 'Antigua and Barbuda' 'Constitutional Monarchy' 'Elisabeth II' 63 'AG');
INSERT INTO `nations` VALUES ('AUS' 'Australia' 'Oceania' 'Australia and New Zealand' 7741220.00 1901 18886000 79.8 351182.00 392911.00 'Australia' 'Constitutional Monarchy Federation' 'Elisabeth II' 135 'AU');
INSERT INTO `nations` VALUES ('AUT' 'Austria' 'Europe' 'Western Europe' 83859.00 1918 8091800 77.7 211860.00 206025.00 'Österreich' 'Federal Republic' 'Thomas Klestil' 1523 'AT');
INSERT INTO `nations` VALUES ('AZE' 'Azerbaijan' 'Asia' 'Middle East' 86600.00 1991 7734000 62.9 4127.00 4100.00 'Azärbaycan' 'Federal Republic' 'Heydär Äliyev' 144 'AZ');
INSERT INTO `nations` VALUES ('BDI' 'Burundi' 'Africa' 'Eastern Africa' 27834.00 1962 6695000 46.2 903.00 982.00 'Burundi/Uburundi' 'Republic' 'Pierre Buyoya' 552 'BI');
INSERT INTO `nations` VALUES ('BEL' 'Belgium' 'Europe' 'Western Europe' 30518.00 1830 10239000 77.8 249704.00 243948.00 'België/Belgique' 'Constitutional Monarchy Federation' 'Albert II' 179 'BE');
INSERT INTO `nations` VALUES ('BEN' 'Benin' 'Africa' 'Western Africa' 112622.00 1960 6097000 50.2 2357.00 2141.00 'Bénin' 'Republic' 'Mathieu Kérékou' 187 'BJ');
INSERT INTO `nations` VALUES ('BFA' 'Burkina Faso' 'Africa' 'Western Africa' 274000.00 1960 11937000 46.7 2425.00 2201.00 'Burkina Faso' 'Republic' 'Blaise Compaoré' 549 'BF');
INSERT INTO `nations` VALUES ('BGD' 'Bangladesh' 'Asia' 'Southern and Central Asia' 143998.00 1971 129155000 60.2 32852.00 31966.00 'Bangladesh' 'Republic' 'Shahabuddin Ahmad' 150 'BD');
INSERT INTO `nations` VALUES ('BGR' 'Bulgaria' 'Europe' 'Eastern Europe' 110994.00 1908 8190900 70.9 12178.00 10169.00 'Balgarija' 'Republic' 'Petar Stojanov' 539 'BG');
INSERT INTO `nations` VALUES ('BHR' 'Bahrain' 'Asia' 'Middle East' 694.00 1971 617000 73.0 6366.00 6097.00 'Al-Bahrayn' 'Monarchy (Emirate)' 'Hamad ibn Isa al-Khalifa' 149 'BH');
INSERT INTO `nations` VALUES ('BHS' 'Bahamas' 'North America' 'Caribbean' 13878.00 1973 307000 71.1 3527.00 3347.00 'The Bahamas' 'Constitutional Monarchy' 'Elisabeth II' 148 'BS');
INSERT INTO `nations` VALUES ('BIH' 'Bosnia and Herzegovina' 'Europe' 'Southern Europe' 51197.00 1992 3972000 71.5 2841.00 NULL 'Bosna i Hercegovina' 'Federal Republic' 'Ante Jelavic' 201 'BA');
INSERT INTO `nations` VALUES ('BLR' 'Belarus' 'Europe' 'Eastern Europe' 207600.00 1991 10236000 68.0 13714.00 NULL 'Belarus' 'Republic' 'Aljaksandr Lukašenka' 3520 'BY');
INSERT INTO `nations` VALUES ('BLZ' 'Belize' 'North America' 'Central America' 22696.00 1981 241000 70.9 630.00 616.00 'Belize' 'Constitutional Monarchy' 'Elisabeth II' 185 'BZ');
INSERT INTO `nations` VALUES ('BMU' 'Bermuda' 'North America' 'North America' 53.00 NULL 65000 76.9 2328.00 2190.00 'Bermuda' 'Dependent Territory of the UK' 'Elisabeth II' 191 'BM');
INSERT INTO `nations` VALUES ('BOL' 'Bolivia' 'South America' 'South America' 1098581.00 1825 8329000 63.7 8571.00 7967.00 'Bolivia' 'Republic' 'Hugo Bánzer Suárez' 194 'BO');
INSERT INTO `nations` VALUES ('BRA' 'Brazil' 'South America' 'South America' 8547403.00 1822 170115000 62.9 776739.00 804108.00 'Brasil' 'Federal Republic' 'Fernando Henrique Cardoso' 211 'BR');
INSERT INTO `nations` VALUES ('BRB' 'Barbados' 'North America' 'Caribbean' 430.00 1966 270000 73.0 2223.00 2186.00 'Barbados' 'Constitutional Monarchy' 'Elisabeth II' 174 'BB');
INSERT INTO `nations` VALUES ('BRN' 'Brunei' 'Asia' 'Southeast Asia' 5765.00 1984 328000 73.6 11705.00 12460.00 'Brunei Darussalam' 'Monarchy (Sultanate)' 'Haji Hassan al-Bolkiah' 538 'BN');
INSERT INTO `nations` VALUES ('BTN' 'Bhutan' 'Asia' 'Southern and Central Asia' 47000.00 1910 2124000 52.4 372.00 383.00 'Druk-Yul' 'Monarchy' 'Jigme Singye Wangchuk' 192 'BT');
INSERT INTO `nations` VALUES ('BVT' 'Bouvet Island' 'Antarctica' 'Antarctica' 59.00 NULL 0 NULL 0.00 NULL 'Bouvetøya' 'Dependent Territory of Norway' 'Harald V' NULL 'BV');
INSERT INTO `nations` VALUES ('BWA' 'Botswana' 'Africa' 'Southern Africa' 581730.00 1966 1622000 39.3 4834.00 4935.00 'Botswana' 'Republic' 'Festus G. Mogae' 204 'BW');
INSERT INTO `nations` VALUES ('CAF' 'Central African Republic' 'Africa' 'Central Africa' 622984.00 1960 3615000 44.0 1054.00 993.00 'Centrafrique/Bê-Afrîka' 'Republic' 'Ange-Félix Patassé' 1889 'CF');
INSERT INTO `nations` VALUES ('CAN' 'Canada' 'North America' 'North America' 9970610.00 1867 31147000 79.4 598862.00 625626.00 'Canada' 'Constitutional Monarchy Federation' 'Elisabeth II' 1822 'CA');
INSERT INTO `nations` VALUES ('CCK' 'Cocos (Keeling) Islands' 'Oceania' 'Australia and New Zealand' 14.00 NULL 600 NULL 0.00 NULL 'Cocos (Keeling) Islands' 'Territory of Australia' 'Elisabeth II' 2317 'CC');
INSERT INTO `nations` VALUES ('CHE' 'Switzerland' 'Europe' 'Western Europe' 41284.00 1499 7160400 79.6 264478.00 256092.00 'Schweiz/Suisse/Svizzera/Svizra' 'Federation' 'Adolf Ogi' 3248 'CH');
INSERT INTO `nations` VALUES ('CHL' 'Chile' 'South America' 'South America' 756626.00 1810 15211000 75.7 72949.00 75780.00 'Chile' 'Republic' 'Ricardo Lagos Escobar' 554 'CL');
INSERT INTO `nations` VALUES ('CHN' 'China' 'Asia' 'Eastern Asia' 9572900.00 -1523 1277558000 71.4 982268.00 917719.00 'Zhongquo' 'Peoples Republic' 'Xi Jinping' 1891 'CN');
INSERT INTO `nations` VALUES ('CIV' 'Côte d’Ivoire' 'Africa' 'Western Africa' 322463.00 1960 14786000 45.2 11345.00 10285.00 'Côte d’Ivoire' 'Republic' 'Laurent Gbagbo' 2814 'CI');
INSERT INTO `nations` VALUES ('CMR' 'Cameroon' 'Africa' 'Central Africa' 475442.00 1960 15085000 54.8 9174.00 8596.00 'Cameroun/Cameroon' 'Republic' 'Paul Biya' 1804 'CM');
INSERT INTO `nations` VALUES ('COD' 'Congo The Democratic Republic of the' 'Africa' 'Central Africa' 2344858.00 1960 51654000 48.8 6964.00 2474.00 'République Démocratique du Congo' 'Republic' 'Joseph Kabila' 2298 'CD');
INSERT INTO `nations` VALUES ('COG' 'Congo' 'Africa' 'Central Africa' 342000.00 1960 2943000 47.4 2108.00 2287.00 'Congo' 'Republic' 'Denis Sassou-Nguesso' 2296 'CG');
INSERT INTO `nations` VALUES ('COK' 'Cook Islands' 'Oceania' 'Polynesia' 236.00 NULL 20000 71.1 100.00 NULL 'The Cook Islands' 'Nonmetropolitan Territory of New Zealand' 'Elisabeth II' 583 'CK');
INSERT INTO `nations` VALUES ('COL' 'Colombia' 'South America' 'South America' 1138914.00 1810 42321000 70.3 102896.00 105116.00 'Colombia' 'Republic' 'Andrés Pastrana Arango' 2257 'CO');
INSERT INTO `nations` VALUES ('COM' 'Comoros' 'Africa' 'Eastern Africa' 1862.00 1975 578000 60.0 4401.00 4361.00 'Komori/Comores' 'Republic' 'Azali Assoumani' 2295 'KM');
INSERT INTO `nations` VALUES ('CPV' 'Cape Verde' 'Africa' 'Western Africa' 4033.00 1975 428000 68.9 435.00 420.00 'Cabo Verde' 'Republic' 'António Mascarenhas Monteiro' 1859 'CV');
INSERT INTO `nations` VALUES ('CRI' 'Costa Rica' 'North America' 'Central America' 51100.00 1821 4023000 75.8 10226.00 9757.00 'Costa Rica' 'Republic' 'Miguel Ángel Rodríguez Echeverría' 584 'CR');
INSERT INTO `nations` VALUES ('CUB' 'Cuba' 'North America' 'Caribbean' 110861.00 1902 11201000 76.2 17843.00 18862.00 'Cuba' 'Socialistic Republic' 'Fidel Castro Ruz' 2413 'CU');
INSERT INTO `nations` VALUES ('CXR' 'Christmas Island' 'Oceania' 'Australia and New Zealand' 135.00 NULL 2500 NULL 0.00 NULL 'Christmas Island' 'Territory of Australia' 'Elisabeth II' 1791 'CX');
INSERT INTO `nations` VALUES ('CYM' 'Cayman Islands' 'North America' 'Caribbean' 264.00 NULL 38000 78.9 1263.00 1186.00 'Cayman Islands' 'Dependent Territory of the UK' 'Elisabeth II' 553 'KY');
INSERT INTO `nations` VALUES ('CYP' 'Cyprus' 'Asia' 'Middle East' 9251.00 1960 754700 76.7 9333.00 8246.00 'Kýpros/Kibris' 'Republic' 'Glafkos Klerides' 2430 'CY');
INSERT INTO `nations` VALUES ('CZE' 'Czech Republic' 'Europe' 'Eastern Europe' 78866.00 1993 10278100 74.5 55017.00 52037.00 '¸esko' 'Republic' 'Václav Havel' 3339 'CZ');
INSERT INTO `nations` VALUES ('DEU' 'Germany' 'Europe' 'Western Europe' 357022.00 1955 82164700 77.4 2133367.00 2102826.00 'Deutschland' 'Federal Republic' 'Johannes Rau' 3068 'DE');
INSERT INTO `nations` VALUES ('DJI' 'Djibouti' 'Africa' 'Eastern Africa' 23200.00 1977 638000 50.8 382.00 373.00 'Djibouti/Jibuti' 'Republic' 'Ismail Omar Guelleh' 585 'DJ');
INSERT INTO `nations` VALUES ('DMA' 'Dominica' 'North America' 'Caribbean' 751.00 1978 71000 73.4 256.00 243.00 'Dominica' 'Republic' 'Vernon Shaw' 586 'DM');
INSERT INTO `nations` VALUES ('DNK' 'Denmark' 'Europe' 'Nordic Countries' 43094.00 800 5330000 76.5 174099.00 169264.00 'Danmark' 'Constitutional Monarchy' 'Margrethe II' 3315 'DK');
INSERT INTO `nations` VALUES ('DOM' 'Dominican Republic' 'North America' 'Caribbean' 48511.00 1844 8495000 73.2 15846.00 15076.00 'República Dominicana' 'Republic' 'Hipólito Mejía Domínguez' 587 'DO');
INSERT INTO `nations` VALUES ('DZA' 'Algeria' 'Africa' 'Northern Africa' 2381741.00 1962 31471000 69.7 49982.00 46966.00 'Al-Jaza’ir/Algérie' 'Republic' 'Abdelaziz Bouteflika' 35 'DZ');
INSERT INTO `nations` VALUES ('ECU' 'Ecuador' 'South America' 'South America' 283561.00 1822 12646000 71.1 19770.00 19769.00 'Ecuador' 'Republic' 'Gustavo Noboa Bejarano' 594 'EC');
INSERT INTO `nations` VALUES ('EGY' 'Egypt' 'Africa' 'Northern Africa' 1001449.00 1922 68470000 63.3 82710.00 75617.00 'Misr' 'Republic' 'Hosni Mubarak' 608 'EG');
INSERT INTO `nations` VALUES ('ERI' 'Eritrea' 'Africa' 'Eastern Africa' 117600.00 1993 3850000 55.8 650.00 755.00 'Ertra' 'Republic' 'Isayas Afewerki [Isaias Afwerki]' 652 'ER');
INSERT INTO `nations` VALUES ('ESH' 'Western Sahara' 'Africa' 'Northern Africa' 266000.00 NULL 293000 49.8 60.00 NULL 'As-Sahrawiya' 'Occupied by Marocco' 'Mohammed Abdel Aziz' 2453 'EH');
INSERT INTO `nations` VALUES ('ESP' 'Spain' 'Europe' 'Southern Europe' 505992.00 1492 39441700 78.8 553233.00 532031.00 'España' 'Constitutional Monarchy' 'Juan Carlos I' 653 'ES');
INSERT INTO `nations` VALUES ('EST' 'Estonia' 'Europe' 'Baltic Countries' 45227.00 1991 1439200 69.5 5328.00 3371.00 'Eesti' 'Republic' 'Lennart Meri' 3791 'EE');
INSERT INTO `nations` VALUES ('ETH' 'Ethiopia' 'Africa' 'Eastern Africa' 1104300.00 -1000 62565000 45.2 6353.00 6180.00 'YeItyop´iya' 'Republic' 'Negasso Gidada' 756 'ET');
INSERT INTO `nations` VALUES ('FIN' 'Finland' 'Europe' 'Nordic Countries' 338145.00 1917 5171300 77.4 121914.00 119833.00 'Suomi' 'Republic' 'Tarja Halonen' 3236 'FI');
INSERT INTO `nations` VALUES ('FJI' 'Fiji Islands' 'Oceania' 'Melanesia' 18274.00 1970 817000 67.9 1536.00 2149.00 'Fiji Islands' 'Republic' 'Josefa Iloilo' 764 'FJ');
INSERT INTO `nations` VALUES ('FLK' 'Falkland Islands' 'South America' 'South America' 12173.00 NULL 2000 NULL 0.00 NULL 'Falkland Islands' 'Dependent Territory of the UK' 'Elisabeth II' 763 'FK');
INSERT INTO `nations` VALUES ('FRA' 'France' 'Europe' 'Western Europe' 551500.00 843 59225700 78.8 1424285.00 1392448.00 'France' 'Republic' 'Jacques Chirac' 2974 'FR');
INSERT INTO `nations` VALUES ('FRO' 'Faroe Islands' 'Europe' 'Nordic Countries' 1399.00 NULL 43000 78.4 0.00 NULL 'Føroyar' 'Part of Denmark' 'Margrethe II' 901 'FO');
INSERT INTO `nations` VALUES ('FSM' 'Micronesia Federated States of' 'Oceania' 'Micronesia' 702.00 1990 119000 68.6 212.00 NULL 'Micronesia' 'Federal Republic' 'Leo A. Falcam' 2689 'FM');
INSERT INTO `nations` VALUES ('GAB' 'Gabon' 'Africa' 'Central Africa' 267668.00 1960 1226000 50.1 5493.00 5279.00 'Le Gabon' 'Republic' 'Omar Bongo' 902 'GA');
INSERT INTO `nations` VALUES ('GBR' 'United Kingdom' 'Europe' 'British Islands' 242900.00 1066 59623400 77.7 1378330.00 1296830.00 'United Kingdom' 'Constitutional Monarchy' 'Elisabeth II' 456 'GB');
INSERT INTO `nations` VALUES ('GEO' 'Georgia' 'Asia' 'Middle East' 69700.00 1991 4968000 64.5 6064.00 5924.00 'Sakartvelo' 'Republic' 'Eduard Ševardnadze' 905 'GE');
INSERT INTO `nations` VALUES ('GHA' 'Ghana' 'Africa' 'Western Africa' 238533.00 1957 20212000 57.4 7137.00 6884.00 'Ghana' 'Republic' 'John Kufuor' 910 'GH');
INSERT INTO `nations` VALUES ('GIB' 'Gibraltar' 'Europe' 'Southern Europe' 6.00 NULL 25000 79.0 258.00 NULL 'Gibraltar' 'Dependent Territory of the UK' 'Elisabeth II' 915 'GI');
INSERT INTO `nations` VALUES ('GIN' 'Guinea' 'Africa' 'Western Africa' 245857.00 1958 7430000 45.6 2352.00 2383.00 'Guinée' 'Republic' 'Lansana Conté' 926 'GN');
INSERT INTO `nations` VALUES ('GLP' 'Guadeloupe' 'North America' 'Caribbean' 1705.00 NULL 456000 77.0 3501.00 NULL 'Guadeloupe' 'Overseas Department of France' 'Jacques Chirac' 919 'GP');
INSERT INTO `nations` VALUES ('GMB' 'Gambia' 'Africa' 'Western Africa' 11295.00 1965 1305000 53.2 320.00 325.00 'The Gambia' 'Republic' 'Yahya Jammeh' 904 'GM');
INSERT INTO `nations` VALUES ('GNB' 'Guinea-Bissau' 'Africa' 'Western Africa' 36125.00 1974 1213000 49.0 293.00 272.00 'Guiné-Bissau' 'Republic' 'Kumba Ialá' 927 'GW');
INSERT INTO `nations` VALUES ('GNQ' 'Equatorial Guinea' 'Africa' 'Central Africa' 28051.00 1968 453000 53.6 283.00 542.00 'Guinea Ecuatorial' 'Republic' 'Teodoro Obiang Nguema Mbasogo' 2972 'GQ');
INSERT INTO `nations` VALUES ('GRC' 'Greece' 'Europe' 'Southern Europe' 131626.00 1830 10545700 78.4 120724.00 119946.00 'Elláda' 'Republic' 'Kostis Stefanopoulos' 2401 'GR');
INSERT INTO `nations` VALUES ('GRD' 'Grenada' 'North America' 'Caribbean' 344.00 1974 94000 64.5 318.00 NULL 'Grenada' 'Constitutional Monarchy' 'Elisabeth II' 916 'GD');
INSERT INTO `nations` VALUES ('GRL' 'Greenland' 'North America' 'North America' 2166090.00 NULL 56000 68.1 0.00 NULL 'Kalaallit Nunaat/Grønland' 'Part of Denmark' 'Margrethe II' 917 'GL');
INSERT INTO `nations` VALUES ('GTM' 'Guatemala' 'North America' 'Central America' 108889.00 1821 11385000 66.2 19008.00 17797.00 'Guatemala' 'Republic' 'Alfonso Portillo Cabrera' 922 'GT');
INSERT INTO `nations` VALUES ('GUF' 'French Guiana' 'South America' 'South America' 90000.00 NULL 181000 76.1 681.00 NULL 'Guyane française' 'Overseas Department of France' 'Jacques Chirac' 3014 'GF');
INSERT INTO `nations` VALUES ('GUM' 'Guam' 'Oceania' 'Micronesia' 549.00 NULL 168000 77.8 1197.00 1136.00 'Guam' 'US Territory' 'George W. Bush' 921 'GU');
INSERT INTO `nations` VALUES ('GUY' 'Guyana' 'South America' 'South America' 214969.00 1966 861000 64.0 722.00 743.00 'Guyana' 'Republic' 'Bharrat Jagdeo' 928 'GY');
INSERT INTO `nations` VALUES ('HKG' 'Hong Kong' 'Asia' 'Eastern Asia' 1075.00 NULL 6782000 79.5 166448.00 173610.00 'Xianggang/Hong Kong' 'Special Administrative Region of China' 'Jiang Zemin' 937 'HK');
INSERT INTO `nations` VALUES ('HMD' 'Heard Island and McDonald Islands' 'Antarctica' 'Antarctica' 359.00 NULL 0 NULL 0.00 NULL 'Heard and McDonald Islands' 'Territory of Australia' 'Elisabeth II' NULL 'HM');
INSERT INTO `nations` VALUES ('HND' 'Honduras' 'North America' 'Central America' 112088.00 1838 6485000 69.9 5333.00 4697.00 'Honduras' 'Republic' 'Carlos Roberto Flores Facussé' 933 'HN');
INSERT INTO `nations` VALUES ('HRV' 'Croatia' 'Europe' 'Southern Europe' 56538.00 1991 4473000 73.7 20208.00 19300.00 'Hrvatska' 'Republic' 'Štipe Mesic' 2409 'HR');
INSERT INTO `nations` VALUES ('HTI' 'Haiti' 'North America' 'Caribbean' 27750.00 1804 8222000 49.2 3459.00 3107.00 'Haïti/Dayti' 'Republic' 'Jean-Bertrand Aristide' 929 'HT');
INSERT INTO `nations` VALUES ('HUN' 'Hungary' 'Europe' 'Eastern Europe' 93030.00 1918 10043200 71.4 48267.00 45914.00 'Magyarország' 'Republic' 'Ferenc Mádl' 3483 'HU');
INSERT INTO `nations` VALUES ('IDN' 'Indonesia' 'Asia' 'Southeast Asia' 1904569.00 1945 212107000 68.0 84982.00 215002.00 'Indonesia' 'Republic' 'Abdurrahman Wahid' 939 'ID');
INSERT INTO `nations` VALUES ('IND' 'India' 'Asia' 'Southern and Central Asia' 3287263.00 1947 1013662000 62.5 447114.00 430572.00 'Bharat/India' 'Federal Republic' 'Kocheril Raman Narayanan' 1109 'IN');
INSERT INTO `nations` VALUES ('IOT' 'British Indian Ocean Territory' 'Africa' 'Eastern Africa' 78.00 NULL 0 NULL 0.00 NULL 'British Indian Ocean Territory' 'Dependent Territory of the UK' 'Elisabeth II' NULL 'IO');
INSERT INTO `nations` VALUES ('IRL' 'Ireland' 'Europe' 'British Islands' 70273.00 1921 3775100 76.8 75921.00 73132.00 'Ireland/Éire' 'Republic' 'Mary McAleese' 1447 'IE');
INSERT INTO `nations` VALUES ('IRN' 'Iran' 'Asia' 'Southern and Central Asia' 1648195.00 1906 67702000 69.7 195746.00 160151.00 'Iran' 'Islamic Republic' 'Ali Mohammad Khatami-Ardakani' 1380 'IR');
INSERT INTO `nations` VALUES ('IRQ' 'Iraq' 'Asia' 'Middle East' 438317.00 1932 23115000 66.5 11500.00 NULL 'Al-´Iraq' 'Republic' 'Saddam Hussein al-Takriti' 1365 'IQ');
INSERT INTO `nations` VALUES ('ISL' 'Iceland' 'Europe' 'Nordic Countries' 103000.00 1944 279000 79.4 8255.00 7474.00 'Ísland' 'Republic' 'Ólafur Ragnar Grímsson' 1449 'IS');
INSERT INTO `nations` VALUES ('ISR' 'Israel' 'Asia' 'Middle East' 21056.00 1948 6217000 78.6 97477.00 98577.00 'Yisra’el/Isra’il' 'Republic' 'Moshe Katzav' 1450 'IL');
INSERT INTO `nations` VALUES ('ITA' 'Italy' 'Europe' 'Southern Europe' 301316.00 1861 57680000 79.0 1161755.00 1145372.00 'Italia' 'Republic' 'Carlo Azeglio Ciampi' 1464 'IT');
INSERT INTO `nations` VALUES ('JAM' 'Jamaica' 'North America' 'Caribbean' 10990.00 1962 2583000 75.2 6871.00 6722.00 'Jamaica' 'Constitutional Monarchy' 'Elisabeth II' 1530 'JM');
INSERT INTO `nations` VALUES ('JOR' 'Jordan' 'Asia' 'Middle East' 88946.00 1946 5083000 77.4 7526.00 7051.00 'Al-Urdunn' 'Constitutional Monarchy' 'Abdullah II' 1786 'JO');
INSERT INTO `nations` VALUES ('JPN' 'Japan' 'Asia' 'Eastern Asia' 377829.00 -660 126714000 80.7 3787042.00 4192638.00 'Nihon/Nippon' 'Constitutional Monarchy' 'Akihito' 1532 'JP');
INSERT INTO `nations` VALUES ('KAZ' 'Kazakstan' 'Asia' 'Southern and Central Asia' 2724900.00 1991 16223000 63.2 24375.00 23383.00 'Qazaqstan' 'Republic' 'Nursultan Nazarbajev' 1864 'KZ');
INSERT INTO `nations` VALUES ('KEN' 'Kenya' 'Africa' 'Eastern Africa' 580367.00 1963 30080000 48.0 9217.00 10241.00 'Kenya' 'Republic' 'Daniel arap Moi' 1881 'KE');
INSERT INTO `nations` VALUES ('KGZ' 'Kyrgyzstan' 'Asia' 'Southern and Central Asia' 199900.00 1991 4699000 63.4 1626.00 1767.00 'Kyrgyzstan' 'Republic' 'Askar Akajev' 2253 'KG');
INSERT INTO `nations` VALUES ('KHM' 'Cambodia' 'Asia' 'Southeast Asia' 181035.00 1953 11168000 56.5 5121.00 5670.00 'Kâmpuchéa' 'Constitutional Monarchy' 'Norodom Sihanouk' 1800 'KH');
INSERT INTO `nations` VALUES ('KIR' 'Kiribati' 'Oceania' 'Micronesia' 726.00 1979 83000 59.8 40.70 NULL 'Kiribati' 'Republic' 'Teburoro Tito' 2256 'KI');
INSERT INTO `nations` VALUES ('KNA' 'Saint Kitts and Nevis' 'North America' 'Caribbean' 261.00 1983 38000 70.7 299.00 NULL 'Saint Kitts and Nevis' 'Constitutional Monarchy' 'Elisabeth II' 3064 'KN');
INSERT INTO `nations` VALUES ('KOR' 'South Korea' 'Asia' 'Eastern Asia' 99434.00 1948 46844000 74.4 320749.00 442544.00 'Taehan Min’guk (Namhan)' 'Republic' 'Kim Dae-jung' 2331 'KR');
INSERT INTO `nations` VALUES ('KWT' 'Kuwait' 'Asia' 'Middle East' 17818.00 1961 1972000 76.1 27037.00 30373.00 'Al-Kuwayt' 'Constitutional Monarchy (Emirate)' 'Jabir al-Ahmad al-Jabir al-Sabah' 2429 'KW');
INSERT INTO `nations` VALUES ('LAO' 'Laos' 'Asia' 'Southeast Asia' 236800.00 1953 5433000 53.1 1292.00 1746.00 'Lao' 'Republic' 'Khamtay Siphandone' 2432 'LA');
INSERT INTO `nations` VALUES ('LBN' 'Lebanon' 'Asia' 'Middle East' 10400.00 1941 3282000 71.3 17121.00 15129.00 'Lubnan' 'Republic' 'Émile Lahoud' 2438 'LB');
INSERT INTO `nations` VALUES ('LBR' 'Liberia' 'Africa' 'Western Africa' 111369.00 1847 3154000 51.0 2012.00 NULL 'Liberia' 'Republic' 'Charles Taylor' 2440 'LR');
INSERT INTO `nations` VALUES ('LBY' 'Libyan Arab Jamahiriya' 'Africa' 'Northern Africa' 1759540.00 1951 5605000 75.5 44806.00 40562.00 'Libiya' 'Socialistic State' 'Muammar al-Qadhafi' 2441 'LY');
INSERT INTO `nations` VALUES ('LCA' 'Saint Lucia' 'North America' 'Caribbean' 622.00 1979 154000 72.3 571.00 NULL 'Saint Lucia' 'Constitutional Monarchy' 'Elisabeth II' 3065 'LC');
INSERT INTO `nations` VALUES ('LIE' 'Liechtenstein' 'Europe' 'Western Europe' 160.00 1806 32300 78.8 1119.00 1084.00 'Liechtenstein' 'Constitutional Monarchy' 'Hans-Adam II' 2446 'LI');
INSERT INTO `nations` VALUES ('LKA' 'Sri Lanka' 'Asia' 'Southern and Central Asia' 65610.00 1948 18827000 71.8 15706.00 15091.00 'Sri Lanka/Ilankai' 'Republic' 'Chandrika Kumaratunga' 3217 'LK');
INSERT INTO `nations` VALUES ('LSO' 'Lesotho' 'Africa' 'Southern Africa' 30355.00 1966 2153000 50.8 1061.00 1161.00 'Lesotho' 'Constitutional Monarchy' 'Letsie III' 2437 'LS');
INSERT INTO `nations` VALUES ('LTU' 'Lithuania' 'Europe' 'Baltic Countries' 65301.00 1991 3698500 69.1 10692.00 9585.00 'Lietuva' 'Republic' 'Valdas Adamkus' 2447 'LT');
INSERT INTO `nations` VALUES ('LUX' 'Luxembourg' 'Europe' 'Western Europe' 2586.00 1867 435700 77.1 16321.00 15519.00 'Luxembourg/Lëtzebuerg' 'Constitutional Monarchy' 'Henri' 2452 'LU');
INSERT INTO `nations` VALUES ('LVA' 'Latvia' 'Europe' 'Baltic Countries' 64589.00 1991 2424200 68.4 6398.00 5639.00 'Latvija' 'Republic' 'Vaira Vike-Freiberga' 2434 'LV');
INSERT INTO `nations` VALUES ('MAC' 'Macao' 'Asia' 'Eastern Asia' 18.00 NULL 473000 81.6 5749.00 5940.00 'Macau/Aomen' 'Special Administrative Region of China' 'Jiang Zemin' 2454 'MO');
INSERT INTO `nations` VALUES ('MAR' 'Morocco' 'Africa' 'Northern Africa' 446550.00 1956 28351000 69.1 36124.00 33514.00 'Al-Maghrib' 'Constitutional Monarchy' 'Mohammed VI' 2486 'MA');
INSERT INTO `nations` VALUES ('MCO' 'Monaco' 'Europe' 'Western Europe' 1.50 1861 34000 78.8 776.00 NULL 'Monaco' 'Constitutional Monarchy' 'Rainier III' 2695 'MC');
INSERT INTO `nations` VALUES ('MDA' 'Moldova' 'Europe' 'Eastern Europe' 33851.00 1991 4380000 64.5 1579.00 1872.00 'Moldova' 'Republic' 'Vladimir Voronin' 2690 'MD');
INSERT INTO `nations` VALUES ('MDG' 'Madagascar' 'Africa' 'Eastern Africa' 587041.00 1960 15942000 55.0 3750.00 3545.00 'Madagasikara/Madagascar' 'Federal Republic' 'Didier Ratsiraka' 2455 'MG');
INSERT INTO `nations` VALUES ('MDV' 'Maldives' 'Asia' 'Southern and Central Asia' 298.00 1965 286000 62.2 199.00 NULL 'Dhivehi Raajje/Maldives' 'Republic' 'Maumoon Abdul Gayoom' 2463 'MV');
INSERT INTO `nations` VALUES ('MEX' 'Mexico' 'North America' 'Central America' 1958201.00 1810 98881000 71.5 414972.00 401461.00 'México' 'Federal Republic' 'Vicente Fox Quesada' 2515 'MX');
INSERT INTO `nations` VALUES ('MHL' 'Marshall Islands' 'Oceania' 'Micronesia' 181.00 1990 64000 65.5 97.00 NULL 'Marshall Islands/Majol' 'Republic' 'Kessai Note' 2507 'MH');
INSERT INTO `nations` VALUES ('MKD' 'Macedonia' 'Europe' 'Southern Europe' 25713.00 1991 2024000 73.8 1694.00 1915.00 'Makedonija' 'Republic' 'Boris Trajkovski' 2460 'MK');
INSERT INTO `nations` VALUES ('MLI' 'Mali' 'Africa' 'Western Africa' 1240192.00 1960 11234000 46.7 2642.00 2453.00 'Mali' 'Republic' 'Alpha Oumar Konaré' 2482 'ML');
INSERT INTO `nations` VALUES ('MLT' 'Malta' 'Europe' 'Southern Europe' 316.00 1964 380200 77.9 3512.00 3338.00 'Malta' 'Republic' 'Guido de Marco' 2484 'MT');
INSERT INTO `nations` VALUES ('MMR' 'Myanmar' 'Asia' 'Southeast Asia' 676578.00 1948 45611000 54.9 180375.00 171028.00 'Myanma Pye' 'Republic' 'kenraali Than Shwe' 2710 'MM');
INSERT INTO `nations` VALUES ('MNG' 'Mongolia' 'Asia' 'Eastern Asia' 1566500.00 1921 2662000 67.3 1043.00 933.00 'Mongol Uls' 'Republic' 'Natsagiin Bagabandi' 2696 'MN');
INSERT INTO `nations` VALUES ('MNP' 'Northern Mariana Islands' 'Oceania' 'Micronesia' 464.00 NULL 78000 75.5 0.00 NULL 'Northern Mariana Islands' 'Commonwealth of the US' 'George W. Bush' 2913 'MP');
INSERT INTO `nations` VALUES ('MOZ' 'Mozambique' 'Africa' 'Eastern Africa' 801590.00 1975 19680000 37.5 2891.00 2711.00 'Moçambique' 'Republic' 'Joaquím A. Chissano' 2698 'MZ');
INSERT INTO `nations` VALUES ('MRT' 'Mauritania' 'Africa' 'Western Africa' 1025520.00 1960 2670000 50.8 998.00 1081.00 'Muritaniya/Mauritanie' 'Republic' 'Maaouiya Ould Sid´Ahmad Taya' 2509 'MR');
INSERT INTO `nations` VALUES ('MSR' 'Montserrat' 'North America' 'Caribbean' 102.00 NULL 11000 78.0 109.00 NULL 'Montserrat' 'Dependent Territory of the UK' 'Elisabeth II' 2697 'MS');
INSERT INTO `nations` VALUES ('MTQ' 'Martinique' 'North America' 'Caribbean' 1102.00 NULL 395000 78.3 2731.00 2559.00 'Martinique' 'Overseas Department of France' 'Jacques Chirac' 2508 'MQ');
INSERT INTO `nations` VALUES ('MUS' 'Mauritius' 'Africa' 'Eastern Africa' 2040.00 1968 1158000 71.0 4251.00 4186.00 'Mauritius' 'Republic' 'Cassam Uteem' 2511 'MU');
INSERT INTO `nations` VALUES ('MWI' 'Malawi' 'Africa' 'Eastern Africa' 118484.00 1964 10925000 37.6 1687.00 2527.00 'Malawi' 'Republic' 'Bakili Muluzi' 2462 'MW');
INSERT INTO `nations` VALUES ('MYS' 'Malaysia' 'Asia' 'Southeast Asia' 329758.00 1957 22244000 70.8 69213.00 97884.00 'Malaysia' 'Constitutional Monarchy Federation' 'Salahuddin Abdul Aziz Shah Alhaj' 2464 'MY');
INSERT INTO `nations` VALUES ('MYT' 'Mayotte' 'Africa' 'Eastern Africa' 373.00 NULL 149000 59.5 0.00 NULL 'Mayotte' 'Territorial Collectivity of France' 'Jacques Chirac' 2514 'YT');
INSERT INTO `nations` VALUES ('NAM' 'Namibia' 'Africa' 'Southern Africa' 824292.00 1990 1726000 42.5 3101.00 3384.00 'Namibia' 'Republic' 'Sam Nujoma' 2726 'NA');
INSERT INTO `nations` VALUES ('NCL' 'New Caledonia' 'Oceania' 'Melanesia' 18575.00 NULL 214000 72.8 3563.00 NULL 'Nouvelle-Calédonie' 'Nonmetropolitan Territory of France' 'Jacques Chirac' 3493 'NC');
INSERT INTO `nations` VALUES ('NER' 'Niger' 'Africa' 'Western Africa' 1267000.00 1960 10730000 41.3 1706.00 1580.00 'Niger' 'Republic' 'Mamadou Tandja' 2738 'NE');
INSERT INTO `nations` VALUES ('NFK' 'Norfolk Island' 'Oceania' 'Australia and New Zealand' 36.00 NULL 2000 NULL 0.00 NULL 'Norfolk Island' 'Territory of Australia' 'Elisabeth II' 2806 'NF');
INSERT INTO `nations` VALUES ('NGA' 'Nigeria' 'Africa' 'Western Africa' 923768.00 1960 111506000 51.6 65707.00 58623.00 'Nigeria' 'Federal Republic' 'Olusegun Obasanjo' 2754 'NG');
INSERT INTO `nations` VALUES ('NIC' 'Nicaragua' 'North America' 'Central America' 130000.00 1838 5074000 68.7 1988.00 2023.00 'Nicaragua' 'Republic' 'Arnoldo Alemán Lacayo' 2734 'NI');
INSERT INTO `nations` VALUES ('NIU' 'Niue' 'Oceania' 'Polynesia' 260.00 NULL 2000 NULL 0.00 NULL 'Niue' 'Nonmetropolitan Territory of New Zealand' 'Elisabeth II' 2805 'NU');
INSERT INTO `nations` VALUES ('NLD' 'Netherlands' 'Europe' 'Western Europe' 41526.00 1581 15864000 78.3 371362.00 360478.00 'Nederland' 'Constitutional Monarchy' 'Beatrix' 5 'NL');
INSERT INTO `nations` VALUES ('NOR' 'Norway' 'Europe' 'Nordic Countries' 323877.00 1905 4478500 78.7 145895.00 153370.00 'Norge' 'Constitutional Monarchy' 'Harald V' 2807 'NO');
INSERT INTO `nations` VALUES ('NPL' 'Nepal' 'Asia' 'Southern and Central Asia' 147181.00 1769 23930000 57.8 4768.00 4837.00 'Nepal' 'Constitutional Monarchy' 'Gyanendra Bir Bikram' 2729 'NP');
INSERT INTO `nations` VALUES ('NRU' 'Nauru' 'Oceania' 'Micronesia' 21.00 1968 12000 60.8 197.00 NULL 'Naoero/Nauru' 'Republic' 'Bernard Dowiyogo' 2728 'NR');
INSERT INTO `nations` VALUES ('NZL' 'New Zealand' 'Oceania' 'Australia and New Zealand' 270534.00 1907 3862000 77.8 54669.00 64960.00 'New Zealand/Aotearoa' 'Constitutional Monarchy' 'Elisabeth II' 3499 'NZ');
INSERT INTO `nations` VALUES ('OMN' 'Oman' 'Asia' 'Middle East' 309500.00 1951 2542000 71.8 16904.00 16153.00 '´Uman' 'Monarchy (Sultanate)' 'Qabus ibn Sa´id' 2821 'OM');
INSERT INTO `nations` VALUES ('PAK' 'Pakistan' 'Asia' 'Southern and Central Asia' 796095.00 1947 156483000 61.1 61289.00 58549.00 'Pakistan' 'Republic' 'Mohammad Rafiq Tarar' 2831 'PK');
INSERT INTO `nations` VALUES ('PAN' 'Panama' 'North America' 'Central America' 75517.00 1903 2856000 75.5 9131.00 8700.00 'Panamá' 'Republic' 'Mireya Elisa Moscoso Rodríguez' 2882 'PA');
INSERT INTO `nations` VALUES ('PCN' 'Pitcairn' 'Oceania' 'Polynesia' 49.00 NULL 50 NULL 0.00 NULL 'Pitcairn' 'Dependent Territory of the UK' 'Elisabeth II' 2912 'PN');
INSERT INTO `nations` VALUES ('PER' 'Peru' 'South America' 'South America' 1285216.00 1821 25662000 70.0 64140.00 65186.00 'Perú/Piruw' 'Republic' 'Valentin Paniagua Corazao' 2890 'PE');
INSERT INTO `nations` VALUES ('PHL' 'Philippines' 'Asia' 'Southeast Asia' 300000.00 1946 75967000 67.5 65107.00 82239.00 'Pilipinas' 'Republic' 'Gloria Macapagal-Arroyo' 766 'PH');
INSERT INTO `nations` VALUES ('PLW' 'Palau' 'Oceania' 'Micronesia' 459.00 1994 19000 68.6 105.00 NULL 'Belau/Palau' 'Republic' 'Kuniwo Nakamura' 2881 'PW');
INSERT INTO `nations` VALUES ('PNG' 'Papua New Guinea' 'Oceania' 'Melanesia' 462840.00 1975 4807000 63.1 4988.00 6328.00 'Papua New Guinea/Papua Niugini' 'Constitutional Monarchy' 'Elisabeth II' 2884 'PG');
INSERT INTO `nations` VALUES ('POL' 'Poland' 'Europe' 'Eastern Europe' 323250.00 1918 38653600 73.2 151697.00 135636.00 'Polska' 'Republic' 'Aleksander Kwasniewski' 2928 'PL');
INSERT INTO `nations` VALUES ('PRI' 'Puerto Rico' 'North America' 'Caribbean' 8875.00 NULL 3869000 75.6 34100.00 32100.00 'Puerto Rico' 'Commonwealth of the US' 'George W. Bush' 2919 'PR');
INSERT INTO `nations` VALUES ('PRK' 'North Korea' 'Asia' 'Eastern Asia' 120538.00 1948 24039000 70.7 5332.00 NULL 'Choson Minjujuui In´min Konghwaguk (Bukhan)' 'Socialistic Republic' 'Kim Jong-il' 2318 'KP');
INSERT INTO `nations` VALUES ('PRT' 'Portugal' 'Europe' 'Southern Europe' 91982.00 1143 9997600 75.8 105954.00 102133.00 'Portugal' 'Republic' 'Jorge Sampãio' 2914 'PT');
INSERT INTO `nations` VALUES ('PRY' 'Paraguay' 'South America' 'South America' 406752.00 1811 5496000 73.7 8444.00 9555.00 'Paraguay' 'Republic' 'Luis Ángel González Macchi' 2885 'PY');
INSERT INTO `nations` VALUES ('PSE' 'Palestine' 'Asia' 'Middle East' 6257.00 NULL 3101000 71.4 4173.00 NULL 'Filastin' 'Autonomous Area' 'Yasser (Yasir) Arafat' 4074 'PS');
INSERT INTO `nations` VALUES ('PYF' 'French Polynesia' 'Oceania' 'Polynesia' 4000.00 NULL 235000 74.8 818.00 781.00 'Polynésie française' 'Nonmetropolitan Territory of France' 'Jacques Chirac' 3016 'PF');
INSERT INTO `nations` VALUES ('QAT' 'Qatar' 'Asia' 'Middle East' 11000.00 1971 599000 72.4 9472.00 8920.00 'Qatar' 'Monarchy' 'Hamad ibn Khalifa al-Thani' 2973 'QA');
INSERT INTO `nations` VALUES ('REU' 'Réunion' 'Africa' 'Eastern Africa' 2510.00 NULL 699000 72.7 8287.00 7988.00 'Réunion' 'Overseas Department of France' 'Jacques Chirac' 3017 'RE');
INSERT INTO `nations` VALUES ('ROM' 'Romania' 'Europe' 'Eastern Europe' 238391.00 1878 22455500 69.9 38158.00 34843.00 'România' 'Republic' 'Ion Iliescu' 3018 'RO');
INSERT INTO `nations` VALUES ('RUS' 'Russian Federation' 'Europe' 'Eastern Europe' 17075400.00 1991 146934000 67.2 276608.00 442989.00 'Rossija' 'Federal Republic' 'Vladimir Putin' 3580 'RU');
INSERT INTO `nations` VALUES ('RWA' 'Rwanda' 'Africa' 'Eastern Africa' 26338.00 1962 7733000 39.3 2036.00 1863.00 'Rwanda/Urwanda' 'Republic' 'Paul Kagame' 3047 'RW');
INSERT INTO `nations` VALUES ('SAU' 'Saudi Arabia' 'Asia' 'Middle East' 2149690.00 1932 21607000 67.8 137635.00 146171.00 'Al-´Arabiya as-Sa´udiya' 'Monarchy' 'Fahd ibn Abdul-Aziz al-Sa´ud' 3173 'SA');
INSERT INTO `nations` VALUES ('SDN' 'Sudan' 'Africa' 'Northern Africa' 2505813.00 1956 29490000 56.6 10162.00 NULL 'As-Sudan' 'Islamic Republic' 'Omar Hassan Ahmad al-Bashir' 3225 'SD');
INSERT INTO `nations` VALUES ('SEN' 'Senegal' 'Africa' 'Western Africa' 196722.00 1960 9481000 62.2 4787.00 4542.00 'Sénégal/Sounougal' 'Republic' 'Abdoulaye Wade' 3198 'SN');
INSERT INTO `nations` VALUES ('SGP' 'Singapore' 'Asia' 'Southeast Asia' 618.00 1965 3567000 80.1 86503.00 96318.00 'Singapore/Singapura/Xinjiapo/Singapur' 'Republic' 'Sellapan Rama Nathan' 3208 'SG');
INSERT INTO `nations` VALUES ('SGS' 'South Georgia and the South Sandwich Islands' 'Antarctica' 'Antarctica' 3903.00 NULL 0 NULL 0.00 NULL 'South Georgia and the South Sandwich Islands' 'Dependent Territory of the UK' 'Elisabeth II' NULL 'GS');
INSERT INTO `nations` VALUES ('SHN' 'Saint Helena' 'Africa' 'Western Africa' 314.00 NULL 6000 76.8 0.00 NULL 'Saint Helena' 'Dependent Territory of the UK' 'Elisabeth II' 3063 'SH');
INSERT INTO `nations` VALUES ('SJM' 'Svalbard and Jan Mayen' 'Europe' 'Nordic Countries' 62422.00 NULL 3200 NULL 0.00 NULL 'Svalbard og Jan Mayen' 'Dependent Territory of Norway' 'Harald V' 938 'SJ');
INSERT INTO `nations` VALUES ('SLB' 'Solomon Islands' 'Oceania' 'Melanesia' 28896.00 1978 444000 71.3 182.00 220.00 'Solomon Islands' 'Constitutional Monarchy' 'Elisabeth II' 3161 'SB');
INSERT INTO `nations` VALUES ('SLE' 'Sierra Leone' 'Africa' 'Western Africa' 71740.00 1961 4854000 45.3 746.00 858.00 'Sierra Leone' 'Republic' 'Ahmed Tejan Kabbah' 3207 'SL');
INSERT INTO `nations` VALUES ('SLV' 'El Salvador' 'North America' 'Central America' 21041.00 1841 6276000 69.7 11863.00 11203.00 'El Salvador' 'Republic' 'Francisco Guillermo Flores Pérez' 645 'SV');
INSERT INTO `nations` VALUES ('SMR' 'San Marino' 'Europe' 'Southern Europe' 61.00 885 27000 81.1 510.00 NULL 'San Marino' 'Republic' NULL 3171 'SM');
INSERT INTO `nations` VALUES ('SOM' 'Somalia' 'Africa' 'Eastern Africa' 637657.00 1960 10097000 46.2 935.00 NULL 'Soomaaliya' 'Republic' 'Abdiqassim Salad Hassan' 3214 'SO');
INSERT INTO `nations` VALUES ('SPM' 'Saint Pierre and Miquelon' 'North America' 'North America' 242.00 NULL 7000 77.6 0.00 NULL 'Saint-Pierre-et-Miquelon' 'Territorial Collectivity of France' 'Jacques Chirac' 3067 'PM');
INSERT INTO `nations` VALUES ('STP' 'Sao Tome and Principe' 'Africa' 'Central Africa' 964.00 1975 147000 65.3 6.00 NULL 'São Tomé e Príncipe' 'Republic' 'Miguel Trovoada' 3172 'ST');
INSERT INTO `nations` VALUES ('SUR' 'Suriname' 'South America' 'South America' 163265.00 1975 417000 71.4 870.00 706.00 'Suriname' 'Republic' 'Ronald Venetiaan' 3243 'SR');
INSERT INTO `nations` VALUES ('SVK' 'Slovakia' 'Europe' 'Eastern Europe' 49012.00 1993 5398700 73.7 20594.00 19452.00 'Slovensko' 'Republic' 'Rudolf Schuster' 3209 'SK');
INSERT INTO `nations` VALUES ('SVN' 'Slovenia' 'Europe' 'Southern Europe' 20256.00 1991 1987800 74.9 19756.00 18202.00 'Slovenija' 'Republic' 'Milan Kucan' 3212 'SI');
INSERT INTO `nations` VALUES ('SWE' 'Sweden' 'Europe' 'Nordic Countries' 449964.00 836 8861400 79.6 226492.00 227757.00 'Sverige' 'Constitutional Monarchy' 'Carl XVI Gustaf' 3048 'SE');
INSERT INTO `nations` VALUES ('SWZ' 'Swaziland' 'Africa' 'Southern Africa' 17364.00 1968 1008000 40.4 1206.00 1312.00 'kaNgwane' 'Monarchy' 'Mswati III' 3244 'SZ');
INSERT INTO `nations` VALUES ('SYC' 'Seychelles' 'Africa' 'Eastern Africa' 455.00 1976 77000 70.4 536.00 539.00 'Sesel/Seychelles' 'Republic' 'France-Albert René' 3206 'SC');
INSERT INTO `nations` VALUES ('SYR' 'Syria' 'Asia' 'Middle East' 185180.00 1941 16125000 68.5 65984.00 64926.00 'Suriya' 'Republic' 'Bashar al-Assad' 3250 'SY');
INSERT INTO `nations` VALUES ('TCA' 'Turks and Caicos Islands' 'North America' 'Caribbean' 430.00 NULL 17000 73.3 96.00 NULL 'The Turks and Caicos Islands' 'Dependent Territory of the UK' 'Elisabeth II' 3423 'TC');
INSERT INTO `nations` VALUES ('TCD' 'Chad' 'Africa' 'Central Africa' 1284000.00 1960 7651000 50.5 1208.00 1102.00 'Tchad/Tshad' 'Republic' 'Idriss Déby' 3337 'TD');
INSERT INTO `nations` VALUES ('TGO' 'Togo' 'Africa' 'Western Africa' 56785.00 1960 4629000 54.7 1449.00 1400.00 'Togo' 'Republic' 'Gnassingbé Eyadéma' 3332 'TG');
INSERT INTO `nations` VALUES ('THA' 'Thailand' 'Asia' 'Southeast Asia' 513115.00 1350 61399000 68.6 116416.00 153907.00 'Prathet Thai' 'Constitutional Monarchy' 'Bhumibol Adulyadej' 3320 'TH');
INSERT INTO `nations` VALUES ('TJK' 'Tajikistan' 'Asia' 'Southern and Central Asia' 143100.00 1991 6188000 64.1 1990.00 1056.00 'Toçikiston' 'Republic' 'Emomali Rahmonov' 3261 'TJ');
INSERT INTO `nations` VALUES ('TKL' 'Tokelau' 'Oceania' 'Polynesia' 12.00 NULL 2000 NULL 0.00 NULL 'Tokelau' 'Nonmetropolitan Territory of New Zealand' 'Elisabeth II' 3333 'TK');
INSERT INTO `nations` VALUES ('TKM' 'Turkmenistan' 'Asia' 'Southern and Central Asia' 488100.00 1991 4459000 60.9 4397.00 2000.00 'Türkmenostan' 'Republic' 'Saparmurad Nijazov' 3419 'TM');
INSERT INTO `nations` VALUES ('TMP' 'East Timor' 'Asia' 'Southeast Asia' 14874.00 NULL 885000 46.0 0.00 NULL 'Timor Timur' 'Administrated by the UN' 'José Alexandre Gusmão' 1522 'TP');
INSERT INTO `nations` VALUES ('TON' 'Tonga' 'Oceania' 'Polynesia' 650.00 1970 99000 67.9 146.00 170.00 'Tonga' 'Monarchy' 'Taufa-ahau Tupou IV' 3334 'TO');
INSERT INTO `nations` VALUES ('TTO' 'Trinidad and Tobago' 'North America' 'Caribbean' 5130.00 1962 1295000 68.0 6232.00 5867.00 'Trinidad and Tobago' 'Republic' 'Arthur N. R. Robinson' 3336 'TT');
INSERT INTO `nations` VALUES ('TUN' 'Tunisia' 'Africa' 'Northern Africa' 163610.00 1956 9586000 73.7 20026.00 18898.00 'Tunis/Tunisie' 'Republic' 'Zine al-Abidine Ben Ali' 3349 'TN');
INSERT INTO `nations` VALUES ('TUR' 'Turkey' 'Asia' 'Middle East' 774815.00 1923 66591000 71.0 210721.00 189122.00 'Türkiye' 'Republic' 'Ahmet Necdet Sezer' 3358 'TR');
INSERT INTO `nations` VALUES ('TUV' 'Tuvalu' 'Oceania' 'Polynesia' 26.00 1978 12000 66.3 6.00 NULL 'Tuvalu' 'Constitutional Monarchy' 'Elisabeth II' 3424 'TV');
INSERT INTO `nations` VALUES ('TWN' 'Taiwan' 'Asia' 'Eastern Asia' 36188.00 1945 22256000 76.4 256254.00 263451.00 'T’ai-wan' 'Republic' 'Chen Shui-bian' 3263 'TW');
INSERT INTO `nations` VALUES ('TZA' 'Tanzania' 'Africa' 'Eastern Africa' 883749.00 1961 33517000 52.3 8005.00 7388.00 'Tanzania' 'Republic' 'Benjamin William Mkapa' 3306 'TZ');
INSERT INTO `nations` VALUES ('UGA' 'Uganda' 'Africa' 'Eastern Africa' 241038.00 1962 21778000 42.9 6313.00 6887.00 'Uganda' 'Republic' 'Yoweri Museveni' 3425 'UG');
INSERT INTO `nations` VALUES ('UKR' 'Ukraine' 'Europe' 'Eastern Europe' 603700.00 1991 50456000 66.0 42168.00 49677.00 'Ukrajina' 'Republic' 'Leonid Kutšma' 3426 'UA');
INSERT INTO `nations` VALUES ('UMI' 'United States Minor Outlying Islands' 'Oceania' 'Micronesia/Caribbean' 16.00 NULL 0 NULL 0.00 NULL 'United States Minor Outlying Islands' 'Dependent Territory of the US' 'George W. Bush' NULL 'UM');
INSERT INTO `nations` VALUES ('URY' 'Uruguay' 'South America' 'South America' 175016.00 1828 3337000 75.2 20831.00 19967.00 'Uruguay' 'Republic' 'Jorge Batlle Ibáñez' 3492 'UY');
INSERT INTO `nations` VALUES ('USA' 'United States' 'North America' 'North America' 9363520.00 1776 278357000 77.1 8510700.00 8110900.00 'United States' 'Federal Republic' 'George W. Bush' 3813 'US');
INSERT INTO `nations` VALUES ('UZB' 'Uzbekistan' 'Asia' 'Southern and Central Asia' 447400.00 1991 24318000 63.7 14194.00 21300.00 'Uzbekiston' 'Republic' 'Islam Karimov' 3503 'UZ');
INSERT INTO `nations` VALUES ('VAT' 'Holy See (Vatican City State)' 'Europe' 'Southern Europe' 0.40 1929 1000 NULL 9.00 NULL 'Santa Sede/Città del Vaticano' 'Independent Church State' 'Johannes Paavali II' 3538 'VA');
INSERT INTO `nations` VALUES ('VCT' 'Saint Vincent and the Grenadines' 'North America' 'Caribbean' 388.00 1979 114000 72.3 285.00 NULL 'Saint Vincent and the Grenadines' 'Constitutional Monarchy' 'Elisabeth II' 3066 'VC');
INSERT INTO `nations` VALUES ('VEN' 'Venezuela' 'South America' 'South America' 912050.00 1811 24170000 73.1 95023.00 88434.00 'Venezuela' 'Federal Republic' 'Hugo Chávez Frías' 3539 'VE');
INSERT INTO `nations` VALUES ('VGB' 'Virgin Islands British' 'North America' 'Caribbean' 151.00 NULL 21000 75.4 612.00 573.00 'British Virgin Islands' 'Dependent Territory of the UK' 'Elisabeth II' 537 'VG');
INSERT INTO `nations` VALUES ('VIR' 'Virgin Islands U.S.' 'North America' 'Caribbean' 347.00 NULL 93000 78.1 0.00 NULL 'Virgin Islands of the United States' 'US Territory' 'George W. Bush' 4067 'VI');
INSERT INTO `nations` VALUES ('VNM' 'Vietnam' 'Asia' 'Southeast Asia' 331689.00 1945 79832000 69.3 21929.00 22834.00 'Viêt Nam' 'Socialistic Republic' 'Trân Duc Luong' 3770 'VN');
INSERT INTO `nations` VALUES ('VUT' 'Vanuatu' 'Oceania' 'Melanesia' 12189.00 1980 190000 60.6 261.00 246.00 'Vanuatu' 'Republic' 'John Bani' 3537 'VU');
INSERT INTO `nations` VALUES ('WLF' 'Wallis and Futuna' 'Oceania' 'Polynesia' 200.00 NULL 15000 NULL 0.00 NULL 'Wallis-et-Futuna' 'Nonmetropolitan Territory of France' 'Jacques Chirac' 3536 'WF');
INSERT INTO `nations` VALUES ('WSM' 'Samoa' 'Oceania' 'Polynesia' 2831.00 1962 180000 69.2 141.00 157.00 'Samoa' 'Parlementary Monarchy' 'Malietoa Tanumafili II' 3169 'WS');
INSERT INTO `nations` VALUES ('YEM' 'Yemen' 'Asia' 'Middle East' 527968.00 1918 18112000 59.8 6041.00 5729.00 'Al-Yaman' 'Republic' 'Ali Abdallah Salih' 1780 'YE');
INSERT INTO `nations` VALUES ('YUG' 'Yugoslavia' 'Europe' 'Southern Europe' 102173.00 1918 10640000 72.4 17000.00 NULL 'Jugoslavija' 'Federal Republic' 'Vojislav Koštunica' 1792 'YU');
INSERT INTO `nations` VALUES ('ZAF' 'South Africa' 'Africa' 'Southern Africa' 1221037.00 1910 40377000 51.1 116729.00 129092.00 'South Africa' 'Republic' 'Thabo Mbeki' 716 'ZA');
INSERT INTO `nations` VALUES ('ZMB' 'Zambia' 'Africa' 'Eastern Africa' 752618.00 1964 9169000 37.2 3377.00 3922.00 'Zambia' 'Republic' 'Frederick Chiluba' 3162 'ZM');
INSERT INTO `nations` VALUES ('ZWE' 'Zimbabwe' 'Africa' 'Eastern Africa' 390757.00 1980 11669000 37.8 5951.00 8670.00 'Zimbabwe' 'Republic' 'Robert G. Mugabe' 4068 'ZW');
COMMIT;