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