politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by end_date
This data as json, CSV (advanced)
Suggested facets: country_id, start_date, end_date, person_id_source, party_id, data_source, description, comment, end_date (date)
start_date (date) 330 ✖
- 1952-01-01 2
- 1956-01-01 2
- 1960-01-01 2
- 1964-01-01 2
- 1972-01-01 2
- 1974-01-01 2
- 1976-01-01 2
- 1983-01-01 2
- 1984-01-01 2
- 1992-01-01 2
- 2000-01-01 2
- 2009-04-04 2
- 2010-08-06 2
- 1906-02-18 1
- 1913-02-18 1
- 1919-02-11 1
- 1919-07-26 1
- 1920-02-18 1
- 1920-09-23 1
- 1924-06-13 1
- 1925-03-02 1
- 1925-05-12 1
- 1931-03-02 1
- 1931-06-13 1
- 1932-05-10 1
- 1937-03-01 1
- 1940-07-11 1
- 1940-12-19 1
- 1944-06-17 1
- 1944-08-04 1
- 1945-01-01 1
- 1945-04-29 1
- 1945-06-24 1
- 1946-01-01 1
- 1946-03-11 1
- 1946-06-28 1
- 1947-01-01 1
- 1947-01-16 1
- 1947-06-25 1
- 1948-01-01 1
- 1948-05-11 1
- 1949-01-01 1
- 1949-02-17 1
- 1949-09-13 1
- 1950-01-01 1
- 1950-01-17 1
- 1951-01-01 1
- 1951-06-21 1
- 1951-11-25 1
- 1952-08-01 1
- 1952-12-16 1
- 1953-01-01 1
- 1954-01-01 1
- 1954-01-16 1
- 1954-07-17 1
- 1955-01-01 1
- 1955-04-24 1
- 1956-03-01 1
- 1957-01-01 1
- 1957-05-22 1
- 1957-10-28 1
- 1958-01-01 1
- 1959-01-01 1
- 1959-01-08 1
- 1959-06-25 1
- 1959-09-12 1
- 1960-08-16 1
- 1961-01-01 1
- 1962-01-01 1
- 1962-01-16 1
- 1962-05-06 1
- 1962-10-30 1
- 1963-01-01 1
- 1963-04-28 1
- 1963-05-21 1
- 1964-07-01 1
- 1964-12-28 1
- 1965-01-01 1
- 1965-06-09 1
- 1965-12-19 1
- 1966-01-01 1
- 1966-06-01 1
- 1967-01-01 1
- 1968-01-01 1
- 1968-01-16 1
- 1968-03-26 1
- 1968-08-01 1
- 1969-01-01 1
- 1969-06-20 1
- 1969-07-01 1
- 1970-01-01 1
- 1971-01-01 1
- 1971-04-25 1
- 1971-12-24 1
- 1973-01-01 1
- 1973-05-24 1
- 1973-06-25 1
- 1974-05-27 1
- 1974-07-01 1
- 1974-07-08 1
- 1974-12-08 1
- 1974-12-13 1
- 1974-12-18 1
- 1974-12-19 1
- 1975-01-01 1
- 1975-06-20 1
- 1976-07-14 1
- 1976-12-03 1
- 1976-12-27 1
- 1977-01-01 1
- 1977-09-03 1
- 1978-01-01 1
- 1978-01-16 1
- 1978-05-29 1
- 1978-07-08 1
- 1979-01-01 1
- 1979-07-01 1
- 1980-01-01 1
- 1980-05-15 1
- 1980-05-18 1
- 1980-08-01 1
- 1981-01-01 1
- 1981-03-09 1
- 1981-05-21 1
- 1982-01-01 1
- 1982-01-27 1
- 1982-02-15 1
- 1982-11-09 1
- 1983-02-13 1
- 1983-05-05 1
- 1984-07-01 1
- 1985-01-01 1
- 1985-03-30 1
- 1985-06-23 1
- 1986-01-01 1
- 1986-03-09 1
- 1986-07-08 1
- 1987-01-01 1
- 1988-01-01 1
- 1988-02-01 1
- 1988-02-23 1
- 1988-02-28 1
- 1988-05-08 1
- 1988-06-25 1
- 1989-01-01 1
- 1989-04-04 1
- 1989-05-23 1
- 1989-11-09 1
- 1989-12-26 1
- 1989-12-31 1
- 1990-01-01 1
- 1990-03-11 1
- 1990-05-04 1
- 1990-05-10 1
- 1990-05-20 1
- 1990-08-01 1
- 1990-08-04 1
- 1990-12-03 1
- 1990-12-22 1
- 1991-01-01 1
- 1991-03-09 1
- 1992-05-25 1
- 1992-07-08 1
- 1992-10-06 1
- 1992-10-11 1
- 1992-11-25 1
- 1992-12-06 1
- 1993-01-01 1
- 1993-02-02 1
- 1993-02-28 1
- 1993-03-02 1
- 1993-05-13 1
- 1993-05-16 1
- 1993-07-07 1
- 1994-01-01 1
- 1994-03-01 1
- 1994-04-04 1
- 1994-07-01 1
- 1995-01-01 1
- 1995-03-10 1
- 1995-05-17 1
- 1995-08-04 1
- 1995-12-23 1
- 1996-01-01 1
- 1996-03-09 1
- 1996-06-18 1
- 1996-08-01 1
- 1996-09-20 1
- 1996-11-29 1
- 1997-01-01 1
- 1997-01-22 1
- 1997-11-11 1
- 1997-12-23 1
- 1998-01-01 1
- 1998-01-20 1
- 1998-02-15 1
- 1998-02-26 1
- 1998-04-03 1
- 1998-04-19 1
- 1999-01-01 1
- 1999-04-04 1
- 1999-05-13 1
- 1999-06-15 1
- 1999-07-01 1
- 1999-07-08 1
- 2000-02-08 1
- 2000-02-18 1
- 2000-03-01 1
- 2000-05-15 1
- 2000-08-01 1
- 2000-08-04 1
- 2000-10-08 1
- 2000-12-20 1
- 2001-01-01 1
- 2001-03-09 1
- 2001-10-08 1
- 2002-01-01 1
- 2002-01-22 1
- 2002-05-05 1
- 2002-12-22 1
- 2003-01-01 1
- 2003-02-26 1
- 2003-02-28 1
- 2003-03-07 1
- 2003-06-20 1
- 2004-01-01 1
- 2004-04-04 1
- 2004-06-15 1
- 2004-06-26 1
- 2004-07-01 1
- 2004-07-08 1
- 2004-07-12 1
- 2004-10-01 1
- 2004-12-20 1
- 2005-01-01 1
- 2005-02-28 1
- 2005-03-12 1
- 2005-08-05 1
- 2005-12-23 1
- 2006-01-01 1
- 2006-01-29 1
- 2006-03-09 1
- 2006-05-15 1
- 2006-10-09 1
- 2006-10-29 1
- 2007-01-01 1
- 2007-05-16 1
- 2007-07-08 1
- 2007-07-15 1
- 2007-08-28 1
- 2007-12-22 1
- 2008-01-01 1
- 2008-02-09 1
- 2008-02-28 1
- 2008-06-28 1
- 2009-01-01 1
- 2009-05-23 1
- 2009-07-12 1
- 2009-12-21 1
- 2010-01-01 1
- 2010-02-03 1
- 2010-02-18 1
- 2010-04-25 1
- 2010-06-30 1
- 2011-01-01 1
- 2011-03-09 1
- 2011-07-08 1
- 2011-08-29 1
- 2011-11-11 1
- 2012-01-01 1
- 2012-01-22 1
- 2012-03-01 1
- 2012-03-18 1
- 2012-05-10 1
- 2012-05-15 1
- 2012-06-30 1
- 2012-12-22 1
- 2013-01-01 1
- 2013-02-28 1
- 2013-03-08 1
- 2013-04-20 1
- 2014-01-01 1
- 2014-04-04 1
- 2014-05-25 1
- 2014-06-15 1
- 2014-07-24 1
- 2014-08-28 1
- 2014-12-21 1
- 2015-01-01 1
- 2015-02-03 1
- 2015-02-15 1
- 2015-03-13 1
- 2015-07-08 1
- 2015-08-06 1
- 2016-01-01 1
- 2016-03-09 1
- 2016-08-01 1
- 2016-10-10 1
- 2017-01-01 1
- 2017-01-19 1
- 2017-01-26 1
- 2017-03-19 1
- 2017-05-08 1
- 2017-06-14 1
- 2017-12-22 1
- 2018-01-01 1
- 2018-01-27 1
- 2018-01-28 1
- 2018-02-04 1
- 2018-07-09 1
- 2018-11-26 1
- 2019-01-01 1
- 2019-04-04 1
- 2019-06-15 1
- 2019-07-08 1
- 2019-07-12 1
- 2019-12-21 1
- 2020-01-01 1
- 2020-02-18 1
- 2020-03-13 1
- 2020-06-28 1
- 2020-08-06 1
- 2021-01-01 1
- 2021-07-07 1
- 2021-10-11 1
- 2022-01-01 1
- 2022-01-29 1
- 2022-05-10 1
- 2022-10-09 1
- 2022-12-23 1
person_id 233 ✖
- 2403 5
- 14223 5
- 17079 4
- 17082 4
- 17099 4
- 404 3
- 15161 3
- 17080 3
- 17104 3
- 17125 3
- 677 2
- 1103 2
- 1245 2
- 1266 2
- 2324 2
- 2775 2
- 2839 2
- 3432 2
- 4009 2
- 4021 2
- 5240 2
- 5505 2
- 5600 2
- 5953 2
- 6238 2
- 6495 2
- 6502 2
- 6582 2
- 6753 2
- 7580 2
- 7634 2
- 7645 2
- 8465 2
- 8781 2
- 9930 2
- 10064 2
- 10350 2
- 10383 2
- 10553 2
- 10876 2
- 10927 2
- 11021 2
- 11089 2
- 11223 2
- 11721 2
- 11772 2
- 11791 2
- 12332 2
- 12508 2
- 13638 2
- 13717 2
- 13837 2
- 14341 2
- 14593 2
- 14732 2
- 15763 2
- 16017 2
- 16552 2
- 16653 2
- 16906 2
- 17029 2
- 17030 2
- 17048 2
- 17051 2
- 17052 2
- 17055 2
- 17056 2
- 17057 2
- 17059 2
- 17065 2
- 17069 2
- 17070 2
- 17072 2
- 17076 2
- 17078 2
- 17083 2
- 17087 2
- 17088 2
- 17089 2
- 17092 2
- 17096 2
- 17097 2
- 17100 2
- 17101 2
- 17124 2
- 17126 2
- 17129 2
- 17130 2
- 17139 2
- 17141 2
- 17143 2
- 17159 2
- 17168 2
- 61 1
- 199 1
- 612 1
- 1495 1
- 1634 1
- 1691 1
- 1853 1
- 2097 1
- 2172 1
- 2628 1
- 3131 1
- 3877 1
- 4507 1
- 4722 1
- 4856 1
- 4901 1
- 5018 1
- 5373 1
- 5990 1
- 6049 1
- 6513 1
- 6560 1
- 6567 1
- 6836 1
- 7150 1
- 7243 1
- 7606 1
- 8235 1
- 8320 1
- 8419 1
- 8422 1
- 8529 1
- 9684 1
- 9761 1
- 9784 1
- 9847 1
- 9888 1
- 9979 1
- 10045 1
- 10508 1
- 11125 1
- 11226 1
- 11793 1
- 11964 1
- 12102 1
- 12516 1
- 12553 1
- 13551 1
- 13646 1
- 13678 1
- 14070 1
- 14075 1
- 14596 1
- 14726 1
- 14793 1
- 15060 1
- 15420 1
- 15583 1
- 15713 1
- 16261 1
- 16326 1
- 17031 1
- 17032 1
- 17033 1
- 17049 1
- 17050 1
- 17053 1
- 17054 1
- 17058 1
- 17060 1
- 17061 1
- 17062 1
- 17063 1
- 17064 1
- 17066 1
- 17067 1
- 17068 1
- 17071 1
- 17073 1
- 17074 1
- 17075 1
- 17077 1
- 17081 1
- 17084 1
- 17085 1
- 17090 1
- 17091 1
- 17093 1
- 17094 1
- 17095 1
- 17098 1
- 17102 1
- 17103 1
- 17105 1
- 17122 1
- 17123 1
- 17127 1
- 17128 1
- 17131 1
- 17132 1
- 17133 1
- 17134 1
- 17135 1
- 17136 1
- 17138 1
- 17140 1
- 17142 1
- 17144 1
- 17145 1
- 17147 1
- 17148 1
- 17149 1
- 17150 1
- 17151 1
- 17152 1
- 17153 1
- 17154 1
- 17155 1
- 17156 1
- 17157 1
- 17158 1
- 17160 1
- 17161 1
- 17162 1
- 17164 1
- 17165 1
- 17166 1
- 17167 1
- 17169 1
- 17170 1
- 17171 1
- 17172 1
- 17173 1
- 17174 1
- 17184 1
- 17185 1
- 17186 1
- 17187 1
- 17188 1
- 17189 1
Link | rowid | id | country_id | start_date | end_date ▼ | person_id | person_id_source | party_id | data_source | description | comment |
---|---|---|---|---|---|---|---|---|---|---|---|
305 | 305 | 306 | Portugal 63 | 2016-03-09 | 11226 | Rebelo de Sousa, Marcelo | Partido Social Democrata 1273 | reuters | |||
308 | 308 | 310 | Bulgaria 10 | 2017-01-19 | 17161 | Rumen Radev | Balgarska Sotsialisticheska Partiya 982 | ap | |||
310 | 310 | 312 | Germany 54 | 2017-03-19 | 14726 | Frank-Walter Steinmeier | Sozialdemokratische Partei Deutschlands 558 | reuters | |||
311 | 311 | 313 | France 43 | 2017-06-14 | 17162 | La République En Marche! | Renaissance 2643 | |||||
312 | 312 | 314 | Cyprus 51 | 2018-02-04 | 17056 | Nicos Anastasiades | Dimokratikó Kómma 851 | reuters | |||
315 | 315 | 317 | Ireland 37 | 2018-11-26 | 10553 | Michael D. Higgins | Labour Party 318 | ||||
316 | 316 | 318 | Slovakia 1 | 2019-06-15 | 17166 | reuters | Progresívne Slovensko 2751 | reuters | |||
317 | 317 | 319 | Lithuania 15 | 2019-07-12 | 17167 | Gitanas Nausėda | no party affiliation 58 | ||||
318 | 318 | 320 | Romania 23 | 2019-12-21 | 17141 | Iohannis, Klaus | Partidul Naţional Liberal 1015 | ||||
325 | 325 | 327 | Czech Republic 68 | 2018-01-27 | 11721 | Miloš Zeman | Strana práv občanů – Zemanovci 406 | ||||
326 | 326 | 328 | Finland 67 | 2018-01-28 | 6495 | Sauli Niinistö | ei kukaan – ingen 1119 | ||||
327 | 327 | 329 | Greece 41 | 2020-03-13 | 17171 | no party affiliation 1358 | |||||
329 | 329 | 331 | Latvia 55 | 2019-07-08 | 17172 | no party affiliation 288 | |||||
330 | 330 | 332 | Malta 72 | 2019-04-04 | 17173 | George Vella | Partit Laburista 1003 | ||||
332 | 332 | 334 | Turkey 20 | 2018-07-09 | 17139 | Recep Tayyip Erdoğan | Adalet ve Kalkınma Partisi 901 | ||||
333 | 333 | 335 | Croatia 62 | 2020-02-18 | 17174 | Zoran Milanović | Socijaldemokratska partija Hrvatske 1493 | ap | |||
334 | 334 | 336 | Poland 74 | 2020-08-06 | 17143 | Prawo i Sprawiedliwość 528 | dpa | ||||
335 | 335 | 337 | Estonia 75 | 2021-10-11 | 17184 | no party affiliation 426 | |||||
336 | 336 | 338 | Israel 34 | 2021-07-07 | 17185 | Isaac Herzog | HaMa'arakh | HaAvoda 244 | reuters | |||
337 | 337 | 339 | Iceland 56 | 2020-06-28 | 17159 | no party affiliation 134 | review | ||||
338 | 338 | 340 | Italy 26 | 2022-01-29 | 8465 | Sergio Mattarella | Partito Democratico 382 | reuters | |||
340 | 340 | 342 | Hungary 39 | 2022-05-10 | 17187 | Katalin Novák | Fidesz – Magyar Polgári Szövetség 921 | dpa | |||
342 | 342 | 344 | Austria 59 | 2022-10-09 | 10383 | Alexander Van der Bellen | Die Grünen – Die Grüne Alternative 1429 | dpa, reuters | |||
343 | 343 | 345 | Slovenia 60 | 2022-12-23 | 17189 | Nataša Pirc Musar | no party affiliation 1370 | reuters | |||
304 | 304 | 305 | France 43 | 1906-02-18 | 1913-02-18 | 17158 | Armand Fallières | Républicaine gauche 2587 | |||
303 | 303 | 304 | France 43 | 1913-02-18 | 1920-02-18 | 17157 | Raymond Poincaré | Républicaine gauche 2587 | |||
302 | 302 | 303 | France 43 | 1920-02-18 | 1920-09-21 | 17156 | Paul Deschanel | Républicaine gauche 2587 | |||
301 | 301 | 302 | France 43 | 1920-09-23 | 1924-06-11 | 17155 | Alexandre Millerand | sans étiquette 947 | |||
313 | 313 | 315 | Germany 54 | 1919-02-11 | 1925-02-28 | 17164 | Sozialdemokratische Partei Deutschlands 558 | ||||
296 | 296 | 297 | Finland 67 | 1919-07-26 | 1925-03-02 | 17150 | Kaarlo Juho Ståhlberg | Kansallinen Edistyspuolue | [Suomen] Liberaalinen Kansanpuolue 1219 | no-2010 | ||
292 | 292 | 293 | Finland 67 | 1925-03-02 | 1931-03-02 | 17145 | Lauri Kristian Relander | Keskusta 94 | no-2010 | ||
300 | 300 | 301 | France 43 | 1924-06-13 | 1931-06-13 | 17154 | Gaston Doumergue | Parti radical-socialiste 401 | |||
299 | 299 | 300 | France 43 | 1931-06-13 | 1932-05-07 | 17153 | Paul Doumer | Parti radical-socialiste 401 | |||
314 | 314 | 316 | Germany 54 | 1925-05-12 | 1934-08-02 | 17165 | parteilos 610 | ||||
293 | 293 | 294 | Finland 67 | 1931-03-02 | 1937-03-01 | 17147 | Pehr Evind Svinhufvud | Kansallinen Kokoomus – Samlingspartiet 1118 | no-2010 | ||
298 | 298 | 299 | France 43 | 1932-05-10 | 1940-07-11 | 17152 | Albert Lebrun | Républicaine gauche 2587 | |||
294 | 294 | 295 | Finland 67 | 1937-03-01 | 1940-12-19 | 17148 | Kyösti Kallio | Keskusta 94 | |||
295 | 295 | 296 | Finland 67 | 1940-12-19 | 1944-08-04 | 17149 | Risto Ryti | Kansallinen Edistyspuolue | [Suomen] Liberaalinen Kansanpuolue 1219 | no-2010 | ||
297 | 297 | 298 | France 43 | 1940-07-11 | 1944-08-09 | 17151 | Philippe Pétain | sans étiquette 947 | |||
154 | 154 | 154 | Switzerland 40 | 1945-01-01 | 1945-12-31 | 9930 | Eduard von Steiger | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
202 | 202 | 202 | Finland 67 | 1944-08-04 | 1946-03-04 | 17050 | Carl Gustaf Emil Mannerheim | ei kukaan – ingen 1119 | |||
65 | 65 | 65 | Switzerland 40 | 1946-01-01 | 1946-12-31 | 10064 | Karl Kobelt | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
11 | 11 | 11 | Italy 26 | 1946-06-28 | 1947-06-25 | 17083 | Enrico De Nicola | Partito Liberale Italiano 487 | |||
140 | 140 | 140 | Switzerland 40 | 1947-01-01 | 1947-12-31 | 13717 | Philipp Etter | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
12 | 12 | 12 | Italy 26 | 1947-06-25 | 1948-05-11 | 17083 | Enrico De Nicola | Partito Liberale Italiano 487 | |||
160 | 160 | 160 | Switzerland 40 | 1948-01-01 | 1948-12-31 | 16326 | Enrico Celio | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
112 | 112 | 112 | Switzerland 40 | 1949-01-01 | 1949-12-31 | 1853 | Ernst Nobs | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
244 | 244 | 244 | Finland 67 | 1946-03-11 | 1950-01-17 | 3432 | Juho Kusti Paasikivi | Kansallinen Kokoomus – Samlingspartiet 1118 | |||
104 | 104 | 104 | Switzerland 40 | 1950-01-01 | 1950-12-31 | 404 | Max Petitpierre | 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 | |||
269 | 269 | 270 | Israel 34 | 1949-02-17 | 1951-11-25 | 17124 | Chaim Weizmann | no party affiliation 123 | |||
179 | 179 | 179 | Switzerland 40 | 1951-01-01 | 1951-12-31 | 9930 | Eduard von Steiger | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
118 | 118 | 118 | Ireland 37 | 1945-06-24 | 1952-01-01 | 17078 | Seán T. O'Kelly | Fianna Fáil 280 | |||
193 | 193 | 193 | Iceland 56 | 1944-06-17 | 1952-01-25 | 17081 | Sveinn Björnsson | no party affiliation 134 | |||
270 | 270 | 271 | Israel 34 | 1951-11-25 | 1952-11-09 | 17124 | Chaim Weizmann | no party affiliation 123 | |||
33 | 33 | 33 | Switzerland 40 | 1952-01-01 | 1952-12-31 | 10064 | Karl Kobelt | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
181 | 181 | 181 | Switzerland 40 | 1953-01-01 | 1953-12-31 | 13717 | Philipp Etter | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
113 | 113 | 113 | France 43 | 1947-01-16 | 1954-01-16 | 6513 | Vincent Auriol | Parti socialiste 1539 | |||
253 | 253 | 253 | Germany 54 | 1949-09-13 | 1954-07-17 | 5953 | Theodor Heuss | Freie Demokratische Partei 543 | |||
258 | 258 | 258 | Switzerland 40 | 1954-01-01 | 1954-12-31 | 4722 | Rodolphe Rubattel | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
35 | 35 | 35 | Italy 26 | 1948-05-11 | 1955-04-24 | 14070 | Luigi Einaudi | Partito Liberale Italiano 487 | |||
50 | 50 | 50 | Switzerland 40 | 1955-01-01 | 1955-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
128 | 128 | 128 | Iceland 56 | 1952-08-01 | 1956-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
245 | 245 | 245 | Finland 67 | 1950-01-17 | 1956-03-01 | 3432 | Juho Kusti Paasikivi | Kansallinen Kokoomus – Samlingspartiet 1118 | |||
230 | 230 | 230 | Switzerland 40 | 1956-01-01 | 1956-12-31 | 13646 | Markus Feldmann | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
4 | 4 | 4 | Austria 59 | 1951-06-21 | 1957-01-04 | 12553 | Theodor Körner | Sozialdemokratische Partei Österreichs 973 | |||
271 | 271 | 272 | Israel 34 | 1952-12-16 | 1957-10-28 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
143 | 143 | 143 | Switzerland 40 | 1957-01-01 | 1957-12-31 | 2097 | Hans Streuli | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
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 | |||
9 | 9 | 9 | France 43 | 1954-01-16 | 1959-01-08 | 199 | René Coty | Centre national des indépendants et paysans 1414 | |||
119 | 119 | 119 | Ireland 37 | 1952-01-01 | 1959-06-24 | 17078 | Seán T. O'Kelly | Fianna Fáil 280 | |||
254 | 254 | 254 | Germany 54 | 1954-07-17 | 1959-09-12 | 5953 | Theodor Heuss | Freie Demokratische Partei 543 | |||
107 | 107 | 107 | Switzerland 40 | 1959-01-01 | 1959-12-31 | 15763 | Paul Chaudet | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
129 | 129 | 129 | Iceland 56 | 1956-01-01 | 1960-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
96 | 96 | 96 | Switzerland 40 | 1960-01-01 | 1960-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
5 | 5 | 5 | Switzerland 40 | 1961-01-01 | 1961-12-31 | 3131 | Friedrich Traugott Wahlen | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
216 | 216 | 216 | Finland 67 | 1956-03-01 | 1962-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
147 | 147 | 147 | Italy 26 | 1955-04-24 | 1962-05-06 | 17084 | Giovanni Gronchi | Democrazia Cristiana 1633 | |||
272 | 272 | 273 | Israel 34 | 1957-10-28 | 1962-10-30 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
51 | 51 | 51 | Switzerland 40 | 1962-01-01 | 1962-12-31 | 15763 | Paul Chaudet | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
273 | 273 | 274 | Israel 34 | 1962-10-30 | 1963-04-23 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
226 | 226 | 226 | Austria 59 | 1957-05-22 | 1963-04-28 | 16653 | Adolf Schärf | Sozialdemokratische Partei Österreichs 973 | |||
231 | 231 | 231 | Switzerland 40 | 1963-01-01 | 1963-12-31 | 1245 | Willy Spühler | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
130 | 130 | 130 | Iceland 56 | 1960-01-01 | 1964-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
172 | 172 | 172 | Germany 54 | 1959-09-12 | 1964-07-01 | 4009 | Heinrich Lübke | Christlich Demokratische Union 808 | |||
238 | 238 | 238 | Italy 26 | 1962-05-06 | 1964-08-10 | 8529 | Antonio Segni | Democrazia Cristiana 1633 | |||
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 | |||
227 | 227 | 227 | Austria 59 | 1963-04-28 | 1965-02-28 | 16653 | Adolf Schärf | Sozialdemokratische Partei Österreichs 973 | |||
195 | 195 | 195 | France 43 | 1959-01-08 | 1965-12-19 | 11223 | Charles de Gaulle | Gaulliste 1094 | |||
168 | 168 | 168 | Switzerland 40 | 1965-01-01 | 1965-12-31 | 5600 | Hans-Peter Tschudi | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
61 | 61 | 61 | Ireland 37 | 1959-06-25 | 1966-06-01 | 12332 | Éamon de Valera | Fianna Fáil 280 | |||
1 | 1 | 1 | Switzerland 40 | 1966-01-01 | 1966-12-31 | 7243 | Hans Schaffner | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
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 | |||
217 | 217 | 217 | Finland 67 | 1962-01-16 | 1968-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
274 | 274 | 275 | Israel 34 | 1963-05-21 | 1968-03-26 | 17126 | Zalman Shazar | HaMa'arakh | HaAvoda 244 | |||
131 | 131 | 131 | Iceland 56 | 1964-01-01 | 1968-08-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
149 | 149 | 149 | Switzerland 40 | 1968-01-01 | 1968-12-31 | 1245 | Willy Spühler | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
196 | 196 | 196 | France 43 | 1965-12-19 | 1969-04-28 | 11223 | Charles de Gaulle | Gaulliste 1094 | |||
173 | 173 | 173 | Germany 54 | 1964-07-01 | 1969-06-30 | 4009 | Heinrich Lübke | Christlich Demokratische Union 808 | |||
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 |
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]) );