external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by capital
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 | |
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 | ||
211 | 211 | 784 | Asia | South West Asia | United Arab Emirates | Abu Dhabi | TC | AE | ARE | 784 | AE |
149 | 149 | 566 | Africa | Western Africa | Nigeria | Abuja | NI | NG | NGA | 566 | NG |
77 | 77 | 288 | Africa | Western Africa | Ghana | Accra | GH | GH | GHA | 288 | GH |
162 | 162 | 612 | Oceania | Pacific | Pitcairn Islands | Adamstown | PC | PN | PCN | 612 | PN |
65 | 65 | 231 | Africa | Eastern Africa | Ethiopia | Addis Ababa | ET | ET | ETH | 231 | ET |
3 | 3 | 12 | Africa | Northern Africa | Algeria | Algiers | AG | DZ | DZA | 12 | DZ |
150 | 150 | 570 | Oceania | Pacific | Niue | Alofi | NE | NU | NIU | 570 | NU |
102 | 102 | 400 | Asia | South West Asia | Jordan | Amman | JO | JO | JOR | 400 | JO |
143 | 143 | 528 | Europe | Western Europe | Netherlands | Amsterdam | NL | NL | NLD | 528 | NL |
5 | 5 | 20 | Europe | South West Europe | Andorra | Andorra la Vella | AN | AD | AND | 20 | AD |
205 | 205 | 792 | Asia | South West Asia | Turkey | Ankara | TU | TR | TUR | 792 | TR |
120 | 120 | 450 | Africa | Indian Ocean | Madagascar | Antananarivo | MA | MG | MDG | 450 | MG |
222 | 222 | 882 | Oceania | Pacific | Western Samoa | Apia | WS | WS | WSM | 882 | WS |
206 | 206 | 795 | Asia | Central Asia | Turkmenistan | Ashgabat | TX | TM | TKM | 795 | TM |
63 | 63 | 232 | Africa | Eastern Africa | Eritrea | Asmara | ER | ER | ERI | 232 | ER |
103 | 103 | 398 | Asia | Central Asia | Kazakhstan | Astana (Akmola) | KZ | KZ | KAZ | 398 | KZ |
159 | 159 | 600 | Americas | South America | Paraguay | Asuncion | PA | PY | PRY | 600 | PY |
79 | 79 | 300 | Europe | South East Europe | Greece | Athens | GR | GR | GRC | 300 | GR |
48 | 48 | 184 | Oceania | Pacific | Cook Islands | Avarua | CW | CK | COK | 184 | CK |
96 | 96 | 368 | Asia | South West Asia | Iraq | Baghdad | IZ | IQ | IRQ | 368 | IQ |
14 | 14 | 31 | Asia | South West Asia | Azerbaijan | Baku (Baki) | AJ | AZ | AZE | 31 | AZ |
124 | 124 | 466 | Africa | Western Africa | Mali | Bamako | ML | ML | MLI | 466 | ML |
30 | 30 | 96 | Asia | South East Asia | Brunei | Bandar Seri Begawan | BX | BN | BRN | 96 | BN |
199 | 199 | 764 | Asia | South East Asia | Thailand | Bangkok | TH | TH | THA | 764 | TH |
39 | 39 | 140 | Africa | Central Africa | Central African Republic | Bangui | CT | CF | CAF | 140 | CF |
74 | 74 | 270 | Africa | Western Africa | Gambia, The | Banjul | GA | GM | GMB | 270 | GM |
82 | 82 | 312 | Americas | West Indies | Guadeloupe | Basse-Terre | GP | GP | GLP | 312 | GP |
171 | 171 | 659 | Americas | West Indies | Saint Kitts and Nevis | Basseterre | SC | KN | KNA | 659 | KN |
42 | 42 | 156 | Asia | East Asia | China | Beijing | CH | CN | CHN | 156 | CN |
112 | 112 | 422 | Asia | South West Asia | Lebanon | Beirut | LE | LB | LBN | 422 | LB |
21 | 21 | 84 | Americas | Central America | Belize | Belmopan | BH | BZ | BLZ | 84 | BZ |
76 | 76 | 276 | Europe | Western Europe | Germany | Berlin | GM | DE | DEU | 276 | DE |
194 | 194 | 756 | Europe | Central Europe | Switzerland | Bern | SZ | CH | CHE | 756 | CH |
109 | 109 | 417 | Asia | Central Asia | Kyrgyzstan | Bishkek | KG | KG | KGZ | 417 | KG |
86 | 86 | 624 | Africa | Western Africa | Guinea-Bissau | Bissau | PU | GW | GNB | 624 | GW |
45 | 45 | 170 | Americas | South America | Colombia | Bogota | CO | CO | COL | 170 | CO |
28 | 28 | 76 | Americas | South America | Brazil | Brasilia | BR | BR | BRA | 76 | BR |
182 | 182 | 703 | Europe | Central Europe | Slovakia | Bratislava | LO | SK | SVK | 703 | SK |
47 | 47 | 178 | Africa | Central Africa | Congo, Republic of the | Brazzaville | CF | CG | COG | 178 | CG |
18 | 18 | 52 | Americas | West Indies | Barbados | Bridgetown | BB | BB | BRB | 52 | BB |
20 | 20 | 56 | Europe | Western Europe | Belgium | Brussels | BE | BE | BEL | 56 | BE |
168 | 168 | 642 | Europe | South East Europe | Romania | Bucharest | RO | RO | ROM | 642 | RO |
91 | 91 | 348 | Europe | Central Europe | Hungary | Budapest | HU | HU | HUN | 348 | HU |
9 | 9 | 32 | Americas | South America | Argentina | Buenos Aires | AR | AR | ARG | 32 | AR |
33 | 33 | 108 | Africa | Central Africa | Burundi | Bujumbura | BY | BI | BDI | 108 | BI |
60 | 60 | 818 | Africa | Northern Africa | Egypt | Cairo | EG | EG | EGY | 818 | EG |
12 | 12 | 36 | Oceania | Pacific | Australia | Canberra | AS | AU | AUS | 36 | AU |
217 | 217 | 862 | Americas | South America | Venezuela | Caracas | VE | VE | VEN | 862 | UE |
172 | 172 | 662 | Americas | West Indies | Saint Lucia | Castries | ST | LC | LCA | 662 | LC |
71 | 71 | 254 | Americas | South America | French Guiana | Cayenne | FG | GF | GUF | 254 | GF |
219 | 219 | 850 | Americas | West Indies | Virgin Islands | Charlotte Amalie | VQ | VI | VIR | 850 | VI |
133 | 133 | 498 | Europe | Eastern Europe | Moldova | Chisinau | MD | MD | MDA | 498 | MD |
188 | 188 | 144 | Asia | South Asia | Sri Lanka | Colombo | CE | LK | LKA | 144 | LK |
85 | 85 | 324 | Africa | Western Africa | Guinea | Conakry | GV | GN | GIN | 324 | GN |
55 | 55 | 208 | Europe | Northern Europe | Denmark | Copenhagen | DA | DK | DNK | 208 | DK |
178 | 178 | 686 | Africa | Western Africa | Senegal | Dakar | SG | SN | SEN | 686 | SN |
195 | 195 | 760 | Asia | South West Asia | Syria | Damascus | SY | SY | SYR | 760 | SY |
198 | 198 | 834 | Africa | Eastern Africa | Tanzania | Dar es Salaam | TZ | TZ | TZA | 834 | TZ |
17 | 17 | 50 | Asia | South Asia | Bangladesh | Dhaka | BG | BD | BGD | 50 | BD |
56 | 56 | 262 | Africa | Eastern Africa | Djibouti | Djibouti | DJ | DJ | DJI | 262 | DJ |
166 | 166 | 634 | Asia | South West Asia | Qatar | Doha | QA | QA | QAT | 634 | QA |
97 | 97 | 372 | Europe | Western Europe | Ireland | Dublin | EI | IE | IRL | 372 | IE |
197 | 197 | 762 | Asia | Central Asia | Tajikistan | Dushanbe | TI | TJ | TJK | 762 | TJ |
127 | 127 | 474 | Americas | West Indies | Martinique | Fort-de-France | MB | MQ | MTQ | 474 | MQ |
180 | 180 | 694 | Africa | Western Africa | Sierra Leone | Freetown | SL | SL | SLE | 694 | SL |
208 | 208 | 798 | Oceania | Pacific | Tuvalu | Funafuti | TV | TV | TUV | 798 | TV |
27 | 27 | 72 | Africa | Southern Africa | Botswana | Gaborone | BC | BW | BWA | 72 | BW |
38 | 38 | 136 | Americas | West Indies | Cayman Islands | George Town | CJ | KY | CYM | 136 | KY |
87 | 87 | 328 | Americas | South America | Guyana | Georgetown | GY | GY | GUY | 328 | GY |
78 | 78 | 292 | Europe | South West Europe | Gibraltar | Gibraltar | GI | GI | GIB | 292 | GI |
207 | 207 | 796 | Americas | West Indies | Turks and Caicos Islands | Grand Turk | TK | TC | TCA | 796 | TC |
84 | 84 | 320 | Americas | Central America | Guatemala | Guatemala | GT | GT | GTM | 320 | GT |
83 | 83 | 316 | Oceania | Pacific | Guam | Hagatna (Agana) | GQ | GU | GUM | 316 | GU |
23 | 23 | 60 | Americas | West Indies | Bermuda | Hamilton | BD | BM | BMU | 60 | BM |
218 | 218 | 704 | Asia | South East Asia | Vietnam | Hanoi | VM | VN | VNM | 704 | VN |
226 | 226 | 716 | Africa | Southern Africa | Zimbabwe | Harare | ZI | ZW | ZWE | 716 | ZW |
52 | 52 | 192 | Americas | West Indies | Cuba | Havana | CU | CU | CUB | 192 | CU |
69 | 69 | 246 | Europe | Northern Europe | Finland | Helsinki | FI | FI | FIN | 246 | FI |
184 | 184 | 90 | Oceania | Pacific | Solomon Islands | Honiara | BP | SB | SLB | 90 | SB |
155 | 155 | 586 | Asia | South Asia | Pakistan | Islamabad | PK | PK | PAK | 586 | PK |
94 | 94 | 360 | Asia | South East Asia | Indonesia | Jakarta | ID | ID | IDN | 360 | ID |
98 | 98 | 376 | Asia | South West Asia | Israel | Jerusalem | IS | IL | ISR | 376 | IL |
1 | 1 | 4 | Asia | South Asia | Afghanistan | Kabul | AF | AF | AFG | 4 | AF |
209 | 209 | 800 | Africa | Eastern Africa | Uganda | Kampala | UG | UG | UGA | 800 | UG |
142 | 142 | 524 | Asia | South Asia | Nepal | Kathmandu | NP | NP | NPL | 524 | NP |
189 | 189 | 736 | Africa | Northern Africa | Sudan | Khartoum | SU | SD | SDN | 736 | SD |
210 | 210 | 804 | Europe | Eastern Europe | Ukraine | Kiev | UP | UA | UKR | 804 | UA |
170 | 170 | 646 | Africa | Central Africa | Rwanda | Kigali | RW | RW | RWA | 646 | RW |
100 | 100 | 388 | Americas | West Indies | Jamaica | Kingston | JM | JM | JAM | 388 | JM |
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 );