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 |
---|---|---|---|---|---|
151 | 151 | Norfolk Island | Kingston | 863 | |
174 | 174 | Saint Vincent and the Grenadines | Kingstown | 863 | |
224 | 224 | Zaire (Dem Rep of Congo) | Kinshasa | 863 | |
156 | 156 | Palau | Koror | 863 | |
122 | 122 | Malaysia | Kuala Lumpur | 863 | |
108 | 108 | Kuwait | Kuwait | 863 | |
25 | 25 | Bolivia | La Paz / Sucre | 863 | |
73 | 73 | Gabon | Libreville | 863 | |
121 | 121 | Malawi | Lilongwe | 863 | |
160 | 160 | Peru | Lima | 863 | |
164 | 164 | Portugal | Lisbon | 863 | |
183 | 183 | Slovenia | Ljubljana | 863 | |
200 | 200 | Togo | Lome | 863 | |
212 | 212 | United Kingdom | London | 863 | |
191 | 191 | Svalbard | Longyearbyen | 863 | |
6 | 6 | Angola | Luanda | 863 | |
225 | 225 | Zambia | Lusaka | 863 | |
118 | 118 | Luxembourg | Luxembourg | 863 | |
228 | 228 | Macau (China) | Macau | 863 | |
187 | 187 | Spain | Madrid | 863 | |
126 | 126 | Marshall Islands | Majuro | 863 | |
62 | 62 | Equatorial Guinea | Malabo | 863 | |
123 | 123 | Maldives | Male (Maale) | 863 | |
130 | 130 | Mayotte | Mamoutzou | 863 | |
147 | 147 | Nicaragua | Managua | 863 | |
16 | 16 | Bahrain | Manama | 863 | |
161 | 161 | Philippines | Manila | 863 | |
138 | 138 | Mozambique | Maputo | 863 | |
113 | 113 | Lesotho | Maseru | 863 | |
220 | 220 | Wallis and Futuna | Mata-Utu (on Ile Uvea) | 863 | |
192 | 192 | Swaziland | Mbabane | 863 | |
131 | 131 | Mexico | Mexico | 863 | |
19 | 19 | Belarus | Minsk | 863 | |
185 | 185 | Somalia | Mogadishu | 863 | |
134 | 134 | Monaco | Monaco | 863 | |
114 | 114 | Liberia | Monrovia | 863 | |
214 | 214 | Uruguay | Montevideo | 863 | |
46 | 46 | Comoros | Moroni | 863 | |
169 | 169 | Russia | Moscow | 863 | |
154 | 154 | Oman | Muscat | 863 | |
40 | 40 | Chad | N'Djamena | 863 | |
104 | 104 | Kenya | Nairobi | 863 | |
15 | 15 | Bahamas, The | Nassau | 863 | |
93 | 93 | India | New Delhi | 863 | |
148 | 148 | Niger | Niamey | 863 | |
53 | 53 | Cyprus | Nicosia | 863 | |
128 | 128 | Mauritania | Nouakchott | 863 | |
145 | 145 | New Caledonia | Noumea | 863 | |
202 | 202 | Tonga | Nuku'alofa | 863 | |
80 | 80 | Greenland | Nuuk (Godthab) | 863 | |
11 | 11 | Aruba | Oranjestad | 863 | |
153 | 153 | Norway | Oslo | 863 | |
36 | 36 | Canada | Ottawa | 863 | |
32 | 32 | Burkina Faso | Ouagadougou | 863 | |
106 | 106 | Korea, North | P'yongyang | 863 | |
4 | 4 | American Samoa | Pago Pago | 863 | |
132 | 132 | Micronesia, Federated States of | Palikir | 863 | |
157 | 157 | Panama | Panama | 863 | |
72 | 72 | French Polynesia | Papeete | 863 | |
190 | 190 | Suriname | Paramaribo | 863 | |
70 | 70 | France | Paris | 863 | |
34 | 34 | Cambodia | Phnom Penh | 863 | |
136 | 136 | Montserrat | Plymouth | 863 | |
129 | 129 | Mauritius | Port Louis | 863 | |
158 | 158 | Papua New Guinea | Port Moresby | 863 | |
216 | 216 | Vanuatu | Port-Vila | 863 | |
88 | 88 | Haiti | Port-au-Prince | 863 | |
203 | 203 | Trinidad and Tobago | Port-of-Spain | 863 | |
22 | 22 | Benin | Porto-Novo | 863 | |
54 | 54 | Czech Republic | Prague | 863 | |
37 | 37 | Cape Verde | Praia | 863 | |
186 | 186 | South Africa | Pretoria | 863 | |
59 | 59 | Ecuador | Quito | 863 | |
137 | 137 | Morocco | Rabat | 863 | |
139 | 139 | Myanmar (Burma) | Rangoon (Yangon) | 863 | |
92 | 92 | Iceland | Reykjavik | 863 | |
111 | 111 | Latvia | Riga | 863 | |
177 | 177 | Saudi Arabia | Riyadh | 863 | |
29 | 29 | British Virgin Islands | Road Town | 863 | |
99 | 99 | Italy | Rome | 863 | |
57 | 57 | Dominica | Roseau | 863 | |
81 | 81 | Grenada | Saint George's | 863 | |
8 | 8 | Antigua and Barbuda | Saint John's | 863 | |
167 | 167 | Reunion | Saint-Denis | 863 | |
173 | 173 | Saint Pierre and Miquelon | Saint-Pierre | 863 | |
152 | 152 | Northern Mariana Islands | Saipan | 863 | |
49 | 49 | Costa Rica | San Jose | 863 | |
165 | 165 | Puerto Rico | San Juan | 863 | |
175 | 175 | San Marino | San Marino | 863 | |
61 | 61 | El Salvador | San Salvador | 863 | |
223 | 223 | Yemen | Sanaa | 863 | |
41 | 41 | Chile | Santiago | 863 | |
58 | 58 | Dominican Republic | Santo Domingo | 863 | |
176 | 176 | Sao Tome and Principe | Sao Tome | 863 | |
26 | 26 | Bosnia and Herzegovina | Sarajevo | 863 | |
107 | 107 | Korea, South | Seoul | 863 | |
181 | 181 | Singapore | Singapore | 863 | |
119 | 119 | Macedonia | Skopje | 863 | |
31 | 31 | Bulgaria | Sofia | 863 | |
66 | 66 | Falkland Islands (Islas Malvinas) | Stanley | 863 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [external_country_iso_fts] USING FTS5 ( [country], [capital], content=[external_country_iso] );