politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by start_date
This data as json, CSV (advanced)
start_date (date) >30 ✖
- 1976-01-01 2
- 1983-01-01 2
- 1984-01-01 2
- 1992-01-01 2
- 2000-01-01 2
- 2009-04-04 2
- 2010-08-06 2
- 1974-12-13 1
- 1974-12-18 1
- 1974-12-19 1
- 1975-01-01 1
- 1975-06-20 1
- 1976-07-14 1
- 1976-12-03 1
- 1976-12-27 1
- 1977-01-01 1
- 1977-09-03 1
- 1978-01-01 1
- 1978-01-16 1
- 1978-05-29 1
- 1978-07-08 1
- 1979-01-01 1
- 1979-07-01 1
- 1980-01-01 1
- 1980-05-15 1
- 1980-05-18 1
- 1980-08-01 1
- 1981-01-01 1
- 1981-03-09 1
- 1981-05-21 1
- …
Link | rowid | id | country_id | start_date ▼ | end_date | person_id | person_id_source | party_id | data_source | description | comment |
---|---|---|---|---|---|---|---|---|---|---|---|
78 | 78 | 78 | Malta 72 | 1974-12-13 | 1976-12-27 | 17091 | Anthony Mamo | no party affiliation 1572 | |||
110 | 110 | 110 | Greece 41 | 1974-12-18 | 1975-06-19 | 17067 | Michail Stasinopoulos | Néa Đimokratía 47 | |||
2 | 2 | 2 | Ireland 37 | 1974-12-19 | 1976-10-22 | 17075 | Cearbhall Ó Dálaigh | no party affiliation 30 | |||
201 | 201 | 201 | Switzerland 40 | 1975-01-01 | 1975-12-31 | 14075 | Pierre Graber | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
21 | 21 | 21 | Greece 41 | 1975-06-20 | 1980-05-15 | 17066 | Konstantinos Tsatsos | Néa Đimokratía 47 | |||
13 | 13 | 13 | Switzerland 40 | 1976-01-01 | 1976-12-31 | 11772 | Rudolf Gnägi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
146 | 146 | 146 | Iceland 56 | 1976-01-01 | 1980-08-01 | 17080 | Kristján Eldjárn | no party affiliation 134 | |||
163 | 163 | 163 | Portugal 63 | 1976-07-14 | 1981-03-09 | 17096 | António Ramalho Eanes | no party affiliation 729 | |||
209 | 209 | 209 | Ireland 37 | 1976-12-03 | 1983-01-01 | 16552 | Patrick Hillery | Fianna Fáil 280 | |||
30 | 30 | 30 | Malta 72 | 1976-12-27 | 1981-12-27 | 5990 | Anton Buttigieg | Partit Laburista 1003 | |||
89 | 89 | 89 | Switzerland 40 | 1977-01-01 | 1977-12-31 | 15161 | Kurt Furgler | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
102 | 102 | 102 | Cyprus 51 | 1977-09-03 | 1983-02-13 | 16017 | Spyros Kyprianou | Dimokratikó Kómma 851 | |||
125 | 125 | 125 | Switzerland 40 | 1978-01-01 | 1978-12-31 | 1691 | Willy Ritschard | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
220 | 220 | 220 | Finland 67 | 1978-01-16 | 1982-01-27 | 14223 | Urho Kekkonen | Keskusta 94 | |||
277 | 277 | 278 | Israel 34 | 1978-05-29 | 1983-05-05 | 17128 | Yitzhak Navon | HaMa'arakh | HaAvoda 244 | |||
233 | 233 | 233 | Italy 26 | 1978-07-08 | 1985-06-23 | 17085 | Sandro Pertini | Partito Socialista Italiano 1475 | |||
111 | 111 | 111 | Switzerland 40 | 1979-01-01 | 1979-12-31 | 15713 | Hans Hürlimann | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
85 | 85 | 85 | Germany 54 | 1979-07-01 | 1984-06-30 | 2172 | Karl Carstens | Christlich Demokratische Union 808 | |||
141 | 141 | 141 | Switzerland 40 | 1980-01-01 | 1980-12-31 | 6836 | Georges-André Chevallaz | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
73 | 73 | 73 | Greece 41 | 1980-05-15 | 1985-03-10 | 2324 | Konstantinos Karamanlis | Néa Đimokratía 47 | |||
8 | 8 | 8 | Austria 59 | 1980-05-18 | 1986-07-08 | 4021 | Rudolf Kirchschläger | Parteilose 272 | |||
46 | 46 | 46 | Iceland 56 | 1980-08-01 | 1984-01-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
152 | 152 | 152 | Switzerland 40 | 1981-01-01 | 1981-12-31 | 15161 | Kurt Furgler | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
164 | 164 | 164 | Portugal 63 | 1981-03-09 | 1986-03-09 | 17096 | António Ramalho Eanes | Partido Renovador Democrático 341 | |||
205 | 205 | 205 | France 43 | 1981-05-21 | 1988-05-08 | 13638 | François Mitterrand | Parti socialiste 1539 | |||
54 | 54 | 54 | Switzerland 40 | 1982-01-01 | 1982-12-31 | 61 | Fritz Honegger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
223 | 223 | 223 | Finland 67 | 1982-01-27 | 1988-02-01 | 12508 | Mauno Koivisto | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
52 | 52 | 52 | Malta 72 | 1982-02-15 | 1987-02-15 | 15060 | Agatha Barbara | Partit Laburista 1003 | |||
263 | 263 | 264 | Turkey 20 | 1982-11-09 | 1989-11-09 | 17134 | Kenan Evren | bağımsız 1399 | |||
124 | 124 | 124 | Switzerland 40 | 1983-01-01 | 1983-12-31 | 677 | Pierre Aubert | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
210 | 210 | 210 | Ireland 37 | 1983-01-01 | 1990-12-02 | 16552 | Patrick Hillery | Fianna Fáil 280 | |||
103 | 103 | 103 | Cyprus 51 | 1983-02-13 | 1988-02-28 | 16017 | Spyros Kyprianou | Dimokratikó Kómma 851 | |||
278 | 278 | 279 | Israel 34 | 1983-05-05 | 1988-02-23 | 17129 | Chaim Herzog | HaMa'arakh | HaAvoda 244 | |||
15 | 15 | 15 | Switzerland 40 | 1984-01-01 | 1984-12-31 | 11125 | Leon Schlumpf | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
47 | 47 | 47 | Iceland 56 | 1984-01-01 | 1988-06-25 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
37 | 37 | 37 | Germany 54 | 1984-07-01 | 1989-05-23 | 6753 | Richard von Weizsäcker | Christlich Demokratische Union 808 | |||
64 | 64 | 64 | Switzerland 40 | 1985-01-01 | 1985-12-31 | 15161 | Kurt Furgler | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
36 | 36 | 36 | Greece 41 | 1985-03-30 | 1990-05-04 | 17064 | Christos Sartzetakis | no party affiliation 1358 | |||
155 | 155 | 155 | Italy 26 | 1985-06-23 | 1992-04-28 | 11964 | Francesco Cossiga | Democrazia Cristiana 1633 | |||
211 | 211 | 211 | Switzerland 40 | 1986-01-01 | 1986-12-31 | 7150 | Alphons Egli | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
87 | 87 | 87 | Portugal 63 | 1986-03-09 | 1991-03-09 | 11089 | Mário Soares | Partido Socialista 725 | |||
99 | 99 | 99 | Austria 59 | 1986-07-08 | 1992-07-08 | 1495 | Kurt Waldheim | Österreichische Volkspartei 1013 | |||
182 | 182 | 182 | Switzerland 40 | 1987-01-01 | 1987-12-31 | 677 | Pierre Aubert | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
177 | 177 | 177 | Switzerland 40 | 1988-01-01 | 1988-12-31 | 7645 | Otto Stich | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
224 | 224 | 224 | Finland 67 | 1988-02-01 | 1994-03-01 | 12508 | Mauno Koivisto | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
279 | 279 | 280 | Israel 34 | 1988-02-23 | 1993-05-13 | 17129 | Chaim Herzog | HaMa'arakh | HaAvoda 244 | |||
134 | 134 | 134 | Cyprus 51 | 1988-02-28 | 1993-02-28 | 17054 | George Vasiliou | Enomeni Dimokrates 1523 | |||
206 | 206 | 206 | France 43 | 1988-05-08 | 1995-05-17 | 13638 | François Mitterrand | Parti socialiste 1539 | |||
48 | 48 | 48 | Iceland 56 | 1988-06-25 | 1992-01-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
132 | 132 | 132 | Switzerland 40 | 1989-01-01 | 1989-12-31 | 6502 | Jean-Pascal Delamuraz | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
120 | 120 | 120 | Malta 72 | 1989-04-04 | 1994-04-04 | 8235 | Vincent Tabone | Partit Nazzjonalista 984 | |||
38 | 38 | 38 | Germany 54 | 1989-05-23 | 1994-06-30 | 6753 | Richard von Weizsäcker | Christlich Demokratische Union 808 | |||
264 | 264 | 265 | Turkey 20 | 1989-11-09 | 1993-04-17 | 17135 | Turgut Özal | Anavatan Partisi 1334 | |||
121 | 121 | 121 | Romania 23 | 1989-12-26 | 1990-05-20 | 17099 | Ion Iliescu | Partidul Democrat 419 | |||
3 | 3 | 3 | Poland 74 | 1989-12-31 | 1990-12-22 | 17095 | Wojciech Jaruzelski | Polska Zjednoczone Partia Robotnicza 1077 | |||
45 | 45 | 45 | Switzerland 40 | 1990-01-01 | 1990-12-31 | 10927 | Arnold Koller | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
92 | 92 | 92 | Lithuania 15 | 1990-03-11 | 1992-11-25 | 2628 | Vytautas Landsbergis | Tėvynės sąjunga 1045 | |||
81 | 81 | 81 | Greece 41 | 1990-05-04 | 1995-03-10 | 2324 | Konstantinos Karamanlis | Néa Đimokratía 47 | |||
66 | 66 | 66 | Slovenia 60 | 1990-05-10 | 1992-12-06 | 17104 | Milan Kučan | no party affiliation 1370 | |||
122 | 122 | 122 | Romania 23 | 1990-05-20 | 1992-10-11 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
243 | 243 | 243 | Bulgaria 10 | 1990-08-01 | 1997-01-22 | 17033 | Zhelyu Zhelev | Suyuz na Demokratichnite Sili 423 | |||
170 | 170 | 170 | Hungary 39 | 1990-08-04 | 1995-08-04 | 17070 | Árpád Göncz | Szabad Demokraták Szövetsége 1426 | |||
127 | 127 | 127 | Ireland 37 | 1990-12-03 | 1997-09-12 | 17077 | Mary Robinson | Labour Party 318 | |||
14 | 14 | 14 | Poland 74 | 1990-12-22 | 1995-12-22 | 17094 | Lech Wałęsa | Solidarność 108 | |||
222 | 222 | 222 | Switzerland 40 | 1991-01-01 | 1991-12-31 | 14732 | Flavio Cotti | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
88 | 88 | 88 | Portugal 63 | 1991-03-09 | 1996-03-09 | 11089 | Mário Soares | Partido Socialista 725 | |||
49 | 49 | 49 | Iceland 56 | 1992-01-01 | 1996-08-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
188 | 188 | 188 | Switzerland 40 | 1992-01-01 | 1992-12-31 | 13678 | René Felber | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
19 | 19 | 19 | Italy 26 | 1992-05-25 | 1999-05-13 | 9761 | Oscar Luigi Scalfaro | Democrazia Cristiana 1633 | |||
79 | 79 | 79 | Austria 59 | 1992-07-08 | 1998-04-19 | 17029 | Thomas Klestil | Österreichische Volkspartei 1013 | |||
83 | 83 | 83 | Estonia 75 | 1992-10-06 | 1996-09-20 | 13837 | Lennart Meri | Rahvuslik Koonderakond "Isamaa" 243 | |||
123 | 123 | 123 | Romania 23 | 1992-10-11 | 1996-11-29 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
251 | 251 | 251 | Lithuania 15 | 1992-11-25 | 1998-02-25 | 1634 | Algirdas Brazauskas | Lietuvos demokratinė darbo partija 519 | |||
67 | 67 | 67 | Slovenia 60 | 1992-12-06 | 1997-12-23 | 17104 | Milan Kučan | no party affiliation 1370 | |||
109 | 109 | 109 | Switzerland 40 | 1993-01-01 | 1993-12-31 | 2775 | Adolf Ogi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
71 | 71 | 71 | Czech Republic 68 | 1993-02-02 | 1998-01-20 | 17057 | Václav Havel | no party affiliation 1567 | |||
236 | 236 | 236 | Cyprus 51 | 1993-02-28 | 1998-02-15 | 17055 | Glafcos Clerides | Dimokratikó Kómma 851 | |||
252 | 252 | 252 | Slovakia 1 | 1993-03-02 | 1998-03-02 | 16261 | Michal Kováč | Hnutie za demokratické Slovensko 1142 | |||
280 | 280 | 281 | Israel 34 | 1993-05-13 | 1998-03-04 | 17130 | Ezer Weizman | HaMa'arakh | HaAvoda 244 | |||
265 | 265 | 266 | Turkey 20 | 1993-05-16 | 2000-05-16 | 17136 | Süleyman Demirel | Doğru Yol Partisi 1141 | |||
184 | 184 | 184 | Latvia 55 | 1993-07-07 | 1996-06-18 | 17088 | Guntis Ulmanis | Latvijas Zemnieku Savienība 1368 | |||
199 | 199 | 199 | Switzerland 40 | 1994-01-01 | 1994-12-31 | 7645 | Otto Stich | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
133 | 133 | 133 | Finland 67 | 1994-03-01 | 2000-03-01 | 17063 | Martti Ahtisaari | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
108 | 108 | 108 | Malta 72 | 1994-04-04 | 1999-04-04 | 4901 | Ugo Mifsud Bonnici | Partit Nazzjonalista 984 | |||
208 | 208 | 208 | Germany 54 | 1994-07-01 | 1999-06-30 | 17061 | Roman Herzog | Christlich Demokratische Union 808 | |||
18 | 18 | 18 | Switzerland 40 | 1995-01-01 | 1995-12-31 | 14593 | Kaspar Villiger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
161 | 161 | 161 | Greece 41 | 1995-03-10 | 2000-02-08 | 17065 | Konstantinos Stephanopoulos | no party affiliation 1358 | |||
249 | 249 | 249 | France 43 | 1995-05-17 | 2002-05-05 | 1103 | Jacques Chirac | Rassemblement pour la république 138 | |||
171 | 171 | 171 | Hungary 39 | 1995-08-04 | 2000-08-04 | 17070 | Árpád Göncz | Szabad Demokraták Szövetsége 1426 | |||
69 | 69 | 69 | Poland 74 | 1995-12-23 | 2000-10-08 | 17092 | Aleksander Kwaśniewski | Sojusz Lewicy Demokratycznej 629 | |||
41 | 41 | 41 | Switzerland 40 | 1996-01-01 | 1996-12-31 | 6502 | Jean-Pascal Delamuraz | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
56 | 56 | 56 | Portugal 63 | 1996-03-09 | 2001-03-09 | 17097 | Jorge Sampaio | Partido Socialista 725 | |||
185 | 185 | 185 | Latvia 55 | 1996-06-18 | 1999-07-08 | 17088 | Guntis Ulmanis | Latvijas Zemnieku Savienība 1368 | |||
25 | 25 | 25 | Iceland 56 | 1996-08-01 | 2000-01-01 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
84 | 84 | 84 | Estonia 75 | 1996-09-20 | 2001-10-08 | 13837 | Lennart Meri | Rahvuslik Koonderakond "Isamaa" 243 | |||
34 | 34 | 34 | Romania 23 | 1996-11-29 | 2000-12-20 | 17098 | Emil Constantinescu | Convenţia Democrată Română 356 | |||
178 | 178 | 178 | Switzerland 40 | 1997-01-01 | 1997-12-31 | 10927 | Arnold Koller | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
165 | 165 | 165 | Bulgaria 10 | 1997-01-22 | 2002-01-22 | 17031 | Petar Stoyanov | Suyuz na Demokratichnite Sili 423 | |||
94 | 94 | 94 | Ireland 37 | 1997-11-11 | 2004-10-01 | 17076 | Mary McAleese | Fianna Fáil 280 | |||
68 | 68 | 68 | Slovenia 60 | 1997-12-23 | 2002-12-22 | 17104 | Milan Kučan | no party affiliation 1370 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE politician_president("id", "country_id", "start_date", "end_date", "person_id", "person_id_source", "party_id", "data_source", "description", "comment", FOREIGN KEY([country_id]) REFERENCES [country]([id]), FOREIGN KEY([party_id]) REFERENCES [party]([id]) );