external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by capital
This data as json, CSV (advanced)
Link | rowid | id | continent | region | country | capital ▼ | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
193 | 193 | 752 | Europe | Northern Europe | Sweden | Stockholm | SW | SE | SWE | 752 | SE |
68 | 68 | 242 | Oceania | Pacific | Fiji | Suva | FJ | FJ | FJI | 242 | FJ |
75 | 75 | 268 | Asia | South West Asia | Georgia | T'bilisi | GG | GE | GEO | 268 | GE |
196 | 196 | 158 | Asia | East Asia | Taiwan | Taipei | TW | TW | TWN | 158 | TW |
64 | 64 | 233 | Europe | Eastern Europe | Estonia | Tallinn | EN | EE | EST | 233 | EE |
105 | 105 | 296 | Oceania | Pacific | Kiribati | Tarawa | KR | KI | KIR | 296 | KI |
215 | 215 | 860 | Asia | Central Asia | Uzbekistan | Tashkent (Toshkent) | UZ | UZ | UZB | 860 | UZ |
90 | 90 | 340 | Americas | Central America | Honduras | Tegucigalpa | HO | HN | HND | 340 | HN |
95 | 95 | 364 | Asia | South West Asia | Iran | Tehran | IR | IR | IRN | 364 | IR |
43 | 43 | 162 | Asia | South East Asia | Christmas Island | The Settlement | KT | CX | CXR | 162 | CX |
7 | 7 | 660 | Americas | West Indies | Anguilla | The Valley | AV | AI | AIA | 660 | AI |
24 | 24 | 64 | Asia | South Asia | Bhutan | Thimphu | BT | BT | BTN | 64 | BT |
2 | 2 | 8 | Europe | South East Europe | Albania | Tirana | AL | AL | ALB | 8 | AL |
101 | 101 | 392 | Asia | East Asia | Japan | Tokyo | JA | JP | JPN | 392 | JP |
67 | 67 | 234 | Europe | Northern Europe | Faroe Islands | Torshavn | FO | FO | FRO | 234 | FO |
115 | 115 | 434 | Africa | Northern Africa | Libya | Tripoli | LY | LY | LBY | 434 | LY |
204 | 204 | 788 | Africa | Northern Africa | Tunisia | Tunis | TS | TN | TUN | 788 | TN |
135 | 135 | 496 | Asia | Northern Asia | Mongolia | Ulaanbaatar | MG | MN | MNG | 496 | MN |
116 | 116 | 438 | Europe | Central Europe | Liechtenstein | Vaduz | LS | LI | LIE | 438 | LI |
125 | 125 | 470 | Europe | Southern Europe | Malta | Valletta | MT | MT | MLT | 470 | MT |
89 | 89 | 336 | Europe | Southern Europe | Holy See (Vatican City) | Vatican City | VT | VA | VAT | 336 | VA |
179 | 179 | 690 | Africa | Indian Ocean | Seychelles | Victoria | SE | SC | SYC | 690 | SC |
227 | 227 | 344 | Asia | East Asia | Hong Kong (China) | Victoria | HK | HK | HKG | 344 | HK |
13 | 13 | 40 | Europe | Central Europe | Austria | Vienna | AU | AT | AUT | 40 | AT |
110 | 110 | 418 | Asia | South East Asia | Laos | Vientiane | LA | LA | LAO | 418 | LA |
117 | 117 | 440 | Europe | Eastern Europe | Lithuania | Vilnius | LH | LT | LTU | 440 | LT |
163 | 163 | 616 | Europe | Eastern Europe | Poland | Warsaw | PL | PL | POL | 616 | PL |
213 | 213 | 840 | Americas | North America | United States | Washington, DC | US | US | USA | 840 | US |
146 | 146 | 554 | Oceania | Pacific | New Zealand | Wellington | NZ | NZ | NZL | 554 | NZ |
44 | 44 | 166 | Asia | South East Asia | Cocos (Keeling) Islands | West Island | CK | CC | CCK | 166 | CC |
144 | 144 | 530 | Americas | West Indies | Netherlands Antilles | Willemstad | NT | AN | ANT | 530 | AN |
140 | 140 | 516 | Africa | Southern Africa | Namibia | Windhoek | WA | NAM | 516 | ||
50 | 50 | 384 | Africa | Western Africa | Cote d'Ivoire | Yamoussoukro | IV | CI | CIV | 384 | CI |
35 | 35 | 120 | Africa | Western Africa | Cameroon | Yaounde | CM | CM | CMR | 120 | CM |
10 | 10 | 51 | Asia | South West Asia | Armenia | Yerevan | AM | AM | ARM | 51 | AM |
51 | 51 | 191 | Europe | South East Europe | Croatia | Zagreb | HR | HR | HRV | 191 | HR |
141 | 141 | 520 | Oceania | Pacific | Nauru | no official capital | NR | NR | NRU | 520 | NR |
201 | 201 | 772 | Oceania | Pacific | Tokelau | none | TL | TK | TKL | 772 | TK |
221 | 221 | 732 | Africa | Northern Africa | Western Sahara | none | WI | EH | ESH | 732 | EH |
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 );