external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by continent descending
This data as json, CSV (advanced)
Link | rowid | id | continent ▲ | region | country | capital | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
108 | 108 | 414 | Asia | South West Asia | Kuwait | Kuwait | KU | KW | KWT | 414 | KW |
109 | 109 | 417 | Asia | Central Asia | Kyrgyzstan | Bishkek | KG | KG | KGZ | 417 | KG |
110 | 110 | 418 | Asia | South East Asia | Laos | Vientiane | LA | LA | LAO | 418 | LA |
112 | 112 | 422 | Asia | South West Asia | Lebanon | Beirut | LE | LB | LBN | 422 | LB |
122 | 122 | 458 | Asia | South East Asia | Malaysia | Kuala Lumpur | MY | MY | MYS | 458 | MY |
123 | 123 | 462 | Asia | South Asia | Maldives | Male (Maale) | MV | MV | MDV | 462 | MV |
135 | 135 | 496 | Asia | Northern Asia | Mongolia | Ulaanbaatar | MG | MN | MNG | 496 | MN |
139 | 139 | 104 | Asia | South East Asia | Myanmar (Burma) | Rangoon (Yangon) | BM | MM | MMR | 104 | MM |
142 | 142 | 524 | Asia | South Asia | Nepal | Kathmandu | NP | NP | NPL | 524 | NP |
154 | 154 | 512 | Asia | South West Asia | Oman | Muscat | MU | OM | OMN | 512 | OM |
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 |
166 | 166 | 634 | Asia | South West Asia | Qatar | Doha | QA | QA | QAT | 634 | QA |
169 | 169 | 643 | Asia | Northern Asia | Russia | Moscow | RS | RU | RUS | 643 | RU |
177 | 177 | 682 | Asia | South West Asia | Saudi Arabia | Riyadh | SA | SA | SAU | 682 | SA |
181 | 181 | 702 | Asia | South East Asia | Singapore | Singapore | SN | SG | SGP | 702 | SG |
188 | 188 | 144 | Asia | South Asia | Sri Lanka | Colombo | CE | LK | LKA | 144 | LK |
195 | 195 | 760 | Asia | South West Asia | Syria | Damascus | SY | SY | SYR | 760 | SY |
196 | 196 | 158 | Asia | East Asia | Taiwan | Taipei | TW | TW | TWN | 158 | TW |
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 |
205 | 205 | 792 | Asia | South West Asia | Turkey | Ankara | TU | TR | TUR | 792 | TR |
206 | 206 | 795 | Asia | Central Asia | Turkmenistan | Ashgabat | TX | TM | TKM | 795 | TM |
211 | 211 | 784 | Asia | South West Asia | United Arab Emirates | Abu Dhabi | TC | AE | ARE | 784 | AE |
215 | 215 | 860 | Asia | Central Asia | Uzbekistan | Tashkent (Toshkent) | UZ | UZ | UZB | 860 | UZ |
218 | 218 | 704 | Asia | South East Asia | Vietnam | Hanoi | VM | VN | VNM | 704 | VN |
223 | 223 | 887 | Asia | South West Asia | Yemen | Sanaa | YM | YE | YEM | 887 | YE |
227 | 227 | 344 | Asia | East Asia | Hong Kong (China) | Victoria | HK | HK | HKG | 344 | HK |
228 | 228 | 446 | Asia | East Asia | Macau (China) | Macau | MC | MO | MAC | 446 | MO |
231 | 231 | 86 | Asia | South Asia | British Indian Ocean Territory | IO | IO | IOT | 86 | IO | |
232 | 232 | 626 | Asia | South East Asia | East Timor | TP | TMP | 626 | TP | ||
229 | 229 | 10 | Antarctica | Antarctica | Antarctica | AY | AQ | ATA | 10 | AQ | |
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 |
9 | 9 | 32 | Americas | South America | Argentina | Buenos Aires | AR | AR | ARG | 32 | AR |
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 |
21 | 21 | 84 | Americas | Central America | Belize | Belmopan | BH | BZ | BLZ | 84 | BZ |
23 | 23 | 60 | Americas | West Indies | Bermuda | Hamilton | BD | BM | BMU | 60 | BM |
25 | 25 | 68 | Americas | South America | Bolivia | La Paz / Sucre | BL | BO | BOL | 68 | BO |
28 | 28 | 76 | Americas | South America | Brazil | Brasilia | BR | BR | BRA | 76 | BR |
29 | 29 | 92 | Americas | West Indies | British Virgin Islands | Road Town | VI | VG | VGB | 92 | VG |
36 | 36 | 124 | Americas | North America | Canada | Ottawa | CA | CA | CAN | 124 | CA |
38 | 38 | 136 | Americas | West Indies | Cayman Islands | George Town | CJ | KY | CYM | 136 | KY |
41 | 41 | 152 | Americas | South America | Chile | Santiago | CI | CL | CHL | 152 | CL |
45 | 45 | 170 | Americas | South America | Colombia | Bogota | CO | CO | COL | 170 | CO |
49 | 49 | 188 | Americas | Central America | Costa Rica | San Jose | CS | CR | CRI | 188 | CR |
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 |
59 | 59 | 218 | Americas | South America | Ecuador | Quito | EC | EC | ECU | 218 | EC |
61 | 61 | 222 | Americas | Central America | El Salvador | San Salvador | ES | SV | SLV | 222 | SV |
66 | 66 | 238 | Americas | South America | Falkland Islands (Islas Malvinas) | Stanley | FA | FK | FLK | 238 | FK |
71 | 71 | 254 | Americas | South America | French Guiana | Cayenne | FG | GF | GUF | 254 | GF |
80 | 80 | 304 | Americas | North America | Greenland | Nuuk (Godthab) | GL | GL | GRL | 304 | GL |
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 |
84 | 84 | 320 | Americas | Central America | Guatemala | Guatemala | GT | GT | GTM | 320 | GT |
87 | 87 | 328 | Americas | South America | Guyana | Georgetown | GY | GY | GUY | 328 | GY |
88 | 88 | 332 | Americas | West Indies | Haiti | Port-au-Prince | HA | HT | HTI | 332 | HT |
90 | 90 | 340 | Americas | Central America | Honduras | Tegucigalpa | HO | HN | HND | 340 | HN |
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 |
131 | 131 | 484 | Americas | Central America | Mexico | Mexico | MX | MX | MEX | 484 | MX |
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 |
147 | 147 | 558 | Americas | Central America | Nicaragua | Managua | NU | NI | NIC | 558 | NI |
157 | 157 | 591 | Americas | Central America | Panama | Panama | PM | PA | PAN | 591 | PA |
159 | 159 | 600 | Americas | South America | Paraguay | Asuncion | PA | PY | PRY | 600 | PY |
160 | 160 | 604 | Americas | South America | Peru | Lima | PE | PE | PER | 604 | PE |
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 |
173 | 173 | 666 | Americas | North America | Saint Pierre and Miquelon | Saint-Pierre | SB | PM | SPM | 666 | PM |
174 | 174 | 670 | Americas | West Indies | Saint Vincent and the Grenadines | Kingstown | VC | VC | VCT | 670 | VC |
190 | 190 | 740 | Americas | South America | Suriname | Paramaribo | NS | SR | SUR | 740 | SR |
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 |
213 | 213 | 840 | Americas | North America | United States | Washington, DC | US | US | USA | 840 | US |
214 | 214 | 858 | Americas | South America | Uruguay | Montevideo | UY | UY | URY | 858 | UY |
217 | 217 | 862 | Americas | South America | Venezuela | Caracas | VE | VE | VEN | 862 | UE |
219 | 219 | 850 | Americas | West Indies | Virgin Islands | Charlotte Amalie | VQ | VI | VIR | 850 | VI |
3 | 3 | 12 | Africa | Northern Africa | Algeria | Algiers | AG | DZ | DZA | 12 | DZ |
6 | 6 | 24 | Africa | Southern Africa | Angola | Luanda | AO | AO | AGO | 24 | AO |
22 | 22 | 204 | Africa | Western Africa | Benin | Porto-Novo | BN | BJ | BEN | 204 | BJ |
27 | 27 | 72 | Africa | Southern Africa | Botswana | Gaborone | BC | BW | BWA | 72 | BW |
32 | 32 | 854 | Africa | Western Africa | Burkina Faso | Ouagadougou | UV | BF | BFA | 854 | BF |
33 | 33 | 108 | Africa | Central Africa | Burundi | Bujumbura | BY | BI | BDI | 108 | BI |
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 |
39 | 39 | 140 | Africa | Central Africa | Central African Republic | Bangui | CT | CF | CAF | 140 | CF |
40 | 40 | 148 | Africa | Central Africa | Chad | N'Djamena | CD | TD | TCD | 148 | TD |
46 | 46 | 174 | Africa | Indian Ocean | Comoros | Moroni | CN | KM | COM | 174 | KM |
47 | 47 | 178 | Africa | Central Africa | Congo, Republic of the | Brazzaville | CF | CG | COG | 178 | CG |
50 | 50 | 384 | Africa | Western Africa | Cote d'Ivoire | Yamoussoukro | IV | CI | CIV | 384 | CI |
56 | 56 | 262 | Africa | Eastern Africa | Djibouti | Djibouti | DJ | DJ | DJI | 262 | DJ |
60 | 60 | 818 | Africa | Northern Africa | Egypt | Cairo | EG | EG | EGY | 818 | EG |
62 | 62 | 226 | Africa | Western Africa | Equatorial Guinea | Malabo | EK | GQ | GNQ | 226 | GQ |
63 | 63 | 232 | Africa | Eastern Africa | Eritrea | Asmara | ER | ER | ERI | 232 | ER |
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 );