1# 2# Populate the world database 3# 4 5# Table Country 6 7INSERT IGNORE INTO Country VALUES 8('AFG','Afghanistan',652090.00,22720000,1), 9('NLD','Netherlands',41526.00,15864000,5), 10('ANT','Netherlands Antilles',800.00,217000,33), 11('ALB','Albania',28748.00,3401200,34), 12('DZA','Algeria',2381741.00,31471000,35), 13('ASM','American Samoa',199.00,68000,54), 14('AND','Andorra',468.00,78000,55), 15('AGO','Angola',1246700.00,12878000,56), 16('AIA','Anguilla',96.00,8000,62), 17('ATG','Antigua and Barbuda',442.00,68000,63), 18('ARE','United Arab Emirates',83600.00,2441000,65), 19('ARG','Argentina',2780400.00,37032000,69), 20('ARM','Armenia',29800.00,3520000,126), 21('ABW','Aruba',193.00,103000,129), 22('AUS','Australia',7741220.00,18886000,135), 23('AZE','Azerbaijan',86600.00,7734000,144), 24('BHS','Bahamas',13878.00,307000,148), 25('BHR','Bahrain',694.00,617000,149), 26('BGD','Bangladesh',143998.00,129155000,150), 27('BRB','Barbados',430.00,270000,174), 28('BEL','Belgium',30518.00,10239000,179), 29('BLZ','Belize',22696.00,241000,185), 30('BEN','Benin',112622.00,6097000,187), 31('BMU','Bermuda',53.00,65000,191), 32('BTN','Bhutan',47000.00,2124000,192), 33('BOL','Bolivia',1098581.00,8329000,194), 34('BIH','Bosnia and Herzegovina',51197.00,3972000,201), 35('BWA','Botswana',581730.00,1622000,204), 36('BRA','Brazil',8547403.00,170115000,211), 37('GBR','United Kingdom',242900.00,59623400,456), 38('VGB','Virgin Islands, British',151.00,21000,537), 39('BRN','Brunei',5765.00,328000,538), 40('BGR','Bulgaria',110994.00,8190900,539), 41('BFA','Burkina Faso',274000.00,11937000,549), 42('BDI','Burundi',27834.00,6695000,552), 43('CYM','Cayman Islands',264.00,38000,553), 44('CHL','Chile',756626.00,15211000,554), 45('COK','Cook Islands',236.00,20000,583), 46('CRI','Costa Rica',51100.00,4023000,584), 47('DJI','Djibouti',23200.00,638000,585), 48('DMA','Dominica',751.00,71000,586), 49('DOM','Dominican Republic',48511.00,8495000,587), 50('ECU','Ecuador',283561.00,12646000,594), 51('EGY','Egypt',1001449.00,68470000,608), 52('SLV','El Salvador',21041.00,6276000,645), 53('ERI','Eritrea',117600.00,3850000,652), 54('ESP','Spain',505992.00,39441700,653), 55('ZAF','South Africa',1221037.00,40377000,716), 56('ETH','Ethiopia',1104300.00,62565000,756), 57('FLK','Falkland Islands',12173.00,2000,763), 58('FJI','Fiji Islands',18274.00,817000,764), 59('PHL','Philippines',300000.00,75967000,766), 60('FRO','Faroe Islands',1399.00,43000,901), 61('GAB','Gabon',267668.00,1226000,902), 62('GMB','Gambia',11295.00,1305000,904), 63('GEO','Georgia',69700.00,4968000,905), 64('GHA','Ghana',238533.00,20212000,910), 65('GIB','Gibraltar',6.00,25000,915), 66('GRD','Grenada',344.00,94000,916), 67('GRL','Greenland',2166090.00,56000,917), 68('GLP','Guadeloupe',1705.00,456000,919), 69('GUM','Guam',549.00,168000,921), 70('GTM','Guatemala',108889.00,11385000,922), 71('GIN','Guinea',245857.00,7430000,926), 72('GNB','Guinea-Bissau',36125.00,1213000,927), 73('GUY','Guyana',214969.00,861000,928), 74('HTI','Haiti',27750.00,8222000,929), 75('HND','Honduras',112088.00,6485000,933), 76('HKG','Hong Kong',1075.00,6782000,937), 77('SJM','Svalbard and Jan Mayen',62422.00,3200,938), 78('IDN','Indonesia',1904569.00,212107000,939), 79('IND','India',3287263.00,1013662000,1109), 80('IRQ','Iraq',438317.00,23115000,1365), 81('IRN','Iran',1648195.00,67702000,1380), 82('IRL','Ireland',70273.00,3775100,1447), 83('ISL','Iceland',103000.00,279000,1449), 84('ISR','Israel',21056.00,6217000,1450), 85('ITA','Italy',301316.00,57680000,1464), 86('TMP','East Timor',14874.00,885000,1522), 87('AUT','Austria',83859.00,8091800,1523), 88('JAM','Jamaica',10990.00,2583000,1530), 89('JPN','Japan',377829.00,126714000,1532), 90('YEM','Yemen',527968.00,18112000,1780), 91('JOR','Jordan',88946.00,5083000,1786), 92('CXR','Christmas Island',135.00,2500,1791), 93('YUG','Yugoslavia',102173.00,10640000,1792), 94('KHM','Cambodia',181035.00,11168000,1800), 95('CMR','Cameroon',475442.00,15085000,1804), 96('CAN','Canada',9970610.00,31147000,1822), 97('CPV','Cape Verde',4033.00,428000,1859), 98('KAZ','Kazakstan',2724900.00,16223000,1864), 99('KEN','Kenya',580367.00,30080000,1881), 100('CAF','Central African Republic',622984.00,3615000,1889), 101('CHN','China',9572900.00,1277558000,1891), 102('KGZ','Kyrgyzstan',199900.00,4699000,2253), 103('KIR','Kiribati',726.00,83000,2256), 104('COL','Colombia',1138914.00,42321000,2257), 105('COM','Comoros',1862.00,578000,2295), 106('COG','Congo',342000.00,2943000,2296), 107('COD','Congo, The Democratic Republic of the',2344858.00,51654000,2298), 108('CCK','Cocos (Keeling) Islands',14.00,600,2317), 109('PRK','North Korea',120538.00,24039000,2318), 110('KOR','South Korea',99434.00,46844000,2331), 111('GRC','Greece',131626.00,10545700,2401), 112('HRV','Croatia',56538.00,4473000,2409), 113('CUB','Cuba',110861.00,11201000,2413), 114('KWT','Kuwait',17818.00,1972000,2429), 115('CYP','Cyprus',9251.00,754700,2430), 116('LAO','Laos',236800.00,5433000,2432), 117('LVA','Latvia',64589.00,2424200,2434), 118('LSO','Lesotho',30355.00,2153000,2437), 119('LBN','Lebanon',10400.00,3282000,2438), 120('LBR','Liberia',111369.00,3154000,2440), 121('LBY','Libyan Arab Jamahiriya',1759540.00,5605000,2441), 122('LIE','Liechtenstein',160.00,32300,2446), 123('LTU','Lithuania',65301.00,3698500,2447), 124('LUX','Luxembourg',2586.00,435700,2452), 125('ESH','Western Sahara',266000.00,293000,2453), 126('MAC','Macao',18.00,473000,2454), 127('MDG','Madagascar',587041.00,15942000,2455), 128('MKD','Macedonia',25713.00,2024000,2460), 129('MWI','Malawi',118484.00,10925000,2462), 130('MDV','Maldives',298.00,286000,2463), 131('MYS','Malaysia',329758.00,22244000,2464), 132('MLI','Mali',1240192.00,11234000,2482), 133('MLT','Malta',316.00,380200,2484), 134('MAR','Morocco',446550.00,28351000,2486), 135('MHL','Marshall Islands',181.00,64000,2507), 136('MTQ','Martinique',1102.00,395000,2508), 137('MRT','Mauritania',1025520.00,2670000,2509), 138('MUS','Mauritius',2040.00,1158000,2511), 139('MYT','Mayotte',373.00,149000,2514), 140('MEX','Mexico',1958201.00,98881000,2515), 141('FSM','Micronesia, Federated States of',702.00,119000,2689), 142('MDA','Moldova',33851.00,4380000,2690), 143('MCO','Monaco',1.50,34000,2695), 144('MNG','Mongolia',1566500.00,2662000,2696), 145('MSR','Montserrat',102.00,11000,2697), 146('MOZ','Mozambique',801590.00,19680000,2698), 147('MMR','Myanmar',676578.00,45611000,2710), 148('NAM','Namibia',824292.00,1726000,2726), 149('NRU','Nauru',21.00,12000,2728), 150('NPL','Nepal',147181.00,23930000,2729), 151('NIC','Nicaragua',130000.00,5074000,2734), 152('NER','Niger',1267000.00,10730000,2738), 153('NGA','Nigeria',923768.00,111506000,2754), 154('NIU','Niue',260.00,2000,2805), 155('NFK','Norfolk Island',36.00,2000,2806), 156('NOR','Norway',323877.00,4478500,2807), 157('CIV','Côte dIvoire',322463.00,14786000,2814), 158('OMN','Oman',309500.00,2542000,2821), 159('PAK','Pakistan',796095.00,156483000,2831), 160('PLW','Palau',459.00,19000,2881), 161('PAN','Panama',75517.00,2856000,2882), 162('PNG','Papua New Guinea',462840.00,4807000,2884), 163('PRY','Paraguay',406752.00,5496000,2885), 164('PER','Peru',1285216.00,25662000,2890), 165('PCN','Pitcairn',49.00,50,2912), 166('MNP','Northern Mariana Islands',464.00,78000,2913), 167('PRT','Portugal',91982.00,9997600,2914), 168('PRI','Puerto Rico',8875.00,3869000,2919), 169('POL','Poland',323250.00,38653600,2928), 170('GNQ','Equatorial Guinea',28051.00,453000,2972), 171('QAT','Qatar',11000.00,599000,2973), 172('FRA','France',551500.00,59225700,2974), 173('GUF','French Guiana',90000.00,181000,3014), 174('PYF','French Polynesia',4000.00,235000,3016), 175('REU','Réunion',2510.00,699000,3017), 176('ROM','Romania',238391.00,22455500,3018), 177('RWA','Rwanda',26338.00,7733000,3047), 178('SWE','Sweden',449964.00,8861400,3048), 179('SHN','Saint Helena',314.00,6000,3063), 180('KNA','Saint Kitts and Nevis',261.00,38000,3064), 181('LCA','Saint Lucia',622.00,154000,3065), 182('VCT','Saint Vincent and the Grenadines',388.00,114000,3066), 183('SPM','Saint Pierre and Miquelon',242.00,7000,3067), 184('DEU','Germany',357022.00,82164700,3068), 185('SLB','Solomon Islands',28896.00,444000,3161), 186('ZMB','Zambia',752618.00,9169000,3162), 187('WSM','Samoa',2831.00,180000,3169), 188('SMR','San Marino',61.00,27000,3171), 189('STP','Sao Tome and Principe',964.00,147000,3172), 190('SAU','Saudi Arabia',2149690.00,21607000,3173), 191('SEN','Senegal',196722.00,9481000,3198), 192('SYC','Seychelles',455.00,77000,3206), 193('SLE','Sierra Leone',71740.00,4854000,3207), 194('SGP','Singapore',618.00,3567000,3208), 195('SVK','Slovakia',49012.00,5398700,3209), 196('SVN','Slovenia',20256.00,1987800,3212), 197('SOM','Somalia',637657.00,10097000,3214), 198('LKA','Sri Lanka',65610.00,18827000,3217), 199('SDN','Sudan',2505813.00,29490000,3225), 200('FIN','Finland',338145.00,5171300,3236), 201('SUR','Suriname',163265.00,417000,3243), 202('SWZ','Swaziland',17364.00,1008000,3244), 203('CHE','Switzerland',41284.00,7160400,3248), 204('SYR','Syria',185180.00,16125000,3250), 205('TJK','Tajikistan',143100.00,6188000,3261), 206('TWN','Taiwan',36188.00,22256000,3263), 207('TZA','Tanzania',883749.00,33517000,3306), 208('DNK','Denmark',43094.00,5330000,3315), 209('THA','Thailand',513115.00,61399000,3320), 210('TGO','Togo',56785.00,4629000,3332), 211('TKL','Tokelau',12.00,2000,3333), 212('TON','Tonga',650.00,99000,3334), 213('TTO','Trinidad and Tobago',5130.00,1295000,3336), 214('TCD','Chad',1284000.00,7651000,3337), 215('CZE','Czech Republic',78866.00,10278100,3339), 216('TUN','Tunisia',163610.00,9586000,3349), 217('TUR','Turkey',774815.00,66591000,3358), 218('TKM','Turkmenistan',488100.00,4459000,3419), 219('TCA','Turks and Caicos Islands',430.00,17000,3423), 220('TUV','Tuvalu',26.00,12000,3424), 221('UGA','Uganda',241038.00,21778000,3425), 222('UKR','Ukraine',603700.00,50456000,3426), 223('HUN','Hungary',93030.00,10043200,3483), 224('URY','Uruguay',175016.00,3337000,3492), 225('NCL','New Caledonia',18575.00,214000,3493), 226('NZL','New Zealand',270534.00,3862000,3499), 227('UZB','Uzbekistan',447400.00,24318000,3503), 228('BLR','Belarus',207600.00,10236000,3520), 229('WLF','Wallis and Futuna',200.00,15000,3536), 230('VUT','Vanuatu',12189.00,190000,3537), 231('VAT','Holy See (Vatican City State)',0.40,1000,3538), 232('VEN','Venezuela',912050.00,24170000,3539), 233('RUS','Russian Federation',17075400.00,146934000,3580), 234('VNM','Vietnam',331689.00,79832000,3770), 235('EST','Estonia',45227.00,1439200,3791), 236('USA','United States',9363520.00,278357000,3813), 237('VIR','Virgin Islands, U.S.',347.00,93000,4067), 238('ZWE','Zimbabwe',390757.00,11669000,4068), 239('PSE','Palestine',6257.00,3101000,4074), 240('ATA','Antarctica',13120000.00,0,NULL), 241('BVT','Bouvet Island',59.00,0,NULL), 242('IOT','British Indian Ocean Territory',78.00,0,NULL), 243('SGS','South Georgia and the South Sandwich Islands',3903.00,0,NULL), 244('HMD','Heard Island and McDonald Islands',359.00,0,NULL), 245('ATF','French Southern territories',7780.00,0,NULL), 246('UMI','United States Minor Outlying Islands',16.00,0,NULL); 247 248# Table City 249 250INSERT INTO City VALUES 251(1,'Kabul','AFG',1780000), 252(2,'Qandahar','AFG',237500), 253(3,'Herat','AFG',186800), 254(4,'Mazar-e-Sharif','AFG',127800), 255(5,'Amsterdam','NLD',731200), 256(6,'Rotterdam','NLD',593321), 257(7,'Haag','NLD',440900), 258(8,'Utrecht','NLD',234323), 259(9,'Eindhoven','NLD',201843), 260(10,'Tilburg','NLD',193238), 261(11,'Groningen','NLD',172701), 262(12,'Breda','NLD',160398), 263(13,'Apeldoorn','NLD',153491), 264(14,'Nijmegen','NLD',152463), 265(15,'Enschede','NLD',149544), 266(16,'Haarlem','NLD',148772), 267(17,'Almere','NLD',142465), 268(18,'Arnhem','NLD',138020), 269(19,'Zaanstad','NLD',135621), 270(20,'´s-Hertogenbosch','NLD',129170), 271(21,'Amersfoort','NLD',126270), 272(22,'Maastricht','NLD',122087), 273(23,'Dordrecht','NLD',119811), 274(24,'Leiden','NLD',117196), 275(25,'Haarlemmermeer','NLD',110722), 276(26,'Zoetermeer','NLD',110214), 277(27,'Emmen','NLD',105853), 278(28,'Zwolle','NLD',105819), 279(29,'Ede','NLD',101574), 280(30,'Delft','NLD',95268), 281(31,'Heerlen','NLD',95052), 282(32,'Alkmaar','NLD',92713), 283(33,'Willemstad','ANT',2345), 284(34,'Tirana','ALB',270000), 285(35,'Alger','DZA',2168000), 286(36,'Oran','DZA',609823), 287(37,'Constantine','DZA',443727), 288(38,'Annaba','DZA',222518), 289(39,'Batna','DZA',183377), 290(40,'Sétif','DZA',179055), 291(41,'Sidi Bel Abbès','DZA',153106), 292(42,'Skikda','DZA',128747), 293(43,'Biskra','DZA',128281), 294(44,'Blida (el-Boulaida)','DZA',127284), 295(45,'Béjaïa','DZA',117162), 296(46,'Mostaganem','DZA',115212), 297(47,'Tébessa','DZA',112007), 298(48,'Tlemcen (Tilimsen)','DZA',110242), 299(49,'Béchar','DZA',107311), 300(50,'Tiaret','DZA',100118), 301(51,'Ech-Chleff (el-Asnam)','DZA',96794), 302(52,'Ghardaïa','DZA',89415), 303(53,'Tafuna','ASM',5200), 304(54,'Fagatogo','ASM',2323), 305(55,'Andorra la Vella','AND',21189), 306(56,'Luanda','AGO',2022000), 307(57,'Huambo','AGO',163100), 308(58,'Lobito','AGO',130000), 309(59,'Benguela','AGO',128300), 310(60,'Namibe','AGO',118200), 311(61,'South Hill','AIA',961), 312(62,'The Valley','AIA',595), 313(63,'Saint John´s','ATG',24000), 314(64,'Dubai','ARE',669181), 315(65,'Abu Dhabi','ARE',398695), 316(66,'Sharja','ARE',320095), 317(67,'al-Ayn','ARE',225970), 318(68,'Ajman','ARE',114395), 319(69,'Buenos Aires','ARG',2982146), 320(70,'La Matanza','ARG',1266461), 321(71,'Córdoba','ARG',1157507), 322(72,'Rosario','ARG',907718), 323(73,'Lomas de Zamora','ARG',622013), 324(74,'Quilmes','ARG',559249), 325(75,'Almirante Brown','ARG',538918), 326(76,'La Plata','ARG',521936), 327(77,'Mar del Plata','ARG',512880), 328(78,'San Miguel de Tucumán','ARG',470809), 329(79,'Lanús','ARG',469735), 330(80,'Merlo','ARG',463846), 331(81,'General San Martín','ARG',422542), 332(82,'Salta','ARG',367550), 333(83,'Moreno','ARG',356993), 334(84,'Santa Fé','ARG',353063), 335(85,'Avellaneda','ARG',353046), 336(86,'Tres de Febrero','ARG',352311), 337(87,'Morón','ARG',349246), 338(88,'Florencio Varela','ARG',315432), 339(89,'San Isidro','ARG',306341), 340(90,'Tigre','ARG',296226), 341(91,'Malvinas Argentinas','ARG',290335), 342(92,'Vicente López','ARG',288341), 343(93,'Berazategui','ARG',276916), 344(94,'Corrientes','ARG',258103), 345(95,'San Miguel','ARG',248700), 346(96,'Bahía Blanca','ARG',239810), 347(97,'Esteban Echeverría','ARG',235760), 348(98,'Resistencia','ARG',229212), 349(99,'José C. Paz','ARG',221754), 350(100,'Paraná','ARG',207041), 351(101,'Godoy Cruz','ARG',206998), 352(102,'Posadas','ARG',201273), 353(103,'Guaymallén','ARG',200595), 354(104,'Santiago del Estero','ARG',189947), 355(105,'San Salvador de Jujuy','ARG',178748), 356(106,'Hurlingham','ARG',170028), 357(107,'Neuquén','ARG',167296), 358(108,'Ituzaingó','ARG',158197), 359(109,'San Fernando','ARG',153036), 360(110,'Formosa','ARG',147636), 361(111,'Las Heras','ARG',145823), 362(112,'La Rioja','ARG',138117), 363(113,'San Fernando del Valle de Cata','ARG',134935), 364(114,'Río Cuarto','ARG',134355), 365(115,'Comodoro Rivadavia','ARG',124104), 366(116,'Mendoza','ARG',123027), 367(117,'San Nicolás de los Arroyos','ARG',119302), 368(118,'San Juan','ARG',119152), 369(119,'Escobar','ARG',116675), 370(120,'Concordia','ARG',116485), 371(121,'Pilar','ARG',113428), 372(122,'San Luis','ARG',110136), 373(123,'Ezeiza','ARG',99578), 374(124,'San Rafael','ARG',94651), 375(125,'Tandil','ARG',91101), 376(126,'Yerevan','ARM',1248700), 377(127,'Gjumri','ARM',211700), 378(128,'Vanadzor','ARM',172700), 379(129,'Oranjestad','ABW',29034), 380(130,'Sydney','AUS',3276207), 381(131,'Melbourne','AUS',2865329), 382(132,'Brisbane','AUS',1291117), 383(133,'Perth','AUS',1096829), 384(134,'Adelaide','AUS',978100), 385(135,'Canberra','AUS',322723), 386(136,'Gold Coast','AUS',311932), 387(137,'Newcastle','AUS',270324), 388(138,'Central Coast','AUS',227657), 389(139,'Wollongong','AUS',219761), 390(140,'Hobart','AUS',126118), 391(141,'Geelong','AUS',125382), 392(142,'Townsville','AUS',109914), 393(143,'Cairns','AUS',92273), 394(144,'Baku','AZE',1787800), 395(145,'Gäncä','AZE',299300), 396(146,'Sumqayit','AZE',283000), 397(147,'Mingäçevir','AZE',93900), 398(148,'Nassau','BHS',172000), 399(149,'al-Manama','BHR',148000), 400(150,'Dhaka','BGD',3612850), 401(151,'Chittagong','BGD',1392860), 402(152,'Khulna','BGD',663340), 403(153,'Rajshahi','BGD',294056), 404(154,'Narayanganj','BGD',202134), 405(155,'Rangpur','BGD',191398), 406(156,'Mymensingh','BGD',188713), 407(157,'Barisal','BGD',170232), 408(158,'Tungi','BGD',168702), 409(159,'Jessore','BGD',139710), 410(160,'Comilla','BGD',135313), 411(161,'Nawabganj','BGD',130577), 412(162,'Dinajpur','BGD',127815), 413(163,'Bogra','BGD',120170), 414(164,'Sylhet','BGD',117396), 415(165,'Brahmanbaria','BGD',109032), 416(166,'Tangail','BGD',106004), 417(167,'Jamalpur','BGD',103556), 418(168,'Pabna','BGD',103277), 419(169,'Naogaon','BGD',101266), 420(170,'Sirajganj','BGD',99669), 421(171,'Narsinghdi','BGD',98342), 422(172,'Saidpur','BGD',96777), 423(173,'Gazipur','BGD',96717), 424(174,'Bridgetown','BRB',6070), 425(175,'Antwerpen','BEL',446525), 426(176,'Gent','BEL',224180), 427(177,'Charleroi','BEL',200827), 428(178,'Liège','BEL',185639), 429(179,'Bruxelles [Brussel]','BEL',133859), 430(180,'Brugge','BEL',116246), 431(181,'Schaerbeek','BEL',105692), 432(182,'Namur','BEL',105419), 433(183,'Mons','BEL',90935), 434(184,'Belize City','BLZ',55810), 435(185,'Belmopan','BLZ',7105), 436(186,'Cotonou','BEN',536827), 437(187,'Porto-Novo','BEN',194000), 438(188,'Djougou','BEN',134099), 439(189,'Parakou','BEN',103577), 440(190,'Saint George','BMU',1800), 441(191,'Hamilton','BMU',1200), 442(192,'Thimphu','BTN',22000), 443(193,'Santa Cruz de la Sierra','BOL',935361), 444(194,'La Paz','BOL',758141), 445(195,'El Alto','BOL',534466), 446(196,'Cochabamba','BOL',482800), 447(197,'Oruro','BOL',223553), 448(198,'Sucre','BOL',178426), 449(199,'Potosí','BOL',140642), 450(200,'Tarija','BOL',125255); 451INSERT INTO City VALUES 452(201,'Sarajevo','BIH',360000), 453(202,'Banja Luka','BIH',143079), 454(203,'Zenica','BIH',96027), 455(204,'Gaborone','BWA',213017), 456(205,'Francistown','BWA',101805), 457(206,'São Paulo','BRA',9968485), 458(207,'Rio de Janeiro','BRA',5598953), 459(208,'Salvador','BRA',2302832), 460(209,'Belo Horizonte','BRA',2139125), 461(210,'Fortaleza','BRA',2097757), 462(211,'Brasília','BRA',1969868), 463(212,'Curitiba','BRA',1584232), 464(213,'Recife','BRA',1378087), 465(214,'Porto Alegre','BRA',1314032), 466(215,'Manaus','BRA',1255049), 467(216,'Belém','BRA',1186926), 468(217,'Guarulhos','BRA',1095874), 469(218,'Goiânia','BRA',1056330), 470(219,'Campinas','BRA',950043), 471(220,'São Gonçalo','BRA',869254), 472(221,'Nova Iguaçu','BRA',862225), 473(222,'São Luís','BRA',837588), 474(223,'Maceió','BRA',786288), 475(224,'Duque de Caxias','BRA',746758), 476(225,'São Bernardo do Campo','BRA',723132), 477(226,'Teresina','BRA',691942), 478(227,'Natal','BRA',688955), 479(228,'Osasco','BRA',659604), 480(229,'Campo Grande','BRA',649593), 481(230,'Santo André','BRA',630073), 482(231,'João Pessoa','BRA',584029), 483(232,'Jaboatão dos Guararapes','BRA',558680), 484(233,'Contagem','BRA',520801), 485(234,'São José dos Campos','BRA',515553), 486(235,'Uberlândia','BRA',487222), 487(236,'Feira de Santana','BRA',479992), 488(237,'Ribeirão Preto','BRA',473276), 489(238,'Sorocaba','BRA',466823), 490(239,'Niterói','BRA',459884), 491(240,'Cuiabá','BRA',453813), 492(241,'Juiz de Fora','BRA',450288), 493(242,'Aracaju','BRA',445555), 494(243,'São João de Meriti','BRA',440052), 495(244,'Londrina','BRA',432257), 496(245,'Joinville','BRA',428011), 497(246,'Belford Roxo','BRA',425194), 498(247,'Santos','BRA',408748), 499(248,'Ananindeua','BRA',400940), 500(249,'Campos dos Goytacazes','BRA',398418), 501(250,'Mauá','BRA',375055), 502(251,'Carapicuíba','BRA',357552), 503(252,'Olinda','BRA',354732), 504(253,'Campina Grande','BRA',352497), 505(254,'São José do Rio Preto','BRA',351944), 506(255,'Caxias do Sul','BRA',349581), 507(256,'Moji das Cruzes','BRA',339194), 508(257,'Diadema','BRA',335078), 509(258,'Aparecida de Goiânia','BRA',324662), 510(259,'Piracicaba','BRA',319104), 511(260,'Cariacica','BRA',319033), 512(261,'Vila Velha','BRA',318758), 513(262,'Pelotas','BRA',315415), 514(263,'Bauru','BRA',313670), 515(264,'Porto Velho','BRA',309750), 516(265,'Serra','BRA',302666), 517(266,'Betim','BRA',302108), 518(267,'Jundíaí','BRA',296127), 519(268,'Canoas','BRA',294125), 520(269,'Franca','BRA',290139), 521(270,'São Vicente','BRA',286848), 522(271,'Maringá','BRA',286461), 523(272,'Montes Claros','BRA',286058), 524(273,'Anápolis','BRA',282197), 525(274,'Florianópolis','BRA',281928), 526(275,'Petrópolis','BRA',279183), 527(276,'Itaquaquecetuba','BRA',270874), 528(277,'Vitória','BRA',270626), 529(278,'Ponta Grossa','BRA',268013), 530(279,'Rio Branco','BRA',259537), 531(280,'Foz do Iguaçu','BRA',259425), 532(281,'Macapá','BRA',256033), 533(282,'Ilhéus','BRA',254970), 534(283,'Vitória da Conquista','BRA',253587), 535(284,'Uberaba','BRA',249225), 536(285,'Paulista','BRA',248473), 537(286,'Limeira','BRA',245497), 538(287,'Blumenau','BRA',244379), 539(288,'Caruaru','BRA',244247), 540(289,'Santarém','BRA',241771), 541(290,'Volta Redonda','BRA',240315), 542(291,'Novo Hamburgo','BRA',239940), 543(292,'Caucaia','BRA',238738), 544(293,'Santa Maria','BRA',238473), 545(294,'Cascavel','BRA',237510), 546(295,'Guarujá','BRA',237206), 547(296,'Ribeirão das Neves','BRA',232685), 548(297,'Governador Valadares','BRA',231724), 549(298,'Taubaté','BRA',229130), 550(299,'Imperatriz','BRA',224564), 551(300,'Gravataí','BRA',223011), 552(301,'Embu','BRA',222223), 553(302,'Mossoró','BRA',214901), 554(303,'Várzea Grande','BRA',214435), 555(304,'Petrolina','BRA',210540), 556(305,'Barueri','BRA',208426), 557(306,'Viamão','BRA',207557), 558(307,'Ipatinga','BRA',206338), 559(308,'Juazeiro','BRA',201073), 560(309,'Juazeiro do Norte','BRA',199636), 561(310,'Taboão da Serra','BRA',197550), 562(311,'São José dos Pinhais','BRA',196884), 563(312,'Magé','BRA',196147), 564(313,'Suzano','BRA',195434), 565(314,'São Leopoldo','BRA',189258), 566(315,'Marília','BRA',188691), 567(316,'São Carlos','BRA',187122), 568(317,'Sumaré','BRA',186205), 569(318,'Presidente Prudente','BRA',185340), 570(319,'Divinópolis','BRA',185047), 571(320,'Sete Lagoas','BRA',182984), 572(321,'Rio Grande','BRA',182222), 573(322,'Itabuna','BRA',182148), 574(323,'Jequié','BRA',179128), 575(324,'Arapiraca','BRA',178988), 576(325,'Colombo','BRA',177764), 577(326,'Americana','BRA',177409), 578(327,'Alvorada','BRA',175574), 579(328,'Araraquara','BRA',174381), 580(329,'Itaboraí','BRA',173977), 581(330,'Santa Bárbara d´Oeste','BRA',171657), 582(331,'Nova Friburgo','BRA',170697), 583(332,'Jacareí','BRA',170356), 584(333,'Araçatuba','BRA',169303), 585(334,'Barra Mansa','BRA',168953), 586(335,'Praia Grande','BRA',168434), 587(336,'Marabá','BRA',167795), 588(337,'Criciúma','BRA',167661), 589(338,'Boa Vista','BRA',167185), 590(339,'Passo Fundo','BRA',166343), 591(340,'Dourados','BRA',164716), 592(341,'Santa Luzia','BRA',164704), 593(342,'Rio Claro','BRA',163551), 594(343,'Maracanaú','BRA',162022), 595(344,'Guarapuava','BRA',160510), 596(345,'Rondonópolis','BRA',155115), 597(346,'São José','BRA',155105), 598(347,'Cachoeiro de Itapemirim','BRA',155024), 599(348,'Nilópolis','BRA',153383), 600(349,'Itapevi','BRA',150664), 601(350,'Cabo de Santo Agostinho','BRA',149964), 602(351,'Camaçari','BRA',149146), 603(352,'Sobral','BRA',146005), 604(353,'Itajaí','BRA',145197), 605(354,'Chapecó','BRA',144158), 606(355,'Cotia','BRA',140042), 607(356,'Lages','BRA',139570), 608(357,'Ferraz de Vasconcelos','BRA',139283), 609(358,'Indaiatuba','BRA',135968), 610(359,'Hortolândia','BRA',135755), 611(360,'Caxias','BRA',133980), 612(361,'São Caetano do Sul','BRA',133321), 613(362,'Itu','BRA',132736), 614(363,'Nossa Senhora do Socorro','BRA',131351), 615(364,'Parnaíba','BRA',129756), 616(365,'Poços de Caldas','BRA',129683), 617(366,'Teresópolis','BRA',128079), 618(367,'Barreiras','BRA',127801), 619(368,'Castanhal','BRA',127634), 620(369,'Alagoinhas','BRA',126820), 621(370,'Itapecerica da Serra','BRA',126672), 622(371,'Uruguaiana','BRA',126305), 623(372,'Paranaguá','BRA',126076), 624(373,'Ibirité','BRA',125982), 625(374,'Timon','BRA',125812), 626(375,'Luziânia','BRA',125597), 627(376,'Macaé','BRA',125597), 628(377,'Teófilo Otoni','BRA',124489), 629(378,'Moji-Guaçu','BRA',123782), 630(379,'Palmas','BRA',121919), 631(380,'Pindamonhangaba','BRA',121904), 632(381,'Francisco Morato','BRA',121197), 633(382,'Bagé','BRA',120793), 634(383,'Sapucaia do Sul','BRA',120217), 635(384,'Cabo Frio','BRA',119503), 636(385,'Itapetininga','BRA',119391), 637(386,'Patos de Minas','BRA',119262), 638(387,'Camaragibe','BRA',118968), 639(388,'Bragança Paulista','BRA',116929), 640(389,'Queimados','BRA',115020), 641(390,'Araguaína','BRA',114948), 642(391,'Garanhuns','BRA',114603), 643(392,'Vitória de Santo Antão','BRA',113595), 644(393,'Santa Rita','BRA',113135), 645(394,'Barbacena','BRA',113079), 646(395,'Abaetetuba','BRA',111258), 647(396,'Jaú','BRA',109965), 648(397,'Lauro de Freitas','BRA',109236), 649(398,'Franco da Rocha','BRA',108964), 650(399,'Teixeira de Freitas','BRA',108441), 651(400,'Varginha','BRA',108314); 652INSERT IGNORE INTO City VALUES 653(401,'Ribeirão Pires','BRA',108121), 654(402,'Sabará','BRA',107781), 655(403,'Catanduva','BRA',107761), 656(404,'Rio Verde','BRA',107755), 657(405,'Botucatu','BRA',107663), 658(406,'Colatina','BRA',107354), 659(407,'Santa Cruz do Sul','BRA',106734), 660(408,'Linhares','BRA',106278), 661(409,'Apucarana','BRA',105114), 662(410,'Barretos','BRA',104156), 663(411,'Guaratinguetá','BRA',103433), 664(412,'Cachoeirinha','BRA',103240), 665(413,'Codó','BRA',103153), 666(414,'Jaraguá do Sul','BRA',102580), 667(415,'Cubatão','BRA',102372), 668(416,'Itabira','BRA',102217), 669(417,'Itaituba','BRA',101320), 670(418,'Araras','BRA',101046), 671(419,'Resende','BRA',100627), 672(420,'Atibaia','BRA',100356), 673(421,'Pouso Alegre','BRA',100028), 674(422,'Toledo','BRA',99387), 675(423,'Crato','BRA',98965), 676(424,'Passos','BRA',98570), 677(425,'Araguari','BRA',98399), 678(426,'São José de Ribamar','BRA',98318), 679(427,'Pinhais','BRA',98198), 680(428,'Sertãozinho','BRA',98140), 681(429,'Conselheiro Lafaiete','BRA',97507), 682(430,'Paulo Afonso','BRA',97291), 683(431,'Angra dos Reis','BRA',96864), 684(432,'Eunápolis','BRA',96610), 685(433,'Salto','BRA',96348), 686(434,'Ourinhos','BRA',96291), 687(435,'Parnamirim','BRA',96210), 688(436,'Jacobina','BRA',96131), 689(437,'Coronel Fabriciano','BRA',95933), 690(438,'Birigui','BRA',94685), 691(439,'Tatuí','BRA',93897), 692(440,'Ji-Paraná','BRA',93346), 693(441,'Bacabal','BRA',93121), 694(442,'Cametá','BRA',92779), 695(443,'Guaíba','BRA',92224), 696(444,'São Lourenço da Mata','BRA',91999), 697(445,'Santana do Livramento','BRA',91779), 698(446,'Votorantim','BRA',91777), 699(447,'Campo Largo','BRA',91203), 700(448,'Patos','BRA',90519), 701(449,'Ituiutaba','BRA',90507), 702(450,'Corumbá','BRA',90111), 703(451,'Palhoça','BRA',89465), 704(452,'Barra do Piraí','BRA',89388), 705(453,'Bento Gonçalves','BRA',89254), 706(454,'Poá','BRA',89236), 707(455,'Águas Lindas de Goiás','BRA',89200), 708(456,'London','GBR',7285000), 709(457,'Birmingham','GBR',1013000), 710(458,'Glasgow','GBR',619680), 711(459,'Liverpool','GBR',461000), 712(460,'Edinburgh','GBR',450180), 713(461,'Sheffield','GBR',431607), 714(462,'Manchester','GBR',430000), 715(463,'Leeds','GBR',424194), 716(464,'Bristol','GBR',402000), 717(465,'Cardiff','GBR',321000), 718(466,'Coventry','GBR',304000), 719(467,'Leicester','GBR',294000), 720(468,'Bradford','GBR',289376), 721(469,'Belfast','GBR',287500), 722(470,'Nottingham','GBR',287000), 723(471,'Kingston upon Hull','GBR',262000), 724(472,'Plymouth','GBR',253000), 725(473,'Stoke-on-Trent','GBR',252000), 726(474,'Wolverhampton','GBR',242000), 727(475,'Derby','GBR',236000), 728(476,'Swansea','GBR',230000), 729(477,'Southampton','GBR',216000), 730(478,'Aberdeen','GBR',213070), 731(479,'Northampton','GBR',196000), 732(480,'Dudley','GBR',192171), 733(481,'Portsmouth','GBR',190000), 734(482,'Newcastle upon Tyne','GBR',189150), 735(483,'Sunderland','GBR',183310), 736(484,'Luton','GBR',183000), 737(485,'Swindon','GBR',180000), 738(486,'Southend-on-Sea','GBR',176000), 739(487,'Walsall','GBR',174739), 740(488,'Bournemouth','GBR',162000), 741(489,'Peterborough','GBR',156000), 742(490,'Brighton','GBR',156124), 743(491,'Blackpool','GBR',151000), 744(492,'Dundee','GBR',146690), 745(493,'West Bromwich','GBR',146386), 746(494,'Reading','GBR',148000), 747(495,'Oldbury/Smethwick (Warley)','GBR',145542), 748(496,'Middlesbrough','GBR',145000), 749(497,'Huddersfield','GBR',143726), 750(498,'Oxford','GBR',144000), 751(499,'Poole','GBR',141000), 752(500,'Bolton','GBR',139020), 753(501,'Blackburn','GBR',140000), 754(502,'Newport','GBR',139000), 755(503,'Preston','GBR',135000), 756(504,'Stockport','GBR',132813), 757(505,'Norwich','GBR',124000), 758(506,'Rotherham','GBR',121380), 759(507,'Cambridge','GBR',121000), 760(508,'Watford','GBR',113080), 761(509,'Ipswich','GBR',114000), 762(510,'Slough','GBR',112000), 763(511,'Exeter','GBR',111000), 764(512,'Cheltenham','GBR',106000), 765(513,'Gloucester','GBR',107000), 766(514,'Saint Helens','GBR',106293), 767(515,'Sutton Coldfield','GBR',106001), 768(516,'York','GBR',104425), 769(517,'Oldham','GBR',103931), 770(518,'Basildon','GBR',100924), 771(519,'Worthing','GBR',100000), 772(520,'Chelmsford','GBR',97451), 773(521,'Colchester','GBR',96063), 774(522,'Crawley','GBR',97000), 775(523,'Gillingham','GBR',92000), 776(524,'Solihull','GBR',94531), 777(525,'Rochdale','GBR',94313), 778(526,'Birkenhead','GBR',93087), 779(527,'Worcester','GBR',95000), 780(528,'Hartlepool','GBR',92000), 781(529,'Halifax','GBR',91069), 782(530,'Woking/Byfleet','GBR',92000), 783(531,'Southport','GBR',90959), 784(532,'Maidstone','GBR',90878), 785(533,'Eastbourne','GBR',90000), 786(534,'Grimsby','GBR',89000), 787(535,'Saint Helier','GBR',27523), 788(536,'Douglas','GBR',23487), 789(537,'Road Town','VGB',8000), 790(538,'Bandar Seri Begawan','BRN',21484), 791(539,'Sofija','BGR',1122302), 792(540,'Plovdiv','BGR',342584), 793(541,'Varna','BGR',299801), 794(542,'Burgas','BGR',195255), 795(543,'Ruse','BGR',166467), 796(544,'Stara Zagora','BGR',147939), 797(545,'Pleven','BGR',121952), 798(546,'Sliven','BGR',105530), 799(547,'Dobric','BGR',100399), 800(548,'umen','BGR',94686), 801(549,'Ouagadougou','BFA',824000), 802(550,'Bobo-Dioulasso','BFA',300000), 803(551,'Koudougou','BFA',105000), 804(552,'Bujumbura','BDI',300000), 805(553,'George Town','CYM',19600), 806(554,'Santiago de Chile','CHL',4703954), 807(555,'Puente Alto','CHL',386236), 808(556,'Viña del Mar','CHL',312493), 809(557,'Valparaíso','CHL',293800), 810(558,'Talcahuano','CHL',277752), 811(559,'Antofagasta','CHL',251429), 812(560,'San Bernardo','CHL',241910), 813(561,'Temuco','CHL',233041), 814(562,'Concepción','CHL',217664), 815(563,'Rancagua','CHL',212977), 816(564,'Arica','CHL',189036), 817(565,'Talca','CHL',187557), 818(566,'Chillán','CHL',178182), 819(567,'Iquique','CHL',177892), 820(568,'Los Angeles','CHL',158215), 821(569,'Puerto Montt','CHL',152194), 822(570,'Coquimbo','CHL',143353), 823(571,'Osorno','CHL',141468), 824(572,'La Serena','CHL',137409), 825(573,'Calama','CHL',137265), 826(574,'Valdivia','CHL',133106), 827(575,'Punta Arenas','CHL',125631), 828(576,'Copiapó','CHL',120128), 829(577,'Quilpué','CHL',118857), 830(578,'Curicó','CHL',115766), 831(579,'Ovalle','CHL',94854), 832(580,'Coronel','CHL',93061), 833(581,'San Pedro de la Paz','CHL',91684), 834(582,'Melipilla','CHL',91056), 835(583,'Avarua','COK',11900), 836(584,'San José','CRI',339131), 837(585,'Djibouti','DJI',383000), 838(586,'Roseau','DMA',16243), 839(587,'Santo Domingo de Guzmán','DOM',1609966), 840(588,'Santiago de los Caballeros','DOM',365463), 841(589,'La Romana','DOM',140204), 842(590,'San Pedro de Macorís','DOM',124735), 843(591,'San Francisco de Macorís','DOM',108485), 844(592,'San Felipe de Puerto Plata','DOM',89423), 845(593,'Guayaquil','ECU',2070040), 846(594,'Quito','ECU',1573458), 847(595,'Cuenca','ECU',270353), 848(596,'Machala','ECU',210368), 849(597,'Santo Domingo de los Colorados','ECU',202111), 850(598,'Portoviejo','ECU',176413), 851(599,'Ambato','ECU',169612), 852(600,'Manta','ECU',164739); 853INSERT INTO City VALUES 854(601,'Duran [Eloy Alfaro]','ECU',152514), 855(602,'Ibarra','ECU',130643), 856(603,'Quevedo','ECU',129631), 857(604,'Milagro','ECU',124177), 858(605,'Loja','ECU',123875), 859(606,'Ríobamba','ECU',123163), 860(607,'Esmeraldas','ECU',123045), 861(608,'Cairo','EGY',6789479), 862(609,'Alexandria','EGY',3328196), 863(610,'Giza','EGY',2221868), 864(611,'Shubra al-Khayma','EGY',870716), 865(612,'Port Said','EGY',469533), 866(613,'Suez','EGY',417610), 867(614,'al-Mahallat al-Kubra','EGY',395402), 868(615,'Tanta','EGY',371010), 869(616,'al-Mansura','EGY',369621), 870(617,'Luxor','EGY',360503), 871(618,'Asyut','EGY',343498), 872(619,'Bahtim','EGY',275807), 873(620,'Zagazig','EGY',267351), 874(621,'al-Faiyum','EGY',260964), 875(622,'Ismailia','EGY',254477), 876(623,'Kafr al-Dawwar','EGY',231978), 877(624,'Assuan','EGY',219017), 878(625,'Damanhur','EGY',212203), 879(626,'al-Minya','EGY',201360), 880(627,'Bani Suwayf','EGY',172032), 881(628,'Qina','EGY',171275), 882(629,'Sawhaj','EGY',170125), 883(630,'Shibin al-Kawm','EGY',159909), 884(631,'Bulaq al-Dakrur','EGY',148787), 885(632,'Banha','EGY',145792), 886(633,'Warraq al-Arab','EGY',127108), 887(634,'Kafr al-Shaykh','EGY',124819), 888(635,'Mallawi','EGY',119283), 889(636,'Bilbays','EGY',113608), 890(637,'Mit Ghamr','EGY',101801), 891(638,'al-Arish','EGY',100447), 892(639,'Talkha','EGY',97700), 893(640,'Qalyub','EGY',97200), 894(641,'Jirja','EGY',95400), 895(642,'Idfu','EGY',94200), 896(643,'al-Hawamidiya','EGY',91700), 897(644,'Disuq','EGY',91300), 898(645,'San Salvador','SLV',415346), 899(646,'Santa Ana','SLV',139389), 900(647,'Mejicanos','SLV',138800), 901(648,'Soyapango','SLV',129800), 902(649,'San Miguel','SLV',127696), 903(650,'Nueva San Salvador','SLV',98400), 904(651,'Apopa','SLV',88800), 905(652,'Asmara','ERI',431000), 906(653,'Madrid','ESP',2879052), 907(654,'Barcelona','ESP',1503451), 908(655,'Valencia','ESP',739412), 909(656,'Sevilla','ESP',701927), 910(657,'Zaragoza','ESP',603367), 911(658,'Málaga','ESP',530553), 912(659,'Bilbao','ESP',357589), 913(660,'Las Palmas de Gran Canaria','ESP',354757), 914(661,'Murcia','ESP',353504), 915(662,'Palma de Mallorca','ESP',326993), 916(663,'Valladolid','ESP',319998), 917(664,'Córdoba','ESP',311708), 918(665,'Vigo','ESP',283670), 919(666,'Alicante [Alacant]','ESP',272432), 920(667,'Gijón','ESP',267980), 921(668,'L´Hospitalet de Llobregat','ESP',247986), 922(669,'Granada','ESP',244767), 923(670,'A Coruña (La Coruña)','ESP',243402), 924(671,'Vitoria-Gasteiz','ESP',217154), 925(672,'Santa Cruz de Tenerife','ESP',213050), 926(673,'Badalona','ESP',209635), 927(674,'Oviedo','ESP',200453), 928(675,'Móstoles','ESP',195351), 929(676,'Elche [Elx]','ESP',193174), 930(677,'Sabadell','ESP',184859), 931(678,'Santander','ESP',184165), 932(679,'Jerez de la Frontera','ESP',182660), 933(680,'Pamplona [Iruña]','ESP',180483), 934(681,'Donostia-San Sebastián','ESP',179208), 935(682,'Cartagena','ESP',177709), 936(683,'Leganés','ESP',173163), 937(684,'Fuenlabrada','ESP',171173), 938(685,'Almería','ESP',169027), 939(686,'Terrassa','ESP',168695), 940(687,'Alcalá de Henares','ESP',164463), 941(688,'Burgos','ESP',162802), 942(689,'Salamanca','ESP',158720), 943(690,'Albacete','ESP',147527), 944(691,'Getafe','ESP',145371), 945(692,'Cádiz','ESP',142449), 946(693,'Alcorcón','ESP',142048), 947(694,'Huelva','ESP',140583), 948(695,'León','ESP',139809), 949(696,'Castellón de la Plana [Castell','ESP',139712), 950(697,'Badajoz','ESP',136613), 951(698,'[San Cristóbal de] la Laguna','ESP',127945), 952(699,'Logroño','ESP',127093), 953(700,'Santa Coloma de Gramenet','ESP',120802), 954(701,'Tarragona','ESP',113016), 955(702,'Lleida (Lérida)','ESP',112207), 956(703,'Jaén','ESP',109247), 957(704,'Ourense (Orense)','ESP',109120), 958(705,'Mataró','ESP',104095), 959(706,'Algeciras','ESP',103106), 960(707,'Marbella','ESP',101144), 961(708,'Barakaldo','ESP',98212), 962(709,'Dos Hermanas','ESP',94591), 963(710,'Santiago de Compostela','ESP',93745), 964(711,'Torrejón de Ardoz','ESP',92262), 965(712,'Cape Town','ZAF',2352121), 966(713,'Soweto','ZAF',904165), 967(714,'Johannesburg','ZAF',756653), 968(715,'Port Elizabeth','ZAF',752319), 969(716,'Pretoria','ZAF',658630), 970(717,'Inanda','ZAF',634065), 971(718,'Durban','ZAF',566120), 972(719,'Vanderbijlpark','ZAF',468931), 973(720,'Kempton Park','ZAF',442633), 974(721,'Alberton','ZAF',410102), 975(722,'Pinetown','ZAF',378810), 976(723,'Pietermaritzburg','ZAF',370190), 977(724,'Benoni','ZAF',365467), 978(725,'Randburg','ZAF',341288), 979(726,'Umlazi','ZAF',339233), 980(727,'Bloemfontein','ZAF',334341), 981(728,'Vereeniging','ZAF',328535), 982(729,'Wonderboom','ZAF',283289), 983(730,'Roodepoort','ZAF',279340), 984(731,'Boksburg','ZAF',262648), 985(732,'Klerksdorp','ZAF',261911), 986(733,'Soshanguve','ZAF',242727), 987(734,'Newcastle','ZAF',222993), 988(735,'East London','ZAF',221047), 989(736,'Welkom','ZAF',203296), 990(737,'Kimberley','ZAF',197254), 991(738,'Uitenhage','ZAF',192120), 992(739,'Chatsworth','ZAF',189885), 993(740,'Mdantsane','ZAF',182639), 994(741,'Krugersdorp','ZAF',181503), 995(742,'Botshabelo','ZAF',177971), 996(743,'Brakpan','ZAF',171363), 997(744,'Witbank','ZAF',167183), 998(745,'Oberholzer','ZAF',164367), 999(746,'Germiston','ZAF',164252), 1000(747,'Springs','ZAF',162072), 1001(748,'Westonaria','ZAF',159632), 1002(749,'Randfontein','ZAF',120838), 1003(750,'Paarl','ZAF',105768), 1004(751,'Potchefstroom','ZAF',101817), 1005(752,'Rustenburg','ZAF',97008), 1006(753,'Nigel','ZAF',96734), 1007(754,'George','ZAF',93818), 1008(755,'Ladysmith','ZAF',89292), 1009(756,'Addis Abeba','ETH',2495000), 1010(757,'Dire Dawa','ETH',164851), 1011(758,'Nazret','ETH',127842), 1012(759,'Gonder','ETH',112249), 1013(760,'Dese','ETH',97314), 1014(761,'Mekele','ETH',96938), 1015(762,'Bahir Dar','ETH',96140), 1016(763,'Stanley','FLK',1636), 1017(764,'Suva','FJI',77366), 1018(765,'Quezon','PHL',2173831), 1019(766,'Manila','PHL',1581082), 1020(767,'Kalookan','PHL',1177604), 1021(768,'Davao','PHL',1147116), 1022(769,'Cebu','PHL',718821), 1023(770,'Zamboanga','PHL',601794), 1024(771,'Pasig','PHL',505058), 1025(772,'Valenzuela','PHL',485433), 1026(773,'Las Piñas','PHL',472780), 1027(774,'Antipolo','PHL',470866), 1028(775,'Taguig','PHL',467375), 1029(776,'Cagayan de Oro','PHL',461877), 1030(777,'Parañaque','PHL',449811), 1031(778,'Makati','PHL',444867), 1032(779,'Bacolod','PHL',429076), 1033(780,'General Santos','PHL',411822), 1034(781,'Marikina','PHL',391170), 1035(782,'Dasmariñas','PHL',379520), 1036(783,'Muntinlupa','PHL',379310), 1037(784,'Iloilo','PHL',365820), 1038(785,'Pasay','PHL',354908), 1039(786,'Malabon','PHL',338855), 1040(787,'San José del Monte','PHL',315807), 1041(788,'Bacoor','PHL',305699), 1042(789,'Iligan','PHL',285061), 1043(790,'Calamba','PHL',281146), 1044(791,'Mandaluyong','PHL',278474), 1045(792,'Butuan','PHL',267279), 1046(793,'Angeles','PHL',263971), 1047(794,'Tarlac','PHL',262481), 1048(795,'Mandaue','PHL',259728), 1049(796,'Baguio','PHL',252386), 1050(797,'Batangas','PHL',247588), 1051(798,'Cainta','PHL',242511), 1052(799,'San Pedro','PHL',231403), 1053 (800,'Navotas','PHL',230403); 1054INSERT INTO City VALUES 1055(801,'Cabanatuan','PHL',222859), 1056(802,'San Fernando','PHL',221857), 1057(803,'Lipa','PHL',218447), 1058(804,'Lapu-Lapu','PHL',217019), 1059(805,'San Pablo','PHL',207927), 1060(806,'Biñan','PHL',201186), 1061(807,'Taytay','PHL',198183), 1062(808,'Lucena','PHL',196075), 1063(809,'Imus','PHL',195482), 1064(810,'Olongapo','PHL',194260), 1065(811,'Binangonan','PHL',187691), 1066(812,'Santa Rosa','PHL',185633), 1067(813,'Tagum','PHL',179531), 1068(814,'Tacloban','PHL',178639), 1069(815,'Malolos','PHL',175291), 1070(816,'Mabalacat','PHL',171045), 1071(817,'Cotabato','PHL',163849), 1072(818,'Meycauayan','PHL',163037), 1073(819,'Puerto Princesa','PHL',161912), 1074(820,'Legazpi','PHL',157010), 1075(821,'Silang','PHL',156137), 1076(822,'Ormoc','PHL',154297), 1077(823,'San Carlos','PHL',154264), 1078(824,'Kabankalan','PHL',149769), 1079(825,'Talisay','PHL',148110), 1080(826,'Valencia','PHL',147924), 1081(827,'Calbayog','PHL',147187), 1082(828,'Santa Maria','PHL',144282), 1083(829,'Pagadian','PHL',142515), 1084(830,'Cadiz','PHL',141954), 1085(831,'Bago','PHL',141721), 1086(832,'Toledo','PHL',141174), 1087(833,'Naga','PHL',137810), 1088(834,'San Mateo','PHL',135603), 1089(835,'Panabo','PHL',133950), 1090(836,'Koronadal','PHL',133786), 1091(837,'Marawi','PHL',131090), 1092(838,'Dagupan','PHL',130328), 1093(839,'Sagay','PHL',129765), 1094(840,'Roxas','PHL',126352), 1095(841,'Lubao','PHL',125699), 1096(842,'Digos','PHL',125171), 1097(843,'San Miguel','PHL',123824), 1098(844,'Malaybalay','PHL',123672), 1099(845,'Tuguegarao','PHL',120645), 1100(846,'Ilagan','PHL',119990), 1101(847,'Baliuag','PHL',119675), 1102(848,'Surigao','PHL',118534), 1103(849,'San Carlos','PHL',118259), 1104(850,'San Juan del Monte','PHL',117680), 1105(851,'Tanauan','PHL',117539), 1106(852,'Concepcion','PHL',115171), 1107(853,'Rodriguez (Montalban)','PHL',115167), 1108(854,'Sariaya','PHL',114568), 1109(855,'Malasiqui','PHL',113190), 1110(856,'General Mariano Alvarez','PHL',112446), 1111(857,'Urdaneta','PHL',111582), 1112(858,'Hagonoy','PHL',111425), 1113(859,'San Jose','PHL',111009), 1114(860,'Polomolok','PHL',110709), 1115(861,'Santiago','PHL',110531), 1116(862,'Tanza','PHL',110517), 1117(863,'Ozamis','PHL',110420), 1118(864,'Mexico','PHL',109481), 1119(865,'San Jose','PHL',108254), 1120(866,'Silay','PHL',107722), 1121(867,'General Trias','PHL',107691), 1122(868,'Tabaco','PHL',107166), 1123(869,'Cabuyao','PHL',106630), 1124(870,'Calapan','PHL',105910), 1125(871,'Mati','PHL',105908), 1126(872,'Midsayap','PHL',105760), 1127(873,'Cauayan','PHL',103952), 1128(874,'Gingoog','PHL',102379), 1129(875,'Dumaguete','PHL',102265), 1130(876,'San Fernando','PHL',102082), 1131(877,'Arayat','PHL',101792), 1132(878,'Bayawan (Tulong)','PHL',101391), 1133(879,'Kidapawan','PHL',101205), 1134(880,'Daraga (Locsin)','PHL',101031), 1135(881,'Marilao','PHL',101017), 1136(882,'Malita','PHL',100000), 1137(883,'Dipolog','PHL',99862), 1138(884,'Cavite','PHL',99367), 1139(885,'Danao','PHL',98781), 1140(886,'Bislig','PHL',97860), 1141(887,'Talavera','PHL',97329), 1142(888,'Guagua','PHL',96858), 1143(889,'Bayambang','PHL',96609), 1144(890,'Nasugbu','PHL',96113), 1145(891,'Baybay','PHL',95630), 1146(892,'Capas','PHL',95219), 1147(893,'Sultan Kudarat','PHL',94861), 1148(894,'Laoag','PHL',94466), 1149(895,'Bayugan','PHL',93623), 1150(896,'Malungon','PHL',93232), 1151(897,'Santa Cruz','PHL',92694), 1152(898,'Sorsogon','PHL',92512), 1153(899,'Candelaria','PHL',92429), 1154(900,'Ligao','PHL',90603), 1155(901,'Tórshavn','FRO',14542), 1156(902,'Libreville','GAB',419000), 1157(903,'Serekunda','GMB',102600), 1158(904,'Banjul','GMB',42326), 1159(905,'Tbilisi','GEO',1235200), 1160(906,'Kutaisi','GEO',240900), 1161(907,'Rustavi','GEO',155400), 1162(908,'Batumi','GEO',137700), 1163(909,'Sohumi','GEO',111700), 1164(910,'Accra','GHA',1070000), 1165(911,'Kumasi','GHA',385192), 1166(912,'Tamale','GHA',151069), 1167(913,'Tema','GHA',109975), 1168(914,'Sekondi-Takoradi','GHA',103653), 1169(915,'Gibraltar','GIB',27025), 1170(916,'Saint George´s','GRD',4621), 1171(917,'Nuuk','GRL',13445), 1172(918,'Les Abymes','GLP',62947), 1173(919,'Basse-Terre','GLP',12433), 1174(920,'Tamuning','GUM',9500), 1175(921,'Agaña','GUM',1139), 1176(922,'Ciudad de Guatemala','GTM',823301), 1177(923,'Mixco','GTM',209791), 1178(924,'Villa Nueva','GTM',101295), 1179(925,'Quetzaltenango','GTM',90801), 1180(926,'Conakry','GIN',1090610), 1181(927,'Bissau','GNB',241000), 1182(928,'Georgetown','GUY',254000), 1183(929,'Port-au-Prince','HTI',884472), 1184(930,'Carrefour','HTI',290204), 1185(931,'Delmas','HTI',240429), 1186(932,'Le-Cap-Haïtien','HTI',102233), 1187(933,'Tegucigalpa','HND',813900), 1188(934,'San Pedro Sula','HND',383900), 1189(935,'La Ceiba','HND',89200), 1190(936,'Kowloon and New Kowloon','HKG',1987996), 1191(937,'Victoria','HKG',1312637), 1192(938,'Longyearbyen','SJM',1438), 1193(939,'Jakarta','IDN',9604900), 1194(940,'Surabaya','IDN',2663820), 1195(941,'Bandung','IDN',2429000), 1196(942,'Medan','IDN',1843919), 1197(943,'Palembang','IDN',1222764), 1198(944,'Tangerang','IDN',1198300), 1199(945,'Semarang','IDN',1104405), 1200(946,'Ujung Pandang','IDN',1060257), 1201(947,'Malang','IDN',716862), 1202(948,'Bandar Lampung','IDN',680332), 1203(949,'Bekasi','IDN',644300), 1204(950,'Padang','IDN',534474), 1205(951,'Surakarta','IDN',518600), 1206(952,'Banjarmasin','IDN',482931), 1207(953,'Pekan Baru','IDN',438638), 1208(954,'Denpasar','IDN',435000), 1209(955,'Yogyakarta','IDN',418944), 1210(956,'Pontianak','IDN',409632), 1211(957,'Samarinda','IDN',399175), 1212(958,'Jambi','IDN',385201), 1213(959,'Depok','IDN',365200), 1214(960,'Cimahi','IDN',344600), 1215(961,'Balikpapan','IDN',338752), 1216(962,'Manado','IDN',332288), 1217(963,'Mataram','IDN',306600), 1218(964,'Pekalongan','IDN',301504), 1219(965,'Tegal','IDN',289744), 1220(966,'Bogor','IDN',285114), 1221(967,'Ciputat','IDN',270800), 1222(968,'Pondokgede','IDN',263200), 1223(969,'Cirebon','IDN',254406), 1224(970,'Kediri','IDN',253760), 1225(971,'Ambon','IDN',249312), 1226(972,'Jember','IDN',218500), 1227(973,'Cilacap','IDN',206900), 1228(974,'Cimanggis','IDN',205100), 1229(975,'Pematang Siantar','IDN',203056), 1230(976,'Purwokerto','IDN',202500), 1231(977,'Ciomas','IDN',187400), 1232(978,'Tasikmalaya','IDN',179800), 1233(979,'Madiun','IDN',171532), 1234(980,'Bengkulu','IDN',146439), 1235(981,'Karawang','IDN',145000), 1236(982,'Banda Aceh','IDN',143409), 1237(983,'Palu','IDN',142800), 1238(984,'Pasuruan','IDN',134019), 1239(985,'Kupang','IDN',129300), 1240(986,'Tebing Tinggi','IDN',129300), 1241(987,'Percut Sei Tuan','IDN',129000), 1242(988,'Binjai','IDN',127222), 1243(989,'Sukabumi','IDN',125766), 1244(990,'Waru','IDN',124300), 1245(991,'Pangkal Pinang','IDN',124000), 1246(992,'Magelang','IDN',123800), 1247(993,'Blitar','IDN',122600), 1248(994,'Serang','IDN',122400), 1249(995,'Probolinggo','IDN',120770), 1250(996,'Cilegon','IDN',117000), 1251(997,'Cianjur','IDN',114300), 1252(998,'Ciparay','IDN',111500), 1253(999,'Lhokseumawe','IDN',109600), 1254(1000,'Taman','IDN',107000); 1255INSERT INTO City VALUES 1256(1001,'Depok','IDN',106800), 1257(1002,'Citeureup','IDN',105100), 1258(1003,'Pemalang','IDN',103500), 1259(1004,'Klaten','IDN',103300), 1260(1005,'Salatiga','IDN',103000), 1261(1006,'Cibinong','IDN',101300), 1262(1007,'Palangka Raya','IDN',99693), 1263(1008,'Mojokerto','IDN',96626), 1264(1009,'Purwakarta','IDN',95900), 1265(1010,'Garut','IDN',95800), 1266(1011,'Kudus','IDN',95300), 1267(1012,'Kendari','IDN',94800), 1268(1013,'Jaya Pura','IDN',94700), 1269(1014,'Gorontalo','IDN',94058), 1270(1015,'Majalaya','IDN',93200), 1271(1016,'Pondok Aren','IDN',92700), 1272(1017,'Jombang','IDN',92600), 1273(1018,'Sunggal','IDN',92300), 1274(1019,'Batam','IDN',91871), 1275(1020,'Padang Sidempuan','IDN',91200), 1276(1021,'Sawangan','IDN',91100), 1277(1022,'Banyuwangi','IDN',89900), 1278(1023,'Tanjung Pinang','IDN',89900), 1279(1024,'Mumbai (Bombay)','IND',10500000), 1280(1025,'Delhi','IND',7206704), 1281(1026,'Calcutta [Kolkata]','IND',4399819), 1282(1027,'Chennai (Madras)','IND',3841396), 1283(1028,'Hyderabad','IND',2964638), 1284(1029,'Ahmedabad','IND',2876710), 1285(1030,'Bangalore','IND',2660088), 1286(1031,'Kanpur','IND',1874409), 1287(1032,'Nagpur','IND',1624752), 1288(1033,'Lucknow','IND',1619115), 1289(1034,'Pune','IND',1566651), 1290(1035,'Surat','IND',1498817), 1291(1036,'Jaipur','IND',1458483), 1292(1037,'Indore','IND',1091674), 1293(1038,'Bhopal','IND',1062771), 1294(1039,'Ludhiana','IND',1042740), 1295(1040,'Vadodara (Baroda)','IND',1031346), 1296(1041,'Kalyan','IND',1014557), 1297(1042,'Madurai','IND',977856), 1298(1043,'Haora (Howrah)','IND',950435), 1299(1044,'Varanasi (Benares)','IND',929270), 1300(1045,'Patna','IND',917243), 1301(1046,'Srinagar','IND',892506), 1302(1047,'Agra','IND',891790), 1303(1048,'Coimbatore','IND',816321), 1304(1049,'Thane (Thana)','IND',803389), 1305(1050,'Allahabad','IND',792858), 1306(1051,'Meerut','IND',753778), 1307(1052,'Vishakhapatnam','IND',752037), 1308(1053,'Jabalpur','IND',741927), 1309(1054,'Amritsar','IND',708835), 1310(1055,'Faridabad','IND',703592), 1311(1056,'Vijayawada','IND',701827), 1312(1057,'Gwalior','IND',690765), 1313(1058,'Jodhpur','IND',666279), 1314(1059,'Nashik (Nasik)','IND',656925), 1315(1060,'Hubli-Dharwad','IND',648298), 1316(1061,'Solapur (Sholapur)','IND',604215), 1317(1062,'Ranchi','IND',599306), 1318(1063,'Bareilly','IND',587211), 1319(1064,'Guwahati (Gauhati)','IND',584342), 1320(1065,'Shambajinagar (Aurangabad)','IND',573272), 1321(1066,'Cochin (Kochi)','IND',564589), 1322(1067,'Rajkot','IND',559407), 1323(1068,'Kota','IND',537371), 1324(1069,'Thiruvananthapuram (Trivandrum','IND',524006), 1325(1070,'Pimpri-Chinchwad','IND',517083), 1326(1071,'Jalandhar (Jullundur)','IND',509510), 1327(1072,'Gorakhpur','IND',505566), 1328(1073,'Chandigarh','IND',504094), 1329(1074,'Mysore','IND',480692), 1330(1075,'Aligarh','IND',480520), 1331(1076,'Guntur','IND',471051), 1332(1077,'Jamshedpur','IND',460577), 1333(1078,'Ghaziabad','IND',454156), 1334(1079,'Warangal','IND',447657), 1335(1080,'Raipur','IND',438639), 1336(1081,'Moradabad','IND',429214), 1337(1082,'Durgapur','IND',425836), 1338(1083,'Amravati','IND',421576), 1339(1084,'Calicut (Kozhikode)','IND',419831), 1340(1085,'Bikaner','IND',416289), 1341(1086,'Bhubaneswar','IND',411542), 1342(1087,'Kolhapur','IND',406370), 1343(1088,'Kataka (Cuttack)','IND',403418), 1344(1089,'Ajmer','IND',402700), 1345(1090,'Bhavnagar','IND',402338), 1346(1091,'Tiruchirapalli','IND',387223), 1347(1092,'Bhilai','IND',386159), 1348(1093,'Bhiwandi','IND',379070), 1349(1094,'Saharanpur','IND',374945), 1350(1095,'Ulhasnagar','IND',369077), 1351(1096,'Salem','IND',366712), 1352(1097,'Ujjain','IND',362266), 1353(1098,'Malegaon','IND',342595), 1354(1099,'Jamnagar','IND',341637), 1355(1100,'Bokaro Steel City','IND',333683), 1356(1101,'Akola','IND',328034), 1357(1102,'Belgaum','IND',326399), 1358(1103,'Rajahmundry','IND',324851), 1359(1104,'Nellore','IND',316606), 1360(1105,'Udaipur','IND',308571), 1361(1106,'New Bombay','IND',307297), 1362(1107,'Bhatpara','IND',304952), 1363(1108,'Gulbarga','IND',304099), 1364(1109,'New Delhi','IND',301297), 1365(1110,'Jhansi','IND',300850), 1366(1111,'Gaya','IND',291675), 1367(1112,'Kakinada','IND',279980), 1368(1113,'Dhule (Dhulia)','IND',278317), 1369(1114,'Panihati','IND',275990), 1370(1115,'Nanded (Nander)','IND',275083), 1371(1116,'Mangalore','IND',273304), 1372(1117,'Dehra Dun','IND',270159), 1373(1118,'Kamarhati','IND',266889), 1374(1119,'Davangere','IND',266082), 1375(1120,'Asansol','IND',262188), 1376(1121,'Bhagalpur','IND',253225), 1377(1122,'Bellary','IND',245391), 1378(1123,'Barddhaman (Burdwan)','IND',245079), 1379(1124,'Rampur','IND',243742), 1380(1125,'Jalgaon','IND',242193), 1381(1126,'Muzaffarpur','IND',241107), 1382(1127,'Nizamabad','IND',241034), 1383(1128,'Muzaffarnagar','IND',240609), 1384(1129,'Patiala','IND',238368), 1385(1130,'Shahjahanpur','IND',237713), 1386(1131,'Kurnool','IND',236800), 1387(1132,'Tiruppur (Tirupper)','IND',235661), 1388(1133,'Rohtak','IND',233400), 1389(1134,'South Dum Dum','IND',232811), 1390(1135,'Mathura','IND',226691), 1391(1136,'Chandrapur','IND',226105), 1392(1137,'Barahanagar (Baranagar)','IND',224821), 1393(1138,'Darbhanga','IND',218391), 1394(1139,'Siliguri (Shiliguri)','IND',216950), 1395(1140,'Raurkela','IND',215489), 1396(1141,'Ambattur','IND',215424), 1397(1142,'Panipat','IND',215218), 1398(1143,'Firozabad','IND',215128), 1399(1144,'Ichalkaranji','IND',214950), 1400(1145,'Jammu','IND',214737), 1401(1146,'Ramagundam','IND',214384), 1402(1147,'Eluru','IND',212866), 1403(1148,'Brahmapur','IND',210418), 1404(1149,'Alwar','IND',205086), 1405(1150,'Pondicherry','IND',203065), 1406(1151,'Thanjavur','IND',202013), 1407(1152,'Bihar Sharif','IND',201323), 1408(1153,'Tuticorin','IND',199854), 1409(1154,'Imphal','IND',198535), 1410(1155,'Latur','IND',197408), 1411(1156,'Sagar','IND',195346), 1412(1157,'Farrukhabad-cum-Fatehgarh','IND',194567), 1413(1158,'Sangli','IND',193197), 1414(1159,'Parbhani','IND',190255), 1415(1160,'Nagar Coil','IND',190084), 1416(1161,'Bijapur','IND',186939), 1417(1162,'Kukatpalle','IND',185378), 1418(1163,'Bally','IND',184474), 1419(1164,'Bhilwara','IND',183965), 1420(1165,'Ratlam','IND',183375), 1421(1166,'Avadi','IND',183215), 1422(1167,'Dindigul','IND',182477), 1423(1168,'Ahmadnagar','IND',181339), 1424(1169,'Bilaspur','IND',179833), 1425(1170,'Shimoga','IND',179258), 1426(1171,'Kharagpur','IND',177989), 1427(1172,'Mira Bhayandar','IND',175372), 1428(1173,'Vellore','IND',175061), 1429(1174,'Jalna','IND',174985), 1430(1175,'Burnpur','IND',174933), 1431(1176,'Anantapur','IND',174924), 1432(1177,'Allappuzha (Alleppey)','IND',174666), 1433(1178,'Tirupati','IND',174369), 1434(1179,'Karnal','IND',173751), 1435(1180,'Burhanpur','IND',172710), 1436(1181,'Hisar (Hissar)','IND',172677), 1437(1182,'Tiruvottiyur','IND',172562), 1438(1183,'Mirzapur-cum-Vindhyachal','IND',169336), 1439(1184,'Secunderabad','IND',167461), 1440(1185,'Nadiad','IND',167051), 1441(1186,'Dewas','IND',164364), 1442(1187,'Murwara (Katni)','IND',163431), 1443(1188,'Ganganagar','IND',161482), 1444(1189,'Vizianagaram','IND',160359), 1445(1190,'Erode','IND',159232), 1446(1191,'Machilipatnam (Masulipatam)','IND',159110), 1447(1192,'Bhatinda (Bathinda)','IND',159042), 1448(1193,'Raichur','IND',157551), 1449(1194,'Agartala','IND',157358), 1450(1195,'Arrah (Ara)','IND',157082), 1451(1196,'Satna','IND',156630), 1452(1197,'Lalbahadur Nagar','IND',155500), 1453(1198,'Aizawl','IND',155240), 1454(1199,'Uluberia','IND',155172), 1455(1200,'Katihar','IND',154367); 1456INSERT INTO City VALUES 1457(1201,'Cuddalore','IND',153086), 1458(1202,'Hugli-Chinsurah','IND',151806), 1459(1203,'Dhanbad','IND',151789), 1460(1204,'Raiganj','IND',151045), 1461(1205,'Sambhal','IND',150869), 1462(1206,'Durg','IND',150645), 1463(1207,'Munger (Monghyr)','IND',150112), 1464(1208,'Kanchipuram','IND',150100), 1465(1209,'North Dum Dum','IND',149965), 1466(1210,'Karimnagar','IND',148583), 1467(1211,'Bharatpur','IND',148519), 1468(1212,'Sikar','IND',148272), 1469(1213,'Hardwar (Haridwar)','IND',147305), 1470(1214,'Dabgram','IND',147217), 1471(1215,'Morena','IND',147124), 1472(1216,'Noida','IND',146514), 1473(1217,'Hapur','IND',146262), 1474(1218,'Bhusawal','IND',145143), 1475(1219,'Khandwa','IND',145133), 1476(1220,'Yamuna Nagar','IND',144346), 1477(1221,'Sonipat (Sonepat)','IND',143922), 1478(1222,'Tenali','IND',143726), 1479(1223,'Raurkela Civil Township','IND',140408), 1480(1224,'Kollam (Quilon)','IND',139852), 1481(1225,'Kumbakonam','IND',139483), 1482(1226,'Ingraj Bazar (English Bazar)','IND',139204), 1483(1227,'Timkur','IND',138903), 1484(1228,'Amroha','IND',137061), 1485(1229,'Serampore','IND',137028), 1486(1230,'Chapra','IND',136877), 1487(1231,'Pali','IND',136842), 1488(1232,'Maunath Bhanjan','IND',136697), 1489(1233,'Adoni','IND',136182), 1490(1234,'Jaunpur','IND',136062), 1491(1235,'Tirunelveli','IND',135825), 1492(1236,'Bahraich','IND',135400), 1493(1237,'Gadag Betigeri','IND',134051), 1494(1238,'Proddatur','IND',133914), 1495(1239,'Chittoor','IND',133462), 1496(1240,'Barrackpur','IND',133265), 1497(1241,'Bharuch (Broach)','IND',133102), 1498(1242,'Naihati','IND',132701), 1499(1243,'Shillong','IND',131719), 1500(1244,'Sambalpur','IND',131138), 1501(1245,'Junagadh','IND',130484), 1502(1246,'Rae Bareli','IND',129904), 1503(1247,'Rewa','IND',128981), 1504(1248,'Gurgaon','IND',128608), 1505(1249,'Khammam','IND',127992), 1506(1250,'Bulandshahr','IND',127201), 1507(1251,'Navsari','IND',126089), 1508(1252,'Malkajgiri','IND',126066), 1509(1253,'Midnapore (Medinipur)','IND',125498), 1510(1254,'Miraj','IND',125407), 1511(1255,'Raj Nandgaon','IND',125371), 1512(1256,'Alandur','IND',125244), 1513(1257,'Puri','IND',125199), 1514(1258,'Navadwip','IND',125037), 1515(1259,'Sirsa','IND',125000), 1516(1260,'Korba','IND',124501), 1517(1261,'Faizabad','IND',124437), 1518(1262,'Etawah','IND',124072), 1519(1263,'Pathankot','IND',123930), 1520(1264,'Gandhinagar','IND',123359), 1521(1265,'Palghat (Palakkad)','IND',123289), 1522(1266,'Veraval','IND',123000), 1523(1267,'Hoshiarpur','IND',122705), 1524(1268,'Ambala','IND',122596), 1525(1269,'Sitapur','IND',121842), 1526(1270,'Bhiwani','IND',121629), 1527(1271,'Cuddapah','IND',121463), 1528(1272,'Bhimavaram','IND',121314), 1529(1273,'Krishnanagar','IND',121110), 1530(1274,'Chandannagar','IND',120378), 1531(1275,'Mandya','IND',120265), 1532(1276,'Dibrugarh','IND',120127), 1533(1277,'Nandyal','IND',119813), 1534(1278,'Balurghat','IND',119796), 1535(1279,'Neyveli','IND',118080), 1536(1280,'Fatehpur','IND',117675), 1537(1281,'Mahbubnagar','IND',116833), 1538(1282,'Budaun','IND',116695), 1539(1283,'Porbandar','IND',116671), 1540(1284,'Silchar','IND',115483), 1541(1285,'Berhampore (Baharampur)','IND',115144), 1542(1286,'Purnea (Purnia)','IND',114912), 1543(1287,'Bankura','IND',114876), 1544(1288,'Rajapalaiyam','IND',114202), 1545(1289,'Titagarh','IND',114085), 1546(1290,'Halisahar','IND',114028), 1547(1291,'Hathras','IND',113285), 1548(1292,'Bhir (Bid)','IND',112434), 1549(1293,'Pallavaram','IND',111866), 1550(1294,'Anand','IND',110266), 1551(1295,'Mango','IND',110024), 1552(1296,'Santipur','IND',109956), 1553(1297,'Bhind','IND',109755), 1554(1298,'Gondiya','IND',109470), 1555(1299,'Tiruvannamalai','IND',109196), 1556(1300,'Yeotmal (Yavatmal)','IND',108578), 1557(1301,'Kulti-Barakar','IND',108518), 1558(1302,'Moga','IND',108304), 1559(1303,'Shivapuri','IND',108277), 1560(1304,'Bidar','IND',108016), 1561(1305,'Guntakal','IND',107592), 1562(1306,'Unnao','IND',107425), 1563(1307,'Barasat','IND',107365), 1564(1308,'Tambaram','IND',107187), 1565(1309,'Abohar','IND',107163), 1566(1310,'Pilibhit','IND',106605), 1567(1311,'Valparai','IND',106523), 1568(1312,'Gonda','IND',106078), 1569(1313,'Surendranagar','IND',105973), 1570(1314,'Qutubullapur','IND',105380), 1571(1315,'Beawar','IND',105363), 1572(1316,'Hindupur','IND',104651), 1573(1317,'Gandhidham','IND',104585), 1574(1318,'Haldwani-cum-Kathgodam','IND',104195), 1575(1319,'Tellicherry (Thalassery)','IND',103579), 1576(1320,'Wardha','IND',102985), 1577(1321,'Rishra','IND',102649), 1578(1322,'Bhuj','IND',102176), 1579(1323,'Modinagar','IND',101660), 1580(1324,'Gudivada','IND',101656), 1581(1325,'Basirhat','IND',101409), 1582(1326,'Uttarpara-Kotrung','IND',100867), 1583(1327,'Ongole','IND',100836), 1584(1328,'North Barrackpur','IND',100513), 1585(1329,'Guna','IND',100490), 1586(1330,'Haldia','IND',100347), 1587(1331,'Habra','IND',100223), 1588(1332,'Kanchrapara','IND',100194), 1589(1333,'Tonk','IND',100079), 1590(1334,'Champdani','IND',98818), 1591(1335,'Orai','IND',98640), 1592(1336,'Pudukkottai','IND',98619), 1593(1337,'Sasaram','IND',98220), 1594(1338,'Hazaribag','IND',97712), 1595(1339,'Palayankottai','IND',97662), 1596(1340,'Banda','IND',97227), 1597(1341,'Godhra','IND',96813), 1598(1342,'Hospet','IND',96322), 1599(1343,'Ashoknagar-Kalyangarh','IND',96315), 1600(1344,'Achalpur','IND',96216), 1601(1345,'Patan','IND',96109), 1602(1346,'Mandasor','IND',95758), 1603(1347,'Damoh','IND',95661), 1604(1348,'Satara','IND',95133), 1605(1349,'Meerut Cantonment','IND',94876), 1606(1350,'Dehri','IND',94526), 1607(1351,'Delhi Cantonment','IND',94326), 1608(1352,'Chhindwara','IND',93731), 1609(1353,'Bansberia','IND',93447), 1610(1354,'Nagaon','IND',93350), 1611(1355,'Kanpur Cantonment','IND',93109), 1612(1356,'Vidisha','IND',92917), 1613(1357,'Bettiah','IND',92583), 1614(1358,'Purulia','IND',92574), 1615(1359,'Hassan','IND',90803), 1616(1360,'Ambala Sadar','IND',90712), 1617(1361,'Baidyabati','IND',90601), 1618(1362,'Morvi','IND',90357), 1619(1363,'Raigarh','IND',89166), 1620(1364,'Vejalpur','IND',89053), 1621(1365,'Baghdad','IRQ',4336000), 1622(1366,'Mosul','IRQ',879000), 1623(1367,'Irbil','IRQ',485968), 1624(1368,'Kirkuk','IRQ',418624), 1625(1369,'Basra','IRQ',406296), 1626(1370,'al-Sulaymaniya','IRQ',364096), 1627(1371,'al-Najaf','IRQ',309010), 1628(1372,'Karbala','IRQ',296705), 1629(1373,'al-Hilla','IRQ',268834), 1630(1374,'al-Nasiriya','IRQ',265937), 1631(1375,'al-Amara','IRQ',208797), 1632(1376,'al-Diwaniya','IRQ',196519), 1633(1377,'al-Ramadi','IRQ',192556), 1634(1378,'al-Kut','IRQ',183183), 1635(1379,'Baquba','IRQ',114516), 1636(1380,'Teheran','IRN',6758845), 1637(1381,'Mashhad','IRN',1887405), 1638(1382,'Esfahan','IRN',1266072), 1639(1383,'Tabriz','IRN',1191043), 1640(1384,'Shiraz','IRN',1053025), 1641(1385,'Karaj','IRN',940968), 1642(1386,'Ahvaz','IRN',804980), 1643(1387,'Qom','IRN',777677), 1644(1388,'Kermanshah','IRN',692986), 1645(1389,'Urmia','IRN',435200), 1646(1390,'Zahedan','IRN',419518), 1647(1391,'Rasht','IRN',417748), 1648(1392,'Hamadan','IRN',401281), 1649(1393,'Kerman','IRN',384991), 1650(1394,'Arak','IRN',380755), 1651(1395,'Ardebil','IRN',340386), 1652(1396,'Yazd','IRN',326776), 1653(1397,'Qazvin','IRN',291117), 1654(1398,'Zanjan','IRN',286295), 1655(1399,'Sanandaj','IRN',277808), 1656(1400,'Bandar-e-Abbas','IRN',273578); 1657INSERT INTO City VALUES 1658(1401,'Khorramabad','IRN',272815), 1659(1402,'Eslamshahr','IRN',265450), 1660(1403,'Borujerd','IRN',217804), 1661(1404,'Abadan','IRN',206073), 1662(1405,'Dezful','IRN',202639), 1663(1406,'Kashan','IRN',201372), 1664(1407,'Sari','IRN',195882), 1665(1408,'Gorgan','IRN',188710), 1666(1409,'Najafabad','IRN',178498), 1667(1410,'Sabzevar','IRN',170738), 1668(1411,'Khomeynishahr','IRN',165888), 1669(1412,'Amol','IRN',159092), 1670(1413,'Neyshabur','IRN',158847), 1671(1414,'Babol','IRN',158346), 1672(1415,'Khoy','IRN',148944), 1673(1416,'Malayer','IRN',144373), 1674(1417,'Bushehr','IRN',143641), 1675(1418,'Qaemshahr','IRN',143286), 1676(1419,'Qarchak','IRN',142690), 1677(1420,'Qods','IRN',138278), 1678(1421,'Sirjan','IRN',135024), 1679(1422,'Bojnurd','IRN',134835), 1680(1423,'Maragheh','IRN',132318), 1681(1424,'Birjand','IRN',127608), 1682(1425,'Ilam','IRN',126346), 1683(1426,'Bukan','IRN',120020), 1684(1427,'Masjed-e-Soleyman','IRN',116883), 1685(1428,'Saqqez','IRN',115394), 1686(1429,'Gonbad-e Qabus','IRN',111253), 1687(1430,'Saveh','IRN',111245), 1688(1431,'Mahabad','IRN',107799), 1689(1432,'Varamin','IRN',107233), 1690(1433,'Andimeshk','IRN',106923), 1691(1434,'Khorramshahr','IRN',105636), 1692(1435,'Shahrud','IRN',104765), 1693(1436,'Marv Dasht','IRN',103579), 1694(1437,'Zabol','IRN',100887), 1695(1438,'Shahr-e Kord','IRN',100477), 1696(1439,'Bandar-e Anzali','IRN',98500), 1697(1440,'Rafsanjan','IRN',98300), 1698(1441,'Marand','IRN',96400), 1699(1442,'Torbat-e Heydariyeh','IRN',94600), 1700(1443,'Jahrom','IRN',94200), 1701(1444,'Semnan','IRN',91045), 1702(1445,'Miandoab','IRN',90100), 1703(1446,'Qomsheh','IRN',89800), 1704(1447,'Dublin','IRL',481854), 1705(1448,'Cork','IRL',127187), 1706(1449,'Reykjavík','ISL',109184), 1707(1450,'Jerusalem','ISR',633700), 1708(1451,'Tel Aviv-Jaffa','ISR',348100), 1709(1452,'Haifa','ISR',265700), 1710(1453,'Rishon Le Ziyyon','ISR',188200), 1711(1454,'Beerseba','ISR',163700), 1712(1455,'Holon','ISR',163100), 1713(1456,'Petah Tiqwa','ISR',159400), 1714(1457,'Ashdod','ISR',155800), 1715(1458,'Netanya','ISR',154900), 1716(1459,'Bat Yam','ISR',137000), 1717(1460,'Bene Beraq','ISR',133900), 1718(1461,'Ramat Gan','ISR',126900), 1719(1462,'Ashqelon','ISR',92300), 1720(1463,'Rehovot','ISR',90300), 1721(1464,'Roma','ITA',2643581), 1722(1465,'Milano','ITA',1300977), 1723(1466,'Napoli','ITA',1002619), 1724(1467,'Torino','ITA',903705), 1725(1468,'Palermo','ITA',683794), 1726(1469,'Genova','ITA',636104), 1727(1470,'Bologna','ITA',381161), 1728(1471,'Firenze','ITA',376662), 1729(1472,'Catania','ITA',337862), 1730(1473,'Bari','ITA',331848), 1731(1474,'Venezia','ITA',277305), 1732(1475,'Messina','ITA',259156), 1733(1476,'Verona','ITA',255268), 1734(1477,'Trieste','ITA',216459), 1735(1478,'Padova','ITA',211391), 1736(1479,'Taranto','ITA',208214), 1737(1480,'Brescia','ITA',191317), 1738(1481,'Reggio di Calabria','ITA',179617), 1739(1482,'Modena','ITA',176022), 1740(1483,'Prato','ITA',172473), 1741(1484,'Parma','ITA',168717), 1742(1485,'Cagliari','ITA',165926), 1743(1486,'Livorno','ITA',161673), 1744(1487,'Perugia','ITA',156673), 1745(1488,'Foggia','ITA',154891), 1746(1489,'Reggio nell´ Emilia','ITA',143664), 1747(1490,'Salerno','ITA',142055), 1748(1491,'Ravenna','ITA',138418), 1749(1492,'Ferrara','ITA',132127), 1750(1493,'Rimini','ITA',131062), 1751(1494,'Syrakusa','ITA',126282), 1752(1495,'Sassari','ITA',120803), 1753(1496,'Monza','ITA',119516), 1754(1497,'Bergamo','ITA',117837), 1755(1498,'Pescara','ITA',115698), 1756(1499,'Latina','ITA',114099), 1757(1500,'Vicenza','ITA',109738), 1758(1501,'Terni','ITA',107770), 1759(1502,'Forlì','ITA',107475), 1760(1503,'Trento','ITA',104906), 1761(1504,'Novara','ITA',102037), 1762(1505,'Piacenza','ITA',98384), 1763(1506,'Ancona','ITA',98329), 1764(1507,'Lecce','ITA',98208), 1765(1508,'Bolzano','ITA',97232), 1766(1509,'Catanzaro','ITA',96700), 1767(1510,'La Spezia','ITA',95504), 1768(1511,'Udine','ITA',94932), 1769(1512,'Torre del Greco','ITA',94505), 1770(1513,'Andria','ITA',94443), 1771(1514,'Brindisi','ITA',93454), 1772(1515,'Giugliano in Campania','ITA',93286), 1773(1516,'Pisa','ITA',92379), 1774(1517,'Barletta','ITA',91904), 1775(1518,'Arezzo','ITA',91729), 1776(1519,'Alessandria','ITA',90289), 1777(1520,'Cesena','ITA',89852), 1778(1521,'Pesaro','ITA',88987), 1779(1522,'Dili','TMP',47900), 1780(1523,'Wien','AUT',1608144), 1781(1524,'Graz','AUT',240967), 1782(1525,'Linz','AUT',188022), 1783(1526,'Salzburg','AUT',144247), 1784(1527,'Innsbruck','AUT',111752), 1785(1528,'Klagenfurt','AUT',91141), 1786(1529,'Spanish Town','JAM',110379), 1787(1530,'Kingston','JAM',103962), 1788(1531,'Portmore','JAM',99799), 1789(1532,'Tokyo','JPN',7980230), 1790(1533,'Jokohama [Yokohama]','JPN',3339594), 1791(1534,'Osaka','JPN',2595674), 1792(1535,'Nagoya','JPN',2154376), 1793(1536,'Sapporo','JPN',1790886), 1794(1537,'Kioto','JPN',1461974), 1795(1538,'Kobe','JPN',1425139), 1796(1539,'Fukuoka','JPN',1308379), 1797(1540,'Kawasaki','JPN',1217359), 1798(1541,'Hiroshima','JPN',1119117), 1799(1542,'Kitakyushu','JPN',1016264), 1800(1543,'Sendai','JPN',989975), 1801(1544,'Chiba','JPN',863930), 1802(1545,'Sakai','JPN',797735), 1803(1546,'Kumamoto','JPN',656734), 1804(1547,'Okayama','JPN',624269), 1805(1548,'Sagamihara','JPN',586300), 1806(1549,'Hamamatsu','JPN',568796), 1807(1550,'Kagoshima','JPN',549977), 1808(1551,'Funabashi','JPN',545299), 1809(1552,'Higashiosaka','JPN',517785), 1810(1553,'Hachioji','JPN',513451), 1811(1554,'Niigata','JPN',497464), 1812(1555,'Amagasaki','JPN',481434), 1813(1556,'Himeji','JPN',475167), 1814(1557,'Shizuoka','JPN',473854), 1815(1558,'Urawa','JPN',469675), 1816(1559,'Matsuyama','JPN',466133), 1817(1560,'Matsudo','JPN',461126), 1818(1561,'Kanazawa','JPN',455386), 1819(1562,'Kawaguchi','JPN',452155), 1820(1563,'Ichikawa','JPN',441893), 1821(1564,'Omiya','JPN',441649), 1822(1565,'Utsunomiya','JPN',440353), 1823(1566,'Oita','JPN',433401), 1824(1567,'Nagasaki','JPN',432759), 1825(1568,'Yokosuka','JPN',430200), 1826(1569,'Kurashiki','JPN',425103), 1827(1570,'Gifu','JPN',408007), 1828(1571,'Hirakata','JPN',403151), 1829(1572,'Nishinomiya','JPN',397618), 1830(1573,'Toyonaka','JPN',396689), 1831(1574,'Wakayama','JPN',391233), 1832(1575,'Fukuyama','JPN',376921), 1833(1576,'Fujisawa','JPN',372840), 1834(1577,'Asahikawa','JPN',364813), 1835(1578,'Machida','JPN',364197), 1836(1579,'Nara','JPN',362812), 1837(1580,'Takatsuki','JPN',361747), 1838(1581,'Iwaki','JPN',361737), 1839(1582,'Nagano','JPN',361391), 1840(1583,'Toyohashi','JPN',360066), 1841(1584,'Toyota','JPN',346090), 1842(1585,'Suita','JPN',345750), 1843(1586,'Takamatsu','JPN',332471), 1844(1587,'Koriyama','JPN',330335), 1845(1588,'Okazaki','JPN',328711), 1846(1589,'Kawagoe','JPN',327211), 1847(1590,'Tokorozawa','JPN',325809), 1848(1591,'Toyama','JPN',325790), 1849(1592,'Kochi','JPN',324710), 1850(1593,'Kashiwa','JPN',320296), 1851(1594,'Akita','JPN',314440), 1852(1595,'Miyazaki','JPN',303784), 1853(1596,'Koshigaya','JPN',301446), 1854(1597,'Naha','JPN',299851), 1855(1598,'Aomori','JPN',295969), 1856(1599,'Hakodate','JPN',294788), 1857(1600,'Akashi','JPN',292253); 1858INSERT IGNORE INTO City VALUES 1859(1601,'Yokkaichi','JPN',288173), 1860(1602,'Fukushima','JPN',287525), 1861(1603,'Morioka','JPN',287353), 1862(1604,'Maebashi','JPN',284473), 1863(1605,'Kasugai','JPN',282348), 1864(1606,'Otsu','JPN',282070), 1865(1607,'Ichihara','JPN',279280), 1866(1608,'Yao','JPN',276421), 1867(1609,'Ichinomiya','JPN',270828), 1868(1610,'Tokushima','JPN',269649), 1869(1611,'Kakogawa','JPN',266281), 1870(1612,'Ibaraki','JPN',261020), 1871(1613,'Neyagawa','JPN',257315), 1872(1614,'Shimonoseki','JPN',257263), 1873(1615,'Yamagata','JPN',255617), 1874(1616,'Fukui','JPN',254818), 1875(1617,'Hiratsuka','JPN',254207), 1876(1618,'Mito','JPN',246559), 1877(1619,'Sasebo','JPN',244240), 1878(1620,'Hachinohe','JPN',242979), 1879(1621,'Takasaki','JPN',239124), 1880(1622,'Shimizu','JPN',239123), 1881(1623,'Kurume','JPN',235611), 1882(1624,'Fuji','JPN',231527), 1883(1625,'Soka','JPN',222768), 1884(1626,'Fuchu','JPN',220576), 1885(1627,'Chigasaki','JPN',216015), 1886(1628,'Atsugi','JPN',212407), 1887(1629,'Numazu','JPN',211382), 1888(1630,'Ageo','JPN',209442), 1889(1631,'Yamato','JPN',208234), 1890(1632,'Matsumoto','JPN',206801), 1891(1633,'Kure','JPN',206504), 1892(1634,'Takarazuka','JPN',205993), 1893(1635,'Kasukabe','JPN',201838), 1894(1636,'Chofu','JPN',201585), 1895(1637,'Odawara','JPN',200171), 1896(1638,'Kofu','JPN',199753), 1897(1639,'Kushiro','JPN',197608), 1898(1640,'Kishiwada','JPN',197276), 1899(1641,'Hitachi','JPN',196622), 1900(1642,'Nagaoka','JPN',192407), 1901(1643,'Itami','JPN',190886), 1902(1644,'Uji','JPN',188735), 1903(1645,'Suzuka','JPN',184061), 1904(1646,'Hirosaki','JPN',177522), 1905(1647,'Ube','JPN',175206), 1906(1648,'Kodaira','JPN',174984), 1907(1649,'Takaoka','JPN',174380), 1908(1650,'Obihiro','JPN',173685), 1909(1651,'Tomakomai','JPN',171958), 1910(1652,'Saga','JPN',170034), 1911(1653,'Sakura','JPN',168072), 1912(1654,'Kamakura','JPN',167661), 1913(1655,'Mitaka','JPN',167268), 1914(1656,'Izumi','JPN',166979), 1915(1657,'Hino','JPN',166770), 1916(1658,'Hadano','JPN',166512), 1917(1659,'Ashikaga','JPN',165243), 1918(1660,'Tsu','JPN',164543), 1919(1661,'Sayama','JPN',162472), 1920(1662,'Yachiyo','JPN',161222), 1921(1663,'Tsukuba','JPN',160768), 1922(1664,'Tachikawa','JPN',159430), 1923(1665,'Kumagaya','JPN',157171), 1924(1666,'Moriguchi','JPN',155941), 1925(1667,'Otaru','JPN',155784), 1926(1668,'Anjo','JPN',153823), 1927(1669,'Narashino','JPN',152849), 1928(1670,'Oyama','JPN',152820), 1929(1671,'Ogaki','JPN',151758), 1930(1672,'Matsue','JPN',149821), 1931(1673,'Kawanishi','JPN',149794), 1932(1674,'Hitachinaka','JPN',148006), 1933(1675,'Niiza','JPN',147744), 1934(1676,'Nagareyama','JPN',147738), 1935(1677,'Tottori','JPN',147523), 1936(1678,'Tama','JPN',146712), 1937(1679,'Iruma','JPN',145922), 1938(1680,'Ota','JPN',145317), 1939(1681,'Omuta','JPN',142889), 1940(1682,'Komaki','JPN',139827), 1941(1683,'Ome','JPN',139216), 1942(1684,'Kadoma','JPN',138953), 1943(1685,'Yamaguchi','JPN',138210), 1944(1686,'Higashimurayama','JPN',136970), 1945(1687,'Yonago','JPN',136461), 1946(1688,'Matsubara','JPN',135010), 1947(1689,'Musashino','JPN',134426), 1948(1690,'Tsuchiura','JPN',134072), 1949(1691,'Joetsu','JPN',133505), 1950(1692,'Miyakonojo','JPN',133183), 1951(1693,'Misato','JPN',132957), 1952(1694,'Kakamigahara','JPN',131831), 1953(1695,'Daito','JPN',130594), 1954(1696,'Seto','JPN',130470), 1955(1697,'Kariya','JPN',127969), 1956(1698,'Urayasu','JPN',127550), 1957(1699,'Beppu','JPN',127486), 1958(1700,'Niihama','JPN',127207), 1959(1701,'Minoo','JPN',127026), 1960(1702,'Fujieda','JPN',126897), 1961(1703,'Abiko','JPN',126670), 1962(1704,'Nobeoka','JPN',125547), 1963(1705,'Tondabayashi','JPN',125094), 1964(1706,'Ueda','JPN',124217), 1965(1707,'Kashihara','JPN',124013), 1966(1708,'Matsusaka','JPN',123582), 1967(1709,'Isesaki','JPN',123285), 1968(1710,'Zama','JPN',122046), 1969(1711,'Kisarazu','JPN',121967), 1970(1712,'Noda','JPN',121030), 1971(1713,'Ishinomaki','JPN',120963), 1972(1714,'Fujinomiya','JPN',119714), 1973(1715,'Kawachinagano','JPN',119666), 1974(1716,'Imabari','JPN',119357), 1975(1717,'Aizuwakamatsu','JPN',119287), 1976(1718,'Higashihiroshima','JPN',119166), 1977(1719,'Habikino','JPN',118968), 1978(1720,'Ebetsu','JPN',118805), 1979(1721,'Hofu','JPN',118751), 1980(1722,'Kiryu','JPN',118326), 1981(1723,'Okinawa','JPN',117748), 1982(1724,'Yaizu','JPN',117258), 1983(1725,'Toyokawa','JPN',115781), 1984(1726,'Ebina','JPN',115571), 1985(1727,'Asaka','JPN',114815), 1986(1728,'Higashikurume','JPN',111666), 1987(1729,'Ikoma','JPN',111645), 1988(1730,'Kitami','JPN',111295), 1989(1731,'Koganei','JPN',110969), 1990(1732,'Iwatsuki','JPN',110034), 1991(1733,'Mishima','JPN',109699), 1992(1734,'Handa','JPN',108600), 1993(1735,'Muroran','JPN',108275), 1994(1736,'Komatsu','JPN',107937), 1995(1737,'Yatsushiro','JPN',107661), 1996(1738,'Iida','JPN',107583), 1997(1739,'Tokuyama','JPN',107078), 1998(1740,'Kokubunji','JPN',106996), 1999(1741,'Akishima','JPN',106914), 2000(1742,'Iwakuni','JPN',106647), 2001(1743,'Kusatsu','JPN',106232), 2002(1744,'Kuwana','JPN',106121), 2003(1745,'Sanda','JPN',105643), 2004(1746,'Hikone','JPN',105508), 2005(1747,'Toda','JPN',103969), 2006(1748,'Tajimi','JPN',103171), 2007(1749,'Ikeda','JPN',102710), 2008(1750,'Fukaya','JPN',102156), 2009(1751,'Ise','JPN',101732), 2010(1752,'Sakata','JPN',101651), 2011(1753,'Kasuga','JPN',101344), 2012(1754,'Kamagaya','JPN',100821), 2013(1755,'Tsuruoka','JPN',100713), 2014(1756,'Hoya','JPN',100313), 2015(1757,'Nishio','JPN',100032), 2016(1758,'Tokai','JPN',99738), 2017(1759,'Inazawa','JPN',98746), 2018(1760,'Sakado','JPN',98221), 2019(1761,'Isehara','JPN',98123), 2020(1762,'Takasago','JPN',97632), 2021(1763,'Fujimi','JPN',96972), 2022(1764,'Urasoe','JPN',96002), 2023(1765,'Yonezawa','JPN',95592), 2024(1766,'Konan','JPN',95521), 2025(1767,'Yamatokoriyama','JPN',95165), 2026(1768,'Maizuru','JPN',94784), 2027(1769,'Onomichi','JPN',93756), 2028(1770,'Higashimatsuyama','JPN',93342), 2029(1771,'Kimitsu','JPN',93216), 2030(1772,'Isahaya','JPN',93058), 2031(1773,'Kanuma','JPN',93053), 2032(1774,'Izumisano','JPN',92583), 2033(1775,'Kameoka','JPN',92398), 2034(1776,'Mobara','JPN',91664), 2035(1777,'Narita','JPN',91470), 2036(1778,'Kashiwazaki','JPN',91229), 2037(1779,'Tsuyama','JPN',91170), 2038(1780,'Sanaa','YEM',503600), 2039(1781,'Aden','YEM',398300), 2040(1782,'Taizz','YEM',317600), 2041(1783,'Hodeida','YEM',298500), 2042(1784,'al-Mukalla','YEM',122400), 2043(1785,'Ibb','YEM',103300), 2044(1786,'Amman','JOR',1000000), 2045(1787,'al-Zarqa','JOR',389815), 2046(1788,'Irbid','JOR',231511), 2047(1789,'al-Rusayfa','JOR',137247), 2048(1790,'Wadi al-Sir','JOR',89104), 2049(1791,'Flying Fish Cove','CXR',700), 2050(1792,'Beograd','YUG',1204000), 2051(1793,'Novi Sad','YUG',179626), 2052(1794,'Ni','YUG',175391), 2053(1795,'Pritina','YUG',155496), 2054(1796,'Kragujevac','YUG',147305), 2055(1797,'Podgorica','YUG',135000), 2056(1798,'Subotica','YUG',100386), 2057(1799,'Prizren','YUG',92303), 2058(1800,'Phnom Penh','KHM',570155); 2059INSERT IGNORE INTO City VALUES 2060(1801,'Battambang','KHM',129800), 2061(1802,'Siem Reap','KHM',105100), 2062(1803,'Douala','CMR',1448300), 2063(1804,'Yaoundé','CMR',1372800), 2064(1805,'Garoua','CMR',177000), 2065(1806,'Maroua','CMR',143000), 2066(1807,'Bamenda','CMR',138000), 2067(1808,'Bafoussam','CMR',131000), 2068(1809,'Nkongsamba','CMR',112454), 2069(1810,'Montréal','CAN',1016376), 2070(1811,'Calgary','CAN',768082), 2071(1812,'Toronto','CAN',688275), 2072(1813,'North York','CAN',622632), 2073(1814,'Winnipeg','CAN',618477), 2074(1815,'Edmonton','CAN',616306), 2075(1816,'Mississauga','CAN',608072), 2076(1817,'Scarborough','CAN',594501), 2077(1818,'Vancouver','CAN',514008), 2078(1819,'Etobicoke','CAN',348845), 2079(1820,'London','CAN',339917), 2080(1821,'Hamilton','CAN',335614), 2081(1822,'Ottawa','CAN',335277), 2082(1823,'Laval','CAN',330393), 2083(1824,'Surrey','CAN',304477), 2084(1825,'Brampton','CAN',296711), 2085(1826,'Windsor','CAN',207588), 2086(1827,'Saskatoon','CAN',193647), 2087(1828,'Kitchener','CAN',189959), 2088(1829,'Markham','CAN',189098), 2089(1830,'Regina','CAN',180400), 2090(1831,'Burnaby','CAN',179209), 2091(1832,'Québec','CAN',167264), 2092(1833,'York','CAN',154980), 2093(1834,'Richmond','CAN',148867), 2094(1835,'Vaughan','CAN',147889), 2095(1836,'Burlington','CAN',145150), 2096(1837,'Oshawa','CAN',140173), 2097(1838,'Oakville','CAN',139192), 2098(1839,'Saint Catharines','CAN',136216), 2099(1840,'Longueuil','CAN',127977), 2100(1841,'Richmond Hill','CAN',116428), 2101(1842,'Thunder Bay','CAN',115913), 2102(1843,'Nepean','CAN',115100), 2103(1844,'Cape Breton','CAN',114733), 2104(1845,'East York','CAN',114034), 2105(1846,'Halifax','CAN',113910), 2106(1847,'Cambridge','CAN',109186), 2107(1848,'Gloucester','CAN',107314), 2108(1849,'Abbotsford','CAN',105403), 2109(1850,'Guelph','CAN',103593), 2110(1851,'Saint John´s','CAN',101936), 2111(1852,'Coquitlam','CAN',101820), 2112(1853,'Saanich','CAN',101388), 2113(1854,'Gatineau','CAN',100702), 2114(1855,'Delta','CAN',95411), 2115(1856,'Sudbury','CAN',92686), 2116(1857,'Kelowna','CAN',89442), 2117(1858,'Barrie','CAN',89269), 2118(1859,'Praia','CPV',94800), 2119(1860,'Almaty','KAZ',1129400), 2120(1861,'Qaraghandy','KAZ',436900), 2121(1862,'Shymkent','KAZ',360100), 2122(1863,'Taraz','KAZ',330100), 2123(1864,'Astana','KAZ',311200), 2124(1865,'Öskemen','KAZ',311000), 2125(1866,'Pavlodar','KAZ',300500), 2126(1867,'Semey','KAZ',269600), 2127(1868,'Aqtöbe','KAZ',253100), 2128(1869,'Qostanay','KAZ',221400), 2129(1870,'Petropavl','KAZ',203500), 2130(1871,'Oral','KAZ',195500), 2131(1872,'Temirtau','KAZ',170500), 2132(1873,'Qyzylorda','KAZ',157400), 2133(1874,'Aqtau','KAZ',143400), 2134(1875,'Atyrau','KAZ',142500), 2135(1876,'Ekibastuz','KAZ',127200), 2136(1877,'Kökshetau','KAZ',123400), 2137(1878,'Rudnyy','KAZ',109500), 2138(1879,'Taldyqorghan','KAZ',98000), 2139(1880,'Zhezqazghan','KAZ',90000), 2140(1881,'Nairobi','KEN',2290000), 2141(1882,'Mombasa','KEN',461753), 2142(1883,'Kisumu','KEN',192733), 2143(1884,'Nakuru','KEN',163927), 2144(1885,'Machakos','KEN',116293), 2145(1886,'Eldoret','KEN',111882), 2146(1887,'Meru','KEN',94947), 2147(1888,'Nyeri','KEN',91258), 2148(1889,'Bangui','CAF',524000), 2149(1890,'Shanghai','CHN',9696300), 2150(1891,'Peking','CHN',7472000), 2151(1892,'Chongqing','CHN',6351600), 2152(1893,'Tianjin','CHN',5286800), 2153(1894,'Wuhan','CHN',4344600), 2154(1895,'Harbin','CHN',4289800), 2155(1896,'Shenyang','CHN',4265200), 2156(1897,'Kanton [Guangzhou]','CHN',4256300), 2157(1898,'Chengdu','CHN',3361500), 2158(1899,'Nanking [Nanjing]','CHN',2870300), 2159(1900,'Changchun','CHN',2812000), 2160(1901,'Xi´an','CHN',2761400), 2161(1902,'Dalian','CHN',2697000), 2162(1903,'Qingdao','CHN',2596000), 2163(1904,'Jinan','CHN',2278100), 2164(1905,'Hangzhou','CHN',2190500), 2165(1906,'Zhengzhou','CHN',2107200), 2166(1907,'Shijiazhuang','CHN',2041500), 2167(1908,'Taiyuan','CHN',1968400), 2168(1909,'Kunming','CHN',1829500), 2169(1910,'Changsha','CHN',1809800), 2170(1911,'Nanchang','CHN',1691600), 2171(1912,'Fuzhou','CHN',1593800), 2172(1913,'Lanzhou','CHN',1565800), 2173(1914,'Guiyang','CHN',1465200), 2174(1915,'Ningbo','CHN',1371200), 2175(1916,'Hefei','CHN',1369100), 2176(1917,'Urumti [Ürümqi]','CHN',1310100), 2177(1918,'Anshan','CHN',1200000), 2178(1919,'Fushun','CHN',1200000), 2179(1920,'Nanning','CHN',1161800), 2180(1921,'Zibo','CHN',1140000), 2181(1922,'Qiqihar','CHN',1070000), 2182(1923,'Jilin','CHN',1040000), 2183(1924,'Tangshan','CHN',1040000), 2184(1925,'Baotou','CHN',980000), 2185(1926,'Shenzhen','CHN',950500), 2186(1927,'Hohhot','CHN',916700), 2187(1928,'Handan','CHN',840000), 2188(1929,'Wuxi','CHN',830000), 2189(1930,'Xuzhou','CHN',810000), 2190(1931,'Datong','CHN',800000), 2191(1932,'Yichun','CHN',800000), 2192(1933,'Benxi','CHN',770000), 2193(1934,'Luoyang','CHN',760000), 2194(1935,'Suzhou','CHN',710000), 2195(1936,'Xining','CHN',700200), 2196(1937,'Huainan','CHN',700000), 2197(1938,'Jixi','CHN',683885), 2198(1939,'Daqing','CHN',660000), 2199(1940,'Fuxin','CHN',640000), 2200(1941,'Amoy [Xiamen]','CHN',627500), 2201(1942,'Liuzhou','CHN',610000), 2202(1943,'Shantou','CHN',580000), 2203(1944,'Jinzhou','CHN',570000), 2204(1945,'Mudanjiang','CHN',570000), 2205(1946,'Yinchuan','CHN',544500), 2206(1947,'Changzhou','CHN',530000), 2207(1948,'Zhangjiakou','CHN',530000), 2208(1949,'Dandong','CHN',520000), 2209(1950,'Hegang','CHN',520000), 2210(1951,'Kaifeng','CHN',510000), 2211(1952,'Jiamusi','CHN',493409), 2212(1953,'Liaoyang','CHN',492559), 2213(1954,'Hengyang','CHN',487148), 2214(1955,'Baoding','CHN',483155), 2215(1956,'Hunjiang','CHN',482043), 2216(1957,'Xinxiang','CHN',473762), 2217(1958,'Huangshi','CHN',457601), 2218(1959,'Haikou','CHN',454300), 2219(1960,'Yantai','CHN',452127), 2220(1961,'Bengbu','CHN',449245), 2221(1962,'Xiangtan','CHN',441968), 2222(1963,'Weifang','CHN',428522), 2223 (1964,'Wuhu','CHN',425740), 2224(1965,'Pingxiang','CHN',425579), 2225(1966,'Yingkou','CHN',421589), 2226(1967,'Anyang','CHN',420332), 2227(1968,'Panzhihua','CHN',415466), 2228(1969,'Pingdingshan','CHN',410775), 2229(1970,'Xiangfan','CHN',410407), 2230(1971,'Zhuzhou','CHN',409924), 2231(1972,'Jiaozuo','CHN',409100), 2232(1973,'Wenzhou','CHN',401871), 2233(1974,'Zhangjiang','CHN',400997), 2234(1975,'Zigong','CHN',393184), 2235(1976,'Shuangyashan','CHN',386081), 2236(1977,'Zaozhuang','CHN',380846), 2237(1978,'Yakeshi','CHN',377869), 2238(1979,'Yichang','CHN',371601), 2239(1980,'Zhenjiang','CHN',368316), 2240(1981,'Huaibei','CHN',366549), 2241(1982,'Qinhuangdao','CHN',364972), 2242(1983,'Guilin','CHN',364130), 2243(1984,'Liupanshui','CHN',363954), 2244(1985,'Panjin','CHN',362773), 2245(1986,'Yangquan','CHN',362268), 2246(1987,'Jinxi','CHN',357052), 2247(1988,'Liaoyuan','CHN',354141), 2248(1989,'Lianyungang','CHN',354139), 2249(1990,'Xianyang','CHN',352125), 2250(1991,'Tai´an','CHN',350696), 2251(1992,'Chifeng','CHN',350077), 2252(1993,'Shaoguan','CHN',350043), 2253(1994,'Nantong','CHN',343341), 2254(1995,'Leshan','CHN',341128), 2255(1996,'Baoji','CHN',337765), 2256(1997,'Linyi','CHN',324720), 2257(1998,'Tonghua','CHN',324600), 2258(1999,'Siping','CHN',317223), 2259(2000,'Changzhi','CHN',317144); 2260INSERT INTO City VALUES 2261(2001,'Tengzhou','CHN',315083), 2262(2002,'Chaozhou','CHN',313469), 2263(2003,'Yangzhou','CHN',312892), 2264(2004,'Dongwan','CHN',308669), 2265(2005,'Ma´anshan','CHN',305421), 2266(2006,'Foshan','CHN',303160), 2267(2007,'Yueyang','CHN',302800), 2268(2008,'Xingtai','CHN',302789), 2269(2009,'Changde','CHN',301276), 2270(2010,'Shihezi','CHN',299676), 2271(2011,'Yancheng','CHN',296831), 2272(2012,'Jiujiang','CHN',291187), 2273(2013,'Dongying','CHN',281728), 2274(2014,'Shashi','CHN',281352), 2275(2015,'Xintai','CHN',281248), 2276(2016,'Jingdezhen','CHN',281183), 2277(2017,'Tongchuan','CHN',280657), 2278(2018,'Zhongshan','CHN',278829), 2279(2019,'Shiyan','CHN',273786), 2280(2020,'Tieli','CHN',265683), 2281(2021,'Jining','CHN',265248), 2282(2022,'Wuhai','CHN',264081), 2283(2023,'Mianyang','CHN',262947), 2284(2024,'Luzhou','CHN',262892), 2285(2025,'Zunyi','CHN',261862), 2286(2026,'Shizuishan','CHN',257862), 2287(2027,'Neijiang','CHN',256012), 2288(2028,'Tongliao','CHN',255129), 2289(2029,'Tieling','CHN',254842), 2290(2030,'Wafangdian','CHN',251733), 2291(2031,'Anqing','CHN',250718), 2292(2032,'Shaoyang','CHN',247227), 2293(2033,'Laiwu','CHN',246833), 2294(2034,'Chengde','CHN',246799), 2295(2035,'Tianshui','CHN',244974), 2296(2036,'Nanyang','CHN',243303), 2297(2037,'Cangzhou','CHN',242708), 2298(2038,'Yibin','CHN',241019), 2299(2039,'Huaiyin','CHN',239675), 2300(2040,'Dunhua','CHN',235100), 2301(2041,'Yanji','CHN',230892), 2302(2042,'Jiangmen','CHN',230587), 2303(2043,'Tongling','CHN',228017), 2304(2044,'Suihua','CHN',227881), 2305(2045,'Gongziling','CHN',226569), 2306(2046,'Xiantao','CHN',222884), 2307(2047,'Chaoyang','CHN',222394), 2308(2048,'Ganzhou','CHN',220129), 2309(2049,'Huzhou','CHN',218071), 2310(2050,'Baicheng','CHN',217987), 2311(2051,'Shangzi','CHN',215373), 2312(2052,'Yangjiang','CHN',215196), 2313(2053,'Qitaihe','CHN',214957), 2314(2054,'Gejiu','CHN',214294), 2315(2055,'Jiangyin','CHN',213659), 2316(2056,'Hebi','CHN',212976), 2317(2057,'Jiaxing','CHN',211526), 2318(2058,'Wuzhou','CHN',210452), 2319(2059,'Meihekou','CHN',209038), 2320(2060,'Xuchang','CHN',208815), 2321(2061,'Liaocheng','CHN',207844), 2322(2062,'Haicheng','CHN',205560), 2323(2063,'Qianjiang','CHN',205504), 2324(2064,'Baiyin','CHN',204970), 2325(2065,'Bei´an','CHN',204899), 2326(2066,'Yixing','CHN',200824), 2327(2067,'Laizhou','CHN',198664), 2328(2068,'Qaramay','CHN',197602), 2329(2069,'Acheng','CHN',197595), 2330(2070,'Dezhou','CHN',195485), 2331(2071,'Nanping','CHN',195064), 2332(2072,'Zhaoqing','CHN',194784), 2333(2073,'Beipiao','CHN',194301), 2334(2074,'Fengcheng','CHN',193784), 2335(2075,'Fuyu','CHN',192981), 2336(2076,'Xinyang','CHN',192509), 2337(2077,'Dongtai','CHN',192247), 2338(2078,'Yuci','CHN',191356), 2339(2079,'Honghu','CHN',190772), 2340(2080,'Ezhou','CHN',190123), 2341(2081,'Heze','CHN',189293), 2342(2082,'Daxian','CHN',188101), 2343(2083,'Linfen','CHN',187309), 2344(2084,'Tianmen','CHN',186332), 2345(2085,'Yiyang','CHN',185818), 2346(2086,'Quanzhou','CHN',185154), 2347(2087,'Rizhao','CHN',185048), 2348(2088,'Deyang','CHN',182488), 2349(2089,'Guangyuan','CHN',182241), 2350(2090,'Changshu','CHN',181805), 2351(2091,'Zhangzhou','CHN',181424), 2352(2092,'Hailar','CHN',180650), 2353(2093,'Nanchong','CHN',180273), 2354(2094,'Jiutai','CHN',180130), 2355(2095,'Zhaodong','CHN',179976), 2356(2096,'Shaoxing','CHN',179818), 2357(2097,'Fuyang','CHN',179572), 2358(2098,'Maoming','CHN',178683), 2359(2099,'Qujing','CHN',178669), 2360(2100,'Ghulja','CHN',177193), 2361(2101,'Jiaohe','CHN',176367), 2362(2102,'Puyang','CHN',175988), 2363(2103,'Huadian','CHN',175873), 2364(2104,'Jiangyou','CHN',175753), 2365(2105,'Qashqar','CHN',174570), 2366(2106,'Anshun','CHN',174142), 2367(2107,'Fuling','CHN',173878), 2368(2108,'Xinyu','CHN',173524), 2369(2109,'Hanzhong','CHN',169930), 2370(2110,'Danyang','CHN',169603), 2371(2111,'Chenzhou','CHN',169400), 2372(2112,'Xiaogan','CHN',166280), 2373(2113,'Shangqiu','CHN',164880), 2374(2114,'Zhuhai','CHN',164747), 2375(2115,'Qingyuan','CHN',164641), 2376(2116,'Aqsu','CHN',164092), 2377(2117,'Jining','CHN',163552), 2378(2118,'Xiaoshan','CHN',162930), 2379(2119,'Zaoyang','CHN',162198), 2380(2120,'Xinghua','CHN',161910), 2381(2121,'Hami','CHN',161315), 2382(2122,'Huizhou','CHN',161023), 2383(2123,'Jinmen','CHN',160794), 2384(2124,'Sanming','CHN',160691), 2385(2125,'Ulanhot','CHN',159538), 2386(2126,'Korla','CHN',159344), 2387(2127,'Wanxian','CHN',156823), 2388(2128,'Rui´an','CHN',156468), 2389(2129,'Zhoushan','CHN',156317), 2390(2130,'Liangcheng','CHN',156307), 2391(2131,'Jiaozhou','CHN',153364), 2392(2132,'Taizhou','CHN',152442), 2393(2133,'Suzhou','CHN',151862), 2394(2134,'Yichun','CHN',151585), 2395(2135,'Taonan','CHN',150168), 2396(2136,'Pingdu','CHN',150123), 2397(2137,'Ji´an','CHN',148583), 2398(2138,'Longkou','CHN',148362), 2399(2139,'Langfang','CHN',148105), 2400(2140,'Zhoukou','CHN',146288), 2401(2141,'Suining','CHN',146086), 2402(2142,'Yulin','CHN',144467), 2403(2143,'Jinhua','CHN',144280), 2404(2144,'Liu´an','CHN',144248), 2405(2145,'Shuangcheng','CHN',142659), 2406(2146,'Suizhou','CHN',142302), 2407(2147,'Ankang','CHN',142170), 2408(2148,'Weinan','CHN',140169), 2409(2149,'Longjing','CHN',139417), 2410(2150,'Da´an','CHN',138963), 2411(2151,'Lengshuijiang','CHN',137994), 2412(2152,'Laiyang','CHN',137080), 2413(2153,'Xianning','CHN',136811), 2414(2154,'Dali','CHN',136554), 2415(2155,'Anda','CHN',136446), 2416(2156,'Jincheng','CHN',136396), 2417(2157,'Longyan','CHN',134481), 2418(2158,'Xichang','CHN',134419), 2419(2159,'Wendeng','CHN',133910), 2420(2160,'Hailun','CHN',133565), 2421(2161,'Binzhou','CHN',133555), 2422(2162,'Linhe','CHN',133183), 2423(2163,'Wuwei','CHN',133101), 2424(2164,'Duyun','CHN',132971), 2425(2165,'Mishan','CHN',132744), 2426(2166,'Shangrao','CHN',132455), 2427(2167,'Changji','CHN',132260), 2428(2168,'Meixian','CHN',132156), 2429(2169,'Yushu','CHN',131861), 2430(2170,'Tiefa','CHN',131807), 2431(2171,'Huai´an','CHN',131149), 2432(2172,'Leiyang','CHN',130115), 2433(2173,'Zalantun','CHN',130031), 2434(2174,'Weihai','CHN',128888), 2435(2175,'Loudi','CHN',128418), 2436(2176,'Qingzhou','CHN',128258), 2437(2177,'Qidong','CHN',126872), 2438(2178,'Huaihua','CHN',126785), 2439(2179,'Luohe','CHN',126438), 2440(2180,'Chuzhou','CHN',125341), 2441(2181,'Kaiyuan','CHN',124219), 2442(2182,'Linqing','CHN',123958), 2443(2183,'Chaohu','CHN',123676), 2444(2184,'Laohekou','CHN',123366), 2445(2185,'Dujiangyan','CHN',123357), 2446(2186,'Zhumadian','CHN',123232), 2447(2187,'Linchuan','CHN',121949), 2448(2188,'Jiaonan','CHN',121397), 2449(2189,'Sanmenxia','CHN',120523), 2450(2190,'Heyuan','CHN',120101), 2451(2191,'Manzhouli','CHN',120023), 2452(2192,'Lhasa','CHN',120000), 2453(2193,'Lianyuan','CHN',118858), 2454(2194,'Kuytun','CHN',118553), 2455(2195,'Puqi','CHN',117264), 2456(2196,'Hongjiang','CHN',116188), 2457(2197,'Qinzhou','CHN',114586), 2458(2198,'Renqiu','CHN',114256), 2459(2199,'Yuyao','CHN',114065), 2460(2200,'Guigang','CHN',114025); 2461INSERT INTO City VALUES 2462(2201,'Kaili','CHN',113958), 2463(2202,'Yan´an','CHN',113277), 2464(2203,'Beihai','CHN',112673), 2465(2204,'Xuangzhou','CHN',112673), 2466(2205,'Quzhou','CHN',112373), 2467(2206,'Yong´an','CHN',111762), 2468(2207,'Zixing','CHN',110048), 2469(2208,'Liyang','CHN',109520), 2470(2209,'Yizheng','CHN',109268), 2471(2210,'Yumen','CHN',109234), 2472(2211,'Liling','CHN',108504), 2473(2212,'Yuncheng','CHN',108359), 2474(2213,'Shanwei','CHN',107847), 2475(2214,'Cixi','CHN',107329), 2476(2215,'Yuanjiang','CHN',107004), 2477(2216,'Bozhou','CHN',106346), 2478(2217,'Jinchang','CHN',105287), 2479(2218,'Fu´an','CHN',105265), 2480(2219,'Suqian','CHN',105021), 2481(2220,'Shishou','CHN',104571), 2482(2221,'Hengshui','CHN',104269), 2483(2222,'Danjiangkou','CHN',103211), 2484(2223,'Fujin','CHN',103104), 2485(2224,'Sanya','CHN',102820), 2486(2225,'Guangshui','CHN',102770), 2487(2226,'Huangshan','CHN',102628), 2488(2227,'Xingcheng','CHN',102384), 2489(2228,'Zhucheng','CHN',102134), 2490(2229,'Kunshan','CHN',102052), 2491(2230,'Haining','CHN',100478), 2492(2231,'Pingliang','CHN',99265), 2493(2232,'Fuqing','CHN',99193), 2494(2233,'Xinzhou','CHN',98667), 2495(2234,'Jieyang','CHN',98531), 2496(2235,'Zhangjiagang','CHN',97994), 2497(2236,'Tong Xian','CHN',97168), 2498(2237,'Ya´an','CHN',95900), 2499(2238,'Jinzhou','CHN',95761), 2500(2239,'Emeishan','CHN',94000), 2501(2240,'Enshi','CHN',93056), 2502(2241,'Bose','CHN',93009), 2503(2242,'Yuzhou','CHN',92889), 2504(2243,'Kaiyuan','CHN',91999), 2505(2244,'Tumen','CHN',91471), 2506(2245,'Putian','CHN',91030), 2507(2246,'Linhai','CHN',90870), 2508(2247,'Xilin Hot','CHN',90646), 2509(2248,'Shaowu','CHN',90286), 2510(2249,'Junan','CHN',90222), 2511(2250,'Huaying','CHN',89400), 2512(2251,'Pingyi','CHN',89373), 2513(2252,'Huangyan','CHN',89288), 2514(2253,'Bishkek','KGZ',589400), 2515(2254,'Osh','KGZ',222700), 2516(2255,'Bikenibeu','KIR',5055), 2517(2256,'Bairiki','KIR',2226), 2518(2257,'Santafé de Bogotá','COL',6260862), 2519(2258,'Cali','COL',2077386), 2520(2259,'Medellín','COL',1861265), 2521(2260,'Barranquilla','COL',1223260), 2522(2261,'Cartagena','COL',805757), 2523(2262,'Cúcuta','COL',606932), 2524(2263,'Bucaramanga','COL',515555), 2525(2264,'Ibagué','COL',393664), 2526(2265,'Pereira','COL',381725), 2527(2266,'Santa Marta','COL',359147), 2528(2267,'Manizales','COL',337580), 2529(2268,'Bello','COL',333470), 2530(2269,'Pasto','COL',332396), 2531(2270,'Neiva','COL',300052), 2532(2271,'Soledad','COL',295058), 2533(2272,'Armenia','COL',288977), 2534(2273,'Villavicencio','COL',273140), 2535(2274,'Soacha','COL',272058), 2536(2275,'Valledupar','COL',263247), 2537(2276,'Montería','COL',248245), 2538(2277,'Itagüí','COL',228985), 2539(2278,'Palmira','COL',226509), 2540(2279,'Buenaventura','COL',224336), 2541(2280,'Floridablanca','COL',221913), 2542(2281,'Sincelejo','COL',220704), 2543(2282,'Popayán','COL',200719), 2544(2283,'Barrancabermeja','COL',178020), 2545(2284,'Dos Quebradas','COL',159363), 2546(2285,'Tuluá','COL',152488), 2547(2286,'Envigado','COL',135848), 2548(2287,'Cartago','COL',125884), 2549(2288,'Girardot','COL',110963), 2550(2289,'Buga','COL',110699), 2551(2290,'Tunja','COL',109740), 2552(2291,'Florencia','COL',108574), 2553(2292,'Maicao','COL',108053), 2554(2293,'Sogamoso','COL',107728), 2555(2294,'Giron','COL',90688), 2556(2295,'Moroni','COM',36000), 2557(2296,'Brazzaville','COG',950000), 2558(2297,'Pointe-Noire','COG',500000), 2559(2298,'Kinshasa','COD',5064000), 2560(2299,'Lubumbashi','COD',851381), 2561(2300,'Mbuji-Mayi','COD',806475), 2562(2301,'Kolwezi','COD',417810), 2563(2302,'Kisangani','COD',417517), 2564(2303,'Kananga','COD',393030), 2565(2304,'Likasi','COD',299118), 2566(2305,'Bukavu','COD',201569), 2567(2306,'Kikwit','COD',182142), 2568(2307,'Tshikapa','COD',180860), 2569(2308,'Matadi','COD',172730), 2570(2309,'Mbandaka','COD',169841), 2571(2310,'Mwene-Ditu','COD',137459), 2572(2311,'Boma','COD',135284), 2573(2312,'Uvira','COD',115590), 2574(2313,'Butembo','COD',109406), 2575(2314,'Goma','COD',109094), 2576(2315,'Kalemie','COD',101309), 2577(2316,'Bantam','CCK',503), 2578(2317,'West Island','CCK',167), 2579(2318,'Pyongyang','PRK',2484000), 2580(2319,'Hamhung','PRK',709730), 2581(2320,'Chongjin','PRK',582480), 2582(2321,'Nampo','PRK',566200), 2583(2322,'Sinuiju','PRK',326011), 2584(2323,'Wonsan','PRK',300148), 2585(2324,'Phyongsong','PRK',272934), 2586(2325,'Sariwon','PRK',254146), 2587(2326,'Haeju','PRK',229172), 2588(2327,'Kanggye','PRK',223410), 2589(2328,'Kimchaek','PRK',179000), 2590(2329,'Hyesan','PRK',178020), 2591(2330,'Kaesong','PRK',171500), 2592(2331,'Seoul','KOR',9981619), 2593(2332,'Pusan','KOR',3804522), 2594(2333,'Inchon','KOR',2559424), 2595(2334,'Taegu','KOR',2548568), 2596(2335,'Taejon','KOR',1425835), 2597(2336,'Kwangju','KOR',1368341), 2598(2337,'Ulsan','KOR',1084891), 2599(2338,'Songnam','KOR',869094), 2600(2339,'Puchon','KOR',779412), 2601(2340,'Suwon','KOR',755550), 2602(2341,'Anyang','KOR',591106), 2603(2342,'Chonju','KOR',563153), 2604(2343,'Chongju','KOR',531376), 2605(2344,'Koyang','KOR',518282), 2606(2345,'Ansan','KOR',510314), 2607(2346,'Pohang','KOR',508899), 2608(2347,'Chang-won','KOR',481694), 2609(2348,'Masan','KOR',441242), 2610(2349,'Kwangmyong','KOR',350914), 2611(2350,'Chonan','KOR',330259), 2612(2351,'Chinju','KOR',329886), 2613(2352,'Iksan','KOR',322685), 2614(2353,'Pyongtaek','KOR',312927), 2615(2354,'Kumi','KOR',311431), 2616(2355,'Uijongbu','KOR',276111), 2617(2356,'Kyongju','KOR',272968), 2618(2357,'Kunsan','KOR',266569), 2619(2358,'Cheju','KOR',258511), 2620(2359,'Kimhae','KOR',256370), 2621(2360,'Sunchon','KOR',249263), 2622(2361,'Mokpo','KOR',247452), 2623(2362,'Yong-in','KOR',242643), 2624(2363,'Wonju','KOR',237460), 2625(2364,'Kunpo','KOR',235233), 2626(2365,'Chunchon','KOR',234528), 2627(2366,'Namyangju','KOR',229060), 2628(2367,'Kangnung','KOR',220403), 2629(2368,'Chungju','KOR',205206), 2630(2369,'Andong','KOR',188443), 2631(2370,'Yosu','KOR',183596), 2632(2371,'Kyongsan','KOR',173746), 2633(2372,'Paju','KOR',163379), 2634(2373,'Yangsan','KOR',163351), 2635(2374,'Ichon','KOR',155332), 2636(2375,'Asan','KOR',154663), 2637(2376,'Koje','KOR',147562), 2638(2377,'Kimchon','KOR',147027), 2639(2378,'Nonsan','KOR',146619), 2640(2379,'Kuri','KOR',142173), 2641(2380,'Chong-up','KOR',139111), 2642(2381,'Chechon','KOR',137070), 2643(2382,'Sosan','KOR',134746), 2644(2383,'Shihung','KOR',133443), 2645(2384,'Tong-yong','KOR',131717), 2646(2385,'Kongju','KOR',131229), 2647(2386,'Yongju','KOR',131097), 2648(2387,'Chinhae','KOR',125997), 2649(2388,'Sangju','KOR',124116), 2650(2389,'Poryong','KOR',122604), 2651(2390,'Kwang-yang','KOR',122052), 2652(2391,'Miryang','KOR',121501), 2653(2392,'Hanam','KOR',115812), 2654(2393,'Kimje','KOR',115427), 2655(2394,'Yongchon','KOR',113511), 2656(2395,'Sachon','KOR',113494), 2657(2396,'Uiwang','KOR',108788), 2658(2397,'Naju','KOR',107831), 2659(2398,'Namwon','KOR',103544), 2660(2399,'Tonghae','KOR',95472), 2661(2400,'Mun-gyong','KOR',92239); 2662INSERT IGNORE INTO City VALUES 2663(2401,'Athenai','GRC',772072), 2664(2402,'Thessaloniki','GRC',383967), 2665(2403,'Pireus','GRC',182671), 2666(2404,'Patras','GRC',153344), 2667(2405,'Peristerion','GRC',137288), 2668(2406,'Herakleion','GRC',116178), 2669(2407,'Kallithea','GRC',114233), 2670(2408,'Larisa','GRC',113090), 2671(2409,'Zagreb','HRV',706770), 2672(2410,'Split','HRV',189388), 2673(2411,'Rijeka','HRV',167964), 2674(2412,'Osijek','HRV',104761), 2675(2413,'La Habana','CUB',2256000), 2676(2414,'Santiago de Cuba','CUB',433180), 2677(2415,'Camagüey','CUB',298726), 2678(2416,'Holguín','CUB',249492), 2679(2417,'Santa Clara','CUB',207350), 2680(2418,'Guantánamo','CUB',205078), 2681(2419,'Pinar del Río','CUB',142100), 2682(2420,'Bayamo','CUB',141000), 2683(2421,'Cienfuegos','CUB',132770), 2684(2422,'Victoria de las Tunas','CUB',132350), 2685(2423,'Matanzas','CUB',123273), 2686(2424,'Manzanillo','CUB',109350), 2687(2425,'Sancti-Spíritus','CUB',100751), 2688(2426,'Ciego de Ávila','CUB',98505), 2689(2427,'al-Salimiya','KWT',130215), 2690(2428,'Jalib al-Shuyukh','KWT',102178), 2691(2429,'Kuwait','KWT',28859), 2692(2430,'Nicosia','CYP',195000), 2693(2431,'Limassol','CYP',154400), 2694(2432,'Vientiane','LAO',531800), 2695(2433,'Savannakhet','LAO',96652), 2696(2434,'Riga','LVA',764328), 2697(2435,'Daugavpils','LVA',114829), 2698(2436,'Liepaja','LVA',89439), 2699(2437,'Maseru','LSO',297000), 2700(2438,'Beirut','LBN',1100000), 2701(2439,'Tripoli','LBN',240000), 2702(2440,'Monrovia','LBR',850000), 2703(2441,'Tripoli','LBY',1682000), 2704(2442,'Bengasi','LBY',804000), 2705(2443,'Misrata','LBY',121669), 2706(2444,'al-Zawiya','LBY',89338), 2707(2445,'Schaan','LIE',5346), 2708(2446,'Vaduz','LIE',5043), 2709(2447,'Vilnius','LTU',577969), 2710(2448,'Kaunas','LTU',412639), 2711(2449,'Klaipeda','LTU',202451), 2712(2450,'iauliai','LTU',146563), 2713(2451,'Panevezys','LTU',133695), 2714(2452,'Luxembourg [Luxemburg/Lëtzebuerg]','LUX',80700), 2715(2453,'El-Aaiún','ESH',169000), 2716(2454,'Macao','MAC',437500), 2717(2455,'Antananarivo','MDG',675669), 2718(2456,'Toamasina','MDG',127441), 2719(2457,'Antsirabé','MDG',120239), 2720(2458,'Mahajanga','MDG',100807), 2721(2459,'Fianarantsoa','MDG',99005), 2722(2460,'Skopje','MKD',444299), 2723(2461,'Blantyre','MWI',478155), 2724(2462,'Lilongwe','MWI',435964), 2725(2463,'Male','MDV',71000), 2726(2464,'Kuala Lumpur','MYS',1297526), 2727(2465,'Ipoh','MYS',382853), 2728(2466,'Johor Baharu','MYS',328436), 2729(2467,'Petaling Jaya','MYS',254350), 2730(2468,'Kelang','MYS',243355), 2731(2469,'Kuala Terengganu','MYS',228119), 2732(2470,'Pinang','MYS',219603), 2733(2471,'Kota Bharu','MYS',219582), 2734(2472,'Kuantan','MYS',199484), 2735(2473,'Taiping','MYS',183261), 2736(2474,'Seremban','MYS',182869), 2737(2475,'Kuching','MYS',148059), 2738(2476,'Sibu','MYS',126381), 2739(2477,'Sandakan','MYS',125841), 2740(2478,'Alor Setar','MYS',124412), 2741(2479,'Selayang Baru','MYS',124228), 2742(2480,'Sungai Petani','MYS',114763), 2743(2481,'Shah Alam','MYS',102019), 2744(2482,'Bamako','MLI',809552), 2745(2483,'Birkirkara','MLT',21445), 2746(2484,'Valletta','MLT',7073), 2747(2485,'Casablanca','MAR',2940623), 2748(2486,'Rabat','MAR',623457), 2749(2487,'Marrakech','MAR',621914), 2750(2488,'Fès','MAR',541162), 2751(2489,'Tanger','MAR',521735), 2752(2490,'Salé','MAR',504420), 2753(2491,'Meknès','MAR',460000), 2754(2492,'Oujda','MAR',365382), 2755(2493,'Kénitra','MAR',292600), 2756(2494,'Tétouan','MAR',277516), 2757(2495,'Safi','MAR',262300), 2758(2496,'Agadir','MAR',155244), 2759(2497,'Mohammedia','MAR',154706), 2760(2498,'Khouribga','MAR',152090), 2761(2499,'Beni-Mellal','MAR',140212), 2762(2500,'Témara','MAR',126303), 2763(2501,'El Jadida','MAR',119083), 2764(2502,'Nador','MAR',112450), 2765(2503,'Ksar el Kebir','MAR',107065), 2766(2504,'Settat','MAR',96200), 2767(2505,'Taza','MAR',92700), 2768(2506,'El Araich','MAR',90400), 2769(2507,'Dalap-Uliga-Darrit','MHL',28000), 2770(2508,'Fort-de-France','MTQ',94050), 2771(2509,'Nouakchott','MRT',667300), 2772(2510,'Nouâdhibou','MRT',97600), 2773(2511,'Port-Louis','MUS',138200), 2774(2512,'Beau Bassin-Rose Hill','MUS',100616), 2775(2513,'Vacoas-Phoenix','MUS',98464), 2776(2514,'Mamoutzou','MYT',12000), 2777(2515,'Ciudad de México','MEX',8591309), 2778(2516,'Guadalajara','MEX',1647720), 2779(2517,'Ecatepec de Morelos','MEX',1620303), 2780(2518,'Puebla','MEX',1346176), 2781(2519,'Nezahualcóyotl','MEX',1224924), 2782(2520,'Juárez','MEX',1217818), 2783(2521,'Tijuana','MEX',1212232), 2784(2522,'León','MEX',1133576), 2785(2523,'Monterrey','MEX',1108499), 2786(2524,'Zapopan','MEX',1002239), 2787(2525,'Naucalpan de Juárez','MEX',857511), 2788(2526,'Mexicali','MEX',764902), 2789(2527,'Culiacán','MEX',744859), 2790(2528,'Acapulco de Juárez','MEX',721011), 2791(2529,'Tlalnepantla de Baz','MEX',720755), 2792(2530,'Mérida','MEX',703324), 2793(2531,'Chihuahua','MEX',670208), 2794(2532,'San Luis Potosí','MEX',669353), 2795(2533,'Guadalupe','MEX',668780), 2796(2534,'Toluca','MEX',665617), 2797(2535,'Aguascalientes','MEX',643360), 2798(2536,'Querétaro','MEX',639839), 2799(2537,'Morelia','MEX',619958), 2800(2538,'Hermosillo','MEX',608697), 2801(2539,'Saltillo','MEX',577352), 2802(2540,'Torreón','MEX',529093), 2803(2541,'Centro (Villahermosa)','MEX',519873), 2804(2542,'San Nicolás de los Garza','MEX',495540), 2805(2543,'Durango','MEX',490524), 2806(2544,'Chimalhuacán','MEX',490245), 2807(2545,'Tlaquepaque','MEX',475472), 2808(2546,'Atizapán de Zaragoza','MEX',467262), 2809(2547,'Veracruz','MEX',457119), 2810(2548,'Cuautitlán Izcalli','MEX',452976), 2811(2549,'Irapuato','MEX',440039), 2812(2550,'Tuxtla Gutiérrez','MEX',433544), 2813(2551,'Tultitlán','MEX',432411), 2814(2552,'Reynosa','MEX',419776), 2815(2553,'Benito Juárez','MEX',419276), 2816(2554,'Matamoros','MEX',416428), 2817(2555,'Xalapa','MEX',390058), 2818(2556,'Celaya','MEX',382140), 2819(2557,'Mazatlán','MEX',380265), 2820(2558,'Ensenada','MEX',369573), 2821(2559,'Ahome','MEX',358663), 2822(2560,'Cajeme','MEX',355679), 2823(2561,'Cuernavaca','MEX',337966), 2824(2562,'Tonalá','MEX',336109), 2825(2563,'Valle de Chalco Solidaridad','MEX',323113), 2826(2564,'Nuevo Laredo','MEX',310277), 2827(2565,'Tepic','MEX',305025), 2828(2566,'Tampico','MEX',294789), 2829(2567,'Ixtapaluca','MEX',293160), 2830(2568,'Apodaca','MEX',282941), 2831(2569,'Guasave','MEX',277201), 2832(2570,'Gómez Palacio','MEX',272806), 2833(2571,'Tapachula','MEX',271141), 2834(2572,'Nicolás Romero','MEX',269393), 2835(2573,'Coatzacoalcos','MEX',267037), 2836(2574,'Uruapan','MEX',265211), 2837(2575,'Victoria','MEX',262686), 2838(2576,'Oaxaca de Juárez','MEX',256848), 2839(2577,'Coacalco de Berriozábal','MEX',252270), 2840(2578,'Pachuca de Soto','MEX',244688), 2841(2579,'General Escobedo','MEX',232961), 2842(2580,'Salamanca','MEX',226864), 2843(2581,'Santa Catarina','MEX',226573), 2844(2582,'Tehuacán','MEX',225943), 2845(2583,'Chalco','MEX',222201), 2846(2584,'Cárdenas','MEX',216903), 2847(2585,'Campeche','MEX',216735), 2848(2586,'La Paz','MEX',213045), 2849(2587,'Othón P. Blanco (Chetumal)','MEX',208014), 2850(2588,'Texcoco','MEX',203681), 2851(2589,'La Paz','MEX',196708), 2852(2590,'Metepec','MEX',194265), 2853(2591,'Monclova','MEX',193657), 2854(2592,'Huixquilucan','MEX',193156), 2855(2593,'Chilpancingo de los Bravo','MEX',192509), 2856(2594,'Puerto Vallarta','MEX',183741), 2857(2595,'Fresnillo','MEX',182744), 2858(2596,'Ciudad Madero','MEX',182012), 2859(2597,'Soledad de Graciano Sánchez','MEX',179956), 2860(2598,'San Juan del Río','MEX',179300), 2861(2599,'San Felipe del Progreso','MEX',177330), 2862(2600,'Córdoba','MEX',176952); 2863INSERT INTO City VALUES 2864(2601,'Tecámac','MEX',172410), 2865(2602,'Ocosingo','MEX',171495), 2866(2603,'Carmen','MEX',171367), 2867(2604,'Lázaro Cárdenas','MEX',170878), 2868(2605,'Jiutepec','MEX',170428), 2869(2606,'Papantla','MEX',170123), 2870(2607,'Comalcalco','MEX',164640), 2871(2608,'Zamora','MEX',161191), 2872(2609,'Nogales','MEX',159103), 2873(2610,'Huimanguillo','MEX',158335), 2874(2611,'Cuautla','MEX',153132), 2875(2612,'Minatitlán','MEX',152983), 2876(2613,'Poza Rica de Hidalgo','MEX',152678), 2877(2614,'Ciudad Valles','MEX',146411), 2878(2615,'Navolato','MEX',145396), 2879(2616,'San Luis Río Colorado','MEX',145276), 2880(2617,'Pénjamo','MEX',143927), 2881(2618,'San Andrés Tuxtla','MEX',142251), 2882(2619,'Guanajuato','MEX',141215), 2883(2620,'Navojoa','MEX',140495), 2884(2621,'Zitácuaro','MEX',137970), 2885(2622,'Boca del Río','MEX',135721), 2886(2623,'Allende','MEX',134645), 2887(2624,'Silao','MEX',134037), 2888(2625,'Macuspana','MEX',133795), 2889(2626,'San Juan Bautista Tuxtepec','MEX',133675), 2890(2627,'San Cristóbal de las Casas','MEX',132317), 2891(2628,'Valle de Santiago','MEX',130557), 2892(2629,'Guaymas','MEX',130108), 2893(2630,'Colima','MEX',129454), 2894(2631,'Dolores Hidalgo','MEX',128675), 2895(2632,'Lagos de Moreno','MEX',127949), 2896(2633,'Piedras Negras','MEX',127898), 2897(2634,'Altamira','MEX',127490), 2898(2635,'Túxpam','MEX',126475), 2899(2636,'San Pedro Garza García','MEX',126147), 2900(2637,'Cuauhtémoc','MEX',124279), 2901(2638,'Manzanillo','MEX',124014), 2902(2639,'Iguala de la Independencia','MEX',123883), 2903(2640,'Zacatecas','MEX',123700), 2904(2641,'Tlajomulco de Zúñiga','MEX',123220), 2905(2642,'Tulancingo de Bravo','MEX',121946), 2906(2643,'Zinacantepec','MEX',121715), 2907(2644,'San Martín Texmelucan','MEX',121093), 2908(2645,'Tepatitlán de Morelos','MEX',118948), 2909(2646,'Martínez de la Torre','MEX',118815), 2910(2647,'Orizaba','MEX',118488), 2911(2648,'Apatzingán','MEX',117849), 2912(2649,'Atlixco','MEX',117019), 2913(2650,'Delicias','MEX',116132), 2914(2651,'Ixtlahuaca','MEX',115548), 2915(2652,'El Mante','MEX',112453), 2916(2653,'Lerdo','MEX',112272), 2917(2654,'Almoloya de Juárez','MEX',110550), 2918(2655,'Acámbaro','MEX',110487), 2919(2656,'Acuña','MEX',110388), 2920(2657,'Guadalupe','MEX',108881), 2921(2658,'Huejutla de Reyes','MEX',108017), 2922(2659,'Hidalgo','MEX',106198), 2923(2660,'Los Cabos','MEX',105199), 2924(2661,'Comitán de Domínguez','MEX',104986), 2925(2662,'Cunduacán','MEX',104164), 2926(2663,'Río Bravo','MEX',103901), 2927(2664,'Temapache','MEX',102824), 2928(2665,'Chilapa de Alvarez','MEX',102716), 2929(2666,'Hidalgo del Parral','MEX',100881), 2930(2667,'San Francisco del Rincón','MEX',100149), 2931(2668,'Taxco de Alarcón','MEX',99907), 2932(2669,'Zumpango','MEX',99781), 2933(2670,'San Pedro Cholula','MEX',99734), 2934(2671,'Lerma','MEX',99714), 2935(2672,'Tecomán','MEX',99296), 2936(2673,'Las Margaritas','MEX',97389), 2937(2674,'Cosoleacaque','MEX',97199), 2938(2675,'San Luis de la Paz','MEX',96763), 2939(2676,'José Azueta','MEX',95448), 2940(2677,'Santiago Ixcuintla','MEX',95311), 2941(2678,'San Felipe','MEX',95305), 2942(2679,'Tejupilco','MEX',94934), 2943(2680,'Tantoyuca','MEX',94709), 2944(2681,'Salvatierra','MEX',94322), 2945(2682,'Tultepec','MEX',93364), 2946(2683,'Temixco','MEX',92686), 2947(2684,'Matamoros','MEX',91858), 2948(2685,'Pánuco','MEX',90551), 2949(2686,'El Fuerte','MEX',89556), 2950(2687,'Tierra Blanca','MEX',89143), 2951(2688,'Weno','FSM',22000), 2952(2689,'Palikir','FSM',8600), 2953(2690,'Chisinau','MDA',719900), 2954(2691,'Tiraspol','MDA',194300), 2955(2692,'Balti','MDA',153400), 2956(2693,'Bender (Tîghina)','MDA',125700), 2957(2694,'Monte-Carlo','MCO',13154), 2958(2695,'Monaco-Ville','MCO',1234), 2959(2696,'Ulan Bator','MNG',773700), 2960(2697,'Plymouth','MSR',2000), 2961(2698,'Maputo','MOZ',1018938), 2962(2699,'Matola','MOZ',424662), 2963(2700,'Beira','MOZ',397368), 2964(2701,'Nampula','MOZ',303346), 2965(2702,'Chimoio','MOZ',171056), 2966(2703,'Naçala-Porto','MOZ',158248), 2967(2704,'Quelimane','MOZ',150116), 2968(2705,'Mocuba','MOZ',124700), 2969(2706,'Tete','MOZ',101984), 2970(2707,'Xai-Xai','MOZ',99442), 2971(2708,'Gurue','MOZ',99300), 2972(2709,'Maxixe','MOZ',93985), 2973(2710,'Rangoon (Yangon)','MMR',3361700), 2974(2711,'Mandalay','MMR',885300), 2975(2712,'Moulmein (Mawlamyine)','MMR',307900), 2976(2713,'Pegu (Bago)','MMR',190900), 2977(2714,'Bassein (Pathein)','MMR',183900), 2978(2715,'Monywa','MMR',138600), 2979(2716,'Sittwe (Akyab)','MMR',137600), 2980(2717,'Taunggyi (Taunggye)','MMR',131500), 2981(2718,'Meikhtila','MMR',129700), 2982(2719,'Mergui (Myeik)','MMR',122700), 2983(2720,'Lashio (Lasho)','MMR',107600), 2984(2721,'Prome (Pyay)','MMR',105700), 2985(2722,'Henzada (Hinthada)','MMR',104700), 2986(2723,'Myingyan','MMR',103600), 2987(2724,'Tavoy (Dawei)','MMR',96800), 2988(2725,'Pagakku (Pakokku)','MMR',94800), 2989(2726,'Windhoek','NAM',169000), 2990(2727,'Yangor','NRU',4050), 2991(2728,'Yaren','NRU',559), 2992(2729,'Kathmandu','NPL',591835), 2993(2730,'Biratnagar','NPL',157764), 2994(2731,'Pokhara','NPL',146318), 2995(2732,'Lalitapur','NPL',145847), 2996(2733,'Birgunj','NPL',90639), 2997(2734,'Managua','NIC',959000), 2998(2735,'León','NIC',123865), 2999(2736,'Chinandega','NIC',97387), 3000(2737,'Masaya','NIC',88971), 3001(2738,'Niamey','NER',420000), 3002(2739,'Zinder','NER',120892), 3003(2740,'Maradi','NER',112965), 3004(2741,'Lagos','NGA',1518000), 3005(2742,'Ibadan','NGA',1432000), 3006(2743,'Ogbomosho','NGA',730000), 3007(2744,'Kano','NGA',674100), 3008(2745,'Oshogbo','NGA',476800), 3009(2746,'Ilorin','NGA',475800), 3010(2747,'Abeokuta','NGA',427400), 3011(2748,'Port Harcourt','NGA',410000), 3012(2749,'Zaria','NGA',379200), 3013(2750,'Ilesha','NGA',378400), 3014(2751,'Onitsha','NGA',371900), 3015(2752,'Iwo','NGA',362000), 3016(2753,'Ado-Ekiti','NGA',359400), 3017(2754,'Abuja','NGA',350100), 3018(2755,'Kaduna','NGA',342200), 3019(2756,'Mushin','NGA',333200), 3020(2757,'Maiduguri','NGA',320000), 3021(2758,'Enugu','NGA',316100), 3022(2759,'Ede','NGA',307100), 3023(2760,'Aba','NGA',298900), 3024(2761,'Ife','NGA',296800), 3025(2762,'Ila','NGA',264000), 3026(2763,'Oyo','NGA',256400), 3027(2764,'Ikerre','NGA',244600), 3028(2765,'Benin City','NGA',229400), 3029(2766,'Iseyin','NGA',217300), 3030(2767,'Katsina','NGA',206500), 3031(2768,'Jos','NGA',206300), 3032(2769,'Sokoto','NGA',204900), 3033(2770,'Ilobu','NGA',199000), 3034(2771,'Offa','NGA',197200), 3035(2772,'Ikorodu','NGA',184900), 3036(2773,'Ilawe-Ekiti','NGA',184500), 3037(2774,'Owo','NGA',183500), 3038(2775,'Ikirun','NGA',181400), 3039(2776,'Shaki','NGA',174500), 3040(2777,'Calabar','NGA',174400), 3041(2778,'Ondo','NGA',173600), 3042(2779,'Akure','NGA',162300), 3043(2780,'Gusau','NGA',158000), 3044(2781,'Ijebu-Ode','NGA',156400), 3045(2782,'Effon-Alaiye','NGA',153100), 3046(2783,'Kumo','NGA',148000), 3047(2784,'Shomolu','NGA',147700), 3048(2785,'Oka-Akoko','NGA',142900), 3049(2786,'Ikare','NGA',140800), 3050(2787,'Sapele','NGA',139200), 3051(2788,'Deba Habe','NGA',138600), 3052(2789,'Minna','NGA',136900), 3053(2790,'Warri','NGA',126100), 3054(2791,'Bida','NGA',125500), 3055(2792,'Ikire','NGA',123300), 3056(2793,'Makurdi','NGA',123100), 3057(2794,'Lafia','NGA',122500), 3058(2795,'Inisa','NGA',119800), 3059(2796,'Shagamu','NGA',117200), 3060(2797,'Awka','NGA',111200), 3061(2798,'Gombe','NGA',107800), 3062(2799,'Igboho','NGA',106800), 3063(2800,'Ejigbo','NGA',105900); 3064INSERT INTO City VALUES 3065(2801,'Agege','NGA',105000), 3066(2802,'Ise-Ekiti','NGA',103400), 3067(2803,'Ugep','NGA',102600), 3068(2804,'Epe','NGA',101000), 3069(2805,'Alofi','NIU',682), 3070(2806,'Kingston','NFK',800), 3071(2807,'Oslo','NOR',508726), 3072(2808,'Bergen','NOR',230948), 3073(2809,'Trondheim','NOR',150166), 3074(2810,'Stavanger','NOR',108848), 3075(2811,'Bærum','NOR',101340), 3076(2812,'Abidjan','CIV',2500000), 3077(2813,'Bouaké','CIV',329850), 3078(2814,'Yamoussoukro','CIV',130000), 3079(2815,'Daloa','CIV',121842), 3080(2816,'Korhogo','CIV',109445), 3081(2817,'al-Sib','OMN',155000), 3082(2818,'Salala','OMN',131813), 3083(2819,'Bawshar','OMN',107500), 3084(2820,'Suhar','OMN',90814), 3085(2821,'Masqat','OMN',51969), 3086(2822,'Karachi','PAK',9269265), 3087(2823,'Lahore','PAK',5063499), 3088(2824,'Faisalabad','PAK',1977246), 3089(2825,'Rawalpindi','PAK',1406214), 3090(2826,'Multan','PAK',1182441), 3091(2827,'Hyderabad','PAK',1151274), 3092(2828,'Gujranwala','PAK',1124749), 3093(2829,'Peshawar','PAK',988005), 3094(2830,'Quetta','PAK',560307), 3095(2831,'Islamabad','PAK',524500), 3096(2832,'Sargodha','PAK',455360), 3097(2833,'Sialkot','PAK',417597), 3098(2834,'Bahawalpur','PAK',403408), 3099(2835,'Sukkur','PAK',329176), 3100(2836,'Jhang','PAK',292214), 3101(2837,'Sheikhupura','PAK',271875), 3102(2838,'Larkana','PAK',270366), 3103(2839,'Gujrat','PAK',250121), 3104(2840,'Mardan','PAK',244511), 3105(2841,'Kasur','PAK',241649), 3106(2842,'Rahim Yar Khan','PAK',228479), 3107(2843,'Sahiwal','PAK',207388), 3108(2844,'Okara','PAK',200901), 3109(2845,'Wah','PAK',198400), 3110(2846,'Dera Ghazi Khan','PAK',188100), 3111(2847,'Mirpur Khas','PAK',184500), 3112(2848,'Nawabshah','PAK',183100), 3113(2849,'Mingora','PAK',174500), 3114(2850,'Chiniot','PAK',169300), 3115(2851,'Kamoke','PAK',151000), 3116(2852,'Mandi Burewala','PAK',149900), 3117(2853,'Jhelum','PAK',145800), 3118(2854,'Sadiqabad','PAK',141500), 3119(2855,'Jacobabad','PAK',137700), 3120(2856,'Shikarpur','PAK',133300), 3121(2857,'Khanewal','PAK',133000), 3122(2858,'Hafizabad','PAK',130200), 3123(2859,'Kohat','PAK',125300), 3124(2860,'Muzaffargarh','PAK',121600), 3125(2861,'Khanpur','PAK',117800), 3126(2862,'Gojra','PAK',115000), 3127(2863,'Bahawalnagar','PAK',109600), 3128(2864,'Muridke','PAK',108600), 3129(2865,'Pak Pattan','PAK',107800), 3130(2866,'Abottabad','PAK',106000), 3131(2867,'Tando Adam','PAK',103400), 3132(2868,'Jaranwala','PAK',103300), 3133(2869,'Khairpur','PAK',102200), 3134(2870,'Chishtian Mandi','PAK',101700), 3135(2871,'Daska','PAK',101500), 3136(2872,'Dadu','PAK',98600), 3137(2873,'Mandi Bahauddin','PAK',97300), 3138(2874,'Ahmadpur East','PAK',96000), 3139(2875,'Kamalia','PAK',95300), 3140(2876,'Khuzdar','PAK',93100), 3141(2877,'Vihari','PAK',92300), 3142(2878,'Dera Ismail Khan','PAK',90400), 3143(2879,'Wazirabad','PAK',89700), 3144(2880,'Nowshera','PAK',89400), 3145(2881,'Koror','PLW',12000), 3146(2882,'Ciudad de Panamá','PAN',471373), 3147(2883,'San Miguelito','PAN',315382), 3148(2884,'Port Moresby','PNG',247000), 3149(2885,'Asunción','PRY',557776), 3150(2886,'Ciudad del Este','PRY',133881), 3151(2887,'San Lorenzo','PRY',133395), 3152(2888,'Lambaré','PRY',99681), 3153(2889,'Fernando de la Mora','PRY',95287), 3154(2890,'Lima','PER',6464693), 3155(2891,'Arequipa','PER',762000), 3156(2892,'Trujillo','PER',652000), 3157(2893,'Chiclayo','PER',517000), 3158(2894,'Callao','PER',424294), 3159(2895,'Iquitos','PER',367000), 3160(2896,'Chimbote','PER',336000), 3161(2897,'Huancayo','PER',327000), 3162(2898,'Piura','PER',325000), 3163(2899,'Cusco','PER',291000), 3164(2900,'Pucallpa','PER',220866), 3165(2901,'Tacna','PER',215683), 3166(2902,'Ica','PER',194820), 3167(2903,'Sullana','PER',147361), 3168(2904,'Juliaca','PER',142576), 3169(2905,'Huánuco','PER',129688), 3170(2906,'Ayacucho','PER',118960), 3171(2907,'Chincha Alta','PER',110016), 3172(2908,'Cajamarca','PER',108009), 3173(2909,'Puno','PER',101578), 3174(2910,'Ventanilla','PER',101056), 3175(2911,'Castilla','PER',90642), 3176(2912,'Adamstown','PCN',42), 3177(2913,'Garapan','MNP',9200), 3178(2914,'Lisboa','PRT',563210), 3179(2915,'Porto','PRT',273060), 3180(2916,'Amadora','PRT',122106), 3181(2917,'Coímbra','PRT',96100), 3182(2918,'Braga','PRT',90535), 3183(2919,'San Juan','PRI',434374), 3184(2920,'Bayamón','PRI',224044), 3185(2921,'Ponce','PRI',186475), 3186(2922,'Carolina','PRI',186076), 3187(2923,'Caguas','PRI',140502), 3188(2924,'Arecibo','PRI',100131), 3189(2925,'Guaynabo','PRI',100053), 3190(2926,'Mayagüez','PRI',98434), 3191(2927,'Toa Baja','PRI',94085), 3192(2928,'Warszawa','POL',1615369), 3193(2929,'Lódz','POL',800110), 3194(2930,'Kraków','POL',738150), 3195(2931,'Wroclaw','POL',636765), 3196(2932,'Poznan','POL',576899), 3197(2933,'Gdansk','POL',458988), 3198(2934,'Szczecin','POL',416988), 3199(2935,'Bydgoszcz','POL',386855), 3200(2936,'Lublin','POL',356251), 3201(2937,'Katowice','POL',345934), 3202(2938,'Bialystok','POL',283937), 3203(2939,'Czestochowa','POL',257812), 3204(2940,'Gdynia','POL',253521), 3205(2941,'Sosnowiec','POL',244102), 3206(2942,'Radom','POL',232262), 3207(2943,'Kielce','POL',212383), 3208(2944,'Gliwice','POL',212164), 3209(2945,'Torun','POL',206158), 3210(2946,'Bytom','POL',205560), 3211(2947,'Zabrze','POL',200177), 3212(2948,'Bielsko-Biala','POL',180307), 3213(2949,'Olsztyn','POL',170904), 3214(2950,'Rzeszów','POL',162049), 3215(2951,'Ruda Slaska','POL',159665), 3216(2952,'Rybnik','POL',144582), 3217(2953,'Walbrzych','POL',136923), 3218(2954,'Tychy','POL',133178), 3219(2955,'Dabrowa Górnicza','POL',131037), 3220(2956,'Plock','POL',131011), 3221(2957,'Elblag','POL',129782), 3222(2958,'Opole','POL',129553), 3223(2959,'Gorzów Wielkopolski','POL',126019), 3224(2960,'Wloclawek','POL',123373), 3225(2961,'Chorzów','POL',121708), 3226(2962,'Tarnów','POL',121494), 3227(2963,'Zielona Góra','POL',118182), 3228(2964,'Koszalin','POL',112375), 3229(2965,'Legnica','POL',109335), 3230(2966,'Kalisz','POL',106641), 3231(2967,'Grudziadz','POL',102434), 3232(2968,'Slupsk','POL',102370), 3233(2969,'Jastrzebie-Zdrój','POL',102294), 3234(2970,'Jaworzno','POL',97929), 3235(2971,'Jelenia Góra','POL',93901), 3236(2972,'Malabo','GNQ',40000), 3237(2973,'Doha','QAT',355000), 3238(2974,'Paris','FRA',2125246), 3239(2975,'Marseille','FRA',798430), 3240(2976,'Lyon','FRA',445452), 3241(2977,'Toulouse','FRA',390350), 3242(2978,'Nice','FRA',342738), 3243(2979,'Nantes','FRA',270251), 3244(2980,'Strasbourg','FRA',264115), 3245(2981,'Montpellier','FRA',225392), 3246(2982,'Bordeaux','FRA',215363), 3247(2983,'Rennes','FRA',206229), 3248(2984,'Le Havre','FRA',190905), 3249(2985,'Reims','FRA',187206), 3250(2986,'Lille','FRA',184657), 3251(2987,'St-Étienne','FRA',180210), 3252(2988,'Toulon','FRA',160639), 3253(2989,'Grenoble','FRA',153317), 3254(2990,'Angers','FRA',151279), 3255(2991,'Dijon','FRA',149867), 3256(2992,'Brest','FRA',149634), 3257(2993,'Le Mans','FRA',146105), 3258(2994,'Clermont-Ferrand','FRA',137140), 3259(2995,'Amiens','FRA',135501), 3260(2996,'Aix-en-Provence','FRA',134222), 3261(2997,'Limoges','FRA',133968), 3262(2998,'Nîmes','FRA',133424), 3263(2999,'Tours','FRA',132820), 3264(3000,'Villeurbanne','FRA',124215); 3265INSERT INTO City VALUES 3266(3001,'Metz','FRA',123776), 3267(3002,'Besançon','FRA',117733), 3268(3003,'Caen','FRA',113987), 3269(3004,'Orléans','FRA',113126), 3270(3005,'Mulhouse','FRA',110359), 3271(3006,'Rouen','FRA',106592), 3272(3007,'Boulogne-Billancourt','FRA',106367), 3273(3008,'Perpignan','FRA',105115), 3274(3009,'Nancy','FRA',103605), 3275(3010,'Roubaix','FRA',96984), 3276(3011,'Argenteuil','FRA',93961), 3277(3012,'Tourcoing','FRA',93540), 3278(3013,'Montreuil','FRA',90674), 3279(3014,'Cayenne','GUF',50699), 3280(3015,'Faaa','PYF',25888), 3281(3016,'Papeete','PYF',25553), 3282(3017,'Saint-Denis','REU',131480), 3283(3018,'Bucuresti','ROM',2016131), 3284(3019,'Iasi','ROM',348070), 3285(3020,'Constanta','ROM',342264), 3286(3021,'Cluj-Napoca','ROM',332498), 3287(3022,'Galati','ROM',330276), 3288(3023,'Timisoara','ROM',324304), 3289(3024,'Brasov','ROM',314225), 3290(3025,'Craiova','ROM',313530), 3291(3026,'Ploiesti','ROM',251348), 3292(3027,'Braila','ROM',233756), 3293(3028,'Oradea','ROM',222239), 3294(3029,'Bacau','ROM',209235), 3295(3030,'Pitesti','ROM',187170), 3296(3031,'Arad','ROM',184408), 3297(3032,'Sibiu','ROM',169611), 3298(3033,'Târgu Mures','ROM',165153), 3299(3034,'Baia Mare','ROM',149665), 3300(3035,'Buzau','ROM',148372), 3301(3036,'Satu Mare','ROM',130059), 3302(3037,'Botosani','ROM',128730), 3303(3038,'Piatra Neamt','ROM',125070), 3304(3039,'Râmnicu Vâlcea','ROM',119741), 3305(3040,'Suceava','ROM',118549), 3306(3041,'Drobeta-Turnu Severin','ROM',117865), 3307(3042,'Târgoviste','ROM',98980), 3308(3043,'Focsani','ROM',98979), 3309(3044,'Târgu Jiu','ROM',98524), 3310(3045,'Tulcea','ROM',96278), 3311(3046,'Resita','ROM',93976), 3312(3047,'Kigali','RWA',286000), 3313(3048,'Stockholm','SWE',750348), 3314(3049,'Gothenburg [Göteborg]','SWE',466990), 3315(3050,'Malmö','SWE',259579), 3316(3051,'Uppsala','SWE',189569), 3317(3052,'Linköping','SWE',133168), 3318(3053,'Västerås','SWE',126328), 3319(3054,'Örebro','SWE',124207), 3320(3055,'Norrköping','SWE',122199), 3321(3056,'Helsingborg','SWE',117737), 3322(3057,'Jönköping','SWE',117095), 3323(3058,'Umeå','SWE',104512), 3324(3059,'Lund','SWE',98948), 3325(3060,'Borås','SWE',96883), 3326(3061,'Sundsvall','SWE',93126), 3327(3062,'Gävle','SWE',90742), 3328(3063,'Jamestown','SHN',1500), 3329(3064,'Basseterre','KNA',11600), 3330(3065,'Castries','LCA',2301), 3331(3066,'Kingstown','VCT',17100), 3332(3067,'Saint-Pierre','SPM',5808), 3333(3068,'Berlin','DEU',3386667), 3334(3069,'Hamburg','DEU',1704735), 3335(3070,'Munich [München]','DEU',1194560), 3336(3071,'Köln','DEU',962507), 3337(3072,'Frankfurt am Main','DEU',643821), 3338(3073,'Essen','DEU',599515), 3339(3074,'Dortmund','DEU',590213), 3340(3075,'Stuttgart','DEU',582443), 3341(3076,'Düsseldorf','DEU',568855), 3342(3077,'Bremen','DEU',540330), 3343(3078,'Duisburg','DEU',519793), 3344(3079,'Hannover','DEU',514718), 3345(3080,'Leipzig','DEU',489532), 3346(3081,'Nürnberg','DEU',486628), 3347(3082,'Dresden','DEU',476668), 3348(3083,'Bochum','DEU',392830), 3349(3084,'Wuppertal','DEU',368993), 3350(3085,'Bielefeld','DEU',321125), 3351(3086,'Mannheim','DEU',307730), 3352(3087,'Bonn','DEU',301048), 3353(3088,'Gelsenkirchen','DEU',281979), 3354(3089,'Karlsruhe','DEU',277204), 3355(3090,'Wiesbaden','DEU',268716), 3356(3091,'Münster','DEU',264670), 3357(3092,'Mönchengladbach','DEU',263697), 3358(3093,'Chemnitz','DEU',263222), 3359(3094,'Augsburg','DEU',254867), 3360(3095,'Halle/Saale','DEU',254360), 3361(3096,'Braunschweig','DEU',246322), 3362(3097,'Aachen','DEU',243825), 3363(3098,'Krefeld','DEU',241769), 3364(3099,'Magdeburg','DEU',235073), 3365(3100,'Kiel','DEU',233795), 3366(3101,'Oberhausen','DEU',222349), 3367(3102,'Lübeck','DEU',213326), 3368(3103,'Hagen','DEU',205201), 3369(3104,'Rostock','DEU',203279), 3370(3105,'Freiburg im Breisgau','DEU',202455), 3371(3106,'Erfurt','DEU',201267), 3372(3107,'Kassel','DEU',196211), 3373(3108,'Saarbrücken','DEU',183836), 3374(3109,'Mainz','DEU',183134), 3375(3110,'Hamm','DEU',181804), 3376(3111,'Herne','DEU',175661), 3377(3112,'Mülheim an der Ruhr','DEU',173895), 3378(3113,'Solingen','DEU',165583), 3379(3114,'Osnabrück','DEU',164539), 3380(3115,'Ludwigshafen am Rhein','DEU',163771), 3381(3116,'Leverkusen','DEU',160841), 3382(3117,'Oldenburg','DEU',154125), 3383(3118,'Neuss','DEU',149702), 3384(3119,'Heidelberg','DEU',139672), 3385(3120,'Darmstadt','DEU',137776), 3386(3121,'Paderborn','DEU',137647), 3387(3122,'Potsdam','DEU',128983), 3388(3123,'Würzburg','DEU',127350), 3389(3124,'Regensburg','DEU',125236), 3390(3125,'Recklinghausen','DEU',125022), 3391(3126,'Göttingen','DEU',124775), 3392(3127,'Bremerhaven','DEU',122735), 3393(3128,'Wolfsburg','DEU',121954), 3394(3129,'Bottrop','DEU',121097), 3395(3130,'Remscheid','DEU',120125), 3396(3131,'Heilbronn','DEU',119526), 3397(3132,'Pforzheim','DEU',117227), 3398(3133,'Offenbach am Main','DEU',116627), 3399(3134,'Ulm','DEU',116103), 3400(3135,'Ingolstadt','DEU',114826), 3401(3136,'Gera','DEU',114718), 3402(3137,'Salzgitter','DEU',112934), 3403(3138,'Cottbus','DEU',110894), 3404(3139,'Reutlingen','DEU',110343), 3405(3140,'Fürth','DEU',109771), 3406(3141,'Siegen','DEU',109225), 3407(3142,'Koblenz','DEU',108003), 3408(3143,'Moers','DEU',106837), 3409(3144,'Bergisch Gladbach','DEU',106150), 3410(3145,'Zwickau','DEU',104146), 3411(3146,'Hildesheim','DEU',104013), 3412(3147,'Witten','DEU',103384), 3413(3148,'Schwerin','DEU',102878), 3414(3149,'Erlangen','DEU',100750), 3415(3150,'Kaiserslautern','DEU',100025), 3416(3151,'Trier','DEU',99891), 3417(3152,'Jena','DEU',99779), 3418(3153,'Iserlohn','DEU',99474), 3419(3154,'Gütersloh','DEU',95028), 3420(3155,'Marl','DEU',93735), 3421(3156,'Lünen','DEU',92044), 3422(3157,'Düren','DEU',91092), 3423(3158,'Ratingen','DEU',90951), 3424(3159,'Velbert','DEU',89881), 3425(3160,'Esslingen am Neckar','DEU',89667), 3426(3161,'Honiara','SLB',50100), 3427(3162,'Lusaka','ZMB',1317000), 3428(3163,'Ndola','ZMB',329200), 3429(3164,'Kitwe','ZMB',288600), 3430(3165,'Kabwe','ZMB',154300), 3431(3166,'Chingola','ZMB',142400), 3432(3167,'Mufulira','ZMB',123900), 3433(3168,'Luanshya','ZMB',118100), 3434(3169,'Apia','WSM',35900), 3435(3170,'Serravalle','SMR',4802), 3436(3171,'San Marino','SMR',2294), 3437(3172,'São Tomé','STP',49541), 3438(3173,'Riyadh','SAU',3324000), 3439(3174,'Jedda','SAU',2046300), 3440(3175,'Mekka','SAU',965700), 3441(3176,'Medina','SAU',608300), 3442(3177,'al-Dammam','SAU',482300), 3443(3178,'al-Taif','SAU',416100), 3444(3179,'Tabuk','SAU',292600), 3445(3180,'Burayda','SAU',248600), 3446(3181,'al-Hufuf','SAU',225800), 3447(3182,'al-Mubarraz','SAU',219100), 3448(3183,'Khamis Mushayt','SAU',217900), 3449(3184,'Hail','SAU',176800), 3450(3185,'al-Kharj','SAU',152100), 3451(3186,'al-Khubar','SAU',141700), 3452(3187,'Jubayl','SAU',140800), 3453(3188,'Hafar al-Batin','SAU',137800), 3454(3189,'al-Tuqba','SAU',125700), 3455(3190,'Yanbu','SAU',119800), 3456(3191,'Abha','SAU',112300), 3457(3192,'Ara´ar','SAU',108100), 3458(3193,'al-Qatif','SAU',98900), 3459(3194,'al-Hawiya','SAU',93900), 3460(3195,'Unayza','SAU',91100), 3461(3196,'Najran','SAU',91000), 3462(3197,'Pikine','SEN',855287), 3463(3198,'Dakar','SEN',785071), 3464(3199,'Thiès','SEN',248000), 3465(3200,'Kaolack','SEN',199000); 3466INSERT IGNORE INTO City VALUES 3467(3201,'Ziguinchor','SEN',192000), 3468(3202,'Rufisque','SEN',150000), 3469(3203,'Saint-Louis','SEN',132400), 3470(3204,'Mbour','SEN',109300), 3471(3205,'Diourbel','SEN',99400), 3472(3206,'Victoria','SYC',41000), 3473(3207,'Freetown','SLE',850000), 3474(3208,'Singapore','SGP',4017733), 3475(3209,'Bratislava','SVK',448292), 3476(3210,'Koice','SVK',241874), 3477(3211,'Preov','SVK',93977), 3478(3212,'Ljubljana','SVN',270986), 3479(3213,'Maribor','SVN',115532), 3480(3214,'Mogadishu','SOM',997000), 3481(3215,'Hargeysa','SOM',90000), 3482(3216,'Kismaayo','SOM',90000), 3483(3217,'Colombo','LKA',645000), 3484(3218,'Dehiwala','LKA',203000), 3485(3219,'Moratuwa','LKA',190000), 3486(3220,'Jaffna','LKA',149000), 3487(3221,'Kandy','LKA',140000), 3488(3222,'Sri Jayawardenepura Kotte','LKA',118000), 3489(3223,'Negombo','LKA',100000), 3490(3224,'Omdurman','SDN',1271403), 3491(3225,'Khartum','SDN',947483), 3492(3226,'Sharq al-Nil','SDN',700887), 3493(3227,'Port Sudan','SDN',308195), 3494(3228,'Kassala','SDN',234622), 3495(3229,'Obeid','SDN',229425), 3496(3230,'Nyala','SDN',227183), 3497(3231,'Wad Madani','SDN',211362), 3498(3232,'al-Qadarif','SDN',191164), 3499(3233,'Kusti','SDN',173599), 3500(3234,'al-Fashir','SDN',141884), 3501(3235,'Juba','SDN',114980), 3502(3236,'Helsinki [Helsingfors]','FIN',555474), 3503(3237,'Espoo','FIN',213271), 3504(3238,'Tampere','FIN',195468), 3505(3239,'Vantaa','FIN',178471), 3506(3240,'Turku [Åbo]','FIN',172561), 3507(3241,'Oulu','FIN',120753), 3508(3242,'Lahti','FIN',96921), 3509(3243,'Paramaribo','SUR',112000), 3510(3244,'Mbabane','SWZ',61000), 3511(3245,'Zürich','CHE',336800), 3512(3246,'Geneve','CHE',173500), 3513(3247,'Basel','CHE',166700), 3514(3248,'Bern','CHE',122700), 3515(3249,'Lausanne','CHE',114500), 3516(3250,'Damascus','SYR',1347000), 3517(3251,'Aleppo','SYR',1261983), 3518(3252,'Hims','SYR',507404), 3519(3253,'Hama','SYR',343361), 3520(3254,'Latakia','SYR',264563), 3521(3255,'al-Qamishliya','SYR',144286), 3522(3256,'Dayr al-Zawr','SYR',140459), 3523(3257,'Jaramana','SYR',138469), 3524(3258,'Duma','SYR',131158), 3525(3259,'al-Raqqa','SYR',108020), 3526(3260,'Idlib','SYR',91081), 3527(3261,'Dushanbe','TJK',524000), 3528(3262,'Khujand','TJK',161500), 3529(3263,'Taipei','TWN',2641312), 3530(3264,'Kaohsiung','TWN',1475505), 3531(3265,'Taichung','TWN',940589), 3532(3266,'Tainan','TWN',728060), 3533(3267,'Panchiao','TWN',523850), 3534(3268,'Chungho','TWN',392176), 3535(3269,'Keelung (Chilung)','TWN',385201), 3536(3270,'Sanchung','TWN',380084), 3537(3271,'Hsinchuang','TWN',365048), 3538(3272,'Hsinchu','TWN',361958), 3539(3273,'Chungli','TWN',318649), 3540(3274,'Fengshan','TWN',318562), 3541(3275,'Taoyuan','TWN',316438), 3542(3276,'Chiayi','TWN',265109), 3543(3277,'Hsintien','TWN',263603), 3544(3278,'Changhwa','TWN',227715), 3545(3279,'Yungho','TWN',227700), 3546(3280,'Tucheng','TWN',224897), 3547(3281,'Pingtung','TWN',214727), 3548(3282,'Yungkang','TWN',193005), 3549(3283,'Pingchen','TWN',188344), 3550(3284,'Tali','TWN',171940), 3551(3285,'Taiping','TWN',165524), 3552(3286,'Pate','TWN',161700), 3553(3287,'Fengyuan','TWN',161032), 3554(3288,'Luchou','TWN',160516), 3555(3289,'Hsichuh','TWN',154976), 3556(3290,'Shulin','TWN',151260), 3557(3291,'Yuanlin','TWN',126402), 3558(3292,'Yangmei','TWN',126323), 3559(3293,'Taliao','TWN',115897), 3560(3294,'Kueishan','TWN',112195), 3561(3295,'Tanshui','TWN',111882), 3562(3296,'Taitung','TWN',111039), 3563(3297,'Hualien','TWN',108407), 3564(3298,'Nantou','TWN',104723), 3565(3299,'Lungtan','TWN',103088), 3566(3300,'Touliu','TWN',98900), 3567(3301,'Tsaotun','TWN',96800), 3568(3302,'Kangshan','TWN',92200), 3569(3303,'Ilan','TWN',92000), 3570(3304,'Miaoli','TWN',90000), 3571(3305,'Dar es Salaam','TZA',1747000), 3572(3306,'Dodoma','TZA',189000), 3573(3307,'Mwanza','TZA',172300), 3574(3308,'Zanzibar','TZA',157634), 3575(3309,'Tanga','TZA',137400), 3576(3310,'Mbeya','TZA',130800), 3577(3311,'Morogoro','TZA',117800), 3578(3312,'Arusha','TZA',102500), 3579(3313,'Moshi','TZA',96800), 3580(3314,'Tabora','TZA',92800), 3581(3315,'København','DNK',495699), 3582(3316,'Århus','DNK',284846), 3583(3317,'Odense','DNK',183912), 3584(3318,'Aalborg','DNK',161161), 3585(3319,'Frederiksberg','DNK',90327), 3586(3320,'Bangkok','THA',6320174), 3587(3321,'Nonthaburi','THA',292100), 3588(3322,'Nakhon Ratchasima','THA',181400), 3589(3323,'Chiang Mai','THA',171100), 3590(3324,'Udon Thani','THA',158100), 3591(3325,'Hat Yai','THA',148632), 3592(3326,'Khon Kaen','THA',126500), 3593(3327,'Pak Kret','THA',126055), 3594(3328,'Nakhon Sawan','THA',123800), 3595(3329,'Ubon Ratchathani','THA',116300), 3596(3330,'Songkhla','THA',94900), 3597(3331,'Nakhon Pathom','THA',94100), 3598(3332,'Lomé','TGO',375000), 3599(3333,'Fakaofo','TKL',300), 3600(3334,'Nuku´alofa','TON',22400), 3601(3335,'Chaguanas','TTO',56601), 3602(3336,'Port-of-Spain','TTO',43396), 3603(3337,'N´Djaména','TCD',530965), 3604(3338,'Moundou','TCD',99500), 3605(3339,'Praha','CZE',1181126), 3606(3340,'Brno','CZE',381862), 3607(3341,'Ostrava','CZE',320041), 3608(3342,'Plzen','CZE',166759), 3609(3343,'Olomouc','CZE',102702), 3610(3344,'Liberec','CZE',99155), 3611(3345,'Ceské Budejovice','CZE',98186), 3612(3346,'Hradec Králové','CZE',98080), 3613(3347,'Ústí nad Labem','CZE',95491), 3614(3348,'Pardubice','CZE',91309), 3615(3349,'Tunis','TUN',690600), 3616(3350,'Sfax','TUN',257800), 3617(3351,'Ariana','TUN',197000), 3618(3352,'Ettadhamen','TUN',178600), 3619(3353,'Sousse','TUN',145900), 3620(3354,'Kairouan','TUN',113100), 3621(3355,'Biserta','TUN',108900), 3622(3356,'Gabès','TUN',106600), 3623(3357,'Istanbul','TUR',8787958), 3624(3358,'Ankara','TUR',3038159), 3625(3359,'Izmir','TUR',2130359), 3626(3360,'Adana','TUR',1131198), 3627(3361,'Bursa','TUR',1095842), 3628(3362,'Gaziantep','TUR',789056), 3629(3363,'Konya','TUR',628364), 3630(3364,'Mersin (Içel)','TUR',587212), 3631(3365,'Antalya','TUR',564914), 3632(3366,'Diyarbakir','TUR',479884), 3633(3367,'Kayseri','TUR',475657), 3634(3368,'Eskisehir','TUR',470781), 3635(3369,'Sanliurfa','TUR',405905), 3636(3370,'Samsun','TUR',339871), 3637(3371,'Malatya','TUR',330312), 3638(3372,'Gebze','TUR',264170), 3639(3373,'Denizli','TUR',253848), 3640(3374,'Sivas','TUR',246642), 3641(3375,'Erzurum','TUR',246535), 3642(3376,'Tarsus','TUR',246206), 3643(3377,'Kahramanmaras','TUR',245772), 3644(3378,'Elâzig','TUR',228815), 3645(3379,'Van','TUR',219319), 3646(3380,'Sultanbeyli','TUR',211068), 3647(3381,'Izmit (Kocaeli)','TUR',210068), 3648(3382,'Manisa','TUR',207148), 3649(3383,'Batman','TUR',203793), 3650(3384,'Balikesir','TUR',196382), 3651(3385,'Sakarya (Adapazari)','TUR',190641), 3652(3386,'Iskenderun','TUR',153022), 3653(3387,'Osmaniye','TUR',146003), 3654(3388,'Çorum','TUR',145495), 3655(3389,'Kütahya','TUR',144761), 3656(3390,'Hatay (Antakya)','TUR',143982), 3657(3391,'Kirikkale','TUR',142044), 3658(3392,'Adiyaman','TUR',141529), 3659(3393,'Trabzon','TUR',138234), 3660(3394,'Ordu','TUR',133642), 3661(3395,'Aydin','TUR',128651), 3662(3396,'Usak','TUR',128162), 3663(3397,'Edirne','TUR',123383), 3664(3398,'Çorlu','TUR',123300), 3665(3399,'Isparta','TUR',121911), 3666(3400,'Karabük','TUR',118285); 3667INSERT IGNORE INTO City VALUES 3668(3401,'Kilis','TUR',118245), 3669(3402,'Alanya','TUR',117300), 3670(3403,'Kiziltepe','TUR',112000), 3671(3404,'Zonguldak','TUR',111542), 3672(3405,'Siirt','TUR',107100), 3673(3406,'Viransehir','TUR',106400), 3674(3407,'Tekirdag','TUR',106077), 3675(3408,'Karaman','TUR',104200), 3676(3409,'Afyon','TUR',103984), 3677(3410,'Aksaray','TUR',102681), 3678(3411,'Ceyhan','TUR',102412), 3679(3412,'Erzincan','TUR',102304), 3680(3413,'Bismil','TUR',101400), 3681(3414,'Nazilli','TUR',99900), 3682(3415,'Tokat','TUR',99500), 3683(3416,'Kars','TUR',93000), 3684(3417,'Inegöl','TUR',90500), 3685(3418,'Bandirma','TUR',90200), 3686(3419,'Ashgabat','TKM',540600), 3687(3420,'Chärjew','TKM',189200), 3688(3421,'Dashhowuz','TKM',141800), 3689(3422,'Mary','TKM',101000), 3690(3423,'Cockburn Town','TCA',4800), 3691(3424,'Funafuti','TUV',4600), 3692(3425,'Kampala','UGA',890800), 3693(3426,'Kyiv','UKR',2624000), 3694(3427,'Harkova [Harkiv]','UKR',1500000), 3695(3428,'Dnipropetrovsk','UKR',1103000), 3696(3429,'Donetsk','UKR',1050000), 3697(3430,'Odesa','UKR',1011000), 3698(3431,'Zaporizzja','UKR',848000), 3699(3432,'Lviv','UKR',788000), 3700(3433,'Kryvyi Rig','UKR',703000), 3701(3434,'Mykolajiv','UKR',508000), 3702(3435,'Mariupol','UKR',490000), 3703(3436,'Lugansk','UKR',469000), 3704(3437,'Vinnytsja','UKR',391000), 3705(3438,'Makijivka','UKR',384000), 3706(3439,'Herson','UKR',353000), 3707(3440,'Sevastopol','UKR',348000), 3708(3441,'Simferopol','UKR',339000), 3709(3442,'Pultava [Poltava]','UKR',313000), 3710(3443,'Ternigiv','UKR',313000), 3711(3444,'Terkasy','UKR',309000), 3712(3445,'Gorlivka','UKR',299000), 3713(3446,'Zytomyr','UKR',297000), 3714(3447,'Sumy','UKR',294000), 3715(3448,'Dniprodzerzynsk','UKR',270000), 3716(3449,'Kirovograd','UKR',265000), 3717(3450,'Hmelnytskyi','UKR',262000), 3718(3451,'Ternivtsi','UKR',259000), 3719(3452,'Rivne','UKR',245000), 3720(3453,'Krementuk','UKR',239000), 3721(3454,'Ivano-Frankivsk','UKR',237000), 3722(3455,'Ternopil','UKR',236000), 3723(3456,'Lutsk','UKR',217000), 3724(3457,'Bila Tserkva','UKR',215000), 3725(3458,'Kramatorsk','UKR',186000), 3726(3459,'Melitopol','UKR',169000), 3727(3460,'Kert','UKR',162000), 3728(3461,'Nikopol','UKR',149000), 3729(3462,'Berdjansk','UKR',130000), 3730(3463,'Pavlograd','UKR',127000), 3731(3464,'Sjeverodonetsk','UKR',127000), 3732(3465,'Slovjansk','UKR',127000), 3733(3466,'Uzgorod','UKR',127000), 3734(3467,'Altevsk','UKR',119000), 3735(3468,'Lysytansk','UKR',116000), 3736(3469,'Jevpatorija','UKR',112000), 3737(3470,'Kamjanets-Podilskyi','UKR',109000), 3738(3471,'Jenakijeve','UKR',105000), 3739(3472,'Krasnyi Lut','UKR',101000), 3740(3473,'Stahanov','UKR',101000), 3741(3474,'Oleksandrija','UKR',99000), 3742(3475,'Konotop','UKR',96000), 3743(3476,'Kostjantynivka','UKR',95000), 3744(3477,'Berdytiv','UKR',90000), 3745(3478,'Izmajil','UKR',90000), 3746(3479,'ostka','UKR',90000), 3747(3480,'Uman','UKR',90000), 3748(3481,'Brovary','UKR',89000), 3749(3482,'Mukateve','UKR',89000), 3750(3483,'Budapest','HUN',1811552), 3751(3484,'Debrecen','HUN',203648), 3752(3485,'Miskolc','HUN',172357), 3753(3486,'Szeged','HUN',158158), 3754(3487,'Pécs','HUN',157332), 3755(3488,'Györ','HUN',127119), 3756(3489,'Nyiregyháza','HUN',112419), 3757(3490,'Kecskemét','HUN',105606), 3758(3491,'Székesfehérvár','HUN',105119), 3759(3492,'Montevideo','URY',1236000), 3760(3493,'Nouméa','NCL',76293), 3761(3494,'Auckland','NZL',381800), 3762(3495,'Christchurch','NZL',324200), 3763(3496,'Manukau','NZL',281800), 3764(3497,'North Shore','NZL',187700), 3765(3498,'Waitakere','NZL',170600), 3766(3499,'Wellington','NZL',166700), 3767(3500,'Dunedin','NZL',119600), 3768(3501,'Hamilton','NZL',117100), 3769(3502,'Lower Hutt','NZL',98100), 3770(3503,'Toskent','UZB',2117500), 3771(3504,'Namangan','UZB',370500), 3772(3505,'Samarkand','UZB',361800), 3773(3506,'Andijon','UZB',318600), 3774(3507,'Buhoro','UZB',237100), 3775(3508,'Karsi','UZB',194100), 3776(3509,'Nukus','UZB',194100), 3777(3510,'Kükon','UZB',190100), 3778(3511,'Fargona','UZB',180500), 3779(3512,'Circik','UZB',146400), 3780(3513,'Margilon','UZB',140800), 3781(3514,'Ürgenc','UZB',138900), 3782(3515,'Angren','UZB',128000), 3783(3516,'Cizah','UZB',124800), 3784(3517,'Navoi','UZB',116300), 3785(3518,'Olmalik','UZB',114900), 3786(3519,'Termiz','UZB',109500), 3787(3520,'Minsk','BLR',1674000), 3788(3521,'Gomel','BLR',475000), 3789(3522,'Mogiljov','BLR',356000), 3790(3523,'Vitebsk','BLR',340000), 3791(3524,'Grodno','BLR',302000), 3792(3525,'Brest','BLR',286000), 3793(3526,'Bobruisk','BLR',221000), 3794(3527,'Baranoviti','BLR',167000), 3795(3528,'Borisov','BLR',151000), 3796(3529,'Pinsk','BLR',130000), 3797(3530,'Ora','BLR',124000), 3798(3531,'Mozyr','BLR',110000), 3799(3532,'Novopolotsk','BLR',106000), 3800(3533,'Lida','BLR',101000), 3801(3534,'Soligorsk','BLR',101000), 3802(3535,'Molodetno','BLR',97000), 3803(3536,'Mata-Utu','WLF',1137), 3804(3537,'Port-Vila','VUT',33700), 3805(3538,'Città del Vaticano','VAT',455), 3806(3539,'Caracas','VEN',1975294), 3807(3540,'Maracaíbo','VEN',1304776), 3808(3541,'Barquisimeto','VEN',877239), 3809(3542,'Valencia','VEN',794246), 3810(3543,'Ciudad Guayana','VEN',663713), 3811(3544,'Petare','VEN',488868), 3812(3545,'Maracay','VEN',444443), 3813(3546,'Barcelona','VEN',322267), 3814(3547,'Maturín','VEN',319726), 3815(3548,'San Cristóbal','VEN',319373), 3816(3549,'Ciudad Bolívar','VEN',301107), 3817(3550,'Cumaná','VEN',293105), 3818(3551,'Mérida','VEN',224887), 3819(3552,'Cabimas','VEN',221329), 3820(3553,'Barinas','VEN',217831), 3821(3554,'Turmero','VEN',217499), 3822(3555,'Baruta','VEN',207290), 3823(3556,'Puerto Cabello','VEN',187722), 3824(3557,'Santa Ana de Coro','VEN',185766), 3825(3558,'Los Teques','VEN',178784), 3826(3559,'Punto Fijo','VEN',167215), 3827(3560,'Guarenas','VEN',165889), 3828(3561,'Acarigua','VEN',158954), 3829(3562,'Puerto La Cruz','VEN',155700), 3830(3563,'Ciudad Losada','VEN',134501), 3831(3564,'Guacara','VEN',131334), 3832(3565,'Valera','VEN',130281), 3833(3566,'Guanare','VEN',125621), 3834(3567,'Carúpano','VEN',119639), 3835(3568,'Catia La Mar','VEN',117012), 3836(3569,'El Tigre','VEN',116256), 3837(3570,'Guatire','VEN',109121), 3838(3571,'Calabozo','VEN',107146), 3839(3572,'Pozuelos','VEN',105690), 3840(3573,'Ciudad Ojeda','VEN',99354), 3841(3574,'Ocumare del Tuy','VEN',97168), 3842(3575,'Valle de la Pascua','VEN',95927), 3843(3576,'Araure','VEN',94269), 3844(3577,'San Fernando de Apure','VEN',93809), 3845(3578,'San Felipe','VEN',90940), 3846(3579,'El Limón','VEN',90000), 3847(3580,'Moscow','RUS',8389200), 3848(3581,'St Petersburg','RUS',4694000), 3849(3582,'Novosibirsk','RUS',1398800), 3850(3583,'Nizni Novgorod','RUS',1357000), 3851(3584,'Jekaterinburg','RUS',1266300), 3852(3585,'Samara','RUS',1156100), 3853(3586,'Omsk','RUS',1148900), 3854(3587,'Kazan','RUS',1101000), 3855(3588,'Ufa','RUS',1091200), 3856(3589,'Teljabinsk','RUS',1083200), 3857(3590,'Rostov-na-Donu','RUS',1012700), 3858(3591,'Perm','RUS',1009700), 3859(3592,'Volgograd','RUS',993400), 3860(3593,'Voronez','RUS',907700), 3861(3594,'Krasnojarsk','RUS',875500), 3862(3595,'Saratov','RUS',874000), 3863(3596,'Toljatti','RUS',722900), 3864(3597,'Uljanovsk','RUS',667400), 3865(3598,'Izevsk','RUS',652800), 3866(3599,'Krasnodar','RUS',639000), 3867(3600,'Jaroslavl','RUS',616700); 3868INSERT IGNORE INTO City VALUES 3869(3601,'Habarovsk','RUS',609400), 3870(3602,'Vladivostok','RUS',606200), 3871(3603,'Irkutsk','RUS',593700), 3872(3604,'Barnaul','RUS',580100), 3873(3605,'Novokuznetsk','RUS',561600), 3874(3606,'Penza','RUS',532200), 3875(3607,'Rjazan','RUS',529900), 3876(3608,'Orenburg','RUS',523600), 3877(3609,'Lipetsk','RUS',521000), 3878(3610,'Nabereznyje Telny','RUS',514700), 3879(3611,'Tula','RUS',506100), 3880(3612,'Tjumen','RUS',503400), 3881(3613,'Kemerovo','RUS',492700), 3882(3614,'Astrahan','RUS',486100), 3883(3615,'Tomsk','RUS',482100), 3884(3616,'Kirov','RUS',466200), 3885(3617,'Ivanovo','RUS',459200), 3886(3618,'Teboksary','RUS',459200), 3887(3619,'Brjansk','RUS',457400), 3888(3620,'Tver','RUS',454900), 3889(3621,'Kursk','RUS',443500), 3890(3622,'Magnitogorsk','RUS',427900), 3891(3623,'Kaliningrad','RUS',424400), 3892(3624,'Nizni Tagil','RUS',390900), 3893(3625,'Murmansk','RUS',376300), 3894(3626,'Ulan-Ude','RUS',370400), 3895(3627,'Kurgan','RUS',364700), 3896(3628,'Arkangeli','RUS',361800), 3897(3629,'Soti','RUS',358600), 3898(3630,'Smolensk','RUS',353400), 3899(3631,'Orjol','RUS',344500), 3900(3632,'Stavropol','RUS',343300), 3901(3633,'Belgorod','RUS',342000), 3902(3634,'Kaluga','RUS',339300), 3903(3635,'Vladimir','RUS',337100), 3904(3636,'Mahatkala','RUS',332800), 3905(3637,'Terepovets','RUS',324400), 3906(3638,'Saransk','RUS',314800), 3907(3639,'Tambov','RUS',312000), 3908(3640,'Vladikavkaz','RUS',310100), 3909(3641,'Tita','RUS',309900), 3910(3642,'Vologda','RUS',302500), 3911(3643,'Veliki Novgorod','RUS',299500), 3912(3644,'Komsomolsk-na-Amure','RUS',291600), 3913(3645,'Kostroma','RUS',288100), 3914(3646,'Volzski','RUS',286900), 3915(3647,'Taganrog','RUS',284400), 3916(3648,'Petroskoi','RUS',282100), 3917(3649,'Bratsk','RUS',277600), 3918(3650,'Dzerzinsk','RUS',277100), 3919(3651,'Surgut','RUS',274900), 3920(3652,'Orsk','RUS',273900), 3921(3653,'Sterlitamak','RUS',265200), 3922(3654,'Angarsk','RUS',264700), 3923(3655,'Jokar-Ola','RUS',249200), 3924(3656,'Rybinsk','RUS',239600), 3925(3657,'Prokopjevsk','RUS',237300), 3926(3658,'Niznevartovsk','RUS',233900), 3927(3659,'Naltik','RUS',233400), 3928(3660,'Syktyvkar','RUS',229700), 3929(3661,'Severodvinsk','RUS',229300), 3930(3662,'Bijsk','RUS',225000), 3931(3663,'Niznekamsk','RUS',223400), 3932(3664,'Blagovetensk','RUS',222000), 3933(3665,'ahty','RUS',221800), 3934(3666,'Staryi Oskol','RUS',213800), 3935(3667,'Zelenograd','RUS',207100), 3936(3668,'Balakovo','RUS',206000), 3937(3669,'Novorossijsk','RUS',203300), 3938(3670,'Pihkova','RUS',201500), 3939(3671,'Zlatoust','RUS',196900), 3940(3672,'Jakutsk','RUS',195400), 3941(3673,'Podolsk','RUS',194300), 3942(3674,'Petropavlovsk-Kamtatski','RUS',194100), 3943(3675,'Kamensk-Uralski','RUS',190600), 3944(3676,'Engels','RUS',189000), 3945(3677,'Syzran','RUS',186900), 3946(3678,'Grozny','RUS',186000), 3947(3679,'Novoterkassk','RUS',184400), 3948(3680,'Berezniki','RUS',181900), 3949(3681,'Juzno-Sahalinsk','RUS',179200), 3950(3682,'Volgodonsk','RUS',178200), 3951(3683,'Abakan','RUS',169200), 3952(3684,'Maikop','RUS',167300), 3953(3685,'Miass','RUS',166200), 3954(3686,'Armavir','RUS',164900), 3955(3687,'Ljubertsy','RUS',163900), 3956(3688,'Rubtsovsk','RUS',162600), 3957(3689,'Kovrov','RUS',159900), 3958(3690,'Nahodka','RUS',157700), 3959(3691,'Ussurijsk','RUS',157300), 3960(3692,'Salavat','RUS',156800), 3961(3693,'Mytiti','RUS',155700), 3962(3694,'Kolomna','RUS',150700), 3963(3695,'Elektrostal','RUS',147000), 3964(3696,'Murom','RUS',142400), 3965(3697,'Kolpino','RUS',141200), 3966(3698,'Norilsk','RUS',140800), 3967(3699,'Almetjevsk','RUS',140700), 3968(3700,'Novomoskovsk','RUS',138100), 3969(3701,'Dimitrovgrad','RUS',137000), 3970(3702,'Pervouralsk','RUS',136100), 3971(3703,'Himki','RUS',133700), 3972(3704,'Balaiha','RUS',132900), 3973(3705,'Nevinnomyssk','RUS',132600), 3974(3706,'Pjatigorsk','RUS',132500), 3975(3707,'Korolev','RUS',132400), 3976(3708,'Serpuhov','RUS',132000), 3977(3709,'Odintsovo','RUS',127400), 3978(3710,'Orehovo-Zujevo','RUS',124900), 3979(3711,'Kamyin','RUS',124600), 3980(3712,'Novoteboksarsk','RUS',123400), 3981(3713,'Terkessk','RUS',121700), 3982(3714,'Atinsk','RUS',121600), 3983(3715,'Magadan','RUS',121000), 3984(3716,'Miturinsk','RUS',120700), 3985(3717,'Kislovodsk','RUS',120400), 3986(3718,'Jelets','RUS',119400), 3987(3719,'Seversk','RUS',118600), 3988(3720,'Noginsk','RUS',117200), 3989(3721,'Velikije Luki','RUS',116300), 3990(3722,'Novokuibyevsk','RUS',116200), 3991(3723,'Neftekamsk','RUS',115700), 3992(3724,'Leninsk-Kuznetski','RUS',113800), 3993(3725,'Oktjabrski','RUS',111500), 3994(3726,'Sergijev Posad','RUS',111100), 3995(3727,'Arzamas','RUS',110700), 3996(3728,'Kiseljovsk','RUS',110000), 3997(3729,'Novotroitsk','RUS',109600), 3998(3730,'Obninsk','RUS',108300), 3999(3731,'Kansk','RUS',107400), 4000(3732,'Glazov','RUS',106300), 4001(3733,'Solikamsk','RUS',106000), 4002(3734,'Sarapul','RUS',105700), 4003(3735,'Ust-Ilimsk','RUS',105200), 4004(3736,'tolkovo','RUS',104900), 4005(3737,'Mezduretensk','RUS',104400), 4006(3738,'Usolje-Sibirskoje','RUS',103500), 4007(3739,'Elista','RUS',103300), 4008(3740,'Novoahtinsk','RUS',101900), 4009(3741,'Votkinsk','RUS',101700), 4010(3742,'Kyzyl','RUS',101100), 4011(3743,'Serov','RUS',100400), 4012(3744,'Zelenodolsk','RUS',100200), 4013(3745,'Zeleznodoroznyi','RUS',100100), 4014(3746,'Kinema','RUS',100000), 4015(3747,'Kuznetsk','RUS',98200), 4016(3748,'Uhta','RUS',98000), 4017(3749,'Jessentuki','RUS',97900), 4018(3750,'Tobolsk','RUS',97600), 4019(3751,'Neftejugansk','RUS',97400), 4020(3752,'Bataisk','RUS',97300), 4021(3753,'Nojabrsk','RUS',97300), 4022(3754,'Balaov','RUS',97100), 4023(3755,'Zeleznogorsk','RUS',96900), 4024(3756,'Zukovski','RUS',96500), 4025(3757,'Anzero-Sudzensk','RUS',96100), 4026(3758,'Bugulma','RUS',94100), 4027(3759,'Zeleznogorsk','RUS',94000), 4028(3760,'Novouralsk','RUS',93300), 4029(3761,'Pukin','RUS',92900), 4030(3762,'Vorkuta','RUS',92600), 4031(3763,'Derbent','RUS',92300), 4032(3764,'Kirovo-Tepetsk','RUS',91600), 4033(3765,'Krasnogorsk','RUS',91000), 4034(3766,'Klin','RUS',90000), 4035(3767,'Taikovski','RUS',90000), 4036(3768,'Novyi Urengoi','RUS',89800), 4037(3769,'Ho Chi Minh City','VNM',3980000), 4038(3770,'Hanoi','VNM',1410000), 4039(3771,'Haiphong','VNM',783133), 4040(3772,'Da Nang','VNM',382674), 4041(3773,'Biên Hoa','VNM',282095), 4042(3774,'Nha Trang','VNM',221331), 4043(3775,'Hue','VNM',219149), 4044(3776,'Can Tho','VNM',215587), 4045(3777,'Cam Pha','VNM',209086), 4046(3778,'Nam Dinh','VNM',171699), 4047(3779,'Quy Nhon','VNM',163385), 4048(3780,'Vung Tau','VNM',145145), 4049(3781,'Rach Gia','VNM',141132), 4050(3782,'Long Xuyen','VNM',132681), 4051(3783,'Thai Nguyen','VNM',127643), 4052(3784,'Hong Gai','VNM',127484), 4053(3785,'Phan Thiêt','VNM',114236), 4054(3786,'Cam Ranh','VNM',114041), 4055(3787,'Vinh','VNM',112455), 4056(3788,'My Tho','VNM',108404), 4057(3789,'Da Lat','VNM',106409), 4058(3790,'Buon Ma Thuot','VNM',97044), 4059(3791,'Tallinn','EST',403981), 4060(3792,'Tartu','EST',101246), 4061(3793,'New York','USA',8008278), 4062(3794,'Los Angeles','USA',3694820), 4063(3795,'Chicago','USA',2896016), 4064(3796,'Houston','USA',1953631), 4065(3797,'Philadelphia','USA',1517550), 4066(3798,'Phoenix','USA',1321045), 4067(3799,'San Diego','USA',1223400), 4068(3800,'Dallas','USA',1188580); 4069INSERT INTO City VALUES 4070(3801,'San Antonio','USA',1144646), 4071(3802,'Detroit','USA',951270), 4072(3803,'San Jose','USA',894943), 4073(3804,'Indianapolis','USA',791926), 4074(3805,'San Francisco','USA',776733), 4075(3806,'Jacksonville','USA',735167), 4076(3807,'Columbus','USA',711470), 4077(3808,'Austin','USA',656562), 4078(3809,'Baltimore','USA',651154), 4079(3810,'Memphis','USA',650100), 4080(3811,'Milwaukee','USA',596974), 4081(3812,'Boston','USA',589141), 4082(3813,'Washington','USA',572059), 4083(3814,'Nashville-Davidson','USA',569891), 4084(3815,'El Paso','USA',563662), 4085(3816,'Seattle','USA',563374), 4086(3817,'Denver','USA',554636), 4087(3818,'Charlotte','USA',540828), 4088(3819,'Fort Worth','USA',534694), 4089(3820,'Portland','USA',529121), 4090(3821,'Oklahoma City','USA',506132), 4091(3822,'Tucson','USA',486699), 4092(3823,'New Orleans','USA',484674), 4093(3824,'Las Vegas','USA',478434), 4094(3825,'Cleveland','USA',478403), 4095(3826,'Long Beach','USA',461522), 4096(3827,'Albuquerque','USA',448607), 4097(3828,'Kansas City','USA',441545), 4098(3829,'Fresno','USA',427652), 4099(3830,'Virginia Beach','USA',425257), 4100(3831,'Atlanta','USA',416474), 4101(3832,'Sacramento','USA',407018), 4102(3833,'Oakland','USA',399484), 4103(3834,'Mesa','USA',396375), 4104(3835,'Tulsa','USA',393049), 4105(3836,'Omaha','USA',390007), 4106(3837,'Minneapolis','USA',382618), 4107(3838,'Honolulu','USA',371657), 4108(3839,'Miami','USA',362470), 4109(3840,'Colorado Springs','USA',360890), 4110(3841,'Saint Louis','USA',348189), 4111(3842,'Wichita','USA',344284), 4112(3843,'Santa Ana','USA',337977), 4113(3844,'Pittsburgh','USA',334563), 4114(3845,'Arlington','USA',332969), 4115(3846,'Cincinnati','USA',331285), 4116(3847,'Anaheim','USA',328014), 4117(3848,'Toledo','USA',313619), 4118(3849,'Tampa','USA',303447), 4119(3850,'Buffalo','USA',292648), 4120(3851,'Saint Paul','USA',287151), 4121(3852,'Corpus Christi','USA',277454), 4122(3853,'Aurora','USA',276393), 4123(3854,'Raleigh','USA',276093), 4124(3855,'Newark','USA',273546), 4125(3856,'Lexington-Fayette','USA',260512), 4126(3857,'Anchorage','USA',260283), 4127(3858,'Louisville','USA',256231), 4128(3859,'Riverside','USA',255166), 4129(3860,'Saint Petersburg','USA',248232), 4130(3861,'Bakersfield','USA',247057), 4131(3862,'Stockton','USA',243771), 4132(3863,'Birmingham','USA',242820), 4133(3864,'Jersey City','USA',240055), 4134(3865,'Norfolk','USA',234403), 4135(3866,'Baton Rouge','USA',227818), 4136(3867,'Hialeah','USA',226419), 4137(3868,'Lincoln','USA',225581), 4138(3869,'Greensboro','USA',223891), 4139(3870,'Plano','USA',222030), 4140(3871,'Rochester','USA',219773), 4141(3872,'Glendale','USA',218812), 4142(3873,'Akron','USA',217074), 4143(3874,'Garland','USA',215768), 4144(3875,'Madison','USA',208054), 4145(3876,'Fort Wayne','USA',205727), 4146(3877,'Fremont','USA',203413), 4147(3878,'Scottsdale','USA',202705), 4148(3879,'Montgomery','USA',201568), 4149(3880,'Shreveport','USA',200145), 4150(3881,'Augusta-Richmond County','USA',199775), 4151(3882,'Lubbock','USA',199564), 4152(3883,'Chesapeake','USA',199184), 4153(3884,'Mobile','USA',198915), 4154(3885,'Des Moines','USA',198682), 4155(3886,'Grand Rapids','USA',197800), 4156(3887,'Richmond','USA',197790), 4157(3888,'Yonkers','USA',196086), 4158(3889,'Spokane','USA',195629), 4159(3890,'Glendale','USA',194973), 4160(3891,'Tacoma','USA',193556), 4161(3892,'Irving','USA',191615), 4162(3893,'Huntington Beach','USA',189594), 4163(3894,'Modesto','USA',188856), 4164(3895,'Durham','USA',187035), 4165(3896,'Columbus','USA',186291), 4166(3897,'Orlando','USA',185951), 4167(3898,'Boise City','USA',185787), 4168(3899,'Winston-Salem','USA',185776), 4169(3900,'San Bernardino','USA',185401), 4170(3901,'Jackson','USA',184256), 4171(3902,'Little Rock','USA',183133), 4172(3903,'Salt Lake City','USA',181743), 4173(3904,'Reno','USA',180480), 4174(3905,'Newport News','USA',180150), 4175(3906,'Chandler','USA',176581), 4176(3907,'Laredo','USA',176576), 4177(3908,'Henderson','USA',175381), 4178(3909,'Arlington','USA',174838), 4179(3910,'Knoxville','USA',173890), 4180(3911,'Amarillo','USA',173627), 4181(3912,'Providence','USA',173618), 4182(3913,'Chula Vista','USA',173556), 4183(3914,'Worcester','USA',172648), 4184(3915,'Oxnard','USA',170358), 4185(3916,'Dayton','USA',166179), 4186(3917,'Garden Grove','USA',165196), 4187(3918,'Oceanside','USA',161029), 4188(3919,'Tempe','USA',158625), 4189(3920,'Huntsville','USA',158216), 4190(3921,'Ontario','USA',158007), 4191(3922,'Chattanooga','USA',155554), 4192(3923,'Fort Lauderdale','USA',152397), 4193(3924,'Springfield','USA',152082), 4194(3925,'Springfield','USA',151580), 4195(3926,'Santa Clarita','USA',151088), 4196(3927,'Salinas','USA',151060), 4197(3928,'Tallahassee','USA',150624), 4198(3929,'Rockford','USA',150115), 4199(3930,'Pomona','USA',149473), 4200(3931,'Metairie','USA',149428), 4201(3932,'Paterson','USA',149222), 4202(3933,'Overland Park','USA',149080), 4203(3934,'Santa Rosa','USA',147595), 4204(3935,'Syracuse','USA',147306), 4205(3936,'Kansas City','USA',146866), 4206(3937,'Hampton','USA',146437), 4207(3938,'Lakewood','USA',144126), 4208(3939,'Vancouver','USA',143560), 4209(3940,'Irvine','USA',143072), 4210(3941,'Aurora','USA',142990), 4211(3942,'Moreno Valley','USA',142381), 4212(3943,'Pasadena','USA',141674), 4213(3944,'Hayward','USA',140030), 4214(3945,'Brownsville','USA',139722), 4215(3946,'Bridgeport','USA',139529), 4216(3947,'Hollywood','USA',139357), 4217(3948,'Warren','USA',138247), 4218(3949,'Torrance','USA',137946), 4219(3950,'Eugene','USA',137893), 4220(3951,'Pembroke Pines','USA',137427), 4221(3952,'Salem','USA',136924), 4222(3953,'Pasadena','USA',133936), 4223(3954,'Escondido','USA',133559), 4224(3955,'Sunnyvale','USA',131760), 4225(3956,'Savannah','USA',131510), 4226(3957,'Fontana','USA',128929), 4227(3958,'Orange','USA',128821), 4228(3959,'Naperville','USA',128358), 4229(3960,'Alexandria','USA',128283), 4230(3961,'Rancho Cucamonga','USA',127743), 4231(3962,'Grand Prairie','USA',127427), 4232(3963,'East Los Angeles','USA',126379), 4233(3964,'Fullerton','USA',126003), 4234(3965,'Corona','USA',124966), 4235(3966,'Flint','USA',124943), 4236(3967,'Paradise','USA',124682), 4237(3968,'Mesquite','USA',124523), 4238(3969,'Sterling Heights','USA',124471), 4239(3970,'Sioux Falls','USA',123975), 4240(3971,'New Haven','USA',123626), 4241(3972,'Topeka','USA',122377), 4242(3973,'Concord','USA',121780), 4243(3974,'Evansville','USA',121582), 4244(3975,'Hartford','USA',121578), 4245(3976,'Fayetteville','USA',121015), 4246(3977,'Cedar Rapids','USA',120758), 4247(3978,'Elizabeth','USA',120568), 4248(3979,'Lansing','USA',119128), 4249(3980,'Lancaster','USA',118718), 4250(3981,'Fort Collins','USA',118652), 4251(3982,'Coral Springs','USA',117549), 4252(3983,'Stamford','USA',117083), 4253(3984,'Thousand Oaks','USA',117005), 4254(3985,'Vallejo','USA',116760), 4255(3986,'Palmdale','USA',116670), 4256(3987,'Columbia','USA',116278), 4257(3988,'El Monte','USA',115965), 4258(3989,'Abilene','USA',115930), 4259(3990,'North Las Vegas','USA',115488), 4260(3991,'Ann Arbor','USA',114024), 4261(3992,'Beaumont','USA',113866), 4262(3993,'Waco','USA',113726), 4263(3994,'Macon','USA',113336), 4264(3995,'Independence','USA',113288), 4265(3996,'Peoria','USA',112936), 4266(3997,'Inglewood','USA',112580), 4267(3998,'Springfield','USA',111454), 4268(3999,'Simi Valley','USA',111351), 4269(4000,'Lafayette','USA',110257); 4270INSERT INTO City VALUES 4271(4001,'Gilbert','USA',109697), 4272(4002,'Carrollton','USA',109576), 4273(4003,'Bellevue','USA',109569), 4274(4004,'West Valley City','USA',108896), 4275(4005,'Clarksville','USA',108787), 4276(4006,'Costa Mesa','USA',108724), 4277(4007,'Peoria','USA',108364), 4278(4008,'South Bend','USA',107789), 4279(4009,'Downey','USA',107323), 4280(4010,'Waterbury','USA',107271), 4281(4011,'Manchester','USA',107006), 4282(4012,'Allentown','USA',106632), 4283(4013,'McAllen','USA',106414), 4284(4014,'Joliet','USA',106221), 4285(4015,'Lowell','USA',105167), 4286(4016,'Provo','USA',105166), 4287(4017,'West Covina','USA',105080), 4288(4018,'Wichita Falls','USA',104197), 4289(4019,'Erie','USA',103717), 4290(4020,'Daly City','USA',103621), 4291(4021,'Citrus Heights','USA',103455), 4292(4022,'Norwalk','USA',103298), 4293(4023,'Gary','USA',102746), 4294(4024,'Berkeley','USA',102743), 4295(4025,'Santa Clara','USA',102361), 4296(4026,'Green Bay','USA',102313), 4297(4027,'Cape Coral','USA',102286), 4298(4028,'Arvada','USA',102153), 4299(4029,'Pueblo','USA',102121), 4300(4030,'Sandy','USA',101853), 4301(4031,'Athens-Clarke County','USA',101489), 4302(4032,'Cambridge','USA',101355), 4303(4033,'Westminster','USA',100940), 4304(4034,'San Buenaventura','USA',100916), 4305(4035,'Portsmouth','USA',100565), 4306(4036,'Livonia','USA',100545), 4307(4037,'Burbank','USA',100316), 4308(4038,'Clearwater','USA',99936), 4309(4039,'Midland','USA',98293), 4310(4040,'Davenport','USA',98256), 4311(4041,'Mission Viejo','USA',98049), 4312(4042,'Miami Beach','USA',97855), 4313(4043,'Sunrise Manor','USA',95362), 4314(4044,'New Bedford','USA',94780), 4315(4045,'El Cajon','USA',94578), 4316(4046,'Norman','USA',94193), 4317(4047,'Richmond','USA',94100), 4318(4048,'Albany','USA',93994), 4319(4049,'Brockton','USA',93653), 4320(4050,'Roanoke','USA',93357), 4321(4051,'Billings','USA',92988), 4322(4052,'Compton','USA',92864), 4323(4053,'Gainesville','USA',92291), 4324(4054,'Fairfield','USA',92256), 4325(4055,'Arden-Arcade','USA',92040), 4326(4056,'San Mateo','USA',91799), 4327(4057,'Visalia','USA',91762), 4328(4058,'Boulder','USA',91238), 4329(4059,'Cary','USA',91213), 4330(4060,'Santa Monica','USA',91084), 4331(4061,'Fall River','USA',90555), 4332(4062,'Kenosha','USA',89447), 4333(4063,'Elgin','USA',89408), 4334(4064,'Odessa','USA',89293), 4335(4065,'Carson','USA',89089), 4336(4066,'Charleston','USA',89063), 4337(4067,'Charlotte Amalie','VIR',13000), 4338(4068,'Harare','ZWE',1410000), 4339(4069,'Bulawayo','ZWE',621742), 4340(4070,'Chitungwiza','ZWE',274912), 4341(4071,'Mount Darwin','ZWE',164362), 4342(4072,'Mutare','ZWE',131367), 4343(4073,'Gweru','ZWE',128037), 4344(4074,'Gaza','PSE',353632), 4345(4075,'Khan Yunis','PSE',123175), 4346(4076,'Hebron','PSE',119401), 4347(4077,'Jabaliya','PSE',113901), 4348(4078,'Nablus','PSE',100231), 4349(4079,'Rafah','PSE',92020); 4350 4351# Table CountryLanguage 4352 4353INSERT IGNORE INTO CountryLanguage VALUES 4354('AFG','Pashto',52.4), 4355('NLD','Dutch',95.6), 4356('ANT','Papiamento',86.2), 4357('ALB','Albaniana',97.9), 4358('DZA','Arabic',86.0), 4359('ASM','Samoan',90.6), 4360('AND','Spanish',44.6), 4361('AGO','Ovimbundu',37.2), 4362('AIA','English',0.0), 4363('ATG','Creole English',95.7), 4364('ARE','Arabic',42.0), 4365('ARG','Spanish',96.8), 4366('ARM','Armenian',93.4), 4367('ABW','Papiamento',76.7), 4368('AUS','English',81.2), 4369('AZE','Azerbaijani',89.0), 4370('BHS','Creole English',89.7), 4371('BHR','Arabic',67.7), 4372('BGD','Bengali',97.7), 4373('BRB','Bajan',95.1), 4374('BEL','Dutch',59.2), 4375('BLZ','English',50.8), 4376('BEN','Fon',39.8), 4377('BMU','English',100.0), 4378('BTN','Dzongkha',50.0), 4379('BOL','Spanish',87.7), 4380('BIH','Serbo-Croatian',99.2), 4381('BWA','Tswana',75.5), 4382('BRA','Portuguese',97.5), 4383('GBR','English',97.3), 4384('VGB','English',0.0), 4385('BRN','Malay',45.5), 4386('BGR','Bulgariana',83.2), 4387('BFA','Mossi',50.2), 4388('BDI','Kirundi',98.1), 4389('CYM','English',0.0), 4390('CHL','Spanish',89.7), 4391('COK','Maori',0.0), 4392('CRI','Spanish',97.5), 4393('DJI','Somali',43.9), 4394('DMA','Creole English',100.0), 4395('DOM','Spanish',98.0), 4396('ECU','Spanish',93.0), 4397('EGY','Arabic',98.8), 4398('SLV','Spanish',100.0), 4399('ERI','Tigrinja',49.1), 4400('ESP','Spanish',74.4), 4401('ZAF','Zulu',22.7), 4402('ETH','Oromo',31.0), 4403('FLK','English',0.0), 4404('FJI','Fijian',50.8), 4405('PHL','Pilipino',29.3), 4406('FRO','Faroese',100.0), 4407('GAB','Fang',35.8), 4408('GMB','Malinke',34.1), 4409('GEO','Georgiana',71.7), 4410('GHA','Akan',52.4), 4411('GIB','English',88.9), 4412('GRD','Creole English',100.0), 4413('GRL','Greenlandic',87.5), 4414('GLP','Creole French',95.0), 4415('GUM','English',37.5), 4416('GTM','Spanish',64.7), 4417('GIN','Ful',38.6), 4418('GNB','Crioulo',36.4), 4419('GUY','Creole English',96.4), 4420('HTI','Haiti Creole',100.0), 4421('HND','Spanish',97.2), 4422('HKG','Canton Chinese',88.7), 4423('SJM','Norwegian',0.0), 4424('IDN','Javanese',39.4), 4425('IND','Hindi',39.9), 4426('IRQ','Arabic',77.2), 4427('IRN','Persian',45.7), 4428('IRL','English',98.4), 4429('ISL','Icelandic',95.7), 4430('ISR','Hebrew',63.1), 4431('ITA','Italian',94.1), 4432('TMP','Sunda',0.0), 4433('AUT','German',92.0), 4434('JAM','Creole English',94.2), 4435('JPN','Japanese',99.1), 4436('YEM','Arabic',99.6), 4437('JOR','Arabic',97.9), 4438('CXR','Chinese',0.0), 4439('YUG','Serbo-Croatian',75.2), 4440('KHM','Khmer',88.6), 4441('CMR','Fang',19.7), 4442('CAN','English',60.4), 4443('CPV','Crioulo',100.0), 4444('KAZ','Kazakh',46.0), 4445('KEN','Kikuyu',20.9), 4446('CAF','Gbaya',23.8), 4447('CHN','Chinese',92.0), 4448('KGZ','Kirgiz',59.7), 4449('KIR','Kiribati',98.9), 4450('COL','Spanish',99.0), 4451('COM','Comorian',75.0), 4452('COG','Kongo',51.5), 4453('COD','Luba',18.0), 4454('CCK','Malay',0.0), 4455('PRK','Korean',99.9), 4456('KOR','Korean',99.9), 4457('GRC','Greek',98.5), 4458('HRV','Serbo-Croatian',95.9), 4459('CUB','Spanish',100.0), 4460('KWT','Arabic',78.1), 4461('CYP','Greek',74.1), 4462('LAO','Lao',67.2), 4463('LVA','Latvian',55.1), 4464('LSO','Sotho',85.0), 4465('LBN','Arabic',93.0), 4466('LBR','Kpelle',19.5), 4467('LBY','Arabic',96.0), 4468('LIE','German',89.0), 4469('LTU','Lithuanian',81.6), 4470('LUX','Luxembourgish',64.4), 4471('ESH','Arabic',100.0), 4472('MAC','Canton Chinese',85.6), 4473('MDG','Malagasy',98.9), 4474('MKD','Macedonian',66.5), 4475('MWI','Chichewa',58.3), 4476('MDV','Dhivehi',100.0), 4477('MYS','Malay',58.4), 4478('MLI','Bambara',31.8), 4479('MLT','Maltese',95.8), 4480('MAR','Arabic',65.0), 4481('MHL','Marshallese',96.8), 4482('MTQ','Creole French',96.6), 4483('MRT','Hassaniya',81.7), 4484('MUS','Creole French',70.6), 4485('MYT','Mahoré',41.9), 4486('MEX','Spanish',92.1), 4487('FSM','Trukese',41.6), 4488('MDA','Romanian',61.9), 4489('MCO','French',41.9), 4490('MNG','Mongolian',78.8), 4491('MSR','English',0.0), 4492('MOZ','Makua',27.8), 4493('MMR','Burmese',69.0), 4494('NAM','Ovambo',50.7), 4495('NRU','Nauru',57.5), 4496('NPL','Nepali',50.4), 4497('NIC','Spanish',97.6), 4498('NER','Hausa',53.1), 4499('NGA','Joruba',21.4), 4500('NIU','Niue',0.0), 4501('NFK','English',0.0), 4502('NOR','Norwegian',96.6), 4503('CIV','Akan',30.0), 4504('OMN','Arabic',76.7), 4505('PAK','Punjabi',48.2), 4506('PLW','Palau',82.2), 4507('PAN','Spanish',76.8), 4508('PNG','Papuan Languages',78.1), 4509('PRY','Spanish',55.1), 4510('PER','Spanish',79.8), 4511('PCN','Pitcairnese',0.0), 4512('MNP','Philippene Languages',34.1), 4513('PRT','Portuguese',99.0), 4514('PRI','Spanish',51.3), 4515('POL','Polish',97.6), 4516('GNQ','Fang',84.8), 4517('QAT','Arabic',40.7), 4518('FRA','French',93.6), 4519('GUF','Creole French',94.3), 4520('PYF','Tahitian',46.4), 4521('REU','Creole French',91.5), 4522('ROM','Romanian',90.7), 4523('RWA','Rwanda',100.0), 4524('SWE','Swedish',89.5), 4525('SHN','English',0.0), 4526('KNA','Creole English',100.0), 4527('LCA','Creole French',80.0), 4528('VCT','Creole English',99.1), 4529('SPM','French',0.0), 4530('DEU','German',91.3), 4531('SLB','Malenasian Languages',85.6), 4532('ZMB','Bemba',29.7), 4533('WSM','Samoan-English',52.0), 4534('SMR','Italian',100.0), 4535('STP','Crioulo',86.3), 4536('SAU','Arabic',95.0), 4537('SEN','Wolof',48.1), 4538('SYC','Seselwa',91.3), 4539('SLE','Mende',34.8), 4540('SGP','Chinese',77.1), 4541('SVK','Slovak',85.6), 4542('SVN','Slovene',87.9), 4543('SOM','Somali',98.3), 4544('LKA','Singali',60.3), 4545('SDN','Arabic',49.4), 4546('FIN','Finnish',92.7), 4547('SUR','Sranantonga',81.0), 4548('SWZ','Swazi',89.9), 4549('CHE','German',63.6), 4550('SYR','Arabic',90.0), 4551('TJK','Tadzhik',62.2), 4552('TWN','Min',66.7), 4553('TZA','Nyamwesi',21.1); 4554INSERT IGNORE INTO CountryLanguage VALUES 4555('DNK','Danish',93.5), 4556('THA','Thai',52.6), 4557('TGO','Ewe',23.2), 4558('TKL','Tokelau',0.0), 4559('TON','Tongan',98.3), 4560('TTO','English',93.5), 4561('TCD','Sara',27.7), 4562('CZE','Czech',81.2), 4563('TUN','Arabic',69.9), 4564('TUR','Turkish',87.6), 4565('TKM','Turkmenian',76.7), 4566('TCA','English',0.0), 4567('TUV','Tuvalu',92.5), 4568('UGA','Ganda',18.1), 4569('UKR','Ukrainian',64.7), 4570('HUN','Hungarian',98.5), 4571('URY','Spanish',95.7), 4572('NCL','Malenasian Languages',45.4), 4573('NZL','English',87.0), 4574('UZB','Uzbek',72.6), 4575('BLR','Belorussian',65.6), 4576('WLF','Wallis',0.0), 4577('VUT','Bislama',56.6), 4578('VAT','Italian',0.0), 4579('VEN','Spanish',96.9), 4580('RUS','Russian',86.6), 4581('VNM','Vietnamese',86.8), 4582('EST','Estonian',65.3), 4583('USA','English',86.2), 4584('VIR','English',81.7), 4585('UMI','English',0.0), 4586('ZWE','Shona',72.1), 4587('PSE','Arabic',95.9), 4588('AFG','Dari',32.1), 4589('NLD','Fries',3.7), 4590('ANT','English',7.8), 4591('ALB','Greek',1.8), 4592('DZA','Berberi',14.0), 4593('ASM','English',3.1), 4594('AND','Catalan',32.3), 4595('AGO','Mbundu',21.6), 4596('ATG','English',0.0), 4597('ARE','Hindi',0.0), 4598('ARG','Italian',1.7), 4599('ARM','Azerbaijani',2.6), 4600('ABW','English',9.5), 4601('AUS','Italian',2.2), 4602('AZE','Russian',3.0), 4603('BHS','Creole French',10.3), 4604('BHR','English',0.0), 4605('BGD','Chakma',0.4), 4606('BRB','English',0.0), 4607('BEL','French',32.6), 4608('BLZ','Spanish',31.6), 4609('BEN','Joruba',12.2), 4610('BTN','Nepali',34.8), 4611('BOL','Ketua',8.1), 4612('BWA','Shona',12.3), 4613('BRA','German',0.5), 4614('GBR','Kymri',0.9), 4615('BRN','Malay-English',28.8), 4616('BGR','Turkish',9.4), 4617('BFA','Ful',9.7), 4618('BDI','French',0.0), 4619('CHL','Araucan',9.6), 4620('COK','English',0.0), 4621('CRI','Creole English',2.0), 4622('DJI','Afar',34.8), 4623('DMA','Creole French',0.0), 4624('DOM','Creole French',2.0), 4625('ECU','Ketua',7.0), 4626('EGY','Sinaberberi',0.0), 4627('SLV','Nahua',0.0), 4628('ERI','Tigre',31.7), 4629('ESP','Catalan',16.9), 4630('ZAF','Xhosa',17.7), 4631('ETH','Amhara',30.0), 4632('FJI','Hindi',43.7), 4633('PHL','Cebuano',23.3), 4634('FRO','Danish',0.0), 4635('GAB','Punu-sira-nzebi',17.1), 4636('GMB','Ful',16.2), 4637('GEO','Russian',8.8), 4638('GHA','Mossi',15.8), 4639('GIB','Arabic',7.4), 4640('GRL','Danish',12.5), 4641('GLP','French',0.0), 4642('GUM','Chamorro',29.6), 4643('GTM','Quiché',10.1), 4644('GIN','Malinke',23.2), 4645('GNB','Ful',16.6), 4646('GUY','Caribbean',2.2), 4647('HTI','French',0.0), 4648('HND','Garifuna',1.3), 4649('HKG','English',2.2), 4650('SJM','Russian',0.0), 4651('IDN','Sunda',15.8), 4652('IND','Bengali',8.2), 4653('IRQ','Kurdish',19.0), 4654('IRN','Azerbaijani',16.8), 4655('IRL','Irish',1.6), 4656('ISL','English',0.0), 4657('ISR','Arabic',18.0), 4658('ITA','Sardinian',2.7), 4659('TMP','Portuguese',0.0), 4660('AUT','Serbo-Croatian',2.2), 4661('JAM','Hindi',1.9), 4662('JPN','Korean',0.5), 4663('YEM','Soqutri',0.0), 4664('JOR','Circassian',1.0), 4665('CXR','English',0.0), 4666('YUG','Albaniana',16.5), 4667('KHM','Vietnamese',5.5), 4668('CMR','Bamileke-bamum',18.6), 4669('CAN','French',23.4), 4670('CPV','Portuguese',0.0), 4671('KAZ','Russian',34.7), 4672('KEN','Luhya',13.8), 4673('CAF','Banda',23.5), 4674('CHN','Zhuang',1.4), 4675('KGZ','Russian',16.2), 4676('KIR','Tuvalu',0.5), 4677('COL','Chibcha',0.4), 4678('COM','Comorian-French',12.9), 4679('COG','Teke',17.3), 4680('COD','Kongo',16.0), 4681('CCK','English',0.0), 4682('PRK','Chinese',0.1), 4683('KOR','Chinese',0.1), 4684('GRC','Turkish',0.9), 4685('HRV','Slovene',0.0), 4686('KWT','English',0.0), 4687('CYP','Turkish',22.4), 4688('LAO','Mon-khmer',16.5), 4689('LVA','Russian',32.5), 4690('LSO','Zulu',15.0), 4691('LBN','Armenian',5.9), 4692('LBR','Bassa',13.7), 4693('LBY','Berberi',1.0), 4694('LIE','Italian',2.5), 4695('LTU','Russian',8.1), 4696('LUX','Portuguese',13.0), 4697('MAC','Portuguese',2.3), 4698('MDG','French',0.0), 4699('MKD','Albaniana',22.9), 4700('MWI','Lomwe',18.4), 4701('MDV','English',0.0), 4702('MYS','Chinese',9.0), 4703('MLI','Ful',13.9), 4704('MLT','English',2.1), 4705('MAR','Berberi',33.0), 4706('MHL','English',0.0), 4707('MTQ','French',0.0), 4708('MRT','Wolof',6.6), 4709('MUS','Bhojpuri',21.1), 4710('MYT','French',20.3), 4711('MEX','Náhuatl',1.8), 4712('FSM','Pohnpei',23.8), 4713('MDA','Russian',23.2), 4714('MCO','Monegasque',16.1), 4715('MNG','Kazakh',5.9), 4716('MOZ','Tsonga',12.4), 4717('MMR','Shan',8.5), 4718('NAM','Nama',12.4), 4719('NRU','Kiribati',17.9), 4720('NPL','Maithili',11.9), 4721('NIC','Miskito',1.6), 4722('NER','Songhai-zerma',21.2), 4723('NGA','Hausa',21.1), 4724('NIU','English',0.0), 4725('NOR','English',0.5), 4726('CIV','Gur',11.7), 4727('OMN','Balochi',0.0), 4728('PAK','Pashto',13.1), 4729('PLW','Philippene Languages',9.2), 4730('PAN','Creole English',14.0), 4731('PNG','Malenasian Languages',20.0), 4732('PRY','Guaraní',40.1), 4733('PER','Ketua',16.4), 4734('MNP','Chamorro',30.0), 4735('PRI','English',47.4), 4736('POL','German',1.3), 4737('GNQ','Bubi',8.7), 4738('QAT','Urdu',0.0), 4739('FRA','Arabic',2.5), 4740('GUF','Indian Languages',1.9), 4741('PYF','French',40.8), 4742('REU','Chinese',2.8), 4743('ROM','Hungarian',7.2), 4744('RWA','French',0.0), 4745('SWE','Finnish',2.4), 4746('KNA','English',0.0), 4747('LCA','English',20.0), 4748('VCT','English',0.0), 4749('DEU','Turkish',2.6), 4750('SLB','Papuan Languages',8.6), 4751('ZMB','Tongan',11.0), 4752('WSM','Samoan',47.5), 4753('STP','French',0.7), 4754('SEN','Ful',21.7); 4755INSERT IGNORE INTO CountryLanguage VALUES 4756('SYC','English',3.8), 4757('SLE','Temne',31.8), 4758('SGP','Malay',14.1), 4759('SVK','Hungarian',10.5), 4760('SVN','Serbo-Croatian',7.9), 4761('SOM','Arabic',0.0), 4762('LKA','Tamil',19.6), 4763('SDN','Dinka',11.5), 4764('FIN','Swedish',5.7), 4765('SUR','Hindi',0.0), 4766('SWZ','Zulu',2.0), 4767('CHE','French',19.2), 4768('SYR','Kurdish',9.0), 4769('TJK','Uzbek',23.2), 4770('TWN','Mandarin Chinese',20.1), 4771('TZA','Swahili',8.8), 4772('DNK','Turkish',0.8), 4773('THA','Lao',26.9), 4774('TGO','Kabyé',13.8), 4775('TKL','English',0.0), 4776('TON','English',0.0), 4777('TTO','Hindi',3.4), 4778('TCD','Arabic',12.3), 4779('CZE','Moravian',12.9), 4780('TUN','Arabic-French',26.3), 4781('TUR','Kurdish',10.6), 4782('TKM','Uzbek',9.2), 4783('TUV','Kiribati',7.5), 4784('UGA','Nkole',10.7), 4785('UKR','Russian',32.9), 4786('HUN','Romani',0.5), 4787('NCL','French',34.3), 4788('NZL','Maori',4.3), 4789('UZB','Russian',10.9), 4790('BLR','Russian',32.0), 4791('WLF','Futuna',0.0), 4792('VUT','English',28.3), 4793('VEN','Goajiro',0.4), 4794('RUS','Tatar',3.2), 4795('VNM','Tho',1.8), 4796('EST','Russian',27.8), 4797('USA','Spanish',7.5), 4798('VIR','Spanish',13.3), 4799('ZWE','Ndebele',16.2), 4800('PSE','Hebrew',4.1), 4801('AFG','Uzbek',8.8), 4802('NLD','Arabic',0.9), 4803('ANT','Dutch',0.0), 4804('ALB','Macedonian',0.1), 4805('ASM','Tongan',3.1), 4806('AND','Portuguese',10.8), 4807('AGO','Kongo',13.2), 4808('ARG','Indian Languages',0.3), 4809('ABW','Spanish',7.4), 4810('AUS','Greek',1.6), 4811('AZE','Lezgian',2.3), 4812('BGD','Marma',0.2), 4813('BEL','Italian',2.4), 4814('BLZ','Maya Languages',9.6), 4815('BEN','Adja',11.1), 4816('BTN','Asami',15.2), 4817('BOL','Aimará',3.2), 4818('BWA','San',3.5), 4819('BRA','Italian',0.4), 4820('GBR','Gaeli',0.1), 4821('BRN','Chinese',9.3), 4822('BGR','Romani',3.7), 4823('BFA','Gurma',5.7), 4824('BDI','Swahili',0.0), 4825('CHL','Aimará',0.5), 4826('CRI','Chibcha',0.3), 4827('DJI','Arabic',10.6), 4828('ERI','Afar',4.3), 4829('ESP','Galecian',6.4), 4830('ZAF','Afrikaans',14.3), 4831('ETH','Tigrinja',7.2), 4832('PHL','Ilocano',9.3), 4833('GAB','Mpongwe',14.6), 4834('GMB','Wolof',12.6), 4835('GEO','Armenian',6.8), 4836('GHA','Ewe',11.9), 4837('GUM','Philippene Languages',19.7), 4838('GTM','Cakchiquel',8.9), 4839('GIN','Susu',11.0), 4840('GNB','Balante',14.6), 4841('GUY','Arawakan',1.4), 4842('HND','Creole English',0.2), 4843('HKG','Fukien',1.9), 4844('IDN','Malay',12.1), 4845('IND','Telugu',7.8), 4846('IRQ','Azerbaijani',1.7), 4847('IRN','Kurdish',9.1), 4848('ISR','Russian',8.9), 4849('ITA','Friuli',1.2), 4850('AUT','Turkish',1.5), 4851('JPN','Chinese',0.2), 4852('JOR','Armenian',1.0), 4853('YUG','Hungarian',3.4), 4854('KHM','Chinese',3.1), 4855('CMR','Duala',10.9), 4856('CAN','Chinese',2.5), 4857('KAZ','Ukrainian',5.0), 4858('KEN','Luo',12.8), 4859('CAF','Mandjia',14.8), 4860('CHN','Mantu',0.9), 4861('KGZ','Uzbek',14.1), 4862('COL','Creole English',0.1), 4863('COM','Comorian-madagassi',5.5), 4864('COG','Mboshi',11.4), 4865('COD','Mongo',13.5), 4866('LAO','Thai',7.8), 4867('LVA','Belorussian',4.1), 4868('LSO','English',0.0), 4869('LBN','French',0.0), 4870('LBR','Grebo',8.9), 4871('LIE','Turkish',2.5), 4872('LTU','Polish',7.0), 4873('LUX','Italian',4.6), 4874('MAC','Mandarin Chinese',1.2), 4875('MKD','Turkish',4.0), 4876('MWI','Yao',13.2), 4877('MYS','Tamil',3.9), 4878('MLI','Senufo and Minianka',12.0), 4879('MRT','Tukulor',5.4), 4880('MUS','French',3.4), 4881('MYT','Malagasy',16.1), 4882('MEX','Yucatec',1.1), 4883('FSM','Mortlock',7.6), 4884('MDA','Ukrainian',8.6), 4885('MCO','Italian',16.1), 4886('MNG','Dorbet',2.7), 4887('MOZ','Sena',9.4), 4888('MMR','Karen',6.2), 4889('NAM','Kavango',9.7), 4890('NRU','Chinese',8.5), 4891('NPL','Bhojpuri',7.5), 4892('NIC','Creole English',0.5), 4893('NER','Tamashek',10.4), 4894('NGA','Ibo',18.1), 4895('NOR','Danish',0.4), 4896('CIV','Malinke',11.4), 4897('PAK','Sindhi',11.8), 4898('PLW','English',3.2), 4899('PAN','Guaymí',5.3), 4900('PRY','Portuguese',3.2), 4901('PER','Aimará',2.3), 4902('MNP','Chinese',7.1), 4903('POL','Ukrainian',0.6), 4904('FRA','Portuguese',1.2), 4905('PYF','Chinese',2.9), 4906('REU','Comorian',2.8), 4907('ROM','Romani',0.7), 4908('SWE','Southern Slavic Languages',1.3), 4909('DEU','Southern Slavic Languages',1.4), 4910('SLB','Polynesian Languages',3.8), 4911('ZMB','Nyanja',7.8), 4912('WSM','English',0.6), 4913('SEN','Serer',12.5), 4914('SYC','French',1.3), 4915('SLE','Limba',8.3), 4916('SGP','Tamil',7.4), 4917('SVK','Romani',1.7), 4918('SVN','Hungarian',0.5), 4919('LKA','Mixed Languages',19.6), 4920('SDN','Nubian Languages',8.1), 4921('FIN','Russian',0.4), 4922('CHE','Italian',7.7), 4923('TJK','Russian',9.7), 4924('TWN','Hakka',11.0), 4925('TZA','Hehet',6.9), 4926('DNK','Arabic',0.7), 4927('THA','Chinese',12.1), 4928('TGO','Watyi',10.3), 4929('TTO','Creole English',2.9), 4930('TCD','Mayo-kebbi',11.5), 4931('CZE','Slovak',3.1), 4932('TUN','Arabic-French-English',3.2), 4933('TUR','Arabic',1.4), 4934('TKM','Russian',6.7), 4935('TUV','English',0.0), 4936('UGA','Kiga',8.3), 4937('UKR','Romanian',0.7), 4938('HUN','German',0.4), 4939('NCL','Polynesian Languages',11.6), 4940('UZB','Tadzhik',4.4), 4941('BLR','Ukrainian',1.3), 4942('VUT','French',14.2), 4943('VEN','Warrau',0.1), 4944('RUS','Ukrainian',1.3), 4945('VNM','Thai',1.6), 4946('EST','Ukrainian',2.8), 4947('USA','French',0.7), 4948('VIR','French',2.5), 4949('ZWE','English',2.2), 4950('AFG','Turkmenian',1.9), 4951('NLD','Turkish',0.8), 4952('AND','French',6.2), 4953('AGO','Luimbe-nganguela',5.4), 4954('ABW','Dutch',5.3), 4955('AUS','Canton Chinese',1.1); 4956INSERT IGNORE INTO CountryLanguage VALUES 4957('AZE','Armenian',2.0), 4958('BGD','Garo',0.1), 4959('BEL','Arabic',1.6), 4960('BLZ','Garifuna',6.8), 4961('BEN','Aizo',8.7), 4962('BOL','Guaraní',0.1), 4963('BWA','Khoekhoe',2.5), 4964('BRA','Japanese',0.4), 4965('BRN','English',3.1), 4966('BGR','Macedonian',2.6), 4967('BFA','Busansi',3.5), 4968('CHL','Rapa nui',0.2), 4969('CRI','Chinese',0.2), 4970('ERI','Hadareb',3.8), 4971('ESP','Basque',1.6), 4972('ZAF','Northsotho',9.1), 4973('ETH','Gurage',4.7), 4974('PHL','Hiligaynon',9.1), 4975('GAB','Mbete',13.8), 4976('GMB','Diola',9.2), 4977('GEO','Azerbaijani',5.5), 4978('GHA','Ga-adangme',7.8), 4979('GUM','Korean',3.3), 4980('GTM','Kekchí',4.9), 4981('GIN','Kissi',6.0), 4982('GNB','Portuguese',8.1), 4983('HND','Miskito',0.2), 4984('HKG','Hakka',1.6), 4985('IDN','Madura',4.3), 4986('IND','Marathi',7.4), 4987('IRQ','Assyrian',0.8), 4988('IRN','Gilaki',5.3), 4989('ITA','French',0.5), 4990('AUT','Hungarian',0.4), 4991('JPN','English',0.1), 4992('YUG','Romani',1.4), 4993('KHM','Tam',2.4), 4994('CMR','Ful',9.6), 4995('CAN','Italian',1.7), 4996('KAZ','German',3.1), 4997('KEN','Kamba',11.2), 4998('CAF','Ngbaka',7.5), 4999('CHN','Hui',0.8), 5000('KGZ','Ukrainian',1.7), 5001('COL','Arawakan',0.1), 5002('COM','Comorian-Arabic',1.6), 5003('COG','Mbete',4.8), 5004('COD','Rwanda',10.3), 5005('LAO','Lao-Soung',5.2), 5006('LVA','Ukrainian',2.9), 5007('LBR','Gio',7.9), 5008('LTU','Belorussian',1.4), 5009('LUX','French',4.2), 5010('MAC','English',0.5), 5011('MKD','Romani',2.3), 5012('MWI','Ngoni',6.7), 5013('MYS','Iban',2.8), 5014('MLI','Soninke',8.7), 5015('MRT','Soninke',2.7), 5016('MUS','Hindi',1.2), 5017('MEX','Zapotec',0.6), 5018('FSM','Kosrean',7.3), 5019('MDA','Gagauzi',3.2), 5020('MCO','English',6.5), 5021('MNG','Bajad',1.9), 5022('MOZ','Lomwe',7.8), 5023('MMR','Rakhine',4.5), 5024('NAM','Afrikaans',9.5), 5025('NRU','Tuvalu',8.5), 5026('NPL','Tharu',5.4), 5027('NIC','Sumo',0.2), 5028('NER','Ful',9.7), 5029('NGA','Ful',11.3), 5030('NOR','Swedish',0.3), 5031('CIV','Kru',10.5), 5032('PAK','Saraiki',9.8), 5033('PLW','Chinese',1.6), 5034('PAN','Cuna',2.0), 5035('PRY','German',0.9), 5036('MNP','Korean',6.5), 5037('POL','Belorussian',0.5), 5038('FRA','Italian',0.4), 5039('REU','Malagasy',1.4), 5040('ROM','German',0.4), 5041('SWE','Arabic',0.8), 5042('DEU','Italian',0.7), 5043('ZMB','Lozi',6.4), 5044('SEN','Diola',5.0), 5045('SLE','Kono-vai',5.1), 5046('SVK','Czech and Moravian',1.1), 5047('SDN','Beja',6.4), 5048('FIN','Estonian',0.2), 5049('CHE','Romansh',0.6), 5050('TWN','Ami',0.6), 5051('TZA','Haya',5.9), 5052('DNK','German',0.5), 5053('THA','Malay',3.6), 5054('TGO','Kotokoli',5.7), 5055('TCD','Kanem-bornu',9.0), 5056('CZE','Polish',0.6), 5057('TKM','Kazakh',2.0), 5058('UGA','Soga',8.2), 5059('UKR','Bulgariana',0.3), 5060('HUN','Serbo-Croatian',0.2), 5061('UZB','Kazakh',3.8), 5062('BLR','Polish',0.6), 5063('RUS','Chuvash',0.9), 5064('VNM','Muong',1.5), 5065('EST','Belorussian',1.4), 5066('USA','German',0.7), 5067('ZWE','Nyanja',2.2), 5068('AFG','Balochi',0.9), 5069('AGO','Nyaneka-nkhumbi',5.4), 5070('AUS','Arabic',1.0), 5071('BGD','Khasi',0.1), 5072('BEL','German',1.0), 5073('BEN','Bariba',8.7), 5074('BWA','Ndebele',1.3), 5075('BRA','Indian Languages',0.2), 5076('BFA','Dagara',3.1), 5077('ERI','Bilin',3.0), 5078('ZAF','English',8.5), 5079('ETH','Somali',4.1), 5080('PHL','Bicol',5.7), 5081('GMB','Soninke',7.6), 5082('GEO','Osseetti',2.4), 5083('GHA','Gurma',3.3), 5084('GUM','Japanese',2.0), 5085('GTM','Mam',2.7), 5086('GIN','Kpelle',4.6), 5087('GNB','Malinke',6.9), 5088('HKG','Chiu chau',1.4), 5089('IDN','Minangkabau',2.4), 5090('IND','Tamil',6.3), 5091('IRQ','Persian',0.8), 5092('IRN','Luri',4.3), 5093('ITA','German',0.5), 5094('AUT','Slovene',0.4), 5095('JPN','Philippene Languages',0.1), 5096('YUG','Slovak',0.7), 5097('CMR','Tikar',7.4), 5098('CAN','German',1.6), 5099('KAZ','Uzbek',2.3), 5100('KEN','Kalenjin',10.8), 5101('CAF','Sara',6.4), 5102('CHN','Miao',0.7), 5103('KGZ','Tatar',1.3), 5104('COL','Caribbean',0.1), 5105('COM','Comorian-Swahili',0.5), 5106('COG','Punu',2.9), 5107('COD','Zande',6.1), 5108('LVA','Polish',2.1), 5109('LBR','Kru',7.2), 5110('LTU','Ukrainian',1.1), 5111('LUX','German',2.3), 5112('MKD','Serbo-Croatian',2.0), 5113('MYS','English',1.6), 5114('MLI','Tamashek',7.3), 5115('MRT','Ful',1.2), 5116('MUS','Tamil',0.8), 5117('MEX','Mixtec',0.6), 5118('FSM','Yap',5.8), 5119('MDA','Bulgariana',1.6), 5120('MNG','Buryat',1.7), 5121('MOZ','Shona',6.5), 5122('MMR','Mon',2.4), 5123('NAM','Herero',8.0), 5124('NRU','English',7.5), 5125('NPL','Tamang',4.9), 5126('NER','Kanuri',4.4), 5127('NGA','Ibibio',5.6), 5128('NOR','Saame',0.0), 5129('CIV','[South]Mande',7.7), 5130('PAK','Urdu',7.6), 5131('PAN','Embera',0.6), 5132('MNP','English',4.8), 5133('FRA','Spanish',0.4), 5134('REU','Tamil',0.0), 5135('ROM','Ukrainian',0.3), 5136('SWE','Spanish',0.6), 5137('DEU','Greek',0.4), 5138('ZMB','Chewa',5.7), 5139('SEN','Malinke',3.8), 5140('SLE','Bullom-sherbro',3.8), 5141('SVK','Ukrainian and Russian',0.6), 5142('SDN','Nuer',4.9), 5143('FIN','Saame',0.0), 5144('TWN','Atayal',0.4), 5145('TZA','Makonde',5.9), 5146('DNK','English',0.3), 5147('THA','Khmer',1.3), 5148('TGO','Ane',5.7), 5149('TCD','Ouaddai',8.7), 5150('CZE','German',0.5), 5151('UGA','Teso',6.0), 5152('UKR','Hungarian',0.3), 5153('HUN','Romanian',0.1), 5154('UZB','Karakalpak',2.0), 5155('RUS','Bashkir',0.7), 5156('VNM','Chinese',1.4); 5157INSERT INTO CountryLanguage VALUES 5158('EST','Finnish',0.7), 5159('USA','Italian',0.6), 5160('AGO','Chokwe',4.2), 5161('AUS','Vietnamese',0.8), 5162('BGD','Santhali',0.1), 5163('BEL','Turkish',0.9), 5164('BEN','Somba',6.7), 5165('BFA','Dyula',2.6), 5166('ERI','Saho',3.0), 5167('ZAF','Tswana',8.1), 5168('ETH','Sidamo',3.2), 5169('PHL','Waray-waray',3.8), 5170('GEO','Abhyasi',1.7), 5171('GHA','Joruba',1.3), 5172('GIN','Yalunka',2.9), 5173('GNB','Mandyako',4.9), 5174('IDN','Batakki',2.2), 5175('IND','Urdu',5.1), 5176('IRN','Mazandarani',3.6), 5177('ITA','Albaniana',0.2), 5178('AUT','Polish',0.2), 5179('JPN','Ainu',0.0), 5180('YUG','Macedonian',0.5), 5181('CMR','Mandara',5.7), 5182('CAN','Polish',0.7), 5183('KAZ','Tatar',2.0), 5184('KEN','Gusii',6.1), 5185('CAF','Mbum',6.4), 5186('CHN','Uighur',0.6), 5187('KGZ','Kazakh',0.8), 5188('COG','Sango',2.6), 5189('COD','Ngala and Bangi',5.8), 5190('LVA','Lithuanian',1.2), 5191('LBR','Mano',7.2), 5192('MYS','Dusun',1.1), 5193('MLI','Songhai',6.9), 5194('MRT','Zenaga',1.2), 5195('MUS','Marathi',0.7), 5196('MEX','Otomí',0.4), 5197('FSM','Wolea',3.7), 5198('MNG','Dariganga',1.4), 5199('MOZ','Tswa',6.0), 5200('MMR','Chin',2.2), 5201('NAM','Caprivi',4.7), 5202('NPL','Newari',3.7), 5203('NGA','Kanuri',4.1), 5204('PAK','Balochi',3.0), 5205('PAN','Arabic',0.6), 5206('MNP','Carolinian',4.8), 5207('FRA','Turkish',0.4), 5208('ROM','Serbo-Croatian',0.1), 5209('SWE','Norwegian',0.5), 5210('DEU','Polish',0.3), 5211('ZMB','Nsenga',4.3), 5212('SEN','Soninke',1.3), 5213('SLE','Ful',3.8), 5214('SDN','Zande',2.7), 5215('TWN','Paiwan',0.3), 5216('TZA','Nyakusa',5.4), 5217('DNK','Swedish',0.3), 5218('THA','Kuy',1.1), 5219('TGO','Moba',5.4), 5220('TCD','Hadjarai',6.7), 5221('CZE','Silesiana',0.4), 5222('UGA','Lango',5.9), 5223('UKR','Belorussian',0.3), 5224('HUN','Slovak',0.1), 5225('UZB','Tatar',1.8), 5226('RUS','Chechen',0.6), 5227('VNM','Khmer',1.4), 5228('USA','Chinese',0.6), 5229('AGO','Luvale',3.6), 5230('AUS','Serbo-Croatian',0.6), 5231('BGD','Tripuri',0.1), 5232('BEN','Ful',5.6), 5233('ZAF','Southsotho',7.6), 5234('ETH','Walaita',2.8), 5235('PHL','Pampango',3.0), 5236('GIN','Loma',2.3), 5237('IDN','Bugi',2.2), 5238('IND','Gujarati',4.8), 5239('IRN','Balochi',2.3), 5240('ITA','Slovene',0.2), 5241('AUT','Czech',0.2), 5242('CMR','Maka',4.9), 5243('CAN','Spanish',0.7), 5244('KEN','Meru',5.5), 5245('CHN','Yi',0.6), 5246('KGZ','Tadzhik',0.8), 5247('COD','Rundi',3.8), 5248('LBR','Loma',5.8), 5249('MOZ','Chuabo',5.7), 5250('MMR','Kachin',1.4), 5251('NAM','San',1.9), 5252('NPL','Hindi',3.0), 5253('NGA','Edo',3.3), 5254('PAK','Hindko',2.4), 5255('SLE','Kuranko',3.4), 5256('SDN','Bari',2.5), 5257('TZA','Chaga and Pare',4.9), 5258('DNK','Norwegian',0.3), 5259('TGO','Naudemba',4.1), 5260('TCD','Tandjile',6.5), 5261('CZE','Romani',0.3), 5262('UGA','Lugbara',4.7), 5263('UKR','Polish',0.1), 5264('RUS','Mordva',0.5), 5265('VNM','Nung',1.1), 5266('USA','Tagalog',0.4), 5267('AGO','Ambo',2.4), 5268('AUS','German',0.6), 5269('ZAF','Tsonga',4.3), 5270('PHL','Pangasinan',1.8), 5271('IDN','Banja',1.8), 5272('IND','Kannada',3.9), 5273('IRN','Arabic',2.2), 5274('ITA','Romani',0.2), 5275('AUT','Romanian',0.2), 5276('CMR','Masana',3.9), 5277('CAN','Portuguese',0.7), 5278('KEN','Nyika',4.8), 5279('CHN','Tujia',0.5), 5280('COD','Teke',2.7), 5281('LBR','Malinke',5.1), 5282('MOZ','Ronga',3.7), 5283('MMR','Kayah',0.4), 5284('NAM','German',0.9), 5285('NGA','Tiv',2.3), 5286('PAK','Brahui',1.2), 5287('SLE','Yalunka',3.4), 5288('SDN','Fur',2.1), 5289('TZA','Luguru',4.9), 5290('TGO','Gurma',3.4), 5291('TCD','Gorane',6.2), 5292('CZE','Hungarian',0.2), 5293('UGA','Gisu',4.5), 5294('RUS','Kazakh',0.4), 5295('VNM','Miao',0.9), 5296('USA','Polish',0.3), 5297('AGO','Luchazi',2.4), 5298('ZAF','Swazi',2.5), 5299('PHL','Maguindanao',1.4), 5300('IDN','Bali',1.7), 5301('IND','Malajalam',3.6), 5302('IRN','Bakhtyari',1.7), 5303('CAN','Punjabi',0.7), 5304('KEN','Masai',1.6), 5305('CHN','Mongolian',0.4), 5306('COD','Boa',2.3), 5307('MOZ','Marendje',3.5), 5308('NGA','Ijo',1.8), 5309('SDN','Chilluk',1.7), 5310('TZA','Shambala',4.3), 5311('UGA','Acholi',4.4), 5312('RUS','Avarian',0.4), 5313('VNM','Man',0.7), 5314('USA','Korean',0.3), 5315('ZAF','Venda',2.2), 5316('PHL','Maranao',1.3), 5317('IND','Orija',3.3), 5318('IRN','Turkmenian',1.6), 5319('CAN','Ukrainian',0.6), 5320('KEN','Turkana',1.4), 5321('CHN','Tibetan',0.4), 5322('COD','Chokwe',1.8), 5323('MOZ','Nyanja',3.3), 5324('NGA','Bura',1.6), 5325('SDN','Lotuko',1.5), 5326('TZA','Gogo',3.9), 5327('UGA','Rwanda',3.2), 5328('RUS','Mari',0.4), 5329('USA','Vietnamese',0.2), 5330('ZAF','Ndebele',1.5), 5331('IND','Punjabi',2.8), 5332('CAN','Dutch',0.5), 5333('CHN','Puyi',0.2), 5334('TZA','Ha',3.5), 5335('RUS','Udmur',0.3), 5336('USA','Japanese',0.2), 5337('IND','Asami',1.5), 5338('CAN','Eskimo Languages',0.1), 5339('CHN','Dong',0.2), 5340('RUS','Belorussian',0.3), 5341('USA','Portuguese',0.2); 5342 5343ANALYZE TABLE Country, City, CountryLanguage; 5344