external_country_iso_fts

Data source: ParlGov · About: simonw/parlgov-datasette

239 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ country capital external_country_iso_fts rank
1 1 Afghanistan Kabul 92  
2 2 Albania Tirana 92  
3 3 Algeria Algiers 92  
4 4 American Samoa Pago Pago 92  
5 5 Andorra Andorra la Vella 92  
6 6 Angola Luanda 92  
7 7 Anguilla The Valley 92  
8 8 Antigua and Barbuda Saint John's 92  
9 9 Argentina Buenos Aires 92  
10 10 Armenia Yerevan 92  
11 11 Aruba Oranjestad 92  
12 12 Australia Canberra 92  
13 13 Austria Vienna 92  
14 14 Azerbaijan Baku (Baki) 92  
15 15 Bahamas, The Nassau 92  
16 16 Bahrain Manama 92  
17 17 Bangladesh Dhaka 92  
18 18 Barbados Bridgetown 92  
19 19 Belarus Minsk 92  
20 20 Belgium Brussels 92  
21 21 Belize Belmopan 92  
22 22 Benin Porto-Novo 92  
23 23 Bermuda Hamilton 92  
24 24 Bhutan Thimphu 92  
25 25 Bolivia La Paz / Sucre 92  
26 26 Bosnia and Herzegovina Sarajevo 92  
27 27 Botswana Gaborone 92  
28 28 Brazil Brasilia 92  
29 29 British Virgin Islands Road Town 92  
30 30 Brunei Bandar Seri Begawan 92  
31 31 Bulgaria Sofia 92  
32 32 Burkina Faso Ouagadougou 92  
33 33 Burundi Bujumbura 92  
34 34 Cambodia Phnom Penh 92  
35 35 Cameroon Yaounde 92  
36 36 Canada Ottawa 92  
37 37 Cape Verde Praia 92  
38 38 Cayman Islands George Town 92  
39 39 Central African Republic Bangui 92  
40 40 Chad N'Djamena 92  
41 41 Chile Santiago 92  
42 42 China Beijing 92  
43 43 Christmas Island The Settlement 92  
44 44 Cocos (Keeling) Islands West Island 92  
45 45 Colombia Bogota 92  
46 46 Comoros Moroni 92  
47 47 Congo, Republic of the Brazzaville 92  
48 48 Cook Islands Avarua 92  
49 49 Costa Rica San Jose 92  
50 50 Cote d'Ivoire Yamoussoukro 92  
51 51 Croatia Zagreb 92  
52 52 Cuba Havana 92  
53 53 Cyprus Nicosia 92  
54 54 Czech Republic Prague 92  
55 55 Denmark Copenhagen 92  
56 56 Djibouti Djibouti 92  
57 57 Dominica Roseau 92  
58 58 Dominican Republic Santo Domingo 92  
59 59 Ecuador Quito 92  
60 60 Egypt Cairo 92  
61 61 El Salvador San Salvador 92  
62 62 Equatorial Guinea Malabo 92  
63 63 Eritrea Asmara 92  
64 64 Estonia Tallinn 92  
65 65 Ethiopia Addis Ababa 92  
66 66 Falkland Islands (Islas Malvinas) Stanley 92  
67 67 Faroe Islands Torshavn 92  
68 68 Fiji Suva 92  
69 69 Finland Helsinki 92  
70 70 France Paris 92  
71 71 French Guiana Cayenne 92  
72 72 French Polynesia Papeete 92  
73 73 Gabon Libreville 92  
74 74 Gambia, The Banjul 92  
75 75 Georgia T'bilisi 92  
76 76 Germany Berlin 92  
77 77 Ghana Accra 92  
78 78 Gibraltar Gibraltar 92  
79 79 Greece Athens 92  
80 80 Greenland Nuuk (Godthab) 92  
81 81 Grenada Saint George's 92  
82 82 Guadeloupe Basse-Terre 92  
83 83 Guam Hagatna (Agana) 92  
84 84 Guatemala Guatemala 92  
85 85 Guinea Conakry 92  
86 86 Guinea-Bissau Bissau 92  
87 87 Guyana Georgetown 92  
88 88 Haiti Port-au-Prince 92  
89 89 Holy See (Vatican City) Vatican City 92  
90 90 Honduras Tegucigalpa 92  
91 91 Hungary Budapest 92  
92 92 Iceland Reykjavik 92  
93 93 India New Delhi 92  
94 94 Indonesia Jakarta 92  
95 95 Iran Tehran 92  
96 96 Iraq Baghdad 92  
97 97 Ireland Dublin 92  
98 98 Israel Jerusalem 92  
99 99 Italy Rome 92  
100 100 Jamaica Kingston 92  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIRTUAL TABLE [external_country_iso_fts] USING FTS5 (
    [country], [capital],
    content=[external_country_iso]
);