external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
51 rows where continent = "Americas"
This data as json, CSV (advanced)
Link | rowid ▼ | id | continent | region | country | capital | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 );