external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by capital descending
This data as json, CSV (advanced)
Link | rowid | id | continent | region | country | capital ▲ | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
169 | 169 | 643 | Asia | Northern Asia | Russia | Moscow | RS | RU | RUS | 643 | RU |
46 | 46 | 174 | Africa | Indian Ocean | Comoros | Moroni | CN | KM | COM | 174 | KM |
214 | 214 | 858 | Americas | South America | Uruguay | Montevideo | UY | UY | URY | 858 | UY |
114 | 114 | 430 | Africa | Western Africa | Liberia | Monrovia | LI | LR | LBR | 430 | LR |
134 | 134 | 492 | Europe | Western Europe | Monaco | Monaco | MN | MC | MCO | 492 | MC |
185 | 185 | 706 | Africa | Eastern Africa | Somalia | Mogadishu | SO | SO | SOM | 706 | SO |
19 | 19 | 112 | Europe | Eastern Europe | Belarus | Minsk | BO | BY | BLR | 112 | BY |
131 | 131 | 484 | Americas | Central America | Mexico | Mexico | MX | MX | MEX | 484 | MX |
192 | 192 | 748 | Africa | Southern Africa | Swaziland | Mbabane | WZ | SZ | SWZ | 748 | SZ |
220 | 220 | 876 | Oceania | Pacific | Wallis and Futuna | Mata-Utu (on Ile Uvea) | WF | WF | WLF | 876 | WF |
113 | 113 | 426 | Africa | Southern Africa | Lesotho | Maseru | LT | LS | LSO | 426 | LS |
138 | 138 | 508 | Africa | Southern Africa | Mozambique | Maputo | MZ | MZ | MOZ | 508 | MZ |
161 | 161 | 608 | Asia | South East Asia | Philippines | Manila | RP | PH | PHL | 608 | PH |
16 | 16 | 48 | Asia | South West Asia | Bahrain | Manama | BA | BH | BHR | 48 | BH |
147 | 147 | 558 | Americas | Central America | Nicaragua | Managua | NU | NI | NIC | 558 | NI |
130 | 130 | 175 | Africa | Indian Ocean | Mayotte | Mamoutzou | MF | YT | MYT | 175 | YT |
123 | 123 | 462 | Asia | South Asia | Maldives | Male (Maale) | MV | MV | MDV | 462 | MV |
62 | 62 | 226 | Africa | Western Africa | Equatorial Guinea | Malabo | EK | GQ | GNQ | 226 | GQ |
126 | 126 | 584 | Oceania | Pacific | Marshall Islands | Majuro | RM | MH | MHL | 584 | MH |
187 | 187 | 724 | Europe | South West Europe | Spain | Madrid | SP | ES | ESP | 724 | ES |
228 | 228 | 446 | Asia | East Asia | Macau (China) | Macau | MC | MO | MAC | 446 | MO |
118 | 118 | 442 | Europe | Western Europe | Luxembourg | Luxembourg | LU | LU | LUX | 442 | LU |
225 | 225 | 894 | Africa | Southern Africa | Zambia | Lusaka | ZA | ZM | ZWB | 894 | ZM |
6 | 6 | 24 | Africa | Southern Africa | Angola | Luanda | AO | AO | AGO | 24 | AO |
191 | 191 | 744 | Europe | Northern Europe | Svalbard | Longyearbyen | SV | SJ | SJM | 744 | SJ |
212 | 212 | 826 | Europe | Western Europe | United Kingdom | London | UK | GB | GBR | 826 | UK/GB |
200 | 200 | 768 | Africa | Western Africa | Togo | Lome | TO | TG | TGO | 768 | TG |
183 | 183 | 705 | Europe | South East Europe | Slovenia | Ljubljana | SI | SI | SVN | 705 | SI |
164 | 164 | 620 | Europe | South West Europe | Portugal | Lisbon | PO | PT | PRT | 620 | PT |
160 | 160 | 604 | Americas | South America | Peru | Lima | PE | PE | PER | 604 | PE |
121 | 121 | 454 | Africa | Southern Africa | Malawi | Lilongwe | MI | MW | MWI | 454 | MW |
73 | 73 | 266 | Africa | Western Africa | Gabon | Libreville | GB | GA | GAB | 266 | GA |
25 | 25 | 68 | Americas | South America | Bolivia | La Paz / Sucre | BL | BO | BOL | 68 | BO |
108 | 108 | 414 | Asia | South West Asia | Kuwait | Kuwait | KU | KW | KWT | 414 | KW |
122 | 122 | 458 | Asia | South East Asia | Malaysia | Kuala Lumpur | MY | MY | MYS | 458 | MY |
156 | 156 | 585 | Oceania | Pacific | Palau | Koror | PS | PW | PLW | 585 | PW |
224 | 224 | 180 | Africa | Central Africa | Zaire (Dem Rep of Congo) | Kinshasa | CG | ZR | ZAR | 180 | ZR |
174 | 174 | 670 | Americas | West Indies | Saint Vincent and the Grenadines | Kingstown | VC | VC | VCT | 670 | VC |
100 | 100 | 388 | Americas | West Indies | Jamaica | Kingston | JM | JM | JAM | 388 | JM |
151 | 151 | 574 | Oceania | Pacific | Norfolk Island | Kingston | NF | NF | NFK | 574 | NF |
170 | 170 | 646 | Africa | Central Africa | Rwanda | Kigali | RW | RW | RWA | 646 | RW |
210 | 210 | 804 | Europe | Eastern Europe | Ukraine | Kiev | UP | UA | UKR | 804 | UA |
189 | 189 | 736 | Africa | Northern Africa | Sudan | Khartoum | SU | SD | SDN | 736 | SD |
142 | 142 | 524 | Asia | South Asia | Nepal | Kathmandu | NP | NP | NPL | 524 | NP |
209 | 209 | 800 | Africa | Eastern Africa | Uganda | Kampala | UG | UG | UGA | 800 | UG |
1 | 1 | 4 | Asia | South Asia | Afghanistan | Kabul | AF | AF | AFG | 4 | AF |
98 | 98 | 376 | Asia | South West Asia | Israel | Jerusalem | IS | IL | ISR | 376 | IL |
94 | 94 | 360 | Asia | South East Asia | Indonesia | Jakarta | ID | ID | IDN | 360 | ID |
155 | 155 | 586 | Asia | South Asia | Pakistan | Islamabad | PK | PK | PAK | 586 | PK |
184 | 184 | 90 | Oceania | Pacific | Solomon Islands | Honiara | BP | SB | SLB | 90 | SB |
69 | 69 | 246 | Europe | Northern Europe | Finland | Helsinki | FI | FI | FIN | 246 | FI |
52 | 52 | 192 | Americas | West Indies | Cuba | Havana | CU | CU | CUB | 192 | CU |
226 | 226 | 716 | Africa | Southern Africa | Zimbabwe | Harare | ZI | ZW | ZWE | 716 | ZW |
218 | 218 | 704 | Asia | South East Asia | Vietnam | Hanoi | VM | VN | VNM | 704 | VN |
23 | 23 | 60 | Americas | West Indies | Bermuda | Hamilton | BD | BM | BMU | 60 | BM |
83 | 83 | 316 | Oceania | Pacific | Guam | Hagatna (Agana) | GQ | GU | GUM | 316 | GU |
84 | 84 | 320 | Americas | Central America | Guatemala | Guatemala | GT | GT | GTM | 320 | GT |
207 | 207 | 796 | Americas | West Indies | Turks and Caicos Islands | Grand Turk | TK | TC | TCA | 796 | TC |
78 | 78 | 292 | Europe | South West Europe | Gibraltar | Gibraltar | GI | GI | GIB | 292 | GI |
87 | 87 | 328 | Americas | South America | Guyana | Georgetown | GY | GY | GUY | 328 | GY |
38 | 38 | 136 | Americas | West Indies | Cayman Islands | George Town | CJ | KY | CYM | 136 | KY |
27 | 27 | 72 | Africa | Southern Africa | Botswana | Gaborone | BC | BW | BWA | 72 | BW |
208 | 208 | 798 | Oceania | Pacific | Tuvalu | Funafuti | TV | TV | TUV | 798 | TV |
180 | 180 | 694 | Africa | Western Africa | Sierra Leone | Freetown | SL | SL | SLE | 694 | SL |
127 | 127 | 474 | Americas | West Indies | Martinique | Fort-de-France | MB | MQ | MTQ | 474 | MQ |
197 | 197 | 762 | Asia | Central Asia | Tajikistan | Dushanbe | TI | TJ | TJK | 762 | TJ |
97 | 97 | 372 | Europe | Western Europe | Ireland | Dublin | EI | IE | IRL | 372 | IE |
166 | 166 | 634 | Asia | South West Asia | Qatar | Doha | QA | QA | QAT | 634 | QA |
56 | 56 | 262 | Africa | Eastern Africa | Djibouti | Djibouti | DJ | DJ | DJI | 262 | DJ |
17 | 17 | 50 | Asia | South Asia | Bangladesh | Dhaka | BG | BD | BGD | 50 | BD |
198 | 198 | 834 | Africa | Eastern Africa | Tanzania | Dar es Salaam | TZ | TZ | TZA | 834 | TZ |
195 | 195 | 760 | Asia | South West Asia | Syria | Damascus | SY | SY | SYR | 760 | SY |
178 | 178 | 686 | Africa | Western Africa | Senegal | Dakar | SG | SN | SEN | 686 | SN |
55 | 55 | 208 | Europe | Northern Europe | Denmark | Copenhagen | DA | DK | DNK | 208 | DK |
85 | 85 | 324 | Africa | Western Africa | Guinea | Conakry | GV | GN | GIN | 324 | GN |
188 | 188 | 144 | Asia | South Asia | Sri Lanka | Colombo | CE | LK | LKA | 144 | LK |
133 | 133 | 498 | Europe | Eastern Europe | Moldova | Chisinau | MD | MD | MDA | 498 | MD |
219 | 219 | 850 | Americas | West Indies | Virgin Islands | Charlotte Amalie | VQ | VI | VIR | 850 | VI |
71 | 71 | 254 | Americas | South America | French Guiana | Cayenne | FG | GF | GUF | 254 | GF |
172 | 172 | 662 | Americas | West Indies | Saint Lucia | Castries | ST | LC | LCA | 662 | LC |
217 | 217 | 862 | Americas | South America | Venezuela | Caracas | VE | VE | VEN | 862 | UE |
12 | 12 | 36 | Oceania | Pacific | Australia | Canberra | AS | AU | AUS | 36 | AU |
60 | 60 | 818 | Africa | Northern Africa | Egypt | Cairo | EG | EG | EGY | 818 | EG |
33 | 33 | 108 | Africa | Central Africa | Burundi | Bujumbura | BY | BI | BDI | 108 | BI |
9 | 9 | 32 | Americas | South America | Argentina | Buenos Aires | AR | AR | ARG | 32 | AR |
91 | 91 | 348 | Europe | Central Europe | Hungary | Budapest | HU | HU | HUN | 348 | HU |
168 | 168 | 642 | Europe | South East Europe | Romania | Bucharest | RO | RO | ROM | 642 | RO |
20 | 20 | 56 | Europe | Western Europe | Belgium | Brussels | BE | BE | BEL | 56 | BE |
18 | 18 | 52 | Americas | West Indies | Barbados | Bridgetown | BB | BB | BRB | 52 | BB |
47 | 47 | 178 | Africa | Central Africa | Congo, Republic of the | Brazzaville | CF | CG | COG | 178 | CG |
182 | 182 | 703 | Europe | Central Europe | Slovakia | Bratislava | LO | SK | SVK | 703 | SK |
28 | 28 | 76 | Americas | South America | Brazil | Brasilia | BR | BR | BRA | 76 | BR |
45 | 45 | 170 | Americas | South America | Colombia | Bogota | CO | CO | COL | 170 | CO |
86 | 86 | 624 | Africa | Western Africa | Guinea-Bissau | Bissau | PU | GW | GNB | 624 | GW |
109 | 109 | 417 | Asia | Central Asia | Kyrgyzstan | Bishkek | KG | KG | KGZ | 417 | KG |
194 | 194 | 756 | Europe | Central Europe | Switzerland | Bern | SZ | CH | CHE | 756 | CH |
76 | 76 | 276 | Europe | Western Europe | Germany | Berlin | GM | DE | DEU | 276 | DE |
21 | 21 | 84 | Americas | Central America | Belize | Belmopan | BH | BZ | BLZ | 84 | BZ |
112 | 112 | 422 | Asia | South West Asia | Lebanon | Beirut | LE | LB | LBN | 422 | LB |
42 | 42 | 156 | Asia | East Asia | China | Beijing | CH | CN | CHN | 156 | CN |
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 );