politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by person_id_source
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
44 | 44 | 44 | Italy 26 | 1971-12-24 | 1978-06-15 | 612 | Giovanni Leone | Democrazia Cristiana 1633 | |||
317 | 317 | 319 | Lithuania 15 | 2019-07-12 | 17167 | Gitanas Nausėda | no party affiliation 58 | ||||
166 | 166 | 166 | Italy 26 | 1964-12-28 | 1971-12-24 | 6049 | Giuseppe Saragat | Partito Socialista Democratico Italiano 242 | |||
236 | 236 | 236 | Cyprus 51 | 1993-02-28 | 1998-02-15 | 17055 | Glafcos Clerides | Dimokratikó Kómma 851 | |||
237 | 237 | 237 | Cyprus 51 | 1998-02-15 | 2003-02-28 | 17055 | Glafcos Clerides | Dimokratikó Kómma 851 | |||
241 | 241 | 241 | Malta 72 | 1999-04-04 | 2004-04-04 | 9784 | Guido de Marco | Partit Nazzjonalista 984 | |||
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 | |||
148 | 148 | 148 | Germany 54 | 1969-07-01 | 1974-06-30 | 8422 | Gustav Heinemann | Sozialdemokratische Partei Deutschlands 558 | nyt | President Heinemann was elected (yes: 512, no: 506, abstain: 3) on 5 March 1969 with votes from the Social Democrats (SPD) and Free Democrats (FDP). | |
339 | 339 | 341 | Switzerland 40 | 2021-01-01 | 2021-12-31 | 17186 | Guy Parmelin | Schweizerische Volkspartei – Union Démocratique du Centre 750 | afp | ||
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 | |||
1 | 1 | 1 | Switzerland 40 | 1966-01-01 | 1966-12-31 | 7243 | Hans Schaffner | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
143 | 143 | 143 | Switzerland 40 | 1957-01-01 | 1957-12-31 | 2097 | Hans Streuli | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
43 | 43 | 43 | Switzerland 40 | 1970-01-01 | 1970-12-31 | 5600 | Hans-Peter Tschudi | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
168 | 168 | 168 | Switzerland 40 | 1965-01-01 | 1965-12-31 | 5600 | Hans-Peter Tschudi | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
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 | |||
172 | 172 | 172 | Germany 54 | 1959-09-12 | 1964-07-01 | 4009 | Heinrich Lübke | Christlich Demokratische Union 808 | |||
173 | 173 | 173 | Germany 54 | 1964-07-01 | 1969-06-30 | 4009 | Heinrich Lübke | Christlich Demokratische Union 808 | |||
136 | 136 | 136 | Austria 59 | 2004-07-08 | 2010-04-25 | 16906 | Heinz Fischer | Sozialdemokratische Partei Österreichs 973 | |||
137 | 137 | 137 | Austria 59 | 2010-04-25 | 2016-05-21 | 16906 | Heinz Fischer | Sozialdemokratische Partei Österreichs 973 | |||
156 | 156 | 156 | Germany 54 | 2004-07-01 | 2009-05-23 | 17059 | Horst Köhler | Christlich Demokratische Union 808 | |||
157 | 157 | 157 | Germany 54 | 2009-05-23 | 2010-05-31 | 17059 | Horst Köhler | Christlich Demokratische Union 808 | |||
341 | 341 | 343 | Switzerland 40 | 2022-01-01 | 2022-12-31 | 17188 | Ignazio Cassis | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | dpa | ||
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 | ||||
16 | 16 | 16 | Romania 23 | 2000-12-20 | 2004-12-20 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
121 | 121 | 121 | Romania 23 | 1989-12-26 | 1990-05-20 | 17099 | Ion Iliescu | Partidul Democrat 419 | |||
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 | |||
336 | 336 | 338 | Israel 34 | 2021-07-07 | 17185 | Isaac Herzog | HaMa'arakh | HaAvoda 244 | reuters | |||
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 | |||
135 | 135 | 135 | Croatia 62 | 2010-02-18 | 2015-02-15 | 17068 | Ivo Josipović | Socijaldemokratska partija Hrvatske 1493 | |||
249 | 249 | 249 | France 43 | 1995-05-17 | 2002-05-05 | 1103 | Jacques Chirac | Rassemblement pour la république 138 | |||
250 | 250 | 250 | France 43 | 2002-05-05 | 2007-05-16 | 1103 | Jacques Chirac | Union pour un mouvement populaire | Les Républicains 658 | |||
86 | 86 | 86 | Slovenia 60 | 2002-12-22 | 2007-12-22 | 9847 | Janez Drnovšek | Liberalna demokracija Slovenije 1252 | |||
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 | |||
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 | |||
240 | 240 | 240 | Germany 54 | 2012-03-18 | 2017-03-19 | 15583 | Joachim Gauck | parteilos 610 | |||
320 | 320 | 322 | Switzerland 40 | 2016-01-01 | 2016-12-31 | 17169 | Johann Schneider-Ammann | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
212 | 212 | 212 | Germany 54 | 1999-07-01 | 2004-06-30 | 17060 | Johannes Rau | Sozialdemokratische Partei Deutschlands 558 | |||
56 | 56 | 56 | Portugal 63 | 1996-03-09 | 2001-03-09 | 17097 | Jorge Sampaio | Partido Socialista 725 | |||
57 | 57 | 57 | Portugal 63 | 2001-03-09 | 2006-03-09 | 17097 | Jorge Sampaio | Partido Socialista 725 | |||
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 | |||
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 | |||
197 | 197 | 197 | Hungary 39 | 2012-05-10 | 2017-05-08 | 17072 | János Áder | Fidesz – Magyar Polgári Szövetség 921 | |||
328 | 328 | 330 | Hungary 39 | 2017-05-08 | 2022-05-09 | 17072 | János Áder | Fidesz – Magyar Polgári Szövetség 921 | |||
296 | 296 | 297 | Finland 67 | 1919-07-26 | 1925-03-02 | 17150 | Kaarlo Juho Ståhlberg | Kansallinen Edistyspuolue | [Suomen] Liberaalinen Kansanpuolue 1219 | no-2010 | ||
85 | 85 | 85 | Germany 54 | 1979-07-01 | 1984-06-30 | 2172 | Karl Carstens | Christlich Demokratische Union 808 | |||
33 | 33 | 33 | Switzerland 40 | 1952-01-01 | 1952-12-31 | 10064 | Karl Kobelt | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
65 | 65 | 65 | Switzerland 40 | 1946-01-01 | 1946-12-31 | 10064 | Karl Kobelt | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
153 | 153 | 153 | Austria 59 | 1945-04-29 | 1950-12-31 | 5373 | Karl Renner | Sozialdemokratische Partei Österreichs 973 | |||
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 | |||
18 | 18 | 18 | Switzerland 40 | 1995-01-01 | 1995-12-31 | 14593 | Kaspar Villiger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
167 | 167 | 167 | Switzerland 40 | 2002-01-01 | 2002-12-31 | 14593 | Kaspar Villiger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
340 | 340 | 342 | Hungary 39 | 2022-05-10 | 17187 | Katalin Novák | Fidesz – Magyar Polgári Szövetség 921 | dpa | |||
263 | 263 | 264 | Turkey 20 | 1982-11-09 | 1989-11-09 | 17134 | Kenan Evren | bağımsız 1399 | |||
287 | 287 | 288 | Croatia 62 | 2015-02-15 | 2020-02-18 | 17142 | Kolinda Grabar-Kitarovic | Hrvatska demokratska zajednica 276 | reuters | ||
73 | 73 | 73 | Greece 41 | 1980-05-15 | 1985-03-10 | 2324 | Konstantinos Karamanlis | Néa Đimokratía 47 | |||
81 | 81 | 81 | Greece 41 | 1990-05-04 | 1995-03-10 | 2324 | Konstantinos Karamanlis | Néa Đimokratía 47 | |||
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 | |||
21 | 21 | 21 | Greece 41 | 1975-06-20 | 1980-05-15 | 17066 | Konstantinos Tsatsos | Néa Đimokratía 47 | |||
144 | 144 | 144 | Iceland 56 | 1968-08-01 | 1972-01-01 | 17080 | Kristján Eldjárn | no party affiliation 134 | |||
145 | 145 | 145 | Iceland 56 | 1972-01-01 | 1976-01-01 | 17080 | Kristján Eldjárn | no party affiliation 134 | |||
146 | 146 | 146 | Iceland 56 | 1976-01-01 | 1980-08-01 | 17080 | Kristján Eldjárn | no party affiliation 134 | |||
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 | |||
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 | |||
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 | |||
99 | 99 | 99 | Austria 59 | 1986-07-08 | 1992-07-08 | 1495 | Kurt Waldheim | Österreichische Volkspartei 1013 | |||
294 | 294 | 295 | Finland 67 | 1937-03-01 | 1940-12-19 | 17148 | Kyösti Kallio | Keskusta 94 | |||
292 | 292 | 293 | Finland 67 | 1925-03-02 | 1931-03-02 | 17145 | Lauri Kristian Relander | Keskusta 94 | no-2010 | ||
55 | 55 | 55 | Poland 74 | 2005-12-23 | 2010-04-10 | 9684 | Lech Kaczyński | Prawo i Sprawiedliwość 528 | |||
14 | 14 | 14 | Poland 74 | 1990-12-22 | 1995-12-22 | 17094 | Lech Wałęsa | Solidarność 108 | |||
83 | 83 | 83 | Estonia 75 | 1992-10-06 | 1996-09-20 | 13837 | Lennart Meri | Rahvuslik Koonderakond "Isamaa" 243 | |||
84 | 84 | 84 | Estonia 75 | 1996-09-20 | 2001-10-08 | 13837 | Lennart Meri | Rahvuslik Koonderakond "Isamaa" 243 | |||
15 | 15 | 15 | Switzerland 40 | 1984-01-01 | 1984-12-31 | 11125 | Leon Schlumpf | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
59 | 59 | 59 | Switzerland 40 | 1969-01-01 | 1969-12-31 | 7634 | Ludwig von Moos | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
242 | 242 | 242 | Switzerland 40 | 1964-01-01 | 1964-12-31 | 7634 | Ludwig von Moos | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
35 | 35 | 35 | Italy 26 | 1948-05-11 | 1955-04-24 | 14070 | Luigi Einaudi | Partito Liberale Italiano 487 | |||
97 | 97 | 97 | Hungary 39 | 2005-08-05 | 2010-08-06 | 17073 | László Sólyom | független 1617 | |||
261 | 261 | 262 | Malta 72 | 2014-04-04 | 2019-04-04 | 17122 | Marie Louise Coleiro Preca | Partit Laburista 1003 | |||
230 | 230 | 230 | Switzerland 40 | 1956-01-01 | 1956-12-31 | 13646 | Markus Feldmann | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
133 | 133 | 133 | Finland 67 | 1994-03-01 | 2000-03-01 | 17063 | Martti Ahtisaari | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
94 | 94 | 94 | Ireland 37 | 1997-11-11 | 2004-10-01 | 17076 | Mary McAleese | Fianna Fáil 280 | |||
95 | 95 | 95 | Ireland 37 | 2004-10-01 | 2011-11-10 | 17076 | Mary McAleese | Fianna Fáil 280 | |||
127 | 127 | 127 | Ireland 37 | 1990-12-03 | 1997-09-12 | 17077 | Mary Robinson | Labour Party 318 | |||
223 | 223 | 223 | Finland 67 | 1982-01-27 | 1988-02-01 | 12508 | Mauno Koivisto | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
224 | 224 | 224 | Finland 67 | 1988-02-01 | 1994-03-01 | 12508 | Mauno Koivisto | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
50 | 50 | 50 | Switzerland 40 | 1955-01-01 | 1955-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
96 | 96 | 96 | Switzerland 40 | 1960-01-01 | 1960-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
104 | 104 | 104 | Switzerland 40 | 1950-01-01 | 1950-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
246 | 246 | 246 | Ireland 37 | 2011-11-11 | 2018-11-26 | 10553 | Michael D. Higgins | Labour Party 318 | |||
315 | 315 | 317 | Ireland 37 | 2018-11-26 | 10553 | Michael D. Higgins | Labour Party 318 | ||||
110 | 110 | 110 | Greece 41 | 1974-12-18 | 1975-06-19 | 17067 | Michail Stasinopoulos | Néa Đimokratía 47 | |||
252 | 252 | 252 | Slovakia 1 | 1993-03-02 | 1998-03-02 | 16261 | Michal Kováč | Hnutie za demokratické Slovensko 1142 | |||
138 | 138 | 138 | Switzerland 40 | 2007-01-01 | 2007-12-31 | 10350 | Micheline Calmy-Rey | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
225 | 225 | 225 | Switzerland 40 | 2011-01-01 | 2011-12-31 | 10350 | Micheline Calmy-Rey | 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]) );