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),
"Name" CHAR(52),
"GovernmentForm" CHAR(45),
"HeadOfState" CHAR(60),
"Capital" INT,
PRIMARY KEY ("Code")
);

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





INSERT INTO "country" VALUES ("USA", "United States", "Federal Republic", "Joe Biden", "3813");
INSERT INTO "country" VALUES ("CAN", "Canada", "Federal Republic", "Justin Trudeau", "1822");
INSERT INTO "country" VALUES ("MEX", "Mexico", "Federal Republic", "Andres Manuel Lopez Obrador", "2704");
INSERT INTO "country" VALUES ("BRA", "Brazil", "Federal Republic", "Luiz Inacio Lula da Silva", "211");
INSERT INTO "country" VALUES ("ARG", "Argentina", "Federal Republic", "Javier Milei", "69");
INSERT INTO "country" VALUES ("GBR", "United Kingdom", "Constitutional Monarchy", "King Charles III", "2686");
INSERT INTO "country" VALUES ("FRA", "France", "Republic", "Emmanuel Macron", "378");
INSERT INTO "country" VALUES ("DEU", "Germany", "Federal Republic", "Olaf Scholz", "3068");
INSERT INTO "country" VALUES ("ITA", "Italy", "Republic", "Sergio Mattarella", "1464");
INSERT INTO "country" VALUES ("JPN", "Japan", "Constitutional Monarchy", "Emperor Naruhito", "1532");
INSERT INTO "country" VALUES ("CHN", "China", "Peoples Republic", "Xi Jinping", "1891");
INSERT INTO "country" VALUES ("IND", "India", "Federal Republic", "Droupadi Murmu", "1107");
INSERT INTO "country" VALUES ("AUS", "Australia", "Constitutional Monarchy", "King Charles III", "135");
INSERT INTO "country" VALUES ("NZL", "New Zealand", "Constitutional Monarchy", "King Charles III", "3475");
INSERT INTO "country" VALUES ("ZAF", "South Africa", "Republic", "Cyril Ramaphosa", "3373");
INSERT INTO "country" VALUES ("EGY", "Egypt", "Republic", "Abdel Fattah el-Sisi", "608");
INSERT INTO "country" VALUES ("NGA", "Nigeria", "Federal Republic", "Bola Ahmed Tinubu", "2754");
INSERT INTO "country" VALUES ("RUS", "Russia", "Federal Republic", "Vladimir Putin", "3580");
INSERT INTO "country" VALUES ("KOR", "South Korea", "Republic", "Yoon Suk-yeol", "2331");
INSERT INTO "country" VALUES ("PRK", "North Korea", "Socialist Republic", "Kim Jong Un", "2447");
INSERT INTO "country" VALUES ("CUB", "Cuba", "Socialist Republic", "Miguel Diaz-Canel", "2413");
INSERT INTO "country" VALUES ("VNM", "Vietnam", "Socialist Republic", "Vo Van Thuong", "3770");
INSERT INTO "country" VALUES ("SWE", "Sweden", "Constitutional Monarchy", "King Carl XVI Gustaf", "3289");
INSERT INTO "country" VALUES ("NOR", "Norway", "Constitutional Monarchy", "King Harald V", "2806");
INSERT INTO "country" VALUES ("FIN", "Finland", "Republic", "Sauli Niinisto", "654");
INSERT INTO "country" VALUES ("ESP", "Spain", "Constitutional Monarchy", "King Felipe VI", "653");
INSERT INTO "country" VALUES ("GRC", "Greece", "Republic", "Katerina Sakellaropoulou", "808");
INSERT INTO "country" VALUES ("TUR", "Turkey", "Republic", "Recep Tayyip Erdogan", "3320");
INSERT INTO "country" VALUES ("IRN", "Iran", "Islamic Republic", "Ali Khamenei", "1380");
INSERT INTO "country" VALUES ("SAU", "Saudi Arabia", "Monarchy", "King Salman bin Abdulaziz Al Saud", "3174");
INSERT INTO "country" VALUES ("ISR", "Israel", "Republic", "Isaac Herzog", "1450");
INSERT INTO "country" VALUES ("ARE", "United Arab Emirates", "Federal Monarchy", "Mohamed bin Zayed Al Nahyan", "1");
INSERT INTO "country" VALUES ("QAT", "Qatar", "Monarchy", "Tamim bin Hamad Al Thani", "2973");
INSERT INTO "country" VALUES ("SGP", "Singapore", "Republic", "Halimah Yacob", "3208");
INSERT INTO "country" VALUES ("MYS", "Malaysia", "Constitutional Monarchy", "Sultan Abdullah of Pahang", "2464");
INSERT INTO "country" VALUES ("THA", "Thailand", "Constitutional Monarchy", "King Maha Vajiralongkorn", "3315");
INSERT INTO "country" VALUES ("IDN", "Indonesia", "Republic", "Joko Widodo", "1744");
INSERT INTO "country" VALUES ("PHL", "Philippines", "Republic", "Ferdinand Marcos Jr.", "2964");
INSERT INTO "country" VALUES ("COL", "Colombia", "Republic", "Gustavo Petro", "2257");
INSERT INTO "country" VALUES ("PER", "Peru", "Republic", "Dina Boluarte", "2860");
INSERT INTO "country" VALUES ("CHL", "Chile", "Republic", "Gabriel Boric", "291");
INSERT INTO "country" VALUES ("VEN", "Venezuela", "Federal Republic", "Nicolas Maduro", "505");
INSERT INTO "country" VALUES ("BOL", "Bolivia", "Republic", "Luis Arce", "194");
INSERT INTO "country" VALUES ("ECU", "Ecuador", "Republic", "Daniel Noboa", "309");
INSERT INTO "country" VALUES ("URY", "Uruguay", "Republic", "Luis Lacalle Pou", "3492");
INSERT INTO "country" VALUES ("PRY", "Paraguay", "Republic", "Santiago Pena", "2885");
INSERT INTO "country" VALUES ("CRI", "Costa Rica", "Republic", "Rodrigo Chaves Robles", "250");
INSERT INTO "country" VALUES ("PAN", "Panama", "Republic", "Laurentino Cortizo", "2881");
INSERT INTO "country" VALUES ("GTM", "Guatemala", "Republic", "Bernardo Arevalo", "928");
INSERT INTO "country" VALUES ("HND", "Honduras", "Republic", "Xiomara Castro", "933");
INSERT INTO "country" VALUES ("SLV", "El Salvador", "Republic", "Nayib Bukele", "639");
INSERT INTO "country" VALUES ("NIC", "Nicaragua", "Republic", "Daniel Ortega", "2744");
INSERT INTO "country" VALUES ("DOM", "Dominican Republic", "Republic", "Luis Abinader", "306");
INSERT INTO "country" VALUES ("HTI", "Haiti", "Republic", "Ariel Henry", "929");
INSERT INTO "country" VALUES ("JAM", "Jamaica", "Constitutional Monarchy", "King Charles III", "1792");
INSERT INTO "country" VALUES ("BHS", "Bahamas", "Constitutional Monarchy", "King Charles III", "148");
INSERT INTO "country" VALUES ("BRB", "Barbados", "Parliamentary Republic", "Sandra Mason", "197");
INSERT INTO "country" VALUES ("TTO", "Trinidad and Tobago", "Parliamentary Republic", "Christine Kangaloo", "3317");
INSERT INTO "country" VALUES ("GUY", "Guyana", "Parliamentary Republic", "Irfaan Ali", "927");
INSERT INTO "country" VALUES ("SUR", "Suriname", "Republic", "Chan Santokhi", "3287");
INSERT INTO "country" VALUES ("BEL", "Belgium", "Constitutional Monarchy", "King Philippe", "179");
INSERT INTO "country" VALUES ("NLD", "Netherlands", "Constitutional Monarchy", "King Willem-Alexander", "2705");
INSERT INTO "country" VALUES ("LUX", "Luxembourg", "Constitutional Monarchy", "Grand Duke Henri", "2448");
INSERT INTO "country" VALUES ("AUT", "Austria", "Federal Republic", "Alexander Van der Bellen", "152");
INSERT INTO "country" VALUES ("CHE", "Switzerland", "Federal Republic", "Alain Berset", "3248");
INSERT INTO "country" VALUES ("POL", "Poland", "Republic", "Andrzej Duda", "2962");
INSERT INTO "country" VALUES ("CZE", "Czech Republic", "Republic", "Petr Pavel", "2919");
INSERT INTO "country" VALUES ("SVK", "Slovakia", "Republic", "Zuzana Caputova", "3209");
INSERT INTO "country" VALUES ("HUN", "Hungary", "Republic", "Katalin Novak", "1090");
INSERT INTO "country" VALUES ("ROU", "Romania", "Republic", "Klaus Iohannis", "3018");
INSERT INTO "country" VALUES ("BGR", "Bulgaria", "Republic", "Rumen Radev", "547");
INSERT INTO "country" VALUES ("SRB", "Serbia", "Republic", "Aleksandar Vucic", "3169");
INSERT INTO "country" VALUES ("HRV", "Croatia", "Republic", "Zoran Milanovic", "2409");
INSERT INTO "country" VALUES ("BIH", "Bosnia and Herzegovina", "Federal Republic", "Collective Presidency", "201");
INSERT INTO "country" VALUES ("SVN", "Slovenia", "Republic", "Natasa Pirc Musar", "3210");
INSERT INTO "country" VALUES ("MKD", "North Macedonia", "Republic", "Stevo Pendarovski", "2460");
INSERT INTO "country" VALUES ("ALB", "Albania", "Republic", "Bajram Begaj", "34");
INSERT INTO "country" VALUES ("MNE", "Montenegro", "Republic", "Jakov Milatovic", "2700");
INSERT INTO "country" VALUES ("KOS", "Kosovo", "Republic", "Vjosa Osmani", "2296");
INSERT INTO "country" VALUES ("EST", "Estonia", "Republic", "Alar Karis", "652");
INSERT INTO "country" VALUES ("LVA", "Latvia", "Republic", "Edgars Rinkevics", "2430");
INSERT INTO "country" VALUES ("LTU", "Lithuania", "Republic", "Gitanas Nauseda", "2440");
INSERT INTO "country" VALUES ("BLR", "Belarus", "Republic", "Alexander Lukashenko", "170");
INSERT INTO "country" VALUES ("UKR", "Ukraine", "Republic", "Volodymyr Zelenskyy", "3338");
INSERT INTO "country" VALUES ("MDA", "Moldova", "Republic", "Maia Sandu", "2579");
INSERT INTO "country" VALUES ("GEO", "Georgia", "Republic", "Salome Zourabichvili", "905");
INSERT INTO "country" VALUES ("ARM", "Armenia", "Republic", "Vahagn Khachaturyan", "126");
INSERT INTO "country" VALUES ("AZE", "Azerbaijan", "Republic", "Ilham Aliyev", "145");
INSERT INTO "country" VALUES ("KAZ", "Kazakhstan", "Republic", "Kassym-Jomart Tokayev", "2254");
INSERT INTO "country" VALUES ("UZB", "Uzbekistan", "Republic", "Shavkat Mirziyoyev", "3503");
INSERT INTO "country" VALUES ("TKM", "Turkmenistan", "Republic", "Serdar Berdimuhamedow", "3321");
INSERT INTO "country" VALUES ("KGZ", "Kyrgyzstan", "Republic", "Sadyr Japarov", "2297");
INSERT INTO "country" VALUES ("TJK", "Tajikistan", "Republic", "Emomali Rahmon", "3290");
INSERT INTO "country" VALUES ("AFG", "Afghanistan", "Islamic Emirate", "Hibatullah Akhundzada", "1791");
INSERT INTO "country" VALUES ("PAK", "Pakistan", "Federal Republic", "Arif Alvi", "2882");
INSERT INTO "country" VALUES ("BGD", "Bangladesh", "Parliamentary Republic", "Mohammed Shahabuddin", "150");
INSERT INTO "country" VALUES ("NPL", "Nepal", "Federal Republic", "Ram Chandra Poudel", "2706");
INSERT INTO "country" VALUES ("BTN", "Bhutan", "Constitutional Monarchy", "King Jigme Khesar Namgyel Wangchuck", "209");
INSERT INTO "country" VALUES ("LKA", "Sri Lanka", "Democratic Socialist Republic", "Ranil Wickremesinghe", "2436");
INSERT INTO "country" VALUES ("MDV", "Maldives", "Republic", "Mohamed Muizzu", "2463");
INSERT INTO "country" VALUES ("MMR", "Myanmar", "Republic", "Myint Swe", "2703");
INSERT INTO "country" VALUES ("LAO", "Laos", "Peoples Democratic Republic", "Thongloun Sisoulith", "2429");
INSERT INTO "country" VALUES ("KHM", "Cambodia", "Constitutional Monarchy", "King Norodom Sihamoni", "2295");
INSERT INTO "country" VALUES ("MNG", "Mongolia", "Republic", "Ukhnaagiin Khurelsukh", "2701");
INSERT INTO "country" VALUES ("BRN", "Brunei", "Absolute Monarchy", "Sultan Hassanal Bolkiah", "218");
INSERT INTO "country" VALUES ("TLS", "East Timor", "Republic", "Jose Ramos-Horta", "3316");
INSERT INTO "country" VALUES ("PNG", "Papua New Guinea", "Constitutional Monarchy", "King Charles III", "2883");
INSERT INTO "country" VALUES ("FJI", "Fiji", "Parliamentary Republic", "Wiliame Katonivere", "649");
INSERT INTO "country" VALUES ("SLB", "Solomon Islands", "Constitutional Monarchy", "King Charles III", "3211");
INSERT INTO "country" VALUES ("VUT", "Vanuatu", "Parliamentary Republic", "Nikenike Vurobaravu", "3504");
INSERT INTO "country" VALUES ("KIR", "Kiribati", "Republic", "Taneti Maamau", "2294");
INSERT INTO "country" VALUES ("TUV", "Tuvalu", "Constitutional Monarchy", "King Charles III", "3322");
INSERT INTO "country" VALUES ("WSM", "Samoa", "Parliamentary Republic", "Tuimalealiifano Vaaletoa Sualauvi II", "3168");
INSERT INTO "country" VALUES ("TON", "Tonga", "Constitutional Monarchy", "King Tupou VI", "3318");
INSERT INTO "country" VALUES ("MHL", "Marshall Islands", "Republic", "Hilda Heine", "2465");
INSERT INTO "country" VALUES ("FSM", "Micronesia", "Federal Republic", "David W. Panuelo", "2578");
INSERT INTO "country" VALUES ("PLW", "Palau", "Republic", "Surangel S. Whipps Jr.", "2880");
INSERT INTO "country" VALUES ("NRU", "Nauru", "Republic", "Russ Kun", "2702");
INSERT INTO "country" VALUES ("DZA", "Algeria", "Republic", "Abdelmadjid Tebboune", "35");
INSERT INTO "country" VALUES ("MAR", "Morocco", "Constitutional Monarchy", "King Mohammed VI", "2699");
INSERT INTO "country" VALUES ("TUN", "Tunisia", "Republic", "Kais Saied", "3319");
INSERT INTO "country" VALUES ("LBY", "Libya", "Transitional Government", "Mohamed al-Menfi", "2437");
INSERT INTO "country" VALUES ("SDN", "Sudan", "Federal Republic", "Abdel Fattah al-Burhan", "3232");
INSERT INTO "country" VALUES ("SSD", "South Sudan", "Republic", "Salva Kiir Mayardit", "3233");
INSERT INTO "country" VALUES ("ERI", "Eritrea", "Republic", "Isaias Afwerki", "648");
INSERT INTO "country" VALUES ("DJI", "Djibouti", "Republic", "Ismail Omar Guelleh", "585");
INSERT INTO "country" VALUES ("SOM", "Somalia", "Federal Republic", "Hassan Sheikh Mohamud", "3212");
INSERT INTO "country" VALUES ("ETH", "Ethiopia", "Federal Republic", "Sahle-Work Zewde", "650");
INSERT INTO "country" VALUES ("KEN", "Kenya", "Republic", "William Ruto", "2293");
INSERT INTO "country" VALUES ("UGA", "Uganda", "Republic", "Yoweri Museveni", "3339");
INSERT INTO "country" VALUES ("RWA", "Rwanda", "Republic", "Paul Kagame", "3067");
INSERT INTO "country" VALUES ("BDI", "Burundi", "Republic", "Evariste Ndayishimiye", "220");
INSERT INTO "country" VALUES ("TZA", "Tanzania", "Republic", "Samia Suluhu Hassan", "3314");
INSERT INTO "country" VALUES ("COD", "DR Congo", "Republic", "Felix Tshisekedi", "2256");
INSERT INTO "country" VALUES ("COG", "Republic of the Congo", "Republic", "Denis Sassou Nguesso", "2972");
INSERT INTO "country" VALUES ("CAF", "Central African Republic", "Republic", "Faustin-Archange Touadera", "240");
INSERT INTO "country" VALUES ("CMR", "Cameroon", "Republic", "Paul Biya", "239");
INSERT INTO "country" VALUES ("GAB", "Gabon", "Republic", "Brice Oligui Nguema", "753");
INSERT INTO "country" VALUES ("GNQ", "Equatorial Guinea", "Republic", "Teodoro Obiang Nguema Mbasogo", "647");
INSERT INTO "country" VALUES ("STP", "Sao Tome and Principe", "Republic", "Carlos Vila Nova", "3170");
INSERT INTO "country" VALUES ("AGO", "Angola", "Republic", "Joao Lourenco", "68");
INSERT INTO "country" VALUES ("ZMB", "Zambia", "Republic", "Hakainde Hichilema", "3581");
INSERT INTO "country" VALUES ("MWI", "Malawi", "Republic", "Lazarus Chakwera", "2461");
INSERT INTO "country" VALUES ("MOZ", "Mozambique", "Republic", "Filipe Nyusi", "2707");
INSERT INTO "country" VALUES ("ZWE", "Zimbabwe", "Republic", "Emmerson Mnangagwa", "3582");
INSERT INTO "country" VALUES ("BWA", "Botswana", "Republic", "Mokgweetsi Masisi", "210");
INSERT INTO "country" VALUES ("NAM", "Namibia", "Republic", "Hage Geingob", "2708");
INSERT INTO "country" VALUES ("LSO", "Lesotho", "Constitutional Monarchy", "King Letsie III", "2435");
INSERT INTO "country" VALUES ("SWZ", "Eswatini", "Absolute Monarchy", "King Mswati III", "3288");
INSERT INTO "country" VALUES ("MDG", "Madagascar", "Republic", "Andry Rajoelina", "2462");
INSERT INTO "country" VALUES ("COM", "Comoros", "Federal Republic", "Azali Assoumani", "241");
INSERT INTO "country" VALUES ("SYC", "Seychelles", "Republic", "Wavel Ramkalawan", "3171");
INSERT INTO "country" VALUES ("MUS", "Mauritius", "Parliamentary Republic", "Prithvirajsing Roopun", "2466");
INSERT INTO "country" VALUES ("CPV", "Cape Verde", "Republic", "Jose Maria Neves", "238");
INSERT INTO "country" VALUES ("SEN", "Senegal", "Republic", "Macky Sall", "3172");
INSERT INTO "country" VALUES ("GMB", "Gambia", "Republic", "Adama Barrow", "754");
INSERT INTO "country" VALUES ("MLI", "Mali", "Republic", "Assimi Goita", "2467");
INSERT INTO "country" VALUES ("BFA", "Burkina Faso", "Republic", "Ibrahim Traore", "219");
INSERT INTO "country" VALUES ("NER", "Niger", "Republic", "Abdourahamane Tchiani", "2745");
INSERT INTO "country" VALUES ("MRT", "Mauritania", "Republic", "Mohamed Ould Ghazouani", "2468");
INSERT INTO "country" VALUES ("ESH", "Western Sahara", "Disputed", "Brahim Ghali", "NULL");
INSERT INTO "country" VALUES ("DZA_REP", "Algeria Republic", "Republic", "Abdelmadjid Tebboune", "35");
INSERT INTO "country" VALUES ("FRA_REP", "France Republic", "Republic", "Emmanuel Macron", "378");
INSERT INTO "country" VALUES ("DEU_FED", "Germany Federal Republic", "Federal Republic", "Olaf Scholz", "3068");
INSERT INTO "country" VALUES ("ITA_REP", "Italy Republic", "Republic", "Sergio Mattarella", "1464");
INSERT INTO "country" VALUES ("USA_FED", "USA Federal Republic", "Federal Republic", "Joe Biden", "3813");
INSERT INTO "country" VALUES ("IND_FED", "India Federal Republic", "Federal Republic", "Droupadi Murmu", "1107");
INSERT INTO "country" VALUES ("RUS_FED", "Russia Federal Republic", "Federal Republic", "Vladimir Putin", "3580");
INSERT INTO "country" VALUES ("CHN_PEO", "China Peoples Republic", "Peoples Republic", "Xi Jinping", "1891");
INSERT INTO "country" VALUES ("GBR_MON", "UK Monarchy", "Constitutional Monarchy", "King Charles III", "2686");
INSERT INTO "country" VALUES ("JPN_MON", "Japan Monarchy", "Constitutional Monarchy", "Emperor Naruhito", "1532");
INSERT INTO "country" VALUES ("CAN_MON", "Canada Monarchy", "Federal Monarchy", "Justin Trudeau", "1822");
INSERT INTO "country" VALUES ("AUS_MON", "Australia Monarchy", "Constitutional Monarchy", "King Charles III", "135");
INSERT INTO "country" VALUES ("NZL_MON", "New Zealand Monarchy", "Constitutional Monarchy", "King Charles III", "3475");
INSERT INTO "country" VALUES ("SWE_MON", "Sweden Monarchy", "Constitutional Monarchy", "King Carl XVI Gustaf", "3289");
INSERT INTO "country" VALUES ("NOR_MON", "Norway Monarchy", "Constitutional Monarchy", "King Harald V", "2806");
INSERT INTO "country" VALUES ("ESP_MON", "Spain Monarchy", "Constitutional Monarchy", "King Felipe VI", "653");
INSERT INTO "country" VALUES ("THA_MON", "Thailand Monarchy", "Constitutional Monarchy", "King Maha Vajiralongkorn", "3315");
INSERT INTO "country" VALUES ("SAU_MON", "Saudi Arabia Monarchy", "Monarchy", "King Salman bin Abdulaziz Al Saud", "3174");
INSERT INTO "country" VALUES ("BRN_MON", "Brunei Monarchy", "Absolute Monarchy", "Sultan Hassanal Bolkiah", "218");
INSERT INTO "country" VALUES ("SWZ_MON", "Eswatini Monarchy", "Absolute Monarchy", "King Mswati III", "3288");
INSERT INTO "country" VALUES ("ARE_MON", "UAE Monarchy", "Federal Monarchy", "Mohamed bin Zayed Al Nahyan", "1");
INSERT INTO "country" VALUES ("QAT_MON", "Qatar Monarchy", "Monarchy", "Tamim bin Hamad Al Thani", "2973");
INSERT INTO "country" VALUES ("MYS_MON", "Malaysia Monarchy", "Constitutional Monarchy", "Sultan Abdullah of Pahang", "2464");
INSERT INTO "country" VALUES ("LSO_MON", "Lesotho Monarchy", "Constitutional Monarchy", "King Letsie III", "2435");
INSERT INTO "country" VALUES ("TON_MON", "Tonga Monarchy", "Constitutional Monarchy", "King Tupou VI", "3318");
INSERT INTO "country" VALUES ("PNG_MON", "PNG Monarchy", "Constitutional Monarchy", "King Charles III", "2883");
INSERT INTO "country" VALUES ("SLB_MON", "Solomon Islands Monarchy", "Constitutional Monarchy", "King Charles III", "3211");
INSERT INTO "country" VALUES ("TUV_MON", "Tuvalu Monarchy", "Constitutional Monarchy", "King Charles III", "3322");
INSERT INTO "country" VALUES ("JAM_MON", "Jamaica Monarchy", "Constitutional Monarchy", "King Charles III", "1792");
INSERT INTO "country" VALUES ("BHS_MON", "Bahamas Monarchy", "Constitutional Monarchy", "King Charles III", "148");
INSERT INTO "country" VALUES ("BEL_MON", "Belgium Monarchy", "Constitutional Monarchy", "King Philippe", "179");
INSERT INTO "country" VALUES ("NLD_MON", "Netherlands Monarchy", "Constitutional Monarchy", "King Willem-Alexander", "2705");
INSERT INTO "country" VALUES ("LUX_MON", "Luxembourg Monarchy", "Constitutional Monarchy", "Grand Duke Henri", "2448");
INSERT INTO "country" VALUES ("MOR_MON", "Morocco Monarchy", "Constitutional Monarchy", "King Mohammed VI", "2699");
INSERT INTO "country" VALUES ("KHM_MON", "Cambodia Monarchy", "Constitutional Monarchy", "King Norodom Sihamoni", "2295");
INSERT INTO "country" VALUES ("BTN_MON", "Bhutan Monarchy", "Constitutional Monarchy", "King Jigme Khesar Namgyel Wangchuck", "209");
INSERT INTO "country" VALUES ("AFG_EMI", "Afghanistan Emirate", "Islamic Emirate", "Hibatullah Akhundzada", "1791");
INSERT INTO "country" VALUES ("LBY_TRA", "Libya Transitional", "Transitional Government", "Mohamed al-Menfi", "2437");
INSERT INTO "country" VALUES ("ESH_DIS", "Western Sahara Disputed", "Disputed", "Brahim Ghali", "NULL");
INSERT INTO "country" VALUES ("VNM_PEO", "Vietnam Peoples Republic", "Peoples Democratic Republic", "Vo Van Thuong", "3770");
INSERT INTO "country" VALUES ("LAO_PEO", "Laos Peoples Democratic Republic", "Peoples Democratic Republic", "Thongloun Sisoulith", "2429");
INSERT INTO "country" VALUES ("PRK_SOC", "North Korea Socialist", "Socialist Republic", "Kim Jong Un", "2447");
INSERT INTO "country" VALUES ("CUB_SOC", "Cuba Socialist", "Socialist Republic", "Miguel Diaz-Canel", "2413");
INSERT INTO "country" VALUES ("IRN_ISL", "Iran Islamic", "Islamic Republic", "Ali Khamenei", "1380");
INSERT INTO "country" VALUES ("LKA_DEM", "Sri Lanka Democratic Socialist", "Democratic Socialist Republic", "Ranil Wickremesinghe", "2436");
INSERT INTO "country" VALUES ("BRB_PAR", "Barbados Parliamentary", "Parliamentary Republic", "Sandra Mason", "197");
INSERT INTO "country" VALUES ("TTO_PAR", "Trinidad and Tobago Parliamentary", "Parliamentary Republic", "Christine Kangaloo", "3317");
INSERT INTO "country" VALUES ("GUY_PAR", "Guyana Parliamentary", "Parliamentary Republic", "Irfaan Ali", "927");
INSERT INTO "country" VALUES ("BGD_PAR", "Bangladesh Parliamentary", "Parliamentary Republic", "Mohammed Shahabuddin", "150");
INSERT INTO "country" VALUES ("FJI_PAR", "Fiji Parliamentary", "Parliamentary Republic", "Wiliame Katonivere", "649");