range_world_1.sql

/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 80029
 Source Host           : localhost:3306
 Source Schema         : world

 Target Server Type    : MySQL
 Target Server Version : 80029
 File Encoding         : 65001

 Date: 16/08/2022 15:00:33
*/

/*!40000 DROP DATABASE IF EXISTS `world`*/;

CREATE DATABASE `world` DEFAULT CHARACTER SET utf8mb4;

USE `world`;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for city_5
-- ----------------------------
DROP TABLE IF EXISTS `city_5`;
CREATE TABLE `city_5` (
                          `id` bigint NOT NULL DEFAULT '0',
                          `name` char(35) NOT NULL DEFAULT '',
                          `country_code` char(3) NOT NULL DEFAULT '',
                          `district` char(20) NOT NULL DEFAULT '',
                          `population` int NOT NULL DEFAULT '0',
                          PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of city_5
-- ----------------------------
BEGIN;
INSERT INTO `city_5` VALUES (2500,'Témara','MAR','Rabat-Salé-Zammour-Z',126303);
INSERT INTO `city_5` VALUES (2501,'El Jadida','MAR','Doukkala-Abda',119083);
INSERT INTO `city_5` VALUES (2502,'Nador','MAR','Oriental',112450);
INSERT INTO `city_5` VALUES (2503,'Ksar el Kebir','MAR','Tanger-Tétouan',107065);
INSERT INTO `city_5` VALUES (2504,'Settat','MAR','Chaouia-Ouardigha',96200);
INSERT INTO `city_5` VALUES (2505,'Taza','MAR','Taza-Al Hoceima-Taou',92700);
INSERT INTO `city_5` VALUES (2506,'El Araich','MAR','Tanger-Tétouan',90400);
INSERT INTO `city_5` VALUES (2507,'Dalap-Uliga-Darrit','MHL','Majuro',28000);
INSERT INTO `city_5` VALUES (2508,'Fort-de-France','MTQ','Fort-de-France',94050);
INSERT INTO `city_5` VALUES (2509,'Nouakchott','MRT','Nouakchott',667300);
INSERT INTO `city_5` VALUES (2510,'Nouâdhibou','MRT','Dakhlet Nouâdhibou',97600);
INSERT INTO `city_5` VALUES (2511,'Port-Louis','MUS','Port-Louis',138200);
INSERT INTO `city_5` VALUES (2512,'Beau Bassin-Rose Hill','MUS','Plaines Wilhelms',100616);
INSERT INTO `city_5` VALUES (2513,'Vacoas-Phoenix','MUS','Plaines Wilhelms',98464);
INSERT INTO `city_5` VALUES (2514,'Mamoutzou','MYT','Mamoutzou',12000);
INSERT INTO `city_5` VALUES (2515,'Ciudad de México','MEX','Distrito Federal',8591309);
INSERT INTO `city_5` VALUES (2516,'Guadalajara','MEX','Jalisco',1647720);
INSERT INTO `city_5` VALUES (2517,'Ecatepec de Morelos','MEX','México',1620303);
INSERT INTO `city_5` VALUES (2518,'Puebla','MEX','Puebla',1346176);
INSERT INTO `city_5` VALUES (2519,'Nezahualcóyotl','MEX','México',1224924);
INSERT INTO `city_5` VALUES (2520,'Juárez','MEX','Chihuahua',1217818);
INSERT INTO `city_5` VALUES (2521,'Tijuana','MEX','Baja California',1212232);
INSERT INTO `city_5` VALUES (2522,'León','MEX','Guanajuato',1133576);
INSERT INTO `city_5` VALUES (2523,'Monterrey','MEX','Nuevo León',1108499);
INSERT INTO `city_5` VALUES (2524,'Zapopan','MEX','Jalisco',1002239);
INSERT INTO `city_5` VALUES (2525,'Naucalpan de Juárez','MEX','México',857511);
INSERT INTO `city_5` VALUES (2526,'Mexicali','MEX','Baja California',764902);
INSERT INTO `city_5` VALUES (2527,'Culiacán','MEX','Sinaloa',744859);
INSERT INTO `city_5` VALUES (2528,'Acapulco de Juárez','MEX','Guerrero',721011);
INSERT INTO `city_5` VALUES (2529,'Tlalnepantla de Baz','MEX','México',720755);
INSERT INTO `city_5` VALUES (2530,'Mérida','MEX','Yucatán',703324);
INSERT INTO `city_5` VALUES (2531,'Chihuahua','MEX','Chihuahua',670208);
INSERT INTO `city_5` VALUES (2532,'San Luis Potosí','MEX','San Luis Potosí',669353);
INSERT INTO `city_5` VALUES (2533,'Guadalupe','MEX','Nuevo León',668780);
INSERT INTO `city_5` VALUES (2534,'Toluca','MEX','México',665617);
INSERT INTO `city_5` VALUES (2535,'Aguascalientes','MEX','Aguascalientes',643360);
INSERT INTO `city_5` VALUES (2536,'Querétaro','MEX','Querétaro de Arteaga',639839);
INSERT INTO `city_5` VALUES (2537,'Morelia','MEX','Michoacán de Ocampo',619958);
INSERT INTO `city_5` VALUES (2538,'Hermosillo','MEX','Sonora',608697);
INSERT INTO `city_5` VALUES (2539,'Saltillo','MEX','Coahuila de Zaragoza',577352);
INSERT INTO `city_5` VALUES (2540,'Torreón','MEX','Coahuila de Zaragoza',529093);
INSERT INTO `city_5` VALUES (2541,'Centro (Villahermosa)','MEX','Tabasco',519873);
INSERT INTO `city_5` VALUES (2542,'San Nicolás de los Garza','MEX','Nuevo León',495540);
INSERT INTO `city_5` VALUES (2543,'Durango','MEX','Durango',490524);
INSERT INTO `city_5` VALUES (2544,'Chimalhuacán','MEX','México',490245);
INSERT INTO `city_5` VALUES (2545,'Tlaquepaque','MEX','Jalisco',475472);
INSERT INTO `city_5` VALUES (2546,'Atizapán de Zaragoza','MEX','México',467262);
INSERT INTO `city_5` VALUES (2547,'Veracruz','MEX','Veracruz',457119);
INSERT INTO `city_5` VALUES (2548,'Cuautitlán Izcalli','MEX','México',452976);
INSERT INTO `city_5` VALUES (2549,'Irapuato','MEX','Guanajuato',440039);
INSERT INTO `city_5` VALUES (2550,'Tuxtla Gutiérrez','MEX','Chiapas',433544);
INSERT INTO `city_5` VALUES (2551,'Tultitlán','MEX','México',432411);
INSERT INTO `city_5` VALUES (2552,'Reynosa','MEX','Tamaulipas',419776);
INSERT INTO `city_5` VALUES (2553,'Benito Juárez','MEX','Quintana Roo',419276);
INSERT INTO `city_5` VALUES (2554,'Matamoros','MEX','Tamaulipas',416428);
INSERT INTO `city_5` VALUES (2555,'Xalapa','MEX','Veracruz',390058);
INSERT INTO `city_5` VALUES (2556,'Celaya','MEX','Guanajuato',382140);
INSERT INTO `city_5` VALUES (2557,'Mazatlán','MEX','Sinaloa',380265);
INSERT INTO `city_5` VALUES (2558,'Ensenada','MEX','Baja California',369573);
INSERT INTO `city_5` VALUES (2559,'Ahome','MEX','Sinaloa',358663);
INSERT INTO `city_5` VALUES (2560,'Cajeme','MEX','Sonora',355679);
INSERT INTO `city_5` VALUES (2561,'Cuernavaca','MEX','Morelos',337966);
INSERT INTO `city_5` VALUES (2562,'Tonalá','MEX','Jalisco',336109);
INSERT INTO `city_5` VALUES (2563,'Valle de Chalco Solidaridad','MEX','México',323113);
INSERT INTO `city_5` VALUES (2564,'Nuevo Laredo','MEX','Tamaulipas',310277);
INSERT INTO `city_5` VALUES (2565,'Tepic','MEX','Nayarit',305025);
INSERT INTO `city_5` VALUES (2566,'Tampico','MEX','Tamaulipas',294789);
INSERT INTO `city_5` VALUES (2567,'Ixtapaluca','MEX','México',293160);
INSERT INTO `city_5` VALUES (2568,'Apodaca','MEX','Nuevo León',282941);
INSERT INTO `city_5` VALUES (2569,'Guasave','MEX','Sinaloa',277201);
INSERT INTO `city_5` VALUES (2570,'Gómez Palacio','MEX','Durango',272806);
INSERT INTO `city_5` VALUES (2571,'Tapachula','MEX','Chiapas',271141);
INSERT INTO `city_5` VALUES (2572,'Nicolás Romero','MEX','México',269393);
INSERT INTO `city_5` VALUES (2573,'Coatzacoalcos','MEX','Veracruz',267037);
INSERT INTO `city_5` VALUES (2574,'Uruapan','MEX','Michoacán de Ocampo',265211);
INSERT INTO `city_5` VALUES (2575,'Victoria','MEX','Tamaulipas',262686);
INSERT INTO `city_5` VALUES (2576,'Oaxaca de Juárez','MEX','Oaxaca',256848);
INSERT INTO `city_5` VALUES (2577,'Coacalco de Berriozábal','MEX','México',252270);
INSERT INTO `city_5` VALUES (2578,'Pachuca de Soto','MEX','Hidalgo',244688);
INSERT INTO `city_5` VALUES (2579,'General Escobedo','MEX','Nuevo León',232961);
INSERT INTO `city_5` VALUES (2580,'Salamanca','MEX','Guanajuato',226864);
INSERT INTO `city_5` VALUES (2581,'Santa Catarina','MEX','Nuevo León',226573);
INSERT INTO `city_5` VALUES (2582,'Tehuacán','MEX','Puebla',225943);
INSERT INTO `city_5` VALUES (2583,'Chalco','MEX','México',222201);
INSERT INTO `city_5` VALUES (2584,'Cárdenas','MEX','Tabasco',216903);
INSERT INTO `city_5` VALUES (2585,'Campeche','MEX','Campeche',216735);
INSERT INTO `city_5` VALUES (2586,'La Paz','MEX','México',213045);
INSERT INTO `city_5` VALUES (2587,'Othón P. Blanco (Chetumal)','MEX','Quintana Roo',208014);
INSERT INTO `city_5` VALUES (2588,'Texcoco','MEX','México',203681);
INSERT INTO `city_5` VALUES (2589,'La Paz','MEX','Baja California Sur',196708);
INSERT INTO `city_5` VALUES (2590,'Metepec','MEX','México',194265);
INSERT INTO `city_5` VALUES (2591,'Monclova','MEX','Coahuila de Zaragoza',193657);
INSERT INTO `city_5` VALUES (2592,'Huixquilucan','MEX','México',193156);
INSERT INTO `city_5` VALUES (2593,'Chilpancingo de los Bravo','MEX','Guerrero',192509);
INSERT INTO `city_5` VALUES (2594,'Puerto Vallarta','MEX','Jalisco',183741);
INSERT INTO `city_5` VALUES (2595,'Fresnillo','MEX','Zacatecas',182744);
INSERT INTO `city_5` VALUES (2596,'Ciudad Madero','MEX','Tamaulipas',182012);
INSERT INTO `city_5` VALUES (2597,'Soledad de Graciano Sánchez','MEX','San Luis Potosí',179956);
INSERT INTO `city_5` VALUES (2598,'San Juan del Río','MEX','Querétaro',179300);
INSERT INTO `city_5` VALUES (2599,'San Felipe del Progreso','MEX','México',177330);
INSERT INTO `city_5` VALUES (2600,'Córdoba','MEX','Veracruz',176952);
INSERT INTO `city_5` VALUES (2601,'Tecámac','MEX','México',172410);
INSERT INTO `city_5` VALUES (2602,'Ocosingo','MEX','Chiapas',171495);
INSERT INTO `city_5` VALUES (2603,'Carmen','MEX','Campeche',171367);
INSERT INTO `city_5` VALUES (2604,'Lázaro Cárdenas','MEX','Michoacán de Ocampo',170878);
INSERT INTO `city_5` VALUES (2605,'Jiutepec','MEX','Morelos',170428);
INSERT INTO `city_5` VALUES (2606,'Papantla','MEX','Veracruz',170123);
INSERT INTO `city_5` VALUES (2607,'Comalcalco','MEX','Tabasco',164640);
INSERT INTO `city_5` VALUES (2608,'Zamora','MEX','Michoacán de Ocampo',161191);
INSERT INTO `city_5` VALUES (2609,'Nogales','MEX','Sonora',159103);
INSERT INTO `city_5` VALUES (2610,'Huimanguillo','MEX','Tabasco',158335);
INSERT INTO `city_5` VALUES (2611,'Cuautla','MEX','Morelos',153132);
INSERT INTO `city_5` VALUES (2612,'Minatitlán','MEX','Veracruz',152983);
INSERT INTO `city_5` VALUES (2613,'Poza Rica de Hidalgo','MEX','Veracruz',152678);
INSERT INTO `city_5` VALUES (2614,'Ciudad Valles','MEX','San Luis Potosí',146411);
INSERT INTO `city_5` VALUES (2615,'Navolato','MEX','Sinaloa',145396);
INSERT INTO `city_5` VALUES (2616,'San Luis Río Colorado','MEX','Sonora',145276);
INSERT INTO `city_5` VALUES (2617,'Pénjamo','MEX','Guanajuato',143927);
INSERT INTO `city_5` VALUES (2618,'San Andrés Tuxtla','MEX','Veracruz',142251);
INSERT INTO `city_5` VALUES (2619,'Guanajuato','MEX','Guanajuato',141215);
INSERT INTO `city_5` VALUES (2620,'Navojoa','MEX','Sonora',140495);
INSERT INTO `city_5` VALUES (2621,'Zitácuaro','MEX','Michoacán de Ocampo',137970);
INSERT INTO `city_5` VALUES (2622,'Boca del Río','MEX','Veracruz-Llave',135721);
INSERT INTO `city_5` VALUES (2623,'Allende','MEX','Guanajuato',134645);
INSERT INTO `city_5` VALUES (2624,'Silao','MEX','Guanajuato',134037);
INSERT INTO `city_5` VALUES (2625,'Macuspana','MEX','Tabasco',133795);
INSERT INTO `city_5` VALUES (2626,'San Juan Bautista Tuxtepec','MEX','Oaxaca',133675);
INSERT INTO `city_5` VALUES (2627,'San Cristóbal de las Casas','MEX','Chiapas',132317);
INSERT INTO `city_5` VALUES (2628,'Valle de Santiago','MEX','Guanajuato',130557);
INSERT INTO `city_5` VALUES (2629,'Guaymas','MEX','Sonora',130108);
INSERT INTO `city_5` VALUES (2630,'Colima','MEX','Colima',129454);
INSERT INTO `city_5` VALUES (2631,'Dolores Hidalgo','MEX','Guanajuato',128675);
INSERT INTO `city_5` VALUES (2632,'Lagos de Moreno','MEX','Jalisco',127949);
INSERT INTO `city_5` VALUES (2633,'Piedras Negras','MEX','Coahuila de Zaragoza',127898);
INSERT INTO `city_5` VALUES (2634,'Altamira','MEX','Tamaulipas',127490);
INSERT INTO `city_5` VALUES (2635,'Túxpam','MEX','Veracruz',126475);
INSERT INTO `city_5` VALUES (2636,'San Pedro Garza García','MEX','Nuevo León',126147);
INSERT INTO `city_5` VALUES (2637,'Cuauhtémoc','MEX','Chihuahua',124279);
INSERT INTO `city_5` VALUES (2638,'Manzanillo','MEX','Colima',124014);
INSERT INTO `city_5` VALUES (2639,'Iguala de la Independencia','MEX','Guerrero',123883);
INSERT INTO `city_5` VALUES (2640,'Zacatecas','MEX','Zacatecas',123700);
INSERT INTO `city_5` VALUES (2641,'Tlajomulco de Zúñiga','MEX','Jalisco',123220);
INSERT INTO `city_5` VALUES (2642,'Tulancingo de Bravo','MEX','Hidalgo',121946);
INSERT INTO `city_5` VALUES (2643,'Zinacantepec','MEX','México',121715);
INSERT INTO `city_5` VALUES (2644,'San Martín Texmelucan','MEX','Puebla',121093);
INSERT INTO `city_5` VALUES (2645,'Tepatitlán de Morelos','MEX','Jalisco',118948);
INSERT INTO `city_5` VALUES (2646,'Martínez de la Torre','MEX','Veracruz',118815);
INSERT INTO `city_5` VALUES (2647,'Orizaba','MEX','Veracruz',118488);
INSERT INTO `city_5` VALUES (2648,'Apatzingán','MEX','Michoacán de Ocampo',117849);
INSERT INTO `city_5` VALUES (2649,'Atlixco','MEX','Puebla',117019);
INSERT INTO `city_5` VALUES (2650,'Delicias','MEX','Chihuahua',116132);
INSERT INTO `city_5` VALUES (2651,'Ixtlahuaca','MEX','México',115548);
INSERT INTO `city_5` VALUES (2652,'El Mante','MEX','Tamaulipas',112453);
INSERT INTO `city_5` VALUES (2653,'Lerdo','MEX','Durango',112272);
INSERT INTO `city_5` VALUES (2654,'Almoloya de Juárez','MEX','México',110550);
INSERT INTO `city_5` VALUES (2655,'Acámbaro','MEX','Guanajuato',110487);
INSERT INTO `city_5` VALUES (2656,'Acuña','MEX','Coahuila de Zaragoza',110388);
INSERT INTO `city_5` VALUES (2657,'Guadalupe','MEX','Zacatecas',108881);
INSERT INTO `city_5` VALUES (2658,'Huejutla de Reyes','MEX','Hidalgo',108017);
INSERT INTO `city_5` VALUES (2659,'Hidalgo','MEX','Michoacán de Ocampo',106198);
INSERT INTO `city_5` VALUES (2660,'Los Cabos','MEX','Baja California Sur',105199);
INSERT INTO `city_5` VALUES (2661,'Comitán de Domínguez','MEX','Chiapas',104986);
INSERT INTO `city_5` VALUES (2662,'Cunduacán','MEX','Tabasco',104164);
INSERT INTO `city_5` VALUES (2663,'Río Bravo','MEX','Tamaulipas',103901);
INSERT INTO `city_5` VALUES (2664,'Temapache','MEX','Veracruz',102824);
INSERT INTO `city_5` VALUES (2665,'Chilapa de Alvarez','MEX','Guerrero',102716);
INSERT INTO `city_5` VALUES (2666,'Hidalgo del Parral','MEX','Chihuahua',100881);
INSERT INTO `city_5` VALUES (2667,'San Francisco del Rincón','MEX','Guanajuato',100149);
INSERT INTO `city_5` VALUES (2668,'Taxco de Alarcón','MEX','Guerrero',99907);
INSERT INTO `city_5` VALUES (2669,'Zumpango','MEX','México',99781);
INSERT INTO `city_5` VALUES (2670,'San Pedro Cholula','MEX','Puebla',99734);
INSERT INTO `city_5` VALUES (2671,'Lerma','MEX','México',99714);
INSERT INTO `city_5` VALUES (2672,'Tecomán','MEX','Colima',99296);
INSERT INTO `city_5` VALUES (2673,'Las Margaritas','MEX','Chiapas',97389);
INSERT INTO `city_5` VALUES (2674,'Cosoleacaque','MEX','Veracruz',97199);
INSERT INTO `city_5` VALUES (2675,'San Luis de la Paz','MEX','Guanajuato',96763);
INSERT INTO `city_5` VALUES (2676,'José Azueta','MEX','Guerrero',95448);
INSERT INTO `city_5` VALUES (2677,'Santiago Ixcuintla','MEX','Nayarit',95311);
INSERT INTO `city_5` VALUES (2678,'San Felipe','MEX','Guanajuato',95305);
INSERT INTO `city_5` VALUES (2679,'Tejupilco','MEX','México',94934);
INSERT INTO `city_5` VALUES (2680,'Tantoyuca','MEX','Veracruz',94709);
INSERT INTO `city_5` VALUES (2681,'Salvatierra','MEX','Guanajuato',94322);
INSERT INTO `city_5` VALUES (2682,'Tultepec','MEX','México',93364);
INSERT INTO `city_5` VALUES (2683,'Temixco','MEX','Morelos',92686);
INSERT INTO `city_5` VALUES (2684,'Matamoros','MEX','Coahuila de Zaragoza',91858);
INSERT INTO `city_5` VALUES (2685,'Pánuco','MEX','Veracruz',90551);
INSERT INTO `city_5` VALUES (2686,'El Fuerte','MEX','Sinaloa',89556);
INSERT INTO `city_5` VALUES (2687,'Tierra Blanca','MEX','Veracruz',89143);
INSERT INTO `city_5` VALUES (2688,'Weno','FSM','Chuuk',22000);
INSERT INTO `city_5` VALUES (2689,'Palikir','FSM','Pohnpei',8600);
INSERT INTO `city_5` VALUES (2690,'Chisinau','MDA','Chisinau',719900);
INSERT INTO `city_5` VALUES (2691,'Tiraspol','MDA','Dnjestria',194300);
INSERT INTO `city_5` VALUES (2692,'Balti','MDA','Balti',153400);
INSERT INTO `city_5` VALUES (2693,'Bender (Tîghina)','MDA','Bender (Tîghina)',125700);
INSERT INTO `city_5` VALUES (2694,'Monte-Carlo','MCO','–',13154);
INSERT INTO `city_5` VALUES (2695,'Monaco-Ville','MCO','–',1234);
INSERT INTO `city_5` VALUES (2696,'Ulan Bator','MNG','Ulaanbaatar',773700);
INSERT INTO `city_5` VALUES (2697,'Plymouth','MSR','Plymouth',2000);
INSERT INTO `city_5` VALUES (2698,'Maputo','MOZ','Maputo',1018938);
INSERT INTO `city_5` VALUES (2699,'Matola','MOZ','Maputo',424662);
INSERT INTO `city_5` VALUES (2700,'Beira','MOZ','Sofala',397368);
INSERT INTO `city_5` VALUES (2701,'Nampula','MOZ','Nampula',303346);
INSERT INTO `city_5` VALUES (2702,'Chimoio','MOZ','Manica',171056);
INSERT INTO `city_5` VALUES (2703,'Naçala-Porto','MOZ','Nampula',158248);
INSERT INTO `city_5` VALUES (2704,'Quelimane','MOZ','Zambézia',150116);
INSERT INTO `city_5` VALUES (2705,'Mocuba','MOZ','Zambézia',124700);
INSERT INTO `city_5` VALUES (2706,'Tete','MOZ','Tete',101984);
INSERT INTO `city_5` VALUES (2707,'Xai-Xai','MOZ','Gaza',99442);
INSERT INTO `city_5` VALUES (2708,'Gurue','MOZ','Zambézia',99300);
INSERT INTO `city_5` VALUES (2709,'Maxixe','MOZ','Inhambane',93985);
INSERT INTO `city_5` VALUES (2710,'Rangoon (Yangon)','MMR','Rangoon [Yangon]',3361700);
INSERT INTO `city_5` VALUES (2711,'Mandalay','MMR','Mandalay',885300);
INSERT INTO `city_5` VALUES (2712,'Moulmein (Mawlamyine)','MMR','Mon',307900);
INSERT INTO `city_5` VALUES (2713,'Pegu (Bago)','MMR','Pegu [Bago]',190900);
INSERT INTO `city_5` VALUES (2714,'Bassein (Pathein)','MMR','Irrawaddy [Ayeyarwad',183900);
INSERT INTO `city_5` VALUES (2715,'Monywa','MMR','Sagaing',138600);
INSERT INTO `city_5` VALUES (2716,'Sittwe (Akyab)','MMR','Rakhine',137600);
INSERT INTO `city_5` VALUES (2717,'Taunggyi (Taunggye)','MMR','Shan',131500);
INSERT INTO `city_5` VALUES (2718,'Meikhtila','MMR','Mandalay',129700);
INSERT INTO `city_5` VALUES (2719,'Mergui (Myeik)','MMR','Tenasserim [Tanintha',122700);
INSERT INTO `city_5` VALUES (2720,'Lashio (Lasho)','MMR','Shan',107600);
INSERT INTO `city_5` VALUES (2721,'Prome (Pyay)','MMR','Pegu [Bago]',105700);
INSERT INTO `city_5` VALUES (2722,'Henzada (Hinthada)','MMR','Irrawaddy [Ayeyarwad',104700);
INSERT INTO `city_5` VALUES (2723,'Myingyan','MMR','Mandalay',103600);
INSERT INTO `city_5` VALUES (2724,'Tavoy (Dawei)','MMR','Tenasserim [Tanintha',96800);
INSERT INTO `city_5` VALUES (2725,'Pagakku (Pakokku)','MMR','Magwe [Magway]',94800);
INSERT INTO `city_5` VALUES (2726,'Windhoek','NAM','Khomas',169000);
INSERT INTO `city_5` VALUES (2727,'Yangor','NRU','–',4050);
INSERT INTO `city_5` VALUES (2728,'Yaren','NRU','–',559);
INSERT INTO `city_5` VALUES (2729,'Kathmandu','NPL','Central',591835);
INSERT INTO `city_5` VALUES (2730,'Biratnagar','NPL','Eastern',157764);
INSERT INTO `city_5` VALUES (2731,'Pokhara','NPL','Western',146318);
INSERT INTO `city_5` VALUES (2732,'Lalitapur','NPL','Central',145847);
INSERT INTO `city_5` VALUES (2733,'Birgunj','NPL','Central',90639);
INSERT INTO `city_5` VALUES (2734,'Managua','NIC','Managua',959000);
INSERT INTO `city_5` VALUES (2735,'León','NIC','León',123865);
INSERT INTO `city_5` VALUES (2736,'Chinandega','NIC','Chinandega',97387);
INSERT INTO `city_5` VALUES (2737,'Masaya','NIC','Masaya',88971);
INSERT INTO `city_5` VALUES (2738,'Niamey','NER','Niamey',420000);
INSERT INTO `city_5` VALUES (2739,'Zinder','NER','Zinder',120892);
INSERT INTO `city_5` VALUES (2740,'Maradi','NER','Maradi',112965);
INSERT INTO `city_5` VALUES (2741,'Lagos','NGA','Lagos',1518000);
INSERT INTO `city_5` VALUES (2742,'Ibadan','NGA','Oyo & Osun',1432000);
INSERT INTO `city_5` VALUES (2743,'Ogbomosho','NGA','Oyo & Osun',730000);
INSERT INTO `city_5` VALUES (2744,'Kano','NGA','Kano & Jigawa',674100);
INSERT INTO `city_5` VALUES (2745,'Oshogbo','NGA','Oyo & Osun',476800);
INSERT INTO `city_5` VALUES (2746,'Ilorin','NGA','Kwara & Kogi',475800);
INSERT INTO `city_5` VALUES (2747,'Abeokuta','NGA','Ogun',427400);
INSERT INTO `city_5` VALUES (2748,'Port Harcourt','NGA','Rivers & Bayelsa',410000);
INSERT INTO `city_5` VALUES (2749,'Zaria','NGA','Kaduna',379200);
INSERT INTO `city_5` VALUES (2750,'Ilesha','NGA','Oyo & Osun',378400);
INSERT INTO `city_5` VALUES (2751,'Onitsha','NGA','Anambra & Enugu & Eb',371900);
INSERT INTO `city_5` VALUES (2752,'Iwo','NGA','Oyo & Osun',362000);
INSERT INTO `city_5` VALUES (2753,'Ado-Ekiti','NGA','Ondo & Ekiti',359400);
INSERT INTO `city_5` VALUES (2754,'Abuja','NGA','Federal Capital Dist',350100);
INSERT INTO `city_5` VALUES (2755,'Kaduna','NGA','Kaduna',342200);
INSERT INTO `city_5` VALUES (2756,'Mushin','NGA','Lagos',333200);
INSERT INTO `city_5` VALUES (2757,'Maiduguri','NGA','Borno & Yobe',320000);
INSERT INTO `city_5` VALUES (2758,'Enugu','NGA','Anambra & Enugu & Eb',316100);
INSERT INTO `city_5` VALUES (2759,'Ede','NGA','Oyo & Osun',307100);
INSERT INTO `city_5` VALUES (2760,'Aba','NGA','Imo & Abia',298900);
INSERT INTO `city_5` VALUES (2761,'Ife','NGA','Oyo & Osun',296800);
INSERT INTO `city_5` VALUES (2762,'Ila','NGA','Oyo & Osun',264000);
INSERT INTO `city_5` VALUES (2763,'Oyo','NGA','Oyo & Osun',256400);
INSERT INTO `city_5` VALUES (2764,'Ikerre','NGA','Ondo & Ekiti',244600);
INSERT INTO `city_5` VALUES (2765,'Benin city_5','NGA','Edo & Delta',229400);
INSERT INTO `city_5` VALUES (2766,'Iseyin','NGA','Oyo & Osun',217300);
INSERT INTO `city_5` VALUES (2767,'Katsina','NGA','Katsina',206500);
INSERT INTO `city_5` VALUES (2768,'Jos','NGA','Plateau & Nassarawa',206300);
INSERT INTO `city_5` VALUES (2769,'Sokoto','NGA','Sokoto & Kebbi & Zam',204900);
INSERT INTO `city_5` VALUES (2770,'Ilobu','NGA','Oyo & Osun',199000);
INSERT INTO `city_5` VALUES (2771,'Offa','NGA','Kwara & Kogi',197200);
INSERT INTO `city_5` VALUES (2772,'Ikorodu','NGA','Lagos',184900);
INSERT INTO `city_5` VALUES (2773,'Ilawe-Ekiti','NGA','Ondo & Ekiti',184500);
INSERT INTO `city_5` VALUES (2774,'Owo','NGA','Ondo & Ekiti',183500);
INSERT INTO `city_5` VALUES (2775,'Ikirun','NGA','Oyo & Osun',181400);
INSERT INTO `city_5` VALUES (2776,'Shaki','NGA','Oyo & Osun',174500);
INSERT INTO `city_5` VALUES (2777,'Calabar','NGA','Cross River',174400);
INSERT INTO `city_5` VALUES (2778,'Ondo','NGA','Ondo & Ekiti',173600);
INSERT INTO `city_5` VALUES (2779,'Akure','NGA','Ondo & Ekiti',162300);
INSERT INTO `city_5` VALUES (2780,'Gusau','NGA','Sokoto & Kebbi & Zam',158000);
INSERT INTO `city_5` VALUES (2781,'Ijebu-Ode','NGA','Ogun',156400);
INSERT INTO `city_5` VALUES (2782,'Effon-Alaiye','NGA','Oyo & Osun',153100);
INSERT INTO `city_5` VALUES (2783,'Kumo','NGA','Bauchi & Gombe',148000);
INSERT INTO `city_5` VALUES (2784,'Shomolu','NGA','Lagos',147700);
INSERT INTO `city_5` VALUES (2785,'Oka-Akoko','NGA','Ondo & Ekiti',142900);
INSERT INTO `city_5` VALUES (2786,'Ikare','NGA','Ondo & Ekiti',140800);
INSERT INTO `city_5` VALUES (2787,'Sapele','NGA','Edo & Delta',139200);
INSERT INTO `city_5` VALUES (2788,'Deba Habe','NGA','Bauchi & Gombe',138600);
INSERT INTO `city_5` VALUES (2789,'Minna','NGA','Niger',136900);
INSERT INTO `city_5` VALUES (2790,'Warri','NGA','Edo & Delta',126100);
INSERT INTO `city_5` VALUES (2791,'Bida','NGA','Niger',125500);
INSERT INTO `city_5` VALUES (2792,'Ikire','NGA','Oyo & Osun',123300);
INSERT INTO `city_5` VALUES (2793,'Makurdi','NGA','Benue',123100);
INSERT INTO `city_5` VALUES (2794,'Lafia','NGA','Plateau & Nassarawa',122500);
INSERT INTO `city_5` VALUES (2795,'Inisa','NGA','Oyo & Osun',119800);
INSERT INTO `city_5` VALUES (2796,'Shagamu','NGA','Ogun',117200);
INSERT INTO `city_5` VALUES (2797,'Awka','NGA','Anambra & Enugu & Eb',111200);
INSERT INTO `city_5` VALUES (2798,'Gombe','NGA','Bauchi & Gombe',107800);
INSERT INTO `city_5` VALUES (2799,'Igboho','NGA','Oyo & Osun',106800);
INSERT INTO `city_5` VALUES (2800,'Ejigbo','NGA','Oyo & Osun',105900);
INSERT INTO `city_5` VALUES (2801,'Agege','NGA','Lagos',105000);
INSERT INTO `city_5` VALUES (2802,'Ise-Ekiti','NGA','Ondo & Ekiti',103400);
INSERT INTO `city_5` VALUES (2803,'Ugep','NGA','Cross River',102600);
INSERT INTO `city_5` VALUES (2804,'Epe','NGA','Lagos',101000);
INSERT INTO `city_5` VALUES (2805,'Alofi','NIU','–',682);
INSERT INTO `city_5` VALUES (2806,'Kingston','NFK','–',800);
INSERT INTO `city_5` VALUES (2807,'Oslo','NOR','Oslo',508726);
INSERT INTO `city_5` VALUES (2808,'Bergen','NOR','Hordaland',230948);
INSERT INTO `city_5` VALUES (2809,'Trondheim','NOR','Sør-Trøndelag',150166);
INSERT INTO `city_5` VALUES (2810,'Stavanger','NOR','Rogaland',108848);
INSERT INTO `city_5` VALUES (2811,'Bærum','NOR','Akershus',101340);
INSERT INTO `city_5` VALUES (2812,'Abidjan','CIV','Abidjan',2500000);
INSERT INTO `city_5` VALUES (2813,'Bouaké','CIV','Bouaké',329850);
INSERT INTO `city_5` VALUES (2814,'Yamoussoukro','CIV','Yamoussoukro',130000);
INSERT INTO `city_5` VALUES (2815,'Daloa','CIV','Daloa',121842);
INSERT INTO `city_5` VALUES (2816,'Korhogo','CIV','Korhogo',109445);
INSERT INTO `city_5` VALUES (2817,'al-Sib','OMN','Masqat',155000);
INSERT INTO `city_5` VALUES (2818,'Salala','OMN','Zufar',131813);
INSERT INTO `city_5` VALUES (2819,'Bawshar','OMN','Masqat',107500);
INSERT INTO `city_5` VALUES (2820,'Suhar','OMN','al-Batina',90814);
INSERT INTO `city_5` VALUES (2821,'Masqat','OMN','Masqat',51969);
INSERT INTO `city_5` VALUES (2822,'Karachi','PAK','Sindh',9269265);
INSERT INTO `city_5` VALUES (2823,'Lahore','PAK','Punjab',5063499);
INSERT INTO `city_5` VALUES (2824,'Faisalabad','PAK','Punjab',1977246);
INSERT INTO `city_5` VALUES (2825,'Rawalpindi','PAK','Punjab',1406214);
INSERT INTO `city_5` VALUES (2826,'Multan','PAK','Punjab',1182441);
INSERT INTO `city_5` VALUES (2827,'Hyderabad','PAK','Sindh',1151274);
INSERT INTO `city_5` VALUES (2828,'Gujranwala','PAK','Punjab',1124749);
INSERT INTO `city_5` VALUES (2829,'Peshawar','PAK','Nothwest Border Prov',988005);
INSERT INTO `city_5` VALUES (2830,'Quetta','PAK','Baluchistan',560307);
INSERT INTO `city_5` VALUES (2831,'Islamabad','PAK','Islamabad',524500);
INSERT INTO `city_5` VALUES (2832,'Sargodha','PAK','Punjab',455360);
INSERT INTO `city_5` VALUES (2833,'Sialkot','PAK','Punjab',417597);
INSERT INTO `city_5` VALUES (2834,'Bahawalpur','PAK','Punjab',403408);
INSERT INTO `city_5` VALUES (2835,'Sukkur','PAK','Sindh',329176);
INSERT INTO `city_5` VALUES (2836,'Jhang','PAK','Punjab',292214);
INSERT INTO `city_5` VALUES (2837,'Sheikhupura','PAK','Punjab',271875);
INSERT INTO `city_5` VALUES (2838,'Larkana','PAK','Sindh',270366);
INSERT INTO `city_5` VALUES (2839,'Gujrat','PAK','Punjab',250121);
INSERT INTO `city_5` VALUES (2840,'Mardan','PAK','Nothwest Border Prov',244511);
INSERT INTO `city_5` VALUES (2841,'Kasur','PAK','Punjab',241649);
INSERT INTO `city_5` VALUES (2842,'Rahim Yar Khan','PAK','Punjab',228479);
INSERT INTO `city_5` VALUES (2843,'Sahiwal','PAK','Punjab',207388);
INSERT INTO `city_5` VALUES (2844,'Okara','PAK','Punjab',200901);
INSERT INTO `city_5` VALUES (2845,'Wah','PAK','Punjab',198400);
INSERT INTO `city_5` VALUES (2846,'Dera Ghazi Khan','PAK','Punjab',188100);
INSERT INTO `city_5` VALUES (2847,'Mirpur Khas','PAK','Sind',184500);
INSERT INTO `city_5` VALUES (2848,'Nawabshah','PAK','Sind',183100);
INSERT INTO `city_5` VALUES (2849,'Mingora','PAK','Nothwest Border Prov',174500);
INSERT INTO `city_5` VALUES (2850,'Chiniot','PAK','Punjab',169300);
INSERT INTO `city_5` VALUES (2851,'Kamoke','PAK','Punjab',151000);
INSERT INTO `city_5` VALUES (2852,'Mandi Burewala','PAK','Punjab',149900);
INSERT INTO `city_5` VALUES (2853,'Jhelum','PAK','Punjab',145800);
INSERT INTO `city_5` VALUES (2854,'Sadiqabad','PAK','Punjab',141500);
INSERT INTO `city_5` VALUES (2855,'Jacobabad','PAK','Sind',137700);
INSERT INTO `city_5` VALUES (2856,'Shikarpur','PAK','Sind',133300);
INSERT INTO `city_5` VALUES (2857,'Khanewal','PAK','Punjab',133000);
INSERT INTO `city_5` VALUES (2858,'Hafizabad','PAK','Punjab',130200);
INSERT INTO `city_5` VALUES (2859,'Kohat','PAK','Nothwest Border Prov',125300);
INSERT INTO `city_5` VALUES (2860,'Muzaffargarh','PAK','Punjab',121600);
INSERT INTO `city_5` VALUES (2861,'Khanpur','PAK','Punjab',117800);
INSERT INTO `city_5` VALUES (2862,'Gojra','PAK','Punjab',115000);
INSERT INTO `city_5` VALUES (2863,'Bahawalnagar','PAK','Punjab',109600);
INSERT INTO `city_5` VALUES (2864,'Muridke','PAK','Punjab',108600);
INSERT INTO `city_5` VALUES (2865,'Pak Pattan','PAK','Punjab',107800);
INSERT INTO `city_5` VALUES (2866,'Abottabad','PAK','Nothwest Border Prov',106000);
INSERT INTO `city_5` VALUES (2867,'Tando Adam','PAK','Sind',103400);
INSERT INTO `city_5` VALUES (2868,'Jaranwala','PAK','Punjab',103300);
INSERT INTO `city_5` VALUES (2869,'Khairpur','PAK','Sind',102200);
INSERT INTO `city_5` VALUES (2870,'Chishtian Mandi','PAK','Punjab',101700);
INSERT INTO `city_5` VALUES (2871,'Daska','PAK','Punjab',101500);
INSERT INTO `city_5` VALUES (2872,'Dadu','PAK','Sind',98600);
INSERT INTO `city_5` VALUES (2873,'Mandi Bahauddin','PAK','Punjab',97300);
INSERT INTO `city_5` VALUES (2874,'Ahmadpur East','PAK','Punjab',96000);
INSERT INTO `city_5` VALUES (2875,'Kamalia','PAK','Punjab',95300);
INSERT INTO `city_5` VALUES (2876,'Khuzdar','PAK','Baluchistan',93100);
INSERT INTO `city_5` VALUES (2877,'Vihari','PAK','Punjab',92300);
INSERT INTO `city_5` VALUES (2878,'Dera Ismail Khan','PAK','Nothwest Border Prov',90400);
INSERT INTO `city_5` VALUES (2879,'Wazirabad','PAK','Punjab',89700);
INSERT INTO `city_5` VALUES (2880,'Nowshera','PAK','Nothwest Border Prov',89400);
INSERT INTO `city_5` VALUES (2881,'Koror','PLW','Koror',12000);
INSERT INTO `city_5` VALUES (2882,'Ciudad de Panamá','PAN','Panamá',471373);
INSERT INTO `city_5` VALUES (2883,'San Miguelito','PAN','San Miguelito',315382);
INSERT INTO `city_5` VALUES (2884,'Port Moresby','PNG','National Capital Dis',247000);
INSERT INTO `city_5` VALUES (2885,'Asunción','PRY','Asunción',557776);
INSERT INTO `city_5` VALUES (2886,'Ciudad del Este','PRY','Alto Paraná',133881);
INSERT INTO `city_5` VALUES (2887,'San Lorenzo','PRY','Central',133395);
INSERT INTO `city_5` VALUES (2888,'Lambaré','PRY','Central',99681);
INSERT INTO `city_5` VALUES (2889,'Fernando de la Mora','PRY','Central',95287);
INSERT INTO `city_5` VALUES (2890,'Lima','PER','Lima',6464693);
INSERT INTO `city_5` VALUES (2891,'Arequipa','PER','Arequipa',762000);
INSERT INTO `city_5` VALUES (2892,'Trujillo','PER','La Libertad',652000);
INSERT INTO `city_5` VALUES (2893,'Chiclayo','PER','Lambayeque',517000);
INSERT INTO `city_5` VALUES (2894,'Callao','PER','Callao',424294);
INSERT INTO `city_5` VALUES (2895,'Iquitos','PER','Loreto',367000);
INSERT INTO `city_5` VALUES (2896,'Chimbote','PER','Ancash',336000);
INSERT INTO `city_5` VALUES (2897,'Huancayo','PER','Junín',327000);
INSERT INTO `city_5` VALUES (2898,'Piura','PER','Piura',325000);
INSERT INTO `city_5` VALUES (2899,'Cusco','PER','Cusco',291000);
INSERT INTO `city_5` VALUES (2900,'Pucallpa','PER','Ucayali',220866);
INSERT INTO `city_5` VALUES (2901,'Tacna','PER','Tacna',215683);
INSERT INTO `city_5` VALUES (2902,'Ica','PER','Ica',194820);
INSERT INTO `city_5` VALUES (2903,'Sullana','PER','Piura',147361);
INSERT INTO `city_5` VALUES (2904,'Juliaca','PER','Puno',142576);
INSERT INTO `city_5` VALUES (2905,'Huánuco','PER','Huanuco',129688);
INSERT INTO `city_5` VALUES (2906,'Ayacucho','PER','Ayacucho',118960);
INSERT INTO `city_5` VALUES (2907,'Chincha Alta','PER','Ica',110016);
INSERT INTO `city_5` VALUES (2908,'Cajamarca','PER','Cajamarca',108009);
INSERT INTO `city_5` VALUES (2909,'Puno','PER','Puno',101578);
INSERT INTO `city_5` VALUES (2910,'Ventanilla','PER','Callao',101056);
INSERT INTO `city_5` VALUES (2911,'Castilla','PER','Piura',90642);
INSERT INTO `city_5` VALUES (2912,'Adamstown','PCN','–',42);
INSERT INTO `city_5` VALUES (2913,'Garapan','MNP','Saipan',9200);
INSERT INTO `city_5` VALUES (2914,'Lisboa','PRT','Lisboa',563210);
INSERT INTO `city_5` VALUES (2915,'Porto','PRT','Porto',273060);
INSERT INTO `city_5` VALUES (2916,'Amadora','PRT','Lisboa',122106);
INSERT INTO `city_5` VALUES (2917,'Coímbra','PRT','Coímbra',96100);
INSERT INTO `city_5` VALUES (2918,'Braga','PRT','Braga',90535);
INSERT INTO `city_5` VALUES (2919,'San Juan','PRI','San Juan',434374);
INSERT INTO `city_5` VALUES (2920,'Bayamón','PRI','Bayamón',224044);
INSERT INTO `city_5` VALUES (2921,'Ponce','PRI','Ponce',186475);
INSERT INTO `city_5` VALUES (2922,'Carolina','PRI','Carolina',186076);
INSERT INTO `city_5` VALUES (2923,'Caguas','PRI','Caguas',140502);
INSERT INTO `city_5` VALUES (2924,'Arecibo','PRI','Arecibo',100131);
INSERT INTO `city_5` VALUES (2925,'Guaynabo','PRI','Guaynabo',100053);
INSERT INTO `city_5` VALUES (2926,'Mayagüez','PRI','Mayagüez',98434);
INSERT INTO `city_5` VALUES (2927,'Toa Baja','PRI','Toa Baja',94085);
INSERT INTO `city_5` VALUES (2928,'Warszawa','POL','Mazowieckie',1615369);
INSERT INTO `city_5` VALUES (2929,'Lódz','POL','Lodzkie',800110);
INSERT INTO `city_5` VALUES (2930,'Kraków','POL','Malopolskie',738150);
INSERT INTO `city_5` VALUES (2931,'Wroclaw','POL','Dolnoslaskie',636765);
INSERT INTO `city_5` VALUES (2932,'Poznan','POL','Wielkopolskie',576899);
INSERT INTO `city_5` VALUES (2933,'Gdansk','POL','Pomorskie',458988);
INSERT INTO `city_5` VALUES (2934,'Szczecin','POL','Zachodnio-Pomorskie',416988);
INSERT INTO `city_5` VALUES (2935,'Bydgoszcz','POL','Kujawsko-Pomorskie',386855);
INSERT INTO `city_5` VALUES (2936,'Lublin','POL','Lubelskie',356251);
INSERT INTO `city_5` VALUES (2937,'Katowice','POL','Slaskie',345934);
INSERT INTO `city_5` VALUES (2938,'Bialystok','POL','Podlaskie',283937);
INSERT INTO `city_5` VALUES (2939,'Czestochowa','POL','Slaskie',257812);
INSERT INTO `city_5` VALUES (2940,'Gdynia','POL','Pomorskie',253521);
INSERT INTO `city_5` VALUES (2941,'Sosnowiec','POL','Slaskie',244102);
INSERT INTO `city_5` VALUES (2942,'Radom','POL','Mazowieckie',232262);
INSERT INTO `city_5` VALUES (2943,'Kielce','POL','Swietokrzyskie',212383);
INSERT INTO `city_5` VALUES (2944,'Gliwice','POL','Slaskie',212164);
INSERT INTO `city_5` VALUES (2945,'Torun','POL','Kujawsko-Pomorskie',206158);
INSERT INTO `city_5` VALUES (2946,'Bytom','POL','Slaskie',205560);
INSERT INTO `city_5` VALUES (2947,'Zabrze','POL','Slaskie',200177);
INSERT INTO `city_5` VALUES (2948,'Bielsko-Biala','POL','Slaskie',180307);
INSERT INTO `city_5` VALUES (2949,'Olsztyn','POL','Warminsko-Mazurskie',170904);
INSERT INTO `city_5` VALUES (2950,'Rzeszów','POL','Podkarpackie',162049);
INSERT INTO `city_5` VALUES (2951,'Ruda Slaska','POL','Slaskie',159665);
INSERT INTO `city_5` VALUES (2952,'Rybnik','POL','Slaskie',144582);
INSERT INTO `city_5` VALUES (2953,'Walbrzych','POL','Dolnoslaskie',136923);
INSERT INTO `city_5` VALUES (2954,'Tychy','POL','Slaskie',133178);
INSERT INTO `city_5` VALUES (2955,'Dabrowa Górnicza','POL','Slaskie',131037);
INSERT INTO `city_5` VALUES (2956,'Plock','POL','Mazowieckie',131011);
INSERT INTO `city_5` VALUES (2957,'Elblag','POL','Warminsko-Mazurskie',129782);
INSERT INTO `city_5` VALUES (2958,'Opole','POL','Opolskie',129553);
INSERT INTO `city_5` VALUES (2959,'Gorzów Wielkopolski','POL','Lubuskie',126019);
INSERT INTO `city_5` VALUES (2960,'Wloclawek','POL','Kujawsko-Pomorskie',123373);
INSERT INTO `city_5` VALUES (2961,'Chorzów','POL','Slaskie',121708);
INSERT INTO `city_5` VALUES (2962,'Tarnów','POL','Malopolskie',121494);
INSERT INTO `city_5` VALUES (2963,'Zielona Góra','POL','Lubuskie',118182);
INSERT INTO `city_5` VALUES (2964,'Koszalin','POL','Zachodnio-Pomorskie',112375);
INSERT INTO `city_5` VALUES (2965,'Legnica','POL','Dolnoslaskie',109335);
INSERT INTO `city_5` VALUES (2966,'Kalisz','POL','Wielkopolskie',106641);
INSERT INTO `city_5` VALUES (2967,'Grudziadz','POL','Kujawsko-Pomorskie',102434);
INSERT INTO `city_5` VALUES (2968,'Slupsk','POL','Pomorskie',102370);
INSERT INTO `city_5` VALUES (2969,'Jastrzebie-Zdrój','POL','Slaskie',102294);
INSERT INTO `city_5` VALUES (2970,'Jaworzno','POL','Slaskie',97929);
INSERT INTO `city_5` VALUES (2971,'Jelenia Góra','POL','Dolnoslaskie',93901);
INSERT INTO `city_5` VALUES (2972,'Malabo','GNQ','Bioko',40000);
INSERT INTO `city_5` VALUES (2973,'Doha','QAT','Doha',355000);
INSERT INTO `city_5` VALUES (2974,'Paris','FRA','Île-de-France',2125246);
INSERT INTO `city_5` VALUES (2975,'Marseille','FRA','Provence-Alpes-Côte',798430);
INSERT INTO `city_5` VALUES (2976,'Lyon','FRA','Rhône-Alpes',445452);
INSERT INTO `city_5` VALUES (2977,'Toulouse','FRA','Midi-Pyrénées',390350);
INSERT INTO `city_5` VALUES (2978,'Nice','FRA','Provence-Alpes-Côte',342738);
INSERT INTO `city_5` VALUES (2979,'Nantes','FRA','Pays de la Loire',270251);
INSERT INTO `city_5` VALUES (2980,'Strasbourg','FRA','Alsace',264115);
INSERT INTO `city_5` VALUES (2981,'Montpellier','FRA','Languedoc-Roussillon',225392);
INSERT INTO `city_5` VALUES (2982,'Bordeaux','FRA','Aquitaine',215363);
INSERT INTO `city_5` VALUES (2983,'Rennes','FRA','Haute-Normandie',206229);
INSERT INTO `city_5` VALUES (2984,'Le Havre','FRA','Champagne-Ardenne',190905);
INSERT INTO `city_5` VALUES (2985,'Reims','FRA','Nord-Pas-de-Calais',187206);
INSERT INTO `city_5` VALUES (2986,'Lille','FRA','Rhône-Alpes',184657);
INSERT INTO `city_5` VALUES (2987,'St-Étienne','FRA','Bretagne',180210);
INSERT INTO `city_5` VALUES (2988,'Toulon','FRA','Provence-Alpes-Côte',160639);
INSERT INTO `city_5` VALUES (2989,'Grenoble','FRA','Rhône-Alpes',153317);
INSERT INTO `city_5` VALUES (2990,'Angers','FRA','Pays de la Loire',151279);
INSERT INTO `city_5` VALUES (2991,'Dijon','FRA','Bourgogne',149867);
INSERT INTO `city_5` VALUES (2992,'Brest','FRA','Bretagne',149634);
INSERT INTO `city_5` VALUES (2993,'Le Mans','FRA','Pays de la Loire',146105);
INSERT INTO `city_5` VALUES (2994,'Clermont-Ferrand','FRA','Auvergne',137140);
INSERT INTO `city_5` VALUES (2995,'Amiens','FRA','Picardie',135501);
INSERT INTO `city_5` VALUES (2996,'Aix-en-Provence','FRA','Provence-Alpes-Côte',134222);
INSERT INTO `city_5` VALUES (2997,'Limoges','FRA','Limousin',133968);
INSERT INTO `city_5` VALUES (2998,'Nîmes','FRA','Languedoc-Roussillon',133424);
INSERT INTO `city_5` VALUES (2999,'Tours','FRA','Centre',132820);
COMMIT;

-- ----------------------------
-- Table structure for city_6
-- ----------------------------
DROP TABLE IF EXISTS `city_6`;
CREATE TABLE `city_6` (
                          `id` bigint NOT NULL DEFAULT '0',
                          `name` char(35) NOT NULL DEFAULT '',
                          `country_code` char(3) NOT NULL DEFAULT '',
                          `district` char(20) NOT NULL DEFAULT '',
                          `population` int NOT NULL DEFAULT '0',
                          PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of city_6
-- ----------------------------
BEGIN;
INSERT INTO `city_6` VALUES (3000,'Villeurbanne','FRA','Rhône-Alpes',124215);
INSERT INTO `city_6` VALUES (3001,'Metz','FRA','Lorraine',123776);
INSERT INTO `city_6` VALUES (3002,'Besançon','FRA','Franche-Comté',117733);
INSERT INTO `city_6` VALUES (3003,'Caen','FRA','Basse-Normandie',113987);
INSERT INTO `city_6` VALUES (3004,'Orléans','FRA','Centre',113126);
INSERT INTO `city_6` VALUES (3005,'Mulhouse','FRA','Alsace',110359);
INSERT INTO `city_6` VALUES (3006,'Rouen','FRA','Haute-Normandie',106592);
INSERT INTO `city_6` VALUES (3007,'Boulogne-Billancourt','FRA','Île-de-France',106367);
INSERT INTO `city_6` VALUES (3008,'Perpignan','FRA','Languedoc-Roussillon',105115);
INSERT INTO `city_6` VALUES (3009,'Nancy','FRA','Lorraine',103605);
INSERT INTO `city_6` VALUES (3010,'Roubaix','FRA','Nord-Pas-de-Calais',96984);
INSERT INTO `city_6` VALUES (3011,'Argenteuil','FRA','Île-de-France',93961);
INSERT INTO `city_6` VALUES (3012,'Tourcoing','FRA','Nord-Pas-de-Calais',93540);
INSERT INTO `city_6` VALUES (3013,'Montreuil','FRA','Île-de-France',90674);
INSERT INTO `city_6` VALUES (3014,'Cayenne','GUF','Cayenne',50699);
INSERT INTO `city_6` VALUES (3015,'Faaa','PYF','Tahiti',25888);
INSERT INTO `city_6` VALUES (3016,'Papeete','PYF','Tahiti',25553);
INSERT INTO `city_6` VALUES (3017,'Saint-Denis','REU','Saint-Denis',131480);
INSERT INTO `city_6` VALUES (3018,'Bucuresti','ROM','Bukarest',2016131);
INSERT INTO `city_6` VALUES (3019,'Iasi','ROM','Iasi',348070);
INSERT INTO `city_6` VALUES (3020,'Constanta','ROM','Constanta',342264);
INSERT INTO `city_6` VALUES (3021,'Cluj-Napoca','ROM','Cluj',332498);
INSERT INTO `city_6` VALUES (3022,'Galati','ROM','Galati',330276);
INSERT INTO `city_6` VALUES (3023,'Timisoara','ROM','Timis',324304);
INSERT INTO `city_6` VALUES (3024,'Brasov','ROM','Brasov',314225);
INSERT INTO `city_6` VALUES (3025,'Craiova','ROM','Dolj',313530);
INSERT INTO `city_6` VALUES (3026,'Ploiesti','ROM','Prahova',251348);
INSERT INTO `city_6` VALUES (3027,'Braila','ROM','Braila',233756);
INSERT INTO `city_6` VALUES (3028,'Oradea','ROM','Bihor',222239);
INSERT INTO `city_6` VALUES (3029,'Bacau','ROM','Bacau',209235);
INSERT INTO `city_6` VALUES (3030,'Pitesti','ROM','Arges',187170);
INSERT INTO `city_6` VALUES (3031,'Arad','ROM','Arad',184408);
INSERT INTO `city_6` VALUES (3032,'Sibiu','ROM','Sibiu',169611);
INSERT INTO `city_6` VALUES (3033,'Târgu Mures','ROM','Mures',165153);
INSERT INTO `city_6` VALUES (3034,'Baia Mare','ROM','Maramures',149665);
INSERT INTO `city_6` VALUES (3035,'Buzau','ROM','Buzau',148372);
INSERT INTO `city_6` VALUES (3036,'Satu Mare','ROM','Satu Mare',130059);
INSERT INTO `city_6` VALUES (3037,'Botosani','ROM','Botosani',128730);
INSERT INTO `city_6` VALUES (3038,'Piatra Neamt','ROM','Neamt',125070);
INSERT INTO `city_6` VALUES (3039,'Râmnicu Vâlcea','ROM','Vâlcea',119741);
INSERT INTO `city_6` VALUES (3040,'Suceava','ROM','Suceava',118549);
INSERT INTO `city_6` VALUES (3041,'Drobeta-Turnu Severin','ROM','Mehedinti',117865);
INSERT INTO `city_6` VALUES (3042,'Târgoviste','ROM','Dâmbovita',98980);
INSERT INTO `city_6` VALUES (3043,'Focsani','ROM','Vrancea',98979);
INSERT INTO `city_6` VALUES (3044,'Târgu Jiu','ROM','Gorj',98524);
INSERT INTO `city_6` VALUES (3045,'Tulcea','ROM','Tulcea',96278);
INSERT INTO `city_6` VALUES (3046,'Resita','ROM','Caras-Severin',93976);
INSERT INTO `city_6` VALUES (3047,'Kigali','RWA','Kigali',286000);
INSERT INTO `city_6` VALUES (3048,'Stockholm','SWE','Lisboa',750348);
INSERT INTO `city_6` VALUES (3049,'Gothenburg [Göteborg]','SWE','West Götanmaan län',466990);
INSERT INTO `city_6` VALUES (3050,'Malmö','SWE','Skåne län',259579);
INSERT INTO `city_6` VALUES (3051,'Uppsala','SWE','Uppsala län',189569);
INSERT INTO `city_6` VALUES (3052,'Linköping','SWE','East Götanmaan län',133168);
INSERT INTO `city_6` VALUES (3053,'Västerås','SWE','Västmanlands län',126328);
INSERT INTO `city_6` VALUES (3054,'Örebro','SWE','Örebros län',124207);
INSERT INTO `city_6` VALUES (3055,'Norrköping','SWE','East Götanmaan län',122199);
INSERT INTO `city_6` VALUES (3056,'Helsingborg','SWE','Skåne län',117737);
INSERT INTO `city_6` VALUES (3057,'Jönköping','SWE','Jönköpings län',117095);
INSERT INTO `city_6` VALUES (3058,'Umeå','SWE','Västerbottens län',104512);
INSERT INTO `city_6` VALUES (3059,'Lund','SWE','Skåne län',98948);
INSERT INTO `city_6` VALUES (3060,'Borås','SWE','West Götanmaan län',96883);
INSERT INTO `city_6` VALUES (3061,'Sundsvall','SWE','Västernorrlands län',93126);
INSERT INTO `city_6` VALUES (3062,'Gävle','SWE','Gävleborgs län',90742);
INSERT INTO `city_6` VALUES (3063,'Jamestown','SHN','Saint Helena',1500);
INSERT INTO `city_6` VALUES (3064,'Basseterre','KNA','St George Basseterre',11600);
INSERT INTO `city_6` VALUES (3065,'Castries','LCA','Castries',2301);
INSERT INTO `city_6` VALUES (3066,'Kingstown','VCT','St George',17100);
INSERT INTO `city_6` VALUES (3067,'Saint-Pierre','SPM','Saint-Pierre',5808);
INSERT INTO `city_6` VALUES (3068,'Berlin','DEU','Berliini',3386667);
INSERT INTO `city_6` VALUES (3069,'Hamburg','DEU','Hamburg',1704735);
INSERT INTO `city_6` VALUES (3070,'Munich [München]','DEU','Baijeri',1194560);
INSERT INTO `city_6` VALUES (3071,'Köln','DEU','Nordrhein-Westfalen',962507);
INSERT INTO `city_6` VALUES (3072,'Frankfurt am Main','DEU','Hessen',643821);
INSERT INTO `city_6` VALUES (3073,'Essen','DEU','Nordrhein-Westfalen',599515);
INSERT INTO `city_6` VALUES (3074,'Dortmund','DEU','Nordrhein-Westfalen',590213);
INSERT INTO `city_6` VALUES (3075,'Stuttgart','DEU','Baden-Württemberg',582443);
INSERT INTO `city_6` VALUES (3076,'Düsseldorf','DEU','Nordrhein-Westfalen',568855);
INSERT INTO `city_6` VALUES (3077,'Bremen','DEU','Bremen',540330);
INSERT INTO `city_6` VALUES (3078,'Duisburg','DEU','Nordrhein-Westfalen',519793);
INSERT INTO `city_6` VALUES (3079,'Hannover','DEU','Niedersachsen',514718);
INSERT INTO `city_6` VALUES (3080,'Leipzig','DEU','Saksi',489532);
INSERT INTO `city_6` VALUES (3081,'Nürnberg','DEU','Baijeri',486628);
INSERT INTO `city_6` VALUES (3082,'Dresden','DEU','Saksi',476668);
INSERT INTO `city_6` VALUES (3083,'Bochum','DEU','Nordrhein-Westfalen',392830);
INSERT INTO `city_6` VALUES (3084,'Wuppertal','DEU','Nordrhein-Westfalen',368993);
INSERT INTO `city_6` VALUES (3085,'Bielefeld','DEU','Nordrhein-Westfalen',321125);
INSERT INTO `city_6` VALUES (3086,'Mannheim','DEU','Baden-Württemberg',307730);
INSERT INTO `city_6` VALUES (3087,'Bonn','DEU','Nordrhein-Westfalen',301048);
INSERT INTO `city_6` VALUES (3088,'Gelsenkirchen','DEU','Nordrhein-Westfalen',281979);
INSERT INTO `city_6` VALUES (3089,'Karlsruhe','DEU','Baden-Württemberg',277204);
INSERT INTO `city_6` VALUES (3090,'Wiesbaden','DEU','Hessen',268716);
INSERT INTO `city_6` VALUES (3091,'Münster','DEU','Nordrhein-Westfalen',264670);
INSERT INTO `city_6` VALUES (3092,'Mönchengladbach','DEU','Nordrhein-Westfalen',263697);
INSERT INTO `city_6` VALUES (3093,'Chemnitz','DEU','Saksi',263222);
INSERT INTO `city_6` VALUES (3094,'Augsburg','DEU','Baijeri',254867);
INSERT INTO `city_6` VALUES (3095,'Halle/Saale','DEU','Anhalt Sachsen',254360);
INSERT INTO `city_6` VALUES (3096,'Braunschweig','DEU','Niedersachsen',246322);
INSERT INTO `city_6` VALUES (3097,'Aachen','DEU','Nordrhein-Westfalen',243825);
INSERT INTO `city_6` VALUES (3098,'Krefeld','DEU','Nordrhein-Westfalen',241769);
INSERT INTO `city_6` VALUES (3099,'Magdeburg','DEU','Anhalt Sachsen',235073);
INSERT INTO `city_6` VALUES (3100,'Kiel','DEU','Schleswig-Holstein',233795);
INSERT INTO `city_6` VALUES (3101,'Oberhausen','DEU','Nordrhein-Westfalen',222349);
INSERT INTO `city_6` VALUES (3102,'Lübeck','DEU','Schleswig-Holstein',213326);
INSERT INTO `city_6` VALUES (3103,'Hagen','DEU','Nordrhein-Westfalen',205201);
INSERT INTO `city_6` VALUES (3104,'Rostock','DEU','Mecklenburg-Vorpomme',203279);
INSERT INTO `city_6` VALUES (3105,'Freiburg im Breisgau','DEU','Baden-Württemberg',202455);
INSERT INTO `city_6` VALUES (3106,'Erfurt','DEU','Thüringen',201267);
INSERT INTO `city_6` VALUES (3107,'Kassel','DEU','Hessen',196211);
INSERT INTO `city_6` VALUES (3108,'Saarbrücken','DEU','Saarland',183836);
INSERT INTO `city_6` VALUES (3109,'Mainz','DEU','Rheinland-Pfalz',183134);
INSERT INTO `city_6` VALUES (3110,'Hamm','DEU','Nordrhein-Westfalen',181804);
INSERT INTO `city_6` VALUES (3111,'Herne','DEU','Nordrhein-Westfalen',175661);
INSERT INTO `city_6` VALUES (3112,'Mülheim an der Ruhr','DEU','Nordrhein-Westfalen',173895);
INSERT INTO `city_6` VALUES (3113,'Solingen','DEU','Nordrhein-Westfalen',165583);
INSERT INTO `city_6` VALUES (3114,'Osnabrück','DEU','Niedersachsen',164539);
INSERT INTO `city_6` VALUES (3115,'Ludwigshafen am Rhein','DEU','Rheinland-Pfalz',163771);
INSERT INTO `city_6` VALUES (3116,'Leverkusen','DEU','Nordrhein-Westfalen',160841);
INSERT INTO `city_6` VALUES (3117,'Oldenburg','DEU','Niedersachsen',154125);
INSERT INTO `city_6` VALUES (3118,'Neuss','DEU','Nordrhein-Westfalen',149702);
INSERT INTO `city_6` VALUES (3119,'Heidelberg','DEU','Baden-Württemberg',139672);
INSERT INTO `city_6` VALUES (3120,'Darmstadt','DEU','Hessen',137776);
INSERT INTO `city_6` VALUES (3121,'Paderborn','DEU','Nordrhein-Westfalen',137647);
INSERT INTO `city_6` VALUES (3122,'Potsdam','DEU','Brandenburg',128983);
INSERT INTO `city_6` VALUES (3123,'Würzburg','DEU','Baijeri',127350);
INSERT INTO `city_6` VALUES (3124,'Regensburg','DEU','Baijeri',125236);
INSERT INTO `city_6` VALUES (3125,'Recklinghausen','DEU','Nordrhein-Westfalen',125022);
INSERT INTO `city_6` VALUES (3126,'Göttingen','DEU','Niedersachsen',124775);
INSERT INTO `city_6` VALUES (3127,'Bremerhaven','DEU','Bremen',122735);
INSERT INTO `city_6` VALUES (3128,'Wolfsburg','DEU','Niedersachsen',121954);
INSERT INTO `city_6` VALUES (3129,'Bottrop','DEU','Nordrhein-Westfalen',121097);
INSERT INTO `city_6` VALUES (3130,'Remscheid','DEU','Nordrhein-Westfalen',120125);
INSERT INTO `city_6` VALUES (3131,'Heilbronn','DEU','Baden-Württemberg',119526);
INSERT INTO `city_6` VALUES (3132,'Pforzheim','DEU','Baden-Württemberg',117227);
INSERT INTO `city_6` VALUES (3133,'Offenbach am Main','DEU','Hessen',116627);
INSERT INTO `city_6` VALUES (3134,'Ulm','DEU','Baden-Württemberg',116103);
INSERT INTO `city_6` VALUES (3135,'Ingolstadt','DEU','Baijeri',114826);
INSERT INTO `city_6` VALUES (3136,'Gera','DEU','Thüringen',114718);
INSERT INTO `city_6` VALUES (3137,'Salzgitter','DEU','Niedersachsen',112934);
INSERT INTO `city_6` VALUES (3138,'Cottbus','DEU','Brandenburg',110894);
INSERT INTO `city_6` VALUES (3139,'Reutlingen','DEU','Baden-Württemberg',110343);
INSERT INTO `city_6` VALUES (3140,'Fürth','DEU','Baijeri',109771);
INSERT INTO `city_6` VALUES (3141,'Siegen','DEU','Nordrhein-Westfalen',109225);
INSERT INTO `city_6` VALUES (3142,'Koblenz','DEU','Rheinland-Pfalz',108003);
INSERT INTO `city_6` VALUES (3143,'Moers','DEU','Nordrhein-Westfalen',106837);
INSERT INTO `city_6` VALUES (3144,'Bergisch Gladbach','DEU','Nordrhein-Westfalen',106150);
INSERT INTO `city_6` VALUES (3145,'Zwickau','DEU','Saksi',104146);
INSERT INTO `city_6` VALUES (3146,'Hildesheim','DEU','Niedersachsen',104013);
INSERT INTO `city_6` VALUES (3147,'Witten','DEU','Nordrhein-Westfalen',103384);
INSERT INTO `city_6` VALUES (3148,'Schwerin','DEU','Mecklenburg-Vorpomme',102878);
INSERT INTO `city_6` VALUES (3149,'Erlangen','DEU','Baijeri',100750);
INSERT INTO `city_6` VALUES (3150,'Kaiserslautern','DEU','Rheinland-Pfalz',100025);
INSERT INTO `city_6` VALUES (3151,'Trier','DEU','Rheinland-Pfalz',99891);
INSERT INTO `city_6` VALUES (3152,'Jena','DEU','Thüringen',99779);
INSERT INTO `city_6` VALUES (3153,'Iserlohn','DEU','Nordrhein-Westfalen',99474);
INSERT INTO `city_6` VALUES (3154,'Gütersloh','DEU','Nordrhein-Westfalen',95028);
INSERT INTO `city_6` VALUES (3155,'Marl','DEU','Nordrhein-Westfalen',93735);
INSERT INTO `city_6` VALUES (3156,'Lünen','DEU','Nordrhein-Westfalen',92044);
INSERT INTO `city_6` VALUES (3157,'Düren','DEU','Nordrhein-Westfalen',91092);
INSERT INTO `city_6` VALUES (3158,'Ratingen','DEU','Nordrhein-Westfalen',90951);
INSERT INTO `city_6` VALUES (3159,'Velbert','DEU','Nordrhein-Westfalen',89881);
INSERT INTO `city_6` VALUES (3160,'Esslingen am Neckar','DEU','Baden-Württemberg',89667);
INSERT INTO `city_6` VALUES (3161,'Honiara','SLB','Honiara',50100);
INSERT INTO `city_6` VALUES (3162,'Lusaka','ZMB','Lusaka',1317000);
INSERT INTO `city_6` VALUES (3163,'Ndola','ZMB','Copperbelt',329200);
INSERT INTO `city_6` VALUES (3164,'Kitwe','ZMB','Copperbelt',288600);
INSERT INTO `city_6` VALUES (3165,'Kabwe','ZMB','Central',154300);
INSERT INTO `city_6` VALUES (3166,'Chingola','ZMB','Copperbelt',142400);
INSERT INTO `city_6` VALUES (3167,'Mufulira','ZMB','Copperbelt',123900);
INSERT INTO `city_6` VALUES (3168,'Luanshya','ZMB','Copperbelt',118100);
INSERT INTO `city_6` VALUES (3169,'Apia','WSM','Upolu',35900);
INSERT INTO `city_6` VALUES (3170,'Serravalle','SMR','Serravalle/Dogano',4802);
INSERT INTO `city_6` VALUES (3171,'San Marino','SMR','San Marino',2294);
INSERT INTO `city_6` VALUES (3172,'São Tomé','STP','Aqua Grande',49541);
INSERT INTO `city_6` VALUES (3173,'Riyadh','SAU','Riyadh',3324000);
INSERT INTO `city_6` VALUES (3174,'Jedda','SAU','Mekka',2046300);
INSERT INTO `city_6` VALUES (3175,'Mekka','SAU','Mekka',965700);
INSERT INTO `city_6` VALUES (3176,'Medina','SAU','Medina',608300);
INSERT INTO `city_6` VALUES (3177,'al-Dammam','SAU','al-Sharqiya',482300);
INSERT INTO `city_6` VALUES (3178,'al-Taif','SAU','Mekka',416100);
INSERT INTO `city_6` VALUES (3179,'Tabuk','SAU','Tabuk',292600);
INSERT INTO `city_6` VALUES (3180,'Burayda','SAU','al-Qasim',248600);
INSERT INTO `city_6` VALUES (3181,'al-Hufuf','SAU','al-Sharqiya',225800);
INSERT INTO `city_6` VALUES (3182,'al-Mubarraz','SAU','al-Sharqiya',219100);
INSERT INTO `city_6` VALUES (3183,'Khamis Mushayt','SAU','Asir',217900);
INSERT INTO `city_6` VALUES (3184,'Hail','SAU','Hail',176800);
INSERT INTO `city_6` VALUES (3185,'al-Kharj','SAU','Riad',152100);
INSERT INTO `city_6` VALUES (3186,'al-Khubar','SAU','al-Sharqiya',141700);
INSERT INTO `city_6` VALUES (3187,'Jubayl','SAU','al-Sharqiya',140800);
INSERT INTO `city_6` VALUES (3188,'Hafar al-Batin','SAU','al-Sharqiya',137800);
INSERT INTO `city_6` VALUES (3189,'al-Tuqba','SAU','al-Sharqiya',125700);
INSERT INTO `city_6` VALUES (3190,'Yanbu','SAU','Medina',119800);
INSERT INTO `city_6` VALUES (3191,'Abha','SAU','Asir',112300);
INSERT INTO `city_6` VALUES (3192,'Ara´ar','SAU','al-Khudud al-Samaliy',108100);
INSERT INTO `city_6` VALUES (3193,'al-Qatif','SAU','al-Sharqiya',98900);
INSERT INTO `city_6` VALUES (3194,'al-Hawiya','SAU','Mekka',93900);
INSERT INTO `city_6` VALUES (3195,'Unayza','SAU','Qasim',91100);
INSERT INTO `city_6` VALUES (3196,'Najran','SAU','Najran',91000);
INSERT INTO `city_6` VALUES (3197,'Pikine','SEN','Cap-Vert',855287);
INSERT INTO `city_6` VALUES (3198,'Dakar','SEN','Cap-Vert',785071);
INSERT INTO `city_6` VALUES (3199,'Thiès','SEN','Thiès',248000);
INSERT INTO `city_6` VALUES (3200,'Kaolack','SEN','Kaolack',199000);
INSERT INTO `city_6` VALUES (3201,'Ziguinchor','SEN','Ziguinchor',192000);
INSERT INTO `city_6` VALUES (3202,'Rufisque','SEN','Cap-Vert',150000);
INSERT INTO `city_6` VALUES (3203,'Saint-Louis','SEN','Saint-Louis',132400);
INSERT INTO `city_6` VALUES (3204,'Mbour','SEN','Thiès',109300);
INSERT INTO `city_6` VALUES (3205,'Diourbel','SEN','Diourbel',99400);
INSERT INTO `city_6` VALUES (3206,'Victoria','SYC','Mahé',41000);
INSERT INTO `city_6` VALUES (3207,'Freetown','SLE','Western',850000);
INSERT INTO `city_6` VALUES (3208,'Singapore','SGP','–',4017733);
INSERT INTO `city_6` VALUES (3209,'Bratislava','SVK','Bratislava',448292);
INSERT INTO `city_6` VALUES (3210,'Košice','SVK','Východné Slovensko',241874);
INSERT INTO `city_6` VALUES (3211,'Prešov','SVK','Východné Slovensko',93977);
INSERT INTO `city_6` VALUES (3212,'Ljubljana','SVN','Osrednjeslovenska',270986);
INSERT INTO `city_6` VALUES (3213,'Maribor','SVN','Podravska',115532);
INSERT INTO `city_6` VALUES (3214,'Mogadishu','SOM','Banaadir',997000);
INSERT INTO `city_6` VALUES (3215,'Hargeysa','SOM','Woqooyi Galbeed',90000);
INSERT INTO `city_6` VALUES (3216,'Kismaayo','SOM','Jubbada Hoose',90000);
INSERT INTO `city_6` VALUES (3217,'Colombo','LKA','Western',645000);
INSERT INTO `city_6` VALUES (3218,'Dehiwala','LKA','Western',203000);
INSERT INTO `city_6` VALUES (3219,'Moratuwa','LKA','Western',190000);
INSERT INTO `city_6` VALUES (3220,'Jaffna','LKA','Northern',149000);
INSERT INTO `city_6` VALUES (3221,'Kandy','LKA','Central',140000);
INSERT INTO `city_6` VALUES (3222,'Sri Jayawardenepura Kotte','LKA','Western',118000);
INSERT INTO `city_6` VALUES (3223,'Negombo','LKA','Western',100000);
INSERT INTO `city_6` VALUES (3224,'Omdurman','SDN','Khartum',1271403);
INSERT INTO `city_6` VALUES (3225,'Khartum','SDN','Khartum',947483);
INSERT INTO `city_6` VALUES (3226,'Sharq al-Nil','SDN','Khartum',700887);
INSERT INTO `city_6` VALUES (3227,'Port Sudan','SDN','al-Bahr al-Ahmar',308195);
INSERT INTO `city_6` VALUES (3228,'Kassala','SDN','Kassala',234622);
INSERT INTO `city_6` VALUES (3229,'Obeid','SDN','Kurdufan al-Shamaliy',229425);
INSERT INTO `city_6` VALUES (3230,'Nyala','SDN','Darfur al-Janubiya',227183);
INSERT INTO `city_6` VALUES (3231,'Wad Madani','SDN','al-Jazira',211362);
INSERT INTO `city_6` VALUES (3232,'al-Qadarif','SDN','al-Qadarif',191164);
INSERT INTO `city_6` VALUES (3233,'Kusti','SDN','al-Bahr al-Abyad',173599);
INSERT INTO `city_6` VALUES (3234,'al-Fashir','SDN','Darfur al-Shamaliya',141884);
INSERT INTO `city_6` VALUES (3235,'Juba','SDN','Bahr al-Jabal',114980);
INSERT INTO `city_6` VALUES (3236,'Helsinki [Helsingfors]','FIN','Newmaa',555474);
INSERT INTO `city_6` VALUES (3237,'Espoo','FIN','Newmaa',213271);
INSERT INTO `city_6` VALUES (3238,'Tampere','FIN','Pirkanmaa',195468);
INSERT INTO `city_6` VALUES (3239,'Vantaa','FIN','Newmaa',178471);
INSERT INTO `city_6` VALUES (3240,'Turku [Åbo]','FIN','Varsinais-Suomi',172561);
INSERT INTO `city_6` VALUES (3241,'Oulu','FIN','Pohjois-Pohjanmaa',120753);
INSERT INTO `city_6` VALUES (3242,'Lahti','FIN','Päijät-Häme',96921);
INSERT INTO `city_6` VALUES (3243,'Paramaribo','SUR','Paramaribo',112000);
INSERT INTO `city_6` VALUES (3244,'Mbabane','SWZ','Hhohho',61000);
INSERT INTO `city_6` VALUES (3245,'Zürich','CHE','Zürich',336800);
INSERT INTO `city_6` VALUES (3246,'Geneve','CHE','Geneve',173500);
INSERT INTO `city_6` VALUES (3247,'Basel','CHE','Basel-Stadt',166700);
INSERT INTO `city_6` VALUES (3248,'Bern','CHE','Bern',122700);
INSERT INTO `city_6` VALUES (3249,'Lausanne','CHE','Vaud',114500);
INSERT INTO `city_6` VALUES (3250,'Damascus','SYR','Damascus',1347000);
INSERT INTO `city_6` VALUES (3251,'Aleppo','SYR','Aleppo',1261983);
INSERT INTO `city_6` VALUES (3252,'Hims','SYR','Hims',507404);
INSERT INTO `city_6` VALUES (3253,'Hama','SYR','Hama',343361);
INSERT INTO `city_6` VALUES (3254,'Latakia','SYR','Latakia',264563);
INSERT INTO `city_6` VALUES (3255,'al-Qamishliya','SYR','al-Hasaka',144286);
INSERT INTO `city_6` VALUES (3256,'Dayr al-Zawr','SYR','Dayr al-Zawr',140459);
INSERT INTO `city_6` VALUES (3257,'Jaramana','SYR','Damaskos',138469);
INSERT INTO `city_6` VALUES (3258,'Duma','SYR','Damaskos',131158);
INSERT INTO `city_6` VALUES (3259,'al-Raqqa','SYR','al-Raqqa',108020);
INSERT INTO `city_6` VALUES (3260,'Idlib','SYR','Idlib',91081);
INSERT INTO `city_6` VALUES (3261,'Dushanbe','TJK','Karotegin',524000);
INSERT INTO `city_6` VALUES (3262,'Khujand','TJK','Khujand',161500);
INSERT INTO `city_6` VALUES (3263,'Taipei','TWN','Taipei',2641312);
INSERT INTO `city_6` VALUES (3264,'Kaohsiung','TWN','Kaohsiung',1475505);
INSERT INTO `city_6` VALUES (3265,'Taichung','TWN','Taichung',940589);
INSERT INTO `city_6` VALUES (3266,'Tainan','TWN','Tainan',728060);
INSERT INTO `city_6` VALUES (3267,'Panchiao','TWN','Taipei',523850);
INSERT INTO `city_6` VALUES (3268,'Chungho','TWN','Taipei',392176);
INSERT INTO `city_6` VALUES (3269,'Keelung (Chilung)','TWN','Keelung',385201);
INSERT INTO `city_6` VALUES (3270,'Sanchung','TWN','Taipei',380084);
INSERT INTO `city_6` VALUES (3271,'Hsinchuang','TWN','Taipei',365048);
INSERT INTO `city_6` VALUES (3272,'Hsinchu','TWN','Hsinchu',361958);
INSERT INTO `city_6` VALUES (3273,'Chungli','TWN','Taoyuan',318649);
INSERT INTO `city_6` VALUES (3274,'Fengshan','TWN','Kaohsiung',318562);
INSERT INTO `city_6` VALUES (3275,'Taoyuan','TWN','Taoyuan',316438);
INSERT INTO `city_6` VALUES (3276,'Chiayi','TWN','Chiayi',265109);
INSERT INTO `city_6` VALUES (3277,'Hsintien','TWN','Taipei',263603);
INSERT INTO `city_6` VALUES (3278,'Changhwa','TWN','Changhwa',227715);
INSERT INTO `city_6` VALUES (3279,'Yungho','TWN','Taipei',227700);
INSERT INTO `city_6` VALUES (3280,'Tucheng','TWN','Taipei',224897);
INSERT INTO `city_6` VALUES (3281,'Pingtung','TWN','Pingtung',214727);
INSERT INTO `city_6` VALUES (3282,'Yungkang','TWN','Tainan',193005);
INSERT INTO `city_6` VALUES (3283,'Pingchen','TWN','Taoyuan',188344);
INSERT INTO `city_6` VALUES (3284,'Tali','TWN','Taichung',171940);
INSERT INTO `city_6` VALUES (3285,'Taiping','TWN','',165524);
INSERT INTO `city_6` VALUES (3286,'Pate','TWN','Taoyuan',161700);
INSERT INTO `city_6` VALUES (3287,'Fengyuan','TWN','Taichung',161032);
INSERT INTO `city_6` VALUES (3288,'Luchou','TWN','Taipei',160516);
INSERT INTO `city_6` VALUES (3289,'Hsichuh','TWN','Taipei',154976);
INSERT INTO `city_6` VALUES (3290,'Shulin','TWN','Taipei',151260);
INSERT INTO `city_6` VALUES (3291,'Yuanlin','TWN','Changhwa',126402);
INSERT INTO `city_6` VALUES (3292,'Yangmei','TWN','Taoyuan',126323);
INSERT INTO `city_6` VALUES (3293,'Taliao','TWN','',115897);
INSERT INTO `city_6` VALUES (3294,'Kueishan','TWN','',112195);
INSERT INTO `city_6` VALUES (3295,'Tanshui','TWN','Taipei',111882);
INSERT INTO `city_6` VALUES (3296,'Taitung','TWN','Taitung',111039);
INSERT INTO `city_6` VALUES (3297,'Hualien','TWN','Hualien',108407);
INSERT INTO `city_6` VALUES (3298,'Nantou','TWN','Nantou',104723);
INSERT INTO `city_6` VALUES (3299,'Lungtan','TWN','Taipei',103088);
INSERT INTO `city_6` VALUES (3300,'Touliu','TWN','Yünlin',98900);
INSERT INTO `city_6` VALUES (3301,'Tsaotun','TWN','Nantou',96800);
INSERT INTO `city_6` VALUES (3302,'Kangshan','TWN','Kaohsiung',92200);
INSERT INTO `city_6` VALUES (3303,'Ilan','TWN','Ilan',92000);
INSERT INTO `city_6` VALUES (3304,'Miaoli','TWN','Miaoli',90000);
INSERT INTO `city_6` VALUES (3305,'Dar es Salaam','TZA','Dar es Salaam',1747000);
INSERT INTO `city_6` VALUES (3306,'Dodoma','TZA','Dodoma',189000);
INSERT INTO `city_6` VALUES (3307,'Mwanza','TZA','Mwanza',172300);
INSERT INTO `city_6` VALUES (3308,'Zanzibar','TZA','Zanzibar West',157634);
INSERT INTO `city_6` VALUES (3309,'Tanga','TZA','Tanga',137400);
INSERT INTO `city_6` VALUES (3310,'Mbeya','TZA','Mbeya',130800);
INSERT INTO `city_6` VALUES (3311,'Morogoro','TZA','Morogoro',117800);
INSERT INTO `city_6` VALUES (3312,'Arusha','TZA','Arusha',102500);
INSERT INTO `city_6` VALUES (3313,'Moshi','TZA','Kilimanjaro',96800);
INSERT INTO `city_6` VALUES (3314,'Tabora','TZA','Tabora',92800);
INSERT INTO `city_6` VALUES (3315,'København','DNK','København',495699);
INSERT INTO `city_6` VALUES (3316,'Århus','DNK','Århus',284846);
INSERT INTO `city_6` VALUES (3317,'Odense','DNK','Fyn',183912);
INSERT INTO `city_6` VALUES (3318,'Aalborg','DNK','Nordjylland',161161);
INSERT INTO `city_6` VALUES (3319,'Frederiksberg','DNK','Frederiksberg',90327);
INSERT INTO `city_6` VALUES (3320,'Bangkok','THA','Bangkok',6320174);
INSERT INTO `city_6` VALUES (3321,'Nonthaburi','THA','Nonthaburi',292100);
INSERT INTO `city_6` VALUES (3322,'Nakhon Ratchasima','THA','Nakhon Ratchasima',181400);
INSERT INTO `city_6` VALUES (3323,'Chiang Mai','THA','Chiang Mai',171100);
INSERT INTO `city_6` VALUES (3324,'Udon Thani','THA','Udon Thani',158100);
INSERT INTO `city_6` VALUES (3325,'Hat Yai','THA','Songkhla',148632);
INSERT INTO `city_6` VALUES (3326,'Khon Kaen','THA','Khon Kaen',126500);
INSERT INTO `city_6` VALUES (3327,'Pak Kret','THA','Nonthaburi',126055);
INSERT INTO `city_6` VALUES (3328,'Nakhon Sawan','THA','Nakhon Sawan',123800);
INSERT INTO `city_6` VALUES (3329,'Ubon Ratchathani','THA','Ubon Ratchathani',116300);
INSERT INTO `city_6` VALUES (3330,'Songkhla','THA','Songkhla',94900);
INSERT INTO `city_6` VALUES (3331,'Nakhon Pathom','THA','Nakhon Pathom',94100);
INSERT INTO `city_6` VALUES (3332,'Lomé','TGO','Maritime',375000);
INSERT INTO `city_6` VALUES (3333,'Fakaofo','TKL','Fakaofo',300);
INSERT INTO `city_6` VALUES (3334,'Nuku´alofa','TON','Tongatapu',22400);
INSERT INTO `city_6` VALUES (3335,'Chaguanas','TTO','Caroni',56601);
INSERT INTO `city_6` VALUES (3336,'Port-of-Spain','TTO','Port-of-Spain',43396);
INSERT INTO `city_6` VALUES (3337,'N´Djaména','TCD','Chari-Baguirmi',530965);
INSERT INTO `city_6` VALUES (3338,'Moundou','TCD','Logone Occidental',99500);
INSERT INTO `city_6` VALUES (3339,'Praha','CZE','Hlavní mesto Praha',1181126);
INSERT INTO `city_6` VALUES (3340,'Brno','CZE','Jizní Morava',381862);
INSERT INTO `city_6` VALUES (3341,'Ostrava','CZE','Severní Morava',320041);
INSERT INTO `city_6` VALUES (3342,'Plzen','CZE','Zapadní Cechy',166759);
INSERT INTO `city_6` VALUES (3343,'Olomouc','CZE','Severní Morava',102702);
INSERT INTO `city_6` VALUES (3344,'Liberec','CZE','Severní Cechy',99155);
INSERT INTO `city_6` VALUES (3345,'Ceské Budejovice','CZE','Jizní Cechy',98186);
INSERT INTO `city_6` VALUES (3346,'Hradec Králové','CZE','Východní Cechy',98080);
INSERT INTO `city_6` VALUES (3347,'Ústí nad Labem','CZE','Severní Cechy',95491);
INSERT INTO `city_6` VALUES (3348,'Pardubice','CZE','Východní Cechy',91309);
INSERT INTO `city_6` VALUES (3349,'Tunis','TUN','Tunis',690600);
INSERT INTO `city_6` VALUES (3350,'Sfax','TUN','Sfax',257800);
INSERT INTO `city_6` VALUES (3351,'Ariana','TUN','Ariana',197000);
INSERT INTO `city_6` VALUES (3352,'Ettadhamen','TUN','Ariana',178600);
INSERT INTO `city_6` VALUES (3353,'Sousse','TUN','Sousse',145900);
INSERT INTO `city_6` VALUES (3354,'Kairouan','TUN','Kairouan',113100);
INSERT INTO `city_6` VALUES (3355,'Biserta','TUN','Biserta',108900);
INSERT INTO `city_6` VALUES (3356,'Gabès','TUN','Gabès',106600);
INSERT INTO `city_6` VALUES (3357,'Istanbul','TUR','Istanbul',8787958);
INSERT INTO `city_6` VALUES (3358,'Ankara','TUR','Ankara',3038159);
INSERT INTO `city_6` VALUES (3359,'Izmir','TUR','Izmir',2130359);
INSERT INTO `city_6` VALUES (3360,'Adana','TUR','Adana',1131198);
INSERT INTO `city_6` VALUES (3361,'Bursa','TUR','Bursa',1095842);
INSERT INTO `city_6` VALUES (3362,'Gaziantep','TUR','Gaziantep',789056);
INSERT INTO `city_6` VALUES (3363,'Konya','TUR','Konya',628364);
INSERT INTO `city_6` VALUES (3364,'Mersin (Içel)','TUR','Içel',587212);
INSERT INTO `city_6` VALUES (3365,'Antalya','TUR','Antalya',564914);
INSERT INTO `city_6` VALUES (3366,'Diyarbakir','TUR','Diyarbakir',479884);
INSERT INTO `city_6` VALUES (3367,'Kayseri','TUR','Kayseri',475657);
INSERT INTO `city_6` VALUES (3368,'Eskisehir','TUR','Eskisehir',470781);
INSERT INTO `city_6` VALUES (3369,'Sanliurfa','TUR','Sanliurfa',405905);
INSERT INTO `city_6` VALUES (3370,'Samsun','TUR','Samsun',339871);
INSERT INTO `city_6` VALUES (3371,'Malatya','TUR','Malatya',330312);
INSERT INTO `city_6` VALUES (3372,'Gebze','TUR','Kocaeli',264170);
INSERT INTO `city_6` VALUES (3373,'Denizli','TUR','Denizli',253848);
INSERT INTO `city_6` VALUES (3374,'Sivas','TUR','Sivas',246642);
INSERT INTO `city_6` VALUES (3375,'Erzurum','TUR','Erzurum',246535);
INSERT INTO `city_6` VALUES (3376,'Tarsus','TUR','Adana',246206);
INSERT INTO `city_6` VALUES (3377,'Kahramanmaras','TUR','Kahramanmaras',245772);
INSERT INTO `city_6` VALUES (3378,'Elâzig','TUR','Elâzig',228815);
INSERT INTO `city_6` VALUES (3379,'Van','TUR','Van',219319);
INSERT INTO `city_6` VALUES (3380,'Sultanbeyli','TUR','Istanbul',211068);
INSERT INTO `city_6` VALUES (3381,'Izmit (Kocaeli)','TUR','Kocaeli',210068);
INSERT INTO `city_6` VALUES (3382,'Manisa','TUR','Manisa',207148);
INSERT INTO `city_6` VALUES (3383,'Batman','TUR','Batman',203793);
INSERT INTO `city_6` VALUES (3384,'Balikesir','TUR','Balikesir',196382);
INSERT INTO `city_6` VALUES (3385,'Sakarya (Adapazari)','TUR','Sakarya',190641);
INSERT INTO `city_6` VALUES (3386,'Iskenderun','TUR','Hatay',153022);
INSERT INTO `city_6` VALUES (3387,'Osmaniye','TUR','Osmaniye',146003);
INSERT INTO `city_6` VALUES (3388,'Çorum','TUR','Çorum',145495);
INSERT INTO `city_6` VALUES (3389,'Kütahya','TUR','Kütahya',144761);
INSERT INTO `city_6` VALUES (3390,'Hatay (Antakya)','TUR','Hatay',143982);
INSERT INTO `city_6` VALUES (3391,'Kirikkale','TUR','Kirikkale',142044);
INSERT INTO `city_6` VALUES (3392,'Adiyaman','TUR','Adiyaman',141529);
INSERT INTO `city_6` VALUES (3393,'Trabzon','TUR','Trabzon',138234);
INSERT INTO `city_6` VALUES (3394,'Ordu','TUR','Ordu',133642);
INSERT INTO `city_6` VALUES (3395,'Aydin','TUR','Aydin',128651);
INSERT INTO `city_6` VALUES (3396,'Usak','TUR','Usak',128162);
INSERT INTO `city_6` VALUES (3397,'Edirne','TUR','Edirne',123383);
INSERT INTO `city_6` VALUES (3398,'Çorlu','TUR','Tekirdag',123300);
INSERT INTO `city_6` VALUES (3399,'Isparta','TUR','Isparta',121911);
INSERT INTO `city_6` VALUES (3400,'Karabük','TUR','Karabük',118285);
INSERT INTO `city_6` VALUES (3401,'Kilis','TUR','Kilis',118245);
INSERT INTO `city_6` VALUES (3402,'Alanya','TUR','Antalya',117300);
INSERT INTO `city_6` VALUES (3403,'Kiziltepe','TUR','Mardin',112000);
INSERT INTO `city_6` VALUES (3404,'Zonguldak','TUR','Zonguldak',111542);
INSERT INTO `city_6` VALUES (3405,'Siirt','TUR','Siirt',107100);
INSERT INTO `city_6` VALUES (3406,'Viransehir','TUR','Sanliurfa',106400);
INSERT INTO `city_6` VALUES (3407,'Tekirdag','TUR','Tekirdag',106077);
INSERT INTO `city_6` VALUES (3408,'Karaman','TUR','Karaman',104200);
INSERT INTO `city_6` VALUES (3409,'Afyon','TUR','Afyon',103984);
INSERT INTO `city_6` VALUES (3410,'Aksaray','TUR','Aksaray',102681);
INSERT INTO `city_6` VALUES (3411,'Ceyhan','TUR','Adana',102412);
INSERT INTO `city_6` VALUES (3412,'Erzincan','TUR','Erzincan',102304);
INSERT INTO `city_6` VALUES (3413,'Bismil','TUR','Diyarbakir',101400);
INSERT INTO `city_6` VALUES (3414,'Nazilli','TUR','Aydin',99900);
INSERT INTO `city_6` VALUES (3415,'Tokat','TUR','Tokat',99500);
INSERT INTO `city_6` VALUES (3416,'Kars','TUR','Kars',93000);
INSERT INTO `city_6` VALUES (3417,'Inegöl','TUR','Bursa',90500);
INSERT INTO `city_6` VALUES (3418,'Bandirma','TUR','Balikesir',90200);
INSERT INTO `city_6` VALUES (3419,'Ashgabat','TKM','Ahal',540600);
INSERT INTO `city_6` VALUES (3420,'Chärjew','TKM','Lebap',189200);
INSERT INTO `city_6` VALUES (3421,'Dashhowuz','TKM','Dashhowuz',141800);
INSERT INTO `city_6` VALUES (3422,'Mary','TKM','Mary',101000);
INSERT INTO `city_6` VALUES (3423,'Cockburn Town','TCA','Grand Turk',4800);
INSERT INTO `city_6` VALUES (3424,'Funafuti','TUV','Funafuti',4600);
INSERT INTO `city_6` VALUES (3425,'Kampala','UGA','Central',890800);
INSERT INTO `city_6` VALUES (3426,'Kyiv','UKR','Kiova',2624000);
INSERT INTO `city_6` VALUES (3427,'Harkova [Harkiv]','UKR','Harkova',1500000);
INSERT INTO `city_6` VALUES (3428,'Dnipropetrovsk','UKR','Dnipropetrovsk',1103000);
INSERT INTO `city_6` VALUES (3429,'Donetsk','UKR','Donetsk',1050000);
INSERT INTO `city_6` VALUES (3430,'Odesa','UKR','Odesa',1011000);
INSERT INTO `city_6` VALUES (3431,'Zaporizzja','UKR','Zaporizzja',848000);
INSERT INTO `city_6` VALUES (3432,'Lviv','UKR','Lviv',788000);
INSERT INTO `city_6` VALUES (3433,'Kryvyi Rig','UKR','Dnipropetrovsk',703000);
INSERT INTO `city_6` VALUES (3434,'Mykolajiv','UKR','Mykolajiv',508000);
INSERT INTO `city_6` VALUES (3435,'Mariupol','UKR','Donetsk',490000);
INSERT INTO `city_6` VALUES (3436,'Lugansk','UKR','Lugansk',469000);
INSERT INTO `city_6` VALUES (3437,'Vinnytsja','UKR','Vinnytsja',391000);
INSERT INTO `city_6` VALUES (3438,'Makijivka','UKR','Donetsk',384000);
INSERT INTO `city_6` VALUES (3439,'Herson','UKR','Herson',353000);
INSERT INTO `city_6` VALUES (3440,'Sevastopol','UKR','Krim',348000);
INSERT INTO `city_6` VALUES (3441,'Simferopol','UKR','Krim',339000);
INSERT INTO `city_6` VALUES (3442,'Pultava [Poltava]','UKR','Pultava',313000);
INSERT INTO `city_6` VALUES (3443,'Tšernigiv','UKR','Tšernigiv',313000);
INSERT INTO `city_6` VALUES (3444,'Tšerkasy','UKR','Tšerkasy',309000);
INSERT INTO `city_6` VALUES (3445,'Gorlivka','UKR','Donetsk',299000);
INSERT INTO `city_6` VALUES (3446,'Zytomyr','UKR','Zytomyr',297000);
INSERT INTO `city_6` VALUES (3447,'Sumy','UKR','Sumy',294000);
INSERT INTO `city_6` VALUES (3448,'Dniprodzerzynsk','UKR','Dnipropetrovsk',270000);
INSERT INTO `city_6` VALUES (3449,'Kirovograd','UKR','Kirovograd',265000);
INSERT INTO `city_6` VALUES (3450,'Hmelnytskyi','UKR','Hmelnytskyi',262000);
INSERT INTO `city_6` VALUES (3451,'Tšernivtsi','UKR','Tšernivtsi',259000);
INSERT INTO `city_6` VALUES (3452,'Rivne','UKR','Rivne',245000);
INSERT INTO `city_6` VALUES (3453,'Krementšuk','UKR','Pultava',239000);
INSERT INTO `city_6` VALUES (3454,'Ivano-Frankivsk','UKR','Ivano-Frankivsk',237000);
INSERT INTO `city_6` VALUES (3455,'Ternopil','UKR','Ternopil',236000);
INSERT INTO `city_6` VALUES (3456,'Lutsk','UKR','Volynia',217000);
INSERT INTO `city_6` VALUES (3457,'Bila Tserkva','UKR','Kiova',215000);
INSERT INTO `city_6` VALUES (3458,'Kramatorsk','UKR','Donetsk',186000);
INSERT INTO `city_6` VALUES (3459,'Melitopol','UKR','Zaporizzja',169000);
INSERT INTO `city_6` VALUES (3460,'Kertš','UKR','Krim',162000);
INSERT INTO `city_6` VALUES (3461,'Nikopol','UKR','Dnipropetrovsk',149000);
INSERT INTO `city_6` VALUES (3462,'Berdjansk','UKR','Zaporizzja',130000);
INSERT INTO `city_6` VALUES (3463,'Pavlograd','UKR','Dnipropetrovsk',127000);
INSERT INTO `city_6` VALUES (3464,'Sjeverodonetsk','UKR','Lugansk',127000);
INSERT INTO `city_6` VALUES (3465,'Slovjansk','UKR','Donetsk',127000);
INSERT INTO `city_6` VALUES (3466,'Uzgorod','UKR','Taka-Karpatia',127000);
INSERT INTO `city_6` VALUES (3467,'Altševsk','UKR','Lugansk',119000);
INSERT INTO `city_6` VALUES (3468,'Lysytšansk','UKR','Lugansk',116000);
INSERT INTO `city_6` VALUES (3469,'Jevpatorija','UKR','Krim',112000);
INSERT INTO `city_6` VALUES (3470,'Kamjanets-Podilskyi','UKR','Hmelnytskyi',109000);
INSERT INTO `city_6` VALUES (3471,'Jenakijeve','UKR','Donetsk',105000);
INSERT INTO `city_6` VALUES (3472,'Krasnyi Lutš','UKR','Lugansk',101000);
INSERT INTO `city_6` VALUES (3473,'Stahanov','UKR','Lugansk',101000);
INSERT INTO `city_6` VALUES (3474,'Oleksandrija','UKR','Kirovograd',99000);
INSERT INTO `city_6` VALUES (3475,'Konotop','UKR','Sumy',96000);
INSERT INTO `city_6` VALUES (3476,'Kostjantynivka','UKR','Donetsk',95000);
INSERT INTO `city_6` VALUES (3477,'Berdytšiv','UKR','Zytomyr',90000);
INSERT INTO `city_6` VALUES (3478,'Izmajil','UKR','Odesa',90000);
INSERT INTO `city_6` VALUES (3479,'Šostka','UKR','Sumy',90000);
INSERT INTO `city_6` VALUES (3480,'Uman','UKR','Tšerkasy',90000);
INSERT INTO `city_6` VALUES (3481,'Brovary','UKR','Kiova',89000);
INSERT INTO `city_6` VALUES (3482,'Mukatševe','UKR','Taka-Karpatia',89000);
INSERT INTO `city_6` VALUES (3483,'Budapest','HUN','Budapest',1811552);
INSERT INTO `city_6` VALUES (3484,'Debrecen','HUN','Hajdú-Bihar',203648);
INSERT INTO `city_6` VALUES (3485,'Miskolc','HUN','Borsod-Abaúj-Zemplén',172357);
INSERT INTO `city_6` VALUES (3486,'Szeged','HUN','Csongrád',158158);
INSERT INTO `city_6` VALUES (3487,'Pécs','HUN','Baranya',157332);
INSERT INTO `city_6` VALUES (3488,'Györ','HUN','Györ-Moson-Sopron',127119);
INSERT INTO `city_6` VALUES (3489,'Nyiregyháza','HUN','Szabolcs-Szatmár-Ber',112419);
INSERT INTO `city_6` VALUES (3490,'Kecskemét','HUN','Bács-Kiskun',105606);
INSERT INTO `city_6` VALUES (3491,'Székesfehérvár','HUN','Fejér',105119);
INSERT INTO `city_6` VALUES (3492,'Montevideo','URY','Montevideo',1236000);
INSERT INTO `city_6` VALUES (3493,'Nouméa','NCL','–',76293);
INSERT INTO `city_6` VALUES (3494,'Auckland','NZL','Auckland',381800);
INSERT INTO `city_6` VALUES (3495,'Christchurch','NZL','Canterbury',324200);
INSERT INTO `city_6` VALUES (3496,'Manukau','NZL','Auckland',281800);
INSERT INTO `city_6` VALUES (3497,'North Shore','NZL','Auckland',187700);
INSERT INTO `city_6` VALUES (3498,'Waitakere','NZL','Auckland',170600);
INSERT INTO `city_6` VALUES (3499,'Wellington','NZL','Wellington',166700);
COMMIT;

-- ----------------------------
-- Table structure for city_7
-- ----------------------------
DROP TABLE IF EXISTS `city_7`;
CREATE TABLE `city_7` (
                          `id` bigint NOT NULL DEFAULT '0',
                          `name` char(35) NOT NULL DEFAULT '',
                          `country_code` char(3) NOT NULL DEFAULT '',
                          `district` char(20) NOT NULL DEFAULT '',
                          `population` int NOT NULL DEFAULT '0',
                          PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of city_7
-- ----------------------------
BEGIN;
INSERT INTO `city_7` VALUES (3500,'Dunedin','NZL','Dunedin',119600);
INSERT INTO `city_7` VALUES (3501,'Hamilton','NZL','Hamilton',117100);
INSERT INTO `city_7` VALUES (3502,'Lower Hutt','NZL','Wellington',98100);
INSERT INTO `city_7` VALUES (3503,'Toskent','UZB','Toskent Shahri',2117500);
INSERT INTO `city_7` VALUES (3504,'Namangan','UZB','Namangan',370500);
INSERT INTO `city_7` VALUES (3505,'Samarkand','UZB','Samarkand',361800);
INSERT INTO `city_7` VALUES (3506,'Andijon','UZB','Andijon',318600);
INSERT INTO `city_7` VALUES (3507,'Buhoro','UZB','Buhoro',237100);
INSERT INTO `city_7` VALUES (3508,'Karsi','UZB','Qashqadaryo',194100);
INSERT INTO `city_7` VALUES (3509,'Nukus','UZB','Karakalpakistan',194100);
INSERT INTO `city_7` VALUES (3510,'Kükon','UZB','Fargona',190100);
INSERT INTO `city_7` VALUES (3511,'Fargona','UZB','Fargona',180500);
INSERT INTO `city_7` VALUES (3512,'Circik','UZB','Toskent',146400);
INSERT INTO `city_7` VALUES (3513,'Margilon','UZB','Fargona',140800);
INSERT INTO `city_7` VALUES (3514,'Ürgenc','UZB','Khorazm',138900);
INSERT INTO `city_7` VALUES (3515,'Angren','UZB','Toskent',128000);
INSERT INTO `city_7` VALUES (3516,'Cizah','UZB','Cizah',124800);
INSERT INTO `city_7` VALUES (3517,'Navoi','UZB','Navoi',116300);
INSERT INTO `city_7` VALUES (3518,'Olmalik','UZB','Toskent',114900);
INSERT INTO `city_7` VALUES (3519,'Termiz','UZB','Surkhondaryo',109500);
INSERT INTO `city_7` VALUES (3520,'Minsk','BLR','Horad Minsk',1674000);
INSERT INTO `city_7` VALUES (3521,'Gomel','BLR','Gomel',475000);
INSERT INTO `city_7` VALUES (3522,'Mogiljov','BLR','Mogiljov',356000);
INSERT INTO `city_7` VALUES (3523,'Vitebsk','BLR','Vitebsk',340000);
INSERT INTO `city_7` VALUES (3524,'Grodno','BLR','Grodno',302000);
INSERT INTO `city_7` VALUES (3525,'Brest','BLR','Brest',286000);
INSERT INTO `city_7` VALUES (3526,'Bobruisk','BLR','Mogiljov',221000);
INSERT INTO `city_7` VALUES (3527,'Baranovitši','BLR','Brest',167000);
INSERT INTO `city_7` VALUES (3528,'Borisov','BLR','Minsk',151000);
INSERT INTO `city_7` VALUES (3529,'Pinsk','BLR','Brest',130000);
INSERT INTO `city_7` VALUES (3530,'Orša','BLR','Vitebsk',124000);
INSERT INTO `city_7` VALUES (3531,'Mozyr','BLR','Gomel',110000);
INSERT INTO `city_7` VALUES (3532,'Novopolotsk','BLR','Vitebsk',106000);
INSERT INTO `city_7` VALUES (3533,'Lida','BLR','Grodno',101000);
INSERT INTO `city_7` VALUES (3534,'Soligorsk','BLR','Minsk',101000);
INSERT INTO `city_7` VALUES (3535,'Molodetšno','BLR','Minsk',97000);
INSERT INTO `city_7` VALUES (3536,'Mata-Utu','WLF','Wallis',1137);
INSERT INTO `city_7` VALUES (3537,'Port-Vila','VUT','Shefa',33700);
INSERT INTO `city_7` VALUES (3538,'Città del Vaticano','VAT','–',455);
INSERT INTO `city_7` VALUES (3539,'Caracas','VEN','Distrito Federal',1975294);
INSERT INTO `city_7` VALUES (3540,'Maracaíbo','VEN','Zulia',1304776);
INSERT INTO `city_7` VALUES (3541,'Barquisimeto','VEN','Lara',877239);
INSERT INTO `city_7` VALUES (3542,'Valencia','VEN','Carabobo',794246);
INSERT INTO `city_7` VALUES (3543,'Ciudad Guayana','VEN','Bolívar',663713);
INSERT INTO `city_7` VALUES (3544,'Petare','VEN','Miranda',488868);
INSERT INTO `city_7` VALUES (3545,'Maracay','VEN','Aragua',444443);
INSERT INTO `city_7` VALUES (3546,'Barcelona','VEN','Anzoátegui',322267);
INSERT INTO `city_7` VALUES (3547,'Maturín','VEN','Monagas',319726);
INSERT INTO `city_7` VALUES (3548,'San Cristóbal','VEN','Táchira',319373);
INSERT INTO `city_7` VALUES (3549,'Ciudad Bolívar','VEN','Bolívar',301107);
INSERT INTO `city_7` VALUES (3550,'Cumaná','VEN','Sucre',293105);
INSERT INTO `city_7` VALUES (3551,'Mérida','VEN','Mérida',224887);
INSERT INTO `city_7` VALUES (3552,'Cabimas','VEN','Zulia',221329);
INSERT INTO `city_7` VALUES (3553,'Barinas','VEN','Barinas',217831);
INSERT INTO `city_7` VALUES (3554,'Turmero','VEN','Aragua',217499);
INSERT INTO `city_7` VALUES (3555,'Baruta','VEN','Miranda',207290);
INSERT INTO `city_7` VALUES (3556,'Puerto Cabello','VEN','Carabobo',187722);
INSERT INTO `city_7` VALUES (3557,'Santa Ana de Coro','VEN','Falcón',185766);
INSERT INTO `city_7` VALUES (3558,'Los Teques','VEN','Miranda',178784);
INSERT INTO `city_7` VALUES (3559,'Punto Fijo','VEN','Falcón',167215);
INSERT INTO `city_7` VALUES (3560,'Guarenas','VEN','Miranda',165889);
INSERT INTO `city_7` VALUES (3561,'Acarigua','VEN','Portuguesa',158954);
INSERT INTO `city_7` VALUES (3562,'Puerto La Cruz','VEN','Anzoátegui',155700);
INSERT INTO `city_7` VALUES (3563,'Ciudad Losada','VEN','',134501);
INSERT INTO `city_7` VALUES (3564,'Guacara','VEN','Carabobo',131334);
INSERT INTO `city_7` VALUES (3565,'Valera','VEN','Trujillo',130281);
INSERT INTO `city_7` VALUES (3566,'Guanare','VEN','Portuguesa',125621);
INSERT INTO `city_7` VALUES (3567,'Carúpano','VEN','Sucre',119639);
INSERT INTO `city_7` VALUES (3568,'Catia La Mar','VEN','Distrito Federal',117012);
INSERT INTO `city_7` VALUES (3569,'El Tigre','VEN','Anzoátegui',116256);
INSERT INTO `city_7` VALUES (3570,'Guatire','VEN','Miranda',109121);
INSERT INTO `city_7` VALUES (3571,'Calabozo','VEN','Guárico',107146);
INSERT INTO `city_7` VALUES (3572,'Pozuelos','VEN','Anzoátegui',105690);
INSERT INTO `city_7` VALUES (3573,'Ciudad Ojeda','VEN','Zulia',99354);
INSERT INTO `city_7` VALUES (3574,'Ocumare del Tuy','VEN','Miranda',97168);
INSERT INTO `city_7` VALUES (3575,'Valle de la Pascua','VEN','Guárico',95927);
INSERT INTO `city_7` VALUES (3576,'Araure','VEN','Portuguesa',94269);
INSERT INTO `city_7` VALUES (3577,'San Fernando de Apure','VEN','Apure',93809);
INSERT INTO `city_7` VALUES (3578,'San Felipe','VEN','Yaracuy',90940);
INSERT INTO `city_7` VALUES (3579,'El Limón','VEN','Aragua',90000);
INSERT INTO `city_7` VALUES (3580,'Moscow','RUS','Moscow (city_7)',8389200);
INSERT INTO `city_7` VALUES (3581,'St Petersburg','RUS','Pietari',4694000);
INSERT INTO `city_7` VALUES (3582,'Novosibirsk','RUS','Novosibirsk',1398800);
INSERT INTO `city_7` VALUES (3583,'Nizni Novgorod','RUS','Nizni Novgorod',1357000);
INSERT INTO `city_7` VALUES (3584,'Jekaterinburg','RUS','Sverdlovsk',1266300);
INSERT INTO `city_7` VALUES (3585,'Samara','RUS','Samara',1156100);
INSERT INTO `city_7` VALUES (3586,'Omsk','RUS','Omsk',1148900);
INSERT INTO `city_7` VALUES (3587,'Kazan','RUS','Tatarstan',1101000);
INSERT INTO `city_7` VALUES (3588,'Ufa','RUS','Baškortostan',1091200);
INSERT INTO `city_7` VALUES (3589,'Tšeljabinsk','RUS','Tšeljabinsk',1083200);
INSERT INTO `city_7` VALUES (3590,'Rostov-na-Donu','RUS','Rostov-na-Donu',1012700);
INSERT INTO `city_7` VALUES (3591,'Perm','RUS','Perm',1009700);
INSERT INTO `city_7` VALUES (3592,'Volgograd','RUS','Volgograd',993400);
INSERT INTO `city_7` VALUES (3593,'Voronez','RUS','Voronez',907700);
INSERT INTO `city_7` VALUES (3594,'Krasnojarsk','RUS','Krasnojarsk',875500);
INSERT INTO `city_7` VALUES (3595,'Saratov','RUS','Saratov',874000);
INSERT INTO `city_7` VALUES (3596,'Toljatti','RUS','Samara',722900);
INSERT INTO `city_7` VALUES (3597,'Uljanovsk','RUS','Uljanovsk',667400);
INSERT INTO `city_7` VALUES (3598,'Izevsk','RUS','Udmurtia',652800);
INSERT INTO `city_7` VALUES (3599,'Krasnodar','RUS','Krasnodar',639000);
INSERT INTO `city_7` VALUES (3600,'Jaroslavl','RUS','Jaroslavl',616700);
INSERT INTO `city_7` VALUES (3601,'Habarovsk','RUS','Habarovsk',609400);
INSERT INTO `city_7` VALUES (3602,'Vladivostok','RUS','Primorje',606200);
INSERT INTO `city_7` VALUES (3603,'Irkutsk','RUS','Irkutsk',593700);
INSERT INTO `city_7` VALUES (3604,'Barnaul','RUS','Altai',580100);
INSERT INTO `city_7` VALUES (3605,'Novokuznetsk','RUS','Kemerovo',561600);
INSERT INTO `city_7` VALUES (3606,'Penza','RUS','Penza',532200);
INSERT INTO `city_7` VALUES (3607,'Rjazan','RUS','Rjazan',529900);
INSERT INTO `city_7` VALUES (3608,'Orenburg','RUS','Orenburg',523600);
INSERT INTO `city_7` VALUES (3609,'Lipetsk','RUS','Lipetsk',521000);
INSERT INTO `city_7` VALUES (3610,'Nabereznyje Tšelny','RUS','Tatarstan',514700);
INSERT INTO `city_7` VALUES (3611,'Tula','RUS','Tula',506100);
INSERT INTO `city_7` VALUES (3612,'Tjumen','RUS','Tjumen',503400);
INSERT INTO `city_7` VALUES (3613,'Kemerovo','RUS','Kemerovo',492700);
INSERT INTO `city_7` VALUES (3614,'Astrahan','RUS','Astrahan',486100);
INSERT INTO `city_7` VALUES (3615,'Tomsk','RUS','Tomsk',482100);
INSERT INTO `city_7` VALUES (3616,'Kirov','RUS','Kirov',466200);
INSERT INTO `city_7` VALUES (3617,'Ivanovo','RUS','Ivanovo',459200);
INSERT INTO `city_7` VALUES (3618,'Tšeboksary','RUS','Tšuvassia',459200);
INSERT INTO `city_7` VALUES (3619,'Brjansk','RUS','Brjansk',457400);
INSERT INTO `city_7` VALUES (3620,'Tver','RUS','Tver',454900);
INSERT INTO `city_7` VALUES (3621,'Kursk','RUS','Kursk',443500);
INSERT INTO `city_7` VALUES (3622,'Magnitogorsk','RUS','Tšeljabinsk',427900);
INSERT INTO `city_7` VALUES (3623,'Kaliningrad','RUS','Kaliningrad',424400);
INSERT INTO `city_7` VALUES (3624,'Nizni Tagil','RUS','Sverdlovsk',390900);
INSERT INTO `city_7` VALUES (3625,'Murmansk','RUS','Murmansk',376300);
INSERT INTO `city_7` VALUES (3626,'Ulan-Ude','RUS','Burjatia',370400);
INSERT INTO `city_7` VALUES (3627,'Kurgan','RUS','Kurgan',364700);
INSERT INTO `city_7` VALUES (3628,'Arkangeli','RUS','Arkangeli',361800);
INSERT INTO `city_7` VALUES (3629,'Sotši','RUS','Krasnodar',358600);
INSERT INTO `city_7` VALUES (3630,'Smolensk','RUS','Smolensk',353400);
INSERT INTO `city_7` VALUES (3631,'Orjol','RUS','Orjol',344500);
INSERT INTO `city_7` VALUES (3632,'Stavropol','RUS','Stavropol',343300);
INSERT INTO `city_7` VALUES (3633,'Belgorod','RUS','Belgorod',342000);
INSERT INTO `city_7` VALUES (3634,'Kaluga','RUS','Kaluga',339300);
INSERT INTO `city_7` VALUES (3635,'Vladimir','RUS','Vladimir',337100);
INSERT INTO `city_7` VALUES (3636,'Mahatškala','RUS','Dagestan',332800);
INSERT INTO `city_7` VALUES (3637,'Tšerepovets','RUS','Vologda',324400);
INSERT INTO `city_7` VALUES (3638,'Saransk','RUS','Mordva',314800);
INSERT INTO `city_7` VALUES (3639,'Tambov','RUS','Tambov',312000);
INSERT INTO `city_7` VALUES (3640,'Vladikavkaz','RUS','North Ossetia-Alania',310100);
INSERT INTO `city_7` VALUES (3641,'Tšita','RUS','Tšita',309900);
INSERT INTO `city_7` VALUES (3642,'Vologda','RUS','Vologda',302500);
INSERT INTO `city_7` VALUES (3643,'Veliki Novgorod','RUS','Novgorod',299500);
INSERT INTO `city_7` VALUES (3644,'Komsomolsk-na-Amure','RUS','Habarovsk',291600);
INSERT INTO `city_7` VALUES (3645,'Kostroma','RUS','Kostroma',288100);
INSERT INTO `city_7` VALUES (3646,'Volzski','RUS','Volgograd',286900);
INSERT INTO `city_7` VALUES (3647,'Taganrog','RUS','Rostov-na-Donu',284400);
INSERT INTO `city_7` VALUES (3648,'Petroskoi','RUS','Karjala',282100);
INSERT INTO `city_7` VALUES (3649,'Bratsk','RUS','Irkutsk',277600);
INSERT INTO `city_7` VALUES (3650,'Dzerzinsk','RUS','Nizni Novgorod',277100);
INSERT INTO `city_7` VALUES (3651,'Surgut','RUS','Hanti-Mansia',274900);
INSERT INTO `city_7` VALUES (3652,'Orsk','RUS','Orenburg',273900);
INSERT INTO `city_7` VALUES (3653,'Sterlitamak','RUS','Baškortostan',265200);
INSERT INTO `city_7` VALUES (3654,'Angarsk','RUS','Irkutsk',264700);
INSERT INTO `city_7` VALUES (3655,'Joškar-Ola','RUS','Marinmaa',249200);
INSERT INTO `city_7` VALUES (3656,'Rybinsk','RUS','Jaroslavl',239600);
INSERT INTO `city_7` VALUES (3657,'Prokopjevsk','RUS','Kemerovo',237300);
INSERT INTO `city_7` VALUES (3658,'Niznevartovsk','RUS','Hanti-Mansia',233900);
INSERT INTO `city_7` VALUES (3659,'Naltšik','RUS','Kabardi-Balkaria',233400);
INSERT INTO `city_7` VALUES (3660,'Syktyvkar','RUS','Komi',229700);
INSERT INTO `city_7` VALUES (3661,'Severodvinsk','RUS','Arkangeli',229300);
INSERT INTO `city_7` VALUES (3662,'Bijsk','RUS','Altai',225000);
INSERT INTO `city_7` VALUES (3663,'Niznekamsk','RUS','Tatarstan',223400);
INSERT INTO `city_7` VALUES (3664,'Blagoveštšensk','RUS','Amur',222000);
INSERT INTO `city_7` VALUES (3665,'Šahty','RUS','Rostov-na-Donu',221800);
INSERT INTO `city_7` VALUES (3666,'Staryi Oskol','RUS','Belgorod',213800);
INSERT INTO `city_7` VALUES (3667,'Zelenograd','RUS','Moscow (city_7)',207100);
INSERT INTO `city_7` VALUES (3668,'Balakovo','RUS','Saratov',206000);
INSERT INTO `city_7` VALUES (3669,'Novorossijsk','RUS','Krasnodar',203300);
INSERT INTO `city_7` VALUES (3670,'Pihkova','RUS','Pihkova',201500);
INSERT INTO `city_7` VALUES (3671,'Zlatoust','RUS','Tšeljabinsk',196900);
INSERT INTO `city_7` VALUES (3672,'Jakutsk','RUS','Saha (Jakutia)',195400);
INSERT INTO `city_7` VALUES (3673,'Podolsk','RUS','Moskova',194300);
INSERT INTO `city_7` VALUES (3674,'Petropavlovsk-Kamtšatski','RUS','Kamtšatka',194100);
INSERT INTO `city_7` VALUES (3675,'Kamensk-Uralski','RUS','Sverdlovsk',190600);
INSERT INTO `city_7` VALUES (3676,'Engels','RUS','Saratov',189000);
INSERT INTO `city_7` VALUES (3677,'Syzran','RUS','Samara',186900);
INSERT INTO `city_7` VALUES (3678,'Grozny','RUS','Tšetšenia',186000);
INSERT INTO `city_7` VALUES (3679,'Novotšerkassk','RUS','Rostov-na-Donu',184400);
INSERT INTO `city_7` VALUES (3680,'Berezniki','RUS','Perm',181900);
INSERT INTO `city_7` VALUES (3681,'Juzno-Sahalinsk','RUS','Sahalin',179200);
INSERT INTO `city_7` VALUES (3682,'Volgodonsk','RUS','Rostov-na-Donu',178200);
INSERT INTO `city_7` VALUES (3683,'Abakan','RUS','Hakassia',169200);
INSERT INTO `city_7` VALUES (3684,'Maikop','RUS','Adygea',167300);
INSERT INTO `city_7` VALUES (3685,'Miass','RUS','Tšeljabinsk',166200);
INSERT INTO `city_7` VALUES (3686,'Armavir','RUS','Krasnodar',164900);
INSERT INTO `city_7` VALUES (3687,'Ljubertsy','RUS','Moskova',163900);
INSERT INTO `city_7` VALUES (3688,'Rubtsovsk','RUS','Altai',162600);
INSERT INTO `city_7` VALUES (3689,'Kovrov','RUS','Vladimir',159900);
INSERT INTO `city_7` VALUES (3690,'Nahodka','RUS','Primorje',157700);
INSERT INTO `city_7` VALUES (3691,'Ussurijsk','RUS','Primorje',157300);
INSERT INTO `city_7` VALUES (3692,'Salavat','RUS','Baškortostan',156800);
INSERT INTO `city_7` VALUES (3693,'Mytištši','RUS','Moskova',155700);
INSERT INTO `city_7` VALUES (3694,'Kolomna','RUS','Moskova',150700);
INSERT INTO `city_7` VALUES (3695,'Elektrostal','RUS','Moskova',147000);
INSERT INTO `city_7` VALUES (3696,'Murom','RUS','Vladimir',142400);
INSERT INTO `city_7` VALUES (3697,'Kolpino','RUS','Pietari',141200);
INSERT INTO `city_7` VALUES (3698,'Norilsk','RUS','Krasnojarsk',140800);
INSERT INTO `city_7` VALUES (3699,'Almetjevsk','RUS','Tatarstan',140700);
INSERT INTO `city_7` VALUES (3700,'Novomoskovsk','RUS','Tula',138100);
INSERT INTO `city_7` VALUES (3701,'Dimitrovgrad','RUS','Uljanovsk',137000);
INSERT INTO `city_7` VALUES (3702,'Pervouralsk','RUS','Sverdlovsk',136100);
INSERT INTO `city_7` VALUES (3703,'Himki','RUS','Moskova',133700);
INSERT INTO `city_7` VALUES (3704,'Balašiha','RUS','Moskova',132900);
INSERT INTO `city_7` VALUES (3705,'Nevinnomyssk','RUS','Stavropol',132600);
INSERT INTO `city_7` VALUES (3706,'Pjatigorsk','RUS','Stavropol',132500);
INSERT INTO `city_7` VALUES (3707,'Korolev','RUS','Moskova',132400);
INSERT INTO `city_7` VALUES (3708,'Serpuhov','RUS','Moskova',132000);
INSERT INTO `city_7` VALUES (3709,'Odintsovo','RUS','Moskova',127400);
INSERT INTO `city_7` VALUES (3710,'Orehovo-Zujevo','RUS','Moskova',124900);
INSERT INTO `city_7` VALUES (3711,'Kamyšin','RUS','Volgograd',124600);
INSERT INTO `city_7` VALUES (3712,'Novotšeboksarsk','RUS','Tšuvassia',123400);
INSERT INTO `city_7` VALUES (3713,'Tšerkessk','RUS','Karatšai-Tšerkessia',121700);
INSERT INTO `city_7` VALUES (3714,'Atšinsk','RUS','Krasnojarsk',121600);
INSERT INTO `city_7` VALUES (3715,'Magadan','RUS','Magadan',121000);
INSERT INTO `city_7` VALUES (3716,'Mitšurinsk','RUS','Tambov',120700);
INSERT INTO `city_7` VALUES (3717,'Kislovodsk','RUS','Stavropol',120400);
INSERT INTO `city_7` VALUES (3718,'Jelets','RUS','Lipetsk',119400);
INSERT INTO `city_7` VALUES (3719,'Seversk','RUS','Tomsk',118600);
INSERT INTO `city_7` VALUES (3720,'Noginsk','RUS','Moskova',117200);
INSERT INTO `city_7` VALUES (3721,'Velikije Luki','RUS','Pihkova',116300);
INSERT INTO `city_7` VALUES (3722,'Novokuibyševsk','RUS','Samara',116200);
INSERT INTO `city_7` VALUES (3723,'Neftekamsk','RUS','Baškortostan',115700);
INSERT INTO `city_7` VALUES (3724,'Leninsk-Kuznetski','RUS','Kemerovo',113800);
INSERT INTO `city_7` VALUES (3725,'Oktjabrski','RUS','Baškortostan',111500);
INSERT INTO `city_7` VALUES (3726,'Sergijev Posad','RUS','Moskova',111100);
INSERT INTO `city_7` VALUES (3727,'Arzamas','RUS','Nizni Novgorod',110700);
INSERT INTO `city_7` VALUES (3728,'Kiseljovsk','RUS','Kemerovo',110000);
INSERT INTO `city_7` VALUES (3729,'Novotroitsk','RUS','Orenburg',109600);
INSERT INTO `city_7` VALUES (3730,'Obninsk','RUS','Kaluga',108300);
INSERT INTO `city_7` VALUES (3731,'Kansk','RUS','Krasnojarsk',107400);
INSERT INTO `city_7` VALUES (3732,'Glazov','RUS','Udmurtia',106300);
INSERT INTO `city_7` VALUES (3733,'Solikamsk','RUS','Perm',106000);
INSERT INTO `city_7` VALUES (3734,'Sarapul','RUS','Udmurtia',105700);
INSERT INTO `city_7` VALUES (3735,'Ust-Ilimsk','RUS','Irkutsk',105200);
INSERT INTO `city_7` VALUES (3736,'Štšolkovo','RUS','Moskova',104900);
INSERT INTO `city_7` VALUES (3737,'Mezduretšensk','RUS','Kemerovo',104400);
INSERT INTO `city_7` VALUES (3738,'Usolje-Sibirskoje','RUS','Irkutsk',103500);
INSERT INTO `city_7` VALUES (3739,'Elista','RUS','Kalmykia',103300);
INSERT INTO `city_7` VALUES (3740,'Novošahtinsk','RUS','Rostov-na-Donu',101900);
INSERT INTO `city_7` VALUES (3741,'Votkinsk','RUS','Udmurtia',101700);
INSERT INTO `city_7` VALUES (3742,'Kyzyl','RUS','Tyva',101100);
INSERT INTO `city_7` VALUES (3743,'Serov','RUS','Sverdlovsk',100400);
INSERT INTO `city_7` VALUES (3744,'Zelenodolsk','RUS','Tatarstan',100200);
INSERT INTO `city_7` VALUES (3745,'Zeleznodoroznyi','RUS','Moskova',100100);
INSERT INTO `city_7` VALUES (3746,'Kinešma','RUS','Ivanovo',100000);
INSERT INTO `city_7` VALUES (3747,'Kuznetsk','RUS','Penza',98200);
INSERT INTO `city_7` VALUES (3748,'Uhta','RUS','Komi',98000);
INSERT INTO `city_7` VALUES (3749,'Jessentuki','RUS','Stavropol',97900);
INSERT INTO `city_7` VALUES (3750,'Tobolsk','RUS','Tjumen',97600);
INSERT INTO `city_7` VALUES (3751,'Neftejugansk','RUS','Hanti-Mansia',97400);
INSERT INTO `city_7` VALUES (3752,'Bataisk','RUS','Rostov-na-Donu',97300);
INSERT INTO `city_7` VALUES (3753,'Nojabrsk','RUS','Yamalin Nenetsia',97300);
INSERT INTO `city_7` VALUES (3754,'Balašov','RUS','Saratov',97100);
INSERT INTO `city_7` VALUES (3755,'Zeleznogorsk','RUS','Kursk',96900);
INSERT INTO `city_7` VALUES (3756,'Zukovski','RUS','Moskova',96500);
INSERT INTO `city_7` VALUES (3757,'Anzero-Sudzensk','RUS','Kemerovo',96100);
INSERT INTO `city_7` VALUES (3758,'Bugulma','RUS','Tatarstan',94100);
INSERT INTO `city_7` VALUES (3759,'Zeleznogorsk','RUS','Krasnojarsk',94000);
INSERT INTO `city_7` VALUES (3760,'Novouralsk','RUS','Sverdlovsk',93300);
INSERT INTO `city_7` VALUES (3761,'Puškin','RUS','Pietari',92900);
INSERT INTO `city_7` VALUES (3762,'Vorkuta','RUS','Komi',92600);
INSERT INTO `city_7` VALUES (3763,'Derbent','RUS','Dagestan',92300);
INSERT INTO `city_7` VALUES (3764,'Kirovo-Tšepetsk','RUS','Kirov',91600);
INSERT INTO `city_7` VALUES (3765,'Krasnogorsk','RUS','Moskova',91000);
INSERT INTO `city_7` VALUES (3766,'Klin','RUS','Moskova',90000);
INSERT INTO `city_7` VALUES (3767,'Tšaikovski','RUS','Perm',90000);
INSERT INTO `city_7` VALUES (3768,'Novyi Urengoi','RUS','Yamalin Nenetsia',89800);
INSERT INTO `city_7` VALUES (3769,'Ho Chi Minh city_7','VNM','Ho Chi Minh city_7',3980000);
INSERT INTO `city_7` VALUES (3770,'Hanoi','VNM','Hanoi',1410000);
INSERT INTO `city_7` VALUES (3771,'Haiphong','VNM','Haiphong',783133);
INSERT INTO `city_7` VALUES (3772,'Da Nang','VNM','Quang Nam-Da Nang',382674);
INSERT INTO `city_7` VALUES (3773,'Biên Hoa','VNM','Dong Nai',282095);
INSERT INTO `city_7` VALUES (3774,'Nha Trang','VNM','Khanh Hoa',221331);
INSERT INTO `city_7` VALUES (3775,'Hue','VNM','Thua Thien-Hue',219149);
INSERT INTO `city_7` VALUES (3776,'Can Tho','VNM','Can Tho',215587);
INSERT INTO `city_7` VALUES (3777,'Cam Pha','VNM','Quang Binh',209086);
INSERT INTO `city_7` VALUES (3778,'Nam Dinh','VNM','Nam Ha',171699);
INSERT INTO `city_7` VALUES (3779,'Quy Nhon','VNM','Binh Dinh',163385);
INSERT INTO `city_7` VALUES (3780,'Vung Tau','VNM','Ba Ria-Vung Tau',145145);
INSERT INTO `city_7` VALUES (3781,'Rach Gia','VNM','Kien Giang',141132);
INSERT INTO `city_7` VALUES (3782,'Long Xuyen','VNM','An Giang',132681);
INSERT INTO `city_7` VALUES (3783,'Thai Nguyen','VNM','Bac Thai',127643);
INSERT INTO `city_7` VALUES (3784,'Hong Gai','VNM','Quang Ninh',127484);
INSERT INTO `city_7` VALUES (3785,'Phan Thiêt','VNM','Binh Thuan',114236);
INSERT INTO `city_7` VALUES (3786,'Cam Ranh','VNM','Khanh Hoa',114041);
INSERT INTO `city_7` VALUES (3787,'Vinh','VNM','Nghe An',112455);
INSERT INTO `city_7` VALUES (3788,'My Tho','VNM','Tien Giang',108404);
INSERT INTO `city_7` VALUES (3789,'Da Lat','VNM','Lam Dong',106409);
INSERT INTO `city_7` VALUES (3790,'Buon Ma Thuot','VNM','Dac Lac',97044);
INSERT INTO `city_7` VALUES (3791,'Tallinn','EST','Harjumaa',403981);
INSERT INTO `city_7` VALUES (3792,'Tartu','EST','Tartumaa',101246);
INSERT INTO `city_7` VALUES (3793,'New York','USA','New York',8008278);
INSERT INTO `city_7` VALUES (3794,'Los Angeles','USA','California',3694820);
INSERT INTO `city_7` VALUES (3795,'Chicago','USA','Illinois',2896016);
INSERT INTO `city_7` VALUES (3796,'Houston','USA','Texas',1953631);
INSERT INTO `city_7` VALUES (3797,'Philadelphia','USA','Pennsylvania',1517550);
INSERT INTO `city_7` VALUES (3798,'Phoenix','USA','Arizona',1321045);
INSERT INTO `city_7` VALUES (3799,'San Diego','USA','California',1223400);
INSERT INTO `city_7` VALUES (3800,'Dallas','USA','Texas',1188580);
INSERT INTO `city_7` VALUES (3801,'San Antonio','USA','Texas',1144646);
INSERT INTO `city_7` VALUES (3802,'Detroit','USA','Michigan',951270);
INSERT INTO `city_7` VALUES (3803,'San Jose','USA','California',894943);
INSERT INTO `city_7` VALUES (3804,'Indianapolis','USA','Indiana',791926);
INSERT INTO `city_7` VALUES (3805,'San Francisco','USA','California',776733);
INSERT INTO `city_7` VALUES (3806,'Jacksonville','USA','Florida',735167);
INSERT INTO `city_7` VALUES (3807,'Columbus','USA','Ohio',711470);
INSERT INTO `city_7` VALUES (3808,'Austin','USA','Texas',656562);
INSERT INTO `city_7` VALUES (3809,'Baltimore','USA','Maryland',651154);
INSERT INTO `city_7` VALUES (3810,'Memphis','USA','Tennessee',650100);
INSERT INTO `city_7` VALUES (3811,'Milwaukee','USA','Wisconsin',596974);
INSERT INTO `city_7` VALUES (3812,'Boston','USA','Massachusetts',589141);
INSERT INTO `city_7` VALUES (3813,'Washington','USA','District of Columbia',572059);
INSERT INTO `city_7` VALUES (3814,'Nashville-Davidson','USA','Tennessee',569891);
INSERT INTO `city_7` VALUES (3815,'El Paso','USA','Texas',563662);
INSERT INTO `city_7` VALUES (3816,'Seattle','USA','Washington',563374);
INSERT INTO `city_7` VALUES (3817,'Denver','USA','Colorado',554636);
INSERT INTO `city_7` VALUES (3818,'Charlotte','USA','North Carolina',540828);
INSERT INTO `city_7` VALUES (3819,'Fort Worth','USA','Texas',534694);
INSERT INTO `city_7` VALUES (3820,'Portland','USA','Oregon',529121);
INSERT INTO `city_7` VALUES (3821,'Oklahoma city_7','USA','Oklahoma',506132);
INSERT INTO `city_7` VALUES (3822,'Tucson','USA','Arizona',486699);
INSERT INTO `city_7` VALUES (3823,'New Orleans','USA','Louisiana',484674);
INSERT INTO `city_7` VALUES (3824,'Las Vegas','USA','Nevada',478434);
INSERT INTO `city_7` VALUES (3825,'Cleveland','USA','Ohio',478403);
INSERT INTO `city_7` VALUES (3826,'Long Beach','USA','California',461522);
INSERT INTO `city_7` VALUES (3827,'Albuquerque','USA','New Mexico',448607);
INSERT INTO `city_7` VALUES (3828,'Kansas city_7','USA','Missouri',441545);
INSERT INTO `city_7` VALUES (3829,'Fresno','USA','California',427652);
INSERT INTO `city_7` VALUES (3830,'Virginia Beach','USA','Virginia',425257);
INSERT INTO `city_7` VALUES (3831,'Atlanta','USA','Georgia',416474);
INSERT INTO `city_7` VALUES (3832,'Sacramento','USA','California',407018);
INSERT INTO `city_7` VALUES (3833,'Oakland','USA','California',399484);
INSERT INTO `city_7` VALUES (3834,'Mesa','USA','Arizona',396375);
INSERT INTO `city_7` VALUES (3835,'Tulsa','USA','Oklahoma',393049);
INSERT INTO `city_7` VALUES (3836,'Omaha','USA','Nebraska',390007);
INSERT INTO `city_7` VALUES (3837,'Minneapolis','USA','Minnesota',382618);
INSERT INTO `city_7` VALUES (3838,'Honolulu','USA','Hawaii',371657);
INSERT INTO `city_7` VALUES (3839,'Miami','USA','Florida',362470);
INSERT INTO `city_7` VALUES (3840,'Colorado Springs','USA','Colorado',360890);
INSERT INTO `city_7` VALUES (3841,'Saint Louis','USA','Missouri',348189);
INSERT INTO `city_7` VALUES (3842,'Wichita','USA','Kansas',344284);
INSERT INTO `city_7` VALUES (3843,'Santa Ana','USA','California',337977);
INSERT INTO `city_7` VALUES (3844,'Pittsburgh','USA','Pennsylvania',334563);
INSERT INTO `city_7` VALUES (3845,'Arlington','USA','Texas',332969);
INSERT INTO `city_7` VALUES (3846,'Cincinnati','USA','Ohio',331285);
INSERT INTO `city_7` VALUES (3847,'Anaheim','USA','California',328014);
INSERT INTO `city_7` VALUES (3848,'Toledo','USA','Ohio',313619);
INSERT INTO `city_7` VALUES (3849,'Tampa','USA','Florida',303447);
INSERT INTO `city_7` VALUES (3850,'Buffalo','USA','New York',292648);
INSERT INTO `city_7` VALUES (3851,'Saint Paul','USA','Minnesota',287151);
INSERT INTO `city_7` VALUES (3852,'Corpus Christi','USA','Texas',277454);
INSERT INTO `city_7` VALUES (3853,'Aurora','USA','Colorado',276393);
INSERT INTO `city_7` VALUES (3854,'Raleigh','USA','North Carolina',276093);
INSERT INTO `city_7` VALUES (3855,'Newark','USA','New Jersey',273546);
INSERT INTO `city_7` VALUES (3856,'Lexington-Fayette','USA','Kentucky',260512);
INSERT INTO `city_7` VALUES (3857,'Anchorage','USA','Alaska',260283);
INSERT INTO `city_7` VALUES (3858,'Louisville','USA','Kentucky',256231);
INSERT INTO `city_7` VALUES (3859,'Riverside','USA','California',255166);
INSERT INTO `city_7` VALUES (3860,'Saint Petersburg','USA','Florida',248232);
INSERT INTO `city_7` VALUES (3861,'Bakersfield','USA','California',247057);
INSERT INTO `city_7` VALUES (3862,'Stockton','USA','California',243771);
INSERT INTO `city_7` VALUES (3863,'Birmingham','USA','Alabama',242820);
INSERT INTO `city_7` VALUES (3864,'Jersey city_7','USA','New Jersey',240055);
INSERT INTO `city_7` VALUES (3865,'Norfolk','USA','Virginia',234403);
INSERT INTO `city_7` VALUES (3866,'Baton Rouge','USA','Louisiana',227818);
INSERT INTO `city_7` VALUES (3867,'Hialeah','USA','Florida',226419);
INSERT INTO `city_7` VALUES (3868,'Lincoln','USA','Nebraska',225581);
INSERT INTO `city_7` VALUES (3869,'Greensboro','USA','North Carolina',223891);
INSERT INTO `city_7` VALUES (3870,'Plano','USA','Texas',222030);
INSERT INTO `city_7` VALUES (3871,'Rochester','USA','New York',219773);
INSERT INTO `city_7` VALUES (3872,'Glendale','USA','Arizona',218812);
INSERT INTO `city_7` VALUES (3873,'Akron','USA','Ohio',217074);
INSERT INTO `city_7` VALUES (3874,'Garland','USA','Texas',215768);
INSERT INTO `city_7` VALUES (3875,'Madison','USA','Wisconsin',208054);
INSERT INTO `city_7` VALUES (3876,'Fort Wayne','USA','Indiana',205727);
INSERT INTO `city_7` VALUES (3877,'Fremont','USA','California',203413);
INSERT INTO `city_7` VALUES (3878,'Scottsdale','USA','Arizona',202705);
INSERT INTO `city_7` VALUES (3879,'Montgomery','USA','Alabama',201568);
INSERT INTO `city_7` VALUES (3880,'Shreveport','USA','Louisiana',200145);
INSERT INTO `city_7` VALUES (3881,'Augusta-Richmond County','USA','Georgia',199775);
INSERT INTO `city_7` VALUES (3882,'Lubbock','USA','Texas',199564);
INSERT INTO `city_7` VALUES (3883,'Chesapeake','USA','Virginia',199184);
INSERT INTO `city_7` VALUES (3884,'Mobile','USA','Alabama',198915);
INSERT INTO `city_7` VALUES (3885,'Des Moines','USA','Iowa',198682);
INSERT INTO `city_7` VALUES (3886,'Grand Rapids','USA','Michigan',197800);
INSERT INTO `city_7` VALUES (3887,'Richmond','USA','Virginia',197790);
INSERT INTO `city_7` VALUES (3888,'Yonkers','USA','New York',196086);
INSERT INTO `city_7` VALUES (3889,'Spokane','USA','Washington',195629);
INSERT INTO `city_7` VALUES (3890,'Glendale','USA','California',194973);
INSERT INTO `city_7` VALUES (3891,'Tacoma','USA','Washington',193556);
INSERT INTO `city_7` VALUES (3892,'Irving','USA','Texas',191615);
INSERT INTO `city_7` VALUES (3893,'Huntington Beach','USA','California',189594);
INSERT INTO `city_7` VALUES (3894,'Modesto','USA','California',188856);
INSERT INTO `city_7` VALUES (3895,'Durham','USA','North Carolina',187035);
INSERT INTO `city_7` VALUES (3896,'Columbus','USA','Georgia',186291);
INSERT INTO `city_7` VALUES (3897,'Orlando','USA','Florida',185951);
INSERT INTO `city_7` VALUES (3898,'Boise city_7','USA','Idaho',185787);
INSERT INTO `city_7` VALUES (3899,'Winston-Salem','USA','North Carolina',185776);
INSERT INTO `city_7` VALUES (3900,'San Bernardino','USA','California',185401);
INSERT INTO `city_7` VALUES (3901,'Jackson','USA','Mississippi',184256);
INSERT INTO `city_7` VALUES (3902,'Little Rock','USA','Arkansas',183133);
INSERT INTO `city_7` VALUES (3903,'Salt Lake city_7','USA','Utah',181743);
INSERT INTO `city_7` VALUES (3904,'Reno','USA','Nevada',180480);
INSERT INTO `city_7` VALUES (3905,'Newport News','USA','Virginia',180150);
INSERT INTO `city_7` VALUES (3906,'Chandler','USA','Arizona',176581);
INSERT INTO `city_7` VALUES (3907,'Laredo','USA','Texas',176576);
INSERT INTO `city_7` VALUES (3908,'Henderson','USA','Nevada',175381);
INSERT INTO `city_7` VALUES (3909,'Arlington','USA','Virginia',174838);
INSERT INTO `city_7` VALUES (3910,'Knoxville','USA','Tennessee',173890);
INSERT INTO `city_7` VALUES (3911,'Amarillo','USA','Texas',173627);
INSERT INTO `city_7` VALUES (3912,'Providence','USA','Rhode Island',173618);
INSERT INTO `city_7` VALUES (3913,'Chula Vista','USA','California',173556);
INSERT INTO `city_7` VALUES (3914,'Worcester','USA','Massachusetts',172648);
INSERT INTO `city_7` VALUES (3915,'Oxnard','USA','California',170358);
INSERT INTO `city_7` VALUES (3916,'Dayton','USA','Ohio',166179);
INSERT INTO `city_7` VALUES (3917,'Garden Grove','USA','California',165196);
INSERT INTO `city_7` VALUES (3918,'Oceanside','USA','California',161029);
INSERT INTO `city_7` VALUES (3919,'Tempe','USA','Arizona',158625);
INSERT INTO `city_7` VALUES (3920,'Huntsville','USA','Alabama',158216);
INSERT INTO `city_7` VALUES (3921,'Ontario','USA','California',158007);
INSERT INTO `city_7` VALUES (3922,'Chattanooga','USA','Tennessee',155554);
INSERT INTO `city_7` VALUES (3923,'Fort Lauderdale','USA','Florida',152397);
INSERT INTO `city_7` VALUES (3924,'Springfield','USA','Massachusetts',152082);
INSERT INTO `city_7` VALUES (3925,'Springfield','USA','Missouri',151580);
INSERT INTO `city_7` VALUES (3926,'Santa Clarita','USA','California',151088);
INSERT INTO `city_7` VALUES (3927,'Salinas','USA','California',151060);
INSERT INTO `city_7` VALUES (3928,'Tallahassee','USA','Florida',150624);
INSERT INTO `city_7` VALUES (3929,'Rockford','USA','Illinois',150115);
INSERT INTO `city_7` VALUES (3930,'Pomona','USA','California',149473);
INSERT INTO `city_7` VALUES (3931,'Metairie','USA','Louisiana',149428);
INSERT INTO `city_7` VALUES (3932,'Paterson','USA','New Jersey',149222);
INSERT INTO `city_7` VALUES (3933,'Overland Park','USA','Kansas',149080);
INSERT INTO `city_7` VALUES (3934,'Santa Rosa','USA','California',147595);
INSERT INTO `city_7` VALUES (3935,'Syracuse','USA','New York',147306);
INSERT INTO `city_7` VALUES (3936,'Kansas city_7','USA','Kansas',146866);
INSERT INTO `city_7` VALUES (3937,'Hampton','USA','Virginia',146437);
INSERT INTO `city_7` VALUES (3938,'Lakewood','USA','Colorado',144126);
INSERT INTO `city_7` VALUES (3939,'Vancouver','USA','Washington',143560);
INSERT INTO `city_7` VALUES (3940,'Irvine','USA','California',143072);
INSERT INTO `city_7` VALUES (3941,'Aurora','USA','Illinois',142990);
INSERT INTO `city_7` VALUES (3942,'Moreno Valley','USA','California',142381);
INSERT INTO `city_7` VALUES (3943,'Pasadena','USA','California',141674);
INSERT INTO `city_7` VALUES (3944,'Hayward','USA','California',140030);
INSERT INTO `city_7` VALUES (3945,'Brownsville','USA','Texas',139722);
INSERT INTO `city_7` VALUES (3946,'Bridgeport','USA','Connecticut',139529);
INSERT INTO `city_7` VALUES (3947,'Hollywood','USA','Florida',139357);
INSERT INTO `city_7` VALUES (3948,'Warren','USA','Michigan',138247);
INSERT INTO `city_7` VALUES (3949,'Torrance','USA','California',137946);
INSERT INTO `city_7` VALUES (3950,'Eugene','USA','Oregon',137893);
INSERT INTO `city_7` VALUES (3951,'Pembroke Pines','USA','Florida',137427);
INSERT INTO `city_7` VALUES (3952,'Salem','USA','Oregon',136924);
INSERT INTO `city_7` VALUES (3953,'Pasadena','USA','Texas',133936);
INSERT INTO `city_7` VALUES (3954,'Escondido','USA','California',133559);
INSERT INTO `city_7` VALUES (3955,'Sunnyvale','USA','California',131760);
INSERT INTO `city_7` VALUES (3956,'Savannah','USA','Georgia',131510);
INSERT INTO `city_7` VALUES (3957,'Fontana','USA','California',128929);
INSERT INTO `city_7` VALUES (3958,'Orange','USA','California',128821);
INSERT INTO `city_7` VALUES (3959,'Naperville','USA','Illinois',128358);
INSERT INTO `city_7` VALUES (3960,'Alexandria','USA','Virginia',128283);
INSERT INTO `city_7` VALUES (3961,'Rancho Cucamonga','USA','California',127743);
INSERT INTO `city_7` VALUES (3962,'Grand Prairie','USA','Texas',127427);
INSERT INTO `city_7` VALUES (3963,'East Los Angeles','USA','California',126379);
INSERT INTO `city_7` VALUES (3964,'Fullerton','USA','California',126003);
INSERT INTO `city_7` VALUES (3965,'Corona','USA','California',124966);
INSERT INTO `city_7` VALUES (3966,'Flint','USA','Michigan',124943);
INSERT INTO `city_7` VALUES (3967,'Paradise','USA','Nevada',124682);
INSERT INTO `city_7` VALUES (3968,'Mesquite','USA','Texas',124523);
INSERT INTO `city_7` VALUES (3969,'Sterling Heights','USA','Michigan',124471);
INSERT INTO `city_7` VALUES (3970,'Sioux Falls','USA','South Dakota',123975);
INSERT INTO `city_7` VALUES (3971,'New Haven','USA','Connecticut',123626);
INSERT INTO `city_7` VALUES (3972,'Topeka','USA','Kansas',122377);
INSERT INTO `city_7` VALUES (3973,'Concord','USA','California',121780);
INSERT INTO `city_7` VALUES (3974,'Evansville','USA','Indiana',121582);
INSERT INTO `city_7` VALUES (3975,'Hartford','USA','Connecticut',121578);
INSERT INTO `city_7` VALUES (3976,'Fayetteville','USA','North Carolina',121015);
INSERT INTO `city_7` VALUES (3977,'Cedar Rapids','USA','Iowa',120758);
INSERT INTO `city_7` VALUES (3978,'Elizabeth','USA','New Jersey',120568);
INSERT INTO `city_7` VALUES (3979,'Lansing','USA','Michigan',119128);
INSERT INTO `city_7` VALUES (3980,'Lancaster','USA','California',118718);
INSERT INTO `city_7` VALUES (3981,'Fort Collins','USA','Colorado',118652);
INSERT INTO `city_7` VALUES (3982,'Coral Springs','USA','Florida',117549);
INSERT INTO `city_7` VALUES (3983,'Stamford','USA','Connecticut',117083);
INSERT INTO `city_7` VALUES (3984,'Thousand Oaks','USA','California',117005);
INSERT INTO `city_7` VALUES (3985,'Vallejo','USA','California',116760);
INSERT INTO `city_7` VALUES (3986,'Palmdale','USA','California',116670);
INSERT INTO `city_7` VALUES (3987,'Columbia','USA','South Carolina',116278);
INSERT INTO `city_7` VALUES (3988,'El Monte','USA','California',115965);
INSERT INTO `city_7` VALUES (3989,'Abilene','USA','Texas',115930);
INSERT INTO `city_7` VALUES (3990,'North Las Vegas','USA','Nevada',115488);
INSERT INTO `city_7` VALUES (3991,'Ann Arbor','USA','Michigan',114024);
INSERT INTO `city_7` VALUES (3992,'Beaumont','USA','Texas',113866);
INSERT INTO `city_7` VALUES (3993,'Waco','USA','Texas',113726);
INSERT INTO `city_7` VALUES (3994,'Macon','USA','Georgia',113336);
INSERT INTO `city_7` VALUES (3995,'Independence','USA','Missouri',113288);
INSERT INTO `city_7` VALUES (3996,'Peoria','USA','Illinois',112936);
INSERT INTO `city_7` VALUES (3997,'Inglewood','USA','California',112580);
INSERT INTO `city_7` VALUES (3998,'Springfield','USA','Illinois',111454);
INSERT INTO `city_7` VALUES (3999,'Simi Valley','USA','California',111351);
COMMIT;

-- ----------------------------
-- Table structure for city_8
-- ----------------------------
DROP TABLE IF EXISTS `city_8`;
CREATE TABLE `city_8` (
                          `id` bigint NOT NULL DEFAULT '0',
                          `name` char(35) NOT NULL DEFAULT '',
                          `country_code` char(3) NOT NULL DEFAULT '',
                          `district` char(20) NOT NULL DEFAULT '',
                          `population` int NOT NULL DEFAULT '0',
                          PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of city_8
-- ----------------------------
BEGIN;
INSERT INTO `city_8` VALUES (4000,'Lafayette','USA','Louisiana',110257);
INSERT INTO `city_8` VALUES (4001,'Gilbert','USA','Arizona',109697);
INSERT INTO `city_8` VALUES (4002,'Carrollton','USA','Texas',109576);
INSERT INTO `city_8` VALUES (4003,'Bellevue','USA','Washington',109569);
INSERT INTO `city_8` VALUES (4004,'West Valley city_8','USA','Utah',108896);
INSERT INTO `city_8` VALUES (4005,'Clarksville','USA','Tennessee',108787);
INSERT INTO `city_8` VALUES (4006,'Costa Mesa','USA','California',108724);
INSERT INTO `city_8` VALUES (4007,'Peoria','USA','Arizona',108364);
INSERT INTO `city_8` VALUES (4008,'South Bend','USA','Indiana',107789);
INSERT INTO `city_8` VALUES (4009,'Downey','USA','California',107323);
INSERT INTO `city_8` VALUES (4010,'Waterbury','USA','Connecticut',107271);
INSERT INTO `city_8` VALUES (4011,'Manchester','USA','New Hampshire',107006);
INSERT INTO `city_8` VALUES (4012,'Allentown','USA','Pennsylvania',106632);
INSERT INTO `city_8` VALUES (4013,'McAllen','USA','Texas',106414);
INSERT INTO `city_8` VALUES (4014,'Joliet','USA','Illinois',106221);
INSERT INTO `city_8` VALUES (4015,'Lowell','USA','Massachusetts',105167);
INSERT INTO `city_8` VALUES (4016,'Provo','USA','Utah',105166);
INSERT INTO `city_8` VALUES (4017,'West Covina','USA','California',105080);
INSERT INTO `city_8` VALUES (4018,'Wichita Falls','USA','Texas',104197);
INSERT INTO `city_8` VALUES (4019,'Erie','USA','Pennsylvania',103717);
INSERT INTO `city_8` VALUES (4020,'Daly city_8','USA','California',103621);
INSERT INTO `city_8` VALUES (4021,'Citrus Heights','USA','California',103455);
INSERT INTO `city_8` VALUES (4022,'Norwalk','USA','California',103298);
INSERT INTO `city_8` VALUES (4023,'Gary','USA','Indiana',102746);
INSERT INTO `city_8` VALUES (4024,'Berkeley','USA','California',102743);
INSERT INTO `city_8` VALUES (4025,'Santa Clara','USA','California',102361);
INSERT INTO `city_8` VALUES (4026,'Green Bay','USA','Wisconsin',102313);
INSERT INTO `city_8` VALUES (4027,'Cape Coral','USA','Florida',102286);
INSERT INTO `city_8` VALUES (4028,'Arvada','USA','Colorado',102153);
INSERT INTO `city_8` VALUES (4029,'Pueblo','USA','Colorado',102121);
INSERT INTO `city_8` VALUES (4030,'Sandy','USA','Utah',101853);
INSERT INTO `city_8` VALUES (4031,'Athens-Clarke County','USA','Georgia',101489);
INSERT INTO `city_8` VALUES (4032,'Cambridge','USA','Massachusetts',101355);
INSERT INTO `city_8` VALUES (4033,'Westminster','USA','Colorado',100940);
INSERT INTO `city_8` VALUES (4034,'San Buenaventura','USA','California',100916);
INSERT INTO `city_8` VALUES (4035,'Portsmouth','USA','Virginia',100565);
INSERT INTO `city_8` VALUES (4036,'Livonia','USA','Michigan',100545);
INSERT INTO `city_8` VALUES (4037,'Burbank','USA','California',100316);
INSERT INTO `city_8` VALUES (4038,'Clearwater','USA','Florida',99936);
INSERT INTO `city_8` VALUES (4039,'Midland','USA','Texas',98293);
INSERT INTO `city_8` VALUES (4040,'Davenport','USA','Iowa',98256);
INSERT INTO `city_8` VALUES (4041,'Mission Viejo','USA','California',98049);
INSERT INTO `city_8` VALUES (4042,'Miami Beach','USA','Florida',97855);
INSERT INTO `city_8` VALUES (4043,'Sunrise Manor','USA','Nevada',95362);
INSERT INTO `city_8` VALUES (4044,'New Bedford','USA','Massachusetts',94780);
INSERT INTO `city_8` VALUES (4045,'El Cajon','USA','California',94578);
INSERT INTO `city_8` VALUES (4046,'Norman','USA','Oklahoma',94193);
INSERT INTO `city_8` VALUES (4047,'Richmond','USA','California',94100);
INSERT INTO `city_8` VALUES (4048,'Albany','USA','New York',93994);
INSERT INTO `city_8` VALUES (4049,'Brockton','USA','Massachusetts',93653);
INSERT INTO `city_8` VALUES (4050,'Roanoke','USA','Virginia',93357);
INSERT INTO `city_8` VALUES (4051,'Billings','USA','Montana',92988);
INSERT INTO `city_8` VALUES (4052,'Compton','USA','California',92864);
INSERT INTO `city_8` VALUES (4053,'Gainesville','USA','Florida',92291);
INSERT INTO `city_8` VALUES (4054,'Fairfield','USA','California',92256);
INSERT INTO `city_8` VALUES (4055,'Arden-Arcade','USA','California',92040);
INSERT INTO `city_8` VALUES (4056,'San Mateo','USA','California',91799);
INSERT INTO `city_8` VALUES (4057,'Visalia','USA','California',91762);
INSERT INTO `city_8` VALUES (4058,'Boulder','USA','Colorado',91238);
INSERT INTO `city_8` VALUES (4059,'Cary','USA','North Carolina',91213);
INSERT INTO `city_8` VALUES (4060,'Santa Monica','USA','California',91084);
INSERT INTO `city_8` VALUES (4061,'Fall River','USA','Massachusetts',90555);
INSERT INTO `city_8` VALUES (4062,'Kenosha','USA','Wisconsin',89447);
INSERT INTO `city_8` VALUES (4063,'Elgin','USA','Illinois',89408);
INSERT INTO `city_8` VALUES (4064,'Odessa','USA','Texas',89293);
INSERT INTO `city_8` VALUES (4065,'Carson','USA','California',89089);
INSERT INTO `city_8` VALUES (4066,'Charleston','USA','South Carolina',89063);
INSERT INTO `city_8` VALUES (4067,'Charlotte Amalie','VIR','St Thomas',13000);
INSERT INTO `city_8` VALUES (4068,'Harare','ZWE','Harare',1410000);
INSERT INTO `city_8` VALUES (4069,'Bulawayo','ZWE','Bulawayo',621742);
INSERT INTO `city_8` VALUES (4070,'Chitungwiza','ZWE','Harare',274912);
INSERT INTO `city_8` VALUES (4071,'Mount Darwin','ZWE','Harare',164362);
INSERT INTO `city_8` VALUES (4072,'Mutare','ZWE','Manicaland',131367);
INSERT INTO `city_8` VALUES (4073,'Gweru','ZWE','Midlands',128037);
INSERT INTO `city_8` VALUES (4074,'Gaza','PSE','Gaza',353632);
INSERT INTO `city_8` VALUES (4075,'Khan Yunis','PSE','Khan Yunis',123175);
INSERT INTO `city_8` VALUES (4076,'Hebron','PSE','Hebron',119401);
INSERT INTO `city_8` VALUES (4077,'Jabaliya','PSE','North Gaza',113901);
INSERT INTO `city_8` VALUES (4078,'Nablus','PSE','Nablus',100231);
INSERT INTO `city_8` VALUES (4079,'Rafah','PSE','Rafah',92020);
COMMIT;

-- ----------------------------
-- Table structure for city_9
-- ----------------------------
DROP TABLE IF EXISTS `city_9`;
CREATE TABLE `city_9` (
                          `id` bigint NOT NULL DEFAULT '0',
                          `name` char(35) NOT NULL DEFAULT '',
                          `country_code` char(3) NOT NULL DEFAULT '',
                          `district` char(20) NOT NULL DEFAULT '',
                          `population` int NOT NULL DEFAULT '0',
                          PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Table structure for country
-- ----------------------------
DROP TABLE IF EXISTS `country`;
CREATE TABLE `country` (
                           `code` char(3) NOT NULL DEFAULT '',
                           `name` char(52) NOT NULL DEFAULT '',
                           `continent` enum('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') NOT NULL DEFAULT 'Asia',
                           `region` char(26) NOT NULL DEFAULT '',
                           `surface_area` decimal(10,2) NOT NULL DEFAULT '0.00',
                           `indep_year` smallint DEFAULT NULL,
                           `population` int NOT NULL DEFAULT '0',
                           `life_expectancy` decimal(3,1) DEFAULT NULL,
                           `gnp` decimal(10,2) DEFAULT NULL,
                           `gnp_old` decimal(10,2) DEFAULT NULL,
                           `local_name` char(45) NOT NULL DEFAULT '',
                           `government_form` char(45) NOT NULL DEFAULT '',
                           `head_of_state` char(60) DEFAULT NULL,
                           `capital` int DEFAULT NULL,
                           `code2` char(2) NOT NULL DEFAULT '',
                           PRIMARY KEY (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of country
-- ----------------------------
BEGIN;
INSERT INTO `country` VALUES ('ABW', 'Aruba', 'North America', 'Caribbean', 193.00, NULL, 103000, 78.4, 828.00, 793.00, 'Aruba', 'Nonmetropolitan Territory of The Netherlands', 'Beatrix', 129, 'AW');
INSERT INTO `country` VALUES ('AFG', 'Afghanistan', 'Asia', 'Southern and Central Asia', 652090.00, 1919, 22720000, 45.9, 5976.00, NULL, 'Afganistan/Afqanestan', 'Islamic Emirate', 'Mohammad Omar', 1, 'AF');
INSERT INTO `country` VALUES ('AGO', 'Angola', 'Africa', 'Central Africa', 1246700.00, 1975, 12878000, 38.3, 6648.00, 7984.00, 'Angola', 'Republic', 'José Eduardo dos Santos', 56, 'AO');
INSERT INTO `country` VALUES ('AIA', 'Anguilla', 'North America', 'Caribbean', 96.00, NULL, 8000, 76.1, 63.20, NULL, 'Anguilla', 'Dependent Territory of the UK', 'Elisabeth II', 62, 'AI');
INSERT INTO `country` VALUES ('ALB', 'Albania', 'Europe', 'Southern Europe', 28748.00, 1912, 3401200, 71.6, 3205.00, 2500.00, 'Shqipëria', 'Republic', 'Rexhep Mejdani', 34, 'AL');
INSERT INTO `country` VALUES ('AND', 'Andorra', 'Europe', 'Southern Europe', 468.00, 1278, 78000, 83.5, 1630.00, NULL, 'Andorra', 'Parliamentary Coprincipality', '', 55, 'AD');
INSERT INTO `country` VALUES ('ANT', 'Netherlands Antilles', 'North America', 'Caribbean', 800.00, NULL, 217000, 74.7, 1941.00, NULL, 'Nederlandse Antillen', 'Nonmetropolitan Territory of The Netherlands', 'Beatrix', 33, 'AN');
INSERT INTO `country` VALUES ('ARE', 'United Arab Emirates', 'Asia', 'Middle East', 83600.00, 1971, 2441000, 74.1, 37966.00, 36846.00, 'Al-Imarat al-´Arabiya al-Muttahida', 'Emirate Federation', 'Zayid bin Sultan al-Nahayan', 65, 'AE');
INSERT INTO `country` VALUES ('ARG', 'Argentina', 'South America', 'South America', 2780400.00, 1816, 37032000, 75.1, 340238.00, 323310.00, 'Argentina', 'Federal Republic', 'Fernando de la Rúa', 69, 'AR');
INSERT INTO `country` VALUES ('ARM', 'Armenia', 'Asia', 'Middle East', 29800.00, 1991, 3520000, 66.4, 1813.00, 1627.00, 'Hajastan', 'Republic', 'Robert Kotšarjan', 126, 'AM');
INSERT INTO `country` VALUES ('ASM', 'American Samoa', 'Oceania', 'Polynesia', 199.00, NULL, 68000, 75.1, 334.00, NULL, 'Amerika Samoa', 'US Territory', 'George W. Bush', 54, 'AS');
INSERT INTO `country` VALUES ('ATA', 'Antarctica', 'Antarctica', 'Antarctica', 13120000.00, NULL, 0, NULL, 0.00, NULL, '–', 'Co-administrated', '', NULL, 'AQ');
INSERT INTO `country` VALUES ('ATF', 'French Southern territories', 'Antarctica', 'Antarctica', 7780.00, NULL, 0, NULL, 0.00, NULL, 'Terres australes françaises', 'Nonmetropolitan Territory of France', 'Jacques Chirac', NULL, 'TF');
INSERT INTO `country` VALUES ('ATG', 'Antigua and Barbuda', 'North America', 'Caribbean', 442.00, 1981, 68000, 70.5, 612.00, 584.00, 'Antigua and Barbuda', 'Constitutional Monarchy', 'Elisabeth II', 63, 'AG');
INSERT INTO `country` VALUES ('AUS', 'Australia', 'Oceania', 'Australia and New Zealand', 7741220.00, 1901, 18886000, 79.8, 351182.00, 392911.00, 'Australia', 'Constitutional Monarchy, Federation', 'Elisabeth II', 135, 'AU');
INSERT INTO `country` VALUES ('AUT', 'Austria', 'Europe', 'Western Europe', 83859.00, 1918, 8091800, 77.7, 211860.00, 206025.00, 'Österreich', 'Federal Republic', 'Thomas Klestil', 1523, 'AT');
INSERT INTO `country` VALUES ('AZE', 'Azerbaijan', 'Asia', 'Middle East', 86600.00, 1991, 7734000, 62.9, 4127.00, 4100.00, 'Azärbaycan', 'Federal Republic', 'Heydär Äliyev', 144, 'AZ');
INSERT INTO `country` VALUES ('BDI', 'Burundi', 'Africa', 'Eastern Africa', 27834.00, 1962, 6695000, 46.2, 903.00, 982.00, 'Burundi/Uburundi', 'Republic', 'Pierre Buyoya', 552, 'BI');
INSERT INTO `country` VALUES ('BEL', 'Belgium', 'Europe', 'Western Europe', 30518.00, 1830, 10239000, 77.8, 249704.00, 243948.00, 'België/Belgique', 'Constitutional Monarchy, Federation', 'Albert II', 179, 'BE');
INSERT INTO `country` VALUES ('BEN', 'Benin', 'Africa', 'Western Africa', 112622.00, 1960, 6097000, 50.2, 2357.00, 2141.00, 'Bénin', 'Republic', 'Mathieu Kérékou', 187, 'BJ');
INSERT INTO `country` VALUES ('BFA', 'Burkina Faso', 'Africa', 'Western Africa', 274000.00, 1960, 11937000, 46.7, 2425.00, 2201.00, 'Burkina Faso', 'Republic', 'Blaise Compaoré', 549, 'BF');
INSERT INTO `country` VALUES ('BGD', 'Bangladesh', 'Asia', 'Southern and Central Asia', 143998.00, 1971, 129155000, 60.2, 32852.00, 31966.00, 'Bangladesh', 'Republic', 'Shahabuddin Ahmad', 150, 'BD');
INSERT INTO `country` VALUES ('BGR', 'Bulgaria', 'Europe', 'Eastern Europe', 110994.00, 1908, 8190900, 70.9, 12178.00, 10169.00, 'Balgarija', 'Republic', 'Petar Stojanov', 539, 'BG');
INSERT INTO `country` VALUES ('BHR', 'Bahrain', 'Asia', 'Middle East', 694.00, 1971, 617000, 73.0, 6366.00, 6097.00, 'Al-Bahrayn', 'Monarchy (Emirate)', 'Hamad ibn Isa al-Khalifa', 149, 'BH');
INSERT INTO `country` VALUES ('BHS', 'Bahamas', 'North America', 'Caribbean', 13878.00, 1973, 307000, 71.1, 3527.00, 3347.00, 'The Bahamas', 'Constitutional Monarchy', 'Elisabeth II', 148, 'BS');
INSERT INTO `country` VALUES ('BIH', 'Bosnia and Herzegovina', 'Europe', 'Southern Europe', 51197.00, 1992, 3972000, 71.5, 2841.00, NULL, 'Bosna i Hercegovina', 'Federal Republic', 'Ante Jelavic', 201, 'BA');
INSERT INTO `country` VALUES ('BLR', 'Belarus', 'Europe', 'Eastern Europe', 207600.00, 1991, 10236000, 68.0, 13714.00, NULL, 'Belarus', 'Republic', 'Aljaksandr Lukašenka', 3520, 'BY');
INSERT INTO `country` VALUES ('BLZ', 'Belize', 'North America', 'Central America', 22696.00, 1981, 241000, 70.9, 630.00, 616.00, 'Belize', 'Constitutional Monarchy', 'Elisabeth II', 185, 'BZ');
INSERT INTO `country` VALUES ('BMU', 'Bermuda', 'North America', 'North America', 53.00, NULL, 65000, 76.9, 2328.00, 2190.00, 'Bermuda', 'Dependent Territory of the UK', 'Elisabeth II', 191, 'BM');
INSERT INTO `country` VALUES ('BOL', 'Bolivia', 'South America', 'South America', 1098581.00, 1825, 8329000, 63.7, 8571.00, 7967.00, 'Bolivia', 'Republic', 'Hugo Bánzer Suárez', 194, 'BO');
INSERT INTO `country` VALUES ('BRA', 'Brazil', 'South America', 'South America', 8547403.00, 1822, 170115000, 62.9, 776739.00, 804108.00, 'Brasil', 'Federal Republic', 'Fernando Henrique Cardoso', 211, 'BR');
INSERT INTO `country` VALUES ('BRB', 'Barbados', 'North America', 'Caribbean', 430.00, 1966, 270000, 73.0, 2223.00, 2186.00, 'Barbados', 'Constitutional Monarchy', 'Elisabeth II', 174, 'BB');
INSERT INTO `country` VALUES ('BRN', 'Brunei', 'Asia', 'Southeast Asia', 5765.00, 1984, 328000, 73.6, 11705.00, 12460.00, 'Brunei Darussalam', 'Monarchy (Sultanate)', 'Haji Hassan al-Bolkiah', 538, 'BN');
INSERT INTO `country` VALUES ('BTN', 'Bhutan', 'Asia', 'Southern and Central Asia', 47000.00, 1910, 2124000, 52.4, 372.00, 383.00, 'Druk-Yul', 'Monarchy', 'Jigme Singye Wangchuk', 192, 'BT');
INSERT INTO `country` VALUES ('BVT', 'Bouvet Island', 'Antarctica', 'Antarctica', 59.00, NULL, 0, NULL, 0.00, NULL, 'Bouvetøya', 'Dependent Territory of Norway', 'Harald V', NULL, 'BV');
INSERT INTO `country` VALUES ('BWA', 'Botswana', 'Africa', 'Southern Africa', 581730.00, 1966, 1622000, 39.3, 4834.00, 4935.00, 'Botswana', 'Republic', 'Festus G. Mogae', 204, 'BW');
INSERT INTO `country` VALUES ('CAF', 'Central African Republic', 'Africa', 'Central Africa', 622984.00, 1960, 3615000, 44.0, 1054.00, 993.00, 'Centrafrique/Bê-Afrîka', 'Republic', 'Ange-Félix Patassé', 1889, 'CF');
INSERT INTO `country` VALUES ('CAN', 'Canada', 'North America', 'North America', 9970610.00, 1867, 31147000, 79.4, 598862.00, 625626.00, 'Canada', 'Constitutional Monarchy, Federation', 'Elisabeth II', 1822, 'CA');
INSERT INTO `country` VALUES ('CCK', 'Cocos (Keeling) Islands', 'Oceania', 'Australia and New Zealand', 14.00, NULL, 600, NULL, 0.00, NULL, 'Cocos (Keeling) Islands', 'Territory of Australia', 'Elisabeth II', 2317, 'CC');
INSERT INTO `country` VALUES ('CHE', 'Switzerland', 'Europe', 'Western Europe', 41284.00, 1499, 7160400, 79.6, 264478.00, 256092.00, 'Schweiz/Suisse/Svizzera/Svizra', 'Federation', 'Adolf Ogi', 3248, 'CH');
INSERT INTO `country` VALUES ('CHL', 'Chile', 'South America', 'South America', 756626.00, 1810, 15211000, 75.7, 72949.00, 75780.00, 'Chile', 'Republic', 'Ricardo Lagos Escobar', 554, 'CL');
INSERT INTO `country` VALUES ('CHN', 'China', 'Asia', 'Eastern Asia', 9572900.00, -1523, 1277558000, 71.4, 982268.00, 917719.00, 'Zhongquo', 'People\'sRepublic', 'Jiang Zemin', 1891, 'CN');
INSERT INTO `country` VALUES ('CIV', 'Côte d’Ivoire', 'Africa', 'Western Africa', 322463.00, 1960, 14786000, 45.2, 11345.00, 10285.00, 'Côte d’Ivoire', 'Republic', 'Laurent Gbagbo', 2814, 'CI');
INSERT INTO `country` VALUES ('CMR', 'Cameroon', 'Africa', 'Central Africa', 475442.00, 1960, 15085000, 54.8, 9174.00, 8596.00, 'Cameroun/Cameroon', 'Republic', 'Paul Biya', 1804, 'CM');
INSERT INTO `country` VALUES ('COD', 'Congo, The Democratic Republic of the', 'Africa', 'Central Africa', 2344858.00, 1960, 51654000, 48.8, 6964.00, 2474.00, 'République Démocratique du Congo', 'Republic', 'Joseph Kabila', 2298, 'CD');
INSERT INTO `country` VALUES ('COG', 'Congo', 'Africa', 'Central Africa', 342000.00, 1960, 2943000, 47.4, 2108.00, 2287.00, 'Congo', 'Republic', 'Denis Sassou-Nguesso', 2296, 'CG');
INSERT INTO `country` VALUES ('COK', 'Cook Islands', 'Oceania', 'Polynesia', 236.00, NULL, 20000, 71.1, 100.00, NULL, 'The Cook Islands', 'Nonmetropolitan Territory of New Zealand', 'Elisabeth II', 583, 'CK');
INSERT INTO `country` VALUES ('COL', 'Colombia', 'South America', 'South America', 1138914.00, 1810, 42321000, 70.3, 102896.00, 105116.00, 'Colombia', 'Republic', 'Andrés Pastrana Arango', 2257, 'CO');
INSERT INTO `country` VALUES ('COM', 'Comoros', 'Africa', 'Eastern Africa', 1862.00, 1975, 578000, 60.0, 4401.00, 4361.00, 'Komori/Comores', 'Republic', 'Azali Assoumani', 2295, 'KM');
INSERT INTO `country` VALUES ('CPV', 'Cape Verde', 'Africa', 'Western Africa', 4033.00, 1975, 428000, 68.9, 435.00, 420.00, 'Cabo Verde', 'Republic', 'António Mascarenhas Monteiro', 1859, 'CV');
INSERT INTO `country` VALUES ('CRI', 'Costa Rica', 'North America', 'Central America', 51100.00, 1821, 4023000, 75.8, 10226.00, 9757.00, 'Costa Rica', 'Republic', 'Miguel Ángel Rodríguez Echeverría', 584, 'CR');
INSERT INTO `country` VALUES ('CUB', 'Cuba', 'North America', 'Caribbean', 110861.00, 1902, 11201000, 76.2, 17843.00, 18862.00, 'Cuba', 'Socialistic Republic', 'Fidel Castro Ruz', 2413, 'CU');
INSERT INTO `country` VALUES ('CXR', 'Christmas Island', 'Oceania', 'Australia and New Zealand', 135.00, NULL, 2500, NULL, 0.00, NULL, 'Christmas Island', 'Territory of Australia', 'Elisabeth II', 1791, 'CX');
INSERT INTO `country` VALUES ('CYM', 'Cayman Islands', 'North America', 'Caribbean', 264.00, NULL, 38000, 78.9, 1263.00, 1186.00, 'Cayman Islands', 'Dependent Territory of the UK', 'Elisabeth II', 553, 'KY');
INSERT INTO `country` VALUES ('CYP', 'Cyprus', 'Asia', 'Middle East', 9251.00, 1960, 754700, 76.7, 9333.00, 8246.00, 'Kýpros/Kibris', 'Republic', 'Glafkos Klerides', 2430, 'CY');
INSERT INTO `country` VALUES ('CZE', 'Czech Republic', 'Europe', 'Eastern Europe', 78866.00, 1993, 10278100, 74.5, 55017.00, 52037.00, '¸esko', 'Republic', 'Václav Havel', 3339, 'CZ');
INSERT INTO `country` VALUES ('DEU', 'Germany', 'Europe', 'Western Europe', 357022.00, 1955, 82164700, 77.4, 2133367.00, 2102826.00, 'Deutschland', 'Federal Republic', 'Johannes Rau', 3068, 'DE');
INSERT INTO `country` VALUES ('DJI', 'Djibouti', 'Africa', 'Eastern Africa', 23200.00, 1977, 638000, 50.8, 382.00, 373.00, 'Djibouti/Jibuti', 'Republic', 'Ismail Omar Guelleh', 585, 'DJ');
INSERT INTO `country` VALUES ('DMA', 'Dominica', 'North America', 'Caribbean', 751.00, 1978, 71000, 73.4, 256.00, 243.00, 'Dominica', 'Republic', 'Vernon Shaw', 586, 'DM');
INSERT INTO `country` VALUES ('DNK', 'Denmark', 'Europe', 'Nordic Countries', 43094.00, 800, 5330000, 76.5, 174099.00, 169264.00, 'Danmark', 'Constitutional Monarchy', 'Margrethe II', 3315, 'DK');
INSERT INTO `country` VALUES ('DOM', 'Dominican Republic', 'North America', 'Caribbean', 48511.00, 1844, 8495000, 73.2, 15846.00, 15076.00, 'República Dominicana', 'Republic', 'Hipólito Mejía Domínguez', 587, 'DO');
INSERT INTO `country` VALUES ('DZA', 'Algeria', 'Africa', 'Northern Africa', 2381741.00, 1962, 31471000, 69.7, 49982.00, 46966.00, 'Al-Jaza’ir/Algérie', 'Republic', 'Abdelaziz Bouteflika', 35, 'DZ');
INSERT INTO `country` VALUES ('ECU', 'Ecuador', 'South America', 'South America', 283561.00, 1822, 12646000, 71.1, 19770.00, 19769.00, 'Ecuador', 'Republic', 'Gustavo Noboa Bejarano', 594, 'EC');
INSERT INTO `country` VALUES ('EGY', 'Egypt', 'Africa', 'Northern Africa', 1001449.00, 1922, 68470000, 63.3, 82710.00, 75617.00, 'Misr', 'Republic', 'Hosni Mubarak', 608, 'EG');
INSERT INTO `country` VALUES ('ERI', 'Eritrea', 'Africa', 'Eastern Africa', 117600.00, 1993, 3850000, 55.8, 650.00, 755.00, 'Ertra', 'Republic', 'Isayas Afewerki [Isaias Afwerki]', 652, 'ER');
INSERT INTO `country` VALUES ('ESH', 'Western Sahara', 'Africa', 'Northern Africa', 266000.00, NULL, 293000, 49.8, 60.00, NULL, 'As-Sahrawiya', 'Occupied by Marocco', 'Mohammed Abdel Aziz', 2453, 'EH');
INSERT INTO `country` VALUES ('ESP', 'Spain', 'Europe', 'Southern Europe', 505992.00, 1492, 39441700, 78.8, 553233.00, 532031.00, 'España', 'Constitutional Monarchy', 'Juan Carlos I', 653, 'ES');
INSERT INTO `country` VALUES ('EST', 'Estonia', 'Europe', 'Baltic Countries', 45227.00, 1991, 1439200, 69.5, 5328.00, 3371.00, 'Eesti', 'Republic', 'Lennart Meri', 3791, 'EE');
INSERT INTO `country` VALUES ('ETH', 'Ethiopia', 'Africa', 'Eastern Africa', 1104300.00, -1000, 62565000, 45.2, 6353.00, 6180.00, 'YeItyop´iya', 'Republic', 'Negasso Gidada', 756, 'ET');
INSERT INTO `country` VALUES ('FIN', 'Finland', 'Europe', 'Nordic Countries', 338145.00, 1917, 5171300, 77.4, 121914.00, 119833.00, 'Suomi', 'Republic', 'Tarja Halonen', 3236, 'FI');
INSERT INTO `country` VALUES ('FJI', 'Fiji Islands', 'Oceania', 'Melanesia', 18274.00, 1970, 817000, 67.9, 1536.00, 2149.00, 'Fiji Islands', 'Republic', 'Josefa Iloilo', 764, 'FJ');
INSERT INTO `country` VALUES ('FLK', 'Falkland Islands', 'South America', 'South America', 12173.00, NULL, 2000, NULL, 0.00, NULL, 'Falkland Islands', 'Dependent Territory of the UK', 'Elisabeth II', 763, 'FK');
INSERT INTO `country` VALUES ('FRA', 'France', 'Europe', 'Western Europe', 551500.00, 843, 59225700, 78.8, 1424285.00, 1392448.00, 'France', 'Republic', 'Jacques Chirac', 2974, 'FR');
INSERT INTO `country` VALUES ('FRO', 'Faroe Islands', 'Europe', 'Nordic Countries', 1399.00, NULL, 43000, 78.4, 0.00, NULL, 'Føroyar', 'Part of Denmark', 'Margrethe II', 901, 'FO');
INSERT INTO `country` VALUES ('FSM', 'Micronesia, Federated States of', 'Oceania', 'Micronesia', 702.00, 1990, 119000, 68.6, 212.00, NULL, 'Micronesia', 'Federal Republic', 'Leo A. Falcam', 2689, 'FM');
INSERT INTO `country` VALUES ('GAB', 'Gabon', 'Africa', 'Central Africa', 267668.00, 1960, 1226000, 50.1, 5493.00, 5279.00, 'Le Gabon', 'Republic', 'Omar Bongo', 902, 'GA');
INSERT INTO `country` VALUES ('GBR', 'United Kingdom', 'Europe', 'British Islands', 242900.00, 1066, 59623400, 77.7, 1378330.00, 1296830.00, 'United Kingdom', 'Constitutional Monarchy', 'Elisabeth II', 456, 'GB');
INSERT INTO `country` VALUES ('GEO', 'Georgia', 'Asia', 'Middle East', 69700.00, 1991, 4968000, 64.5, 6064.00, 5924.00, 'Sakartvelo', 'Republic', 'Eduard Ševardnadze', 905, 'GE');
INSERT INTO `country` VALUES ('GHA', 'Ghana', 'Africa', 'Western Africa', 238533.00, 1957, 20212000, 57.4, 7137.00, 6884.00, 'Ghana', 'Republic', 'John Kufuor', 910, 'GH');
INSERT INTO `country` VALUES ('GIB', 'Gibraltar', 'Europe', 'Southern Europe', 6.00, NULL, 25000, 79.0, 258.00, NULL, 'Gibraltar', 'Dependent Territory of the UK', 'Elisabeth II', 915, 'GI');
INSERT INTO `country` VALUES ('GIN', 'Guinea', 'Africa', 'Western Africa', 245857.00, 1958, 7430000, 45.6, 2352.00, 2383.00, 'Guinée', 'Republic', 'Lansana Conté', 926, 'GN');
INSERT INTO `country` VALUES ('GLP', 'Guadeloupe', 'North America', 'Caribbean', 1705.00, NULL, 456000, 77.0, 3501.00, NULL, 'Guadeloupe', 'Overseas Department of France', 'Jacques Chirac', 919, 'GP');
INSERT INTO `country` VALUES ('GMB', 'Gambia', 'Africa', 'Western Africa', 11295.00, 1965, 1305000, 53.2, 320.00, 325.00, 'The Gambia', 'Republic', 'Yahya Jammeh', 904, 'GM');
INSERT INTO `country` VALUES ('GNB', 'Guinea-Bissau', 'Africa', 'Western Africa', 36125.00, 1974, 1213000, 49.0, 293.00, 272.00, 'Guiné-Bissau', 'Republic', 'Kumba Ialá', 927, 'GW');
INSERT INTO `country` VALUES ('GNQ', 'Equatorial Guinea', 'Africa', 'Central Africa', 28051.00, 1968, 453000, 53.6, 283.00, 542.00, 'Guinea Ecuatorial', 'Republic', 'Teodoro Obiang Nguema Mbasogo', 2972, 'GQ');
INSERT INTO `country` VALUES ('GRC', 'Greece', 'Europe', 'Southern Europe', 131626.00, 1830, 10545700, 78.4, 120724.00, 119946.00, 'Elláda', 'Republic', 'Kostis Stefanopoulos', 2401, 'GR');
INSERT INTO `country` VALUES ('GRD', 'Grenada', 'North America', 'Caribbean', 344.00, 1974, 94000, 64.5, 318.00, NULL, 'Grenada', 'Constitutional Monarchy', 'Elisabeth II', 916, 'GD');
INSERT INTO `country` VALUES ('GRL', 'Greenland', 'North America', 'North America', 2166090.00, NULL, 56000, 68.1, 0.00, NULL, 'Kalaallit Nunaat/Grønland', 'Part of Denmark', 'Margrethe II', 917, 'GL');
INSERT INTO `country` VALUES ('GTM', 'Guatemala', 'North America', 'Central America', 108889.00, 1821, 11385000, 66.2, 19008.00, 17797.00, 'Guatemala', 'Republic', 'Alfonso Portillo Cabrera', 922, 'GT');
INSERT INTO `country` VALUES ('GUF', 'French Guiana', 'South America', 'South America', 90000.00, NULL, 181000, 76.1, 681.00, NULL, 'Guyane française', 'Overseas Department of France', 'Jacques Chirac', 3014, 'GF');
INSERT INTO `country` VALUES ('GUM', 'Guam', 'Oceania', 'Micronesia', 549.00, NULL, 168000, 77.8, 1197.00, 1136.00, 'Guam', 'US Territory', 'George W. Bush', 921, 'GU');
INSERT INTO `country` VALUES ('GUY', 'Guyana', 'South America', 'South America', 214969.00, 1966, 861000, 64.0, 722.00, 743.00, 'Guyana', 'Republic', 'Bharrat Jagdeo', 928, 'GY');
INSERT INTO `country` VALUES ('HKG', 'Hong Kong', 'Asia', 'Eastern Asia', 1075.00, NULL, 6782000, 79.5, 166448.00, 173610.00, 'Xianggang/Hong Kong', 'Special Administrative Region of China', 'Jiang Zemin', 937, 'HK');
INSERT INTO `country` VALUES ('HMD', 'Heard Island and McDonald Islands', 'Antarctica', 'Antarctica', 359.00, NULL, 0, NULL, 0.00, NULL, 'Heard and McDonald Islands', 'Territory of Australia', 'Elisabeth II', NULL, 'HM');
INSERT INTO `country` VALUES ('HND', 'Honduras', 'North America', 'Central America', 112088.00, 1838, 6485000, 69.9, 5333.00, 4697.00, 'Honduras', 'Republic', 'Carlos Roberto Flores Facussé', 933, 'HN');
INSERT INTO `country` VALUES ('HRV', 'Croatia', 'Europe', 'Southern Europe', 56538.00, 1991, 4473000, 73.7, 20208.00, 19300.00, 'Hrvatska', 'Republic', 'Štipe Mesic', 2409, 'HR');
INSERT INTO `country` VALUES ('HTI', 'Haiti', 'North America', 'Caribbean', 27750.00, 1804, 8222000, 49.2, 3459.00, 3107.00, 'Haïti/Dayti', 'Republic', 'Jean-Bertrand Aristide', 929, 'HT');
INSERT INTO `country` VALUES ('HUN', 'Hungary', 'Europe', 'Eastern Europe', 93030.00, 1918, 10043200, 71.4, 48267.00, 45914.00, 'Magyarország', 'Republic', 'Ferenc Mádl', 3483, 'HU');
INSERT INTO `country` VALUES ('IDN', 'Indonesia', 'Asia', 'Southeast Asia', 1904569.00, 1945, 212107000, 68.0, 84982.00, 215002.00, 'Indonesia', 'Republic', 'Abdurrahman Wahid', 939, 'ID');
INSERT INTO `country` VALUES ('IND', 'India', 'Asia', 'Southern and Central Asia', 3287263.00, 1947, 1013662000, 62.5, 447114.00, 430572.00, 'Bharat/India', 'Federal Republic', 'Kocheril Raman Narayanan', 1109, 'IN');
INSERT INTO `country` VALUES ('IOT', 'British Indian Ocean Territory', 'Africa', 'Eastern Africa', 78.00, NULL, 0, NULL, 0.00, NULL, 'British Indian Ocean Territory', 'Dependent Territory of the UK', 'Elisabeth II', NULL, 'IO');
INSERT INTO `country` VALUES ('IRL', 'Ireland', 'Europe', 'British Islands', 70273.00, 1921, 3775100, 76.8, 75921.00, 73132.00, 'Ireland/Éire', 'Republic', 'Mary McAleese', 1447, 'IE');
INSERT INTO `country` VALUES ('IRN', 'Iran', 'Asia', 'Southern and Central Asia', 1648195.00, 1906, 67702000, 69.7, 195746.00, 160151.00, 'Iran', 'Islamic Republic', 'Ali Mohammad Khatami-Ardakani', 1380, 'IR');
INSERT INTO `country` VALUES ('IRQ', 'Iraq', 'Asia', 'Middle East', 438317.00, 1932, 23115000, 66.5, 11500.00, NULL, 'Al-´Iraq', 'Republic', 'Saddam Hussein al-Takriti', 1365, 'IQ');
INSERT INTO `country` VALUES ('ISL', 'Iceland', 'Europe', 'Nordic Countries', 103000.00, 1944, 279000, 79.4, 8255.00, 7474.00, 'Ísland', 'Republic', 'Ólafur Ragnar Grímsson', 1449, 'IS');
INSERT INTO `country` VALUES ('ISR', 'Israel', 'Asia', 'Middle East', 21056.00, 1948, 6217000, 78.6, 97477.00, 98577.00, 'Yisra’el/Isra’il', 'Republic', 'Moshe Katzav', 1450, 'IL');
INSERT INTO `country` VALUES ('ITA', 'Italy', 'Europe', 'Southern Europe', 301316.00, 1861, 57680000, 79.0, 1161755.00, 1145372.00, 'Italia', 'Republic', 'Carlo Azeglio Ciampi', 1464, 'IT');
INSERT INTO `country` VALUES ('JAM', 'Jamaica', 'North America', 'Caribbean', 10990.00, 1962, 2583000, 75.2, 6871.00, 6722.00, 'Jamaica', 'Constitutional Monarchy', 'Elisabeth II', 1530, 'JM');
INSERT INTO `country` VALUES ('JOR', 'Jordan', 'Asia', 'Middle East', 88946.00, 1946, 5083000, 77.4, 7526.00, 7051.00, 'Al-Urdunn', 'Constitutional Monarchy', 'Abdullah II', 1786, 'JO');
INSERT INTO `country` VALUES ('JPN', 'Japan', 'Asia', 'Eastern Asia', 377829.00, -660, 126714000, 80.7, 3787042.00, 4192638.00, 'Nihon/Nippon', 'Constitutional Monarchy', 'Akihito', 1532, 'JP');
INSERT INTO `country` VALUES ('KAZ', 'Kazakstan', 'Asia', 'Southern and Central Asia', 2724900.00, 1991, 16223000, 63.2, 24375.00, 23383.00, 'Qazaqstan', 'Republic', 'Nursultan Nazarbajev', 1864, 'KZ');
INSERT INTO `country` VALUES ('KEN', 'Kenya', 'Africa', 'Eastern Africa', 580367.00, 1963, 30080000, 48.0, 9217.00, 10241.00, 'Kenya', 'Republic', 'Daniel arap Moi', 1881, 'KE');
INSERT INTO `country` VALUES ('KGZ', 'Kyrgyzstan', 'Asia', 'Southern and Central Asia', 199900.00, 1991, 4699000, 63.4, 1626.00, 1767.00, 'Kyrgyzstan', 'Republic', 'Askar Akajev', 2253, 'KG');
INSERT INTO `country` VALUES ('KHM', 'Cambodia', 'Asia', 'Southeast Asia', 181035.00, 1953, 11168000, 56.5, 5121.00, 5670.00, 'Kâmpuchéa', 'Constitutional Monarchy', 'Norodom Sihanouk', 1800, 'KH');
INSERT INTO `country` VALUES ('KIR', 'Kiribati', 'Oceania', 'Micronesia', 726.00, 1979, 83000, 59.8, 40.70, NULL, 'Kiribati', 'Republic', 'Teburoro Tito', 2256, 'KI');
INSERT INTO `country` VALUES ('KNA', 'Saint Kitts and Nevis', 'North America', 'Caribbean', 261.00, 1983, 38000, 70.7, 299.00, NULL, 'Saint Kitts and Nevis', 'Constitutional Monarchy', 'Elisabeth II', 3064, 'KN');
INSERT INTO `country` VALUES ('KOR', 'South Korea', 'Asia', 'Eastern Asia', 99434.00, 1948, 46844000, 74.4, 320749.00, 442544.00, 'Taehan Min’guk (Namhan)', 'Republic', 'Kim Dae-jung', 2331, 'KR');
INSERT INTO `country` VALUES ('KWT', 'Kuwait', 'Asia', 'Middle East', 17818.00, 1961, 1972000, 76.1, 27037.00, 30373.00, 'Al-Kuwayt', 'Constitutional Monarchy (Emirate)', 'Jabir al-Ahmad al-Jabir al-Sabah', 2429, 'KW');
INSERT INTO `country` VALUES ('LAO', 'Laos', 'Asia', 'Southeast Asia', 236800.00, 1953, 5433000, 53.1, 1292.00, 1746.00, 'Lao', 'Republic', 'Khamtay Siphandone', 2432, 'LA');
INSERT INTO `country` VALUES ('LBN', 'Lebanon', 'Asia', 'Middle East', 10400.00, 1941, 3282000, 71.3, 17121.00, 15129.00, 'Lubnan', 'Republic', 'Émile Lahoud', 2438, 'LB');
INSERT INTO `country` VALUES ('LBR', 'Liberia', 'Africa', 'Western Africa', 111369.00, 1847, 3154000, 51.0, 2012.00, NULL, 'Liberia', 'Republic', 'Charles Taylor', 2440, 'LR');
INSERT INTO `country` VALUES ('LBY', 'Libyan Arab Jamahiriya', 'Africa', 'Northern Africa', 1759540.00, 1951, 5605000, 75.5, 44806.00, 40562.00, 'Libiya', 'Socialistic State', 'Muammar al-Qadhafi', 2441, 'LY');
INSERT INTO `country` VALUES ('LCA', 'Saint Lucia', 'North America', 'Caribbean', 622.00, 1979, 154000, 72.3, 571.00, NULL, 'Saint Lucia', 'Constitutional Monarchy', 'Elisabeth II', 3065, 'LC');
INSERT INTO `country` VALUES ('LIE', 'Liechtenstein', 'Europe', 'Western Europe', 160.00, 1806, 32300, 78.8, 1119.00, 1084.00, 'Liechtenstein', 'Constitutional Monarchy', 'Hans-Adam II', 2446, 'LI');
INSERT INTO `country` VALUES ('LKA', 'Sri Lanka', 'Asia', 'Southern and Central Asia', 65610.00, 1948, 18827000, 71.8, 15706.00, 15091.00, 'Sri Lanka/Ilankai', 'Republic', 'Chandrika Kumaratunga', 3217, 'LK');
INSERT INTO `country` VALUES ('LSO', 'Lesotho', 'Africa', 'Southern Africa', 30355.00, 1966, 2153000, 50.8, 1061.00, 1161.00, 'Lesotho', 'Constitutional Monarchy', 'Letsie III', 2437, 'LS');
INSERT INTO `country` VALUES ('LTU', 'Lithuania', 'Europe', 'Baltic Countries', 65301.00, 1991, 3698500, 69.1, 10692.00, 9585.00, 'Lietuva', 'Republic', 'Valdas Adamkus', 2447, 'LT');
INSERT INTO `country` VALUES ('LUX', 'Luxembourg', 'Europe', 'Western Europe', 2586.00, 1867, 435700, 77.1, 16321.00, 15519.00, 'Luxembourg/Lëtzebuerg', 'Constitutional Monarchy', 'Henri', 2452, 'LU');
INSERT INTO `country` VALUES ('LVA', 'Latvia', 'Europe', 'Baltic Countries', 64589.00, 1991, 2424200, 68.4, 6398.00, 5639.00, 'Latvija', 'Republic', 'Vaira Vike-Freiberga', 2434, 'LV');
INSERT INTO `country` VALUES ('MAC', 'Macao', 'Asia', 'Eastern Asia', 18.00, NULL, 473000, 81.6, 5749.00, 5940.00, 'Macau/Aomen', 'Special Administrative Region of China', 'Jiang Zemin', 2454, 'MO');
INSERT INTO `country` VALUES ('MAR', 'Morocco', 'Africa', 'Northern Africa', 446550.00, 1956, 28351000, 69.1, 36124.00, 33514.00, 'Al-Maghrib', 'Constitutional Monarchy', 'Mohammed VI', 2486, 'MA');
INSERT INTO `country` VALUES ('MCO', 'Monaco', 'Europe', 'Western Europe', 1.50, 1861, 34000, 78.8, 776.00, NULL, 'Monaco', 'Constitutional Monarchy', 'Rainier III', 2695, 'MC');
INSERT INTO `country` VALUES ('MDA', 'Moldova', 'Europe', 'Eastern Europe', 33851.00, 1991, 4380000, 64.5, 1579.00, 1872.00, 'Moldova', 'Republic', 'Vladimir Voronin', 2690, 'MD');
INSERT INTO `country` VALUES ('MDG', 'Madagascar', 'Africa', 'Eastern Africa', 587041.00, 1960, 15942000, 55.0, 3750.00, 3545.00, 'Madagasikara/Madagascar', 'Federal Republic', 'Didier Ratsiraka', 2455, 'MG');
INSERT INTO `country` VALUES ('MDV', 'Maldives', 'Asia', 'Southern and Central Asia', 298.00, 1965, 286000, 62.2, 199.00, NULL, 'Dhivehi Raajje/Maldives', 'Republic', 'Maumoon Abdul Gayoom', 2463, 'MV');
INSERT INTO `country` VALUES ('MEX', 'Mexico', 'North America', 'Central America', 1958201.00, 1810, 98881000, 71.5, 414972.00, 401461.00, 'México', 'Federal Republic', 'Vicente Fox Quesada', 2515, 'MX');
INSERT INTO `country` VALUES ('MHL', 'Marshall Islands', 'Oceania', 'Micronesia', 181.00, 1990, 64000, 65.5, 97.00, NULL, 'Marshall Islands/Majol', 'Republic', 'Kessai Note', 2507, 'MH');
INSERT INTO `country` VALUES ('MKD', 'Macedonia', 'Europe', 'Southern Europe', 25713.00, 1991, 2024000, 73.8, 1694.00, 1915.00, 'Makedonija', 'Republic', 'Boris Trajkovski', 2460, 'MK');
INSERT INTO `country` VALUES ('MLI', 'Mali', 'Africa', 'Western Africa', 1240192.00, 1960, 11234000, 46.7, 2642.00, 2453.00, 'Mali', 'Republic', 'Alpha Oumar Konaré', 2482, 'ML');
INSERT INTO `country` VALUES ('MLT', 'Malta', 'Europe', 'Southern Europe', 316.00, 1964, 380200, 77.9, 3512.00, 3338.00, 'Malta', 'Republic', 'Guido de Marco', 2484, 'MT');
INSERT INTO `country` VALUES ('MMR', 'Myanmar', 'Asia', 'Southeast Asia', 676578.00, 1948, 45611000, 54.9, 180375.00, 171028.00, 'Myanma Pye', 'Republic', 'kenraali Than Shwe', 2710, 'MM');
INSERT INTO `country` VALUES ('MNG', 'Mongolia', 'Asia', 'Eastern Asia', 1566500.00, 1921, 2662000, 67.3, 1043.00, 933.00, 'Mongol Uls', 'Republic', 'Natsagiin Bagabandi', 2696, 'MN');
INSERT INTO `country` VALUES ('MNP', 'Northern Mariana Islands', 'Oceania', 'Micronesia', 464.00, NULL, 78000, 75.5, 0.00, NULL, 'Northern Mariana Islands', 'Commonwealth of the US', 'George W. Bush', 2913, 'MP');
INSERT INTO `country` VALUES ('MOZ', 'Mozambique', 'Africa', 'Eastern Africa', 801590.00, 1975, 19680000, 37.5, 2891.00, 2711.00, 'Moçambique', 'Republic', 'Joaquím A. Chissano', 2698, 'MZ');
INSERT INTO `country` VALUES ('MRT', 'Mauritania', 'Africa', 'Western Africa', 1025520.00, 1960, 2670000, 50.8, 998.00, 1081.00, 'Muritaniya/Mauritanie', 'Republic', 'Maaouiya Ould Sid´Ahmad Taya', 2509, 'MR');
INSERT INTO `country` VALUES ('MSR', 'Montserrat', 'North America', 'Caribbean', 102.00, NULL, 11000, 78.0, 109.00, NULL, 'Montserrat', 'Dependent Territory of the UK', 'Elisabeth II', 2697, 'MS');
INSERT INTO `country` VALUES ('MTQ', 'Martinique', 'North America', 'Caribbean', 1102.00, NULL, 395000, 78.3, 2731.00, 2559.00, 'Martinique', 'Overseas Department of France', 'Jacques Chirac', 2508, 'MQ');
INSERT INTO `country` VALUES ('MUS', 'Mauritius', 'Africa', 'Eastern Africa', 2040.00, 1968, 1158000, 71.0, 4251.00, 4186.00, 'Mauritius', 'Republic', 'Cassam Uteem', 2511, 'MU');
INSERT INTO `country` VALUES ('MWI', 'Malawi', 'Africa', 'Eastern Africa', 118484.00, 1964, 10925000, 37.6, 1687.00, 2527.00, 'Malawi', 'Republic', 'Bakili Muluzi', 2462, 'MW');
INSERT INTO `country` VALUES ('MYS', 'Malaysia', 'Asia', 'Southeast Asia', 329758.00, 1957, 22244000, 70.8, 69213.00, 97884.00, 'Malaysia', 'Constitutional Monarchy, Federation', 'Salahuddin Abdul Aziz Shah Alhaj', 2464, 'MY');
INSERT INTO `country` VALUES ('MYT', 'Mayotte', 'Africa', 'Eastern Africa', 373.00, NULL, 149000, 59.5, 0.00, NULL, 'Mayotte', 'Territorial Collectivity of France', 'Jacques Chirac', 2514, 'YT');
INSERT INTO `country` VALUES ('NAM', 'Namibia', 'Africa', 'Southern Africa', 824292.00, 1990, 1726000, 42.5, 3101.00, 3384.00, 'Namibia', 'Republic', 'Sam Nujoma', 2726, 'NA');
INSERT INTO `country` VALUES ('NCL', 'New Caledonia', 'Oceania', 'Melanesia', 18575.00, NULL, 214000, 72.8, 3563.00, NULL, 'Nouvelle-Calédonie', 'Nonmetropolitan Territory of France', 'Jacques Chirac', 3493, 'NC');
INSERT INTO `country` VALUES ('NER', 'Niger', 'Africa', 'Western Africa', 1267000.00, 1960, 10730000, 41.3, 1706.00, 1580.00, 'Niger', 'Republic', 'Mamadou Tandja', 2738, 'NE');
INSERT INTO `country` VALUES ('NFK', 'Norfolk Island', 'Oceania', 'Australia and New Zealand', 36.00, NULL, 2000, NULL, 0.00, NULL, 'Norfolk Island', 'Territory of Australia', 'Elisabeth II', 2806, 'NF');
INSERT INTO `country` VALUES ('NGA', 'Nigeria', 'Africa', 'Western Africa', 923768.00, 1960, 111506000, 51.6, 65707.00, 58623.00, 'Nigeria', 'Federal Republic', 'Olusegun Obasanjo', 2754, 'NG');
INSERT INTO `country` VALUES ('NIC', 'Nicaragua', 'North America', 'Central America', 130000.00, 1838, 5074000, 68.7, 1988.00, 2023.00, 'Nicaragua', 'Republic', 'Arnoldo Alemán Lacayo', 2734, 'NI');
INSERT INTO `country` VALUES ('NIU', 'Niue', 'Oceania', 'Polynesia', 260.00, NULL, 2000, NULL, 0.00, NULL, 'Niue', 'Nonmetropolitan Territory of New Zealand', 'Elisabeth II', 2805, 'NU');
INSERT INTO `country` VALUES ('NLD', 'Netherlands', 'Europe', 'Western Europe', 41526.00, 1581, 15864000, 78.3, 371362.00, 360478.00, 'Nederland', 'Constitutional Monarchy', 'Beatrix', 5, 'NL');
INSERT INTO `country` VALUES ('NOR', 'Norway', 'Europe', 'Nordic Countries', 323877.00, 1905, 4478500, 78.7, 145895.00, 153370.00, 'Norge', 'Constitutional Monarchy', 'Harald V', 2807, 'NO');
INSERT INTO `country` VALUES ('NPL', 'Nepal', 'Asia', 'Southern and Central Asia', 147181.00, 1769, 23930000, 57.8, 4768.00, 4837.00, 'Nepal', 'Constitutional Monarchy', 'Gyanendra Bir Bikram', 2729, 'NP');
INSERT INTO `country` VALUES ('NRU', 'Nauru', 'Oceania', 'Micronesia', 21.00, 1968, 12000, 60.8, 197.00, NULL, 'Naoero/Nauru', 'Republic', 'Bernard Dowiyogo', 2728, 'NR');
INSERT INTO `country` VALUES ('NZL', 'New Zealand', 'Oceania', 'Australia and New Zealand', 270534.00, 1907, 3862000, 77.8, 54669.00, 64960.00, 'New Zealand/Aotearoa', 'Constitutional Monarchy', 'Elisabeth II', 3499, 'NZ');
INSERT INTO `country` VALUES ('OMN', 'Oman', 'Asia', 'Middle East', 309500.00, 1951, 2542000, 71.8, 16904.00, 16153.00, '´Uman', 'Monarchy (Sultanate)', 'Qabus ibn Sa´id', 2821, 'OM');
INSERT INTO `country` VALUES ('PAK', 'Pakistan', 'Asia', 'Southern and Central Asia', 796095.00, 1947, 156483000, 61.1, 61289.00, 58549.00, 'Pakistan', 'Republic', 'Mohammad Rafiq Tarar', 2831, 'PK');
INSERT INTO `country` VALUES ('PAN', 'Panama', 'North America', 'Central America', 75517.00, 1903, 2856000, 75.5, 9131.00, 8700.00, 'Panamá', 'Republic', 'Mireya Elisa Moscoso Rodríguez', 2882, 'PA');
INSERT INTO `country` VALUES ('PCN', 'Pitcairn', 'Oceania', 'Polynesia', 49.00, NULL, 50, NULL, 0.00, NULL, 'Pitcairn', 'Dependent Territory of the UK', 'Elisabeth II', 2912, 'PN');
INSERT INTO `country` VALUES ('PER', 'Peru', 'South America', 'South America', 1285216.00, 1821, 25662000, 70.0, 64140.00, 65186.00, 'Perú/Piruw', 'Republic', 'Valentin Paniagua Corazao', 2890, 'PE');
INSERT INTO `country` VALUES ('PHL', 'Philippines', 'Asia', 'Southeast Asia', 300000.00, 1946, 75967000, 67.5, 65107.00, 82239.00, 'Pilipinas', 'Republic', 'Gloria Macapagal-Arroyo', 766, 'PH');
INSERT INTO `country` VALUES ('PLW', 'Palau', 'Oceania', 'Micronesia', 459.00, 1994, 19000, 68.6, 105.00, NULL, 'Belau/Palau', 'Republic', 'Kuniwo Nakamura', 2881, 'PW');
INSERT INTO `country` VALUES ('PNG', 'Papua New Guinea', 'Oceania', 'Melanesia', 462840.00, 1975, 4807000, 63.1, 4988.00, 6328.00, 'Papua New Guinea/Papua Niugini', 'Constitutional Monarchy', 'Elisabeth II', 2884, 'PG');
INSERT INTO `country` VALUES ('POL', 'Poland', 'Europe', 'Eastern Europe', 323250.00, 1918, 38653600, 73.2, 151697.00, 135636.00, 'Polska', 'Republic', 'Aleksander Kwasniewski', 2928, 'PL');
INSERT INTO `country` VALUES ('PRI', 'Puerto Rico', 'North America', 'Caribbean', 8875.00, NULL, 3869000, 75.6, 34100.00, 32100.00, 'Puerto Rico', 'Commonwealth of the US', 'George W. Bush', 2919, 'PR');
INSERT INTO `country` VALUES ('PRK', 'North Korea', 'Asia', 'Eastern Asia', 120538.00, 1948, 24039000, 70.7, 5332.00, NULL, 'Choson Minjujuui In´min Konghwaguk (Bukhan)', 'Socialistic Republic', 'Kim Jong-il', 2318, 'KP');
INSERT INTO `country` VALUES ('PRT', 'Portugal', 'Europe', 'Southern Europe', 91982.00, 1143, 9997600, 75.8, 105954.00, 102133.00, 'Portugal', 'Republic', 'Jorge Sampãio', 2914, 'PT');
INSERT INTO `country` VALUES ('PRY', 'Paraguay', 'South America', 'South America', 406752.00, 1811, 5496000, 73.7, 8444.00, 9555.00, 'Paraguay', 'Republic', 'Luis Ángel González Macchi', 2885, 'PY');
INSERT INTO `country` VALUES ('PSE', 'Palestine', 'Asia', 'Middle East', 6257.00, NULL, 3101000, 71.4, 4173.00, NULL, 'Filastin', 'Autonomous Area', 'Yasser (Yasir) Arafat', 4074, 'PS');
INSERT INTO `country` VALUES ('PYF', 'French Polynesia', 'Oceania', 'Polynesia', 4000.00, NULL, 235000, 74.8, 818.00, 781.00, 'Polynésie française', 'Nonmetropolitan Territory of France', 'Jacques Chirac', 3016, 'PF');
INSERT INTO `country` VALUES ('QAT', 'Qatar', 'Asia', 'Middle East', 11000.00, 1971, 599000, 72.4, 9472.00, 8920.00, 'Qatar', 'Monarchy', 'Hamad ibn Khalifa al-Thani', 2973, 'QA');
INSERT INTO `country` VALUES ('REU', 'Réunion', 'Africa', 'Eastern Africa', 2510.00, NULL, 699000, 72.7, 8287.00, 7988.00, 'Réunion', 'Overseas Department of France', 'Jacques Chirac', 3017, 'RE');
INSERT INTO `country` VALUES ('ROM', 'Romania', 'Europe', 'Eastern Europe', 238391.00, 1878, 22455500, 69.9, 38158.00, 34843.00, 'România', 'Republic', 'Ion Iliescu', 3018, 'RO');
INSERT INTO `country` VALUES ('RUS', 'Russian Federation', 'Europe', 'Eastern Europe', 17075400.00, 1991, 146934000, 67.2, 276608.00, 442989.00, 'Rossija', 'Federal Republic', 'Vladimir Putin', 3580, 'RU');
INSERT INTO `country` VALUES ('RWA', 'Rwanda', 'Africa', 'Eastern Africa', 26338.00, 1962, 7733000, 39.3, 2036.00, 1863.00, 'Rwanda/Urwanda', 'Republic', 'Paul Kagame', 3047, 'RW');
INSERT INTO `country` VALUES ('SAU', 'Saudi Arabia', 'Asia', 'Middle East', 2149690.00, 1932, 21607000, 67.8, 137635.00, 146171.00, 'Al-´Arabiya as-Sa´udiya', 'Monarchy', 'Fahd ibn Abdul-Aziz al-Sa´ud', 3173, 'SA');
INSERT INTO `country` VALUES ('SDN', 'Sudan', 'Africa', 'Northern Africa', 2505813.00, 1956, 29490000, 56.6, 10162.00, NULL, 'As-Sudan', 'Islamic Republic', 'Omar Hassan Ahmad al-Bashir', 3225, 'SD');
INSERT INTO `country` VALUES ('SEN', 'Senegal', 'Africa', 'Western Africa', 196722.00, 1960, 9481000, 62.2, 4787.00, 4542.00, 'Sénégal/Sounougal', 'Republic', 'Abdoulaye Wade', 3198, 'SN');
INSERT INTO `country` VALUES ('SGP', 'Singapore', 'Asia', 'Southeast Asia', 618.00, 1965, 3567000, 80.1, 86503.00, 96318.00, 'Singapore/Singapura/Xinjiapo/Singapur', 'Republic', 'Sellapan Rama Nathan', 3208, 'SG');
INSERT INTO `country` VALUES ('SGS', 'South Georgia and the South Sandwich Islands', 'Antarctica', 'Antarctica', 3903.00, NULL, 0, NULL, 0.00, NULL, 'South Georgia and the South Sandwich Islands', 'Dependent Territory of the UK', 'Elisabeth II', NULL, 'GS');
INSERT INTO `country` VALUES ('SHN', 'Saint Helena', 'Africa', 'Western Africa', 314.00, NULL, 6000, 76.8, 0.00, NULL, 'Saint Helena', 'Dependent Territory of the UK', 'Elisabeth II', 3063, 'SH');
INSERT INTO `country` VALUES ('SJM', 'Svalbard and Jan Mayen', 'Europe', 'Nordic Countries', 62422.00, NULL, 3200, NULL, 0.00, NULL, 'Svalbard og Jan Mayen', 'Dependent Territory of Norway', 'Harald V', 938, 'SJ');
INSERT INTO `country` VALUES ('SLB', 'Solomon Islands', 'Oceania', 'Melanesia', 28896.00, 1978, 444000, 71.3, 182.00, 220.00, 'Solomon Islands', 'Constitutional Monarchy', 'Elisabeth II', 3161, 'SB');
INSERT INTO `country` VALUES ('SLE', 'Sierra Leone', 'Africa', 'Western Africa', 71740.00, 1961, 4854000, 45.3, 746.00, 858.00, 'Sierra Leone', 'Republic', 'Ahmed Tejan Kabbah', 3207, 'SL');
INSERT INTO `country` VALUES ('SLV', 'El Salvador', 'North America', 'Central America', 21041.00, 1841, 6276000, 69.7, 11863.00, 11203.00, 'El Salvador', 'Republic', 'Francisco Guillermo Flores Pérez', 645, 'SV');
INSERT INTO `country` VALUES ('SMR', 'San Marino', 'Europe', 'Southern Europe', 61.00, 885, 27000, 81.1, 510.00, NULL, 'San Marino', 'Republic', NULL, 3171, 'SM');
INSERT INTO `country` VALUES ('SOM', 'Somalia', 'Africa', 'Eastern Africa', 637657.00, 1960, 10097000, 46.2, 935.00, NULL, 'Soomaaliya', 'Republic', 'Abdiqassim Salad Hassan', 3214, 'SO');
INSERT INTO `country` VALUES ('SPM', 'Saint Pierre and Miquelon', 'North America', 'North America', 242.00, NULL, 7000, 77.6, 0.00, NULL, 'Saint-Pierre-et-Miquelon', 'Territorial Collectivity of France', 'Jacques Chirac', 3067, 'PM');
INSERT INTO `country` VALUES ('STP', 'Sao Tome and Principe', 'Africa', 'Central Africa', 964.00, 1975, 147000, 65.3, 6.00, NULL, 'São Tomé e Príncipe', 'Republic', 'Miguel Trovoada', 3172, 'ST');
INSERT INTO `country` VALUES ('SUR', 'Suriname', 'South America', 'South America', 163265.00, 1975, 417000, 71.4, 870.00, 706.00, 'Suriname', 'Republic', 'Ronald Venetiaan', 3243, 'SR');
INSERT INTO `country` VALUES ('SVK', 'Slovakia', 'Europe', 'Eastern Europe', 49012.00, 1993, 5398700, 73.7, 20594.00, 19452.00, 'Slovensko', 'Republic', 'Rudolf Schuster', 3209, 'SK');
INSERT INTO `country` VALUES ('SVN', 'Slovenia', 'Europe', 'Southern Europe', 20256.00, 1991, 1987800, 74.9, 19756.00, 18202.00, 'Slovenija', 'Republic', 'Milan Kucan', 3212, 'SI');
INSERT INTO `country` VALUES ('SWE', 'Sweden', 'Europe', 'Nordic Countries', 449964.00, 836, 8861400, 79.6, 226492.00, 227757.00, 'Sverige', 'Constitutional Monarchy', 'Carl XVI Gustaf', 3048, 'SE');
INSERT INTO `country` VALUES ('SWZ', 'Swaziland', 'Africa', 'Southern Africa', 17364.00, 1968, 1008000, 40.4, 1206.00, 1312.00, 'kaNgwane', 'Monarchy', 'Mswati III', 3244, 'SZ');
INSERT INTO `country` VALUES ('SYC', 'Seychelles', 'Africa', 'Eastern Africa', 455.00, 1976, 77000, 70.4, 536.00, 539.00, 'Sesel/Seychelles', 'Republic', 'France-Albert René', 3206, 'SC');
INSERT INTO `country` VALUES ('SYR', 'Syria', 'Asia', 'Middle East', 185180.00, 1941, 16125000, 68.5, 65984.00, 64926.00, 'Suriya', 'Republic', 'Bashar al-Assad', 3250, 'SY');
INSERT INTO `country` VALUES ('TCA', 'Turks and Caicos Islands', 'North America', 'Caribbean', 430.00, NULL, 17000, 73.3, 96.00, NULL, 'The Turks and Caicos Islands', 'Dependent Territory of the UK', 'Elisabeth II', 3423, 'TC');
INSERT INTO `country` VALUES ('TCD', 'Chad', 'Africa', 'Central Africa', 1284000.00, 1960, 7651000, 50.5, 1208.00, 1102.00, 'Tchad/Tshad', 'Republic', 'Idriss Déby', 3337, 'TD');
INSERT INTO `country` VALUES ('TGO', 'Togo', 'Africa', 'Western Africa', 56785.00, 1960, 4629000, 54.7, 1449.00, 1400.00, 'Togo', 'Republic', 'Gnassingbé Eyadéma', 3332, 'TG');
INSERT INTO `country` VALUES ('THA', 'Thailand', 'Asia', 'Southeast Asia', 513115.00, 1350, 61399000, 68.6, 116416.00, 153907.00, 'Prathet Thai', 'Constitutional Monarchy', 'Bhumibol Adulyadej', 3320, 'TH');
INSERT INTO `country` VALUES ('TJK', 'Tajikistan', 'Asia', 'Southern and Central Asia', 143100.00, 1991, 6188000, 64.1, 1990.00, 1056.00, 'Toçikiston', 'Republic', 'Emomali Rahmonov', 3261, 'TJ');
INSERT INTO `country` VALUES ('TKL', 'Tokelau', 'Oceania', 'Polynesia', 12.00, NULL, 2000, NULL, 0.00, NULL, 'Tokelau', 'Nonmetropolitan Territory of New Zealand', 'Elisabeth II', 3333, 'TK');
INSERT INTO `country` VALUES ('TKM', 'Turkmenistan', 'Asia', 'Southern and Central Asia', 488100.00, 1991, 4459000, 60.9, 4397.00, 2000.00, 'Türkmenostan', 'Republic', 'Saparmurad Nijazov', 3419, 'TM');
INSERT INTO `country` VALUES ('TMP', 'East Timor', 'Asia', 'Southeast Asia', 14874.00, NULL, 885000, 46.0, 0.00, NULL, 'Timor Timur', 'Administrated by the UN', 'José Alexandre Gusmão', 1522, 'TP');
INSERT INTO `country` VALUES ('TON', 'Tonga', 'Oceania', 'Polynesia', 650.00, 1970, 99000, 67.9, 146.00, 170.00, 'Tonga', 'Monarchy', 'Taufa\'ahau Tupou IV', 3334, 'TO');
INSERT INTO `country` VALUES ('TTO', 'Trinidad and Tobago', 'North America', 'Caribbean', 5130.00, 1962, 1295000, 68.0, 6232.00, 5867.00, 'Trinidad and Tobago', 'Republic', 'Arthur N. R. Robinson', 3336, 'TT');
INSERT INTO `country` VALUES ('TUN', 'Tunisia', 'Africa', 'Northern Africa', 163610.00, 1956, 9586000, 73.7, 20026.00, 18898.00, 'Tunis/Tunisie', 'Republic', 'Zine al-Abidine Ben Ali', 3349, 'TN');
INSERT INTO `country` VALUES ('TUR', 'Turkey', 'Asia', 'Middle East', 774815.00, 1923, 66591000, 71.0, 210721.00, 189122.00, 'Türkiye', 'Republic', 'Ahmet Necdet Sezer', 3358, 'TR');
INSERT INTO `country` VALUES ('TUV', 'Tuvalu', 'Oceania', 'Polynesia', 26.00, 1978, 12000, 66.3, 6.00, NULL, 'Tuvalu', 'Constitutional Monarchy', 'Elisabeth II', 3424, 'TV');
INSERT INTO `country` VALUES ('TWN', 'Taiwan', 'Asia', 'Eastern Asia', 36188.00, 1945, 22256000, 76.4, 256254.00, 263451.00, 'T’ai-wan', 'Republic', 'Chen Shui-bian', 3263, 'TW');
INSERT INTO `country` VALUES ('TZA', 'Tanzania', 'Africa', 'Eastern Africa', 883749.00, 1961, 33517000, 52.3, 8005.00, 7388.00, 'Tanzania', 'Republic', 'Benjamin William Mkapa', 3306, 'TZ');
INSERT INTO `country` VALUES ('UGA', 'Uganda', 'Africa', 'Eastern Africa', 241038.00, 1962, 21778000, 42.9, 6313.00, 6887.00, 'Uganda', 'Republic', 'Yoweri Museveni', 3425, 'UG');
INSERT INTO `country` VALUES ('UKR', 'Ukraine', 'Europe', 'Eastern Europe', 603700.00, 1991, 50456000, 66.0, 42168.00, 49677.00, 'Ukrajina', 'Republic', 'Leonid Kutšma', 3426, 'UA');
INSERT INTO `country` VALUES ('UMI', 'United States Minor Outlying Islands', 'Oceania', 'Micronesia/Caribbean', 16.00, NULL, 0, NULL, 0.00, NULL, 'United States Minor Outlying Islands', 'Dependent Territory of the US', 'George W. Bush', NULL, 'UM');
INSERT INTO `country` VALUES ('URY', 'Uruguay', 'South America', 'South America', 175016.00, 1828, 3337000, 75.2, 20831.00, 19967.00, 'Uruguay', 'Republic', 'Jorge Batlle Ibáñez', 3492, 'UY');
INSERT INTO `country` VALUES ('USA', 'United States', 'North America', 'North America', 9363520.00, 1776, 278357000, 77.1, 8510700.00, 8110900.00, 'United States', 'Federal Republic', 'George W. Bush', 3813, 'US');
INSERT INTO `country` VALUES ('UZB', 'Uzbekistan', 'Asia', 'Southern and Central Asia', 447400.00, 1991, 24318000, 63.7, 14194.00, 21300.00, 'Uzbekiston', 'Republic', 'Islam Karimov', 3503, 'UZ');
INSERT INTO `country` VALUES ('VAT', 'Holy See (Vatican City State)', 'Europe', 'Southern Europe', 0.40, 1929, 1000, NULL, 9.00, NULL, 'Santa Sede/Città del Vaticano', 'Independent Church State', 'Johannes Paavali II', 3538, 'VA');
INSERT INTO `country` VALUES ('VCT', 'Saint Vincent and the Grenadines', 'North America', 'Caribbean', 388.00, 1979, 114000, 72.3, 285.00, NULL, 'Saint Vincent and the Grenadines', 'Constitutional Monarchy', 'Elisabeth II', 3066, 'VC');
INSERT INTO `country` VALUES ('VEN', 'Venezuela', 'South America', 'South America', 912050.00, 1811, 24170000, 73.1, 95023.00, 88434.00, 'Venezuela', 'Federal Republic', 'Hugo Chávez Frías', 3539, 'VE');
INSERT INTO `country` VALUES ('VGB', 'Virgin Islands, British', 'North America', 'Caribbean', 151.00, NULL, 21000, 75.4, 612.00, 573.00, 'British Virgin Islands', 'Dependent Territory of the UK', 'Elisabeth II', 537, 'VG');
INSERT INTO `country` VALUES ('VIR', 'Virgin Islands, U.S.', 'North America', 'Caribbean', 347.00, NULL, 93000, 78.1, 0.00, NULL, 'Virgin Islands of the United States', 'US Territory', 'George W. Bush', 4067, 'VI');
INSERT INTO `country` VALUES ('VNM', 'Vietnam', 'Asia', 'Southeast Asia', 331689.00, 1945, 79832000, 69.3, 21929.00, 22834.00, 'Viêt Nam', 'Socialistic Republic', 'Trân Duc Luong', 3770, 'VN');
INSERT INTO `country` VALUES ('VUT', 'Vanuatu', 'Oceania', 'Melanesia', 12189.00, 1980, 190000, 60.6, 261.00, 246.00, 'Vanuatu', 'Republic', 'John Bani', 3537, 'VU');
INSERT INTO `country` VALUES ('WLF', 'Wallis and Futuna', 'Oceania', 'Polynesia', 200.00, NULL, 15000, NULL, 0.00, NULL, 'Wallis-et-Futuna', 'Nonmetropolitan Territory of France', 'Jacques Chirac', 3536, 'WF');
INSERT INTO `country` VALUES ('WSM', 'Samoa', 'Oceania', 'Polynesia', 2831.00, 1962, 180000, 69.2, 141.00, 157.00, 'Samoa', 'Parlementary Monarchy', 'Malietoa Tanumafili II', 3169, 'WS');
INSERT INTO `country` VALUES ('YEM', 'Yemen', 'Asia', 'Middle East', 527968.00, 1918, 18112000, 59.8, 6041.00, 5729.00, 'Al-Yaman', 'Republic', 'Ali Abdallah Salih', 1780, 'YE');
INSERT INTO `country` VALUES ('YUG', 'Yugoslavia', 'Europe', 'Southern Europe', 102173.00, 1918, 10640000, 72.4, 17000.00, NULL, 'Jugoslavija', 'Federal Republic', 'Vojislav Koštunica', 1792, 'YU');
INSERT INTO `country` VALUES ('ZAF', 'South Africa', 'Africa', 'Southern Africa', 1221037.00, 1910, 40377000, 51.1, 116729.00, 129092.00, 'South Africa', 'Republic', 'Thabo Mbeki', 716, 'ZA');
INSERT INTO `country` VALUES ('ZMB', 'Zambia', 'Africa', 'Eastern Africa', 752618.00, 1964, 9169000, 37.2, 3377.00, 3922.00, 'Zambia', 'Republic', 'Frederick Chiluba', 3162, 'ZM');
INSERT INTO `country` VALUES ('ZWE', 'Zimbabwe', 'Africa', 'Eastern Africa', 390757.00, 1980, 11669000, 37.8, 5951.00, 8670.00, 'Zimbabwe', 'Republic', 'Robert G. Mugabe', 4068, 'ZW');
COMMIT;

-- ----------------------------
-- Table structure for countrylanguage
-- ----------------------------
DROP TABLE IF EXISTS `countrylanguage`;
CREATE TABLE `countrylanguage` (
                                   `country_code` char(3) NOT NULL DEFAULT '',
                                   `language` char(30) NOT NULL DEFAULT '',
                                   `is_official` enum('T','F') NOT NULL DEFAULT 'F',
                                   `percentage` decimal(4,1) NOT NULL DEFAULT '0.0',
                                   PRIMARY KEY (`country_code`,`language`),
                                   KEY `country_code` (`country_code`),
                                   CONSTRAINT `countrylanguage_ibfk_1` FOREIGN KEY (`country_code`) REFERENCES `country` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of countrylanguage
-- ----------------------------
BEGIN;
INSERT INTO `countrylanguage` VALUES ('ABW', 'Dutch', 'T', 5.3);
INSERT INTO `countrylanguage` VALUES ('ABW', 'English', 'F', 9.5);
INSERT INTO `countrylanguage` VALUES ('ABW', 'Papiamento', 'F', 76.7);
INSERT INTO `countrylanguage` VALUES ('ABW', 'Spanish', 'F', 7.4);
INSERT INTO `countrylanguage` VALUES ('AFG', 'Balochi', 'F', 0.9);
INSERT INTO `countrylanguage` VALUES ('AFG', 'Dari', 'T', 32.1);
INSERT INTO `countrylanguage` VALUES ('AFG', 'Pashto', 'T', 52.4);
INSERT INTO `countrylanguage` VALUES ('AFG', 'Turkmenian', 'F', 1.9);
INSERT INTO `countrylanguage` VALUES ('AFG', 'Uzbek', 'F', 8.8);
INSERT INTO `countrylanguage` VALUES ('AGO', 'Ambo', 'F', 2.4);
INSERT INTO `countrylanguage` VALUES ('AGO', 'Chokwe', 'F', 4.2);
INSERT INTO `countrylanguage` VALUES ('AGO', 'Kongo', 'F', 13.2);
INSERT INTO `countrylanguage` VALUES ('AGO', 'Luchazi', 'F', 2.4);
INSERT INTO `countrylanguage` VALUES ('AGO', 'Luimbe-nganguela', 'F', 5.4);
INSERT INTO `countrylanguage` VALUES ('AGO', 'Luvale', 'F', 3.6);
INSERT INTO `countrylanguage` VALUES ('AGO', 'Mbundu', 'F', 21.6);
INSERT INTO `countrylanguage` VALUES ('AGO', 'Nyaneka-nkhumbi', 'F', 5.4);
INSERT INTO `countrylanguage` VALUES ('AGO', 'Ovimbundu', 'F', 37.2);
INSERT INTO `countrylanguage` VALUES ('AIA', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('ALB', 'Albaniana', 'T', 97.9);
INSERT INTO `countrylanguage` VALUES ('ALB', 'Greek', 'F', 1.8);
INSERT INTO `countrylanguage` VALUES ('ALB', 'Macedonian', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('AND', 'Catalan', 'T', 32.3);
INSERT INTO `countrylanguage` VALUES ('AND', 'French', 'F', 6.2);
INSERT INTO `countrylanguage` VALUES ('AND', 'Portuguese', 'F', 10.8);
INSERT INTO `countrylanguage` VALUES ('AND', 'Spanish', 'F', 44.6);
INSERT INTO `countrylanguage` VALUES ('ANT', 'Dutch', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('ANT', 'English', 'F', 7.8);
INSERT INTO `countrylanguage` VALUES ('ANT', 'Papiamento', 'T', 86.2);
INSERT INTO `countrylanguage` VALUES ('ARE', 'Arabic', 'T', 42.0);
INSERT INTO `countrylanguage` VALUES ('ARE', 'Hindi', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('ARG', 'Indian Languages', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('ARG', 'Italian', 'F', 1.7);
INSERT INTO `countrylanguage` VALUES ('ARG', 'Spanish', 'T', 96.8);
INSERT INTO `countrylanguage` VALUES ('ARM', 'Armenian', 'T', 93.4);
INSERT INTO `countrylanguage` VALUES ('ARM', 'Azerbaijani', 'F', 2.6);
INSERT INTO `countrylanguage` VALUES ('ASM', 'English', 'T', 3.1);
INSERT INTO `countrylanguage` VALUES ('ASM', 'Samoan', 'T', 90.6);
INSERT INTO `countrylanguage` VALUES ('ASM', 'Tongan', 'F', 3.1);
INSERT INTO `countrylanguage` VALUES ('ATG', 'Creole English', 'F', 95.7);
INSERT INTO `countrylanguage` VALUES ('ATG', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('AUS', 'Arabic', 'F', 1.0);
INSERT INTO `countrylanguage` VALUES ('AUS', 'Canton Chinese', 'F', 1.1);
INSERT INTO `countrylanguage` VALUES ('AUS', 'English', 'T', 81.2);
INSERT INTO `countrylanguage` VALUES ('AUS', 'German', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('AUS', 'Greek', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('AUS', 'Italian', 'F', 2.2);
INSERT INTO `countrylanguage` VALUES ('AUS', 'Serbo-Croatian', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('AUS', 'Vietnamese', 'F', 0.8);
INSERT INTO `countrylanguage` VALUES ('AUT', 'Czech', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('AUT', 'German', 'T', 92.0);
INSERT INTO `countrylanguage` VALUES ('AUT', 'Hungarian', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('AUT', 'Polish', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('AUT', 'Romanian', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('AUT', 'Serbo-Croatian', 'F', 2.2);
INSERT INTO `countrylanguage` VALUES ('AUT', 'Slovene', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('AUT', 'Turkish', 'F', 1.5);
INSERT INTO `countrylanguage` VALUES ('AZE', 'Armenian', 'F', 2.0);
INSERT INTO `countrylanguage` VALUES ('AZE', 'Azerbaijani', 'T', 89.0);
INSERT INTO `countrylanguage` VALUES ('AZE', 'Lezgian', 'F', 2.3);
INSERT INTO `countrylanguage` VALUES ('AZE', 'Russian', 'F', 3.0);
INSERT INTO `countrylanguage` VALUES ('BDI', 'French', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('BDI', 'Kirundi', 'T', 98.1);
INSERT INTO `countrylanguage` VALUES ('BDI', 'Swahili', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('BEL', 'Arabic', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('BEL', 'Dutch', 'T', 59.2);
INSERT INTO `countrylanguage` VALUES ('BEL', 'French', 'T', 32.6);
INSERT INTO `countrylanguage` VALUES ('BEL', 'German', 'T', 1.0);
INSERT INTO `countrylanguage` VALUES ('BEL', 'Italian', 'F', 2.4);
INSERT INTO `countrylanguage` VALUES ('BEL', 'Turkish', 'F', 0.9);
INSERT INTO `countrylanguage` VALUES ('BEN', 'Adja', 'F', 11.1);
INSERT INTO `countrylanguage` VALUES ('BEN', 'Aizo', 'F', 8.7);
INSERT INTO `countrylanguage` VALUES ('BEN', 'Bariba', 'F', 8.7);
INSERT INTO `countrylanguage` VALUES ('BEN', 'Fon', 'F', 39.8);
INSERT INTO `countrylanguage` VALUES ('BEN', 'Ful', 'F', 5.6);
INSERT INTO `countrylanguage` VALUES ('BEN', 'Joruba', 'F', 12.2);
INSERT INTO `countrylanguage` VALUES ('BEN', 'Somba', 'F', 6.7);
INSERT INTO `countrylanguage` VALUES ('BFA', 'Busansi', 'F', 3.5);
INSERT INTO `countrylanguage` VALUES ('BFA', 'Dagara', 'F', 3.1);
INSERT INTO `countrylanguage` VALUES ('BFA', 'Dyula', 'F', 2.6);
INSERT INTO `countrylanguage` VALUES ('BFA', 'Ful', 'F', 9.7);
INSERT INTO `countrylanguage` VALUES ('BFA', 'Gurma', 'F', 5.7);
INSERT INTO `countrylanguage` VALUES ('BFA', 'Mossi', 'F', 50.2);
INSERT INTO `countrylanguage` VALUES ('BGD', 'Bengali', 'T', 97.7);
INSERT INTO `countrylanguage` VALUES ('BGD', 'Chakma', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('BGD', 'Garo', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('BGD', 'Khasi', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('BGD', 'Marma', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('BGD', 'Santhali', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('BGD', 'Tripuri', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('BGR', 'Bulgariana', 'T', 83.2);
INSERT INTO `countrylanguage` VALUES ('BGR', 'Macedonian', 'F', 2.6);
INSERT INTO `countrylanguage` VALUES ('BGR', 'Romani', 'F', 3.7);
INSERT INTO `countrylanguage` VALUES ('BGR', 'Turkish', 'F', 9.4);
INSERT INTO `countrylanguage` VALUES ('BHR', 'Arabic', 'T', 67.7);
INSERT INTO `countrylanguage` VALUES ('BHR', 'English', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('BHS', 'Creole English', 'F', 89.7);
INSERT INTO `countrylanguage` VALUES ('BHS', 'Creole French', 'F', 10.3);
INSERT INTO `countrylanguage` VALUES ('BIH', 'Serbo-Croatian', 'T', 99.2);
INSERT INTO `countrylanguage` VALUES ('BLR', 'Belorussian', 'T', 65.6);
INSERT INTO `countrylanguage` VALUES ('BLR', 'Polish', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('BLR', 'Russian', 'T', 32.0);
INSERT INTO `countrylanguage` VALUES ('BLR', 'Ukrainian', 'F', 1.3);
INSERT INTO `countrylanguage` VALUES ('BLZ', 'English', 'T', 50.8);
INSERT INTO `countrylanguage` VALUES ('BLZ', 'Garifuna', 'F', 6.8);
INSERT INTO `countrylanguage` VALUES ('BLZ', 'Maya Languages', 'F', 9.6);
INSERT INTO `countrylanguage` VALUES ('BLZ', 'Spanish', 'F', 31.6);
INSERT INTO `countrylanguage` VALUES ('BMU', 'English', 'T', 100.0);
INSERT INTO `countrylanguage` VALUES ('BOL', 'Aimará', 'T', 3.2);
INSERT INTO `countrylanguage` VALUES ('BOL', 'Guaraní', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('BOL', 'Ketšua', 'T', 8.1);
INSERT INTO `countrylanguage` VALUES ('BOL', 'Spanish', 'T', 87.7);
INSERT INTO `countrylanguage` VALUES ('BRA', 'German', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('BRA', 'Indian Languages', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('BRA', 'Italian', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('BRA', 'Japanese', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('BRA', 'Portuguese', 'T', 97.5);
INSERT INTO `countrylanguage` VALUES ('BRB', 'Bajan', 'F', 95.1);
INSERT INTO `countrylanguage` VALUES ('BRB', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('BRN', 'Chinese', 'F', 9.3);
INSERT INTO `countrylanguage` VALUES ('BRN', 'English', 'F', 3.1);
INSERT INTO `countrylanguage` VALUES ('BRN', 'Malay', 'T', 45.5);
INSERT INTO `countrylanguage` VALUES ('BRN', 'Malay-English', 'F', 28.8);
INSERT INTO `countrylanguage` VALUES ('BTN', 'Asami', 'F', 15.2);
INSERT INTO `countrylanguage` VALUES ('BTN', 'Dzongkha', 'T', 50.0);
INSERT INTO `countrylanguage` VALUES ('BTN', 'Nepali', 'F', 34.8);
INSERT INTO `countrylanguage` VALUES ('BWA', 'Khoekhoe', 'F', 2.5);
INSERT INTO `countrylanguage` VALUES ('BWA', 'Ndebele', 'F', 1.3);
INSERT INTO `countrylanguage` VALUES ('BWA', 'San', 'F', 3.5);
INSERT INTO `countrylanguage` VALUES ('BWA', 'Shona', 'F', 12.3);
INSERT INTO `countrylanguage` VALUES ('BWA', 'Tswana', 'F', 75.5);
INSERT INTO `countrylanguage` VALUES ('CAF', 'Banda', 'F', 23.5);
INSERT INTO `countrylanguage` VALUES ('CAF', 'Gbaya', 'F', 23.8);
INSERT INTO `countrylanguage` VALUES ('CAF', 'Mandjia', 'F', 14.8);
INSERT INTO `countrylanguage` VALUES ('CAF', 'Mbum', 'F', 6.4);
INSERT INTO `countrylanguage` VALUES ('CAF', 'Ngbaka', 'F', 7.5);
INSERT INTO `countrylanguage` VALUES ('CAF', 'Sara', 'F', 6.4);
INSERT INTO `countrylanguage` VALUES ('CAN', 'Chinese', 'F', 2.5);
INSERT INTO `countrylanguage` VALUES ('CAN', 'Dutch', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('CAN', 'English', 'T', 60.4);
INSERT INTO `countrylanguage` VALUES ('CAN', 'Eskimo Languages', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('CAN', 'French', 'T', 23.4);
INSERT INTO `countrylanguage` VALUES ('CAN', 'German', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('CAN', 'Italian', 'F', 1.7);
INSERT INTO `countrylanguage` VALUES ('CAN', 'Polish', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('CAN', 'Portuguese', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('CAN', 'Punjabi', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('CAN', 'Spanish', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('CAN', 'Ukrainian', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('CCK', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('CCK', 'Malay', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('CHE', 'French', 'T', 19.2);
INSERT INTO `countrylanguage` VALUES ('CHE', 'German', 'T', 63.6);
INSERT INTO `countrylanguage` VALUES ('CHE', 'Italian', 'T', 7.7);
INSERT INTO `countrylanguage` VALUES ('CHE', 'Romansh', 'T', 0.6);
INSERT INTO `countrylanguage` VALUES ('CHL', 'Aimará', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('CHL', 'Araucan', 'F', 9.6);
INSERT INTO `countrylanguage` VALUES ('CHL', 'Rapa nui', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('CHL', 'Spanish', 'T', 89.7);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Chinese', 'T', 92.0);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Dong', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Hui', 'F', 0.8);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Mantšu', 'F', 0.9);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Miao', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Mongolian', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Puyi', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Tibetan', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Tujia', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Uighur', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Yi', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('CHN', 'Zhuang', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('CIV', '[South]Mande', 'F', 7.7);
INSERT INTO `countrylanguage` VALUES ('CIV', 'Akan', 'F', 30.0);
INSERT INTO `countrylanguage` VALUES ('CIV', 'Gur', 'F', 11.7);
INSERT INTO `countrylanguage` VALUES ('CIV', 'Kru', 'F', 10.5);
INSERT INTO `countrylanguage` VALUES ('CIV', 'Malinke', 'F', 11.4);
INSERT INTO `countrylanguage` VALUES ('CMR', 'Bamileke-bamum', 'F', 18.6);
INSERT INTO `countrylanguage` VALUES ('CMR', 'Duala', 'F', 10.9);
INSERT INTO `countrylanguage` VALUES ('CMR', 'Fang', 'F', 19.7);
INSERT INTO `countrylanguage` VALUES ('CMR', 'Ful', 'F', 9.6);
INSERT INTO `countrylanguage` VALUES ('CMR', 'Maka', 'F', 4.9);
INSERT INTO `countrylanguage` VALUES ('CMR', 'Mandara', 'F', 5.7);
INSERT INTO `countrylanguage` VALUES ('CMR', 'Masana', 'F', 3.9);
INSERT INTO `countrylanguage` VALUES ('CMR', 'Tikar', 'F', 7.4);
INSERT INTO `countrylanguage` VALUES ('COD', 'Boa', 'F', 2.3);
INSERT INTO `countrylanguage` VALUES ('COD', 'Chokwe', 'F', 1.8);
INSERT INTO `countrylanguage` VALUES ('COD', 'Kongo', 'F', 16.0);
INSERT INTO `countrylanguage` VALUES ('COD', 'Luba', 'F', 18.0);
INSERT INTO `countrylanguage` VALUES ('COD', 'Mongo', 'F', 13.5);
INSERT INTO `countrylanguage` VALUES ('COD', 'Ngala and Bangi', 'F', 5.8);
INSERT INTO `countrylanguage` VALUES ('COD', 'Rundi', 'F', 3.8);
INSERT INTO `countrylanguage` VALUES ('COD', 'Rwanda', 'F', 10.3);
INSERT INTO `countrylanguage` VALUES ('COD', 'Teke', 'F', 2.7);
INSERT INTO `countrylanguage` VALUES ('COD', 'Zande', 'F', 6.1);
INSERT INTO `countrylanguage` VALUES ('COG', 'Kongo', 'F', 51.5);
INSERT INTO `countrylanguage` VALUES ('COG', 'Mbete', 'F', 4.8);
INSERT INTO `countrylanguage` VALUES ('COG', 'Mboshi', 'F', 11.4);
INSERT INTO `countrylanguage` VALUES ('COG', 'Punu', 'F', 2.9);
INSERT INTO `countrylanguage` VALUES ('COG', 'Sango', 'F', 2.6);
INSERT INTO `countrylanguage` VALUES ('COG', 'Teke', 'F', 17.3);
INSERT INTO `countrylanguage` VALUES ('COK', 'English', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('COK', 'Maori', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('COL', 'Arawakan', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('COL', 'Caribbean', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('COL', 'Chibcha', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('COL', 'Creole English', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('COL', 'Spanish', 'T', 99.0);
INSERT INTO `countrylanguage` VALUES ('COM', 'Comorian', 'T', 75.0);
INSERT INTO `countrylanguage` VALUES ('COM', 'Comorian-Arabic', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('COM', 'Comorian-French', 'F', 12.9);
INSERT INTO `countrylanguage` VALUES ('COM', 'Comorian-madagassi', 'F', 5.5);
INSERT INTO `countrylanguage` VALUES ('COM', 'Comorian-Swahili', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('CPV', 'Crioulo', 'F', 100.0);
INSERT INTO `countrylanguage` VALUES ('CPV', 'Portuguese', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('CRI', 'Chibcha', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('CRI', 'Chinese', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('CRI', 'Creole English', 'F', 2.0);
INSERT INTO `countrylanguage` VALUES ('CRI', 'Spanish', 'T', 97.5);
INSERT INTO `countrylanguage` VALUES ('CUB', 'Spanish', 'T', 100.0);
INSERT INTO `countrylanguage` VALUES ('CXR', 'Chinese', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('CXR', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('CYM', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('CYP', 'Greek', 'T', 74.1);
INSERT INTO `countrylanguage` VALUES ('CYP', 'Turkish', 'T', 22.4);
INSERT INTO `countrylanguage` VALUES ('CZE', 'Czech', 'T', 81.2);
INSERT INTO `countrylanguage` VALUES ('CZE', 'German', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('CZE', 'Hungarian', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('CZE', 'Moravian', 'F', 12.9);
INSERT INTO `countrylanguage` VALUES ('CZE', 'Polish', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('CZE', 'Romani', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('CZE', 'Silesiana', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('CZE', 'Slovak', 'F', 3.1);
INSERT INTO `countrylanguage` VALUES ('DEU', 'German', 'T', 91.3);
INSERT INTO `countrylanguage` VALUES ('DEU', 'Greek', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('DEU', 'Italian', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('DEU', 'Polish', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('DEU', 'Southern Slavic Languages', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('DEU', 'Turkish', 'F', 2.6);
INSERT INTO `countrylanguage` VALUES ('DJI', 'Afar', 'F', 34.8);
INSERT INTO `countrylanguage` VALUES ('DJI', 'Arabic', 'T', 10.6);
INSERT INTO `countrylanguage` VALUES ('DJI', 'Somali', 'F', 43.9);
INSERT INTO `countrylanguage` VALUES ('DMA', 'Creole English', 'F', 100.0);
INSERT INTO `countrylanguage` VALUES ('DMA', 'Creole French', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('DNK', 'Arabic', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('DNK', 'Danish', 'T', 93.5);
INSERT INTO `countrylanguage` VALUES ('DNK', 'English', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('DNK', 'German', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('DNK', 'Norwegian', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('DNK', 'Swedish', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('DNK', 'Turkish', 'F', 0.8);
INSERT INTO `countrylanguage` VALUES ('DOM', 'Creole French', 'F', 2.0);
INSERT INTO `countrylanguage` VALUES ('DOM', 'Spanish', 'T', 98.0);
INSERT INTO `countrylanguage` VALUES ('DZA', 'Arabic', 'T', 86.0);
INSERT INTO `countrylanguage` VALUES ('DZA', 'Berberi', 'F', 14.0);
INSERT INTO `countrylanguage` VALUES ('ECU', 'Ketšua', 'F', 7.0);
INSERT INTO `countrylanguage` VALUES ('ECU', 'Spanish', 'T', 93.0);
INSERT INTO `countrylanguage` VALUES ('EGY', 'Arabic', 'T', 98.8);
INSERT INTO `countrylanguage` VALUES ('EGY', 'Sinaberberi', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('ERI', 'Afar', 'F', 4.3);
INSERT INTO `countrylanguage` VALUES ('ERI', 'Bilin', 'F', 3.0);
INSERT INTO `countrylanguage` VALUES ('ERI', 'Hadareb', 'F', 3.8);
INSERT INTO `countrylanguage` VALUES ('ERI', 'Saho', 'F', 3.0);
INSERT INTO `countrylanguage` VALUES ('ERI', 'Tigre', 'F', 31.7);
INSERT INTO `countrylanguage` VALUES ('ERI', 'Tigrinja', 'T', 49.1);
INSERT INTO `countrylanguage` VALUES ('ESH', 'Arabic', 'T', 100.0);
INSERT INTO `countrylanguage` VALUES ('ESP', 'Basque', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('ESP', 'Catalan', 'F', 16.9);
INSERT INTO `countrylanguage` VALUES ('ESP', 'Galecian', 'F', 6.4);
INSERT INTO `countrylanguage` VALUES ('ESP', 'Spanish', 'T', 74.4);
INSERT INTO `countrylanguage` VALUES ('EST', 'Belorussian', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('EST', 'Estonian', 'T', 65.3);
INSERT INTO `countrylanguage` VALUES ('EST', 'Finnish', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('EST', 'Russian', 'F', 27.8);
INSERT INTO `countrylanguage` VALUES ('EST', 'Ukrainian', 'F', 2.8);
INSERT INTO `countrylanguage` VALUES ('ETH', 'Amhara', 'F', 30.0);
INSERT INTO `countrylanguage` VALUES ('ETH', 'Gurage', 'F', 4.7);
INSERT INTO `countrylanguage` VALUES ('ETH', 'Oromo', 'F', 31.0);
INSERT INTO `countrylanguage` VALUES ('ETH', 'Sidamo', 'F', 3.2);
INSERT INTO `countrylanguage` VALUES ('ETH', 'Somali', 'F', 4.1);
INSERT INTO `countrylanguage` VALUES ('ETH', 'Tigrinja', 'F', 7.2);
INSERT INTO `countrylanguage` VALUES ('ETH', 'Walaita', 'F', 2.8);
INSERT INTO `countrylanguage` VALUES ('FIN', 'Estonian', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('FIN', 'Finnish', 'T', 92.7);
INSERT INTO `countrylanguage` VALUES ('FIN', 'Russian', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('FIN', 'Saame', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('FIN', 'Swedish', 'T', 5.7);
INSERT INTO `countrylanguage` VALUES ('FJI', 'Fijian', 'T', 50.8);
INSERT INTO `countrylanguage` VALUES ('FJI', 'Hindi', 'F', 43.7);
INSERT INTO `countrylanguage` VALUES ('FLK', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('FRA', 'Arabic', 'F', 2.5);
INSERT INTO `countrylanguage` VALUES ('FRA', 'French', 'T', 93.6);
INSERT INTO `countrylanguage` VALUES ('FRA', 'Italian', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('FRA', 'Portuguese', 'F', 1.2);
INSERT INTO `countrylanguage` VALUES ('FRA', 'Spanish', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('FRA', 'Turkish', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('FRO', 'Danish', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('FRO', 'Faroese', 'T', 100.0);
INSERT INTO `countrylanguage` VALUES ('FSM', 'Kosrean', 'F', 7.3);
INSERT INTO `countrylanguage` VALUES ('FSM', 'Mortlock', 'F', 7.6);
INSERT INTO `countrylanguage` VALUES ('FSM', 'Pohnpei', 'F', 23.8);
INSERT INTO `countrylanguage` VALUES ('FSM', 'Trukese', 'F', 41.6);
INSERT INTO `countrylanguage` VALUES ('FSM', 'Wolea', 'F', 3.7);
INSERT INTO `countrylanguage` VALUES ('FSM', 'Yap', 'F', 5.8);
INSERT INTO `countrylanguage` VALUES ('GAB', 'Fang', 'F', 35.8);
INSERT INTO `countrylanguage` VALUES ('GAB', 'Mbete', 'F', 13.8);
INSERT INTO `countrylanguage` VALUES ('GAB', 'Mpongwe', 'F', 14.6);
INSERT INTO `countrylanguage` VALUES ('GAB', 'Punu-sira-nzebi', 'F', 17.1);
INSERT INTO `countrylanguage` VALUES ('GBR', 'English', 'T', 97.3);
INSERT INTO `countrylanguage` VALUES ('GBR', 'Gaeli', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('GBR', 'Kymri', 'F', 0.9);
INSERT INTO `countrylanguage` VALUES ('GEO', 'Abhyasi', 'F', 1.7);
INSERT INTO `countrylanguage` VALUES ('GEO', 'Armenian', 'F', 6.8);
INSERT INTO `countrylanguage` VALUES ('GEO', 'Azerbaijani', 'F', 5.5);
INSERT INTO `countrylanguage` VALUES ('GEO', 'Georgiana', 'T', 71.7);
INSERT INTO `countrylanguage` VALUES ('GEO', 'Osseetti', 'F', 2.4);
INSERT INTO `countrylanguage` VALUES ('GEO', 'Russian', 'F', 8.8);
INSERT INTO `countrylanguage` VALUES ('GHA', 'Akan', 'F', 52.4);
INSERT INTO `countrylanguage` VALUES ('GHA', 'Ewe', 'F', 11.9);
INSERT INTO `countrylanguage` VALUES ('GHA', 'Ga-adangme', 'F', 7.8);
INSERT INTO `countrylanguage` VALUES ('GHA', 'Gurma', 'F', 3.3);
INSERT INTO `countrylanguage` VALUES ('GHA', 'Joruba', 'F', 1.3);
INSERT INTO `countrylanguage` VALUES ('GHA', 'Mossi', 'F', 15.8);
INSERT INTO `countrylanguage` VALUES ('GIB', 'Arabic', 'F', 7.4);
INSERT INTO `countrylanguage` VALUES ('GIB', 'English', 'T', 88.9);
INSERT INTO `countrylanguage` VALUES ('GIN', 'Ful', 'F', 38.6);
INSERT INTO `countrylanguage` VALUES ('GIN', 'Kissi', 'F', 6.0);
INSERT INTO `countrylanguage` VALUES ('GIN', 'Kpelle', 'F', 4.6);
INSERT INTO `countrylanguage` VALUES ('GIN', 'Loma', 'F', 2.3);
INSERT INTO `countrylanguage` VALUES ('GIN', 'Malinke', 'F', 23.2);
INSERT INTO `countrylanguage` VALUES ('GIN', 'Susu', 'F', 11.0);
INSERT INTO `countrylanguage` VALUES ('GIN', 'Yalunka', 'F', 2.9);
INSERT INTO `countrylanguage` VALUES ('GLP', 'Creole French', 'F', 95.0);
INSERT INTO `countrylanguage` VALUES ('GLP', 'French', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('GMB', 'Diola', 'F', 9.2);
INSERT INTO `countrylanguage` VALUES ('GMB', 'Ful', 'F', 16.2);
INSERT INTO `countrylanguage` VALUES ('GMB', 'Malinke', 'F', 34.1);
INSERT INTO `countrylanguage` VALUES ('GMB', 'Soninke', 'F', 7.6);
INSERT INTO `countrylanguage` VALUES ('GMB', 'Wolof', 'F', 12.6);
INSERT INTO `countrylanguage` VALUES ('GNB', 'Balante', 'F', 14.6);
INSERT INTO `countrylanguage` VALUES ('GNB', 'Crioulo', 'F', 36.4);
INSERT INTO `countrylanguage` VALUES ('GNB', 'Ful', 'F', 16.6);
INSERT INTO `countrylanguage` VALUES ('GNB', 'Malinke', 'F', 6.9);
INSERT INTO `countrylanguage` VALUES ('GNB', 'Mandyako', 'F', 4.9);
INSERT INTO `countrylanguage` VALUES ('GNB', 'Portuguese', 'T', 8.1);
INSERT INTO `countrylanguage` VALUES ('GNQ', 'Bubi', 'F', 8.7);
INSERT INTO `countrylanguage` VALUES ('GNQ', 'Fang', 'F', 84.8);
INSERT INTO `countrylanguage` VALUES ('GRC', 'Greek', 'T', 98.5);
INSERT INTO `countrylanguage` VALUES ('GRC', 'Turkish', 'F', 0.9);
INSERT INTO `countrylanguage` VALUES ('GRD', 'Creole English', 'F', 100.0);
INSERT INTO `countrylanguage` VALUES ('GRL', 'Danish', 'T', 12.5);
INSERT INTO `countrylanguage` VALUES ('GRL', 'Greenlandic', 'T', 87.5);
INSERT INTO `countrylanguage` VALUES ('GTM', 'Cakchiquel', 'F', 8.9);
INSERT INTO `countrylanguage` VALUES ('GTM', 'Kekchí', 'F', 4.9);
INSERT INTO `countrylanguage` VALUES ('GTM', 'Mam', 'F', 2.7);
INSERT INTO `countrylanguage` VALUES ('GTM', 'Quiché', 'F', 10.1);
INSERT INTO `countrylanguage` VALUES ('GTM', 'Spanish', 'T', 64.7);
INSERT INTO `countrylanguage` VALUES ('GUF', 'Creole French', 'F', 94.3);
INSERT INTO `countrylanguage` VALUES ('GUF', 'Indian Languages', 'F', 1.9);
INSERT INTO `countrylanguage` VALUES ('GUM', 'Chamorro', 'T', 29.6);
INSERT INTO `countrylanguage` VALUES ('GUM', 'English', 'T', 37.5);
INSERT INTO `countrylanguage` VALUES ('GUM', 'Japanese', 'F', 2.0);
INSERT INTO `countrylanguage` VALUES ('GUM', 'Korean', 'F', 3.3);
INSERT INTO `countrylanguage` VALUES ('GUM', 'Philippene Languages', 'F', 19.7);
INSERT INTO `countrylanguage` VALUES ('GUY', 'Arawakan', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('GUY', 'Caribbean', 'F', 2.2);
INSERT INTO `countrylanguage` VALUES ('GUY', 'Creole English', 'F', 96.4);
INSERT INTO `countrylanguage` VALUES ('HKG', 'Canton Chinese', 'F', 88.7);
INSERT INTO `countrylanguage` VALUES ('HKG', 'Chiu chau', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('HKG', 'English', 'T', 2.2);
INSERT INTO `countrylanguage` VALUES ('HKG', 'Fukien', 'F', 1.9);
INSERT INTO `countrylanguage` VALUES ('HKG', 'Hakka', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('HND', 'Creole English', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('HND', 'Garifuna', 'F', 1.3);
INSERT INTO `countrylanguage` VALUES ('HND', 'Miskito', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('HND', 'Spanish', 'T', 97.2);
INSERT INTO `countrylanguage` VALUES ('HRV', 'Serbo-Croatian', 'T', 95.9);
INSERT INTO `countrylanguage` VALUES ('HRV', 'Slovene', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('HTI', 'French', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('HTI', 'Haiti Creole', 'F', 100.0);
INSERT INTO `countrylanguage` VALUES ('HUN', 'German', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('HUN', 'Hungarian', 'T', 98.5);
INSERT INTO `countrylanguage` VALUES ('HUN', 'Romani', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('HUN', 'Romanian', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('HUN', 'Serbo-Croatian', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('HUN', 'Slovak', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('IDN', 'Bali', 'F', 1.7);
INSERT INTO `countrylanguage` VALUES ('IDN', 'Banja', 'F', 1.8);
INSERT INTO `countrylanguage` VALUES ('IDN', 'Batakki', 'F', 2.2);
INSERT INTO `countrylanguage` VALUES ('IDN', 'Bugi', 'F', 2.2);
INSERT INTO `countrylanguage` VALUES ('IDN', 'Javanese', 'F', 39.4);
INSERT INTO `countrylanguage` VALUES ('IDN', 'Madura', 'F', 4.3);
INSERT INTO `countrylanguage` VALUES ('IDN', 'Malay', 'T', 12.1);
INSERT INTO `countrylanguage` VALUES ('IDN', 'Minangkabau', 'F', 2.4);
INSERT INTO `countrylanguage` VALUES ('IDN', 'Sunda', 'F', 15.8);
INSERT INTO `countrylanguage` VALUES ('IND', 'Asami', 'F', 1.5);
INSERT INTO `countrylanguage` VALUES ('IND', 'Bengali', 'F', 8.2);
INSERT INTO `countrylanguage` VALUES ('IND', 'Gujarati', 'F', 4.8);
INSERT INTO `countrylanguage` VALUES ('IND', 'Hindi', 'T', 39.9);
INSERT INTO `countrylanguage` VALUES ('IND', 'Kannada', 'F', 3.9);
INSERT INTO `countrylanguage` VALUES ('IND', 'Malajalam', 'F', 3.6);
INSERT INTO `countrylanguage` VALUES ('IND', 'Marathi', 'F', 7.4);
INSERT INTO `countrylanguage` VALUES ('IND', 'Orija', 'F', 3.3);
INSERT INTO `countrylanguage` VALUES ('IND', 'Punjabi', 'F', 2.8);
INSERT INTO `countrylanguage` VALUES ('IND', 'Tamil', 'F', 6.3);
INSERT INTO `countrylanguage` VALUES ('IND', 'Telugu', 'F', 7.8);
INSERT INTO `countrylanguage` VALUES ('IND', 'Urdu', 'F', 5.1);
INSERT INTO `countrylanguage` VALUES ('IRL', 'English', 'T', 98.4);
INSERT INTO `countrylanguage` VALUES ('IRL', 'Irish', 'T', 1.6);
INSERT INTO `countrylanguage` VALUES ('IRN', 'Arabic', 'F', 2.2);
INSERT INTO `countrylanguage` VALUES ('IRN', 'Azerbaijani', 'F', 16.8);
INSERT INTO `countrylanguage` VALUES ('IRN', 'Bakhtyari', 'F', 1.7);
INSERT INTO `countrylanguage` VALUES ('IRN', 'Balochi', 'F', 2.3);
INSERT INTO `countrylanguage` VALUES ('IRN', 'Gilaki', 'F', 5.3);
INSERT INTO `countrylanguage` VALUES ('IRN', 'Kurdish', 'F', 9.1);
INSERT INTO `countrylanguage` VALUES ('IRN', 'Luri', 'F', 4.3);
INSERT INTO `countrylanguage` VALUES ('IRN', 'Mazandarani', 'F', 3.6);
INSERT INTO `countrylanguage` VALUES ('IRN', 'Persian', 'T', 45.7);
INSERT INTO `countrylanguage` VALUES ('IRN', 'Turkmenian', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('IRQ', 'Arabic', 'T', 77.2);
INSERT INTO `countrylanguage` VALUES ('IRQ', 'Assyrian', 'F', 0.8);
INSERT INTO `countrylanguage` VALUES ('IRQ', 'Azerbaijani', 'F', 1.7);
INSERT INTO `countrylanguage` VALUES ('IRQ', 'Kurdish', 'F', 19.0);
INSERT INTO `countrylanguage` VALUES ('IRQ', 'Persian', 'F', 0.8);
INSERT INTO `countrylanguage` VALUES ('ISL', 'English', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('ISL', 'Icelandic', 'T', 95.7);
INSERT INTO `countrylanguage` VALUES ('ISR', 'Arabic', 'T', 18.0);
INSERT INTO `countrylanguage` VALUES ('ISR', 'Hebrew', 'T', 63.1);
INSERT INTO `countrylanguage` VALUES ('ISR', 'Russian', 'F', 8.9);
INSERT INTO `countrylanguage` VALUES ('ITA', 'Albaniana', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('ITA', 'French', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('ITA', 'Friuli', 'F', 1.2);
INSERT INTO `countrylanguage` VALUES ('ITA', 'German', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('ITA', 'Italian', 'T', 94.1);
INSERT INTO `countrylanguage` VALUES ('ITA', 'Romani', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('ITA', 'Sardinian', 'F', 2.7);
INSERT INTO `countrylanguage` VALUES ('ITA', 'Slovene', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('JAM', 'Creole English', 'F', 94.2);
INSERT INTO `countrylanguage` VALUES ('JAM', 'Hindi', 'F', 1.9);
INSERT INTO `countrylanguage` VALUES ('JOR', 'Arabic', 'T', 97.9);
INSERT INTO `countrylanguage` VALUES ('JOR', 'Armenian', 'F', 1.0);
INSERT INTO `countrylanguage` VALUES ('JOR', 'Circassian', 'F', 1.0);
INSERT INTO `countrylanguage` VALUES ('JPN', 'Ainu', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('JPN', 'Chinese', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('JPN', 'English', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('JPN', 'Japanese', 'T', 99.1);
INSERT INTO `countrylanguage` VALUES ('JPN', 'Korean', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('JPN', 'Philippene Languages', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('KAZ', 'German', 'F', 3.1);
INSERT INTO `countrylanguage` VALUES ('KAZ', 'Kazakh', 'T', 46.0);
INSERT INTO `countrylanguage` VALUES ('KAZ', 'Russian', 'F', 34.7);
INSERT INTO `countrylanguage` VALUES ('KAZ', 'Tatar', 'F', 2.0);
INSERT INTO `countrylanguage` VALUES ('KAZ', 'Ukrainian', 'F', 5.0);
INSERT INTO `countrylanguage` VALUES ('KAZ', 'Uzbek', 'F', 2.3);
INSERT INTO `countrylanguage` VALUES ('KEN', 'Gusii', 'F', 6.1);
INSERT INTO `countrylanguage` VALUES ('KEN', 'Kalenjin', 'F', 10.8);
INSERT INTO `countrylanguage` VALUES ('KEN', 'Kamba', 'F', 11.2);
INSERT INTO `countrylanguage` VALUES ('KEN', 'Kikuyu', 'F', 20.9);
INSERT INTO `countrylanguage` VALUES ('KEN', 'Luhya', 'F', 13.8);
INSERT INTO `countrylanguage` VALUES ('KEN', 'Luo', 'F', 12.8);
INSERT INTO `countrylanguage` VALUES ('KEN', 'Masai', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('KEN', 'Meru', 'F', 5.5);
INSERT INTO `countrylanguage` VALUES ('KEN', 'Nyika', 'F', 4.8);
INSERT INTO `countrylanguage` VALUES ('KEN', 'Turkana', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('KGZ', 'Kazakh', 'F', 0.8);
INSERT INTO `countrylanguage` VALUES ('KGZ', 'Kirgiz', 'T', 59.7);
INSERT INTO `countrylanguage` VALUES ('KGZ', 'Russian', 'T', 16.2);
INSERT INTO `countrylanguage` VALUES ('KGZ', 'Tadzhik', 'F', 0.8);
INSERT INTO `countrylanguage` VALUES ('KGZ', 'Tatar', 'F', 1.3);
INSERT INTO `countrylanguage` VALUES ('KGZ', 'Ukrainian', 'F', 1.7);
INSERT INTO `countrylanguage` VALUES ('KGZ', 'Uzbek', 'F', 14.1);
INSERT INTO `countrylanguage` VALUES ('KHM', 'Chinese', 'F', 3.1);
INSERT INTO `countrylanguage` VALUES ('KHM', 'Khmer', 'T', 88.6);
INSERT INTO `countrylanguage` VALUES ('KHM', 'Tšam', 'F', 2.4);
INSERT INTO `countrylanguage` VALUES ('KHM', 'Vietnamese', 'F', 5.5);
INSERT INTO `countrylanguage` VALUES ('KIR', 'Kiribati', 'T', 98.9);
INSERT INTO `countrylanguage` VALUES ('KIR', 'Tuvalu', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('KNA', 'Creole English', 'F', 100.0);
INSERT INTO `countrylanguage` VALUES ('KNA', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('KOR', 'Chinese', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('KOR', 'Korean', 'T', 99.9);
INSERT INTO `countrylanguage` VALUES ('KWT', 'Arabic', 'T', 78.1);
INSERT INTO `countrylanguage` VALUES ('KWT', 'English', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('LAO', 'Lao', 'T', 67.2);
INSERT INTO `countrylanguage` VALUES ('LAO', 'Lao-Soung', 'F', 5.2);
INSERT INTO `countrylanguage` VALUES ('LAO', 'Mon-khmer', 'F', 16.5);
INSERT INTO `countrylanguage` VALUES ('LAO', 'Thai', 'F', 7.8);
INSERT INTO `countrylanguage` VALUES ('LBN', 'Arabic', 'T', 93.0);
INSERT INTO `countrylanguage` VALUES ('LBN', 'Armenian', 'F', 5.9);
INSERT INTO `countrylanguage` VALUES ('LBN', 'French', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('LBR', 'Bassa', 'F', 13.7);
INSERT INTO `countrylanguage` VALUES ('LBR', 'Gio', 'F', 7.9);
INSERT INTO `countrylanguage` VALUES ('LBR', 'Grebo', 'F', 8.9);
INSERT INTO `countrylanguage` VALUES ('LBR', 'Kpelle', 'F', 19.5);
INSERT INTO `countrylanguage` VALUES ('LBR', 'Kru', 'F', 7.2);
INSERT INTO `countrylanguage` VALUES ('LBR', 'Loma', 'F', 5.8);
INSERT INTO `countrylanguage` VALUES ('LBR', 'Malinke', 'F', 5.1);
INSERT INTO `countrylanguage` VALUES ('LBR', 'Mano', 'F', 7.2);
INSERT INTO `countrylanguage` VALUES ('LBY', 'Arabic', 'T', 96.0);
INSERT INTO `countrylanguage` VALUES ('LBY', 'Berberi', 'F', 1.0);
INSERT INTO `countrylanguage` VALUES ('LCA', 'Creole French', 'F', 80.0);
INSERT INTO `countrylanguage` VALUES ('LCA', 'English', 'T', 20.0);
INSERT INTO `countrylanguage` VALUES ('LIE', 'German', 'T', 89.0);
INSERT INTO `countrylanguage` VALUES ('LIE', 'Italian', 'F', 2.5);
INSERT INTO `countrylanguage` VALUES ('LIE', 'Turkish', 'F', 2.5);
INSERT INTO `countrylanguage` VALUES ('LKA', 'Mixed Languages', 'F', 19.6);
INSERT INTO `countrylanguage` VALUES ('LKA', 'Singali', 'T', 60.3);
INSERT INTO `countrylanguage` VALUES ('LKA', 'Tamil', 'T', 19.6);
INSERT INTO `countrylanguage` VALUES ('LSO', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('LSO', 'Sotho', 'T', 85.0);
INSERT INTO `countrylanguage` VALUES ('LSO', 'Zulu', 'F', 15.0);
INSERT INTO `countrylanguage` VALUES ('LTU', 'Belorussian', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('LTU', 'Lithuanian', 'T', 81.6);
INSERT INTO `countrylanguage` VALUES ('LTU', 'Polish', 'F', 7.0);
INSERT INTO `countrylanguage` VALUES ('LTU', 'Russian', 'F', 8.1);
INSERT INTO `countrylanguage` VALUES ('LTU', 'Ukrainian', 'F', 1.1);
INSERT INTO `countrylanguage` VALUES ('LUX', 'French', 'T', 4.2);
INSERT INTO `countrylanguage` VALUES ('LUX', 'German', 'T', 2.3);
INSERT INTO `countrylanguage` VALUES ('LUX', 'Italian', 'F', 4.6);
INSERT INTO `countrylanguage` VALUES ('LUX', 'Luxembourgish', 'T', 64.4);
INSERT INTO `countrylanguage` VALUES ('LUX', 'Portuguese', 'F', 13.0);
INSERT INTO `countrylanguage` VALUES ('LVA', 'Belorussian', 'F', 4.1);
INSERT INTO `countrylanguage` VALUES ('LVA', 'Latvian', 'T', 55.1);
INSERT INTO `countrylanguage` VALUES ('LVA', 'Lithuanian', 'F', 1.2);
INSERT INTO `countrylanguage` VALUES ('LVA', 'Polish', 'F', 2.1);
INSERT INTO `countrylanguage` VALUES ('LVA', 'Russian', 'F', 32.5);
INSERT INTO `countrylanguage` VALUES ('LVA', 'Ukrainian', 'F', 2.9);
INSERT INTO `countrylanguage` VALUES ('MAC', 'Canton Chinese', 'F', 85.6);
INSERT INTO `countrylanguage` VALUES ('MAC', 'English', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('MAC', 'Mandarin Chinese', 'F', 1.2);
INSERT INTO `countrylanguage` VALUES ('MAC', 'Portuguese', 'T', 2.3);
INSERT INTO `countrylanguage` VALUES ('MAR', 'Arabic', 'T', 65.0);
INSERT INTO `countrylanguage` VALUES ('MAR', 'Berberi', 'F', 33.0);
INSERT INTO `countrylanguage` VALUES ('MCO', 'English', 'F', 6.5);
INSERT INTO `countrylanguage` VALUES ('MCO', 'French', 'T', 41.9);
INSERT INTO `countrylanguage` VALUES ('MCO', 'Italian', 'F', 16.1);
INSERT INTO `countrylanguage` VALUES ('MCO', 'Monegasque', 'F', 16.1);
INSERT INTO `countrylanguage` VALUES ('MDA', 'Bulgariana', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('MDA', 'Gagauzi', 'F', 3.2);
INSERT INTO `countrylanguage` VALUES ('MDA', 'Romanian', 'T', 61.9);
INSERT INTO `countrylanguage` VALUES ('MDA', 'Russian', 'F', 23.2);
INSERT INTO `countrylanguage` VALUES ('MDA', 'Ukrainian', 'F', 8.6);
INSERT INTO `countrylanguage` VALUES ('MDG', 'French', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('MDG', 'Malagasy', 'T', 98.9);
INSERT INTO `countrylanguage` VALUES ('MDV', 'Dhivehi', 'T', 100.0);
INSERT INTO `countrylanguage` VALUES ('MDV', 'English', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('MEX', 'Mixtec', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('MEX', 'Náhuatl', 'F', 1.8);
INSERT INTO `countrylanguage` VALUES ('MEX', 'Otomí', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('MEX', 'Spanish', 'T', 92.1);
INSERT INTO `countrylanguage` VALUES ('MEX', 'Yucatec', 'F', 1.1);
INSERT INTO `countrylanguage` VALUES ('MEX', 'Zapotec', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('MHL', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('MHL', 'Marshallese', 'T', 96.8);
INSERT INTO `countrylanguage` VALUES ('MKD', 'Albaniana', 'F', 22.9);
INSERT INTO `countrylanguage` VALUES ('MKD', 'Macedonian', 'T', 66.5);
INSERT INTO `countrylanguage` VALUES ('MKD', 'Romani', 'F', 2.3);
INSERT INTO `countrylanguage` VALUES ('MKD', 'Serbo-Croatian', 'F', 2.0);
INSERT INTO `countrylanguage` VALUES ('MKD', 'Turkish', 'F', 4.0);
INSERT INTO `countrylanguage` VALUES ('MLI', 'Bambara', 'F', 31.8);
INSERT INTO `countrylanguage` VALUES ('MLI', 'Ful', 'F', 13.9);
INSERT INTO `countrylanguage` VALUES ('MLI', 'Senufo and Minianka', 'F', 12.0);
INSERT INTO `countrylanguage` VALUES ('MLI', 'Songhai', 'F', 6.9);
INSERT INTO `countrylanguage` VALUES ('MLI', 'Soninke', 'F', 8.7);
INSERT INTO `countrylanguage` VALUES ('MLI', 'Tamashek', 'F', 7.3);
INSERT INTO `countrylanguage` VALUES ('MLT', 'English', 'T', 2.1);
INSERT INTO `countrylanguage` VALUES ('MLT', 'Maltese', 'T', 95.8);
INSERT INTO `countrylanguage` VALUES ('MMR', 'Burmese', 'T', 69.0);
INSERT INTO `countrylanguage` VALUES ('MMR', 'Chin', 'F', 2.2);
INSERT INTO `countrylanguage` VALUES ('MMR', 'Kachin', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('MMR', 'Karen', 'F', 6.2);
INSERT INTO `countrylanguage` VALUES ('MMR', 'Kayah', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('MMR', 'Mon', 'F', 2.4);
INSERT INTO `countrylanguage` VALUES ('MMR', 'Rakhine', 'F', 4.5);
INSERT INTO `countrylanguage` VALUES ('MMR', 'Shan', 'F', 8.5);
INSERT INTO `countrylanguage` VALUES ('MNG', 'Bajad', 'F', 1.9);
INSERT INTO `countrylanguage` VALUES ('MNG', 'Buryat', 'F', 1.7);
INSERT INTO `countrylanguage` VALUES ('MNG', 'Dariganga', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('MNG', 'Dorbet', 'F', 2.7);
INSERT INTO `countrylanguage` VALUES ('MNG', 'Kazakh', 'F', 5.9);
INSERT INTO `countrylanguage` VALUES ('MNG', 'Mongolian', 'T', 78.8);
INSERT INTO `countrylanguage` VALUES ('MNP', 'Carolinian', 'F', 4.8);
INSERT INTO `countrylanguage` VALUES ('MNP', 'Chamorro', 'F', 30.0);
INSERT INTO `countrylanguage` VALUES ('MNP', 'Chinese', 'F', 7.1);
INSERT INTO `countrylanguage` VALUES ('MNP', 'English', 'T', 4.8);
INSERT INTO `countrylanguage` VALUES ('MNP', 'Korean', 'F', 6.5);
INSERT INTO `countrylanguage` VALUES ('MNP', 'Philippene Languages', 'F', 34.1);
INSERT INTO `countrylanguage` VALUES ('MOZ', 'Chuabo', 'F', 5.7);
INSERT INTO `countrylanguage` VALUES ('MOZ', 'Lomwe', 'F', 7.8);
INSERT INTO `countrylanguage` VALUES ('MOZ', 'Makua', 'F', 27.8);
INSERT INTO `countrylanguage` VALUES ('MOZ', 'Marendje', 'F', 3.5);
INSERT INTO `countrylanguage` VALUES ('MOZ', 'Nyanja', 'F', 3.3);
INSERT INTO `countrylanguage` VALUES ('MOZ', 'Ronga', 'F', 3.7);
INSERT INTO `countrylanguage` VALUES ('MOZ', 'Sena', 'F', 9.4);
INSERT INTO `countrylanguage` VALUES ('MOZ', 'Shona', 'F', 6.5);
INSERT INTO `countrylanguage` VALUES ('MOZ', 'Tsonga', 'F', 12.4);
INSERT INTO `countrylanguage` VALUES ('MOZ', 'Tswa', 'F', 6.0);
INSERT INTO `countrylanguage` VALUES ('MRT', 'Ful', 'F', 1.2);
INSERT INTO `countrylanguage` VALUES ('MRT', 'Hassaniya', 'F', 81.7);
INSERT INTO `countrylanguage` VALUES ('MRT', 'Soninke', 'F', 2.7);
INSERT INTO `countrylanguage` VALUES ('MRT', 'Tukulor', 'F', 5.4);
INSERT INTO `countrylanguage` VALUES ('MRT', 'Wolof', 'F', 6.6);
INSERT INTO `countrylanguage` VALUES ('MRT', 'Zenaga', 'F', 1.2);
INSERT INTO `countrylanguage` VALUES ('MSR', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('MTQ', 'Creole French', 'F', 96.6);
INSERT INTO `countrylanguage` VALUES ('MTQ', 'French', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('MUS', 'Bhojpuri', 'F', 21.1);
INSERT INTO `countrylanguage` VALUES ('MUS', 'Creole French', 'F', 70.6);
INSERT INTO `countrylanguage` VALUES ('MUS', 'French', 'F', 3.4);
INSERT INTO `countrylanguage` VALUES ('MUS', 'Hindi', 'F', 1.2);
INSERT INTO `countrylanguage` VALUES ('MUS', 'Marathi', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('MUS', 'Tamil', 'F', 0.8);
INSERT INTO `countrylanguage` VALUES ('MWI', 'Chichewa', 'T', 58.3);
INSERT INTO `countrylanguage` VALUES ('MWI', 'Lomwe', 'F', 18.4);
INSERT INTO `countrylanguage` VALUES ('MWI', 'Ngoni', 'F', 6.7);
INSERT INTO `countrylanguage` VALUES ('MWI', 'Yao', 'F', 13.2);
INSERT INTO `countrylanguage` VALUES ('MYS', 'Chinese', 'F', 9.0);
INSERT INTO `countrylanguage` VALUES ('MYS', 'Dusun', 'F', 1.1);
INSERT INTO `countrylanguage` VALUES ('MYS', 'English', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('MYS', 'Iban', 'F', 2.8);
INSERT INTO `countrylanguage` VALUES ('MYS', 'Malay', 'T', 58.4);
INSERT INTO `countrylanguage` VALUES ('MYS', 'Tamil', 'F', 3.9);
INSERT INTO `countrylanguage` VALUES ('MYT', 'French', 'T', 20.3);
INSERT INTO `countrylanguage` VALUES ('MYT', 'Mahoré', 'F', 41.9);
INSERT INTO `countrylanguage` VALUES ('MYT', 'Malagasy', 'F', 16.1);
INSERT INTO `countrylanguage` VALUES ('NAM', 'Afrikaans', 'F', 9.5);
INSERT INTO `countrylanguage` VALUES ('NAM', 'Caprivi', 'F', 4.7);
INSERT INTO `countrylanguage` VALUES ('NAM', 'German', 'F', 0.9);
INSERT INTO `countrylanguage` VALUES ('NAM', 'Herero', 'F', 8.0);
INSERT INTO `countrylanguage` VALUES ('NAM', 'Kavango', 'F', 9.7);
INSERT INTO `countrylanguage` VALUES ('NAM', 'Nama', 'F', 12.4);
INSERT INTO `countrylanguage` VALUES ('NAM', 'Ovambo', 'F', 50.7);
INSERT INTO `countrylanguage` VALUES ('NAM', 'San', 'F', 1.9);
INSERT INTO `countrylanguage` VALUES ('NCL', 'French', 'T', 34.3);
INSERT INTO `countrylanguage` VALUES ('NCL', 'Malenasian Languages', 'F', 45.4);
INSERT INTO `countrylanguage` VALUES ('NCL', 'Polynesian Languages', 'F', 11.6);
INSERT INTO `countrylanguage` VALUES ('NER', 'Ful', 'F', 9.7);
INSERT INTO `countrylanguage` VALUES ('NER', 'Hausa', 'F', 53.1);
INSERT INTO `countrylanguage` VALUES ('NER', 'Kanuri', 'F', 4.4);
INSERT INTO `countrylanguage` VALUES ('NER', 'Songhai-zerma', 'F', 21.2);
INSERT INTO `countrylanguage` VALUES ('NER', 'Tamashek', 'F', 10.4);
INSERT INTO `countrylanguage` VALUES ('NFK', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('NGA', 'Bura', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('NGA', 'Edo', 'F', 3.3);
INSERT INTO `countrylanguage` VALUES ('NGA', 'Ful', 'F', 11.3);
INSERT INTO `countrylanguage` VALUES ('NGA', 'Hausa', 'F', 21.1);
INSERT INTO `countrylanguage` VALUES ('NGA', 'Ibibio', 'F', 5.6);
INSERT INTO `countrylanguage` VALUES ('NGA', 'Ibo', 'F', 18.1);
INSERT INTO `countrylanguage` VALUES ('NGA', 'Ijo', 'F', 1.8);
INSERT INTO `countrylanguage` VALUES ('NGA', 'Joruba', 'F', 21.4);
INSERT INTO `countrylanguage` VALUES ('NGA', 'Kanuri', 'F', 4.1);
INSERT INTO `countrylanguage` VALUES ('NGA', 'Tiv', 'F', 2.3);
INSERT INTO `countrylanguage` VALUES ('NIC', 'Creole English', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('NIC', 'Miskito', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('NIC', 'Spanish', 'T', 97.6);
INSERT INTO `countrylanguage` VALUES ('NIC', 'Sumo', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('NIU', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('NIU', 'Niue', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('NLD', 'Arabic', 'F', 0.9);
INSERT INTO `countrylanguage` VALUES ('NLD', 'Dutch', 'T', 95.6);
INSERT INTO `countrylanguage` VALUES ('NLD', 'Fries', 'F', 3.7);
INSERT INTO `countrylanguage` VALUES ('NLD', 'Turkish', 'F', 0.8);
INSERT INTO `countrylanguage` VALUES ('NOR', 'Danish', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('NOR', 'English', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('NOR', 'Norwegian', 'T', 96.6);
INSERT INTO `countrylanguage` VALUES ('NOR', 'Saame', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('NOR', 'Swedish', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('NPL', 'Bhojpuri', 'F', 7.5);
INSERT INTO `countrylanguage` VALUES ('NPL', 'Hindi', 'F', 3.0);
INSERT INTO `countrylanguage` VALUES ('NPL', 'Maithili', 'F', 11.9);
INSERT INTO `countrylanguage` VALUES ('NPL', 'Nepali', 'T', 50.4);
INSERT INTO `countrylanguage` VALUES ('NPL', 'Newari', 'F', 3.7);
INSERT INTO `countrylanguage` VALUES ('NPL', 'Tamang', 'F', 4.9);
INSERT INTO `countrylanguage` VALUES ('NPL', 'Tharu', 'F', 5.4);
INSERT INTO `countrylanguage` VALUES ('NRU', 'Chinese', 'F', 8.5);
INSERT INTO `countrylanguage` VALUES ('NRU', 'English', 'T', 7.5);
INSERT INTO `countrylanguage` VALUES ('NRU', 'Kiribati', 'F', 17.9);
INSERT INTO `countrylanguage` VALUES ('NRU', 'Nauru', 'T', 57.5);
INSERT INTO `countrylanguage` VALUES ('NRU', 'Tuvalu', 'F', 8.5);
INSERT INTO `countrylanguage` VALUES ('NZL', 'English', 'T', 87.0);
INSERT INTO `countrylanguage` VALUES ('NZL', 'Maori', 'F', 4.3);
INSERT INTO `countrylanguage` VALUES ('OMN', 'Arabic', 'T', 76.7);
INSERT INTO `countrylanguage` VALUES ('OMN', 'Balochi', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('PAK', 'Balochi', 'F', 3.0);
INSERT INTO `countrylanguage` VALUES ('PAK', 'Brahui', 'F', 1.2);
INSERT INTO `countrylanguage` VALUES ('PAK', 'Hindko', 'F', 2.4);
INSERT INTO `countrylanguage` VALUES ('PAK', 'Pashto', 'F', 13.1);
INSERT INTO `countrylanguage` VALUES ('PAK', 'Punjabi', 'F', 48.2);
INSERT INTO `countrylanguage` VALUES ('PAK', 'Saraiki', 'F', 9.8);
INSERT INTO `countrylanguage` VALUES ('PAK', 'Sindhi', 'F', 11.8);
INSERT INTO `countrylanguage` VALUES ('PAK', 'Urdu', 'T', 7.6);
INSERT INTO `countrylanguage` VALUES ('PAN', 'Arabic', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('PAN', 'Creole English', 'F', 14.0);
INSERT INTO `countrylanguage` VALUES ('PAN', 'Cuna', 'F', 2.0);
INSERT INTO `countrylanguage` VALUES ('PAN', 'Embera', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('PAN', 'Guaymí', 'F', 5.3);
INSERT INTO `countrylanguage` VALUES ('PAN', 'Spanish', 'T', 76.8);
INSERT INTO `countrylanguage` VALUES ('PCN', 'Pitcairnese', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('PER', 'Aimará', 'T', 2.3);
INSERT INTO `countrylanguage` VALUES ('PER', 'Ketšua', 'T', 16.4);
INSERT INTO `countrylanguage` VALUES ('PER', 'Spanish', 'T', 79.8);
INSERT INTO `countrylanguage` VALUES ('PHL', 'Bicol', 'F', 5.7);
INSERT INTO `countrylanguage` VALUES ('PHL', 'Cebuano', 'F', 23.3);
INSERT INTO `countrylanguage` VALUES ('PHL', 'Hiligaynon', 'F', 9.1);
INSERT INTO `countrylanguage` VALUES ('PHL', 'Ilocano', 'F', 9.3);
INSERT INTO `countrylanguage` VALUES ('PHL', 'Maguindanao', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('PHL', 'Maranao', 'F', 1.3);
INSERT INTO `countrylanguage` VALUES ('PHL', 'Pampango', 'F', 3.0);
INSERT INTO `countrylanguage` VALUES ('PHL', 'Pangasinan', 'F', 1.8);
INSERT INTO `countrylanguage` VALUES ('PHL', 'Pilipino', 'T', 29.3);
INSERT INTO `countrylanguage` VALUES ('PHL', 'Waray-waray', 'F', 3.8);
INSERT INTO `countrylanguage` VALUES ('PLW', 'Chinese', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('PLW', 'English', 'T', 3.2);
INSERT INTO `countrylanguage` VALUES ('PLW', 'Palau', 'T', 82.2);
INSERT INTO `countrylanguage` VALUES ('PLW', 'Philippene Languages', 'F', 9.2);
INSERT INTO `countrylanguage` VALUES ('PNG', 'Malenasian Languages', 'F', 20.0);
INSERT INTO `countrylanguage` VALUES ('PNG', 'Papuan Languages', 'F', 78.1);
INSERT INTO `countrylanguage` VALUES ('POL', 'Belorussian', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('POL', 'German', 'F', 1.3);
INSERT INTO `countrylanguage` VALUES ('POL', 'Polish', 'T', 97.6);
INSERT INTO `countrylanguage` VALUES ('POL', 'Ukrainian', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('PRI', 'English', 'F', 47.4);
INSERT INTO `countrylanguage` VALUES ('PRI', 'Spanish', 'T', 51.3);
INSERT INTO `countrylanguage` VALUES ('PRK', 'Chinese', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('PRK', 'Korean', 'T', 99.9);
INSERT INTO `countrylanguage` VALUES ('PRT', 'Portuguese', 'T', 99.0);
INSERT INTO `countrylanguage` VALUES ('PRY', 'German', 'F', 0.9);
INSERT INTO `countrylanguage` VALUES ('PRY', 'Guaraní', 'T', 40.1);
INSERT INTO `countrylanguage` VALUES ('PRY', 'Portuguese', 'F', 3.2);
INSERT INTO `countrylanguage` VALUES ('PRY', 'Spanish', 'T', 55.1);
INSERT INTO `countrylanguage` VALUES ('PSE', 'Arabic', 'F', 95.9);
INSERT INTO `countrylanguage` VALUES ('PSE', 'Hebrew', 'F', 4.1);
INSERT INTO `countrylanguage` VALUES ('PYF', 'Chinese', 'F', 2.9);
INSERT INTO `countrylanguage` VALUES ('PYF', 'French', 'T', 40.8);
INSERT INTO `countrylanguage` VALUES ('PYF', 'Tahitian', 'F', 46.4);
INSERT INTO `countrylanguage` VALUES ('QAT', 'Arabic', 'T', 40.7);
INSERT INTO `countrylanguage` VALUES ('QAT', 'Urdu', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('REU', 'Chinese', 'F', 2.8);
INSERT INTO `countrylanguage` VALUES ('REU', 'Comorian', 'F', 2.8);
INSERT INTO `countrylanguage` VALUES ('REU', 'Creole French', 'F', 91.5);
INSERT INTO `countrylanguage` VALUES ('REU', 'Malagasy', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('REU', 'Tamil', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('ROM', 'German', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('ROM', 'Hungarian', 'F', 7.2);
INSERT INTO `countrylanguage` VALUES ('ROM', 'Romani', 'T', 0.7);
INSERT INTO `countrylanguage` VALUES ('ROM', 'Romanian', 'T', 90.7);
INSERT INTO `countrylanguage` VALUES ('ROM', 'Serbo-Croatian', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('ROM', 'Ukrainian', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Avarian', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Bashkir', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Belorussian', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Chechen', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Chuvash', 'F', 0.9);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Kazakh', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Mari', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Mordva', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Russian', 'T', 86.6);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Tatar', 'F', 3.2);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Udmur', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('RUS', 'Ukrainian', 'F', 1.3);
INSERT INTO `countrylanguage` VALUES ('RWA', 'French', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('RWA', 'Rwanda', 'T', 100.0);
INSERT INTO `countrylanguage` VALUES ('SAU', 'Arabic', 'T', 95.0);
INSERT INTO `countrylanguage` VALUES ('SDN', 'Arabic', 'T', 49.4);
INSERT INTO `countrylanguage` VALUES ('SDN', 'Bari', 'F', 2.5);
INSERT INTO `countrylanguage` VALUES ('SDN', 'Beja', 'F', 6.4);
INSERT INTO `countrylanguage` VALUES ('SDN', 'Chilluk', 'F', 1.7);
INSERT INTO `countrylanguage` VALUES ('SDN', 'Dinka', 'F', 11.5);
INSERT INTO `countrylanguage` VALUES ('SDN', 'Fur', 'F', 2.1);
INSERT INTO `countrylanguage` VALUES ('SDN', 'Lotuko', 'F', 1.5);
INSERT INTO `countrylanguage` VALUES ('SDN', 'Nubian Languages', 'F', 8.1);
INSERT INTO `countrylanguage` VALUES ('SDN', 'Nuer', 'F', 4.9);
INSERT INTO `countrylanguage` VALUES ('SDN', 'Zande', 'F', 2.7);
INSERT INTO `countrylanguage` VALUES ('SEN', 'Diola', 'F', 5.0);
INSERT INTO `countrylanguage` VALUES ('SEN', 'Ful', 'F', 21.7);
INSERT INTO `countrylanguage` VALUES ('SEN', 'Malinke', 'F', 3.8);
INSERT INTO `countrylanguage` VALUES ('SEN', 'Serer', 'F', 12.5);
INSERT INTO `countrylanguage` VALUES ('SEN', 'Soninke', 'F', 1.3);
INSERT INTO `countrylanguage` VALUES ('SEN', 'Wolof', 'T', 48.1);
INSERT INTO `countrylanguage` VALUES ('SGP', 'Chinese', 'T', 77.1);
INSERT INTO `countrylanguage` VALUES ('SGP', 'Malay', 'T', 14.1);
INSERT INTO `countrylanguage` VALUES ('SGP', 'Tamil', 'T', 7.4);
INSERT INTO `countrylanguage` VALUES ('SHN', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('SJM', 'Norwegian', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('SJM', 'Russian', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('SLB', 'Malenasian Languages', 'F', 85.6);
INSERT INTO `countrylanguage` VALUES ('SLB', 'Papuan Languages', 'F', 8.6);
INSERT INTO `countrylanguage` VALUES ('SLB', 'Polynesian Languages', 'F', 3.8);
INSERT INTO `countrylanguage` VALUES ('SLE', 'Bullom-sherbro', 'F', 3.8);
INSERT INTO `countrylanguage` VALUES ('SLE', 'Ful', 'F', 3.8);
INSERT INTO `countrylanguage` VALUES ('SLE', 'Kono-vai', 'F', 5.1);
INSERT INTO `countrylanguage` VALUES ('SLE', 'Kuranko', 'F', 3.4);
INSERT INTO `countrylanguage` VALUES ('SLE', 'Limba', 'F', 8.3);
INSERT INTO `countrylanguage` VALUES ('SLE', 'Mende', 'F', 34.8);
INSERT INTO `countrylanguage` VALUES ('SLE', 'Temne', 'F', 31.8);
INSERT INTO `countrylanguage` VALUES ('SLE', 'Yalunka', 'F', 3.4);
INSERT INTO `countrylanguage` VALUES ('SLV', 'Nahua', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('SLV', 'Spanish', 'T', 100.0);
INSERT INTO `countrylanguage` VALUES ('SMR', 'Italian', 'T', 100.0);
INSERT INTO `countrylanguage` VALUES ('SOM', 'Arabic', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('SOM', 'Somali', 'T', 98.3);
INSERT INTO `countrylanguage` VALUES ('SPM', 'French', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('STP', 'Crioulo', 'F', 86.3);
INSERT INTO `countrylanguage` VALUES ('STP', 'French', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('SUR', 'Hindi', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('SUR', 'Sranantonga', 'F', 81.0);
INSERT INTO `countrylanguage` VALUES ('SVK', 'Czech and Moravian', 'F', 1.1);
INSERT INTO `countrylanguage` VALUES ('SVK', 'Hungarian', 'F', 10.5);
INSERT INTO `countrylanguage` VALUES ('SVK', 'Romani', 'F', 1.7);
INSERT INTO `countrylanguage` VALUES ('SVK', 'Slovak', 'T', 85.6);
INSERT INTO `countrylanguage` VALUES ('SVK', 'Ukrainian and Russian', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('SVN', 'Hungarian', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('SVN', 'Serbo-Croatian', 'F', 7.9);
INSERT INTO `countrylanguage` VALUES ('SVN', 'Slovene', 'T', 87.9);
INSERT INTO `countrylanguage` VALUES ('SWE', 'Arabic', 'F', 0.8);
INSERT INTO `countrylanguage` VALUES ('SWE', 'Finnish', 'F', 2.4);
INSERT INTO `countrylanguage` VALUES ('SWE', 'Norwegian', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('SWE', 'Southern Slavic Languages', 'F', 1.3);
INSERT INTO `countrylanguage` VALUES ('SWE', 'Spanish', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('SWE', 'Swedish', 'T', 89.5);
INSERT INTO `countrylanguage` VALUES ('SWZ', 'Swazi', 'T', 89.9);
INSERT INTO `countrylanguage` VALUES ('SWZ', 'Zulu', 'F', 2.0);
INSERT INTO `countrylanguage` VALUES ('SYC', 'English', 'T', 3.8);
INSERT INTO `countrylanguage` VALUES ('SYC', 'French', 'T', 1.3);
INSERT INTO `countrylanguage` VALUES ('SYC', 'Seselwa', 'F', 91.3);
INSERT INTO `countrylanguage` VALUES ('SYR', 'Arabic', 'T', 90.0);
INSERT INTO `countrylanguage` VALUES ('SYR', 'Kurdish', 'F', 9.0);
INSERT INTO `countrylanguage` VALUES ('TCA', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('TCD', 'Arabic', 'T', 12.3);
INSERT INTO `countrylanguage` VALUES ('TCD', 'Gorane', 'F', 6.2);
INSERT INTO `countrylanguage` VALUES ('TCD', 'Hadjarai', 'F', 6.7);
INSERT INTO `countrylanguage` VALUES ('TCD', 'Kanem-bornu', 'F', 9.0);
INSERT INTO `countrylanguage` VALUES ('TCD', 'Mayo-kebbi', 'F', 11.5);
INSERT INTO `countrylanguage` VALUES ('TCD', 'Ouaddai', 'F', 8.7);
INSERT INTO `countrylanguage` VALUES ('TCD', 'Sara', 'F', 27.7);
INSERT INTO `countrylanguage` VALUES ('TCD', 'Tandjile', 'F', 6.5);
INSERT INTO `countrylanguage` VALUES ('TGO', 'Ane', 'F', 5.7);
INSERT INTO `countrylanguage` VALUES ('TGO', 'Ewe', 'T', 23.2);
INSERT INTO `countrylanguage` VALUES ('TGO', 'Gurma', 'F', 3.4);
INSERT INTO `countrylanguage` VALUES ('TGO', 'Kabyé', 'T', 13.8);
INSERT INTO `countrylanguage` VALUES ('TGO', 'Kotokoli', 'F', 5.7);
INSERT INTO `countrylanguage` VALUES ('TGO', 'Moba', 'F', 5.4);
INSERT INTO `countrylanguage` VALUES ('TGO', 'Naudemba', 'F', 4.1);
INSERT INTO `countrylanguage` VALUES ('TGO', 'Watyi', 'F', 10.3);
INSERT INTO `countrylanguage` VALUES ('THA', 'Chinese', 'F', 12.1);
INSERT INTO `countrylanguage` VALUES ('THA', 'Khmer', 'F', 1.3);
INSERT INTO `countrylanguage` VALUES ('THA', 'Kuy', 'F', 1.1);
INSERT INTO `countrylanguage` VALUES ('THA', 'Lao', 'F', 26.9);
INSERT INTO `countrylanguage` VALUES ('THA', 'Malay', 'F', 3.6);
INSERT INTO `countrylanguage` VALUES ('THA', 'Thai', 'T', 52.6);
INSERT INTO `countrylanguage` VALUES ('TJK', 'Russian', 'F', 9.7);
INSERT INTO `countrylanguage` VALUES ('TJK', 'Tadzhik', 'T', 62.2);
INSERT INTO `countrylanguage` VALUES ('TJK', 'Uzbek', 'F', 23.2);
INSERT INTO `countrylanguage` VALUES ('TKL', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('TKL', 'Tokelau', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('TKM', 'Kazakh', 'F', 2.0);
INSERT INTO `countrylanguage` VALUES ('TKM', 'Russian', 'F', 6.7);
INSERT INTO `countrylanguage` VALUES ('TKM', 'Turkmenian', 'T', 76.7);
INSERT INTO `countrylanguage` VALUES ('TKM', 'Uzbek', 'F', 9.2);
INSERT INTO `countrylanguage` VALUES ('TMP', 'Portuguese', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('TMP', 'Sunda', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('TON', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('TON', 'Tongan', 'T', 98.3);
INSERT INTO `countrylanguage` VALUES ('TTO', 'Creole English', 'F', 2.9);
INSERT INTO `countrylanguage` VALUES ('TTO', 'English', 'F', 93.5);
INSERT INTO `countrylanguage` VALUES ('TTO', 'Hindi', 'F', 3.4);
INSERT INTO `countrylanguage` VALUES ('TUN', 'Arabic', 'T', 69.9);
INSERT INTO `countrylanguage` VALUES ('TUN', 'Arabic-French', 'F', 26.3);
INSERT INTO `countrylanguage` VALUES ('TUN', 'Arabic-French-English', 'F', 3.2);
INSERT INTO `countrylanguage` VALUES ('TUR', 'Arabic', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('TUR', 'Kurdish', 'F', 10.6);
INSERT INTO `countrylanguage` VALUES ('TUR', 'Turkish', 'T', 87.6);
INSERT INTO `countrylanguage` VALUES ('TUV', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('TUV', 'Kiribati', 'F', 7.5);
INSERT INTO `countrylanguage` VALUES ('TUV', 'Tuvalu', 'T', 92.5);
INSERT INTO `countrylanguage` VALUES ('TWN', 'Ami', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('TWN', 'Atayal', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('TWN', 'Hakka', 'F', 11.0);
INSERT INTO `countrylanguage` VALUES ('TWN', 'Mandarin Chinese', 'T', 20.1);
INSERT INTO `countrylanguage` VALUES ('TWN', 'Min', 'F', 66.7);
INSERT INTO `countrylanguage` VALUES ('TWN', 'Paiwan', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('TZA', 'Chaga and Pare', 'F', 4.9);
INSERT INTO `countrylanguage` VALUES ('TZA', 'Gogo', 'F', 3.9);
INSERT INTO `countrylanguage` VALUES ('TZA', 'Ha', 'F', 3.5);
INSERT INTO `countrylanguage` VALUES ('TZA', 'Haya', 'F', 5.9);
INSERT INTO `countrylanguage` VALUES ('TZA', 'Hehet', 'F', 6.9);
INSERT INTO `countrylanguage` VALUES ('TZA', 'Luguru', 'F', 4.9);
INSERT INTO `countrylanguage` VALUES ('TZA', 'Makonde', 'F', 5.9);
INSERT INTO `countrylanguage` VALUES ('TZA', 'Nyakusa', 'F', 5.4);
INSERT INTO `countrylanguage` VALUES ('TZA', 'Nyamwesi', 'F', 21.1);
INSERT INTO `countrylanguage` VALUES ('TZA', 'Shambala', 'F', 4.3);
INSERT INTO `countrylanguage` VALUES ('TZA', 'Swahili', 'T', 8.8);
INSERT INTO `countrylanguage` VALUES ('UGA', 'Acholi', 'F', 4.4);
INSERT INTO `countrylanguage` VALUES ('UGA', 'Ganda', 'F', 18.1);
INSERT INTO `countrylanguage` VALUES ('UGA', 'Gisu', 'F', 4.5);
INSERT INTO `countrylanguage` VALUES ('UGA', 'Kiga', 'F', 8.3);
INSERT INTO `countrylanguage` VALUES ('UGA', 'Lango', 'F', 5.9);
INSERT INTO `countrylanguage` VALUES ('UGA', 'Lugbara', 'F', 4.7);
INSERT INTO `countrylanguage` VALUES ('UGA', 'Nkole', 'F', 10.7);
INSERT INTO `countrylanguage` VALUES ('UGA', 'Rwanda', 'F', 3.2);
INSERT INTO `countrylanguage` VALUES ('UGA', 'Soga', 'F', 8.2);
INSERT INTO `countrylanguage` VALUES ('UGA', 'Teso', 'F', 6.0);
INSERT INTO `countrylanguage` VALUES ('UKR', 'Belorussian', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('UKR', 'Bulgariana', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('UKR', 'Hungarian', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('UKR', 'Polish', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('UKR', 'Romanian', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('UKR', 'Russian', 'F', 32.9);
INSERT INTO `countrylanguage` VALUES ('UKR', 'Ukrainian', 'T', 64.7);
INSERT INTO `countrylanguage` VALUES ('UMI', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('URY', 'Spanish', 'T', 95.7);
INSERT INTO `countrylanguage` VALUES ('USA', 'Chinese', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('USA', 'English', 'T', 86.2);
INSERT INTO `countrylanguage` VALUES ('USA', 'French', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('USA', 'German', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('USA', 'Italian', 'F', 0.6);
INSERT INTO `countrylanguage` VALUES ('USA', 'Japanese', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('USA', 'Korean', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('USA', 'Polish', 'F', 0.3);
INSERT INTO `countrylanguage` VALUES ('USA', 'Portuguese', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('USA', 'Spanish', 'F', 7.5);
INSERT INTO `countrylanguage` VALUES ('USA', 'Tagalog', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('USA', 'Vietnamese', 'F', 0.2);
INSERT INTO `countrylanguage` VALUES ('UZB', 'Karakalpak', 'F', 2.0);
INSERT INTO `countrylanguage` VALUES ('UZB', 'Kazakh', 'F', 3.8);
INSERT INTO `countrylanguage` VALUES ('UZB', 'Russian', 'F', 10.9);
INSERT INTO `countrylanguage` VALUES ('UZB', 'Tadzhik', 'F', 4.4);
INSERT INTO `countrylanguage` VALUES ('UZB', 'Tatar', 'F', 1.8);
INSERT INTO `countrylanguage` VALUES ('UZB', 'Uzbek', 'T', 72.6);
INSERT INTO `countrylanguage` VALUES ('VAT', 'Italian', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('VCT', 'Creole English', 'F', 99.1);
INSERT INTO `countrylanguage` VALUES ('VCT', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('VEN', 'Goajiro', 'F', 0.4);
INSERT INTO `countrylanguage` VALUES ('VEN', 'Spanish', 'T', 96.9);
INSERT INTO `countrylanguage` VALUES ('VEN', 'Warrau', 'F', 0.1);
INSERT INTO `countrylanguage` VALUES ('VGB', 'English', 'T', 0.0);
INSERT INTO `countrylanguage` VALUES ('VIR', 'English', 'T', 81.7);
INSERT INTO `countrylanguage` VALUES ('VIR', 'French', 'F', 2.5);
INSERT INTO `countrylanguage` VALUES ('VIR', 'Spanish', 'F', 13.3);
INSERT INTO `countrylanguage` VALUES ('VNM', 'Chinese', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('VNM', 'Khmer', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('VNM', 'Man', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('VNM', 'Miao', 'F', 0.9);
INSERT INTO `countrylanguage` VALUES ('VNM', 'Muong', 'F', 1.5);
INSERT INTO `countrylanguage` VALUES ('VNM', 'Nung', 'F', 1.1);
INSERT INTO `countrylanguage` VALUES ('VNM', 'Thai', 'F', 1.6);
INSERT INTO `countrylanguage` VALUES ('VNM', 'Tho', 'F', 1.8);
INSERT INTO `countrylanguage` VALUES ('VNM', 'Vietnamese', 'T', 86.8);
INSERT INTO `countrylanguage` VALUES ('VUT', 'Bislama', 'T', 56.6);
INSERT INTO `countrylanguage` VALUES ('VUT', 'English', 'T', 28.3);
INSERT INTO `countrylanguage` VALUES ('VUT', 'French', 'T', 14.2);
INSERT INTO `countrylanguage` VALUES ('WLF', 'Futuna', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('WLF', 'Wallis', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('WSM', 'English', 'T', 0.6);
INSERT INTO `countrylanguage` VALUES ('WSM', 'Samoan', 'T', 47.5);
INSERT INTO `countrylanguage` VALUES ('WSM', 'Samoan-English', 'F', 52.0);
INSERT INTO `countrylanguage` VALUES ('YEM', 'Arabic', 'T', 99.6);
INSERT INTO `countrylanguage` VALUES ('YEM', 'Soqutri', 'F', 0.0);
INSERT INTO `countrylanguage` VALUES ('YUG', 'Albaniana', 'F', 16.5);
INSERT INTO `countrylanguage` VALUES ('YUG', 'Hungarian', 'F', 3.4);
INSERT INTO `countrylanguage` VALUES ('YUG', 'Macedonian', 'F', 0.5);
INSERT INTO `countrylanguage` VALUES ('YUG', 'Romani', 'F', 1.4);
INSERT INTO `countrylanguage` VALUES ('YUG', 'Serbo-Croatian', 'T', 75.2);
INSERT INTO `countrylanguage` VALUES ('YUG', 'Slovak', 'F', 0.7);
INSERT INTO `countrylanguage` VALUES ('ZAF', 'Afrikaans', 'T', 14.3);
INSERT INTO `countrylanguage` VALUES ('ZAF', 'English', 'T', 8.5);
INSERT INTO `countrylanguage` VALUES ('ZAF', 'Ndebele', 'F', 1.5);
INSERT INTO `countrylanguage` VALUES ('ZAF', 'Northsotho', 'F', 9.1);
INSERT INTO `countrylanguage` VALUES ('ZAF', 'Southsotho', 'F', 7.6);
INSERT INTO `countrylanguage` VALUES ('ZAF', 'Swazi', 'F', 2.5);
INSERT INTO `countrylanguage` VALUES ('ZAF', 'Tsonga', 'F', 4.3);
INSERT INTO `countrylanguage` VALUES ('ZAF', 'Tswana', 'F', 8.1);
INSERT INTO `countrylanguage` VALUES ('ZAF', 'Venda', 'F', 2.2);
INSERT INTO `countrylanguage` VALUES ('ZAF', 'Xhosa', 'T', 17.7);
INSERT INTO `countrylanguage` VALUES ('ZAF', 'Zulu', 'T', 22.7);
INSERT INTO `countrylanguage` VALUES ('ZMB', 'Bemba', 'F', 29.7);
INSERT INTO `countrylanguage` VALUES ('ZMB', 'Chewa', 'F', 5.7);
INSERT INTO `countrylanguage` VALUES ('ZMB', 'Lozi', 'F', 6.4);
INSERT INTO `countrylanguage` VALUES ('ZMB', 'Nsenga', 'F', 4.3);
INSERT INTO `countrylanguage` VALUES ('ZMB', 'Nyanja', 'F', 7.8);
INSERT INTO `countrylanguage` VALUES ('ZMB', 'Tongan', 'F', 11.0);
INSERT INTO `countrylanguage` VALUES ('ZWE', 'English', 'T', 2.2);
INSERT INTO `countrylanguage` VALUES ('ZWE', 'Ndebele', 'F', 16.2);
INSERT INTO `countrylanguage` VALUES ('ZWE', 'Nyanja', 'F', 2.2);
INSERT INTO `countrylanguage` VALUES ('ZWE', 'Shona', 'F', 72.1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;

DROP DATABASE IF EXISTS meta;
CREATE DATABASE IF NOT EXISTS meta;
USE meta;

CREATE TABLE `undo_log` (
                            `id` bigint NOT NULL AUTO_INCREMENT,
                            `branch_id` bigint NOT NULL,
                            `xid` varchar(100) NOT NULL,
                            `context` varchar(128) NOT NULL,
                            `rollback_info` longblob NOT NULL,
                            `log_status` int NOT NULL,
                            `log_created` datetime NOT NULL,
                            `log_modified` datetime NOT NULL,
                            `ext` varchar(100) DEFAULT NULL,
                            PRIMARY KEY (`id`)
);