-- Modified verion of MySQL world database script -- Creates both world and world2 (same as world except tables empty) -- Also create a user - dbuser and grant all access to dbuser for both world and world2 -- It is assumed you have the appropriated privleges to run this script; -- Open a command window and run from the system prompt -- >mysql -vvv -h localhost -u root -p < "MySQL world and world2.sql" Drop database if exists world; revoke all privileges, grant option from 'dbuser'@'localhost'; drop user 'dbuser'@'localhost'; Create database world; use world; CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'dbuser'; Grant all on world.* to 'dbuser'@'localhost'; -- 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,'´s-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çao',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étif','DZA','Sétif',179055); INSERT INTO `City` VALUES (41,'Sidi Bel Abbès','DZA','Sidi Bel Abbès',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éjaïa','DZA','Béjaïa',117162); INSERT INTO `City` VALUES (46,'Mostaganem','DZA','Mostaganem',115212); INSERT INTO `City` VALUES (47,'Tébessa','DZA','Tébessa',112007); INSERT INTO `City` VALUES (48,'Tlemcen (Tilimsen)','DZA','Tlemcen',110242); INSERT INTO `City` VALUES (49,'Béchar','DZA','Béchar',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ïa','DZA','Ghardaïa',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','–',961); INSERT INTO `City` VALUES (62,'The Valley','AIA','–',595); INSERT INTO `City` VALUES (63,'Saint John´s','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órdoba','ARG','Córdoba',1157507); INSERT INTO `City` VALUES (72,'Rosario','ARG','Santa Fé',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án','ARG','Tucumán',470809); INSERT INTO `City` VALUES (79,'Lanús','ARG','Buenos Aires',469735); INSERT INTO `City` VALUES (80,'Merlo','ARG','Buenos Aires',463846); INSERT INTO `City` VALUES (81,'General San Martín','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é','ARG','Santa Fé',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ón','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ópez','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ía Blanca','ARG','Buenos Aires',239810); INSERT INTO `City` VALUES (97,'Esteban Echeverría','ARG','Buenos Aires',235760); INSERT INTO `City` VALUES (98,'Resistencia','ARG','Chaco',229212); INSERT INTO `City` VALUES (99,'José C. Paz','ARG','Buenos Aires',221754); INSERT INTO `City` VALUES (100,'Paraná','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én','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én','ARG','Neuquén',167296); INSERT INTO `City` VALUES (108,'Ituzaingó','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ío Cuarto','ARG','Córdoba',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ás 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','Širak',211700); INSERT INTO `City` VALUES (128,'Vanadzor','ARM','Lori',172700); INSERT INTO `City` VALUES (129,'Oranjestad','ABW','–',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äncä','AZE','Gäncä',299300); INSERT INTO `City` VALUES (146,'Sumqayit','AZE','Sumqayit',283000); INSERT INTO `City` VALUES (147,'Mingäçevir','AZE','Mingäçevir',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ège','BEL','Liège',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émé',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´s',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í','BOL','Potosí',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ão Paulo','BRA','São 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á',2097757); INSERT INTO `City` VALUES (211,'Brasília','BRA','Distrito Federal',1969868); INSERT INTO `City` VALUES (212,'Curitiba','BRA','Paraná',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ém','BRA','Pará',1186926); INSERT INTO `City` VALUES (217,'Guarulhos','BRA','São Paulo',1095874); INSERT INTO `City` VALUES (218,'Goiânia','BRA','Goiás',1056330); INSERT INTO `City` VALUES (219,'Campinas','BRA','São Paulo',950043); INSERT INTO `City` VALUES (220,'São Gonçalo','BRA','Rio de Janeiro',869254); INSERT INTO `City` VALUES (221,'Nova Iguaçu','BRA','Rio de Janeiro',862225); INSERT INTO `City` VALUES (222,'São Luís','BRA','Maranhão',837588); INSERT INTO `City` VALUES (223,'Maceió','BRA','Alagoas',786288); INSERT INTO `City` VALUES (224,'Duque de Caxias','BRA','Rio de Janeiro',746758); INSERT INTO `City` VALUES (225,'São Bernardo do Campo','BRA','São Paulo',723132); INSERT INTO `City` VALUES (226,'Teresina','BRA','Piauí',691942); INSERT INTO `City` VALUES (227,'Natal','BRA','Rio Grande do Norte',688955); INSERT INTO `City` VALUES (228,'Osasco','BRA','São Paulo',659604); INSERT INTO `City` VALUES (229,'Campo Grande','BRA','Mato Grosso do Sul',649593); INSERT INTO `City` VALUES (230,'Santo André','BRA','São Paulo',630073); INSERT INTO `City` VALUES (231,'João Pessoa','BRA','Paraíba',584029); INSERT INTO `City` VALUES (232,'Jaboatão dos Guararapes','BRA','Pernambuco',558680); INSERT INTO `City` VALUES (233,'Contagem','BRA','Minas Gerais',520801); INSERT INTO `City` VALUES (234,'São José dos Campos','BRA','São Paulo',515553); INSERT INTO `City` VALUES (235,'Uberlândia','BRA','Minas Gerais',487222); INSERT INTO `City` VALUES (236,'Feira de Santana','BRA','Bahia',479992); INSERT INTO `City` VALUES (237,'Ribeirão Preto','BRA','São Paulo',473276); INSERT INTO `City` VALUES (238,'Sorocaba','BRA','São Paulo',466823); INSERT INTO `City` VALUES (239,'Niterói','BRA','Rio de Janeiro',459884); INSERT INTO `City` VALUES (240,'Cuiabá','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ão João de Meriti','BRA','Rio de Janeiro',440052); INSERT INTO `City` VALUES (244,'Londrina','BRA','Paraná',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ão Paulo',408748); INSERT INTO `City` VALUES (248,'Ananindeua','BRA','Pará',400940); INSERT INTO `City` VALUES (249,'Campos dos Goytacazes','BRA','Rio de Janeiro',398418); INSERT INTO `City` VALUES (250,'Mauá','BRA','São Paulo',375055); INSERT INTO `City` VALUES (251,'Carapicuíba','BRA','São Paulo',357552); INSERT INTO `City` VALUES (252,'Olinda','BRA','Pernambuco',354732); INSERT INTO `City` VALUES (253,'Campina Grande','BRA','Paraíba',352497); INSERT INTO `City` VALUES (254,'São José do Rio Preto','BRA','São 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ão Paulo',339194); INSERT INTO `City` VALUES (257,'Diadema','BRA','São Paulo',335078); INSERT INTO `City` VALUES (258,'Aparecida de Goiânia','BRA','Goiás',324662); INSERT INTO `City` VALUES (259,'Piracicaba','BRA','São Paulo',319104); INSERT INTO `City` VALUES (260,'Cariacica','BRA','Espírito Santo',319033); INSERT INTO `City` VALUES (261,'Vila Velha','BRA','Espírito Santo',318758); INSERT INTO `City` VALUES (262,'Pelotas','BRA','Rio Grande do Sul',315415); INSERT INTO `City` VALUES (263,'Bauru','BRA','São Paulo',313670); INSERT INTO `City` VALUES (264,'Porto Velho','BRA','Rondônia',309750); INSERT INTO `City` VALUES (265,'Serra','BRA','Espírito Santo',302666); INSERT INTO `City` VALUES (266,'Betim','BRA','Minas Gerais',302108); INSERT INTO `City` VALUES (267,'Jundíaí','BRA','São Paulo',296127); INSERT INTO `City` VALUES (268,'Canoas','BRA','Rio Grande do Sul',294125); INSERT INTO `City` VALUES (269,'Franca','BRA','São Paulo',290139); INSERT INTO `City` VALUES (270,'São Vicente','BRA','São Paulo',286848); INSERT INTO `City` VALUES (271,'Maringá','BRA','Paraná',286461); INSERT INTO `City` VALUES (272,'Montes Claros','BRA','Minas Gerais',286058); INSERT INTO `City` VALUES (273,'Anápolis','BRA','Goiás',282197); INSERT INTO `City` VALUES (274,'Florianópolis','BRA','Santa Catarina',281928); INSERT INTO `City` VALUES (275,'Petrópolis','BRA','Rio de Janeiro',279183); INSERT INTO `City` VALUES (276,'Itaquaquecetuba','BRA','São Paulo',270874); INSERT INTO `City` VALUES (277,'Vitória','BRA','Espírito Santo',270626); INSERT INTO `City` VALUES (278,'Ponta Grossa','BRA','Paraná',268013); INSERT INTO `City` VALUES (279,'Rio Branco','BRA','Acre',259537); INSERT INTO `City` VALUES (280,'Foz do Iguaçu','BRA','Paraná',259425); INSERT INTO `City` VALUES (281,'Macapá','BRA','Amapá',256033); INSERT INTO `City` VALUES (282,'Ilhéus','BRA','Bahia',254970); INSERT INTO `City` VALUES (283,'Vitória 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ão 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ém','BRA','Pará',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á',238738); INSERT INTO `City` VALUES (293,'Santa Maria','BRA','Rio Grande do Sul',238473); INSERT INTO `City` VALUES (294,'Cascavel','BRA','Paraná',237510); INSERT INTO `City` VALUES (295,'Guarujá','BRA','São Paulo',237206); INSERT INTO `City` VALUES (296,'Ribeirão das Neves','BRA','Minas Gerais',232685); INSERT INTO `City` VALUES (297,'Governador Valadares','BRA','Minas Gerais',231724); INSERT INTO `City` VALUES (298,'Taubaté','BRA','São Paulo',229130); INSERT INTO `City` VALUES (299,'Imperatriz','BRA','Maranhão',224564); INSERT INTO `City` VALUES (300,'Gravataí','BRA','Rio Grande do Sul',223011); INSERT INTO `City` VALUES (301,'Embu','BRA','São Paulo',222223); INSERT INTO `City` VALUES (302,'Mossoró','BRA','Rio Grande do Norte',214901); INSERT INTO `City` VALUES (303,'Várzea Grande','BRA','Mato Grosso',214435); INSERT INTO `City` VALUES (304,'Petrolina','BRA','Pernambuco',210540); INSERT INTO `City` VALUES (305,'Barueri','BRA','São Paulo',208426); INSERT INTO `City` VALUES (306,'Viamão','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á',199636); INSERT INTO `City` VALUES (310,'Taboão da Serra','BRA','São Paulo',197550); INSERT INTO `City` VALUES (311,'São José dos Pinhais','BRA','Paraná',196884); INSERT INTO `City` VALUES (312,'Magé','BRA','Rio de Janeiro',196147); INSERT INTO `City` VALUES (313,'Suzano','BRA','São Paulo',195434); INSERT INTO `City` VALUES (314,'São Leopoldo','BRA','Rio Grande do Sul',189258); INSERT INTO `City` VALUES (315,'Marília','BRA','São Paulo',188691); INSERT INTO `City` VALUES (316,'São Carlos','BRA','São Paulo',187122); INSERT INTO `City` VALUES (317,'Sumaré','BRA','São Paulo',186205); INSERT INTO `City` VALUES (318,'Presidente Prudente','BRA','São Paulo',185340); INSERT INTO `City` VALUES (319,'Divinópolis','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é','BRA','Bahia',179128); INSERT INTO `City` VALUES (324,'Arapiraca','BRA','Alagoas',178988); INSERT INTO `City` VALUES (325,'Colombo','BRA','Paraná',177764); INSERT INTO `City` VALUES (326,'Americana','BRA','São Paulo',177409); INSERT INTO `City` VALUES (327,'Alvorada','BRA','Rio Grande do Sul',175574); INSERT INTO `City` VALUES (328,'Araraquara','BRA','São Paulo',174381); INSERT INTO `City` VALUES (329,'Itaboraí','BRA','Rio de Janeiro',173977); INSERT INTO `City` VALUES (330,'Santa Bárbara d´Oeste','BRA','São Paulo',171657); INSERT INTO `City` VALUES (331,'Nova Friburgo','BRA','Rio de Janeiro',170697); INSERT INTO `City` VALUES (332,'Jacareí','BRA','São Paulo',170356); INSERT INTO `City` VALUES (333,'Araçatuba','BRA','São Paulo',169303); INSERT INTO `City` VALUES (334,'Barra Mansa','BRA','Rio de Janeiro',168953); INSERT INTO `City` VALUES (335,'Praia Grande','BRA','São Paulo',168434); INSERT INTO `City` VALUES (336,'Marabá','BRA','Pará',167795); INSERT INTO `City` VALUES (337,'Criciúma','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ão Paulo',163551); INSERT INTO `City` VALUES (343,'Maracanaú','BRA','Ceará',162022); INSERT INTO `City` VALUES (344,'Guarapuava','BRA','Paraná',160510); INSERT INTO `City` VALUES (345,'Rondonópolis','BRA','Mato Grosso',155115); INSERT INTO `City` VALUES (346,'São José','BRA','Santa Catarina',155105); INSERT INTO `City` VALUES (347,'Cachoeiro de Itapemirim','BRA','Espírito Santo',155024); INSERT INTO `City` VALUES (348,'Nilópolis','BRA','Rio de Janeiro',153383); INSERT INTO `City` VALUES (349,'Itapevi','BRA','São Paulo',150664); INSERT INTO `City` VALUES (350,'Cabo de Santo Agostinho','BRA','Pernambuco',149964); INSERT INTO `City` VALUES (351,'Camaçari','BRA','Bahia',149146); INSERT INTO `City` VALUES (352,'Sobral','BRA','Ceará',146005); INSERT INTO `City` VALUES (353,'Itajaí','BRA','Santa Catarina',145197); INSERT INTO `City` VALUES (354,'Chapecó','BRA','Santa Catarina',144158); INSERT INTO `City` VALUES (355,'Cotia','BRA','São Paulo',140042); INSERT INTO `City` VALUES (356,'Lages','BRA','Santa Catarina',139570); INSERT INTO `City` VALUES (357,'Ferraz de Vasconcelos','BRA','São Paulo',139283); INSERT INTO `City` VALUES (358,'Indaiatuba','BRA','São Paulo',135968); INSERT INTO `City` VALUES (359,'Hortolândia','BRA','São Paulo',135755); INSERT INTO `City` VALUES (360,'Caxias','BRA','Maranhão',133980); INSERT INTO `City` VALUES (361,'São Caetano do Sul','BRA','São Paulo',133321); INSERT INTO `City` VALUES (362,'Itu','BRA','São Paulo',132736); INSERT INTO `City` VALUES (363,'Nossa Senhora do Socorro','BRA','Sergipe',131351); INSERT INTO `City` VALUES (364,'Parnaíba','BRA','Piauí',129756); INSERT INTO `City` VALUES (365,'Poços de Caldas','BRA','Minas Gerais',129683); INSERT INTO `City` VALUES (366,'Teresópolis','BRA','Rio de Janeiro',128079); INSERT INTO `City` VALUES (367,'Barreiras','BRA','Bahia',127801); INSERT INTO `City` VALUES (368,'Castanhal','BRA','Pará',127634); INSERT INTO `City` VALUES (369,'Alagoinhas','BRA','Bahia',126820); INSERT INTO `City` VALUES (370,'Itapecerica da Serra','BRA','São Paulo',126672); INSERT INTO `City` VALUES (371,'Uruguaiana','BRA','Rio Grande do Sul',126305); INSERT INTO `City` VALUES (372,'Paranaguá','BRA','Paraná',126076); INSERT INTO `City` VALUES (373,'Ibirité','BRA','Minas Gerais',125982); INSERT INTO `City` VALUES (374,'Timon','BRA','Maranhão',125812); INSERT INTO `City` VALUES (375,'Luziânia','BRA','Goiás',125597); INSERT INTO `City` VALUES (376,'Macaé','BRA','Rio de Janeiro',125597); INSERT INTO `City` VALUES (377,'Teófilo Otoni','BRA','Minas Gerais',124489); INSERT INTO `City` VALUES (378,'Moji-Guaçu','BRA','São Paulo',123782); INSERT INTO `City` VALUES (379,'Palmas','BRA','Tocantins',121919); INSERT INTO `City` VALUES (380,'Pindamonhangaba','BRA','São Paulo',121904); INSERT INTO `City` VALUES (381,'Francisco Morato','BRA','São Paulo',121197); INSERT INTO `City` VALUES (382,'Bagé','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ão 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ça Paulista','BRA','São Paulo',116929); INSERT INTO `City` VALUES (389,'Queimados','BRA','Rio de Janeiro',115020); INSERT INTO `City` VALUES (390,'Araguaína','BRA','Tocantins',114948); INSERT INTO `City` VALUES (391,'Garanhuns','BRA','Pernambuco',114603); INSERT INTO `City` VALUES (392,'Vitória de Santo Antão','BRA','Pernambuco',113595); INSERT INTO `City` VALUES (393,'Santa Rita','BRA','Paraíba',113135); INSERT INTO `City` VALUES (394,'Barbacena','BRA','Minas Gerais',113079); INSERT INTO `City` VALUES (395,'Abaetetuba','BRA','Pará',111258); INSERT INTO `City` VALUES (396,'Jaú','BRA','São Paulo',109965); INSERT INTO `City` VALUES (397,'Lauro de Freitas','BRA','Bahia',109236); INSERT INTO `City` VALUES (398,'Franco da Rocha','BRA','São 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ão Pires','BRA','São Paulo',108121); INSERT INTO `City` VALUES (402,'Sabará','BRA','Minas Gerais',107781); INSERT INTO `City` VALUES (403,'Catanduva','BRA','São Paulo',107761); INSERT INTO `City` VALUES (404,'Rio Verde','BRA','Goiás',107755); INSERT INTO `City` VALUES (405,'Botucatu','BRA','São Paulo',107663); INSERT INTO `City` VALUES (406,'Colatina','BRA','Espírito 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írito Santo',106278); INSERT INTO `City` VALUES (409,'Apucarana','BRA','Paraná',105114); INSERT INTO `City` VALUES (410,'Barretos','BRA','São Paulo',104156); INSERT INTO `City` VALUES (411,'Guaratinguetá','BRA','São Paulo',103433); INSERT INTO `City` VALUES (412,'Cachoeirinha','BRA','Rio Grande do Sul',103240); INSERT INTO `City` VALUES (413,'Codó','BRA','Maranhão',103153); INSERT INTO `City` VALUES (414,'Jaraguá do Sul','BRA','Santa Catarina',102580); INSERT INTO `City` VALUES (415,'Cubatão','BRA','São Paulo',102372); INSERT INTO `City` VALUES (416,'Itabira','BRA','Minas Gerais',102217); INSERT INTO `City` VALUES (417,'Itaituba','BRA','Pará',101320); INSERT INTO `City` VALUES (418,'Araras','BRA','São Paulo',101046); INSERT INTO `City` VALUES (419,'Resende','BRA','Rio de Janeiro',100627); INSERT INTO `City` VALUES (420,'Atibaia','BRA','São Paulo',100356); INSERT INTO `City` VALUES (421,'Pouso Alegre','BRA','Minas Gerais',100028); INSERT INTO `City` VALUES (422,'Toledo','BRA','Paraná',99387); INSERT INTO `City` VALUES (423,'Crato','BRA','Ceará',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ão José de Ribamar','BRA','Maranhão',98318); INSERT INTO `City` VALUES (427,'Pinhais','BRA','Paraná',98198); INSERT INTO `City` VALUES (428,'Sertãozinho','BRA','São 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ápolis','BRA','Bahia',96610); INSERT INTO `City` VALUES (433,'Salto','BRA','São Paulo',96348); INSERT INTO `City` VALUES (434,'Ourinhos','BRA','São 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ão Paulo',94685); INSERT INTO `City` VALUES (439,'Tatuí','BRA','São Paulo',93897); INSERT INTO `City` VALUES (440,'Ji-Paraná','BRA','Rondônia',93346); INSERT INTO `City` VALUES (441,'Bacabal','BRA','Maranhão',93121); INSERT INTO `City` VALUES (442,'Cametá','BRA','Pará',92779); INSERT INTO `City` VALUES (443,'Guaíba','BRA','Rio Grande do Sul',92224); INSERT INTO `City` VALUES (444,'São Lourenço 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ão Paulo',91777); INSERT INTO `City` VALUES (447,'Campo Largo','BRA','Paraná',91203); INSERT INTO `City` VALUES (448,'Patos','BRA','Paraíba',90519); INSERT INTO `City` VALUES (449,'Ituiutaba','BRA','Minas Gerais',90507); INSERT INTO `City` VALUES (450,'Corumbá','BRA','Mato Grosso do Sul',90111); INSERT INTO `City` VALUES (451,'Palhoça','BRA','Santa Catarina',89465); INSERT INTO `City` VALUES (452,'Barra do Piraí','BRA','Rio de Janeiro',89388); INSERT INTO `City` VALUES (453,'Bento Gonçalves','BRA','Rio Grande do Sul',89254); INSERT INTO `City` VALUES (454,'Poá','BRA','São Paulo',89236); INSERT INTO `City` VALUES (455,'Águas Lindas de Goiás','BRA','Goiás',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','–',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,'Šumen','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é',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ña del Mar','CHL','Valparaíso',312493); INSERT INTO `City` VALUES (557,'Valparaíso','CHL','Valparaíso',293800); INSERT INTO `City` VALUES (558,'Talcahuano','CHL','Bíobío',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ía',233041); INSERT INTO `City` VALUES (562,'Concepción','CHL','Bíobío',217664); INSERT INTO `City` VALUES (563,'Rancagua','CHL','O´Higgins',212977); INSERT INTO `City` VALUES (564,'Arica','CHL','Tarapacá',189036); INSERT INTO `City` VALUES (565,'Talca','CHL','Maule',187557); INSERT INTO `City` VALUES (566,'Chillán','CHL','Bíobío',178182); INSERT INTO `City` VALUES (567,'Iquique','CHL','Tarapacá',177892); INSERT INTO `City` VALUES (568,'Los Angeles','CHL','Bíobío',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ó','CHL','Atacama',120128); INSERT INTO `City` VALUES (577,'Quilpué','CHL','Valparaíso',118857); INSERT INTO `City` VALUES (578,'Curicó','CHL','Maule',115766); INSERT INTO `City` VALUES (579,'Ovalle','CHL','Coquimbo',94854); INSERT INTO `City` VALUES (580,'Coronel','CHL','Bíobío',93061); INSERT INTO `City` VALUES (581,'San Pedro de la Paz','CHL','Bíobío',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é','CRI','San José',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án','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ís','DOM','San Pedro de Macorís',124735); INSERT INTO `City` VALUES (591,'San Francisco de Macorís','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í',176413); INSERT INTO `City` VALUES (599,'Ambato','ECU','Tungurahua',169612); INSERT INTO `City` VALUES (600,'Manta','ECU','Manabí',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íos',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íobamba','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álaga','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ón',319998); INSERT INTO `City` VALUES (664,'Córdoba','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ón','ESP','Asturia',267980); INSERT INTO `City` VALUES (668,'L´Hospitalet de Llobregat','ESP','Katalonia',247986); INSERT INTO `City` VALUES (669,'Granada','ESP','Andalusia',244767); INSERT INTO `City` VALUES (670,'A Coruña (La Coruña)','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óstoles','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ña]','ESP','Navarra',180483); INSERT INTO `City` VALUES (681,'Donostia-San Sebastián','ESP','Baskimaa',179208); INSERT INTO `City` VALUES (682,'Cartagena','ESP','Murcia',177709); INSERT INTO `City` VALUES (683,'Leganés','ESP','Madrid',173163); INSERT INTO `City` VALUES (684,'Fuenlabrada','ESP','Madrid',171173); INSERT INTO `City` VALUES (685,'Almería','ESP','Andalusia',169027); INSERT INTO `City` VALUES (686,'Terrassa','ESP','Katalonia',168695); INSERT INTO `City` VALUES (687,'Alcalá de Henares','ESP','Madrid',164463); INSERT INTO `City` VALUES (688,'Burgos','ESP','Castilla and León',162802); INSERT INTO `City` VALUES (689,'Salamanca','ESP','Castilla and León',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ádiz','ESP','Andalusia',142449); INSERT INTO `City` VALUES (693,'Alcorcón','ESP','Madrid',142048); INSERT INTO `City` VALUES (694,'Huelva','ESP','Andalusia',140583); INSERT INTO `City` VALUES (695,'León','ESP','Castilla and León',139809); INSERT INTO `City` VALUES (696,'Castellón de la Plana [Castell','ESP','Valencia',139712); INSERT INTO `City` VALUES (697,'Badajoz','ESP','Extremadura',136613); INSERT INTO `City` VALUES (698,'[San Cristóbal de] la Laguna','ESP','Canary Islands',127945); INSERT INTO `City` VALUES (699,'Logroño','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érida)','ESP','Katalonia',112207); INSERT INTO `City` VALUES (703,'Jaén','ESP','Andalusia',109247); INSERT INTO `City` VALUES (704,'Ourense (Orense)','ESP','Galicia',109120); INSERT INTO `City` VALUES (705,'Mataró','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ón 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ñas','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ñaque','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ñas','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é 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ñan','PHL','Southern Tagalog',201186); INSERT INTO `City` VALUES (807,'Taytay','PHL','Southern Tagalog',198183); INSERT INTO `City` VALUES (808,'Lucena','PHL','Southern Tagalog',196075); INSERT INTO `City` VALUES (809,'Imus','PHL','Southern Tagalog',195482); INSERT INTO `City` VALUES (810,'Olongapo','PHL','Central Luzon',194260); INSERT INTO `City` VALUES (811,'Binangonan','PHL','Southern Tagalog',187691); INSERT INTO `City` VALUES (812,'Santa Rosa','PHL','Southern Tagalog',185633); INSERT INTO `City` VALUES (813,'Tagum','PHL','Southern Mindanao',179531); INSERT INTO `City` VALUES (814,'Tacloban','PHL','Eastern Visayas',178639); INSERT INTO `City` VALUES (815,'Malolos','PHL','Central Luzon',175291); INSERT INTO `City` VALUES (816,'Mabalacat','PHL','Central Luzon',171045); INSERT INTO `City` VALUES (817,'Cotabato','PHL','Central Mindanao',163849); INSERT INTO `City` VALUES (818,'Meycauayan','PHL','Central Luzon',163037); INSERT INTO `City` VALUES (819,'Puerto Princesa','PHL','Southern Tagalog',161912); INSERT INTO `City` VALUES (820,'Legazpi','PHL','Bicol',157010); INSERT INTO `City` VALUES (821,'Silang','PHL','Southern Tagalog',156137); INSERT INTO `City` VALUES (822,'Ormoc','PHL','Eastern Visayas',154297); INSERT INTO `City` VALUES (823,'San Carlos','PHL','Ilocos',154264); INSERT INTO `City` VALUES (824,'Kabankalan','PHL','Western Visayas',149769); INSERT INTO `City` VALUES (825,'Talisay','PHL','Central Visayas',148110); INSERT INTO `City` VALUES (826,'Valencia','PHL','Northern Mindanao',147924); INSERT INTO `City` VALUES (827,'Calbayog','PHL','Eastern Visayas',147187); INSERT INTO `City` VALUES (828,'Santa Maria','PHL','Central Luzon',144282); INSERT INTO `City` VALUES (829,'Pagadian','PHL','Western Mindanao',142515); INSERT INTO `City` VALUES (830,'Cadiz','PHL','Western Visayas',141954); INSERT INTO `City` VALUES (831,'Bago','PHL','Western Visayas',141721); INSERT INTO `City` VALUES (832,'Toledo','PHL','Central Visayas',141174); INSERT INTO `City` VALUES (833,'Naga','PHL','Bicol',137810); INSERT INTO `City` VALUES (834,'San Mateo','PHL','Southern Tagalog',135603); INSERT INTO `City` VALUES (835,'Panabo','PHL','Southern Mindanao',133950); INSERT INTO `City` VALUES (836,'Koronadal','PHL','Southern Mindanao',133786); INSERT INTO `City` VALUES (837,'Marawi','PHL','Central Mindanao',131090); INSERT INTO `City` VALUES (838,'Dagupan','PHL','Ilocos',130328); INSERT INTO `City` VALUES (839,'Sagay','PHL','Western Visayas',129765); INSERT INTO `City` VALUES (840,'Roxas','PHL','Western Visayas',126352); INSERT INTO `City` VALUES (841,'Lubao','PHL','Central Luzon',125699); INSERT INTO `City` VALUES (842,'Digos','PHL','Southern Mindanao',125171); INSERT INTO `City` VALUES (843,'San Miguel','PHL','Central Luzon',123824); INSERT INTO `City` VALUES (844,'Malaybalay','PHL','Northern Mindanao',123672); INSERT INTO `City` VALUES (845,'Tuguegarao','PHL','Cagayan Valley',120645); INSERT INTO `City` VALUES (846,'Ilagan','PHL','Cagayan Valley',119990); INSERT INTO `City` VALUES (847,'Baliuag','PHL','Central Luzon',119675); INSERT INTO `City` VALUES (848,'Surigao','PHL','Caraga',118534); INSERT INTO `City` VALUES (849,'San Carlos','PHL','Western Visayas',118259); INSERT INTO `City` VALUES (850,'San Juan del Monte','PHL','National Capital Reg',117680); INSERT INTO `City` VALUES (851,'Tanauan','PHL','Southern Tagalog',117539); INSERT INTO `City` VALUES (852,'Concepcion','PHL','Central Luzon',115171); INSERT INTO `City` VALUES (853,'Rodriguez (Montalban)','PHL','Southern Tagalog',115167); INSERT INTO `City` VALUES (854,'Sariaya','PHL','Southern Tagalog',114568); INSERT INTO `City` VALUES (855,'Malasiqui','PHL','Ilocos',113190); INSERT INTO `City` VALUES (856,'General Mariano Alvarez','PHL','Southern Tagalog',112446); INSERT INTO `City` VALUES (857,'Urdaneta','PHL','Ilocos',111582); INSERT INTO `City` VALUES (858,'Hagonoy','PHL','Central Luzon',111425); INSERT INTO `City` VALUES (859,'San Jose','PHL','Southern Tagalog',111009); INSERT INTO `City` VALUES (860,'Polomolok','PHL','Southern Mindanao',110709); INSERT INTO `City` VALUES (861,'Santiago','PHL','Cagayan Valley',110531); INSERT INTO `City` VALUES (862,'Tanza','PHL','Southern Tagalog',110517); INSERT INTO `City` VALUES (863,'Ozamis','PHL','Northern Mindanao',110420); INSERT INTO `City` VALUES (864,'Mexico','PHL','Central Luzon',109481); INSERT INTO `City` VALUES (865,'San Jose','PHL','Central Luzon',108254); INSERT INTO `City` VALUES (866,'Silay','PHL','Western Visayas',107722); INSERT INTO `City` VALUES (867,'General Trias','PHL','Southern Tagalog',107691); INSERT INTO `City` VALUES (868,'Tabaco','PHL','Bicol',107166); INSERT INTO `City` VALUES (869,'Cabuyao','PHL','Southern Tagalog',106630); INSERT INTO `City` VALUES (870,'Calapan','PHL','Southern Tagalog',105910); INSERT INTO `City` VALUES (871,'Mati','PHL','Southern Mindanao',105908); INSERT INTO `City` VALUES (872,'Midsayap','PHL','Central Mindanao',105760); INSERT INTO `City` VALUES (873,'Cauayan','PHL','Cagayan Valley',103952); INSERT INTO `City` VALUES (874,'Gingoog','PHL','Northern Mindanao',102379); INSERT INTO `City` VALUES (875,'Dumaguete','PHL','Central Visayas',102265); INSERT INTO `City` VALUES (876,'San Fernando','PHL','Ilocos',102082); INSERT INTO `City` VALUES (877,'Arayat','PHL','Central Luzon',101792); INSERT INTO `City` VALUES (878,'Bayawan (Tulong)','PHL','Central Visayas',101391); INSERT INTO `City` VALUES (879,'Kidapawan','PHL','Central Mindanao',101205); INSERT INTO `City` VALUES (880,'Daraga (Locsin)','PHL','Bicol',101031); INSERT INTO `City` VALUES (881,'Marilao','PHL','Central Luzon',101017); INSERT INTO `City` VALUES (882,'Malita','PHL','Southern Mindanao',100000); INSERT INTO `City` VALUES (883,'Dipolog','PHL','Western Mindanao',99862); INSERT INTO `City` VALUES (884,'Cavite','PHL','Southern Tagalog',99367); INSERT INTO `City` VALUES (885,'Danao','PHL','Central Visayas',98781); INSERT INTO `City` VALUES (886,'Bislig','PHL','Caraga',97860); INSERT INTO `City` VALUES (887,'Talavera','PHL','Central Luzon',97329); INSERT INTO `City` VALUES (888,'Guagua','PHL','Central Luzon',96858); INSERT INTO `City` VALUES (889,'Bayambang','PHL','Ilocos',96609); INSERT INTO `City` VALUES (890,'Nasugbu','PHL','Southern Tagalog',96113); INSERT INTO `City` VALUES (891,'Baybay','PHL','Eastern Visayas',95630); INSERT INTO `City` VALUES (892,'Capas','PHL','Central Luzon',95219); INSERT INTO `City` VALUES (893,'Sultan Kudarat','PHL','ARMM',94861); INSERT INTO `City` VALUES (894,'Laoag','PHL','Ilocos',94466); INSERT INTO `City` VALUES (895,'Bayugan','PHL','Caraga',93623); INSERT INTO `City` VALUES (896,'Malungon','PHL','Southern Mindanao',93232); INSERT INTO `City` VALUES (897,'Santa Cruz','PHL','Southern Tagalog',92694); INSERT INTO `City` VALUES (898,'Sorsogon','PHL','Bicol',92512); INSERT INTO `City` VALUES (899,'Candelaria','PHL','Southern Tagalog',92429); INSERT INTO `City` VALUES (900,'Ligao','PHL','Bicol',90603); INSERT INTO `City` VALUES (901,'Tórshavn','FRO','Streymoyar',14542); INSERT INTO `City` VALUES (902,'Libreville','GAB','Estuaire',419000); INSERT INTO `City` VALUES (903,'Serekunda','GMB','Kombo St Mary',102600); INSERT INTO `City` VALUES (904,'Banjul','GMB','Banjul',42326); INSERT INTO `City` VALUES (905,'Tbilisi','GEO','Tbilisi',1235200); INSERT INTO `City` VALUES (906,'Kutaisi','GEO','Imereti',240900); INSERT INTO `City` VALUES (907,'Rustavi','GEO','Kvemo Kartli',155400); INSERT INTO `City` VALUES (908,'Batumi','GEO','Adzaria [Atšara]',137700); INSERT INTO `City` VALUES (909,'Sohumi','GEO','Abhasia [Aphazeti]',111700); INSERT INTO `City` VALUES (910,'Accra','GHA','Greater Accra',1070000); INSERT INTO `City` VALUES (911,'Kumasi','GHA','Ashanti',385192); INSERT INTO `City` VALUES (912,'Tamale','GHA','Northern',151069); INSERT INTO `City` VALUES (913,'Tema','GHA','Greater Accra',109975); INSERT INTO `City` VALUES (914,'Sekondi-Takoradi','GHA','Western',103653); INSERT INTO `City` VALUES (915,'Gibraltar','GIB','–',27025); INSERT INTO `City` VALUES (916,'Saint George´s','GRD','St George',4621); INSERT INTO `City` VALUES (917,'Nuuk','GRL','Kitaa',13445); INSERT INTO `City` VALUES (918,'Les Abymes','GLP','Grande-Terre',62947); INSERT INTO `City` VALUES (919,'Basse-Terre','GLP','Basse-Terre',12433); INSERT INTO `City` VALUES (920,'Tamuning','GUM','–',9500); INSERT INTO `City` VALUES (921,'Agaña','GUM','–',1139); INSERT INTO `City` VALUES (922,'Ciudad de Guatemala','GTM','Guatemala',823301); INSERT INTO `City` VALUES (923,'Mixco','GTM','Guatemala',209791); INSERT INTO `City` VALUES (924,'Villa Nueva','GTM','Guatemala',101295); INSERT INTO `City` VALUES (925,'Quetzaltenango','GTM','Quetzaltenango',90801); INSERT INTO `City` VALUES (926,'Conakry','GIN','Conakry',1090610); INSERT INTO `City` VALUES (927,'Bissau','GNB','Bissau',241000); INSERT INTO `City` VALUES (928,'Georgetown','GUY','Georgetown',254000); INSERT INTO `City` VALUES (929,'Port-au-Prince','HTI','Ouest',884472); INSERT INTO `City` VALUES (930,'Carrefour','HTI','Ouest',290204); INSERT INTO `City` VALUES (931,'Delmas','HTI','Ouest',240429); INSERT INTO `City` VALUES (932,'Le-Cap-Haïtien','HTI','Nord',102233); INSERT INTO `City` VALUES (933,'Tegucigalpa','HND','Distrito Central',813900); INSERT INTO `City` VALUES (934,'San Pedro Sula','HND','Cortés',383900); INSERT INTO `City` VALUES (935,'La Ceiba','HND','Atlántida',89200); INSERT INTO `City` VALUES (936,'Kowloon and New Kowloon','HKG','Kowloon and New Kowl',1987996); INSERT INTO `City` VALUES (937,'Victoria','HKG','Hongkong',1312637); INSERT INTO `City` VALUES (938,'Longyearbyen','SJM','Länsimaa',1438); INSERT INTO `City` VALUES (939,'Jakarta','IDN','Jakarta Raya',9604900); INSERT INTO `City` VALUES (940,'Surabaya','IDN','East Java',2663820); INSERT INTO `City` VALUES (941,'Bandung','IDN','West Java',2429000); INSERT INTO `City` VALUES (942,'Medan','IDN','Sumatera Utara',1843919); INSERT INTO `City` VALUES (943,'Palembang','IDN','Sumatera Selatan',1222764); INSERT INTO `City` VALUES (944,'Tangerang','IDN','West Java',1198300); INSERT INTO `City` VALUES (945,'Semarang','IDN','Central Java',1104405); INSERT INTO `City` VALUES (946,'Ujung Pandang','IDN','Sulawesi Selatan',1060257); INSERT INTO `City` VALUES (947,'Malang','IDN','East Java',716862); INSERT INTO `City` VALUES (948,'Bandar Lampung','IDN','Lampung',680332); INSERT INTO `City` VALUES (949,'Bekasi','IDN','West Java',644300); INSERT INTO `City` VALUES (950,'Padang','IDN','Sumatera Barat',534474); INSERT INTO `City` VALUES (951,'Surakarta','IDN','Central Java',518600); INSERT INTO `City` VALUES (952,'Banjarmasin','IDN','Kalimantan Selatan',482931); INSERT INTO `City` VALUES (953,'Pekan Baru','IDN','Riau',438638); INSERT INTO `City` VALUES (954,'Denpasar','IDN','Bali',435000); INSERT INTO `City` VALUES (955,'Yogyakarta','IDN','Yogyakarta',418944); INSERT INTO `City` VALUES (956,'Pontianak','IDN','Kalimantan Barat',409632); INSERT INTO `City` VALUES (957,'Samarinda','IDN','Kalimantan Timur',399175); INSERT INTO `City` VALUES (958,'Jambi','IDN','Jambi',385201); INSERT INTO `City` VALUES (959,'Depok','IDN','West Java',365200); INSERT INTO `City` VALUES (960,'Cimahi','IDN','West Java',344600); INSERT INTO `City` VALUES (961,'Balikpapan','IDN','Kalimantan Timur',338752); INSERT INTO `City` VALUES (962,'Manado','IDN','Sulawesi Utara',332288); INSERT INTO `City` VALUES (963,'Mataram','IDN','Nusa Tenggara Barat',306600); INSERT INTO `City` VALUES (964,'Pekalongan','IDN','Central Java',301504); INSERT INTO `City` VALUES (965,'Tegal','IDN','Central Java',289744); INSERT INTO `City` VALUES (966,'Bogor','IDN','West Java',285114); INSERT INTO `City` VALUES (967,'Ciputat','IDN','West Java',270800); INSERT INTO `City` VALUES (968,'Pondokgede','IDN','West Java',263200); INSERT INTO `City` VALUES (969,'Cirebon','IDN','West Java',254406); INSERT INTO `City` VALUES (970,'Kediri','IDN','East Java',253760); INSERT INTO `City` VALUES (971,'Ambon','IDN','Molukit',249312); INSERT INTO `City` VALUES (972,'Jember','IDN','East Java',218500); INSERT INTO `City` VALUES (973,'Cilacap','IDN','Central Java',206900); INSERT INTO `City` VALUES (974,'Cimanggis','IDN','West Java',205100); INSERT INTO `City` VALUES (975,'Pematang Siantar','IDN','Sumatera Utara',203056); INSERT INTO `City` VALUES (976,'Purwokerto','IDN','Central Java',202500); INSERT INTO `City` VALUES (977,'Ciomas','IDN','West Java',187400); INSERT INTO `City` VALUES (978,'Tasikmalaya','IDN','West Java',179800); INSERT INTO `City` VALUES (979,'Madiun','IDN','East Java',171532); INSERT INTO `City` VALUES (980,'Bengkulu','IDN','Bengkulu',146439); INSERT INTO `City` VALUES (981,'Karawang','IDN','West Java',145000); INSERT INTO `City` VALUES (982,'Banda Aceh','IDN','Aceh',143409); INSERT INTO `City` VALUES (983,'Palu','IDN','Sulawesi Tengah',142800); INSERT INTO `City` VALUES (984,'Pasuruan','IDN','East Java',134019); INSERT INTO `City` VALUES (985,'Kupang','IDN','Nusa Tenggara Timur',129300); INSERT INTO `City` VALUES (986,'Tebing Tinggi','IDN','Sumatera Utara',129300); INSERT INTO `City` VALUES (987,'Percut Sei Tuan','IDN','Sumatera Utara',129000); INSERT INTO `City` VALUES (988,'Binjai','IDN','Sumatera Utara',127222); INSERT INTO `City` VALUES (989,'Sukabumi','IDN','West Java',125766); INSERT INTO `City` VALUES (990,'Waru','IDN','East Java',124300); INSERT INTO `City` VALUES (991,'Pangkal Pinang','IDN','Sumatera Selatan',124000); INSERT INTO `City` VALUES (992,'Magelang','IDN','Central Java',123800); INSERT INTO `City` VALUES (993,'Blitar','IDN','East Java',122600); INSERT INTO `City` VALUES (994,'Serang','IDN','West Java',122400); INSERT INTO `City` VALUES (995,'Probolinggo','IDN','East Java',120770); INSERT INTO `City` VALUES (996,'Cilegon','IDN','West Java',117000); INSERT INTO `City` VALUES (997,'Cianjur','IDN','West Java',114300); INSERT INTO `City` VALUES (998,'Ciparay','IDN','West Java',111500); INSERT INTO `City` VALUES (999,'Lhokseumawe','IDN','Aceh',109600); INSERT INTO `City` VALUES (1000,'Taman','IDN','East Java',107000); INSERT INTO `City` VALUES (1001,'Depok','IDN','Yogyakarta',106800); INSERT INTO `City` VALUES (1002,'Citeureup','IDN','West Java',105100); INSERT INTO `City` VALUES (1003,'Pemalang','IDN','Central Java',103500); INSERT INTO `City` VALUES (1004,'Klaten','IDN','Central Java',103300); INSERT INTO `City` VALUES (1005,'Salatiga','IDN','Central Java',103000); INSERT INTO `City` VALUES (1006,'Cibinong','IDN','West Java',101300); INSERT INTO `City` VALUES (1007,'Palangka Raya','IDN','Kalimantan Tengah',99693); INSERT INTO `City` VALUES (1008,'Mojokerto','IDN','East Java',96626); INSERT INTO `City` VALUES (1009,'Purwakarta','IDN','West Java',95900); INSERT INTO `City` VALUES (1010,'Garut','IDN','West Java',95800); INSERT INTO `City` VALUES (1011,'Kudus','IDN','Central Java',95300); INSERT INTO `City` VALUES (1012,'Kendari','IDN','Sulawesi Tenggara',94800); INSERT INTO `City` VALUES (1013,'Jaya Pura','IDN','West Irian',94700); INSERT INTO `City` VALUES (1014,'Gorontalo','IDN','Sulawesi Utara',94058); INSERT INTO `City` VALUES (1015,'Majalaya','IDN','West Java',93200); INSERT INTO `City` VALUES (1016,'Pondok Aren','IDN','West Java',92700); INSERT INTO `City` VALUES (1017,'Jombang','IDN','East Java',92600); INSERT INTO `City` VALUES (1018,'Sunggal','IDN','Sumatera Utara',92300); INSERT INTO `City` VALUES (1019,'Batam','IDN','Riau',91871); INSERT INTO `City` VALUES (1020,'Padang Sidempuan','IDN','Sumatera Utara',91200); INSERT INTO `City` VALUES (1021,'Sawangan','IDN','West Java',91100); INSERT INTO `City` VALUES (1022,'Banyuwangi','IDN','East Java',89900); INSERT INTO `City` VALUES (1023,'Tanjung Pinang','IDN','Riau',89900); INSERT INTO `City` VALUES (1024,'Mumbai (Bombay)','IND','Maharashtra',10500000); INSERT INTO `City` VALUES (1025,'Delhi','IND','Delhi',7206704); INSERT INTO `City` VALUES (1026,'Calcutta [Kolkata]','IND','West Bengali',4399819); INSERT INTO `City` VALUES (1027,'Chennai (Madras)','IND','Tamil Nadu',3841396); INSERT INTO `City` VALUES (1028,'Hyderabad','IND','Andhra Pradesh',2964638); INSERT INTO `City` VALUES (1029,'Ahmedabad','IND','Gujarat',2876710); INSERT INTO `City` VALUES (1030,'Bangalore','IND','Karnataka',2660088); INSERT INTO `City` VALUES (1031,'Kanpur','IND','Uttar Pradesh',1874409); INSERT INTO `City` VALUES (1032,'Nagpur','IND','Maharashtra',1624752); INSERT INTO `City` VALUES (1033,'Lucknow','IND','Uttar Pradesh',1619115); INSERT INTO `City` VALUES (1034,'Pune','IND','Maharashtra',1566651); INSERT INTO `City` VALUES (1035,'Surat','IND','Gujarat',1498817); INSERT INTO `City` VALUES (1036,'Jaipur','IND','Rajasthan',1458483); INSERT INTO `City` VALUES (1037,'Indore','IND','Madhya Pradesh',1091674); INSERT INTO `City` VALUES (1038,'Bhopal','IND','Madhya Pradesh',1062771); INSERT INTO `City` VALUES (1039,'Ludhiana','IND','Punjab',1042740); INSERT INTO `City` VALUES (1040,'Vadodara (Baroda)','IND','Gujarat',1031346); INSERT INTO `City` VALUES (1041,'Kalyan','IND','Maharashtra',1014557); INSERT INTO `City` VALUES (1042,'Madurai','IND','Tamil Nadu',977856); INSERT INTO `City` VALUES (1043,'Haora (Howrah)','IND','West Bengali',950435); INSERT INTO `City` VALUES (1044,'Varanasi (Benares)','IND','Uttar Pradesh',929270); INSERT INTO `City` VALUES (1045,'Patna','IND','Bihar',917243); INSERT INTO `City` VALUES (1046,'Srinagar','IND','Jammu and Kashmir',892506); INSERT INTO `City` VALUES (1047,'Agra','IND','Uttar Pradesh',891790); INSERT INTO `City` VALUES (1048,'Coimbatore','IND','Tamil Nadu',816321); INSERT INTO `City` VALUES (1049,'Thane (Thana)','IND','Maharashtra',803389); INSERT INTO `City` VALUES (1050,'Allahabad','IND','Uttar Pradesh',792858); INSERT INTO `City` VALUES (1051,'Meerut','IND','Uttar Pradesh',753778); INSERT INTO `City` VALUES (1052,'Vishakhapatnam','IND','Andhra Pradesh',752037); INSERT INTO `City` VALUES (1053,'Jabalpur','IND','Madhya Pradesh',741927); INSERT INTO `City` VALUES (1054,'Amritsar','IND','Punjab',708835); INSERT INTO `City` VALUES (1055,'Faridabad','IND','Haryana',703592); INSERT INTO `City` VALUES (1056,'Vijayawada','IND','Andhra Pradesh',701827); INSERT INTO `City` VALUES (1057,'Gwalior','IND','Madhya Pradesh',690765); INSERT INTO `City` VALUES (1058,'Jodhpur','IND','Rajasthan',666279); INSERT INTO `City` VALUES (1059,'Nashik (Nasik)','IND','Maharashtra',656925); INSERT INTO `City` VALUES (1060,'Hubli-Dharwad','IND','Karnataka',648298); INSERT INTO `City` VALUES (1061,'Solapur (Sholapur)','IND','Maharashtra',604215); INSERT INTO `City` VALUES (1062,'Ranchi','IND','Jharkhand',599306); INSERT INTO `City` VALUES (1063,'Bareilly','IND','Uttar Pradesh',587211); INSERT INTO `City` VALUES (1064,'Guwahati (Gauhati)','IND','Assam',584342); INSERT INTO `City` VALUES (1065,'Shambajinagar (Aurangabad)','IND','Maharashtra',573272); INSERT INTO `City` VALUES (1066,'Cochin (Kochi)','IND','Kerala',564589); INSERT INTO `City` VALUES (1067,'Rajkot','IND','Gujarat',559407); INSERT INTO `City` VALUES (1068,'Kota','IND','Rajasthan',537371); INSERT INTO `City` VALUES (1069,'Thiruvananthapuram (Trivandrum','IND','Kerala',524006); INSERT INTO `City` VALUES (1070,'Pimpri-Chinchwad','IND','Maharashtra',517083); INSERT INTO `City` VALUES (1071,'Jalandhar (Jullundur)','IND','Punjab',509510); INSERT INTO `City` VALUES (1072,'Gorakhpur','IND','Uttar Pradesh',505566); INSERT INTO `City` VALUES (1073,'Chandigarh','IND','Chandigarh',504094); INSERT INTO `City` VALUES (1074,'Mysore','IND','Karnataka',480692); INSERT INTO `City` VALUES (1075,'Aligarh','IND','Uttar Pradesh',480520); INSERT INTO `City` VALUES (1076,'Guntur','IND','Andhra Pradesh',471051); INSERT INTO `City` VALUES (1077,'Jamshedpur','IND','Jharkhand',460577); INSERT INTO `City` VALUES (1078,'Ghaziabad','IND','Uttar Pradesh',454156); INSERT INTO `City` VALUES (1079,'Warangal','IND','Andhra Pradesh',447657); INSERT INTO `City` VALUES (1080,'Raipur','IND','Chhatisgarh',438639); INSERT INTO `City` VALUES (1081,'Moradabad','IND','Uttar Pradesh',429214); INSERT INTO `City` VALUES (1082,'Durgapur','IND','West Bengali',425836); INSERT INTO `City` VALUES (1083,'Amravati','IND','Maharashtra',421576); INSERT INTO `City` VALUES (1084,'Calicut (Kozhikode)','IND','Kerala',419831); INSERT INTO `City` VALUES (1085,'Bikaner','IND','Rajasthan',416289); INSERT INTO `City` VALUES (1086,'Bhubaneswar','IND','Orissa',411542); INSERT INTO `City` VALUES (1087,'Kolhapur','IND','Maharashtra',406370); INSERT INTO `City` VALUES (1088,'Kataka (Cuttack)','IND','Orissa',403418); INSERT INTO `City` VALUES (1089,'Ajmer','IND','Rajasthan',402700); INSERT INTO `City` VALUES (1090,'Bhavnagar','IND','Gujarat',402338); INSERT INTO `City` VALUES (1091,'Tiruchirapalli','IND','Tamil Nadu',387223); INSERT INTO `City` VALUES (1092,'Bhilai','IND','Chhatisgarh',386159); INSERT INTO `City` VALUES (1093,'Bhiwandi','IND','Maharashtra',379070); INSERT INTO `City` VALUES (1094,'Saharanpur','IND','Uttar Pradesh',374945); INSERT INTO `City` VALUES (1095,'Ulhasnagar','IND','Maharashtra',369077); INSERT INTO `City` VALUES (1096,'Salem','IND','Tamil Nadu',366712); INSERT INTO `City` VALUES (1097,'Ujjain','IND','Madhya Pradesh',362266); INSERT INTO `City` VALUES (1098,'Malegaon','IND','Maharashtra',342595); INSERT INTO `City` VALUES (1099,'Jamnagar','IND','Gujarat',341637); INSERT INTO `City` VALUES (1100,'Bokaro Steel City','IND','Jharkhand',333683); INSERT INTO `City` VALUES (1101,'Akola','IND','Maharashtra',328034); INSERT INTO `City` VALUES (1102,'Belgaum','IND','Karnataka',326399); INSERT INTO `City` VALUES (1103,'Rajahmundry','IND','Andhra Pradesh',324851); INSERT INTO `City` VALUES (1104,'Nellore','IND','Andhra Pradesh',316606); INSERT INTO `City` VALUES (1105,'Udaipur','IND','Rajasthan',308571); INSERT INTO `City` VALUES (1106,'New Bombay','IND','Maharashtra',307297); INSERT INTO `City` VALUES (1107,'Bhatpara','IND','West Bengali',304952); INSERT INTO `City` VALUES (1108,'Gulbarga','IND','Karnataka',304099); INSERT INTO `City` VALUES (1109,'New Delhi','IND','Delhi',301297); INSERT INTO `City` VALUES (1110,'Jhansi','IND','Uttar Pradesh',300850); INSERT INTO `City` VALUES (1111,'Gaya','IND','Bihar',291675); INSERT INTO `City` VALUES (1112,'Kakinada','IND','Andhra Pradesh',279980); INSERT INTO `City` VALUES (1113,'Dhule (Dhulia)','IND','Maharashtra',278317); INSERT INTO `City` VALUES (1114,'Panihati','IND','West Bengali',275990); INSERT INTO `City` VALUES (1115,'Nanded (Nander)','IND','Maharashtra',275083); INSERT INTO `City` VALUES (1116,'Mangalore','IND','Karnataka',273304); INSERT INTO `City` VALUES (1117,'Dehra Dun','IND','Uttaranchal',270159); INSERT INTO `City` VALUES (1118,'Kamarhati','IND','West Bengali',266889); INSERT INTO `City` VALUES (1119,'Davangere','IND','Karnataka',266082); INSERT INTO `City` VALUES (1120,'Asansol','IND','West Bengali',262188); INSERT INTO `City` VALUES (1121,'Bhagalpur','IND','Bihar',253225); INSERT INTO `City` VALUES (1122,'Bellary','IND','Karnataka',245391); INSERT INTO `City` VALUES (1123,'Barddhaman (Burdwan)','IND','West Bengali',245079); INSERT INTO `City` VALUES (1124,'Rampur','IND','Uttar Pradesh',243742); INSERT INTO `City` VALUES (1125,'Jalgaon','IND','Maharashtra',242193); INSERT INTO `City` VALUES (1126,'Muzaffarpur','IND','Bihar',241107); INSERT INTO `City` VALUES (1127,'Nizamabad','IND','Andhra Pradesh',241034); INSERT INTO `City` VALUES (1128,'Muzaffarnagar','IND','Uttar Pradesh',240609); INSERT INTO `City` VALUES (1129,'Patiala','IND','Punjab',238368); INSERT INTO `City` VALUES (1130,'Shahjahanpur','IND','Uttar Pradesh',237713); INSERT INTO `City` VALUES (1131,'Kurnool','IND','Andhra Pradesh',236800); INSERT INTO `City` VALUES (1132,'Tiruppur (Tirupper)','IND','Tamil Nadu',235661); INSERT INTO `City` VALUES (1133,'Rohtak','IND','Haryana',233400); INSERT INTO `City` VALUES (1134,'South Dum Dum','IND','West Bengali',232811); INSERT INTO `City` VALUES (1135,'Mathura','IND','Uttar Pradesh',226691); INSERT INTO `City` VALUES (1136,'Chandrapur','IND','Maharashtra',226105); INSERT INTO `City` VALUES (1137,'Barahanagar (Baranagar)','IND','West Bengali',224821); INSERT INTO `City` VALUES (1138,'Darbhanga','IND','Bihar',218391); INSERT INTO `City` VALUES (1139,'Siliguri (Shiliguri)','IND','West Bengali',216950); INSERT INTO `City` VALUES (1140,'Raurkela','IND','Orissa',215489); INSERT INTO `City` VALUES (1141,'Ambattur','IND','Tamil Nadu',215424); INSERT INTO `City` VALUES (1142,'Panipat','IND','Haryana',215218); INSERT INTO `City` VALUES (1143,'Firozabad','IND','Uttar Pradesh',215128); INSERT INTO `City` VALUES (1144,'Ichalkaranji','IND','Maharashtra',214950); INSERT INTO `City` VALUES (1145,'Jammu','IND','Jammu and Kashmir',214737); INSERT INTO `City` VALUES (1146,'Ramagundam','IND','Andhra Pradesh',214384); INSERT INTO `City` VALUES (1147,'Eluru','IND','Andhra Pradesh',212866); INSERT INTO `City` VALUES (1148,'Brahmapur','IND','Orissa',210418); INSERT INTO `City` VALUES (1149,'Alwar','IND','Rajasthan',205086); INSERT INTO `City` VALUES (1150,'Pondicherry','IND','Pondicherry',203065); INSERT INTO `City` VALUES (1151,'Thanjavur','IND','Tamil Nadu',202013); INSERT INTO `City` VALUES (1152,'Bihar Sharif','IND','Bihar',201323); INSERT INTO `City` VALUES (1153,'Tuticorin','IND','Tamil Nadu',199854); INSERT INTO `City` VALUES (1154,'Imphal','IND','Manipur',198535); INSERT INTO `City` VALUES (1155,'Latur','IND','Maharashtra',197408); INSERT INTO `City` VALUES (1156,'Sagar','IND','Madhya Pradesh',195346); INSERT INTO `City` VALUES (1157,'Farrukhabad-cum-Fatehgarh','IND','Uttar Pradesh',194567); INSERT INTO `City` VALUES (1158,'Sangli','IND','Maharashtra',193197); INSERT INTO `City` VALUES (1159,'Parbhani','IND','Maharashtra',190255); INSERT INTO `City` VALUES (1160,'Nagar Coil','IND','Tamil Nadu',190084); INSERT INTO `City` VALUES (1161,'Bijapur','IND','Karnataka',186939); INSERT INTO `City` VALUES (1162,'Kukatpalle','IND','Andhra Pradesh',185378); INSERT INTO `City` VALUES (1163,'Bally','IND','West Bengali',184474); INSERT INTO `City` VALUES (1164,'Bhilwara','IND','Rajasthan',183965); INSERT INTO `City` VALUES (1165,'Ratlam','IND','Madhya Pradesh',183375); INSERT INTO `City` VALUES (1166,'Avadi','IND','Tamil Nadu',183215); INSERT INTO `City` VALUES (1167,'Dindigul','IND','Tamil Nadu',182477); INSERT INTO `City` VALUES (1168,'Ahmadnagar','IND','Maharashtra',181339); INSERT INTO `City` VALUES (1169,'Bilaspur','IND','Chhatisgarh',179833); INSERT INTO `City` VALUES (1170,'Shimoga','IND','Karnataka',179258); INSERT INTO `City` VALUES (1171,'Kharagpur','IND','West Bengali',177989); INSERT INTO `City` VALUES (1172,'Mira Bhayandar','IND','Maharashtra',175372); INSERT INTO `City` VALUES (1173,'Vellore','IND','Tamil Nadu',175061); INSERT INTO `City` VALUES (1174,'Jalna','IND','Maharashtra',174985); INSERT INTO `City` VALUES (1175,'Burnpur','IND','West Bengali',174933); INSERT INTO `City` VALUES (1176,'Anantapur','IND','Andhra Pradesh',174924); INSERT INTO `City` VALUES (1177,'Allappuzha (Alleppey)','IND','Kerala',174666); INSERT INTO `City` VALUES (1178,'Tirupati','IND','Andhra Pradesh',174369); INSERT INTO `City` VALUES (1179,'Karnal','IND','Haryana',173751); INSERT INTO `City` VALUES (1180,'Burhanpur','IND','Madhya Pradesh',172710); INSERT INTO `City` VALUES (1181,'Hisar (Hissar)','IND','Haryana',172677); INSERT INTO `City` VALUES (1182,'Tiruvottiyur','IND','Tamil Nadu',172562); INSERT INTO `City` VALUES (1183,'Mirzapur-cum-Vindhyachal','IND','Uttar Pradesh',169336); INSERT INTO `City` VALUES (1184,'Secunderabad','IND','Andhra Pradesh',167461); INSERT INTO `City` VALUES (1185,'Nadiad','IND','Gujarat',167051); INSERT INTO `City` VALUES (1186,'Dewas','IND','Madhya Pradesh',164364); INSERT INTO `City` VALUES (1187,'Murwara (Katni)','IND','Madhya Pradesh',163431); INSERT INTO `City` VALUES (1188,'Ganganagar','IND','Rajasthan',161482); INSERT INTO `City` VALUES (1189,'Vizianagaram','IND','Andhra Pradesh',160359); INSERT INTO `City` VALUES (1190,'Erode','IND','Tamil Nadu',159232); INSERT INTO `City` VALUES (1191,'Machilipatnam (Masulipatam)','IND','Andhra Pradesh',159110); INSERT INTO `City` VALUES (1192,'Bhatinda (Bathinda)','IND','Punjab',159042); INSERT INTO `City` VALUES (1193,'Raichur','IND','Karnataka',157551); INSERT INTO `City` VALUES (1194,'Agartala','IND','Tripura',157358); INSERT INTO `City` VALUES (1195,'Arrah (Ara)','IND','Bihar',157082); INSERT INTO `City` VALUES (1196,'Satna','IND','Madhya Pradesh',156630); INSERT INTO `City` VALUES (1197,'Lalbahadur Nagar','IND','Andhra Pradesh',155500); INSERT INTO `City` VALUES (1198,'Aizawl','IND','Mizoram',155240); INSERT INTO `City` VALUES (1199,'Uluberia','IND','West Bengali',155172); INSERT INTO `City` VALUES (1200,'Katihar','IND','Bihar',154367); INSERT INTO `City` VALUES (1201,'Cuddalore','IND','Tamil Nadu',153086); INSERT INTO `City` VALUES (1202,'Hugli-Chinsurah','IND','West Bengali',151806); INSERT INTO `City` VALUES (1203,'Dhanbad','IND','Jharkhand',151789); INSERT INTO `City` VALUES (1204,'Raiganj','IND','West Bengali',151045); INSERT INTO `City` VALUES (1205,'Sambhal','IND','Uttar Pradesh',150869); INSERT INTO `City` VALUES (1206,'Durg','IND','Chhatisgarh',150645); INSERT INTO `City` VALUES (1207,'Munger (Monghyr)','IND','Bihar',150112); INSERT INTO `City` VALUES (1208,'Kanchipuram','IND','Tamil Nadu',150100); INSERT INTO `City` VALUES (1209,'North Dum Dum','IND','West Bengali',149965); INSERT INTO `City` VALUES (1210,'Karimnagar','IND','Andhra Pradesh',148583); INSERT INTO `City` VALUES (1211,'Bharatpur','IND','Rajasthan',148519); INSERT INTO `City` VALUES (1212,'Sikar','IND','Rajasthan',148272); INSERT INTO `City` VALUES (1213,'Hardwar (Haridwar)','IND','Uttaranchal',147305); INSERT INTO `City` VALUES (1214,'Dabgram','IND','West Bengali',147217); INSERT INTO `City` VALUES (1215,'Morena','IND','Madhya Pradesh',147124); INSERT INTO `City` VALUES (1216,'Noida','IND','Uttar Pradesh',146514); INSERT INTO `City` VALUES (1217,'Hapur','IND','Uttar Pradesh',146262); INSERT INTO `City` VALUES (1218,'Bhusawal','IND','Maharashtra',145143); INSERT INTO `City` VALUES (1219,'Khandwa','IND','Madhya Pradesh',145133); INSERT INTO `City` VALUES (1220,'Yamuna Nagar','IND','Haryana',144346); INSERT INTO `City` VALUES (1221,'Sonipat (Sonepat)','IND','Haryana',143922); INSERT INTO `City` VALUES (1222,'Tenali','IND','Andhra Pradesh',143726); INSERT INTO `City` VALUES (1223,'Raurkela Civil Township','IND','Orissa',140408); INSERT INTO `City` VALUES (1224,'Kollam (Quilon)','IND','Kerala',139852); INSERT INTO `City` VALUES (1225,'Kumbakonam','IND','Tamil Nadu',139483); INSERT INTO `City` VALUES (1226,'Ingraj Bazar (English Bazar)','IND','West Bengali',139204); INSERT INTO `City` VALUES (1227,'Timkur','IND','Karnataka',138903); INSERT INTO `City` VALUES (1228,'Amroha','IND','Uttar Pradesh',137061); INSERT INTO `City` VALUES (1229,'Serampore','IND','West Bengali',137028); INSERT INTO `City` VALUES (1230,'Chapra','IND','Bihar',136877); INSERT INTO `City` VALUES (1231,'Pali','IND','Rajasthan',136842); INSERT INTO `City` VALUES (1232,'Maunath Bhanjan','IND','Uttar Pradesh',136697); INSERT INTO `City` VALUES (1233,'Adoni','IND','Andhra Pradesh',136182); INSERT INTO `City` VALUES (1234,'Jaunpur','IND','Uttar Pradesh',136062); INSERT INTO `City` VALUES (1235,'Tirunelveli','IND','Tamil Nadu',135825); INSERT INTO `City` VALUES (1236,'Bahraich','IND','Uttar Pradesh',135400); INSERT INTO `City` VALUES (1237,'Gadag Betigeri','IND','Karnataka',134051); INSERT INTO `City` VALUES (1238,'Proddatur','IND','Andhra Pradesh',133914); INSERT INTO `City` VALUES (1239,'Chittoor','IND','Andhra Pradesh',133462); INSERT INTO `City` VALUES (1240,'Barrackpur','IND','West Bengali',133265); INSERT INTO `City` VALUES (1241,'Bharuch (Broach)','IND','Gujarat',133102); INSERT INTO `City` VALUES (1242,'Naihati','IND','West Bengali',132701); INSERT INTO `City` VALUES (1243,'Shillong','IND','Meghalaya',131719); INSERT INTO `City` VALUES (1244,'Sambalpur','IND','Orissa',131138); INSERT INTO `City` VALUES (1245,'Junagadh','IND','Gujarat',130484); INSERT INTO `City` VALUES (1246,'Rae Bareli','IND','Uttar Pradesh',129904); INSERT INTO `City` VALUES (1247,'Rewa','IND','Madhya Pradesh',128981); INSERT INTO `City` VALUES (1248,'Gurgaon','IND','Haryana',128608); INSERT INTO `City` VALUES (1249,'Khammam','IND','Andhra Pradesh',127992); INSERT INTO `City` VALUES (1250,'Bulandshahr','IND','Uttar Pradesh',127201); INSERT INTO `City` VALUES (1251,'Navsari','IND','Gujarat',126089); INSERT INTO `City` VALUES (1252,'Malkajgiri','IND','Andhra Pradesh',126066); INSERT INTO `City` VALUES (1253,'Midnapore (Medinipur)','IND','West Bengali',125498); INSERT INTO `City` VALUES (1254,'Miraj','IND','Maharashtra',125407); INSERT INTO `City` VALUES (1255,'Raj Nandgaon','IND','Chhatisgarh',125371); INSERT INTO `City` VALUES (1256,'Alandur','IND','Tamil Nadu',125244); INSERT INTO `City` VALUES (1257,'Puri','IND','Orissa',125199); INSERT INTO `City` VALUES (1258,'Navadwip','IND','West Bengali',125037); INSERT INTO `City` VALUES (1259,'Sirsa','IND','Haryana',125000); INSERT INTO `City` VALUES (1260,'Korba','IND','Chhatisgarh',124501); INSERT INTO `City` VALUES (1261,'Faizabad','IND','Uttar Pradesh',124437); INSERT INTO `City` VALUES (1262,'Etawah','IND','Uttar Pradesh',124072); INSERT INTO `City` VALUES (1263,'Pathankot','IND','Punjab',123930); INSERT INTO `City` VALUES (1264,'Gandhinagar','IND','Gujarat',123359); INSERT INTO `City` VALUES (1265,'Palghat (Palakkad)','IND','Kerala',123289); INSERT INTO `City` VALUES (1266,'Veraval','IND','Gujarat',123000); INSERT INTO `City` VALUES (1267,'Hoshiarpur','IND','Punjab',122705); INSERT INTO `City` VALUES (1268,'Ambala','IND','Haryana',122596); INSERT INTO `City` VALUES (1269,'Sitapur','IND','Uttar Pradesh',121842); INSERT INTO `City` VALUES (1270,'Bhiwani','IND','Haryana',121629); INSERT INTO `City` VALUES (1271,'Cuddapah','IND','Andhra Pradesh',121463); INSERT INTO `City` VALUES (1272,'Bhimavaram','IND','Andhra Pradesh',121314); INSERT INTO `City` VALUES (1273,'Krishnanagar','IND','West Bengali',121110); INSERT INTO `City` VALUES (1274,'Chandannagar','IND','West Bengali',120378); INSERT INTO `City` VALUES (1275,'Mandya','IND','Karnataka',120265); INSERT INTO `City` VALUES (1276,'Dibrugarh','IND','Assam',120127); INSERT INTO `City` VALUES (1277,'Nandyal','IND','Andhra Pradesh',119813); INSERT INTO `City` VALUES (1278,'Balurghat','IND','West Bengali',119796); INSERT INTO `City` VALUES (1279,'Neyveli','IND','Tamil Nadu',118080); INSERT INTO `City` VALUES (1280,'Fatehpur','IND','Uttar Pradesh',117675); INSERT INTO `City` VALUES (1281,'Mahbubnagar','IND','Andhra Pradesh',116833); INSERT INTO `City` VALUES (1282,'Budaun','IND','Uttar Pradesh',116695); INSERT INTO `City` VALUES (1283,'Porbandar','IND','Gujarat',116671); INSERT INTO `City` VALUES (1284,'Silchar','IND','Assam',115483); INSERT INTO `City` VALUES (1285,'Berhampore (Baharampur)','IND','West Bengali',115144); INSERT INTO `City` VALUES (1286,'Purnea (Purnia)','IND','Jharkhand',114912); INSERT INTO `City` VALUES (1287,'Bankura','IND','West Bengali',114876); INSERT INTO `City` VALUES (1288,'Rajapalaiyam','IND','Tamil Nadu',114202); INSERT INTO `City` VALUES (1289,'Titagarh','IND','West Bengali',114085); INSERT INTO `City` VALUES (1290,'Halisahar','IND','West Bengali',114028); INSERT INTO `City` VALUES (1291,'Hathras','IND','Uttar Pradesh',113285); INSERT INTO `City` VALUES (1292,'Bhir (Bid)','IND','Maharashtra',112434); INSERT INTO `City` VALUES (1293,'Pallavaram','IND','Tamil Nadu',111866); INSERT INTO `City` VALUES (1294,'Anand','IND','Gujarat',110266); INSERT INTO `City` VALUES (1295,'Mango','IND','Jharkhand',110024); INSERT INTO `City` VALUES (1296,'Santipur','IND','West Bengali',109956); INSERT INTO `City` VALUES (1297,'Bhind','IND','Madhya Pradesh',109755); INSERT INTO `City` VALUES (1298,'Gondiya','IND','Maharashtra',109470); INSERT INTO `City` VALUES (1299,'Tiruvannamalai','IND','Tamil Nadu',109196); INSERT INTO `City` VALUES (1300,'Yeotmal (Yavatmal)','IND','Maharashtra',108578); INSERT INTO `City` VALUES (1301,'Kulti-Barakar','IND','West Bengali',108518); INSERT INTO `City` VALUES (1302,'Moga','IND','Punjab',108304); INSERT INTO `City` VALUES (1303,'Shivapuri','IND','Madhya Pradesh',108277); INSERT INTO `City` VALUES (1304,'Bidar','IND','Karnataka',108016); INSERT INTO `City` VALUES (1305,'Guntakal','IND','Andhra Pradesh',107592); INSERT INTO `City` VALUES (1306,'Unnao','IND','Uttar Pradesh',107425); INSERT INTO `City` VALUES (1307,'Barasat','IND','West Bengali',107365); INSERT INTO `City` VALUES (1308,'Tambaram','IND','Tamil Nadu',107187); INSERT INTO `City` VALUES (1309,'Abohar','IND','Punjab',107163); INSERT INTO `City` VALUES (1310,'Pilibhit','IND','Uttar Pradesh',106605); INSERT INTO `City` VALUES (1311,'Valparai','IND','Tamil Nadu',106523); INSERT INTO `City` VALUES (1312,'Gonda','IND','Uttar Pradesh',106078); INSERT INTO `City` VALUES (1313,'Surendranagar','IND','Gujarat',105973); INSERT INTO `City` VALUES (1314,'Qutubullapur','IND','Andhra Pradesh',105380); INSERT INTO `City` VALUES (1315,'Beawar','IND','Rajasthan',105363); INSERT INTO `City` VALUES (1316,'Hindupur','IND','Andhra Pradesh',104651); INSERT INTO `City` VALUES (1317,'Gandhidham','IND','Gujarat',104585); INSERT INTO `City` VALUES (1318,'Haldwani-cum-Kathgodam','IND','Uttaranchal',104195); INSERT INTO `City` VALUES (1319,'Tellicherry (Thalassery)','IND','Kerala',103579); INSERT INTO `City` VALUES (1320,'Wardha','IND','Maharashtra',102985); INSERT INTO `City` VALUES (1321,'Rishra','IND','West Bengali',102649); INSERT INTO `City` VALUES (1322,'Bhuj','IND','Gujarat',102176); INSERT INTO `City` VALUES (1323,'Modinagar','IND','Uttar Pradesh',101660); INSERT INTO `City` VALUES (1324,'Gudivada','IND','Andhra Pradesh',101656); INSERT INTO `City` VALUES (1325,'Basirhat','IND','West Bengali',101409); INSERT INTO `City` VALUES (1326,'Uttarpara-Kotrung','IND','West Bengali',100867); INSERT INTO `City` VALUES (1327,'Ongole','IND','Andhra Pradesh',100836); INSERT INTO `City` VALUES (1328,'North Barrackpur','IND','West Bengali',100513); INSERT INTO `City` VALUES (1329,'Guna','IND','Madhya Pradesh',100490); INSERT INTO `City` VALUES (1330,'Haldia','IND','West Bengali',100347); INSERT INTO `City` VALUES (1331,'Habra','IND','West Bengali',100223); INSERT INTO `City` VALUES (1332,'Kanchrapara','IND','West Bengali',100194); INSERT INTO `City` VALUES (1333,'Tonk','IND','Rajasthan',100079); INSERT INTO `City` VALUES (1334,'Champdani','IND','West Bengali',98818); INSERT INTO `City` VALUES (1335,'Orai','IND','Uttar Pradesh',98640); INSERT INTO `City` VALUES (1336,'Pudukkottai','IND','Tamil Nadu',98619); INSERT INTO `City` VALUES (1337,'Sasaram','IND','Bihar',98220); INSERT INTO `City` VALUES (1338,'Hazaribag','IND','Jharkhand',97712); INSERT INTO `City` VALUES (1339,'Palayankottai','IND','Tamil Nadu',97662); INSERT INTO `City` VALUES (1340,'Banda','IND','Uttar Pradesh',97227); INSERT INTO `City` VALUES (1341,'Godhra','IND','Gujarat',96813); INSERT INTO `City` VALUES (1342,'Hospet','IND','Karnataka',96322); INSERT INTO `City` VALUES (1343,'Ashoknagar-Kalyangarh','IND','West Bengali',96315); INSERT INTO `City` VALUES (1344,'Achalpur','IND','Maharashtra',96216); INSERT INTO `City` VALUES (1345,'Patan','IND','Gujarat',96109); INSERT INTO `City` VALUES (1346,'Mandasor','IND','Madhya Pradesh',95758); INSERT INTO `City` VALUES (1347,'Damoh','IND','Madhya Pradesh',95661); INSERT INTO `City` VALUES (1348,'Satara','IND','Maharashtra',95133); INSERT INTO `City` VALUES (1349,'Meerut Cantonment','IND','Uttar Pradesh',94876); INSERT INTO `City` VALUES (1350,'Dehri','IND','Bihar',94526); INSERT INTO `City` VALUES (1351,'Delhi Cantonment','IND','Delhi',94326); INSERT INTO `City` VALUES (1352,'Chhindwara','IND','Madhya Pradesh',93731); INSERT INTO `City` VALUES (1353,'Bansberia','IND','West Bengali',93447); INSERT INTO `City` VALUES (1354,'Nagaon','IND','Assam',93350); INSERT INTO `City` VALUES (1355,'Kanpur Cantonment','IND','Uttar Pradesh',93109); INSERT INTO `City` VALUES (1356,'Vidisha','IND','Madhya Pradesh',92917); INSERT INTO `City` VALUES (1357,'Bettiah','IND','Bihar',92583); INSERT INTO `City` VALUES (1358,'Purulia','IND','Jharkhand',92574); INSERT INTO `City` VALUES (1359,'Hassan','IND','Karnataka',90803); INSERT INTO `City` VALUES (1360,'Ambala Sadar','IND','Haryana',90712); INSERT INTO `City` VALUES (1361,'Baidyabati','IND','West Bengali',90601); INSERT INTO `City` VALUES (1362,'Morvi','IND','Gujarat',90357); INSERT INTO `City` VALUES (1363,'Raigarh','IND','Chhatisgarh',89166); INSERT INTO `City` VALUES (1364,'Vejalpur','IND','Gujarat',89053); INSERT INTO `City` VALUES (1365,'Baghdad','IRQ','Baghdad',4336000); INSERT INTO `City` VALUES (1366,'Mosul','IRQ','Ninawa',879000); INSERT INTO `City` VALUES (1367,'Irbil','IRQ','Irbil',485968); INSERT INTO `City` VALUES (1368,'Kirkuk','IRQ','al-Tamim',418624); INSERT INTO `City` VALUES (1369,'Basra','IRQ','Basra',406296); INSERT INTO `City` VALUES (1370,'al-Sulaymaniya','IRQ','al-Sulaymaniya',364096); INSERT INTO `City` VALUES (1371,'al-Najaf','IRQ','al-Najaf',309010); INSERT INTO `City` VALUES (1372,'Karbala','IRQ','Karbala',296705); INSERT INTO `City` VALUES (1373,'al-Hilla','IRQ','Babil',268834); INSERT INTO `City` VALUES (1374,'al-Nasiriya','IRQ','DhiQar',265937); INSERT INTO `City` VALUES (1375,'al-Amara','IRQ','Maysan',208797); INSERT INTO `City` VALUES (1376,'al-Diwaniya','IRQ','al-Qadisiya',196519); INSERT INTO `City` VALUES (1377,'al-Ramadi','IRQ','al-Anbar',192556); INSERT INTO `City` VALUES (1378,'al-Kut','IRQ','Wasit',183183); INSERT INTO `City` VALUES (1379,'Baquba','IRQ','Diyala',114516); INSERT INTO `City` VALUES (1380,'Teheran','IRN','Teheran',6758845); INSERT INTO `City` VALUES (1381,'Mashhad','IRN','Khorasan',1887405); INSERT INTO `City` VALUES (1382,'Esfahan','IRN','Esfahan',1266072); INSERT INTO `City` VALUES (1383,'Tabriz','IRN','East Azerbaidzan',1191043); INSERT INTO `City` VALUES (1384,'Shiraz','IRN','Fars',1053025); INSERT INTO `City` VALUES (1385,'Karaj','IRN','Teheran',940968); INSERT INTO `City` VALUES (1386,'Ahvaz','IRN','Khuzestan',804980); INSERT INTO `City` VALUES (1387,'Qom','IRN','Qom',777677); INSERT INTO `City` VALUES (1388,'Kermanshah','IRN','Kermanshah',692986); INSERT INTO `City` VALUES (1389,'Urmia','IRN','West Azerbaidzan',435200); INSERT INTO `City` VALUES (1390,'Zahedan','IRN','Sistan va Baluchesta',419518); INSERT INTO `City` VALUES (1391,'Rasht','IRN','Gilan',417748); INSERT INTO `City` VALUES (1392,'Hamadan','IRN','Hamadan',401281); INSERT INTO `City` VALUES (1393,'Kerman','IRN','Kerman',384991); INSERT INTO `City` VALUES (1394,'Arak','IRN','Markazi',380755); INSERT INTO `City` VALUES (1395,'Ardebil','IRN','Ardebil',340386); INSERT INTO `City` VALUES (1396,'Yazd','IRN','Yazd',326776); INSERT INTO `City` VALUES (1397,'Qazvin','IRN','Qazvin',291117); INSERT INTO `City` VALUES (1398,'Zanjan','IRN','Zanjan',286295); INSERT INTO `City` VALUES (1399,'Sanandaj','IRN','Kordestan',277808); INSERT INTO `City` VALUES (1400,'Bandar-e-Abbas','IRN','Hormozgan',273578); INSERT INTO `City` VALUES (1401,'Khorramabad','IRN','Lorestan',272815); INSERT INTO `City` VALUES (1402,'Eslamshahr','IRN','Teheran',265450); INSERT INTO `City` VALUES (1403,'Borujerd','IRN','Lorestan',217804); INSERT INTO `City` VALUES (1404,'Abadan','IRN','Khuzestan',206073); INSERT INTO `City` VALUES (1405,'Dezful','IRN','Khuzestan',202639); INSERT INTO `City` VALUES (1406,'Kashan','IRN','Esfahan',201372); INSERT INTO `City` VALUES (1407,'Sari','IRN','Mazandaran',195882); INSERT INTO `City` VALUES (1408,'Gorgan','IRN','Golestan',188710); INSERT INTO `City` VALUES (1409,'Najafabad','IRN','Esfahan',178498); INSERT INTO `City` VALUES (1410,'Sabzevar','IRN','Khorasan',170738); INSERT INTO `City` VALUES (1411,'Khomeynishahr','IRN','Esfahan',165888); INSERT INTO `City` VALUES (1412,'Amol','IRN','Mazandaran',159092); INSERT INTO `City` VALUES (1413,'Neyshabur','IRN','Khorasan',158847); INSERT INTO `City` VALUES (1414,'Babol','IRN','Mazandaran',158346); INSERT INTO `City` VALUES (1415,'Khoy','IRN','West Azerbaidzan',148944); INSERT INTO `City` VALUES (1416,'Malayer','IRN','Hamadan',144373); INSERT INTO `City` VALUES (1417,'Bushehr','IRN','Bushehr',143641); INSERT INTO `City` VALUES (1418,'Qaemshahr','IRN','Mazandaran',143286); INSERT INTO `City` VALUES (1419,'Qarchak','IRN','Teheran',142690); INSERT INTO `City` VALUES (1420,'Qods','IRN','Teheran',138278); INSERT INTO `City` VALUES (1421,'Sirjan','IRN','Kerman',135024); INSERT INTO `City` VALUES (1422,'Bojnurd','IRN','Khorasan',134835); INSERT INTO `City` VALUES (1423,'Maragheh','IRN','East Azerbaidzan',132318); INSERT INTO `City` VALUES (1424,'Birjand','IRN','Khorasan',127608); INSERT INTO `City` VALUES (1425,'Ilam','IRN','Ilam',126346); INSERT INTO `City` VALUES (1426,'Bukan','IRN','West Azerbaidzan',120020); INSERT INTO `City` VALUES (1427,'Masjed-e-Soleyman','IRN','Khuzestan',116883); INSERT INTO `City` VALUES (1428,'Saqqez','IRN','Kordestan',115394); INSERT INTO `City` VALUES (1429,'Gonbad-e Qabus','IRN','Mazandaran',111253); INSERT INTO `City` VALUES (1430,'Saveh','IRN','Qom',111245); INSERT INTO `City` VALUES (1431,'Mahabad','IRN','West Azerbaidzan',107799); INSERT INTO `City` VALUES (1432,'Varamin','IRN','Teheran',107233); INSERT INTO `City` VALUES (1433,'Andimeshk','IRN','Khuzestan',106923); INSERT INTO `City` VALUES (1434,'Khorramshahr','IRN','Khuzestan',105636); INSERT INTO `City` VALUES (1435,'Shahrud','IRN','Semnan',104765); INSERT INTO `City` VALUES (1436,'Marv Dasht','IRN','Fars',103579); INSERT INTO `City` VALUES (1437,'Zabol','IRN','Sistan va Baluchesta',100887); INSERT INTO `City` VALUES (1438,'Shahr-e Kord','IRN','Chaharmahal va Bakht',100477); INSERT INTO `City` VALUES (1439,'Bandar-e Anzali','IRN','Gilan',98500); INSERT INTO `City` VALUES (1440,'Rafsanjan','IRN','Kerman',98300); INSERT INTO `City` VALUES (1441,'Marand','IRN','East Azerbaidzan',96400); INSERT INTO `City` VALUES (1442,'Torbat-e Heydariyeh','IRN','Khorasan',94600); INSERT INTO `City` VALUES (1443,'Jahrom','IRN','Fars',94200); INSERT INTO `City` VALUES (1444,'Semnan','IRN','Semnan',91045); INSERT INTO `City` VALUES (1445,'Miandoab','IRN','West Azerbaidzan',90100); INSERT INTO `City` VALUES (1446,'Qomsheh','IRN','Esfahan',89800); INSERT INTO `City` VALUES (1447,'Dublin','IRL','Leinster',481854); INSERT INTO `City` VALUES (1448,'Cork','IRL','Munster',127187); INSERT INTO `City` VALUES (1449,'Reykjavík','ISL','Höfuðborgarsvæði',109184); INSERT INTO `City` VALUES (1450,'Jerusalem','ISR','Jerusalem',633700); INSERT INTO `City` VALUES (1451,'Tel Aviv-Jaffa','ISR','Tel Aviv',348100); INSERT INTO `City` VALUES (1452,'Haifa','ISR','Haifa',265700); INSERT INTO `City` VALUES (1453,'Rishon Le Ziyyon','ISR','Ha Merkaz',188200); INSERT INTO `City` VALUES (1454,'Beerseba','ISR','Ha Darom',163700); INSERT INTO `City` VALUES (1455,'Holon','ISR','Tel Aviv',163100); INSERT INTO `City` VALUES (1456,'Petah Tiqwa','ISR','Ha Merkaz',159400); INSERT INTO `City` VALUES (1457,'Ashdod','ISR','Ha Darom',155800); INSERT INTO `City` VALUES (1458,'Netanya','ISR','Ha Merkaz',154900); INSERT INTO `City` VALUES (1459,'Bat Yam','ISR','Tel Aviv',137000); INSERT INTO `City` VALUES (1460,'Bene Beraq','ISR','Tel Aviv',133900); INSERT INTO `City` VALUES (1461,'Ramat Gan','ISR','Tel Aviv',126900); INSERT INTO `City` VALUES (1462,'Ashqelon','ISR','Ha Darom',92300); INSERT INTO `City` VALUES (1463,'Rehovot','ISR','Ha Merkaz',90300); INSERT INTO `City` VALUES (1464,'Roma','ITA','Latium',2643581); INSERT INTO `City` VALUES (1465,'Milano','ITA','Lombardia',1300977); INSERT INTO `City` VALUES (1466,'Napoli','ITA','Campania',1002619); INSERT INTO `City` VALUES (1467,'Torino','ITA','Piemonte',903705); INSERT INTO `City` VALUES (1468,'Palermo','ITA','Sisilia',683794); INSERT INTO `City` VALUES (1469,'Genova','ITA','Liguria',636104); INSERT INTO `City` VALUES (1470,'Bologna','ITA','Emilia-Romagna',381161); INSERT INTO `City` VALUES (1471,'Firenze','ITA','Toscana',376662); INSERT INTO `City` VALUES (1472,'Catania','ITA','Sisilia',337862); INSERT INTO `City` VALUES (1473,'Bari','ITA','Apulia',331848); INSERT INTO `City` VALUES (1474,'Venezia','ITA','Veneto',277305); INSERT INTO `City` VALUES (1475,'Messina','ITA','Sisilia',259156); INSERT INTO `City` VALUES (1476,'Verona','ITA','Veneto',255268); INSERT INTO `City` VALUES (1477,'Trieste','ITA','Friuli-Venezia Giuli',216459); INSERT INTO `City` VALUES (1478,'Padova','ITA','Veneto',211391); INSERT INTO `City` VALUES (1479,'Taranto','ITA','Apulia',208214); INSERT INTO `City` VALUES (1480,'Brescia','ITA','Lombardia',191317); INSERT INTO `City` VALUES (1481,'Reggio di Calabria','ITA','Calabria',179617); INSERT INTO `City` VALUES (1482,'Modena','ITA','Emilia-Romagna',176022); INSERT INTO `City` VALUES (1483,'Prato','ITA','Toscana',172473); INSERT INTO `City` VALUES (1484,'Parma','ITA','Emilia-Romagna',168717); INSERT INTO `City` VALUES (1485,'Cagliari','ITA','Sardinia',165926); INSERT INTO `City` VALUES (1486,'Livorno','ITA','Toscana',161673); INSERT INTO `City` VALUES (1487,'Perugia','ITA','Umbria',156673); INSERT INTO `City` VALUES (1488,'Foggia','ITA','Apulia',154891); INSERT INTO `City` VALUES (1489,'Reggio nell´ Emilia','ITA','Emilia-Romagna',143664); INSERT INTO `City` VALUES (1490,'Salerno','ITA','Campania',142055); INSERT INTO `City` VALUES (1491,'Ravenna','ITA','Emilia-Romagna',138418); INSERT INTO `City` VALUES (1492,'Ferrara','ITA','Emilia-Romagna',132127); INSERT INTO `City` VALUES (1493,'Rimini','ITA','Emilia-Romagna',131062); INSERT INTO `City` VALUES (1494,'Syrakusa','ITA','Sisilia',126282); INSERT INTO `City` VALUES (1495,'Sassari','ITA','Sardinia',120803); INSERT INTO `City` VALUES (1496,'Monza','ITA','Lombardia',119516); INSERT INTO `City` VALUES (1497,'Bergamo','ITA','Lombardia',117837); INSERT INTO `City` VALUES (1498,'Pescara','ITA','Abruzzit',115698); INSERT INTO `City` VALUES (1499,'Latina','ITA','Latium',114099); INSERT INTO `City` VALUES (1500,'Vicenza','ITA','Veneto',109738); INSERT INTO `City` VALUES (1501,'Terni','ITA','Umbria',107770); INSERT INTO `City` VALUES (1502,'Forlì','ITA','Emilia-Romagna',107475); INSERT INTO `City` VALUES (1503,'Trento','ITA','Trentino-Alto Adige',104906); INSERT INTO `City` VALUES (1504,'Novara','ITA','Piemonte',102037); INSERT INTO `City` VALUES (1505,'Piacenza','ITA','Emilia-Romagna',98384); INSERT INTO `City` VALUES (1506,'Ancona','ITA','Marche',98329); INSERT INTO `City` VALUES (1507,'Lecce','ITA','Apulia',98208); INSERT INTO `City` VALUES (1508,'Bolzano','ITA','Trentino-Alto Adige',97232); INSERT INTO `City` VALUES (1509,'Catanzaro','ITA','Calabria',96700); INSERT INTO `City` VALUES (1510,'La Spezia','ITA','Liguria',95504); INSERT INTO `City` VALUES (1511,'Udine','ITA','Friuli-Venezia Giuli',94932); INSERT INTO `City` VALUES (1512,'Torre del Greco','ITA','Campania',94505); INSERT INTO `City` VALUES (1513,'Andria','ITA','Apulia',94443); INSERT INTO `City` VALUES (1514,'Brindisi','ITA','Apulia',93454); INSERT INTO `City` VALUES (1515,'Giugliano in Campania','ITA','Campania',93286); INSERT INTO `City` VALUES (1516,'Pisa','ITA','Toscana',92379); INSERT INTO `City` VALUES (1517,'Barletta','ITA','Apulia',91904); INSERT INTO `City` VALUES (1518,'Arezzo','ITA','Toscana',91729); INSERT INTO `City` VALUES (1519,'Alessandria','ITA','Piemonte',90289); INSERT INTO `City` VALUES (1520,'Cesena','ITA','Emilia-Romagna',89852); INSERT INTO `City` VALUES (1521,'Pesaro','ITA','Marche',88987); INSERT INTO `City` VALUES (1522,'Dili','TMP','Dili',47900); INSERT INTO `City` VALUES (1523,'Wien','AUT','Wien',1608144); INSERT INTO `City` VALUES (1524,'Graz','AUT','Steiermark',240967); INSERT INTO `City` VALUES (1525,'Linz','AUT','North Austria',188022); INSERT INTO `City` VALUES (1526,'Salzburg','AUT','Salzburg',144247); INSERT INTO `City` VALUES (1527,'Innsbruck','AUT','Tiroli',111752); INSERT INTO `City` VALUES (1528,'Klagenfurt','AUT','Kärnten',91141); INSERT INTO `City` VALUES (1529,'Spanish Town','JAM','St. Catherine',110379); INSERT INTO `City` VALUES (1530,'Kingston','JAM','St. Andrew',103962); INSERT INTO `City` VALUES (1531,'Portmore','JAM','St. Andrew',99799); INSERT INTO `City` VALUES (1532,'Tokyo','JPN','Tokyo-to',7980230); INSERT INTO `City` VALUES (1533,'Jokohama [Yokohama]','JPN','Kanagawa',3339594); INSERT INTO `City` VALUES (1534,'Osaka','JPN','Osaka',2595674); INSERT INTO `City` VALUES (1535,'Nagoya','JPN','Aichi',2154376); INSERT INTO `City` VALUES (1536,'Sapporo','JPN','Hokkaido',1790886); INSERT INTO `City` VALUES (1537,'Kioto','JPN','Kyoto',1461974); INSERT INTO `City` VALUES (1538,'Kobe','JPN','Hyogo',1425139); INSERT INTO `City` VALUES (1539,'Fukuoka','JPN','Fukuoka',1308379); INSERT INTO `City` VALUES (1540,'Kawasaki','JPN','Kanagawa',1217359); INSERT INTO `City` VALUES (1541,'Hiroshima','JPN','Hiroshima',1119117); INSERT INTO `City` VALUES (1542,'Kitakyushu','JPN','Fukuoka',1016264); INSERT INTO `City` VALUES (1543,'Sendai','JPN','Miyagi',989975); INSERT INTO `City` VALUES (1544,'Chiba','JPN','Chiba',863930); INSERT INTO `City` VALUES (1545,'Sakai','JPN','Osaka',797735); INSERT INTO `City` VALUES (1546,'Kumamoto','JPN','Kumamoto',656734); INSERT INTO `City` VALUES (1547,'Okayama','JPN','Okayama',624269); INSERT INTO `City` VALUES (1548,'Sagamihara','JPN','Kanagawa',586300); INSERT INTO `City` VALUES (1549,'Hamamatsu','JPN','Shizuoka',568796); INSERT INTO `City` VALUES (1550,'Kagoshima','JPN','Kagoshima',549977); INSERT INTO `City` VALUES (1551,'Funabashi','JPN','Chiba',545299); INSERT INTO `City` VALUES (1552,'Higashiosaka','JPN','Osaka',517785); INSERT INTO `City` VALUES (1553,'Hachioji','JPN','Tokyo-to',513451); INSERT INTO `City` VALUES (1554,'Niigata','JPN','Niigata',497464); INSERT INTO `City` VALUES (1555,'Amagasaki','JPN','Hyogo',481434); INSERT INTO `City` VALUES (1556,'Himeji','JPN','Hyogo',475167); INSERT INTO `City` VALUES (1557,'Shizuoka','JPN','Shizuoka',473854); INSERT INTO `City` VALUES (1558,'Urawa','JPN','Saitama',469675); INSERT INTO `City` VALUES (1559,'Matsuyama','JPN','Ehime',466133); INSERT INTO `City` VALUES (1560,'Matsudo','JPN','Chiba',461126); INSERT INTO `City` VALUES (1561,'Kanazawa','JPN','Ishikawa',455386); INSERT INTO `City` VALUES (1562,'Kawaguchi','JPN','Saitama',452155); INSERT INTO `City` VALUES (1563,'Ichikawa','JPN','Chiba',441893); INSERT INTO `City` VALUES (1564,'Omiya','JPN','Saitama',441649); INSERT INTO `City` VALUES (1565,'Utsunomiya','JPN','Tochigi',440353); INSERT INTO `City` VALUES (1566,'Oita','JPN','Oita',433401); INSERT INTO `City` VALUES (1567,'Nagasaki','JPN','Nagasaki',432759); INSERT INTO `City` VALUES (1568,'Yokosuka','JPN','Kanagawa',430200); INSERT INTO `City` VALUES (1569,'Kurashiki','JPN','Okayama',425103); INSERT INTO `City` VALUES (1570,'Gifu','JPN','Gifu',408007); INSERT INTO `City` VALUES (1571,'Hirakata','JPN','Osaka',403151); INSERT INTO `City` VALUES (1572,'Nishinomiya','JPN','Hyogo',397618); INSERT INTO `City` VALUES (1573,'Toyonaka','JPN','Osaka',396689); INSERT INTO `City` VALUES (1574,'Wakayama','JPN','Wakayama',391233); INSERT INTO `City` VALUES (1575,'Fukuyama','JPN','Hiroshima',376921); INSERT INTO `City` VALUES (1576,'Fujisawa','JPN','Kanagawa',372840); INSERT INTO `City` VALUES (1577,'Asahikawa','JPN','Hokkaido',364813); INSERT INTO `City` VALUES (1578,'Machida','JPN','Tokyo-to',364197); INSERT INTO `City` VALUES (1579,'Nara','JPN','Nara',362812); INSERT INTO `City` VALUES (1580,'Takatsuki','JPN','Osaka',361747); INSERT INTO `City` VALUES (1581,'Iwaki','JPN','Fukushima',361737); INSERT INTO `City` VALUES (1582,'Nagano','JPN','Nagano',361391); INSERT INTO `City` VALUES (1583,'Toyohashi','JPN','Aichi',360066); INSERT INTO `City` VALUES (1584,'Toyota','JPN','Aichi',346090); INSERT INTO `City` VALUES (1585,'Suita','JPN','Osaka',345750); INSERT INTO `City` VALUES (1586,'Takamatsu','JPN','Kagawa',332471); INSERT INTO `City` VALUES (1587,'Koriyama','JPN','Fukushima',330335); INSERT INTO `City` VALUES (1588,'Okazaki','JPN','Aichi',328711); INSERT INTO `City` VALUES (1589,'Kawagoe','JPN','Saitama',327211); INSERT INTO `City` VALUES (1590,'Tokorozawa','JPN','Saitama',325809); INSERT INTO `City` VALUES (1591,'Toyama','JPN','Toyama',325790); INSERT INTO `City` VALUES (1592,'Kochi','JPN','Kochi',324710); INSERT INTO `City` VALUES (1593,'Kashiwa','JPN','Chiba',320296); INSERT INTO `City` VALUES (1594,'Akita','JPN','Akita',314440); INSERT INTO `City` VALUES (1595,'Miyazaki','JPN','Miyazaki',303784); INSERT INTO `City` VALUES (1596,'Koshigaya','JPN','Saitama',301446); INSERT INTO `City` VALUES (1597,'Naha','JPN','Okinawa',299851); INSERT INTO `City` VALUES (1598,'Aomori','JPN','Aomori',295969); INSERT INTO `City` VALUES (1599,'Hakodate','JPN','Hokkaido',294788); INSERT INTO `City` VALUES (1600,'Akashi','JPN','Hyogo',292253); INSERT INTO `City` VALUES (1601,'Yokkaichi','JPN','Mie',288173); INSERT INTO `City` VALUES (1602,'Fukushima','JPN','Fukushima',287525); INSERT INTO `City` VALUES (1603,'Morioka','JPN','Iwate',287353); INSERT INTO `City` VALUES (1604,'Maebashi','JPN','Gumma',284473); INSERT INTO `City` VALUES (1605,'Kasugai','JPN','Aichi',282348); INSERT INTO `City` VALUES (1606,'Otsu','JPN','Shiga',282070); INSERT INTO `City` VALUES (1607,'Ichihara','JPN','Chiba',279280); INSERT INTO `City` VALUES (1608,'Yao','JPN','Osaka',276421); INSERT INTO `City` VALUES (1609,'Ichinomiya','JPN','Aichi',270828); INSERT INTO `City` VALUES (1610,'Tokushima','JPN','Tokushima',269649); INSERT INTO `City` VALUES (1611,'Kakogawa','JPN','Hyogo',266281); INSERT INTO `City` VALUES (1612,'Ibaraki','JPN','Osaka',261020); INSERT INTO `City` VALUES (1613,'Neyagawa','JPN','Osaka',257315); INSERT INTO `City` VALUES (1614,'Shimonoseki','JPN','Yamaguchi',257263); INSERT INTO `City` VALUES (1615,'Yamagata','JPN','Yamagata',255617); INSERT INTO `City` VALUES (1616,'Fukui','JPN','Fukui',254818); INSERT INTO `City` VALUES (1617,'Hiratsuka','JPN','Kanagawa',254207); INSERT INTO `City` VALUES (1618,'Mito','JPN','Ibaragi',246559); INSERT INTO `City` VALUES (1619,'Sasebo','JPN','Nagasaki',244240); INSERT INTO `City` VALUES (1620,'Hachinohe','JPN','Aomori',242979); INSERT INTO `City` VALUES (1621,'Takasaki','JPN','Gumma',239124); INSERT INTO `City` VALUES (1622,'Shimizu','JPN','Shizuoka',239123); INSERT INTO `City` VALUES (1623,'Kurume','JPN','Fukuoka',235611); INSERT INTO `City` VALUES (1624,'Fuji','JPN','Shizuoka',231527); INSERT INTO `City` VALUES (1625,'Soka','JPN','Saitama',222768); INSERT INTO `City` VALUES (1626,'Fuchu','JPN','Tokyo-to',220576); INSERT INTO `City` VALUES (1627,'Chigasaki','JPN','Kanagawa',216015); INSERT INTO `City` VALUES (1628,'Atsugi','JPN','Kanagawa',212407); INSERT INTO `City` VALUES (1629,'Numazu','JPN','Shizuoka',211382); INSERT INTO `City` VALUES (1630,'Ageo','JPN','Saitama',209442); INSERT INTO `City` VALUES (1631,'Yamato','JPN','Kanagawa',208234); INSERT INTO `City` VALUES (1632,'Matsumoto','JPN','Nagano',206801); INSERT INTO `City` VALUES (1633,'Kure','JPN','Hiroshima',206504); INSERT INTO `City` VALUES (1634,'Takarazuka','JPN','Hyogo',205993); INSERT INTO `City` VALUES (1635,'Kasukabe','JPN','Saitama',201838); INSERT INTO `City` VALUES (1636,'Chofu','JPN','Tokyo-to',201585); INSERT INTO `City` VALUES (1637,'Odawara','JPN','Kanagawa',200171); INSERT INTO `City` VALUES (1638,'Kofu','JPN','Yamanashi',199753); INSERT INTO `City` VALUES (1639,'Kushiro','JPN','Hokkaido',197608); INSERT INTO `City` VALUES (1640,'Kishiwada','JPN','Osaka',197276); INSERT INTO `City` VALUES (1641,'Hitachi','JPN','Ibaragi',196622); INSERT INTO `City` VALUES (1642,'Nagaoka','JPN','Niigata',192407); INSERT INTO `City` VALUES (1643,'Itami','JPN','Hyogo',190886); INSERT INTO `City` VALUES (1644,'Uji','JPN','Kyoto',188735); INSERT INTO `City` VALUES (1645,'Suzuka','JPN','Mie',184061); INSERT INTO `City` VALUES (1646,'Hirosaki','JPN','Aomori',177522); INSERT INTO `City` VALUES (1647,'Ube','JPN','Yamaguchi',175206); INSERT INTO `City` VALUES (1648,'Kodaira','JPN','Tokyo-to',174984); INSERT INTO `City` VALUES (1649,'Takaoka','JPN','Toyama',174380); INSERT INTO `City` VALUES (1650,'Obihiro','JPN','Hokkaido',173685); INSERT INTO `City` VALUES (1651,'Tomakomai','JPN','Hokkaido',171958); INSERT INTO `City` VALUES (1652,'Saga','JPN','Saga',170034); INSERT INTO `City` VALUES (1653,'Sakura','JPN','Chiba',168072); INSERT INTO `City` VALUES (1654,'Kamakura','JPN','Kanagawa',167661); INSERT INTO `City` VALUES (1655,'Mitaka','JPN','Tokyo-to',167268); INSERT INTO `City` VALUES (1656,'Izumi','JPN','Osaka',166979); INSERT INTO `City` VALUES (1657,'Hino','JPN','Tokyo-to',166770); INSERT INTO `City` VALUES (1658,'Hadano','JPN','Kanagawa',166512); INSERT INTO `City` VALUES (1659,'Ashikaga','JPN','Tochigi',165243); INSERT INTO `City` VALUES (1660,'Tsu','JPN','Mie',164543); INSERT INTO `City` VALUES (1661,'Sayama','JPN','Saitama',162472); INSERT INTO `City` VALUES (1662,'Yachiyo','JPN','Chiba',161222); INSERT INTO `City` VALUES (1663,'Tsukuba','JPN','Ibaragi',160768); INSERT INTO `City` VALUES (1664,'Tachikawa','JPN','Tokyo-to',159430); INSERT INTO `City` VALUES (1665,'Kumagaya','JPN','Saitama',157171); INSERT INTO `City` VALUES (1666,'Moriguchi','JPN','Osaka',155941); INSERT INTO `City` VALUES (1667,'Otaru','JPN','Hokkaido',155784); INSERT INTO `City` VALUES (1668,'Anjo','JPN','Aichi',153823); INSERT INTO `City` VALUES (1669,'Narashino','JPN','Chiba',152849); INSERT INTO `City` VALUES (1670,'Oyama','JPN','Tochigi',152820); INSERT INTO `City` VALUES (1671,'Ogaki','JPN','Gifu',151758); INSERT INTO `City` VALUES (1672,'Matsue','JPN','Shimane',149821); INSERT INTO `City` VALUES (1673,'Kawanishi','JPN','Hyogo',149794); INSERT INTO `City` VALUES (1674,'Hitachinaka','JPN','Tokyo-to',148006); INSERT INTO `City` VALUES (1675,'Niiza','JPN','Saitama',147744); INSERT INTO `City` VALUES (1676,'Nagareyama','JPN','Chiba',147738); INSERT INTO `City` VALUES (1677,'Tottori','JPN','Tottori',147523); INSERT INTO `City` VALUES (1678,'Tama','JPN','Ibaragi',146712); INSERT INTO `City` VALUES (1679,'Iruma','JPN','Saitama',145922); INSERT INTO `City` VALUES (1680,'Ota','JPN','Gumma',145317); INSERT INTO `City` VALUES (1681,'Omuta','JPN','Fukuoka',142889); INSERT INTO `City` VALUES (1682,'Komaki','JPN','Aichi',139827); INSERT INTO `City` VALUES (1683,'Ome','JPN','Tokyo-to',139216); INSERT INTO `City` VALUES (1684,'Kadoma','JPN','Osaka',138953); INSERT INTO `City` VALUES (1685,'Yamaguchi','JPN','Yamaguchi',138210); INSERT INTO `City` VALUES (1686,'Higashimurayama','JPN','Tokyo-to',136970); INSERT INTO `City` VALUES (1687,'Yonago','JPN','Tottori',136461); INSERT INTO `City` VALUES (1688,'Matsubara','JPN','Osaka',135010); INSERT INTO `City` VALUES (1689,'Musashino','JPN','Tokyo-to',134426); INSERT INTO `City` VALUES (1690,'Tsuchiura','JPN','Ibaragi',134072); INSERT INTO `City` VALUES (1691,'Joetsu','JPN','Niigata',133505); INSERT INTO `City` VALUES (1692,'Miyakonojo','JPN','Miyazaki',133183); INSERT INTO `City` VALUES (1693,'Misato','JPN','Saitama',132957); INSERT INTO `City` VALUES (1694,'Kakamigahara','JPN','Gifu',131831); INSERT INTO `City` VALUES (1695,'Daito','JPN','Osaka',130594); INSERT INTO `City` VALUES (1696,'Seto','JPN','Aichi',130470); INSERT INTO `City` VALUES (1697,'Kariya','JPN','Aichi',127969); INSERT INTO `City` VALUES (1698,'Urayasu','JPN','Chiba',127550); INSERT INTO `City` VALUES (1699,'Beppu','JPN','Oita',127486); INSERT INTO `City` VALUES (1700,'Niihama','JPN','Ehime',127207); INSERT INTO `City` VALUES (1701,'Minoo','JPN','Osaka',127026); INSERT INTO `City` VALUES (1702,'Fujieda','JPN','Shizuoka',126897); INSERT INTO `City` VALUES (1703,'Abiko','JPN','Chiba',126670); INSERT INTO `City` VALUES (1704,'Nobeoka','JPN','Miyazaki',125547); INSERT INTO `City` VALUES (1705,'Tondabayashi','JPN','Osaka',125094); INSERT INTO `City` VALUES (1706,'Ueda','JPN','Nagano',124217); INSERT INTO `City` VALUES (1707,'Kashihara','JPN','Nara',124013); INSERT INTO `City` VALUES (1708,'Matsusaka','JPN','Mie',123582); INSERT INTO `City` VALUES (1709,'Isesaki','JPN','Gumma',123285); INSERT INTO `City` VALUES (1710,'Zama','JPN','Kanagawa',122046); INSERT INTO `City` VALUES (1711,'Kisarazu','JPN','Chiba',121967); INSERT INTO `City` VALUES (1712,'Noda','JPN','Chiba',121030); INSERT INTO `City` VALUES (1713,'Ishinomaki','JPN','Miyagi',120963); INSERT INTO `City` VALUES (1714,'Fujinomiya','JPN','Shizuoka',119714); INSERT INTO `City` VALUES (1715,'Kawachinagano','JPN','Osaka',119666); INSERT INTO `City` VALUES (1716,'Imabari','JPN','Ehime',119357); INSERT INTO `City` VALUES (1717,'Aizuwakamatsu','JPN','Fukushima',119287); INSERT INTO `City` VALUES (1718,'Higashihiroshima','JPN','Hiroshima',119166); INSERT INTO `City` VALUES (1719,'Habikino','JPN','Osaka',118968); INSERT INTO `City` VALUES (1720,'Ebetsu','JPN','Hokkaido',118805); INSERT INTO `City` VALUES (1721,'Hofu','JPN','Yamaguchi',118751); INSERT INTO `City` VALUES (1722,'Kiryu','JPN','Gumma',118326); INSERT INTO `City` VALUES (1723,'Okinawa','JPN','Okinawa',117748); INSERT INTO `City` VALUES (1724,'Yaizu','JPN','Shizuoka',117258); INSERT INTO `City` VALUES (1725,'Toyokawa','JPN','Aichi',115781); INSERT INTO `City` VALUES (1726,'Ebina','JPN','Kanagawa',115571); INSERT INTO `City` VALUES (1727,'Asaka','JPN','Saitama',114815); INSERT INTO `City` VALUES (1728,'Higashikurume','JPN','Tokyo-to',111666); INSERT INTO `City` VALUES (1729,'Ikoma','JPN','Nara',111645); INSERT INTO `City` VALUES (1730,'Kitami','JPN','Hokkaido',111295); INSERT INTO `City` VALUES (1731,'Koganei','JPN','Tokyo-to',110969); INSERT INTO `City` VALUES (1732,'Iwatsuki','JPN','Saitama',110034); INSERT INTO `City` VALUES (1733,'Mishima','JPN','Shizuoka',109699); INSERT INTO `City` VALUES (1734,'Handa','JPN','Aichi',108600); INSERT INTO `City` VALUES (1735,'Muroran','JPN','Hokkaido',108275); INSERT INTO `City` VALUES (1736,'Komatsu','JPN','Ishikawa',107937); INSERT INTO `City` VALUES (1737,'Yatsushiro','JPN','Kumamoto',107661); INSERT INTO `City` VALUES (1738,'Iida','JPN','Nagano',107583); INSERT INTO `City` VALUES (1739,'Tokuyama','JPN','Yamaguchi',107078); INSERT INTO `City` VALUES (1740,'Kokubunji','JPN','Tokyo-to',106996); INSERT INTO `City` VALUES (1741,'Akishima','JPN','Tokyo-to',106914); INSERT INTO `City` VALUES (1742,'Iwakuni','JPN','Yamaguchi',106647); INSERT INTO `City` VALUES (1743,'Kusatsu','JPN','Shiga',106232); INSERT INTO `City` VALUES (1744,'Kuwana','JPN','Mie',106121); INSERT INTO `City` VALUES (1745,'Sanda','JPN','Hyogo',105643); INSERT INTO `City` VALUES (1746,'Hikone','JPN','Shiga',105508); INSERT INTO `City` VALUES (1747,'Toda','JPN','Saitama',103969); INSERT INTO `City` VALUES (1748,'Tajimi','JPN','Gifu',103171); INSERT INTO `City` VALUES (1749,'Ikeda','JPN','Osaka',102710); INSERT INTO `City` VALUES (1750,'Fukaya','JPN','Saitama',102156); INSERT INTO `City` VALUES (1751,'Ise','JPN','Mie',101732); INSERT INTO `City` VALUES (1752,'Sakata','JPN','Yamagata',101651); INSERT INTO `City` VALUES (1753,'Kasuga','JPN','Fukuoka',101344); INSERT INTO `City` VALUES (1754,'Kamagaya','JPN','Chiba',100821); INSERT INTO `City` VALUES (1755,'Tsuruoka','JPN','Yamagata',100713); INSERT INTO `City` VALUES (1756,'Hoya','JPN','Tokyo-to',100313); INSERT INTO `City` VALUES (1757,'Nishio','JPN','Chiba',100032); INSERT INTO `City` VALUES (1758,'Tokai','JPN','Aichi',99738); INSERT INTO `City` VALUES (1759,'Inazawa','JPN','Aichi',98746); INSERT INTO `City` VALUES (1760,'Sakado','JPN','Saitama',98221); INSERT INTO `City` VALUES (1761,'Isehara','JPN','Kanagawa',98123); INSERT INTO `City` VALUES (1762,'Takasago','JPN','Hyogo',97632); INSERT INTO `City` VALUES (1763,'Fujimi','JPN','Saitama',96972); INSERT INTO `City` VALUES (1764,'Urasoe','JPN','Okinawa',96002); INSERT INTO `City` VALUES (1765,'Yonezawa','JPN','Yamagata',95592); INSERT INTO `City` VALUES (1766,'Konan','JPN','Aichi',95521); INSERT INTO `City` VALUES (1767,'Yamatokoriyama','JPN','Nara',95165); INSERT INTO `City` VALUES (1768,'Maizuru','JPN','Kyoto',94784); INSERT INTO `City` VALUES (1769,'Onomichi','JPN','Hiroshima',93756); INSERT INTO `City` VALUES (1770,'Higashimatsuyama','JPN','Saitama',93342); INSERT INTO `City` VALUES (1771,'Kimitsu','JPN','Chiba',93216); INSERT INTO `City` VALUES (1772,'Isahaya','JPN','Nagasaki',93058); INSERT INTO `City` VALUES (1773,'Kanuma','JPN','Tochigi',93053); INSERT INTO `City` VALUES (1774,'Izumisano','JPN','Osaka',92583); INSERT INTO `City` VALUES (1775,'Kameoka','JPN','Kyoto',92398); INSERT INTO `City` VALUES (1776,'Mobara','JPN','Chiba',91664); INSERT INTO `City` VALUES (1777,'Narita','JPN','Chiba',91470); INSERT INTO `City` VALUES (1778,'Kashiwazaki','JPN','Niigata',91229); INSERT INTO `City` VALUES (1779,'Tsuyama','JPN','Okayama',91170); INSERT INTO `City` VALUES (1780,'Sanaa','YEM','Sanaa',503600); INSERT INTO `City` VALUES (1781,'Aden','YEM','Aden',398300); INSERT INTO `City` VALUES (1782,'Taizz','YEM','Taizz',317600); INSERT INTO `City` VALUES (1783,'Hodeida','YEM','Hodeida',298500); INSERT INTO `City` VALUES (1784,'al-Mukalla','YEM','Hadramawt',122400); INSERT INTO `City` VALUES (1785,'Ibb','YEM','Ibb',103300); INSERT INTO `City` VALUES (1786,'Amman','JOR','Amman',1000000); INSERT INTO `City` VALUES (1787,'al-Zarqa','JOR','al-Zarqa',389815); INSERT INTO `City` VALUES (1788,'Irbid','JOR','Irbid',231511); INSERT INTO `City` VALUES (1789,'al-Rusayfa','JOR','al-Zarqa',137247); INSERT INTO `City` VALUES (1790,'Wadi al-Sir','JOR','Amman',89104); INSERT INTO `City` VALUES (1791,'Flying Fish Cove','CXR','–',700); INSERT INTO `City` VALUES (1792,'Beograd','YUG','Central Serbia',1204000); INSERT INTO `City` VALUES (1793,'Novi Sad','YUG','Vojvodina',179626); INSERT INTO `City` VALUES (1794,'Niš','YUG','Central Serbia',175391); INSERT INTO `City` VALUES (1795,'Priština','YUG','Kosovo and Metohija',155496); INSERT INTO `City` VALUES (1796,'Kragujevac','YUG','Central Serbia',147305); INSERT INTO `City` VALUES (1797,'Podgorica','YUG','Montenegro',135000); INSERT INTO `City` VALUES (1798,'Subotica','YUG','Vojvodina',100386); INSERT INTO `City` VALUES (1799,'Prizren','YUG','Kosovo and Metohija',92303); INSERT INTO `City` VALUES (1800,'Phnom Penh','KHM','Phnom Penh',570155); INSERT INTO `City` VALUES (1801,'Battambang','KHM','Battambang',129800); INSERT INTO `City` VALUES (1802,'Siem Reap','KHM','Siem Reap',105100); INSERT INTO `City` VALUES (1803,'Douala','CMR','Littoral