external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by capital
This data as json, CSV (advanced)
Link | rowid | id | continent | region | country | capital ▼ | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
151 | 151 | 574 | Oceania | Pacific | Norfolk Island | Kingston | NF | NF | NFK | 574 | NF |
174 | 174 | 670 | Americas | West Indies | Saint Vincent and the Grenadines | Kingstown | VC | VC | VCT | 670 | VC |
224 | 224 | 180 | Africa | Central Africa | Zaire (Dem Rep of Congo) | Kinshasa | CG | ZR | ZAR | 180 | ZR |
156 | 156 | 585 | Oceania | Pacific | Palau | Koror | PS | PW | PLW | 585 | PW |
122 | 122 | 458 | Asia | South East Asia | Malaysia | Kuala Lumpur | MY | MY | MYS | 458 | MY |
108 | 108 | 414 | Asia | South West Asia | Kuwait | Kuwait | KU | KW | KWT | 414 | KW |
25 | 25 | 68 | Americas | South America | Bolivia | La Paz / Sucre | BL | BO | BOL | 68 | BO |
73 | 73 | 266 | Africa | Western Africa | Gabon | Libreville | GB | GA | GAB | 266 | GA |
121 | 121 | 454 | Africa | Southern Africa | Malawi | Lilongwe | MI | MW | MWI | 454 | MW |
160 | 160 | 604 | Americas | South America | Peru | Lima | PE | PE | PER | 604 | PE |
164 | 164 | 620 | Europe | South West Europe | Portugal | Lisbon | PO | PT | PRT | 620 | PT |
183 | 183 | 705 | Europe | South East Europe | Slovenia | Ljubljana | SI | SI | SVN | 705 | SI |
200 | 200 | 768 | Africa | Western Africa | Togo | Lome | TO | TG | TGO | 768 | TG |
212 | 212 | 826 | Europe | Western Europe | United Kingdom | London | UK | GB | GBR | 826 | UK/GB |
191 | 191 | 744 | Europe | Northern Europe | Svalbard | Longyearbyen | SV | SJ | SJM | 744 | SJ |
6 | 6 | 24 | Africa | Southern Africa | Angola | Luanda | AO | AO | AGO | 24 | AO |
225 | 225 | 894 | Africa | Southern Africa | Zambia | Lusaka | ZA | ZM | ZWB | 894 | ZM |
118 | 118 | 442 | Europe | Western Europe | Luxembourg | Luxembourg | LU | LU | LUX | 442 | LU |
228 | 228 | 446 | Asia | East Asia | Macau (China) | Macau | MC | MO | MAC | 446 | MO |
187 | 187 | 724 | Europe | South West Europe | Spain | Madrid | SP | ES | ESP | 724 | ES |
126 | 126 | 584 | Oceania | Pacific | Marshall Islands | Majuro | RM | MH | MHL | 584 | MH |
62 | 62 | 226 | Africa | Western Africa | Equatorial Guinea | Malabo | EK | GQ | GNQ | 226 | GQ |
123 | 123 | 462 | Asia | South Asia | Maldives | Male (Maale) | MV | MV | MDV | 462 | MV |
130 | 130 | 175 | Africa | Indian Ocean | Mayotte | Mamoutzou | MF | YT | MYT | 175 | YT |
147 | 147 | 558 | Americas | Central America | Nicaragua | Managua | NU | NI | NIC | 558 | NI |
16 | 16 | 48 | Asia | South West Asia | Bahrain | Manama | BA | BH | BHR | 48 | BH |
161 | 161 | 608 | Asia | South East Asia | Philippines | Manila | RP | PH | PHL | 608 | PH |
138 | 138 | 508 | Africa | Southern Africa | Mozambique | Maputo | MZ | MZ | MOZ | 508 | MZ |
113 | 113 | 426 | Africa | Southern Africa | Lesotho | Maseru | LT | LS | LSO | 426 | LS |
220 | 220 | 876 | Oceania | Pacific | Wallis and Futuna | Mata-Utu (on Ile Uvea) | WF | WF | WLF | 876 | WF |
192 | 192 | 748 | Africa | Southern Africa | Swaziland | Mbabane | WZ | SZ | SWZ | 748 | SZ |
131 | 131 | 484 | Americas | Central America | Mexico | Mexico | MX | MX | MEX | 484 | MX |
19 | 19 | 112 | Europe | Eastern Europe | Belarus | Minsk | BO | BY | BLR | 112 | BY |
185 | 185 | 706 | Africa | Eastern Africa | Somalia | Mogadishu | SO | SO | SOM | 706 | SO |
134 | 134 | 492 | Europe | Western Europe | Monaco | Monaco | MN | MC | MCO | 492 | MC |
114 | 114 | 430 | Africa | Western Africa | Liberia | Monrovia | LI | LR | LBR | 430 | LR |
214 | 214 | 858 | Americas | South America | Uruguay | Montevideo | UY | UY | URY | 858 | UY |
46 | 46 | 174 | Africa | Indian Ocean | Comoros | Moroni | CN | KM | COM | 174 | KM |
169 | 169 | 643 | Asia | Northern Asia | Russia | Moscow | RS | RU | RUS | 643 | RU |
154 | 154 | 512 | Asia | South West Asia | Oman | Muscat | MU | OM | OMN | 512 | OM |
40 | 40 | 148 | Africa | Central Africa | Chad | N'Djamena | CD | TD | TCD | 148 | TD |
104 | 104 | 404 | Africa | Eastern Africa | Kenya | Nairobi | KE | KE | KEN | 404 | KE |
15 | 15 | 44 | Americas | West Indies | Bahamas, The | Nassau | BF | BS | BHS | 44 | BS |
93 | 93 | 356 | Asia | South Asia | India | New Delhi | IN | IN | IND | 356 | IN |
148 | 148 | 562 | Africa | Western Africa | Niger | Niamey | NG | NE | NER | 562 | NE |
53 | 53 | 196 | Asia | South West Asia | Cyprus | Nicosia | CY | CY | CYP | 196 | CY |
128 | 128 | 478 | Africa | Western Africa | Mauritania | Nouakchott | MR | MR | MRT | 478 | MR |
145 | 145 | 540 | Oceania | Pacific | New Caledonia | Noumea | NC | NC | NCL | 540 | NC |
202 | 202 | 776 | Oceania | Pacific | Tonga | Nuku'alofa | TN | TO | TON | 776 | TO |
80 | 80 | 304 | Americas | North America | Greenland | Nuuk (Godthab) | GL | GL | GRL | 304 | GL |
11 | 11 | 533 | Americas | West Indies | Aruba | Oranjestad | AA | AW | ABW | 533 | AW |
153 | 153 | 578 | Europe | Northern Europe | Norway | Oslo | NO | NO | NOR | 578 | NO |
36 | 36 | 124 | Americas | North America | Canada | Ottawa | CA | CA | CAN | 124 | CA |
32 | 32 | 854 | Africa | Western Africa | Burkina Faso | Ouagadougou | UV | BF | BFA | 854 | BF |
106 | 106 | 408 | Asia | East Asia | Korea, North | P'yongyang | KN | KP | PRK | 408 | KP |
4 | 4 | 16 | Oceania | Pacific | American Samoa | Pago Pago | AQ | AS | ASM | 16 | AS |
132 | 132 | 583 | Oceania | Pacific | Micronesia, Federated States of | Palikir | FM | FSM | 583 | FM | |
157 | 157 | 591 | Americas | Central America | Panama | Panama | PM | PA | PAN | 591 | PA |
72 | 72 | 258 | Oceania | Pacific | French Polynesia | Papeete | FP | PF | PYF | 258 | PF |
190 | 190 | 740 | Americas | South America | Suriname | Paramaribo | NS | SR | SUR | 740 | SR |
70 | 70 | 250 | Europe | Western Europe | France | Paris | FR | FR | FRA | 250 | FR |
34 | 34 | 116 | Asia | South East Asia | Cambodia | Phnom Penh | CB | KH | KHM | 116 | KH |
136 | 136 | 500 | Americas | West Indies | Montserrat | Plymouth | MH | MS | MSR | 500 | MS |
129 | 129 | 480 | Africa | Indian Ocean | Mauritius | Port Louis | MP | MU | MUS | 480 | MU |
158 | 158 | 598 | Oceania | Pacific | Papua New Guinea | Port Moresby | PP | PG | PNG | 598 | PG |
216 | 216 | 548 | Oceania | Pacific | Vanuatu | Port-Vila | NH | VU | VUT | 548 | VU |
88 | 88 | 332 | Americas | West Indies | Haiti | Port-au-Prince | HA | HT | HTI | 332 | HT |
203 | 203 | 780 | Americas | West Indies | Trinidad and Tobago | Port-of-Spain | TD | TT | TTO | 780 | TT |
22 | 22 | 204 | Africa | Western Africa | Benin | Porto-Novo | BN | BJ | BEN | 204 | BJ |
54 | 54 | 203 | Europe | Central Europe | Czech Republic | Prague | EZ | CZ | CZE | 203 | CZ |
37 | 37 | 132 | Africa | Western Africa | Cape Verde | Praia | CV | CV | CPV | 132 | CV |
186 | 186 | 710 | Africa | Southern Africa | South Africa | Pretoria | SF | ZA | ZAF | 710 | ZA |
59 | 59 | 218 | Americas | South America | Ecuador | Quito | EC | EC | ECU | 218 | EC |
137 | 137 | 504 | Africa | Northern Africa | Morocco | Rabat | MO | MA | MAR | 504 | MA |
139 | 139 | 104 | Asia | South East Asia | Myanmar (Burma) | Rangoon (Yangon) | BM | MM | MMR | 104 | MM |
92 | 92 | 352 | Europe | Northern Europe | Iceland | Reykjavik | IC | IS | ISL | 352 | IS |
111 | 111 | 428 | Europe | Eastern Europe | Latvia | Riga | LG | LV | LVA | 428 | LV |
177 | 177 | 682 | Asia | South West Asia | Saudi Arabia | Riyadh | SA | SA | SAU | 682 | SA |
29 | 29 | 92 | Americas | West Indies | British Virgin Islands | Road Town | VI | VG | VGB | 92 | VG |
99 | 99 | 380 | Europe | Southern Europe | Italy | Rome | IT | IT | ITA | 380 | IT |
57 | 57 | 212 | Americas | West Indies | Dominica | Roseau | DO | DM | DMA | 212 | DM |
81 | 81 | 308 | Americas | West Indies | Grenada | Saint George's | GJ | GD | GRD | 308 | GD |
8 | 8 | 28 | Americas | West Indies | Antigua and Barbuda | Saint John's | AC | AG | ATG | 28 | AG |
167 | 167 | 638 | Africa | Indian Ocean | Reunion | Saint-Denis | RE | RE | REU | 638 | RE |
173 | 173 | 666 | Americas | North America | Saint Pierre and Miquelon | Saint-Pierre | SB | PM | SPM | 666 | PM |
152 | 152 | 580 | Oceania | Pacific | Northern Mariana Islands | Saipan | CQ | MP | MNP | 580 | MP |
49 | 49 | 188 | Americas | Central America | Costa Rica | San Jose | CS | CR | CRI | 188 | CR |
165 | 165 | 630 | Americas | West Indies | Puerto Rico | San Juan | RQ | PR | PRI | 630 | PR |
175 | 175 | 674 | Europe | Southern Europe | San Marino | San Marino | SM | SM | SMR | 674 | SM |
61 | 61 | 222 | Americas | Central America | El Salvador | San Salvador | ES | SV | SLV | 222 | SV |
223 | 223 | 887 | Asia | South West Asia | Yemen | Sanaa | YM | YE | YEM | 887 | YE |
41 | 41 | 152 | Americas | South America | Chile | Santiago | CI | CL | CHL | 152 | CL |
58 | 58 | 214 | Americas | West Indies | Dominican Republic | Santo Domingo | DR | DO | DOM | 214 | DO |
176 | 176 | 678 | Africa | Western Africa | Sao Tome and Principe | Sao Tome | TP | ST | STP | 678 | ST |
26 | 26 | 70 | Europe | South East Europe | Bosnia and Herzegovina | Sarajevo | BK | BA | BIH | 70 | BA |
107 | 107 | 410 | Asia | East Asia | Korea, South | Seoul | KS | KR | KOR | 410 | KR |
181 | 181 | 702 | Asia | South East Asia | Singapore | Singapore | SN | SG | SGP | 702 | SG |
119 | 119 | 807 | Europe | South East Europe | Macedonia | Skopje | MK | MK | MKD | 807 | MK |
31 | 31 | 100 | Europe | South East Europe | Bulgaria | Sofia | BU | BG | BGR | 100 | BG |
66 | 66 | 238 | Americas | South America | Falkland Islands (Islas Malvinas) | Stanley | FA | FK | FLK | 238 | FK |
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 );