text: CREATE TABLE list (id VARCHAR(10) NOT NULL, value VARCHAR(64) NOT NULL, PRIMARY KEY(id));
  
  INSERT INTO "list" ("id", "value") VALUES (E'AF', E'Afgaanistaan');
  INSERT INTO "list" ("id", "value") VALUES (E'AX', E'Åland Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'AL', E'Albaaniya');
  INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'Aljeeriya');
  INSERT INTO "list" ("id", "value") VALUES (E'AD', E'Andora');
  INSERT INTO "list" ("id", "value") VALUES (E'AO', E'Angoola');
  INSERT INTO "list" ("id", "value") VALUES (E'AI', E'Anguilla');
  INSERT INTO "list" ("id", "value") VALUES (E'AQ', E'Antarctica');
  INSERT INTO "list" ("id", "value") VALUES (E'AG', E'Antigua iyo Barbuda');
  INSERT INTO "list" ("id", "value") VALUES (E'AR', E'Arjantiin');
  INSERT INTO "list" ("id", "value") VALUES (E'AM', E'Armeeniya');
  INSERT INTO "list" ("id", "value") VALUES (E'AW', E'Aruba');
  INSERT INTO "list" ("id", "value") VALUES (E'AC', E'Ascension Island');
  INSERT INTO "list" ("id", "value") VALUES (E'AU', E'Awstaraaliya');
  INSERT INTO "list" ("id", "value") VALUES (E'AT', E'Awsteriya');
  INSERT INTO "list" ("id", "value") VALUES (E'IE', E'Ayrlaand');
  INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'Azerbajaan');
  INSERT INTO "list" ("id", "value") VALUES (E'BB', E'Baarbadoos');
  INSERT INTO "list" ("id", "value") VALUES (E'BS', E'Bahaamas');
  INSERT INTO "list" ("id", "value") VALUES (E'PK', E'Bakistaan');
  INSERT INTO "list" ("id", "value") VALUES (E'BD', E'Bangaaladheesh');
  INSERT INTO "list" ("id", "value") VALUES (E'BH', E'Baxreyn');
  INSERT INTO "list" ("id", "value") VALUES (E'BY', E'Belarus');
  INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'Belize');
  INSERT INTO "list" ("id", "value") VALUES (E'BM', E'Bermuuda');
  INSERT INTO "list" ("id", "value") VALUES (E'BT', E'Bhutan');
  INSERT INTO "list" ("id", "value") VALUES (E'BE', E'Biljam');
  INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'Biniin');
  INSERT INTO "list" ("id", "value") VALUES (E'BO', E'Boliifiya');
  INSERT INTO "list" ("id", "value") VALUES (E'PL', E'Booland');
  INSERT INTO "list" ("id", "value") VALUES (E'PT', E'Bortuqaal');
  INSERT INTO "list" ("id", "value") VALUES (E'BA', E'Bosniya Hersigoviina');
  INSERT INTO "list" ("id", "value") VALUES (E'BW', E'Botuswaana');
  INSERT INTO "list" ("id", "value") VALUES (E'BR', E'Braasiil');
  INSERT INTO "list" ("id", "value") VALUES (E'IO', E'British Indian Ocean Territory');
  INSERT INTO "list" ("id", "value") VALUES (E'VG', E'British Virgin Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'BG', E'Bulgaariya');
  INSERT INTO "list" ("id", "value") VALUES (E'BF', E'Burkiina Faaso');
  INSERT INTO "list" ("id", "value") VALUES (E'BI', E'Burundi');
  INSERT INTO "list" ("id", "value") VALUES (E'BN', E'Buruneeya');
  INSERT INTO "list" ("id", "value") VALUES (E'IC', E'Canary Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'CV', E'Cape Verde Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'Caribbean Netherlands');
  INSERT INTO "list" ("id", "value") VALUES (E'KY', E'Cayman Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'EA', E'Ceuta & Melilla');
  INSERT INTO "list" ("id", "value") VALUES (E'CX', E'Christmas Island');
  INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'Ciraaq');
  INSERT INTO "list" ("id", "value") VALUES (E'CC', E'Cocos (Keeling) Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'OM', E'Cumaan');
  INSERT INTO "list" ("id", "value") VALUES (E'CW', E'Curaçao');
  INSERT INTO "list" ("id", "value") VALUES (E'DK', E'Denmark');
  INSERT INTO "list" ("id", "value") VALUES (E'DG', E'Diego Garcia');
  INSERT INTO "list" ("id", "value") VALUES (E'DM', E'Domeenika');
  INSERT INTO "list" ("id", "value") VALUES (E'SV', E'El Salvador');
  INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'Equatorial Guinea');
  INSERT INTO "list" ("id", "value") VALUES (E'ER', E'Eretereeya');
  INSERT INTO "list" ("id", "value") VALUES (E'EE', E'Estooniya');
  INSERT INTO "list" ("id", "value") VALUES (E'EZ', E'Eurozone');
  INSERT INTO "list" ("id", "value") VALUES (E'VA', E'Faatikaan');
  INSERT INTO "list" ("id", "value") VALUES (E'PS', E'Falastiin Daanka galbeed iyo Qasa');
  INSERT INTO "list" ("id", "value") VALUES (E'FR', E'Faransiis');
  INSERT INTO "list" ("id", "value") VALUES (E'FO', E'Faroe Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'VE', E'Fenisuweela');
  INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'Fiji');
  INSERT INTO "list" ("id", "value") VALUES (E'PH', E'Filibiin');
  INSERT INTO "list" ("id", "value") VALUES (E'FI', E'Finland');
  INSERT INTO "list" ("id", "value") VALUES (E'VN', E'Fiyetnaam');
  INSERT INTO "list" ("id", "value") VALUES (E'GF', E'French Guiana');
  INSERT INTO "list" ("id", "value") VALUES (E'PF', E'French Polynesia');
  INSERT INTO "list" ("id", "value") VALUES (E'TF', E'French Southern Territories');
  INSERT INTO "list" ("id", "value") VALUES (E'GA', E'Gaaboon');
  INSERT INTO "list" ("id", "value") VALUES (E'GH', E'Gaana');
  INSERT INTO "list" ("id", "value") VALUES (E'GM', E'Gambiya');
  INSERT INTO "list" ("id", "value") VALUES (E'GI', E'Gibraltar');
  INSERT INTO "list" ("id", "value") VALUES (E'GN', E'Gini');
  INSERT INTO "list" ("id", "value") VALUES (E'GW', E'Gini-Bisaaw');
  INSERT INTO "list" ("id", "value") VALUES (E'GR', E'Giriig');
  INSERT INTO "list" ("id", "value") VALUES (E'GD', E'Giriinaada');
  INSERT INTO "list" ("id", "value") VALUES (E'GL', E'Greenland');
  INSERT INTO "list" ("id", "value") VALUES (E'GP', E'Guadeloupe');
  INSERT INTO "list" ("id", "value") VALUES (E'GU', E'Guam');
  INSERT INTO "list" ("id", "value") VALUES (E'GG', E'Guernsey');
  INSERT INTO "list" ("id", "value") VALUES (E'GT', E'Guwaatamaala');
  INSERT INTO "list" ("id", "value") VALUES (E'GY', E'Guyana');
  INSERT INTO "list" ("id", "value") VALUES (E'HU', E'Hangeri');
  INSERT INTO "list" ("id", "value") VALUES (E'HT', E'Hayti');
  INSERT INTO "list" ("id", "value") VALUES (E'IN', E'Hindiya');
  INSERT INTO "list" ("id", "value") VALUES (E'HN', E'Honduras');
  INSERT INTO "list" ("id", "value") VALUES (E'HK', E'Hong Kong SAR China');
  INSERT INTO "list" ("id", "value") VALUES (E'IR', E'Iiraan');
  INSERT INTO "list" ("id", "value") VALUES (E'IS', E'Iislaand');
  INSERT INTO "list" ("id", "value") VALUES (E'EC', E'Ikuwadoor');
  INSERT INTO "list" ("id", "value") VALUES (E'AE', E'Imaaraadka Carabta ee Midoobay');
  INSERT INTO "list" ("id", "value") VALUES (E'ID', E'Indoneesiya');
  INSERT INTO "list" ("id", "value") VALUES (E'ES', E'Isbeyn');
  INSERT INTO "list" ("id", "value") VALUES (E'IM', E'Isle of Man');
  INSERT INTO "list" ("id", "value") VALUES (E'IL', E'Israaʼiil');
  INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'Iswaasilaand');
  INSERT INTO "list" ("id", "value") VALUES (E'SE', E'Iswidhan');
  INSERT INTO "list" ("id", "value") VALUES (E'ET', E'Itoobiya');
  INSERT INTO "list" ("id", "value") VALUES (E'CI', E'Ivory coast');
  INSERT INTO "list" ("id", "value") VALUES (E'TD', E'Jaad');
  INSERT INTO "list" ("id", "value") VALUES (E'JP', E'Jabaan');
  INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'Jabuuti');
  INSERT INTO "list" ("id", "value") VALUES (E'JM', E'Jameyka');
  INSERT INTO "list" ("id", "value") VALUES (E'CF', E'Jamhuuriyadda Afrikada Dhexe');
  INSERT INTO "list" ("id", "value") VALUES (E'CD', E'Jamhuuriyadda Dimuquraadiga Kongo');
  INSERT INTO "list" ("id", "value") VALUES (E'DO', E'Jamhuuriyadda Domeenika');
  INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'Jamhuuriyadda Jek');
  INSERT INTO "list" ("id", "value") VALUES (E'DE', E'Jarmal');
  INSERT INTO "list" ("id", "value") VALUES (E'FK', E'Jaziiradaha Fooklaan');
  INSERT INTO "list" ("id", "value") VALUES (E'CK', E'Jaziiradda Cook');
  INSERT INTO "list" ("id", "value") VALUES (E'JE', E'Jersey');
  INSERT INTO "list" ("id", "value") VALUES (E'CL', E'Jili');
  INSERT INTO "list" ("id", "value") VALUES (E'GE', E'Joorjiya');
  INSERT INTO "list" ("id", "value") VALUES (E'CM', E'Kaameruun');
  INSERT INTO "list" ("id", "value") VALUES (E'KH', E'Kamboodiya');
  INSERT INTO "list" ("id", "value") VALUES (E'CA', E'Kanada');
  INSERT INTO "list" ("id", "value") VALUES (E'KZ', E'Kasaakhistaan');
  INSERT INTO "list" ("id", "value") VALUES (E'KE', E'Kiiniya');
  INSERT INTO "list" ("id", "value") VALUES (E'KG', E'Kirgistaan');
  INSERT INTO "list" ("id", "value") VALUES (E'KI', E'Kiribati');
  INSERT INTO "list" ("id", "value") VALUES (E'CO', E'Kolombiya');
  INSERT INTO "list" ("id", "value") VALUES (E'KM', E'Komooros');
  INSERT INTO "list" ("id", "value") VALUES (E'CG', E'Kongo');
  INSERT INTO "list" ("id", "value") VALUES (E'ZA', E'Koonfur Afrika');
  INSERT INTO "list" ("id", "value") VALUES (E'HR', E'Korweeshiya');
  INSERT INTO "list" ("id", "value") VALUES (E'XK', E'Kosovo');
  INSERT INTO "list" ("id", "value") VALUES (E'CR', E'Kosta Riika');
  INSERT INTO "list" ("id", "value") VALUES (E'CU', E'Kuuba');
  INSERT INTO "list" ("id", "value") VALUES (E'KR', E'Kuuriyada Koonfureed');
  INSERT INTO "list" ("id", "value") VALUES (E'KP', E'Kuuriyada Waqooyi');
  INSERT INTO "list" ("id", "value") VALUES (E'KW', E'Kuwayt');
  INSERT INTO "list" ("id", "value") VALUES (E'LA', E'Laos');
  INSERT INTO "list" ("id", "value") VALUES (E'LV', E'Latfiya');
  INSERT INTO "list" ("id", "value") VALUES (E'LR', E'Laybeeriya');
  INSERT INTO "list" ("id", "value") VALUES (E'LI', E'Liechtenstein');
  INSERT INTO "list" ("id", "value") VALUES (E'LY', E'Liibiya');
  INSERT INTO "list" ("id", "value") VALUES (E'LT', E'Lituweeniya');
  INSERT INTO "list" ("id", "value") VALUES (E'LS', E'Losooto');
  INSERT INTO "list" ("id", "value") VALUES (E'LB', E'Lubnaan');
  INSERT INTO "list" ("id", "value") VALUES (E'LU', E'Luksemboorg');
  INSERT INTO "list" ("id", "value") VALUES (E'MT', E'Maalda');
  INSERT INTO "list" ("id", "value") VALUES (E'MV', E'Maaldiqeen');
  INSERT INTO "list" ("id", "value") VALUES (E'ML', E'Maali');
  INSERT INTO "list" ("id", "value") VALUES (E'MO', E'Macau SAR China');
  INSERT INTO "list" ("id", "value") VALUES (E'MG', E'Madagaskar');
  INSERT INTO "list" ("id", "value") VALUES (E'MK', E'Makadooniya');
  INSERT INTO "list" ("id", "value") VALUES (E'MW', E'Malaawi');
  INSERT INTO "list" ("id", "value") VALUES (E'MY', E'Malaysia');
  INSERT INTO "list" ("id", "value") VALUES (E'US', E'Maraykanka');
  INSERT INTO "list" ("id", "value") VALUES (E'MA', E'Marooko');
  INSERT INTO "list" ("id", "value") VALUES (E'MH', E'Marshall Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'Martinique');
  INSERT INTO "list" ("id", "value") VALUES (E'EG', E'Masar');
  INSERT INTO "list" ("id", "value") VALUES (E'YT', E'Mayotte');
  INSERT INTO "list" ("id", "value") VALUES (E'MX', E'Meksiko');
  INSERT INTO "list" ("id", "value") VALUES (E'FM', E'Micronesia');
  INSERT INTO "list" ("id", "value") VALUES (E'MM', E'Miyanmar');
  INSERT INTO "list" ("id", "value") VALUES (E'MD', E'Moldofa');
  INSERT INTO "list" ("id", "value") VALUES (E'MN', E'Mongooliya');
  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'MC', E'Moonako');
  INSERT INTO "list" ("id", "value") VALUES (E'MU', E'Murishiyoos');
  INSERT INTO "list" ("id", "value") VALUES (E'MR', E'Muritaaniya');
  INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'Musambiig');
  INSERT INTO "list" ("id", "value") VALUES (E'NA', E'Namiibiya');
  INSERT INTO "list" ("id", "value") VALUES (E'NR', E'Nauru');
  INSERT INTO "list" ("id", "value") VALUES (E'NG', E'Nayjeeriya');
  INSERT INTO "list" ("id", "value") VALUES (E'NE', E'Nayjer');
  INSERT INTO "list" ("id", "value") VALUES (E'NP', E'Nebaal');
  INSERT INTO "list" ("id", "value") VALUES (E'NL', E'Netherlands');
  INSERT INTO "list" ("id", "value") VALUES (E'NC', E'New Caledonia');
  INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'Neyuusilaand');
  INSERT INTO "list" ("id", "value") VALUES (E'NI', E'Nikaraaguwa');
  INSERT INTO "list" ("id", "value") VALUES (E'NU', E'Niue');
  INSERT INTO "list" ("id", "value") VALUES (E'NO', E'Noorweey');
  INSERT INTO "list" ("id", "value") VALUES (E'NF', E'Norfolk Island');
  INSERT INTO "list" ("id", "value") VALUES (E'MP', E'Northern Mariana Islands');
  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'PG', E'Papua New Guinea');
  INSERT INTO "list" ("id", "value") VALUES (E'PY', E'Paraguay');
  INSERT INTO "list" ("id", "value") VALUES (E'PE', E'Peru');
  INSERT INTO "list" ("id", "value") VALUES (E'PN', E'Pitcairn');
  INSERT INTO "list" ("id", "value") VALUES (E'PR', E'Puerto Rico');
  INSERT INTO "list" ("id", "value") VALUES (E'QA', E'Qadar');
  INSERT INTO "list" ("id", "value") VALUES (E'CY', E'Qubrus');
  INSERT INTO "list" ("id", "value") VALUES (E'RE', E'Réunion');
  INSERT INTO "list" ("id", "value") VALUES (E'RO', E'Rumaaniya');
  INSERT INTO "list" ("id", "value") VALUES (E'RU', E'Ruush');
  INSERT INTO "list" ("id", "value") VALUES (E'RW', E'Ruwanda');
  INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'Saambiya');
  INSERT INTO "list" ("id", "value") VALUES (E'SA', E'Sacuudi Carabiya');
  INSERT INTO "list" ("id", "value") VALUES (E'SH', E'Saint Helena');
  INSERT INTO "list" ("id", "value") VALUES (E'KN', E'Saint Kitts and Nevis');
  INSERT INTO "list" ("id", "value") VALUES (E'LC', E'Saint Lucia');
  INSERT INTO "list" ("id", "value") VALUES (E'PM', E'Saint Pierre and Miquelon');
  INSERT INTO "list" ("id", "value") VALUES (E'VC', E'Saint Vincent and the Grenadines');
  INSERT INTO "list" ("id", "value") VALUES (E'WS', E'Samoa');
  INSERT INTO "list" ("id", "value") VALUES (E'AS', E'Samowa Ameerika');
  INSERT INTO "list" ("id", "value") VALUES (E'SM', E'San Marino');
  INSERT INTO "list" ("id", "value") VALUES (E'ST', E'São Tomé and Príncipe');
  INSERT INTO "list" ("id", "value") VALUES (E'RS', E'Serbia');
  INSERT INTO "list" ("id", "value") VALUES (E'CN', E'Shiinaha');
  INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'Simbaabwe');
  INSERT INTO "list" ("id", "value") VALUES (E'SG', E'Singaboor');
  INSERT INTO "list" ("id", "value") VALUES (E'SN', E'Sinigaal');
  INSERT INTO "list" ("id", "value") VALUES (E'SX', E'Sint Maarten');
  INSERT INTO "list" ("id", "value") VALUES (E'SL', E'Siraaliyoon');
  INSERT INTO "list" ("id", "value") VALUES (E'LK', E'Sirilaanka');
  INSERT INTO "list" ("id", "value") VALUES (E'SC', E'Sishelis');
  INSERT INTO "list" ("id", "value") VALUES (E'SK', E'Slovakia');
  INSERT INTO "list" ("id", "value") VALUES (E'SI', E'Slovenia');
  INSERT INTO "list" ("id", "value") VALUES (E'SB', E'Solomon Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'SO', E'Soomaaliya');
  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'SR', E'Suriname');
  INSERT INTO "list" ("id", "value") VALUES (E'SD', E'Suudaan');
  INSERT INTO "list" ("id", "value") VALUES (E'SY', E'Suuriya');
  INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'Svalbard & Jan Mayen');
  INSERT INTO "list" ("id", "value") VALUES (E'CH', E'Swiiserlaand');
  INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'Tajikistan');
  INSERT INTO "list" ("id", "value") VALUES (E'IT', E'Talyaani');
  INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'Tansaaniya');
  INSERT INTO "list" ("id", "value") VALUES (E'TH', E'Taylaand');
  INSERT INTO "list" ("id", "value") VALUES (E'TW', E'Taywaan');
  INSERT INTO "list" ("id", "value") VALUES (E'TL', E'Timorka bari');
  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'TG', E'Toogo');
  INSERT INTO "list" ("id", "value") VALUES (E'TT', E'Trinidad and Tobago');
  INSERT INTO "list" ("id", "value") VALUES (E'TA', E'Tristan da Cunha');
  INSERT INTO "list" ("id", "value") VALUES (E'TN', E'Tuniisiya');
  INSERT INTO "list" ("id", "value") VALUES (E'TR', E'Turki');
  INSERT INTO "list" ("id", "value") VALUES (E'TM', E'Turkmenistan');
  INSERT INTO "list" ("id", "value") VALUES (E'TC', E'Turks and Caicos Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'TV', E'Tuvalu');
  INSERT INTO "list" ("id", "value") VALUES (E'UM', E'U.S. Outlying Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'VI', E'U.S. Virgin Islands');
  INSERT INTO "list" ("id", "value") VALUES (E'UG', E'Ugaanda');
  INSERT INTO "list" ("id", "value") VALUES (E'UA', E'Ukrayn');
  INSERT INTO "list" ("id", "value") VALUES (E'GB', E'United Kingdom');
  INSERT INTO "list" ("id", "value") VALUES (E'UN', E'United Nations');
  INSERT INTO "list" ("id", "value") VALUES (E'JO', E'Urdun');
  INSERT INTO "list" ("id", "value") VALUES (E'UY', E'Uruguwaay');
  INSERT INTO "list" ("id", "value") VALUES (E'UZ', E'Uusbakistaan');
  INSERT INTO "list" ("id", "value") VALUES (E'VU', E'Vanuatu');
  INSERT INTO "list" ("id", "value") VALUES (E'WF', E'Wallis and Futuna');
  INSERT INTO "list" ("id", "value") VALUES (E'EH', E'Western Sahara');
  INSERT INTO "list" ("id", "value") VALUES (E'YE', E'Yaman');
  