external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by internet descending
This data as json, CSV (advanced)
Suggested facets: continent, region
Link | rowid | id | continent | region | country | capital | fips | iso2 | iso3 | isonumeric | internet ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|
226 | 226 | 716 | Africa | Southern Africa | Zimbabwe | Harare | ZI | ZW | ZWE | 716 | ZW |
224 | 224 | 180 | Africa | Central Africa | Zaire (Dem Rep of Congo) | Kinshasa | CG | ZR | ZAR | 180 | ZR |
225 | 225 | 894 | Africa | Southern Africa | Zambia | Lusaka | ZA | ZM | ZWB | 894 | ZM |
186 | 186 | 710 | Africa | Southern Africa | South Africa | Pretoria | SF | ZA | ZAF | 710 | ZA |
239 | 239 | 891 | Europe | South East Europe | Yugoslavia | YU | YUG | 891 | YU | ||
130 | 130 | 175 | Africa | Indian Ocean | Mayotte | Mamoutzou | MF | YT | MYT | 175 | YT |
223 | 223 | 887 | Asia | South West Asia | Yemen | Sanaa | YM | YE | YEM | 887 | YE |
222 | 222 | 882 | Oceania | Pacific | Western Samoa | Apia | WS | WS | WSM | 882 | WS |
220 | 220 | 876 | Oceania | Pacific | Wallis and Futuna | Mata-Utu (on Ile Uvea) | WF | WF | WLF | 876 | WF |
216 | 216 | 548 | Oceania | Pacific | Vanuatu | Port-Vila | NH | VU | VUT | 548 | VU |
218 | 218 | 704 | Asia | South East Asia | Vietnam | Hanoi | VM | VN | VNM | 704 | VN |
219 | 219 | 850 | Americas | West Indies | Virgin Islands | Charlotte Amalie | VQ | VI | VIR | 850 | VI |
29 | 29 | 92 | Americas | West Indies | British Virgin Islands | Road Town | VI | VG | VGB | 92 | VG |
174 | 174 | 670 | Americas | West Indies | Saint Vincent and the Grenadines | Kingstown | VC | VC | VCT | 670 | VC |
89 | 89 | 336 | Europe | Southern Europe | Holy See (Vatican City) | Vatican City | VT | VA | VAT | 336 | VA |
215 | 215 | 860 | Asia | Central Asia | Uzbekistan | Tashkent (Toshkent) | UZ | UZ | UZB | 860 | UZ |
214 | 214 | 858 | Americas | South America | Uruguay | Montevideo | UY | UY | URY | 858 | UY |
213 | 213 | 840 | Americas | North America | United States | Washington, DC | US | US | USA | 840 | US |
238 | 238 | 581 | Oceania | North Pacific Ocean | United States Minor Outlying Islands | UM | UMI | 581 | UM | ||
212 | 212 | 826 | Europe | Western Europe | United Kingdom | London | UK | GB | GBR | 826 | UK/GB |
209 | 209 | 800 | Africa | Eastern Africa | Uganda | Kampala | UG | UG | UGA | 800 | UG |
217 | 217 | 862 | Americas | South America | Venezuela | Caracas | VE | VE | VEN | 862 | UE |
210 | 210 | 804 | Europe | Eastern Europe | Ukraine | Kiev | UP | UA | UKR | 804 | UA |
198 | 198 | 834 | Africa | Eastern Africa | Tanzania | Dar es Salaam | TZ | TZ | TZA | 834 | TZ |
196 | 196 | 158 | Asia | East Asia | Taiwan | Taipei | TW | TW | TWN | 158 | TW |
208 | 208 | 798 | Oceania | Pacific | Tuvalu | Funafuti | TV | TV | TUV | 798 | TV |
203 | 203 | 780 | Americas | West Indies | Trinidad and Tobago | Port-of-Spain | TD | TT | TTO | 780 | TT |
205 | 205 | 792 | Asia | South West Asia | Turkey | Ankara | TU | TR | TUR | 792 | TR |
232 | 232 | 626 | Asia | South East Asia | East Timor | TP | TMP | 626 | TP | ||
202 | 202 | 776 | Oceania | Pacific | Tonga | Nuku'alofa | TN | TO | TON | 776 | TO |
204 | 204 | 788 | Africa | Northern Africa | Tunisia | Tunis | TS | TN | TUN | 788 | TN |
206 | 206 | 795 | Asia | Central Asia | Turkmenistan | Ashgabat | TX | TM | TKM | 795 | TM |
201 | 201 | 772 | Oceania | Pacific | Tokelau | none | TL | TK | TKL | 772 | TK |
197 | 197 | 762 | Asia | Central Asia | Tajikistan | Dushanbe | TI | TJ | TJK | 762 | TJ |
199 | 199 | 764 | Asia | South East Asia | Thailand | Bangkok | TH | TH | THA | 764 | TH |
200 | 200 | 768 | Africa | Western Africa | Togo | Lome | TO | TG | TGO | 768 | TG |
40 | 40 | 148 | Africa | Central Africa | Chad | N'Djamena | CD | TD | TCD | 148 | TD |
207 | 207 | 796 | Americas | West Indies | Turks and Caicos Islands | Grand Turk | TK | TC | TCA | 796 | TC |
192 | 192 | 748 | Africa | Southern Africa | Swaziland | Mbabane | WZ | SZ | SWZ | 748 | SZ |
195 | 195 | 760 | Asia | South West Asia | Syria | Damascus | SY | SY | SYR | 760 | SY |
61 | 61 | 222 | Americas | Central America | El Salvador | San Salvador | ES | SV | SLV | 222 | SV |
176 | 176 | 678 | Africa | Western Africa | Sao Tome and Principe | Sao Tome | TP | ST | STP | 678 | ST |
190 | 190 | 740 | Americas | South America | Suriname | Paramaribo | NS | SR | SUR | 740 | SR |
185 | 185 | 706 | Africa | Eastern Africa | Somalia | Mogadishu | SO | SO | SOM | 706 | SO |
178 | 178 | 686 | Africa | Western Africa | Senegal | Dakar | SG | SN | SEN | 686 | SN |
175 | 175 | 674 | Europe | Southern Europe | San Marino | San Marino | SM | SM | SMR | 674 | SM |
180 | 180 | 694 | Africa | Western Africa | Sierra Leone | Freetown | SL | SL | SLE | 694 | SL |
182 | 182 | 703 | Europe | Central Europe | Slovakia | Bratislava | LO | SK | SVK | 703 | SK |
191 | 191 | 744 | Europe | Northern Europe | Svalbard | Longyearbyen | SV | SJ | SJM | 744 | SJ |
183 | 183 | 705 | Europe | South East Europe | Slovenia | Ljubljana | SI | SI | SVN | 705 | SI |
236 | 236 | 654 | Atlantic Ocean | South Atlantic Ocean | Saint Helena | SH | SH | SHN | 654 | SH | |
181 | 181 | 702 | Asia | South East Asia | Singapore | Singapore | SN | SG | SGP | 702 | SG |
193 | 193 | 752 | Europe | Northern Europe | Sweden | Stockholm | SW | SE | SWE | 752 | SE |
189 | 189 | 736 | Africa | Northern Africa | Sudan | Khartoum | SU | SD | SDN | 736 | SD |
179 | 179 | 690 | Africa | Indian Ocean | Seychelles | Victoria | SE | SC | SYC | 690 | SC |
184 | 184 | 90 | Oceania | Pacific | Solomon Islands | Honiara | BP | SB | SLB | 90 | SB |
177 | 177 | 682 | Asia | South West Asia | Saudi Arabia | Riyadh | SA | SA | SAU | 682 | SA |
170 | 170 | 646 | Africa | Central Africa | Rwanda | Kigali | RW | RW | RWA | 646 | RW |
169 | 169 | 643 | Asia | Northern Asia | Russia | Moscow | RS | RU | RUS | 643 | RU |
168 | 168 | 642 | Europe | South East Europe | Romania | Bucharest | RO | RO | ROM | 642 | RO |
167 | 167 | 638 | Africa | Indian Ocean | Reunion | Saint-Denis | RE | RE | REU | 638 | RE |
166 | 166 | 634 | Asia | South West Asia | Qatar | Doha | QA | QA | QAT | 634 | QA |
159 | 159 | 600 | Americas | South America | Paraguay | Asuncion | PA | PY | PRY | 600 | PY |
156 | 156 | 585 | Oceania | Pacific | Palau | Koror | PS | PW | PLW | 585 | PW |
164 | 164 | 620 | Europe | South West Europe | Portugal | Lisbon | PO | PT | PRT | 620 | PT |
165 | 165 | 630 | Americas | West Indies | Puerto Rico | San Juan | RQ | PR | PRI | 630 | PR |
162 | 162 | 612 | Oceania | Pacific | Pitcairn Islands | Adamstown | PC | PN | PCN | 612 | PN |
173 | 173 | 666 | Americas | North America | Saint Pierre and Miquelon | Saint-Pierre | SB | PM | SPM | 666 | PM |
163 | 163 | 616 | Europe | Eastern Europe | Poland | Warsaw | PL | PL | POL | 616 | PL |
155 | 155 | 586 | Asia | South Asia | Pakistan | Islamabad | PK | PK | PAK | 586 | PK |
161 | 161 | 608 | Asia | South East Asia | Philippines | Manila | RP | PH | PHL | 608 | PH |
158 | 158 | 598 | Oceania | Pacific | Papua New Guinea | Port Moresby | PP | PG | PNG | 598 | PG |
72 | 72 | 258 | Oceania | Pacific | French Polynesia | Papeete | FP | PF | PYF | 258 | PF |
160 | 160 | 604 | Americas | South America | Peru | Lima | PE | PE | PER | 604 | PE |
157 | 157 | 591 | Americas | Central America | Panama | Panama | PM | PA | PAN | 591 | PA |
154 | 154 | 512 | Asia | South West Asia | Oman | Muscat | MU | OM | OMN | 512 | OM |
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 |
141 | 141 | 520 | Oceania | Pacific | Nauru | no official capital | NR | NR | NRU | 520 | NR |
142 | 142 | 524 | Asia | South Asia | Nepal | Kathmandu | NP | NP | NPL | 524 | NP |
153 | 153 | 578 | Europe | Northern Europe | Norway | Oslo | NO | NO | NOR | 578 | NO |
143 | 143 | 528 | Europe | Western Europe | Netherlands | Amsterdam | NL | NL | NLD | 528 | NL |
147 | 147 | 558 | Americas | Central America | Nicaragua | Managua | NU | NI | NIC | 558 | NI |
149 | 149 | 566 | Africa | Western Africa | Nigeria | Abuja | NI | NG | NGA | 566 | NG |
151 | 151 | 574 | Oceania | Pacific | Norfolk Island | Kingston | NF | NF | NFK | 574 | NF |
148 | 148 | 562 | Africa | Western Africa | Niger | Niamey | NG | NE | NER | 562 | NE |
145 | 145 | 540 | Oceania | Pacific | New Caledonia | Noumea | NC | NC | NCL | 540 | NC |
138 | 138 | 508 | Africa | Southern Africa | Mozambique | Maputo | MZ | MZ | MOZ | 508 | MZ |
122 | 122 | 458 | Asia | South East Asia | Malaysia | Kuala Lumpur | MY | MY | MYS | 458 | MY |
131 | 131 | 484 | Americas | Central America | Mexico | Mexico | MX | MX | MEX | 484 | MX |
121 | 121 | 454 | Africa | Southern Africa | Malawi | Lilongwe | MI | MW | MWI | 454 | MW |
123 | 123 | 462 | Asia | South Asia | Maldives | Male (Maale) | MV | MV | MDV | 462 | MV |
129 | 129 | 480 | Africa | Indian Ocean | Mauritius | Port Louis | MP | MU | MUS | 480 | MU |
125 | 125 | 470 | Europe | Southern Europe | Malta | Valletta | MT | MT | MLT | 470 | MT |
136 | 136 | 500 | Americas | West Indies | Montserrat | Plymouth | MH | MS | MSR | 500 | MS |
128 | 128 | 478 | Africa | Western Africa | Mauritania | Nouakchott | MR | MR | MRT | 478 | MR |
127 | 127 | 474 | Americas | West Indies | Martinique | Fort-de-France | MB | MQ | MTQ | 474 | MQ |
152 | 152 | 580 | Oceania | Pacific | Northern Mariana Islands | Saipan | CQ | MP | MNP | 580 | MP |
228 | 228 | 446 | Asia | East Asia | Macau (China) | Macau | MC | MO | MAC | 446 | MO |
135 | 135 | 496 | Asia | Northern Asia | Mongolia | Ulaanbaatar | MG | MN | MNG | 496 | MN |
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 );