politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by country_id descending
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
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. | |
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 | |||
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 | |||
307 | 307 | 309 | Estonia 75 | 2016-10-10 | 2021-10-10 | 17160 | Isamaaliit 846 | ||||
335 | 335 | 337 | Estonia 75 | 2021-10-11 | 17184 | no party affiliation 426 | |||||
3 | 3 | 3 | Poland 74 | 1989-12-31 | 1990-12-22 | 17095 | Wojciech Jaruzelski | Polska Zjednoczone Partia Robotnicza 1077 | |||
14 | 14 | 14 | Poland 74 | 1990-12-22 | 1995-12-22 | 17094 | Lech Wałęsa | Solidarność 108 | |||
55 | 55 | 55 | Poland 74 | 2005-12-23 | 2010-04-10 | 9684 | Lech Kaczyński | Prawo i Sprawiedliwość 528 | |||
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 | |||
190 | 190 | 190 | Poland 74 | 2010-08-06 | 2015-08-06 | 17093 | Bronisław Komorowski | Platforma Obywatelska 512 | |||
290 | 290 | 291 | Poland 74 | 2015-08-06 | 2020-08-06 | 17143 | Prawo i Sprawiedliwość 528 | dpa, reuters | |||
334 | 334 | 336 | Poland 74 | 2020-08-06 | 17143 | Prawo i Sprawiedliwość 528 | dpa | ||||
17 | 17 | 17 | Malta 72 | 2004-04-04 | 2009-04-04 | 11793 | Edward Fenech Adami | Partit Nazzjonalista 984 | |||
30 | 30 | 30 | Malta 72 | 1976-12-27 | 1981-12-27 | 5990 | Anton Buttigieg | Partit Laburista 1003 | |||
52 | 52 | 52 | Malta 72 | 1982-02-15 | 1987-02-15 | 15060 | Agatha Barbara | Partit Laburista 1003 | |||
78 | 78 | 78 | Malta 72 | 1974-12-13 | 1976-12-27 | 17091 | Anthony Mamo | no party affiliation 1572 | |||
108 | 108 | 108 | Malta 72 | 1994-04-04 | 1999-04-04 | 4901 | Ugo Mifsud Bonnici | Partit Nazzjonalista 984 | |||
120 | 120 | 120 | Malta 72 | 1989-04-04 | 1994-04-04 | 8235 | Vincent Tabone | Partit Nazzjonalista 984 | |||
215 | 215 | 215 | Malta 72 | 2009-04-04 | 2014-04-04 | 17090 | George Abela | Partit Laburista 1003 | |||
241 | 241 | 241 | Malta 72 | 1999-04-04 | 2004-04-04 | 9784 | Guido de Marco | Partit Nazzjonalista 984 | |||
261 | 261 | 262 | Malta 72 | 2014-04-04 | 2019-04-04 | 17122 | Marie Louise Coleiro Preca | Partit Laburista 1003 | |||
330 | 330 | 332 | Malta 72 | 2019-04-04 | 17173 | George Vella | Partit Laburista 1003 | ||||
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 | |||
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 | |||
126 | 126 | 126 | Czech Republic 68 | 2013-03-08 | 2018-01-27 | 11721 | Miloš Zeman | Strana práv občanů – Zemanovci 406 | |||
325 | 325 | 327 | Czech Republic 68 | 2018-01-27 | 11721 | Miloš Zeman | Strana práv občanů – Zemanovci 406 | ||||
20 | 20 | 20 | Finland 67 | 2012-03-01 | 2018-01-28 | 6495 | Sauli Niinistö | Kansallinen Kokoomus – Samlingspartiet 1118 | |||
133 | 133 | 133 | Finland 67 | 1994-03-01 | 2000-03-01 | 17063 | Martti Ahtisaari | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
202 | 202 | 202 | Finland 67 | 1944-08-04 | 1946-03-04 | 17050 | Carl Gustaf Emil Mannerheim | ei kukaan – ingen 1119 | |||
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 | |||
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 | |||
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 | |||
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 | |||
292 | 292 | 293 | Finland 67 | 1925-03-02 | 1931-03-02 | 17145 | Lauri Kristian Relander | Keskusta 94 | no-2010 | ||
293 | 293 | 294 | Finland 67 | 1931-03-02 | 1937-03-01 | 17147 | Pehr Evind Svinhufvud | Kansallinen Kokoomus – Samlingspartiet 1118 | no-2010 | ||
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 | ||
296 | 296 | 297 | Finland 67 | 1919-07-26 | 1925-03-02 | 17150 | Kaarlo Juho Ståhlberg | Kansallinen Edistyspuolue | [Suomen] Liberaalinen Kansanpuolue 1219 | no-2010 | ||
326 | 326 | 328 | Finland 67 | 2018-01-28 | 6495 | Sauli Niinistö | ei kukaan – ingen 1119 | ||||
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 | |||
87 | 87 | 87 | Portugal 63 | 1986-03-09 | 1991-03-09 | 11089 | Mário Soares | Partido Socialista 725 | |||
88 | 88 | 88 | Portugal 63 | 1991-03-09 | 1996-03-09 | 11089 | Mário Soares | Partido Socialista 725 | |||
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 | |||
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 | |||
305 | 305 | 306 | Portugal 63 | 2016-03-09 | 11226 | Rebelo de Sousa, Marcelo | Partido Social Democrata 1273 | reuters | |||
135 | 135 | 135 | Croatia 62 | 2010-02-18 | 2015-02-15 | 17068 | Ivo Josipović | Socijaldemokratska partija Hrvatske 1493 | |||
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 | |||
287 | 287 | 288 | Croatia 62 | 2015-02-15 | 2020-02-18 | 17142 | Kolinda Grabar-Kitarovic | Hrvatska demokratska zajednica 276 | reuters | ||
333 | 333 | 335 | Croatia 62 | 2020-02-18 | 17174 | Zoran Milanović | Socijaldemokratska partija Hrvatske 1493 | ap | |||
60 | 60 | 60 | Slovenia 60 | 2007-12-22 | 2012-12-22 | 17103 | Danilo Türk | no party affiliation 1370 | |||
66 | 66 | 66 | Slovenia 60 | 1990-05-10 | 1992-12-06 | 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 | |||
68 | 68 | 68 | Slovenia 60 | 1997-12-23 | 2002-12-22 | 17104 | Milan Kučan | no party affiliation 1370 | |||
86 | 86 | 86 | Slovenia 60 | 2002-12-22 | 2007-12-22 | 9847 | Janez Drnovšek | Liberalna demokracija Slovenije 1252 | |||
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 | |||
343 | 343 | 345 | Slovenia 60 | 2022-12-23 | 17189 | Nataša Pirc Musar | no party affiliation 1370 | reuters | |||
4 | 4 | 4 | Austria 59 | 1951-06-21 | 1957-01-04 | 12553 | Theodor Körner | Sozialdemokratische Partei Österreichs 973 | |||
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 | |||
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 | |||
99 | 99 | 99 | Austria 59 | 1986-07-08 | 1992-07-08 | 1495 | Kurt Waldheim | Österreichische Volkspartei 1013 | |||
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 | |||
153 | 153 | 153 | Austria 59 | 1945-04-29 | 1950-12-31 | 5373 | Karl Renner | Sozialdemokratische Partei Österreichs 973 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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]) );