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 d’Ivoire',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,'Priština','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,'Urumtši [Ü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,'Košice','SVK',241874),
3477(3211,'Prešov','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,'Tšernigiv','UKR',313000),
3711(3444,'Tšerkasy','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,'Tšernivtsi','UKR',259000),
3719(3452,'Rivne','UKR',245000),
3720(3453,'Krementšuk','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,'Altševsk','UKR',119000),
3735(3468,'Lysytšansk','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,'Berdytšiv','UKR',90000),
3745(3478,'Izmajil','UKR',90000),
3746(3479,'Šostka','UKR',90000),
3747(3480,'Uman','UKR',90000),
3748(3481,'Brovary','UKR',89000),
3749(3482,'Mukatševe','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,'Baranovitši','BLR',167000),
3795(3528,'Borisov','BLR',151000),
3796(3529,'Pinsk','BLR',130000),
3797(3530,'Orša','BLR',124000),
3798(3531,'Mozyr','BLR',110000),
3799(3532,'Novopolotsk','BLR',106000),
3800(3533,'Lida','BLR',101000),
3801(3534,'Soligorsk','BLR',101000),
3802(3535,'Molodetšno','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,'Tšeljabinsk','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 Tšelny','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,'Tšeboksary','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,'Sotši','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,'Mahatškala','RUS',332800),
3905(3637,'Tšerepovets','RUS',324400),
3906(3638,'Saransk','RUS',314800),
3907(3639,'Tambov','RUS',312000),
3908(3640,'Vladikavkaz','RUS',310100),
3909(3641,'Tšita','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,'Joškar-Ola','RUS',249200),
3924(3656,'Rybinsk','RUS',239600),
3925(3657,'Prokopjevsk','RUS',237300),
3926(3658,'Niznevartovsk','RUS',233900),
3927(3659,'Naltšik','RUS',233400),
3928(3660,'Syktyvkar','RUS',229700),
3929(3661,'Severodvinsk','RUS',229300),
3930(3662,'Bijsk','RUS',225000),
3931(3663,'Niznekamsk','RUS',223400),
3932(3664,'Blagoveštšensk','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-Kamtšatski','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,'Novotšerkassk','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,'Mytištši','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,'Balašiha','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,'Kamyšin','RUS',124600),
3980(3712,'Novotšeboksarsk','RUS',123400),
3981(3713,'Tšerkessk','RUS',121700),
3982(3714,'Atšinsk','RUS',121600),
3983(3715,'Magadan','RUS',121000),
3984(3716,'Mitšurinsk','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,'Novokuibyševsk','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,'Štšolkovo','RUS',104900),
4005(3737,'Mezduretšensk','RUS',104400),
4006(3738,'Usolje-Sibirskoje','RUS',103500),
4007(3739,'Elista','RUS',103300),
4008(3740,'Novošahtinsk','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,'Kinešma','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,'Balašov','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,'Puškin','RUS',92900),
4030(3762,'Vorkuta','RUS',92600),
4031(3763,'Derbent','RUS',92300),
4032(3764,'Kirovo-Tšepetsk','RUS',91600),
4033(3765,'Krasnogorsk','RUS',91000),
4034(3766,'Klin','RUS',90000),
4035(3767,'Tšaikovski','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','Ketšua',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','Ketšua',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','Ketšua',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','Mantšu',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','Tšam',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