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'Afganistāna');
INSERT INTO "list" ("id", "value") VALUES (E'AL', E'Albānija');
INSERT INTO "list" ("id", "value") VALUES (E'DZ', E'Alžīrija');
INSERT INTO "list" ("id", "value") VALUES (E'US', E'Amerikas Savienotās Valstis');
INSERT INTO "list" ("id", "value") VALUES (E'AD', E'Andora');
INSERT INTO "list" ("id", "value") VALUES (E'AI', E'Angilja');
INSERT INTO "list" ("id", "value") VALUES (E'AO', E'Angola');
INSERT INTO "list" ("id", "value") VALUES (E'AQ', E'Antarktika');
INSERT INTO "list" ("id", "value") VALUES (E'AG', E'Antigva un Barbuda');
INSERT INTO "list" ("id", "value") VALUES (E'GB', E'Apvienotā Karaliste');
INSERT INTO "list" ("id", "value") VALUES (E'AE', E'Apvienotie Arābu Emirāti');
INSERT INTO "list" ("id", "value") VALUES (E'AR', E'Argentīna');
INSERT INTO "list" ("id", "value") VALUES (E'AM', E'Armēnija');
INSERT INTO "list" ("id", "value") VALUES (E'AW', E'Aruba');
INSERT INTO "list" ("id", "value") VALUES (E'UM', E'ASV Mazās Aizjūras salas');
INSERT INTO "list" ("id", "value") VALUES (E'AS', E'ASV Samoa');
INSERT INTO "list" ("id", "value") VALUES (E'VI', E'ASV Virdžīnas');
INSERT INTO "list" ("id", "value") VALUES (E'AU', E'Austrālija');
INSERT INTO "list" ("id", "value") VALUES (E'AT', E'Austrija');
INSERT INTO "list" ("id", "value") VALUES (E'TL', E'Austrumtimora');
INSERT INTO "list" ("id", "value") VALUES (E'AZ', E'Azerbaidžāna');
INSERT INTO "list" ("id", "value") VALUES (E'BS', E'Bahamu salas');
INSERT INTO "list" ("id", "value") VALUES (E'BH', E'Bahreina');
INSERT INTO "list" ("id", "value") VALUES (E'BY', E'Baltkrievija');
INSERT INTO "list" ("id", "value") VALUES (E'BD', E'Bangladeša');
INSERT INTO "list" ("id", "value") VALUES (E'BB', E'Barbadosa');
INSERT INTO "list" ("id", "value") VALUES (E'BZ', E'Beliza');
INSERT INTO "list" ("id", "value") VALUES (E'BE', E'Beļģija');
INSERT INTO "list" ("id", "value") VALUES (E'BJ', E'Benina');
INSERT INTO "list" ("id", "value") VALUES (E'BM', E'Bermudu salas');
INSERT INTO "list" ("id", "value") VALUES (E'BO', E'Bolīvija');
INSERT INTO "list" ("id", "value") VALUES (E'BA', E'Bosnija un Hercegovina');
INSERT INTO "list" ("id", "value") VALUES (E'BW', E'Botsvāna');
INSERT INTO "list" ("id", "value") VALUES (E'BR', E'Brazīlija');
INSERT INTO "list" ("id", "value") VALUES (E'VG', E'Britu Virdžīnas');
INSERT INTO "list" ("id", "value") VALUES (E'BN', E'Bruneja');
INSERT INTO "list" ("id", "value") VALUES (E'BG', E'Bulgārija');
INSERT INTO "list" ("id", "value") VALUES (E'BF', E'Burkinafaso');
INSERT INTO "list" ("id", "value") VALUES (E'BI', E'Burundija');
INSERT INTO "list" ("id", "value") VALUES (E'BT', E'Butāna');
INSERT INTO "list" ("id", "value") VALUES (E'BV', E'Buvē sala');
INSERT INTO "list" ("id", "value") VALUES (E'CF', E'Centrālāfrikas Republika');
INSERT INTO "list" ("id", "value") VALUES (E'TD', E'Čada');
INSERT INTO "list" ("id", "value") VALUES (E'CZ', E'Čehija');
INSERT INTO "list" ("id", "value") VALUES (E'CL', E'Čīle');
INSERT INTO "list" ("id", "value") VALUES (E'DK', E'Dānija');
INSERT INTO "list" ("id", "value") VALUES (E'ZA', E'Dienvidāfrikas Republika');
INSERT INTO "list" ("id", "value") VALUES (E'GS', E'Dienviddžordžija un Dienvidsendviču salas');
INSERT INTO "list" ("id", "value") VALUES (E'KR', E'Dienvidkoreja');
INSERT INTO "list" ("id", "value") VALUES (E'SS', E'Dienvidsudāna');
INSERT INTO "list" ("id", "value") VALUES (E'DM', E'Dominika');
INSERT INTO "list" ("id", "value") VALUES (E'DO', E'Dominikāna');
INSERT INTO "list" ("id", "value") VALUES (E'JE', E'Džērsija');
INSERT INTO "list" ("id", "value") VALUES (E'DJ', E'Džibutija');
INSERT INTO "list" ("id", "value") VALUES (E'EG', E'Ēģipte');
INSERT INTO "list" ("id", "value") VALUES (E'EC', E'Ekvadora');
INSERT INTO "list" ("id", "value") VALUES (E'GQ', E'Ekvatoriālā Gvineja');
INSERT INTO "list" ("id", "value") VALUES (E'ER', E'Eritreja');
INSERT INTO "list" ("id", "value") VALUES (E'ET', E'Etiopija');
INSERT INTO "list" ("id", "value") VALUES (E'FO', E'Fēru salas');
INSERT INTO "list" ("id", "value") VALUES (E'FJ', E'Fidži');
INSERT INTO "list" ("id", "value") VALUES (E'PH', E'Filipīnas');
INSERT INTO "list" ("id", "value") VALUES (E'FK', E'Folklenda salas');
INSERT INTO "list" ("id", "value") VALUES (E'FR', E'Francija');
INSERT INTO "list" ("id", "value") VALUES (E'TF', E'Francijas Dienvidjūru teritorija');
INSERT INTO "list" ("id", "value") VALUES (E'GF', E'Francijas Gviāna');
INSERT INTO "list" ("id", "value") VALUES (E'PF', E'Francijas Polinēzija');
INSERT INTO "list" ("id", "value") VALUES (E'GA', E'Gabona');
INSERT INTO "list" ("id", "value") VALUES (E'GY', E'Gajāna');
INSERT INTO "list" ("id", "value") VALUES (E'GM', E'Gambija');
INSERT INTO "list" ("id", "value") VALUES (E'GH', E'Gana');
INSERT INTO "list" ("id", "value") VALUES (E'GG', E'Gērnsija');
INSERT INTO "list" ("id", "value") VALUES (E'GI', E'Gibraltārs');
INSERT INTO "list" ("id", "value") VALUES (E'GD', E'Grenāda');
INSERT INTO "list" ("id", "value") VALUES (E'GL', E'Grenlande');
INSERT INTO "list" ("id", "value") VALUES (E'GR', E'Grieķija');
INSERT INTO "list" ("id", "value") VALUES (E'GE', E'Gruzija');
INSERT INTO "list" ("id", "value") VALUES (E'GU', E'Guama');
INSERT INTO "list" ("id", "value") VALUES (E'GP', E'Gvadelupa');
INSERT INTO "list" ("id", "value") VALUES (E'GT', E'Gvatemala');
INSERT INTO "list" ("id", "value") VALUES (E'GN', E'Gvineja');
INSERT INTO "list" ("id", "value") VALUES (E'GW', E'Gvineja-Bisava');
INSERT INTO "list" ("id", "value") VALUES (E'HT', E'Haiti');
INSERT INTO "list" ("id", "value") VALUES (E'HM', E'Hērda sala un Makdonalda salas');
INSERT INTO "list" ("id", "value") VALUES (E'HN', E'Hondurasa');
INSERT INTO "list" ("id", "value") VALUES (E'HR', E'Horvātija');
INSERT INTO "list" ("id", "value") VALUES (E'EE', E'Igaunija');
INSERT INTO "list" ("id", "value") VALUES (E'IN', E'Indija');
INSERT INTO "list" ("id", "value") VALUES (E'IO', E'Indijas okeāna Britu teritorija');
INSERT INTO "list" ("id", "value") VALUES (E'ID', E'Indonēzija');
INSERT INTO "list" ("id", "value") VALUES (E'IQ', E'Irāka');
INSERT INTO "list" ("id", "value") VALUES (E'IR', E'Irāna');
INSERT INTO "list" ("id", "value") VALUES (E'IE', E'Īrija');
INSERT INTO "list" ("id", "value") VALUES (E'IS', E'Islande');
INSERT INTO "list" ("id", "value") VALUES (E'IT', E'Itālija');
INSERT INTO "list" ("id", "value") VALUES (E'IL', E'Izraēla');
INSERT INTO "list" ("id", "value") VALUES (E'JM', E'Jamaika');
INSERT INTO "list" ("id", "value") VALUES (E'JP', E'Japāna');
INSERT INTO "list" ("id", "value") VALUES (E'NC', E'Jaunkaledonija');
INSERT INTO "list" ("id", "value") VALUES (E'NZ', E'Jaunzēlande');
INSERT INTO "list" ("id", "value") VALUES (E'YE', E'Jemena');
INSERT INTO "list" ("id", "value") VALUES (E'JO', E'Jordānija');
INSERT INTO "list" ("id", "value") VALUES (E'CV', E'Kaboverde');
INSERT INTO "list" ("id", "value") VALUES (E'KY', E'Kaimanu salas');
INSERT INTO "list" ("id", "value") VALUES (E'KH', E'Kambodža');
INSERT INTO "list" ("id", "value") VALUES (E'CM', E'Kamerūna');
INSERT INTO "list" ("id", "value") VALUES (E'CA', E'Kanāda');
INSERT INTO "list" ("id", "value") VALUES (E'QA', E'Katara');
INSERT INTO "list" ("id", "value") VALUES (E'KZ', E'Kazahstāna');
INSERT INTO "list" ("id", "value") VALUES (E'KE', E'Kenija');
INSERT INTO "list" ("id", "value") VALUES (E'CY', E'Kipra');
INSERT INTO "list" ("id", "value") VALUES (E'CW', E'Kirasao');
INSERT INTO "list" ("id", "value") VALUES (E'KG', E'Kirgizstāna');
INSERT INTO "list" ("id", "value") VALUES (E'KI', E'Kiribati');
INSERT INTO "list" ("id", "value") VALUES (E'CC', E'Kokosu (Kīlinga) salas');
INSERT INTO "list" ("id", "value") VALUES (E'CO', E'Kolumbija');
INSERT INTO "list" ("id", "value") VALUES (E'KM', E'Komoru salas');
INSERT INTO "list" ("id", "value") VALUES (E'CG', E'Kongo (Brazavila)');
INSERT INTO "list" ("id", "value") VALUES (E'CD', E'Kongo (Kinšasa)');
INSERT INTO "list" ("id", "value") VALUES (E'CR', E'Kostarika');
INSERT INTO "list" ("id", "value") VALUES (E'CI', E'Kotdivuāra');
INSERT INTO "list" ("id", "value") VALUES (E'RU', E'Krievija');
INSERT INTO "list" ("id", "value") VALUES (E'CU', E'Kuba');
INSERT INTO "list" ("id", "value") VALUES (E'CK', E'Kuka salas');
INSERT INTO "list" ("id", "value") VALUES (E'KW', E'Kuveita');
INSERT INTO "list" ("id", "value") VALUES (E'CN', E'Ķīna');
INSERT INTO "list" ("id", "value") VALUES (E'HK', E'Ķīnas īpašās pārvaldes apgabals Honkonga');
INSERT INTO "list" ("id", "value") VALUES (E'MO', E'ĶTR īpašais administratīvais reģions Makao');
INSERT INTO "list" ("id", "value") VALUES (E'LA', E'Laosa');
INSERT INTO "list" ("id", "value") VALUES (E'LV', E'Latvija');
INSERT INTO "list" ("id", "value") VALUES (E'LS', E'Lesoto');
INSERT INTO "list" ("id", "value") VALUES (E'LB', E'Libāna');
INSERT INTO "list" ("id", "value") VALUES (E'LR', E'Libērija');
INSERT INTO "list" ("id", "value") VALUES (E'LY', E'Lībija');
INSERT INTO "list" ("id", "value") VALUES (E'LT', E'Lietuva');
INSERT INTO "list" ("id", "value") VALUES (E'LI', E'Lihtenšteina');
INSERT INTO "list" ("id", "value") VALUES (E'LU', E'Luksemburga');
INSERT INTO "list" ("id", "value") VALUES (E'MG', E'Madagaskara');
INSERT INTO "list" ("id", "value") VALUES (E'YT', E'Majota');
INSERT INTO "list" ("id", "value") VALUES (E'MY', E'Malaizija');
INSERT INTO "list" ("id", "value") VALUES (E'MW', E'Malāvija');
INSERT INTO "list" ("id", "value") VALUES (E'MV', E'Maldīvija');
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'Maroka');
INSERT INTO "list" ("id", "value") VALUES (E'MH', E'Māršala salas');
INSERT INTO "list" ("id", "value") VALUES (E'MQ', E'Martinika');
INSERT INTO "list" ("id", "value") VALUES (E'MU', E'Maurīcija');
INSERT INTO "list" ("id", "value") VALUES (E'MR', E'Mauritānija');
INSERT INTO "list" ("id", "value") VALUES (E'MX', E'Meksika');
INSERT INTO "list" ("id", "value") VALUES (E'ME', E'Melnkalne');
INSERT INTO "list" ("id", "value") VALUES (E'IM', E'Mena');
INSERT INTO "list" ("id", "value") VALUES (E'FM', E'Mikronēzija');
INSERT INTO "list" ("id", "value") VALUES (E'MM', E'Mjanma (Birma)');
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'Mongolija');
INSERT INTO "list" ("id", "value") VALUES (E'MS', E'Montserrata');
INSERT INTO "list" ("id", "value") VALUES (E'MZ', E'Mozambika');
INSERT INTO "list" ("id", "value") VALUES (E'NA', E'Namībija');
INSERT INTO "list" ("id", "value") VALUES (E'NR', E'Nauru');
INSERT INTO "list" ("id", "value") VALUES (E'NP', E'Nepāla');
INSERT INTO "list" ("id", "value") VALUES (E'NL', E'Nīderlande');
INSERT INTO "list" ("id", "value") VALUES (E'BQ', E'Nīderlandes Karību salas');
INSERT INTO "list" ("id", "value") VALUES (E'NE', E'Nigēra');
INSERT INTO "list" ("id", "value") VALUES (E'NG', E'Nigērija');
INSERT INTO "list" ("id", "value") VALUES (E'NI', E'Nikaragva');
INSERT INTO "list" ("id", "value") VALUES (E'NU', E'Niue');
INSERT INTO "list" ("id", "value") VALUES (E'NF', E'Norfolkas sala');
INSERT INTO "list" ("id", "value") VALUES (E'NO', E'Norvēģija');
INSERT INTO "list" ("id", "value") VALUES (E'AX', E'Olandes salas');
INSERT INTO "list" ("id", "value") VALUES (E'OM', E'Omāna');
INSERT INTO "list" ("id", "value") VALUES (E'PK', E'Pakistāna');
INSERT INTO "list" ("id", "value") VALUES (E'PW', E'Palau');
INSERT INTO "list" ("id", "value") VALUES (E'PS', E'Palestīna');
INSERT INTO "list" ("id", "value") VALUES (E'PA', E'Panama');
INSERT INTO "list" ("id", "value") VALUES (E'PG', E'Papua-Jaungvineja');
INSERT INTO "list" ("id", "value") VALUES (E'PY', E'Paragvaja');
INSERT INTO "list" ("id", "value") VALUES (E'PE', E'Peru');
INSERT INTO "list" ("id", "value") VALUES (E'PN', E'Pitkērnas salas');
INSERT INTO "list" ("id", "value") VALUES (E'PL', E'Polija');
INSERT INTO "list" ("id", "value") VALUES (E'PT', E'Portugāle');
INSERT INTO "list" ("id", "value") VALUES (E'PR', E'Puertoriko');
INSERT INTO "list" ("id", "value") VALUES (E'RE', E'Reinjona');
INSERT INTO "list" ("id", "value") VALUES (E'EH', E'Rietumsahāra');
INSERT INTO "list" ("id", "value") VALUES (E'RW', E'Ruanda');
INSERT INTO "list" ("id", "value") VALUES (E'RO', E'Rumānija');
INSERT INTO "list" ("id", "value") VALUES (E'SV', E'Salvadora');
INSERT INTO "list" ("id", "value") VALUES (E'WS', E'Samoa');
INSERT INTO "list" ("id", "value") VALUES (E'SM', E'Sanmarīno');
INSERT INTO "list" ("id", "value") VALUES (E'ST', E'Santome un Prinsipi');
INSERT INTO "list" ("id", "value") VALUES (E'SA', E'Saūda Arābija');
INSERT INTO "list" ("id", "value") VALUES (E'SC', E'Seišelu salas');
INSERT INTO "list" ("id", "value") VALUES (E'BL', E'Senbartelmī');
INSERT INTO "list" ("id", "value") VALUES (E'SN', E'Senegāla');
INSERT INTO "list" ("id", "value") VALUES (E'MF', E'Senmartēna');
INSERT INTO "list" ("id", "value") VALUES (E'PM', E'Senpjēra un Mikelona');
INSERT INTO "list" ("id", "value") VALUES (E'KN', E'Sentkitsa un Nevisa');
INSERT INTO "list" ("id", "value") VALUES (E'LC', E'Sentlūsija');
INSERT INTO "list" ("id", "value") VALUES (E'VC', E'Sentvinsenta un Grenadīnas');
INSERT INTO "list" ("id", "value") VALUES (E'RS', E'Serbija');
INSERT INTO "list" ("id", "value") VALUES (E'SG', E'Singapūra');
INSERT INTO "list" ("id", "value") VALUES (E'SX', E'Sintmārtena');
INSERT INTO "list" ("id", "value") VALUES (E'SY', E'Sīrija');
INSERT INTO "list" ("id", "value") VALUES (E'SL', E'Sjerraleone');
INSERT INTO "list" ("id", "value") VALUES (E'SK', E'Slovākija');
INSERT INTO "list" ("id", "value") VALUES (E'SI', E'Slovēnija');
INSERT INTO "list" ("id", "value") VALUES (E'SO', E'Somālija');
INSERT INTO "list" ("id", "value") VALUES (E'FI', E'Somija');
INSERT INTO "list" ("id", "value") VALUES (E'ES', E'Spānija');
INSERT INTO "list" ("id", "value") VALUES (E'SD', E'Sudāna');
INSERT INTO "list" ("id", "value") VALUES (E'SR', E'Surinama');
INSERT INTO "list" ("id", "value") VALUES (E'SH', E'Sv.Helēnas sala');
INSERT INTO "list" ("id", "value") VALUES (E'SJ', E'Svalbāra un Jana Majena sala');
INSERT INTO "list" ("id", "value") VALUES (E'SZ', E'Svatini');
INSERT INTO "list" ("id", "value") VALUES (E'LK', E'Šrilanka');
INSERT INTO "list" ("id", "value") VALUES (E'CH', E'Šveice');
INSERT INTO "list" ("id", "value") VALUES (E'TJ', E'Tadžikistāna');
INSERT INTO "list" ("id", "value") VALUES (E'TW', E'Taivāna');
INSERT INTO "list" ("id", "value") VALUES (E'TH', E'Taizeme');
INSERT INTO "list" ("id", "value") VALUES (E'TZ', E'Tanzānija');
INSERT INTO "list" ("id", "value") VALUES (E'TC', E'Tērksas un Kaikosas salas');
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'Trinidāda un Tobāgo');
INSERT INTO "list" ("id", "value") VALUES (E'TN', E'Tunisija');
INSERT INTO "list" ("id", "value") VALUES (E'TR', E'Turcija');
INSERT INTO "list" ("id", "value") VALUES (E'TM', E'Turkmenistāna');
INSERT INTO "list" ("id", "value") VALUES (E'TV', E'Tuvalu');
INSERT INTO "list" ("id", "value") VALUES (E'UG', E'Uganda');
INSERT INTO "list" ("id", "value") VALUES (E'UA', E'Ukraina');
INSERT INTO "list" ("id", "value") VALUES (E'HU', E'Ungārija');
INSERT INTO "list" ("id", "value") VALUES (E'UY', E'Urugvaja');
INSERT INTO "list" ("id", "value") VALUES (E'UZ', E'Uzbekistāna');
INSERT INTO "list" ("id", "value") VALUES (E'DE', E'Vācija');
INSERT INTO "list" ("id", "value") VALUES (E'VU', E'Vanuatu');
INSERT INTO "list" ("id", "value") VALUES (E'VA', E'Vatikāns');
INSERT INTO "list" ("id", "value") VALUES (E'VE', E'Venecuēla');
INSERT INTO "list" ("id", "value") VALUES (E'VN', E'Vjetnama');
INSERT INTO "list" ("id", "value") VALUES (E'WF', E'Volisa un Futunas salas');
INSERT INTO "list" ("id", "value") VALUES (E'SB', E'Zālamana salas');
INSERT INTO "list" ("id", "value") VALUES (E'ZM', E'Zambija');
INSERT INTO "list" ("id", "value") VALUES (E'KP', E'Ziemeļkoreja');
INSERT INTO "list" ("id", "value") VALUES (E'MK', E'Ziemeļmaķedonija');
INSERT INTO "list" ("id", "value") VALUES (E'MP', E'Ziemeļu Marianas salas');
INSERT INTO "list" ("id", "value") VALUES (E'CX', E'Ziemsvētku sala');
INSERT INTO "list" ("id", "value") VALUES (E'ZW', E'Zimbabve');
INSERT INTO "list" ("id", "value") VALUES (E'SE', E'Zviedrija');
