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'Afganistan');
INSERT INTO "list" ("id", "value") VALUES (E'ZA', E'Afrika e Jugut');
INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'Algjeri');
INSERT INTO "list" ("id", "value") VALUES (E'AD', E'Andorrë');
INSERT INTO "list" ("id", "value") VALUES (E'AO', E'Angolë');
INSERT INTO "list" ("id", "value") VALUES (E'AI', E'Anguilë');
INSERT INTO "list" ("id", "value") VALUES (E'AQ', E'Antarktikë');
INSERT INTO "list" ("id", "value") VALUES (E'AG', E'Antigua e Barbuda');
INSERT INTO "list" ("id", "value") VALUES (E'SA', E'Arabi Saudite');
INSERT INTO "list" ("id", "value") VALUES (E'AR', E'Argjentinë');
INSERT INTO "list" ("id", "value") VALUES (E'AM', E'Armeni');
INSERT INTO "list" ("id", "value") VALUES (E'AW', E'Arubë');
INSERT INTO "list" ("id", "value") VALUES (E'AU', E'Australi');
INSERT INTO "list" ("id", "value") VALUES (E'AT', E'Austri');
INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'Azerbajxhan');
INSERT INTO "list" ("id", "value") VALUES (E'BS', E'Bahama');
INSERT INTO "list" ("id", "value") VALUES (E'BH', E'Bahrejn');
INSERT INTO "list" ("id", "value") VALUES (E'BD', E'Bangladesh');
INSERT INTO "list" ("id", "value") VALUES (E'BB', E'Barbados');
INSERT INTO "list" ("id", "value") VALUES (E'BE', E'Belgjikë');
INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'Belizë');
INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'Benin');
INSERT INTO "list" ("id", "value") VALUES (E'BM', E'Bermude');
INSERT INTO "list" ("id", "value") VALUES (E'BY', E'Bjellorusi');
INSERT INTO "list" ("id", "value") VALUES (E'BO', E'Bolivi');
INSERT INTO "list" ("id", "value") VALUES (E'BA', E'Bosnjë-Hercegovinë');
INSERT INTO "list" ("id", "value") VALUES (E'BW', E'Botsvanë');
INSERT INTO "list" ("id", "value") VALUES (E'BR', E'Brazil');
INSERT INTO "list" ("id", "value") VALUES (E'BN', E'Brunei');
INSERT INTO "list" ("id", "value") VALUES (E'BG', E'Bullgari');
INSERT INTO "list" ("id", "value") VALUES (E'BF', E'Burkina-Faso');
INSERT INTO "list" ("id", "value") VALUES (E'BI', E'Burundi');
INSERT INTO "list" ("id", "value") VALUES (E'BT', E'Butan');
INSERT INTO "list" ("id", "value") VALUES (E'CI', E'Côte d’Ivoire');
INSERT INTO "list" ("id", "value") VALUES (E'TD', E'Çad');
INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'Çeki');
INSERT INTO "list" ("id", "value") VALUES (E'DK', E'Danimarkë');
INSERT INTO "list" ("id", "value") VALUES (E'DM', E'Dominikë');
INSERT INTO "list" ("id", "value") VALUES (E'EG', E'Egjipt');
INSERT INTO "list" ("id", "value") VALUES (E'EC', E'Ekuador');
INSERT INTO "list" ("id", "value") VALUES (E'AE', E'Emiratet e Bashkuara Arabe');
INSERT INTO "list" ("id", "value") VALUES (E'ER', E'Eritre');
INSERT INTO "list" ("id", "value") VALUES (E'EE', E'Estoni');
INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'Esvatini');
INSERT INTO "list" ("id", "value") VALUES (E'ET', E'Etiopi');
INSERT INTO "list" ("id", "value") VALUES (E'PH', E'Filipine');
INSERT INTO "list" ("id", "value") VALUES (E'FI', E'Finlandë');
INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'Fixhi');
INSERT INTO "list" ("id", "value") VALUES (E'FR', E'Francë');
INSERT INTO "list" ("id", "value") VALUES (E'GA', E'Gabon');
INSERT INTO "list" ("id", "value") VALUES (E'GM', E'Gambi');
INSERT INTO "list" ("id", "value") VALUES (E'GH', E'Ganë');
INSERT INTO "list" ("id", "value") VALUES (E'GG', E'Gernsej');
INSERT INTO "list" ("id", "value") VALUES (E'GD', E'Granadë');
INSERT INTO "list" ("id", "value") VALUES (E'GR', E'Greqi');
INSERT INTO "list" ("id", "value") VALUES (E'GL', E'Grënlandë');
INSERT INTO "list" ("id", "value") VALUES (E'GP', E'Guadelupë');
INSERT INTO "list" ("id", "value") VALUES (E'GF', E'Guajana Franceze');
INSERT INTO "list" ("id", "value") VALUES (E'GY', E'Guajanë');
INSERT INTO "list" ("id", "value") VALUES (E'GU', E'Guam');
INSERT INTO "list" ("id", "value") VALUES (E'GT', E'Guatemalë');
INSERT INTO "list" ("id", "value") VALUES (E'GN', E'Guine');
INSERT INTO "list" ("id", "value") VALUES (E'GW', E'Guine-Bisau');
INSERT INTO "list" ("id", "value") VALUES (E'PG', E'Guineja e Re-Papua');
INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'Guineja Ekuatoriale');
INSERT INTO "list" ("id", "value") VALUES (E'GE', E'Gjeorgji');
INSERT INTO "list" ("id", "value") VALUES (E'DE', E'Gjermani');
INSERT INTO "list" ("id", "value") VALUES (E'GI', E'Gjibraltar');
INSERT INTO "list" ("id", "value") VALUES (E'HT', E'Haiti');
INSERT INTO "list" ("id", "value") VALUES (E'NL', E'Holandë');
INSERT INTO "list" ("id", "value") VALUES (E'HN', E'Honduras');
INSERT INTO "list" ("id", "value") VALUES (E'HU', E'Hungari');
INSERT INTO "list" ("id", "value") VALUES (E'IN', E'Indi');
INSERT INTO "list" ("id", "value") VALUES (E'ID', E'Indonezi');
INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'Irak');
INSERT INTO "list" ("id", "value") VALUES (E'IR', E'Iran');
INSERT INTO "list" ("id", "value") VALUES (E'IE', E'Irlandë');
INSERT INTO "list" ("id", "value") VALUES (E'IS', E'Islandë');
INSERT INTO "list" ("id", "value") VALUES (E'AX', E'Ishujt Alandë');
INSERT INTO "list" ("id", "value") VALUES (E'MP', E'Ishujt e Marianës Veriore');
INSERT INTO "list" ("id", "value") VALUES (E'VG', E'Ishujt e Virgjër Britanikë');
INSERT INTO "list" ("id", "value") VALUES (E'VI', E'Ishujt e Virgjër të SHBA-së');
INSERT INTO "list" ("id", "value") VALUES (E'FK', E'Ishujt Falkland');
INSERT INTO "list" ("id", "value") VALUES (E'FO', E'Ishujt Faroe');
INSERT INTO "list" ("id", "value") VALUES (E'HM', E'Ishujt Hërd e Mekdonald');
INSERT INTO "list" ("id", "value") VALUES (E'KY', E'Ishujt Kajman');
INSERT INTO "list" ("id", "value") VALUES (E'CC', E'Ishujt Kokos');
INSERT INTO "list" ("id", "value") VALUES (E'CK', E'Ishujt Kuk');
INSERT INTO "list" ("id", "value") VALUES (E'MH', E'Ishujt Marshall');
INSERT INTO "list" ("id", "value") VALUES (E'UM', E'Ishujt Periferikë të SHBA-së');
INSERT INTO "list" ("id", "value") VALUES (E'PN', E'Ishujt Pitkern');
INSERT INTO "list" ("id", "value") VALUES (E'SB', E'Ishujt Solomon');
INSERT INTO "list" ("id", "value") VALUES (E'TC', E'Ishujt Turks dhe Kaikos');
INSERT INTO "list" ("id", "value") VALUES (E'BV', E'Ishulli Bove');
INSERT INTO "list" ("id", "value") VALUES (E'CX', E'Ishulli i Krishtlindjes');
INSERT INTO "list" ("id", "value") VALUES (E'IM', E'Ishulli i Manit');
INSERT INTO "list" ("id", "value") VALUES (E'NF', E'Ishulli Norfolk');
INSERT INTO "list" ("id", "value") VALUES (E'IT', E'Itali');
INSERT INTO "list" ("id", "value") VALUES (E'IL', E'Izrael');
INSERT INTO "list" ("id", "value") VALUES (E'JP', E'Japoni');
INSERT INTO "list" ("id", "value") VALUES (E'YE', E'Jemen');
INSERT INTO "list" ("id", "value") VALUES (E'JO', E'Jordani');
INSERT INTO "list" ("id", "value") VALUES (E'NC', E'Kaledoni e Re');
INSERT INTO "list" ("id", "value") VALUES (E'KH', E'Kamboxhia');
INSERT INTO "list" ("id", "value") VALUES (E'CM', E'Kamerun');
INSERT INTO "list" ("id", "value") VALUES (E'CA', E'Kanada');
INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'Karaibet holandeze');
INSERT INTO "list" ("id", "value") VALUES (E'QA', E'Katar');
INSERT INTO "list" ("id", "value") VALUES (E'KZ', E'Kazakistan');
INSERT INTO "list" ("id", "value") VALUES (E'KE', E'Kenia');
INSERT INTO "list" ("id", "value") VALUES (E'CV', E'Kepi i Gjelbër');
INSERT INTO "list" ("id", "value") VALUES (E'CL', E'Kili');
INSERT INTO "list" ("id", "value") VALUES (E'CN', E'Kinë');
INSERT INTO "list" ("id", "value") VALUES (E'KG', E'Kirgizi');
INSERT INTO "list" ("id", "value") VALUES (E'KI', E'Kiribati');
INSERT INTO "list" ("id", "value") VALUES (E'CO', E'Kolumbi');
INSERT INTO "list" ("id", "value") VALUES (E'KM', E'Komore');
INSERT INTO "list" ("id", "value") VALUES (E'CG', E'Kongo-Brazavilë');
INSERT INTO "list" ("id", "value") VALUES (E'CD', E'Kongo-Kinshasa');
INSERT INTO "list" ("id", "value") VALUES (E'KR', E'Kore e Jugut');
INSERT INTO "list" ("id", "value") VALUES (E'KP', E'Kore e Veriut');
INSERT INTO "list" ("id", "value") VALUES (E'CR', E'Kosta-Rikë');
INSERT INTO "list" ("id", "value") VALUES (E'HR', E'Kroaci');
INSERT INTO "list" ("id", "value") VALUES (E'CU', E'Kubë');
INSERT INTO "list" ("id", "value") VALUES (E'CW', E'Kurasao');
INSERT INTO "list" ("id", "value") VALUES (E'KW', E'Kuvajt');
INSERT INTO "list" ("id", "value") VALUES (E'LA', E'Laos');
INSERT INTO "list" ("id", "value") VALUES (E'LS', E'Lesoto');
INSERT INTO "list" ("id", "value") VALUES (E'LV', E'Letoni');
INSERT INTO "list" ("id", "value") VALUES (E'LB', E'Liban');
INSERT INTO "list" ("id", "value") VALUES (E'LR', E'Liberi');
INSERT INTO "list" ("id", "value") VALUES (E'LY', E'Libi');
INSERT INTO "list" ("id", "value") VALUES (E'LI', E'Lihtenshtajn');
INSERT INTO "list" ("id", "value") VALUES (E'LT', E'Lituani');
INSERT INTO "list" ("id", "value") VALUES (E'LU', E'Luksemburg');
INSERT INTO "list" ("id", "value") VALUES (E'MG', E'Madagaskar');
INSERT INTO "list" ("id", "value") VALUES (E'YT', E'Majotë');
INSERT INTO "list" ("id", "value") VALUES (E'ME', E'Mal i Zi');
INSERT INTO "list" ("id", "value") VALUES (E'MY', E'Malajzi');
INSERT INTO "list" ("id", "value") VALUES (E'MW', E'Malavi');
INSERT INTO "list" ("id", "value") VALUES (E'MV', E'Maldive');
INSERT INTO "list" ("id", "value") VALUES (E'ML', E'Mali');
INSERT INTO "list" ("id", "value") VALUES (E'MT', E'Maltë');
INSERT INTO "list" ("id", "value") VALUES (E'MK', E'Maqedonia e Veriut');
INSERT INTO "list" ("id", "value") VALUES (E'MA', E'Marok');
INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'Martinikë');
INSERT INTO "list" ("id", "value") VALUES (E'MR', E'Mauritani');
INSERT INTO "list" ("id", "value") VALUES (E'MU', E'Mauritius');
INSERT INTO "list" ("id", "value") VALUES (E'GB', E'Mbretëria e Bashkuar');
INSERT INTO "list" ("id", "value") VALUES (E'MX', E'Meksikë');
INSERT INTO "list" ("id", "value") VALUES (E'MM', E'Mianmar (Burmë)');
INSERT INTO "list" ("id", "value") VALUES (E'FM', E'Mikronezi');
INSERT INTO "list" ("id", "value") VALUES (E'MD', E'Moldavi');
INSERT INTO "list" ("id", "value") VALUES (E'MC', E'Monako');
INSERT INTO "list" ("id", "value") VALUES (E'MN', E'Mongoli');
INSERT INTO "list" ("id", "value") VALUES (E'MS', E'Montserat');
INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'Mozambik');
INSERT INTO "list" ("id", "value") VALUES (E'NA', E'Namibi');
INSERT INTO "list" ("id", "value") VALUES (E'NR', E'Nauru');
INSERT INTO "list" ("id", "value") VALUES (E'NP', E'Nepal');
INSERT INTO "list" ("id", "value") VALUES (E'NE', E'Niger');
INSERT INTO "list" ("id", "value") VALUES (E'NG', E'Nigeri');
INSERT INTO "list" ("id", "value") VALUES (E'NI', E'Nikaragua');
INSERT INTO "list" ("id", "value") VALUES (E'NU', E'Niue');
INSERT INTO "list" ("id", "value") VALUES (E'NO', E'Norvegji');
INSERT INTO "list" ("id", "value") VALUES (E'OM', E'Oman');
INSERT INTO "list" ("id", "value") VALUES (E'PK', E'Pakistan');
INSERT INTO "list" ("id", "value") VALUES (E'PW', E'Palau');
INSERT INTO "list" ("id", "value") VALUES (E'PA', E'Panama');
INSERT INTO "list" ("id", "value") VALUES (E'PY', E'Paraguai');
INSERT INTO "list" ("id", "value") VALUES (E'PE', E'Peru');
INSERT INTO "list" ("id", "value") VALUES (E'PF', E'Polinezia Franceze');
INSERT INTO "list" ("id", "value") VALUES (E'PL', E'Poloni');
INSERT INTO "list" ("id", "value") VALUES (E'PR', E'Porto-Riko');
INSERT INTO "list" ("id", "value") VALUES (E'PT', E'Portugali');
INSERT INTO "list" ("id", "value") VALUES (E'CY', E'Qipro');
INSERT INTO "list" ("id", "value") VALUES (E'DO', E'Republika Dominikane');
INSERT INTO "list" ("id", "value") VALUES (E'CF', E'Republika e Afrikës Qendrore');
INSERT INTO "list" ("id", "value") VALUES (E'RE', E'Reunion');
INSERT INTO "list" ("id", "value") VALUES (E'HK', E'RPA i Hong-Kongut');
INSERT INTO "list" ("id", "value") VALUES (E'MO', E'RPA i Makaos');
INSERT INTO "list" ("id", "value") VALUES (E'RW', E'Ruandë');
INSERT INTO "list" ("id", "value") VALUES (E'RO', E'Rumani');
INSERT INTO "list" ("id", "value") VALUES (E'RU', E'Rusi');
INSERT INTO "list" ("id", "value") VALUES (E'EH', E'Saharaja Perëndimore');
INSERT INTO "list" ("id", "value") VALUES (E'SV', E'Salvador');
INSERT INTO "list" ("id", "value") VALUES (E'WS', E'Samoa');
INSERT INTO "list" ("id", "value") VALUES (E'AS', E'Samoa Amerikane');
INSERT INTO "list" ("id", "value") VALUES (E'SM', E'San-Marino');
INSERT INTO "list" ("id", "value") VALUES (E'ST', E'Sao-Tome e Principe');
INSERT INTO "list" ("id", "value") VALUES (E'SC', E'Sejshelle');
INSERT INTO "list" ("id", "value") VALUES (E'BL', E'Sen-Bartelemi');
INSERT INTO "list" ("id", "value") VALUES (E'MF', E'Sen-Marten');
INSERT INTO "list" ("id", "value") VALUES (E'SN', E'Senegal');
INSERT INTO "list" ("id", "value") VALUES (E'RS', E'Serbi');
INSERT INTO "list" ("id", "value") VALUES (E'SL', E'Sierra-Leone');
INSERT INTO "list" ("id", "value") VALUES (E'SG', E'Singapor');
INSERT INTO "list" ("id", "value") VALUES (E'SX', E'Sint-Marten');
INSERT INTO "list" ("id", "value") VALUES (E'SY', E'Siri');
INSERT INTO "list" ("id", "value") VALUES (E'SK', E'Sllovaki');
INSERT INTO "list" ("id", "value") VALUES (E'SI', E'Slloveni');
INSERT INTO "list" ("id", "value") VALUES (E'SO', E'Somali');
INSERT INTO "list" ("id", "value") VALUES (E'ES', E'Spanjë');
INSERT INTO "list" ("id", "value") VALUES (E'LK', E'Sri-Lankë');
INSERT INTO "list" ("id", "value") VALUES (E'SD', E'Sudan');
INSERT INTO "list" ("id", "value") VALUES (E'SS', E'Sudani i Jugut');
INSERT INTO "list" ("id", "value") VALUES (E'SE', E'Suedi');
INSERT INTO "list" ("id", "value") VALUES (E'SR', E'Surinami');
INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'Svalbard e Jan-Majen');
INSERT INTO "list" ("id", "value") VALUES (E'US', E'SHBA');
INSERT INTO "list" ("id", "value") VALUES (E'SH', E'Shën-Elenë');
INSERT INTO "list" ("id", "value") VALUES (E'KN', E'Shën-Kits dhe Nevis');
INSERT INTO "list" ("id", "value") VALUES (E'LC', E'Shën-Luçia');
INSERT INTO "list" ("id", "value") VALUES (E'PM', E'Shën-Pier dhe Mikelon');
INSERT INTO "list" ("id", "value") VALUES (E'VC', E'Shën-Vincent dhe Grenadine');
INSERT INTO "list" ("id", "value") VALUES (E'AL', E'Shqipëri');
INSERT INTO "list" ("id", "value") VALUES (E'TH', E'Tajlandë');
INSERT INTO "list" ("id", "value") VALUES (E'TW', E'Tajvan');
INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'Tanzani');
INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'Taxhikistan');
INSERT INTO "list" ("id", "value") VALUES (E'TF', E'Territoret Jugore Franceze');
INSERT INTO "list" ("id", "value") VALUES (E'PS', E'Territoret Palestineze');
INSERT INTO "list" ("id", "value") VALUES (E'IO', E'Territori Britanik i Oqeanit Indian');
INSERT INTO "list" ("id", "value") VALUES (E'TL', E'Timor-Leste');
INSERT INTO "list" ("id", "value") VALUES (E'TG', E'Togo');
INSERT INTO "list" ("id", "value") VALUES (E'TK', E'Tokelau');
INSERT INTO "list" ("id", "value") VALUES (E'TO', E'Tonga');
INSERT INTO "list" ("id", "value") VALUES (E'TT', E'Trinidad e Tobago');
INSERT INTO "list" ("id", "value") VALUES (E'TN', E'Tunizi');
INSERT INTO "list" ("id", "value") VALUES (E'TM', E'Turkmenistan');
INSERT INTO "list" ("id", "value") VALUES (E'TR', E'Turqi');
INSERT INTO "list" ("id", "value") VALUES (E'TV', E'Tuvalu');
INSERT INTO "list" ("id", "value") VALUES (E'UG', E'Ugandë');
INSERT INTO "list" ("id", "value") VALUES (E'UA', E'Ukrainë');
INSERT INTO "list" ("id", "value") VALUES (E'WF', E'Uollis e Futuna');
INSERT INTO "list" ("id", "value") VALUES (E'UY', E'Uruguai');
INSERT INTO "list" ("id", "value") VALUES (E'UZ', E'Uzbekistan');
INSERT INTO "list" ("id", "value") VALUES (E'VU', E'Vanuatu');
INSERT INTO "list" ("id", "value") VALUES (E'VA', E'Vatikan');
INSERT INTO "list" ("id", "value") VALUES (E'VE', E'Venezuelë');
INSERT INTO "list" ("id", "value") VALUES (E'VN', E'Vietnam');
INSERT INTO "list" ("id", "value") VALUES (E'JM', E'Xhamajkë');
INSERT INTO "list" ("id", "value") VALUES (E'JE', E'Xhersej');
INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'Xhibuti');
INSERT INTO "list" ("id", "value") VALUES (E'GS', E'Xhorxha Jugore dhe Ishujt Senduiçë të Jugut');
INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'Zambi');
INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'Zelandë e Re');
INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'Zimbabve');
INSERT INTO "list" ("id", "value") VALUES (E'CH', E'Zvicër');