external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by region descending
This data as json, CSV (advanced)
Suggested facets: continent
region 28 ✖
- Pacific 25
- West Indies 25
- Western Africa 20
- South West Asia 18
- South America 14
- South East Asia 13
- Southern Africa 10
- South Asia 9
- South East Europe 9
- Western Europe 9
- Central America 8
- East Asia 7
- Eastern Africa 7
- Eastern Europe 7
- Northern Africa 7
- Northern Europe 7
- Central Africa 6
- Central Europe 6
- Indian Ocean 6
- Central Asia 5
- North America 4
- South West Europe 4
- Southern Europe 4
- South Atlantic Ocean 3
- Northern Asia 2
- Southern Indian Ocean 2
- Antarctica 1
- North Pacific Ocean 1
Link | rowid | id | continent | region ▲ | country | capital | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
20 | 20 | 56 | Europe | Western Europe | Belgium | Brussels | BE | BE | BEL | 56 | BE |
70 | 70 | 250 | Europe | Western Europe | France | Paris | FR | FR | FRA | 250 | FR |
76 | 76 | 276 | Europe | Western Europe | Germany | Berlin | GM | DE | DEU | 276 | DE |
97 | 97 | 372 | Europe | Western Europe | Ireland | Dublin | EI | IE | IRL | 372 | IE |
118 | 118 | 442 | Europe | Western Europe | Luxembourg | Luxembourg | LU | LU | LUX | 442 | LU |
134 | 134 | 492 | Europe | Western Europe | Monaco | Monaco | MN | MC | MCO | 492 | MC |
143 | 143 | 528 | Europe | Western Europe | Netherlands | Amsterdam | NL | NL | NLD | 528 | NL |
212 | 212 | 826 | Europe | Western Europe | United Kingdom | London | UK | GB | GBR | 826 | UK/GB |
233 | 233 | 249 | Europe | Western Europe | France, Metropolitan | FX | FXX | 249 | FX | ||
22 | 22 | 204 | Africa | Western Africa | Benin | Porto-Novo | BN | BJ | BEN | 204 | BJ |
32 | 32 | 854 | Africa | Western Africa | Burkina Faso | Ouagadougou | UV | BF | BFA | 854 | BF |
35 | 35 | 120 | Africa | Western Africa | Cameroon | Yaounde | CM | CM | CMR | 120 | CM |
37 | 37 | 132 | Africa | Western Africa | Cape Verde | Praia | CV | CV | CPV | 132 | CV |
50 | 50 | 384 | Africa | Western Africa | Cote d'Ivoire | Yamoussoukro | IV | CI | CIV | 384 | CI |
62 | 62 | 226 | Africa | Western Africa | Equatorial Guinea | Malabo | EK | GQ | GNQ | 226 | GQ |
73 | 73 | 266 | Africa | Western Africa | Gabon | Libreville | GB | GA | GAB | 266 | GA |
74 | 74 | 270 | Africa | Western Africa | Gambia, The | Banjul | GA | GM | GMB | 270 | GM |
77 | 77 | 288 | Africa | Western Africa | Ghana | Accra | GH | GH | GHA | 288 | GH |
85 | 85 | 324 | Africa | Western Africa | Guinea | Conakry | GV | GN | GIN | 324 | GN |
86 | 86 | 624 | Africa | Western Africa | Guinea-Bissau | Bissau | PU | GW | GNB | 624 | GW |
114 | 114 | 430 | Africa | Western Africa | Liberia | Monrovia | LI | LR | LBR | 430 | LR |
124 | 124 | 466 | Africa | Western Africa | Mali | Bamako | ML | ML | MLI | 466 | ML |
128 | 128 | 478 | Africa | Western Africa | Mauritania | Nouakchott | MR | MR | MRT | 478 | MR |
148 | 148 | 562 | Africa | Western Africa | Niger | Niamey | NG | NE | NER | 562 | NE |
149 | 149 | 566 | Africa | Western Africa | Nigeria | Abuja | NI | NG | NGA | 566 | NG |
176 | 176 | 678 | Africa | Western Africa | Sao Tome and Principe | Sao Tome | TP | ST | STP | 678 | ST |
178 | 178 | 686 | Africa | Western Africa | Senegal | Dakar | SG | SN | SEN | 686 | SN |
180 | 180 | 694 | Africa | Western Africa | Sierra Leone | Freetown | SL | SL | SLE | 694 | SL |
200 | 200 | 768 | Africa | Western Africa | Togo | Lome | TO | TG | TGO | 768 | TG |
7 | 7 | 660 | Americas | West Indies | Anguilla | The Valley | AV | AI | AIA | 660 | AI |
8 | 8 | 28 | Americas | West Indies | Antigua and Barbuda | Saint John's | AC | AG | ATG | 28 | AG |
11 | 11 | 533 | Americas | West Indies | Aruba | Oranjestad | AA | AW | ABW | 533 | AW |
15 | 15 | 44 | Americas | West Indies | Bahamas, The | Nassau | BF | BS | BHS | 44 | BS |
18 | 18 | 52 | Americas | West Indies | Barbados | Bridgetown | BB | BB | BRB | 52 | BB |
23 | 23 | 60 | Americas | West Indies | Bermuda | Hamilton | BD | BM | BMU | 60 | BM |
29 | 29 | 92 | Americas | West Indies | British Virgin Islands | Road Town | VI | VG | VGB | 92 | VG |
38 | 38 | 136 | Americas | West Indies | Cayman Islands | George Town | CJ | KY | CYM | 136 | KY |
52 | 52 | 192 | Americas | West Indies | Cuba | Havana | CU | CU | CUB | 192 | CU |
57 | 57 | 212 | Americas | West Indies | Dominica | Roseau | DO | DM | DMA | 212 | DM |
58 | 58 | 214 | Americas | West Indies | Dominican Republic | Santo Domingo | DR | DO | DOM | 214 | DO |
81 | 81 | 308 | Americas | West Indies | Grenada | Saint George's | GJ | GD | GRD | 308 | GD |
82 | 82 | 312 | Americas | West Indies | Guadeloupe | Basse-Terre | GP | GP | GLP | 312 | GP |
88 | 88 | 332 | Americas | West Indies | Haiti | Port-au-Prince | HA | HT | HTI | 332 | HT |
100 | 100 | 388 | Americas | West Indies | Jamaica | Kingston | JM | JM | JAM | 388 | JM |
127 | 127 | 474 | Americas | West Indies | Martinique | Fort-de-France | MB | MQ | MTQ | 474 | MQ |
136 | 136 | 500 | Americas | West Indies | Montserrat | Plymouth | MH | MS | MSR | 500 | MS |
144 | 144 | 530 | Americas | West Indies | Netherlands Antilles | Willemstad | NT | AN | ANT | 530 | AN |
165 | 165 | 630 | Americas | West Indies | Puerto Rico | San Juan | RQ | PR | PRI | 630 | PR |
171 | 171 | 659 | Americas | West Indies | Saint Kitts and Nevis | Basseterre | SC | KN | KNA | 659 | KN |
172 | 172 | 662 | Americas | West Indies | Saint Lucia | Castries | ST | LC | LCA | 662 | LC |
174 | 174 | 670 | Americas | West Indies | Saint Vincent and the Grenadines | Kingstown | VC | VC | VCT | 670 | VC |
203 | 203 | 780 | Americas | West Indies | Trinidad and Tobago | Port-of-Spain | TD | TT | TTO | 780 | TT |
207 | 207 | 796 | Americas | West Indies | Turks and Caicos Islands | Grand Turk | TK | TC | TCA | 796 | TC |
219 | 219 | 850 | Americas | West Indies | Virgin Islands | Charlotte Amalie | VQ | VI | VIR | 850 | VI |
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 | |
89 | 89 | 336 | Europe | Southern Europe | Holy See (Vatican City) | Vatican City | VT | VA | VAT | 336 | VA |
99 | 99 | 380 | Europe | Southern Europe | Italy | Rome | IT | IT | ITA | 380 | IT |
125 | 125 | 470 | Europe | Southern Europe | Malta | Valletta | MT | MT | MLT | 470 | MT |
175 | 175 | 674 | Europe | Southern Europe | San Marino | San Marino | SM | SM | SMR | 674 | SM |
6 | 6 | 24 | Africa | Southern Africa | Angola | Luanda | AO | AO | AGO | 24 | AO |
27 | 27 | 72 | Africa | Southern Africa | Botswana | Gaborone | BC | BW | BWA | 72 | BW |
113 | 113 | 426 | Africa | Southern Africa | Lesotho | Maseru | LT | LS | LSO | 426 | LS |
121 | 121 | 454 | Africa | Southern Africa | Malawi | Lilongwe | MI | MW | MWI | 454 | MW |
138 | 138 | 508 | Africa | Southern Africa | Mozambique | Maputo | MZ | MZ | MOZ | 508 | MZ |
140 | 140 | 516 | Africa | Southern Africa | Namibia | Windhoek | WA | NAM | 516 | ||
186 | 186 | 710 | Africa | Southern Africa | South Africa | Pretoria | SF | ZA | ZAF | 710 | ZA |
192 | 192 | 748 | Africa | Southern Africa | Swaziland | Mbabane | WZ | SZ | SWZ | 748 | SZ |
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 |
5 | 5 | 20 | Europe | South West Europe | Andorra | Andorra la Vella | AN | AD | AND | 20 | AD |
78 | 78 | 292 | Europe | South West Europe | Gibraltar | Gibraltar | GI | GI | GIB | 292 | GI |
164 | 164 | 620 | Europe | South West Europe | Portugal | Lisbon | PO | PT | PRT | 620 | PT |
187 | 187 | 724 | Europe | South West Europe | Spain | Madrid | SP | ES | ESP | 724 | ES |
10 | 10 | 51 | Asia | South West Asia | Armenia | Yerevan | AM | AM | ARM | 51 | AM |
14 | 14 | 31 | Asia | South West Asia | Azerbaijan | Baku (Baki) | AJ | AZ | AZE | 31 | AZ |
16 | 16 | 48 | Asia | South West Asia | Bahrain | Manama | BA | BH | BHR | 48 | BH |
53 | 53 | 196 | Asia | South West Asia | Cyprus | Nicosia | CY | CY | CYP | 196 | CY |
75 | 75 | 268 | Asia | South West Asia | Georgia | T'bilisi | GG | GE | GEO | 268 | GE |
95 | 95 | 364 | Asia | South West Asia | Iran | Tehran | IR | IR | IRN | 364 | IR |
96 | 96 | 368 | Asia | South West Asia | Iraq | Baghdad | IZ | IQ | IRQ | 368 | IQ |
98 | 98 | 376 | Asia | South West Asia | Israel | Jerusalem | IS | IL | ISR | 376 | IL |
102 | 102 | 400 | Asia | South West Asia | Jordan | Amman | JO | JO | JOR | 400 | JO |
108 | 108 | 414 | Asia | South West Asia | Kuwait | Kuwait | KU | KW | KWT | 414 | KW |
112 | 112 | 422 | Asia | South West Asia | Lebanon | Beirut | LE | LB | LBN | 422 | LB |
154 | 154 | 512 | Asia | South West Asia | Oman | Muscat | MU | OM | OMN | 512 | OM |
166 | 166 | 634 | Asia | South West Asia | Qatar | Doha | QA | QA | QAT | 634 | QA |
177 | 177 | 682 | Asia | South West Asia | Saudi Arabia | Riyadh | SA | SA | SAU | 682 | SA |
195 | 195 | 760 | Asia | South West Asia | Syria | Damascus | SY | SY | SYR | 760 | SY |
205 | 205 | 792 | Asia | South West Asia | Turkey | Ankara | TU | TR | TUR | 792 | TR |
211 | 211 | 784 | Asia | South West Asia | United Arab Emirates | Abu Dhabi | TC | AE | ARE | 784 | AE |
223 | 223 | 887 | Asia | South West Asia | Yemen | Sanaa | YM | YE | YEM | 887 | YE |
2 | 2 | 8 | Europe | South East Europe | Albania | Tirana | AL | AL | ALB | 8 | AL |
26 | 26 | 70 | Europe | South East Europe | Bosnia and Herzegovina | Sarajevo | BK | BA | BIH | 70 | BA |
31 | 31 | 100 | Europe | South East Europe | Bulgaria | Sofia | BU | BG | BGR | 100 | BG |
51 | 51 | 191 | Europe | South East Europe | Croatia | Zagreb | HR | HR | HRV | 191 | HR |
79 | 79 | 300 | Europe | South East Europe | Greece | Athens | GR | GR | GRC | 300 | GR |
119 | 119 | 807 | Europe | South East Europe | Macedonia | Skopje | MK | MK | MKD | 807 | MK |
168 | 168 | 642 | Europe | South East Europe | Romania | Bucharest | RO | RO | ROM | 642 | RO |
183 | 183 | 705 | Europe | South East Europe | Slovenia | Ljubljana | SI | SI | SVN | 705 | SI |
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 );