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 "country" (
"Code" CHAR(3),
"Continent" TEXT,
"Region" CHAR(26),
"LocalName" CHAR(45),
"GovernmentForm" CHAR(45),
"HeadOfState" CHAR(60),
PRIMARY KEY ("Code")
);





INSERT INTO "country" VALUES ("AFG", "Asia", "Southern Asia", "Afganistan", "Islamic Emirate", "Mohammad Omar");
INSERT INTO "country" VALUES ("NGA", "Africa", "Western Africa", "Nigeria", "Federal Republic", "Muhammadu Buhari");
INSERT INTO "country" VALUES ("EGY", "Africa", "Northern Africa", "Egypt", "Republic", "Abdel Fattah el-Sisi");
INSERT INTO "country" VALUES ("ZAF", "Africa", "Southern Africa", "South Africa", "Republic", "Cyril Ramaphosa");
INSERT INTO "country" VALUES ("KEN", "Africa", "Eastern Africa", "Kenya", "Republic", "Uhuru Kenyatta");
INSERT INTO "country" VALUES ("DZA", "Africa", "Northern Africa", "Algeria", "Republic", "Abdelmadjid Tebboune");
INSERT INTO "country" VALUES ("MAR", "Africa", "Northern Africa", "Morocco", "Constitutional Monarchy", "Mohammed VI");
INSERT INTO "country" VALUES ("ETH", "Africa", "Eastern Africa", "Ethiopia", "Federal Democratic Republic", "Sahle-Work Zewde");
INSERT INTO "country" VALUES ("GHA", "Africa", "Western Africa", "Ghana", "Republic", "Nana Akufo-Addo");
INSERT INTO "country" VALUES ("CIV", "Africa", "Western Africa", "Cote dIvoire", "Republic", "Alassane Ouattara");
INSERT INTO "country" VALUES ("SDN", "Africa", "Northern Africa", "Sudan", "Federal Republic", "Abdalla Hamdok");
INSERT INTO "country" VALUES ("UGA", "Africa", "Eastern Africa", "Uganda", "Republic", "Yoweri Museveni");
INSERT INTO "country" VALUES ("TZA", "Africa", "Eastern Africa", "Tanzania", "Republic", "Samia Suluhu Hassan");
INSERT INTO "country" VALUES ("MOZ", "Africa", "Eastern Africa", "Mozambique", "Republic", "Filipe Nyusi");
INSERT INTO "country" VALUES ("CMR", "Africa", "Central Africa", "Cameroon", "Republic", "Paul Biya");
INSERT INTO "country" VALUES ("MDG", "Africa", "Eastern Africa", "Madagascar", "Republic", "Andry Rajoelina");
INSERT INTO "country" VALUES ("AGO", "Africa", "Central Africa", "Angola", "Republic", "João Lourenço");
INSERT INTO "country" VALUES ("ZMB", "Africa", "Eastern Africa", "Zambia", "Republic", "Hakainde Hichilema");
INSERT INTO "country" VALUES ("ZWE", "Africa", "Eastern Africa", "Zimbabwe", "Republic", "Emmerson Mnangagwa");
INSERT INTO "country" VALUES ("TUN", "Africa", "Northern Africa", "Tunisia", "Republic", "Kais Saied");
INSERT INTO "country" VALUES ("LBY", "Africa", "Northern Africa", "Libya", "Transitional Government", "Mohamed al-Menfi");
INSERT INTO "country" VALUES ("SOM", "Africa", "Eastern Africa", "Somalia", "Federal Republic", "Mohamed Abdullahi Mohamed");
INSERT INTO "country" VALUES ("RWA", "Africa", "Eastern Africa", "Rwanda", "Republic", "Paul Kagame");
INSERT INTO "country" VALUES ("BDI", "Africa", "Eastern Africa", "Burundi", "Republic", "Évariste Ndayishimiye");
INSERT INTO "country" VALUES ("BEN", "Africa", "Western Africa", "Benin", "Republic", "Patrice Talon");
INSERT INTO "country" VALUES ("BFA", "Africa", "Western Africa", "Burkina Faso", "Republic", "Roch Marc Christian Kaboré");
INSERT INTO "country" VALUES ("NER", "Africa", "Western Africa", "Niger", "Republic", "Mohamed Bazoum");
INSERT INTO "country" VALUES ("MLI", "Africa", "Western Africa", "Mali", "Transitional Government", "Assimi Goïta");
INSERT INTO "country" VALUES ("SEN", "Africa", "Western Africa", "Senegal", "Republic", "Macky Sall");
INSERT INTO "country" VALUES ("GIN", "Africa", "Western Africa", "Guinea", "Republic", "Mamady Doumbouya");
INSERT INTO "country" VALUES ("SLE", "Africa", "Western Africa", "Sierra Leone", "Republic", "Julius Maada Bio");
INSERT INTO "country" VALUES ("LBR", "Africa", "Western Africa", "Liberia", "Republic", "George Weah");
INSERT INTO "country" VALUES ("TGO", "Africa", "Western Africa", "Togo", "Republic", "Faure Gnassingbé");
INSERT INTO "country" VALUES ("ERI", "Africa", "Eastern Africa", "Eritrea", "Peoples Republic", "Isaias Afwerki");
INSERT INTO "country" VALUES ("DJI", "Africa", "Eastern Africa", "Djibouti", "Republic", "Ismaïl Omar Guelleh");
INSERT INTO "country" VALUES ("CPV", "Africa", "Western Africa", "Cape Verde", "Republic", "José Maria Neves");
INSERT INTO "country" VALUES ("GMB", "Africa", "Western Africa", "Gambia", "Republic", "Adama Barrow");
INSERT INTO "country" VALUES ("GNB", "Africa", "Western Africa", "Guinea-Bissau", "Republic", "Umaro Sissoco Embaló");
INSERT INTO "country" VALUES ("MRT", "Africa", "Western Africa", "Mauritania", "Republic", "Mohamed Ould Ghazouani");
INSERT INTO "country" VALUES ("COM", "Africa", "Eastern Africa", "Comoros", "Federal Republic", "Azali Assoumani");
INSERT INTO "country" VALUES ("MUS", "Africa", "Eastern Africa", "Mauritius", "Republic", "Prithvirajsing Roopun");
INSERT INTO "country" VALUES ("SYC", "Africa", "Eastern Africa", "Seychelles", "Republic", "Wavel Ramkalawan");
INSERT INTO "country" VALUES ("STP", "Africa", "Central Africa", "Sao Tome and Principe", "Republic", "Carlos Vila Nova");
INSERT INTO "country" VALUES ("GNQ", "Africa", "Central Africa", "Equatorial Guinea", "Republic", "Teodoro Obiang Nguema Mbasogo");
INSERT INTO "country" VALUES ("CAF", "Africa", "Central Africa", "Central African Republic", "Republic", "Faustin-Archange Touadéra");
INSERT INTO "country" VALUES ("COG", "Africa", "Central Africa", "Congo", "Republic", "Denis Sassou Nguesso");
INSERT INTO "country" VALUES ("COD", "Africa", "Central Africa", "DR Congo", "Republic", "Félix Tshisekedi");
INSERT INTO "country" VALUES ("GAB", "Africa", "Central Africa", "Gabon", "Republic", "Ali Bongo Ondimba");
INSERT INTO "country" VALUES ("BWA", "Africa", "Southern Africa", "Botswana", "Republic", "Mokgweetsi Masisi");
INSERT INTO "country" VALUES ("LSO", "Africa", "Southern Africa", "Lesotho", "Constitutional Monarchy", "Letsie III");
INSERT INTO "country" VALUES ("NAM", "Africa", "Southern Africa", "Namibia", "Republic", "Hage Geingob");
INSERT INTO "country" VALUES ("SWZ", "Africa", "Southern Africa", "Eswatini", "Absolute Monarchy", "Mswati III");
INSERT INTO "country" VALUES ("MWI", "Africa", "Eastern Africa", "Malawi", "Republic", "Lazarus Chakwera");
INSERT INTO "country" VALUES ("SSD", "Africa", "Eastern Africa", "South Sudan", "Republic", "Salva Kiir Mayardit");
INSERT INTO "country" VALUES ("ESH", "Africa", "Northern Africa", "Western Sahara", "Disputed Territory", "");
INSERT INTO "country" VALUES ("REU", "Africa", "Eastern Africa", "Reunion", "Overseas Department of France", "Emmanuel Macron");
INSERT INTO "country" VALUES ("MYT", "Africa", "Eastern Africa", "Mayotte", "Overseas Department of France", "Emmanuel Macron");
INSERT INTO "country" VALUES ("SHN", "Africa", "Western Africa", "Saint Helena", "Overseas Territory of UK", "Elizabeth II");
INSERT INTO "country" VALUES ("CPV", "Africa", "Western Africa", "Cape Verde", "Republic", "José Maria Neves");
INSERT INTO "country" VALUES ("BFA", "Africa", "Western Africa", "Burkina Faso", "Republic", "Roch Marc Christian Kaboré");
INSERT INTO "country" VALUES ("MLI", "Africa", "Western Africa", "Mali", "Transitional Government", "Assimi Goïta");
INSERT INTO "country" VALUES ("NER", "Africa", "Western Africa", "Niger", "Republic", "Mohamed Bazoum");
INSERT INTO "country" VALUES ("TGO", "Africa", "Western Africa", "Togo", "Republic", "Faure Gnassingbé");
INSERT INTO "country" VALUES ("BEN", "Africa", "Western Africa", "Benin", "Republic", "Patrice Talon");
INSERT INTO "country" VALUES ("GHA", "Africa", "Western Africa", "Ghana", "Republic", "Nana Akufo-Addo");
INSERT INTO "country" VALUES ("CIV", "Africa", "Western Africa", "Cote dIvoire", "Republic", "Alassane Ouattara");
INSERT INTO "country" VALUES ("GIN", "Africa", "Western Africa", "Guinea", "Republic", "Mamady Doumbouya");
INSERT INTO "country" VALUES ("GNB", "Africa", "Western Africa", "Guinea-Bissau", "Republic", "Umaro Sissoco Embaló");
INSERT INTO "country" VALUES ("SEN", "Africa", "Western Africa", "Senegal", "Republic", "Macky Sall");
INSERT INTO "country" VALUES ("GMB", "Africa", "Western Africa", "Gambia", "Republic", "Adama Barrow");
INSERT INTO "country" VALUES ("MRT", "Africa", "Western Africa", "Mauritania", "Republic", "Mohamed Ould Ghazouani");
INSERT INTO "country" VALUES ("LBR", "Africa", "Western Africa", "Liberia", "Republic", "George Weah");
INSERT INTO "country" VALUES ("SLE", "Africa", "Western Africa", "Sierra Leone", "Republic", "Julius Maada Bio");
INSERT INTO "country" VALUES ("CMR", "Africa", "Central Africa", "Cameroon", "Republic", "Paul Biya");
INSERT INTO "country" VALUES ("CAF", "Africa", "Central Africa", "Central African Republic", "Republic", "Faustin-Archange Touadéra");
INSERT INTO "country" VALUES ("TCD", "Africa", "Central Africa", "Chad", "Transitional Military Council", "Mahamat Déby");
INSERT INTO "country" VALUES ("COD", "Africa", "Central Africa", "DR Congo", "Republic", "Félix Tshisekedi");
INSERT INTO "country" VALUES ("COG", "Africa", "Central Africa", "Congo", "Republic", "Denis Sassou Nguesso");
INSERT INTO "country" VALUES ("GNQ", "Africa", "Central Africa", "Equatorial Guinea", "Republic", "Teodoro Obiang Nguema Mbasogo");
INSERT INTO "country" VALUES ("GAB", "Africa", "Central Africa", "Gabon", "Republic", "Ali Bongo Ondimba");
INSERT INTO "country" VALUES ("STP", "Africa", "Central Africa", "Sao Tome and Principe", "Republic", "Carlos Vila Nova");
INSERT INTO "country" VALUES ("BWA", "Africa", "Southern Africa", "Botswana", "Republic", "Mokgweetsi Masisi");
INSERT INTO "country" VALUES ("LSO", "Africa", "Southern Africa", "Lesotho", "Constitutional Monarchy", "Letsie III");
INSERT INTO "country" VALUES ("NAM", "Africa", "Southern Africa", "Namibia", "Republic", "Hage Geingeb");
INSERT INTO "country" VALUES ("ZAF", "Africa", "Southern Africa", "South Africa", "Republic", "Cyril Ramaphosa");
INSERT INTO "country" VALUES ("SWZ", "Africa", "Southern Africa", "Eswatini", "Absolute Monarchy", "Mswati III");
INSERT INTO "country" VALUES ("AGO", "Africa", "Central Africa", "Angola", "Republic", "João Lourenço");
INSERT INTO "country" VALUES ("ZMB", "Africa", "Eastern Africa", "Zambia", "Republic", "Hakainde Hichilema");
INSERT INTO "country" VALUES ("ZWE", "Africa", "Eastern Africa", "Zimbabwe", "Republic", "Emmerson Mnangagwa");
INSERT INTO "country" VALUES ("MWI", "Africa", "Eastern Africa", "Malawi", "Republic", "Lazarus Chakwera");
INSERT INTO "country" VALUES ("MOZ", "Africa", "Eastern Africa", "Mozambique", "Republic", "Filipe Nyusi");
INSERT INTO "country" VALUES ("MDG", "Africa", "Eastern Africa", "Madagascar", "Republic", "Andry Rajoelina");
INSERT INTO "country" VALUES ("COM", "Africa", "Eastern Africa", "Comoros", "Federal Republic", "Azali Assoumani");
INSERT INTO "country" VALUES ("MUS", "Africa", "Eastern Africa", "Mauritius", "Republic", "Prithvirajsing Roopun");
INSERT INTO "country" VALUES ("SYC", "Africa", "Eastern Africa", "Seychelles", "Republic", "Wavel Ramkalawan");
INSERT INTO "country" VALUES ("ERI", "Africa", "Eastern Africa", "Eritrea", "Peoples Republic", "Isaias Afwerki");
INSERT INTO "country" VALUES ("DJI", "Africa", "Eastern Africa", "Djibouti", "Republic", "Ismaïl Omar Guelleh");
INSERT INTO "country" VALUES ("ETH", "Africa", "Eastern Africa", "Ethiopia", "Federal Democratic Republic", "Sahle-Work Zewde");
INSERT INTO "country" VALUES ("KEN", "Africa", "Eastern Africa", "Kenya", "Republic", "Uhuru Kenyatta");
INSERT INTO "country" VALUES ("RWA", "Africa", "Eastern Africa", "Rwanda", "Republic", "Paul Kagame");
INSERT INTO "country" VALUES ("BDI", "Africa", "Eastern Africa", "Burundi", "Republic", "Évariste Ndayishimiye");
INSERT INTO "country" VALUES ("SSD", "Africa", "Eastern Africa", "South Sudan", "Republic", "Salva Kiir Mayardit");
INSERT INTO "country" VALUES ("SDN", "Africa", "Northern Africa", "Sudan", "Federal Republic", "Abdalla Hamdok");
INSERT INTO "country" VALUES ("EGY", "Africa", "Northern Africa", "Egypt", "Republic", "Abdel Fattah el-Sisi");
INSERT INTO "country" VALUES ("LBY", "Africa", "Northern Africa", "Libya", "Transitional Government", "Mohamed al-Menfi");
INSERT INTO "country" VALUES ("TUN", "Africa", "Northern Africa", "Tunisia", "Republic", "Kais Saied");
INSERT INTO "country" VALUES ("DZA", "Africa", "Northern Africa", "Algeria", "Republic", "Abdelmadjid Tebboune");
INSERT INTO "country" VALUES ("MAR", "Africa", "Northern Africa", "Morocco", "Constitutional Monarchy", "Mohammed VI");
INSERT INTO "country" VALUES ("SOM", "Africa", "Eastern Africa", "Somalia", "Federal Republic", "Mohamed Abdullahi Mohamed");
INSERT INTO "country" VALUES ("UGA", "Africa", "Eastern Africa", "Uganda", "Republic", "Yoweri Museveni");
INSERT INTO "country" VALUES ("TZA", "Africa", "Eastern Africa", "Tanzania", "Republic", "Samia Suluhu Hassan");