[Jython-checkins] SF.net SVN: jython: [4874] trunk/sandbox/wierzbicki/javaone2008/world.sql

[<fwi...@us...>]

Revision: 4874
          http://jython.svn.sourceforge.net/jython/?rev=4874&view=rev
Author:   fwierzbicki
Date:     2008-07-08 03:01:19 -0700 (Tue, 08 Jul 2008)

Log Message:
-----------
sql for demo.

Added Paths:
-----------
    trunk/sandbox/wierzbicki/javaone2008/world.sql

Added: trunk/sandbox/wierzbicki/javaone2008/world.sql
===================================================================
--- trunk/sandbox/wierzbicki/javaone2008/world.sql	                        (rev 0)
+++ trunk/sandbox/wierzbicki/javaone2008/world.sql	2008-07-08 10:01:19 UTC (rev 4874)
@@ -0,0 +1,5391 @@
+-- MySQL dump 10.9
+--
+-- Host: localhost    Database: world
+-- ------------------------------------------------------
+-- Server version	4.1.13-log
+
+/*!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 latin1 */;
+/*!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 `City`
+--
+
+DROP TABLE IF EXISTS `City`;
+CREATE TABLE `City` (
+  `ID` int(11) NOT NULL auto_increment,
+  `Name` char(35) NOT NULL default '',
+  `CountryCode` char(3) NOT NULL default '',
+  `District` char(20) NOT NULL default '',
+  `Population` int(11) NOT NULL default '0',
+  PRIMARY KEY  (`ID`)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+--
+-- Dumping data for table `City`
+--
+
+INSERT INTO `City` VALUES (1,'Kabul','AFG','Kabol',1780000);
+INSERT INTO `City` VALUES (2,'Qandahar','AFG','Qandahar',237500);
+INSERT INTO `City` VALUES (3,'Herat','AFG','Herat',186800);
+INSERT INTO `City` VALUES (4,'Mazar-e-Sharif','AFG','Balkh',127800);
+INSERT INTO `City` VALUES (5,'Amsterdam','NLD','Noord-Holland',731200);
+INSERT INTO `City` VALUES (6,'Rotterdam','NLD','Zuid-Holland',593321);
+INSERT INTO `City` VALUES (7,'Haag','NLD','Zuid-Holland',440900);
+INSERT INTO `City` VALUES (8,'Utrecht','NLD','Utrecht',234323);
+INSERT INTO `City` VALUES (9,'Eindhoven','NLD','Noord-Brabant',201843);
+INSERT INTO `City` VALUES (10,'Tilburg','NLD','Noord-Brabant',193238);
+INSERT INTO `City` VALUES (11,'Groningen','NLD','Groningen',172701);
+INSERT INTO `City` VALUES (12,'Breda','NLD','Noord-Brabant',160398);
+INSERT INTO `City` VALUES (13,'Apeldoorn','NLD','Gelderland',153491);
+INSERT INTO `City` VALUES (14,'Nijmegen','NLD','Gelderland',152463);
+INSERT INTO `City` VALUES (15,'Enschede','NLD','Overijssel',149544);
+INSERT INTO `City` VALUES (16,'Haarlem','NLD','Noord-Holland',148772);
+INSERT INTO `City` VALUES (17,'Almere','NLD','Flevoland',142465);
+INSERT INTO `City` VALUES (18,'Arnhem','NLD','Gelderland',138020);
+INSERT INTO `City` VALUES (19,'Zaanstad','NLD','Noord-Holland',135621);
+INSERT INTO `City` VALUES (20,'\xB4s-Hertogenbosch','NLD','Noord-Brabant',129170);
+INSERT INTO `City` VALUES (21,'Amersfoort','NLD','Utrecht',126270);
+INSERT INTO `City` VALUES (22,'Maastricht','NLD','Limburg',122087);
+INSERT INTO `City` VALUES (23,'Dordrecht','NLD','Zuid-Holland',119811);
+INSERT INTO `City` VALUES (24,'Leiden','NLD','Zuid-Holland',117196);
+INSERT INTO `City` VALUES (25,'Haarlemmermeer','NLD','Noord-Holland',110722);
+INSERT INTO `City` VALUES (26,'Zoetermeer','NLD','Zuid-Holland',110214);
+INSERT INTO `City` VALUES (27,'Emmen','NLD','Drenthe',105853);
+INSERT INTO `City` VALUES (28,'Zwolle','NLD','Overijssel',105819);
+INSERT INTO `City` VALUES (29,'Ede','NLD','Gelderland',101574);
+INSERT INTO `City` VALUES (30,'Delft','NLD','Zuid-Holland',95268);
+INSERT INTO `City` VALUES (31,'Heerlen','NLD','Limburg',95052);
+INSERT INTO `City` VALUES (32,'Alkmaar','NLD','Noord-Holland',92713);
+INSERT INTO `City` VALUES (33,'Willemstad','ANT','Cura\xE7ao',2345);
+INSERT INTO `City` VALUES (34,'Tirana','ALB','Tirana',270000);
+INSERT INTO `City` VALUES (35,'Alger','DZA','Alger',2168000);
+INSERT INTO `City` VALUES (36,'Oran','DZA','Oran',609823);
+INSERT INTO `City` VALUES (37,'Constantine','DZA','Constantine',443727);
+INSERT INTO `City` VALUES (38,'Annaba','DZA','Annaba',222518);
+INSERT INTO `City` VALUES (39,'Batna','DZA','Batna',183377);
+INSERT INTO `City` VALUES (40,'S\xE9tif','DZA','S\xE9tif',179055);
+INSERT INTO `City` VALUES (41,'Sidi Bel Abb\xE8s','DZA','Sidi Bel Abb\xE8s',153106);
+INSERT INTO `City` VALUES (42,'Skikda','DZA','Skikda',128747);
+INSERT INTO `City` VALUES (43,'Biskra','DZA','Biskra',128281);
+INSERT INTO `City` VALUES (44,'Blida (el-Boulaida)','DZA','Blida',127284);
+INSERT INTO `City` VALUES (45,'B\xE9ja\xEFa','DZA','B\xE9ja\xEFa',117162);
+INSERT INTO `City` VALUES (46,'Mostaganem','DZA','Mostaganem',115212);
+INSERT INTO `City` VALUES (47,'T\xE9bessa','DZA','T\xE9bessa',112007);
+INSERT INTO `City` VALUES (48,'Tlemcen (Tilimsen)','DZA','Tlemcen',110242);
+INSERT INTO `City` VALUES (49,'B\xE9char','DZA','B\xE9char',107311);
+INSERT INTO `City` VALUES (50,'Tiaret','DZA','Tiaret',100118);
+INSERT INTO `City` VALUES (51,'Ech-Chleff (el-Asnam)','DZA','Chlef',96794);
+INSERT INTO `City` VALUES (52,'Gharda\xEFa','DZA','Gharda\xEFa',89415);
+INSERT INTO `City` VALUES (53,'Tafuna','ASM','Tutuila',5200);
+INSERT INTO `City` VALUES (54,'Fagatogo','ASM','Tutuila',2323);
+INSERT INTO `City` VALUES (55,'Andorra la Vella','AND','Andorra la Vella',21189);
+INSERT INTO `City` VALUES (56,'Luanda','AGO','Luanda',2022000);
+INSERT INTO `City` VALUES (57,'Huambo','AGO','Huambo',163100);
+INSERT INTO `City` VALUES (58,'Lobito','AGO','Benguela',130000);
+INSERT INTO `City` VALUES (59,'Benguela','AGO','Benguela',128300);
+INSERT INTO `City` VALUES (60,'Namibe','AGO','Namibe',118200);
+INSERT INTO `City` VALUES (61,'South Hill','AIA','\x96',961);
+INSERT INTO `City` VALUES (62,'The Valley','AIA','\x96',595);
+INSERT INTO `City` VALUES (63,'Saint John\xB4s','ATG','St John',24000);
+INSERT INTO `City` VALUES (64,'Dubai','ARE','Dubai',669181);
+INSERT INTO `City` VALUES (65,'Abu Dhabi','ARE','Abu Dhabi',398695);
+INSERT INTO `City` VALUES (66,'Sharja','ARE','Sharja',320095);
+INSERT INTO `City` VALUES (67,'al-Ayn','ARE','Abu Dhabi',225970);
+INSERT INTO `City` VALUES (68,'Ajman','ARE','Ajman',114395);
+INSERT INTO `City` VALUES (69,'Buenos Aires','ARG','Distrito Federal',2982146);
+INSERT INTO `City` VALUES (70,'La Matanza','ARG','Buenos Aires',1266461);
+INSERT INTO `City` VALUES (71,'C\xF3rdoba','ARG','C\xF3rdoba',1157507);
+INSERT INTO `City` VALUES (72,'Rosario','ARG','Santa F\xE9',907718);
+INSERT INTO `City` VALUES (73,'Lomas de Zamora','ARG','Buenos Aires',622013);
+INSERT INTO `City` VALUES (74,'Quilmes','ARG','Buenos Aires',559249);
+INSERT INTO `City` VALUES (75,'Almirante Brown','ARG','Buenos Aires',538918);
+INSERT INTO `City` VALUES (76,'La Plata','ARG','Buenos Aires',521936);
+INSERT INTO `City` VALUES (77,'Mar del Plata','ARG','Buenos Aires',512880);
+INSERT INTO `City` VALUES (78,'San Miguel de Tucum\xE1n','ARG','Tucum\xE1n',470809);
+INSERT INTO `City` VALUES (79,'Lan\xFAs','ARG','Buenos Aires',469735);
+INSERT INTO `City` VALUES (80,'Merlo','ARG','Buenos Aires',463846);
+INSERT INTO `City` VALUES (81,'General San Mart\xEDn','ARG','Buenos Aires',422542);
+INSERT INTO `City` VALUES (82,'Salta','ARG','Salta',367550);
+INSERT INTO `City` VALUES (83,'Moreno','ARG','Buenos Aires',356993);
+INSERT INTO `City` VALUES (84,'Santa F\xE9','ARG','Santa F\xE9',353063);
+INSERT INTO `City` VALUES (85,'Avellaneda','ARG','Buenos Aires',353046);
+INSERT INTO `City` VALUES (86,'Tres de Febrero','ARG','Buenos Aires',352311);
+INSERT INTO `City` VALUES (87,'Mor\xF3n','ARG','Buenos Aires',349246);
+INSERT INTO `City` VALUES (88,'Florencio Varela','ARG','Buenos Aires',315432);
+INSERT INTO `City` VALUES (89,'San Isidro','ARG','Buenos Aires',306341);
+INSERT INTO `City` VALUES (90,'Tigre','ARG','Buenos Aires',296226);
+INSERT INTO `City` VALUES (91,'Malvinas Argentinas','ARG','Buenos Aires',290335);
+INSERT INTO `City` VALUES (92,'Vicente L\xF3pez','ARG','Buenos Aires',288341);
+INSERT INTO `City` VALUES (93,'Berazategui','ARG','Buenos Aires',276916);
+INSERT INTO `City` VALUES (94,'Corrientes','ARG','Corrientes',258103);
+INSERT INTO `City` VALUES (95,'San Miguel','ARG','Buenos Aires',248700);
+INSERT INTO `City` VALUES (96,'Bah\xEDa Blanca','ARG','Buenos Aires',239810);
+INSERT INTO `City` VALUES (97,'Esteban Echeverr\xEDa','ARG','Buenos Aires',235760);
+INSERT INTO `City` VALUES (98,'Resistencia','ARG','Chaco',229212);
+INSERT INTO `City` VALUES (99,'Jos\xE9 C. Paz','ARG','Buenos Aires',221754);
+INSERT INTO `City` VALUES (100,'Paran\xE1','ARG','Entre Rios',207041);
+INSERT INTO `City` VALUES (101,'Godoy Cruz','ARG','Mendoza',206998);
+INSERT INTO `City` VALUES (102,'Posadas','ARG','Misiones',201273);
+INSERT INTO `City` VALUES (103,'Guaymall\xE9n','ARG','Mendoza',200595);
+INSERT INTO `City` VALUES (104,'Santiago del Estero','ARG','Santiago del Estero',189947);
+INSERT INTO `City` VALUES (105,'San Salvador de Jujuy','ARG','Jujuy',178748);
+INSERT INTO `City` VALUES (106,'Hurlingham','ARG','Buenos Aires',170028);
+INSERT INTO `City` VALUES (107,'Neuqu\xE9n','ARG','Neuqu\xE9n',167296);
+INSERT INTO `City` VALUES (108,'Ituzaing\xF3','ARG','Buenos Aires',158197);
+INSERT INTO `City` VALUES (109,'San Fernando','ARG','Buenos Aires',153036);
+INSERT INTO `City` VALUES (110,'Formosa','ARG','Formosa',147636);
+INSERT INTO `City` VALUES (111,'Las Heras','ARG','Mendoza',145823);
+INSERT INTO `City` VALUES (112,'La Rioja','ARG','La Rioja',138117);
+INSERT INTO `City` VALUES (113,'San Fernando del Valle de Cata','ARG','Catamarca',134935);
+INSERT INTO `City` VALUES (114,'R\xEDo Cuarto','ARG','C\xF3rdoba',134355);
+INSERT INTO `City` VALUES (115,'Comodoro Rivadavia','ARG','Chubut',124104);
+INSERT INTO `City` VALUES (116,'Mendoza','ARG','Mendoza',123027);
+INSERT INTO `City` VALUES (117,'San Nicol\xE1s de los Arroyos','ARG','Buenos Aires',119302);
+INSERT INTO `City` VALUES (118,'San Juan','ARG','San Juan',119152);
+INSERT INTO `City` VALUES (119,'Escobar','ARG','Buenos Aires',116675);
+INSERT INTO `City` VALUES (120,'Concordia','ARG','Entre Rios',116485);
+INSERT INTO `City` VALUES (121,'Pilar','ARG','Buenos Aires',113428);
+INSERT INTO `City` VALUES (122,'San Luis','ARG','San Luis',110136);
+INSERT INTO `City` VALUES (123,'Ezeiza','ARG','Buenos Aires',99578);
+INSERT INTO `City` VALUES (124,'San Rafael','ARG','Mendoza',94651);
+INSERT INTO `City` VALUES (125,'Tandil','ARG','Buenos Aires',91101);
+INSERT INTO `City` VALUES (126,'Yerevan','ARM','Yerevan',1248700);
+INSERT INTO `City` VALUES (127,'Gjumri','ARM','\x8Airak',211700);
+INSERT INTO `City` VALUES (128,'Vanadzor','ARM','Lori',172700);
+INSERT INTO `City` VALUES (129,'Oranjestad','ABW','\x96',29034);
+INSERT INTO `City` VALUES (130,'Sydney','AUS','New South Wales',3276207);
+INSERT INTO `City` VALUES (131,'Melbourne','AUS','Victoria',2865329);
+INSERT INTO `City` VALUES (132,'Brisbane','AUS','Queensland',1291117);
+INSERT INTO `City` VALUES (133,'Perth','AUS','West Australia',1096829);
+INSERT INTO `City` VALUES (134,'Adelaide','AUS','South Australia',978100);
+INSERT INTO `City` VALUES (135,'Canberra','AUS','Capital Region',322723);
+INSERT INTO `City` VALUES (136,'Gold Coast','AUS','Queensland',311932);
+INSERT INTO `City` VALUES (137,'Newcastle','AUS','New South Wales',270324);
+INSERT INTO `City` VALUES (138,'Central Coast','AUS','New South Wales',227657);
+INSERT INTO `City` VALUES (139,'Wollongong','AUS','New South Wales',219761);
+INSERT INTO `City` VALUES (140,'Hobart','AUS','Tasmania',126118);
+INSERT INTO `City` VALUES (141,'Geelong','AUS','Victoria',125382);
+INSERT INTO `City` VALUES (142,'Townsville','AUS','Queensland',109914);
+INSERT INTO `City` VALUES (143,'Cairns','AUS','Queensland',92273);
+INSERT INTO `City` VALUES (144,'Baku','AZE','Baki',1787800);
+INSERT INTO `City` VALUES (145,'G\xE4nc\xE4','AZE','G\xE4nc\xE4',299300);
+INSERT INTO `City` VALUES (146,'Sumqayit','AZE','Sumqayit',283000);
+INSERT INTO `City` VALUES (147,'Ming\xE4\xE7evir','AZE','Ming\xE4\xE7evir',93900);
+INSERT INTO `City` VALUES (148,'Nassau','BHS','New Providence',172000);
+INSERT INTO `City` VALUES (149,'al-Manama','BHR','al-Manama',148000);
+INSERT INTO `City` VALUES (150,'Dhaka','BGD','Dhaka',3612850);
+INSERT INTO `City` VALUES (151,'Chittagong','BGD','Chittagong',1392860);
+INSERT INTO `City` VALUES (152,'Khulna','BGD','Khulna',663340);
+INSERT INTO `City` VALUES (153,'Rajshahi','BGD','Rajshahi',294056);
+INSERT INTO `City` VALUES (154,'Narayanganj','BGD','Dhaka',202134);
+INSERT INTO `City` VALUES (155,'Rangpur','BGD','Rajshahi',191398);
+INSERT INTO `City` VALUES (156,'Mymensingh','BGD','Dhaka',188713);
+INSERT INTO `City` VALUES (157,'Barisal','BGD','Barisal',170232);
+INSERT INTO `City` VALUES (158,'Tungi','BGD','Dhaka',168702);
+INSERT INTO `City` VALUES (159,'Jessore','BGD','Khulna',139710);
+INSERT INTO `City` VALUES (160,'Comilla','BGD','Chittagong',135313);
+INSERT INTO `City` VALUES (161,'Nawabganj','BGD','Rajshahi',130577);
+INSERT INTO `City` VALUES (162,'Dinajpur','BGD','Rajshahi',127815);
+INSERT INTO `City` VALUES (163,'Bogra','BGD','Rajshahi',120170);
+INSERT INTO `City` VALUES (164,'Sylhet','BGD','Sylhet',117396);
+INSERT INTO `City` VALUES (165,'Brahmanbaria','BGD','Chittagong',109032);
+INSERT INTO `City` VALUES (166,'Tangail','BGD','Dhaka',106004);
+INSERT INTO `City` VALUES (167,'Jamalpur','BGD','Dhaka',103556);
+INSERT INTO `City` VALUES (168,'Pabna','BGD','Rajshahi',103277);
+INSERT INTO `City` VALUES (169,'Naogaon','BGD','Rajshahi',101266);
+INSERT INTO `City` VALUES (170,'Sirajganj','BGD','Rajshahi',99669);
+INSERT INTO `City` VALUES (171,'Narsinghdi','BGD','Dhaka',98342);
+INSERT INTO `City` VALUES (172,'Saidpur','BGD','Rajshahi',96777);
+INSERT INTO `City` VALUES (173,'Gazipur','BGD','Dhaka',96717);
+INSERT INTO `City` VALUES (174,'Bridgetown','BRB','St Michael',6070);
+INSERT INTO `City` VALUES (175,'Antwerpen','BEL','Antwerpen',446525);
+INSERT INTO `City` VALUES (176,'Gent','BEL','East Flanderi',224180);
+INSERT INTO `City` VALUES (177,'Charleroi','BEL','Hainaut',200827);
+INSERT INTO `City` VALUES (178,'Li\xE8ge','BEL','Li\xE8ge',185639);
+INSERT INTO `City` VALUES (179,'Bruxelles [Brussel]','BEL','Bryssel',133859);
+INSERT INTO `City` VALUES (180,'Brugge','BEL','West Flanderi',116246);
+INSERT INTO `City` VALUES (181,'Schaerbeek','BEL','Bryssel',105692);
+INSERT INTO `City` VALUES (182,'Namur','BEL','Namur',105419);
+INSERT INTO `City` VALUES (183,'Mons','BEL','Hainaut',90935);
+INSERT INTO `City` VALUES (184,'Belize City','BLZ','Belize City',55810);
+INSERT INTO `City` VALUES (185,'Belmopan','BLZ','Cayo',7105);
+INSERT INTO `City` VALUES (186,'Cotonou','BEN','Atlantique',536827);
+INSERT INTO `City` VALUES (187,'Porto-Novo','BEN','Ou\xE9m\xE9',194000);
+INSERT INTO `City` VALUES (188,'Djougou','BEN','Atacora',134099);
+INSERT INTO `City` VALUES (189,'Parakou','BEN','Borgou',103577);
+INSERT INTO `City` VALUES (190,'Saint George','BMU','Saint George\xB4s',1800);
+INSERT INTO `City` VALUES (191,'Hamilton','BMU','Hamilton',1200);
+INSERT INTO `City` VALUES (192,'Thimphu','BTN','Thimphu',22000);
+INSERT INTO `City` VALUES (193,'Santa Cruz de la Sierra','BOL','Santa Cruz',935361);
+INSERT INTO `City` VALUES (194,'La Paz','BOL','La Paz',758141);
+INSERT INTO `City` VALUES (195,'El Alto','BOL','La Paz',534466);
+INSERT INTO `City` VALUES (196,'Cochabamba','BOL','Cochabamba',482800);
+INSERT INTO `City` VALUES (197,'Oruro','BOL','Oruro',223553);
+INSERT INTO `City` VALUES (198,'Sucre','BOL','Chuquisaca',178426);
+INSERT INTO `City` VALUES (199,'Potos\xED','BOL','Potos\xED',140642);
+INSERT INTO `City` VALUES (200,'Tarija','BOL','Tarija',125255);
+INSERT INTO `City` VALUES (201,'Sarajevo','BIH','Federaatio',360000);
+INSERT INTO `City` VALUES (202,'Banja Luka','BIH','Republika Srpska',143079);
+INSERT INTO `City` VALUES (203,'Zenica','BIH','Federaatio',96027);
+INSERT INTO `City` VALUES (204,'Gaborone','BWA','Gaborone',213017);
+INSERT INTO `City` VALUES (205,'Francistown','BWA','Francistown',101805);
+INSERT INTO `City` VALUES (206,'S\xE3o Paulo','BRA','S\xE3o Paulo',9968485);
+INSERT INTO `City` VALUES (207,'Rio de Janeiro','BRA','Rio de Janeiro',5598953);
+INSERT INTO `City` VALUES (208,'Salvador','BRA','Bahia',2302832);
+INSERT INTO `City` VALUES (209,'Belo Horizonte','BRA','Minas Gerais',2139125);
+INSERT INTO `City` VALUES (210,'Fortaleza','BRA','Cear\xE1',2097757);
+INSERT INTO `City` VALUES (211,'Bras\xEDlia','BRA','Distrito Federal',1969868);
+INSERT INTO `City` VALUES (212,'Curitiba','BRA','Paran\xE1',1584232);
+INSERT INTO `City` VALUES (213,'Recife','BRA','Pernambuco',1378087);
+INSERT INTO `City` VALUES (214,'Porto Alegre','BRA','Rio Grande do Sul',1314032);
+INSERT INTO `City` VALUES (215,'Manaus','BRA','Amazonas',1255049);
+INSERT INTO `City` VALUES (216,'Bel\xE9m','BRA','Par\xE1',1186926);
+INSERT INTO `City` VALUES (217,'Guarulhos','BRA','S\xE3o Paulo',1095874);
+INSERT INTO `City` VALUES (218,'Goi\xE2nia','BRA','Goi\xE1s',1056330);
+INSERT INTO `City` VALUES (219,'Campinas','BRA','S\xE3o Paulo',950043);
+INSERT INTO `City` VALUES (220,'S\xE3o Gon\xE7alo','BRA','Rio de Janeiro',869254);
+INSERT INTO `City` VALUES (221,'Nova Igua\xE7u','BRA','Rio de Janeiro',862225);
+INSERT INTO `City` VALUES (222,'S\xE3o Lu\xEDs','BRA','Maranh\xE3o',837588);
+INSERT INTO `City` VALUES (223,'Macei\xF3','BRA','Alagoas',786288);
+INSERT INTO `City` VALUES (224,'Duque de Caxias','BRA','Rio de Janeiro',746758);
+INSERT INTO `City` VALUES (225,'S\xE3o Bernardo do Campo','BRA','S\xE3o Paulo',723132);
+INSERT INTO `City` VALUES (226,'Teresina','BRA','Piau\xED',691942);
+INSERT INTO `City` VALUES (227,'Natal','BRA','Rio Grande do Norte',688955);
+INSERT INTO `City` VALUES (228,'Osasco','BRA','S\xE3o Paulo',659604);
+INSERT INTO `City` VALUES (229,'Campo Grande','BRA','Mato Grosso do Sul',649593);
+INSERT INTO `City` VALUES (230,'Santo Andr\xE9','BRA','S\xE3o Paulo',630073);
+INSERT INTO `City` VALUES (231,'Jo\xE3o Pessoa','BRA','Para\xEDba',584029);
+INSERT INTO `City` VALUES (232,'Jaboat\xE3o dos Guararapes','BRA','Pernambuco',558680);
+INSERT INTO `City` VALUES (233,'Contagem','BRA','Minas Gerais',520801);
+INSERT INTO `City` VALUES (234,'S\xE3o Jos\xE9 dos Campos','BRA','S\xE3o Paulo',515553);
+INSERT INTO `City` VALUES (235,'Uberl\xE2ndia','BRA','Minas Gerais',487222);
+INSERT INTO `City` VALUES (236,'Feira de Santana','BRA','Bahia',479992);
+INSERT INTO `City` VALUES (237,'Ribeir\xE3o Preto','BRA','S\xE3o Paulo',473276);
+INSERT INTO `City` VALUES (238,'Sorocaba','BRA','S\xE3o Paulo',466823);
+INSERT INTO `City` VALUES (239,'Niter\xF3i','BRA','Rio de Janeiro',459884);
+INSERT INTO `City` VALUES (240,'Cuiab\xE1','BRA','Mato Grosso',453813);
+INSERT INTO `City` VALUES (241,'Juiz de Fora','BRA','Minas Gerais',450288);
+INSERT INTO `City` VALUES (242,'Aracaju','BRA','Sergipe',445555);
+INSERT INTO `City` VALUES (243,'S\xE3o Jo\xE3o de Meriti','BRA','Rio de Janeiro',440052);
+INSERT INTO `City` VALUES (244,'Londrina','BRA','Paran\xE1',432257);
+INSERT INTO `City` VALUES (245,'Joinville','BRA','Santa Catarina',428011);
+INSERT INTO `City` VALUES (246,'Belford Roxo','BRA','Rio de Janeiro',425194);
+INSERT INTO `City` VALUES (247,'Santos','BRA','S\xE3o Paulo',408748);
+INSERT INTO `City` VALUES (248,'Ananindeua','BRA','Par\xE1',400940);
+INSERT INTO `City` VALUES (249,'Campos dos Goytacazes','BRA','Rio de Janeiro',398418);
+INSERT INTO `City` VALUES (250,'Mau\xE1','BRA','S\xE3o Paulo',375055);
+INSERT INTO `City` VALUES (251,'Carapicu\xEDba','BRA','S\xE3o Paulo',357552);
+INSERT INTO `City` VALUES (252,'Olinda','BRA','Pernambuco',354732);
+INSERT INTO `City` VALUES (253,'Campina Grande','BRA','Para\xEDba',352497);
+INSERT INTO `City` VALUES (254,'S\xE3o Jos\xE9 do Rio Preto','BRA','S\xE3o Paulo',351944);
+INSERT INTO `City` VALUES (255,'Caxias do Sul','BRA','Rio Grande do Sul',349581);
+INSERT INTO `City` VALUES (256,'Moji das Cruzes','BRA','S\xE3o Paulo',339194);
+INSERT INTO `City` VALUES (257,'Diadema','BRA','S\xE3o Paulo',335078);
+INSERT INTO `City` VALUES (258,'Aparecida de Goi\xE2nia','BRA','Goi\xE1s',324662);
+INSERT INTO `City` VALUES (259,'Piracicaba','BRA','S\xE3o Paulo',319104);
+INSERT INTO `City` VALUES (260,'Cariacica','BRA','Esp\xEDrito Santo',319033);
+INSERT INTO `City` VALUES (261,'Vila Velha','BRA','Esp\xEDrito Santo',318758);
+INSERT INTO `City` VALUES (262,'Pelotas','BRA','Rio Grande do Sul',315415);
+INSERT INTO `City` VALUES (263,'Bauru','BRA','S\xE3o Paulo',313670);
+INSERT INTO `City` VALUES (264,'Porto Velho','BRA','Rond\xF4nia',309750);
+INSERT INTO `City` VALUES (265,'Serra','BRA','Esp\xEDrito Santo',302666);
+INSERT INTO `City` VALUES (266,'Betim','BRA','Minas Gerais',302108);
+INSERT INTO `City` VALUES (267,'Jund\xEDa\xED','BRA','S\xE3o Paulo',296127);
+INSERT INTO `City` VALUES (268,'Canoas','BRA','Rio Grande do Sul',294125);
+INSERT INTO `City` VALUES (269,'Franca','BRA','S\xE3o Paulo',290139);
+INSERT INTO `City` VALUES (270,'S\xE3o Vicente','BRA','S\xE3o Paulo',286848);
+INSERT INTO `City` VALUES (271,'Maring\xE1','BRA','Paran\xE1',286461);
+INSERT INTO `City` VALUES (272,'Montes Claros','BRA','Minas Gerais',286058);
+INSERT INTO `City` VALUES (273,'An\xE1polis','BRA','Goi\xE1s',282197);
+INSERT INTO `City` VALUES (274,'Florian\xF3polis','BRA','Santa Catarina',281928);
+INSERT INTO `City` VALUES (275,'Petr\xF3polis','BRA','Rio de Janeiro',279183);
+INSERT INTO `City` VALUES (276,'Itaquaquecetuba','BRA','S\xE3o Paulo',270874);
+INSERT INTO `City` VALUES (277,'Vit\xF3ria','BRA','Esp\xEDrito Santo',270626);
+INSERT INTO `City` VALUES (278,'Ponta Grossa','BRA','Paran\xE1',268013);
+INSERT INTO `City` VALUES (279,'Rio Branco','BRA','Acre',259537);
+INSERT INTO `City` VALUES (280,'Foz do Igua\xE7u','BRA','Paran\xE1',259425);
+INSERT INTO `City` VALUES (281,'Macap\xE1','BRA','Amap\xE1',256033);
+INSERT INTO `City` VALUES (282,'Ilh\xE9us','BRA','Bahia',254970);
+INSERT INTO `City` VALUES (283,'Vit\xF3ria da Conquista','BRA','Bahia',253587);
+INSERT INTO `City` VALUES (284,'Uberaba','BRA','Minas Gerais',249225);
+INSERT INTO `City` VALUES (285,'Paulista','BRA','Pernambuco',248473);
+INSERT INTO `City` VALUES (286,'Limeira','BRA','S\xE3o Paulo',245497);
+INSERT INTO `City` VALUES (287,'Blumenau','BRA','Santa Catarina',244379);
+INSERT INTO `City` VALUES (288,'Caruaru','BRA','Pernambuco',244247);
+INSERT INTO `City` VALUES (289,'Santar\xE9m','BRA','Par\xE1',241771);
+INSERT INTO `City` VALUES (290,'Volta Redonda','BRA','Rio de Janeiro',240315);
+INSERT INTO `City` VALUES (291,'Novo Hamburgo','BRA','Rio Grande do Sul',239940);
+INSERT INTO `City` VALUES (292,'Caucaia','BRA','Cear\xE1',238738);
+INSERT INTO `City` VALUES (293,'Santa Maria','BRA','Rio Grande do Sul',238473);
+INSERT INTO `City` VALUES (294,'Cascavel','BRA','Paran\xE1',237510);
+INSERT INTO `City` VALUES (295,'Guaruj\xE1','BRA','S\xE3o Paulo',237206);
+INSERT INTO `City` VALUES (296,'Ribeir\xE3o das Neves','BRA','Minas Gerais',232685);
+INSERT INTO `City` VALUES (297,'Governador Valadares','BRA','Minas Gerais',231724);
+INSERT INTO `City` VALUES (298,'Taubat\xE9','BRA','S\xE3o Paulo',229130);
+INSERT INTO `City` VALUES (299,'Imperatriz','BRA','Maranh\xE3o',224564);
+INSERT INTO `City` VALUES (300,'Gravata\xED','BRA','Rio Grande do Sul',223011);
+INSERT INTO `City` VALUES (301,'Embu','BRA','S\xE3o Paulo',222223);
+INSERT INTO `City` VALUES (302,'Mossor\xF3','BRA','Rio Grande do Norte',214901);
+INSERT INTO `City` VALUES (303,'V\xE1rzea Grande','BRA','Mato Grosso',214435);
+INSERT INTO `City` VALUES (304,'Petrolina','BRA','Pernambuco',210540);
+INSERT INTO `City` VALUES (305,'Barueri','BRA','S\xE3o Paulo',208426);
+INSERT INTO `City` VALUES (306,'Viam\xE3o','BRA','Rio Grande do Sul',207557);
+INSERT INTO `City` VALUES (307,'Ipatinga','BRA','Minas Gerais',206338);
+INSERT INTO `City` VALUES (308,'Juazeiro','BRA','Bahia',201073);
+INSERT INTO `City` VALUES (309,'Juazeiro do Norte','BRA','Cear\xE1',199636);
+INSERT INTO `City` VALUES (310,'Tabo\xE3o da Serra','BRA','S\xE3o Paulo',197550);
+INSERT INTO `City` VALUES (311,'S\xE3o Jos\xE9 dos Pinhais','BRA','Paran\xE1',196884);
+INSERT INTO `City` VALUES (312,'Mag\xE9','BRA','Rio de Janeiro',196147);
+INSERT INTO `City` VALUES (313,'Suzano','BRA','S\xE3o Paulo',195434);
+INSERT INTO `City` VALUES (314,'S\xE3o Leopoldo','BRA','Rio Grande do Sul',189258);
+INSERT INTO `City` VALUES (315,'Mar\xEDlia','BRA','S\xE3o Paulo',188691);
+INSERT INTO `City` VALUES (316,'S\xE3o Carlos','BRA','S\xE3o Paulo',187122);
+INSERT INTO `City` VALUES (317,'Sumar\xE9','BRA','S\xE3o Paulo',186205);
+INSERT INTO `City` VALUES (318,'Presidente Prudente','BRA','S\xE3o Paulo',185340);
+INSERT INTO `City` VALUES (319,'Divin\xF3polis','BRA','Minas Gerais',185047);
+INSERT INTO `City` VALUES (320,'Sete Lagoas','BRA','Minas Gerais',182984);
+INSERT INTO `City` VALUES (321,'Rio Grande','BRA','Rio Grande do Sul',182222);
+INSERT INTO `City` VALUES (322,'Itabuna','BRA','Bahia',182148);
+INSERT INTO `City` VALUES (323,'Jequi\xE9','BRA','Bahia',179128);
+INSERT INTO `City` VALUES (324,'Arapiraca','BRA','Alagoas',178988);
+INSERT INTO `City` VALUES (325,'Colombo','BRA','Paran\xE1',177764);
+INSERT INTO `City` VALUES (326,'Americana','BRA','S\xE3o Paulo',177409);
+INSERT INTO `City` VALUES (327,'Alvorada','BRA','Rio Grande do Sul',175574);
+INSERT INTO `City` VALUES (328,'Araraquara','BRA','S\xE3o Paulo',174381);
+INSERT INTO `City` VALUES (329,'Itabora\xED','BRA','Rio de Janeiro',173977);
+INSERT INTO `City` VALUES (330,'Santa B\xE1rbara d\xB4Oeste','BRA','S\xE3o Paulo',171657);
+INSERT INTO `City` VALUES (331,'Nova Friburgo','BRA','Rio de Janeiro',170697);
+INSERT INTO `City` VALUES (332,'Jacare\xED','BRA','S\xE3o Paulo',170356);
+INSERT INTO `City` VALUES (333,'Ara\xE7atuba','BRA','S\xE3o Paulo',169303);
+INSERT INTO `City` VALUES (334,'Barra Mansa','BRA','Rio de Janeiro',168953);
+INSERT INTO `City` VALUES (335,'Praia Grande','BRA','S\xE3o Paulo',168434);
+INSERT INTO `City` VALUES (336,'Marab\xE1','BRA','Par\xE1',167795);
+INSERT INTO `City` VALUES (337,'Crici\xFAma','BRA','Santa Catarina',167661);
+INSERT INTO `City` VALUES (338,'Boa Vista','BRA','Roraima',167185);
+INSERT INTO `City` VALUES (339,'Passo Fundo','BRA','Rio Grande do Sul',166343);
+INSERT INTO `City` VALUES (340,'Dourados','BRA','Mato Grosso do Sul',164716);
+INSERT INTO `City` VALUES (341,'Santa Luzia','BRA','Minas Gerais',164704);
+INSERT INTO `City` VALUES (342,'Rio Claro','BRA','S\xE3o Paulo',163551);
+INSERT INTO `City` VALUES (343,'Maracana\xFA','BRA','Cear\xE1',162022);
+INSERT INTO `City` VALUES (344,'Guarapuava','BRA','Paran\xE1',160510);
+INSERT INTO `City` VALUES (345,'Rondon\xF3polis','BRA','Mato Grosso',155115);
+INSERT INTO `City` VALUES (346,'S\xE3o Jos\xE9','BRA','Santa Catarina',155105);
+INSERT INTO `City` VALUES (347,'Cachoeiro de Itapemirim','BRA','Esp\xEDrito Santo',155024);
+INSERT INTO `City` VALUES (348,'Nil\xF3polis','BRA','Rio de Janeiro',153383);
+INSERT INTO `City` VALUES (349,'Itapevi','BRA','S\xE3o Paulo',150664);
+INSERT INTO `City` VALUES (350,'Cabo de Santo Agostinho','BRA','Pernambuco',149964);
+INSERT INTO `City` VALUES (351,'Cama\xE7ari','BRA','Bahia',149146);
+INSERT INTO `City` VALUES (352,'Sobral','BRA','Cear\xE1',146005);
+INSERT INTO `City` VALUES (353,'Itaja\xED','BRA','Santa Catarina',145197);
+INSERT INTO `City` VALUES (354,'Chapec\xF3','BRA','Santa Catarina',144158);
+INSERT INTO `City` VALUES (355,'Cotia','BRA','S\xE3o Paulo',140042);
+INSERT INTO `City` VALUES (356,'Lages','BRA','Santa Catarina',139570);
+INSERT INTO `City` VALUES (357,'Ferraz de Vasconcelos','BRA','S\xE3o Paulo',139283);
+INSERT INTO `City` VALUES (358,'Indaiatuba','BRA','S\xE3o Paulo',135968);
+INSERT INTO `City` VALUES (359,'Hortol\xE2ndia','BRA','S\xE3o Paulo',135755);
+INSERT INTO `City` VALUES (360,'Caxias','BRA','Maranh\xE3o',133980);
+INSERT INTO `City` VALUES (361,'S\xE3o Caetano do Sul','BRA','S\xE3o Paulo',133321);
+INSERT INTO `City` VALUES (362,'Itu','BRA','S\xE3o Paulo',132736);
+INSERT INTO `City` VALUES (363,'Nossa Senhora do Socorro','BRA','Sergipe',131351);
+INSERT INTO `City` VALUES (364,'Parna\xEDba','BRA','Piau\xED',129756);
+INSERT INTO `City` VALUES (365,'Po\xE7os de Caldas','BRA','Minas Gerais',129683);
+INSERT INTO `City` VALUES (366,'Teres\xF3polis','BRA','Rio de Janeiro',128079);
+INSERT INTO `City` VALUES (367,'Barreiras','BRA','Bahia',127801);
+INSERT INTO `City` VALUES (368,'Castanhal','BRA','Par\xE1',127634);
+INSERT INTO `City` VALUES (369,'Alagoinhas','BRA','Bahia',126820);
+INSERT INTO `City` VALUES (370,'Itapecerica da Serra','BRA','S\xE3o Paulo',126672);
+INSERT INTO `City` VALUES (371,'Uruguaiana','BRA','Rio Grande do Sul',126305);
+INSERT INTO `City` VALUES (372,'Paranagu\xE1','BRA','Paran\xE1',126076);
+INSERT INTO `City` VALUES (373,'Ibirit\xE9','BRA','Minas Gerais',125982);
+INSERT INTO `City` VALUES (374,'Timon','BRA','Maranh\xE3o',125812);
+INSERT INTO `City` VALUES (375,'Luzi\xE2nia','BRA','Goi\xE1s',125597);
+INSERT INTO `City` VALUES (376,'Maca\xE9','BRA','Rio de Janeiro',125597);
+INSERT INTO `City` VALUES (377,'Te\xF3filo Otoni','BRA','Minas Gerais',124489);
+INSERT INTO `City` VALUES (378,'Moji-Gua\xE7u','BRA','S\xE3o Paulo',123782);
+INSERT INTO `City` VALUES (379,'Palmas','BRA','Tocantins',121919);
+INSERT INTO `City` VALUES (380,'Pindamonhangaba','BRA','S\xE3o Paulo',121904);
+INSERT INTO `City` VALUES (381,'Francisco Morato','BRA','S\xE3o Paulo',121197);
+INSERT INTO `City` VALUES (382,'Bag\xE9','BRA','Rio Grande do Sul',120793);
+INSERT INTO `City` VALUES (383,'Sapucaia do Sul','BRA','Rio Grande do Sul',120217);
+INSERT INTO `City` VALUES (384,'Cabo Frio','BRA','Rio de Janeiro',119503);
+INSERT INTO `City` VALUES (385,'Itapetininga','BRA','S\xE3o Paulo',119391);
+INSERT INTO `City` VALUES (386,'Patos de Minas','BRA','Minas Gerais',119262);
+INSERT INTO `City` VALUES (387,'Camaragibe','BRA','Pernambuco',118968);
+INSERT INTO `City` VALUES (388,'Bragan\xE7a Paulista','BRA','S\xE3o Paulo',116929);
+INSERT INTO `City` VALUES (389,'Queimados','BRA','Rio de Janeiro',115020);
+INSERT INTO `City` VALUES (390,'Aragua\xEDna','BRA','Tocantins',114948);
+INSERT INTO `City` VALUES (391,'Garanhuns','BRA','Pernambuco',114603);
+INSERT INTO `City` VALUES (392,'Vit\xF3ria de Santo Ant\xE3o','BRA','Pernambuco',113595);
+INSERT INTO `City` VALUES (393,'Santa Rita','BRA','Para\xEDba',113135);
+INSERT INTO `City` VALUES (394,'Barbacena','BRA','Minas Gerais',113079);
+INSERT INTO `City` VALUES (395,'Abaetetuba','BRA','Par\xE1',111258);
+INSERT INTO `City` VALUES (396,'Ja\xFA','BRA','S\xE3o Paulo',109965);
+INSERT INTO `City` VALUES (397,'Lauro de Freitas','BRA','Bahia',109236);
+INSERT INTO `City` VALUES (398,'Franco da Rocha','BRA','S\xE3o Paulo',108964);
+INSERT INTO `City` VALUES (399,'Teixeira de Freitas','BRA','Bahia',108441);
+INSERT INTO `City` VALUES (400,'Varginha','BRA','Minas Gerais',108314);
+INSERT INTO `City` VALUES (401,'Ribeir\xE3o Pires','BRA','S\xE3o Paulo',108121);
+INSERT INTO `City` VALUES (402,'Sabar\xE1','BRA','Minas Gerais',107781);
+INSERT INTO `City` VALUES (403,'Catanduva','BRA','S\xE3o Paulo',107761);
+INSERT INTO `City` VALUES (404,'Rio Verde','BRA','Goi\xE1s',107755);
+INSERT INTO `City` VALUES (405,'Botucatu','BRA','S\xE3o Paulo',107663);
+INSERT INTO `City` VALUES (406,'Colatina','BRA','Esp\xEDrito Santo',107354);
+INSERT INTO `City` VALUES (407,'Santa Cruz do Sul','BRA','Rio Grande do Sul',106734);
+INSERT INTO `City` VALUES (408,'Linhares','BRA','Esp\xEDrito Santo',106278);
+INSERT INTO `City` VALUES (409,'Apucarana','BRA','Paran\xE1',105114);
+INSERT INTO `City` VALUES (410,'Barretos','BRA','S\xE3o Paulo',104156);
+INSERT INTO `City` VALUES (411,'Guaratinguet\xE1','BRA','S\xE3o Paulo',103433);
+INSERT INTO `City` VALUES (412,'Cachoeirinha','BRA','Rio Grande do Sul',103240);
+INSERT INTO `City` VALUES (413,'Cod\xF3','BRA','Maranh\xE3o',103153);
+INSERT INTO `City` VALUES (414,'Jaragu\xE1 do Sul','BRA','Santa Catarina',102580);
+INSERT INTO `City` VALUES (415,'Cubat\xE3o','BRA','S\xE3o Paulo',102372);
+INSERT INTO `City` VALUES (416,'Itabira','BRA','Minas Gerais',102217);
+INSERT INTO `City` VALUES (417,'Itaituba','BRA','Par\xE1',101320);
+INSERT INTO `City` VALUES (418,'Araras','BRA','S\xE3o Paulo',101046);
+INSERT INTO `City` VALUES (419,'Resende','BRA','Rio de Janeiro',100627);
+INSERT INTO `City` VALUES (420,'Atibaia','BRA','S\xE3o Paulo',100356);
+INSERT INTO `City` VALUES (421,'Pouso Alegre','BRA','Minas Gerais',100028);
+INSERT INTO `City` VALUES (422,'Toledo','BRA','Paran\xE1',99387);
+INSERT INTO `City` VALUES (423,'Crato','BRA','Cear\xE1',98965);
+INSERT INTO `City` VALUES (424,'Passos','BRA','Minas Gerais',98570);
+INSERT INTO `City` VALUES (425,'Araguari','BRA','Minas Gerais',98399);
+INSERT INTO `City` VALUES (426,'S\xE3o Jos\xE9 de Ribamar','BRA','Maranh\xE3o',98318);
+INSERT INTO `City` VALUES (427,'Pinhais','BRA','Paran\xE1',98198);
+INSERT INTO `City` VALUES (428,'Sert\xE3ozinho','BRA','S\xE3o Paulo',98140);
+INSERT INTO `City` VALUES (429,'Conselheiro Lafaiete','BRA','Minas Gerais',97507);
+INSERT INTO `City` VALUES (430,'Paulo Afonso','BRA','Bahia',97291);
+INSERT INTO `City` VALUES (431,'Angra dos Reis','BRA','Rio de Janeiro',96864);
+INSERT INTO `City` VALUES (432,'Eun\xE1polis','BRA','Bahia',96610);
+INSERT INTO `City` VALUES (433,'Salto','BRA','S\xE3o Paulo',96348);
+INSERT INTO `City` VALUES (434,'Ourinhos','BRA','S\xE3o Paulo',96291);
+INSERT INTO `City` VALUES (435,'Parnamirim','BRA','Rio Grande do Norte',96210);
+INSERT INTO `City` VALUES (436,'Jacobina','BRA','Bahia',96131);
+INSERT INTO `City` VALUES (437,'Coronel Fabriciano','BRA','Minas Gerais',95933);
+INSERT INTO `City` VALUES (438,'Birigui','BRA','S\xE3o Paulo',94685);
+INSERT INTO `City` VALUES (439,'Tatu\xED','BRA','S\xE3o Paulo',93897);
+INSERT INTO `City` VALUES (440,'Ji-Paran\xE1','BRA','Rond\xF4nia',93346);
+INSERT INTO `City` VALUES (441,'Bacabal','BRA','Maranh\xE3o',93121);
+INSERT INTO `City` VALUES (442,'Camet\xE1','BRA','Par\xE1',92779);
+INSERT INTO `City` VALUES (443,'Gua\xEDba','BRA','Rio Grande do Sul',92224);
+INSERT INTO `City` VALUES (444,'S\xE3o Louren\xE7o da Mata','BRA','Pernambuco',91999);
+INSERT INTO `City` VALUES (445,'Santana do Livramento','BRA','Rio Grande do Sul',91779);
+INSERT INTO `City` VALUES (446,'Votorantim','BRA','S\xE3o Paulo',91777);
+INSERT INTO `City` VALUES (447,'Campo Largo','BRA','Paran\xE1',91203);
+INSERT INTO `City` VALUES (448,'Patos','BRA','Para\xEDba',90519);
+INSERT INTO `City` VALUES (449,'Ituiutaba','BRA','Minas Gerais',90507);
+INSERT INTO `City` VALUES (450,'Corumb\xE1','BRA','Mato Grosso do Sul',90111);
+INSERT INTO `City` VALUES (451,'Palho\xE7a','BRA','Santa Catarina',89465);
+INSERT INTO `City` VALUES (452,'Barra do Pira\xED','BRA','Rio de Janeiro',89388);
+INSERT INTO `City` VALUES (453,'Bento Gon\xE7alves','BRA','Rio Grande do Sul',89254);
+INSERT INTO `City` VALUES (454,'Po\xE1','BRA','S\xE3o Paulo',89236);
+INSERT INTO `City` VALUES (455,'\xC1guas Lindas de Goi\xE1s','BRA','Goi\xE1s',89200);
+INSERT INTO `City` VALUES (456,'London','GBR','England',7285000);
+INSERT INTO `City` VALUES (457,'Birmingham','GBR','England',1013000);
+INSERT INTO `City` VALUES (458,'Glasgow','GBR','Scotland',619680);
+INSERT INTO `City` VALUES (459,'Liverpool','GBR','England',461000);
+INSERT INTO `City` VALUES (460,'Edinburgh','GBR','Scotland',450180);
+INSERT INTO `City` VALUES (461,'Sheffield','GBR','England',431607);
+INSERT INTO `City` VALUES (462,'Manchester','GBR','England',430000);
+INSERT INTO `City` VALUES (463,'Leeds','GBR','England',424194);
+INSERT INTO `City` VALUES (464,'Bristol','GBR','England',402000);
+INSERT INTO `City` VALUES (465,'Cardiff','GBR','Wales',321000);
+INSERT INTO `City` VALUES (466,'Coventry','GBR','England',304000);
+INSERT INTO `City` VALUES (467,'Leicester','GBR','England',294000);
+INSERT INTO `City` VALUES (468,'Bradford','GBR','England',289376);
+INSERT INTO `City` VALUES (469,'Belfast','GBR','North Ireland',287500);
+INSERT INTO `City` VALUES (470,'Nottingham','GBR','England',287000);
+INSERT INTO `City` VALUES (471,'Kingston upon Hull','GBR','England',262000);
+INSERT INTO `City` VALUES (472,'Plymouth','GBR','England',253000);
+INSERT INTO `City` VALUES (473,'Stoke-on-Trent','GBR','England',252000);
+INSERT INTO `City` VALUES (474,'Wolverhampton','GBR','England',242000);
+INSERT INTO `City` VALUES (475,'Derby','GBR','England',236000);
+INSERT INTO `City` VALUES (476,'Swansea','GBR','Wales',230000);
+INSERT INTO `City` VALUES (477,'Southampton','GBR','England',216000);
+INSERT INTO `City` VALUES (478,'Aberdeen','GBR','Scotland',213070);
+INSERT INTO `City` VALUES (479,'Northampton','GBR','England',196000);
+INSERT INTO `City` VALUES (480,'Dudley','GBR','England',192171);
+INSERT INTO `City` VALUES (481,'Portsmouth','GBR','England',190000);
+INSERT INTO `City` VALUES (482,'Newcastle upon Tyne','GBR','England',189150);
+INSERT INTO `City` VALUES (483,'Sunderland','GBR','England',183310);
+INSERT INTO `City` VALUES (484,'Luton','GBR','England',183000);
+INSERT INTO `City` VALUES (485,'Swindon','GBR','England',180000);
+INSERT INTO `City` VALUES (486,'Southend-on-Sea','GBR','England',176000);
+INSERT INTO `City` VALUES (487,'Walsall','GBR','England',174739);
+INSERT INTO `City` VALUES (488,'Bournemouth','GBR','England',162000);
+INSERT INTO `City` VALUES (489,'Peterborough','GBR','England',156000);
+INSERT INTO `City` VALUES (490,'Brighton','GBR','England',156124);
+INSERT INTO `City` VALUES (491,'Blackpool','GBR','England',151000);
+INSERT INTO `City` VALUES (492,'Dundee','GBR','Scotland',146690);
+INSERT INTO `City` VALUES (493,'West Bromwich','GBR','England',146386);
+INSERT INTO `City` VALUES (494,'Reading','GBR','England',148000);
+INSERT INTO `City` VALUES (495,'Oldbury/Smethwick (Warley)','GBR','England',145542);
+INSERT INTO `City` VALUES (496,'Middlesbrough','GBR','England',145000);
+INSERT INTO `City` VALUES (497,'Huddersfield','GBR','England',143726);
+INSERT INTO `City` VALUES (498,'Oxford','GBR','England',144000);
+INSERT INTO `City` VALUES (499,'Poole','GBR','England',141000);
+INSERT INTO `City` VALUES (500,'Bolton','GBR','England',139020);
+INSERT INTO `City` VALUES (501,'Blackburn','GBR','England',140000);
+INSERT INTO `City` VALUES (502,'Newport','GBR','Wales',139000);
+INSERT INTO `City` VALUES (503,'Preston','GBR','England',135000);
+INSERT INTO `City` VALUES (504,'Stockport','GBR','England',132813);
+INSERT INTO `City` VALUES (505,'Norwich','GBR','England',124000);
+INSERT INTO `City` VALUES (506,'Rotherham','GBR','England',121380);
+INSERT INTO `City` VALUES (507,'Cambridge','GBR','England',121000);
+INSERT INTO `City` VALUES (508,'Watford','GBR','England',113080);
+INSERT INTO `City` VALUES (509,'Ipswich','GBR','England',114000);
+INSERT INTO `City` VALUES (510,'Slough','GBR','England',112000);
+INSERT INTO `City` VALUES (511,'Exeter','GBR','England',111000);
+INSERT INTO `City` VALUES (512,'Cheltenham','GBR','England',106000);
+INSERT INTO `City` VALUES (513,'Gloucester','GBR','England',107000);
+INSERT INTO `City` VALUES (514,'Saint Helens','GBR','England',106293);
+INSERT INTO `City` VALUES (515,'Sutton Coldfield','GBR','England',106001);
+INSERT INTO `City` VALUES (516,'York','GBR','England',104425);
+INSERT INTO `City` VALUES (517,'Oldham','GBR','England',103931);
+INSERT INTO `City` VALUES (518,'Basildon','GBR','England',100924);
+INSERT INTO `City` VALUES (519,'Worthing','GBR','England',100000);
+INSERT INTO `City` VALUES (520,'Chelmsford','GBR','England',97451);
+INSERT INTO `City` VALUES (521,'Colchester','GBR','England',96063);
+INSERT INTO `City` VALUES (522,'Crawley','GBR','England',97000);
+INSERT INTO `City` VALUES (523,'Gillingham','GBR','England',92000);
+INSERT INTO `City` VALUES (524,'Solihull','GBR','England',94531);
+INSERT INTO `City` VALUES (525,'Rochdale','GBR','England',94313);
+INSERT INTO `City` VALUES (526,'Birkenhead','GBR','England',93087);
+INSERT INTO `City` VALUES (527,'Worcester','GBR','England',95000);
+INSERT INTO `City` VALUES (528,'Hartlepool','GBR','England',92000);
+INSERT INTO `City` VALUES (529,'Halifax','GBR','England',91069);
+INSERT INTO `City` VALUES (530,'Woking/Byfleet','GBR','England',92000);
+INSERT INTO `City` VALUES (531,'Southport','GBR','England',90959);
+INSERT INTO `City` VALUES (532,'Maidstone','GBR','England',90878);
+INSERT INTO `City` VALUES (533,'Eastbourne','GBR','England',90000);
+INSERT INTO `City` VALUES (534,'Grimsby','GBR','England',89000);
+INSERT INTO `City` VALUES (535,'Saint Helier','GBR','Jersey',27523);
+INSERT INTO `City` VALUES (536,'Douglas','GBR','\x96',23487);
+INSERT INTO `City` VALUES (537,'Road Town','VGB','Tortola',8000);
+INSERT INTO `City` VALUES (538,'Bandar Seri Begawan','BRN','Brunei and Muara',21484);
+INSERT INTO `City` VALUES (539,'Sofija','BGR','Grad Sofija',1122302);
+INSERT INTO `City` VALUES (540,'Plovdiv','BGR','Plovdiv',342584);
+INSERT INTO `City` VALUES (541,'Varna','BGR','Varna',299801);
+INSERT INTO `City` VALUES (542,'Burgas','BGR','Burgas',195255);
+INSERT INTO `City` VALUES (543,'Ruse','BGR','Ruse',166467);
+INSERT INTO `City` VALUES (544,'Stara Zagora','BGR','Haskovo',147939);
+INSERT INTO `City` VALUES (545,'Pleven','BGR','Lovec',121952);
+INSERT INTO `City` VALUES (546,'Sliven','BGR','Burgas',105530);
+INSERT INTO `City` VALUES (547,'Dobric','BGR','Varna',100399);
+INSERT INTO `City` VALUES (548,'\x8Aumen','BGR','Varna',94686);
+INSERT INTO `City` VALUES (549,'Ouagadougou','BFA','Kadiogo',824000);
+INSERT INTO `City` VALUES (550,'Bobo-Dioulasso','BFA','Houet',300000);
+INSERT INTO `City` VALUES (551,'Koudougou','BFA','Boulkiemd\xE9',105000);
+INSERT INTO `City` VALUES (552,'Bujumbura','BDI','Bujumbura',300000);
+INSERT INTO `City` VALUES (553,'George Town','CYM','Grand Cayman',19600);
+INSERT INTO `City` VALUES (554,'Santiago de Chile','CHL','Santiago',4703954);
+INSERT INTO `City` VALUES (555,'Puente Alto','CHL','Santiago',386236);
+INSERT INTO `City` VALUES (556,'Vi\xF1a del Mar','CHL','Valpara\xEDso',312493);
+INSERT INTO `City` VALUES (557,'Valpara\xEDso','CHL','Valpara\xEDso',293800);
+INSERT INTO `City` VALUES (558,'Talcahuano','CHL','B\xEDob\xEDo',277752);
+INSERT INTO `City` VALUES (559,'Antofagasta','CHL','Antofagasta',251429);
+INSERT INTO `City` VALUES (560,'San Bernardo','CHL','Santiago',241910);
+INSERT INTO `City` VALUES (561,'Temuco','CHL','La Araucan\xEDa',233041);
+INSERT INTO `City` VALUES (562,'Concepci\xF3n','CHL','B\xEDob\xEDo',217664);
+INSERT INTO `City` VALUES (563,'Rancagua','CHL','O\xB4Higgins',212977);
+INSERT INTO `City` VALUES (564,'Arica','CHL','Tarapac\xE1',189036);
+INSERT INTO `City` VALUES (565,'Talca','CHL','Maule',187557);
+INSERT INTO `City` VALUES (566,'Chill\xE1n','CHL','B\xEDob\xEDo',178182);
+INSERT INTO `City` VALUES (567,'Iquique','CHL','Tarapac\xE1',177892);
+INSERT INTO `City` VALUES (568,'Los Angeles','CHL','B\xEDob\xEDo',158215);
+INSERT INTO `City` VALUES (569,'Puerto Montt','CHL','Los Lagos',152194);
+INSERT INTO `City` VALUES (570,'Coquimbo','CHL','Coquimbo',143353);
+INSERT INTO `City` VALUES (571,'Osorno','CHL','Los Lagos',141468);
+INSERT INTO `City` VALUES (572,'La Serena','CHL','Coquimbo',137409);
+INSERT INTO `City` VALUES (573,'Calama','CHL','Antofagasta',137265);
+INSERT INTO `City` VALUES (574,'Valdivia','CHL','Los Lagos',133106);
+INSERT INTO `City` VALUES (575,'Punta Arenas','CHL','Magallanes',125631);
+INSERT INTO `City` VALUES (576,'Copiap\xF3','CHL','Atacama',120128);
+INSERT INTO `City` VALUES (577,'Quilpu\xE9','CHL','Valpara\xEDso',118857);
+INSERT INTO `City` VALUES (578,'Curic\xF3','CHL','Maule',115766);
+INSERT INTO `City` VALUES (579,'Ovalle','CHL','Coquimbo',94854);
+INSERT INTO `City` VALUES (580,'Coronel','CHL','B\xEDob\xEDo',93061);
+INSERT INTO `City` VALUES (581,'San Pedro de la Paz','CHL','B\xEDob\xEDo',91684);
+INSERT INTO `City` VALUES (582,'Melipilla','CHL','Santiago',91056);
+INSERT INTO `City` VALUES (583,'Avarua','COK','Rarotonga',11900);
+INSERT INTO `City` VALUES (584,'San Jos\xE9','CRI','San Jos\xE9',339131);
+INSERT INTO `City` VALUES (585,'Djibouti','DJI','Djibouti',383000);
+INSERT INTO `City` VALUES (586,'Roseau','DMA','St George',16243);
+INSERT INTO `City` VALUES (587,'Santo Domingo de Guzm\xE1n','DOM','Distrito Nacional',1609966);
+INSERT INTO `City` VALUES (588,'Santiago de los Caballeros','DOM','Santiago',365463);
+INSERT INTO `City` VALUES (589,'La Romana','DOM','La Romana',140204);
+INSERT INTO `City` VALUES (590,'San Pedro de Macor\xEDs','DOM','San Pedro de Macor\xEDs',124735);
+INSERT INTO `City` VALUES (591,'San Francisco de Macor\xEDs','DOM','Duarte',108485);
+INSERT INTO `City` VALUES (592,'San Felipe de Puerto Plata','DOM','Puerto Plata',89423);
+INSERT INTO `City` VALUES (593,'Guayaquil','ECU','Guayas',2070040);
+INSERT INTO `City` VALUES (594,'Quito','ECU','Pichincha',1573458);
+INSERT INTO `City` VALUES (595,'Cuenca','ECU','Azuay',270353);
+INSERT INTO `City` VALUES (596,'Machala','ECU','El Oro',210368);
+INSERT INTO `City` VALUES (597,'Santo Domingo de los Colorados','ECU','Pichincha',202111);
+INSERT INTO `City` VALUES (598,'Portoviejo','ECU','Manab\xED',176413);
+INSERT INTO `City` VALUES (599,'Ambato','ECU','Tungurahua',169612);
+INSERT INTO `City` VALUES (600,'Manta','ECU','Manab\xED',164739);
+INSERT INTO `City` VALUES (601,'Duran [Eloy Alfaro]','ECU','Guayas',152514);
+INSERT INTO `City` VALUES (602,'Ibarra','ECU','Imbabura',130643);
+INSERT INTO `City` VALUES (603,'Quevedo','ECU','Los R\xEDos',129631);
+INSERT INTO `City` VALUES (604,'Milagro','ECU','Guayas',124177);
+INSERT INTO `City` VALUES (605,'Loja','ECU','Loja',123875);
+INSERT INTO `City` VALUES (606,'R\xEDobamba','ECU','Chimborazo',123163);
+INSERT INTO `City` VALUES (607,'Esmeraldas','ECU','Esmeraldas',123045);
+INSERT INTO `City` VALUES (608,'Cairo','EGY','Kairo',6789479);
+INSERT INTO `City` VALUES (609,'Alexandria','EGY','Aleksandria',3328196);
+INSERT INTO `City` VALUES (610,'Giza','EGY','Giza',2221868);
+INSERT INTO `City` VALUES (611,'Shubra al-Khayma','EGY','al-Qalyubiya',870716);
+INSERT INTO `City` VALUES (612,'Port Said','EGY','Port Said',469533);
+INSERT INTO `City` VALUES (613,'Suez','EGY','Suez',417610);
+INSERT INTO `City` VALUES (614,'al-Mahallat al-Kubra','EGY','al-Gharbiya',395402);
+INSERT INTO `City` VALUES (615,'Tanta','EGY','al-Gharbiya',371010);
+INSERT INTO `City` VALUES (616,'al-Mansura','EGY','al-Daqahliya',369621);
+INSERT INTO `City` VALUES (617,'Luxor','EGY','Luxor',360503);
+INSERT INTO `City` VALUES (618,'Asyut','EGY','Asyut',343498);
+INSERT INTO `City` VALUES (619,'Bahtim','EGY','al-Qalyubiya',275807);
+INSERT INTO `City` VALUES (620,'Zagazig','EGY','al-Sharqiya',267351);
+INSERT INTO `City` VALUES (621,'al-Faiyum','EGY','al-Faiyum',260964);
+INSERT INTO `City` VALUES (622,'Ismailia','EGY','Ismailia',254477);
+INSERT INTO `City` VALUES (623,'Kafr al-Dawwar','EGY','al-Buhayra',231978);
+INSERT INTO `City` VALUES (624,'Assuan','EGY','Assuan',219017);
+INSERT INTO `City` VALUES (625,'Damanhur','EGY','al-Buhayra',212203);
+INSERT INTO `City` VALUES (626,'al-Minya','EGY','al-Minya',201360);
+INSERT INTO `City` VALUES (627,'Bani Suwayf','EGY','Bani Suwayf',172032);
+INSERT INTO `City` VALUES (628,'Qina','EGY','Qina',171275);
+INSERT INTO `City` VALUES (629,'Sawhaj','EGY','Sawhaj',170125);
+INSERT INTO `City` VALUES (630,'Shibin al-Kawm','EGY','al-Minufiya',159909);
+INSERT INTO `City` VALUES (631,'Bulaq al-Dakrur','EGY','Giza',148787);
+INSERT INTO `City` VALUES (632,'Banha','EGY','al-Qalyubiya',145792);
+INSERT INTO `City` VALUES (633,'Warraq al-Arab','EGY','Giza',127108);
+INSERT INTO `City` VALUES (634,'Kafr al-Shaykh','EGY','Kafr al-Shaykh',124819);
+INSERT INTO `City` VALUES (635,'Mallawi','EGY','al-Minya',119283);
+INSERT INTO `City` VALUES (636,'Bilbays','EGY','al-Sharqiya',113608);
+INSERT INTO `City` VALUES (637,'Mit Ghamr','EGY','al-Daqahliya',101801);
+INSERT INTO `City` VALUES (638,'al-Arish','EGY','Shamal Sina',100447);
+INSERT INTO `City` VALUES (639,'Talkha','EGY','al-Daqahliya',97700);
+INSERT INTO `City` VALUES (640,'Qalyub','EGY','al-Qalyubiya',97200);
+INSERT INTO `City` VALUES (641,'Jirja','EGY','Sawhaj',95400);
+INSERT INTO `City` VALUES (642,'Idfu','EGY','Qina',94200);
+INSERT INTO `City` VALUES (643,'al-Hawamidiya','EGY','Giza',91700);
+INSERT INTO `City` VALUES (644,'Disuq','EGY','Kafr al-Shaykh',91300);
+INSERT INTO `City` VALUES (645,'San Salvador','SLV','San Salvador',415346);
+INSERT INTO `City` VALUES (646,'Santa Ana','SLV','Santa Ana',139389);
+INSERT INTO `City` VALUES (647,'Mejicanos','SLV','San Salvador',138800);
+INSERT INTO `City` VALUES (648,'Soyapango','SLV','San Salvador',129800);
+INSERT INTO `City` VALUES (649,'San Miguel','SLV','San Miguel',127696);
+INSERT INTO `City` VALUES (650,'Nueva San Salvador','SLV','La Libertad',98400);
+INSERT INTO `City` VALUES (651,'Apopa','SLV','San Salvador',88800);
+INSERT INTO `City` VALUES (652,'Asmara','ERI','Maekel',431000);
+INSERT INTO `City` VALUES (653,'Madrid','ESP','Madrid',2879052);
+INSERT INTO `City` VALUES (654,'Barcelona','ESP','Katalonia',1503451);
+INSERT INTO `City` VALUES (655,'Valencia','ESP','Valencia',739412);
+INSERT INTO `City` VALUES (656,'Sevilla','ESP','Andalusia',701927);
+INSERT INTO `City` VALUES (657,'Zaragoza','ESP','Aragonia',603367);
+INSERT INTO `City` VALUES (658,'M\xE1laga','ESP','Andalusia',530553);
+INSERT INTO `City` VALUES (659,'Bilbao','ESP','Baskimaa',357589);
+INSERT INTO `City` VALUES (660,'Las Palmas de Gran Canaria','ESP','Canary Islands',354757);
+INSERT INTO `City` VALUES (661,'Murcia','ESP','Murcia',353504);
+INSERT INTO `City` VALUES (662,'Palma de Mallorca','ESP','Balears',326993);
+INSERT INTO `City` VALUES (663,'Valladolid','ESP','Castilla and Le\xF3n',319998);
+INSERT INTO `City` VALUES (664,'C\xF3rdoba','ESP','Andalusia',311708);
+INSERT INTO `City` VALUES (665,'Vigo','ESP','Galicia',283670);
+INSERT INTO `City` VALUES (666,'Alicante [Alacant]','ESP','Valencia',272432);
+INSERT INTO `City` VALUES (667,'Gij\xF3n','ESP','Asturia',267980);
+INSERT INTO `City` VALUES (668,'L\xB4Hospitalet de Llobregat','ESP','Katalonia',247986);
+INSERT INTO `City` VALUES (669,'Granada','ESP','Andalusia',244767);
+INSERT INTO `City` VALUES (670,'A Coru\xF1a (La Coru\xF1a)','ESP','Galicia',243402);
+INSERT INTO `City` VALUES (671,'Vitoria-Gasteiz','ESP','Baskimaa',217154);
+INSERT INTO `City` VALUES (672,'Santa Cruz de Tenerife','ESP','Canary Islands',213050);
+INSERT INTO `City` VALUES (673,'Badalona','ESP','Katalonia',209635);
+INSERT INTO `City` VALUES (674,'Oviedo','ESP','Asturia',200453);
+INSERT INTO `City` VALUES (675,'M\xF3stoles','ESP','Madrid',195351);
+INSERT INTO `City` VALUES (676,'Elche [Elx]','ESP','Valencia',193174);
+INSERT INTO `City` VALUES (677,'Sabadell','ESP','Katalonia',184859);
+INSERT INTO `City` VALUES (678,'Santander','ESP','Cantabria',184165);
+INSERT INTO `City` VALUES (679,'Jerez de la Frontera','ESP','Andalusia',182660);
+INSERT INTO `City` VALUES (680,'Pamplona [Iru\xF1a]','ESP','Navarra',180483);
+INSERT INTO `City` VALUES (681,'Donostia-San Sebasti\xE1n','ESP','Baskimaa',179208);
+INSERT INTO `City` VALUES (682,'Cartagena','ESP','Murcia',177709);
+INSERT INTO `City` VALUES (683,'Legan\xE9s','ESP','Madrid',173163);
+INSERT INTO `City` VALUES (684,'Fuenlabrada','ESP','Madrid',171173);
+INSERT INTO `City` VALUES (685,'Almer\xEDa','ESP','Andalusia',169027);
+INSERT INTO `City` VALUES (686,'Terrassa','ESP','Katalonia',168695);
+INSERT INTO `City` VALUES (687,'Alcal\xE1 de Henares','ESP','Madrid',164463);
+INSERT INTO `City` VALUES (688,'Burgos','ESP','Castilla and Le\xF3n',162802);
+INSERT INTO `City` VALUES (689,'Salamanca','ESP','Castilla and Le\xF3n',158720);
+INSERT INTO `City` VALUES (690,'Albacete','ESP','Kastilia-La Mancha',147527);
+INSERT INTO `City` VALUES (691,'Getafe','ESP','Madrid',145371);
+INSERT INTO `City` VALUES (692,'C\xE1diz','ESP','Andalusia',142449);
+INSERT INTO `City` VALUES (693,'Alcorc\xF3n','ESP','Madrid',142048);
+INSERT INTO `City` VALUES (694,'Huelva','ESP','Andalusia',140583);
+INSERT INTO `City` VALUES (695,'Le\xF3n','ESP','Castilla and Le\xF3n',139809);
+INSERT INTO `City` VALUES (696,'Castell\xF3n de la Plana [Castell','ESP','Valencia',139712);
+INSERT INTO `City` VALUES (697,'Badajoz','ESP','Extremadura',136613);
+INSERT INTO `City` VALUES (698,'[San Crist\xF3bal de] la Laguna','ESP','Canary Islands',127945);
+INSERT INTO `City` VALUES (699,'Logro\xF1o','ESP','La Rioja',127093);
+INSERT INTO `City` VALUES (700,'Santa Coloma de Gramenet','ESP','Katalonia',120802);
+INSERT INTO `City` VALUES (701,'Tarragona','ESP','Katalonia',113016);
+INSERT INTO `City` VALUES (702,'Lleida (L\xE9rida)','ESP','Katalonia',112207);
+INSERT INTO `City` VALUES (703,'Ja\xE9n','ESP','Andalusia',109247);
+INSERT INTO `City` VALUES (704,'Ourense (Orense)','ESP','Galicia',109120);
+INSERT INTO `City` VALUES (705,'Matar\xF3','ESP','Katalonia',104095);
+INSERT INTO `City` VALUES (706,'Algeciras','ESP','Andalusia',103106);
+INSERT INTO `City` VALUES (707,'Marbella','ESP','Andalusia',101144);
+INSERT INTO `City` VALUES (708,'Barakaldo','ESP','Baskimaa',98212);
+INSERT INTO `City` VALUES (709,'Dos Hermanas','ESP','Andalusia',94591);
+INSERT INTO `City` VALUES (710,'Santiago de Compostela','ESP','Galicia',93745);
+INSERT INTO `City` VALUES (711,'Torrej\xF3n de Ardoz','ESP','Madrid',92262);
+INSERT INTO `City` VALUES (712,'Cape Town','ZAF','Western Cape',2352121);
+INSERT INTO `City` VALUES (713,'Soweto','ZAF','Gauteng',904165);
+INSERT INTO `City` VALUES (714,'Johannesburg','ZAF','Gauteng',756653);
+INSERT INTO `City` VALUES (715,'Port Elizabeth','ZAF','Eastern Cape',752319);
+INSERT INTO `City` VALUES (716,'Pretoria','ZAF','Gauteng',658630);
+INSERT INTO `City` VALUES (717,'Inanda','ZAF','KwaZulu-Natal',634065);
+INSERT INTO `City` VALUES (718,'Durban','ZAF','KwaZulu-Natal',566120);
+INSERT INTO `City` VALUES (719,'Vanderbijlpark','ZAF','Gauteng',468931);
+INSERT INTO `City` VALUES (720,'Kempton Park','ZAF','Gauteng',442633);
+INSERT INTO `City` VALUES (721,'Alberton','ZAF','Gauteng',410102);
+INSERT INTO `City` VALUES (722,'Pinetown','ZAF','KwaZulu-Natal',378810);
+INSERT INTO `City` VALUES (723,'Pietermaritzburg','ZAF','KwaZulu-Natal',370190);
+INSERT INTO `City` VALUES (724,'Benoni','ZAF','Gauteng',365467);
+INSERT INTO `City` VALUES (725,'Randburg','ZAF','Gauteng',341288);
+INSERT INTO `City` VALUES (726,'Umlazi','ZAF','KwaZulu-Natal',339233);
+INSERT INTO `City` VALUES (727,'Bloemfontein','ZAF','Free State',334341);
+INSERT INTO `City` VALUES (728,'Vereeniging','ZAF','Gauteng',328535);
+INSERT INTO `City` VALUES (729,'Wonderboom','ZAF','Gauteng',283289);
+INSERT INTO `City` VALUES (730,'Roodepoort','ZAF','Gauteng',279340);
+INSERT INTO `City` VALUES (731,'Boksburg','ZAF','Gauteng',262648);
+INSERT INTO `City` VALUES (732,'Klerksdorp','ZAF','North West',261911);
+INSERT INTO `City` VALUES (733,'Soshanguve','ZAF','Gauteng',242727);
+INSERT INTO `City` VALUES (734,'Newcastle','ZAF','KwaZulu-Natal',222993);
+INSERT INTO `City` VALUES (735,'East London','ZAF','Eastern Cape',221047);
+INSERT INTO `City` VALUES (736,'Welkom','ZAF','Free State',203296);
+INSERT INTO `City` VALUES (737,'Kimberley','ZAF','Northern Cape',197254);
+INSERT INTO `City` VALUES (738,'Uitenhage','ZAF','Eastern Cape',192120);
+INSERT INTO `City` VALUES (739,'Chatsworth','ZAF','KwaZulu-Natal',189885);
+INSERT INTO `City` VALUES (740,'Mdantsane','ZAF','Eastern Cape',182639);
+INSERT INTO `City` VALUES (741,'Krugersdorp','ZAF','Gauteng',181503);
+INSERT INTO `City` VALUES (742,'Botshabelo','ZAF','Free State',177971);
+INSERT INTO `City` VALUES (743,'Brakpan','ZAF','Gauteng',171363);
+INSERT INTO `City` VALUES (744,'Witbank','ZAF','Mpumalanga',167183);
+INSERT INTO `City` VALUES (745,'Oberholzer','ZAF','Gauteng',164367);
+INSERT INTO `City` VALUES (746,'Germiston','ZAF','Gauteng',164252);
+INSERT INTO `City` VALUES (747,'Springs','ZAF','Gauteng',162072);
+INSERT INTO `City` VALUES (748,'Westonaria','ZAF','Gauteng',159632);
+INSERT INTO `City` VALUES (749,'Randfontein','ZAF','Gauteng',120838);
+INSERT INTO `City` VALUES (750,'Paarl','ZAF','Western Cape',105768);
+INSERT INTO `City` VALUES (751,'Potchefstroom','ZAF','North West',101817);
+INSERT INTO `City` VALUES (752,'Rustenburg','ZAF','North West',97008);
+INSERT INTO `City` VALUES (753,'Nigel','ZAF','Gauteng',96734);
+INSERT INTO `City` VALUES (754,'George','ZAF','Western Cape',93818);
+INSERT INTO `City` VALUES (755,'Ladysmith','ZAF','KwaZulu-Natal',89292);
+INSERT INTO `City` VALUES (756,'Addis Abeba','ETH','Addis Abeba',2495000);
+INSERT INTO `City` VALUES (757,'Dire Dawa','ETH','Dire Dawa',164851);
+INSERT INTO `City` VALUES (758,'Nazret','ETH','Oromia',127842);
+INSERT INTO `City` VALUES (759,'Gonder','ETH','Amhara',112249);
+INSERT INTO `City` VALUES (760,'Dese','ETH','Amhara',97314);
+INSERT INTO `City` VALUES (761,'Mekele','ETH','Tigray',96938);
+INSERT INTO `City` VALUES (762,'Bahir Dar','ETH','Amhara',96140);
+INSERT INTO `City` VALUES (763,'Stanley','FLK','East Falkland',1636);
+INSERT INTO `City` VALUES (764,'Suva','FJI','Central',77366);
+INSERT INTO `City` VALUES (765,'Quezon','PHL','National Capital Reg',2173831);
+INSERT INTO `City` VALUES (766,'Manila','PHL','National Capital Reg',1581082);
+INSERT INTO `City` VALUES (767,'Kalookan','PHL','National Capital Reg',1177604);
+INSERT INTO `City` VALUES (768,'Davao','PHL','Southern Mindanao',1147116);
+INSERT INTO `City` VALUES (769,'Cebu','PHL','Central Visayas',718821);
+INSERT INTO `City` VALUES (770,'Zamboanga','PHL','Western Mindanao',601794);
+INSERT INTO `City` VALUES (771,'Pasig','PHL','National Capital Reg',505058);
+INSERT INTO `City` VALUES (772,'Valenzuela','PHL','National Capital Reg',485433);
+INSERT INTO `City` VALUES (773,'Las Pi\xF1as','PHL','National Capital Reg',472780);
+INSERT INTO `City` VALUES (774,'Antipolo','PHL','Southern Tagalog',470866);
+INSERT INTO `City` VALUES (775,'Taguig','PHL','National Capital Reg',467375);
+INSERT INTO `City` VALUES (776,'Cagayan de Oro','PHL','Northern Mindanao',461877);
+INSERT INTO `City` VALUES (777,'Para\xF1aque','PHL','National Capital Reg',449811);
+INSERT INTO `City` VALUES (778,'Makati','PHL','National Capital Reg',444867);
+INSERT INTO `City` VALUES (779,'Bacolod','PHL','Western Visayas',429076);
+INSERT INTO `City` VALUES (780,'General Santos','PHL','Southern Mindanao',411822);
+INSERT INTO `City` VALUES (781,'Marikina','PHL','National Capital Reg',391170);
+INSERT INTO `City` VALUES (782,'Dasmari\xF1as','PHL','Southern Tagalog',379520);
+INSERT INTO `City` VALUES (783,'Muntinlupa','PHL','National Capital Reg',379310);
+INSERT INTO `City` VALUES (784,'Iloilo','PHL','Western Visayas',365820);
+INSERT INTO `City` VALUES (785,'Pasay','PHL','National Capital Reg',354908);
+INSERT INTO `City` VALUES (786,'Malabon','PHL','National Capital Reg',338855);
+INSERT INTO `City` VALUES (787,'San Jos\xE9 del Monte','PHL','Central Luzon',315807);
+INSERT INTO `City` VALUES (788,'Bacoor','PHL','Southern Tagalog',305699);
+INSERT INTO `City` VALUES (789,'Iligan','PHL','Central Mindanao',285061);
+INSERT INTO `City` VALUES (790,'Calamba','PHL','Southern Tagalog',281146);
+INSERT INTO `City` VALUES (791,'Mandaluyong','PHL','National Capital Reg',278474);
+INSERT INTO `City` VALUES (792,'Butuan','PHL','Caraga',267279);
+INSERT INTO `City` VALUES (793,'Angeles','PHL','Central Luzon',263971);
+INSERT INTO `City` VALUES (794,'Tarlac','PHL','Central Luzon',262481);
+INSERT INTO `City` VALUES (795,'Mandaue','PHL','Central Visayas',259728);
+INSERT INTO `City` VALUES (796,'Baguio','PHL','CAR',252386);
+INSERT INTO `City` VALUES (797,'Batangas','PHL','Southern Tagalog',247588);
+INSERT INTO `City` VALUES (798,'Cainta','PHL','Southern Tagalog',242511);
+INSERT INTO `City` VALUES (799,'San Pedro','PHL','Southern Tagalog',231403);
+INSERT INTO `City` VALUES (800,'Navotas','PHL','National Capital Reg',230403);
+INSERT INTO `City` VALUES (801,'Cabanatuan','PHL','Central Luzon',222859);
+INSERT INTO `City` VALUES (802,'San Fernando','PHL','Central Luzon',221857);
+INSERT INTO `City` VALUES (803,'Lipa','PHL','Southern Tagalog',218447);
+INSERT INTO `City` VALUES (804,'Lapu-Lapu','PHL','Central Visayas',217019);
+INSERT INTO `City` VALUES (805,'San Pablo','PHL','Southern Tagalog',207927);
+INSERT INTO `City` VALUES (806,'Bi\xF1an','PHL','Southern Tagalog',201186);
+INSERT INTO `City` VALUES (807,'Taytay','PHL','Southern Tagalog',198183);
+INSERT INTO `City` V...
 
[truncated message content]