external_country_iso_fts
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows
This data as json, CSV (advanced)
Link | rowid ▼ | country | capital | external_country_iso_fts | rank |
---|---|---|---|---|---|
101 | 101 | Japan | Tokyo | 426 | |
102 | 102 | Jordan | Amman | 426 | |
103 | 103 | Kazakhstan | Astana (Akmola) | 426 | |
104 | 104 | Kenya | Nairobi | 426 | |
105 | 105 | Kiribati | Tarawa | 426 | |
106 | 106 | Korea, North | P'yongyang | 426 | |
107 | 107 | Korea, South | Seoul | 426 | |
108 | 108 | Kuwait | Kuwait | 426 | |
109 | 109 | Kyrgyzstan | Bishkek | 426 | |
110 | 110 | Laos | Vientiane | 426 | |
111 | 111 | Latvia | Riga | 426 | |
112 | 112 | Lebanon | Beirut | 426 | |
113 | 113 | Lesotho | Maseru | 426 | |
114 | 114 | Liberia | Monrovia | 426 | |
115 | 115 | Libya | Tripoli | 426 | |
116 | 116 | Liechtenstein | Vaduz | 426 | |
117 | 117 | Lithuania | Vilnius | 426 | |
118 | 118 | Luxembourg | Luxembourg | 426 | |
119 | 119 | Macedonia | Skopje | 426 | |
120 | 120 | Madagascar | Antananarivo | 426 | |
121 | 121 | Malawi | Lilongwe | 426 | |
122 | 122 | Malaysia | Kuala Lumpur | 426 | |
123 | 123 | Maldives | Male (Maale) | 426 | |
124 | 124 | Mali | Bamako | 426 | |
125 | 125 | Malta | Valletta | 426 | |
126 | 126 | Marshall Islands | Majuro | 426 | |
127 | 127 | Martinique | Fort-de-France | 426 | |
128 | 128 | Mauritania | Nouakchott | 426 | |
129 | 129 | Mauritius | Port Louis | 426 | |
130 | 130 | Mayotte | Mamoutzou | 426 | |
131 | 131 | Mexico | Mexico | 426 | |
132 | 132 | Micronesia, Federated States of | Palikir | 426 | |
133 | 133 | Moldova | Chisinau | 426 | |
134 | 134 | Monaco | Monaco | 426 | |
135 | 135 | Mongolia | Ulaanbaatar | 426 | |
136 | 136 | Montserrat | Plymouth | 426 | |
137 | 137 | Morocco | Rabat | 426 | |
138 | 138 | Mozambique | Maputo | 426 | |
139 | 139 | Myanmar (Burma) | Rangoon (Yangon) | 426 | |
140 | 140 | Namibia | Windhoek | 426 | |
141 | 141 | Nauru | no official capital | 426 | |
142 | 142 | Nepal | Kathmandu | 426 | |
143 | 143 | Netherlands | Amsterdam | 426 | |
144 | 144 | Netherlands Antilles | Willemstad | 426 | |
145 | 145 | New Caledonia | Noumea | 426 | |
146 | 146 | New Zealand | Wellington | 426 | |
147 | 147 | Nicaragua | Managua | 426 | |
148 | 148 | Niger | Niamey | 426 | |
149 | 149 | Nigeria | Abuja | 426 | |
150 | 150 | Niue | Alofi | 426 | |
151 | 151 | Norfolk Island | Kingston | 426 | |
152 | 152 | Northern Mariana Islands | Saipan | 426 | |
153 | 153 | Norway | Oslo | 426 | |
154 | 154 | Oman | Muscat | 426 | |
155 | 155 | Pakistan | Islamabad | 426 | |
156 | 156 | Palau | Koror | 426 | |
157 | 157 | Panama | Panama | 426 | |
158 | 158 | Papua New Guinea | Port Moresby | 426 | |
159 | 159 | Paraguay | Asuncion | 426 | |
160 | 160 | Peru | Lima | 426 | |
161 | 161 | Philippines | Manila | 426 | |
162 | 162 | Pitcairn Islands | Adamstown | 426 | |
163 | 163 | Poland | Warsaw | 426 | |
164 | 164 | Portugal | Lisbon | 426 | |
165 | 165 | Puerto Rico | San Juan | 426 | |
166 | 166 | Qatar | Doha | 426 | |
167 | 167 | Reunion | Saint-Denis | 426 | |
168 | 168 | Romania | Bucharest | 426 | |
169 | 169 | Russia | Moscow | 426 | |
170 | 170 | Rwanda | Kigali | 426 | |
171 | 171 | Saint Kitts and Nevis | Basseterre | 426 | |
172 | 172 | Saint Lucia | Castries | 426 | |
173 | 173 | Saint Pierre and Miquelon | Saint-Pierre | 426 | |
174 | 174 | Saint Vincent and the Grenadines | Kingstown | 426 | |
175 | 175 | San Marino | San Marino | 426 | |
176 | 176 | Sao Tome and Principe | Sao Tome | 426 | |
177 | 177 | Saudi Arabia | Riyadh | 426 | |
178 | 178 | Senegal | Dakar | 426 | |
179 | 179 | Seychelles | Victoria | 426 | |
180 | 180 | Sierra Leone | Freetown | 426 | |
181 | 181 | Singapore | Singapore | 426 | |
182 | 182 | Slovakia | Bratislava | 426 | |
183 | 183 | Slovenia | Ljubljana | 426 | |
184 | 184 | Solomon Islands | Honiara | 426 | |
185 | 185 | Somalia | Mogadishu | 426 | |
186 | 186 | South Africa | Pretoria | 426 | |
187 | 187 | Spain | Madrid | 426 | |
188 | 188 | Sri Lanka | Colombo | 426 | |
189 | 189 | Sudan | Khartoum | 426 | |
190 | 190 | Suriname | Paramaribo | 426 | |
191 | 191 | Svalbard | Longyearbyen | 426 | |
192 | 192 | Swaziland | Mbabane | 426 | |
193 | 193 | Sweden | Stockholm | 426 | |
194 | 194 | Switzerland | Bern | 426 | |
195 | 195 | Syria | Damascus | 426 | |
196 | 196 | Taiwan | Taipei | 426 | |
197 | 197 | Tajikistan | Dushanbe | 426 | |
198 | 198 | Tanzania | Dar es Salaam | 426 | |
199 | 199 | Thailand | Bangkok | 426 | |
200 | 200 | Togo | Lome | 426 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [external_country_iso_fts] USING FTS5 ( [country], [capital], content=[external_country_iso] );