-- MySQL dump 10.14 Distrib 5.5.60-MariaDB, for Linux (x86_64) -- -- Host: localhost Database: cia -- ------------------------------------------------------ -- Server version 5.5.60-MariaDB /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `cia` -- DROP TABLE IF EXISTS `cia`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cia` ( `name` varchar(50) NOT NULL, `region` varchar(60) DEFAULT NULL, `area` decimal(10,0) DEFAULT NULL, `population` decimal(11,0) DEFAULT NULL, `gdp` decimal(14,0) DEFAULT NULL, PRIMARY KEY (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cia` -- LOCK TABLES `cia` WRITE; /*!40000 ALTER TABLE `cia` DISABLE KEYS */; INSERT INTO `cia` VALUES ('Afghanistan','Asia',652000,25838797,21000000000),('Albania','Europe',28748,3490435,5600000000),('Algeria','Africa',2381740,31193917,147600000000),('American Samoa','Oceania',199,65446,150000000),('Andorra','Europe',468,66824,1200000000),('Angola','Africa',1246700,10145267,11600000000),('Anguilla','Central America and the Caribbean',91,11797,88000000),('Antarctica','Antarctic Region',14000000,0,NULL),('Antigua and Barbuda','Central America and the Caribbean',442,66422,524000000),('Argentina','South America',2766890,36955182,367000000000),('Armenia','Commonwealth of Independent States',29800,3344336,9900000000),('Aruba','Central America and the Caribbean',193,69539,1600000000),('Ashmore and Cartier Islands','Southeast Asia',5,0,NULL),('Australia','Oceania',7686850,19169083,416200000000),('Austria','Europe',83858,8131111,190600000000),('Azerbaijan','Commonwealth of Independent States',86600,7748163,14000000000),('Bahamas, The','Central America and the Caribbean',13940,294982,5580000000),('Bahrain','Middle East',620,634137,8600000000),('Baker Island','Oceania',1,0,NULL),('Bangladesh','Asia',144000,129194224,187000000000),('Barbados','Central America and the Caribbean',430,274540,2900000000),('Bassas da India','Africa',0,0,NULL),('Belarus','Commonwealth of Independent States',207600,10366719,55200000000),('Belgium','Europe',30510,10241506,243400000000),('Belize','Central America and the Caribbean',22960,249183,740000000),('Benin','Africa',112620,6395919,8100000000),('Bermuda','North America',58,62997,2000000000),('Bhutan','Asia',47000,2005222,2100000000),('Bolivia','South America',1098580,8152620,24200000000),('Bosnia and Herzegovina','Bosnia and Herzegovina, Europe',51129,3835777,6200000000),('Botswana','Africa',600370,1576470,5700000000),('Bouvet Island','Antarctic Region',58,0,NULL),('Brazil','South America',8511965,172860370,1130000000000),('British Indian Ocean Territory','World',60,0,NULL),('British Virgin Islands','Central America and the Caribbean',150,19615,287000000),('Brunei','Southeast Asia',5770,336376,5600000000),('Bulgaria','Europe',110910,7796694,34900000000),('Burkina Faso','Africa',274200,11946065,12400000000),('Burma','Southeast Asia',678500,41734853,59400000000),('Burundi','Africa',27830,6054714,4200000000),('Cambodia','Southeast Asia',181040,12212306,8200000000),('Cameroon','Africa',475440,15421937,31500000000),('Canada','North America',9976140,31281092,722300000000),('Cape Verde','World',4033,401343,618000000),('Cayman Islands','Africa',259,34763,930000000),('Central African Republic','Africa',622984,3512751,5800000000),('Chad','Africa',1284000,8424504,7600000000),('Chile','South America',756950,15153797,185100000000),('China','Asia',9596960,1261832482,4800000000000),('Christmas Island','Southeast Asia',135,2564,0),('Clipperton Island','World',7,0,NULL),('Cocos (Keeling) Islands','Southeast Asia',14,635,0),('Colombia','South America, Central America and the Caribbean',1138910,39685655,245100000000),('Comoros','Africa',2170,578400,410000000),('Congo, Democratic Republic of the','Africa',2345410,51964999,35700000000),('Congo, Republic of the','Africa',342000,2830961,4150000000),('Cook Islands','Oceania',240,20407,112000000),('Coral Sea Islands','Oceania',0,0,NULL),('Costa Rica','Central America and the Caribbean',51100,3710558,26000000000),('Cote d\'Ivoire','Africa',322460,15980950,25700000000),('Croatia','Europe',56538,4282216,23900000000),('Cuba','Central America and the Caribbean',110860,11141997,18600000000),('Cyprus','Middle East',9250,758363,9000000),('Czech Republic','Europe',78866,10272179,120800000000),('Denmark','Europe',43094,5336394,127700000000),('Djibouti','Africa',22000,451442,550000000),('Dominica','Central America and the Caribbean',754,71540,225000000),('Dominican Republic','Central America and the Caribbean',48730,8442533,43700000000),('Ecuador','South America',283560,12920092,54500000000),('Egypt','Africa',1001450,68359979,200000000000),('El Salvador','Central America and the Caribbean',21040,6122515,18100000000),('Equatorial Guinea','Africa',28051,474214,960000000),('Eritrea','Africa',121320,4135933,2900000000),('Estonia','Europe',45226,1431471,7900000000),('Ethiopia','Africa',1127127,64117452,33300000000),('Europa Island','Africa',28,0,NULL),('Falkland Islands (Islas Malvinas)','South America',12173,2826,0),('Faroe Islands','Europe',1399,45296,700000000),('Fiji','Oceania',18270,832494,5900000000),('Finland','Europe',337030,5167486,108600000000),('France','Europe',547030,59329691,1373000000000),('French Guiana','South America',91000,172605,1000000000),('French Polynesia','Oceania',4167,249110,2600000000),('French Southern and Antarctic Lands','Antarctic Region',7781,0,NULL),('Gabon','Africa',267667,1208436,7900000000),('Gambia, The','Africa',11300,1367124,1400000000),('Gaza Strip','Middle East',360,1132063,1170000000),('Georgia','Commonwealth of Independent States',69700,5019538,11700000000),('Germany','Europe',357021,82797408,1864000000000),('Ghana','Africa',238540,19533560,35500000000),('Gibraltar','Europe',6,29481,500000000),('Glorioso Islands','Africa',5,0,NULL),('Greece','Europe',131940,10601527,149200000000),('Greenland','Arctic Region',2175600,56309,945000000),('Grenada','Central America and the Caribbean',340,89018,360000000),('Guadeloupe','Central America and the Caribbean',1780,426493,3700000000),('Guam','Oceania',541,154623,3000000000),('Guatemala','Central America and the Caribbean',108890,12639939,47900000000),('Guernsey','Europe',194,64080,1150000000),('Guinea','Africa',245857,7466200,9200000000),('Guinea-Bissau','Africa',36120,1285715,1100000000),('Guyana','South America',214970,697286,1860000000),('Haiti','Central America and the Caribbean',27750,6867995,9200000000),('Heard Island and McDonald Islands','Antarctic Region',412,0,NULL),('Holy See (Vatican City)','Europe',1880,921,245000000),('Honduras','Central America and the Caribbean',112090,6249598,14100000000),('Hong Kong','Southeast Asia',1092,7116302,158200000000),('Howland Island','Oceania',1,0,NULL),('Hungary','Europe',93030,10138844,79400000000),('Iceland','Arctic Region',103000,276365,6420000000),('India','Asia',3287590,1014003817,1805000000000),('Indonesia','Southeast Asia',1919440,224784210,610000000000),('Iran','Middle East',1648000,65619636,347600000000),('Iraq','Middle East',437072,22675617,59900000000),('Ireland','Europe',70280,3797257,73700000000),('Israel','Middle East',20770,5842454,105400000000),('Italy','Europe',301230,57634327,1212000000000),('Jamaica','Central America and the Caribbean',10990,2652689,8800000000),('Jan Mayen','Arctic Region',373,0,NULL),('Japan','Asia',377835,126549976,2950000000000),('Jarvis Island','Oceania',4,0,NULL),('Jersey','Europe',116,88915,2200000000),('Johnston Atoll','Oceania',2,0,NULL),('Jordan','Middle East',89213,4998564,16000000000),('Juan de Nova Island','Africa',4,0,NULL),('Kazakhstan','Commonwealth of Independent States',2717300,16733227,54500000000),('Kenya','Africa',582650,30339770,45100000000),('Kingman Reef','Oceania',1,0,NULL),('Kiribati','Oceania',717,91985,74000000),('Korea, North','Asia',120540,21687550,22600000000),('Korea, South','Asia',98480,47470969,625700000000),('Kuwait','Middle East',17820,1973572,44800000000),('Kyrgyzstan','Commonwealth of Independent States',198500,4685230,10300000000),('Laos','Southeast Asia',236800,5497459,7000000000),('Latvia','Europe',64589,2404926,9800000000),('Lebanon','Middle East',10400,3578036,16200000000),('Lesotho','Africa',30355,2143141,4700000000),('Liberia','Africa',111370,3164156,2850000000),('Libya','Africa',1759540,5115450,39300000000),('Liechtenstein','Europe',160,32207,730000000),('Lithuania','Europe',65200,3620756,17300000000),('Luxembourg','Europe',2586,437389,14700000000),('Macau','Southeast Asia',21,445594,7650000000),('Macedonia, The Former Yugoslav Republic of','Europe',25333,2041467,7600000000),('Madagascar','Africa',587040,15506472,11500000000),('Malawi','Africa',118480,10385849,9400000000),('Malaysia','Southeast Asia',329750,21793293,229100000000),('Maldives','Asia',300,301475,540000000),('Mali','Africa',1240000,10685948,8500000000),('Malta','Europe',316,391670,5),('Man, Isle of','Europe',572,73117,1200000000),('Marshall Islands','Oceania',181,68126,105000000),('Martinique','Central America and the Caribbean',1100,414516,4240000000),('Mauritania','Africa',1030700,2667859,4900000000),('Mauritius','World',1860,1179368,12300000000),('Mayotte','Africa',374,155911,85000000),('Mexico','North America',1972550,100349766,865500000000),('Micronesia, Federated States of','Oceania',702,133144,240000000),('Midway Islands','Oceania',6,0,NULL),('Moldova','Commonwealth of Independent States',33843,4430654,9700000000),('Monaco','Europe',2,31693,870000000),('Mongolia','Asia',1565000,2650952,6100000000),('Montserrat','Central America and the Caribbean',100,6409,31000000),('Morocco','Africa',446550,30122350,108000000000),('Mozambique','Africa',801590,19104696,18700000000),('Namibia','Africa',825418,1771327,7100000000),('Nauru','Oceania',21,11845,100000000),('Navassa Island','Central America and the Caribbean',5,0,NULL),('Nepal','Asia',140800,24702119,27400000000),('Netherlands','Europe',41532,15892237,365100000000),('Netherlands Antilles','Central America and the Caribbean',960,210134,2400000000),('New Caledonia','Oceania',19060,201816,3000000000),('New Zealand','Oceania',268680,3819762,63800000000),('Nicaragua','Central America and the Caribbean',129494,4812569,12500000000),('Niger','Africa',1267000,10075511,9600000000),('Nigeria','Africa',923768,123337822,110500000000),('Niue','Oceania',260,2113,4500000),('Norfolk Island','Oceania',34,1892,0),('Northern Mariana Islands','Oceania',477,71912,524000000),('Norway','Europe',324220,4481162,111300000000),('Oman','Middle East',212460,2533389,19600000000),('Pakistan','Asia',803940,141553775,282000000000),('Palau','Oceania',458,18766,160000000),('Palmyra Atoll','Oceania',11,0,NULL),('Panama','Central America and the Caribbean',78200,2808268,21000000000),('Papua New Guinea','Oceania',462840,4926984,11600000000),('Paracel Islands','Southeast Asia',0,0,NULL),('Paraguay','South America',406750,5585828,19900000000),('Peru','South America',1280000,27012899,116000000000),('Philippines','Southeast Asia',300000,81159644,282000000000),('Pitcairn Islands','Oceania',47,54,0),('Poland','Europe',312685,38646023,276500000000),('Portugal','Europe',92391,10048232,151400000000),('Puerto Rico','Central America and the Caribbean',9104,3915798,38100000000),('Qatar','Middle East',11437,744483,12300000000),('Reunion','World',2512,720934,3400000000),('Romania','Europe',237500,22411121,87400000000),('Russia','Asia',17075200,146001176,620300000000),('Rwanda','Africa',26338,7229129,5900000000),('Saint Helena','Africa',410,7212,13900000),('Saint Kitts and Nevis','Central America and the Caribbean',261,38819,244000000),('Saint Lucia','Central America and the Caribbean',620,156260,656000000),('Saint Pierre and Miquelon','North America',242,6896,74000000),('Saint Vincent and the Grenadines','Central America and the Caribbean',389,115461,309000000),('Samoa','Oceania',2860,179466,485000000),('San Marino','Europe',60,26937,500000000),('Sao Tome and Principe','Africa',1001,159883,169000000),('Saudi Arabia','Middle East',1960582,22023506,191000000000),('Senegal','Africa',196190,9987494,16600000000),('Serbia and Montenegro','Europe',102350,10662087,20600000000),('Seychelles','Africa',455,79326,590000000),('Sierra Leone','Africa',71740,5232624,2500000000),('Singapore','Southeast Asia',647,4151264,98000000000),('Slovakia','Europe',48845,5407956,45900000000),('Slovenia','Europe',20253,1927593,21400000000),('Solomon Islands','Oceania',28450,466194,1210000000),('Somalia','Africa',637657,7253137,4300000000),('South Africa','Africa',1219912,43421021,296100000000),('South Georgia and the South Sandwich Islands','Antarctic Region',4066,0,NULL),('Spain','Europe',504782,39996671,677500000000),('Spratly Islands','Southeast Asia',0,0,NULL),('Sri Lanka','Asia',65610,19238575,50500000000),('Sudan','Africa',2505810,35079814,32600000000),('Suriname','South America',163270,431303,1480000000),('Svalbard','Arctic Region',62049,2416,NULL),('Swaziland','Africa',17363,1083289,4200000000),('Sweden','Europe',449964,8873052,184000000000),('Switzerland','Europe',41290,7262372,197000000000),('Syria','Middle East',185180,16305659,42200000000),('Taiwan','Southeast Asia',35980,22191087,357000000000),('Tajikistan','Commonwealth of Independent States',143100,6440732,6200000000),('Tanzania','Africa',945087,35306126,23300000000),('Thailand','Southeast Asia',514000,61230874,388700000000),('Togo','Africa',56785,5018502,8600000000),('Tokelau','Oceania',10,1458,1500000),('Tonga','Oceania',748,102321,238000000),('Trinidad and Tobago','Central America and the Caribbean',5128,1175523,9410000000),('Tromelin Island','Africa',1,0,NULL),('Tunisia','Middle East',163610,9593402,52600000000),('Turkey','Europe',780580,65666677,409400000000),('Turkmenistan','Commonwealth of Independent States',488100,4518268,7700000000),('Turks and Caicos Islands','Central America and the Caribbean',430,17502,117000000),('Tuvalu','Oceania',26,10838,7800000),('Uganda','Africa',236040,23317560,24200000000),('Ukraine','Commonwealth of Independent States',603700,49153027,109500000000),('United Arab Emirates','Middle East',82880,2369153,41500000000),('United Kingdom','Europe',244820,59511464,1290000000000),('United States','North America',9629091,275562673,9255000000000),('Uruguay','South America',176220,3334074,28000000000),('Uzbekistan','Commonwealth of Independent States',447400,24755519,59300000000),('Vanuatu','Oceania',14760,189618,245000000),('Venezuela','South America, Central America and the Caribbean',912050,23542649,182800000000),('Vietnam','Southeast Asia',329560,78773873,143100000000),('Virgin Islands','Central America and the Caribbean',352,120917,1800000000),('Wake Island','Oceania',6,0,NULL),('Wallis and Futuna','Oceania',274,15283,28700000),('West Bank','Middle East',5860,2020298,3300000000),('Western Sahara','Africa',266000,244943,0),('Yemen','Middle East',527970,17479206,12700000000),('Zambia','Africa',752614,9582418,8500000000),('Zimbabwe','Africa',390580,11342521,26500000000); /*!40000 ALTER TABLE `cia` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!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 */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2019-04-10 13:33:14