CREATE TABLE list (id VARCHAR(64) NOT NULL, value VARCHAR(64) NOT NULL, PRIMARY KEY(id));

INSERT INTO "list" ("id", "value") VALUES (E'AF', E'Afuganisitani');
INSERT INTO "list" ("id", "value") VALUES (E'ZA', E'Afurika y’Epfo');
INSERT INTO "list" ("id", "value") VALUES (E'AX', E'Åland Islands');
INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'Alijeriya');
INSERT INTO "list" ("id", "value") VALUES (E'AL', E'Alubaniya');
INSERT INTO "list" ("id", "value") VALUES (E'VI', E'Amazinga y’Isugi y’Abanyamerika');
INSERT INTO "list" ("id", "value") VALUES (E'PH', E'Amazinga ya Filipine');
INSERT INTO "list" ("id", "value") VALUES (E'MP', E'Amazinga ya Mariyana ryo mu majaruguru');
INSERT INTO "list" ("id", "value") VALUES (E'RE', E'Amazinga ya Reyiniyo');
INSERT INTO "list" ("id", "value") VALUES (E'SB', E'Amazinga ya Salumoni');
INSERT INTO "list" ("id", "value") VALUES (E'SC', E'Amazinga ya Seyisheli');
INSERT INTO "list" ("id", "value") VALUES (E'TC', E'Amazinga ya Turkisi na Cayikosi');
INSERT INTO "list" ("id", "value") VALUES (E'AD', E'Andora');
INSERT INTO "list" ("id", "value") VALUES (E'AO', E'Angola');
INSERT INTO "list" ("id", "value") VALUES (E'AI', E'Angwila');
INSERT INTO "list" ("id", "value") VALUES (E'AQ', E'Antarctica');
INSERT INTO "list" ("id", "value") VALUES (E'AG', E'Antigwa na Baribuda');
INSERT INTO "list" ("id", "value") VALUES (E'SA', E'Arabiya Sawudite');
INSERT INTO "list" ("id", "value") VALUES (E'AR', E'Arijantine');
INSERT INTO "list" ("id", "value") VALUES (E'AW', E'Aruba');
INSERT INTO "list" ("id", "value") VALUES (E'AM', E'Arumeniya');
INSERT INTO "list" ("id", "value") VALUES (E'IS', E'Ayisilandi');
INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'Azerubayijani');
INSERT INTO "list" ("id", "value") VALUES (E'BS', E'Bahamasi');
INSERT INTO "list" ("id", "value") VALUES (E'BH', E'Bahareyini');
INSERT INTO "list" ("id", "value") VALUES (E'BD', E'Bangaladeshi');
INSERT INTO "list" ("id", "value") VALUES (E'BB', E'Barubadosi');
INSERT INTO "list" ("id", "value") VALUES (E'BY', E'Belausi');
INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'Belize');
INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'Bene');
INSERT INTO "list" ("id", "value") VALUES (E'BM', E'Berimuda');
INSERT INTO "list" ("id", "value") VALUES (E'MM', E'Birimaniya');
INSERT INTO "list" ("id", "value") VALUES (E'BO', E'Boliviya');
INSERT INTO "list" ("id", "value") VALUES (E'BA', E'Bosiniya na Herigozevine');
INSERT INTO "list" ("id", "value") VALUES (E'BW', E'Botswana');
INSERT INTO "list" ("id", "value") VALUES (E'BV', E'Bouvet Island');
INSERT INTO "list" ("id", "value") VALUES (E'BG', E'Buligariya');
INSERT INTO "list" ("id", "value") VALUES (E'BR', E'Burezili');
INSERT INTO "list" ("id", "value") VALUES (E'BF', E'Burukina Faso');
INSERT INTO "list" ("id", "value") VALUES (E'BN', E'Buruneyi');
INSERT INTO "list" ("id", "value") VALUES (E'BT', E'Butani');
INSERT INTO "list" ("id", "value") VALUES (E'TD', E'Cadi');
INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'Caribbean Netherlands');
INSERT INTO "list" ("id", "value") VALUES (E'CX', E'Christmas Island');
INSERT INTO "list" ("id", "value") VALUES (E'CC', E'Cocos (Keeling) Islands');
INSERT INTO "list" ("id", "value") VALUES (E'CW', E'Curaçao');
INSERT INTO "list" ("id", "value") VALUES (E'DK', E'Danimariki');
INSERT INTO "list" ("id", "value") VALUES (E'DM', E'Dominika');
INSERT INTO "list" ("id", "value") VALUES (E'EC', E'Ekwateri');
INSERT INTO "list" ("id", "value") VALUES (E'SV', E'Eli Saluvatori');
INSERT INTO "list" ("id", "value") VALUES (E'ER', E'Elitereya');
INSERT INTO "list" ("id", "value") VALUES (E'EE', E'Esitoniya');
INSERT INTO "list" ("id", "value") VALUES (E'ET', E'Etiyopiya');
INSERT INTO "list" ("id", "value") VALUES (E'FO', E'Faroe Islands');
INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'Fiji');
INSERT INTO "list" ("id", "value") VALUES (E'FI', E'Finilandi');
INSERT INTO "list" ("id", "value") VALUES (E'TF', E'French Southern Territories');
INSERT INTO "list" ("id", "value") VALUES (E'GA', E'Gabo');
INSERT INTO "list" ("id", "value") VALUES (E'GM', E'Gambiya');
INSERT INTO "list" ("id", "value") VALUES (E'GH', E'Gana');
INSERT INTO "list" ("id", "value") VALUES (E'GD', E'Gerenada');
INSERT INTO "list" ("id", "value") VALUES (E'GW', E'Gineya Bisawu');
INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'Gineya Ekwatoriyali');
INSERT INTO "list" ("id", "value") VALUES (E'GG', E'Guernsey');
INSERT INTO "list" ("id", "value") VALUES (E'GN', E'Guneya');
INSERT INTO "list" ("id", "value") VALUES (E'GL', E'Gurunilandi');
INSERT INTO "list" ("id", "value") VALUES (E'GY', E'Guyane');
INSERT INTO "list" ("id", "value") VALUES (E'GP', E'Gwadelupe');
INSERT INTO "list" ("id", "value") VALUES (E'GU', E'Gwamu');
INSERT INTO "list" ("id", "value") VALUES (E'GT', E'Gwatemala');
INSERT INTO "list" ("id", "value") VALUES (E'GF', E'Gwayana y’Abafaransa');
INSERT INTO "list" ("id", "value") VALUES (E'HT', E'Hayiti');
INSERT INTO "list" ("id", "value") VALUES (E'HM', E'Heard & McDonald Islands');
INSERT INTO "list" ("id", "value") VALUES (E'ES', E'Hisipaniya');
INSERT INTO "list" ("id", "value") VALUES (E'HN', E'Hondurasi');
INSERT INTO "list" ("id", "value") VALUES (E'HK', E'Hong Kong SAR China');
INSERT INTO "list" ("id", "value") VALUES (E'HU', E'Hungariya');
INSERT INTO "list" ("id", "value") VALUES (E'VG', E'Ibirwa by’isugi by’Abongereza');
INSERT INTO "list" ("id", "value") VALUES (E'CV', E'Ibirwa bya Kapuveri');
INSERT INTO "list" ("id", "value") VALUES (E'KY', E'Ibirwa bya Keyimani');
INSERT INTO "list" ("id", "value") VALUES (E'UA', E'Ikerene');
INSERT INTO "list" ("id", "value") VALUES (E'ID', E'Indoneziya');
INSERT INTO "list" ("id", "value") VALUES (E'IO', E'Intara y’Ubwongereza yo mu birwa by’Abahindi');
INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'Iraki');
INSERT INTO "list" ("id", "value") VALUES (E'IR', E'Irani');
INSERT INTO "list" ("id", "value") VALUES (E'UY', E'Irigwe');
INSERT INTO "list" ("id", "value") VALUES (E'IE', E'Irilandi');
INSERT INTO "list" ("id", "value") VALUES (E'IL', E'Isiraheli');
INSERT INTO "list" ("id", "value") VALUES (E'IM', E'Isle of Man');
INSERT INTO "list" ("id", "value") VALUES (E'FK', E'Izinga rya Filikilandi');
INSERT INTO "list" ("id", "value") VALUES (E'KM', E'Izinga rya Komore');
INSERT INTO "list" ("id", "value") VALUES (E'CK', E'Izinga rya Kuku');
INSERT INTO "list" ("id", "value") VALUES (E'MH', E'Izinga rya Marishari');
INSERT INTO "list" ("id", "value") VALUES (E'MU', E'Izinga rya Morise');
INSERT INTO "list" ("id", "value") VALUES (E'NF', E'izinga rya Norufoluke');
INSERT INTO "list" ("id", "value") VALUES (E'CY', E'Izinga rya Shipure');
INSERT INTO "list" ("id", "value") VALUES (E'JM', E'Jamayika');
INSERT INTO "list" ("id", "value") VALUES (E'JE', E'Jersey');
INSERT INTO "list" ("id", "value") VALUES (E'GE', E'Jeworujiya');
INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'Jibuti');
INSERT INTO "list" ("id", "value") VALUES (E'GI', E'Juburalitari');
INSERT INTO "list" ("id", "value") VALUES (E'KH', E'Kamboje');
INSERT INTO "list" ("id", "value") VALUES (E'CM', E'Kameruni');
INSERT INTO "list" ("id", "value") VALUES (E'CA', E'Kanada');
INSERT INTO "list" ("id", "value") VALUES (E'QA', E'Katari');
INSERT INTO "list" ("id", "value") VALUES (E'KZ', E'Kazakisitani');
INSERT INTO "list" ("id", "value") VALUES (E'KE', E'Kenya');
INSERT INTO "list" ("id", "value") VALUES (E'CU', E'Kiba');
INSERT INTO "list" ("id", "value") VALUES (E'KI', E'Kiribati');
INSERT INTO "list" ("id", "value") VALUES (E'KG', E'Kirigisitani');
INSERT INTO "list" ("id", "value") VALUES (E'CO', E'Kolombiya');
INSERT INTO "list" ("id", "value") VALUES (E'CG', E'Kongo');
INSERT INTO "list" ("id", "value") VALUES (E'KP', E'Koreya y’amajaruguru');
INSERT INTO "list" ("id", "value") VALUES (E'KR', E'Koreya y’amajepfo');
INSERT INTO "list" ("id", "value") VALUES (E'HR', E'Korowasiya');
INSERT INTO "list" ("id", "value") VALUES (E'CR', E'Kositarika');
INSERT INTO "list" ("id", "value") VALUES (E'CI', E'Kotedivuware');
INSERT INTO "list" ("id", "value") VALUES (E'KW', E'Koweti');
INSERT INTO "list" ("id", "value") VALUES (E'LV', E'Lativa');
INSERT INTO "list" ("id", "value") VALUES (E'LA', E'Layosi');
INSERT INTO "list" ("id", "value") VALUES (E'LS', E'Lesoto');
INSERT INTO "list" ("id", "value") VALUES (E'AE', E'Leta Zunze Ubumwe z’Abarabu');
INSERT INTO "list" ("id", "value") VALUES (E'US', E'Leta Zunze Ubumwe za Amerika');
INSERT INTO "list" ("id", "value") VALUES (E'LB', E'Libani');
INSERT INTO "list" ("id", "value") VALUES (E'LR', E'Liberiya');
INSERT INTO "list" ("id", "value") VALUES (E'LY', E'Libiya');
INSERT INTO "list" ("id", "value") VALUES (E'LI', E'Lishyitenshitayini');
INSERT INTO "list" ("id", "value") VALUES (E'LT', E'Lituwaniya');
INSERT INTO "list" ("id", "value") VALUES (E'LU', E'Lukusamburu');
INSERT INTO "list" ("id", "value") VALUES (E'MO', E'Macao SAR China');
INSERT INTO "list" ("id", "value") VALUES (E'MG', E'Madagasikari');
INSERT INTO "list" ("id", "value") VALUES (E'MW', E'Malawi');
INSERT INTO "list" ("id", "value") VALUES (E'MY', E'Maleziya');
INSERT INTO "list" ("id", "value") VALUES (E'ML', E'Mali');
INSERT INTO "list" ("id", "value") VALUES (E'MT', E'Malita');
INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'Maritiniki');
INSERT INTO "list" ("id", "value") VALUES (E'MA', E'Maroke');
INSERT INTO "list" ("id", "value") VALUES (E'YT', E'Mayote');
INSERT INTO "list" ("id", "value") VALUES (E'MX', E'Migizike');
INSERT INTO "list" ("id", "value") VALUES (E'FM', E'Mikoroniziya');
INSERT INTO "list" ("id", "value") VALUES (E'EG', E'Misiri');
INSERT INTO "list" ("id", "value") VALUES (E'MV', E'Moludave');
INSERT INTO "list" ("id", "value") VALUES (E'MD', E'Moludavi');
INSERT INTO "list" ("id", "value") VALUES (E'MC', E'Monako');
INSERT INTO "list" ("id", "value") VALUES (E'MN', E'Mongoliya');
INSERT INTO "list" ("id", "value") VALUES (E'ME', E'Montenegro');
INSERT INTO "list" ("id", "value") VALUES (E'MS', E'Monteserati');
INSERT INTO "list" ("id", "value") VALUES (E'MR', E'Moritaniya');
INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'Mozambiki');
INSERT INTO "list" ("id", "value") VALUES (E'NA', E'Namibiya');
INSERT INTO "list" ("id", "value") VALUES (E'NR', E'Nawuru');
INSERT INTO "list" ("id", "value") VALUES (E'NP', E'Nepali');
INSERT INTO "list" ("id", "value") VALUES (E'NE', E'Nijeri');
INSERT INTO "list" ("id", "value") VALUES (E'NG', E'Nijeriya');
INSERT INTO "list" ("id", "value") VALUES (E'NI', E'Nikaragwa');
INSERT INTO "list" ("id", "value") VALUES (E'NC', E'Niyukaledoniya');
INSERT INTO "list" ("id", "value") VALUES (E'NU', E'Niyuwe');
INSERT INTO "list" ("id", "value") VALUES (E'MK', E'North Macedonia');
INSERT INTO "list" ("id", "value") VALUES (E'NO', E'Noruveji');
INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'Nuvelizelandi');
INSERT INTO "list" ("id", "value") VALUES (E'OM', E'Omani');
INSERT INTO "list" ("id", "value") VALUES (E'AU', E'Ositaraliya');
INSERT INTO "list" ("id", "value") VALUES (E'AT', E'Otirishe');
INSERT INTO "list" ("id", "value") VALUES (E'PK', E'Pakisitani');
INSERT INTO "list" ("id", "value") VALUES (E'PW', E'Palawu');
INSERT INTO "list" ("id", "value") VALUES (E'PS', E'Palesitina Wesitibanka na Gaza');
INSERT INTO "list" ("id", "value") VALUES (E'PA', E'Panama');
INSERT INTO "list" ("id", "value") VALUES (E'PG', E'Papuwa Niyugineya');
INSERT INTO "list" ("id", "value") VALUES (E'PY', E'Paragwe');
INSERT INTO "list" ("id", "value") VALUES (E'PE', E'Peru');
INSERT INTO "list" ("id", "value") VALUES (E'PN', E'Pitikeyirini');
INSERT INTO "list" ("id", "value") VALUES (E'PF', E'Polineziya y’Abafaransa');
INSERT INTO "list" ("id", "value") VALUES (E'PL', E'Polonye');
INSERT INTO "list" ("id", "value") VALUES (E'PT', E'Porutugali');
INSERT INTO "list" ("id", "value") VALUES (E'PR', E'Puwetoriko');
INSERT INTO "list" ("id", "value") VALUES (E'CD', E'Repubulika Iharanira Demokarasi ya Kongo');
INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'Repubulika ya Ceke');
INSERT INTO "list" ("id", "value") VALUES (E'DO', E'Repubulika ya Dominika');
INSERT INTO "list" ("id", "value") VALUES (E'CF', E'Repubulika ya Santarafurika');
INSERT INTO "list" ("id", "value") VALUES (E'RO', E'Rumaniya');
INSERT INTO "list" ("id", "value") VALUES (E'WS', E'Samowa');
INSERT INTO "list" ("id", "value") VALUES (E'AS', E'Samowa nyamerika');
INSERT INTO "list" ("id", "value") VALUES (E'SM', E'Sanimarino');
INSERT INTO "list" ("id", "value") VALUES (E'ST', E'Sawotome na Perensipe');
INSERT INTO "list" ("id", "value") VALUES (E'SH', E'Sehelene');
INSERT INTO "list" ("id", "value") VALUES (E'KN', E'Sekitsi na Nevisi');
INSERT INTO "list" ("id", "value") VALUES (E'LC', E'Selusiya');
INSERT INTO "list" ("id", "value") VALUES (E'PM', E'Sempiyeri na Mikeloni');
INSERT INTO "list" ("id", "value") VALUES (E'SN', E'Senegali');
INSERT INTO "list" ("id", "value") VALUES (E'RS', E'Serbia');
INSERT INTO "list" ("id", "value") VALUES (E'VC', E'Sevensa na Gerenadine');
INSERT INTO "list" ("id", "value") VALUES (E'CL', E'Shili');
INSERT INTO "list" ("id", "value") VALUES (E'SK', E'Silovakiya');
INSERT INTO "list" ("id", "value") VALUES (E'SI', E'Siloveniya');
INSERT INTO "list" ("id", "value") VALUES (E'SG', E'Singapuru');
INSERT INTO "list" ("id", "value") VALUES (E'SX', E'Sint Maarten');
INSERT INTO "list" ("id", "value") VALUES (E'LK', E'Sirilanka');
INSERT INTO "list" ("id", "value") VALUES (E'SY', E'Siriya');
INSERT INTO "list" ("id", "value") VALUES (E'SL', E'Siyeralewone');
INSERT INTO "list" ("id", "value") VALUES (E'SO', E'Somaliya');
INSERT INTO "list" ("id", "value") VALUES (E'GS', E'South Georgia & South Sandwich Islands');
INSERT INTO "list" ("id", "value") VALUES (E'SS', E'South Sudan');
INSERT INTO "list" ("id", "value") VALUES (E'BL', E'St. Barthélemy');
INSERT INTO "list" ("id", "value") VALUES (E'MF', E'St. Martin');
INSERT INTO "list" ("id", "value") VALUES (E'SD', E'Sudani');
INSERT INTO "list" ("id", "value") VALUES (E'SR', E'Suriname');
INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'Suwazilandi');
INSERT INTO "list" ("id", "value") VALUES (E'SE', E'Suwedi');
INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'Svalbard & Jan Mayen');
INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'Tajikisitani');
INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'Tanzaniya');
INSERT INTO "list" ("id", "value") VALUES (E'TH', E'Tayilandi');
INSERT INTO "list" ("id", "value") VALUES (E'TW', E'Tayiwani');
INSERT INTO "list" ("id", "value") VALUES (E'TL', E'Timoru y’iburasirazuba');
INSERT INTO "list" ("id", "value") VALUES (E'TT', E'Tirinidadi na Tobago');
INSERT INTO "list" ("id", "value") VALUES (E'TG', E'Togo');
INSERT INTO "list" ("id", "value") VALUES (E'TK', E'Tokelawu');
INSERT INTO "list" ("id", "value") VALUES (E'TO', E'Tonga');
INSERT INTO "list" ("id", "value") VALUES (E'TN', E'Tuniziya');
INSERT INTO "list" ("id", "value") VALUES (E'TR', E'Turukiya');
INSERT INTO "list" ("id", "value") VALUES (E'TM', E'Turukumenisitani');
INSERT INTO "list" ("id", "value") VALUES (E'TV', E'Tuvalu');
INSERT INTO "list" ("id", "value") VALUES (E'RW', E'u Rwanda');
INSERT INTO "list" ("id", "value") VALUES (E'UM', E'U.S. Outlying Islands');
INSERT INTO "list" ("id", "value") VALUES (E'BE', E'Ububiligi');
INSERT INTO "list" ("id", "value") VALUES (E'DE', E'Ubudage');
INSERT INTO "list" ("id", "value") VALUES (E'FR', E'Ubufaransa');
INSERT INTO "list" ("id", "value") VALUES (E'UG', E'Ubugande');
INSERT INTO "list" ("id", "value") VALUES (E'GR', E'Ubugereki');
INSERT INTO "list" ("id", "value") VALUES (E'IN', E'Ubuhindi');
INSERT INTO "list" ("id", "value") VALUES (E'NL', E'Ubuholandi');
INSERT INTO "list" ("id", "value") VALUES (E'BI', E'Uburundi');
INSERT INTO "list" ("id", "value") VALUES (E'RU', E'Uburusiya');
INSERT INTO "list" ("id", "value") VALUES (E'CN', E'Ubushinwa');
INSERT INTO "list" ("id", "value") VALUES (E'CH', E'Ubusuwisi');
INSERT INTO "list" ("id", "value") VALUES (E'IT', E'Ubutaliyani');
INSERT INTO "list" ("id", "value") VALUES (E'JP', E'Ubuyapani');
INSERT INTO "list" ("id", "value") VALUES (E'GB', E'Ubwongereza');
INSERT INTO "list" ("id", "value") VALUES (E'VA', E'Umurwa wa Vatikani');
INSERT INTO "list" ("id", "value") VALUES (E'UZ', E'Uzubekisitani');
INSERT INTO "list" ("id", "value") VALUES (E'VU', E'Vanuwatu');
INSERT INTO "list" ("id", "value") VALUES (E'VE', E'Venezuwela');
INSERT INTO "list" ("id", "value") VALUES (E'VN', E'Viyetinamu');
INSERT INTO "list" ("id", "value") VALUES (E'WF', E'Walisi na Futuna');
INSERT INTO "list" ("id", "value") VALUES (E'EH', E'Western Sahara');
INSERT INTO "list" ("id", "value") VALUES (E'YE', E'Yemeni');
INSERT INTO "list" ("id", "value") VALUES (E'JO', E'Yorudaniya');
INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'Zambiya');
INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'Zimbabwe');