external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by isonumeric
This data as json, CSV (advanced)
region 28 ✖
- Pacific 25
- West Indies 25
- Western Africa 20
- South West Asia 18
- South America 14
- South East Asia 13
- Southern Africa 10
- South Asia 9
- South East Europe 9
- Western Europe 9
- Central America 8
- East Asia 7
- Eastern Africa 7
- Eastern Europe 7
- Northern Africa 7
- Northern Europe 7
- Central Africa 6
- Central Europe 6
- Indian Ocean 6
- Central Asia 5
- North America 4
- South West Europe 4
- Southern Europe 4
- South Atlantic Ocean 3
- Northern Asia 2
- Southern Indian Ocean 2
- Antarctica 1
- North Pacific Ocean 1
continent 8 ✖
- Africa 56
- Asia 54
- Americas 51
- Europe 46
- Oceania 26
- Atlantic Ocean 3
- Indian Ocean 2
- Antarctica 1
Link | rowid | id | continent | region | country | capital | fips | iso2 | iso3 | isonumeric ▼ | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 4 | Asia | South Asia | Afghanistan | Kabul | AF | AF | AFG | 4 | AF |
2 | 2 | 8 | Europe | South East Europe | Albania | Tirana | AL | AL | ALB | 8 | AL |
229 | 229 | 10 | Antarctica | Antarctica | Antarctica | AY | AQ | ATA | 10 | AQ | |
3 | 3 | 12 | Africa | Northern Africa | Algeria | Algiers | AG | DZ | DZA | 12 | DZ |
4 | 4 | 16 | Oceania | Pacific | American Samoa | Pago Pago | AQ | AS | ASM | 16 | AS |
5 | 5 | 20 | Europe | South West Europe | Andorra | Andorra la Vella | AN | AD | AND | 20 | AD |
6 | 6 | 24 | Africa | Southern Africa | Angola | Luanda | AO | AO | AGO | 24 | AO |
8 | 8 | 28 | Americas | West Indies | Antigua and Barbuda | Saint John's | AC | AG | ATG | 28 | AG |
14 | 14 | 31 | Asia | South West Asia | Azerbaijan | Baku (Baki) | AJ | AZ | AZE | 31 | AZ |
9 | 9 | 32 | Americas | South America | Argentina | Buenos Aires | AR | AR | ARG | 32 | AR |
12 | 12 | 36 | Oceania | Pacific | Australia | Canberra | AS | AU | AUS | 36 | AU |
13 | 13 | 40 | Europe | Central Europe | Austria | Vienna | AU | AT | AUT | 40 | AT |
15 | 15 | 44 | Americas | West Indies | Bahamas, The | Nassau | BF | BS | BHS | 44 | BS |
16 | 16 | 48 | Asia | South West Asia | Bahrain | Manama | BA | BH | BHR | 48 | BH |
17 | 17 | 50 | Asia | South Asia | Bangladesh | Dhaka | BG | BD | BGD | 50 | BD |
10 | 10 | 51 | Asia | South West Asia | Armenia | Yerevan | AM | AM | ARM | 51 | AM |
18 | 18 | 52 | Americas | West Indies | Barbados | Bridgetown | BB | BB | BRB | 52 | BB |
20 | 20 | 56 | Europe | Western Europe | Belgium | Brussels | BE | BE | BEL | 56 | BE |
23 | 23 | 60 | Americas | West Indies | Bermuda | Hamilton | BD | BM | BMU | 60 | BM |
24 | 24 | 64 | Asia | South Asia | Bhutan | Thimphu | BT | BT | BTN | 64 | BT |
25 | 25 | 68 | Americas | South America | Bolivia | La Paz / Sucre | BL | BO | BOL | 68 | BO |
26 | 26 | 70 | Europe | South East Europe | Bosnia and Herzegovina | Sarajevo | BK | BA | BIH | 70 | BA |
27 | 27 | 72 | Africa | Southern Africa | Botswana | Gaborone | BC | BW | BWA | 72 | BW |
230 | 230 | 74 | Atlantic Ocean | South Atlantic Ocean | Bouvet Island | BV | BV | BVT | 74 | BV | |
28 | 28 | 76 | Americas | South America | Brazil | Brasilia | BR | BR | BRA | 76 | BR |
21 | 21 | 84 | Americas | Central America | Belize | Belmopan | BH | BZ | BLZ | 84 | BZ |
231 | 231 | 86 | Asia | South Asia | British Indian Ocean Territory | IO | IO | IOT | 86 | IO | |
184 | 184 | 90 | Oceania | Pacific | Solomon Islands | Honiara | BP | SB | SLB | 90 | SB |
29 | 29 | 92 | Americas | West Indies | British Virgin Islands | Road Town | VI | VG | VGB | 92 | VG |
30 | 30 | 96 | Asia | South East Asia | Brunei | Bandar Seri Begawan | BX | BN | BRN | 96 | BN |
31 | 31 | 100 | Europe | South East Europe | Bulgaria | Sofia | BU | BG | BGR | 100 | BG |
139 | 139 | 104 | Asia | South East Asia | Myanmar (Burma) | Rangoon (Yangon) | BM | MM | MMR | 104 | MM |
33 | 33 | 108 | Africa | Central Africa | Burundi | Bujumbura | BY | BI | BDI | 108 | BI |
19 | 19 | 112 | Europe | Eastern Europe | Belarus | Minsk | BO | BY | BLR | 112 | BY |
34 | 34 | 116 | Asia | South East Asia | Cambodia | Phnom Penh | CB | KH | KHM | 116 | KH |
35 | 35 | 120 | Africa | Western Africa | Cameroon | Yaounde | CM | CM | CMR | 120 | CM |
36 | 36 | 124 | Americas | North America | Canada | Ottawa | CA | CA | CAN | 124 | CA |
37 | 37 | 132 | Africa | Western Africa | Cape Verde | Praia | CV | CV | CPV | 132 | CV |
38 | 38 | 136 | Americas | West Indies | Cayman Islands | George Town | CJ | KY | CYM | 136 | KY |
39 | 39 | 140 | Africa | Central Africa | Central African Republic | Bangui | CT | CF | CAF | 140 | CF |
188 | 188 | 144 | Asia | South Asia | Sri Lanka | Colombo | CE | LK | LKA | 144 | LK |
40 | 40 | 148 | Africa | Central Africa | Chad | N'Djamena | CD | TD | TCD | 148 | TD |
41 | 41 | 152 | Americas | South America | Chile | Santiago | CI | CL | CHL | 152 | CL |
42 | 42 | 156 | Asia | East Asia | China | Beijing | CH | CN | CHN | 156 | CN |
196 | 196 | 158 | Asia | East Asia | Taiwan | Taipei | TW | TW | TWN | 158 | TW |
43 | 43 | 162 | Asia | South East Asia | Christmas Island | The Settlement | KT | CX | CXR | 162 | CX |
44 | 44 | 166 | Asia | South East Asia | Cocos (Keeling) Islands | West Island | CK | CC | CCK | 166 | CC |
45 | 45 | 170 | Americas | South America | Colombia | Bogota | CO | CO | COL | 170 | CO |
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 |
48 | 48 | 184 | Oceania | Pacific | Cook Islands | Avarua | CW | CK | COK | 184 | CK |
49 | 49 | 188 | Americas | Central America | Costa Rica | San Jose | CS | CR | CRI | 188 | CR |
51 | 51 | 191 | Europe | South East Europe | Croatia | Zagreb | HR | HR | HRV | 191 | HR |
52 | 52 | 192 | Americas | West Indies | Cuba | Havana | CU | CU | CUB | 192 | CU |
53 | 53 | 196 | Asia | South West Asia | Cyprus | Nicosia | CY | CY | CYP | 196 | CY |
54 | 54 | 203 | Europe | Central Europe | Czech Republic | Prague | EZ | CZ | CZE | 203 | CZ |
22 | 22 | 204 | Africa | Western Africa | Benin | Porto-Novo | BN | BJ | BEN | 204 | BJ |
55 | 55 | 208 | Europe | Northern Europe | Denmark | Copenhagen | DA | DK | DNK | 208 | DK |
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 |
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 |
64 | 64 | 233 | Europe | Eastern Europe | Estonia | Tallinn | EN | EE | EST | 233 | EE |
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 |
237 | 237 | 239 | Atlantic Ocean | South Atlantic Ocean | South Georgia and the South Sandwich Islands | SX | GS | SGS | 239 | GS | |
68 | 68 | 242 | Oceania | Pacific | Fiji | Suva | FJ | FJ | FJI | 242 | FJ |
69 | 69 | 246 | Europe | Northern Europe | Finland | Helsinki | FI | FI | FIN | 246 | FI |
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 |
71 | 71 | 254 | Americas | South America | French Guiana | Cayenne | FG | GF | GUF | 254 | GF |
72 | 72 | 258 | Oceania | Pacific | French Polynesia | Papeete | FP | PF | PYF | 258 | PF |
234 | 234 | 260 | Indian Ocean | Southern Indian Ocean | French Southern and Antarctic Lands | FS | TF | ATF | 260 | ||
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 |
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 |
76 | 76 | 276 | Europe | Western Europe | Germany | Berlin | GM | DE | DEU | 276 | DE |
77 | 77 | 288 | Africa | Western Africa | Ghana | Accra | GH | GH | GHA | 288 | GH |
78 | 78 | 292 | Europe | South West Europe | Gibraltar | Gibraltar | GI | GI | GIB | 292 | GI |
105 | 105 | 296 | Oceania | Pacific | Kiribati | Tarawa | KR | KI | KIR | 296 | KI |
79 | 79 | 300 | Europe | South East Europe | Greece | Athens | GR | GR | GRC | 300 | GR |
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 |
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 |
85 | 85 | 324 | Africa | Western Africa | Guinea | Conakry | GV | GN | GIN | 324 | GN |
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 |
235 | 235 | 334 | Indian Ocean | Southern Indian Ocean | Heard Island and McDonald Islands | HM | HM | HMD | 334 | HM | |
89 | 89 | 336 | Europe | Southern Europe | Holy See (Vatican City) | Vatican City | VT | VA | VAT | 336 | VA |
90 | 90 | 340 | Americas | Central America | Honduras | Tegucigalpa | HO | HN | HND | 340 | HN |
227 | 227 | 344 | Asia | East Asia | Hong Kong (China) | Victoria | HK | HK | HKG | 344 | HK |
91 | 91 | 348 | Europe | Central Europe | Hungary | Budapest | HU | HU | HUN | 348 | HU |
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 );