politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by party_id descending
This data as json, CSV (advanced)
Suggested facets: data_source, description, comment, start_date (date), end_date (date)
Link | rowid | id | country_id | start_date | end_date | person_id | person_id_source | party_id ▲ | data_source | description | comment |
---|---|---|---|---|---|---|---|---|---|---|---|
316 | 316 | 318 | Slovakia 1 | 2019-06-15 | 17166 | reuters | Progresívne Slovensko 2751 | reuters | |||
311 | 311 | 313 | France 43 | 2017-06-14 | 17162 | La République En Marche! | Renaissance 2643 | |||||
298 | 298 | 299 | France 43 | 1932-05-10 | 1940-07-11 | 17152 | Albert Lebrun | Républicaine gauche 2587 | |||
302 | 302 | 303 | France 43 | 1920-02-18 | 1920-09-21 | 17156 | Paul Deschanel | Républicaine gauche 2587 | |||
303 | 303 | 304 | France 43 | 1913-02-18 | 1920-02-18 | 17157 | Raymond Poincaré | Républicaine gauche 2587 | |||
304 | 304 | 305 | France 43 | 1906-02-18 | 1913-02-18 | 17158 | Armand Fallières | Républicaine gauche 2587 | |||
22 | 22 | 22 | Slovakia 1 | 2004-06-15 | 2009-04-04 | 17101 | Ivan Gašparovič | Hnutie za demokraciu 2160 | |||
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 | |||
19 | 19 | 19 | Italy 26 | 1992-05-25 | 1999-05-13 | 9761 | Oscar Luigi Scalfaro | Democrazia Cristiana 1633 | |||
44 | 44 | 44 | Italy 26 | 1971-12-24 | 1978-06-15 | 612 | Giovanni Leone | Democrazia Cristiana 1633 | |||
147 | 147 | 147 | Italy 26 | 1955-04-24 | 1962-05-06 | 17084 | Giovanni Gronchi | Democrazia Cristiana 1633 | |||
155 | 155 | 155 | Italy 26 | 1985-06-23 | 1992-04-28 | 11964 | Francesco Cossiga | Democrazia Cristiana 1633 | |||
238 | 238 | 238 | Italy 26 | 1962-05-06 | 1964-08-10 | 8529 | Antonio Segni | Democrazia Cristiana 1633 | |||
97 | 97 | 97 | Hungary 39 | 2005-08-05 | 2010-08-06 | 17073 | László Sólyom | független 1617 | |||
169 | 169 | 169 | Hungary 39 | 2000-08-04 | 2005-08-05 | 17071 | Ferenc Mádl | független 1617 | |||
78 | 78 | 78 | Malta 72 | 1974-12-13 | 1976-12-27 | 17091 | Anthony Mamo | no party affiliation 1572 | |||
71 | 71 | 71 | Czech Republic 68 | 1993-02-02 | 1998-01-20 | 17057 | Václav Havel | no party affiliation 1567 | |||
72 | 72 | 72 | Czech Republic 68 | 1998-01-20 | 2003-02-02 | 17057 | Václav Havel | no party affiliation 1567 | |||
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. | ||
175 | 175 | 175 | Italy 26 | 2013-04-20 | 2015-01-14 | 5240 | Giorgio Napolitano | senzo partito 1552 | |||
247 | 247 | 247 | Bulgaria 10 | 2012-01-22 | 2017-01-19 | 17032 | Rosen Plevneliev | Grazhdani za Evropeysko Razvitie na Balgariya 1541 | |||
113 | 113 | 113 | France 43 | 1947-01-16 | 1954-01-16 | 6513 | Vincent Auriol | Parti socialiste 1539 | |||
189 | 189 | 189 | France 43 | 2012-05-15 | 2017-06-14 | 9979 | François Hollande | Parti socialiste 1539 | |||
205 | 205 | 205 | France 43 | 1981-05-21 | 1988-05-08 | 13638 | François Mitterrand | Parti socialiste 1539 | |||
206 | 206 | 206 | France 43 | 1988-05-08 | 1995-05-17 | 13638 | François Mitterrand | Parti socialiste 1539 | |||
134 | 134 | 134 | Cyprus 51 | 1988-02-28 | 1993-02-28 | 17054 | George Vasiliou | Enomeni Dimokrates 1523 | |||
135 | 135 | 135 | Croatia 62 | 2010-02-18 | 2015-02-15 | 17068 | Ivo Josipović | Socijaldemokratska partija Hrvatske 1493 | |||
333 | 333 | 335 | Croatia 62 | 2020-02-18 | 17174 | Zoran Milanović | Socijaldemokratska partija Hrvatske 1493 | ap | |||
233 | 233 | 233 | Italy 26 | 1978-07-08 | 1985-06-23 | 17085 | Sandro Pertini | Partito Socialista Italiano 1475 | |||
128 | 128 | 128 | Iceland 56 | 1952-08-01 | 1956-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
129 | 129 | 129 | Iceland 56 | 1956-01-01 | 1960-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
130 | 130 | 130 | Iceland 56 | 1960-01-01 | 1964-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
131 | 131 | 131 | Iceland 56 | 1964-01-01 | 1968-08-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
114 | 114 | 114 | Estonia 75 | 2006-10-09 | 2011-08-29 | 10876 | Toomas Hendrik Ilves | Sotsiaaldemokraatlik Erakond | Mõõdukad 1448 | |||
115 | 115 | 115 | Estonia 75 | 2011-08-29 | 2016-10-10 | 10876 | Toomas Hendrik Ilves | Sotsiaaldemokraatlik Erakond | Mõõdukad 1448 | |||
309 | 309 | 311 | Austria 59 | 2017-01-26 | 2022-10-09 | 10383 | Alexander Van der Bellen | Die Grünen – Die Grüne Alternative 1429 | reuters | ||
342 | 342 | 344 | Austria 59 | 2022-10-09 | 10383 | Alexander Van der Bellen | Die Grünen – Die Grüne Alternative 1429 | dpa, reuters | |||
170 | 170 | 170 | Hungary 39 | 1990-08-04 | 1995-08-04 | 17070 | Árpád Göncz | Szabad Demokraták Szövetsége 1426 | |||
171 | 171 | 171 | Hungary 39 | 1995-08-04 | 2000-08-04 | 17070 | Árpád Göncz | Szabad Demokraták Szövetsége 1426 | |||
9 | 9 | 9 | France 43 | 1954-01-16 | 1959-01-08 | 199 | René Coty | Centre national des indépendants et paysans 1414 | |||
263 | 263 | 264 | Turkey 20 | 1982-11-09 | 1989-11-09 | 17134 | Kenan Evren | bağımsız 1399 | |||
266 | 266 | 267 | Turkey 20 | 2000-05-15 | 2007-08-28 | 17140 | Ahmet Necdet Sezer | bağımsız 1399 | |||
186 | 186 | 186 | Croatia 62 | 2000-02-18 | 2005-02-28 | 17069 | Stjepan Mesić | Hrvatska narodna stranka – Liberalni demokrati 1384 | |||
187 | 187 | 187 | Croatia 62 | 2005-02-28 | 2010-02-18 | 17069 | Stjepan Mesić | Hrvatska narodna stranka – Liberalni demokrati 1384 | |||
60 | 60 | 60 | Slovenia 60 | 2007-12-22 | 2012-12-22 | 17103 | Danilo Türk | no party affiliation 1370 | |||
66 | 66 | 66 | Slovenia 60 | 1990-05-10 | 1992-12-06 | 17104 | Milan Kučan | no party affiliation 1370 | |||
67 | 67 | 67 | Slovenia 60 | 1992-12-06 | 1997-12-23 | 17104 | Milan Kučan | no party affiliation 1370 | |||
68 | 68 | 68 | Slovenia 60 | 1997-12-23 | 2002-12-22 | 17104 | Milan Kučan | no party affiliation 1370 | |||
331 | 331 | 333 | Slovenia 60 | 2017-12-22 | 2022-12-22 | 8781 | Borut Pahor | no party affiliation 1370 | |||
343 | 343 | 345 | Slovenia 60 | 2022-12-23 | 17189 | Nataša Pirc Musar | no party affiliation 1370 | reuters | |||
184 | 184 | 184 | Latvia 55 | 1993-07-07 | 1996-06-18 | 17088 | Guntis Ulmanis | Latvijas Zemnieku Savienība 1368 | |||
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 | |||
26 | 26 | 26 | Iceland 56 | 2000-01-01 | 2004-06-26 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
27 | 27 | 27 | Iceland 56 | 2004-06-26 | 2008-06-28 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
28 | 28 | 28 | Iceland 56 | 2008-06-28 | 2012-06-30 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
29 | 29 | 29 | Iceland 56 | 2012-06-30 | 2016-08-01 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
262 | 262 | 263 | Slovakia 1 | 2014-06-15 | 2019-06-15 | 17123 | Andrej Kiska | no party affiliation 1359 | |||
36 | 36 | 36 | Greece 41 | 1985-03-30 | 1990-05-04 | 17064 | Christos Sartzetakis | no party affiliation 1358 | |||
161 | 161 | 161 | Greece 41 | 1995-03-10 | 2000-02-08 | 17065 | Konstantinos Stephanopoulos | no party affiliation 1358 | |||
162 | 162 | 162 | Greece 41 | 2000-02-08 | 2005-03-12 | 17065 | Konstantinos Stephanopoulos | no party affiliation 1358 | |||
327 | 327 | 329 | Greece 41 | 2020-03-13 | 17171 | no party affiliation 1358 | |||||
76 | 76 | 76 | Greece 41 | 2005-03-12 | 2010-02-03 | 11021 | Karolos Papoulias | Panellinio Sosialistikó Kínima 1338 | |||
77 | 77 | 77 | Greece 41 | 2010-02-03 | 2015-03-13 | 11021 | Karolos Papoulias | Panellinio Sosialistikó Kínima 1338 | |||
264 | 264 | 265 | Turkey 20 | 1989-11-09 | 1993-04-17 | 17135 | Turgut Özal | Anavatan Partisi 1334 | |||
150 | 150 | 150 | Portugal 63 | 2006-03-09 | 2011-03-09 | 2839 | Aníbal Cavaco Silva | Partido Social Democrata 1273 | |||
151 | 151 | 151 | Portugal 63 | 2011-03-09 | 2016-03-09 | 2839 | Aníbal Cavaco Silva | Partido Social Democrata 1273 | |||
305 | 305 | 306 | Portugal 63 | 2016-03-09 | 11226 | Rebelo de Sousa, Marcelo | Partido Social Democrata 1273 | reuters | |||
86 | 86 | 86 | Slovenia 60 | 2002-12-22 | 2007-12-22 | 9847 | Janez Drnovšek | Liberalna demokracija Slovenije 1252 | |||
295 | 295 | 296 | Finland 67 | 1940-12-19 | 1944-08-04 | 17149 | Risto Ryti | Kansallinen Edistyspuolue | [Suomen] Liberaalinen Kansanpuolue 1219 | no-2010 | ||
296 | 296 | 297 | Finland 67 | 1919-07-26 | 1925-03-02 | 17150 | Kaarlo Juho Ståhlberg | Kansallinen Edistyspuolue | [Suomen] Liberaalinen Kansanpuolue 1219 | no-2010 | ||
252 | 252 | 252 | Slovakia 1 | 1993-03-02 | 1998-03-02 | 16261 | Michal Kováč | Hnutie za demokratické Slovensko 1142 | |||
265 | 265 | 266 | Turkey 20 | 1993-05-16 | 2000-05-16 | 17136 | Süleyman Demirel | Doğru Yol Partisi 1141 | |||
16 | 16 | 16 | Romania 23 | 2000-12-20 | 2004-12-20 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
122 | 122 | 122 | Romania 23 | 1990-05-20 | 1992-10-11 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
123 | 123 | 123 | Romania 23 | 1992-10-11 | 1996-11-29 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
202 | 202 | 202 | Finland 67 | 1944-08-04 | 1946-03-04 | 17050 | Carl Gustaf Emil Mannerheim | ei kukaan – ingen 1119 | |||
326 | 326 | 328 | Finland 67 | 2018-01-28 | 6495 | Sauli Niinistö | ei kukaan – ingen 1119 | ||||
20 | 20 | 20 | Finland 67 | 2012-03-01 | 2018-01-28 | 6495 | Sauli Niinistö | Kansallinen Kokoomus – Samlingspartiet 1118 | |||
244 | 244 | 244 | Finland 67 | 1946-03-11 | 1950-01-17 | 3432 | Juho Kusti Paasikivi | Kansallinen Kokoomus – Samlingspartiet 1118 | |||
245 | 245 | 245 | Finland 67 | 1950-01-17 | 1956-03-01 | 3432 | Juho Kusti Paasikivi | Kansallinen Kokoomus – Samlingspartiet 1118 | |||
293 | 293 | 294 | Finland 67 | 1931-03-02 | 1937-03-01 | 17147 | Pehr Evind Svinhufvud | Kansallinen Kokoomus – Samlingspartiet 1118 | no-2010 | ||
106 | 106 | 106 | France 43 | 1969-06-20 | 1974-04-02 | 12102 | Georges Pompidou | Gaulliste 1094 | |||
195 | 195 | 195 | France 43 | 1959-01-08 | 1965-12-19 | 11223 | Charles de Gaulle | Gaulliste 1094 | |||
196 | 196 | 196 | France 43 | 1965-12-19 | 1969-04-28 | 11223 | Charles de Gaulle | Gaulliste 1094 | |||
3 | 3 | 3 | Poland 74 | 1989-12-31 | 1990-12-22 | 17095 | Wojciech Jaruzelski | Polska Zjednoczone Partia Robotnicza 1077 | |||
92 | 92 | 92 | Lithuania 15 | 1990-03-11 | 1992-11-25 | 2628 | Vytautas Landsbergis | Tėvynės sąjunga 1045 | |||
176 | 176 | 176 | Slovakia 1 | 1999-06-15 | 2004-06-15 | 17102 | Rudolf Schuster | Strana občianskeho porozumenia 1016 | |||
285 | 285 | 286 | Romania 23 | 2014-12-21 | 2019-12-21 | 17141 | Iohannis, Klaus | Partidul Naţional Liberal 1015 | |||
318 | 318 | 320 | Romania 23 | 2019-12-21 | 17141 | Iohannis, Klaus | Partidul Naţional Liberal 1015 | ||||
79 | 79 | 79 | Austria 59 | 1992-07-08 | 1998-04-19 | 17029 | Thomas Klestil | Österreichische Volkspartei 1013 | |||
80 | 80 | 80 | Austria 59 | 1998-04-19 | 2004-07-06 | 17029 | Thomas Klestil | Österreichische Volkspartei 1013 | |||
99 | 99 | 99 | Austria 59 | 1986-07-08 | 1992-07-08 | 1495 | Kurt Waldheim | Österreichische Volkspartei 1013 | |||
30 | 30 | 30 | Malta 72 | 1976-12-27 | 1981-12-27 | 5990 | Anton Buttigieg | Partit Laburista 1003 | |||
52 | 52 | 52 | Malta 72 | 1982-02-15 | 1987-02-15 | 15060 | Agatha Barbara | Partit Laburista 1003 | |||
215 | 215 | 215 | Malta 72 | 2009-04-04 | 2014-04-04 | 17090 | George Abela | Partit Laburista 1003 | |||
261 | 261 | 262 | Malta 72 | 2014-04-04 | 2019-04-04 | 17122 | Marie Louise Coleiro Preca | Partit Laburista 1003 | |||
330 | 330 | 332 | Malta 72 | 2019-04-04 | 17173 | George Vella | Partit Laburista 1003 | ||||
17 | 17 | 17 | Malta 72 | 2004-04-04 | 2009-04-04 | 11793 | Edward Fenech Adami | Partit Nazzjonalista 984 |
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]) );