PRAGMA foreign_keys = ON;

PRAGMA writable_schema = 1;
DELETE FROM sqlite_master WHERE type IN ("table", "index", "trigger");
PRAGMA writable_schema = 0;
VACUUM;

CREATE TABLE "city" (
"ID" INT,
"Name" CHAR(35),
PRIMARY KEY ("ID")
);

CREATE TABLE "country" (
"Code" CHAR(3) UNIQUE,
"Name" CHAR(52),
"GovernmentForm" CHAR(45),
"Capital" INT,
PRIMARY KEY ("Code")
);

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
PRIMARY KEY ("CountryCode", "Language"),
FOREIGN KEY ("CountryCode") REFERENCES "country"("Code")
);





INSERT INTO "city" VALUES ("1", "Kabul");
INSERT INTO "city" VALUES ("2", "Tirana");
INSERT INTO "city" VALUES ("3", "Algiers");
INSERT INTO "city" VALUES ("4", "Andorra la Vella");
INSERT INTO "city" VALUES ("5", "Luanda");
INSERT INTO "city" VALUES ("6", "Buenos Aires");
INSERT INTO "city" VALUES ("7", "Yerevan");
INSERT INTO "city" VALUES ("8", "Canberra");
INSERT INTO "city" VALUES ("9", "Vienna");
INSERT INTO "city" VALUES ("10", "Baku");
INSERT INTO "city" VALUES ("11", "Nassau");
INSERT INTO "city" VALUES ("12", "Manama");
INSERT INTO "city" VALUES ("13", "Dhaka");
INSERT INTO "city" VALUES ("14", "Bridgetown");
INSERT INTO "city" VALUES ("15", "Minsk");
INSERT INTO "city" VALUES ("16", "Brussels");
INSERT INTO "city" VALUES ("17", "Belmopan");
INSERT INTO "city" VALUES ("18", "Porto-Novo");
INSERT INTO "city" VALUES ("19", "Thimphu");
INSERT INTO "city" VALUES ("20", "Sucre");
INSERT INTO "city" VALUES ("21", "Sarajevo");
INSERT INTO "city" VALUES ("22", "Gaborone");
INSERT INTO "city" VALUES ("23", "Brasília");
INSERT INTO "city" VALUES ("24", "Bandar Seri Begawan");
INSERT INTO "city" VALUES ("25", "Sofia");
INSERT INTO "city" VALUES ("26", "Ouagadougou");
INSERT INTO "city" VALUES ("27", "Bujumbura");
INSERT INTO "city" VALUES ("28", "Phnom Penh");
INSERT INTO "city" VALUES ("29", "Yaoundé");
INSERT INTO "city" VALUES ("30", "Ottawa");
INSERT INTO "city" VALUES ("31", "Praia");
INSERT INTO "city" VALUES ("32", "Bangui");
INSERT INTO "city" VALUES ("33", "N'Djamena");
INSERT INTO "city" VALUES ("34", "Santiago");
INSERT INTO "city" VALUES ("35", "Beijing");
INSERT INTO "city" VALUES ("36", "Bogotá");
INSERT INTO "city" VALUES ("37", "Moroni");
INSERT INTO "city" VALUES ("38", "Kinshasa");
INSERT INTO "city" VALUES ("39", "Brazzaville");
INSERT INTO "city" VALUES ("40", "San José");
INSERT INTO "city" VALUES ("41", "Yamoussoukro");
INSERT INTO "city" VALUES ("42", "Zagreb");
INSERT INTO "city" VALUES ("43", "Havana");
INSERT INTO "city" VALUES ("44", "Nicosia");
INSERT INTO "city" VALUES ("45", "Prague");
INSERT INTO "city" VALUES ("46", "Copenhagen");
INSERT INTO "city" VALUES ("47", "Djibouti");
INSERT INTO "city" VALUES ("48", "Roseau");
INSERT INTO "city" VALUES ("49", "Santo Domingo");
INSERT INTO "city" VALUES ("50", "Quito");
INSERT INTO "city" VALUES ("51", "Cairo");
INSERT INTO "city" VALUES ("52", "San Salvador");
INSERT INTO "city" VALUES ("53", "Malabo");
INSERT INTO "city" VALUES ("54", "Asmara");
INSERT INTO "city" VALUES ("55", "Tallinn");
INSERT INTO "city" VALUES ("56", "Addis Ababa");
INSERT INTO "city" VALUES ("57", "Palikir");
INSERT INTO "city" VALUES ("58", "Suva");
INSERT INTO "city" VALUES ("59", "Helsinki");
INSERT INTO "city" VALUES ("60", "Paris");
INSERT INTO "city" VALUES ("61", "Libreville");
INSERT INTO "city" VALUES ("62", "Banjul");
INSERT INTO "city" VALUES ("63", "Tbilisi");
INSERT INTO "city" VALUES ("64", "Berlin");
INSERT INTO "city" VALUES ("65", "Accra");
INSERT INTO "city" VALUES ("66", "Athens");
INSERT INTO "city" VALUES ("67", "Saint George's");
INSERT INTO "city" VALUES ("68", "Guatemala City");
INSERT INTO "city" VALUES ("69", "Conakry");
INSERT INTO "city" VALUES ("70", "Bissau");
INSERT INTO "city" VALUES ("71", "Georgetown");
INSERT INTO "city" VALUES ("72", "Port-au-Prince");
INSERT INTO "city" VALUES ("73", "Tegucigalpa");
INSERT INTO "city" VALUES ("74", "Budapest");
INSERT INTO "city" VALUES ("75", "Reykjavík");
INSERT INTO "city" VALUES ("76", "New Delhi");
INSERT INTO "city" VALUES ("77", "Jakarta");
INSERT INTO "city" VALUES ("78", "Tehran");
INSERT INTO "city" VALUES ("79", "Baghdad");
INSERT INTO "city" VALUES ("80", "Dublin");
INSERT INTO "city" VALUES ("81", "Jerusalem");
INSERT INTO "city" VALUES ("82", "Rome");
INSERT INTO "city" VALUES ("83", "Kingston");
INSERT INTO "city" VALUES ("84", "Tokyo");
INSERT INTO "city" VALUES ("85", "Amman");
INSERT INTO "city" VALUES ("86", "Astana");
INSERT INTO "city" VALUES ("87", "Nairobi");
INSERT INTO "city" VALUES ("88", "Tarawa");
INSERT INTO "city" VALUES ("89", "Pyongyang");
INSERT INTO "city" VALUES ("90", "Seoul");
INSERT INTO "city" VALUES ("91", "Pristina");
INSERT INTO "city" VALUES ("92", "Kuwait City");
INSERT INTO "city" VALUES ("93", "Bishkek");
INSERT INTO "city" VALUES ("94", "Vientiane");
INSERT INTO "city" VALUES ("95", "Riga");
INSERT INTO "city" VALUES ("96", "Beirut");
INSERT INTO "city" VALUES ("97", "Maseru");
INSERT INTO "city" VALUES ("98", "Monrovia");
INSERT INTO "city" VALUES ("99", "Tripoli");
INSERT INTO "city" VALUES ("100", "Vaduz");
INSERT INTO "city" VALUES ("101", "Vilnius");
INSERT INTO "city" VALUES ("102", "Luxembourg City");
INSERT INTO "city" VALUES ("103", "Antananarivo");
INSERT INTO "city" VALUES ("104", "Lilongwe");
INSERT INTO "city" VALUES ("105", "Kuala Lumpur");
INSERT INTO "city" VALUES ("106", "Malé");
INSERT INTO "city" VALUES ("107", "Bamako");
INSERT INTO "city" VALUES ("108", "Valletta");
INSERT INTO "city" VALUES ("109", "Majuro");
INSERT INTO "city" VALUES ("110", "Nouakchott");
INSERT INTO "city" VALUES ("111", "Port Louis");
INSERT INTO "city" VALUES ("112", "Mexico City");
INSERT INTO "city" VALUES ("113", "Chisinau");
INSERT INTO "city" VALUES ("114", "Monaco");
INSERT INTO "city" VALUES ("115", "Ulaanbaatar");
INSERT INTO "city" VALUES ("116", "Podgorica");
INSERT INTO "city" VALUES ("117", "Rabat");
INSERT INTO "city" VALUES ("118", "Maputo");
INSERT INTO "city" VALUES ("119", "Naypyidaw");
INSERT INTO "city" VALUES ("120", "Windhoek");
INSERT INTO "city" VALUES ("121", "Yaren");
INSERT INTO "city" VALUES ("122", "Kathmandu");
INSERT INTO "city" VALUES ("123", "Amsterdam");
INSERT INTO "city" VALUES ("124", "Wellington");
INSERT INTO "city" VALUES ("125", "Managua");
INSERT INTO "city" VALUES ("126", "Niamey");
INSERT INTO "city" VALUES ("127", "Abuja");
INSERT INTO "city" VALUES ("128", "Oslo");
INSERT INTO "city" VALUES ("129", "Muscat");
INSERT INTO "city" VALUES ("130", "Islamabad");
INSERT INTO "city" VALUES ("131", "Melekeok");
INSERT INTO "city" VALUES ("132", "Panama City");
INSERT INTO "city" VALUES ("133", "Port Moresby");
INSERT INTO "city" VALUES ("134", "Asunción");
INSERT INTO "city" VALUES ("135", "Lima");
INSERT INTO "city" VALUES ("136", "Manila");
INSERT INTO "city" VALUES ("137", "Warsaw");
INSERT INTO "city" VALUES ("138", "Lisbon");
INSERT INTO "city" VALUES ("139", "Doha");
INSERT INTO "city" VALUES ("140", "Bucharest");
INSERT INTO "city" VALUES ("141", "Moscow");
INSERT INTO "city" VALUES ("142", "Kigali");
INSERT INTO "city" VALUES ("143", "Basseterre");
INSERT INTO "city" VALUES ("144", "Castries");
INSERT INTO "city" VALUES ("145", "Kingstown");
INSERT INTO "city" VALUES ("146", "Apia");
INSERT INTO "city" VALUES ("147", "San Marino");
INSERT INTO "city" VALUES ("148", "São Tomé");
INSERT INTO "city" VALUES ("149", "Riyadh");
INSERT INTO "city" VALUES ("150", "Dakar");
INSERT INTO "city" VALUES ("151", "Belgrade");
INSERT INTO "city" VALUES ("152", "Victoria");
INSERT INTO "city" VALUES ("153", "Freetown");
INSERT INTO "city" VALUES ("154", "Singapore");
INSERT INTO "city" VALUES ("155", "Bratislava");
INSERT INTO "city" VALUES ("156", "Ljubljana");
INSERT INTO "city" VALUES ("157", "Honiara");
INSERT INTO "city" VALUES ("158", "Mogadishu");
INSERT INTO "city" VALUES ("159", "Pretoria");
INSERT INTO "city" VALUES ("160", "Juba");
INSERT INTO "city" VALUES ("161", "Madrid");
INSERT INTO "city" VALUES ("162", "Colombo");
INSERT INTO "city" VALUES ("163", "Khartoum");
INSERT INTO "city" VALUES ("164", "Paramaribo");
INSERT INTO "city" VALUES ("165", "Stockholm");
INSERT INTO "city" VALUES ("166", "Bern");
INSERT INTO "city" VALUES ("167", "Damascus");
INSERT INTO "city" VALUES ("168", "Taipei");
INSERT INTO "city" VALUES ("169", "Dushanbe");
INSERT INTO "city" VALUES ("170", "Dodoma");
INSERT INTO "city" VALUES ("171", "Bangkok");
INSERT INTO "city" VALUES ("172", "Dili");
INSERT INTO "city" VALUES ("173", "Lomé");
INSERT INTO "city" VALUES ("174", "Nukuʻalofa");
INSERT INTO "city" VALUES ("175", "Port of Spain");
INSERT INTO "city" VALUES ("176", "Tunis");
INSERT INTO "city" VALUES ("177", "Ankara");
INSERT INTO "city" VALUES ("178", "Ashgabat");
INSERT INTO "city" VALUES ("179", "Funafuti");
INSERT INTO "city" VALUES ("180", "Kampala");
INSERT INTO "city" VALUES ("181", "Kyiv");
INSERT INTO "city" VALUES ("182", "Abu Dhabi");
INSERT INTO "city" VALUES ("183", "London");
INSERT INTO "city" VALUES ("184", "Washington, D.C.");
INSERT INTO "city" VALUES ("185", "Montevideo");
INSERT INTO "city" VALUES ("186", "Tashkent");
INSERT INTO "city" VALUES ("187", "Port Vila");
INSERT INTO "city" VALUES ("188", "Caracas");
INSERT INTO "city" VALUES ("189", "Hanoi");
INSERT INTO "city" VALUES ("190", "Sana'a");
INSERT INTO "city" VALUES ("191", "Lusaka");
INSERT INTO "city" VALUES ("192", "Harare");
INSERT INTO "city" VALUES ("193", "Vatican City");
INSERT INTO "city" VALUES ("194", "Palau");
INSERT INTO "city" VALUES ("195", "Ngerulmud");
INSERT INTO "city" VALUES ("196", "Kingston");
INSERT INTO "city" VALUES ("197", "Road Town");
INSERT INTO "city" VALUES ("198", "George Town");
INSERT INTO "city" VALUES ("199", "Hamilton");
INSERT INTO "city" VALUES ("200", "Stanley");
INSERT INTO "city" VALUES ("201", "Gibraltar");
INSERT INTO "city" VALUES ("202", "Saint Helier");
INSERT INTO "city" VALUES ("203", "Douglas");
INSERT INTO "city" VALUES ("204", "Plymouth");
INSERT INTO "city" VALUES ("205", "Oranjestad");
INSERT INTO "city" VALUES ("206", "Willemstad");
INSERT INTO "city" VALUES ("207", "Philipsburg");
INSERT INTO "city" VALUES ("208", "Nuuk");
INSERT INTO "city" VALUES ("209", "Longyearbyen");
INSERT INTO "city" VALUES ("210", "Saint-Pierre");
INSERT INTO "city" VALUES ("211", "Cayenne");
INSERT INTO "city" VALUES ("212", "Papeete");
INSERT INTO "city" VALUES ("213", "Mata-Utu");
INSERT INTO "city" VALUES ("214", "Nouméa");
INSERT INTO "city" VALUES ("215", "Alofi");
INSERT INTO "city" VALUES ("216", "Avarua");
INSERT INTO "city" VALUES ("217", "Pago Pago");
INSERT INTO "city" VALUES ("218", "Hagåtña");
INSERT INTO "city" VALUES ("219", "Saipan");
INSERT INTO "city" VALUES ("220", "San Juan");
INSERT INTO "city" VALUES ("221", "Charlotte Amalie");
INSERT INTO "city" VALUES ("222", "Hong Kong");
INSERT INTO "city" VALUES ("223", "Macau");
INSERT INTO "city" VALUES ("224", "Taipei");
INSERT INTO "city" VALUES ("225", "Ramallah");
INSERT INTO "city" VALUES ("226", "Papeete");
INSERT INTO "city" VALUES ("227", "Saint-Denis");
INSERT INTO "city" VALUES ("228", "Mamoudzou");
INSERT INTO "city" VALUES ("229", "Jamestown");
INSERT INTO "city" VALUES ("230", "Flying Fish Cove");
INSERT INTO "city" VALUES ("231", "West Island");
INSERT INTO "city" VALUES ("232", "King Edward Point");
INSERT INTO "city" VALUES ("233", "Adamstown");
INSERT INTO "city" VALUES ("234", "The Valley");
INSERT INTO "city" VALUES ("235", "Saint John's");
INSERT INTO "city" VALUES ("236", "Gustavia");
INSERT INTO "city" VALUES ("237", "The Bottom");
INSERT INTO "city" VALUES ("238", "Brades");
INSERT INTO "city" VALUES ("239", "Cockburn Town");
INSERT INTO "city" VALUES ("240", "Road Town");
INSERT INTO "city" VALUES ("241", "George Town");
INSERT INTO "city" VALUES ("242", "Hamilton");
INSERT INTO "city" VALUES ("243", "Stanley");
INSERT INTO "city" VALUES ("244", "Gibraltar");
INSERT INTO "city" VALUES ("245", "Saint Helier");
INSERT INTO "city" VALUES ("246", "Douglas");
INSERT INTO "city" VALUES ("247", "Plymouth");
INSERT INTO "city" VALUES ("248", "Oranjestad");
INSERT INTO "city" VALUES ("249", "Willemstad");
INSERT INTO "city" VALUES ("250", "Philipsburg");
INSERT INTO "city" VALUES ("251", "Nuuk");
INSERT INTO "city" VALUES ("252", "Longyearbyen");
INSERT INTO "city" VALUES ("253", "Saint-Pierre");
INSERT INTO "city" VALUES ("254", "Cayenne");
INSERT INTO "city" VALUES ("255", "Papeete");
INSERT INTO "city" VALUES ("256", "Mata-Utu");
INSERT INTO "city" VALUES ("257", "Nouméa");
INSERT INTO "city" VALUES ("258", "Alofi");
INSERT INTO "city" VALUES ("259", "Avarua");
INSERT INTO "city" VALUES ("260", "Pago Pago");
INSERT INTO "city" VALUES ("261", "Hagåtña");
INSERT INTO "city" VALUES ("262", "Saipan");
INSERT INTO "city" VALUES ("263", "San Juan");
INSERT INTO "city" VALUES ("264", "Charlotte Amalie");
INSERT INTO "city" VALUES ("265", "Hong Kong");
INSERT INTO "city" VALUES ("266", "Macau");
INSERT INTO "city" VALUES ("267", "Taipei");
INSERT INTO "city" VALUES ("268", "Ramallah");
INSERT INTO "city" VALUES ("269", "Papeete");
INSERT INTO "city" VALUES ("270", "Saint-Denis");
INSERT INTO "city" VALUES ("271", "Mamoudzou");
INSERT INTO "city" VALUES ("272", "Jamestown");
INSERT INTO "city" VALUES ("273", "Flying Fish Cove");
INSERT INTO "city" VALUES ("274", "West Island");
INSERT INTO "city" VALUES ("275", "King Edward Point");
INSERT INTO "city" VALUES ("276", "Adamstown");
INSERT INTO "city" VALUES ("277", "The Valley");
INSERT INTO "city" VALUES ("278", "Saint John's");
INSERT INTO "city" VALUES ("279", "Gustavia");
INSERT INTO "city" VALUES ("280", "The Bottom");
INSERT INTO "city" VALUES ("281", "Brades");
INSERT INTO "city" VALUES ("282", "Cockburn Town");
INSERT INTO "city" VALUES ("283", "Road Town");
INSERT INTO "city" VALUES ("284", "George Town");
INSERT INTO "city" VALUES ("285", "Hamilton");
INSERT INTO "city" VALUES ("286", "Stanley");
INSERT INTO "city" VALUES ("287", "Gibraltar");
INSERT INTO "city" VALUES ("288", "Saint Helier");
INSERT INTO "city" VALUES ("289", "Douglas");
INSERT INTO "city" VALUES ("290", "Plymouth");
INSERT INTO "city" VALUES ("291", "Oranjestad");
INSERT INTO "city" VALUES ("292", "Willemstad");
INSERT INTO "city" VALUES ("293", "Philipsburg");
INSERT INTO "city" VALUES ("294", "Nuuk");
INSERT INTO "city" VALUES ("295", "Longyearbyen");
INSERT INTO "city" VALUES ("296", "Saint-Pierre");
INSERT INTO "city" VALUES ("297", "Cayenne");
INSERT INTO "city" VALUES ("298", "Papeete");
INSERT INTO "city" VALUES ("299", "Mata-Utu");
INSERT INTO "city" VALUES ("300", "Nouméa");
INSERT INTO "city" VALUES ("301", "Alofi");
INSERT INTO "city" VALUES ("302", "Avarua");
INSERT INTO "city" VALUES ("303", "Pago Pago");
INSERT INTO "city" VALUES ("304", "Hagåtña");
INSERT INTO "city" VALUES ("305", "Saipan");
INSERT INTO "city" VALUES ("306", "San Juan");
INSERT INTO "city" VALUES ("307", "Charlotte Amalie");
INSERT INTO "city" VALUES ("308", "Hong Kong");
INSERT INTO "city" VALUES ("309", "Macau");
INSERT INTO "city" VALUES ("310", "Taipei");
INSERT INTO "city" VALUES ("311", "Ramallah");
INSERT INTO "city" VALUES ("312", "Papeete");
INSERT INTO "city" VALUES ("313", "Saint-Denis");
INSERT INTO "city" VALUES ("314", "Mamoudzou");
INSERT INTO "city" VALUES ("315", "Jamestown");
INSERT INTO "city" VALUES ("316", "Flying Fish Cove");
INSERT INTO "city" VALUES ("317", "West Island");
INSERT INTO "city" VALUES ("318", "King Edward Point");
INSERT INTO "city" VALUES ("319", "Adamstown");
INSERT INTO "city" VALUES ("320", "The Valley");
INSERT INTO "city" VALUES ("321", "Saint John's");
INSERT INTO "city" VALUES ("322", "Gustavia");
INSERT INTO "city" VALUES ("323", "The Bottom");
INSERT INTO "city" VALUES ("324", "Brades");
INSERT INTO "city" VALUES ("325", "Cockburn Town");
INSERT INTO "city" VALUES ("326", "Road Town");
INSERT INTO "city" VALUES ("327", "George Town");
INSERT INTO "city" VALUES ("328", "Hamilton");
INSERT INTO "city" VALUES ("329", "Stanley");
INSERT INTO "city" VALUES ("330", "Gibraltar");
INSERT INTO "city" VALUES ("331", "Saint Helier");
INSERT INTO "city" VALUES ("332", "Douglas");
INSERT INTO "city" VALUES ("333", "Plymouth");
INSERT INTO "city" VALUES ("334", "Oranjestad");
INSERT INTO "city" VALUES ("335", "Willemstad");
INSERT INTO "city" VALUES ("336", "Philipsburg");
INSERT INTO "city" VALUES ("337", "Nuuk");
INSERT INTO "city" VALUES ("338", "Longyearbyen");
INSERT INTO "city" VALUES ("339", "Saint-Pierre");
INSERT INTO "city" VALUES ("340", "Cayenne");
INSERT INTO "city" VALUES ("341", "Papeete");
INSERT INTO "city" VALUES ("342", "Mata-Utu");
INSERT INTO "city" VALUES ("343", "Nouméa");
INSERT INTO "city" VALUES ("344", "Alofi");
INSERT INTO "city" VALUES ("345", "Avarua");
INSERT INTO "city" VALUES ("346", "Pago Pago");
INSERT INTO "city" VALUES ("347", "Hagåtña");
INSERT INTO "city" VALUES ("348", "Saipan");
INSERT INTO "city" VALUES ("349", "San Juan");
INSERT INTO "city" VALUES ("350", "Charlotte Amalie");
INSERT INTO "city" VALUES ("351", "Hong Kong");
INSERT INTO "city" VALUES ("352", "Macau");
INSERT INTO "city" VALUES ("353", "Taipei");
INSERT INTO "city" VALUES ("354", "Ramallah");
INSERT INTO "city" VALUES ("355", "Papeete");
INSERT INTO "city" VALUES ("356", "Saint-Denis");
INSERT INTO "city" VALUES ("357", "Mamoudzou");
INSERT INTO "city" VALUES ("358", "Jamestown");
INSERT INTO "city" VALUES ("359", "Flying Fish Cove");
INSERT INTO "city" VALUES ("360", "West Island");
INSERT INTO "city" VALUES ("361", "King Edward Point");
INSERT INTO "city" VALUES ("362", "Adamstown");
INSERT INTO "city" VALUES ("363", "The Valley");
INSERT INTO "city" VALUES ("364", "Saint John's");
INSERT INTO "city" VALUES ("365", "Gustavia");
INSERT INTO "city" VALUES ("366", "The Bottom");
INSERT INTO "city" VALUES ("367", "Brades");
INSERT INTO "city" VALUES ("368", "Cockburn Town");
INSERT INTO "city" VALUES ("369", "Road Town");
INSERT INTO "city" VALUES ("370", "George Town");
INSERT INTO "city" VALUES ("371", "Hamilton");
INSERT INTO "city" VALUES ("372", "Stanley");
INSERT INTO "city" VALUES ("373", "Gibraltar");
INSERT INTO "city" VALUES ("374", "Saint Helier");
INSERT INTO "city" VALUES ("375", "Douglas");
INSERT INTO "city" VALUES ("376", "Plymouth");
INSERT INTO "city" VALUES ("377", "Oranjestad");
INSERT INTO "city" VALUES ("378", "Willemstad");
INSERT INTO "city" VALUES ("379", "Philipsburg");
INSERT INTO "city" VALUES ("380", "Nuuk");
INSERT INTO "city" VALUES ("381", "Longyearbyen");
INSERT INTO "city" VALUES ("382", "Saint-Pierre");
INSERT INTO "city" VALUES ("383", "Cayenne");
INSERT INTO "city" VALUES ("384", "Papeete");
INSERT INTO "city" VALUES ("385", "Mata-Utu");
INSERT INTO "city" VALUES ("386", "Nouméa");
INSERT INTO "city" VALUES ("387", "Alofi");
INSERT INTO "city" VALUES ("388", "Avarua");
INSERT INTO "city" VALUES ("389", "Pago Pago");
INSERT INTO "city" VALUES ("390", "Hagåtña");
INSERT INTO "city" VALUES ("391", "Saipan");
INSERT INTO "city" VALUES ("392", "San Juan");
INSERT INTO "city" VALUES ("393", "Charlotte Amalie");
INSERT INTO "city" VALUES ("394", "Hong Kong");
INSERT INTO "city" VALUES ("395", "Macau");