-- DB2 verion of MySQL world database script
-- Creates both world and world2 (same as world except tables empty)
-- It is assumed you have the appropriated privleges to run this script;
-- from db2 command window execute via  db2 -t -v -f "DB2 world and world2.txt"
-- If you have errors add the -s option so that the script will stop after the error
-- You may also need to user 'db2 terminate' to terminate db2 backend process if something is hanging

-- Some changes have been made to the city data compared to the MySQL file for purposes
-- of using the DBCompare option. After loading and running DBCompare, I realized there are 
-- also some other differences, due to different character code sets used between DB2 and MySQL???

connect reset;
drop database world;

Create database world;
-- connect to world user your_userid password your_password;
connect to world;

--
-- Table structure for table `City`
--

CREATE TABLE City (ID integer NOT NULL,
    Name char(35) NOT NULL default ' ',
    CountryCode char(3) NOT NULL default ' ',
    District char(20) NOT NULL default ' ',
    Population integer NOT NULL default 0);

Create unique index city_ix on city (ID);

--
-- Table structure for table Country 
--

CREATE TABLE Country  (
  Code char(3) NOT NULL default ' ',
  Name char(52) NOT NULL default ' ',
  Continent Char(20) NOT NULL,
  Region char(26) NOT NULL default ' ',
  SurfaceArea decimal(10,2) NOT NULL default 0.00,
  IndepYear smallint default NULL,
  Population int NOT NULL default 0,
  LifeExpectancy decimal(3,1) default NULL,
  GNP decimal(10,2) default NULL,
  GNPOld decimal(10,2) default NULL,
  LocalName char(45) NOT NULL default ' ',
  GovernmentForm char(45) NOT NULL default ' ',
  HeadOfState char(60) default NULL,
  Capital int default NULL,
  Code2 char(2) NOT NULL default ' ');

create unique index country_ix on country (Code);

--
-- Table structure for table `CountryLanguage`
--

CREATE TABLE CountryLanguage (
  CountryCode char(3) NOT NULL default ' ',
  Language char(30) NOT NULL default '',
  IsOfficial char(1) NOT NULL default 'F',
  Percentage decimal(4,1) NOT NULL default 0.0);


create unique index CountryLanguage_ix on CountryLanguage (CountryCode, Language);




--
-- Dumping data for table `City`
--

INSERT INTO City VALUES (1,'Kabul','AFG','Kabol',1790000);
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','NLD','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',462000);
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,'Rotherrham','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',1448300);
INSERT INTO City VALUES (1804,'Yaoundé','CMR','Centre',1372800);
INSERT INTO City VALUES (1805,'Garoua','CMR','Nord',177000);
INSERT INTO City VALUES (1806,'Maroua','CMR','Extrême-Nord',143000);
INSERT INTO City VALUES (1807,'Bamenda','CMR','Nord-Ouest',138000);
INSERT INTO City VALUES (1808,'Bafoussam','CMR','Ouest',131000);
INSERT INTO City VALUES (1809,'Nkongsamba','CMR','Littoral',112454);
INSERT INTO City VALUES (1810,'Montréal','CAN','Québec',1016376);
INSERT INTO City VALUES (1811,'Calgary','CAN','Alberta',768082);
INSERT INTO City VALUES (1812,'Toronto','CAN','Ontario',688275);
INSERT INTO City VALUES (1813,'North York','CAN','Ontario',622632);
INSERT INTO City VALUES (1814,'Winnipeg','CAN','Manitoba',618477);
INSERT INTO City VALUES (1815,'Edmonton','CAN','Alberta',616306);
INSERT INTO City VALUES (1816,'Mississauga','CAN','Ontario',608072);
INSERT INTO City VALUES (1817,'Scarborough','CAN','Ontario',594501);
INSERT INTO City VALUES (1818,'Vancouver','CAN','British Colombia',514008);
INSERT INTO City VALUES (1819,'Etobicoke','CAN','Ontario',348845);
INSERT INTO City VALUES (1820,'London','CAN','Ontario',339917);
INSERT INTO City VALUES (1821,'Hamilton','CAN','Ontario',335614);
INSERT INTO City VALUES (1822,'Ottawa','CAN','Ontario',335277);
INSERT INTO City VALUES (1823,'Laval','CAN','Québec',330393);
INSERT INTO City VALUES (1824,'Surrey','CAN','British Colombia',304477);
INSERT INTO City VALUES (1825,'Brampton','CAN','Ontario',296711);
INSERT INTO City VALUES (1826,'Windsor','CAN','Ontario',207588);
INSERT INTO City VALUES (1827,'Saskatoon','CAN','Saskatchewan',193647);
INSERT INTO City VALUES (1828,'Kitchener','CAN','Ontario',189959);
INSERT INTO City VALUES (1829,'Markham','CAN','Ontario',189098);
INSERT INTO City VALUES (1830,'Regina','CAN','Saskatchewan',180400);
INSERT INTO City VALUES (1831,'Burnaby','CAN','British Colombia',179209);
INSERT INTO City VALUES (1832,'Québec','CAN','Québec',167264);
INSERT INTO City VALUES (1833,'York','CAN','Ontario',154980);
INSERT INTO City VALUES (1834,'Richmond','CAN','British Colombia',148867);
INSERT INTO City VALUES (1835,'Vaughan','CAN','Ontario',147889);
INSERT INTO City VALUES (1836,'Burlington','CAN','Ontario',145150);
INSERT INTO City VALUES (1837,'Oshawa','CAN','Ontario',140173);
INSERT INTO City VALUES (1838,'Oakville','CAN','Ontario',139192);
INSERT INTO City VALUES (1839,'Saint Catharines','CAN','Ontario',136216);
INSERT INTO City VALUES (1840,'Longueuil','CAN','Québec',127977);
INSERT INTO City VALUES (1841,'Richmond Hill','CAN','Ontario',116428);
INSERT INTO City VALUES (1842,'Thunder Bay','CAN','Ontario',115913);
INSERT INTO City VALUES (1843,'Nepean','CAN','Ontario',115100);
INSERT INTO City VALUES (1844,'Cape Breton','CAN','Nova Scotia',114733);
INSERT INTO City VALUES (1845,'East York','CAN','Ontario',114034);
INSERT INTO City VALUES (1846,'Halifax','CAN','Nova Scotia',113910);
INSERT INTO City VALUES (1847,'Cambridge','CAN','Ontario',109186);
INSERT INTO City VALUES (1848,'Glouce