external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by country
This data as json, CSV (advanced)
Link | rowid | id | continent | region | country ▼ | capital | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
190 | 190 | 740 | Americas | South America | Suriname | Paramaribo | NS | SR | SUR | 740 | SR |
191 | 191 | 744 | Europe | Northern Europe | Svalbard | Longyearbyen | SV | SJ | SJM | 744 | SJ |
192 | 192 | 748 | Africa | Southern Africa | Swaziland | Mbabane | WZ | SZ | SWZ | 748 | SZ |
193 | 193 | 752 | Europe | Northern Europe | Sweden | Stockholm | SW | SE | SWE | 752 | SE |
194 | 194 | 756 | Europe | Central Europe | Switzerland | Bern | SZ | CH | CHE | 756 | CH |
195 | 195 | 760 | Asia | South West Asia | Syria | Damascus | SY | SY | SYR | 760 | SY |
196 | 196 | 158 | Asia | East Asia | Taiwan | Taipei | TW | TW | TWN | 158 | TW |
197 | 197 | 762 | Asia | Central Asia | Tajikistan | Dushanbe | TI | TJ | TJK | 762 | TJ |
198 | 198 | 834 | Africa | Eastern Africa | Tanzania | Dar es Salaam | TZ | TZ | TZA | 834 | TZ |
199 | 199 | 764 | Asia | South East Asia | Thailand | Bangkok | TH | TH | THA | 764 | TH |
200 | 200 | 768 | Africa | Western Africa | Togo | Lome | TO | TG | TGO | 768 | TG |
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 |
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 |
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 |
239 | 239 | 891 | Europe | South East Europe | Yugoslavia | YU | YUG | 891 | YU | ||
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 );