EeCDS5eB

1
2CREATE TABLE IF NOT EXISTS country(
3    id text not null primary key,
4    description text not null
5);
6
7
8insert into country(id, description) values('ABW', 'Aruba');
9insert into country(id, description) values('AFG', 'Afghanistan');
10insert into country(id, description) values('AGO', 'Angola');
11insert into country(id, description) values('AIA', 'Anguilla');
12insert into country(id, description) values('ALA', 'Aland Islands');
13insert into country(id, description) values('ALB', 'Albania');
14insert into country(id, description) values('AND', 'Andorra');
15insert into country(id, description) values('ARE', 'United Arab Emirates');
16insert into country(id, description) values('ARG', 'Argentina');
17insert into country(id, description) values('ARM', 'Armenia');
18insert into country(id, description) values('ASM', 'American Samoa');
19insert into country(id, description) values('ATA', 'Antarctica');
20insert into country(id, description) values('ATF', 'French Southern Territories');
21insert into country(id, description) values('ATG', 'Antigua and Barbuda');
22insert into country(id, description) values('AUS', 'Australia');
23insert into country(id, description) values('AUT', 'Austria');
24insert into country(id, description) values('AZE', 'Azerbaijan');
25insert into country(id, description) values('BDI', 'Burundi');
26insert into country(id, description) values('BEL', 'Belgium');
27insert into country(id, description) values('BEN', 'Benin');
28insert into country(id, description) values('BES', 'Bonaire, Sint Eustatius and Saba');
29insert into country(id, description) values('BFA', 'Burkina Faso');
30insert into country(id, description) values('BGD', 'Bangladesh');
31insert into country(id, description) values('BGR', 'Bulgaria');
32insert into country(id, description) values('BHR', 'Bahrain');
33insert into country(id, description) values('BHS', 'Bahamas');
34insert into country(id, description) values('BIH', 'Bosnia and Herzegovina');
35insert into country(id, description) values('BLM', 'Saint Barthélemy');
36insert into country(id, description) values('BLR', 'Belarus');
37insert into country(id, description) values('BLZ', 'Belize');
38insert into country(id, description) values('BMU', 'Bermuda');
39insert into country(id, description) values('BOL', 'Bolivia, Plurinational State of');
40insert into country(id, description) values('BRA', 'Brazil');
41insert into country(id, description) values('BRB', 'Barbados');
42insert into country(id, description) values('BRN', 'Brunei Darussalam');
43insert into country(id, description) values('BTN', 'Bhutan');
44insert into country(id, description) values('BVT', 'Bouvet Island');
45insert into country(id, description) values('BWA', 'Botswana');
46insert into country(id, description) values('CAF', 'Central African Republic');
47insert into country(id, description) values('CAN', 'Canada');
48insert into country(id, description) values('CCK', 'Cocos (Keeling) Islands');
49insert into country(id, description) values('CHE', 'Switzerland');
50insert into country(id, description) values('CHL', 'Chile');
51insert into country(id, description) values('CHN', 'China');
52insert into country(id, description) values('CIV', 'Cote d Ivoire');
53insert into country(id, description) values('CMR', 'Cameroon');
54insert into country(id, description) values('COD', 'Congo, the Democratic Republic of the');
55insert into country(id, description) values('COG', 'Congo');
56insert into country(id, description) values('COK', 'Cook Islands');
57insert into country(id, description) values('COL', 'Colombia');
58insert into country(id, description) values('COM', 'Comoros');
59insert into country(id, description) values('CPV', 'Cabo Verde');
60insert into country(id, description) values('CRI', 'Costa Rica');
61insert into country(id, description) values('CUB', 'Cuba');
62insert into country(id, description) values('CUW', 'Curaçao');
63insert into country(id, description) values('CXR', 'Christmas Island');
64insert into country(id, description) values('CYM', 'Cayman Islands');
65insert into country(id, description) values('CYP', 'Cyprus');
66insert into country(id, description) values('CZE', 'Czechia');
67insert into country(id, description) values('DEU', 'Germany');
68insert into country(id, description) values('DJI', 'Djibouti');
69insert into country(id, description) values('DMA', 'Dominica');
70insert into country(id, description) values('DNK', 'Denmark');
71insert into country(id, description) values('DOM', 'Dominican Republic');
72insert into country(id, description) values('DZA', 'Algeria');
73insert into country(id, description) values('ECU', 'Ecuador');
74insert into country(id, description) values('EGY', 'Egypt');
75insert into country(id, description) values('ERI', 'Eritrea');
76insert into country(id, description) values('ESH', 'Western Sahara');
77insert into country(id, description) values('ESP', 'Spain');
78insert into country(id, description) values('EST', 'Estonia');
79insert into country(id, description) values('ETH', 'Ethiopia');
80insert into country(id, description) values('FIN', 'Finland');
81insert into country(id, description) values('FJI', 'Fiji');
82insert into country(id, description) values('FLK', 'Falkland Islands (Malvinas)');
83insert into country(id, description) values('FRA', 'France');
84insert into country(id, description) values('FRO', 'Faroe Islands');
85insert into country(id, description) values('FSM', 'Micronesia, Federated States of');
86insert into country(id, description) values('GAB', 'Gabon');
87insert into country(id, description) values('GBR', 'United Kingdom');
88insert into country(id, description) values('GEO', 'Georgia');
89insert into country(id, description) values('GGY', 'Guernsey');
90insert into country(id, description) values('GHA', 'Ghana');
91insert into country(id, description) values('GIB', 'Gibraltar');
92insert into country(id, description) values('GIN', 'Guinea');
93insert into country(id, description) values('GLP', 'Guadeloupe');
94insert into country(id, description) values('GMB', 'Gambia');
95insert into country(id, description) values('GNB', 'Guinea-Bissau');
96insert into country(id, description) values('GNQ', 'Equatorial Guinea');
97insert into country(id, description) values('GRC', 'Greece');
98insert into country(id, description) values('GRD', 'Grenada');
99insert into country(id, description) values('GRL', 'Greenland');
100insert into country(id, description) values('GTM', 'Guatemala');
101insert into country(id, description) values('GUF', 'French Guiana');
102insert into country(id, description) values('GUM', 'Guam');
103insert into country(id, description) values('GUY', 'Guyana');
104insert into country(id, description) values('HKG', 'Hong Kong');
105insert into country(id, description) values('HMD', 'Heard Island and McDonald Islands');
106insert into country(id, description) values('HND', 'Honduras');
107insert into country(id, description) values('HRV', 'Croatia');
108insert into country(id, description) values('HTI', 'Haiti');
109insert into country(id, description) values('HUN', 'Hungary');
110insert into country(id, description) values('IDN', 'Indonesia');
111insert into country(id, description) values('IMN', 'Isle of Man');
112insert into country(id, description) values('IND', 'India');
113insert into country(id, description) values('IOT', 'British Indian Ocean Territory');
114insert into country(id, description) values('IRL', 'Ireland');
115insert into country(id, description) values('IRN', 'Iran, Islamic Republic of');
116insert into country(id, description) values('IRQ', 'Iraq');
117insert into country(id, description) values('ISL', 'Iceland');
118insert into country(id, description) values('ISR', 'Israel');
119insert into country(id, description) values('ITA', 'Italy');
120insert into country(id, description) values('JAM', 'Jamaica');
121insert into country(id, description) values('JEY', 'Jersey');
122insert into country(id, description) values('JOR', 'Jordan');
123insert into country(id, description) values('JPN', 'Japan');
124insert into country(id, description) values('KAZ', 'Kazakhstan');
125insert into country(id, description) values('KEN', 'Kenya');
126insert into country(id, description) values('KGZ', 'Kyrgyzstan');
127insert into country(id, description) values('KHM', 'Cambodia');
128insert into country(id, description) values('KIR', 'Kiribati');
129insert into country(id, description) values('KNA', 'Saint Kitts and Nevis');
130insert into country(id, description) values('KOR', 'Korea, Republic of');
131insert into country(id, description) values('KWT', 'Kuwait');
132insert into country(id, description) values('LAO', 'Lao People s Democratic Republic');
133insert into country(id, description) values('LBN', 'Lebanon');
134insert into country(id, description) values('LBR', 'Liberia');
135insert into country(id, description) values('LBY', 'Libya');
136insert into country(id, description) values('LCA', 'Saint Lucia');
137insert into country(id, description) values('LIE', 'Liechtenstein');
138insert into country(id, description) values('LKA', 'Sri Lanka');
139insert into country(id, description) values('LSO', 'Lesotho');
140insert into country(id, description) values('LTU', 'Lithuania');
141insert into country(id, description) values('LUX', 'Luxembourg');
142insert into country(id, description) values('LVA', 'Latvia');
143insert into country(id, description) values('MAC', 'Macao');
144insert into country(id, description) values('MAF', 'Saint Martin (French part)');
145insert into country(id, description) values('MAR', 'Morocco');
146insert into country(id, description) values('MCO', 'Monaco');
147insert into country(id, description) values('MDA', 'Moldova, Republic of');
148insert into country(id, description) values('MDG', 'Madagascar');
149insert into country(id, description) values('MDV', 'Maldives');
150insert into country(id, description) values('MEX', 'Mexico');
151insert into country(id, description) values('MHL', 'Marshall Islands');
152insert into country(id, description) values('MKD', 'Macedonia, the former Yugoslav Republic of');
153insert into country(id, description) values('MLI', 'Mali');
154insert into country(id, description) values('MLT', 'Malta');
155insert into country(id, description) values('MMR', 'Myanmar');
156insert into country(id, description) values('MNE', 'Montenegro');
157insert into country(id, description) values('MNG', 'Mongolia');
158insert into country(id, description) values('MNP', 'Northern Mariana Islands');
159insert into country(id, description) values('MOZ', 'Mozambique');
160insert into country(id, description) values('MRT', 'Mauritania');
161insert into country(id, description) values('MSR', 'Montserrat');
162insert into country(id, description) values('MTQ', 'Martinique');
163insert into country(id, description) values('MUS', 'Mauritius');
164insert into country(id, description) values('MWI', 'Malawi');
165insert into country(id, description) values('MYS', 'Malaysia');
166insert into country(id, description) values('MYT', 'Mayotte');
167insert into country(id, description) values('NAM', 'Namibia');
168insert into country(id, description) values('NCL', 'New Caledonia');
169insert into country(id, description) values('NER', 'Niger');
170insert into country(id, description) values('NFK', 'Norfolk Island');
171insert into country(id, description) values('NGA', 'Nigeria');
172insert into country(id, description) values('NIC', 'Nicaragua');
173insert into country(id, description) values('NIU', 'Niue');
174insert into country(id, description) values('NLD', 'Netherlands');
175insert into country(id, description) values('NOR', 'Norway');
176insert into country(id, description) values('NPL', 'Nepal');
177insert into country(id, description) values('NRU', 'Nauru');
178insert into country(id, description) values('NZL', 'New Zealand');
179insert into country(id, description) values('OMN', 'Oman');
180insert into country(id, description) values('PAK', 'Pakistan');
181insert into country(id, description) values('PAN', 'Panama');
182insert into country(id, description) values('PCN', 'Pitcairn');
183insert into country(id, description) values('PER', 'Peru');
184insert into country(id, description) values('PHL', 'Philippines');
185insert into country(id, description) values('PLW', 'Palau');
186insert into country(id, description) values('PNG', 'Papua New Guinea');
187insert into country(id, description) values('POL', 'Poland');
188insert into country(id, description) values('PRI', 'Puerto Rico');
189insert into country(id, description) values('PRK', 'Korea, Democratic People\'s Republic of');
190insert into country(id, description) values('PRT', ' Portugal');
191insert into country(id, description) values('PRY', ' Paraguay');
192insert into country(id, description) values('PSE', ' Palestine, State of');
193insert into country(id, description) values('PYF', ' French Polynesia');
194insert into country(id, description) values('QAT', ' Qatar');
195insert into country(id, description) values('REU', ' Réunion');
196insert into country(id, description) values('ROU', ' Romania');
197insert into country(id, description) values('RUS', ' Russian Federation');
198insert into country(id, description) values('RWA', ' Rwanda');
199insert into country(id, description) values('SAU', 'Saudi Arabia');
200insert into country(id, description) values('SDN', 'Sudan');
201insert into country(id, description) values('SEN', 'Senegal');
202insert into country(id, description) values('SGP', 'Singapore');
203insert into country(id, description) values('SGS', 'South Georgia and the South Sandwich Islands');
204insert into country(id, description) values('SHN', 'Saint Helena, Ascension and Tristan da Cunha');
205insert into country(id, description) values('SJM', 'Svalbard and Jan Mayen');
206insert into country(id, description) values('SLB', 'Solomon Islands');
207insert into country(id, description) values('SLE', 'Sierra Leone');
208insert into country(id, description) values('SLV', 'El Salvador');
209insert into country(id, description) values('SMR', 'San Marino');
210insert into country(id, description) values('SOM', 'Somalia');
211insert into country(id, description) values('SPM', 'Saint Pierre and Miquelon');
212insert into country(id, description) values('SRB', 'Serbia');
213insert into country(id, description) values('SSD', 'South Sudan');
214insert into country(id, description) values('STP', 'Sao Tome and Principe');
215insert into country(id, description) values('SUR', 'Suriname');
216insert into country(id, description) values('SVK', 'Slovakia');
217insert into country(id, description) values('SVN', 'Slovenia');
218insert into country(id, description) values('SWE', 'Sweden');
219insert into country(id, description) values('SWZ', 'Swaziland');
220insert into country(id, description) values('SXM', 'Sint Maarten (Dutch part)');
221insert into country(id, description) values('SYC', 'Seychelles');
222insert into country(id, description) values('SYR', 'Syrian Arab Republic');
223insert into country(id, description) values('TCA', 'Turks and Caicos Islands');
224insert into country(id, description) values('TCD', 'Chad');
225insert into country(id, description) values('TGO', 'Togo');
226insert into country(id, description) values('THA', 'Thailand');
227insert into country(id, description) values('TJK', 'Tajikistan');
228insert into country(id, description) values('TKL', 'Tokelau');
229insert into country(id, description) values('TKM', 'Turkmenistan');
230insert into country(id, description) values('TLS', 'Timor-Leste');
231insert into country(id, description) values('TON', 'Tonga');
232insert into country(id, description) values('TTO', 'Trinidad and Tobago');
233insert into country(id, description) values('TUN', 'Tunisia');
234insert into country(id, description) values('TUR', 'Turkey');
235insert into country(id, description) values('TUV', 'Tuvalu');
236insert into country(id, description) values('TWN', 'Taiwan, Province of China');
237insert into country(id, description) values('TZA', 'Tanzania, United Republic of');
238insert into country(id, description) values('UGA', 'Uganda');
239insert into country(id, description) values('UKR', 'Ukraine');
240insert into country(id, description) values('UMI', 'United States Minor Outlying Islands');
241insert into country(id, description) values('URY', 'Uruguay');
242insert into country(id, description) values('USA', 'United States of America');
243insert into country(id, description) values('UZB', 'Uzbekistan');
244insert into country(id, description) values('VAT', 'Holy See (Vatican City State)');
245insert into country(id, description) values('VCT', 'Saint Vincent and the Grenadines');
246insert into country(id, description) values('VEN', 'Venezuela, Bolivarian Republic of');
247insert into country(id, description) values('VGB', 'Virgin Islands, British');
248insert into country(id, description) values('VIR', 'Virgin Islands, U.S.');
249insert into country(id, description) values('VNM', 'Viet Nam');
250insert into country(id, description) values('VUT', 'Vanuatu');
251insert into country(id, description) values('WLF', 'Wallis and Futuna');
252insert into country(id, description) values('WSM', 'Samoa');
253insert into country(id, description) values('YEM', 'Yemen');
254insert into country(id, description) values('ZAF', 'South Africa');
255insert into country(id, description) values('ZMB', 'Zambia');
256insert into country(id, description) values('ZWE', 'Zimbabwe');