politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by end_date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
251 | 251 | 251 | Lithuania 15 | 1992-11-25 | 1998-02-25 | 1634 | Algirdas Brazauskas | Lietuvos demokratinė darbo partija 519 | |||
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 | |||
79 | 79 | 79 | Austria 59 | 1992-07-08 | 1998-04-19 | 17029 | Thomas Klestil | Österreichische Volkspartei 1013 | |||
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 | |||
108 | 108 | 108 | Malta 72 | 1994-04-04 | 1999-04-04 | 4901 | Ugo Mifsud Bonnici | Partit Nazzjonalista 984 | |||
19 | 19 | 19 | Italy 26 | 1992-05-25 | 1999-05-13 | 9761 | Oscar Luigi Scalfaro | Democrazia Cristiana 1633 | |||
208 | 208 | 208 | Germany 54 | 1994-07-01 | 1999-06-30 | 17061 | Roman Herzog | Christlich Demokratische Union 808 | |||
185 | 185 | 185 | Latvia 55 | 1996-06-18 | 1999-07-08 | 17088 | Guntis Ulmanis | Latvijas Zemnieku Savienība 1368 | |||
228 | 228 | 228 | Switzerland 40 | 1999-01-01 | 1999-12-31 | 14596 | Ruth Dreifuss | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
25 | 25 | 25 | Iceland 56 | 1996-08-01 | 2000-01-01 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
161 | 161 | 161 | Greece 41 | 1995-03-10 | 2000-02-08 | 17065 | Konstantinos Stephanopoulos | no party affiliation 1358 | |||
133 | 133 | 133 | Finland 67 | 1994-03-01 | 2000-03-01 | 17063 | Martti Ahtisaari | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
265 | 265 | 266 | Turkey 20 | 1993-05-16 | 2000-05-16 | 17136 | Süleyman Demirel | Doğru Yol Partisi 1141 | |||
281 | 281 | 282 | Israel 34 | 1998-04-03 | 2000-07-13 | 17130 | Ezer Weizman | HaMa'arakh | HaAvoda 244 | |||
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 | |||
34 | 34 | 34 | Romania 23 | 1996-11-29 | 2000-12-20 | 17098 | Emil Constantinescu | Convenţia Democrată Română 356 | |||
200 | 200 | 200 | Switzerland 40 | 2000-01-01 | 2000-12-31 | 2775 | Adolf Ogi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
56 | 56 | 56 | Portugal 63 | 1996-03-09 | 2001-03-09 | 17097 | Jorge Sampaio | Partido Socialista 725 | |||
84 | 84 | 84 | Estonia 75 | 1996-09-20 | 2001-10-08 | 13837 | Lennart Meri | Rahvuslik Koonderakond "Isamaa" 243 | |||
191 | 191 | 191 | Switzerland 40 | 2001-01-01 | 2001-12-31 | 7580 | Moritz Leuenberger | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
165 | 165 | 165 | Bulgaria 10 | 1997-01-22 | 2002-01-22 | 17031 | Petar Stoyanov | Suyuz na Demokratichnite Sili 423 | |||
249 | 249 | 249 | France 43 | 1995-05-17 | 2002-05-05 | 1103 | Jacques Chirac | Rassemblement pour la république 138 | |||
68 | 68 | 68 | Slovenia 60 | 1997-12-23 | 2002-12-22 | 17104 | Milan Kučan | no party affiliation 1370 | |||
167 | 167 | 167 | Switzerland 40 | 2002-01-01 | 2002-12-31 | 14593 | Kaspar Villiger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
72 | 72 | 72 | Czech Republic 68 | 1998-01-20 | 2003-02-02 | 17057 | Václav Havel | no party affiliation 1567 | |||
192 | 192 | 192 | Lithuania 15 | 1998-02-26 | 2003-02-26 | 17087 | Valdas Adamkus | no party affiliation 58 | |||
237 | 237 | 237 | Cyprus 51 | 1998-02-15 | 2003-02-28 | 17055 | Glafcos Clerides | Dimokratikó Kómma 851 | |||
31 | 31 | 31 | Latvia 55 | 1999-07-08 | 2003-06-20 | 17089 | Vaira Vīķe-Freiberga | no party affiliation 288 | |||
98 | 98 | 98 | Switzerland 40 | 2003-01-01 | 2003-12-31 | 11791 | Pascal Couchepin | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
241 | 241 | 241 | Malta 72 | 1999-04-04 | 2004-04-04 | 9784 | Guido de Marco | Partit Nazzjonalista 984 | |||
221 | 221 | 221 | Lithuania 15 | 2003-02-26 | 2004-04-06 | 13551 | Rolandas Paksas | Lietuvos demokratinė darbo partija 519 | |||
176 | 176 | 176 | Slovakia 1 | 1999-06-15 | 2004-06-15 | 17102 | Rudolf Schuster | Strana občianskeho porozumenia 1016 | |||
26 | 26 | 26 | Iceland 56 | 2000-01-01 | 2004-06-26 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
212 | 212 | 212 | Germany 54 | 1999-07-01 | 2004-06-30 | 17060 | Johannes Rau | Sozialdemokratische Partei Deutschlands 558 | |||
80 | 80 | 80 | Austria 59 | 1998-04-19 | 2004-07-06 | 17029 | Thomas Klestil | Österreichische Volkspartei 1013 | |||
94 | 94 | 94 | Ireland 37 | 1997-11-11 | 2004-10-01 | 17076 | Mary McAleese | Fianna Fáil 280 | |||
16 | 16 | 16 | Romania 23 | 2000-12-20 | 2004-12-20 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
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 | |||
186 | 186 | 186 | Croatia 62 | 2000-02-18 | 2005-02-28 | 17069 | Stjepan Mesić | Hrvatska narodna stranka – Liberalni demokrati 1384 | |||
162 | 162 | 162 | Greece 41 | 2000-02-08 | 2005-03-12 | 17065 | Konstantinos Stephanopoulos | no party affiliation 1358 | |||
169 | 169 | 169 | Hungary 39 | 2000-08-04 | 2005-08-05 | 17071 | Ferenc Mádl | független 1617 | |||
70 | 70 | 70 | Poland 74 | 2000-10-08 | 2005-12-23 | 17092 | Aleksander Kwaśniewski | Sojusz Lewicy Demokratycznej 629 | |||
40 | 40 | 40 | Switzerland 40 | 2005-01-01 | 2005-12-31 | 7606 | Samuel Schmid | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
213 | 213 | 213 | Finland 67 | 2000-03-01 | 2006-01-29 | 5505 | Tarja Halonen | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
57 | 57 | 57 | Portugal 63 | 2001-03-09 | 2006-03-09 | 17097 | Jorge Sampaio | Partido Socialista 725 | |||
93 | 93 | 93 | Italy 26 | 1999-05-13 | 2006-05-15 | 8419 | Carlo Azeglio Ciampi | senzo partito 1552 | Previously a Governor of the Bank of Italy and PM of a technical cabinet. | ||
58 | 58 | 58 | Estonia 75 | 2001-10-08 | 2006-10-09 | 17062 | Arnold Rüütel | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond 417 | reuters | President Rüütel was elected (yes: 186, no: 155) on 21 September 2001. | |
158 | 158 | 158 | Bulgaria 10 | 2002-01-22 | 2006-10-29 | 17030 | Georgi Parvanov | Balgarska Sotsialisticheska Partiya 982 | |||
75 | 75 | 75 | Switzerland 40 | 2006-01-01 | 2006-12-31 | 7580 | Moritz Leuenberger | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
250 | 250 | 250 | France 43 | 2002-05-05 | 2007-05-16 | 1103 | Jacques Chirac | Union pour un mouvement populaire | Les Républicains 658 | |||
282 | 282 | 283 | Israel 34 | 2000-08-01 | 2007-07-01 | 17131 | Moshe Katsav | Likud 678 | |||
32 | 32 | 32 | Latvia 55 | 2003-06-20 | 2007-07-08 | 17089 | Vaira Vīķe-Freiberga | no party affiliation 288 | |||
266 | 266 | 267 | Turkey 20 | 2000-05-15 | 2007-08-28 | 17140 | Ahmet Necdet Sezer | bağımsız 1399 | |||
86 | 86 | 86 | Slovenia 60 | 2002-12-22 | 2007-12-22 | 9847 | Janez Drnovšek | Liberalna demokracija Slovenije 1252 | |||
138 | 138 | 138 | Switzerland 40 | 2007-01-01 | 2007-12-31 | 10350 | Micheline Calmy-Rey | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
90 | 90 | 90 | Czech Republic 68 | 2003-03-07 | 2008-02-09 | 14341 | Václav Klaus | Občanská demokratická strana 829 | |||
256 | 256 | 256 | Cyprus 51 | 2003-02-28 | 2008-02-28 | 4856 | Tassos Papadopoulos | Dimokratikó Kómma 851 | |||
27 | 27 | 27 | Iceland 56 | 2004-06-26 | 2008-06-28 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
6 | 6 | 6 | Switzerland 40 | 2008-01-01 | 2008-12-31 | 11791 | Pascal Couchepin | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
17 | 17 | 17 | Malta 72 | 2004-04-04 | 2009-04-04 | 11793 | Edward Fenech Adami | Partit Nazzjonalista 984 | |||
22 | 22 | 22 | Slovakia 1 | 2004-06-15 | 2009-04-04 | 17101 | Ivan Gašparovič | Hnutie za demokraciu 2160 | |||
156 | 156 | 156 | Germany 54 | 2004-07-01 | 2009-05-23 | 17059 | Horst Köhler | Christlich Demokratische Union 808 | |||
207 | 207 | 207 | Lithuania 15 | 2004-07-12 | 2009-07-12 | 17087 | Valdas Adamkus | no party affiliation 58 | |||
100 | 100 | 100 | Romania 23 | 2004-12-20 | 2009-12-21 | 17100 | Traian Băsescu | Partidul Democrat-Liberal 958 | |||
63 | 63 | 63 | Switzerland 40 | 2009-01-01 | 2009-12-31 | 14793 | Hans-Rudolf Merz | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
76 | 76 | 76 | Greece 41 | 2005-03-12 | 2010-02-03 | 11021 | Karolos Papoulias | Panellinio Sosialistikó Kínima 1338 | |||
187 | 187 | 187 | Croatia 62 | 2005-02-28 | 2010-02-18 | 17069 | Stjepan Mesić | Hrvatska narodna stranka – Liberalni demokrati 1384 | |||
55 | 55 | 55 | Poland 74 | 2005-12-23 | 2010-04-10 | 9684 | Lech Kaczyński | Prawo i Sprawiedliwość 528 | |||
136 | 136 | 136 | Austria 59 | 2004-07-08 | 2010-04-25 | 16906 | Heinz Fischer | Sozialdemokratische Partei Österreichs 973 | |||
157 | 157 | 157 | Germany 54 | 2009-05-23 | 2010-05-31 | 17059 | Horst Köhler | Christlich Demokratische Union 808 | |||
97 | 97 | 97 | Hungary 39 | 2005-08-05 | 2010-08-06 | 17073 | László Sólyom | független 1617 | |||
139 | 139 | 139 | Switzerland 40 | 2010-01-01 | 2010-12-31 | 17048 | Doris Leuthard | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
150 | 150 | 150 | Portugal 63 | 2006-03-09 | 2011-03-09 | 2839 | Aníbal Cavaco Silva | Partido Social Democrata 1273 | |||
291 | 291 | 292 | Latvia 55 | 2007-07-08 | 2011-07-08 | 17144 | Valdis Zatlers | no party affiliation 288 | |||
114 | 114 | 114 | Estonia 75 | 2006-10-09 | 2011-08-29 | 10876 | Toomas Hendrik Ilves | Sotsiaaldemokraatlik Erakond | Mõõdukad 1448 | |||
95 | 95 | 95 | Ireland 37 | 2004-10-01 | 2011-11-10 | 17076 | Mary McAleese | Fianna Fáil 280 | |||
225 | 225 | 225 | Switzerland 40 | 2011-01-01 | 2011-12-31 | 10350 | Micheline Calmy-Rey | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
159 | 159 | 159 | Bulgaria 10 | 2006-10-29 | 2012-01-22 | 17030 | Georgi Parvanov | Balgarska Sotsialisticheska Partiya 982 | |||
82 | 82 | 82 | Germany 54 | 2010-06-30 | 2012-02-07 | 17058 | Christian Wulff | Christlich Demokratische Union 808 | |||
214 | 214 | 214 | Finland 67 | 2006-01-29 | 2012-03-01 | 5505 | Tarja Halonen | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
117 | 117 | 117 | Hungary 39 | 2010-08-06 | 2012-04-02 | 17074 | Pál Schmitt | Fidesz – Magyar Polgári Szövetség 921 | |||
255 | 255 | 255 | France 43 | 2007-05-16 | 2012-05-15 | 4507 | Nicolas Sarkozy | Union pour un mouvement populaire | Les Républicains 658 | |||
28 | 28 | 28 | Iceland 56 | 2008-06-28 | 2012-06-30 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
60 | 60 | 60 | Slovenia 60 | 2007-12-22 | 2012-12-22 | 17103 | Danilo Türk | no party affiliation 1370 | |||
257 | 257 | 257 | Switzerland 40 | 2012-01-01 | 2012-12-31 | 17049 | Eveline Widmer-Schlumpf | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
142 | 142 | 142 | Cyprus 51 | 2008-02-28 | 2013-02-28 | 17053 | Dimitris Christofias | Anorthotikó Kómma Ergazómenou Laoú 572 | |||
91 | 91 | 91 | Czech Republic 68 | 2008-02-09 | 2013-03-07 | 14341 | Václav Klaus | Občanská demokratická strana 829 | |||
174 | 174 | 174 | Italy 26 | 2006-05-15 | 2013-04-20 | 5240 | Giorgio Napolitano | Democratici di Sinistra 809 | |||
183 | 183 | 183 | Switzerland 40 | 2013-01-01 | 2013-12-31 | 17051 | Ueli Maurer | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
215 | 215 | 215 | Malta 72 | 2009-04-04 | 2014-04-04 | 17090 | George Abela | Partit Laburista 1003 | |||
239 | 239 | 239 | Lithuania 15 | 2009-07-12 | 2014-05-25 | 1266 | Dalia Grybauskaitė | no party affiliation 58 | |||
23 | 23 | 23 | Slovakia 1 | 2009-04-04 | 2014-06-15 | 17101 | Ivan Gašparovič | Hnutie za demokraciu 2160 | |||
283 | 283 | 284 | Israel 34 | 2007-07-15 | 2014-07-24 | 17132 | Shimon Peres | Kadima 1870 | |||
267 | 267 | 268 | Turkey 20 | 2007-08-28 | 2014-08-28 | 17138 | Abdullah Gül | Adalet ve Kalkınma Partisi 901 | |||
101 | 101 | 101 | Romania 23 | 2009-12-21 | 2014-12-21 | 17100 | Traian Băsescu | Partidul Democrat-Liberal 958 |
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]) );