external_country_iso
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by continent
This data as json, CSV (advanced)
Link | rowid | id | continent ▼ | region | country | capital | fips | iso2 | iso3 | isonumeric | internet |
---|---|---|---|---|---|---|---|---|---|---|---|
175 | 175 | 674 | Europe | Southern Europe | San Marino | San Marino | SM | SM | SMR | 674 | SM |
182 | 182 | 703 | Europe | Central Europe | Slovakia | Bratislava | LO | SK | SVK | 703 | SK |
183 | 183 | 705 | Europe | South East Europe | Slovenia | Ljubljana | SI | SI | SVN | 705 | SI |
187 | 187 | 724 | Europe | South West Europe | Spain | Madrid | SP | ES | ESP | 724 | ES |
191 | 191 | 744 | Europe | Northern Europe | Svalbard | Longyearbyen | SV | SJ | SJM | 744 | SJ |
193 | 193 | 752 | Europe | Northern Europe | Sweden | Stockholm | SW | SE | SWE | 752 | SE |
194 | 194 | 756 | Europe | Central Europe | Switzerland | Bern | SZ | CH | CHE | 756 | CH |
210 | 210 | 804 | Europe | Eastern Europe | Ukraine | Kiev | UP | UA | UKR | 804 | UA |
212 | 212 | 826 | Europe | Western Europe | United Kingdom | London | UK | GB | GBR | 826 | UK/GB |
233 | 233 | 249 | Europe | Western Europe | France, Metropolitan | FX | FXX | 249 | FX | ||
239 | 239 | 891 | Europe | South East Europe | Yugoslavia | YU | YUG | 891 | YU | ||
234 | 234 | 260 | Indian Ocean | Southern Indian Ocean | French Southern and Antarctic Lands | FS | TF | ATF | 260 | ||
235 | 235 | 334 | Indian Ocean | Southern Indian Ocean | Heard Island and McDonald Islands | HM | HM | HMD | 334 | HM | |
4 | 4 | 16 | Oceania | Pacific | American Samoa | Pago Pago | AQ | AS | ASM | 16 | AS |
12 | 12 | 36 | Oceania | Pacific | Australia | Canberra | AS | AU | AUS | 36 | AU |
48 | 48 | 184 | Oceania | Pacific | Cook Islands | Avarua | CW | CK | COK | 184 | CK |
68 | 68 | 242 | Oceania | Pacific | Fiji | Suva | FJ | FJ | FJI | 242 | FJ |
72 | 72 | 258 | Oceania | Pacific | French Polynesia | Papeete | FP | PF | PYF | 258 | PF |
83 | 83 | 316 | Oceania | Pacific | Guam | Hagatna (Agana) | GQ | GU | GUM | 316 | GU |
105 | 105 | 296 | Oceania | Pacific | Kiribati | Tarawa | KR | KI | KIR | 296 | KI |
126 | 126 | 584 | Oceania | Pacific | Marshall Islands | Majuro | RM | MH | MHL | 584 | MH |
132 | 132 | 583 | Oceania | Pacific | Micronesia, Federated States of | Palikir | FM | FSM | 583 | FM | |
141 | 141 | 520 | Oceania | Pacific | Nauru | no official capital | NR | NR | NRU | 520 | NR |
145 | 145 | 540 | Oceania | Pacific | New Caledonia | Noumea | NC | NC | NCL | 540 | NC |
146 | 146 | 554 | Oceania | Pacific | New Zealand | Wellington | NZ | NZ | NZL | 554 | NZ |
150 | 150 | 570 | Oceania | Pacific | Niue | Alofi | NE | NU | NIU | 570 | NU |
151 | 151 | 574 | Oceania | Pacific | Norfolk Island | Kingston | NF | NF | NFK | 574 | NF |
152 | 152 | 580 | Oceania | Pacific | Northern Mariana Islands | Saipan | CQ | MP | MNP | 580 | MP |
156 | 156 | 585 | Oceania | Pacific | Palau | Koror | PS | PW | PLW | 585 | PW |
158 | 158 | 598 | Oceania | Pacific | Papua New Guinea | Port Moresby | PP | PG | PNG | 598 | PG |
162 | 162 | 612 | Oceania | Pacific | Pitcairn Islands | Adamstown | PC | PN | PCN | 612 | PN |
184 | 184 | 90 | Oceania | Pacific | Solomon Islands | Honiara | BP | SB | SLB | 90 | SB |
201 | 201 | 772 | Oceania | Pacific | Tokelau | none | TL | TK | TKL | 772 | TK |
202 | 202 | 776 | Oceania | Pacific | Tonga | Nuku'alofa | TN | TO | TON | 776 | TO |
208 | 208 | 798 | Oceania | Pacific | Tuvalu | Funafuti | TV | TV | TUV | 798 | TV |
216 | 216 | 548 | Oceania | Pacific | Vanuatu | Port-Vila | NH | VU | VUT | 548 | VU |
220 | 220 | 876 | Oceania | Pacific | Wallis and Futuna | Mata-Utu (on Ile Uvea) | WF | WF | WLF | 876 | WF |
222 | 222 | 882 | Oceania | Pacific | Western Samoa | Apia | WS | WS | WSM | 882 | WS |
238 | 238 | 581 | Oceania | North Pacific Ocean | United States Minor Outlying Islands | UM | UMI | 581 | UM |
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 );