politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by person_id_source
This data as json, CSV (advanced)
Suggested facets: country_id, data_source, comment, end_date (date)
start_date (date) >30 ✖
- 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
- …
Link | rowid | id | country_id | start_date | end_date | person_id | person_id_source ▼ | party_id | data_source | description | comment |
---|---|---|---|---|---|---|---|---|---|---|---|
290 | 290 | 291 | Poland 74 | 2015-08-06 | 2020-08-06 | 17143 | Prawo i Sprawiedliwość 528 | dpa, reuters | |||
306 | 306 | 308 | Iceland 56 | 2016-08-01 | 2020-06-28 | 17159 | no party affiliation 134 | dpa | |||
307 | 307 | 309 | Estonia 75 | 2016-10-10 | 2021-10-10 | 17160 | Isamaaliit 846 | ||||
311 | 311 | 313 | France 43 | 2017-06-14 | 17162 | La République En Marche! | Renaissance 2643 | |||||
313 | 313 | 315 | Germany 54 | 1919-02-11 | 1925-02-28 | 17164 | Sozialdemokratische Partei Deutschlands 558 | ||||
314 | 314 | 316 | Germany 54 | 1925-05-12 | 1934-08-02 | 17165 | parteilos 610 | ||||
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 | |||||
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 | |||||
337 | 337 | 339 | Iceland 56 | 2020-06-28 | 17159 | no party affiliation 134 | review | ||||
267 | 267 | 268 | Turkey 20 | 2007-08-28 | 2014-08-28 | 17138 | Abdullah Gül | Adalet ve Kalkınma Partisi 901 | |||
109 | 109 | 109 | Switzerland 40 | 1993-01-01 | 1993-12-31 | 2775 | Adolf Ogi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
200 | 200 | 200 | Switzerland 40 | 2000-01-01 | 2000-12-31 | 2775 | Adolf Ogi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
226 | 226 | 226 | Austria 59 | 1957-05-22 | 1963-04-28 | 16653 | Adolf Schärf | Sozialdemokratische Partei Österreichs 973 | |||
227 | 227 | 227 | Austria 59 | 1963-04-28 | 1965-02-28 | 16653 | Adolf Schärf | Sozialdemokratische Partei Österreichs 973 | |||
52 | 52 | 52 | Malta 72 | 1982-02-15 | 1987-02-15 | 15060 | Agatha Barbara | Partit Laburista 1003 | |||
266 | 266 | 267 | Turkey 20 | 2000-05-15 | 2007-08-28 | 17140 | Ahmet Necdet Sezer | bağımsız 1399 | |||
322 | 322 | 324 | Switzerland 40 | 2018-01-01 | 2018-12-31 | 17170 | Alain Berset | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
298 | 298 | 299 | France 43 | 1932-05-10 | 1940-07-11 | 17152 | Albert Lebrun | Républicaine gauche 2587 | |||
69 | 69 | 69 | Poland 74 | 1995-12-23 | 2000-10-08 | 17092 | Aleksander Kwaśniewski | Sojusz Lewicy Demokratycznej 629 | |||
70 | 70 | 70 | Poland 74 | 2000-10-08 | 2005-12-23 | 17092 | Aleksander Kwaśniewski | Sojusz Lewicy Demokratycznej 629 | |||
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 | |||
301 | 301 | 302 | France 43 | 1920-09-23 | 1924-06-11 | 17155 | Alexandre Millerand | sans étiquette 947 | |||
251 | 251 | 251 | Lithuania 15 | 1992-11-25 | 1998-02-25 | 1634 | Algirdas Brazauskas | Lietuvos demokratinė darbo partija 519 | |||
211 | 211 | 211 | Switzerland 40 | 1986-01-01 | 1986-12-31 | 7150 | Alphons Egli | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
262 | 262 | 263 | Slovakia 1 | 2014-06-15 | 2019-06-15 | 17123 | Andrej Kiska | no party affiliation 1359 | |||
105 | 105 | 105 | Latvia 55 | 2011-07-08 | 2015-07-08 | 10508 | Andris Bērziņš | Zaļo un Zemnieku savienība 466 | |||
78 | 78 | 78 | Malta 72 | 1974-12-13 | 1976-12-27 | 17091 | Anthony Mamo | no party affiliation 1572 | |||
30 | 30 | 30 | Malta 72 | 1976-12-27 | 1981-12-27 | 5990 | Anton Buttigieg | Partit Laburista 1003 | |||
238 | 238 | 238 | Italy 26 | 1962-05-06 | 1964-08-10 | 8529 | Antonio Segni | Democrazia Cristiana 1633 | |||
163 | 163 | 163 | Portugal 63 | 1976-07-14 | 1981-03-09 | 17096 | António Ramalho Eanes | no party affiliation 729 | |||
164 | 164 | 164 | Portugal 63 | 1981-03-09 | 1986-03-09 | 17096 | António Ramalho Eanes | Partido Renovador Democrático 341 | |||
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 | |||
39 | 39 | 39 | Cyprus 51 | 1960-08-16 | 1974-07-15 | 17052 | Archbishop Makarios III | no party affiliation 534 | |||
203 | 203 | 203 | Cyprus 51 | 1974-12-08 | 1977-08-03 | 17052 | Archbishop Makarios III | no party affiliation 534 | |||
304 | 304 | 305 | France 43 | 1906-02-18 | 1913-02-18 | 17158 | Armand Fallières | Républicaine gauche 2587 | |||
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 | |||
178 | 178 | 178 | Switzerland 40 | 1997-01-01 | 1997-12-31 | 10927 | Arnold Koller | 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. | |
180 | 180 | 180 | Slovenia 60 | 2012-12-22 | 2017-12-22 | 8781 | Borut Pahor | Združena lista – Socialni demokrati 706 | |||
331 | 331 | 333 | Slovenia 60 | 2017-12-22 | 2022-12-22 | 8781 | Borut Pahor | no party affiliation 1370 | |||
190 | 190 | 190 | Poland 74 | 2010-08-06 | 2015-08-06 | 17093 | Bronisław Komorowski | Platforma Obywatelska 512 | |||
202 | 202 | 202 | Finland 67 | 1944-08-04 | 1946-03-04 | 17050 | Carl Gustaf Emil Mannerheim | ei kukaan – ingen 1119 | |||
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. | ||
2 | 2 | 2 | Ireland 37 | 1974-12-19 | 1976-10-22 | 17075 | Cearbhall Ó Dálaigh | no party affiliation 30 | |||
278 | 278 | 279 | Israel 34 | 1983-05-05 | 1988-02-23 | 17129 | Chaim Herzog | HaMa'arakh | HaAvoda 244 | |||
279 | 279 | 280 | Israel 34 | 1988-02-23 | 1993-05-13 | 17129 | Chaim Herzog | HaMa'arakh | HaAvoda 244 | |||
269 | 269 | 270 | Israel 34 | 1949-02-17 | 1951-11-25 | 17124 | Chaim Weizmann | no party affiliation 123 | |||
270 | 270 | 271 | Israel 34 | 1951-11-25 | 1952-11-09 | 17124 | Chaim Weizmann | no party affiliation 123 | |||
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 | |||
82 | 82 | 82 | Germany 54 | 2010-06-30 | 2012-02-07 | 17058 | Christian Wulff | Christlich Demokratische Union 808 | |||
36 | 36 | 36 | Greece 41 | 1985-03-30 | 1990-05-04 | 17064 | Christos Sartzetakis | no party affiliation 1358 | |||
239 | 239 | 239 | Lithuania 15 | 2009-07-12 | 2014-05-25 | 1266 | Dalia Grybauskaitė | no party affiliation 58 | |||
260 | 260 | 261 | Lithuania 15 | 2014-05-25 | 2019-07-12 | 1266 | Dalia Grybauskaitė | no party affiliation 58 | |||
60 | 60 | 60 | Slovenia 60 | 2007-12-22 | 2012-12-22 | 17103 | Danilo Türk | no party affiliation 1370 | |||
259 | 259 | 260 | Switzerland 40 | 2014-01-01 | 2014-12-31 | 17105 | Didier Burkhalter | 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 | |||
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 | |||
321 | 321 | 323 | Switzerland 40 | 2017-01-01 | 2017-12-31 | 17048 | Doris Leuthard | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
154 | 154 | 154 | Switzerland 40 | 1945-01-01 | 1945-12-31 | 9930 | Eduard von Steiger | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
179 | 179 | 179 | Switzerland 40 | 1951-01-01 | 1951-12-31 | 9930 | Eduard von Steiger | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
17 | 17 | 17 | Malta 72 | 2004-04-04 | 2009-04-04 | 11793 | Edward Fenech Adami | Partit Nazzjonalista 984 | |||
34 | 34 | 34 | Romania 23 | 1996-11-29 | 2000-12-20 | 17098 | Emil Constantinescu | Convenţia Democrată Română 356 | |||
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 | |||
11 | 11 | 11 | Italy 26 | 1946-06-28 | 1947-06-25 | 17083 | Enrico De Nicola | Partito Liberale Italiano 487 | |||
12 | 12 | 12 | Italy 26 | 1947-06-25 | 1948-05-11 | 17083 | Enrico De Nicola | Partito Liberale Italiano 487 | |||
276 | 276 | 277 | Israel 34 | 1973-05-24 | 1978-05-29 | 17127 | Ephraim Katzir | HaMa'arakh | HaAvoda 244 | |||
232 | 232 | 232 | Switzerland 40 | 1974-01-01 | 1974-12-31 | 3877 | Ernst Brugger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
112 | 112 | 112 | Switzerland 40 | 1949-01-01 | 1949-12-31 | 1853 | Ernst Nobs | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
229 | 229 | 229 | Ireland 37 | 1973-06-25 | 1974-11-17 | 15420 | Erskine Hamilton Childers | Fianna Fáil 280 | |||
257 | 257 | 257 | Switzerland 40 | 2012-01-01 | 2012-12-31 | 17049 | Eveline Widmer-Schlumpf | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
280 | 280 | 281 | Israel 34 | 1993-05-13 | 1998-03-04 | 17130 | Ezer Weizman | HaMa'arakh | HaAvoda 244 | |||
281 | 281 | 282 | Israel 34 | 1998-04-03 | 2000-07-13 | 17130 | Ezer Weizman | HaMa'arakh | HaAvoda 244 | |||
169 | 169 | 169 | Hungary 39 | 2000-08-04 | 2005-08-05 | 17071 | Ferenc Mádl | független 1617 | |||
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 | |||
222 | 222 | 222 | Switzerland 40 | 1991-01-01 | 1991-12-31 | 14732 | Flavio Cotti | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
155 | 155 | 155 | Italy 26 | 1985-06-23 | 1992-04-28 | 11964 | Francesco Cossiga | Democrazia Cristiana 1633 | |||
310 | 310 | 312 | Germany 54 | 2017-03-19 | 14726 | Frank-Walter Steinmeier | Sozialdemokratische Partei Deutschlands 558 | reuters | |||
234 | 234 | 234 | Austria 59 | 1965-06-09 | 1971-04-25 | 6238 | Franz Jonas | Sozialdemokratische Partei Österreichs 973 | |||
235 | 235 | 235 | Austria 59 | 1971-04-25 | 1974-04-24 | 6238 | Franz Jonas | Sozialdemokratische Partei Österreichs 973 | |||
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 | |||
5 | 5 | 5 | Switzerland 40 | 1961-01-01 | 1961-12-31 | 3131 | Friedrich Traugott Wahlen | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
54 | 54 | 54 | Switzerland 40 | 1982-01-01 | 1982-12-31 | 61 | Fritz Honegger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
300 | 300 | 301 | France 43 | 1924-06-13 | 1931-06-13 | 17154 | Gaston Doumergue | Parti radical-socialiste 401 | |||
215 | 215 | 215 | Malta 72 | 2009-04-04 | 2014-04-04 | 17090 | George Abela | Partit Laburista 1003 | |||
134 | 134 | 134 | Cyprus 51 | 1988-02-28 | 1993-02-28 | 17054 | George Vasiliou | Enomeni Dimokrates 1523 | |||
330 | 330 | 332 | Malta 72 | 2019-04-04 | 17173 | George Vella | Partit Laburista 1003 | ||||
106 | 106 | 106 | France 43 | 1969-06-20 | 1974-04-02 | 12102 | Georges Pompidou | Gaulliste 1094 | |||
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 | |||
158 | 158 | 158 | Bulgaria 10 | 2002-01-22 | 2006-10-29 | 17030 | Georgi Parvanov | Balgarska Sotsialisticheska Partiya 982 | |||
159 | 159 | 159 | Bulgaria 10 | 2006-10-29 | 2012-01-22 | 17030 | Georgi Parvanov | Balgarska Sotsialisticheska Partiya 982 | |||
174 | 174 | 174 | Italy 26 | 2006-05-15 | 2013-04-20 | 5240 | Giorgio Napolitano | Democratici di Sinistra 809 | |||
175 | 175 | 175 | Italy 26 | 2013-04-20 | 2015-01-14 | 5240 | Giorgio Napolitano | senzo partito 1552 | |||
147 | 147 | 147 | Italy 26 | 1955-04-24 | 1962-05-06 | 17084 | Giovanni Gronchi | 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]) );