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'Afghanistan');
  INSERT INTO "list" ("id", "value") VALUES (E'ZA', E'Afrika Kusini');
  INSERT INTO "list" ("id", "value") VALUES (E'IS', E'Aislandi');
  INSERT INTO "list" ("id", "value") VALUES (E'AR', E'Ajentina');
  INSERT INTO "list" ("id", "value") VALUES (E'AL', E'Albania');
  INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'Aljeria');
  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'Anguilla');
  INSERT INTO "list" ("id", "value") VALUES (E'AQ', E'Antaktika');
  INSERT INTO "list" ("id", "value") VALUES (E'AG', E'Antigua na Barbuda');
  INSERT INTO "list" ("id", "value") VALUES (E'AM', E'Armenia');
  INSERT INTO "list" ("id", "value") VALUES (E'AW', E'Aruba');
  INSERT INTO "list" ("id", "value") VALUES (E'AU', E'Australia');
  INSERT INTO "list" ("id", "value") VALUES (E'AT', E'Austria');
  INSERT INTO "list" ("id", "value") VALUES (E'IE', E'Ayalandi');
  INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'Azabajani');
  INSERT INTO "list" ("id", "value") VALUES (E'BB', E'Babadosi');
  INSERT INTO "list" ("id", "value") VALUES (E'BS', E'Bahama');
  INSERT INTO "list" ("id", "value") VALUES (E'BH', E'Bahareni');
  INSERT INTO "list" ("id", "value") VALUES (E'BD', E'Bangladeshi');
  INSERT INTO "list" ("id", "value") VALUES (E'BY', E'Belarusi');
  INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'Belize');
  INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'Benin');
  INSERT INTO "list" ("id", "value") VALUES (E'BM', E'Bermuda');
  INSERT INTO "list" ("id", "value") VALUES (E'BT', E'Bhutan');
  INSERT INTO "list" ("id", "value") VALUES (E'BO', E'Bolivia');
  INSERT INTO "list" ("id", "value") VALUES (E'BA', E'Bosnia na Hezegovina');
  INSERT INTO "list" ("id", "value") VALUES (E'BW', E'Botswana');
  INSERT INTO "list" ("id", "value") VALUES (E'BR', E'Brazili');
  INSERT INTO "list" ("id", "value") VALUES (E'BN', E'Brunei');
  INSERT INTO "list" ("id", "value") VALUES (E'BF', E'Bukinafaso');
  INSERT INTO "list" ("id", "value") VALUES (E'BG', E'Bulgaria');
  INSERT INTO "list" ("id", "value") VALUES (E'BI', E'Burundi');
  INSERT INTO "list" ("id", "value") VALUES (E'CV', E'Cape Verde');
  INSERT INTO "list" ("id", "value") VALUES (E'EA', E'Ceuta na Melilla');
  INSERT INTO "list" ("id", "value") VALUES (E'TD', E'Chadi');
  INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'Chechia');
  INSERT INTO "list" ("id", "value") VALUES (E'CL', E'Chile');
  INSERT INTO "list" ("id", "value") VALUES (E'CN', E'China');
  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'Dominika');
  INSERT INTO "list" ("id", "value") VALUES (E'EC', E'Ekwado');
  INSERT INTO "list" ("id", "value") VALUES (E'SV', E'Elsavado');
  INSERT INTO "list" ("id", "value") VALUES (E'IO', E'Eneo la Uingereza katika Bahari Hindi');
  INSERT INTO "list" ("id", "value") VALUES (E'ER', E'Eritrea');
  INSERT INTO "list" ("id", "value") VALUES (E'EE', E'Estonia');
  INSERT INTO "list" ("id", "value") VALUES (E'ET', E'Ethiopia');
  INSERT INTO "list" ("id", "value") VALUES (E'EZ', E'Eurozone');
  INSERT INTO "list" ("id", "value") VALUES (E'AE', E'Falme za Kiarabu');
  INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'Fiji');
  INSERT INTO "list" ("id", "value") VALUES (E'GA', E'Gabon');
  INSERT INTO "list" ("id", "value") VALUES (E'GM', E'Gambia');
  INSERT INTO "list" ("id", "value") VALUES (E'GH', E'Ghana');
  INSERT INTO "list" ("id", "value") VALUES (E'GN', E'Gine');
  INSERT INTO "list" ("id", "value") VALUES (E'GW', E'Ginebisau');
  INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'Ginekweta');
  INSERT INTO "list" ("id", "value") VALUES (E'GD', E'Grenada');
  INSERT INTO "list" ("id", "value") VALUES (E'GL', E'Grinlandi');
  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'GY', E'Guyana');
  INSERT INTO "list" ("id", "value") VALUES (E'GP', E'Gwadelupe');
  INSERT INTO "list" ("id", "value") VALUES (E'GF', E'Gwiyana ya Ufaransa');
  INSERT INTO "list" ("id", "value") VALUES (E'HT', E'Haiti');
  INSERT INTO "list" ("id", "value") VALUES (E'ES', E'Hispania');
  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'Hungaria');
  INSERT INTO "list" ("id", "value") VALUES (E'IN', E'India');
  INSERT INTO "list" ("id", "value") VALUES (E'ID', E'Indonesia');
  INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'Iraki');
  INSERT INTO "list" ("id", "value") VALUES (E'IR', E'Iran');
  INSERT INTO "list" ("id", "value") VALUES (E'IM', E'Isle of Man');
  INSERT INTO "list" ("id", "value") VALUES (E'IL', E'Israeli');
  INSERT INTO "list" ("id", "value") VALUES (E'IT', E'Italia');
  INSERT INTO "list" ("id", "value") VALUES (E'CI', E'Ivorikosti');
  INSERT INTO "list" ("id", "value") VALUES (E'JM', E'Jamaika');
  INSERT INTO "list" ("id", "value") VALUES (E'CF', E'Jamhuri ya Afrika ya Kati');
  INSERT INTO "list" ("id", "value") VALUES (E'DO', E'Jamhuri ya Dominika');
  INSERT INTO "list" ("id", "value") VALUES (E'CD', E'Jamhuri ya Kidemokrasia ya Kongo');
  INSERT INTO "list" ("id", "value") VALUES (E'JP', E'Japani');
  INSERT INTO "list" ("id", "value") VALUES (E'JE', E'Jersey');
  INSERT INTO "list" ("id", "value") VALUES (E'GI', E'Jibralta');
  INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'Jibuti');
  INSERT INTO "list" ("id", "value") VALUES (E'GE', E'Jojia');
  INSERT INTO "list" ("id", "value") VALUES (E'GS', E'Jojia Kusini na Visiwa vya Sandwich Kusini');
  INSERT INTO "list" ("id", "value") VALUES (E'KH', E'Kambodia');
  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'Kazakistani');
  INSERT INTO "list" ("id", "value") VALUES (E'KE', E'Kenya');
  INSERT INTO "list" ("id", "value") VALUES (E'KI', E'Kiribati');
  INSERT INTO "list" ("id", "value") VALUES (E'KG', E'Kirigizistani');
  INSERT INTO "list" ("id", "value") VALUES (E'AC', E'Kisiwa cha Ascension');
  INSERT INTO "list" ("id", "value") VALUES (E'CX', E'Kisiwa cha Christmas');
  INSERT INTO "list" ("id", "value") VALUES (E'NF', E'Kisiwa cha Norfolk');
  INSERT INTO "list" ("id", "value") VALUES (E'CO', E'Kolombia');
  INSERT INTO "list" ("id", "value") VALUES (E'KM', E'Komoro');
  INSERT INTO "list" ("id", "value") VALUES (E'CG', E'Kongo - Brazzaville');
  INSERT INTO "list" ("id", "value") VALUES (E'HR', E'Korasia');
  INSERT INTO "list" ("id", "value") VALUES (E'KP', E'Korea Kaskazini');
  INSERT INTO "list" ("id", "value") VALUES (E'KR', E'Korea Kusini');
  INSERT INTO "list" ("id", "value") VALUES (E'XK', E'Kosovo');
  INSERT INTO "list" ("id", "value") VALUES (E'CR', E'Kostarika');
  INSERT INTO "list" ("id", "value") VALUES (E'CU', E'Kuba');
  INSERT INTO "list" ("id", "value") VALUES (E'CW', E'Kurakao');
  INSERT INTO "list" ("id", "value") VALUES (E'KW', E'Kuwait');
  INSERT INTO "list" ("id", "value") VALUES (E'LA', E'Laosi');
  INSERT INTO "list" ("id", "value") VALUES (E'LU', E'Lasembagi');
  INSERT INTO "list" ("id", "value") VALUES (E'LV', E'Lativia');
  INSERT INTO "list" ("id", "value") VALUES (E'LB', E'Lebanoni');
  INSERT INTO "list" ("id", "value") VALUES (E'LS', E'Lesotho');
  INSERT INTO "list" ("id", "value") VALUES (E'LR', E'Liberia');
  INSERT INTO "list" ("id", "value") VALUES (E'LY', E'Libya');
  INSERT INTO "list" ("id", "value") VALUES (E'LI', E'Lishtensteni');
  INSERT INTO "list" ("id", "value") VALUES (E'LT', E'Lithuania');
  INSERT INTO "list" ("id", "value") VALUES (E'MO', E'Macau SAR China');
  INSERT INTO "list" ("id", "value") VALUES (E'MK', E'Macedonia');
  INSERT INTO "list" ("id", "value") VALUES (E'MG', E'Madagaska');
  INSERT INTO "list" ("id", "value") VALUES (E'TF', E'Maeneo ya Kusini ya Ufaransa');
  INSERT INTO "list" ("id", "value") VALUES (E'PS', E'Maeneo ya Palestina');
  INSERT INTO "list" ("id", "value") VALUES (E'MW', E'Malawi');
  INSERT INTO "list" ("id", "value") VALUES (E'MV', E'Maldivi');
  INSERT INTO "list" ("id", "value") VALUES (E'MY', E'Malesia');
  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'US', E'Marekani');
  INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'Martiniki');
  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'Mikronesia');
  INSERT INTO "list" ("id", "value") VALUES (E'EG', E'Misri');
  INSERT INTO "list" ("id", "value") VALUES (E'MD', E'Moldova');
  INSERT INTO "list" ("id", "value") VALUES (E'MC', E'Monako');
  INSERT INTO "list" ("id", "value") VALUES (E'MN', E'Mongolia');
  INSERT INTO "list" ("id", "value") VALUES (E'ME', E'Montenegro');
  INSERT INTO "list" ("id", "value") VALUES (E'MS', E'Montserrati');
  INSERT INTO "list" ("id", "value") VALUES (E'MU', E'Morisi');
  INSERT INTO "list" ("id", "value") VALUES (E'MR', E'Moritania');
  INSERT INTO "list" ("id", "value") VALUES (E'MA', E'Morocco');
  INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'Msumbiji');
  INSERT INTO "list" ("id", "value") VALUES (E'MM', E'Myanmar (Burma)');
  INSERT INTO "list" ("id", "value") VALUES (E'NA', E'Namibia');
  INSERT INTO "list" ("id", "value") VALUES (E'NR', E'Nauru');
  INSERT INTO "list" ("id", "value") VALUES (E'NP', E'Nepali');
  INSERT INTO "list" ("id", "value") VALUES (E'NE', E'Nijer');
  INSERT INTO "list" ("id", "value") VALUES (E'NG', E'Nijeria');
  INSERT INTO "list" ("id", "value") VALUES (E'NI', E'Nikaragwa');
  INSERT INTO "list" ("id", "value") VALUES (E'NU', E'Niue');
  INSERT INTO "list" ("id", "value") VALUES (E'NO', E'Norwe');
  INSERT INTO "list" ("id", "value") VALUES (E'NC', E'Nyukaledonia');
  INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'Nyuzilandi');
  INSERT INTO "list" ("id", "value") VALUES (E'OM', E'Omani');
  INSERT INTO "list" ("id", "value") VALUES (E'PK', E'Pakistani');
  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'Paragwai');
  INSERT INTO "list" ("id", "value") VALUES (E'PE', E'Peru');
  INSERT INTO "list" ("id", "value") VALUES (E'PL', E'Polandi');
  INSERT INTO "list" ("id", "value") VALUES (E'PF', E'Polinesia ya Ufaransa');
  INSERT INTO "list" ("id", "value") VALUES (E'PR', E'Puetoriko');
  INSERT INTO "list" ("id", "value") VALUES (E'RE', E'Riyunioni');
  INSERT INTO "list" ("id", "value") VALUES (E'RO', E'Romania');
  INSERT INTO "list" ("id", "value") VALUES (E'RW', E'Rwanda');
  INSERT INTO "list" ("id", "value") VALUES (E'EH', E'Sahara Magharibi');
  INSERT INTO "list" ("id", "value") VALUES (E'MF', E'Saint Martin');
  INSERT INTO "list" ("id", "value") VALUES (E'CY', E'Saiprasi');
  INSERT INTO "list" ("id", "value") VALUES (E'WS', E'Samoa');
  INSERT INTO "list" ("id", "value") VALUES (E'AS', E'Samoa ya Marekani');
  INSERT INTO "list" ("id", "value") VALUES (E'SM', E'San Marino');
  INSERT INTO "list" ("id", "value") VALUES (E'BL', E'Santabathelemi');
  INSERT INTO "list" ("id", "value") VALUES (E'SH', E'Santahelena');
  INSERT INTO "list" ("id", "value") VALUES (E'KN', E'Santakitzi na Nevis');
  INSERT INTO "list" ("id", "value") VALUES (E'LC', E'Santalusia');
  INSERT INTO "list" ("id", "value") VALUES (E'PM', E'Santapierre na Miquelon');
  INSERT INTO "list" ("id", "value") VALUES (E'VC', E'Santavisenti na Grenadini');
  INSERT INTO "list" ("id", "value") VALUES (E'ST', E'Sao Tome na Prinsipe');
  INSERT INTO "list" ("id", "value") VALUES (E'SA', E'Saudia');
  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'SL', E'Siera Leoni');
  INSERT INTO "list" ("id", "value") VALUES (E'SG', E'Singapore');
  INSERT INTO "list" ("id", "value") VALUES (E'SX', E'Sint Maarten');
  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'SO', E'Somalia');
  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 Kusini');
  INSERT INTO "list" ("id", "value") VALUES (E'SR', E'Suriname');
  INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'Svalbard na Jan Mayen');
  INSERT INTO "list" ("id", "value") VALUES (E'SY', E'Syria');
  INSERT INTO "list" ("id", "value") VALUES (E'TH', E'Tailandi');
  INSERT INTO "list" ("id", "value") VALUES (E'TW', E'Taiwan');
  INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'Tajikistani');
  INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'Tanzania');
  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 na Tobago');
  INSERT INTO "list" ("id", "value") VALUES (E'TA', E'Tristan da Cunha');
  INSERT INTO "list" ("id", "value") VALUES (E'TN', E'Tunisia');
  INSERT INTO "list" ("id", "value") VALUES (E'TM', E'Turukimenistani');
  INSERT INTO "list" ("id", "value") VALUES (E'TV', E'Tuvalu');
  INSERT INTO "list" ("id", "value") VALUES (E'BE', E'Ubelgiji');
  INSERT INTO "list" ("id", "value") VALUES (E'FR', E'Ufaransa');
  INSERT INTO "list" ("id", "value") VALUES (E'PH', E'Ufilipino');
  INSERT INTO "list" ("id", "value") VALUES (E'FI', E'Ufini');
  INSERT INTO "list" ("id", "value") VALUES (E'UG', E'Uganda');
  INSERT INTO "list" ("id", "value") VALUES (E'GR', E'Ugiriki');
  INSERT INTO "list" ("id", "value") VALUES (E'NL', E'Uholanzi');
  INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'Uholanzi ya Karibiani');
  INSERT INTO "list" ("id", "value") VALUES (E'GB', E'Uingereza');
  INSERT INTO "list" ("id", "value") VALUES (E'DE', E'Ujerumani');
  INSERT INTO "list" ("id", "value") VALUES (E'UA', E'Ukraine');
  INSERT INTO "list" ("id", "value") VALUES (E'UN', E'Umoja wa Mataifa');
  INSERT INTO "list" ("id", "value") VALUES (E'PT', E'Ureno');
  INSERT INTO "list" ("id", "value") VALUES (E'UY', E'Urugwai');
  INSERT INTO "list" ("id", "value") VALUES (E'RU', E'Urusi');
  INSERT INTO "list" ("id", "value") VALUES (E'SC', E'Ushelisheli');
  INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'Uswazi');
  INSERT INTO "list" ("id", "value") VALUES (E'SE', E'Uswidi');
  INSERT INTO "list" ("id", "value") VALUES (E'CH', E'Uswisi');
  INSERT INTO "list" ("id", "value") VALUES (E'TR', E'Uturuki');
  INSERT INTO "list" ("id", "value") VALUES (E'UZ', E'Uzibekistani');
  INSERT INTO "list" ("id", "value") VALUES (E'VU', E'Vanuatu');
  INSERT INTO "list" ("id", "value") VALUES (E'VA', E'Vatikani');
  INSERT INTO "list" ("id", "value") VALUES (E'VE', E'Venezuela');
  INSERT INTO "list" ("id", "value") VALUES (E'VN', E'Vietnamu');
  INSERT INTO "list" ("id", "value") VALUES (E'UM', E'Visiwa Vidogo vya Nje vya Marekani');
  INSERT INTO "list" ("id", "value") VALUES (E'AX', E'Visiwa vya Alandi');
  INSERT INTO "list" ("id", "value") VALUES (E'CC', E'Visiwa vya Cocos (Keeling)');
  INSERT INTO "list" ("id", "value") VALUES (E'CK', E'Visiwa vya Cook');
  INSERT INTO "list" ("id", "value") VALUES (E'FK', E'Visiwa vya Falkland');
  INSERT INTO "list" ("id", "value") VALUES (E'FO', E'Visiwa vya Faroe');
  INSERT INTO "list" ("id", "value") VALUES (E'IC', E'Visiwa vya Kanari');
  INSERT INTO "list" ("id", "value") VALUES (E'KY', E'Visiwa vya Kayman');
  INSERT INTO "list" ("id", "value") VALUES (E'MP', E'Visiwa vya Mariana vya Kaskazini');
  INSERT INTO "list" ("id", "value") VALUES (E'MH', E'Visiwa vya Marshall');
  INSERT INTO "list" ("id", "value") VALUES (E'PN', E'Visiwa vya Pitcairn');
  INSERT INTO "list" ("id", "value") VALUES (E'SB', E'Visiwa vya Solomon');
  INSERT INTO "list" ("id", "value") VALUES (E'TC', E'Visiwa vya Turki na Kaiko');
  INSERT INTO "list" ("id", "value") VALUES (E'VI', E'Visiwa vya Virgin vya Marekani');
  INSERT INTO "list" ("id", "value") VALUES (E'VG', E'Visiwa vya Virgin vya Uingereza');
  INSERT INTO "list" ("id", "value") VALUES (E'WF', E'Walis na Futuna');
  INSERT INTO "list" ("id", "value") VALUES (E'YE', E'Yemeni');
  INSERT INTO "list" ("id", "value") VALUES (E'JO', E'Yordani');
  INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'Zambia');
  INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'Zimbabwe');
  