external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by continent 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
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 |
238 | 238 | 581 | Oceania | North Pacific Ocean | United States Minor Outlying Islands | UM | UMI | 581 | UM | ||
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 | |
2 | 2 | 8 | Europe | South East Europe | Albania | Tirana | AL | AL | ALB | 8 | AL |
5 | 5 | 20 | Europe | South West Europe | Andorra | Andorra la Vella | AN | AD | AND | 20 | AD |
13 | 13 | 40 | Europe | Central Europe | Austria | Vienna | AU | AT | AUT | 40 | AT |
19 | 19 | 112 | Europe | Eastern Europe | Belarus | Minsk | BO | BY | BLR | 112 | BY |
20 | 20 | 56 | Europe | Western Europe | Belgium | Brussels | BE | BE | BEL | 56 | BE |
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 |
54 | 54 | 203 | Europe | Central Europe | Czech Republic | Prague | EZ | CZ | CZE | 203 | CZ |
55 | 55 | 208 | Europe | Northern Europe | Denmark | Copenhagen | DA | DK | DNK | 208 | DK |
64 | 64 | 233 | Europe | Eastern Europe | Estonia | Tallinn | EN | EE | EST | 233 | EE |
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 |
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 |
78 | 78 | 292 | Europe | South West Europe | Gibraltar | Gibraltar | GI | GI | GIB | 292 | GI |
79 | 79 | 300 | Europe | South East Europe | Greece | Athens | GR | GR | GRC | 300 | GR |
89 | 89 | 336 | Europe | Southern Europe | Holy See (Vatican City) | Vatican City | VT | VA | VAT | 336 | VA |
91 | 91 | 348 | Europe | Central Europe | Hungary | Budapest | HU | HU | HUN | 348 | HU |
92 | 92 | 352 | Europe | Northern Europe | Iceland | Reykjavik | IC | IS | ISL | 352 | IS |
97 | 97 | 372 | Europe | Western Europe | Ireland | Dublin | EI | IE | IRL | 372 | IE |
99 | 99 | 380 | Europe | Southern Europe | Italy | Rome | IT | IT | ITA | 380 | IT |
111 | 111 | 428 | Europe | Eastern Europe | Latvia | Riga | LG | LV | LVA | 428 | LV |
116 | 116 | 438 | Europe | Central Europe | Liechtenstein | Vaduz | LS | LI | LIE | 438 | LI |
117 | 117 | 440 | Europe | Eastern Europe | Lithuania | Vilnius | LH | LT | LTU | 440 | LT |
118 | 118 | 442 | Europe | Western Europe | Luxembourg | Luxembourg | LU | LU | LUX | 442 | LU |
119 | 119 | 807 | Europe | South East Europe | Macedonia | Skopje | MK | MK | MKD | 807 | MK |
125 | 125 | 470 | Europe | Southern Europe | Malta | Valletta | MT | MT | MLT | 470 | MT |
133 | 133 | 498 | Europe | Eastern Europe | Moldova | Chisinau | MD | MD | MDA | 498 | MD |
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 |
153 | 153 | 578 | Europe | Northern Europe | Norway | Oslo | NO | NO | NOR | 578 | NO |
163 | 163 | 616 | Europe | Eastern Europe | Poland | Warsaw | PL | PL | POL | 616 | PL |
164 | 164 | 620 | Europe | South West Europe | Portugal | Lisbon | PO | PT | PRT | 620 | PT |
168 | 168 | 642 | Europe | South East Europe | Romania | Bucharest | RO | RO | ROM | 642 | RO |
175 | 175 | 674 | Europe | Southern Europe | San Marino | San Marino | SM | SM | SMR | 674 | SM |
182 | 182 | 703 | Europe | Central Europe | Slovakia | Bratislava | LO | SK | SVK | 703 | SK |
183 | 183 | 705 | Europe | South East Europe | Slovenia | Ljubljana | SI | SI | SVN | 705 | SI |
187 | 187 | 724 | Europe | South West Europe | Spain | Madrid | SP | ES | ESP | 724 | ES |
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 |
194 | 194 | 756 | Europe | Central Europe | Switzerland | Bern | SZ | CH | CHE | 756 | CH |
210 | 210 | 804 | Europe | Eastern Europe | Ukraine | Kiev | UP | UA | UKR | 804 | UA |
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 | ||
239 | 239 | 891 | Europe | South East Europe | Yugoslavia | YU | YUG | 891 | YU | ||
230 | 230 | 74 | Atlantic Ocean | South Atlantic Ocean | Bouvet Island | BV | BV | BVT | 74 | BV | |
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 | |
1 | 1 | 4 | Asia | South Asia | Afghanistan | Kabul | AF | AF | AFG | 4 | AF |
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 |
17 | 17 | 50 | Asia | South Asia | Bangladesh | Dhaka | BG | BD | BGD | 50 | BD |
24 | 24 | 64 | Asia | South Asia | Bhutan | Thimphu | BT | BT | BTN | 64 | BT |
30 | 30 | 96 | Asia | South East Asia | Brunei | Bandar Seri Begawan | BX | BN | BRN | 96 | BN |
34 | 34 | 116 | Asia | South East Asia | Cambodia | Phnom Penh | CB | KH | KHM | 116 | KH |
42 | 42 | 156 | Asia | East Asia | China | Beijing | CH | CN | CHN | 156 | CN |
43 | 43 | 162 | Asia | South East Asia | Christmas Island | The Settlement | KT | CX | CXR | 162 | CX |
44 | 44 | 166 | Asia | South East Asia | Cocos (Keeling) Islands | West Island | CK | CC | CCK | 166 | CC |
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 |
93 | 93 | 356 | Asia | South Asia | India | New Delhi | IN | IN | IND | 356 | IN |
94 | 94 | 360 | Asia | South East Asia | Indonesia | Jakarta | ID | ID | IDN | 360 | ID |
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 |
101 | 101 | 392 | Asia | East Asia | Japan | Tokyo | JA | JP | JPN | 392 | JP |
102 | 102 | 400 | Asia | South West Asia | Jordan | Amman | JO | JO | JOR | 400 | JO |
103 | 103 | 398 | Asia | Central Asia | Kazakhstan | Astana (Akmola) | KZ | KZ | KAZ | 398 | KZ |
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 |
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 );