external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
25 rows where region = "West Indies" sorted by isonumeric
This data as json, CSV (advanced)
Link | rowid | id | continent | region | country | capital | fips | iso2 | iso3 | isonumeric ▼ | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
8 | 8 | 28 | Americas | West Indies | Antigua and Barbuda | Saint John's | AC | AG | ATG | 28 | AG |
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 |
23 | 23 | 60 | Americas | West Indies | Bermuda | Hamilton | BD | BM | BMU | 60 | BM |
29 | 29 | 92 | Americas | West Indies | British Virgin Islands | Road Town | VI | VG | VGB | 92 | VG |
38 | 38 | 136 | Americas | West Indies | Cayman Islands | George Town | CJ | KY | CYM | 136 | KY |
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 |
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 |
88 | 88 | 332 | Americas | West Indies | Haiti | Port-au-Prince | HA | HT | HTI | 332 | HT |
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 |
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 |
11 | 11 | 533 | Americas | West Indies | Aruba | Oranjestad | AA | AW | ABW | 533 | AW |
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 |
7 | 7 | 660 | Americas | West Indies | Anguilla | The Valley | AV | AI | AIA | 660 | AI |
172 | 172 | 662 | Americas | West Indies | Saint Lucia | Castries | ST | LC | LCA | 662 | LC |
174 | 174 | 670 | Americas | West Indies | Saint Vincent and the Grenadines | Kingstown | VC | VC | VCT | 670 | VC |
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 |
219 | 219 | 850 | Americas | West Indies | Virgin Islands | Charlotte Amalie | VQ | VI | VIR | 850 | VI |
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 );