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'AL', E'Albània');
INSERT INTO "list" ("id", "value") VALUES (E'DE', E'Alemanya');
INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'Algèria');
INSERT INTO "list" ("id", "value") VALUES (E'AD', E'Andorra');
INSERT INTO "list" ("id", "value") VALUES (E'AO', E'Angola');
INSERT INTO "list" ("id", "value") VALUES (E'AI', E'Anguilla');
INSERT INTO "list" ("id", "value") VALUES (E'AQ', E'Antàrtida');
INSERT INTO "list" ("id", "value") VALUES (E'AG', E'Antigua i Barbuda');
INSERT INTO "list" ("id", "value") VALUES (E'SA', E'Aràbia Saudita');
INSERT INTO "list" ("id", "value") VALUES (E'AR', E'Argentina');
INSERT INTO "list" ("id", "value") VALUES (E'AM', E'Armènia');
INSERT INTO "list" ("id", "value") VALUES (E'AW', E'Aruba');
INSERT INTO "list" ("id", "value") VALUES (E'AU', E'Austràlia');
INSERT INTO "list" ("id", "value") VALUES (E'AT', E'Àustria');
INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'Azerbaidjan');
INSERT INTO "list" ("id", "value") VALUES (E'BS', E'Bahames');
INSERT INTO "list" ("id", "value") VALUES (E'BH', E'Bahrain');
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'BY', E'Belarús');
INSERT INTO "list" ("id", "value") VALUES (E'BE', E'Bèlgica');
INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'Belize');
INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'Benín');
INSERT INTO "list" ("id", "value") VALUES (E'BM', E'Bermudes');
INSERT INTO "list" ("id", "value") VALUES (E'BT', E'Bhutan');
INSERT INTO "list" ("id", "value") VALUES (E'BO', E'Bolívia');
INSERT INTO "list" ("id", "value") VALUES (E'BA', E'Bòsnia i Hercegovina');
INSERT INTO "list" ("id", "value") VALUES (E'BW', E'Botswana');
INSERT INTO "list" ("id", "value") VALUES (E'BV', E'Bouvet');
INSERT INTO "list" ("id", "value") VALUES (E'BR', E'Brasil');
INSERT INTO "list" ("id", "value") VALUES (E'BN', E'Brunei');
INSERT INTO "list" ("id", "value") VALUES (E'BG', E'Bulgària');
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'KH', E'Cambodja');
INSERT INTO "list" ("id", "value") VALUES (E'CM', E'Camerun');
INSERT INTO "list" ("id", "value") VALUES (E'CA', E'Canadà');
INSERT INTO "list" ("id", "value") VALUES (E'CV', E'Cap Verd');
INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'Carib Neerlandès');
INSERT INTO "list" ("id", "value") VALUES (E'VA', E'Ciutat del Vaticà');
INSERT INTO "list" ("id", "value") VALUES (E'CO', E'Colòmbia');
INSERT INTO "list" ("id", "value") VALUES (E'KM', E'Comores');
INSERT INTO "list" ("id", "value") VALUES (E'CG', E'Congo - Brazzaville');
INSERT INTO "list" ("id", "value") VALUES (E'CD', E'Congo - Kinshasa');
INSERT INTO "list" ("id", "value") VALUES (E'KP', E'Corea del Nord');
INSERT INTO "list" ("id", "value") VALUES (E'KR', E'Corea del Sud');
INSERT INTO "list" ("id", "value") VALUES (E'CR', E'Costa Rica');
INSERT INTO "list" ("id", "value") VALUES (E'CI', E'Côte d’Ivoire');
INSERT INTO "list" ("id", "value") VALUES (E'HR', E'Croàcia');
INSERT INTO "list" ("id", "value") VALUES (E'CU', E'Cuba');
INSERT INTO "list" ("id", "value") VALUES (E'CW', E'Curaçao');
INSERT INTO "list" ("id", "value") VALUES (E'DK', E'Dinamarca');
INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'Djibouti');
INSERT INTO "list" ("id", "value") VALUES (E'DM', E'Dominica');
INSERT INTO "list" ("id", "value") VALUES (E'EG', E'Egipte');
INSERT INTO "list" ("id", "value") VALUES (E'SV', E'El Salvador');
INSERT INTO "list" ("id", "value") VALUES (E'AE', E'Emirats Àrabs Units');
INSERT INTO "list" ("id", "value") VALUES (E'EC', E'Equador');
INSERT INTO "list" ("id", "value") VALUES (E'ER', E'Eritrea');
INSERT INTO "list" ("id", "value") VALUES (E'SK', E'Eslovàquia');
INSERT INTO "list" ("id", "value") VALUES (E'SI', E'Eslovènia');
INSERT INTO "list" ("id", "value") VALUES (E'ES', E'Espanya');
INSERT INTO "list" ("id", "value") VALUES (E'US', E'Estats Units');
INSERT INTO "list" ("id", "value") VALUES (E'EE', E'Estònia');
INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'eSwatini');
INSERT INTO "list" ("id", "value") VALUES (E'ET', E'Etiòpia');
INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'Fiji');
INSERT INTO "list" ("id", "value") VALUES (E'PH', E'Filipines');
INSERT INTO "list" ("id", "value") VALUES (E'FI', E'Finlàndia');
INSERT INTO "list" ("id", "value") VALUES (E'FR', E'França');
INSERT INTO "list" ("id", "value") VALUES (E'GA', E'Gabon');
INSERT INTO "list" ("id", "value") VALUES (E'GM', E'Gàmbia');
INSERT INTO "list" ("id", "value") VALUES (E'GE', E'Geòrgia');
INSERT INTO "list" ("id", "value") VALUES (E'GH', E'Ghana');
INSERT INTO "list" ("id", "value") VALUES (E'GI', E'Gibraltar');
INSERT INTO "list" ("id", "value") VALUES (E'GR', E'Grècia');
INSERT INTO "list" ("id", "value") VALUES (E'GD', E'Grenada');
INSERT INTO "list" ("id", "value") VALUES (E'GL', E'Groenlàndia');
INSERT INTO "list" ("id", "value") VALUES (E'GP', E'Guadeloupe');
INSERT INTO "list" ("id", "value") VALUES (E'GF', E'Guaiana Francesa');
INSERT INTO "list" ("id", "value") VALUES (E'GU', E'Guam');
INSERT INTO "list" ("id", "value") VALUES (E'GT', E'Guatemala');
INSERT INTO "list" ("id", "value") VALUES (E'GG', E'Guernsey');
INSERT INTO "list" ("id", "value") VALUES (E'GN', E'Guinea');
INSERT INTO "list" ("id", "value") VALUES (E'GW', E'Guinea Bissau');
INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'Guinea Equatorial');
INSERT INTO "list" ("id", "value") VALUES (E'GY', E'Guyana');
INSERT INTO "list" ("id", "value") VALUES (E'HT', E'Haití');
INSERT INTO "list" ("id", "value") VALUES (E'HN', E'Hondures');
INSERT INTO "list" ("id", "value") VALUES (E'HK', E'Hong Kong (RAE Xina)');
INSERT INTO "list" ("id", "value") VALUES (E'HU', E'Hongria');
INSERT INTO "list" ("id", "value") VALUES (E'YE', E'Iemen');
INSERT INTO "list" ("id", "value") VALUES (E'CX', E'Illa Christmas');
INSERT INTO "list" ("id", "value") VALUES (E'RE', E'Illa de la Reunió');
INSERT INTO "list" ("id", "value") VALUES (E'IM', E'Illa de Man');
INSERT INTO "list" ("id", "value") VALUES (E'HM', E'Illa Heard i Illes McDonald');
INSERT INTO "list" ("id", "value") VALUES (E'AX', E'Illes Åland');
INSERT INTO "list" ("id", "value") VALUES (E'KY', E'Illes Caiman');
INSERT INTO "list" ("id", "value") VALUES (E'CC', E'Illes Cocos');
INSERT INTO "list" ("id", "value") VALUES (E'CK', E'Illes Cook');
INSERT INTO "list" ("id", "value") VALUES (E'FO', E'Illes Fèroe');
INSERT INTO "list" ("id", "value") VALUES (E'GS', E'Illes Geòrgia del Sud i Sandwich del Sud');
INSERT INTO "list" ("id", "value") VALUES (E'FK', E'Illes Malvines');
INSERT INTO "list" ("id", "value") VALUES (E'MP', E'Illes Mariannes del Nord');
INSERT INTO "list" ("id", "value") VALUES (E'MH', E'Illes Marshall');
INSERT INTO "list" ("id", "value") VALUES (E'UM', E'Illes Perifèriques Menors dels EUA');
INSERT INTO "list" ("id", "value") VALUES (E'PN', E'Illes Pitcairn');
INSERT INTO "list" ("id", "value") VALUES (E'SB', E'Illes Salomó');
INSERT INTO "list" ("id", "value") VALUES (E'TC', E'Illes Turks i Caicos');
INSERT INTO "list" ("id", "value") VALUES (E'VG', E'Illes Verges Britàniques');
INSERT INTO "list" ("id", "value") VALUES (E'VI', E'Illes Verges Nord-americanes');
INSERT INTO "list" ("id", "value") VALUES (E'IN', E'Índia');
INSERT INTO "list" ("id", "value") VALUES (E'ID', E'Indonèsia');
INSERT INTO "list" ("id", "value") VALUES (E'IR', E'Iran');
INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'Iraq');
INSERT INTO "list" ("id", "value") VALUES (E'IE', E'Irlanda');
INSERT INTO "list" ("id", "value") VALUES (E'IS', E'Islàndia');
INSERT INTO "list" ("id", "value") VALUES (E'IL', E'Israel');
INSERT INTO "list" ("id", "value") VALUES (E'IT', E'Itàlia');
INSERT INTO "list" ("id", "value") VALUES (E'JM', E'Jamaica');
INSERT INTO "list" ("id", "value") VALUES (E'JP', E'Japó');
INSERT INTO "list" ("id", "value") VALUES (E'JE', E'Jersey');
INSERT INTO "list" ("id", "value") VALUES (E'JO', E'Jordània');
INSERT INTO "list" ("id", "value") VALUES (E'KZ', E'Kazakhstan');
INSERT INTO "list" ("id", "value") VALUES (E'KE', E'Kenya');
INSERT INTO "list" ("id", "value") VALUES (E'KG', E'Kirguizistan');
INSERT INTO "list" ("id", "value") VALUES (E'KI', E'Kiribati');
INSERT INTO "list" ("id", "value") VALUES (E'KW', E'Kuwait');
INSERT INTO "list" ("id", "value") VALUES (E'LA', E'Laos');
INSERT INTO "list" ("id", "value") VALUES (E'LS', E'Lesotho');
INSERT INTO "list" ("id", "value") VALUES (E'LV', E'Letònia');
INSERT INTO "list" ("id", "value") VALUES (E'LB', E'Líban');
INSERT INTO "list" ("id", "value") VALUES (E'LR', E'Libèria');
INSERT INTO "list" ("id", "value") VALUES (E'LY', E'Líbia');
INSERT INTO "list" ("id", "value") VALUES (E'LI', E'Liechtenstein');
INSERT INTO "list" ("id", "value") VALUES (E'LT', E'Lituània');
INSERT INTO "list" ("id", "value") VALUES (E'LU', E'Luxemburg');
INSERT INTO "list" ("id", "value") VALUES (E'MO', E'Macau (RAE Xina)');
INSERT INTO "list" ("id", "value") VALUES (E'MK', E'Macedònia del Nord');
INSERT INTO "list" ("id", "value") VALUES (E'MG', E'Madagascar');
INSERT INTO "list" ("id", "value") VALUES (E'MY', E'Malàisia');
INSERT INTO "list" ("id", "value") VALUES (E'MW', E'Malawi');
INSERT INTO "list" ("id", "value") VALUES (E'MV', E'Maldives');
INSERT INTO "list" ("id", "value") VALUES (E'ML', E'Mali');
INSERT INTO "list" ("id", "value") VALUES (E'MT', E'Malta');
INSERT INTO "list" ("id", "value") VALUES (E'MA', E'Marroc');
INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'Martinica');
INSERT INTO "list" ("id", "value") VALUES (E'MU', E'Maurici');
INSERT INTO "list" ("id", "value") VALUES (E'MR', E'Mauritània');
INSERT INTO "list" ("id", "value") VALUES (E'YT', E'Mayotte');
INSERT INTO "list" ("id", "value") VALUES (E'MX', E'Mèxic');
INSERT INTO "list" ("id", "value") VALUES (E'FM', E'Micronèsia');
INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'Moçambic');
INSERT INTO "list" ("id", "value") VALUES (E'MD', E'Moldàvia');
INSERT INTO "list" ("id", "value") VALUES (E'MC', E'Mònaco');
INSERT INTO "list" ("id", "value") VALUES (E'MN', E'Mongòlia');
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'MM', E'Myanmar (Birmània)');
INSERT INTO "list" ("id", "value") VALUES (E'NA', E'Namíbia');
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'NI', E'Nicaragua');
INSERT INTO "list" ("id", "value") VALUES (E'NE', E'Níger');
INSERT INTO "list" ("id", "value") VALUES (E'NG', E'Nigèria');
INSERT INTO "list" ("id", "value") VALUES (E'NU', E'Niue');
INSERT INTO "list" ("id", "value") VALUES (E'NF', E'Norfolk');
INSERT INTO "list" ("id", "value") VALUES (E'NO', E'Noruega');
INSERT INTO "list" ("id", "value") VALUES (E'NC', E'Nova Caledònia');
INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'Nova Zelanda');
INSERT INTO "list" ("id", "value") VALUES (E'OM', E'Oman');
INSERT INTO "list" ("id", "value") VALUES (E'NL', E'Països Baixos');
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'Panamà');
INSERT INTO "list" ("id", "value") VALUES (E'PG', E'Papua Nova Guinea');
INSERT INTO "list" ("id", "value") VALUES (E'PY', E'Paraguai');
INSERT INTO "list" ("id", "value") VALUES (E'PE', E'Perú');
INSERT INTO "list" ("id", "value") VALUES (E'PF', E'Polinèsia Francesa');
INSERT INTO "list" ("id", "value") VALUES (E'PL', E'Polònia');
INSERT INTO "list" ("id", "value") VALUES (E'PT', E'Portugal');
INSERT INTO "list" ("id", "value") VALUES (E'PR', E'Puerto Rico');
INSERT INTO "list" ("id", "value") VALUES (E'QA', E'Qatar');
INSERT INTO "list" ("id", "value") VALUES (E'GB', E'Regne Unit');
INSERT INTO "list" ("id", "value") VALUES (E'CF', E'República Centreafricana');
INSERT INTO "list" ("id", "value") VALUES (E'ZA', E'República de Sud-àfrica');
INSERT INTO "list" ("id", "value") VALUES (E'DO', E'República Dominicana');
INSERT INTO "list" ("id", "value") VALUES (E'RO', E'Romania');
INSERT INTO "list" ("id", "value") VALUES (E'RW', E'Ruanda');
INSERT INTO "list" ("id", "value") VALUES (E'RU', E'Rússia');
INSERT INTO "list" ("id", "value") VALUES (E'EH', E'Sàhara Occidental');
INSERT INTO "list" ("id", "value") VALUES (E'BL', E'Saint Barthélemy');
INSERT INTO "list" ("id", "value") VALUES (E'KN', E'Saint Christopher i Nevis');
INSERT INTO "list" ("id", "value") VALUES (E'SH', E'Saint Helena');
INSERT INTO "list" ("id", "value") VALUES (E'LC', E'Saint Lucia');
INSERT INTO "list" ("id", "value") VALUES (E'MF', E'Saint Martin');
INSERT INTO "list" ("id", "value") VALUES (E'VC', E'Saint Vincent i les Grenadines');
INSERT INTO "list" ("id", "value") VALUES (E'PM', E'Saint-Pierre-et-Miquelon');
INSERT INTO "list" ("id", "value") VALUES (E'WS', E'Samoa');
INSERT INTO "list" ("id", "value") VALUES (E'AS', E'Samoa Nord-americana');
INSERT INTO "list" ("id", "value") VALUES (E'SM', E'San Marino');
INSERT INTO "list" ("id", "value") VALUES (E'ST', E'São Tomé i Príncipe');
INSERT INTO "list" ("id", "value") VALUES (E'SN', E'Senegal');
INSERT INTO "list" ("id", "value") VALUES (E'RS', E'Sèrbia');
INSERT INTO "list" ("id", "value") VALUES (E'SC', E'Seychelles');
INSERT INTO "list" ("id", "value") VALUES (E'SL', E'Sierra Leone');
INSERT INTO "list" ("id", "value") VALUES (E'SG', E'Singapur');
INSERT INTO "list" ("id", "value") VALUES (E'SX', E'Sint Maarten');
INSERT INTO "list" ("id", "value") VALUES (E'SY', E'Síria');
INSERT INTO "list" ("id", "value") VALUES (E'SO', E'Somàlia');
INSERT INTO "list" ("id", "value") VALUES (E'LK', E'Sri Lanka');
INSERT INTO "list" ("id", "value") VALUES (E'SD', E'Sudan');
INSERT INTO "list" ("id", "value") VALUES (E'SS', E'Sudan del Sud');
INSERT INTO "list" ("id", "value") VALUES (E'SE', E'Suècia');
INSERT INTO "list" ("id", "value") VALUES (E'CH', E'Suïssa');
INSERT INTO "list" ("id", "value") VALUES (E'SR', E'Surinam');
INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'Svalbard i Jan Mayen');
INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'Tadjikistan');
INSERT INTO "list" ("id", "value") VALUES (E'TH', E'Tailàndia');
INSERT INTO "list" ("id", "value") VALUES (E'TW', E'Taiwan');
INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'Tanzània');
INSERT INTO "list" ("id", "value") VALUES (E'IO', E'Territori Britànic de l’Oceà Índic');
INSERT INTO "list" ("id", "value") VALUES (E'TF', E'Territoris Australs Francesos');
INSERT INTO "list" ("id", "value") VALUES (E'PS', E'Territoris palestins');
INSERT INTO "list" ("id", "value") VALUES (E'TL', E'Timor Oriental');
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'Trinitat i Tobago');
INSERT INTO "list" ("id", "value") VALUES (E'TN', E'Tunísia');
INSERT INTO "list" ("id", "value") VALUES (E'TM', E'Turkmenistan');
INSERT INTO "list" ("id", "value") VALUES (E'TR', E'Turquia');
INSERT INTO "list" ("id", "value") VALUES (E'TV', E'Tuvalu');
INSERT INTO "list" ("id", "value") VALUES (E'TD', E'Txad');
INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'Txèquia');
INSERT INTO "list" ("id", "value") VALUES (E'UA', E'Ucraïna');
INSERT INTO "list" ("id", "value") VALUES (E'UG', E'Uganda');
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'VE', E'Veneçuela');
INSERT INTO "list" ("id", "value") VALUES (E'VN', E'Vietnam');
INSERT INTO "list" ("id", "value") VALUES (E'WF', E'Wallis i Futuna');
INSERT INTO "list" ("id", "value") VALUES (E'CL', E'Xile');
INSERT INTO "list" ("id", "value") VALUES (E'CN', E'Xina');
INSERT INTO "list" ("id", "value") VALUES (E'CY', E'Xipre');
INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'Zàmbia');
INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'Zimbàbue');
