blob: 829fba12abeafcff22e394e575f46c1d96299ebc [file] [log] [blame]
DROP TABLE IF EXISTS Country;
CREATE TABLE Country (
Code CHAR(3) PRIMARY KEY,
Name VARCHAR,
Continent VARCHAR,
Region VARCHAR,
SurfaceArea DECIMAL(10,2),
IndepYear SMALLINT,
Population INT,
LifeExpectancy DECIMAL(3,1),
GNP DECIMAL(10,2),
GNPOld DECIMAL(10,2),
LocalName VARCHAR,
GovernmentForm VARCHAR,
HeadOfState VARCHAR,
Capital INT,
Code2 CHAR(2)
) WITH "template=partitioned, backups=1, CACHE_NAME=Country, VALUE_TYPE=demo.model.Country";
DROP TABLE IF EXISTS City;
CREATE TABLE City (
ID INT,
Name VARCHAR,
CountryCode CHAR(3),
District VARCHAR,
Population INT,
PRIMARY KEY (ID, CountryCode)
) WITH "template=partitioned, backups=1, affinityKey=CountryCode, CACHE_NAME=City, KEY_TYPE=demo.model.CityKey, VALUE_TYPE=demo.model.City";
CREATE INDEX idx_country_code ON city (CountryCode);
DROP TABLE IF EXISTS CountryLanguage;
CREATE TABLE CountryLanguage (
CountryCode CHAR(3),
Language VARCHAR,
IsOfficial CHAR(2),
Percentage DECIMAL(4,1),
PRIMARY KEY (CountryCode, Language)
) WITH "template=partitioned, backups=1, affinityKey=CountryCode, CACHE_NAME=CountryLng, KEY_TYPE=demo.model.CountryLngKey, VALUE_TYPE=demo.model.CountryLng";
CREATE INDEX idx_lang_country_code ON CountryLanguage (CountryCode);
SET STREAMING ON;
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (1,'Kabul','AFG','Kabol',1780000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (2,'Qandahar','AFG','Qandahar',237500);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (3,'Herat','AFG','Herat',186800);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (4,'Mazar-e-Sharif','AFG','Balkh',127800);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (5,'Amsterdam','NLD','Noord-Holland',731200);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (6,'Rotterdam','NLD','Zuid-Holland',593321);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (7,'Haag','NLD','Zuid-Holland',440900);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (8,'Utrecht','NLD','Utrecht',234323);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (9,'Eindhoven','NLD','Noord-Brabant',201843);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (10,'Tilburg','NLD','Noord-Brabant',193238);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (11,'Groningen','NLD','Groningen',172701);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (12,'Breda','NLD','Noord-Brabant',160398);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (13,'Apeldoorn','NLD','Gelderland',153491);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (14,'Nijmegen','NLD','Gelderland',152463);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (15,'Enschede','NLD','Overijssel',149544);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (16,'Haarlem','NLD','Noord-Holland',148772);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (17,'Almere','NLD','Flevoland',142465);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (18,'Arnhem','NLD','Gelderland',138020);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (19,'Zaanstad','NLD','Noord-Holland',135621);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (20,'´s-Hertogenbosch','NLD','Noord-Brabant',129170);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (21,'Amersfoort','NLD','Utrecht',126270);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (22,'Maastricht','NLD','Limburg',122087);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (23,'Dordrecht','NLD','Zuid-Holland',119811);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (24,'Leiden','NLD','Zuid-Holland',117196);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (25,'Haarlemmermeer','NLD','Noord-Holland',110722);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (26,'Zoetermeer','NLD','Zuid-Holland',110214);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (27,'Emmen','NLD','Drenthe',105853);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (28,'Zwolle','NLD','Overijssel',105819);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (29,'Ede','NLD','Gelderland',101574);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (30,'Delft','NLD','Zuid-Holland',95268);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (31,'Heerlen','NLD','Limburg',95052);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (32,'Alkmaar','NLD','Noord-Holland',92713);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (33,'Willemstad','ANT','Curaçao',2345);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (34,'Tirana','ALB','Tirana',270000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (35,'Alger','DZA','Alger',2168000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (36,'Oran','DZA','Oran',609823);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (37,'Constantine','DZA','Constantine',443727);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (38,'Annaba','DZA','Annaba',222518);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (39,'Batna','DZA','Batna',183377);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (40,'Sétif','DZA','Sétif',179055);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (41,'Sidi Bel Abbès','DZA','Sidi Bel Abbès',153106);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (42,'Skikda','DZA','Skikda',128747);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (43,'Biskra','DZA','Biskra',128281);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (44,'Blida (el-Boulaida)','DZA','Blida',127284);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (45,'Béjaïa','DZA','Béjaïa',117162);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (46,'Mostaganem','DZA','Mostaganem',115212);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (47,'Tébessa','DZA','Tébessa',112007);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (48,'Tlemcen (Tilimsen)','DZA','Tlemcen',110242);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (49,'Béchar','DZA','Béchar',107311);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (50,'Tiaret','DZA','Tiaret',100118);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (51,'Ech-Chleff (el-Asnam)','DZA','Chlef',96794);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (52,'Ghardaïa','DZA','Ghardaïa',89415);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (53,'Tafuna','ASM','Tutuila',5200);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (54,'Fagatogo','ASM','Tutuila',2323);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (55,'Andorra la Vella','AND','Andorra la Vella',21189);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (56,'Luanda','AGO','Luanda',2022000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (57,'Huambo','AGO','Huambo',163100);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (58,'Lobito','AGO','Benguela',130000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (59,'Benguela','AGO','Benguela',128300);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (60,'Namibe','AGO','Namibe',118200);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (61,'South Hill','AIA','–',961);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (62,'The Valley','AIA','–',595);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (63,'Saint John´s','ATG','St John',24000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (64,'Dubai','ARE','Dubai',669181);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (65,'Abu Dhabi','ARE','Abu Dhabi',398695);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (66,'Sharja','ARE','Sharja',320095);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (67,'al-Ayn','ARE','Abu Dhabi',225970);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (68,'Ajman','ARE','Ajman',114395);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (69,'Buenos Aires','ARG','Distrito Federal',2982146);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (70,'La Matanza','ARG','Buenos Aires',1266461);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (71,'Córdoba','ARG','Córdoba',1157507);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (72,'Rosario','ARG','Santa Fé',907718);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (73,'Lomas de Zamora','ARG','Buenos Aires',622013);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (74,'Quilmes','ARG','Buenos Aires',559249);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (75,'Almirante Brown','ARG','Buenos Aires',538918);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (76,'La Plata','ARG','Buenos Aires',521936);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (77,'Mar del Plata','ARG','Buenos Aires',512880);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (78,'San Miguel de Tucumán','ARG','Tucumán',470809);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (79,'Lanús','ARG','Buenos Aires',469735);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (80,'Merlo','ARG','Buenos Aires',463846);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (81,'General San Martín','ARG','Buenos Aires',422542);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (82,'Salta','ARG','Salta',367550);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (83,'Moreno','ARG','Buenos Aires',356993);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (84,'Santa Fé','ARG','Santa Fé',353063);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (85,'Avellaneda','ARG','Buenos Aires',353046);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (86,'Tres de Febrero','ARG','Buenos Aires',352311);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (87,'Morón','ARG','Buenos Aires',349246);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (88,'Florencio Varela','ARG','Buenos Aires',315432);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (89,'San Isidro','ARG','Buenos Aires',306341);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (90,'Tigre','ARG','Buenos Aires',296226);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (91,'Malvinas Argentinas','ARG','Buenos Aires',290335);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (92,'Vicente López','ARG','Buenos Aires',288341);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (93,'Berazategui','ARG','Buenos Aires',276916);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (94,'Corrientes','ARG','Corrientes',258103);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (95,'San Miguel','ARG','Buenos Aires',248700);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (96,'Bahía Blanca','ARG','Buenos Aires',239810);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (97,'Esteban Echeverría','ARG','Buenos Aires',235760);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (98,'Resistencia','ARG','Chaco',229212);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (99,'José C. Paz','ARG','Buenos Aires',221754);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (100,'Paraná','ARG','Entre Rios',207041);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (101,'Godoy Cruz','ARG','Mendoza',206998);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (102,'Posadas','ARG','Misiones',201273);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (103,'Guaymallén','ARG','Mendoza',200595);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (104,'Santiago del Estero','ARG','Santiago del Estero',189947);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (105,'San Salvador de Jujuy','ARG','Jujuy',178748);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (106,'Hurlingham','ARG','Buenos Aires',170028);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (107,'Neuquén','ARG','Neuquén',167296);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (108,'Ituzaingó','ARG','Buenos Aires',158197);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (109,'San Fernando','ARG','Buenos Aires',153036);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (110,'Formosa','ARG','Formosa',147636);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (111,'Las Heras','ARG','Mendoza',145823);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (112,'La Rioja','ARG','La Rioja',138117);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (113,'San Fernando del Valle de Cata','ARG','Catamarca',134935);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (114,'Río Cuarto','ARG','Córdoba',134355);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (115,'Comodoro Rivadavia','ARG','Chubut',124104);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (116,'Mendoza','ARG','Mendoza',123027);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (117,'San Nicolás de los Arroyos','ARG','Buenos Aires',119302);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (118,'San Juan','ARG','San Juan',119152);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (119,'Escobar','ARG','Buenos Aires',116675);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (120,'Concordia','ARG','Entre Rios',116485);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (121,'Pilar','ARG','Buenos Aires',113428);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (122,'San Luis','ARG','San Luis',110136);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (123,'Ezeiza','ARG','Buenos Aires',99578);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (124,'San Rafael','ARG','Mendoza',94651);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (125,'Tandil','ARG','Buenos Aires',91101);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (126,'Yerevan','ARM','Yerevan',1248700);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (127,'Gjumri','ARM','Širak',211700);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (128,'Vanadzor','ARM','Lori',172700);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (129,'Oranjestad','ABW','–',29034);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (130,'Sydney','AUS','New South Wales',3276207);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (131,'Melbourne','AUS','Victoria',2865329);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (132,'Brisbane','AUS','Queensland',1291117);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (133,'Perth','AUS','West Australia',1096829);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (134,'Adelaide','AUS','South Australia',978100);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (135,'Canberra','AUS','Capital Region',322723);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (136,'Gold Coast','AUS','Queensland',311932);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (137,'Newcastle','AUS','New South Wales',270324);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (138,'Central Coast','AUS','New South Wales',227657);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (139,'Wollongong','AUS','New South Wales',219761);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (140,'Hobart','AUS','Tasmania',126118);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (141,'Geelong','AUS','Victoria',125382);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (142,'Townsville','AUS','Queensland',109914);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (143,'Cairns','AUS','Queensland',92273);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (144,'Baku','AZE','Baki',1787800);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (145,'Gäncä','AZE','Gäncä',299300);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (146,'Sumqayit','AZE','Sumqayit',283000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (147,'Mingäçevir','AZE','Mingäçevir',93900);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (148,'Nassau','BHS','New Providence',172000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (149,'al-Manama','BHR','al-Manama',148000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (150,'Dhaka','BGD','Dhaka',3612850);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (151,'Chittagong','BGD','Chittagong',1392860);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (152,'Khulna','BGD','Khulna',663340);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (153,'Rajshahi','BGD','Rajshahi',294056);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (154,'Narayanganj','BGD','Dhaka',202134);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (155,'Rangpur','BGD','Rajshahi',191398);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (156,'Mymensingh','BGD','Dhaka',188713);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (157,'Barisal','BGD','Barisal',170232);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (158,'Tungi','BGD','Dhaka',168702);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (159,'Jessore','BGD','Khulna',139710);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (160,'Comilla','BGD','Chittagong',135313);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (161,'Nawabganj','BGD','Rajshahi',130577);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (162,'Dinajpur','BGD','Rajshahi',127815);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (163,'Bogra','BGD','Rajshahi',120170);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (164,'Sylhet','BGD','Sylhet',117396);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (165,'Brahmanbaria','BGD','Chittagong',109032);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (166,'Tangail','BGD','Dhaka',106004);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (167,'Jamalpur','BGD','Dhaka',103556);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (168,'Pabna','BGD','Rajshahi',103277);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (169,'Naogaon','BGD','Rajshahi',101266);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (170,'Sirajganj','BGD','Rajshahi',99669);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (171,'Narsinghdi','BGD','Dhaka',98342);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (172,'Saidpur','BGD','Rajshahi',96777);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (173,'Gazipur','BGD','Dhaka',96717);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (174,'Bridgetown','BRB','St Michael',6070);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (175,'Antwerpen','BEL','Antwerpen',446525);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (176,'Gent','BEL','East Flanderi',224180);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (177,'Charleroi','BEL','Hainaut',200827);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (178,'Liège','BEL','Liège',185639);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (179,'Bruxelles [Brussel]','BEL','Bryssel',133859);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (180,'Brugge','BEL','West Flanderi',116246);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (181,'Schaerbeek','BEL','Bryssel',105692);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (182,'Namur','BEL','Namur',105419);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (183,'Mons','BEL','Hainaut',90935);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (184,'Belize City','BLZ','Belize City',55810);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (185,'Belmopan','BLZ','Cayo',7105);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (186,'Cotonou','BEN','Atlantique',536827);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (187,'Porto-Novo','BEN','Ouémé',194000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (188,'Djougou','BEN','Atacora',134099);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (189,'Parakou','BEN','Borgou',103577);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (190,'Saint George','BMU','Saint George´s',1800);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (191,'Hamilton','BMU','Hamilton',1200);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (192,'Thimphu','BTN','Thimphu',22000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (193,'Santa Cruz de la Sierra','BOL','Santa Cruz',935361);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (194,'La Paz','BOL','La Paz',758141);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (195,'El Alto','BOL','La Paz',534466);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (196,'Cochabamba','BOL','Cochabamba',482800);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (197,'Oruro','BOL','Oruro',223553);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (198,'Sucre','BOL','Chuquisaca',178426);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (199,'Potosí','BOL','Potosí',140642);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (200,'Tarija','BOL','Tarija',125255);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (201,'Sarajevo','BIH','Federaatio',360000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (202,'Banja Luka','BIH','Republika Srpska',143079);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (203,'Zenica','BIH','Federaatio',96027);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (204,'Gaborone','BWA','Gaborone',213017);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (205,'Francistown','BWA','Francistown',101805);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (206,'São Paulo','BRA','São Paulo',9968485);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (207,'Rio de Janeiro','BRA','Rio de Janeiro',5598953);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (208,'Salvador','BRA','Bahia',2302832);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (209,'Belo Horizonte','BRA','Minas Gerais',2139125);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (210,'Fortaleza','BRA','Ceará',2097757);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (211,'Brasília','BRA','Distrito Federal',1969868);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (212,'Curitiba','BRA','Paraná',1584232);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (213,'Recife','BRA','Pernambuco',1378087);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (214,'Porto Alegre','BRA','Rio Grande do Sul',1314032);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (215,'Manaus','BRA','Amazonas',1255049);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (216,'Belém','BRA','Pará',1186926);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (217,'Guarulhos','BRA','São Paulo',1095874);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (218,'Goiânia','BRA','Goiás',1056330);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (219,'Campinas','BRA','São Paulo',950043);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (220,'São Gonçalo','BRA','Rio de Janeiro',869254);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (221,'Nova Iguaçu','BRA','Rio de Janeiro',862225);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (222,'São Luís','BRA','Maranhão',837588);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (223,'Maceió','BRA','Alagoas',786288);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (224,'Duque de Caxias','BRA','Rio de Janeiro',746758);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (225,'São Bernardo do Campo','BRA','São Paulo',723132);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (226,'Teresina','BRA','Piauí',691942);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (227,'Natal','BRA','Rio Grande do Norte',688955);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (228,'Osasco','BRA','São Paulo',659604);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (229,'Campo Grande','BRA','Mato Grosso do Sul',649593);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (230,'Santo André','BRA','São Paulo',630073);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (231,'João Pessoa','BRA','Paraíba',584029);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (232,'Jaboatão dos Guararapes','BRA','Pernambuco',558680);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (233,'Contagem','BRA','Minas Gerais',520801);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (234,'São José dos Campos','BRA','São Paulo',515553);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (235,'Uberlândia','BRA','Minas Gerais',487222);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (236,'Feira de Santana','BRA','Bahia',479992);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (237,'Ribeirão Preto','BRA','São Paulo',473276);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (238,'Sorocaba','BRA','São Paulo',466823);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (239,'Niterói','BRA','Rio de Janeiro',459884);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (240,'Cuiabá','BRA','Mato Grosso',453813);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (241,'Juiz de Fora','BRA','Minas Gerais',450288);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (242,'Aracaju','BRA','Sergipe',445555);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (243,'São João de Meriti','BRA','Rio de Janeiro',440052);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (244,'Londrina','BRA','Paraná',432257);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (245,'Joinville','BRA','Santa Catarina',428011);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (246,'Belford Roxo','BRA','Rio de Janeiro',425194);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (247,'Santos','BRA','São Paulo',408748);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (248,'Ananindeua','BRA','Pará',400940);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (249,'Campos dos Goytacazes','BRA','Rio de Janeiro',398418);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (250,'Mauá','BRA','São Paulo',375055);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (251,'Carapicuíba','BRA','São Paulo',357552);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (252,'Olinda','BRA','Pernambuco',354732);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (253,'Campina Grande','BRA','Paraíba',352497);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (254,'São José do Rio Preto','BRA','São Paulo',351944);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (255,'Caxias do Sul','BRA','Rio Grande do Sul',349581);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (256,'Moji das Cruzes','BRA','São Paulo',339194);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (257,'Diadema','BRA','São Paulo',335078);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (258,'Aparecida de Goiânia','BRA','Goiás',324662);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (259,'Piracicaba','BRA','São Paulo',319104);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (260,'Cariacica','BRA','Espírito Santo',319033);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (261,'Vila Velha','BRA','Espírito Santo',318758);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (262,'Pelotas','BRA','Rio Grande do Sul',315415);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (263,'Bauru','BRA','São Paulo',313670);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (264,'Porto Velho','BRA','Rondônia',309750);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (265,'Serra','BRA','Espírito Santo',302666);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (266,'Betim','BRA','Minas Gerais',302108);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (267,'Jundíaí','BRA','São Paulo',296127);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (268,'Canoas','BRA','Rio Grande do Sul',294125);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (269,'Franca','BRA','São Paulo',290139);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (270,'São Vicente','BRA','São Paulo',286848);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (271,'Maringá','BRA','Paraná',286461);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (272,'Montes Claros','BRA','Minas Gerais',286058);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (273,'Anápolis','BRA','Goiás',282197);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (274,'Florianópolis','BRA','Santa Catarina',281928);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (275,'Petrópolis','BRA','Rio de Janeiro',279183);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (276,'Itaquaquecetuba','BRA','São Paulo',270874);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (277,'Vitória','BRA','Espírito Santo',270626);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (278,'Ponta Grossa','BRA','Paraná',268013);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (279,'Rio Branco','BRA','Acre',259537);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (280,'Foz do Iguaçu','BRA','Paraná',259425);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (281,'Macapá','BRA','Amapá',256033);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (282,'Ilhéus','BRA','Bahia',254970);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (283,'Vitória da Conquista','BRA','Bahia',253587);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (284,'Uberaba','BRA','Minas Gerais',249225);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (285,'Paulista','BRA','Pernambuco',248473);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (286,'Limeira','BRA','São Paulo',245497);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (287,'Blumenau','BRA','Santa Catarina',244379);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (288,'Caruaru','BRA','Pernambuco',244247);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (289,'Santarém','BRA','Pará',241771);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (290,'Volta Redonda','BRA','Rio de Janeiro',240315);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (291,'Novo Hamburgo','BRA','Rio Grande do Sul',239940);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (292,'Caucaia','BRA','Ceará',238738);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (293,'Santa Maria','BRA','Rio Grande do Sul',238473);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (294,'Cascavel','BRA','Paraná',237510);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (295,'Guarujá','BRA','São Paulo',237206);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (296,'Ribeirão das Neves','BRA','Minas Gerais',232685);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (297,'Governador Valadares','BRA','Minas Gerais',231724);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (298,'Taubaté','BRA','São Paulo',229130);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (299,'Imperatriz','BRA','Maranhão',224564);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (300,'Gravataí','BRA','Rio Grande do Sul',223011);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (301,'Embu','BRA','São Paulo',222223);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (302,'Mossoró','BRA','Rio Grande do Norte',214901);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (303,'Várzea Grande','BRA','Mato Grosso',214435);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (304,'Petrolina','BRA','Pernambuco',210540);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (305,'Barueri','BRA','São Paulo',208426);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (306,'Viamão','BRA','Rio Grande do Sul',207557);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (307,'Ipatinga','BRA','Minas Gerais',206338);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (308,'Juazeiro','BRA','Bahia',201073);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (309,'Juazeiro do Norte','BRA','Ceará',199636);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (310,'Taboão da Serra','BRA','São Paulo',197550);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (311,'São José dos Pinhais','BRA','Paraná',196884);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (312,'Magé','BRA','Rio de Janeiro',196147);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (313,'Suzano','BRA','São Paulo',195434);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (314,'São Leopoldo','BRA','Rio Grande do Sul',189258);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (315,'Marília','BRA','São Paulo',188691);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (316,'São Carlos','BRA','São Paulo',187122);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (317,'Sumaré','BRA','São Paulo',186205);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (318,'Presidente Prudente','BRA','São Paulo',185340);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (319,'Divinópolis','BRA','Minas Gerais',185047);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (320,'Sete Lagoas','BRA','Minas Gerais',182984);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (321,'Rio Grande','BRA','Rio Grande do Sul',182222);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (322,'Itabuna','BRA','Bahia',182148);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (323,'Jequié','BRA','Bahia',179128);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (324,'Arapiraca','BRA','Alagoas',178988);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (325,'Colombo','BRA','Paraná',177764);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (326,'Americana','BRA','São Paulo',177409);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (327,'Alvorada','BRA','Rio Grande do Sul',175574);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (328,'Araraquara','BRA','São Paulo',174381);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (329,'Itaboraí','BRA','Rio de Janeiro',173977);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (330,'Santa Bárbara d´Oeste','BRA','São Paulo',171657);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (331,'Nova Friburgo','BRA','Rio de Janeiro',170697);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (332,'Jacareí','BRA','São Paulo',170356);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (333,'Araçatuba','BRA','São Paulo',169303);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (334,'Barra Mansa','BRA','Rio de Janeiro',168953);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (335,'Praia Grande','BRA','São Paulo',168434);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (336,'Marabá','BRA','Pará',167795);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (337,'Criciúma','BRA','Santa Catarina',167661);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (338,'Boa Vista','BRA','Roraima',167185);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (339,'Passo Fundo','BRA','Rio Grande do Sul',166343);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (340,'Dourados','BRA','Mato Grosso do Sul',164716);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (341,'Santa Luzia','BRA','Minas Gerais',164704);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (342,'Rio Claro','BRA','São Paulo',163551);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (343,'Maracanaú','BRA','Ceará',162022);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (344,'Guarapuava','BRA','Paraná',160510);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (345,'Rondonópolis','BRA','Mato Grosso',155115);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (346,'São José','BRA','Santa Catarina',155105);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (347,'Cachoeiro de Itapemirim','BRA','Espírito Santo',155024);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (348,'Nilópolis','BRA','Rio de Janeiro',153383);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (349,'Itapevi','BRA','São Paulo',150664);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (350,'Cabo de Santo Agostinho','BRA','Pernambuco',149964);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (351,'Camaçari','BRA','Bahia',149146);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (352,'Sobral','BRA','Ceará',146005);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (353,'Itajaí','BRA','Santa Catarina',145197);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (354,'Chapecó','BRA','Santa Catarina',144158);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (355,'Cotia','BRA','São Paulo',140042);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (356,'Lages','BRA','Santa Catarina',139570);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (357,'Ferraz de Vasconcelos','BRA','São Paulo',139283);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (358,'Indaiatuba','BRA','São Paulo',135968);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (359,'Hortolândia','BRA','São Paulo',135755);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (360,'Caxias','BRA','Maranhão',133980);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (361,'São Caetano do Sul','BRA','São Paulo',133321);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (362,'Itu','BRA','São Paulo',132736);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (363,'Nossa Senhora do Socorro','BRA','Sergipe',131351);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (364,'Parnaíba','BRA','Piauí',129756);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (365,'Poços de Caldas','BRA','Minas Gerais',129683);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (366,'Teresópolis','BRA','Rio de Janeiro',128079);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (367,'Barreiras','BRA','Bahia',127801);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (368,'Castanhal','BRA','Pará',127634);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (369,'Alagoinhas','BRA','Bahia',126820);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (370,'Itapecerica da Serra','BRA','São Paulo',126672);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (371,'Uruguaiana','BRA','Rio Grande do Sul',126305);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (372,'Paranaguá','BRA','Paraná',126076);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (373,'Ibirité','BRA','Minas Gerais',125982);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (374,'Timon','BRA','Maranhão',125812);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (375,'Luziânia','BRA','Goiás',125597);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (376,'Macaé','BRA','Rio de Janeiro',125597);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (377,'Teófilo Otoni','BRA','Minas Gerais',124489);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (378,'Moji-Guaçu','BRA','São Paulo',123782);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (379,'Palmas','BRA','Tocantins',121919);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (380,'Pindamonhangaba','BRA','São Paulo',121904);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (381,'Francisco Morato','BRA','São Paulo',121197);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (382,'Bagé','BRA','Rio Grande do Sul',120793);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (383,'Sapucaia do Sul','BRA','Rio Grande do Sul',120217);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (384,'Cabo Frio','BRA','Rio de Janeiro',119503);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (385,'Itapetininga','BRA','São Paulo',119391);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (386,'Patos de Minas','BRA','Minas Gerais',119262);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (387,'Camaragibe','BRA','Pernambuco',118968);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (388,'Bragança Paulista','BRA','São Paulo',116929);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (389,'Queimados','BRA','Rio de Janeiro',115020);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (390,'Araguaína','BRA','Tocantins',114948);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (391,'Garanhuns','BRA','Pernambuco',114603);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (392,'Vitória de Santo Antão','BRA','Pernambuco',113595);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (393,'Santa Rita','BRA','Paraíba',113135);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (394,'Barbacena','BRA','Minas Gerais',113079);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (395,'Abaetetuba','BRA','Pará',111258);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (396,'Jaú','BRA','São Paulo',109965);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (397,'Lauro de Freitas','BRA','Bahia',109236);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (398,'Franco da Rocha','BRA','São Paulo',108964);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (399,'Teixeira de Freitas','BRA','Bahia',108441);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (400,'Varginha','BRA','Minas Gerais',108314);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (401,'Ribeirão Pires','BRA','São Paulo',108121);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (402,'Sabará','BRA','Minas Gerais',107781);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (403,'Catanduva','BRA','São Paulo',107761);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (404,'Rio Verde','BRA','Goiás',107755);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (405,'Botucatu','BRA','São Paulo',107663);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (406,'Colatina','BRA','Espírito Santo',107354);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (407,'Santa Cruz do Sul','BRA','Rio Grande do Sul',106734);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (408,'Linhares','BRA','Espírito Santo',106278);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (409,'Apucarana','BRA','Paraná',105114);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (410,'Barretos','BRA','São Paulo',104156);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (411,'Guaratinguetá','BRA','São Paulo',103433);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (412,'Cachoeirinha','BRA','Rio Grande do Sul',103240);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (413,'Codó','BRA','Maranhão',103153);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (414,'Jaraguá do Sul','BRA','Santa Catarina',102580);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (415,'Cubatão','BRA','São Paulo',102372);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (416,'Itabira','BRA','Minas Gerais',102217);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (417,'Itaituba','BRA','Pará',101320);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (418,'Araras','BRA','São Paulo',101046);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (419,'Resende','BRA','Rio de Janeiro',100627);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (420,'Atibaia','BRA','São Paulo',100356);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (421,'Pouso Alegre','BRA','Minas Gerais',100028);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (422,'Toledo','BRA','Paraná',99387);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (423,'Crato','BRA','Ceará',98965);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (424,'Passos','BRA','Minas Gerais',98570);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (425,'Araguari','BRA','Minas Gerais',98399);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (426,'São José de Ribamar','BRA','Maranhão',98318);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (427,'Pinhais','BRA','Paraná',98198);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (428,'Sertãozinho','BRA','São Paulo',98140);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (429,'Conselheiro Lafaiete','BRA','Minas Gerais',97507);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (430,'Paulo Afonso','BRA','Bahia',97291);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (431,'Angra dos Reis','BRA','Rio de Janeiro',96864);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (432,'Eunápolis','BRA','Bahia',96610);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (433,'Salto','BRA','São Paulo',96348);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (434,'Ourinhos','BRA','São Paulo',96291);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (435,'Parnamirim','BRA','Rio Grande do Norte',96210);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (436,'Jacobina','BRA','Bahia',96131);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (437,'Coronel Fabriciano','BRA','Minas Gerais',95933);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (438,'Birigui','BRA','São Paulo',94685);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (439,'Tatuí','BRA','São Paulo',93897);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (440,'Ji-Paraná','BRA','Rondônia',93346);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (441,'Bacabal','BRA','Maranhão',93121);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (442,'Cametá','BRA','Pará',92779);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (443,'Guaíba','BRA','Rio Grande do Sul',92224);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (444,'São Lourenço da Mata','BRA','Pernambuco',91999);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (445,'Santana do Livramento','BRA','Rio Grande do Sul',91779);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (446,'Votorantim','BRA','São Paulo',91777);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (447,'Campo Largo','BRA','Paraná',91203);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (448,'Patos','BRA','Paraíba',90519);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (449,'Ituiutaba','BRA','Minas Gerais',90507);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (450,'Corumbá','BRA','Mato Grosso do Sul',90111);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (451,'Palhoça','BRA','Santa Catarina',89465);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (452,'Barra do Piraí','BRA','Rio de Janeiro',89388);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (453,'Bento Gonçalves','BRA','Rio Grande do Sul',89254);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (454,'Poá','BRA','São Paulo',89236);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (455,'Águas Lindas de Goiás','BRA','Goiás',89200);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (456,'London','GBR','England',7285000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (457,'Birmingham','GBR','England',1013000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (458,'Glasgow','GBR','Scotland',619680);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (459,'Liverpool','GBR','England',461000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (460,'Edinburgh','GBR','Scotland',450180);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (461,'Sheffield','GBR','England',431607);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (462,'Manchester','GBR','England',430000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (463,'Leeds','GBR','England',424194);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (464,'Bristol','GBR','England',402000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (465,'Cardiff','GBR','Wales',321000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (466,'Coventry','GBR','England',304000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (467,'Leicester','GBR','England',294000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (468,'Bradford','GBR','England',289376);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (469,'Belfast','GBR','North Ireland',287500);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (470,'Nottingham','GBR','England',287000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (471,'Kingston upon Hull','GBR','England',262000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (472,'Plymouth','GBR','England',253000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (473,'Stoke-on-Trent','GBR','England',252000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (474,'Wolverhampton','GBR','England',242000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (475,'Derby','GBR','England',236000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (476,'Swansea','GBR','Wales',230000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (477,'Southampton','GBR','England',216000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (478,'Aberdeen','GBR','Scotland',213070);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (479,'Northampton','GBR','England',196000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (480,'Dudley','GBR','England',192171);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (481,'Portsmouth','GBR','England',190000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (482,'Newcastle upon Tyne','GBR','England',189150);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (483,'Sunderland','GBR','England',183310);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (484,'Luton','GBR','England',183000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (485,'Swindon','GBR','England',180000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (486,'Southend-on-Sea','GBR','England',176000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (487,'Walsall','GBR','England',174739);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (488,'Bournemouth','GBR','England',162000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (489,'Peterborough','GBR','England',156000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (490,'Brighton','GBR','England',156124);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (491,'Blackpool','GBR','England',151000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (492,'Dundee','GBR','Scotland',146690);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (493,'West Bromwich','GBR','England',146386);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (494,'Reading','GBR','England',148000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (495,'Oldbury/Smethwick (Warley)','GBR','England',145542);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (496,'Middlesbrough','GBR','England',145000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (497,'Huddersfield','GBR','England',143726);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (498,'Oxford','GBR','England',144000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (499,'Poole','GBR','England',141000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (500,'Bolton','GBR','England',139020);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (501,'Blackburn','GBR','England',140000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (502,'Newport','GBR','Wales',139000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (503,'Preston','GBR','England',135000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (504,'Stockport','GBR','England',132813);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (505,'Norwich','GBR','England',124000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (506,'Rotherham','GBR','England',121380);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (507,'Cambridge','GBR','England',121000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (508,'Watford','GBR','England',113080);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (509,'Ipswich','GBR','England',114000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (510,'Slough','GBR','England',112000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (511,'Exeter','GBR','England',111000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (512,'Cheltenham','GBR','England',106000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (513,'Gloucester','GBR','England',107000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (514,'Saint Helens','GBR','England',106293);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (515,'Sutton Coldfield','GBR','England',106001);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (516,'York','GBR','England',104425);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (517,'Oldham','GBR','England',103931);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (518,'Basildon','GBR','England',100924);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (519,'Worthing','GBR','England',100000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (520,'Chelmsford','GBR','England',97451);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (521,'Colchester','GBR','England',96063);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (522,'Crawley','GBR','England',97000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (523,'Gillingham','GBR','England',92000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (524,'Solihull','GBR','England',94531);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (525,'Rochdale','GBR','England',94313);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (526,'Birkenhead','GBR','England',93087);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (527,'Worcester','GBR','England',95000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (528,'Hartlepool','GBR','England',92000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (529,'Halifax','GBR','England',91069);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (530,'Woking/Byfleet','GBR','England',92000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (531,'Southport','GBR','England',90959);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (532,'Maidstone','GBR','England',90878);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (533,'Eastbourne','GBR','England',90000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (534,'Grimsby','GBR','England',89000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (535,'Saint Helier','GBR','Jersey',27523);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (536,'Douglas','GBR','–',23487);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (537,'Road Town','VGB','Tortola',8000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (538,'Bandar Seri Begawan','BRN','Brunei and Muara',21484);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (539,'Sofija','BGR','Grad Sofija',1122302);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (540,'Plovdiv','BGR','Plovdiv',342584);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (541,'Varna','BGR','Varna',299801);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (542,'Burgas','BGR','Burgas',195255);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (543,'Ruse','BGR','Ruse',166467);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (544,'Stara Zagora','BGR','Haskovo',147939);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (545,'Pleven','BGR','Lovec',121952);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (546,'Sliven','BGR','Burgas',105530);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (547,'Dobric','BGR','Varna',100399);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (548,'Šumen','BGR','Varna',94686);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (549,'Ouagadougou','BFA','Kadiogo',824000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (550,'Bobo-Dioulasso','BFA','Houet',300000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (551,'Koudougou','BFA','Boulkiemdé',105000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (552,'Bujumbura','BDI','Bujumbura',300000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (553,'George Town','CYM','Grand Cayman',19600);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (554,'Santiago de Chile','CHL','Santiago',4703954);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (555,'Puente Alto','CHL','Santiago',386236);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (556,'Viña del Mar','CHL','Valparaíso',312493);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (557,'Valparaíso','CHL','Valparaíso',293800);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (558,'Talcahuano','CHL','Bíobío',277752);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (559,'Antofagasta','CHL','Antofagasta',251429);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (560,'San Bernardo','CHL','Santiago',241910);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (561,'Temuco','CHL','La Araucanía',233041);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (562,'Concepción','CHL','Bíobío',217664);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (563,'Rancagua','CHL','O´Higgins',212977);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (564,'Arica','CHL','Tarapacá',189036);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (565,'Talca','CHL','Maule',187557);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (566,'Chillán','CHL','Bíobío',178182);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (567,'Iquique','CHL','Tarapacá',177892);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (568,'Los Angeles','CHL','Bíobío',158215);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (569,'Puerto Montt','CHL','Los Lagos',152194);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (570,'Coquimbo','CHL','Coquimbo',143353);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (571,'Osorno','CHL','Los Lagos',141468);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (572,'La Serena','CHL','Coquimbo',137409);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (573,'Calama','CHL','Antofagasta',137265);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (574,'Valdivia','CHL','Los Lagos',133106);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (575,'Punta Arenas','CHL','Magallanes',125631);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (576,'Copiapó','CHL','Atacama',120128);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (577,'Quilpué','CHL','Valparaíso',118857);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (578,'Curicó','CHL','Maule',115766);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (579,'Ovalle','CHL','Coquimbo',94854);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (580,'Coronel','CHL','Bíobío',93061);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (581,'San Pedro de la Paz','CHL','Bíobío',91684);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (582,'Melipilla','CHL','Santiago',91056);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (583,'Avarua','COK','Rarotonga',11900);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (584,'San José','CRI','San José',339131);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (585,'Djibouti','DJI','Djibouti',383000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (586,'Roseau','DMA','St George',16243);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (587,'Santo Domingo de Guzmán','DOM','Distrito Nacional',1609966);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (588,'Santiago de los Caballeros','DOM','Santiago',365463);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (589,'La Romana','DOM','La Romana',140204);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (590,'San Pedro de Macorís','DOM','San Pedro de Macorís',124735);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (591,'San Francisco de Macorís','DOM','Duarte',108485);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (592,'San Felipe de Puerto Plata','DOM','Puerto Plata',89423);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (593,'Guayaquil','ECU','Guayas',2070040);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (594,'Quito','ECU','Pichincha',1573458);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (595,'Cuenca','ECU','Azuay',270353);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (596,'Machala','ECU','El Oro',210368);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (597,'Santo Domingo de los Colorados','ECU','Pichincha',202111);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (598,'Portoviejo','ECU','Manabí',176413);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (599,'Ambato','ECU','Tungurahua',169612);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (600,'Manta','ECU','Manabí',164739);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (601,'Duran [Eloy Alfaro]','ECU','Guayas',152514);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (602,'Ibarra','ECU','Imbabura',130643);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (603,'Quevedo','ECU','Los Ríos',129631);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (604,'Milagro','ECU','Guayas',124177);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (605,'Loja','ECU','Loja',123875);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (606,'Ríobamba','ECU','Chimborazo',123163);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (607,'Esmeraldas','ECU','Esmeraldas',123045);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (608,'Cairo','EGY','Kairo',6789479);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (609,'Alexandria','EGY','Aleksandria',3328196);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (610,'Giza','EGY','Giza',2221868);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (611,'Shubra al-Khayma','EGY','al-Qalyubiya',870716);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (612,'Port Said','EGY','Port Said',469533);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (613,'Suez','EGY','Suez',417610);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (614,'al-Mahallat al-Kubra','EGY','al-Gharbiya',395402);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (615,'Tanta','EGY','al-Gharbiya',371010);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (616,'al-Mansura','EGY','al-Daqahliya',369621);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (617,'Luxor','EGY','Luxor',360503);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (618,'Asyut','EGY','Asyut',343498);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (619,'Bahtim','EGY','al-Qalyubiya',275807);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (620,'Zagazig','EGY','al-Sharqiya',267351);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (621,'al-Faiyum','EGY','al-Faiyum',260964);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (622,'Ismailia','EGY','Ismailia',254477);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (623,'Kafr al-Dawwar','EGY','al-Buhayra',231978);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (624,'Assuan','EGY','Assuan',219017);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (625,'Damanhur','EGY','al-Buhayra',212203);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (626,'al-Minya','EGY','al-Minya',201360);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (627,'Bani Suwayf','EGY','Bani Suwayf',172032);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (628,'Qina','EGY','Qina',171275);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (629,'Sawhaj','EGY','Sawhaj',170125);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (630,'Shibin al-Kawm','EGY','al-Minufiya',159909);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (631,'Bulaq al-Dakrur','EGY','Giza',148787);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (632,'Banha','EGY','al-Qalyubiya',145792);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (633,'Warraq al-Arab','EGY','Giza',127108);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (634,'Kafr al-Shaykh','EGY','Kafr al-Shaykh',124819);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (635,'Mallawi','EGY','al-Minya',119283);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (636,'Bilbays','EGY','al-Sharqiya',113608);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (637,'Mit Ghamr','EGY','al-Daqahliya',101801);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (638,'al-Arish','EGY','Shamal Sina',100447);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (639,'Talkha','EGY','al-Daqahliya',97700);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (640,'Qalyub','EGY','al-Qalyubiya',97200);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (641,'Jirja','EGY','Sawhaj',95400);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (642,'Idfu','EGY','Qina',94200);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (643,'al-Hawamidiya','EGY','Giza',91700);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (644,'Disuq','EGY','Kafr al-Shaykh',91300);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (645,'San Salvador','SLV','San Salvador',415346);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (646,'Santa Ana','SLV','Santa Ana',139389);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (647,'Mejicanos','SLV','San Salvador',138800);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (648,'Soyapango','SLV','San Salvador',129800);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (649,'San Miguel','SLV','San Miguel',127696);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (650,'Nueva San Salvador','SLV','La Libertad',98400);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (651,'Apopa','SLV','San Salvador',88800);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (652,'Asmara','ERI','Maekel',431000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (653,'Madrid','ESP','Madrid',2879052);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (654,'Barcelona','ESP','Katalonia',1503451);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (655,'Valencia','ESP','Valencia',739412);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (656,'Sevilla','ESP','Andalusia',701927);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (657,'Zaragoza','ESP','Aragonia',603367);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (658,'Málaga','ESP','Andalusia',530553);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (659,'Bilbao','ESP','Baskimaa',357589);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (660,'Las Palmas de Gran Canaria','ESP','Canary Islands',354757);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (661,'Murcia','ESP','Murcia',353504);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (662,'Palma de Mallorca','ESP','Balears',326993);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (663,'Valladolid','ESP','Castilla and León',319998);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (664,'Córdoba','ESP','Andalusia',311708);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (665,'Vigo','ESP','Galicia',283670);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (666,'Alicante [Alacant]','ESP','Valencia',272432);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (667,'Gijón','ESP','Asturia',267980);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (668,'L´Hospitalet de Llobregat','ESP','Katalonia',247986);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (669,'Granada','ESP','Andalusia',244767);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (670,'A Coruña (La Coruña)','ESP','Galicia',243402);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (671,'Vitoria-Gasteiz','ESP','Baskimaa',217154);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (672,'Santa Cruz de Tenerife','ESP','Canary Islands',213050);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (673,'Badalona','ESP','Katalonia',209635);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (674,'Oviedo','ESP','Asturia',200453);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (675,'Móstoles','ESP','Madrid',195351);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (676,'Elche [Elx]','ESP','Valencia',193174);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (677,'Sabadell','ESP','Katalonia',184859);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (678,'Santander','ESP','Cantabria',184165);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (679,'Jerez de la Frontera','ESP','Andalusia',182660);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (680,'Pamplona [Iruña]','ESP','Navarra',180483);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (681,'Donostia-San Sebastián','ESP','Baskimaa',179208);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (682,'Cartagena','ESP','Murcia',177709);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (683,'Leganés','ESP','Madrid',173163);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (684,'Fuenlabrada','ESP','Madrid',171173);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (685,'Almería','ESP','Andalusia',169027);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (686,'Terrassa','ESP','Katalonia',168695);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (687,'Alcalá de Henares','ESP','Madrid',164463);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (688,'Burgos','ESP','Castilla and León',162802);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (689,'Salamanca','ESP','Castilla and León',158720);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (690,'Albacete','ESP','Kastilia-La Mancha',147527);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (691,'Getafe','ESP','Madrid',145371);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (692,'Cádiz','ESP','Andalusia',142449);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (693,'Alcorcón','ESP','Madrid',142048);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (694,'Huelva','ESP','Andalusia',140583);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (695,'León','ESP','Castilla and León',139809);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (696,'Castellón de la Plana [Castell','ESP','Valencia',139712);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (697,'Badajoz','ESP','Extremadura',136613);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (698,'[San Cristóbal de] la Laguna','ESP','Canary Islands',127945);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (699,'Logroño','ESP','La Rioja',127093);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (700,'Santa Coloma de Gramenet','ESP','Katalonia',120802);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (701,'Tarragona','ESP','Katalonia',113016);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (702,'Lleida (Lérida)','ESP','Katalonia',112207);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (703,'Jaén','ESP','Andalusia',109247);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (704,'Ourense (Orense)','ESP','Galicia',109120);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (705,'Mataró','ESP','Katalonia',104095);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (706,'Algeciras','ESP','Andalusia',103106);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (707,'Marbella','ESP','Andalusia',101144);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (708,'Barakaldo','ESP','Baskimaa',98212);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (709,'Dos Hermanas','ESP','Andalusia',94591);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (710,'Santiago de Compostela','ESP','Galicia',93745);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (711,'Torrejón de Ardoz','ESP','Madrid',92262);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (712,'Cape Town','ZAF','Western Cape',2352121);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (713,'Soweto','ZAF','Gauteng',904165);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (714,'Johannesburg','ZAF','Gauteng',756653);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (715,'Port Elizabeth','ZAF','Eastern Cape',752319);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (716,'Pretoria','ZAF','Gauteng',658630);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (717,'Inanda','ZAF','KwaZulu-Natal',634065);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (718,'Durban','ZAF','KwaZulu-Natal',566120);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (719,'Vanderbijlpark','ZAF','Gauteng',468931);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (720,'Kempton Park','ZAF','Gauteng',442633);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (721,'Alberton','ZAF','Gauteng',410102);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (722,'Pinetown','ZAF','KwaZulu-Natal',378810);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (723,'Pietermaritzburg','ZAF','KwaZulu-Natal',370190);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (724,'Benoni','ZAF','Gauteng',365467);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (725,'Randburg','ZAF','Gauteng',341288);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (726,'Umlazi','ZAF','KwaZulu-Natal',339233);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (727,'Bloemfontein','ZAF','Free State',334341);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (728,'Vereeniging','ZAF','Gauteng',328535);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (729,'Wonderboom','ZAF','Gauteng',283289);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (730,'Roodepoort','ZAF','Gauteng',279340);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (731,'Boksburg','ZAF','Gauteng',262648);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (732,'Klerksdorp','ZAF','North West',261911);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (733,'Soshanguve','ZAF','Gauteng',242727);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (734,'Newcastle','ZAF','KwaZulu-Natal',222993);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (735,'East London','ZAF','Eastern Cape',221047);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (736,'Welkom','ZAF','Free State',203296);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (737,'Kimberley','ZAF','Northern Cape',197254);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (738,'Uitenhage','ZAF','Eastern Cape',192120);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (739,'Chatsworth','ZAF','KwaZulu-Natal',189885);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (740,'Mdantsane','ZAF','Eastern Cape',182639);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (741,'Krugersdorp','ZAF','Gauteng',181503);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (742,'Botshabelo','ZAF','Free State',177971);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (743,'Brakpan','ZAF','Gauteng',171363);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (744,'Witbank','ZAF','Mpumalanga',167183);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (745,'Oberholzer','ZAF','Gauteng',164367);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (746,'Germiston','ZAF','Gauteng',164252);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (747,'Springs','ZAF','Gauteng',162072);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (748,'Westonaria','ZAF','Gauteng',159632);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (749,'Randfontein','ZAF','Gauteng',120838);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (750,'Paarl','ZAF','Western Cape',105768);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (751,'Potchefstroom','ZAF','North West',101817);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (752,'Rustenburg','ZAF','North West',97008);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (753,'Nigel','ZAF','Gauteng',96734);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (754,'George','ZAF','Western Cape',93818);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (755,'Ladysmith','ZAF','KwaZulu-Natal',89292);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (756,'Addis Abeba','ETH','Addis Abeba',2495000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (757,'Dire Dawa','ETH','Dire Dawa',164851);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (758,'Nazret','ETH','Oromia',127842);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (759,'Gonder','ETH','Amhara',112249);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (760,'Dese','ETH','Amhara',97314);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (761,'Mekele','ETH','Tigray',96938);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (762,'Bahir Dar','ETH','Amhara',96140);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (763,'Stanley','FLK','East Falkland',1636);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (764,'Suva','FJI','Central',77366);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (765,'Quezon','PHL','National Capital Reg',2173831);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (766,'Manila','PHL','National Capital Reg',1581082);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (767,'Kalookan','PHL','National Capital Reg',1177604);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (768,'Davao','PHL','Southern Mindanao',1147116);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (769,'Cebu','PHL','Central Visayas',718821);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (770,'Zamboanga','PHL','Western Mindanao',601794);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (771,'Pasig','PHL','National Capital Reg',505058);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (772,'Valenzuela','PHL','National Capital Reg',485433);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (773,'Las Piñas','PHL','National Capital Reg',472780);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (774,'Antipolo','PHL','Southern Tagalog',470866);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (775,'Taguig','PHL','National Capital Reg',467375);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (776,'Cagayan de Oro','PHL','Northern Mindanao',461877);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (777,'Parañaque','PHL','National Capital Reg',449811);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (778,'Makati','PHL','National Capital Reg',444867);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (779,'Bacolod','PHL','Western Visayas',429076);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (780,'General Santos','PHL','Southern Mindanao',411822);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (781,'Marikina','PHL','National Capital Reg',391170);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (782,'Dasmariñas','PHL','Southern Tagalog',379520);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (783,'Muntinlupa','PHL','National Capital Reg',379310);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (784,'Iloilo','PHL','Western Visayas',365820);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (785,'Pasay','PHL','National Capital Reg',354908);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (786,'Malabon','PHL','National Capital Reg',338855);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (787,'San José del Monte','PHL','Central Luzon',315807);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (788,'Bacoor','PHL','Southern Tagalog',305699);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (789,'Iligan','PHL','Central Mindanao',285061);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (790,'Calamba','PHL','Southern Tagalog',281146);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (791,'Mandaluyong','PHL','National Capital Reg',278474);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (792,'Butuan','PHL','Caraga',267279);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (793,'Angeles','PHL','Central Luzon',263971);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (794,'Tarlac','PHL','Central Luzon',262481);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (795,'Mandaue','PHL','Central Visayas',259728);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (796,'Baguio','PHL','CAR',252386);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (797,'Batangas','PHL','Southern Tagalog',247588);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (798,'Cainta','PHL','Southern Tagalog',242511);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (799,'San Pedro','PHL','Southern Tagalog',231403);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (800,'Navotas','PHL','National Capital Reg',230403);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (801,'Cabanatuan','PHL','Central Luzon',222859);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (802,'San Fernando','PHL','Central Luzon',221857);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (803,'Lipa','PHL','Southern Tagalog',218447);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (804,'Lapu-Lapu','PHL','Central Visayas',217019);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (805,'San Pablo','PHL','Southern Tagalog',207927);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (806,'Biñan','PHL','Southern Tagalog',201186);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (807,'Taytay','PHL','Southern Tagalog',198183);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (808,'Lucena','PHL','Southern Tagalog',196075);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (809,'Imus','PHL','Southern Tagalog',195482);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (810,'Olongapo','PHL','Central Luzon',194260);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (811,'Binangonan','PHL','Southern Tagalog',187691);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (812,'Santa Rosa','PHL','Southern Tagalog',185633);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (813,'Tagum','PHL','Southern Mindanao',179531);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (814,'Tacloban','PHL','Eastern Visayas',178639);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (815,'Malolos','PHL','Central Luzon',175291);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (816,'Mabalacat','PHL','Central Luzon',171045);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (817,'Cotabato','PHL','Central Mindanao',163849);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (818,'Meycauayan','PHL','Central Luzon',163037);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (819,'Puerto Princesa','PHL','Southern Tagalog',161912);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (820,'Legazpi','PHL','Bicol',157010);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (821,'Silang','PHL','Southern Tagalog',156137);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (822,'Ormoc','PHL','Eastern Visayas',154297);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (823,'San Carlos','PHL','Ilocos',154264);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (824,'Kabankalan','PHL','Western Visayas',149769);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (825,'Talisay','PHL','Central Visayas',148110);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (826,'Valencia','PHL','Northern Mindanao',147924);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (827,'Calbayog','PHL','Eastern Visayas',147187);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (828,'Santa Maria','PHL','Central Luzon',144282);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (829,'Pagadian','PHL','Western Mindanao',142515);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (830,'Cadiz','PHL','Western Visayas',141954);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (831,'Bago','PHL','Western Visayas',141721);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (832,'Toledo','PHL','Central Visayas',141174);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (833,'Naga','PHL','Bicol',137810);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (834,'San Mateo','PHL','Southern Tagalog',135603);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (835,'Panabo','PHL','Southern Mindanao',133950);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (836,'Koronadal','PHL','Southern Mindanao',133786);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (837,'Marawi','PHL','Central Mindanao',131090);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (838,'Dagupan','PHL','Ilocos',130328);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (839,'Sagay','PHL','Western Visayas',129765);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (840,'Roxas','PHL','Western Visayas',126352);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (841,'Lubao','PHL','Central Luzon',125699);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (842,'Digos','PHL','Southern Mindanao',125171);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (843,'San Miguel','PHL','Central Luzon',123824);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (844,'Malaybalay','PHL','Northern Mindanao',123672);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (845,'Tuguegarao','PHL','Cagayan Valley',120645);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (846,'Ilagan','PHL','Cagayan Valley',119990);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (847,'Baliuag','PHL','Central Luzon',119675);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (848,'Surigao','PHL','Caraga',118534);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (849,'San Carlos','PHL','Western Visayas',118259);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (850,'San Juan del Monte','PHL','National Capital Reg',117680);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (851,'Tanauan','PHL','Southern Tagalog',117539);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (852,'Concepcion','PHL','Central Luzon',115171);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (853,'Rodriguez (Montalban)','PHL','Southern Tagalog',115167);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (854,'Sariaya','PHL','Southern Tagalog',114568);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (855,'Malasiqui','PHL','Ilocos',113190);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (856,'General Mariano Alvarez','PHL','Southern Tagalog',112446);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (857,'Urdaneta','PHL','Ilocos',111582);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (858,'Hagonoy','PHL','Central Luzon',111425);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (859,'San Jose','PHL','Southern Tagalog',111009);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (860,'Polomolok','PHL','Southern Mindanao',110709);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (861,'Santiago','PHL','Cagayan Valley',110531);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (862,'Tanza','PHL','Southern Tagalog',110517);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (863,'Ozamis','PHL','Northern Mindanao',110420);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (864,'Mexico','PHL','Central Luzon',109481);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (865,'San Jose','PHL','Central Luzon',108254);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (866,'Silay','PHL','Western Visayas',107722);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (867,'General Trias','PHL','Southern Tagalog',107691);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (868,'Tabaco','PHL','Bicol',107166);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (869,'Cabuyao','PHL','Southern Tagalog',106630);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (870,'Calapan','PHL','Southern Tagalog',105910);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (871,'Mati','PHL','Southern Mindanao',105908);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (872,'Midsayap','PHL','Central Mindanao',105760);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (873,'Cauayan','PHL','Cagayan Valley',103952);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (874,'Gingoog','PHL','Northern Mindanao',102379);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (875,'Dumaguete','PHL','Central Visayas',102265);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (876,'San Fernando','PHL','Ilocos',102082);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (877,'Arayat','PHL','Central Luzon',101792);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (878,'Bayawan (Tulong)','PHL','Central Visayas',101391);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (879,'Kidapawan','PHL','Central Mindanao',101205);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (880,'Daraga (Locsin)','PHL','Bicol',101031);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (881,'Marilao','PHL','Central Luzon',101017);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (882,'Malita','PHL','Southern Mindanao',100000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (883,'Dipolog','PHL','Western Mindanao',99862);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (884,'Cavite','PHL','Southern Tagalog',99367);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (885,'Danao','PHL','Central Visayas',98781);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (886,'Bislig','PHL','Caraga',97860);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (887,'Talavera','PHL','Central Luzon',97329);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (888,'Guagua','PHL','Central Luzon',96858);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (889,'Bayambang','PHL','Ilocos',96609);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (890,'Nasugbu','PHL','Southern Tagalog',96113);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (891,'Baybay','PHL','Eastern Visayas',95630);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (892,'Capas','PHL','Central Luzon',95219);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (893,'Sultan Kudarat','PHL','ARMM',94861);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (894,'Laoag','PHL','Ilocos',94466);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (895,'Bayugan','PHL','Caraga',93623);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (896,'Malungon','PHL','Southern Mindanao',93232);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (897,'Santa Cruz','PHL','Southern Tagalog',92694);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (898,'Sorsogon','PHL','Bicol',92512);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (899,'Candelaria','PHL','Southern Tagalog',92429);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (900,'Ligao','PHL','Bicol',90603);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (901,'Tórshavn','FRO','Streymoyar',14542);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (902,'Libreville','GAB','Estuaire',419000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (903,'Serekunda','GMB','Kombo St Mary',102600);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (904,'Banjul','GMB','Banjul',42326);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (905,'Tbilisi','GEO','Tbilisi',1235200);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (906,'Kutaisi','GEO','Imereti',240900);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (907,'Rustavi','GEO','Kvemo Kartli',155400);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (908,'Batumi','GEO','Adzaria [Atšara]',137700);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (909,'Sohumi','GEO','Abhasia [Aphazeti]',111700);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (910,'Accra','GHA','Greater Accra',1070000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (911,'Kumasi','GHA','Ashanti',385192);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (912,'Tamale','GHA','Northern',151069);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (913,'Tema','GHA','Greater Accra',109975);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (914,'Sekondi-Takoradi','GHA','Western',103653);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (915,'Gibraltar','GIB','–',27025);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (916,'Saint George´s','GRD','St George',4621);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (917,'Nuuk','GRL','Kitaa',13445);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (918,'Les Abymes','GLP','Grande-Terre',62947);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (919,'Basse-Terre','GLP','Basse-Terre',12433);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (920,'Tamuning','GUM','–',9500);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (921,'Agaña','GUM','–',1139);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (922,'Ciudad de Guatemala','GTM','Guatemala',823301);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (923,'Mixco','GTM','Guatemala',209791);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (924,'Villa Nueva','GTM','Guatemala',101295);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (925,'Quetzaltenango','GTM','Quetzaltenango',90801);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (926,'Conakry','GIN','Conakry',1090610);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (927,'Bissau','GNB','Bissau',241000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (928,'Georgetown','GUY','Georgetown',254000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (929,'Port-au-Prince','HTI','Ouest',884472);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (930,'Carrefour','HTI','Ouest',290204);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (931,'Delmas','HTI','Ouest',240429);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (932,'Le-Cap-Haïtien','HTI','Nord',102233);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (933,'Tegucigalpa','HND','Distrito Central',813900);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (934,'San Pedro Sula','HND','Cortés',383900);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (935,'La Ceiba','HND','Atlántida',89200);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (936,'Kowloon and New Kowloon','HKG','Kowloon and New Kowl',1987996);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (937,'Victoria','HKG','Hongkong',1312637);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (938,'Longyearbyen','SJM','Länsimaa',1438);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (939,'Jakarta','IDN','Jakarta Raya',9604900);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (940,'Surabaya','IDN','East Java',2663820);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (941,'Bandung','IDN','West Java',2429000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (942,'Medan','IDN','Sumatera Utara',1843919);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (943,'Palembang','IDN','Sumatera Selatan',1222764);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (944,'Tangerang','IDN','West Java',1198300);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (945,'Semarang','IDN','Central Java',1104405);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (946,'Ujung Pandang','IDN','Sulawesi Selatan',1060257);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (947,'Malang','IDN','East Java',716862);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (948,'Bandar Lampung','IDN','Lampung',680332);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (949,'Bekasi','IDN','West Java',644300);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (950,'Padang','IDN','Sumatera Barat',534474);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (951,'Surakarta','IDN','Central Java',518600);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (952,'Banjarmasin','IDN','Kalimantan Selatan',482931);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (953,'Pekan Baru','IDN','Riau',438638);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (954,'Denpasar','IDN','Bali',435000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (955,'Yogyakarta','IDN','Yogyakarta',418944);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (956,'Pontianak','IDN','Kalimantan Barat',409632);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (957,'Samarinda','IDN','Kalimantan Timur',399175);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (958,'Jambi','IDN','Jambi',385201);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (959,'Depok','IDN','West Java',365200);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (960,'Cimahi','IDN','West Java',344600);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (961,'Balikpapan','IDN','Kalimantan Timur',338752);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (962,'Manado','IDN','Sulawesi Utara',332288);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (963,'Mataram','IDN','Nusa Tenggara Barat',306600);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (964,'Pekalongan','IDN','Central Java',301504);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (965,'Tegal','IDN','Central Java',289744);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (966,'Bogor','IDN','West Java',285114);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (967,'Ciputat','IDN','West Java',270800);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (968,'Pondokgede','IDN','West Java',263200);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (969,'Cirebon','IDN','West Java',254406);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (970,'Kediri','IDN','East Java',253760);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (971,'Ambon','IDN','Molukit',249312);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (972,'Jember','IDN','East Java',218500);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (973,'Cilacap','IDN','Central Java',206900);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (974,'Cimanggis','IDN','West Java',205100);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (975,'Pematang Siantar','IDN','Sumatera Utara',203056);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (976,'Purwokerto','IDN','Central Java',202500);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (977,'Ciomas','IDN','West Java',187400);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (978,'Tasikmalaya','IDN','West Java',179800);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (979,'Madiun','IDN','East Java',171532);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (980,'Bengkulu','IDN','Bengkulu',146439);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (981,'Karawang','IDN','West Java',145000);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (982,'Banda Aceh','IDN','Aceh',143409);
INSERT INTO City(ID, Name, CountryCode, District, Population) VALUES (983,'Palu','IDN','Sulawesi Tengah',142800);
INSERT INTO City(ID, Name, CountryCode, District, Population)