external_country_iso_fts
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows sorted by country
This data as json, CSV (advanced)
Link | rowid | country ▼ | capital | external_country_iso_fts | rank |
---|---|---|---|---|---|
1 | 1 | Afghanistan | Kabul | 401 | |
2 | 2 | Albania | Tirana | 401 | |
3 | 3 | Algeria | Algiers | 401 | |
4 | 4 | American Samoa | Pago Pago | 401 | |
5 | 5 | Andorra | Andorra la Vella | 401 | |
6 | 6 | Angola | Luanda | 401 | |
7 | 7 | Anguilla | The Valley | 401 | |
229 | 229 | Antarctica | 401 | ||
8 | 8 | Antigua and Barbuda | Saint John's | 401 | |
9 | 9 | Argentina | Buenos Aires | 401 | |
10 | 10 | Armenia | Yerevan | 401 | |
11 | 11 | Aruba | Oranjestad | 401 | |
12 | 12 | Australia | Canberra | 401 | |
13 | 13 | Austria | Vienna | 401 | |
14 | 14 | Azerbaijan | Baku (Baki) | 401 | |
15 | 15 | Bahamas, The | Nassau | 401 | |
16 | 16 | Bahrain | Manama | 401 | |
17 | 17 | Bangladesh | Dhaka | 401 | |
18 | 18 | Barbados | Bridgetown | 401 | |
19 | 19 | Belarus | Minsk | 401 | |
20 | 20 | Belgium | Brussels | 401 | |
21 | 21 | Belize | Belmopan | 401 | |
22 | 22 | Benin | Porto-Novo | 401 | |
23 | 23 | Bermuda | Hamilton | 401 | |
24 | 24 | Bhutan | Thimphu | 401 | |
25 | 25 | Bolivia | La Paz / Sucre | 401 | |
26 | 26 | Bosnia and Herzegovina | Sarajevo | 401 | |
27 | 27 | Botswana | Gaborone | 401 | |
230 | 230 | Bouvet Island | 401 | ||
28 | 28 | Brazil | Brasilia | 401 | |
231 | 231 | British Indian Ocean Territory | 401 | ||
29 | 29 | British Virgin Islands | Road Town | 401 | |
30 | 30 | Brunei | Bandar Seri Begawan | 401 | |
31 | 31 | Bulgaria | Sofia | 401 | |
32 | 32 | Burkina Faso | Ouagadougou | 401 | |
33 | 33 | Burundi | Bujumbura | 401 | |
34 | 34 | Cambodia | Phnom Penh | 401 | |
35 | 35 | Cameroon | Yaounde | 401 | |
36 | 36 | Canada | Ottawa | 401 | |
37 | 37 | Cape Verde | Praia | 401 | |
38 | 38 | Cayman Islands | George Town | 401 | |
39 | 39 | Central African Republic | Bangui | 401 | |
40 | 40 | Chad | N'Djamena | 401 | |
41 | 41 | Chile | Santiago | 401 | |
42 | 42 | China | Beijing | 401 | |
43 | 43 | Christmas Island | The Settlement | 401 | |
44 | 44 | Cocos (Keeling) Islands | West Island | 401 | |
45 | 45 | Colombia | Bogota | 401 | |
46 | 46 | Comoros | Moroni | 401 | |
47 | 47 | Congo, Republic of the | Brazzaville | 401 | |
48 | 48 | Cook Islands | Avarua | 401 | |
49 | 49 | Costa Rica | San Jose | 401 | |
50 | 50 | Cote d'Ivoire | Yamoussoukro | 401 | |
51 | 51 | Croatia | Zagreb | 401 | |
52 | 52 | Cuba | Havana | 401 | |
53 | 53 | Cyprus | Nicosia | 401 | |
54 | 54 | Czech Republic | Prague | 401 | |
55 | 55 | Denmark | Copenhagen | 401 | |
56 | 56 | Djibouti | Djibouti | 401 | |
57 | 57 | Dominica | Roseau | 401 | |
58 | 58 | Dominican Republic | Santo Domingo | 401 | |
232 | 232 | East Timor | 401 | ||
59 | 59 | Ecuador | Quito | 401 | |
60 | 60 | Egypt | Cairo | 401 | |
61 | 61 | El Salvador | San Salvador | 401 | |
62 | 62 | Equatorial Guinea | Malabo | 401 | |
63 | 63 | Eritrea | Asmara | 401 | |
64 | 64 | Estonia | Tallinn | 401 | |
65 | 65 | Ethiopia | Addis Ababa | 401 | |
66 | 66 | Falkland Islands (Islas Malvinas) | Stanley | 401 | |
67 | 67 | Faroe Islands | Torshavn | 401 | |
68 | 68 | Fiji | Suva | 401 | |
69 | 69 | Finland | Helsinki | 401 | |
70 | 70 | France | Paris | 401 | |
233 | 233 | France, Metropolitan | 401 | ||
71 | 71 | French Guiana | Cayenne | 401 | |
72 | 72 | French Polynesia | Papeete | 401 | |
234 | 234 | French Southern and Antarctic Lands | 401 | ||
73 | 73 | Gabon | Libreville | 401 | |
74 | 74 | Gambia, The | Banjul | 401 | |
75 | 75 | Georgia | T'bilisi | 401 | |
76 | 76 | Germany | Berlin | 401 | |
77 | 77 | Ghana | Accra | 401 | |
78 | 78 | Gibraltar | Gibraltar | 401 | |
79 | 79 | Greece | Athens | 401 | |
80 | 80 | Greenland | Nuuk (Godthab) | 401 | |
81 | 81 | Grenada | Saint George's | 401 | |
82 | 82 | Guadeloupe | Basse-Terre | 401 | |
83 | 83 | Guam | Hagatna (Agana) | 401 | |
84 | 84 | Guatemala | Guatemala | 401 | |
85 | 85 | Guinea | Conakry | 401 | |
86 | 86 | Guinea-Bissau | Bissau | 401 | |
87 | 87 | Guyana | Georgetown | 401 | |
88 | 88 | Haiti | Port-au-Prince | 401 | |
235 | 235 | Heard Island and McDonald Islands | 401 | ||
89 | 89 | Holy See (Vatican City) | Vatican City | 401 | |
90 | 90 | Honduras | Tegucigalpa | 401 | |
227 | 227 | Hong Kong (China) | Victoria | 401 | |
91 | 91 | Hungary | Budapest | 401 | |
92 | 92 | Iceland | Reykjavik | 401 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [external_country_iso_fts] USING FTS5 ( [country], [capital], content=[external_country_iso] );