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