politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
143 | 143 | 143 | Switzerland 40 | 1957-01-01 | 1957-12-31 | 2097 | Hans Streuli | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
142 | 142 | 142 | Cyprus 51 | 2008-02-28 | 2013-02-28 | 17053 | Dimitris Christofias | Anorthotikó Kómma Ergazómenou Laoú 572 | |||
141 | 141 | 141 | Switzerland 40 | 1980-01-01 | 1980-12-31 | 6836 | Georges-André Chevallaz | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
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 | |||
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 | |||
138 | 138 | 138 | Switzerland 40 | 2007-01-01 | 2007-12-31 | 10350 | Micheline Calmy-Rey | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
137 | 137 | 137 | Austria 59 | 2010-04-25 | 2016-05-21 | 16906 | Heinz Fischer | Sozialdemokratische Partei Österreichs 973 | |||
136 | 136 | 136 | Austria 59 | 2004-07-08 | 2010-04-25 | 16906 | Heinz Fischer | Sozialdemokratische Partei Österreichs 973 | |||
135 | 135 | 135 | Croatia 62 | 2010-02-18 | 2015-02-15 | 17068 | Ivo Josipović | Socijaldemokratska partija Hrvatske 1493 | |||
134 | 134 | 134 | Cyprus 51 | 1988-02-28 | 1993-02-28 | 17054 | George Vasiliou | Enomeni Dimokrates 1523 | |||
133 | 133 | 133 | Finland 67 | 1994-03-01 | 2000-03-01 | 17063 | Martti Ahtisaari | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
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 | |||
131 | 131 | 131 | Iceland 56 | 1964-01-01 | 1968-08-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
130 | 130 | 130 | Iceland 56 | 1960-01-01 | 1964-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 | |||
128 | 128 | 128 | Iceland 56 | 1952-08-01 | 1956-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
127 | 127 | 127 | Ireland 37 | 1990-12-03 | 1997-09-12 | 17077 | Mary Robinson | Labour Party 318 | |||
126 | 126 | 126 | Czech Republic 68 | 2013-03-08 | 2018-01-27 | 11721 | Miloš Zeman | Strana práv občanů – Zemanovci 406 | |||
125 | 125 | 125 | Switzerland 40 | 1978-01-01 | 1978-12-31 | 1691 | Willy Ritschard | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
124 | 124 | 124 | Switzerland 40 | 1983-01-01 | 1983-12-31 | 677 | Pierre Aubert | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
123 | 123 | 123 | Romania 23 | 1992-10-11 | 1996-11-29 | 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 | |||
121 | 121 | 121 | Romania 23 | 1989-12-26 | 1990-05-20 | 17099 | Ion Iliescu | Partidul Democrat 419 | |||
120 | 120 | 120 | Malta 72 | 1989-04-04 | 1994-04-04 | 8235 | Vincent Tabone | Partit Nazzjonalista 984 | |||
119 | 119 | 119 | Ireland 37 | 1952-01-01 | 1959-06-24 | 17078 | Seán T. O'Kelly | Fianna Fáil 280 | |||
118 | 118 | 118 | Ireland 37 | 1945-06-24 | 1952-01-01 | 17078 | Seán T. O'Kelly | Fianna Fáil 280 | |||
117 | 117 | 117 | Hungary 39 | 2010-08-06 | 2012-04-02 | 17074 | Pál Schmitt | Fidesz – Magyar Polgári Szövetség 921 | |||
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 | |||
115 | 115 | 115 | Estonia 75 | 2011-08-29 | 2016-10-10 | 10876 | Toomas Hendrik Ilves | Sotsiaaldemokraatlik Erakond | Mõõdukad 1448 | |||
114 | 114 | 114 | Estonia 75 | 2006-10-09 | 2011-08-29 | 10876 | Toomas Hendrik Ilves | Sotsiaaldemokraatlik Erakond | Mõõdukad 1448 | |||
113 | 113 | 113 | France 43 | 1947-01-16 | 1954-01-16 | 6513 | Vincent Auriol | Parti socialiste 1539 | |||
112 | 112 | 112 | Switzerland 40 | 1949-01-01 | 1949-12-31 | 1853 | Ernst Nobs | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
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 | |||
110 | 110 | 110 | Greece 41 | 1974-12-18 | 1975-06-19 | 17067 | Michail Stasinopoulos | Néa Đimokratía 47 | |||
109 | 109 | 109 | Switzerland 40 | 1993-01-01 | 1993-12-31 | 2775 | Adolf Ogi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
108 | 108 | 108 | Malta 72 | 1994-04-04 | 1999-04-04 | 4901 | Ugo Mifsud Bonnici | Partit Nazzjonalista 984 | |||
107 | 107 | 107 | Switzerland 40 | 1959-01-01 | 1959-12-31 | 15763 | Paul Chaudet | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
106 | 106 | 106 | France 43 | 1969-06-20 | 1974-04-02 | 12102 | Georges Pompidou | Gaulliste 1094 | |||
105 | 105 | 105 | Latvia 55 | 2011-07-08 | 2015-07-08 | 10508 | Andris Bērziņš | Zaļo un Zemnieku savienība 466 | |||
104 | 104 | 104 | Switzerland 40 | 1950-01-01 | 1950-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
103 | 103 | 103 | Cyprus 51 | 1983-02-13 | 1988-02-28 | 16017 | Spyros Kyprianou | Dimokratikó Kómma 851 | |||
102 | 102 | 102 | Cyprus 51 | 1977-09-03 | 1983-02-13 | 16017 | Spyros Kyprianou | Dimokratikó Kómma 851 | |||
101 | 101 | 101 | Romania 23 | 2009-12-21 | 2014-12-21 | 17100 | Traian Băsescu | Partidul Democrat-Liberal 958 | |||
100 | 100 | 100 | Romania 23 | 2004-12-20 | 2009-12-21 | 17100 | Traian Băsescu | Partidul Democrat-Liberal 958 | |||
99 | 99 | 99 | Austria 59 | 1986-07-08 | 1992-07-08 | 1495 | Kurt Waldheim | Österreichische Volkspartei 1013 | |||
98 | 98 | 98 | Switzerland 40 | 2003-01-01 | 2003-12-31 | 11791 | Pascal Couchepin | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
97 | 97 | 97 | Hungary 39 | 2005-08-05 | 2010-08-06 | 17073 | László Sólyom | független 1617 | |||
96 | 96 | 96 | Switzerland 40 | 1960-01-01 | 1960-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
95 | 95 | 95 | Ireland 37 | 2004-10-01 | 2011-11-10 | 17076 | Mary McAleese | Fianna Fáil 280 | |||
94 | 94 | 94 | Ireland 37 | 1997-11-11 | 2004-10-01 | 17076 | Mary McAleese | Fianna Fáil 280 | |||
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. | ||
92 | 92 | 92 | Lithuania 15 | 1990-03-11 | 1992-11-25 | 2628 | Vytautas Landsbergis | Tėvynės sąjunga 1045 | |||
91 | 91 | 91 | Czech Republic 68 | 2008-02-09 | 2013-03-07 | 14341 | Václav Klaus | Občanská demokratická strana 829 | |||
90 | 90 | 90 | Czech Republic 68 | 2003-03-07 | 2008-02-09 | 14341 | Václav Klaus | Občanská demokratická strana 829 | |||
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 | |||
88 | 88 | 88 | Portugal 63 | 1991-03-09 | 1996-03-09 | 11089 | Mário Soares | Partido Socialista 725 | |||
87 | 87 | 87 | Portugal 63 | 1986-03-09 | 1991-03-09 | 11089 | Mário Soares | Partido Socialista 725 | |||
86 | 86 | 86 | Slovenia 60 | 2002-12-22 | 2007-12-22 | 9847 | Janez Drnovšek | Liberalna demokracija Slovenije 1252 | |||
85 | 85 | 85 | Germany 54 | 1979-07-01 | 1984-06-30 | 2172 | Karl Carstens | Christlich Demokratische Union 808 | |||
84 | 84 | 84 | Estonia 75 | 1996-09-20 | 2001-10-08 | 13837 | Lennart Meri | Rahvuslik Koonderakond "Isamaa" 243 | |||
83 | 83 | 83 | Estonia 75 | 1992-10-06 | 1996-09-20 | 13837 | Lennart Meri | Rahvuslik Koonderakond "Isamaa" 243 | |||
82 | 82 | 82 | Germany 54 | 2010-06-30 | 2012-02-07 | 17058 | Christian Wulff | Christlich Demokratische Union 808 | |||
81 | 81 | 81 | Greece 41 | 1990-05-04 | 1995-03-10 | 2324 | Konstantinos Karamanlis | Néa Đimokratía 47 | |||
80 | 80 | 80 | Austria 59 | 1998-04-19 | 2004-07-06 | 17029 | Thomas Klestil | Österreichische Volkspartei 1013 | |||
79 | 79 | 79 | Austria 59 | 1992-07-08 | 1998-04-19 | 17029 | Thomas Klestil | Österreichische Volkspartei 1013 | |||
78 | 78 | 78 | Malta 72 | 1974-12-13 | 1976-12-27 | 17091 | Anthony Mamo | no party affiliation 1572 | |||
77 | 77 | 77 | Greece 41 | 2010-02-03 | 2015-03-13 | 11021 | Karolos Papoulias | Panellinio Sosialistikó Kínima 1338 | |||
76 | 76 | 76 | Greece 41 | 2005-03-12 | 2010-02-03 | 11021 | Karolos Papoulias | Panellinio Sosialistikó Kínima 1338 | |||
75 | 75 | 75 | Switzerland 40 | 2006-01-01 | 2006-12-31 | 7580 | Moritz Leuenberger | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
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 | |||
73 | 73 | 73 | Greece 41 | 1980-05-15 | 1985-03-10 | 2324 | Konstantinos Karamanlis | Néa Đimokratía 47 | |||
72 | 72 | 72 | Czech Republic 68 | 1998-01-20 | 2003-02-02 | 17057 | Václav Havel | no party affiliation 1567 | |||
71 | 71 | 71 | Czech Republic 68 | 1993-02-02 | 1998-01-20 | 17057 | Václav Havel | no party affiliation 1567 | |||
70 | 70 | 70 | Poland 74 | 2000-10-08 | 2005-12-23 | 17092 | Aleksander Kwaśniewski | Sojusz Lewicy Demokratycznej 629 | |||
69 | 69 | 69 | Poland 74 | 1995-12-23 | 2000-10-08 | 17092 | Aleksander Kwaśniewski | Sojusz Lewicy Demokratycznej 629 | |||
68 | 68 | 68 | Slovenia 60 | 1997-12-23 | 2002-12-22 | 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 | |||
66 | 66 | 66 | Slovenia 60 | 1990-05-10 | 1992-12-06 | 17104 | Milan Kučan | no party affiliation 1370 | |||
65 | 65 | 65 | Switzerland 40 | 1946-01-01 | 1946-12-31 | 10064 | Karl Kobelt | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
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 | |||
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 | |||
62 | 62 | 62 | Ireland 37 | 1966-06-01 | 1973-06-24 | 12332 | Éamon de Valera | Fianna Fáil 280 | |||
61 | 61 | 61 | Ireland 37 | 1959-06-25 | 1966-06-01 | 12332 | Éamon de Valera | Fianna Fáil 280 | |||
60 | 60 | 60 | Slovenia 60 | 2007-12-22 | 2012-12-22 | 17103 | Danilo Türk | no party affiliation 1370 | |||
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 | |||
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. | |
57 | 57 | 57 | Portugal 63 | 2001-03-09 | 2006-03-09 | 17097 | Jorge Sampaio | Partido Socialista 725 | |||
56 | 56 | 56 | Portugal 63 | 1996-03-09 | 2001-03-09 | 17097 | Jorge Sampaio | Partido Socialista 725 | |||
55 | 55 | 55 | Poland 74 | 2005-12-23 | 2010-04-10 | 9684 | Lech Kaczyński | Prawo i Sprawiedliwość 528 | |||
54 | 54 | 54 | Switzerland 40 | 1982-01-01 | 1982-12-31 | 61 | Fritz Honegger | 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 | |||
52 | 52 | 52 | Malta 72 | 1982-02-15 | 1987-02-15 | 15060 | Agatha Barbara | Partit Laburista 1003 | |||
51 | 51 | 51 | Switzerland 40 | 1962-01-01 | 1962-12-31 | 15763 | Paul Chaudet | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
50 | 50 | 50 | Switzerland 40 | 1955-01-01 | 1955-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
49 | 49 | 49 | Iceland 56 | 1992-01-01 | 1996-08-01 | 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 | |||
47 | 47 | 47 | Iceland 56 | 1984-01-01 | 1988-06-25 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
46 | 46 | 46 | Iceland 56 | 1980-08-01 | 1984-01-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
45 | 45 | 45 | Switzerland 40 | 1990-01-01 | 1990-12-31 | 10927 | Arnold Koller | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
44 | 44 | 44 | Italy 26 | 1971-12-24 | 1978-06-15 | 612 | Giovanni Leone | Democrazia Cristiana 1633 |
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]) );