CREATE DATABASE IF NOT EXISTS `el_mundo` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `el_mundo`; -- MySQL dump 10.13 Distrib 8.0.25, for Linux (x86_64) -- -- Host: 10.0.29.9 Database: el_mundo -- ------------------------------------------------------ -- Server version 5.5.68-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 */; /*!50503 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 `dependencia` -- DROP TABLE IF EXISTS `dependencia`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `dependencia` ( `tiene` smallint(6) NOT NULL, `de` smallint(6) NOT NULL, PRIMARY KEY (`tiene`), KEY `de` (`de`), CONSTRAINT `dependencia_ibfk_1` FOREIGN KEY (`tiene`) REFERENCES `territorio` (`idter`), CONSTRAINT `dependencia_ibfk_2` FOREIGN KEY (`de`) REFERENCES `territorio` (`idter`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `dependencia` -- LOCK TABLES `dependencia` WRITE; /*!40000 ALTER TABLE `dependencia` DISABLE KEYS */; INSERT INTO `dependencia` VALUES (31,55),(34,55),(35,55),(36,55),(42,85),(43,85),(40,97),(41,97),(260,107),(10,108),(11,108),(16,108),(28,108),(239,108),(240,108),(241,108),(242,108),(243,108),(244,108),(245,108),(246,108),(265,108),(266,108),(37,112),(7,114),(8,114),(13,114),(14,114),(18,114),(19,114),(20,114),(21,114),(22,114),(25,114),(29,114),(262,114),(264,114),(9,177),(44,177),(255,177),(32,178),(256,178),(261,178),(30,180),(38,180),(39,180),(263,180),(1,189),(2,189),(3,189),(4,189),(5,189),(6,189),(12,189),(15,189),(17,189),(23,189),(24,189),(26,189),(27,189),(257,189),(258,189),(259,189); /*!40000 ALTER TABLE `dependencia` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `independencia` -- DROP TABLE IF EXISTS `independencia`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `independencia` ( `tiene` smallint(6) NOT NULL, `de` smallint(6) NOT NULL, PRIMARY KEY (`tiene`), KEY `de` (`de`), CONSTRAINT `independencia_ibfk_1` FOREIGN KEY (`tiene`) REFERENCES `territorio` (`idter`), CONSTRAINT `independencia_ibfk_2` FOREIGN KEY (`de`) REFERENCES `territorio` (`idter`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `independencia` -- LOCK TABLES `independencia` WRITE; /*!40000 ALTER TABLE `independencia` DISABLE KEYS */; INSERT INTO `independencia` VALUES (250,57),(248,86),(247,117),(251,117),(254,166),(249,201),(252,206); /*!40000 ALTER TABLE `independencia` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `region` -- DROP TABLE IF EXISTS `region`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `region` ( `idreg` smallint(6) NOT NULL, `nombre` varchar(10) NOT NULL, `tipo` enum('continente','oceano') DEFAULT NULL, PRIMARY KEY (`idreg`), UNIQUE KEY `nombre` (`nombre`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `region` -- LOCK TABLES `region` WRITE; /*!40000 ALTER TABLE `region` DISABLE KEYS */; INSERT INTO `region` VALUES (1,'Africa','continente'),(2,'America','continente'),(3,'Asia','continente'),(4,'Antartida','continente'),(5,'Europa','continente'),(6,'Oceania','continente'),(7,'Atlantico','oceano'),(8,'Pacifico','oceano'); /*!40000 ALTER TABLE `region` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `territorio` -- DROP TABLE IF EXISTS `territorio`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `territorio` ( `idter` smallint(6) NOT NULL, `nombre` varchar(43) DEFAULT NULL, `oficial` varchar(53) DEFAULT NULL, `capital` varchar(24) DEFAULT NULL, `poblacion` int(11) NOT NULL, `superficie` decimal(12,3) NOT NULL, `tipo` enum('arrecife','atolon','autonomo','comunidad','dependiente','estado_asociado','glaciar','independiente','no_incorporado','ONU','region_administrativa','region_autonoma','territorio_externo','ultramar') DEFAULT NULL, `idreg` smallint(6) DEFAULT NULL, PRIMARY KEY (`idter`), KEY `idreg` (`idreg`), CONSTRAINT `territorio_ibfk_1` FOREIGN KEY (`idreg`) REFERENCES `region` (`idreg`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `territorio` -- LOCK TABLES `territorio` WRITE; /*!40000 ALTER TABLE `territorio` DISABLE KEYS */; INSERT INTO `territorio` VALUES (1,'Acrotiri y Dhekelia','Bases Soberanas de Acrotiri y Dhekelia','Episkopi',13500,254.000,'ultramar',5),(2,'Anguila','Anguila','El Valle',14000,91.000,'ultramar',2),(3,'Bermudas','Bermudas','Hamilton',65000,54.000,'ultramar',2),(4,'Islas Caiman','Islas Caiman','George Town',54878,260.000,'ultramar',2),(5,'Georgias del Sur y Sandwich del Sur, Islas ','Islas Georgias del Sur y Sandwich del Sur','King Edward Point',2,3093.000,'ultramar',2),(6,'Gibraltar','Gibraltar','Gibraltar',30000,7.000,'ultramar',5),(7,'Guadalupe','Guadalupe','Basse-Terre',407000,1704.000,'ultramar',2),(8,'Guayana Francesa','Guayana Francesa','Cayena',262000,83846.000,'ultramar',2),(9,'Jan Mayen','Jan Mayen','Olonkinbyen',18,377.000,'ultramar',5),(10,'Isla Jarvis','Isla Jarvis',NULL,0,4.500,'ultramar',8),(11,'Johnston, Atolon','Atolon Johnston',NULL,1100,2.670,'ultramar',8),(12,'Islas Malvinas','Islas Malvinas/Falkland Islands','Puerto Argentino/Stanley',3000,12173.000,'ultramar',2),(13,'Martinica','La Isla de Martinica','Fort de France',389000,1100.000,'ultramar',2),(14,'Mayotte','Mayotte','Mamoudzou',223000,374.000,'ultramar',1),(15,'Montserrat','Montserrat','Brades',5000,102.000,'ultramar',2),(16,'Palmyra, Atolon','Atolon Palmyra','Palmyra',20,3.900,'ultramar',3),(17,'Islas Pitcairn','Islas Pitcairn, Henderson, Ducie y Oeno','Adamstown',60,47.000,'ultramar',6),(18,'Polinesia Francesa','Polinesia Francesa','Papeete',272000,4167.000,'ultramar',6),(19,'Reunion','La Isla de la Reunion','Saint Denis',850000,2512.000,'ultramar',1),(20,'San Bartolome','Colectividad de San Bartolome','Gustavia',10000,21.000,'ultramar',2),(21,'San Martin','Colectividad de San Martin','Marigot',39000,54.000,'ultramar',2),(22,'San Pedro y Miquelon','San Pedro y Miquelon','San Pedro',6000,242.000,'ultramar',2),(23,'Santa Elena, Ascension y Tristan de Acuña','Santa Elena, Ascension y Tristan de Acuña','Jamestown',4000,308.000,'ultramar',7),(24,'Territorio Britanico del Oceano Índico','Territorio Britanico del Oceano Índico','Diego Garcia',3500,60.000,'ultramar',1),(25,'Tierras Australes y Antarticas Francesas','Tierras Australes y Antarticas Francesas','Saint-Pierre',140,7829.000,'ultramar',4),(26,'Islas Turcas y Caicos','Islas Turcas y Caicos','Cockburn Town',44819,417.000,'ultramar',2),(27,'Islas Virgenes Britanicas','Islas Virgenes Britanicas','Road Town',33000,151.000,'ultramar',2),(28,'Isla Wake','Isla Wake','Airport',45,7.370,'ultramar',8),(29,'Wallis y Futuna','Territorio de las Islas Wallis y Futuna','Mata-Utu',12000,142.000,'ultramar',6),(30,'Caribe Neerlandes','Caribe Neerlandes',NULL,18000,328.000,'territorio_externo',2),(31,'Islas Cocos','Territorio de las Islas Cocos','West Island',628,14.000,'territorio_externo',3),(32,'Islas Cook','Islas Cook','Avarua',15000,236.000,'territorio_externo',6),(33,'Islas Heard y McDonald','Islas Heard y McDonald',NULL,0,372.000,'territorio_externo',4),(34,'Islas del Mar del Coral','Islas del Mar del Coral',NULL,0,3.000,'territorio_externo',6),(35,'Isla de Navidad','Territorio de la Isla de Navidad','Flying Fish Cove',2000,135.000,'territorio_externo',3),(36,'Norfolk','Territorio de las Islas Norfolk','Kingston',3000,36.000,'territorio_externo',6),(37,'Åland','Islas de Åland','Mariehamn',28563,29000.000,'region_autonoma',5),(38,'Aruba','Aruba','Oranjestad',106000,180.000,'region_autonoma',2),(39,'Curazao','Pais de Curazao','Willemstad',158000,444.000,'region_autonoma',2),(40,'Islas Feroe','Islas Feroe','Torshavn',48000,1393.000,'region_autonoma',5),(41,'Groenlandia','Groenlandia','Nuuk',56000,2166086.000,'region_autonoma',2),(42,'Hong Kong','Region Administrativa Especial de Hong Kong','Hong Kong',7196000,1104.000,'region_administrativa',3),(43,'Macao','Region Administrativa Especial de Macao','Macao',620000,28.000,'region_administrativa',3),(44,'Svalbard','Svalbard','Longyearbyen',3000,62045.000,'region_administrativa',5),(45,'Afganistan','Republica Islamica de Afganistan','Kabul',26285000,652230.000,'ONU',3),(46,'Albania','Republica de Albania','Tirana',2761000,28748.000,'ONU',5),(47,'Alemania','Republica Federal de Alemania','Berlin',80892000,357168.000,'ONU',5),(48,'Andorra','Principado de Andorra','Andorra la Vieja',75000,468.000,'ONU',5),(49,'Angola','Republica de Angola','Luanda',19743000,1246700.000,'ONU',1),(50,'Antigua y Barbuda','Antigua y Barbuda','Saint John\'s',88000,443.000,'ONU',2),(51,'Arabia Saudita','Reino de Arabia Saudita','Riad',30954000,2149690.000,'ONU',3),(52,'Argelia','Republica Argelina Democratica y Popular','Argel',3909000,2381741.000,'ONU',1),(53,'Argentina','Republica Argentina','Buenos Aires',42670000,2780400.000,'ONU',2),(54,'Armenia','Republica de Armenia','Erevan',3017000,29743.000,'ONU',3),(55,'Australia','Mancomunidad de Australia','Canberra',23545000,7692024.000,'ONU',6),(56,'Austria','Republica de Austria','Viena',8531000,83871.000,'ONU',5),(57,'Azerbaiyan','Republica de Azerbaiyan','Baku',9537000,86600.000,'ONU',3),(58,'Bahamas','Mancomunidad de las Bahamas','Nasau',374000,13880.000,'ONU',2),(59,'Banglades','Republica Popular de Banglades','Daca',156623000,143998.000,'ONU',3),(60,'Barbados','Barbados','Bridgetown',282000,430.000,'ONU',2),(61,'Barein','Reino de Barein','Manama',1659000,741.000,'ONU',3),(62,'Belgica','Reino de Belgica','Bruselas',11315000,30528.000,'ONU',5),(63,'Belice','Belice','Belmopan',358000,22966.000,'ONU',2),(64,'Benin','Republica de Benin','Porto-Novo',10385000,112622.000,'ONU',1),(65,'Bielorrusia','Republica de Bielorrusia','Minsk',9467000,207600.000,'ONU',5),(66,'Birmania','Republica de la Union de Myanmar','Naipyido',62673000,676578.000,'ONU',3),(67,'Bolivia','Estado Plurinacional de Bolivia','Sucre',10303000,1098581.000,'ONU',2),(68,'Bosnia y Herzegovina','Bosnia y Herzegovina','Sarajevo',3774000,51197.000,'ONU',5),(69,'Botsuana','Republica de Botsuana','Gaborone',2135000,581730.000,'ONU',1),(70,'Brasil','Republica Federativa del Brasil','Brasilia',202790000,8514877.000,'ONU',2),(71,'Brunei','Estado de Brunei, Morada de la Paz','Bandar Seri Begawan',414000,5765.000,'ONU',3),(72,'Bulgaria','Republica de Bulgaria','Sofia',7218000,110879.000,'ONU',5),(73,'Burkina Faso','Burkina Faso','Uagadugu',17891000,274200.000,'ONU',1),(74,'Burundi','Republica de Burundi','Buyumbura',9728000,27830.000,'ONU',1),(75,'Butan','Reino de Butan','Timbu',747000,38394.000,'ONU',3),(76,'Cabo Verde','Republica de Cabo Verde','Praia',517000,4033.000,'ONU',1),(77,'Camboya','Reino de Camboya','Phnom Penh',14804000,181035.000,'ONU',3),(78,'Camerun','Republica de Camerun','Yaunde',21488000,475440.000,'ONU',1),(79,'Canada','Canada','Ottawa',35518000,9984670.000,'ONU',2),(80,'Catar','Estado de Catar','Doha',2045239,11586.000,'ONU',3),(81,'Centroafricana, Republica','Republica Centroafricana','Bangui',2177000,622984.000,'ONU',1),(82,'Chad','Republica de Chad','Yamena',13419000,1284000.000,'ONU',1),(83,'Checa, Republica','Republica Checa','Praga',10519000,78866.000,'ONU',5),(84,'Chile','Republica de Chile','Santiago de Chile',16645000,756102.000,'ONU',2),(85,'China','Republica Popular China','Pekin',1364063000,9596961.000,'ONU',3),(86,'Chipre','Republica de Chipre','Nicosia',872000,9251.000,'ONU',3),(87,'Colombia','Republica de Colombia','Bogota',47681000,1141748.000,'ONU',2),(88,'Comoras','Union de las Comoras','Moroni',763000,2235.000,'ONU',1),(89,'Congo, Republica del','Republica del Congo','Brazzaville',4676000,342000.000,'ONU',1),(90,'Congo, Republica Democratica del','Republica Democratica del Congo','Kinsasa',77028000,2344858.000,'ONU',1),(91,'Corea del Norte','Republica Popular Democratica de Corea','Pionyang',25586000,120538.000,'ONU',3),(92,'Corea del Sur','Republica de Corea','Seul',50787000,99720.000,'ONU',3),(93,'Costa de Marfil','Republica de Costa de Marfil','Yamusukro',24658000,322463.000,'ONU',1),(94,'Costa Rica','Republica de Costa Rica','San Jose',4740000,51100.000,'ONU',2),(95,'Croacia','Republica de Croacia','Zagreb',4244000,56594.000,'ONU',5),(96,'Cuba','Republica de Cuba','La Habana',11165000,110860.000,'ONU',2),(97,'Dinamarca','Reino de Dinamarca','Copenhague',5641000,43094.000,'ONU',5),(98,'Dominica','Mancomunidad de Dominica','Roseau',71000,751.000,'ONU',2),(99,'Dominicana, Republica','Republica Dominicana','Santo Domingo',9863000,48670.000,'ONU',2),(100,'Ecuador','Republica del Ecuador','Quito',16041000,283561.000,'ONU',2),(101,'Egipto','Republica Arabe de Egipto','El Cairo',86542000,1001450.000,'ONU',1),(102,'El Salvador','Republica de El Salvador','San Salvador',6458000,21041.000,'ONU',2),(103,'Emiratos Arabes Unidos','Emiratos Arabes Unidos','Abu Dabi',8795000,83600.000,'ONU',3),(104,'Eritrea','Estado de Eritrea','Asmara',5182000,117600.000,'ONU',1),(105,'Eslovaquia','Republica Eslovaca','Bratislava',5420000,49035.000,'ONU',5),(106,'Eslovenia','Republica de Eslovenia','Liubliana',2063000,20273.000,'ONU',5),(107,'España','Reino de España','Madrid',46471000,505370.000,'ONU',5),(108,'Estados Unidos','Estados Unidos de America','Washington D.C.',318191000,9371174.000,'ONU',2),(109,'Estonia','Republica de Estonia','Tallin',1316000,9371174.000,'ONU',5),(110,'Etiopia','Republica Democratica Federal de Etiopia','Adis Abeba',88928000,45228.000,'ONU',1),(111,'Filipinas','Republica de Filipinas','Manila',98987000,300000.000,'ONU',3),(112,'Finlandia','Republica de Finlandia','Helsinki',5463000,338145.000,'ONU',5),(113,'Fiyi','Republica de Fiyi','Suva',867000,18274.000,'ONU',6),(114,'Francia','Republica Francesa','Paris',64061000,643801.000,'ONU',5),(115,'Gabon','Republica Gabonesa','Libreville',2291000,267667.000,'ONU',1),(116,'Gambia','Republica del Gambia','Banjul',1958000,11295.000,'ONU',1),(117,'Georgia','Georgia','Tiflis',4499000,69700.000,'ONU',3),(118,'Ghana','Republica de Ghana','Accra',27117000,238533.000,'ONU',1),(119,'Granada','Granada','Saint George\'s',104000,344.000,'ONU',2),(120,'Grecia','Republica Helenica','Atenas',10779000,131957.000,'ONU',5),(121,'Guatemala','Republica de Guatemala','Ciudad de Guatemala',15808000,108889.000,'ONU',2),(122,'Guinea','Republica de Guinea','Conakry',12227000,245857.000,'ONU',1),(123,'Guinea Ecuatorial','Republica de Guinea Ecuatorial','Malabo',1915000,28051.000,'ONU',1),(124,'Guinea-Bisau','Republica de Guinea-Bisau','Bissau',1743000,36125.000,'ONU',1),(125,'Guyana','Republica Cooperativa de Guyana','Georgetown',803000,214969.000,'ONU',2),(126,'Haiti','Republica de Haiti','Puerto Principe',10936000,27750.000,'ONU',2),(127,'Honduras','Republica de Honduras','Tegucigalpa',8750000,112492.000,'ONU',2),(128,'Hungria','Hungria','Budapest',9866000,93028.000,'ONU',5),(129,'India','Republica de la India','Nueva Delhi',1278501000,3287595.000,'ONU',3),(130,'Indonesia','Republica de Indonesia','Yakarta',251913000,1904569.000,'ONU',3),(131,'Irak','Republica de Irak','Bagdad',36104000,438317.000,'ONU',3),(132,'Iran','Republica Islamica de Iran','Teheran',77777000,1648195.000,'ONU',3),(133,'Irlanda','Republica de Irlanda','Dublin',4603000,70273.000,'ONU',5),(134,'Islandia','Republica de Islandia','Reikiavik',327000,103000.000,'ONU',5),(135,'Israel','Estado de Israel','Jerusalen',8208000,22072.000,'ONU',3),(136,'Italia','Republica Italiana','Roma',60183000,301340.000,'ONU',5),(137,'Jamaica','Jamaica','Kingston',2722000,10991.000,'ONU',2),(138,'Japon','Japon','Tokio',127034000,377915.000,'ONU',3),(139,'Jordania','Reino Hachemita de Jordania','Aman',6701000,89342.000,'ONU',3),(140,'Kazajistan','Republica de Kazajistan','Astana',17283000,2724900.000,'ONU',3),(141,'Kenia','Republica de Kenia','Nairobi',44595000,580367.000,'ONU',1),(142,'Kirguistan','Republica Kirguisa','Biskek',5777000,199951.000,'ONU',3),(143,'Kiribati','Republica de Kiribati','Tarawa',108000,811.000,'ONU',6),(144,'Kuwait','Estado de Kuwait','Ciudad de Kuwait',3966000,17818.000,'ONU',3),(145,'Laos','Republica Democratica Popular Lao','Vientian',6706000,236800.000,'ONU',3),(146,'Lesoto','Reino de Lesoto','Maseru',1904000,30355.000,'ONU',1),(147,'Letonia','Republica de Letonia','Riga',1996000,64589.000,'ONU',5),(148,'Libano','Republica Libanesa','Beirut',4192000,10400.000,'ONU',3),(149,'Liberia','Republica de Liberia','Monrovia',3963000,111369.000,'ONU',1),(150,'Libia','Estado de Libia','Tripoli',6421000,1759540.000,'ONU',1),(151,'Liechtenstein','Principado de Liechtenstein','Vaduz',37000,160.000,'ONU',5),(152,'Lituania','Republica de Lituania','Vilna',2928000,65300.000,'ONU',5),(153,'Luxemburgo','Gran Ducado de Luxemburgo','Luxemburgo',554000,2586.000,'ONU',5),(154,'Macedonia','Republica de Macedonia','Skopie',2068000,25713.000,'ONU',5),(155,'Madagascar','Republica de Madagascar','Antananarivo',22446000,587041.000,'ONU',1),(156,'Malasia','Malasia','Kuala Lumpur',31229000,329847.000,'ONU',3),(157,'Malaui','Republica de Malaui','Lilongüe',15802000,118484.000,'ONU',1),(158,'Maldivas','Republica de las Maldivas','Male',335000,298.000,'ONU',3),(159,'Mali','Republica de Mali','Bamako',17228000,1240192.000,'ONU',1),(160,'Malta','Republica de Malta','La Valeta',423000,316.000,'ONU',5),(161,'Marruecos','Reino de Marruecos','Rabat',33307000,446550.000,'ONU',1),(162,'Islas Marshall','Republica de las Islas Marshall','Majuro',57000,181.000,'ONU',6),(163,'Mauricio','Republica de Mauricio','Port Louis',1280000,2040.000,'ONU',1),(164,'Mauritania','Republica Islamica de Mauritania','Nuakchot',3550000,1030700.000,'ONU',1),(165,'Mexico','Estados Unidos Mexicanos','Ciudad de Mexico',119713000,1964375.000,'ONU',2),(166,'Moldavia','Republica de Moldavia','Chisinau',3494000,33851.000,'ONU',5),(167,'Monaco','Principado de Monaco','Monaco',37000,2.000,'ONU',5),(168,'Mongolia','Mongolia','Ulan Bator',2964000,1564116.000,'ONU',3),(169,'Montenegro','Republica de Montenegro','Podgorica',620000,13812.000,'ONU',5),(170,'Mozambique','Republica de Mozambique','Maputo',25307000,799380.000,'ONU',1),(171,'Namibia','Republica de Namibia','Windhoek',2201000,824292.000,'ONU',1),(172,'Nauru','Republica de Nauru','Yaren',10000,21.000,'ONU',6),(173,'Nepal','Republica Federal Democratica de Nepal','Katmandu',27590000,147181.000,'ONU',3),(174,'Nicaragua','Republica de Nicaragua','Managua',6363000,130370.000,'ONU',2),(175,'Niger','Republica del Niger','Niamey',18179000,1267000.000,'ONU',1),(176,'Nigeria','Republica Federal de Nigeria','Abuja',179626000,923768.000,'ONU',1),(177,'Noruega','Reino de Noruega','Oslo',5139000,323802.000,'ONU',5),(178,'Nueva Zelanda','Nueva Zelanda','Wellington',4509000,267710.000,'ONU',6),(179,'Oman','Sultanato de Oman','Mascate',4054000,309500.000,'ONU',3),(180,'Paises Bajos','Reino de los Paises Bajos','Amsterdam',16858000,41865.000,'ONU',5),(181,'Pakistan','Republica Islamica de Pakistan','Islamabad',187900000,796095.000,'ONU',3),(182,'Palaos','Republica de Palaos','Melekeok',21000,459.000,'ONU',6),(183,'Panama','Republica de Panama','Panama',3671000,75420.000,'ONU',2),(184,'Papua Nueva Guinea','Estado Independiente de Papua Nueva Guinea','Port Moresby',7672000,462840.000,'ONU',6),(185,'Paraguay','Republica del Paraguay','Asuncion',6832000,406752.000,'ONU',2),(186,'Peru','Republica del Peru','Lima',30819000,1285216.000,'ONU',2),(187,'Polonia','Republica de Polonia','Varsovia',38507000,312685.000,'ONU',5),(188,'Portugal','Republica Portuguesa','Lisboa',10511000,92090.000,'ONU',5),(189,'Reino Unido','Reino Unido de Gran Bretaña e Irlanda del Norte','Londres',64551000,243610.000,'ONU',5),(190,'Ruanda','Republica de Ruanda','Kigali',11036000,26338.000,'ONU',1),(191,'Rumania','Rumania','Bucarest',19704000,238391.000,'ONU',5),(192,'Rusia','Federacion Rusa','Moscu',143781000,17075400.000,'ONU',5),(193,'Islas Salomon','Islas Salomon','Honiara',574000,28896.000,'ONU',6),(194,'Samoa','Estado Independiente de Samoa','Apia',192000,2831.000,'ONU',6),(195,'San Cristobal y Nieves','Federacion de San Cristobal y Nieves','Basseterre',56000,261.000,'ONU',2),(196,'San Marino','Serenisima Republica de San Marino','Ciudad de San Marino',33000,61.000,'ONU',5),(197,'San Vicente y las Granadinas','San Vicente y las Granadinas','Kingstown',110000,389.000,'ONU',2),(198,'Santa Lucia','Santa Lucia','Castries',171000,616.000,'ONU',2),(199,'Santo Tome y Principe','Republica Democratica de Santo Tome y Principe','Santo Tome',189000,964.000,'ONU',1),(200,'Senegal','Republica de Senegal','Dakar',13067000,196722.000,'ONU',1),(201,'Serbia','Republica de Serbia','Belgrado',7139000,77474.000,'ONU',5),(202,'Seychelles','Republica de las Seychelles','Victoria',96000,455.000,'ONU',1),(203,'Sierra Leona','Republica de Sierra Leona','Freetown',6350000,71740.000,'ONU',1),(204,'Singapur','Republica de Singapur','Singapur',5523000,697.000,'ONU',3),(205,'Siria','Republica Arabe Siria','Damasco',22713000,185180.000,'ONU',3),(206,'Somalia','Republica Federal de Somalia','Mogadiscio',9774000,637657.000,'ONU',1),(207,'Sri Lanka','Republica Democratica Socialista de Sri Lanka','Colombo',20608000,65610.000,'ONU',3),(208,'Suazilandia','Reino de Suazilandia','Lobamba',1087000,17364.000,'ONU',1),(209,'Sudafrica','Republica de Sudafrica','Pretoria',53696000,1219090.000,'ONU',1),(210,'Sudan','Republica del Sudan','Jartum',37289000,1886068.000,'ONU',1),(211,'Sudan del Sur','Republica de Sudan del Sur','Yuba',10789000,619745.000,'ONU',1),(212,'Suecia','Reino de Suecia','Estocolmo',9687000,450295.000,'ONU',5),(213,'Suiza','Confederacion Helvetica','Berna',8171000,41277.000,'ONU',5),(214,'Surinam','Republica del Surinam','Paramaribo',554000,163820.000,'ONU',2),(215,'Tailandia','Reino de Tailandia','Bangkok',67948000,513120.000,'ONU',3),(216,'Tanzania','Republica Unida de Tanzania','Dodoma',47186000,947300.000,'ONU',1),(217,'Tayikistan','Republica de Tayikistan','Dusambe',8254000,143100.000,'ONU',3),(218,'Timor Oriental','Republica Democratica de Timor Oriental','Dili',1212000,14874.000,'ONU',3),(219,'Togo','Republica Togolesa','Lome',6868000,56785.000,'ONU',1),(220,'Tonga','Reino de Tonga','Nukualofa',105000,747.000,'ONU',6),(221,'Trinidad y Tobago','Republica de Trinidad y Tobago','Puerto España',1350000,5128.000,'ONU',2),(222,'Tunez','Republica Tunecina','Tunez',11001000,163610.000,'ONU',1),(223,'Turkmenistan','Turkmenistan','Asjabad',5562000,488100.000,'ONU',3),(224,'Turquia','Republica de Turquia','Ankara',77192000,783562.000,'ONU',3),(225,'Tuvalu','Tuvalu','Funafuti',12000,26.000,'ONU',6),(226,'Ucrania','Ucrania','Kiev',45321000,603550.000,'ONU',5),(227,'Uganda','Republica de Uganda','Kampala',36630000,241038.000,'ONU',1),(228,'Uruguay','Republica Oriental del Uruguay','Montevideo',3304000,176215.000,'ONU',2),(229,'Uzbekistan','Republica de Uzbekistan','Taskent',30570000,447400.000,'ONU',3),(230,'Vanuatu','Republica de Vanuatu','Port Vila',272000,12189.000,'ONU',6),(231,'Venezuela','Republica Bolivariana de Venezuela','Caracas',30258000,916445.000,'ONU',2),(232,'Vietnam','Republica Socialista de Vietnam','Hanoi',90643000,331210.000,'ONU',3),(233,'Yemen','Republica del Yemen','Sana',25999000,527968.000,'ONU',3),(234,'Yibuti','Republica de Yibuti','Yibuti',936000,23200.000,'ONU',1),(235,'Zambia','Republica de Zambia','Lusaka',15023000,752618.000,'ONU',1),(236,'Zimbabue','Republica de Zimbabue','Harare',13347000,390757.000,'ONU',1),(237,'Palestina','Estado de Palestina','Jerusalen Este',4549000,6220.000,'ONU',3),(238,'Vaticano, Ciudad del','Estado de la Ciudad del Vaticano','Ciudad del Vaticano',800,0.440,'ONU',5),(239,'Isla Baker','Isla Baker','Meyerton City',0,1.640,'no_incorporado',8),(240,'Guam','Guam','Agaña',161000,544.000,'no_incorporado',6),(241,'Isla Howland','Isla Howland',NULL,0,1.600,'no_incorporado',8),(242,'Marianas del Norte, Islas','Estado Libre Asociado de las Islas Marianas del Norte','Saipan',48000,464.000,'no_incorporado',6),(243,'Isla de Navaza','Isla de Navaza',NULL,0,5.200,'no_incorporado',2),(244,'Puerto Rico','Estado Libre Asociado de Puerto Rico','San Juan',3582000,9104.000,'no_incorporado',2),(245,'Samoa Americana','Territorio de la Samoa Americana','Pago Pago',55000,199.000,'no_incorporado',6),(246,'Virgenes de los Estados Unidos, Islas','Islas Virgenes de los Estados Unidos','Charlotte Amalie',105000,346.000,'no_incorporado',2),(247,'Abjasia','Republica de Abjasia','Sujumi',242862,8600.000,'independiente',3),(248,'Chipre del Norte','Republica Turca del Norte de Chipre','Nicosia',294906,3355.000,'independiente',3),(249,'Kosovo','Republica de Kosovo','Pristina',1847000,10887.000,'independiente',5),(250,'Nagorno Karabaj','Republica de Nagorno Karabaj','Stepanakert',138800,11458.000,'independiente',3),(251,'Osetia del Sur','Republica de Osetia del Sur','Tsjinval',80000,3900.000,'independiente',3),(252,'Somalilandia','Republica de Somalilandia','Hargeisa',3500000,137600.000,'independiente',1),(253,'Taiwan','Republica de China','Taipei',23397000,35980.000,'independiente',3),(254,'Transnistria','Republica Moldava Pridnestroviana','Tiraspol',518700,4163.000,'independiente',5),(255,'Isla Bouvet','Isla Bouvet',NULL,0,49.000,'glaciar',7),(256,'Niue','Niue','Alofi',2000,260.000,'estado_asociado',6),(257,'Guernsey','Bailiazgo de Guernsey','Saint Peter Port',64000,78.000,'dependiente',5),(258,'Jersey','Bailiazgo de Jersey','Saint Helier',102000,116.000,'dependiente',5),(259,'Isla de Man','Isla de Man','Douglas',88000,572.000,'dependiente',5),(260,'Sahara Occidental','Republica Arabe Saharaui Democratica','El Aaiun',629000,266000.000,'dependiente',1),(261,'Tokelau','Tokelau',NULL,1000,12.000,'dependiente',6),(262,'Nueva Caledonia','Territorio de Nueva Caledonia y dependencias','Numea',262000,18575.000,'comunidad',6),(263,'San Martin','Sint Maarten','Philipsburg',41000,34.000,'autonomo',2),(264,'Isla Clipperton','Isla Clipperton',NULL,0,6.000,'atolon',8),(265,'Islas Midway','Islas Midway',NULL,0,6.200,'atolon',8),(266,'Kingman, Arrecife','Arrecife Kingman',NULL,0,1.000,'arrecife',3); /*!40000 ALTER TABLE `territorio` 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 2021-08-23 10:53:08