external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
7 rows where region = "East Asia" sorted by isonumeric
This data as json, CSV (advanced)
Link | rowid | id | continent | region | country | capital | fips | iso2 | iso3 | isonumeric ▼ | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
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 |
227 | 227 | 344 | Asia | East Asia | Hong Kong (China) | Victoria | HK | HK | HKG | 344 | HK |
101 | 101 | 392 | Asia | East Asia | Japan | Tokyo | JA | JP | JPN | 392 | JP |
106 | 106 | 408 | Asia | East Asia | Korea, North | P'yongyang | KN | KP | PRK | 408 | KP |
107 | 107 | 410 | Asia | East Asia | Korea, South | Seoul | KS | KR | KOR | 410 | KR |
228 | 228 | 446 | Asia | East Asia | Macau (China) | Macau | MC | MO | MAC | 446 | MO |
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 );