external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by country descending
This data as json, CSV (advanced)
Link | rowid | id | continent | region | country ▲ | capital | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
130 | 130 | 175 | Africa | Indian Ocean | Mayotte | Mamoutzou | MF | YT | MYT | 175 | YT |
129 | 129 | 480 | Africa | Indian Ocean | Mauritius | Port Louis | MP | MU | MUS | 480 | MU |
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 |
126 | 126 | 584 | Oceania | Pacific | Marshall Islands | Majuro | RM | MH | MHL | 584 | MH |
125 | 125 | 470 | Europe | Southern Europe | Malta | Valletta | MT | MT | MLT | 470 | MT |
124 | 124 | 466 | Africa | Western Africa | Mali | Bamako | ML | ML | MLI | 466 | ML |
123 | 123 | 462 | Asia | South Asia | Maldives | Male (Maale) | MV | MV | MDV | 462 | MV |
122 | 122 | 458 | Asia | South East Asia | Malaysia | Kuala Lumpur | MY | MY | MYS | 458 | MY |
121 | 121 | 454 | Africa | Southern Africa | Malawi | Lilongwe | MI | MW | MWI | 454 | MW |
120 | 120 | 450 | Africa | Indian Ocean | Madagascar | Antananarivo | MA | MG | MDG | 450 | MG |
119 | 119 | 807 | Europe | South East Europe | Macedonia | Skopje | MK | MK | MKD | 807 | MK |
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 |
117 | 117 | 440 | Europe | Eastern Europe | Lithuania | Vilnius | LH | LT | LTU | 440 | LT |
116 | 116 | 438 | Europe | Central Europe | Liechtenstein | Vaduz | LS | LI | LIE | 438 | LI |
115 | 115 | 434 | Africa | Northern Africa | Libya | Tripoli | LY | LY | LBY | 434 | LY |
114 | 114 | 430 | Africa | Western Africa | Liberia | Monrovia | LI | LR | LBR | 430 | LR |
113 | 113 | 426 | Africa | Southern Africa | Lesotho | Maseru | LT | LS | LSO | 426 | LS |
112 | 112 | 422 | Asia | South West Asia | Lebanon | Beirut | LE | LB | LBN | 422 | LB |
111 | 111 | 428 | Europe | Eastern Europe | Latvia | Riga | LG | LV | LVA | 428 | LV |
110 | 110 | 418 | Asia | South East Asia | Laos | Vientiane | LA | LA | LAO | 418 | LA |
109 | 109 | 417 | Asia | Central Asia | Kyrgyzstan | Bishkek | KG | KG | KGZ | 417 | KG |
108 | 108 | 414 | Asia | South West Asia | Kuwait | Kuwait | KU | KW | KWT | 414 | KW |
107 | 107 | 410 | Asia | East Asia | Korea, South | Seoul | KS | KR | KOR | 410 | KR |
106 | 106 | 408 | Asia | East Asia | Korea, North | P'yongyang | KN | KP | PRK | 408 | KP |
105 | 105 | 296 | Oceania | Pacific | Kiribati | Tarawa | KR | KI | KIR | 296 | KI |
104 | 104 | 404 | Africa | Eastern Africa | Kenya | Nairobi | KE | KE | KEN | 404 | KE |
103 | 103 | 398 | Asia | Central Asia | Kazakhstan | Astana (Akmola) | KZ | KZ | KAZ | 398 | KZ |
102 | 102 | 400 | Asia | South West Asia | Jordan | Amman | JO | JO | JOR | 400 | JO |
101 | 101 | 392 | Asia | East Asia | Japan | Tokyo | JA | JP | JPN | 392 | JP |
100 | 100 | 388 | Americas | West Indies | Jamaica | Kingston | JM | JM | JAM | 388 | JM |
99 | 99 | 380 | Europe | Southern Europe | Italy | Rome | IT | IT | ITA | 380 | IT |
98 | 98 | 376 | Asia | South West Asia | Israel | Jerusalem | IS | IL | ISR | 376 | IL |
97 | 97 | 372 | Europe | Western Europe | Ireland | Dublin | EI | IE | IRL | 372 | IE |
96 | 96 | 368 | Asia | South West Asia | Iraq | Baghdad | IZ | IQ | IRQ | 368 | IQ |
95 | 95 | 364 | Asia | South West Asia | Iran | Tehran | IR | IR | IRN | 364 | IR |
94 | 94 | 360 | Asia | South East Asia | Indonesia | Jakarta | ID | ID | IDN | 360 | ID |
93 | 93 | 356 | Asia | South Asia | India | New Delhi | IN | IN | IND | 356 | IN |
92 | 92 | 352 | Europe | Northern Europe | Iceland | Reykjavik | IC | IS | ISL | 352 | IS |
91 | 91 | 348 | Europe | Central Europe | Hungary | Budapest | HU | HU | HUN | 348 | HU |
227 | 227 | 344 | Asia | East Asia | Hong Kong (China) | Victoria | HK | HK | HKG | 344 | HK |
90 | 90 | 340 | Americas | Central America | Honduras | Tegucigalpa | HO | HN | HND | 340 | HN |
89 | 89 | 336 | Europe | Southern Europe | Holy See (Vatican City) | Vatican City | VT | VA | VAT | 336 | VA |
235 | 235 | 334 | Indian Ocean | Southern Indian Ocean | Heard Island and McDonald Islands | HM | HM | HMD | 334 | HM | |
88 | 88 | 332 | Americas | West Indies | Haiti | Port-au-Prince | HA | HT | HTI | 332 | HT |
87 | 87 | 328 | Americas | South America | Guyana | Georgetown | GY | GY | GUY | 328 | GY |
86 | 86 | 624 | Africa | Western Africa | Guinea-Bissau | Bissau | PU | GW | GNB | 624 | GW |
85 | 85 | 324 | Africa | Western Africa | Guinea | Conakry | GV | GN | GIN | 324 | GN |
84 | 84 | 320 | Americas | Central America | Guatemala | Guatemala | GT | GT | GTM | 320 | GT |
83 | 83 | 316 | Oceania | Pacific | Guam | Hagatna (Agana) | GQ | GU | GUM | 316 | GU |
82 | 82 | 312 | Americas | West Indies | Guadeloupe | Basse-Terre | GP | GP | GLP | 312 | GP |
81 | 81 | 308 | Americas | West Indies | Grenada | Saint George's | GJ | GD | GRD | 308 | GD |
80 | 80 | 304 | Americas | North America | Greenland | Nuuk (Godthab) | GL | GL | GRL | 304 | GL |
79 | 79 | 300 | Europe | South East Europe | Greece | Athens | GR | GR | GRC | 300 | GR |
78 | 78 | 292 | Europe | South West Europe | Gibraltar | Gibraltar | GI | GI | GIB | 292 | GI |
77 | 77 | 288 | Africa | Western Africa | Ghana | Accra | GH | GH | GHA | 288 | GH |
76 | 76 | 276 | Europe | Western Europe | Germany | Berlin | GM | DE | DEU | 276 | DE |
75 | 75 | 268 | Asia | South West Asia | Georgia | T'bilisi | GG | GE | GEO | 268 | GE |
74 | 74 | 270 | Africa | Western Africa | Gambia, The | Banjul | GA | GM | GMB | 270 | GM |
73 | 73 | 266 | Africa | Western Africa | Gabon | Libreville | GB | GA | GAB | 266 | GA |
234 | 234 | 260 | Indian Ocean | Southern Indian Ocean | French Southern and Antarctic Lands | FS | TF | ATF | 260 | ||
72 | 72 | 258 | Oceania | Pacific | French Polynesia | Papeete | FP | PF | PYF | 258 | PF |
71 | 71 | 254 | Americas | South America | French Guiana | Cayenne | FG | GF | GUF | 254 | GF |
233 | 233 | 249 | Europe | Western Europe | France, Metropolitan | FX | FXX | 249 | FX | ||
70 | 70 | 250 | Europe | Western Europe | France | Paris | FR | FR | FRA | 250 | FR |
69 | 69 | 246 | Europe | Northern Europe | Finland | Helsinki | FI | FI | FIN | 246 | FI |
68 | 68 | 242 | Oceania | Pacific | Fiji | Suva | FJ | FJ | FJI | 242 | FJ |
67 | 67 | 234 | Europe | Northern Europe | Faroe Islands | Torshavn | FO | FO | FRO | 234 | FO |
66 | 66 | 238 | Americas | South America | Falkland Islands (Islas Malvinas) | Stanley | FA | FK | FLK | 238 | FK |
65 | 65 | 231 | Africa | Eastern Africa | Ethiopia | Addis Ababa | ET | ET | ETH | 231 | ET |
64 | 64 | 233 | Europe | Eastern Europe | Estonia | Tallinn | EN | EE | EST | 233 | EE |
63 | 63 | 232 | Africa | Eastern Africa | Eritrea | Asmara | ER | ER | ERI | 232 | ER |
62 | 62 | 226 | Africa | Western Africa | Equatorial Guinea | Malabo | EK | GQ | GNQ | 226 | GQ |
61 | 61 | 222 | Americas | Central America | El Salvador | San Salvador | ES | SV | SLV | 222 | SV |
60 | 60 | 818 | Africa | Northern Africa | Egypt | Cairo | EG | EG | EGY | 818 | EG |
59 | 59 | 218 | Americas | South America | Ecuador | Quito | EC | EC | ECU | 218 | EC |
232 | 232 | 626 | Asia | South East Asia | East Timor | TP | TMP | 626 | TP | ||
58 | 58 | 214 | Americas | West Indies | Dominican Republic | Santo Domingo | DR | DO | DOM | 214 | DO |
57 | 57 | 212 | Americas | West Indies | Dominica | Roseau | DO | DM | DMA | 212 | DM |
56 | 56 | 262 | Africa | Eastern Africa | Djibouti | Djibouti | DJ | DJ | DJI | 262 | DJ |
55 | 55 | 208 | Europe | Northern Europe | Denmark | Copenhagen | DA | DK | DNK | 208 | DK |
54 | 54 | 203 | Europe | Central Europe | Czech Republic | Prague | EZ | CZ | CZE | 203 | CZ |
53 | 53 | 196 | Asia | South West Asia | Cyprus | Nicosia | CY | CY | CYP | 196 | CY |
52 | 52 | 192 | Americas | West Indies | Cuba | Havana | CU | CU | CUB | 192 | CU |
51 | 51 | 191 | Europe | South East Europe | Croatia | Zagreb | HR | HR | HRV | 191 | HR |
50 | 50 | 384 | Africa | Western Africa | Cote d'Ivoire | Yamoussoukro | IV | CI | CIV | 384 | CI |
49 | 49 | 188 | Americas | Central America | Costa Rica | San Jose | CS | CR | CRI | 188 | CR |
48 | 48 | 184 | Oceania | Pacific | Cook Islands | Avarua | CW | CK | COK | 184 | CK |
47 | 47 | 178 | Africa | Central Africa | Congo, Republic of the | Brazzaville | CF | CG | COG | 178 | CG |
46 | 46 | 174 | Africa | Indian Ocean | Comoros | Moroni | CN | KM | COM | 174 | KM |
45 | 45 | 170 | Americas | South America | Colombia | Bogota | CO | CO | COL | 170 | CO |
44 | 44 | 166 | Asia | South East Asia | Cocos (Keeling) Islands | West Island | CK | CC | CCK | 166 | CC |
43 | 43 | 162 | Asia | South East Asia | Christmas Island | The Settlement | KT | CX | CXR | 162 | CX |
42 | 42 | 156 | Asia | East Asia | China | Beijing | CH | CN | CHN | 156 | CN |
41 | 41 | 152 | Americas | South America | Chile | Santiago | CI | CL | CHL | 152 | CL |
40 | 40 | 148 | Africa | Central Africa | Chad | N'Djamena | CD | TD | TCD | 148 | TD |
39 | 39 | 140 | Africa | Central Africa | Central African Republic | Bangui | CT | CF | CAF | 140 | CF |
38 | 38 | 136 | Americas | West Indies | Cayman Islands | George Town | CJ | KY | CYM | 136 | KY |
37 | 37 | 132 | Africa | Western Africa | Cape Verde | Praia | CV | CV | CPV | 132 | CV |
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 );