external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by iso3
This data as json, CSV (advanced)
Link | rowid | id | continent | region | country | capital | fips | iso2 | iso3 ▼ | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
192 | 192 | 748 | Africa | Southern Africa | Swaziland | Mbabane | WZ | SZ | SWZ | 748 | SZ |
179 | 179 | 690 | Africa | Indian Ocean | Seychelles | Victoria | SE | SC | SYC | 690 | SC |
195 | 195 | 760 | Asia | South West Asia | Syria | Damascus | SY | SY | SYR | 760 | SY |
207 | 207 | 796 | Americas | West Indies | Turks and Caicos Islands | Grand Turk | TK | TC | TCA | 796 | TC |
40 | 40 | 148 | Africa | Central Africa | Chad | N'Djamena | CD | TD | TCD | 148 | TD |
200 | 200 | 768 | Africa | Western Africa | Togo | Lome | TO | TG | TGO | 768 | TG |
199 | 199 | 764 | Asia | South East Asia | Thailand | Bangkok | TH | TH | THA | 764 | TH |
197 | 197 | 762 | Asia | Central Asia | Tajikistan | Dushanbe | TI | TJ | TJK | 762 | TJ |
201 | 201 | 772 | Oceania | Pacific | Tokelau | none | TL | TK | TKL | 772 | TK |
206 | 206 | 795 | Asia | Central Asia | Turkmenistan | Ashgabat | TX | TM | TKM | 795 | TM |
232 | 232 | 626 | Asia | South East Asia | East Timor | TP | TMP | 626 | TP | ||
202 | 202 | 776 | Oceania | Pacific | Tonga | Nuku'alofa | TN | TO | TON | 776 | TO |
203 | 203 | 780 | Americas | West Indies | Trinidad and Tobago | Port-of-Spain | TD | TT | TTO | 780 | TT |
204 | 204 | 788 | Africa | Northern Africa | Tunisia | Tunis | TS | TN | TUN | 788 | TN |
205 | 205 | 792 | Asia | South West Asia | Turkey | Ankara | TU | TR | TUR | 792 | TR |
208 | 208 | 798 | Oceania | Pacific | Tuvalu | Funafuti | TV | TV | TUV | 798 | TV |
196 | 196 | 158 | Asia | East Asia | Taiwan | Taipei | TW | TW | TWN | 158 | TW |
198 | 198 | 834 | Africa | Eastern Africa | Tanzania | Dar es Salaam | TZ | TZ | TZA | 834 | TZ |
209 | 209 | 800 | Africa | Eastern Africa | Uganda | Kampala | UG | UG | UGA | 800 | UG |
210 | 210 | 804 | Europe | Eastern Europe | Ukraine | Kiev | UP | UA | UKR | 804 | UA |
238 | 238 | 581 | Oceania | North Pacific Ocean | United States Minor Outlying Islands | UM | UMI | 581 | UM | ||
214 | 214 | 858 | Americas | South America | Uruguay | Montevideo | UY | UY | URY | 858 | UY |
213 | 213 | 840 | Americas | North America | United States | Washington, DC | US | US | USA | 840 | US |
215 | 215 | 860 | Asia | Central Asia | Uzbekistan | Tashkent (Toshkent) | UZ | UZ | UZB | 860 | UZ |
89 | 89 | 336 | Europe | Southern Europe | Holy See (Vatican City) | Vatican City | VT | VA | VAT | 336 | VA |
174 | 174 | 670 | Americas | West Indies | Saint Vincent and the Grenadines | Kingstown | VC | VC | VCT | 670 | VC |
217 | 217 | 862 | Americas | South America | Venezuela | Caracas | VE | VE | VEN | 862 | UE |
29 | 29 | 92 | Americas | West Indies | British Virgin Islands | Road Town | VI | VG | VGB | 92 | VG |
219 | 219 | 850 | Americas | West Indies | Virgin Islands | Charlotte Amalie | VQ | VI | VIR | 850 | VI |
218 | 218 | 704 | Asia | South East Asia | Vietnam | Hanoi | VM | VN | VNM | 704 | VN |
216 | 216 | 548 | Oceania | Pacific | Vanuatu | Port-Vila | NH | VU | VUT | 548 | VU |
220 | 220 | 876 | Oceania | Pacific | Wallis and Futuna | Mata-Utu (on Ile Uvea) | WF | WF | WLF | 876 | WF |
222 | 222 | 882 | Oceania | Pacific | Western Samoa | Apia | WS | WS | WSM | 882 | WS |
223 | 223 | 887 | Asia | South West Asia | Yemen | Sanaa | YM | YE | YEM | 887 | YE |
239 | 239 | 891 | Europe | South East Europe | Yugoslavia | YU | YUG | 891 | YU | ||
186 | 186 | 710 | Africa | Southern Africa | South Africa | Pretoria | SF | ZA | ZAF | 710 | ZA |
224 | 224 | 180 | Africa | Central Africa | Zaire (Dem Rep of Congo) | Kinshasa | CG | ZR | ZAR | 180 | ZR |
225 | 225 | 894 | Africa | Southern Africa | Zambia | Lusaka | ZA | ZM | ZWB | 894 | ZM |
226 | 226 | 716 | Africa | Southern Africa | Zimbabwe | Harare | ZI | ZW | ZWE | 716 | ZW |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE external_country_iso ( id INTEGER, continent TEXT, region TEXT, country TEXT, capital TEXT, fips TEXT, iso2 TEXT, iso3 TEXT, isonumeric INTEGER, internet TEXT );