politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by end_date descending
This data as json, CSV (advanced)
Link | rowid | id | country_id | start_date | end_date ▲ | person_id | person_id_source | party_id | data_source | description | comment |
---|---|---|---|---|---|---|---|---|---|---|---|
204 | 204 | 204 | Switzerland 40 | 2004-01-01 | 2004-12-31 | 9888 | Joseph Deiss | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
16 | 16 | 16 | Romania 23 | 2000-12-20 | 2004-12-20 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
94 | 94 | 94 | Ireland 37 | 1997-11-11 | 2004-10-01 | 17076 | Mary McAleese | Fianna Fáil 280 | |||
80 | 80 | 80 | Austria 59 | 1998-04-19 | 2004-07-06 | 17029 | Thomas Klestil | Österreichische Volkspartei 1013 | |||
212 | 212 | 212 | Germany 54 | 1999-07-01 | 2004-06-30 | 17060 | Johannes Rau | Sozialdemokratische Partei Deutschlands 558 | |||
26 | 26 | 26 | Iceland 56 | 2000-01-01 | 2004-06-26 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
176 | 176 | 176 | Slovakia 1 | 1999-06-15 | 2004-06-15 | 17102 | Rudolf Schuster | Strana občianskeho porozumenia 1016 | |||
221 | 221 | 221 | Lithuania 15 | 2003-02-26 | 2004-04-06 | 13551 | Rolandas Paksas | Lietuvos demokratinė darbo partija 519 | |||
241 | 241 | 241 | Malta 72 | 1999-04-04 | 2004-04-04 | 9784 | Guido de Marco | Partit Nazzjonalista 984 | |||
98 | 98 | 98 | Switzerland 40 | 2003-01-01 | 2003-12-31 | 11791 | Pascal Couchepin | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
31 | 31 | 31 | Latvia 55 | 1999-07-08 | 2003-06-20 | 17089 | Vaira Vīķe-Freiberga | no party affiliation 288 | |||
237 | 237 | 237 | Cyprus 51 | 1998-02-15 | 2003-02-28 | 17055 | Glafcos Clerides | Dimokratikó Kómma 851 | |||
192 | 192 | 192 | Lithuania 15 | 1998-02-26 | 2003-02-26 | 17087 | Valdas Adamkus | no party affiliation 58 | |||
72 | 72 | 72 | Czech Republic 68 | 1998-01-20 | 2003-02-02 | 17057 | Václav Havel | no party affiliation 1567 | |||
167 | 167 | 167 | Switzerland 40 | 2002-01-01 | 2002-12-31 | 14593 | Kaspar Villiger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
68 | 68 | 68 | Slovenia 60 | 1997-12-23 | 2002-12-22 | 17104 | Milan Kučan | no party affiliation 1370 | |||
249 | 249 | 249 | France 43 | 1995-05-17 | 2002-05-05 | 1103 | Jacques Chirac | Rassemblement pour la république 138 | |||
165 | 165 | 165 | Bulgaria 10 | 1997-01-22 | 2002-01-22 | 17031 | Petar Stoyanov | Suyuz na Demokratichnite Sili 423 | |||
191 | 191 | 191 | Switzerland 40 | 2001-01-01 | 2001-12-31 | 7580 | Moritz Leuenberger | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
84 | 84 | 84 | Estonia 75 | 1996-09-20 | 2001-10-08 | 13837 | Lennart Meri | Rahvuslik Koonderakond "Isamaa" 243 | |||
56 | 56 | 56 | Portugal 63 | 1996-03-09 | 2001-03-09 | 17097 | Jorge Sampaio | Partido Socialista 725 | |||
200 | 200 | 200 | Switzerland 40 | 2000-01-01 | 2000-12-31 | 2775 | Adolf Ogi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
34 | 34 | 34 | Romania 23 | 1996-11-29 | 2000-12-20 | 17098 | Emil Constantinescu | Convenţia Democrată Română 356 | |||
69 | 69 | 69 | Poland 74 | 1995-12-23 | 2000-10-08 | 17092 | Aleksander Kwaśniewski | Sojusz Lewicy Demokratycznej 629 | |||
171 | 171 | 171 | Hungary 39 | 1995-08-04 | 2000-08-04 | 17070 | Árpád Göncz | Szabad Demokraták Szövetsége 1426 | |||
281 | 281 | 282 | Israel 34 | 1998-04-03 | 2000-07-13 | 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 | |||
133 | 133 | 133 | Finland 67 | 1994-03-01 | 2000-03-01 | 17063 | Martti Ahtisaari | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
161 | 161 | 161 | Greece 41 | 1995-03-10 | 2000-02-08 | 17065 | Konstantinos Stephanopoulos | no party affiliation 1358 | |||
25 | 25 | 25 | Iceland 56 | 1996-08-01 | 2000-01-01 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
228 | 228 | 228 | Switzerland 40 | 1999-01-01 | 1999-12-31 | 14596 | Ruth Dreifuss | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
185 | 185 | 185 | Latvia 55 | 1996-06-18 | 1999-07-08 | 17088 | Guntis Ulmanis | Latvijas Zemnieku Savienība 1368 | |||
208 | 208 | 208 | Germany 54 | 1994-07-01 | 1999-06-30 | 17061 | Roman Herzog | Christlich Demokratische Union 808 | |||
19 | 19 | 19 | Italy 26 | 1992-05-25 | 1999-05-13 | 9761 | Oscar Luigi Scalfaro | Democrazia Cristiana 1633 | |||
108 | 108 | 108 | Malta 72 | 1994-04-04 | 1999-04-04 | 4901 | Ugo Mifsud Bonnici | Partit Nazzjonalista 984 | |||
116 | 116 | 116 | Switzerland 40 | 1998-01-01 | 1998-12-31 | 14732 | Flavio Cotti | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
79 | 79 | 79 | Austria 59 | 1992-07-08 | 1998-04-19 | 17029 | Thomas Klestil | Österreichische Volkspartei 1013 | |||
280 | 280 | 281 | Israel 34 | 1993-05-13 | 1998-03-04 | 17130 | Ezer Weizman | HaMa'arakh | HaAvoda 244 | |||
252 | 252 | 252 | Slovakia 1 | 1993-03-02 | 1998-03-02 | 16261 | Michal Kováč | Hnutie za demokratické Slovensko 1142 | |||
251 | 251 | 251 | Lithuania 15 | 1992-11-25 | 1998-02-25 | 1634 | Algirdas Brazauskas | Lietuvos demokratinė darbo partija 519 | |||
236 | 236 | 236 | Cyprus 51 | 1993-02-28 | 1998-02-15 | 17055 | Glafcos Clerides | Dimokratikó Kómma 851 | |||
71 | 71 | 71 | Czech Republic 68 | 1993-02-02 | 1998-01-20 | 17057 | Václav Havel | no party affiliation 1567 | |||
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 | |||
67 | 67 | 67 | Slovenia 60 | 1992-12-06 | 1997-12-23 | 17104 | Milan Kučan | no party affiliation 1370 | |||
127 | 127 | 127 | Ireland 37 | 1990-12-03 | 1997-09-12 | 17077 | Mary Robinson | Labour Party 318 | |||
243 | 243 | 243 | Bulgaria 10 | 1990-08-01 | 1997-01-22 | 17033 | Zhelyu Zhelev | Suyuz na Demokratichnite Sili 423 | |||
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 | |||
123 | 123 | 123 | Romania 23 | 1992-10-11 | 1996-11-29 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
83 | 83 | 83 | Estonia 75 | 1992-10-06 | 1996-09-20 | 13837 | Lennart Meri | Rahvuslik Koonderakond "Isamaa" 243 | |||
49 | 49 | 49 | Iceland 56 | 1992-01-01 | 1996-08-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
184 | 184 | 184 | Latvia 55 | 1993-07-07 | 1996-06-18 | 17088 | Guntis Ulmanis | Latvijas Zemnieku Savienība 1368 | |||
88 | 88 | 88 | Portugal 63 | 1991-03-09 | 1996-03-09 | 11089 | Mário Soares | Partido Socialista 725 | |||
18 | 18 | 18 | Switzerland 40 | 1995-01-01 | 1995-12-31 | 14593 | Kaspar Villiger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
14 | 14 | 14 | Poland 74 | 1990-12-22 | 1995-12-22 | 17094 | Lech Wałęsa | Solidarność 108 | |||
170 | 170 | 170 | Hungary 39 | 1990-08-04 | 1995-08-04 | 17070 | Árpád Göncz | Szabad Demokraták Szövetsége 1426 | |||
206 | 206 | 206 | France 43 | 1988-05-08 | 1995-05-17 | 13638 | François Mitterrand | Parti socialiste 1539 | |||
81 | 81 | 81 | Greece 41 | 1990-05-04 | 1995-03-10 | 2324 | Konstantinos Karamanlis | Néa Đimokratía 47 | |||
199 | 199 | 199 | Switzerland 40 | 1994-01-01 | 1994-12-31 | 7645 | Otto Stich | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
38 | 38 | 38 | Germany 54 | 1989-05-23 | 1994-06-30 | 6753 | Richard von Weizsäcker | Christlich Demokratische Union 808 | |||
120 | 120 | 120 | Malta 72 | 1989-04-04 | 1994-04-04 | 8235 | Vincent Tabone | Partit Nazzjonalista 984 | |||
224 | 224 | 224 | Finland 67 | 1988-02-01 | 1994-03-01 | 12508 | Mauno Koivisto | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
109 | 109 | 109 | Switzerland 40 | 1993-01-01 | 1993-12-31 | 2775 | Adolf Ogi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
279 | 279 | 280 | Israel 34 | 1988-02-23 | 1993-05-13 | 17129 | Chaim Herzog | HaMa'arakh | HaAvoda 244 | |||
264 | 264 | 265 | Turkey 20 | 1989-11-09 | 1993-04-17 | 17135 | Turgut Özal | Anavatan Partisi 1334 | |||
134 | 134 | 134 | Cyprus 51 | 1988-02-28 | 1993-02-28 | 17054 | George Vasiliou | Enomeni Dimokrates 1523 | |||
188 | 188 | 188 | Switzerland 40 | 1992-01-01 | 1992-12-31 | 13678 | René Felber | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
66 | 66 | 66 | Slovenia 60 | 1990-05-10 | 1992-12-06 | 17104 | Milan Kučan | no party affiliation 1370 | |||
92 | 92 | 92 | Lithuania 15 | 1990-03-11 | 1992-11-25 | 2628 | Vytautas Landsbergis | Tėvynės sąjunga 1045 | |||
122 | 122 | 122 | Romania 23 | 1990-05-20 | 1992-10-11 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
99 | 99 | 99 | Austria 59 | 1986-07-08 | 1992-07-08 | 1495 | Kurt Waldheim | Österreichische Volkspartei 1013 | |||
155 | 155 | 155 | Italy 26 | 1985-06-23 | 1992-04-28 | 11964 | Francesco Cossiga | Democrazia Cristiana 1633 | |||
48 | 48 | 48 | Iceland 56 | 1988-06-25 | 1992-01-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
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 | |||
87 | 87 | 87 | Portugal 63 | 1986-03-09 | 1991-03-09 | 11089 | Mário Soares | Partido Socialista 725 | |||
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 | |||
3 | 3 | 3 | Poland 74 | 1989-12-31 | 1990-12-22 | 17095 | Wojciech Jaruzelski | Polska Zjednoczone Partia Robotnicza 1077 | |||
210 | 210 | 210 | Ireland 37 | 1983-01-01 | 1990-12-02 | 16552 | Patrick Hillery | Fianna Fáil 280 | |||
121 | 121 | 121 | Romania 23 | 1989-12-26 | 1990-05-20 | 17099 | Ion Iliescu | Partidul Democrat 419 | |||
36 | 36 | 36 | Greece 41 | 1985-03-30 | 1990-05-04 | 17064 | Christos Sartzetakis | no party affiliation 1358 | |||
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 | |||
263 | 263 | 264 | Turkey 20 | 1982-11-09 | 1989-11-09 | 17134 | Kenan Evren | bağımsız 1399 | |||
37 | 37 | 37 | Germany 54 | 1984-07-01 | 1989-05-23 | 6753 | Richard von Weizsäcker | Christlich Demokratische Union 808 | |||
177 | 177 | 177 | Switzerland 40 | 1988-01-01 | 1988-12-31 | 7645 | Otto Stich | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
47 | 47 | 47 | Iceland 56 | 1984-01-01 | 1988-06-25 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
205 | 205 | 205 | France 43 | 1981-05-21 | 1988-05-08 | 13638 | François Mitterrand | Parti socialiste 1539 | |||
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 | |||
223 | 223 | 223 | Finland 67 | 1982-01-27 | 1988-02-01 | 12508 | Mauno Koivisto | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
182 | 182 | 182 | Switzerland 40 | 1987-01-01 | 1987-12-31 | 677 | Pierre Aubert | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
52 | 52 | 52 | Malta 72 | 1982-02-15 | 1987-02-15 | 15060 | Agatha Barbara | Partit Laburista 1003 | |||
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 | |||
8 | 8 | 8 | Austria 59 | 1980-05-18 | 1986-07-08 | 4021 | Rudolf Kirchschläger | Parteilose 272 | |||
164 | 164 | 164 | Portugal 63 | 1981-03-09 | 1986-03-09 | 17096 | António Ramalho Eanes | Partido Renovador Democrático 341 | |||
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 | |||
233 | 233 | 233 | Italy 26 | 1978-07-08 | 1985-06-23 | 17085 | Sandro Pertini | Partito Socialista Italiano 1475 | |||
73 | 73 | 73 | Greece 41 | 1980-05-15 | 1985-03-10 | 2324 | Konstantinos Karamanlis | Néa Đimokratía 47 | |||
15 | 15 | 15 | Switzerland 40 | 1984-01-01 | 1984-12-31 | 11125 | Leon Schlumpf | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
85 | 85 | 85 | Germany 54 | 1979-07-01 | 1984-06-30 | 2172 | Karl Carstens | Christlich Demokratische Union 808 | |||
46 | 46 | 46 | Iceland 56 | 1980-08-01 | 1984-01-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
124 | 124 | 124 | Switzerland 40 | 1983-01-01 | 1983-12-31 | 677 | Pierre Aubert | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 |
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]) );