external_country_iso_fts
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | country | capital | external_country_iso_fts | rank |
---|---|---|---|---|---|
239 | 239 | Yugoslavia | 383 | ||
238 | 238 | United States Minor Outlying Islands | 383 | ||
237 | 237 | South Georgia and the South Sandwich Islands | 383 | ||
236 | 236 | Saint Helena | 383 | ||
235 | 235 | Heard Island and McDonald Islands | 383 | ||
234 | 234 | French Southern and Antarctic Lands | 383 | ||
233 | 233 | France, Metropolitan | 383 | ||
232 | 232 | East Timor | 383 | ||
231 | 231 | British Indian Ocean Territory | 383 | ||
230 | 230 | Bouvet Island | 383 | ||
229 | 229 | Antarctica | 383 | ||
228 | 228 | Macau (China) | Macau | 383 | |
227 | 227 | Hong Kong (China) | Victoria | 383 | |
226 | 226 | Zimbabwe | Harare | 383 | |
225 | 225 | Zambia | Lusaka | 383 | |
224 | 224 | Zaire (Dem Rep of Congo) | Kinshasa | 383 | |
223 | 223 | Yemen | Sanaa | 383 | |
222 | 222 | Western Samoa | Apia | 383 | |
221 | 221 | Western Sahara | none | 383 | |
220 | 220 | Wallis and Futuna | Mata-Utu (on Ile Uvea) | 383 | |
219 | 219 | Virgin Islands | Charlotte Amalie | 383 | |
218 | 218 | Vietnam | Hanoi | 383 | |
217 | 217 | Venezuela | Caracas | 383 | |
216 | 216 | Vanuatu | Port-Vila | 383 | |
215 | 215 | Uzbekistan | Tashkent (Toshkent) | 383 | |
214 | 214 | Uruguay | Montevideo | 383 | |
213 | 213 | United States | Washington, DC | 383 | |
212 | 212 | United Kingdom | London | 383 | |
211 | 211 | United Arab Emirates | Abu Dhabi | 383 | |
210 | 210 | Ukraine | Kiev | 383 | |
209 | 209 | Uganda | Kampala | 383 | |
208 | 208 | Tuvalu | Funafuti | 383 | |
207 | 207 | Turks and Caicos Islands | Grand Turk | 383 | |
206 | 206 | Turkmenistan | Ashgabat | 383 | |
205 | 205 | Turkey | Ankara | 383 | |
204 | 204 | Tunisia | Tunis | 383 | |
203 | 203 | Trinidad and Tobago | Port-of-Spain | 383 | |
202 | 202 | Tonga | Nuku'alofa | 383 | |
201 | 201 | Tokelau | none | 383 | |
200 | 200 | Togo | Lome | 383 | |
199 | 199 | Thailand | Bangkok | 383 | |
198 | 198 | Tanzania | Dar es Salaam | 383 | |
197 | 197 | Tajikistan | Dushanbe | 383 | |
196 | 196 | Taiwan | Taipei | 383 | |
195 | 195 | Syria | Damascus | 383 | |
194 | 194 | Switzerland | Bern | 383 | |
193 | 193 | Sweden | Stockholm | 383 | |
192 | 192 | Swaziland | Mbabane | 383 | |
191 | 191 | Svalbard | Longyearbyen | 383 | |
190 | 190 | Suriname | Paramaribo | 383 | |
189 | 189 | Sudan | Khartoum | 383 | |
188 | 188 | Sri Lanka | Colombo | 383 | |
187 | 187 | Spain | Madrid | 383 | |
186 | 186 | South Africa | Pretoria | 383 | |
185 | 185 | Somalia | Mogadishu | 383 | |
184 | 184 | Solomon Islands | Honiara | 383 | |
183 | 183 | Slovenia | Ljubljana | 383 | |
182 | 182 | Slovakia | Bratislava | 383 | |
181 | 181 | Singapore | Singapore | 383 | |
180 | 180 | Sierra Leone | Freetown | 383 | |
179 | 179 | Seychelles | Victoria | 383 | |
178 | 178 | Senegal | Dakar | 383 | |
177 | 177 | Saudi Arabia | Riyadh | 383 | |
176 | 176 | Sao Tome and Principe | Sao Tome | 383 | |
175 | 175 | San Marino | San Marino | 383 | |
174 | 174 | Saint Vincent and the Grenadines | Kingstown | 383 | |
173 | 173 | Saint Pierre and Miquelon | Saint-Pierre | 383 | |
172 | 172 | Saint Lucia | Castries | 383 | |
171 | 171 | Saint Kitts and Nevis | Basseterre | 383 | |
170 | 170 | Rwanda | Kigali | 383 | |
169 | 169 | Russia | Moscow | 383 | |
168 | 168 | Romania | Bucharest | 383 | |
167 | 167 | Reunion | Saint-Denis | 383 | |
166 | 166 | Qatar | Doha | 383 | |
165 | 165 | Puerto Rico | San Juan | 383 | |
164 | 164 | Portugal | Lisbon | 383 | |
163 | 163 | Poland | Warsaw | 383 | |
162 | 162 | Pitcairn Islands | Adamstown | 383 | |
161 | 161 | Philippines | Manila | 383 | |
160 | 160 | Peru | Lima | 383 | |
159 | 159 | Paraguay | Asuncion | 383 | |
158 | 158 | Papua New Guinea | Port Moresby | 383 | |
157 | 157 | Panama | Panama | 383 | |
156 | 156 | Palau | Koror | 383 | |
155 | 155 | Pakistan | Islamabad | 383 | |
154 | 154 | Oman | Muscat | 383 | |
153 | 153 | Norway | Oslo | 383 | |
152 | 152 | Northern Mariana Islands | Saipan | 383 | |
151 | 151 | Norfolk Island | Kingston | 383 | |
150 | 150 | Niue | Alofi | 383 | |
149 | 149 | Nigeria | Abuja | 383 | |
148 | 148 | Niger | Niamey | 383 | |
147 | 147 | Nicaragua | Managua | 383 | |
146 | 146 | New Zealand | Wellington | 383 | |
145 | 145 | New Caledonia | Noumea | 383 | |
144 | 144 | Netherlands Antilles | Willemstad | 383 | |
143 | 143 | Netherlands | Amsterdam | 383 | |
142 | 142 | Nepal | Kathmandu | 383 | |
141 | 141 | Nauru | no official capital | 383 | |
140 | 140 | Namibia | Windhoek | 383 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [external_country_iso_fts] USING FTS5 ( [country], [capital], content=[external_country_iso] );