external_country_iso_fts
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by capital
This data as json, CSV (advanced)
Link | rowid | country | capital ▼ | external_country_iso_fts | rank |
---|---|---|---|---|---|
229 | 229 | Antarctica | 413 | ||
230 | 230 | Bouvet Island | 413 | ||
231 | 231 | British Indian Ocean Territory | 413 | ||
232 | 232 | East Timor | 413 | ||
233 | 233 | France, Metropolitan | 413 | ||
234 | 234 | French Southern and Antarctic Lands | 413 | ||
235 | 235 | Heard Island and McDonald Islands | 413 | ||
236 | 236 | Saint Helena | 413 | ||
237 | 237 | South Georgia and the South Sandwich Islands | 413 | ||
238 | 238 | United States Minor Outlying Islands | 413 | ||
239 | 239 | Yugoslavia | 413 | ||
211 | 211 | United Arab Emirates | Abu Dhabi | 413 | |
149 | 149 | Nigeria | Abuja | 413 | |
77 | 77 | Ghana | Accra | 413 | |
162 | 162 | Pitcairn Islands | Adamstown | 413 | |
65 | 65 | Ethiopia | Addis Ababa | 413 | |
3 | 3 | Algeria | Algiers | 413 | |
150 | 150 | Niue | Alofi | 413 | |
102 | 102 | Jordan | Amman | 413 | |
143 | 143 | Netherlands | Amsterdam | 413 | |
5 | 5 | Andorra | Andorra la Vella | 413 | |
205 | 205 | Turkey | Ankara | 413 | |
120 | 120 | Madagascar | Antananarivo | 413 | |
222 | 222 | Western Samoa | Apia | 413 | |
206 | 206 | Turkmenistan | Ashgabat | 413 | |
63 | 63 | Eritrea | Asmara | 413 | |
103 | 103 | Kazakhstan | Astana (Akmola) | 413 | |
159 | 159 | Paraguay | Asuncion | 413 | |
79 | 79 | Greece | Athens | 413 | |
48 | 48 | Cook Islands | Avarua | 413 | |
96 | 96 | Iraq | Baghdad | 413 | |
14 | 14 | Azerbaijan | Baku (Baki) | 413 | |
124 | 124 | Mali | Bamako | 413 | |
30 | 30 | Brunei | Bandar Seri Begawan | 413 | |
199 | 199 | Thailand | Bangkok | 413 | |
39 | 39 | Central African Republic | Bangui | 413 | |
74 | 74 | Gambia, The | Banjul | 413 | |
82 | 82 | Guadeloupe | Basse-Terre | 413 | |
171 | 171 | Saint Kitts and Nevis | Basseterre | 413 | |
42 | 42 | China | Beijing | 413 | |
112 | 112 | Lebanon | Beirut | 413 | |
21 | 21 | Belize | Belmopan | 413 | |
76 | 76 | Germany | Berlin | 413 | |
194 | 194 | Switzerland | Bern | 413 | |
109 | 109 | Kyrgyzstan | Bishkek | 413 | |
86 | 86 | Guinea-Bissau | Bissau | 413 | |
45 | 45 | Colombia | Bogota | 413 | |
28 | 28 | Brazil | Brasilia | 413 | |
182 | 182 | Slovakia | Bratislava | 413 | |
47 | 47 | Congo, Republic of the | Brazzaville | 413 | |
18 | 18 | Barbados | Bridgetown | 413 | |
20 | 20 | Belgium | Brussels | 413 | |
168 | 168 | Romania | Bucharest | 413 | |
91 | 91 | Hungary | Budapest | 413 | |
9 | 9 | Argentina | Buenos Aires | 413 | |
33 | 33 | Burundi | Bujumbura | 413 | |
60 | 60 | Egypt | Cairo | 413 | |
12 | 12 | Australia | Canberra | 413 | |
217 | 217 | Venezuela | Caracas | 413 | |
172 | 172 | Saint Lucia | Castries | 413 | |
71 | 71 | French Guiana | Cayenne | 413 | |
219 | 219 | Virgin Islands | Charlotte Amalie | 413 | |
133 | 133 | Moldova | Chisinau | 413 | |
188 | 188 | Sri Lanka | Colombo | 413 | |
85 | 85 | Guinea | Conakry | 413 | |
55 | 55 | Denmark | Copenhagen | 413 | |
178 | 178 | Senegal | Dakar | 413 | |
195 | 195 | Syria | Damascus | 413 | |
198 | 198 | Tanzania | Dar es Salaam | 413 | |
17 | 17 | Bangladesh | Dhaka | 413 | |
56 | 56 | Djibouti | Djibouti | 413 | |
166 | 166 | Qatar | Doha | 413 | |
97 | 97 | Ireland | Dublin | 413 | |
197 | 197 | Tajikistan | Dushanbe | 413 | |
127 | 127 | Martinique | Fort-de-France | 413 | |
180 | 180 | Sierra Leone | Freetown | 413 | |
208 | 208 | Tuvalu | Funafuti | 413 | |
27 | 27 | Botswana | Gaborone | 413 | |
38 | 38 | Cayman Islands | George Town | 413 | |
87 | 87 | Guyana | Georgetown | 413 | |
78 | 78 | Gibraltar | Gibraltar | 413 | |
207 | 207 | Turks and Caicos Islands | Grand Turk | 413 | |
84 | 84 | Guatemala | Guatemala | 413 | |
83 | 83 | Guam | Hagatna (Agana) | 413 | |
23 | 23 | Bermuda | Hamilton | 413 | |
218 | 218 | Vietnam | Hanoi | 413 | |
226 | 226 | Zimbabwe | Harare | 413 | |
52 | 52 | Cuba | Havana | 413 | |
69 | 69 | Finland | Helsinki | 413 | |
184 | 184 | Solomon Islands | Honiara | 413 | |
155 | 155 | Pakistan | Islamabad | 413 | |
94 | 94 | Indonesia | Jakarta | 413 | |
98 | 98 | Israel | Jerusalem | 413 | |
1 | 1 | Afghanistan | Kabul | 413 | |
209 | 209 | Uganda | Kampala | 413 | |
142 | 142 | Nepal | Kathmandu | 413 | |
189 | 189 | Sudan | Khartoum | 413 | |
210 | 210 | Ukraine | Kiev | 413 | |
170 | 170 | Rwanda | Kigali | 413 | |
100 | 100 | Jamaica | Kingston | 413 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [external_country_iso_fts] USING FTS5 ( [country], [capital], content=[external_country_iso] );