external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows
This data as json, CSV (advanced)
Link | rowid ▼ | id | continent | region | country | capital | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
201 | 201 | 772 | Oceania | Pacific | Tokelau | none | TL | TK | TKL | 772 | TK |
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 |
206 | 206 | 795 | Asia | Central Asia | Turkmenistan | Ashgabat | TX | TM | TKM | 795 | TM |
207 | 207 | 796 | Americas | West Indies | Turks and Caicos Islands | Grand Turk | TK | TC | TCA | 796 | TC |
208 | 208 | 798 | Oceania | Pacific | Tuvalu | Funafuti | TV | TV | TUV | 798 | TV |
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 |
211 | 211 | 784 | Asia | South West Asia | United Arab Emirates | Abu Dhabi | TC | AE | ARE | 784 | AE |
212 | 212 | 826 | Europe | Western Europe | United Kingdom | London | UK | GB | GBR | 826 | UK/GB |
213 | 213 | 840 | Americas | North America | United States | Washington, DC | US | US | USA | 840 | US |
214 | 214 | 858 | Americas | South America | Uruguay | Montevideo | UY | UY | URY | 858 | UY |
215 | 215 | 860 | Asia | Central Asia | Uzbekistan | Tashkent (Toshkent) | UZ | UZ | UZB | 860 | UZ |
216 | 216 | 548 | Oceania | Pacific | Vanuatu | Port-Vila | NH | VU | VUT | 548 | VU |
217 | 217 | 862 | Americas | South America | Venezuela | Caracas | VE | VE | VEN | 862 | UE |
218 | 218 | 704 | Asia | South East Asia | Vietnam | Hanoi | VM | VN | VNM | 704 | VN |
219 | 219 | 850 | Americas | West Indies | Virgin Islands | Charlotte Amalie | VQ | VI | VIR | 850 | VI |
220 | 220 | 876 | Oceania | Pacific | Wallis and Futuna | Mata-Utu (on Ile Uvea) | WF | WF | WLF | 876 | WF |
221 | 221 | 732 | Africa | Northern Africa | Western Sahara | none | WI | EH | ESH | 732 | EH |
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 |
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 |
227 | 227 | 344 | Asia | East Asia | Hong Kong (China) | Victoria | HK | HK | HKG | 344 | HK |
228 | 228 | 446 | Asia | East Asia | Macau (China) | Macau | MC | MO | MAC | 446 | MO |
229 | 229 | 10 | Antarctica | Antarctica | Antarctica | AY | AQ | ATA | 10 | AQ | |
230 | 230 | 74 | Atlantic Ocean | South Atlantic Ocean | Bouvet Island | BV | BV | BVT | 74 | BV | |
231 | 231 | 86 | Asia | South Asia | British Indian Ocean Territory | IO | IO | IOT | 86 | IO | |
232 | 232 | 626 | Asia | South East Asia | East Timor | TP | TMP | 626 | TP | ||
233 | 233 | 249 | Europe | Western Europe | France, Metropolitan | FX | FXX | 249 | FX | ||
234 | 234 | 260 | Indian Ocean | Southern Indian Ocean | French Southern and Antarctic Lands | FS | TF | ATF | 260 | ||
235 | 235 | 334 | Indian Ocean | Southern Indian Ocean | Heard Island and McDonald Islands | HM | HM | HMD | 334 | HM | |
236 | 236 | 654 | Atlantic Ocean | South Atlantic Ocean | Saint Helena | SH | SH | SHN | 654 | SH | |
237 | 237 | 239 | Atlantic Ocean | South Atlantic Ocean | South Georgia and the South Sandwich Islands | SX | GS | SGS | 239 | GS | |
238 | 238 | 581 | Oceania | North Pacific Ocean | United States Minor Outlying Islands | UM | UMI | 581 | UM | ||
239 | 239 | 891 | Europe | South East Europe | Yugoslavia | YU | YUG | 891 | YU |
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 );