JMinor Application Framework

As simple as possible but not simpler

User Tools

Site Tools


documentation:tutorials:world:data

World Data

File: resources/demos/world/create_schema.sql -

CREATE USER IF NOT EXISTS scott password 'tiger';
ALTER USER scott admin TRUE;
 
CREATE schema world;
 
CREATE TABLE world.country (
  code VARCHAR(3) NOT NULL,
  name VARCHAR(52) NOT NULL,
  continent VARCHAR(20) NOT NULL,
  region VARCHAR(26) NOT NULL,
  surfacearea DECIMAL(10,2) NOT NULL,
  indepyear SMALLINT,
  population INT NOT NULL,
  lifeexpectancy DECIMAL(3,1),
  gnp DECIMAL(10,2),
  gnpold DECIMAL(10,2),
  localname VARCHAR(45) NOT NULL,
  governmentform VARCHAR(45) NOT NULL,
  headofstate VARCHAR(60),
  capital INT,
  code2 VARCHAR(2) NOT NULL,
  CONSTRAINT country_pk PRIMARY KEY (code),
  CONSTRAINT continent_chk CHECK(continent IN ('Asia','Europe','North America','Africa','Oceania','Antarctica','South America'))
);
 
CREATE TABLE world.city (
  id INT NOT NULL,
  name VARCHAR(35) NOT NULL,
  countrycode VARCHAR(3) NOT NULL,
  district VARCHAR(20) NOT NULL,
  population INT NOT NULL,
  CONSTRAINT city_pk PRIMARY KEY (id)
);
 
CREATE SEQUENCE world.city_seq START WITH 4080;
 
CREATE TABLE world.countrylanguage (
  countrycode VARCHAR(3) NOT NULL,
  LANGUAGE VARCHAR(30) NOT NULL,
  isofficial BOOLEAN DEFAULT FALSE NOT NULL,
  percentage DECIMAL(4,1) NOT NULL,
  CONSTRAINT countrylanguage_pk PRIMARY KEY (countrycode, LANGUAGE),
  CONSTRAINT countrylanguage_country_fk FOREIGN KEY (countrycode) REFERENCES world.country(code)
);
 
INSERT INTO world.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 world.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 world.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 world.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 world.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 world.country VALUES ('AND','Andorra','Europe','Southern Europe',468.00,1278,78000,83.5,1630.00,NULL,'Andorra','Parliamentary Coprincipality','',55,'AD');
INSERT INTO world.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 world.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 world.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 world.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 world.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 world.country VALUES ('ATA','Antarctica','Antarctica','Antarctica',13120000.00,NULL,0,NULL,0.00,NULL,'–','Co-administrated','',NULL,'AQ');
INSERT INTO world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.country VALUES ('KIR','Kiribati','Oceania','Micronesia',726.00,1979,83000,59.8,40.70,NULL,'Kiribati','Republic','Teburoro Tito',2256,'KI');
INSERT INTO world.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 world.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 world.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 world.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 world.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 world.country VALUES ('LBR','Liberia','Africa','Western Africa',111369.00,1847,3154000,51.0,2012.00,NULL,'Liberia','Republic','Charles Taylor',2440,'LR');
INSERT INTO world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.country VALUES ('NRU','Nauru','Oceania','Micronesia',21.00,1968,12000,60.8,197.00,NULL,'Naoero/Nauru','Republic','Bernard Dowiyogo',2728,'NR');
INSERT INTO world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.country VALUES ('PLW','Palau','Oceania','Micronesia',459.00,1994,19000,68.6,105.00,NULL,'Belau/Palau','Republic','Kuniwo Nakamura',2881,'PW');
INSERT INTO world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.country VALUES ('TUV','Tuvalu','Oceania','Polynesia',26.00,1978,12000,66.3,6.00,NULL,'Tuvalu','Constitutional Monarchy','Elisabeth II',3424,'TV');
INSERT INTO world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.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 world.country VALUES ('VUT','Vanuatu','Oceania','Melanesia',12189.00,1980,190000,60.6,261.00,246.00,'Vanuatu','Republic','John Bani',3537,'VU');
INSERT INTO world.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 world.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 world.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 world.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 world.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 world.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 world.country VALUES ('ZWE','Zimbabwe','Africa','Eastern Africa',390757.00,1980,11669000,37.8,5951.00,8670.00,'Zimbabwe','Republic','Robert G. Mugabe',4068,'ZW');
 
 
INSERT INTO world.city VALUES (1,'Kabul','AFG','Kabol',1780000);
INSERT INTO world.city VALUES (2,'Qandahar','AFG','Qandahar',237500);
INSERT INTO world.city VALUES (3,'Herat','AFG','Herat',186800);
INSERT INTO world.city VALUES (4,'Mazar-e-Sharif','AFG','Balkh',127800);
INSERT INTO world.city VALUES (5,'Amsterdam','NLD','Noord-Holland',731200);
INSERT INTO world.city VALUES (6,'Rotterdam','NLD','Zuid-Holland',593321);
INSERT INTO world.city VALUES (7,'Haag','NLD','Zuid-Holland',440900);
INSERT INTO world.city VALUES (8,'Utrecht','NLD','Utrecht',234323);
INSERT INTO world.city VALUES (9,'Eindhoven','NLD','Noord-Brabant',201843);
INSERT INTO world.city VALUES (10,'Tilburg','NLD','Noord-Brabant',193238);
INSERT INTO world.city VALUES (11,'Groningen','NLD','Groningen',172701);
INSERT INTO world.city VALUES (12,'Breda','NLD','Noord-Brabant',160398);
INSERT INTO world.city VALUES (13,'Apeldoorn','NLD','Gelderland',153491);
INSERT INTO world.city VALUES (14,'Nijmegen','NLD','Gelderland',152463);
INSERT INTO world.city VALUES (15,'Enschede','NLD','Overijssel',149544);
INSERT INTO world.city VALUES (16,'Haarlem','NLD','Noord-Holland',148772);
INSERT INTO world.city VALUES (17,'Almere','NLD','Flevoland',142465);
INSERT INTO world.city VALUES (18,'Arnhem','NLD','Gelderland',138020);
INSERT INTO world.city VALUES (19,'Zaanstad','NLD','Noord-Holland',135621);
INSERT INTO world.city VALUES (20,'´s-Hertogenbosch','NLD','Noord-Brabant',129170);
INSERT INTO world.city VALUES (21,'Amersfoort','NLD','Utrecht',126270);
INSERT INTO world.city VALUES (22,'Maastricht','NLD','Limburg',122087);
INSERT INTO world.city VALUES (23,'Dordrecht','NLD','Zuid-Holland',119811);
INSERT INTO world.city VALUES (24,'Leiden','NLD','Zuid-Holland',117196);
INSERT INTO world.city VALUES (25,'Haarlemmermeer','NLD','Noord-Holland',110722);
INSERT INTO world.city VALUES (26,'Zoetermeer','NLD','Zuid-Holland',110214);
INSERT INTO world.city VALUES (27,'Emmen','NLD','Drenthe',105853);
INSERT INTO world.city VALUES (28,'Zwolle','NLD','Overijssel',105819);
INSERT INTO world.city VALUES (29,'Ede','NLD','Gelderland',101574);
INSERT INTO world.city VALUES (30,'Delft','NLD','Zuid-Holland',95268);
INSERT INTO world.city VALUES (31,'Heerlen','NLD','Limburg',95052);
INSERT INTO world.city VALUES (32,'Alkmaar','NLD','Noord-Holland',92713);
INSERT INTO world.city VALUES (33,'Willemstad','ANT','Curaçao',2345);
INSERT INTO world.city VALUES (34,'Tirana','ALB','Tirana',270000);
INSERT INTO world.city VALUES (35,'Alger','DZA','Alger',2168000);
INSERT INTO world.city VALUES (36,'Oran','DZA','Oran',609823);
INSERT INTO world.city VALUES (37,'Constantine','DZA','Constantine',443727);
INSERT INTO world.city VALUES (38,'Annaba','DZA','Annaba',222518);
INSERT INTO world.city VALUES (39,'Batna','DZA','Batna',183377);
INSERT INTO world.city VALUES (40,'Sétif','DZA','Sétif',179055);
INSERT INTO world.city VALUES (41,'Sidi Bel Abbès','DZA','Sidi Bel Abbès',153106);
INSERT INTO world.city VALUES (42,'Skikda','DZA','Skikda',128747);
INSERT INTO world.city VALUES (43,'Biskra','DZA','Biskra',128281);
INSERT INTO world.city VALUES (44,'Blida (el-Boulaida)','DZA','Blida',127284);
INSERT INTO world.city VALUES (45,'Béjaïa','DZA','Béjaïa',117162);
INSERT INTO world.city VALUES (46,'Mostaganem','DZA','Mostaganem',115212);
INSERT INTO world.city VALUES (47,'Tébessa','DZA','Tébessa',112007);
INSERT INTO world.city VALUES (48,'Tlemcen (Tilimsen)','DZA','Tlemcen',110242);
INSERT INTO world.city VALUES (49,'Béchar','DZA','Béchar',107311);
INSERT INTO world.city VALUES (50,'Tiaret','DZA','Tiaret',100118);
INSERT INTO world.city VALUES (51,'Ech-Chleff (el-Asnam)','DZA','Chlef',96794);
INSERT INTO world.city VALUES (52,'Ghardaïa','DZA','Ghardaïa',89415);
INSERT INTO world.city VALUES (53,'Tafuna','ASM','Tutuila',5200);
INSERT INTO world.city VALUES (54,'Fagatogo','ASM','Tutuila',2323);
INSERT INTO world.city VALUES (55,'Andorra la Vella','AND','Andorra la Vella',21189);
INSERT INTO world.city VALUES (56,'Luanda','AGO','Luanda',2022000);
INSERT INTO world.city VALUES (57,'Huambo','AGO','Huambo',163100);
INSERT INTO world.city VALUES (58,'Lobito','AGO','Benguela',130000);
INSERT INTO world.city VALUES (59,'Benguela','AGO','Benguela',128300);
INSERT INTO world.city VALUES (60,'Namibe','AGO','Namibe',118200);
INSERT INTO world.city VALUES (61,'South Hill','AIA','–',961);
INSERT INTO world.city VALUES (62,'The Valley','AIA','–',595);
INSERT INTO world.city VALUES (63,'Saint John´s','ATG','St John',24000);
INSERT INTO world.city VALUES (64,'Dubai','ARE','Dubai',669181);
INSERT INTO world.city VALUES (65,'Abu Dhabi','ARE','Abu Dhabi',398695);
INSERT INTO world.city VALUES (66,'Sharja','ARE','Sharja',320095);
INSERT INTO world.city VALUES (67,'al-Ayn','ARE','Abu Dhabi',225970);
INSERT INTO world.city VALUES (68,'Ajman','ARE','Ajman',114395);
INSERT INTO world.city VALUES (69,'Buenos Aires','ARG','Distrito Federal',2982146);
INSERT INTO world.city VALUES (70,'La Matanza','ARG','Buenos Aires',1266461);
INSERT INTO world.city VALUES (71,'Córdoba','ARG','Córdoba',1157507);
INSERT INTO world.city VALUES (72,'Rosario','ARG','Santa Fé',907718);
INSERT INTO world.city VALUES (73,'Lomas de Zamora','ARG','Buenos Aires',622013);
INSERT INTO world.city VALUES (74,'Quilmes','ARG','Buenos Aires',559249);
INSERT INTO world.city VALUES (75,'Almirante Brown','ARG','Buenos Aires',538918);
INSERT INTO world.city VALUES (76,'La Plata','ARG','Buenos Aires',521936);
INSERT INTO world.city VALUES (77,'Mar del Plata','ARG','Buenos Aires',512880);
INSERT INTO world.city VALUES (78,'San Miguel de Tucumán','ARG','Tucumán',470809);
INSERT INTO world.city VALUES (79,'Lanús','ARG','Buenos Aires',469735);
INSERT INTO world.city VALUES (80,'Merlo','ARG','Buenos Aires',463846);
INSERT INTO world.city VALUES (81,'General San Martín','ARG','Buenos Aires',422542);
INSERT INTO world.city VALUES (82,'Salta','ARG','Salta',367550);
INSERT INTO world.city VALUES (83,'Moreno','ARG','Buenos Aires',356993);
INSERT INTO world.city VALUES (84,'Santa Fé','ARG','Santa Fé',353063);
INSERT INTO world.city VALUES (85,'Avellaneda','ARG','Buenos Aires',353046);
INSERT INTO world.city VALUES (86,'Tres de Febrero','ARG','Buenos Aires',352311);
INSERT INTO world.city VALUES (87,'Morón','ARG','Buenos Aires',349246);
INSERT INTO world.city VALUES (88,'Florencio Varela','ARG','Buenos Aires',315432);
INSERT INTO world.city VALUES (89,'San Isidro','ARG','Buenos Aires',306341);
INSERT INTO world.city VALUES (90,'Tigre','ARG','Buenos Aires',296226);
INSERT INTO world.city VALUES (91,'Malvinas Argentinas','ARG','Buenos Aires',290335);
INSERT INTO world.city VALUES (92,'Vicente López','ARG','Buenos Aires',288341);
INSERT INTO world.city VALUES (93,'Berazategui','ARG','Buenos Aires',276916);
INSERT INTO world.city VALUES (94,'Corrientes','ARG','Corrientes',258103);
INSERT INTO world.city VALUES (95,'San Miguel','ARG','Buenos Aires',248700);
INSERT INTO world.city VALUES (96,'Bahía Blanca','ARG','Buenos Aires',239810);
INSERT INTO world.city VALUES (97,'Esteban Echeverría','ARG','Buenos Aires',235760);
INSERT INTO world.city VALUES (98,'Resistencia','ARG','Chaco',229212);
INSERT INTO world.city VALUES (99,'José C. Paz','ARG','Buenos Aires',221754);
INSERT INTO world.city VALUES (100,'Paraná','ARG','Entre Rios',207041);
INSERT INTO world.city VALUES (101,'Godoy Cruz','ARG','Mendoza',206998);
INSERT INTO world.city VALUES (102,'Posadas','ARG','Misiones',201273);
INSERT INTO world.city VALUES (103,'Guaymallén','ARG','Mendoza',200595);
INSERT INTO world.city VALUES (104,'Santiago del Estero','ARG','Santiago del Estero',189947);
INSERT INTO world.city VALUES (105,'San Salvador de Jujuy','ARG','Jujuy',178748);
INSERT INTO world.city VALUES (106,'Hurlingham','ARG','Buenos Aires',170028);
INSERT INTO world.city VALUES (107,'Neuquén','ARG','Neuquén',167296);
INSERT INTO world.city VALUES (108,'Ituzaingó','ARG','Buenos Aires',158197);
INSERT INTO world.city VALUES (109,'San Fernando','ARG','Buenos Aires',153036);
INSERT INTO world.city VALUES (110,'Formosa','ARG','Formosa',147636);
INSERT INTO world.city VALUES (111,'Las Heras','ARG','Mendoza',145823);
INSERT INTO world.city VALUES (112,'La Rioja','ARG','La Rioja',138117);
INSERT INTO world.city VALUES (113,'San Fernando del Valle de Cata','ARG','Catamarca',134935);
INSERT INTO world.city VALUES (114,'Río Cuarto','ARG','Córdoba',134355);
INSERT INTO world.city VALUES (115,'Comodoro Rivadavia','ARG','Chubut',124104);
INSERT INTO world.city VALUES (116,'Mendoza','ARG','Mendoza',123027);
INSERT INTO world.city VALUES (117,'San Nicolás de los Arroyos','ARG','Buenos Aires',119302);
INSERT INTO world.city VALUES (118,'San Juan','ARG','San Juan',119152);
INSERT INTO world.city VALUES (119,'Escobar','ARG','Buenos Aires',116675);
INSERT INTO world.city VALUES (120,'Concordia','ARG','Entre Rios',116485);
INSERT INTO world.city VALUES (121,'Pilar','ARG','Buenos Aires',113428);
INSERT INTO world.city VALUES (122,'San Luis','ARG','San Luis',110136);
INSERT INTO world.city VALUES (123,'Ezeiza','ARG','Buenos Aires',99578);
INSERT INTO world.city VALUES (124,'San Rafael','ARG','Mendoza',94651);
INSERT INTO world.city VALUES (125,'Tandil','ARG','Buenos Aires',91101);
INSERT INTO world.city VALUES (126,'Yerevan','ARM','Yerevan',1248700);
INSERT INTO world.city VALUES (127,'Gjumri','ARM','Širak',211700);
INSERT INTO world.city VALUES (128,'Vanadzor','ARM','Lori',172700);
INSERT INTO world.city VALUES (129,'Oranjestad','ABW','–',29034);
INSERT INTO world.city VALUES (130,'Sydney','AUS','New South Wales',3276207);
INSERT INTO world.city VALUES (131,'Melbourne','AUS','Victoria',2865329);
INSERT INTO world.city VALUES (132,'Brisbane','AUS','Queensland',1291117);
INSERT INTO world.city VALUES (133,'Perth','AUS','West Australia',1096829);
INSERT INTO world.city VALUES (134,'Adelaide','AUS','South Australia',978100);
INSERT INTO world.city VALUES (135,'Canberra','AUS','Capital Region',322723);
INSERT INTO world.city VALUES (136,'Gold Coast','AUS','Queensland',311932);
INSERT INTO world.city VALUES (137,'Newcastle','AUS','New South Wales',270324);
INSERT INTO world.city VALUES (138,'Central Coast','AUS','New South Wales',227657);
INSERT INTO world.city VALUES (139,'Wollongong','AUS','New South Wales',219761);
INSERT INTO world.city VALUES (140,'Hobart','AUS','Tasmania',126118);
INSERT INTO world.city VALUES (141,'Geelong','AUS','Victoria',125382);
INSERT INTO world.city VALUES (142,'Townsville','AUS','Queensland',109914);
INSERT INTO world.city VALUES (143,'Cairns','AUS','Queensland',92273);
INSERT INTO world.city VALUES (144,'Baku','AZE','Baki',1787800);
INSERT INTO world.city VALUES (145,'Gäncä','AZE','Gäncä',299300);
INSERT INTO world.city VALUES (146,'Sumqayit','AZE','Sumqayit',283000);
INSERT INTO world.city VALUES (147,'Mingäçevir','AZE','Mingäçevir',93900);
INSERT INTO world.city VALUES (148,'Nassau','BHS','New Providence',172000);
INSERT INTO world.city VALUES (149,'al-Manama','BHR','al-Manama',148000);
INSERT INTO world.city VALUES (150,'Dhaka','BGD','Dhaka',3612850);
INSERT INTO world.city VALUES (151,'Chittagong','BGD','Chittagong',1392860);
INSERT INTO world.city VALUES (152,'Khulna','BGD','Khulna',663340);
INSERT INTO world.city VALUES (153,'Rajshahi','BGD','Rajshahi',294056);
INSERT INTO world.city VALUES (154,'Narayanganj','BGD','Dhaka',202134);
INSERT INTO world.city VALUES (155,'Rangpur','BGD','Rajshahi',191398);
INSERT INTO world.city VALUES (156,'Mymensingh','BGD','Dhaka',188713);
INSERT INTO world.city VALUES (157,'Barisal','BGD','Barisal',170232);
INSERT INTO world.city VALUES (158,'Tungi','BGD','Dhaka',168702);
INSERT INTO world.city VALUES (159,'Jessore','BGD','Khulna',139710);
INSERT INTO world.city VALUES (160,'Comilla','BGD','Chittagong',135313);
INSERT INTO world.city VALUES (161,'Nawabganj','BGD','Rajshahi',130577);
INSERT INTO world.city VALUES (162,'Dinajpur','BGD','Rajshahi',127815);
INSERT INTO world.city VALUES (163,'Bogra','BGD','Rajshahi',120170);
INSERT INTO world.city VALUES (164,'Sylhet','BGD','Sylhet',117396);
INSERT INTO world.city VALUES (165,'Brahmanbaria','BGD','Chittagong',109032);
INSERT INTO world.city VALUES (166,'Tangail','BGD','Dhaka',106004);
INSERT INTO world.city VALUES (167,'Jamalpur','BGD','Dhaka',103556);
INSERT INTO world.city VALUES (168,'Pabna','BGD','Rajshahi',103277);
INSERT INTO world.city VALUES (169,'Naogaon','BGD','Rajshahi',101266);
INSERT INTO world.city VALUES (170,'Sirajganj','BGD','Rajshahi',99669);
INSERT INTO world.city VALUES (171,'Narsinghdi','BGD','Dhaka',98342);
INSERT INTO world.city VALUES (172,'Saidpur','BGD','Rajshahi',96777);
INSERT INTO world.city VALUES (173,'Gazipur','BGD','Dhaka',96717);
INSERT INTO world.city VALUES (174,'Bridgetown','BRB','St Michael',6070);
INSERT INTO world.city VALUES (175,'Antwerpen','BEL','Antwerpen',446525);
INSERT INTO world.city VALUES (176,'Gent','BEL','East Flanderi',224180);
INSERT INTO world.city VALUES (177,'Charleroi','BEL','Hainaut',200827);
INSERT INTO world.city VALUES (178,'Liège','BEL','Liège',185639);
INSERT INTO world.city VALUES (179,'Bruxelles [Brussel]','BEL','Bryssel',133859);
INSERT INTO world.city VALUES (180,'Brugge','BEL','West Flanderi',116246);
INSERT INTO world.city VALUES (181,'Schaerbeek','BEL','Bryssel',105692);
INSERT INTO world.city VALUES (182,'Namur','BEL','Namur',105419);
INSERT INTO world.city VALUES (183,'Mons','BEL','Hainaut',90935);
INSERT INTO world.city VALUES (184,'Belize City','BLZ','Belize City',55810);
INSERT INTO world.city VALUES (185,'Belmopan','BLZ','Cayo',7105);
INSERT INTO world.city VALUES (186,'Cotonou','BEN','Atlantique',536827);
INSERT INTO world.city VALUES (187,'Porto-Novo','BEN','Ouémé',194000);
INSERT INTO world.city VALUES (188,'Djougou','BEN','Atacora',134099);
INSERT INTO world.city VALUES (189,'Parakou','BEN','Borgou',103577);
INSERT INTO world.city VALUES (190,'Saint George','BMU','Saint George´s',1800);
INSERT INTO world.city VALUES (191,'Hamilton','BMU','Hamilton',1200);
INSERT INTO world.city VALUES (192,'Thimphu','BTN','Thimphu',22000);
INSERT INTO world.city VALUES (193,'Santa Cruz de la Sierra','BOL','Santa Cruz',935361);
INSERT INTO world.city VALUES (194,'La Paz','BOL','La Paz',758141);
INSERT INTO world.city VALUES (195,'El Alto','BOL','La Paz',534466);
INSERT INTO world.city VALUES (196,'Cochabamba','BOL','Cochabamba',482800);
INSERT INTO world.city VALUES (197,'Oruro','BOL','Oruro',223553);
INSERT INTO world.city VALUES (198,'Sucre','BOL','Chuquisaca',178426);
INSERT INTO world.city VALUES (199,'Potosí','BOL','Potosí',140642);
INSERT INTO world.city VALUES (200,'Tarija','BOL','Tarija',125255);
INSERT INTO world.city VALUES (201,'Sarajevo','BIH','Federaatio',360000);
INSERT INTO world.city VALUES (202,'Banja Luka','BIH','Republika Srpska',143079);
INSERT INTO world.city VALUES (203,'Zenica','BIH','Federaatio',96027);
INSERT INTO world.city VALUES (204,'Gaborone','BWA','Gaborone',213017);
INSERT INTO world.city VALUES (205,'Francistown','BWA','Francistown',101805);
INSERT INTO world.city VALUES (206,'São Paulo','BRA','São Paulo',9968485);
INSERT INTO world.city VALUES (207,'Rio de Janeiro','BRA','Rio de Janeiro',5598953);
INSERT INTO world.city VALUES (208,'Salvador','BRA','Bahia',2302832);
INSERT INTO world.city VALUES (209,'Belo Horizonte','BRA','Minas Gerais',2139125);
INSERT INTO world.city VALUES (210,'Fortaleza','BRA','Ceará',2097757);
INSERT INTO world.city VALUES (211,'Brasília','BRA','Distrito Federal',1969868);
INSERT INTO world.city VALUES (212,'Curitiba','BRA','Paraná',1584232);
INSERT INTO world.city VALUES (213,'Recife','BRA','Pernambuco',1378087);
INSERT INTO world.city VALUES (214,'Porto Alegre','BRA','Rio Grande do Sul',1314032);
INSERT INTO world.city VALUES (215,'Manaus','BRA','Amazonas',1255049);
INSERT INTO world.city VALUES (216,'Belém','BRA','Pará',1186926);
INSERT INTO world.city VALUES (217,'Guarulhos','BRA','São Paulo',1095874);
INSERT INTO world.city VALUES (218,'Goiânia','BRA','Goiás',1056330);
INSERT INTO world.city VALUES (219,'Campinas','BRA','São Paulo',950043);
INSERT INTO world.city VALUES (220,'São Gonçalo','BRA','Rio de Janeiro',869254);
INSERT INTO world.city VALUES (221,'Nova Iguaçu','BRA','Rio de Janeiro',862225);
INSERT INTO world.city VALUES (222,'São Luís','BRA','Maranhão',837588);
INSERT INTO world.city VALUES (223,'Maceió','BRA','Alagoas',786288);
INSERT INTO world.city VALUES (224,'Duque de Caxias','BRA','Rio de Janeiro',746758);
INSERT INTO world.city VALUES (225,'São Bernardo do Campo','BRA','São Paulo',723132);
INSERT INTO world.city VALUES (226,'Teresina','BRA','Piauí',691942);
INSERT INTO world.city VALUES (227,'Natal','BRA','Rio Grande do Norte',688955);
INSERT INTO world.city VALUES (228,'Osasco','BRA','São Paulo',659604);
INSERT INTO world.city VALUES (229,'Campo Grande','BRA','Mato Grosso do Sul',649593);
INSERT INTO world.city VALUES (230,'Santo André','BRA','São Paulo',630073);
INSERT INTO world.city VALUES (231,'João Pessoa','BRA','Paraíba',584029);
INSERT INTO world.city VALUES (232,'Jaboatão dos Guararapes','BRA','Pernambuco',558680);
INSERT INTO world.city VALUES (233,'Contagem','BRA','Minas Gerais',520801);
INSERT INTO world.city VALUES (234,'São José dos Campos','BRA','São Paulo',515553);
INSERT INTO world.city VALUES (235,'Uberlândia','BRA','Minas Gerais',487222);
INSERT INTO world.city VALUES (236,'Feira de Santana','BRA','Bahia',479992);
INSERT INTO world.city VALUES (237,'Ribeirão Preto','BRA','São Paulo',473276);
INSERT INTO world.city VALUES (238,'Sorocaba','BRA','São Paulo',466823);
INSERT INTO world.city VALUES (239,'Niterói','BRA','Rio de Janeiro',459884);
INSERT INTO world.city VALUES (240,'Cuiabá','BRA','Mato Grosso',453813);
INSERT INTO world.city VALUES (241,'Juiz de Fora','BRA','Minas Gerais',450288);
INSERT INTO world.city VALUES (242,'Aracaju','BRA','Sergipe',445555);
INSERT INTO world.city VALUES (243,'São João de Meriti','BRA','Rio de Janeiro',440052);
INSERT INTO world.city VALUES (244,'Londrina','BRA','Paraná',432257);
INSERT INTO world.city VALUES (245,'Joinville','BRA','Santa Catarina',428011);
INSERT INTO world.city VALUES (246,'Belford Roxo','BRA','Rio de Janeiro',425194);
INSERT INTO world.city VALUES (247,'Santos','BRA','São Paulo',408748);
INSERT INTO world.city VALUES (248,'Ananindeua','BRA','Pará',400940);
INSERT INTO world.city VALUES (249,'Campos dos Goytacazes','BRA','Rio de Janeiro',398418);
INSERT INTO world.city VALUES (250,'Mauá','BRA','São Paulo',375055);
INSERT INTO world.city VALUES (251,'Carapicuíba','BRA','São Paulo',357552);
INSERT INTO world.city VALUES (252,'Olinda','BRA','Pernambuco',354732);
INSERT INTO world.city VALUES (253,'Campina Grande','BRA','Paraíba',352497);
INSERT INTO world.city VALUES (254,'São José do Rio Preto','BRA','São Paulo',351944);
INSERT INTO world.city VALUES (255,'Caxias do Sul','BRA','Rio Grande do Sul',349581);
INSERT INTO world.city VALUES (256,'Moji das Cruzes','BRA','São Paulo',339194);
INSERT INTO world.city VALUES (257,'Diadema','BRA','São Paulo',335078);
INSERT INTO world.city VALUES (258,'Aparecida de Goiânia','BRA','Goiás',324662);
INSERT INTO world.city VALUES (259,'Piracicaba','BRA','São Paulo',319104);
INSERT INTO world.city VALUES (260,'Cariacica','BRA','Espírito Santo',319033);
INSERT INTO world.city VALUES (261,'Vila Velha','BRA','Espírito Santo',318758);
INSERT INTO world.city VALUES (262,'Pelotas','BRA','Rio Grande do Sul',315415);
INSERT INTO world.city VALUES (263,'Bauru','BRA','São Paulo',313670);
INSERT INTO world.city VALUES (264,'Porto Velho','BRA','Rondônia',309750);
INSERT INTO world.city VALUES (265,'Serra','BRA','Espírito Santo',302666);
INSERT INTO world.city VALUES (266,'Betim','BRA','Minas Gerais',302108);
INSERT INTO world.city VALUES (267,'Jundíaí','BRA','São Paulo',296127);
INSERT INTO world.city VALUES (268,'Canoas','BRA','Rio Grande do Sul',294125);
INSERT INTO world.city VALUES (269,'Franca','BRA','São Paulo',290139);
INSERT INTO world.city VALUES (270,'São Vicente','BRA','São Paulo',286848);
INSERT INTO world.city VALUES (271,'Maringá','BRA','Paraná',286461);
INSERT INTO world.city VALUES (272,'Montes Claros','BRA','Minas Gerais',286058);
INSERT INTO world.city VALUES (273,'Anápolis','BRA','Goiás',282197);
INSERT INTO world.city VALUES (274,'Florianópolis','BRA','Santa Catarina',281928);
INSERT INTO world.city VALUES (275,'Petrópolis','BRA','Rio de Janeiro',279183);
INSERT INTO world.city VALUES (276,'Itaquaquecetuba','BRA','São Paulo',270874);
INSERT INTO world.city VALUES (277,'Vitória','BRA','Espírito Santo',270626);
INSERT INTO world.city VALUES (278,'Ponta Grossa','BRA','Paraná',268013);
INSERT INTO world.city VALUES (279,'Rio Branco','BRA','Acre',259537);
INSERT INTO world.city VALUES (280,'Foz do Iguaçu','BRA','Paraná',259425);
INSERT INTO world.city VALUES (281,'Macapá','BRA','Amapá',256033);
INSERT INTO world.city VALUES (282,'Ilhéus','BRA','Bahia',254970);
INSERT INTO world.city VALUES (283,'Vitória da Conquista','BRA','Bahia',253587);
INSERT INTO world.city VALUES (284,'Uberaba','BRA','Minas Gerais',249225);
INSERT INTO world.city VALUES (285,'Paulista','BRA','Pernambuco',248473);
INSERT INTO world.city VALUES (286,'Limeira','BRA','São Paulo',245497);
INSERT INTO world.city VALUES (287,'Blumenau','BRA','Santa Catarina',244379);
INSERT INTO world.city VALUES (288,'Caruaru','BRA','Pernambuco',244247);
INSERT INTO world.city VALUES (289,'Santarém','BRA','Pará',241771);
INSERT INTO world.city VALUES (290,'Volta Redonda','BRA','Rio de Janeiro',240315);
INSERT INTO world.city VALUES (291,'Novo Hamburgo','BRA','Rio Grande do Sul',239940);
INSERT INTO world.city VALUES (292,'Caucaia','BRA','Ceará',238738);
INSERT INTO world.city VALUES (293,'Santa Maria','BRA','Rio Grande do Sul',238473);
INSERT INTO world.city VALUES (294,'Cascavel','BRA','Paraná',237510);
INSERT INTO world.city VALUES (295,'Guarujá','BRA','São Paulo',237206);
INSERT INTO world.city VALUES (296,'Ribeirão das Neves','BRA','Minas Gerais',232685);
INSERT INTO world.city VALUES (297,'Governador Valadares','BRA','Minas Gerais',231724);
INSERT INTO world.city VALUES (298,'Taubaté','BRA','São Paulo',229130);
INSERT INTO world.city VALUES (299,'Imperatriz','BRA','Maranhão',224564);
INSERT INTO world.city VALUES (300,'Gravataí','BRA','Rio Grande do Sul',223011);
INSERT INTO world.city VALUES (301,'Embu','BRA','São Paulo',222223);
INSERT INTO world.city VALUES (302,'Mossoró','BRA','Rio Grande do Norte',214901);
INSERT INTO world.city VALUES (303,'Várzea Grande','BRA','Mato Grosso',214435);
INSERT INTO world.city VALUES (304,'Petrolina','BRA','Pernambuco',210540);
INSERT INTO world.city VALUES (305,'Barueri','BRA','São Paulo',208426);
INSERT INTO world.city VALUES (306,'Viamão','BRA','Rio Grande do Sul',207557);
INSERT INTO world.city VALUES (307,'Ipatinga','BRA','Minas Gerais',206338);
INSERT INTO world.city VALUES (308,'Juazeiro','BRA','Bahia',201073);
INSERT INTO world.city VALUES (309,'Juazeiro do Norte','BRA','Ceará',199636);
INSERT INTO world.city VALUES (310,'Taboão da Serra','BRA','São Paulo',197550);
INSERT INTO world.city VALUES (311,'São José dos Pinhais','BRA','Paraná',196884);
INSERT INTO world.city VALUES (312,'Magé','BRA','Rio de Janeiro',196147);
INSERT INTO world.city VALUES (313,'Suzano','BRA','São Paulo',195434);
INSERT INTO world.city VALUES (314,'São Leopoldo','BRA','Rio Grande do Sul',189258);
INSERT INTO world.city VALUES (315,'Marília','BRA','São Paulo',188691);
INSERT INTO world.city VALUES (316,'São Carlos','BRA','São Paulo',187122);
INSERT INTO world.city VALUES (317,'Sumaré','BRA','São Paulo',186205);
INSERT INTO world.city VALUES (318,'Presidente Prudente','BRA','São Paulo',185340);
INSERT INTO world.city VALUES (319,'Divinópolis','BRA','Minas Gerais',185047);
INSERT INTO world.city VALUES (320,'Sete Lagoas','BRA','Minas Gerais',182984);
INSERT INTO world.city VALUES (321,'Rio Grande','BRA','Rio Grande do Sul',182222);
INSERT INTO world.city VALUES (322,'Itabuna','BRA','Bahia',182148);
INSERT INTO world.city VALUES (323,'Jequié','BRA','Bahia',179128);
INSERT INTO world.city VALUES (324,'Arapiraca','BRA','Alagoas',178988);
INSERT INTO world.city VALUES (325,'Colombo','BRA','Paraná',177764);
INSERT INTO world.city VALUES (326,'Americana','BRA','São Paulo',177409);
INSERT INTO world.city VALUES (327,'Alvorada','BRA','Rio Grande do Sul',175574);
INSERT INTO world.city VALUES (328,'Araraquara','BRA','São Paulo',174381);
INSERT INTO world.city VALUES (329,'Itaboraí','BRA','Rio de Janeiro',173977);
INSERT INTO world.city VALUES (330,'Santa Bárbara d´Oeste','BRA','São Paulo',171657);
INSERT INTO world.city VALUES (331,'Nova Friburgo','BRA','Rio de Janeiro',170697);
INSERT INTO world.city VALUES (332,'Jacareí','BRA','São Paulo',170356);
INSERT INTO world.city VALUES (333,'Araçatuba','BRA','São Paulo',169303);
INSERT INTO world.city VALUES (334,'Barra Mansa','BRA','Rio de Janeiro',168953);
INSERT INTO world.city VALUES (335,'Praia Grande','BRA','São Paulo',168434);
INSERT INTO world.city VALUES (336,'Marabá','BRA','Pará',167795);
INSERT INTO world.city VALUES (337,'Criciúma','BRA','Santa Catarina',167661);
INSERT INTO world.city VALUES (338,'Boa Vista','BRA','Roraima',167185);
INSERT INTO world.city VALUES (339,'Passo Fundo','BRA','Rio Grande do Sul',166343);
INSERT INTO world.city VALUES (340,'Dourados','BRA','Mato Grosso do Sul',164716);
INSERT INTO world.city VALUES (341,'Santa Luzia','BRA','Minas Gerais',164704);
INSERT INTO world.city VALUES (342,'Rio Claro','BRA','São Paulo',163551);
INSERT INTO world.city VALUES (343,'Maracanaú','BRA','Ceará',162022);
INSERT INTO world.city VALUES (344,'Guarapuava','BRA','Paraná',160510);
INSERT INTO world.city VALUES (345,'Rondonópolis','BRA','Mato Grosso',155115);
INSERT INTO world.city VALUES (346,'São José','BRA','Santa Catarina',155105);
INSERT INTO world.city VALUES (347,'Cachoeiro de Itapemirim','BRA','Espírito Santo',155024);
INSERT INTO world.city VALUES (348,'Nilópolis','BRA','Rio de Janeiro',153383);
INSERT INTO world.city VALUES (349,'Itapevi','BRA','São Paulo',150664);
INSERT INTO world.city VALUES (350,'Cabo de Santo Agostinho','BRA','Pernambuco',149964);
INSERT INTO world.city VALUES (351,'Camaçari','BRA','Bahia',149146);
INSERT INTO world.city VALUES (352,'Sobral','BRA','Ceará',146005);
INSERT INTO world.city VALUES (353,'Itajaí','BRA','Santa Catarina',145197);
INSERT INTO world.city VALUES (354,'Chapecó','BRA','Santa Catarina',144158);
INSERT INTO world.city VALUES (355,'Cotia','BRA','São Paulo',140042);
INSERT INTO world.city VALUES (356,'Lages','BRA','Santa Catarina',139570);
INSERT INTO world.city VALUES (357,'Ferraz de Vasconcelos','BRA','São Paulo',139283);
INSERT INTO world.city VALUES (358,'Indaiatuba','BRA','São Paulo',135968);
INSERT INTO world.city VALUES (359,'Hortolândia','BRA','São Paulo',135755);
INSERT INTO world.city VALUES (360,'Caxias','BRA','Maranhão',133980);
INSERT INTO world.city VALUES (361,'São Caetano do Sul','BRA','São Paulo',133321);
INSERT INTO world.city VALUES (362,'Itu','BRA','São Paulo',132736);
INSERT INTO world.city VALUES (363,'Nossa Senhora do Socorro','BRA','Sergipe',131351);
INSERT INTO world.city VALUES (364,'Parnaíba','BRA','Piauí',129756);
INSERT INTO world.city VALUES (365,'Poços de Caldas','BRA','Minas Gerais',129683);
INSERT INTO world.city VALUES (366,'Teresópolis','BRA','Rio de Janeiro',128079);
INSERT INTO world.city VALUES (367,'Barreiras','BRA','Bahia',127801);
INSERT INTO world.city VALUES (368,'Castanhal','BRA','Pará',127634);
INSERT INTO world.city VALUES (369,'Alagoinhas','BRA','Bahia',126820);
INSERT INTO world.city VALUES (370,'Itapecerica da Serra','BRA','São Paulo',126672);
INSERT INTO world.city VALUES (371,'Uruguaiana','BRA','Rio Grande do Sul',126305);
INSERT INTO world.city VALUES (372,'Paranaguá','BRA','Paraná',126076);
INSERT INTO world.city VALUES (373,'Ibirité','BRA','Minas Gerais',125982);
INSERT INTO world.city VALUES (374,'Timon','BRA','Maranhão',125812);
INSERT INTO world.city VALUES (375,'Luziânia','BRA','Goiás',125597);
INSERT INTO world.city VALUES (376,'Macaé','BRA','Rio de Janeiro',125597);
INSERT INTO world.city VALUES (377,'Teófilo Otoni','BRA','Minas Gerais',124489);
INSERT INTO world.city VALUES (378,'Moji-Guaçu','BRA','São Paulo',123782);
INSERT INTO world.city VALUES (379,'Palmas','BRA','Tocantins',121919);
INSERT INTO world.city VALUES (380,'Pindamonhangaba','BRA','São Paulo',121904);
INSERT INTO world.city VALUES (381,'Francisco Morato','BRA','São Paulo',121197);
INSERT INTO world.city VALUES (382,'Bagé','BRA','Rio Grande do Sul',120793);
INSERT INTO world.city VALUES (383,'Sapucaia do Sul','BRA','Rio Grande do Sul',120217);
INSERT INTO world.city VALUES (384,'Cabo Frio','BRA','Rio de Janeiro',119503);
INSERT INTO world.city VALUES (385,'Itapetininga','BRA','São Paulo',119391);
INSERT INTO world.city VALUES (386,'Patos de Minas','BRA','Minas Gerais',119262);
INSERT INTO world.city VALUES (387,'Camaragibe','BRA','Pernambuco',118968);
INSERT INTO world.city VALUES (388,'Bragança Paulista','BRA','São Paulo',116929);
INSERT INTO world.city VALUES (389,'Queimados','BRA','Rio de Janeiro',115020);
INSERT INTO world.city VALUES (390,'Araguaína','BRA','Tocantins',114948);
INSERT INTO world.city VALUES (391,'Garanhuns','BRA','Pernambuco',114603);
INSERT INTO world.city VALUES (392,'Vitória de Santo Antão','BRA','Pernambuco',113595);
INSERT INTO world.city VALUES (393,'Santa Rita','BRA','Paraíba',113135);
INSERT INTO world.city VALUES (394,'Barbacena','BRA','Minas Gerais',113079);
INSERT INTO world.city VALUES (395,'Abaetetuba','BRA','Pará',111258);
INSERT INTO world.city VALUES (396,'Jaú','BRA','São Paulo',109965);
INSERT INTO world.city VALUES (397,'Lauro de Freitas','BRA','Bahia',109236);
INSERT INTO world.city VALUES (398,'Franco da Rocha','BRA','São Paulo',108964);
INSERT INTO world.city VALUES (399,'Teixeira de Freitas','BRA','Bahia',108441);
INSERT INTO world.city VALUES (400,'Varginha','BRA','Minas Gerais',108314);
INSERT INTO world.city VALUES (401,'Ribeirão Pires','BRA','São Paulo',108121);
INSERT INTO world.city VALUES (402,'Sabará','BRA','Minas Gerais',107781);
INSERT INTO world.city VALUES (403,'Catanduva','BRA','São Paulo',107761);
INSERT INTO world.city VALUES (404,'Rio Verde','BRA','Goiás',107755);
INSERT INTO world.city VALUES (405,'Botucatu','BRA','São Paulo',107663);
INSERT INTO world.city VALUES (406,'Colatina','BRA','Espírito Santo',107354);
INSERT INTO world.city VALUES (407,'Santa Cruz do Sul','BRA','Rio Grande do Sul',106734);
INSERT INTO world.city VALUES (408,'Linhares','BRA','Espírito Santo',106278);
INSERT INTO world.city VALUES (409,'Apucarana','BRA','Paraná',105114);
INSERT INTO world.city VALUES (410,'Barretos','BRA','São Paulo',104156);
INSERT INTO world.city VALUES (411,'Guaratinguetá','BRA','São Paulo',103433);
INSERT INTO world.city VALUES (412,'Cachoeirinha','BRA','Rio Grande do Sul',103240);
INSERT INTO world.city VALUES (413,'Codó','BRA','Maranhão',103153);
INSERT INTO world.city VALUES (414,'Jaraguá do Sul','BRA','Santa Catarina',102580);
INSERT INTO world.city VALUES (415,'Cubatão','BRA','São Paulo',102372);
INSERT INTO world.city VALUES (416,'Itabira','BRA','Minas Gerais',102217);
INSERT INTO world.city VALUES (417,'Itaituba','BRA','Pará',101320);
INSERT INTO world.city VALUES (418,'Araras','BRA','São Paulo',101046);
INSERT INTO world.city VALUES (419,'Resende','BRA','Rio de Janeiro',100627);
INSERT INTO world.city VALUES (420,'Atibaia','BRA','São Paulo',100356);
INSERT INTO world.city VALUES (421,'Pouso Alegre','BRA','Minas Gerais',100028);
INSERT INTO world.city VALUES (422,'Toledo','BRA','Paraná',99387);
INSERT INTO world.city VALUES (423,'Crato','BRA','Ceará',98965);
INSERT INTO world.city VALUES (424,'Passos','BRA','Minas Gerais',98570);
INSERT INTO world.city VALUES (425,'Araguari','BRA','Minas Gerais',98399);
INSERT INTO world.city VALUES (426,'São José de Ribamar','BRA','Maranhão',98318);
INSERT INTO world.city VALUES (427,'Pinhais','BRA','Paraná',98198);
INSERT INTO world.city VALUES (428,'Sertãozinho','BRA','São Paulo',98140);
INSERT INTO world.city VALUES (429,'Conselheiro Lafaiete','BRA','Minas Gerais',97507);
INSERT INTO world.city VALUES (430,'Paulo Afonso','BRA','Bahia',97291);
INSERT INTO world.city VALUES (431,'Angra dos Reis','BRA','Rio de Janeiro',96864);
INSERT INTO world.city VALUES (432,'Eunápolis','BRA','Bahia',96610);
INSERT INTO world.city VALUES (433,'Salto','BRA','São Paulo',96348);
INSERT INTO world.city VALUES (434,'Ourinhos','BRA','São Paulo',96291);
INSERT INTO world.city VALUES (435,'Parnamirim','BRA','Rio Grande do Norte',96210);
INSERT INTO world.city VALUES (436,'Jacobina','BRA','Bahia',96131);
INSERT INTO world.city VALUES (437,'Coronel Fabriciano','BRA','Minas Gerais',95933);
INSERT INTO world.city VALUES (438,'Birigui','BRA','São Paulo',94685);
INSERT INTO world.city VALUES (439,'Tatuí','BRA','São Paulo',93897);
INSERT INTO world.city VALUES (440,'Ji-Paraná','BRA','Rondônia',93346);
INSERT INTO world.city VALUES (441,'Bacabal','BRA','Maranhão',93121);
INSERT INTO world.city VALUES (442,'Cametá','BRA','Pará',92779);
INSERT INTO world.city VALUES (443,'Guaíba','BRA','Rio Grande do Sul',92224);
INSERT INTO world.city VALUES (444,'São Lourenço da Mata','BRA','Pernambuco',91999);
INSERT INTO world.city VALUES (445,'Santana do Livramento','BRA','Rio Grande do Sul',91779);
INSERT INTO world.city VALUES (446,'Votorantim','BRA','São Paulo',91777);
INSERT INTO world.city VALUES (447,'Campo Largo','BRA','Paraná',91203);
INSERT INTO world.city VALUES (448,'Patos','BRA','Paraíba',90519);
INSERT INTO world.city VALUES (449,'Ituiutaba','BRA','Minas Gerais',90507);
INSERT INTO world.city VALUES (450,'Corumbá','BRA','Mato Grosso do Sul',90111);
INSERT INTO world.city VALUES (451,'Palhoça','BRA','Santa Catarina',89465);
INSERT INTO world.city VALUES (452,'Barra do Piraí','BRA','Rio de Janeiro',89388);
INSERT INTO world.city VALUES (453,'Bento Gonçalves','BRA','Rio Grande do Sul',89254);
INSERT INTO world.city VALUES (454,'Poá','BRA','São Paulo',89236);
INSERT INTO world.city VALUES (455,'Águas Lindas de Goiás','BRA','Goiás',89200);
INSERT INTO world.city VALUES (456,'London','GBR','England',7285000);
INSERT INTO world.city VALUES (457,'Birmingham','GBR','England',1013000);
INSERT INTO world.city VALUES (458,'Glasgow','GBR','Scotland',619680);
INSERT INTO world.city VALUES (459,'Liverpool','GBR','England',461000);
INSERT INTO world.city VALUES (460,'Edinburgh','GBR','Scotland',450180);
INSERT INTO world.city VALUES (461,'Sheffield','GBR','England',431607);
INSERT INTO world.city VALUES (462,'Manchester','GBR','England',430000);
INSERT INTO world.city VALUES (463,'Leeds','GBR','England',424194);
INSERT INTO world.city VALUES (464,'Bristol','GBR','England',402000);
INSERT INTO world.city VALUES (465,'Cardiff','GBR','Wales',321000);
INSERT INTO world.city VALUES (466,'Coventry','GBR','England',304000);
INSERT INTO world.city VALUES (467,'Leicester','GBR','England',294000);
INSERT INTO world.city VALUES (468,'Bradford','GBR','England',289376);
INSERT INTO world.city VALUES (469,'Belfast','GBR','North Ireland',287500);
INSERT INTO world.city VALUES (470,'Nottingham','GBR','England',287000);
INSERT INTO world.city VALUES (471,'Kingston upon Hull','GBR','England',262000);
INSERT INTO world.city VALUES (472,'Plymouth','GBR','England',253000);
INSERT INTO world.city VALUES (473,'Stoke-on-Trent','GBR','England',252000);
INSERT INTO world.city VALUES (474,'Wolverhampton','GBR','England',242000);
INSERT INTO world.city VALUES (475,'Derby','GBR','England',236000);
INSERT INTO world.city VALUES (476,'Swansea','GBR','Wales',230000);
INSERT INTO world.city VALUES (477,'Southampton','GBR','England',216000);
INSERT INTO world.city VALUES (478,'Aberdeen','GBR','Scotland',213070);
INSERT INTO world.city VALUES (479,'Northampton','GBR','England',196000);
INSERT INTO world.city VALUES (480,'Dudley','GBR','England',192171);
INSERT INTO world.city VALUES (481,'Portsmouth','GBR','England',190000);
INSERT INTO world.city VALUES (482,'Newcastle upon Tyne','GBR','England',189150);
INSERT INTO world.city VALUES (483,'Sunderland','GBR','England',183310);
INSERT INTO world.city VALUES (484,'Luton','GBR','England',183000);
INSERT INTO world.city VALUES (485,'Swindon','GBR','England',180000);
INSERT INTO world.city VALUES (486,'Southend-on-Sea','GBR','England',176000);
INSERT INTO world.city VALUES (487,'Walsall','GBR','England',174739);
INSERT INTO world.city VALUES (488,'Bournemouth','GBR','England',162000);
INSERT INTO world.city VALUES (489,'Peterborough','GBR','England',156000);
INSERT INTO world.city VALUES (490,'Brighton','GBR','England',156124);
INSERT INTO world.city VALUES (491,'Blackpool','GBR','England',151000);
INSERT INTO world.city VALUES (492,'Dundee','GBR','Scotland',146690);
INSERT INTO world.city VALUES (493,'West Bromwich','GBR','England',146386);
INSERT INTO world.city VALUES (494,'Reading','GBR','England',148000);
INSERT INTO world.city VALUES (495,'Oldbury/Smethwick (Warley)','GBR','England',145542);
INSERT INTO world.city VALUES (496,'Middlesbrough','GBR','England',145000);
INSERT INTO world.city VALUES (497,'Huddersfield','GBR','England',143726);
INSERT INTO world.city VALUES (498,'Oxford','GBR','England',144000);
INSERT INTO world.city VALUES (499,'Poole','GBR','England',141000);
INSERT INTO world.city VALUES (500,'Bolton','GBR','England',139020);
INSERT INTO world.city VALUES (501,'Blackburn','GBR','England',140000);
INSERT INTO world.city VALUES (502,'Newport','GBR','Wales',139000);
INSERT INTO world.city VALUES (503,'Preston','GBR','England',135000);
INSERT INTO world.city VALUES (504,'Stockport','GBR','England',132813);
INSERT INTO world.city VALUES (505,'Norwich','GBR','England',124000);
INSERT INTO world.city VALUES (506,'Rotherham','GBR','England',121380);
INSERT INTO world.city VALUES (507,'Cambridge','GBR','England',121000);
INSERT INTO world.city VALUES (508,'Watford','GBR','England',113080);
INSERT INTO world.city VALUES (509,'Ipswich','GBR','England',114000);
INSERT INTO world.city VALUES (510,'Slough','GBR','England',112000);
INSERT INTO world.city VALUES (511,'Exeter','GBR','England',111000);
INSERT INTO world.city VALUES (512,'Cheltenham','GBR','England',106000);
INSERT INTO world.city VALUES (513,'Gloucester','GBR','England',107000);
INSERT INTO world.city VALUES (514,'Saint Helens','GBR','England',106293);
INSERT INTO world.city VALUES (515,'Sutton Coldfield','GBR','England',106001);
INSERT INTO world.city VALUES (516,'York','GBR','England',104425);
INSERT INTO world.city VALUES (517,'Oldham','GBR','England',103931);
INSERT INTO world.city VALUES (518,'Basildon','GBR','England',100924);
INSERT INTO world.city VALUES (519,'Worthing','GBR','England',100000);
INSERT INTO world.city VALUES (520,'Chelmsford','GBR','England',97451);
INSERT INTO world.city VALUES (521,'Colchester','GBR','England',96063);
INSERT INTO world.city VALUES (522,'Crawley','GBR','England',97000);
INSERT INTO world.city VALUES (523,'Gillingham','GBR','England',92000);
INSERT INTO world.city VALUES (524,'Solihull','GBR','England',94531);
INSERT INTO world.city VALUES (525,'Rochdale','GBR','England',94313);
INSERT INTO world.city VALUES (526,'Birkenhead','GBR','England',93087);
INSERT INTO world.city VALUES (527,'Worcester','GBR','England',95000);
INSERT INTO world.city VALUES (528,'Hartlepool','GBR','England',92000);
INSERT INTO world.city VALUES (529,'Halifax','GBR','England',91069);
INSERT INTO world.city VALUES (530,'Woking/Byfleet','GBR','England',92000);
INSERT INTO world.city VALUES (531,'Southport','GBR','England',90959);
INSERT INTO world.city VALUES (532,'Maidstone','GBR','England',90878);
INSERT INTO world.city VALUES (533,'Eastbourne','GBR','England',90000);
INSERT INTO world.city VALUES (534,'Grimsby','GBR','England',89000);
INSERT INTO world.city VALUES (535,'Saint Helier','GBR','Jersey',27523);
INSERT INTO world.city VALUES (536,'Douglas','GBR','–',23487);
INSERT INTO world.city VALUES (537,'Road Town','VGB','Tortola',8000);
INSERT INTO world.city VALUES (538,'Bandar Seri Begawan','BRN','Brunei and Muara',21484);
INSERT INTO world.city VALUES (539,'Sofija','BGR','Grad Sofija',1122302);
INSERT INTO world.city VALUES (540,'Plovdiv','BGR','Plovdiv',342584);
INSERT INTO world.city VALUES (541,'Varna','BGR','Varna',299801);
INSERT INTO world.city VALUES (542,'Burgas','BGR','Burgas',195255);
INSERT INTO world.city VALUES (543,'Ruse','BGR','Ruse',166467);
INSERT INTO world.city VALUES (544,'Stara Zagora','BGR','Haskovo',147939);
INSERT INTO world.city VALUES (545,'Pleven','BGR','Lovec',121952);
INSERT INTO world.city VALUES (546,'Sliven','BGR','Burgas',105530);
INSERT INTO world.city VALUES (547,'Dobric','BGR','Varna',100399);
INSERT INTO world.city VALUES (548,'Šumen','BGR','Varna',94686);
INSERT INTO world.city VALUES (549,'Ouagadougou','BFA','Kadiogo',824000);
INSERT INTO world.city VALUES (550,'Bobo-Dioulasso','BFA','Houet',300000);
INSERT INTO world.city VALUES (551,'Koudougou','BFA','Boulkiemdé',105000);
INSERT INTO world.city VALUES (552,'Bujumbura','BDI','Bujumbura',300000);
INSERT INTO world.city VALUES (553,'George Town','CYM','Grand Cayman',19600);
INSERT INTO world.city VALUES (554,'Santiago de Chile','CHL','Santiago',4703954);
INSERT INTO world.city VALUES (555,'Puente Alto','CHL','Santiago',386236);
INSERT INTO world.city VALUES (556,'Viña del Mar','CHL','Valparaíso',312493);
INSERT INTO world.city VALUES (557,'Valparaíso','CHL','Valparaíso',293800);
INSERT INTO world.city VALUES (558,'Talcahuano','CHL','Bíobío',277752);
INSERT INTO world.city VALUES (559,'Antofagasta','CHL','Antofagasta',251429);
INSERT INTO world.city VALUES (560,'San Bernardo','CHL','Santiago',241910);
INSERT INTO world.city VALUES (561,'Temuco','CHL','La Araucanía',233041);
INSERT INTO world.city VALUES (562,'Concepción','CHL','Bíobío',217664);
INSERT INTO world.city VALUES (563,'Rancagua','CHL','O´Higgins',212977);
INSERT INTO world.city VALUES (564,'Arica','CHL','Tarapacá',189036);
INSERT INTO world.city VALUES (565,'Talca','CHL','Maule',187557);
INSERT INTO world.city VALUES (566,'Chillán','CHL','Bíobío',178182);
INSERT INTO world.city VALUES (567,'Iquique','CHL','Tarapacá',177892);
INSERT INTO world.city VALUES (568,'Los Angeles','CHL','Bíobío',158215);
INSERT INTO world.city VALUES (569,'Puerto Montt','CHL','Los Lagos',152194);
INSERT INTO world.city VALUES (570,'Coquimbo','CHL','Coquimbo',143353);
INSERT INTO world.city VALUES (571,'Osorno','CHL','Los Lagos',141468);
INSERT INTO world.city VALUES (572,'La Serena','CHL','Coquimbo',137409);
INSERT INTO world.city VALUES (573,'Calama','CHL','Antofagasta',137265);
INSERT INTO world.city VALUES (574,'Valdivia','CHL','Los Lagos',133106);
INSERT INTO world.city VALUES (575,'Punta Arenas','CHL','Magallanes',125631);
INSERT INTO world.city VALUES (576,'Copiapó','CHL','Atacama',120128);
INSERT INTO world.city VALUES (577,'Quilpué','CHL','Valparaíso',118857);
INSERT INTO world.city VALUES (578,'Curicó','CHL','Maule',115766);
INSERT INTO world.city VALUES (579,'Ovalle','CHL','Coquimbo',94854);
INSERT INTO world.city VALUES (580,'Coronel','CHL','Bíobío',93061);
INSERT INTO world.city VALUES (581,'San Pedro de la Paz','CHL','Bíobío',91684);
INSERT INTO world.city VALUES (582,'Melipilla','CHL','Santiago',91056);
INSERT INTO world.city VALUES (583,'Avarua','COK','Rarotonga',11900);
INSERT INTO world.city VALUES (584,'San José','CRI','San José',339131);
INSERT INTO world.city VALUES (585,'Djibouti','DJI','Djibouti',383000);
INSERT INTO world.city VALUES (586,'Roseau','DMA','St George',16243);
INSERT INTO world.city VALUES (587,'Santo Domingo de Guzmán','DOM','Distrito Nacional',1609966);
INSERT INTO world.city VALUES (588,'Santiago de los Caballeros','DOM','Santiago',365463);
INSERT INTO world.city VALUES (589,'La Romana','DOM','La Romana',140204);
INSERT INTO world.city VALUES (590,'San Pedro de Macorís','DOM','San Pedro de Macorís',124735);
INSERT INTO world.city VALUES (591,'San Francisco de Macorís','DOM','Duarte',108485);
INSERT INTO world.city VALUES (592,'San Felipe de Puerto Plata','DOM','Puerto Plata',89423);
INSERT INTO world.city VALUES (593,'Guayaquil','ECU','Guayas',2070040);
INSERT INTO world.city VALUES (594,'Quito','ECU','Pichincha',1573458);
INSERT INTO world.city VALUES (595,'Cuenca','ECU','Azuay',270353);
INSERT INTO world.city VALUES (596,'Machala','ECU','El Oro',210368);
INSERT INTO world.city VALUES (597,'Santo Domingo de los Colorados','ECU','Pichincha',202111);
INSERT INTO world.city VALUES (598,'Portoviejo','ECU','Manabí',176413);
INSERT INTO world.city VALUES (599,'Ambato','ECU','Tungurahua',169612);
INSERT INTO world.city VALUES (600,'Manta','ECU','Manabí',164739);
INSERT INTO world.city VALUES (601,'Duran [Eloy Alfaro]','ECU','Guayas',152514);
INSERT INTO world.city VALUES (602,'Ibarra','ECU','Imbabura',130643);
INSERT INTO world.city VALUES (603,'Quevedo','ECU','Los Ríos',129631);
INSERT INTO world.city VALUES (604,'Milagro','ECU','Guayas',124177);
INSERT INTO world.city VALUES (605,'Loja','ECU','Loja',123875);
INSERT INTO world.city VALUES (606,'Ríobamba','ECU','Chimborazo',123163);
INSERT INTO world.city VALUES (607,'Esmeraldas','ECU','Esmeraldas',123045);
INSERT INTO world.city VALUES (608,'Cairo','EGY','Kairo',6789479);
INSERT INTO world.city VALUES (609,'Alexandria','EGY','Aleksandria',3328196);
INSERT INTO world.city VALUES (610,'Giza','EGY','Giza',2221868);
INSERT INTO world.city VALUES (611,'Shubra al-Khayma','EGY','al-Qalyubiya',870716);
INSERT INTO world.city VALUES (612,'Port Said','EGY','Port Said',469533);
INSERT INTO world.city VALUES (613,'Suez','EGY','Suez',417610);
INSERT INTO world.city VALUES (614,'al-Mahallat al-Kubra','EGY','al-Gharbiya',395402);
INSERT INTO world.city VALUES (615,'Tanta','EGY','al-Gharbiya',371010);
INSERT INTO world.city VALUES (616,'al-Mansura','EGY','al-Daqahliya',369621);
INSERT INTO world.city VALUES (617,'Luxor','EGY','Luxor',360503);
INSERT INTO world.city VALUES (618,'Asyut','EGY','Asyut',343498);
INSERT INTO world.city VALUES (619,'Bahtim','EGY','al-Qalyubiya',275807);
INSERT INTO world.city VALUES (620,'Zagazig','EGY','al-Sharqiya',267351);
INSERT INTO world.city VALUES (621,'al-Faiyum','EGY','al-Faiyum',260964);
INSERT INTO world.city VALUES (622,'Ismailia','EGY','Ismailia',254477);
INSERT INTO world.city VALUES (623,'Kafr al-Dawwar','EGY','al-Buhayra',231978);
INSERT INTO world.city VALUES (624,'Assuan','EGY','Assuan',219017);
INSERT INTO world.city VALUES (625,'Damanhur','EGY','al-Buhayra',212203);
INSERT INTO world.city VALUES (626,'al-Minya','EGY','al-Minya',201360);
INSERT INTO world.city VALUES (627,'Bani Suwayf','EGY','Bani Suwayf',172032);
INSERT INTO world.city VALUES (628,'Qina','EGY','Qina',171275);
INSERT INTO world.city VALUES (629,'Sawhaj','EGY','Sawhaj',170125);
INSERT INTO world.city VALUES (630,'Shibin al-Kawm','EGY','al-Minufiya',159909);
INSERT INTO world.city VALUES (631,'Bulaq al-Dakrur','EGY','Giza',148787);
INSERT INTO world.city VALUES (632,'Banha','EGY','al-Qalyubiya',145792);
INSERT INTO world.city VALUES (633,'Warraq al-Arab','EGY','Giza',127108);
INSERT INTO world.city VALUES (634,'Kafr al-Shaykh','EGY','Kafr al-Shaykh',124819);
INSERT INTO world.city VALUES (635,'Mallawi','EGY','al-Minya',119283);
INSERT INTO world.city VALUES (636,'Bilbays','EGY','al-Sharqiya',113608);
INSERT INTO world.city VALUES (637,'Mit Ghamr','EGY','al-Daqahliya',101801);
INSERT INTO world.city VALUES (638,'al-Arish','EGY','Shamal Sina',100447);
INSERT INTO world.city VALUES (639,'Talkha','EGY','al-Daqahliya',97700);
INSERT INTO world.city VALUES (640,'Qalyub','EGY','al-Qalyubiya',97200);
INSERT INTO world.city VALUES (641,'Jirja','EGY','Sawhaj',95400);
INSERT INTO world.city VALUES (642,'Idfu','EGY','Qina',94200);
INSERT INTO world.city VALUES (643,'al-Hawamidiya','EGY','Giza',91700);
INSERT INTO world.city VALUES (644,'Disuq','EGY','Kafr al-Shaykh',91300);
INSERT INTO world.city VALUES (645,'San Salvador','SLV','San Salvador',415346);
INSERT INTO world.city VALUES (646,'Santa Ana','SLV','Santa Ana',139389);
INSERT INTO world.city VALUES (647,'Mejicanos','SLV','San Salvador',138800);
INSERT INTO world.city VALUES (648,'Soyapango','SLV','San Salvador',129800);
INSERT INTO world.city VALUES (649,'San Miguel','SLV','San Miguel',127696);
INSERT INTO world.city VALUES (650,'Nueva San Salvador','SLV','La Libertad',98400);
INSERT INTO world.city VALUES (651,'Apopa','SLV','San Salvador',88800);
INSERT INTO world.city VALUES (652,'Asmara','ERI','Maekel',431000);
INSERT INTO world.city VALUES (653,'Madrid','ESP','Madrid',2879052);
INSERT INTO world.city VALUES (654,'Barcelona','ESP','Katalonia',1503451);
INSERT INTO world.city VALUES (655,'Valencia','ESP','Valencia',739412);
INSERT INTO world.city VALUES (656,'Sevilla','ESP','Andalusia',701927);
INSERT INTO world.city VALUES (657,'Zaragoza','ESP','Aragonia',603367);
INSERT INTO world.city VALUES (658,'Málaga','ESP','Andalusia',530553);
INSERT INTO world.city VALUES (659,'Bilbao','ESP','Baskimaa',357589);
INSERT INTO world.city VALUES (660,'Las Palmas de Gran Canaria','ESP','Canary Islands',354757);
INSERT INTO world.city VALUES (661,'Murcia','ESP','Murcia',353504);
INSERT INTO world.city VALUES (662,'Palma de Mallorca','ESP','Balears',326993);
INSERT INTO world.city VALUES (663,'Valladolid','ESP','Castilla and León',319998);
INSERT INTO world.city VALUES (664,'Córdoba','ESP','Andalusia',311708);
INSERT INTO world.city VALUES (665,'Vigo','ESP','Galicia',283670);
INSERT INTO world.city VALUES (666,'Alicante [Alacant]','ESP','Valencia',272432);
INSERT INTO world.city VALUES (667,'Gijón','ESP','Asturia',267980);
INSERT INTO world.city VALUES (668,'L´Hospitalet de Llobregat','ESP','Katalonia',247986);
INSERT INTO world.city VALUES (669,'Granada','ESP','Andalusia',244767);
INSERT INTO world.city VALUES (670,'A Coruña (La Coruña)','ESP','Galicia',243402);
INSERT INTO world.city VALUES (671,'Vitoria-Gasteiz','ESP','Baskimaa',217154);
INSERT INTO world.city VALUES (672,'Santa Cruz de Tenerife','ESP','Canary Islands',213050);
INSERT INTO world.city VALUES (673,'Badalona','ESP','Katalonia',209635);
INSERT INTO world.city VALUES (674,'Oviedo','ESP','Asturia',200453);
INSERT INTO world.city VALUES (675,'Móstoles','ESP','Madrid',195351);
INSERT INTO world.city VALUES (676,'Elche [Elx]','ESP','Valencia',193174);
INSERT INTO world.city VALUES (677,'Sabadell','ESP','Katalonia',184859);
INSERT INTO world.city VALUES (678,'Santander','ESP','Cantabria',184165);
INSERT INTO world.city VALUES (679,'Jerez de la Frontera','ESP','Andalusia',182660);
INSERT INTO world.city VALUES (680,'Pamplona [Iruña]','ESP','Navarra',180483);
INSERT INTO world.city VALUES (681,'Donostia-San Sebastián','ESP','Baskimaa',179208);
INSERT INTO world.city VALUES (682,'Cartagena','ESP','Murcia',177709);
INSERT INTO world.city VALUES (683,'Leganés','ESP','Madrid',173163);
INSERT INTO world.city VALUES (684,'Fuenlabrada','ESP','Madrid',171173);
INSERT INTO world.city VALUES (685,'Almería','ESP','Andalusia',169027);
INSERT INTO world.city VALUES (686,'Terrassa','ESP','Katalonia',168695);
INSERT INTO world.city VALUES (687,'Alcalá de Henares','ESP','Madrid',164463);
INSERT INTO world.city VALUES (688,'Burgos','ESP','Castilla and León',162802);
INSERT INTO world.city VALUES (689,'Salamanca','ESP','Castilla and León',158720);
INSERT INTO world.city VALUES (690,'Albacete','ESP','Kastilia-La Mancha',147527);
INSERT INTO world.city VALUES (691,'Getafe','ESP','Madrid',145371);
INSERT INTO world.city VALUES (692,'Cádiz','ESP','Andalusia',142449);
INSERT INTO world.city VALUES (693,'Alcorcón','ESP','Madrid',142048);
INSERT INTO world.city VALUES (694,'Huelva','ESP','Andalusia',140583);
INSERT INTO world.city VALUES (695,'León','ESP','Castilla and León',139809);
INSERT INTO world.city VALUES (696,'Castellón de la Plana [Castell','ESP','Valencia',139712);
INSERT INTO world.city VALUES (697,'Badajoz','ESP','Extremadura',136613);
INSERT INTO world.city VALUES (698,'[San Cristóbal de] la Laguna','ESP','Canary Islands',127945);
INSERT INTO world.city VALUES (699,'Logroño','ESP','La Rioja',127093);
INSERT INTO world.city VALUES (700,'Santa Coloma de Gramenet','ESP','Katalonia',120802);
INSERT INTO world.city VALUES (701,'Tarragona','ESP','Katalonia',113016);
INSERT INTO world.city VALUES (702,'Lleida (Lérida)','ESP','Katalonia',112207);
INSERT INTO world.city VALUES (703,'Jaén','ESP','Andalusia',109247);
INSERT INTO world.city VALUES (704,'Ourense (Orense)','ESP','Galicia',109120);
INSERT INTO world.city VALUES (705,'Mataró','ESP','Katalonia',104095);
INSERT INTO world.city VALUES (706,'Algeciras','ESP','Andalusia',103106);
INSERT INTO world.city VALUES (707,'Marbella','ESP','Andalusia',101144);
INSERT INTO world.city VALUES (708,'Barakaldo','ESP','Baskimaa',98212);
INSERT INTO world.city VALUES (709,'Dos Hermanas','ESP','Andalusia',94591);
INSERT INTO world.city VALUES (710,'Santiago de Compostela','ESP','Galicia',93745);
INSERT INTO world.city VALUES (711,'Torrejón de Ardoz','ESP','Madrid',92262);
INSERT INTO world.city VALUES (712,'Cape Town','ZAF','Western Cape',2352121);
INSERT INTO world.city VALUES (713,'Soweto','ZAF','Gauteng',904165);
INSERT INTO world.city VALUES (714,'Johannesburg','ZAF','Gauteng',756653);
INSERT INTO world.city VALUES (715,'Port Elizabeth','ZAF','Eastern Cape',752319);
INSERT INTO world.city VALUES (716,'Pretoria','ZAF','Gauteng',658630);
INSERT INTO world.city VALUES (717,'Inanda','ZAF','KwaZulu-Natal',634065);
INSERT INTO world.city VALUES (718,'Durban','ZAF','KwaZulu-Natal',566120);
INSERT INTO world.city VALUES (719,'Vanderbijlpark','ZAF','Gauteng',468931);
INSERT INTO world.city VALUES (720,'Kempton Park','ZAF','Gauteng',442633);
INSERT INTO world.city VALUES (721,'Alberton','ZAF','Gauteng',410102);
INSERT INTO world.city VALUES (722,'Pinetown','ZAF','KwaZulu-Natal',378810);
INSERT INTO world.city VALUES (723,'Pietermaritzburg','ZAF','KwaZulu-Natal',370190);
INSERT INTO world.city VALUES (724,'Benoni','ZAF','Gauteng',365467);
INSERT INTO world.city VALUES (725,'Randburg','ZAF','Gauteng',341288);
INSERT INTO world.city VALUES (726,'Umlazi','ZAF','KwaZulu-Natal',339233);
INSERT INTO world.city VALUES (727,'Bloemfontein','ZAF','Free State',334341);
INSERT INTO world.city VALUES (728,'Vereeniging','ZAF','Gauteng',328535);
INSERT INTO world.city VALUES (729,'Wonderboom','ZAF','Gauteng',283289);
INSERT INTO world.city VALUES (730,'Roodepoort','ZAF','Gauteng',279340);
INSERT INTO world.city VALUES (731,'Boksburg','ZAF','Gauteng',262648);
INSERT INTO world.city VALUES (732,'Klerksdorp','ZAF','North West',261911);
INSERT INTO world.city VALUES (733,'Soshanguve','ZAF','Gauteng',242727);
INSERT INTO world.city VALUES (734,'Newcastle','ZAF','KwaZulu-Natal',222993);
INSERT INTO world.city VALUES (735,'East London','ZAF','Eastern Cape',221047);
INSERT INTO world.city VALUES (736,'Welkom','ZAF','Free State',203296);
INSERT INTO world.city VALUES (737,'Kimberley','ZAF','Northern Cape',197254);
INSERT INTO world.city VALUES (738,'Uitenhage','ZAF','Eastern Cape',192120);
INSERT INTO world.city VALUES (739,'Chatsworth','ZAF','KwaZulu-Natal',189885);
INSERT INTO world.city VALUES (740,'Mdantsane','ZAF','Eastern Cape',182639);
INSERT INTO world.city VALUES (741,'Krugersdorp','ZAF','Gauteng',181503);
INSERT INTO world.city VALUES (742,'Botshabelo','ZAF','Free State',177971);
INSERT INTO world.city VALUES (743,'Brakpan','ZAF','Gauteng',171363);
INSERT INTO world.city VALUES (744,'Witbank','ZAF','Mpumalanga',167183);
INSERT INTO world.city VALUES (745,'Oberholzer','ZAF','Gauteng',164367);
INSERT INTO world.city VALUES (746,'Germiston','ZAF','Gauteng',164252);
INSERT INTO world.city VALUES (747,'Springs','ZAF','Gauteng',162072);
INSERT INTO world.city VALUES (748,'Westonaria','ZAF','Gauteng',159632);
INSERT INTO world.city VALUES (749,'Randfontein','ZAF','Gauteng',120838);
INSERT INTO world.city VALUES (750,'Paarl','ZAF','Western Cape',105768);
INSERT INTO world.city VALUES (751,'Potchefstroom','ZAF','North West',101817);
INSERT INTO world.city VALUES (752,'Rustenburg','ZAF','North West',97008);
INSERT INTO world.city VALUES (753,'Nigel','ZAF','Gauteng',96734);
INSERT INTO world.city VALUES (754,'George','ZAF','Western Cape',93818);
INSERT INTO world.city VALUES (755,'Ladysmith','ZAF','KwaZulu-Natal',89292);
INSERT INTO world.city VALUES (756,'Addis Abeba','ETH','Addis Abeba',2495000);
INSERT INTO world.city VALUES (757,'Dire Dawa','ETH','Dire Dawa',164851);
INSERT INTO world.city VALUES (758,'Nazret','ETH','Oromia',127842);
INSERT INTO world.city VALUES (759,'Gonder','ETH','Amhara',112249);
INSERT INTO world.city VALUES (760,'Dese','ETH','Amhara',97314);
INSERT INTO world.city VALUES (761,'Mekele','ETH','Tigray',96938);
INSERT INTO world.city VALUES (762,'Bahir Dar','ETH','Amhara',96140);
INSERT INTO world.city VALUES (763,'Stanley','FLK','East Falkland',1636);
INSERT INTO world.city VALUES (764,'Suva','FJI','Central',77366);
INSERT INTO world.city VALUES (765,'Quezon','PHL','National Capital Reg',2173831);
INSERT INTO world.city VALUES (766,'Manila','PHL','National Capital Reg',1581082);
INSERT INTO world.city VALUES (767,'Kalookan','PHL','National Capital Reg',1177604);
INSERT INTO world.city VALUES (768,'Davao','PHL','Southern Mindanao',1147116);
INSERT INTO world.city VALUES (769,'Cebu','PHL','Central Visayas',718821);
INSERT INTO world.city VALUES (770,'Zamboanga','PHL','Western Mindanao',601794);
INSERT INTO world.city VALUES (771,'Pasig','PHL','National Capital Reg',505058);
INSERT INTO world.city VALUES (772,'Valenzuela','PHL','National Capital Reg',485433);
INSERT INTO world.city VALUES (773,'Las Piñas','PHL','National Capital Reg',472780);
INSERT INTO world.city VALUES (774,'Antipolo','PHL','Southern Tagalog',470866);
INSERT INTO world.city VALUES (775,'Taguig','PHL','National Capital Reg',467375);
INSERT INTO world.city VALUES (776,'Cagayan de Oro','PHL','Northern Mindanao',461877);
INSERT INTO world.city VALUES (777,'Parañaque','PHL','National Capital Reg',449811);
INSERT INTO world.city VALUES (778,'Makati','PHL','National Capital Reg',444867);
INSERT INTO world.city VALUES (779,'Bacolod','PHL','Western Visayas',429076);
INSERT INTO world.city VALUES (780,'General Santos','PHL','Southern Mindanao',411822);
INSERT INTO world.city VALUES (781,'Marikina','PHL','National Capital Reg',391170);
INSERT INTO world.city VALUES (782,'Dasmariñas','PHL','Southern Tagalog',379520);
INSERT INTO world.city VALUES (783,'Muntinlupa','PHL','National Capital Reg',379310);
INSERT INTO world.city VALUES (784,'Iloilo','PHL','Western Visayas',365820);
INSERT INTO world.city VALUES (785,'Pasay','PHL','National Capital Reg',354908);
INSERT INTO world.city VALUES (786,'Malabon','PHL','National Capital Reg',338855);
INSERT INTO world.city VALUES (787,'San José del Monte','PHL','Central Luzon',315807);
INSERT INTO world.city VALUES (788,'Bacoor','PHL','Southern Tagalog',305699);
INSERT INTO world.city VALUES (789,'Iligan','PHL','Central Mindanao',285061);
INSERT INTO world.city VALUES (790,'Calamba','PHL','Southern Tagalog',281146);
INSERT INTO world.city VALUES (791,'Mandaluyong','PHL','National Capital Reg',278474);
INSERT INTO world.city VALUES (792,'Butuan','PHL','Caraga',267279);
INSERT INTO world.city VALUES (793,'Angeles','PHL','Central Luzon',263971);
INSERT INTO world.city VALUES (794,'Tarlac','PHL','Central Luzon',262481);
INSERT INTO world.city VALUES (795,'Mandaue','PHL','Central Visayas',259728);
INSERT INTO world.city VALUES (796,'Baguio','PHL','CAR',252386);
INSERT INTO world.city VALUES (797,'Batangas','PHL','Southern Tagalog',247588);
INSERT INTO world.city VALUES (798,'Cainta','PHL','Southern Tagalog',242511);
INSERT INTO world.city VALUES (799,'San Pedro','PHL','Southern Tagalog',231403);
INSERT INTO world.city VALUES (800,'Navotas','PHL','National Capital Reg',230403);
INSERT INTO world.city VALUES (801,'Cabanatuan','PHL','Central Luzon',222859);
INSERT INTO world.city VALUES (802,'San Fernando','PHL','Central Luzon',221857);
INSERT INTO world.city VALUES (803,'Lipa','PHL','Southern Tagalog',218447);
INSERT INTO world.city VALUES (804,'Lapu-Lapu','PHL','Central Visayas',217019);
INSERT INTO world.city VALUES (805,'San Pablo','PHL','Southern Tagalog',207927);
INSERT INTO world.city VALUES (806,'Biñan','PHL','Southern Tagalog',201186);
INSERT INTO world.city VALUES (807,'Taytay','PHL','Southern Tagalog',198183);
INSERT INTO world.city VALUES (808,'Lucena','PHL','Southern Tagalog',196075);
INSERT INTO world.city VALUES (809,'Imus','PHL','Southern Tagalog',195482);
INSERT INTO world.city VALUES (810,'Olongapo','PHL','Central Luzon',194260);
INSERT INTO world.city VALUES (811,'Binangonan','PHL','Southern Tagalog',187691);
INSERT INTO world.city VALUES (812,'Santa Rosa','PHL','Southern Tagalog',185633);
INSERT INTO world.city VALUES (813,'Tagum','PHL','Southern Mindanao',179531);
INSERT INTO world.city VALUES (814,'Tacloban','PHL','Eastern Visayas',178639);
INSERT INTO world.city VALUES (815,'Malolos','PHL','Central Luzon',175291);
INSERT INTO world.city VALUES (816,'Mabalacat','PHL','Central Luzon',171045);
INSERT INTO world.city VALUES (817,'Cotabato','PHL','Central Mindanao',163849);
INSERT INTO world.city VALUES (818,'Meycauayan','PHL','Central Luzon',163037);
INSERT INTO world.city VALUES (819,'Puerto Princesa','PHL','Southern Tagalog',161912);
INSERT INTO world.city VALUES (820,'Legazpi','PHL','Bicol',157010);
INSERT INTO world.city VALUES (821,'Silang','PHL','Southern Tagalog',156137);
INSERT INTO world.city VALUES (822,'Ormoc','PHL','Eastern Visayas',154297);
INSERT INTO world.city VALUES (823,'San Carlos','PHL','Ilocos',154264);
INSERT INTO world.city VALUES (824,'Kabankalan','PHL','Western Visayas',149769);
INSERT INTO world.city VALUES (825,'Talisay','PHL','Central Visayas',148110);
INSERT INTO world.city VALUES (826,'Valencia','PHL','Northern Mindanao',147924);
INSERT INTO world.city VALUES (827,'Calbayog','PHL','Eastern Visayas',147187);
INSERT INTO world.city VALUES (828,'Santa Maria','PHL','Central Luzon',144282);
INSERT INTO world.city VALUES (829,'Pagadian','PHL','Western Mindanao',142515);
INSERT INTO world.city VALUES (830,'Cadiz','PHL','Western Visayas',141954);
INSERT INTO world.city VALUES (831,'Bago','PHL','Western Visayas',141721);
INSERT INTO world.city VALUES (832,'Toledo','PHL','Central Visayas',141174);
INSERT INTO world.city VALUES (833,'Naga','PHL','Bicol',137810);
INSERT INTO world.city VALUES (834,'San Mateo','PHL','Southern Tagalog',135603);
INSERT INTO world.city VALUES (835,'Panabo','PHL','Southern Mindanao',133950);
INSERT INTO world.city VALUES (836,'Koronadal','PHL','Southern Mindanao',133786);
INSERT INTO world.city VALUES (837,'Marawi','PHL','Central Mindanao',131090);
INSERT INTO world.city VALUES (838,'Dagupan','PHL','Ilocos',130328);
INSERT INTO world.city VALUES (839,'Sagay','PHL','Western Visayas',129765);
INSERT INTO world.city VALUES (840,'Roxas','PHL','Western Visayas',126352);
INSERT INTO world.city VALUES (841,'Lubao','PHL','Central Luzon',125699);
INSERT INTO world.city VALUES (842,'Digos','PHL','Southern Mindanao',125171);
INSERT INTO world.city VALUES (843,'San Miguel','PHL','Central Luzon',123824);
INSERT INTO world.city VALUES (844,'Malaybalay','PHL','Northern Mindanao',123672);
INSERT INTO world.city VALUES (845,'Tuguegarao','PHL','Cagayan Valley',120645);
INSERT INTO world.city VALUES (846,'Ilagan','PHL','Cagayan Valley',119990);
INSERT INTO world.city VALUES (847,'Baliuag','PHL','Central Luzon',119675);
INSERT INTO world.city VALUES (848,'Surigao','PHL','Caraga',118534);
INSERT INTO world.city VALUES (849,'San Carlos','PHL','Western Visayas',118259);
INSERT INTO world.city VALUES (850,'San Juan del Monte','PHL','National Capital Reg',117680);
INSERT INTO world.city VALUES (851,'Tanauan','PHL','Southern Tagalog',117539);
INSERT INTO world.city VALUES (852,'Concepcion','PHL','Central Luzon',115171);
INSERT INTO world.city VALUES (853,'Rodriguez (Montalban)','PHL','Southern Tagalog',115167);
INSERT INTO world.city VALUES (854,'Sariaya','PHL','Southern Tagalog',114568);
INSERT INTO world.city VALUES (855,'Malasiqui','PHL','Ilocos',113190);
INSERT INTO world.city VALUES (856,'General Mariano Alvarez','PHL','Southern Tagalog',112446);
INSERT INTO world.city VALUES (857,'Urdaneta','PHL','Ilocos',111582);
INSERT INTO world.city VALUES (858,'Hagonoy','PHL','Central Luzon',111425);
INSERT INTO world.city VALUES (859,'San Jose','PHL','Southern Tagalog',111009);
INSERT INTO world.city VALUES (860,'Polomolok','PHL','Southern Mindanao',110709);
INSERT INTO world.city VALUES (861,'Santiago','PHL','Cagayan Valley',110531);
INSERT INTO world.city VALUES (862,'Tanza','PHL','Southern Tagalog',110517);
INSERT INTO world.city VALUES (863,'Ozamis','PHL','Northern Mindanao',110420);
INSERT INTO world.city VALUES (864,'Mexico','PHL','Central Luzon',109481);
INSERT INTO world.city VALUES (865,'San Jose','PHL','Central Luzon',108254);
INSERT INTO world.city VALUES (866,'Silay','PHL','Western Visayas',107722);
INSERT INTO world.city VALUES (867,'General Trias','PHL','Southern Tagalog',107691);
INSERT INTO world.city VALUES (868,'Tabaco','PHL','Bicol',107166);
INSERT INTO world.city VALUES (869,'Cabuyao','PHL','Southern Tagalog',106630);
INSERT INTO world.city VALUES (870,'Calapan','PHL','Southern Tagalog',105910);
INSERT INTO world.city VALUES (871,'Mati','PHL','Southern Mindanao',105908);
INSERT INTO world.city VALUES (872,'Midsayap','PHL','Central Mindanao',105760);
INSERT INTO world.city VALUES (873,'Cauayan','PHL','Cagayan Valley',103952);
INSERT INTO world.city VALUES (874,'Gingoog','PHL','Northern Mindanao',102379);
INSERT INTO world.city VALUES (875,'Dumaguete','PHL','Central Visayas',102265);
INSERT INTO world.city VALUES (876,'San Fernando','PHL','Ilocos',102082);
INSERT INTO world.city VALUES (877,'Arayat','PHL','Central Luzon',101792);
INSERT INTO world.city VALUES (878,'Bayawan (Tulong)','PHL','Central Visayas',101391);
INSERT INTO world.city VALUES (879,'Kidapawan','PHL','Central Mindanao',101205);
INSERT INTO world.city VALUES (880,'Daraga (Locsin)','PHL','Bicol',101031);
INSERT INTO world.city VALUES (881,'Marilao','PHL','Central Luzon',101017);
INSERT INTO world.city VALUES (882,'Malita','PHL','Southern Mindanao',100000);
INSERT INTO world.city VALUES (883,'Dipolog','PHL','Western Mindanao',99862);
INSERT INTO world.city VALUES (884,'Cavite','PHL','Southern Tagalog',99367);
INSERT INTO world.city VALUES (885,'Danao','PHL','Central Visayas',98781);
INSERT INTO world.city VALUES (886,'Bislig','PHL','Caraga',97860);
INSERT INTO world.city VALUES (887,'Talavera','PHL','Central Luzon',97329);
INSERT INTO world.city VALUES (888,'Guagua','PHL','Central Luzon',96858);
INSERT INTO world.city VALUES (889,'Bayambang','PHL','Ilocos',96609);
INSERT INTO world.city VALUES (890,'Nasugbu','PHL','Southern Tagalog',96113);
INSERT INTO world.city VALUES (891,'Baybay','PHL','Eastern Visayas',95630);
INSERT INTO world.city VALUES (892,'Capas','PHL','Central Luzon',95219);
INSERT INTO world.city VALUES (893,'Sultan Kudarat','PHL','ARMM',94861);
INSERT INTO world.city VALUES (894,'Laoag','PHL','Ilocos',94466);
INSERT INTO world.city VALUES (895,'Bayugan','PHL','Caraga',93623);
INSERT INTO world.city VALUES (896,'Malungon','PHL','Southern Mindanao',93232);
INSERT INTO world.city VALUES (897,'Santa Cruz','PHL','Southern Tagalog',92694);
INSERT INTO world.city VALUES (898,'Sorsogon','PHL','Bicol',92512);
INSERT INTO world.city VALUES (899,'Candelaria','PHL','Southern Tagalog',92429);
INSERT INTO world.city VALUES (900,'Ligao','PHL','Bicol',90603);
INSERT INTO world.city VALUES (901,'Tórshavn','FRO','Streymoyar',14542);
INSERT INTO world.city VALUES (902,'Libreville','GAB','Estuaire',419000);
INSERT INTO world.city VALUES (903,'Serekunda','GMB','Kombo St Mary',102600);
INSERT INTO world.city VALUES (904,'Banjul','GMB','Banjul',42326);
INSERT INTO world.city VALUES (905,'Tbilisi','GEO','Tbilisi',1235200);
INSERT INTO world.city VALUES (906,'Kutaisi','GEO','Imereti',240900);
INSERT INTO world.city VALUES (907,'Rustavi','GEO','Kvemo Kartli',155400);
INSERT INTO world.city VALUES (908,'Batumi','GEO','Adzaria [Atšara]',137700);
INSERT INTO world.city VALUES (909,'Sohumi','GEO','Abhasia [Aphazeti]',111700);
INSERT INTO world.city VALUES (910,'Accra','GHA','Greater Accra',1070000);
INSERT INTO world.city VALUES (911,'Kumasi','GHA','Ashanti',385192);
INSERT INTO world.city VALUES (912,'Tamale','GHA','Northern',151069);
INSERT INTO world.city VALUES (913,'Tema','GHA','Greater Accra',109975);
INSERT INTO world.city VALUES (914,'Sekondi-Takoradi','GHA','Western',103653);
INSERT INTO world.city VALUES (915,'Gibraltar','GIB','–',27025);
INSERT INTO world.city VALUES (916,'Saint George´s','GRD','St George',4621);
INSERT INTO world.city VALUES (917,'Nuuk','GRL','Kitaa',13445);
INSERT INTO world.city VALUES (918,'Les Abymes','GLP','Grande-Terre',62947);
INSERT INTO world.city VALUES (919,'Basse-Terre','GLP','Basse-Terre',12433);
INSERT INTO world.city VALUES (920,'Tamuning','GUM','–',9500);
INSERT INTO world.city VALUES (921,'Agaña','GUM','–',1139);
INSERT INTO world.city VALUES (922,'Ciudad de Guatemala','GTM','Guatemala',823301);
INSERT INTO world.city VALUES (923,'Mixco','GTM','Guatemala',209791);
INSERT INTO world.city VALUES (924,'Villa Nueva','GTM','Guatemala',101295);
INSERT INTO world.city VALUES (925,'Quetzaltenango','GTM','Quetzaltenango',90801);
INSERT INTO world.city VALUES (926,'Conakry','GIN','Conakry',1090610);
INSERT INTO world.city VALUES (927,'Bissau','GNB','Bissau',241000);
INSERT INTO world.city VALUES (928,'Georgetown','GUY','Georgetown',254000);
INSERT INTO world.city VALUES (929,'Port-au-Prince','HTI','Ouest',884472);
INSERT INTO world.city VALUES (930,'Carrefour','HTI','Ouest',290204);
INSERT INTO world.city VALUES (931,'Delmas','HTI','Ouest',240429);
INSERT INTO world.city VALUES (932,'Le-Cap-Haïtien','HTI','Nord',102233);
INSERT INTO world.city VALUES (933,'Tegucigalpa','HND','Distrito Central',813900);
INSERT INTO world.city VALUES (934,'San Pedro Sula','HND','Cortés',383900);
INSERT INTO world.city VALUES (935,'La Ceiba','HND','Atlántida',89200);
INSERT INTO world.city VALUES (936,'Kowloon and New Kowloon','HKG','Kowloon and New Kowl',1987996);
INSERT INTO world.city VALUES (937,'Victoria','HKG','Hongkong',1312637);
INSERT INTO world.city VALUES (938,'Longyearbyen','SJM','Länsimaa',1438);
INSERT INTO world.city VALUES (939,'Jakarta','IDN','Jakarta Raya',9604900);
INSERT INTO world.city VALUES (940,'Surabaya','IDN','East Java',2663820);
INSERT INTO world.city VALUES (941,'Bandung','IDN','West Java',2429000);
INSERT INTO world.city VALUES (942,'Medan','IDN','Sumatera Utara',1843919);
INSERT INTO world.city VALUES (943,'Palembang','IDN','Sumatera Selatan',1222764);
INSERT INTO world.city VALUES (944,'Tangerang','IDN','West Java',1198300);
INSERT INTO world.city VALUES (945,'Semarang','IDN','Central Java',1104405);
INSERT INTO world.city VALUES (946,'Ujung Pandang','IDN','Sulawesi Selatan',1060257);
INSERT INTO world.city VALUES (947,'Malang','IDN','East Java',716862);
INSERT INTO world.city VALUES (948,'Bandar Lampung','IDN','Lampung',680332);
INSERT INTO world.city VALUES (949,'Bekasi','IDN','West Java',644300);
INSERT INTO world.city VALUES (950,'Padang','IDN','Sumatera Barat',534474);
INSERT INTO world.city VALUES (951,'Surakarta','IDN','Central Java',518600);
INSERT INTO world.city VALUES (952,'Banjarmasin','IDN','Kalimantan Selatan',482931);
INSERT INTO world.city VALUES (953,'Pekan Baru','IDN','Riau',438638);
INSERT INTO world.city VALUES (954,'Denpasar','IDN','Bali',435000);
INSERT INTO world.city VALUES (955,'Yogyakarta','IDN','Yogyakarta',418944);
INSERT INTO world.city VALUES (956,'Pontianak','IDN','Kalimantan Barat',409632);
INSERT INTO world.city VALUES (957,'Samarinda','IDN','Kalimantan Timur',399175);
INSERT INTO world.city VALUES (958,'Jambi','IDN','Jambi',385201);
INSERT INTO world.city VALUES (959,'Depok','IDN','West Java',365200);
INSERT INTO world.city VALUES (960,'Cimahi','IDN','West Java',344600);
INSERT INTO world.city VALUES (961,'Balikpapan','IDN','Kalimantan Timur',338752);
INSERT INTO world.city VALUES (962,'Manado','IDN','Sulawesi Utara',332288);
INSERT INTO world.city VALUES (963,'Mataram','IDN','Nusa Tenggara Barat',306600);
INSERT INTO world.city VALUES (964,'Pekalongan','IDN','Central Java',301504);
INSERT INTO world.city VALUES (965,'Tegal','IDN','Central Java',289744);
INSERT INTO world.city VALUES (966,'Bogor','IDN','West Java',285114);
INSERT INTO world.city VALUES (967,'Ciputat','IDN','West Java',270800);
INSERT INTO world.city VALUES (968,'Pondokgede','IDN','West Java',263200);
INSERT INTO world.city VALUES (969,'Cirebon','IDN','West Java',254406);
INSERT INTO world.city VALUES (970,'Kediri','IDN','East Java',253760);
INSERT INTO world.city VALUES (971,'Ambon','IDN','Molukit',249312);
INSERT INTO world.city VALUES (972,'Jember','IDN','East Java',218500);
INSERT INTO world.city VALUES (973,'Cilacap','IDN','Central Java',206900);
INSERT INTO world.city VALUES (974,'Cimanggis','IDN','West Java',205100);
INSERT INTO world.city VALUES (975,'Pematang Siantar','IDN','Sumatera Utara',203056);
INSERT INTO world.city VALUES (976,'Purwokerto','IDN','Central Java',202500);
INSERT INTO world.city VALUES (977,'Ciomas','IDN','West Java',187400);
INSERT INTO world.city VALUES (978,'Tasikmalaya','IDN','West Java',179800);
INSERT INTO world.city VALUES (979,'Madiun','IDN','East Java',171532);
INSERT INTO world.city VALUES (980,'Bengkulu','IDN','Bengkulu',146439);
INSERT INTO world.city VALUES (981,'Karawang','IDN','West Java',145000);
INSERT INTO world.city VALUES (982,'Banda Aceh','IDN','Aceh',143409);
INSERT INTO world.city VALUES (983,'Palu','IDN','Sulawesi Tengah',142800);
INSERT INTO world.city VALUES (984,'Pasuruan','IDN','East Java',134019);
INSERT INTO world.city VALUES (985,'Kupang','IDN','Nusa Tenggara Timur',129300);
INSERT INTO world.city VALUES (986,'Tebing Tinggi','IDN','Sumatera Utara',129300);
INSERT INTO world.city VALUES (987,'Percut Sei Tuan','IDN','Sumatera Utara',129000);
INSERT INTO world.city VALUES (988,'Binjai','IDN','Sumatera Utara',127222);
INSERT INTO world.city VALUES (989,'Sukabumi','IDN','West Java',125766);
INSERT INTO world.city VALUES (990,'Waru','IDN','East Java',124300);
INSERT INTO world.city VALUES (991,'Pangkal Pinang','IDN','Sumatera Selatan',124000);
INSERT INTO world.city VALUES (992,'Magelang','IDN','Central Java',123800);
INSERT INTO world.city VALUES (993,'Blitar','IDN','East Java',122600);
INSERT INTO world.city VALUES (994,'Serang','IDN','West Java',122400);
INSERT INTO world.city VALUES (995,'Probolinggo','IDN','East Java',120770);
INSERT INTO world.city VALUES (996,'Cilegon','IDN','West Java',117000);
INSERT INTO world.city VALUES (997,'Cianjur','IDN','West Java',114300);
INSERT INTO world.city VALUES (998,'Ciparay','IDN','West Java',111500);
INSERT INTO world.city VALUES (999,'Lhokseumawe','IDN','Aceh',109600);
INSERT INTO world.city VALUES (1000,'Taman','IDN','East Java',107000);
INSERT INTO world.city VALUES (1001,'Depok','IDN','Yogyakarta',106800);
INSERT INTO world.city VALUES (1002,'Citeureup','IDN','West Java',105100);
INSERT INTO world.city VALUES (1003,'Pemalang','IDN','Central Java',103500);
INSERT INTO world.city VALUES (1004,'Klaten','IDN','Central Java',103300);
INSERT INTO world.city VALUES (1005,'Salatiga','IDN','Central Java',103000);
INSERT INTO world.city VALUES (1006,'Cibinong','IDN','West Java',101300);
INSERT INTO world.city VALUES (1007,'Palangka Raya','IDN','Kalimantan Tengah',99693);
INSERT INTO world.city VALUES (1008,'Mojokerto','IDN','East Java',96626);
INSERT INTO world.city VALUES (1009,'Purwakarta','IDN','West Java',95900);
INSERT INTO world.city VALUES (1010,'Garut','IDN','West Java',95800);
INSERT INTO world.city VALUES (1011,'Kudus','IDN','Central Java',95300);
INSERT INTO world.city VALUES (1012,'Kendari','IDN','Sulawesi Tenggara',94800);
INSERT INTO world.city VALUES (1013,'Jaya Pura','IDN','West Irian',94700);
INSERT INTO world.city VALUES (1014,'Gorontalo','IDN','Sulawesi Utara',94058);
INSERT INTO world.city VALUES (1015,'Majalaya','IDN','West Java',93200);
INSERT INTO world.city VALUES (1016,'Pondok Aren','IDN','West Java',92700);
INSERT INTO world.city VALUES (1017,'Jombang','IDN','East Java',92600);
INSERT INTO world.city VALUES (1018,'Sunggal','IDN','Sumatera Utara',92300);
INSERT INTO world.city VALUES (1019,'Batam','IDN','Riau',91871);
INSERT INTO world.city VALUES (1020,'Padang Sidempuan','IDN','Sumatera Utara',91200);
INSERT INTO world.city VALUES (1021,'Sawangan','IDN','West Java',91100);
INSERT INTO world.city VALUES (1022,'Banyuwangi','IDN','East Java',89900);
INSERT INTO world.city VALUES (1023,'Tanjung Pinang','IDN','Riau',89900);
INSERT INTO world.city VALUES (1024,'Mumbai (Bombay)','IND','Maharashtra',10500000);
INSERT INTO world.city VALUES (1025,'Delhi','IND','Delhi',7206704);
INSERT INTO world.city VALUES (1026,'Calcutta [Kolkata]','IND','West Bengali',4399819);
INSERT INTO world.city VALUES (1027,'Chennai (Madras)','IND','Tamil Nadu',3841396);
INSERT INTO world.city VALUES (1028,'Hyderabad','IND','Andhra Pradesh',2964638);
INSERT INTO world.city VALUES (1029,'Ahmedabad','IND','Gujarat',2876710);
INSERT INTO world.city VALUES (1030,'Bangalore','IND','Karnataka',2660088);
INSERT INTO world.city VALUES (1031,'Kanpur','IND','Uttar Pradesh',1874409);
INSERT INTO world.city VALUES (1032,'Nagpur','IND','Maharashtra',1624752);
INSERT INTO world.city VALUES (1033,'Lucknow','IND','Uttar Pradesh',1619115);
INSERT INTO world.city VALUES (1034,'Pune','IND','Maharashtra',1566651);
INSERT INTO world.city VALUES (1035,'Surat','IND','Gujarat',1498817);
INSERT INTO world.city VALUES (1036,'Jaipur','IND','Rajasthan',1458483);
INSERT INTO world.city VALUES (1037,'Indore','IND','Madhya Pradesh',1091674);
INSERT INTO world.city VALUES (1038,'Bhopal','IND','Madhya Pradesh',1062771);
INSERT INTO world.city VALUES (1039,'Ludhiana','IND','Punjab',1042740);
INSERT INTO world.city VALUES (1040,'Vadodara (Baroda)','IND','Gujarat',1031346);
INSERT INTO world.city VALUES (1041,'Kalyan','IND','Maharashtra',1014557);
INSERT INTO world.city VALUES (1042,'Madurai','IND','Tamil Nadu',977856);
INSERT INTO world.city VALUES (1043,'Haora (Howrah)','IND','West Bengali',950435);
INSERT INTO world.city VALUES (1044,'Varanasi (Benares)','IND','Uttar Pradesh',929270);
INSERT INTO world.city VALUES (1045,'Patna','IND','Bihar',917243);
INSERT INTO world.city VALUES (1046,'Srinagar','IND','Jammu and Kashmir',892506);
INSERT INTO world.city VALUES (1047,'Agra','IND','Uttar Pradesh',891790);
INSERT INTO world.city VALUES (1048,'Coimbatore','IND','Tamil Nadu',816321);
INSERT INTO world.city VALUES (1049,'Thane (Thana)','IND','Maharashtra',803389);
INSERT INTO world.city VALUES (1050,'Allahabad','IND','Uttar Pradesh',792858);
INSERT INTO world.city VALUES (1051,'Meerut','IND','Uttar Pradesh',753778);
INSERT INTO world.city VALUES (1052,'Vishakhapatnam','IND','Andhra Pradesh',752037);
INSERT INTO world.city VALUES (1053,'Jabalpur','IND','Madhya Pradesh',741927);
INSERT INTO world.city VALUES (1054,'Amritsar','IND','Punjab',708835);
INSERT INTO world.city VALUES (1055,'Faridabad','IND','Haryana',703592);
INSERT INTO world.city VALUES (1056,'Vijayawada','IND','Andhra Pradesh',701827);
INSERT INTO world.city VALUES (1057,'Gwalior','IND','Madhya Pradesh',690765);
INSERT INTO world.city VALUES (1058,'Jodhpur','IND','Rajasthan',666279);
INSERT INTO world.city VALUES (1059,'Nashik (Nasik)','IND','Maharashtra',656925);
INSERT INTO world.city VALUES (1060,'Hubli-Dharwad','IND','Karnataka',648298);
INSERT INTO world.city VALUES (1061,'Solapur (Sholapur)','IND','Maharashtra',604215);
INSERT INTO world.city VALUES (1062,'Ranchi','IND','Jharkhand',599306);
INSERT INTO world.city VALUES (1063,'Bareilly','IND','Uttar Pradesh',587211);
INSERT INTO world.city VALUES (1064,'Guwahati (Gauhati)','IND','Assam',584342);
INSERT INTO world.city VALUES (1065,'Shambajinagar (Aurangabad)','IND','Maharashtra',573272);
INSERT INTO world.city VALUES (1066,'Cochin (Kochi)','IND','Kerala',564589);
INSERT INTO world.city VALUES (1067,'Rajkot','IND','Gujarat',559407);
INSERT INTO world.city VALUES (1068,'Kota','IND','Rajasthan',537371);
INSERT INTO world.city VALUES (1069,'Thiruvananthapuram (Trivandrum','IND','Kerala',524006);
INSERT INTO world.city VALUES (1070,'Pimpri-Chinchwad','IND','Maharashtra',517083);
INSERT INTO world.city VALUES (1071,'Jalandhar (Jullundur)','IND','Punjab',509510);
INSERT INTO world.city VALUES (1072,'Gorakhpur','IND','Uttar Pradesh',505566);
INSERT INTO world.city VALUES (1073,'Chandigarh','IND','Chandigarh',504094);
INSERT INTO world.city VALUES (1074,'Mysore','IND','Karnataka',480692);
INSERT INTO world.city VALUES (1075,'Aligarh','IND','Uttar Pradesh',480520);
INSERT INTO world.city VALUES (1076,'Guntur','IND','Andhra Pradesh',471051);
INSERT INTO world.city VALUES (1077,'Jamshedpur','IND','Jharkhand',460577);
INSERT INTO world.city VALUES (1078,'Ghaziabad','IND','Uttar Pradesh',454156);
INSERT INTO world.city VALUES (1079,'Warangal','IND','Andhra Pradesh',447657);
INSERT INTO world.city VALUES (1080,'Raipur','IND','Chhatisgarh',438639);
INSERT INTO world.city VALUES (1081,'Moradabad','IND','Uttar Pradesh',429214);
INSERT INTO world.city VALUES (1082,'Durgapur','IND','West Bengali',425836);
INSERT INTO world.city VALUES (1083,'Amravati','IND','Maharashtra',421576);
INSERT INTO world.city VALUES (1084,'Calicut (Kozhikode)','IND','Kerala',419831);
INSERT INTO world.city VALUES (1085,'Bikaner','IND','Rajasthan',416289);
INSERT INTO world.city VALUES (1086,'Bhubaneswar','IND','Orissa',411542);
INSERT INTO world.city VALUES (1087,'Kolhapur','IND','Maharashtra',406370);
INSERT INTO world.city VALUES (1088,'Kataka (Cuttack)','IND','Orissa',403418);
INSERT INTO world.city VALUES (1089,'Ajmer','IND','Rajasthan',402700);
INSERT INTO world.city VALUES (1090,'Bhavnagar','IND','Gujarat',402338);
INSERT INTO world.city VALUES (1091,'Tiruchirapalli','IND','Tamil Nadu',387223);
INSERT INTO world.city VALUES (1092,'Bhilai','IND','Chhatisgarh',386159);
INSERT INTO world.city VALUES (1093,'Bhiwandi','IND','Maharashtra',379070);
INSERT INTO world.city VALUES (1094,'Saharanpur','IND','Uttar Pradesh',374945);
INSERT INTO world.city VALUES (1095,'Ulhasnagar','IND','Maharashtra',369077);
INSERT INTO world.city VALUES (1096,'Salem','IND','Tamil Nadu',366712);
INSERT INTO world.city VALUES (1097,'Ujjain','IND','Madhya Pradesh',362266);
INSERT INTO world.city VALUES (1098,'Malegaon','IND','Maharashtra',342595);
INSERT INTO world.city VALUES (1099,'Jamnagar','IND','Gujarat',341637);
INSERT INTO world.city VALUES (1100,'Bokaro Steel City','IND','Jharkhand',333683);
INSERT INTO world.city VALUES (1101,'Akola','IND','Maharashtra',328034);
INSERT INTO world.city VALUES (1102,'Belgaum','IND','Karnataka',326399);
INSERT INTO world.city VALUES (1103,'Rajahmundry','IND','Andhra Pradesh',324851);
INSERT INTO world.city VALUES (1104,'Nellore','IND','Andhra Pradesh',316606);
INSERT INTO world.city VALUES (1105,'Udaipur','IND','Rajasthan',308571);
INSERT INTO world.city VALUES (1106,'New Bombay','IND','Maharashtra',307297);
INSERT INTO world.city VALUES (1107,'Bhatpara','IND','West Bengali',304952);
INSERT INTO world.city VALUES (1108,'Gulbarga','IND','Karnataka',304099);
INSERT INTO world.city VALUES (1109,'New Delhi','IND','Delhi',301297);
INSERT INTO world.city VALUES (1110,'Jhansi','IND','Uttar Pradesh',300850);
INSERT INTO world.city VALUES (1111,'Gaya','IND','Bihar',291675);
INSERT INTO world.city VALUES (1112,'Kakinada','IND','Andhra Pradesh',279980);
INSERT INTO world.city VALUES (1113,'Dhule (Dhulia)','IND','Maharashtra',278317);
INSERT INTO world.city VALUES (1114,'Panihati','IND','West Bengali',275990);
INSERT INTO world.city VALUES (1115,'Nanded (Nander)','IND','Maharashtra',275083);
INSERT INTO world.city VALUES (1116,'Mangalore','IND','Karnataka',273304);
INSERT INTO world.city VALUES (1117,'Dehra Dun','IND','Uttaranchal',270159);
INSERT INTO world.city VALUES (1118,'Kamarhati','IND','West Bengali',266889);
INSERT INTO world.city VALUES (1119,'Davangere','IND','Karnataka',266082);
INSERT INTO world.city VALUES (1120,'Asansol','IND','West Bengali',262188);
INSERT INTO world.city VALUES (1121,'Bhagalpur','IND','Bihar',253225);
INSERT INTO world.city VALUES (1122,'Bellary','IND','Karnataka',245391);
INSERT INTO world.city VALUES (1123,'Barddhaman (Burdwan)','IND','West Bengali',245079);
INSERT INTO world.city VALUES (1124,'Rampur','IND','Uttar Pradesh',243742);
INSERT INTO world.city VALUES (1125,'Jalgaon','IND','Maharashtra',242193);
INSERT INTO world.city VALUES (1126,'Muzaffarpur','IND','Bihar',241107);
INSERT INTO world.city VALUES (1127,'Nizamabad','IND','Andhra Pradesh',241034);
INSERT INTO world.city VALUES (1128,'Muzaffarnagar','IND','Uttar Pradesh',240609);
INSERT INTO world.city VALUES (1129,'Patiala','IND','Punjab',238368);
INSERT INTO world.city VALUES (1130,'Shahjahanpur','IND','Uttar Pradesh',237713);
INSERT INTO world.city VALUES (1131,'Kurnool','IND','Andhra Pradesh',236800);
INSERT INTO world.city VALUES (1132,'Tiruppur (Tirupper)','IND','Tamil Nadu',235661);
INSERT INTO world.city VALUES (1133,'Rohtak','IND','Haryana',233400);
INSERT INTO world.city VALUES (1134,'South Dum Dum','IND','West Bengali',232811);
INSERT INTO world.city VALUES (1135,'Mathura','IND','Uttar Pradesh',226691);
INSERT INTO world.city VALUES (1136,'Chandrapur','IND','Maharashtra',226105);
INSERT INTO world.city VALUES (1137,'Barahanagar (Baranagar)','IND','West Bengali',224821);
INSERT INTO world.city VALUES (1138,'Darbhanga','IND','Bihar',218391);
INSERT INTO world.city VALUES (1139,'Siliguri (Shiliguri)','IND','West Bengali',216950);
INSERT INTO world.city VALUES (1140,'Raurkela','IND','Orissa',215489);
INSERT INTO world.city VALUES (1141,'Ambattur','IND','Tamil Nadu',215424);
INSERT INTO world.city VALUES (1142,'Panipat','IND','Haryana',215218);
INSERT INTO world.city VALUES (1143,'Firozabad','IND','Uttar Pradesh',215128);
INSERT INTO world.city VALUES (1144,'Ichalkaranji','IND','Maharashtra',214950);
INSERT INTO world.city VALUES (1145,'Jammu','IND','Jammu and Kashmir',214737);
INSERT INTO world.city VALUES (1146,'Ramagundam','IND','Andhra Pradesh',214384);
INSERT INTO world.city VALUES (1147,'Eluru','IND','Andhra Pradesh',212866);
INSERT INTO world.city VALUES (1148,'Brahmapur','IND','Orissa',210418);
INSERT INTO world.city VALUES (1149,'Alwar','IND','Rajasthan',205086);
INSERT INTO world.city VALUES (1150,'Pondicherry','IND','Pondicherry',203065);
INSERT INTO world.city VALUES (1151,'Thanjavur','IND','Tamil Nadu',202013);
INSERT INTO world.city VALUES (1152,'Bihar Sharif','IND','Bihar',201323);
INSERT INTO world.city VALUES (1153,'Tuticorin','IND','Tamil Nadu',199854);
INSERT INTO world.city VALUES (1154,'Imphal','IND','Manipur',198535);
INSERT INTO world.city VALUES (1155,'Latur','IND','Maharashtra',197408);
INSERT INTO world.city VALUES (1156,'Sagar','IND','Madhya Pradesh',195346);
INSERT INTO world.city VALUES (1157,'Farrukhabad-cum-Fatehgarh','IND','Uttar Pradesh',194567);
INSERT INTO world.city VALUES (1158,'Sangli','IND','Maharashtra',193197);
INSERT INTO world.city VALUES (1159,'Parbhani','IND','Maharashtra',190255);
INSERT INTO world.city VALUES (1160,'Nagar Coil','IND','Tamil Nadu',190084);
INSERT INTO world.city VALUES (1161,'Bijapur','IND','Karnataka',186939);
INSERT INTO world.city VALUES (1162,'Kukatpalle','IND','Andhra Pradesh',185378);
INSERT INTO world.city VALUES (1163,'Bally','IND','West Bengali',184474);
INSERT INTO world.city VALUES (1164,'Bhilwara','IND','Rajasthan',183965);
INSERT INTO world.city VALUES (1165,'Ratlam','IND','Madhya Pradesh',183375);
INSERT INTO world.city VALUES (1166,'Avadi','IND','Tamil Nadu',183215);
INSERT INTO world.city VALUES (1167,'Dindigul','IND','Tamil Nadu',182477);
INSERT INTO world.city VALUES (1168,'Ahmadnagar','IND','Maharashtra',181339);
INSERT INTO world.city VALUES (1169,'Bilaspur','IND','Chhatisgarh',179833);
INSERT INTO world.city VALUES (1170,'Shimoga','IND','Karnataka',179258);
INSERT INTO world.city VALUES (1171,'Kharagpur','IND','West Bengali',177989);
INSERT INTO world.city VALUES (1172,'Mira Bhayandar','IND','Maharashtra',175372);
INSERT INTO world.city VALUES (1173,'Vellore','IND','Tamil Nadu',175061);
INSERT INTO world.city VALUES (1174,'Jalna','IND','Maharashtra',174985);
INSERT INTO world.city VALUES (1175,'Burnpur','IND','West Bengali',174933);
INSERT INTO world.city VALUES (1176,'Anantapur','IND','Andhra Pradesh',174924);
INSERT INTO world.city VALUES (1177,'Allappuzha (Alleppey)','IND','Kerala',174666);
INSERT INTO world.city VALUES (1178,'Tirupati','IND','Andhra Pradesh',174369);
INSERT INTO world.city VALUES (1179,'Karnal','IND','Haryana',173751);
INSERT INTO world.city VALUES (1180,'Burhanpur','IND','Madhya Pradesh',172710);
INSERT INTO world.city VALUES (1181,'Hisar (Hissar)','IND','Haryana',172677);
INSERT INTO world.city VALUES (1182,'Tiruvottiyur','IND','Tamil Nadu',172562);
INSERT INTO world.city VALUES (1183,'Mirzapur-cum-Vindhyachal','IND','Uttar Pradesh',169336);
INSERT INTO world.city VALUES (1184,'Secunderabad','IND','Andhra Pradesh',167461);
INSERT INTO world.city VALUES (1185,'Nadiad','IND','Gujarat',167051);
INSERT INTO world.city VALUES (1186,'Dewas','IND','Madhya Pradesh',164364);
INSERT INTO world.city VALUES (1187,'Murwara (Katni)','IND','Madhya Pradesh',163431);
INSERT INTO world.city VALUES (1188,'Ganganagar','IND','Rajasthan',161482);
INSERT INTO world.city VALUES (1189,'Vizianagaram','IND','Andhra Pradesh',160359);
INSERT INTO world.city VALUES (1190,'Erode','IND','Tamil Nadu',159232);
INSERT INTO world.city VALUES (1191,'Machilipatnam (Masulipatam)','IND','Andhra Pradesh',159110);
INSERT INTO world.city VALUES (1192,'Bhatinda (Bathinda)','IND','Punjab',159042);
INSERT INTO world.city VALUES (1193,'Raichur','IND','Karnataka',157551);
INSERT INTO world.city VALUES (1194,'Agartala','IND','Tripura',157358);
INSERT INTO world.city VALUES (1195,'Arrah (Ara)','IND','Bihar',157082);
INSERT INTO world.city VALUES (1196,'Satna','IND','Madhya Pradesh',156630);
INSERT INTO world.city VALUES (1197,'Lalbahadur Nagar','IND','Andhra Pradesh',155500);
INSERT INTO world.city VALUES (1198,'Aizawl','IND','Mizoram',155240);
INSERT INTO world.city VALUES (1199,'Uluberia','IND','West Bengali',155172);
INSERT INTO world.city VALUES (1200,'Katihar','IND','Bihar',154367);
INSERT INTO world.city VALUES (1201,'Cuddalore','IND','Tamil Nadu',153086);
INSERT INTO world.city VALUES (1202,'Hugli-Chinsurah','IND','West Bengali',151806);
INSERT INTO world.city VALUES (1203,'Dhanbad','IND','Jharkhand',151789);
INSERT INTO world.city VALUES (1204,'Raiganj','IND','West Bengali',151045);
INSERT INTO world.city VALUES (1205,'Sambhal','IND','Uttar Pradesh',150869);
INSERT INTO world.city VALUES (1206,'Durg','IND','Chhatisgarh',150645);
INSERT INTO world.city VALUES (1207,'Munger (Monghyr)','IND','Bihar',150112);
INSERT INTO world.city VALUES (1208,'Kanchipuram','IND','Tamil Nadu',150100);
INSERT INTO world.city VALUES (1209,'North Dum Dum','IND','West Bengali',149965);
INSERT INTO world.city VALUES (1210,'Karimnagar','IND','Andhra Pradesh',148583);
INSERT INTO world.city VALUES (1211,'Bharatpur','IND','Rajasthan',148519);
INSERT INTO world.city VALUES (1212,'Sikar','IND','Rajasthan',148272);
INSERT INTO world.city VALUES (1213,'Hardwar (Haridwar)','IND','Uttaranchal',147305);
INSERT INTO world.city VALUES (1214,'Dabgram','IND','West Bengali',147217);
INSERT INTO world.city VALUES (1215,'Morena','IND','Madhya Pradesh',147124);
INSERT INTO world.city VALUES (1216,'Noida','IND','Uttar Pradesh',146514);
INSERT INTO world.city VALUES (1217,'Hapur','IND','Uttar Pradesh',146262);
INSERT INTO world.city VALUES (1218,'Bhusawal','IND','Maharashtra',145143);
INSERT INTO world.city VALUES (1219,'Khandwa','IND','Madhya Pradesh',145133);
INSERT INTO world.city VALUES (1220,'Yamuna Nagar','IND','Haryana',144346);
INSERT INTO world.city VALUES (1221,'Sonipat (Sonepat)','IND','Haryana',143922);
INSERT INTO world.city VALUES (1222,'Tenali','IND','Andhra Pradesh',143726);
INSERT INTO world.city VALUES (1223,'Raurkela Civil Township','IND','Orissa',140408);
INSERT INTO world.city VALUES (1224,'Kollam (Quilon)','IND','Kerala',139852);
INSERT INTO world.city VALUES (1225,'Kumbakonam','IND','Tamil Nadu',139483);
INSERT INTO world.city VALUES (1226,'Ingraj Bazar (English Bazar)','IND','West Bengali',139204);
INSERT INTO world.city VALUES (1227,'Timkur','IND','Karnataka',138903);
INSERT INTO world.city VALUES (1228,'Amroha','IND','Uttar Pradesh',137061);
INSERT INTO world.city VALUES (1229,'Serampore','IND','West Bengali',137028);
INSERT INTO world.city VALUES (1230,'Chapra','IND','Bihar',136877);
INSERT INTO world.city VALUES (1231,'Pali','IND','Rajasthan',136842);
INSERT INTO world.city VALUES (1232,'Maunath Bhanjan','IND','Uttar Pradesh',136697);
INSERT INTO world.city VALUES (1233,'Adoni','IND','Andhra Pradesh',136182);
INSERT INTO world.city VALUES (1234,'Jaunpur','IND','Uttar Pradesh',136062);
INSERT INTO world.city VALUES (1235,'Tirunelveli','IND','Tamil Nadu',135825);
INSERT INTO world.city VALUES (1236,'Bahraich','IND','Uttar Pradesh',135400);
INSERT INTO world.city VALUES (1237,'Gadag Betigeri','IND','Karnataka',134051);
INSERT INTO world.city VALUES (1238,'Proddatur','IND','Andhra Pradesh',133914);
INSERT INTO world.city VALUES (1239,'Chittoor','IND','Andhra Pradesh',133462);
INSERT INTO world.city VALUES (1240,'Barrackpur','IND','West Bengali',133265);
INSERT INTO world.city VALUES (1241,'Bharuch (Broach)','IND','Gujarat',133102);
INSERT INTO world.city VALUES (1242,'Naihati','IND','West Bengali',132701);
INSERT INTO world.city VALUES (1243,'Shillong','IND','Meghalaya',131719);
INSERT INTO world.city VALUES (1244,'Sambalpur','IND','Orissa',131138);
INSERT INTO world.city VALUES (1245,'Junagadh','IND','Gujarat',130484);
INSERT INTO world.city VALUES (1246,'Rae Bareli','IND','Uttar Pradesh',129904);
INSERT INTO world.city VALUES (1247,'Rewa','IND','Madhya Pradesh',128981);
INSERT INTO world.city VALUES (1248,'Gurgaon','IND','Haryana',128608);
INSERT INTO world.city VALUES (1249,'Khammam','IND','Andhra Pradesh',127992);
INSERT INTO world.city VALUES (1250,'Bulandshahr','IND','Uttar Pradesh',127201);
INSERT INTO world.city VALUES (1251,'Navsari','IND','Gujarat',126089);
INSERT INTO world.city VALUES (1252,'Malkajgiri','IND','Andhra Pradesh',126066);
INSERT INTO world.city VALUES (1253,'Midnapore (Medinipur)','IND','West Bengali',125498);
INSERT INTO world.city VALUES (1254,'Miraj','IND','Maharashtra',125407);
INSERT INTO world.city VALUES (1255,'Raj Nandgaon','IND','Chhatisgarh',125371);
INSERT INTO world.city VALUES (1256,'Alandur','IND','Tamil Nadu',125244);
INSERT INTO world.city VALUES (1257,'Puri','IND','Orissa',125199);
INSERT INTO world.city VALUES (1258,'Navadwip','IND','West Bengali',125037);
INSERT INTO world.city VALUES (1259,'Sirsa','IND','Haryana',125000);
INSERT INTO world.city VALUES (1260,'Korba','IND','Chhatisgarh',124501);
INSERT INTO world.city VALUES (1261,'Faizabad','IND','Uttar Pradesh',124437);
INSERT INTO world.city VALUES (1262,'Etawah','IND','Uttar Pradesh',124072);
INSERT INTO world.city VALUES (1263,'Pathankot','IND','Punjab',123930);
INSERT INTO world.city VALUES (1264,'Gandhinagar','IND','Gujarat',123359);
INSERT INTO world.city VALUES (1265,'Palghat (Palakkad)','IND','Kerala',123289);
INSERT INTO world.city VALUES (1266,'Veraval','IND','Gujarat',123000);
INSERT INTO world.city VALUES (1267,'Hoshiarpur','IND','Punjab',122705);
INSERT INTO world.city VALUES (1268,'Ambala','IND','Haryana',122596);
INSERT INTO world.city VALUES (1269,'Sitapur','IND','Uttar Pradesh',121842);
INSERT INTO world.city VALUES (1270,'Bhiwani','IND','Haryana',121629);
INSERT INTO world.city VALUES (1271,'Cuddapah','IND','Andhra Pradesh',121463);
INSERT INTO world.city VALUES (1272,'Bhimavaram','IND','Andhra Pradesh',121314);
INSERT INTO world.city VALUES (1273,'Krishnanagar','IND','West Bengali',121110);
INSERT INTO world.city VALUES (1274,'Chandannagar','IND','West Bengali',120378);
INSERT INTO world.city VALUES (1275,'Mandya','IND','Karnataka',120265);
INSERT INTO world.city VALUES (1276,'Dibrugarh','IND','Assam',120127);
INSERT INTO world.city VALUES (1277,'Nandyal','IND','Andhra Pradesh',119813);
INSERT INTO world.city VALUES (1278,'Balurghat','IND','West Bengali',119796);
INSERT INTO world.city VALUES (1279,'Neyveli','IND','Tamil Nadu',118080);
INSERT INTO world.city VALUES (1280,'Fatehpur','IND','Uttar Pradesh',117675);
INSERT INTO world.city VALUES (1281,'Mahbubnagar','IND','Andhra Pradesh',116833);
INSERT INTO world.city VALUES (1282,'Budaun','IND','Uttar Pradesh',116695);
INSERT INTO world.city VALUES (1283,'Porbandar','IND','Gujarat',116671);
INSERT INTO world.city VALUES (1284,'Silchar','IND','Assam',115483);
INSERT INTO world.city VALUES (1285,'Berhampore (Baharampur)','IND','West Bengali',115144);
INSERT INTO world.city VALUES (1286,'Purnea (Purnia)','IND','Jharkhand',114912);
INSERT INTO world.city VALUES (1287,'Bankura','IND','West Bengali',114876);
INSERT INTO world.city VALUES (1288,'Rajapalaiyam','IND','Tamil Nadu',114202);
INSERT INTO world.city VALUES (1289,'Titagarh','IND','West Bengali',114085);
INSERT INTO world.city VALUES (1290,'Halisahar','IND','West Bengali',114028);
INSERT INTO world.city VALUES (1291,'Hathras','IND','Uttar Pradesh',113285);
INSERT INTO world.city VALUES (1292,'Bhir (Bid)','IND','Maharashtra',112434);
INSERT INTO world.city VALUES (1293,'Pallavaram','IND','Tamil Nadu',111866);
INSERT INTO world.city VALUES (1294,'Anand','IND','Gujarat',110266);
INSERT INTO world.city VALUES (1295,'Mango','IND','Jharkhand',110024);
INSERT INTO world.city VALUES (1296,'Santipur','IND','West Bengali',109956);
INSERT INTO world.city VALUES (1297,'Bhind','IND','Madhya Pradesh',109755);
INSERT INTO world.city VALUES (1298,'Gondiya','IND','Maharashtra',109470);
INSERT INTO world.city VALUES (1299,'Tiruvannamalai','IND','Tamil Nadu',109196);
INSERT INTO world.city VALUES (1300,'Yeotmal (Yavatmal)','IND','Maharashtra',108578);
INSERT INTO world.city VALUES (1301,'Kulti-Barakar','IND','West Bengali',108518);
INSERT INTO world.city VALUES (1302,'Moga','IND','Punjab',108304);
INSERT INTO world.city VALUES (1303,'Shivapuri','IND','Madhya Pradesh',108277);
INSERT INTO world.city VALUES (1304,'Bidar','IND','Karnataka',108016);
INSERT INTO world.city VALUES (1305,'Guntakal','IND','Andhra Pradesh',107592);
INSERT INTO world.city VALUES (1306,'Unnao','IND','Uttar Pradesh',107425);
INSERT INTO world.city VALUES (1307,'Barasat','IND','West Bengali',107365);
INSERT INTO world.city VALUES (1308,'Tambaram','IND','Tamil Nadu',107187);
INSERT INTO world.city VALUES (1309,'Abohar','IND','Punjab',107163);
INSERT INTO world.city VALUES (1310,'Pilibhit','IND','Uttar Pradesh',106605);
INSERT INTO world.city VALUES (1311,'Valparai','IND','Tamil Nadu',106523);
INSERT INTO world.city VALUES (1312,'Gonda','IND','Uttar Pradesh',106078);
INSERT INTO world.city VALUES (1313,'Surendranagar','IND','Gujarat',105973);
INSERT INTO world.city VALUES (1314,'Qutubullapur','IND','Andhra Pradesh',105380);
INSERT INTO world.city VALUES (1315,'Beawar','IND','Rajasthan',105363);
INSERT INTO world.city VALUES (1316,'Hindupur','IND','Andhra Pradesh',104651);
INSERT INTO world.city VALUES (1317,'Gandhidham','IND','Gujarat',104585);
INSERT INTO world.city VALUES (1318,'Haldwani-cum-Kathgodam','IND','Uttaranchal',104195);
INSERT INTO world.city VALUES (1319,'Tellicherry (Thalassery)','IND','Kerala',103579);
INSERT INTO world.city VALUES (1320,'Wardha','IND','Maharashtra',102985);
INSERT INTO world.city VALUES (1321,'Rishra','IND','West Bengali',102649);
INSERT INTO world.city VALUES (1322,'Bhuj','IND','Gujarat',102176);
INSERT INTO world.city VALUES (1323,'Modinagar','IND','Uttar Pradesh',101660);
INSERT INTO world.city VALUES (1324,'Gudivada','IND','Andhra Pradesh',101656);
INSERT INTO world.city VALUES (1325,'Basirhat','IND','West Bengali',101409);
INSERT INTO world.city VALUES (1326,'Uttarpara-Kotrung','IND','West Bengali',100867);
INSERT INTO world.city VALUES (1327,'Ongole','IND','Andhra Pradesh',100836);
INSERT INTO world.city VALUES (1328,'North Barrackpur','IND','West Bengali',100513);
INSERT INTO world.city VALUES (1329,'Guna','IND','Madhya Pradesh',100490);
INSERT INTO world.city VALUES (1330,'Haldia','IND','West Bengali',100347);
INSERT INTO world.city VALUES (1331,'Habra','IND','West Bengali',100223);
INSERT INTO world.city VALUES (1332,'Kanchrapara','IND','West Bengali',100194);
INSERT INTO world.city VALUES (1333,'Tonk','IND','Rajasthan',100079);
INSERT INTO world.city VALUES (1334,'Champdani','IND','West Bengali',98818);
INSERT INTO world.city VALUES (1335,'Orai','IND','Uttar Pradesh',98640);
INSERT INTO world.city VALUES (1336,'Pudukkottai','IND','Tamil Nadu',98619);
INSERT INTO world.city VALUES (1337,'Sasaram','IND','Bihar',98220);
INSERT INTO world.city VALUES (1338,'Hazaribag','IND','Jharkhand',97712);
INSERT INTO world.city VALUES (1339,'Palayankottai','IND','Tamil Nadu',97662);
INSERT INTO world.city VALUES (1340,'Banda','IND','Uttar Pradesh',97227);
INSERT INTO world.city VALUES (1341,'Godhra','IND','Gujarat',96813);
INSERT INTO world.city VALUES (1342,'Hospet','IND','Karnataka',96322);
INSERT INTO world.city VALUES (1343,'Ashoknagar-Kalyangarh','IND','West Bengali',96315);
INSERT INTO world.city VALUES (1344,'Achalpur','IND','Maharashtra',96216);
INSERT INTO world.city VALUES (1345,'Patan','IND','Gujarat',96109);
INSERT INTO world.city VALUES (1346,'Mandasor','IND','Madhya Pradesh',95758);
INSERT INTO world.city VALUES (1347,'Damoh','IND','Madhya Pradesh',95661);
INSERT INTO world.city VALUES (1348,'Satara','IND','Maharashtra',95133);
INSERT INTO world.city VALUES (1349,'Meerut Cantonment','IND','Uttar Pradesh',94876);
INSERT INTO world.city VALUES (1350,'Dehri','IND','Bihar',94526);
INSERT INTO world.city VALUES (1351,'Delhi Cantonment','IND','Delhi',94326);
INSERT INTO world.city VALUES (1352,'Chhindwara','IND','Madhya Pradesh',93731);
INSERT INTO world.city VALUES (1353,'Bansberia','IND','West Bengali',93447);
INSERT INTO world.city VALUES (1354,'Nagaon','IND','Assam',93350);
INSERT INTO world.city VALUES (1355,'Kanpur Cantonment','IND','Uttar Pradesh',93109);
INSERT INTO world.city VALUES (1356,'Vidisha','IND','Madhya Pradesh',92917);
INSERT INTO world.city VALUES (1357,'Bettiah','IND','Bihar',92583);
INSERT INTO world.city VALUES (1358,'Purulia','IND','Jharkhand',92574);
INSERT INTO world.city VALUES (1359,'Hassan','IND','Karnataka',90803);
INSERT INTO world.city VALUES (1360,'Ambala Sadar','IND','Haryana',90712);
INSERT INTO world.city VALUES (1361,'Baidyabati','IND','West Bengali',90601);
INSERT INTO world.city VALUES (1362,'Morvi','IND','Gujarat',90357);
INSERT INTO world.city VALUES (1363,'Raigarh','IND','Chhatisgarh',89166);
INSERT INTO world.city VALUES (1364,'Vejalpur','IND','Gujarat',89053);
INSERT INTO world.city VALUES (1365,'Baghdad','IRQ','Baghdad',4336000);
INSERT INTO world.city VALUES (1366,'Mosul','IRQ','Ninawa',879000);
INSERT INTO world.city VALUES (1367,'Irbil','IRQ','Irbil',485968);
INSERT INTO world.city VALUES (1368,'Kirkuk','IRQ','al-Tamim',418624);
INSERT INTO world.city VALUES (1369,'Basra','IRQ','Basra',406296);
INSERT INTO world.city VALUES (1370,'al-Sulaymaniya','IRQ','al-Sulaymaniya',364096);
INSERT INTO world.city VALUES (1371,'al-Najaf','IRQ','al-Najaf',309010);
INSERT INTO world.city VALUES (1372,'Karbala','IRQ','Karbala',296705);
INSERT INTO world.city VALUES (1373,'al-Hilla','IRQ','Babil',268834);
INSERT INTO world.city VALUES (1374,'al-Nasiriya','IRQ','DhiQar',265937);
INSERT INTO world.city VALUES (1375,'al-Amara','IRQ','Maysan',208797);
INSERT INTO world.city VALUES (1376,'al-Diwaniya','IRQ','al-Qadisiya',196519);
INSERT INTO world.city VALUES (1377,'al-Ramadi','IRQ','al-Anbar',192556);
INSERT INTO world.city VALUES (1378,'al-Kut','IRQ','Wasit',183183);
INSERT INTO world.city VALUES (1379,'Baquba','IRQ','Diyala',114516);
INSERT INTO world.city VALUES (1380,'Teheran','IRN','Teheran',6758845);
INSERT INTO world.city VALUES (1381,'Mashhad','IRN','Khorasan',1887405);
INSERT INTO world.city VALUES (1382,'Esfahan','IRN','Esfahan',1266072);
INSERT INTO world.city VALUES (1383,'Tabriz','IRN','East Azerbaidzan',1191043);
INSERT INTO world.city VALUES (1384,'Shiraz','IRN','Fars',1053025);
INSERT INTO world.city VALUES (1385,'Karaj','IRN','Teheran',940968);
INSERT INTO world.city VALUES (1386,'Ahvaz','IRN','Khuzestan',804980);
INSERT INTO world.city VALUES (1387,'Qom','IRN','Qom',777677);
INSERT INTO world.city VALUES (1388,'Kermanshah','IRN','Kermanshah',692986);
INSERT INTO world.city VALUES (1389,'Urmia','IRN','West Azerbaidzan',435200);
INSERT INTO world.city VALUES (1390,'Zahedan','IRN','Sistan va Baluchesta',419518);
INSERT INTO world.city VALUES (1391,'Rasht','IRN','Gilan',417748);
INSERT INTO world.city VALUES (1392,'Hamadan','IRN','Hamadan',401281);
INSERT INTO world.city VALUES (1393,'Kerman','IRN','Kerman',384991);
INSERT INTO world.city VALUES (1394,'Arak','IRN','Markazi',380755);
INSERT INTO world.city VALUES (1395,'Ardebil','IRN','Ardebil',340386);
INSERT INTO world.city VALUES (1396,'Yazd','IRN','Yazd',326776);
INSERT INTO world.city VALUES (1397,'Qazvin','IRN','Qazvin',291117);
INSERT INTO world.city VALUES (1398,'Zanjan','IRN','Zanjan',286295);
INSERT INTO world.city VALUES (1399,'Sanandaj','IRN','Kordestan',277808);
INSERT INTO world.city VALUES (1400,'Bandar-e-Abbas','IRN','Hormozgan',273578);
INSERT INTO world.city VALUES (1401,'Khorramabad','IRN','Lorestan',272815);
INSERT INTO world.city VALUES (1402,'Eslamshahr','IRN','Teheran',265450);
INSERT INTO world.city VALUES (1403,'Borujerd','IRN','Lorestan',217804);
INSERT INTO world.city VALUES (1404,'Abadan','IRN','Khuzestan',206073);
INSERT INTO world.city VALUES (1405,'Dezful','IRN','Khuzestan',202639);
INSERT INTO world.city VALUES (1406,'Kashan','IRN','Esfahan',201372);
INSERT INTO world.city VALUES (1407,'Sari','IRN','Mazandaran',195882);
INSERT INTO world.city VALUES (1408,'Gorgan','IRN','Golestan',188710);
INSERT INTO world.city VALUES (1409,'Najafabad','IRN','Esfahan',178498);
INSERT INTO world.city VALUES (1410,'Sabzevar','IRN','Khorasan',170738);
INSERT INTO world.city VALUES (1411,'Khomeynishahr','IRN','Esfahan',165888);
INSERT INTO world.city VALUES (1412,'Amol','IRN','Mazandaran',159092);
INSERT INTO world.city VALUES (1413,'Neyshabur','IRN','Khorasan',158847);
INSERT INTO world.city VALUES (1414,'Babol','IRN','Mazandaran',158346);
INSERT INTO world.city VALUES (1415,'Khoy','IRN','West Azerbaidzan',148944);
INSERT INTO world.city VALUES (1416,'Malayer','IRN','Hamadan',144373);
INSERT INTO world.city VALUES (1417,'Bushehr','IRN','Bushehr',143641);
INSERT INTO world.city VALUES (1418,'Qaemshahr','IRN','Mazandaran',143286);
INSERT INTO world.city VALUES (1419,'Qarchak','IRN','Teheran',142690);
INSERT INTO world.city VALUES (1420,'Qods','IRN','Teheran',138278);
INSERT INTO world.city VALUES (1421,'Sirjan','IRN','Kerman',135024);
INSERT INTO world.city VALUES (1422,'Bojnurd','IRN','Khorasan',134835);
INSERT INTO world.city VALUES (1423,'Maragheh','IRN','East Azerbaidzan',132318);
INSERT INTO world.city VALUES (1424,'Birjand','IRN','Khorasan',127608);
INSERT INTO world.city VALUES (1425,'Ilam','IRN','Ilam',126346);
INSERT INTO world.city VALUES (1426,'Bukan','IRN','West Azerbaidzan',120020);
INSERT INTO world.city VALUES (1427,'Masjed-e-Soleyman','IRN','Khuzestan',116883);
INSERT INTO world.city VALUES (1428,'Saqqez','IRN','Kordestan',115394);
INSERT INTO world.city VALUES (1429,'Gonbad-e Qabus','IRN','Mazandaran',111253);
INSERT INTO world.city VALUES (1430,'Saveh','IRN','Qom',111245);
INSERT INTO world.city VALUES (1431,'Mahabad','IRN','West Azerbaidzan',107799);
INSERT INTO world.city VALUES (1432,'Varamin','IRN','Teheran',107233);
INSERT INTO world.city VALUES (1433,'Andimeshk','IRN','Khuzestan',106923);
INSERT INTO world.city VALUES (1434,'Khorramshahr','IRN','Khuzestan',105636);
INSERT INTO world.city VALUES (1435,'Shahrud','IRN','Semnan',104765);
INSERT INTO world.city VALUES (1436,'Marv Dasht','IRN','Fars',103579);
INSERT INTO world.city VALUES (1437,'Zabol','IRN','Sistan va Baluchesta',100887);
INSERT INTO world.city VALUES (1438,'Shahr-e Kord','IRN','Chaharmahal va Bakht',100477);
INSERT INTO world.city VALUES (1439,'Bandar-e Anzali','IRN','Gilan',98500);
INSERT INTO world.city VALUES (1440,'Rafsanjan','IRN','Kerman',98300);
INSERT INTO world.city VALUES (1441,'Marand','IRN','East Azerbaidzan',96400);
INSERT INTO world.city VALUES (1442,'Torbat-e Heydariyeh','IRN','Khorasan',94600);
INSERT INTO world.city VALUES (1443,'Jahrom','IRN','Fars',94200);
INSERT INTO world.city VALUES (1444,'Semnan','IRN','Semnan',91045);
INSERT INTO world.city VALUES (1445,'Miandoab','IRN','West Azerbaidzan',90100);
INSERT INTO world.city VALUES (1446,'Qomsheh','IRN','Esfahan',89800);
INSERT INTO world.city VALUES (1447,'Dublin','IRL','Leinster',481854);
INSERT INTO world.city VALUES (1448,'Cork','IRL','Munster',127187);
INSERT INTO world.city VALUES (1449,'Reykjavík','ISL','Höfuðborgarsvæði',109184);
INSERT INTO world.city VALUES (1450,'Jerusalem','ISR','Jerusalem',633700);
INSERT INTO world.city VALUES (1451,'Tel Aviv-Jaffa','ISR','Tel Aviv',348100);
INSERT INTO world.city VALUES (1452,'Haifa','ISR','Haifa',265700);
INSERT INTO world.city VALUES (1453,'Rishon Le Ziyyon','ISR','Ha Merkaz',188200);
INSERT INTO world.city VALUES (1454,'Beerseba','ISR','Ha Darom',163700);
INSERT INTO world.city VALUES (1455,'Holon','ISR','Tel Aviv',163100);
INSERT INTO world.city VALUES (1456,'Petah Tiqwa','ISR','Ha Merkaz',159400);
INSERT INTO world.city VALUES (1457,'Ashdod','ISR','Ha Darom',155800);
INSERT INTO world.city VALUES (1458,'Netanya','ISR','Ha Merkaz',154900);
INSERT INTO world.city VALUES (1459,'Bat Yam','ISR','Tel Aviv',137000);
INSERT INTO world.city VALUES (1460,'Bene Beraq','ISR','Tel Aviv',133900);
INSERT INTO world.city VALUES (1461,'Ramat Gan','ISR','Tel Aviv',126900);
INSERT INTO world.city VALUES (1462,'Ashqelon','ISR','Ha Darom',92300);
INSERT INTO world.city VALUES (1463,'Rehovot','ISR','Ha Merkaz',90300);
INSERT INTO world.city VALUES (1464,'Roma','ITA','Latium',2643581);
INSERT INTO world.city VALUES (1465,'Milano','ITA','Lombardia',1300977);
INSERT INTO world.city VALUES (1466,'Napoli','ITA','Campania',1002619);
INSERT INTO world.city VALUES (1467,'Torino','ITA','Piemonte',903705);
INSERT INTO world.city VALUES (1468,'Palermo','ITA','Sisilia',683794);
INSERT INTO world.city VALUES (1469,'Genova','ITA','Liguria',636104);
INSERT INTO world.city VALUES (1470,'Bologna','ITA','Emilia-Romagna',381161);
INSERT INTO world.city VALUES (1471,'Firenze','ITA','Toscana',376662);
INSERT INTO world.city VALUES (1472,'Catania','ITA','Sisilia',337862);
INSERT INTO world.city VALUES (1473,'Bari','ITA','Apulia',331848);
INSERT INTO world.city VALUES (1474,'Venezia','ITA','Veneto',277305);
INSERT INTO world.city VALUES (1475,'Messina','ITA','Sisilia',259156);
INSERT INTO world.city VALUES (1476,'Verona','ITA','Veneto',255268);
INSERT INTO world.city VALUES (1477,'Trieste','ITA','Friuli-Venezia Giuli',216459);
INSERT INTO world.city VALUES (1478,'Padova','ITA','Veneto',211391);
INSERT INTO world.city VALUES (1479,'Taranto','ITA','Apulia',208214);
INSERT INTO world.city VALUES (1480,'Brescia','ITA','Lombardia',191317);
INSERT INTO world.city VALUES (1481,'Reggio di Calabria','ITA','Calabria',179617);
INSERT INTO world.city VALUES (1482,'Modena','ITA','Emilia-Romagna',176022);
INSERT INTO world.city VALUES (1483,'Prato','ITA','Toscana',172473);
INSERT INTO world.city VALUES (1484,'Parma','ITA','Emilia-Romagna',168717);
INSERT INTO world.city VALUES (1485,'Cagliari','ITA','Sardinia',165926);
INSERT INTO world.city VALUES (1486,'Livorno','ITA','Toscana',161673);
INSERT INTO world.city VALUES (1487,'Perugia','ITA','Umbria',156673);
INSERT INTO world.city VALUES (1488,'Foggia','ITA','Apulia',154891);
INSERT INTO world.city VALUES (1489,'Reggio nell´ Emilia','ITA','Emilia-Romagna',143664);
INSERT INTO world.city VALUES (1490,'Salerno','ITA','Campania',142055);
INSERT INTO world.city VALUES (1491,'Ravenna','ITA','Emilia-Romagna',138418);
INSERT INTO world.city VALUES (1492,'Ferrara','ITA','Emilia-Romagna',132127);
INSERT INTO world.city VALUES (1493,'Rimini','ITA','Emilia-Romagna',131062);
INSERT INTO world.city VALUES (1494,'Syrakusa','ITA','Sisilia',126282);
INSERT INTO world.city VALUES (1495,'Sassari','ITA','Sardinia',120803);
INSERT INTO world.city VALUES (1496,'Monza','ITA','Lombardia',119516);
INSERT INTO world.city VALUES (1497,'Bergamo','ITA','Lombardia',117837);
INSERT INTO world.city VALUES (1498,'Pescara','ITA','Abruzzit',115698);
INSERT INTO world.city VALUES (1499,'Latina','ITA','Latium',114099);
INSERT INTO world.city VALUES (1500,'Vicenza','ITA','Veneto',109738);
INSERT INTO world.city VALUES (1501,'Terni','ITA','Umbria',107770);
INSERT INTO world.city VALUES (1502,'Forlì','ITA','Emilia-Romagna',107475);
INSERT INTO world.city VALUES (1503,'Trento','ITA','Trentino-Alto Adige',104906);
INSERT INTO world.city VALUES (1504,'Novara','ITA','Piemonte',102037);
INSERT INTO world.city VALUES (1505,'Piacenza','ITA','Emilia-Romagna',98384);
INSERT INTO world.city VALUES (1506,'Ancona','ITA','Marche',98329);
INSERT INTO world.city VALUES (1507,'Lecce','ITA','Apulia',98208);
INSERT INTO world.city VALUES (1508,'Bolzano','ITA','Trentino-Alto Adige',97232);
INSERT INTO world.city VALUES (1509,'Catanzaro','ITA','Calabria',96700);
INSERT INTO world.city VALUES (1510,'La Spezia','ITA','Liguria',95504);
INSERT INTO world.city VALUES (1511,'Udine','ITA','Friuli-Venezia Giuli',94932);
INSERT INTO world.city VALUES (1512,'Torre del Greco','ITA','Campania',94505);
INSERT INTO world.city VALUES (1513,'Andria','ITA','Apulia',94443);
INSERT INTO world.city VALUES (1514,'Brindisi','ITA','Apulia',93454);
INSERT INTO world.city VALUES (1515,'Giugliano in Campania','ITA','Campania',93286);
INSERT INTO world.city VALUES (1516,'Pisa','ITA','Toscana',92379);
INSERT INTO world.city VALUES (1517,'Barletta','ITA','Apulia',91904);
INSERT INTO world.city VALUES (1518,'Arezzo','ITA','Toscana',91729);
INSERT INTO world.city VALUES (1519,'Alessandria','ITA','Piemonte',90289);
INSERT INTO world.city VALUES (1520,'Cesena','ITA','Emilia-Romagna',89852);
INSERT INTO world.city VALUES (1521,'Pesaro','ITA','Marche',88987);
INSERT INTO world.city VALUES (1522,'Dili','TMP','Dili',47900);
INSERT INTO world.city VALUES (1523,'Wien','AUT','Wien',1608144);
INSERT INTO world.city VALUES (1524,'Graz','AUT','Steiermark',240967);
INSERT INTO world.city VALUES (1525,'Linz','AUT','North Austria',188022);
INSERT INTO world.city VALUES (1526,'Salzburg','AUT','Salzburg',144247);
INSERT INTO world.city VALUES (1527,'Innsbruck','AUT','Tiroli',111752);
INSERT INTO world.city VALUES (1528,'Klagenfurt','AUT','Kärnten',91141);
INSERT INTO world.city VALUES (1529,'Spanish Town','JAM','St. Catherine',110379);
INSERT INTO world.city VALUES (1530,'Kingston','JAM','St. Andrew',103962);
INSERT INTO world.city VALUES (1531,'Portmore','JAM','St. Andrew',99799);
INSERT INTO world.city VALUES (1532,'Tokyo','JPN','Tokyo-to',7980230);
INSERT INTO world.city VALUES (1533,'Jokohama [Yokohama]','JPN','Kanagawa',3339594);
INSERT INTO world.city VALUES (1534,'Osaka','JPN','Osaka',2595674);
INSERT INTO world.city VALUES (1535,'Nagoya','JPN','Aichi',2154376);
INSERT INTO world.city VALUES (1536,'Sapporo','JPN','Hokkaido',1790886);
INSERT INTO world.city VALUES (1537,'Kioto','JPN','Kyoto',1461974);
INSERT INTO world.city VALUES (1538,'Kobe','JPN','Hyogo',1425139);
INSERT INTO world.city VALUES (1539,'Fukuoka','JPN','Fukuoka',1308379);
INSERT INTO world.city VALUES (1540,'Kawasaki','JPN','Kanagawa',1217359);
INSERT INTO world.city VALUES (1541,'Hiroshima','JPN','Hiroshima',1119117);
INSERT INTO world.city VALUES (1542,'Kitakyushu','JPN','Fukuoka',1016264);
INSERT INTO world.city VALUES (1543,'Sendai','JPN','Miyagi',989975);
INSERT INTO world.city VALUES (1544,'Chiba','JPN','Chiba',863930);
INSERT INTO world.city VALUES (1545,'Sakai','JPN','Osaka',797735);
INSERT INTO world.city VALUES (1546,'Kumamoto','JPN','Kumamoto',656734);
INSERT INTO world.city VALUES (1547,'Okayama','JPN','Okayama',624269);
INSERT INTO world.city VALUES (1548,'Sagamihara','JPN','Kanagawa',586300);
INSERT INTO world.city VALUES (1549,'Hamamatsu','JPN','Shizuoka',568796);
INSERT INTO world.city VALUES (1550,'Kagoshima','JPN','Kagoshima',549977);
INSERT INTO world.city VALUES (1551,'Funabashi','JPN','Chiba',545299);
INSERT INTO world.city VALUES (1552,'Higashiosaka','JPN','Osaka',517785);
INSERT INTO world.city VALUES (1553,'Hachioji','JPN','Tokyo-to',513451);
INSERT INTO world.city VALUES (1554,'Niigata','JPN','Niigata',497464);
INSERT INTO world.city VALUES (1555,'Amagasaki','JPN','Hyogo',481434);
INSERT INTO world.city VALUES (1556,'Himeji','JPN','Hyogo',475167);
INSERT INTO world.city VALUES (1557,'Shizuoka','JPN','Shizuoka',473854);
INSERT INTO world.city VALUES (1558,'Urawa','JPN','Saitama',469675);
INSERT INTO world.city VALUES (1559,'Matsuyama','JPN','Ehime',466133);
INSERT INTO world.city VALUES (1560,'Matsudo','JPN','Chiba',461126);
INSERT INTO world.city VALUES (1561,'Kanazawa','JPN','Ishikawa',455386);
INSERT INTO world.city VALUES (1562,'Kawaguchi','JPN','Saitama',452155);
INSERT INTO world.city VALUES (1563,'Ichikawa','JPN','Chiba',441893);
INSERT INTO world.city VALUES (1564,'Omiya','JPN','Saitama',441649);
INSERT INTO world.city VALUES (1565,'Utsunomiya','JPN','Tochigi',440353);
INSERT INTO world.city VALUES (1566,'Oita','JPN','Oita',433401);
INSERT INTO world.city VALUES (1567,'Nagasaki','JPN','Nagasaki',432759);
INSERT INTO world.city VALUES (1568,'Yokosuka','JPN','Kanagawa',430200);
INSERT INTO world.city VALUES (1569,'Kurashiki','JPN','Okayama',425103);
INSERT INTO world.city VALUES (1570,'Gifu','JPN','Gifu',408007);
INSERT INTO world.city VALUES (1571,'Hirakata','JPN','Osaka',403151);
INSERT INTO world.city VALUES (1572,'Nishinomiya','JPN','Hyogo',397618);
INSERT INTO world.city VALUES (1573,'Toyonaka','JPN','Osaka',396689);
INSERT INTO world.city VALUES (1574,'Wakayama','JPN','Wakayama',391233);
INSERT INTO world.city VALUES (1575,'Fukuyama','JPN','Hiroshima',376921);
INSERT INTO world.city VALUES (1576,'Fujisawa','JPN','Kanagawa',372840);
INSERT INTO world.city VALUES (1577,'Asahikawa','JPN','Hokkaido',364813);
INSERT INTO world.city VALUES (1578,'Machida','JPN','Tokyo-to',364197);
INSERT INTO world.city VALUES (1579,'Nara','JPN','Nara',362812);
INSERT INTO world.city VALUES (1580,'Takatsuki','JPN','Osaka',361747);
INSERT INTO world.city VALUES (1581,'Iwaki','JPN','Fukushima',361737);
INSERT INTO world.city VALUES (1582,'Nagano','JPN','Nagano',361391);
INSERT INTO world.city VALUES (1583,'Toyohashi','JPN','Aichi',360066);
INSERT INTO world.city VALUES (1584,'Toyota','JPN','Aichi',346090);
INSERT INTO world.city VALUES (1585,'Suita','JPN','Osaka',345750);
INSERT INTO world.city VALUES (1586,'Takamatsu','JPN','Kagawa',332471);
INSERT INTO world.city VALUES (1587,'Koriyama','JPN','Fukushima',330335);
INSERT INTO world.city VALUES (1588,'Okazaki','JPN','Aichi',328711);
INSERT INTO world.city VALUES (1589,'Kawagoe','JPN','Saitama',327211);
INSERT INTO world.city VALUES (1590,'Tokorozawa','JPN','Saitama',325809);
INSERT INTO world.city VALUES (1591,'Toyama','JPN','Toyama',325790);
INSERT INTO world.city VALUES (1592,'Kochi','JPN','Kochi',324710);
INSERT INTO world.city VALUES (1593,'Kashiwa','JPN','Chiba',320296);
INSERT INTO world.city VALUES (1594,'Akita','JPN','Akita',314440);
INSERT INTO world.city VALUES (1595,'Miyazaki','JPN','Miyazaki',303784);
INSERT INTO world.city VALUES (1596,'Koshigaya','JPN','Saitama',301446);
INSERT INTO world.city VALUES (1597,'Naha','JPN','Okinawa',299851);
INSERT INTO world.city VALUES (1598,'Aomori','JPN','Aomori',295969);
INSERT INTO world.city VALUES (1599,'Hakodate','JPN','Hokkaido',294788);
INSERT INTO world.city VALUES (1600,'Akashi','JPN','Hyogo',292253);
INSERT INTO world.city VALUES (1601,'Yokkaichi','JPN','Mie',288173);
INSERT INTO world.city VALUES (1602,'Fukushima','JPN','Fukushima',287525);
INSERT INTO world.city VALUES (1603,'Morioka','JPN','Iwate',287353);
INSERT INTO world.city VALUES (1604,'Maebashi','JPN','Gumma',284473);
INSERT INTO world.city VALUES (1605,'Kasugai','JPN','Aichi',282348);
INSERT INTO world.city VALUES (1606,'Otsu','JPN','Shiga',282070);
INSERT INTO world.city VALUES (1607,'Ichihara','JPN','Chiba',279280);
INSERT INTO world.city VALUES (1608,'Yao','JPN','Osaka',276421);
INSERT INTO world.city VALUES (1609,'Ichinomiya','JPN','Aichi',270828);
INSERT INTO world.city VALUES (1610,'Tokushima','JPN','Tokushima',269649);
INSERT INTO world.city VALUES (1611,'Kakogawa','JPN','Hyogo',266281);
INSERT INTO world.city VALUES (1612,'Ibaraki','JPN','Osaka',261020);
INSERT INTO world.city VALUES (1613,'Neyagawa','JPN','Osaka',257315);
INSERT INTO world.city VALUES (1614,'Shimonoseki','JPN','Yamaguchi',257263);
INSERT INTO world.city VALUES (1615,'Yamagata','JPN','Yamagata',255617);
INSERT INTO world.city VALUES (1616,'Fukui','JPN','Fukui',254818);
INSERT INTO world.city VALUES (1617,'Hiratsuka','JPN','Kanagawa',254207);
INSERT INTO world.city VALUES (1618,'Mito','JPN','Ibaragi',246559);
INSERT INTO world.city VALUES (1619,'Sasebo','JPN','Nagasaki',244240);
INSERT INTO world.city VALUES (1620,'Hachinohe','JPN','Aomori',242979);
INSERT INTO world.city VALUES (1621,'Takasaki','JPN','Gumma',239124);
INSERT INTO world.city VALUES (1622,'Shimizu','JPN','Shizuoka',239123);
INSERT INTO world.city VALUES (1623,'Kurume','JPN','Fukuoka',235611);
INSERT INTO world.city VALUES (1624,'Fuji','JPN','Shizuoka',231527);
INSERT INTO world.city VALUES (1625,'Soka','JPN','Saitama',222768);
INSERT INTO world.city VALUES (1626,'Fuchu','JPN','Tokyo-to',220576);
INSERT INTO world.city VALUES (1627,'Chigasaki','JPN','Kanagawa',216015);
INSERT INTO world.city VALUES (1628,'Atsugi','JPN','Kanagawa',212407);
INSERT INTO world.city VALUES (1629,'Numazu','JPN','Shizuoka',211382);
INSERT INTO world.city VALUES (1630,'Ageo','JPN','Saitama',209442);
INSERT INTO world.city VALUES (1631,'Yamato','JPN','Kanagawa',208234);
INSERT INTO world.city VALUES (1632,'Matsumoto','JPN','Nagano',206801);
INSERT INTO world.city VALUES (1633,'Kure','JPN','Hiroshima',206504);
INSERT INTO world.city VALUES (1634,'Takarazuka','JPN','Hyogo',205993);
INSERT INTO world.city VALUES (1635,'Kasukabe','JPN','Saitama',201838);
INSERT INTO world.city VALUES (1636,'Chofu','JPN','Tokyo-to',201585);
INSERT INTO world.city VALUES (1637,'Odawara','JPN','Kanagawa',200171);
INSERT INTO world.city VALUES (1638,'Kofu','JPN','Yamanashi',199753);
INSERT INTO world.city VALUES (1639,'Kushiro','JPN','Hokkaido',197608);
INSERT INTO world.city VALUES (1640,'Kishiwada','JPN','Osaka',197276);
INSERT INTO world.city VALUES (1641,'Hitachi','JPN','Ibaragi',196622);
INSERT INTO world.city VALUES (1642,'Nagaoka','JPN','Niigata',192407);
INSERT INTO world.city VALUES (1643,'Itami','JPN','Hyogo',190886);
INSERT INTO world.city VALUES (1644,'Uji','JPN','Kyoto',188735);
INSERT INTO world.city VALUES (1645,'Suzuka','JPN','Mie',184061);
INSERT INTO world.city VALUES (1646,'Hirosaki','JPN','Aomori',177522);
INSERT INTO world.city VALUES (1647,'Ube','JPN','Yamaguchi',175206);
INSERT INTO world.city VALUES (1648,'Kodaira','JPN','Tokyo-to',174984);
INSERT INTO world.city VALUES (1649,'Takaoka','JPN','Toyama',174380);
INSERT INTO world.city VALUES (1650,'Obihiro','JPN','Hokkaido',173685);
INSERT INTO world.city VALUES (1651,'Tomakomai','JPN','Hokkaido',171958);
INSERT INTO world.city VALUES (1652,'Saga','JPN','Saga',170034);
INSERT INTO world.city VALUES (1653,'Sakura','JPN','Chiba',168072);
INSERT INTO world.city VALUES (1654,'Kamakura','JPN','Kanagawa',167661);
INSERT INTO world.city VALUES (1655,'Mitaka','JPN','Tokyo-to',167268);
INSERT INTO world.city VALUES (1656,'Izumi','JPN','Osaka',166979);
INSERT INTO world.city VALUES (1657,'Hino','JPN','Tokyo-to',166770);
INSERT INTO world.city VALUES (1658,'Hadano','JPN','Kanagawa',166512);
INSERT INTO world.city VALUES (1659,'Ashikaga','JPN','Tochigi',165243);
INSERT INTO world.city VALUES (1660,'Tsu','JPN','Mie',164543);
INSERT INTO world.city VALUES (1661,'Sayama','JPN','Saitama',162472);
INSERT INTO world.city VALUES (1662,'Yachiyo','JPN','Chiba',161222);
INSERT INTO world.city VALUES (1663,'Tsukuba','JPN','Ibaragi',160768);
INSERT INTO world.city VALUES (1664,'Tachikawa','JPN','Tokyo-to',159430);
INSERT INTO world.city VALUES (1665,'Kumagaya','JPN','Saitama',157171);
INSERT INTO world.city VALUES (1666,'Moriguchi','JPN','Osaka',155941);
INSERT INTO world.city VALUES (1667,'Otaru','JPN','Hokkaido',155784);
INSERT INTO world.city VALUES (1668,'Anjo','JPN','Aichi',153823);
INSERT INTO world.city VALUES (1669,'Narashino','JPN','Chiba',152849);
INSERT INTO world.city VALUES (1670,'Oyama','JPN','Tochigi',152820);
INSERT INTO world.city VALUES (1671,'Ogaki','JPN','Gifu',151758);
INSERT INTO world.city VALUES (1672,'Matsue','JPN','Shimane',149821);
INSERT INTO world.city VALUES (1673,'Kawanishi','JPN','Hyogo',149794);
INSERT INTO world.city VALUES (1674,'Hitachinaka','JPN','Tokyo-to',148006);
INSERT INTO world.city VALUES (1675,'Niiza','JPN','Saitama',147744);
INSERT INTO world.city VALUES (1676,'Nagareyama','JPN','Chiba',147738);
INSERT INTO world.city VALUES (1677,'Tottori','JPN','Tottori',147523);
INSERT INTO world.city VALUES (1678,'Tama','JPN','Ibaragi',146712);
INSERT INTO world.city VALUES (1679,'Iruma','JPN','Saitama',145922);
INSERT INTO world.city VALUES (1680,'Ota','JPN','Gumma',145317);
INSERT INTO world.city VALUES (1681,'Omuta','JPN','Fukuoka',142889);
INSERT INTO world.city VALUES (1682,'Komaki','JPN','Aichi',139827);
INSERT INTO world.city VALUES (1683,'Ome','JPN','Tokyo-to',139216);
INSERT INTO world.city VALUES (1684,'Kadoma','JPN','Osaka',138953);
INSERT INTO world.city VALUES (1685,'Yamaguchi','JPN','Yamaguchi',138210);
INSERT INTO world.city VALUES (1686,'Higashimurayama','JPN','Tokyo-to',136970);
INSERT INTO world.city VALUES (1687,'Yonago','JPN','Tottori',136461);
INSERT INTO world.city VALUES (1688,'Matsubara','JPN','Osaka',135010);
INSERT INTO world.city VALUES (1689,'Musashino','JPN','Tokyo-to',134426);
INSERT INTO world.city VALUES (1690,'Tsuchiura','JPN','Ibaragi',134072);
INSERT INTO world.city VALUES (1691,'Joetsu','JPN','Niigata',133505);
INSERT INTO world.city VALUES (1692,'Miyakonojo','JPN','Miyazaki',133183);
INSERT INTO world.city VALUES (1693,'Misato','JPN','Saitama',132957);
INSERT INTO world.city VALUES (1694