external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
54 rows where continent = "Asia"
This data as json, CSV (advanced)
Link | rowid ▼ | id | continent | region | country | capital | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
101 | 101 | 392 | Asia | East Asia | Japan | Tokyo | JA | JP | JPN | 392 | JP |
102 | 102 | 400 | Asia | South West Asia | Jordan | Amman | JO | JO | JOR | 400 | JO |
103 | 103 | 398 | Asia | Central Asia | Kazakhstan | Astana (Akmola) | KZ | KZ | KAZ | 398 | KZ |
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 |
108 | 108 | 414 | Asia | South West Asia | Kuwait | Kuwait | KU | KW | KWT | 414 | KW |
109 | 109 | 417 | Asia | Central Asia | Kyrgyzstan | Bishkek | KG | KG | KGZ | 417 | KG |
110 | 110 | 418 | Asia | South East Asia | Laos | Vientiane | LA | LA | LAO | 418 | LA |
112 | 112 | 422 | Asia | South West Asia | Lebanon | Beirut | LE | LB | LBN | 422 | LB |
122 | 122 | 458 | Asia | South East Asia | Malaysia | Kuala Lumpur | MY | MY | MYS | 458 | MY |
123 | 123 | 462 | Asia | South Asia | Maldives | Male (Maale) | MV | MV | MDV | 462 | MV |
135 | 135 | 496 | Asia | Northern Asia | Mongolia | Ulaanbaatar | MG | MN | MNG | 496 | MN |
139 | 139 | 104 | Asia | South East Asia | Myanmar (Burma) | Rangoon (Yangon) | BM | MM | MMR | 104 | MM |
142 | 142 | 524 | Asia | South Asia | Nepal | Kathmandu | NP | NP | NPL | 524 | NP |
154 | 154 | 512 | Asia | South West Asia | Oman | Muscat | MU | OM | OMN | 512 | OM |
155 | 155 | 586 | Asia | South Asia | Pakistan | Islamabad | PK | PK | PAK | 586 | PK |
161 | 161 | 608 | Asia | South East Asia | Philippines | Manila | RP | PH | PHL | 608 | PH |
166 | 166 | 634 | Asia | South West Asia | Qatar | Doha | QA | QA | QAT | 634 | QA |
169 | 169 | 643 | Asia | Northern Asia | Russia | Moscow | RS | RU | RUS | 643 | RU |
177 | 177 | 682 | Asia | South West Asia | Saudi Arabia | Riyadh | SA | SA | SAU | 682 | SA |
181 | 181 | 702 | Asia | South East Asia | Singapore | Singapore | SN | SG | SGP | 702 | SG |
188 | 188 | 144 | Asia | South Asia | Sri Lanka | Colombo | CE | LK | LKA | 144 | LK |
195 | 195 | 760 | Asia | South West Asia | Syria | Damascus | SY | SY | SYR | 760 | SY |
196 | 196 | 158 | Asia | East Asia | Taiwan | Taipei | TW | TW | TWN | 158 | TW |
197 | 197 | 762 | Asia | Central Asia | Tajikistan | Dushanbe | TI | TJ | TJK | 762 | TJ |
199 | 199 | 764 | Asia | South East Asia | Thailand | Bangkok | TH | TH | THA | 764 | TH |
205 | 205 | 792 | Asia | South West Asia | Turkey | Ankara | TU | TR | TUR | 792 | TR |
206 | 206 | 795 | Asia | Central Asia | Turkmenistan | Ashgabat | TX | TM | TKM | 795 | TM |
211 | 211 | 784 | Asia | South West Asia | United Arab Emirates | Abu Dhabi | TC | AE | ARE | 784 | AE |
215 | 215 | 860 | Asia | Central Asia | Uzbekistan | Tashkent (Toshkent) | UZ | UZ | UZB | 860 | UZ |
218 | 218 | 704 | Asia | South East Asia | Vietnam | Hanoi | VM | VN | VNM | 704 | VN |
223 | 223 | 887 | Asia | South West Asia | Yemen | Sanaa | YM | YE | YEM | 887 | YE |
227 | 227 | 344 | Asia | East Asia | Hong Kong (China) | Victoria | HK | HK | HKG | 344 | HK |
228 | 228 | 446 | Asia | East Asia | Macau (China) | Macau | MC | MO | MAC | 446 | MO |
231 | 231 | 86 | Asia | South Asia | British Indian Ocean Territory | IO | IO | IOT | 86 | IO | |
232 | 232 | 626 | Asia | South East Asia | East Timor | TP | TMP | 626 | TP |
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 );