external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
56 rows where continent = "Africa" sorted by isonumeric
This data as json, CSV (advanced)
Suggested facets: region
Link | rowid | id | continent | region | country | capital | fips | iso2 | iso3 | isonumeric ▼ | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
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 |
27 | 27 | 72 | Africa | Southern Africa | Botswana | Gaborone | BC | BW | BWA | 72 | BW |
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 |
130 | 130 | 175 | Africa | Indian Ocean | Mayotte | Mamoutzou | MF | YT | MYT | 175 | YT |
47 | 47 | 178 | Africa | Central Africa | Congo, Republic of the | Brazzaville | CF | CG | COG | 178 | CG |
224 | 224 | 180 | Africa | Central Africa | Zaire (Dem Rep of Congo) | Kinshasa | CG | ZR | ZAR | 180 | ZR |
22 | 22 | 204 | Africa | Western Africa | Benin | Porto-Novo | BN | BJ | BEN | 204 | BJ |
62 | 62 | 226 | Africa | Western Africa | Equatorial Guinea | Malabo | EK | GQ | GNQ | 226 | GQ |
65 | 65 | 231 | Africa | Eastern Africa | Ethiopia | Addis Ababa | ET | ET | ETH | 231 | ET |
63 | 63 | 232 | Africa | Eastern Africa | Eritrea | Asmara | ER | ER | ERI | 232 | ER |
56 | 56 | 262 | Africa | Eastern Africa | Djibouti | Djibouti | DJ | DJ | DJI | 262 | DJ |
73 | 73 | 266 | Africa | Western Africa | Gabon | Libreville | GB | GA | GAB | 266 | GA |
74 | 74 | 270 | Africa | Western Africa | Gambia, The | Banjul | GA | GM | GMB | 270 | GM |
77 | 77 | 288 | Africa | Western Africa | Ghana | Accra | GH | GH | GHA | 288 | GH |
85 | 85 | 324 | Africa | Western Africa | Guinea | Conakry | GV | GN | GIN | 324 | GN |
50 | 50 | 384 | Africa | Western Africa | Cote d'Ivoire | Yamoussoukro | IV | CI | CIV | 384 | CI |
104 | 104 | 404 | Africa | Eastern Africa | Kenya | Nairobi | KE | KE | KEN | 404 | KE |
113 | 113 | 426 | Africa | Southern Africa | Lesotho | Maseru | LT | LS | LSO | 426 | LS |
114 | 114 | 430 | Africa | Western Africa | Liberia | Monrovia | LI | LR | LBR | 430 | LR |
115 | 115 | 434 | Africa | Northern Africa | Libya | Tripoli | LY | LY | LBY | 434 | LY |
120 | 120 | 450 | Africa | Indian Ocean | Madagascar | Antananarivo | MA | MG | MDG | 450 | MG |
121 | 121 | 454 | Africa | Southern Africa | Malawi | Lilongwe | MI | MW | MWI | 454 | MW |
124 | 124 | 466 | Africa | Western Africa | Mali | Bamako | ML | ML | MLI | 466 | ML |
128 | 128 | 478 | Africa | Western Africa | Mauritania | Nouakchott | MR | MR | MRT | 478 | MR |
129 | 129 | 480 | Africa | Indian Ocean | Mauritius | Port Louis | MP | MU | MUS | 480 | MU |
137 | 137 | 504 | Africa | Northern Africa | Morocco | Rabat | MO | MA | MAR | 504 | MA |
138 | 138 | 508 | Africa | Southern Africa | Mozambique | Maputo | MZ | MZ | MOZ | 508 | MZ |
140 | 140 | 516 | Africa | Southern Africa | Namibia | Windhoek | WA | NAM | 516 | ||
148 | 148 | 562 | Africa | Western Africa | Niger | Niamey | NG | NE | NER | 562 | NE |
149 | 149 | 566 | Africa | Western Africa | Nigeria | Abuja | NI | NG | NGA | 566 | NG |
86 | 86 | 624 | Africa | Western Africa | Guinea-Bissau | Bissau | PU | GW | GNB | 624 | GW |
167 | 167 | 638 | Africa | Indian Ocean | Reunion | Saint-Denis | RE | RE | REU | 638 | RE |
170 | 170 | 646 | Africa | Central Africa | Rwanda | Kigali | RW | RW | RWA | 646 | RW |
176 | 176 | 678 | Africa | Western Africa | Sao Tome and Principe | Sao Tome | TP | ST | STP | 678 | ST |
178 | 178 | 686 | Africa | Western Africa | Senegal | Dakar | SG | SN | SEN | 686 | SN |
179 | 179 | 690 | Africa | Indian Ocean | Seychelles | Victoria | SE | SC | SYC | 690 | SC |
180 | 180 | 694 | Africa | Western Africa | Sierra Leone | Freetown | SL | SL | SLE | 694 | SL |
185 | 185 | 706 | Africa | Eastern Africa | Somalia | Mogadishu | SO | SO | SOM | 706 | SO |
186 | 186 | 710 | Africa | Southern Africa | South Africa | Pretoria | SF | ZA | ZAF | 710 | ZA |
226 | 226 | 716 | Africa | Southern Africa | Zimbabwe | Harare | ZI | ZW | ZWE | 716 | ZW |
221 | 221 | 732 | Africa | Northern Africa | Western Sahara | none | WI | EH | ESH | 732 | EH |
189 | 189 | 736 | Africa | Northern Africa | Sudan | Khartoum | SU | SD | SDN | 736 | SD |
192 | 192 | 748 | Africa | Southern Africa | Swaziland | Mbabane | WZ | SZ | SWZ | 748 | SZ |
200 | 200 | 768 | Africa | Western Africa | Togo | Lome | TO | TG | TGO | 768 | TG |
204 | 204 | 788 | Africa | Northern Africa | Tunisia | Tunis | TS | TN | TUN | 788 | TN |
209 | 209 | 800 | Africa | Eastern Africa | Uganda | Kampala | UG | UG | UGA | 800 | UG |
60 | 60 | 818 | Africa | Northern Africa | Egypt | Cairo | EG | EG | EGY | 818 | EG |
198 | 198 | 834 | Africa | Eastern Africa | Tanzania | Dar es Salaam | TZ | TZ | TZA | 834 | TZ |
32 | 32 | 854 | Africa | Western Africa | Burkina Faso | Ouagadougou | UV | BF | BFA | 854 | BF |
225 | 225 | 894 | Africa | Southern Africa | Zambia | Lusaka | ZA | ZM | ZWB | 894 | ZM |
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 );