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'Afganujo');
INSERT INTO "list" ("id", "value") VALUES (E'AX', E'Åland Islands');
INSERT INTO "list" ("id", "value") VALUES (E'AL', E'Albanujo');
INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'Alĝerio');
INSERT INTO "list" ("id", "value") VALUES (E'AS', E'American Samoa');
INSERT INTO "list" ("id", "value") VALUES (E'AD', E'Andoro');
INSERT INTO "list" ("id", "value") VALUES (E'AO', E'Angolo');
INSERT INTO "list" ("id", "value") VALUES (E'AI', E'Angvilo');
INSERT INTO "list" ("id", "value") VALUES (E'AQ', E'Antarkto');
INSERT INTO "list" ("id", "value") VALUES (E'AG', E'Antigvo-Barbudo');
INSERT INTO "list" ("id", "value") VALUES (E'AR', E'Argentino');
INSERT INTO "list" ("id", "value") VALUES (E'AM', E'Armenujo');
INSERT INTO "list" ("id", "value") VALUES (E'AW', E'Arubo');
INSERT INTO "list" ("id", "value") VALUES (E'AU', E'Aŭstralio');
INSERT INTO "list" ("id", "value") VALUES (E'AT', E'Aŭstrujo');
INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'Azerbajĝano');
INSERT INTO "list" ("id", "value") VALUES (E'BS', E'Bahamoj');
INSERT INTO "list" ("id", "value") VALUES (E'BD', E'Bangladeŝo');
INSERT INTO "list" ("id", "value") VALUES (E'BB', E'Barbado');
INSERT INTO "list" ("id", "value") VALUES (E'BH', E'Barejno');
INSERT INTO "list" ("id", "value") VALUES (E'PW', E'Belaŭo');
INSERT INTO "list" ("id", "value") VALUES (E'BE', E'Belgujo');
INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'Belizo');
INSERT INTO "list" ("id", "value") VALUES (E'BY', E'Belorusujo');
INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'Benino');
INSERT INTO "list" ("id", "value") VALUES (E'BM', E'Bermudoj');
INSERT INTO "list" ("id", "value") VALUES (E'BW', E'Bocvano');
INSERT INTO "list" ("id", "value") VALUES (E'BO', E'Bolivio');
INSERT INTO "list" ("id", "value") VALUES (E'BA', E'Bosnio-Hercegovino');
INSERT INTO "list" ("id", "value") VALUES (E'BV', E'Bouvet Island');
INSERT INTO "list" ("id", "value") VALUES (E'BR', E'Brazilo');
INSERT INTO "list" ("id", "value") VALUES (E'IO', E'Brita Hindoceana Teritorio');
INSERT INTO "list" ("id", "value") VALUES (E'VG', E'Britaj Virgulininsuloj');
INSERT INTO "list" ("id", "value") VALUES (E'BN', E'Brunejo');
INSERT INTO "list" ("id", "value") VALUES (E'BG', E'Bulgarujo');
INSERT INTO "list" ("id", "value") VALUES (E'BF', E'Burkino');
INSERT INTO "list" ("id", "value") VALUES (E'BI', E'Burundo');
INSERT INTO "list" ("id", "value") VALUES (E'BT', E'Butano');
INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'Caribbean Netherlands');
INSERT INTO "list" ("id", "value") VALUES (E'CF', E'Centr-Afrika Respubliko');
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'CD', E'Congo - Kinshasa');
INSERT INTO "list" ("id", "value") VALUES (E'CW', E'Curaçao');
INSERT INTO "list" ("id", "value") VALUES (E'TD', E'Ĉado');
INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'Ĉeĥujo');
INSERT INTO "list" ("id", "value") VALUES (E'CL', E'Ĉilio');
INSERT INTO "list" ("id", "value") VALUES (E'CN', E'Ĉinujo');
INSERT INTO "list" ("id", "value") VALUES (E'DK', E'Danujo');
INSERT INTO "list" ("id", "value") VALUES (E'DO', E'Domingo');
INSERT INTO "list" ("id", "value") VALUES (E'DM', E'Dominiko');
INSERT INTO "list" ("id", "value") VALUES (E'CI', E'Ebur-Bordo');
INSERT INTO "list" ("id", "value") VALUES (E'EG', E'Egipto');
INSERT INTO "list" ("id", "value") VALUES (E'EC', E'Ekvadoro');
INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'Ekvatora Gvineo');
INSERT INTO "list" ("id", "value") VALUES (E'ER', E'Eritreo');
INSERT INTO "list" ("id", "value") VALUES (E'EE', E'Estonujo');
INSERT INTO "list" ("id", "value") VALUES (E'ET', E'Etiopujo');
INSERT INTO "list" ("id", "value") VALUES (E'FK', E'Falkland Islands');
INSERT INTO "list" ("id", "value") VALUES (E'FO', E'Ferooj');
INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'Fiĝoj');
INSERT INTO "list" ("id", "value") VALUES (E'PH', E'Filipinoj');
INSERT INTO "list" ("id", "value") VALUES (E'FI', E'Finnlando');
INSERT INTO "list" ("id", "value") VALUES (E'GF', E'Franca Gviano');
INSERT INTO "list" ("id", "value") VALUES (E'PF', E'Franca Polinezio');
INSERT INTO "list" ("id", "value") VALUES (E'FR', E'Francujo');
INSERT INTO "list" ("id", "value") VALUES (E'TF', E'French Southern Territories');
INSERT INTO "list" ("id", "value") VALUES (E'GA', E'Gabono');
INSERT INTO "list" ("id", "value") VALUES (E'GM', E'Gambio');
INSERT INTO "list" ("id", "value") VALUES (E'GH', E'Ganao');
INSERT INTO "list" ("id", "value") VALUES (E'DE', E'Germanujo');
INSERT INTO "list" ("id", "value") VALUES (E'GR', E'Grekujo');
INSERT INTO "list" ("id", "value") VALUES (E'GD', E'Grenado');
INSERT INTO "list" ("id", "value") VALUES (E'GL', E'Gronlando');
INSERT INTO "list" ("id", "value") VALUES (E'GG', E'Guernsey');
INSERT INTO "list" ("id", "value") VALUES (E'GY', E'Gujano');
INSERT INTO "list" ("id", "value") VALUES (E'GP', E'Gvadelupo');
INSERT INTO "list" ("id", "value") VALUES (E'GU', E'Gvamo');
INSERT INTO "list" ("id", "value") VALUES (E'GT', E'Gvatemalo');
INSERT INTO "list" ("id", "value") VALUES (E'GN', E'Gvineo');
INSERT INTO "list" ("id", "value") VALUES (E'GW', E'Gvineo-Bisaŭo');
INSERT INTO "list" ("id", "value") VALUES (E'GI', E'Ĝibraltaro');
INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'Ĝibutio');
INSERT INTO "list" ("id", "value") VALUES (E'HT', E'Haitio');
INSERT INTO "list" ("id", "value") VALUES (E'HM', E'Herda kaj Makdonaldaj Insuloj');
INSERT INTO "list" ("id", "value") VALUES (E'IN', E'Hindujo');
INSERT INTO "list" ("id", "value") VALUES (E'ES', E'Hispanujo');
INSERT INTO "list" ("id", "value") VALUES (E'HN', E'Honduro');
INSERT INTO "list" ("id", "value") VALUES (E'HK', E'Hong Kong SAR China');
INSERT INTO "list" ("id", "value") VALUES (E'HU', E'Hungarujo');
INSERT INTO "list" ("id", "value") VALUES (E'ID', E'Indonezio');
INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'Irako');
INSERT INTO "list" ("id", "value") VALUES (E'IR', E'Irano');
INSERT INTO "list" ("id", "value") VALUES (E'IE', E'Irlando');
INSERT INTO "list" ("id", "value") VALUES (E'IS', E'Islando');
INSERT INTO "list" ("id", "value") VALUES (E'IM', E'Isle of Man');
INSERT INTO "list" ("id", "value") VALUES (E'IL', E'Israelo');
INSERT INTO "list" ("id", "value") VALUES (E'IT', E'Italujo');
INSERT INTO "list" ("id", "value") VALUES (E'JM', E'Jamajko');
INSERT INTO "list" ("id", "value") VALUES (E'JP', E'Japanujo');
INSERT INTO "list" ("id", "value") VALUES (E'YE', E'Jemeno');
INSERT INTO "list" ("id", "value") VALUES (E'JE', E'Jersey');
INSERT INTO "list" ("id", "value") VALUES (E'JO', E'Jordanio');
INSERT INTO "list" ("id", "value") VALUES (E'CV', E'Kabo-Verdo');
INSERT INTO "list" ("id", "value") VALUES (E'KH', E'Kamboĝo');
INSERT INTO "list" ("id", "value") VALUES (E'CM', E'Kameruno');
INSERT INTO "list" ("id", "value") VALUES (E'CA', E'Kanado');
INSERT INTO "list" ("id", "value") VALUES (E'GE', E'Kartvelujo');
INSERT INTO "list" ("id", "value") VALUES (E'QA', E'Kataro');
INSERT INTO "list" ("id", "value") VALUES (E'KZ', E'Kazaĥstano');
INSERT INTO "list" ("id", "value") VALUES (E'KY', E'Kejmanoj');
INSERT INTO "list" ("id", "value") VALUES (E'KE', E'Kenjo');
INSERT INTO "list" ("id", "value") VALUES (E'CY', E'Kipro');
INSERT INTO "list" ("id", "value") VALUES (E'KG', E'Kirgizistano');
INSERT INTO "list" ("id", "value") VALUES (E'KI', E'Kiribato');
INSERT INTO "list" ("id", "value") VALUES (E'CO', E'Kolombio');
INSERT INTO "list" ("id", "value") VALUES (E'KM', E'Komoroj');
INSERT INTO "list" ("id", "value") VALUES (E'CG', E'Kongolo');
INSERT INTO "list" ("id", "value") VALUES (E'CR', E'Kostariko');
INSERT INTO "list" ("id", "value") VALUES (E'HR', E'Kroatujo');
INSERT INTO "list" ("id", "value") VALUES (E'CU', E'Kubo');
INSERT INTO "list" ("id", "value") VALUES (E'CK', E'Kukinsuloj');
INSERT INTO "list" ("id", "value") VALUES (E'KW', E'Kuvajto');
INSERT INTO "list" ("id", "value") VALUES (E'LA', E'Laoso');
INSERT INTO "list" ("id", "value") VALUES (E'LV', E'Latvujo');
INSERT INTO "list" ("id", "value") VALUES (E'LS', E'Lesoto');
INSERT INTO "list" ("id", "value") VALUES (E'LB', E'Libano');
INSERT INTO "list" ("id", "value") VALUES (E'LR', E'Liberio');
INSERT INTO "list" ("id", "value") VALUES (E'LY', E'Libio');
INSERT INTO "list" ("id", "value") VALUES (E'LI', E'Liĥtenŝtejno');
INSERT INTO "list" ("id", "value") VALUES (E'LT', E'Litovujo');
INSERT INTO "list" ("id", "value") VALUES (E'LU', E'Luksemburgo');
INSERT INTO "list" ("id", "value") VALUES (E'MO', E'Macao SAR China');
INSERT INTO "list" ("id", "value") VALUES (E'MG', E'Madagaskaro');
INSERT INTO "list" ("id", "value") VALUES (E'YT', E'Majoto');
INSERT INTO "list" ("id", "value") VALUES (E'MY', E'Malajzio');
INSERT INTO "list" ("id", "value") VALUES (E'MW', E'Malavio');
INSERT INTO "list" ("id", "value") VALUES (E'MV', E'Maldivoj');
INSERT INTO "list" ("id", "value") VALUES (E'ML', E'Malio');
INSERT INTO "list" ("id", "value") VALUES (E'MT', E'Malto');
INSERT INTO "list" ("id", "value") VALUES (E'MA', E'Maroko');
INSERT INTO "list" ("id", "value") VALUES (E'MH', E'Marŝaloj');
INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'Martiniko');
INSERT INTO "list" ("id", "value") VALUES (E'MU', E'Maŭricio');
INSERT INTO "list" ("id", "value") VALUES (E'MR', E'Maŭritanujo');
INSERT INTO "list" ("id", "value") VALUES (E'MX', E'Meksiko');
INSERT INTO "list" ("id", "value") VALUES (E'FM', E'Mikronezio');
INSERT INTO "list" ("id", "value") VALUES (E'MM', E'Mjanmao');
INSERT INTO "list" ("id", "value") VALUES (E'MD', E'Moldavujo');
INSERT INTO "list" ("id", "value") VALUES (E'MC', E'Monako');
INSERT INTO "list" ("id", "value") VALUES (E'MN', E'Mongolujo');
INSERT INTO "list" ("id", "value") VALUES (E'ME', E'Montenegro');
INSERT INTO "list" ("id", "value") VALUES (E'MS', E'Montserrat');
INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'Mozambiko');
INSERT INTO "list" ("id", "value") VALUES (E'NA', E'Namibio');
INSERT INTO "list" ("id", "value") VALUES (E'NR', E'Nauro');
INSERT INTO "list" ("id", "value") VALUES (E'NL', E'Nederlando');
INSERT INTO "list" ("id", "value") VALUES (E'NP', E'Nepalo');
INSERT INTO "list" ("id", "value") VALUES (E'NG', E'Niĝerio');
INSERT INTO "list" ("id", "value") VALUES (E'NE', E'Niĝero');
INSERT INTO "list" ("id", "value") VALUES (E'NI', E'Nikaragvo');
INSERT INTO "list" ("id", "value") VALUES (E'NU', E'Niuo');
INSERT INTO "list" ("id", "value") VALUES (E'KP', E'Nord-Koreo');
INSERT INTO "list" ("id", "value") VALUES (E'MP', E'Nord-Marianoj');
INSERT INTO "list" ("id", "value") VALUES (E'NF', E'Norfolkinsulo');
INSERT INTO "list" ("id", "value") VALUES (E'MK', E'North Macedonia');
INSERT INTO "list" ("id", "value") VALUES (E'NO', E'Norvegujo');
INSERT INTO "list" ("id", "value") VALUES (E'NC', E'Nov-Kaledonio');
INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'Nov-Zelando');
INSERT INTO "list" ("id", "value") VALUES (E'EH', E'Okcidenta Saharo');
INSERT INTO "list" ("id", "value") VALUES (E'OM', E'Omano');
INSERT INTO "list" ("id", "value") VALUES (E'PK', E'Pakistano');
INSERT INTO "list" ("id", "value") VALUES (E'PS', E'Palestinian Territories');
INSERT INTO "list" ("id", "value") VALUES (E'PA', E'Panamo');
INSERT INTO "list" ("id", "value") VALUES (E'PG', E'Papuo-Nov-Gvineo');
INSERT INTO "list" ("id", "value") VALUES (E'PY', E'Paragvajo');
INSERT INTO "list" ("id", "value") VALUES (E'PE', E'Peruo');
INSERT INTO "list" ("id", "value") VALUES (E'PN', E'Pitkarna Insulo');
INSERT INTO "list" ("id", "value") VALUES (E'PL', E'Pollando');
INSERT INTO "list" ("id", "value") VALUES (E'PT', E'Portugalujo');
INSERT INTO "list" ("id", "value") VALUES (E'PR', E'Puerto-Riko');
INSERT INTO "list" ("id", "value") VALUES (E'RE', E'Reunio');
INSERT INTO "list" ("id", "value") VALUES (E'RW', E'Ruando');
INSERT INTO "list" ("id", "value") VALUES (E'RO', E'Rumanujo');
INSERT INTO "list" ("id", "value") VALUES (E'RU', E'Rusujo');
INSERT INTO "list" ("id", "value") VALUES (E'SB', E'Salomonoj');
INSERT INTO "list" ("id", "value") VALUES (E'SV', E'Salvadoro');
INSERT INTO "list" ("id", "value") VALUES (E'WS', E'Samoo');
INSERT INTO "list" ("id", "value") VALUES (E'SM', E'San-Marino');
INSERT INTO "list" ("id", "value") VALUES (E'ST', E'Sao-Tomeo kaj Principeo');
INSERT INTO "list" ("id", "value") VALUES (E'SA', E'Saŭda Arabujo');
INSERT INTO "list" ("id", "value") VALUES (E'SC', E'Sejŝeloj');
INSERT INTO "list" ("id", "value") VALUES (E'SN', E'Senegalo');
INSERT INTO "list" ("id", "value") VALUES (E'SH', E'Sent-Heleno');
INSERT INTO "list" ("id", "value") VALUES (E'KN', E'Sent-Kristofo kaj Neviso');
INSERT INTO "list" ("id", "value") VALUES (E'LC', E'Sent-Lucio');
INSERT INTO "list" ("id", "value") VALUES (E'PM', E'Sent-Piero kaj Mikelono');
INSERT INTO "list" ("id", "value") VALUES (E'VC', E'Sent-Vincento kaj la Grenadinoj');
INSERT INTO "list" ("id", "value") VALUES (E'RS', E'Serbia');
INSERT INTO "list" ("id", "value") VALUES (E'SL', E'Siera-Leono');
INSERT INTO "list" ("id", "value") VALUES (E'SG', E'Singapuro');
INSERT INTO "list" ("id", "value") VALUES (E'SX', E'Sint Maarten');
INSERT INTO "list" ("id", "value") VALUES (E'SY', E'Sirio');
INSERT INTO "list" ("id", "value") VALUES (E'SK', E'Slovakujo');
INSERT INTO "list" ("id", "value") VALUES (E'SI', E'Slovenujo');
INSERT INTO "list" ("id", "value") VALUES (E'SO', E'Somalujo');
INSERT INTO "list" ("id", "value") VALUES (E'SS', E'South Sudan');
INSERT INTO "list" ("id", "value") VALUES (E'LK', E'Sri-Lanko');
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'ZA', E'Sud-Afriko');
INSERT INTO "list" ("id", "value") VALUES (E'GS', E'Sud-Georgio kaj Sud-Sandviĉinsuloj');
INSERT INTO "list" ("id", "value") VALUES (E'KR', E'Sud-Koreo');
INSERT INTO "list" ("id", "value") VALUES (E'SD', E'Sudano');
INSERT INTO "list" ("id", "value") VALUES (E'SR', E'Surinamo');
INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'Svalbardo kaj Jan-Majen-insulo');
INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'Svazilando');
INSERT INTO "list" ("id", "value") VALUES (E'SE', E'Svedujo');
INSERT INTO "list" ("id", "value") VALUES (E'CH', E'Svisujo');
INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'Taĝikujo');
INSERT INTO "list" ("id", "value") VALUES (E'TH', E'Tajlando');
INSERT INTO "list" ("id", "value") VALUES (E'TW', E'Tajvano');
INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'Tanzanio');
INSERT INTO "list" ("id", "value") VALUES (E'TL', E'Timor-Leste');
INSERT INTO "list" ("id", "value") VALUES (E'TG', E'Togolo');
INSERT INTO "list" ("id", "value") VALUES (E'TK', E'Tokelau');
INSERT INTO "list" ("id", "value") VALUES (E'TO', E'Tongo');
INSERT INTO "list" ("id", "value") VALUES (E'TT', E'Trinidado kaj Tobago');
INSERT INTO "list" ("id", "value") VALUES (E'TN', E'Tunizio');
INSERT INTO "list" ("id", "value") VALUES (E'TM', E'Turkmenujo');
INSERT INTO "list" ("id", "value") VALUES (E'TC', E'Turks & Caicos Islands');
INSERT INTO "list" ("id", "value") VALUES (E'TR', E'Turkujo');
INSERT INTO "list" ("id", "value") VALUES (E'TV', E'Tuvalo');
INSERT INTO "list" ("id", "value") VALUES (E'UG', E'Ugando');
INSERT INTO "list" ("id", "value") VALUES (E'UA', E'Ukrajno');
INSERT INTO "list" ("id", "value") VALUES (E'GB', E'Unuiĝinta Reĝlando');
INSERT INTO "list" ("id", "value") VALUES (E'AE', E'Unuiĝintaj Arabaj Emirlandoj');
INSERT INTO "list" ("id", "value") VALUES (E'UY', E'Urugvajo');
INSERT INTO "list" ("id", "value") VALUES (E'UM', E'Usonaj malgrandaj insuloj');
INSERT INTO "list" ("id", "value") VALUES (E'VI', E'Usonaj Virgulininsuloj');
INSERT INTO "list" ("id", "value") VALUES (E'US', E'Usono');
INSERT INTO "list" ("id", "value") VALUES (E'UZ', E'Uzbekujo');
INSERT INTO "list" ("id", "value") VALUES (E'WF', E'Valiso kaj Futuno');
INSERT INTO "list" ("id", "value") VALUES (E'VU', E'Vanuatuo');
INSERT INTO "list" ("id", "value") VALUES (E'VA', E'Vatikano');
INSERT INTO "list" ("id", "value") VALUES (E'VE', E'Venezuelo');
INSERT INTO "list" ("id", "value") VALUES (E'VN', E'Vjetnamo');
INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'Zambio');
INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'Zimbabvo');
