politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by person_id_source descending
This data as json, CSV (advanced)
Suggested facets: country_id, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
61 | 61 | 61 | Ireland 37 | 1959-06-25 | 1966-06-01 | 12332 | Éamon de Valera | Fianna Fáil 280 | |||
62 | 62 | 62 | Ireland 37 | 1966-06-01 | 1973-06-24 | 12332 | Éamon de Valera | Fianna Fáil 280 | |||
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 | |||
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 | |||
316 | 316 | 318 | Slovakia 1 | 2019-06-15 | 17166 | reuters | Progresívne Slovensko 2751 | reuters | |||
333 | 333 | 335 | Croatia 62 | 2020-02-18 | 17174 | Zoran Milanović | Socijaldemokratska partija Hrvatske 1493 | ap | |||
243 | 243 | 243 | Bulgaria 10 | 1990-08-01 | 1997-01-22 | 17033 | Zhelyu Zhelev | Suyuz na Demokratichnite Sili 423 | |||
274 | 274 | 275 | Israel 34 | 1963-05-21 | 1968-03-26 | 17126 | Zalman Shazar | HaMa'arakh | HaAvoda 244 | |||
275 | 275 | 276 | Israel 34 | 1968-03-26 | 1973-05-24 | 17126 | Zalman Shazar | HaMa'arakh | HaAvoda 244 | |||
277 | 277 | 278 | Israel 34 | 1978-05-29 | 1983-05-05 | 17128 | Yitzhak Navon | HaMa'arakh | HaAvoda 244 | |||
271 | 271 | 272 | Israel 34 | 1952-12-16 | 1957-10-28 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
272 | 272 | 273 | Israel 34 | 1957-10-28 | 1962-10-30 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
273 | 273 | 274 | Israel 34 | 1962-10-30 | 1963-04-23 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
3 | 3 | 3 | Poland 74 | 1989-12-31 | 1990-12-22 | 17095 | Wojciech Jaruzelski | Polska Zjednoczone Partia Robotnicza 1077 | |||
149 | 149 | 149 | Switzerland 40 | 1968-01-01 | 1968-12-31 | 1245 | Willy Spühler | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
231 | 231 | 231 | Switzerland 40 | 1963-01-01 | 1963-12-31 | 1245 | Willy Spühler | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
125 | 125 | 125 | Switzerland 40 | 1978-01-01 | 1978-12-31 | 1691 | Willy Ritschard | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
198 | 198 | 198 | Germany 54 | 1974-07-01 | 1979-06-30 | 6567 | Walter Scheel | Freie Demokratische Partei 543 | |||
90 | 90 | 90 | Czech Republic 68 | 2003-03-07 | 2008-02-09 | 14341 | Václav Klaus | Občanská demokratická strana 829 | |||
91 | 91 | 91 | Czech Republic 68 | 2008-02-09 | 2013-03-07 | 14341 | Václav Klaus | Občanská demokratická strana 829 | |||
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 | |||
92 | 92 | 92 | Lithuania 15 | 1990-03-11 | 1992-11-25 | 2628 | Vytautas Landsbergis | Tėvynės sąjunga 1045 | |||
120 | 120 | 120 | Malta 72 | 1989-04-04 | 1994-04-04 | 8235 | Vincent Tabone | Partit Nazzjonalista 984 | |||
113 | 113 | 113 | France 43 | 1947-01-16 | 1954-01-16 | 6513 | Vincent Auriol | Parti socialiste 1539 | |||
46 | 46 | 46 | Iceland 56 | 1980-08-01 | 1984-01-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
47 | 47 | 47 | Iceland 56 | 1984-01-01 | 1988-06-25 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
48 | 48 | 48 | Iceland 56 | 1988-06-25 | 1992-01-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
49 | 49 | 49 | Iceland 56 | 1992-01-01 | 1996-08-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
248 | 248 | 248 | France 43 | 1974-05-27 | 1981-05-21 | 8320 | Valéry Giscard d'Estaing | Independants républicains | Démocratie libérale 59 | |||
291 | 291 | 292 | Latvia 55 | 2007-07-08 | 2011-07-08 | 17144 | Valdis Zatlers | no party affiliation 288 | |||
192 | 192 | 192 | Lithuania 15 | 1998-02-26 | 2003-02-26 | 17087 | Valdas Adamkus | no party affiliation 58 | |||
207 | 207 | 207 | Lithuania 15 | 2004-07-12 | 2009-07-12 | 17087 | Valdas Adamkus | no party affiliation 58 | |||
31 | 31 | 31 | Latvia 55 | 1999-07-08 | 2003-06-20 | 17089 | Vaira Vīķe-Freiberga | no party affiliation 288 | |||
32 | 32 | 32 | Latvia 55 | 2003-06-20 | 2007-07-08 | 17089 | Vaira Vīķe-Freiberga | no party affiliation 288 | |||
216 | 216 | 216 | Finland 67 | 1956-03-01 | 1962-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
217 | 217 | 217 | Finland 67 | 1962-01-16 | 1968-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
218 | 218 | 218 | Finland 67 | 1968-01-16 | 1974-01-01 | 14223 | Urho Kekkonen | Keskusta 94 | |||
219 | 219 | 219 | Finland 67 | 1974-01-01 | 1978-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
220 | 220 | 220 | Finland 67 | 1978-01-16 | 1982-01-27 | 14223 | Urho Kekkonen | Keskusta 94 | |||
108 | 108 | 108 | Malta 72 | 1994-04-04 | 1999-04-04 | 4901 | Ugo Mifsud Bonnici | Partit Nazzjonalista 984 | |||
183 | 183 | 183 | Switzerland 40 | 2013-01-01 | 2013-12-31 | 17051 | Ueli Maurer | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
323 | 323 | 325 | Switzerland 40 | 2019-01-01 | 2019-12-31 | 17051 | Ueli Maurer | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
264 | 264 | 265 | Turkey 20 | 1989-11-09 | 1993-04-17 | 17135 | Turgut Özal | Anavatan Partisi 1334 | |||
100 | 100 | 100 | Romania 23 | 2004-12-20 | 2009-12-21 | 17100 | Traian Băsescu | Partidul Democrat-Liberal 958 | |||
101 | 101 | 101 | Romania 23 | 2009-12-21 | 2014-12-21 | 17100 | Traian Băsescu | Partidul Democrat-Liberal 958 | |||
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 | |||
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 | |||
74 | 74 | 74 | Switzerland 40 | 1958-01-01 | 1958-12-31 | 6560 | Thomas Holenstein | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
4 | 4 | 4 | Austria 59 | 1951-06-21 | 1957-01-04 | 12553 | Theodor Körner | Sozialdemokratische Partei Österreichs 973 | |||
253 | 253 | 253 | Germany 54 | 1949-09-13 | 1954-07-17 | 5953 | Theodor Heuss | Freie Demokratische Partei 543 | |||
254 | 254 | 254 | Germany 54 | 1954-07-17 | 1959-09-12 | 5953 | Theodor Heuss | Freie Demokratische Partei 543 | |||
256 | 256 | 256 | Cyprus 51 | 2003-02-28 | 2008-02-28 | 4856 | Tassos Papadopoulos | Dimokratikó Kómma 851 | |||
213 | 213 | 213 | Finland 67 | 2000-03-01 | 2006-01-29 | 5505 | Tarja Halonen | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
214 | 214 | 214 | Finland 67 | 2006-01-29 | 2012-03-01 | 5505 | Tarja Halonen | 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 | |||
193 | 193 | 193 | Iceland 56 | 1944-06-17 | 1952-01-25 | 17081 | Sveinn Björnsson | no party affiliation 134 | |||
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 | |||
102 | 102 | 102 | Cyprus 51 | 1977-09-03 | 1983-02-13 | 16017 | Spyros Kyprianou | Dimokratikó Kómma 851 | |||
103 | 103 | 103 | Cyprus 51 | 1983-02-13 | 1988-02-28 | 16017 | Spyros Kyprianou | Dimokratikó Kómma 851 | |||
319 | 319 | 321 | Switzerland 40 | 2015-01-01 | 2015-12-31 | 17168 | Simonetta Sommaruga | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
324 | 324 | 326 | Switzerland 40 | 2020-01-01 | 2020-12-31 | 17168 | Simonetta Sommaruga | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
283 | 283 | 284 | Israel 34 | 2007-07-15 | 2014-07-24 | 17132 | Shimon Peres | Kadima 1870 | |||
118 | 118 | 118 | Ireland 37 | 1945-06-24 | 1952-01-01 | 17078 | Seán T. O'Kelly | Fianna Fáil 280 | |||
119 | 119 | 119 | Ireland 37 | 1952-01-01 | 1959-06-24 | 17078 | Seán T. O'Kelly | Fianna Fáil 280 | |||
286 | 286 | 287 | Italy 26 | 2015-02-03 | 2022-01-29 | 8465 | Sergio Mattarella | Partito Democratico 382 | reuters | Mattarella was one of the founders of the Democratic Party (PD) in 2007 and was officially endorsed by the party. | |
338 | 338 | 340 | Italy 26 | 2022-01-29 | 8465 | Sergio Mattarella | Partito Democratico 382 | reuters | |||
20 | 20 | 20 | Finland 67 | 2012-03-01 | 2018-01-28 | 6495 | Sauli Niinistö | Kansallinen Kokoomus – Samlingspartiet 1118 | |||
326 | 326 | 328 | Finland 67 | 2018-01-28 | 6495 | Sauli Niinistö | ei kukaan – ingen 1119 | ||||
233 | 233 | 233 | Italy 26 | 1978-07-08 | 1985-06-23 | 17085 | Sandro Pertini | Partito Socialista Italiano 1475 | |||
40 | 40 | 40 | Switzerland 40 | 2005-01-01 | 2005-12-31 | 7606 | Samuel Schmid | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
228 | 228 | 228 | Switzerland 40 | 1999-01-01 | 1999-12-31 | 14596 | Ruth Dreifuss | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
308 | 308 | 310 | Bulgaria 10 | 2017-01-19 | 17161 | Rumen Radev | Balgarska Sotsialisticheska Partiya 982 | ap | |||
176 | 176 | 176 | Slovakia 1 | 1999-06-15 | 2004-06-15 | 17102 | Rudolf Schuster | Strana občianskeho porozumenia 1016 | |||
7 | 7 | 7 | Austria 59 | 1974-07-08 | 1980-05-18 | 4021 | Rudolf Kirchschläger | Parteilose 272 | |||
8 | 8 | 8 | Austria 59 | 1980-05-18 | 1986-07-08 | 4021 | Rudolf Kirchschläger | Parteilose 272 | |||
13 | 13 | 13 | Switzerland 40 | 1976-01-01 | 1976-12-31 | 11772 | Rudolf Gnägi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
194 | 194 | 194 | Switzerland 40 | 1971-01-01 | 1971-12-31 | 11772 | Rudolf Gnägi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
247 | 247 | 247 | Bulgaria 10 | 2012-01-22 | 2017-01-19 | 17032 | Rosen Plevneliev | Grazhdani za Evropeysko Razvitie na Balgariya 1541 | |||
208 | 208 | 208 | Germany 54 | 1994-07-01 | 1999-06-30 | 17061 | Roman Herzog | Christlich Demokratische Union 808 | |||
221 | 221 | 221 | Lithuania 15 | 2003-02-26 | 2004-04-06 | 13551 | Rolandas Paksas | Lietuvos demokratinė darbo partija 519 | |||
42 | 42 | 42 | Switzerland 40 | 1973-01-01 | 1973-12-31 | 6582 | Roger Bonvin | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
53 | 53 | 53 | Switzerland 40 | 1967-01-01 | 1967-12-31 | 6582 | Roger Bonvin | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
258 | 258 | 258 | Switzerland 40 | 1954-01-01 | 1954-12-31 | 4722 | Rodolphe Rubattel | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
295 | 295 | 296 | Finland 67 | 1940-12-19 | 1944-08-04 | 17149 | Risto Ryti | Kansallinen Edistyspuolue | [Suomen] Liberaalinen Kansanpuolue 1219 | no-2010 | ||
37 | 37 | 37 | Germany 54 | 1984-07-01 | 1989-05-23 | 6753 | Richard von Weizsäcker | Christlich Demokratische Union 808 | |||
38 | 38 | 38 | Germany 54 | 1989-05-23 | 1994-06-30 | 6753 | Richard von Weizsäcker | Christlich Demokratische Union 808 | |||
284 | 284 | 285 | Israel 34 | 2014-07-24 | 2021-07-07 | 17133 | Reuven Rivlin | Likud 678 |
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]) );