external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
4 rows where region = "North America" sorted by isonumeric
This data as json, CSV (advanced)
Link | rowid | id | continent | region | country | capital | fips | iso2 | iso3 | isonumeric ▼ | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
36 | 36 | 124 | Americas | North America | Canada | Ottawa | CA | CA | CAN | 124 | CA |
80 | 80 | 304 | Americas | North America | Greenland | Nuuk (Godthab) | GL | GL | GRL | 304 | GL |
173 | 173 | 666 | Americas | North America | Saint Pierre and Miquelon | Saint-Pierre | SB | PM | SPM | 666 | PM |
213 | 213 | 840 | Americas | North America | United States | Washington, DC | US | US | USA | 840 | US |
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 );