external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by region
This data as json, CSV (advanced)
Suggested facets: region
continent 8 ✖
- Africa 56
- Asia 54
- Americas 51
- Europe 46
- Oceania 26
- Atlantic Ocean 3
- Indian Ocean 2
- Antarctica 1
Link | rowid | id | continent | region ▼ | country | capital | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
229 | 229 | 10 | Antarctica | Antarctica | Antarctica | AY | AQ | ATA | 10 | AQ | |
33 | 33 | 108 | Africa | Central Africa | Burundi | Bujumbura | BY | BI | BDI | 108 | BI |
39 | 39 | 140 | Africa | Central Africa | Central African Republic | Bangui | CT | CF | CAF | 140 | CF |
40 | 40 | 148 | Africa | Central Africa | Chad | N'Djamena | CD | TD | TCD | 148 | TD |
47 | 47 | 178 | Africa | Central Africa | Congo, Republic of the | Brazzaville | CF | CG | COG | 178 | CG |
170 | 170 | 646 | Africa | Central Africa | Rwanda | Kigali | RW | RW | RWA | 646 | RW |
224 | 224 | 180 | Africa | Central Africa | Zaire (Dem Rep of Congo) | Kinshasa | CG | ZR | ZAR | 180 | ZR |
21 | 21 | 84 | Americas | Central America | Belize | Belmopan | BH | BZ | BLZ | 84 | BZ |
49 | 49 | 188 | Americas | Central America | Costa Rica | San Jose | CS | CR | CRI | 188 | CR |
61 | 61 | 222 | Americas | Central America | El Salvador | San Salvador | ES | SV | SLV | 222 | SV |
84 | 84 | 320 | Americas | Central America | Guatemala | Guatemala | GT | GT | GTM | 320 | GT |
90 | 90 | 340 | Americas | Central America | Honduras | Tegucigalpa | HO | HN | HND | 340 | HN |
131 | 131 | 484 | Americas | Central America | Mexico | Mexico | MX | MX | MEX | 484 | MX |
147 | 147 | 558 | Americas | Central America | Nicaragua | Managua | NU | NI | NIC | 558 | NI |
157 | 157 | 591 | Americas | Central America | Panama | Panama | PM | PA | PAN | 591 | PA |
103 | 103 | 398 | Asia | Central Asia | Kazakhstan | Astana (Akmola) | KZ | KZ | KAZ | 398 | KZ |
109 | 109 | 417 | Asia | Central Asia | Kyrgyzstan | Bishkek | KG | KG | KGZ | 417 | KG |
197 | 197 | 762 | Asia | Central Asia | Tajikistan | Dushanbe | TI | TJ | TJK | 762 | TJ |
206 | 206 | 795 | Asia | Central Asia | Turkmenistan | Ashgabat | TX | TM | TKM | 795 | TM |
215 | 215 | 860 | Asia | Central Asia | Uzbekistan | Tashkent (Toshkent) | UZ | UZ | UZB | 860 | UZ |
13 | 13 | 40 | Europe | Central Europe | Austria | Vienna | AU | AT | AUT | 40 | AT |
54 | 54 | 203 | Europe | Central Europe | Czech Republic | Prague | EZ | CZ | CZE | 203 | CZ |
91 | 91 | 348 | Europe | Central Europe | Hungary | Budapest | HU | HU | HUN | 348 | HU |
116 | 116 | 438 | Europe | Central Europe | Liechtenstein | Vaduz | LS | LI | LIE | 438 | LI |
182 | 182 | 703 | Europe | Central Europe | Slovakia | Bratislava | LO | SK | SVK | 703 | SK |
194 | 194 | 756 | Europe | Central Europe | Switzerland | Bern | SZ | CH | CHE | 756 | CH |
42 | 42 | 156 | Asia | East Asia | China | Beijing | CH | CN | CHN | 156 | CN |
101 | 101 | 392 | Asia | East Asia | Japan | Tokyo | JA | JP | JPN | 392 | JP |
106 | 106 | 408 | Asia | East Asia | Korea, North | P'yongyang | KN | KP | PRK | 408 | KP |
107 | 107 | 410 | Asia | East Asia | Korea, South | Seoul | KS | KR | KOR | 410 | KR |
196 | 196 | 158 | Asia | East Asia | Taiwan | Taipei | TW | TW | TWN | 158 | TW |
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 |
56 | 56 | 262 | Africa | Eastern Africa | Djibouti | Djibouti | DJ | DJ | DJI | 262 | DJ |
63 | 63 | 232 | Africa | Eastern Africa | Eritrea | Asmara | ER | ER | ERI | 232 | ER |
65 | 65 | 231 | Africa | Eastern Africa | Ethiopia | Addis Ababa | ET | ET | ETH | 231 | ET |
104 | 104 | 404 | Africa | Eastern Africa | Kenya | Nairobi | KE | KE | KEN | 404 | KE |
185 | 185 | 706 | Africa | Eastern Africa | Somalia | Mogadishu | SO | SO | SOM | 706 | SO |
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 |
19 | 19 | 112 | Europe | Eastern Europe | Belarus | Minsk | BO | BY | BLR | 112 | BY |
64 | 64 | 233 | Europe | Eastern Europe | Estonia | Tallinn | EN | EE | EST | 233 | EE |
111 | 111 | 428 | Europe | Eastern Europe | Latvia | Riga | LG | LV | LVA | 428 | LV |
117 | 117 | 440 | Europe | Eastern Europe | Lithuania | Vilnius | LH | LT | LTU | 440 | LT |
133 | 133 | 498 | Europe | Eastern Europe | Moldova | Chisinau | MD | MD | MDA | 498 | MD |
163 | 163 | 616 | Europe | Eastern Europe | Poland | Warsaw | PL | PL | POL | 616 | PL |
210 | 210 | 804 | Europe | Eastern Europe | Ukraine | Kiev | UP | UA | UKR | 804 | UA |
46 | 46 | 174 | Africa | Indian Ocean | Comoros | Moroni | CN | KM | COM | 174 | KM |
120 | 120 | 450 | Africa | Indian Ocean | Madagascar | Antananarivo | MA | MG | MDG | 450 | MG |
129 | 129 | 480 | Africa | Indian Ocean | Mauritius | Port Louis | MP | MU | MUS | 480 | MU |
130 | 130 | 175 | Africa | Indian Ocean | Mayotte | Mamoutzou | MF | YT | MYT | 175 | YT |
167 | 167 | 638 | Africa | Indian Ocean | Reunion | Saint-Denis | RE | RE | REU | 638 | RE |
179 | 179 | 690 | Africa | Indian Ocean | Seychelles | Victoria | SE | SC | SYC | 690 | SC |
36 | 36 | 124 | Americas | North America | Canada | Ottawa | CA | CA | CAN | 124 | CA |
80 | 80 | 304 | Americas | North America | Greenland | Nuuk (Godthab) | GL | GL | GRL | 304 | GL |
173 | 173 | 666 | Americas | North America | Saint Pierre and Miquelon | Saint-Pierre | SB | PM | SPM | 666 | PM |
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 | ||
3 | 3 | 12 | Africa | Northern Africa | Algeria | Algiers | AG | DZ | DZA | 12 | DZ |
60 | 60 | 818 | Africa | Northern Africa | Egypt | Cairo | EG | EG | EGY | 818 | EG |
115 | 115 | 434 | Africa | Northern Africa | Libya | Tripoli | LY | LY | LBY | 434 | LY |
137 | 137 | 504 | Africa | Northern Africa | Morocco | Rabat | MO | MA | MAR | 504 | MA |
189 | 189 | 736 | Africa | Northern Africa | Sudan | Khartoum | SU | SD | SDN | 736 | SD |
204 | 204 | 788 | Africa | Northern Africa | Tunisia | Tunis | TS | TN | TUN | 788 | TN |
221 | 221 | 732 | Africa | Northern Africa | Western Sahara | none | WI | EH | ESH | 732 | EH |
135 | 135 | 496 | Asia | Northern Asia | Mongolia | Ulaanbaatar | MG | MN | MNG | 496 | MN |
169 | 169 | 643 | Asia | Northern Asia | Russia | Moscow | RS | RU | RUS | 643 | RU |
55 | 55 | 208 | Europe | Northern Europe | Denmark | Copenhagen | DA | DK | DNK | 208 | DK |
67 | 67 | 234 | Europe | Northern Europe | Faroe Islands | Torshavn | FO | FO | FRO | 234 | FO |
69 | 69 | 246 | Europe | Northern Europe | Finland | Helsinki | FI | FI | FIN | 246 | FI |
92 | 92 | 352 | Europe | Northern Europe | Iceland | Reykjavik | IC | IS | ISL | 352 | IS |
153 | 153 | 578 | Europe | Northern Europe | Norway | Oslo | NO | NO | NOR | 578 | NO |
191 | 191 | 744 | Europe | Northern Europe | Svalbard | Longyearbyen | SV | SJ | SJM | 744 | SJ |
193 | 193 | 752 | Europe | Northern Europe | Sweden | Stockholm | SW | SE | SWE | 752 | SE |
4 | 4 | 16 | Oceania | Pacific | American Samoa | Pago Pago | AQ | AS | ASM | 16 | AS |
12 | 12 | 36 | Oceania | Pacific | Australia | Canberra | AS | AU | AUS | 36 | AU |
48 | 48 | 184 | Oceania | Pacific | Cook Islands | Avarua | CW | CK | COK | 184 | CK |
68 | 68 | 242 | Oceania | Pacific | Fiji | Suva | FJ | FJ | FJI | 242 | FJ |
72 | 72 | 258 | Oceania | Pacific | French Polynesia | Papeete | FP | PF | PYF | 258 | PF |
83 | 83 | 316 | Oceania | Pacific | Guam | Hagatna (Agana) | GQ | GU | GUM | 316 | GU |
105 | 105 | 296 | Oceania | Pacific | Kiribati | Tarawa | KR | KI | KIR | 296 | KI |
126 | 126 | 584 | Oceania | Pacific | Marshall Islands | Majuro | RM | MH | MHL | 584 | MH |
132 | 132 | 583 | Oceania | Pacific | Micronesia, Federated States of | Palikir | FM | FSM | 583 | FM | |
141 | 141 | 520 | Oceania | Pacific | Nauru | no official capital | NR | NR | NRU | 520 | NR |
145 | 145 | 540 | Oceania | Pacific | New Caledonia | Noumea | NC | NC | NCL | 540 | NC |
146 | 146 | 554 | Oceania | Pacific | New Zealand | Wellington | NZ | NZ | NZL | 554 | NZ |
150 | 150 | 570 | Oceania | Pacific | Niue | Alofi | NE | NU | NIU | 570 | NU |
151 | 151 | 574 | Oceania | Pacific | Norfolk Island | Kingston | NF | NF | NFK | 574 | NF |
152 | 152 | 580 | Oceania | Pacific | Northern Mariana Islands | Saipan | CQ | MP | MNP | 580 | MP |
156 | 156 | 585 | Oceania | Pacific | Palau | Koror | PS | PW | PLW | 585 | PW |
158 | 158 | 598 | Oceania | Pacific | Papua New Guinea | Port Moresby | PP | PG | PNG | 598 | PG |
162 | 162 | 612 | Oceania | Pacific | Pitcairn Islands | Adamstown | PC | PN | PCN | 612 | PN |
184 | 184 | 90 | Oceania | Pacific | Solomon Islands | Honiara | BP | SB | SLB | 90 | SB |
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 |
208 | 208 | 798 | Oceania | Pacific | Tuvalu | Funafuti | TV | TV | TUV | 798 | TV |
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 |
9 | 9 | 32 | Americas | South America | Argentina | Buenos Aires | AR | AR | ARG | 32 | AR |
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 );