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),
"CountryCode" CHAR(3),
PRIMARY KEY ("ID"),
FOREIGN KEY ("CountryCode") REFERENCES "country"("Code")
);

CREATE TABLE "country" (
"Code" CHAR(3) UNIQUE,
"Name" CHAR(52),
"Continent" TEXT,
"Population" INT,
PRIMARY KEY ("Code")
);

CREATE TABLE "countrylanguage" (
"CountryCode" CHAR(3),
"Language" CHAR(30),
PRIMARY KEY ("CountryCode", "Language")
);





INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Asia", "22720000");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Europe", "15988000");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Africa", "40377000");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Africa", "68470000");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Africa", "111506000");
INSERT INTO "country" VALUES ("CHN", "China", "Asia", "1277558000");
INSERT INTO "country" VALUES ("IND", "India", "Asia", "1013662000");
INSERT INTO "country" VALUES ("JPN", "Japan", "Asia", "126714000");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Asia", "46844000");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Asia", "212107000");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Asia", "156487000");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Asia", "129155000");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Asia", "79832000");
INSERT INTO "country" VALUES ("PHL", "Philippines", "Asia", "76987000");
INSERT INTO "country" VALUES ("IRN", "Iran", "Asia", "67467000");
INSERT INTO "country" VALUES ("THA", "Thailand", "Asia", "61399000");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "Asia", "45611000");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "24771000");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "Asia", "21607000");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "Asia", "22244000");
INSERT INTO "country" VALUES ("PRK", "North Korea", "Asia", "23348000");
INSERT INTO "country" VALUES ("SYR", "Syria", "Asia", "16125000");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "Asia", "18827000");
INSERT INTO "country" VALUES ("KAZ", "Kazakhstan", "Asia", "16223000");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Asia", "2441000");
INSERT INTO "country" VALUES ("ISR", "Israel", "Asia", "6217000");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "3567000");
INSERT INTO "country" VALUES ("JOR", "Jordan", "Asia", "5083000");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Asia", "7734000");
INSERT INTO "country" VALUES ("KWT", "Kuwait", "Asia", "1972000");
INSERT INTO "country" VALUES ("OMN", "Oman", "Asia", "2441000");
INSERT INTO "country" VALUES ("YEM", "Yemen", "Asia", "18112000");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Asia", "4934000");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Asia", "3520000");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Asia", "769000");
INSERT INTO "country" VALUES ("BHR", "Bahrain", "Asia", "617000");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "759000");
INSERT INTO "country" VALUES ("BTN", "Bhutan", "Asia", "2124000");
INSERT INTO "country" VALUES ("MDV", "Maldives", "Asia", "307000");
INSERT INTO "country" VALUES ("TLS", "East Timor", "Asia", "885000");
INSERT INTO "country" VALUES ("BRN", "Brunei", "Asia", "336000");
INSERT INTO "country" VALUES ("LAO", "Laos", "Asia", "5433000");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Asia", "2654000");
INSERT INTO "country" VALUES ("NPL", "Nepal", "Asia", "23940000");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Asia", "6188000");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Asia", "4518000");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "Asia", "4709000");
INSERT INTO "country" VALUES ("LBN", "Lebanon", "Asia", "3562000");
INSERT INTO "country" VALUES ("PSE", "Palestine", "Asia", "3101000");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Asia", "3567000");
INSERT INTO "country" VALUES ("TWN", "Taiwan", "Asia", "22280000");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Asia", "24771000");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Asia", "79832000");
INSERT INTO "country" VALUES ("YEM", "Yemen", "Asia", "18112000");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "Africa", "11669000");
INSERT INTO "country" VALUES ("DZA", "Algeria", "Africa", "31471000");
INSERT INTO "country" VALUES ("SDN", "Sudan", "Africa", "35079000");
INSERT INTO "country" VALUES ("MAR", "Morocco", "Africa", "28351000");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Africa", "62565000");
INSERT INTO "country" VALUES ("COD", "Congo, The Democratic Republic of the", "Africa", "50416000");
INSERT INTO "country" VALUES ("TZA", "Tanzania", "Africa", "33790000");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Africa", "30339000");
INSERT INTO "country" VALUES ("UGA", "Uganda", "Africa", "23317000");
INSERT INTO "country" VALUES ("GHA", "Ghana", "Africa", "19533000");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Africa", "19686000");
INSERT INTO "country" VALUES ("MDG", "Madagascar", "Africa", "15942000");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "Africa", "15085000");
INSERT INTO "country" VALUES ("CIV", "Cote dIvoire", "Africa", "14786000");
INSERT INTO "country" VALUES ("AGO", "Angola", "Africa", "12878000");
INSERT INTO "country" VALUES ("NER", "Niger", "Africa", "10146000");
INSERT INTO "country" VALUES ("BFA", "Burkina Faso", "Africa", "11937000");
INSERT INTO "country" VALUES ("MLI", "Mali", "Africa", "11241000");
INSERT INTO "country" VALUES ("MWI", "Malawi", "Africa", "10470000");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "Africa", "9169000");
INSERT INTO "country" VALUES ("SEN", "Senegal", "Africa", "9481000");
INSERT INTO "country" VALUES ("SOM", "Somalia", "Africa", "10090000");
INSERT INTO "country" VALUES ("TCD", "Chad", "Africa", "7615000");
INSERT INTO "country" VALUES ("RWA", "Rwanda", "Africa", "7733000");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "Africa", "9524000");
INSERT INTO "country" VALUES ("GIN", "Guinea", "Africa", "7495000");
INSERT INTO "country" VALUES ("BEN", "Benin", "Africa", "6095000");
INSERT INTO "country" VALUES ("BDI", "Burundi", "Africa", "6695000");
INSERT INTO "country" VALUES ("LBY", "Libya", "Africa", "5670000");
INSERT INTO "country" VALUES ("SLE", "Sierra Leone", "Africa", "4843000");
INSERT INTO "country" VALUES ("TGO", "Togo", "Africa", "4625000");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "Africa", "3850000");
INSERT INTO "country" VALUES ("CAF", "Central African Republic", "Africa", "3701000");
INSERT INTO "country" VALUES ("LBR", "Liberia", "Africa", "3154000");
INSERT INTO "country" VALUES ("MRT", "Mauritania", "Africa", "2670000");
INSERT INTO "country" VALUES ("COG", "Congo", "Africa", "2943000");
INSERT INTO "country" VALUES ("NAM", "Namibia", "Africa", "1726000");
INSERT INTO "country" VALUES ("GAB", "Gabon", "Africa", "1226000");
INSERT INTO "country" VALUES ("GMB", "Gambia", "Africa", "1337000");
INSERT INTO "country" VALUES ("BWA", "Botswana", "Africa", "1622000");
INSERT INTO "country" VALUES ("LSO", "Lesotho", "Africa", "2153000");
INSERT INTO "country" VALUES ("GNB", "Guinea-Bissau", "Africa", "1213000");
INSERT INTO "country" VALUES ("SWZ", "Swaziland", "Africa", "1083000");
INSERT INTO "country" VALUES ("DJI", "Djibouti", "Africa", "691000");
INSERT INTO "country" VALUES ("COM", "Comoros", "Africa", "578000");
INSERT INTO "country" VALUES ("CPV", "Cape Verde", "Africa", "435000");
INSERT INTO "country" VALUES ("STP", "Sao Tome and Principe", "Africa", "147000");
INSERT INTO "country" VALUES ("SYC", "Seychelles", "Africa", "77000");
INSERT INTO "country" VALUES ("ESH", "Western Sahara", "Africa", "213000");
INSERT INTO "country" VALUES ("REU", "Reunion", "Africa", "720000");
INSERT INTO "country" VALUES ("MYT", "Mayotte", "Africa", "163000");
INSERT INTO "country" VALUES ("SJM", "Svalbard and Jan Mayen", "Europe", "2000");
INSERT INTO "country" VALUES ("GRL", "Greenland", "North America", "56000");
INSERT INTO "country" VALUES ("FRO", "Faroe Islands", "Europe", "43000");
INSERT INTO "country" VALUES ("GIB", "Gibraltar", "Europe", "25000");
INSERT INTO "country" VALUES ("AND", "Andorra", "Europe", "78000");
INSERT INTO "country" VALUES ("SMR", "San Marino", "Europe", "27000");
INSERT INTO "country" VALUES ("VAT", "Holy See Vatican City State", "Europe", "1000");
INSERT INTO "country" VALUES ("MCO", "Monaco", "Europe", "34000");
INSERT INTO "country" VALUES ("LIE", "Liechtenstein", "Europe", "32000");
INSERT INTO "country" VALUES ("MLT", "Malta", "Europe", "397000");
INSERT INTO "country" VALUES ("LUX", "Luxembourg", "Europe", "435000");
INSERT INTO "country" VALUES ("ISL", "Iceland", "Europe", "279000");
INSERT INTO "country" VALUES ("CYP", "Cyprus", "Asia", "759000");
INSERT INTO "country" VALUES ("FJI", "Fiji Islands", "Oceania", "817000");
INSERT INTO "country" VALUES ("PNG", "Papua New Guinea", "Oceania", "4807000");
INSERT INTO "country" VALUES ("NZL", "New Zealand", "Oceania", "3864000");
INSERT INTO "country" VALUES ("AUS", "Australia", "Oceania", "18886000");
INSERT INTO "country" VALUES ("KIR", "Kiribati", "Oceania", "83000");
INSERT INTO "country" VALUES ("MHL", "Marshall Islands", "Oceania", "64000");
INSERT INTO "country" VALUES ("FSM", "Micronesia, Federated States of", "Oceania", "119000");
INSERT INTO "country" VALUES ("NRU", "Nauru", "Oceania", "10000");
INSERT INTO "country" VALUES ("PLW", "Palau", "Oceania", "19000");
INSERT INTO "country" VALUES ("WSM", "Samoa", "Oceania", "180000");
INSERT INTO "country" VALUES ("SLB", "Solomon Islands", "Oceania", "442000");
INSERT INTO "country" VALUES ("TON", "Tonga", "Oceania", "99000");
INSERT INTO "country" VALUES ("TUV", "Tuvalu", "Oceania", "11000");
INSERT INTO "country" VALUES ("VUT", "Vanuatu", "Oceania", "190000");
INSERT INTO "country" VALUES ("NIU", "Niue", "Oceania", "2000");
INSERT INTO "country" VALUES ("NFK", "Norfolk Island", "Oceania", "2000");
INSERT INTO "country" VALUES ("PCN", "Pitcairn", "Oceania", "50");
INSERT INTO "country" VALUES ("TKL", "Tokelau", "Oceania", "2000");
INSERT INTO "country" VALUES ("WLF", "Wallis and Futuna", "Oceania", "15000");
INSERT INTO "country" VALUES ("ASM", "American Samoa", "Oceania", "68000");
INSERT INTO "country" VALUES ("COK", "Cook Islands", "Oceania", "20000");
INSERT INTO "country" VALUES ("GUM", "Guam", "Oceania", "168000");
INSERT INTO "country" VALUES ("MNP", "Northern Mariana Islands", "Oceania", "78000");
INSERT INTO "country" VALUES ("PYF", "French Polynesia", "Oceania", "235000");
INSERT INTO "country" VALUES ("NCL", "New Caledonia", "Oceania", "210000");
INSERT INTO "country" VALUES ("FLK", "Falkland Islands Malvinas", "South America", "2000");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");
INSERT INTO "country" VALUES ("CCK", "Cocos Keeling Islands", "Oceania", "600");
INSERT INTO "country" VALUES ("CXR", "Christmas Island", "Oceania", "2500");
INSERT INTO "country" VALUES ("HMD", "Heard Island and McDonald Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("SGS", "South Georgia and the South Sandwich Islands", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATA", "Antarctica", "Antarctica", "0");
INSERT INTO "country" VALUES ("BVT", "Bouvet Island", "Antarctica", "0");
INSERT INTO "country" VALUES ("ATF", "French Southern Territories", "Antarctica", "0");
INSERT INTO "country" VALUES ("IOT", "British Indian Ocean Territory", "Africa", "0");