politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by party_id
This data as json, CSV (advanced)
Suggested facets: country_id, description, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 1 | Switzerland 40 | 1966-01-01 | 1966-12-31 | 7243 | Hans Schaffner | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
6 | 6 | 6 | Switzerland 40 | 2008-01-01 | 2008-12-31 | 11791 | Pascal Couchepin | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
18 | 18 | 18 | Switzerland 40 | 1995-01-01 | 1995-12-31 | 14593 | Kaspar Villiger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
24 | 24 | 24 | Switzerland 40 | 1972-01-01 | 1972-12-31 | 10045 | Nello Celio | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
33 | 33 | 33 | Switzerland 40 | 1952-01-01 | 1952-12-31 | 10064 | Karl Kobelt | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
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 | |||
50 | 50 | 50 | Switzerland 40 | 1955-01-01 | 1955-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
51 | 51 | 51 | Switzerland 40 | 1962-01-01 | 1962-12-31 | 15763 | Paul Chaudet | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
54 | 54 | 54 | Switzerland 40 | 1982-01-01 | 1982-12-31 | 61 | Fritz Honegger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
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 | |||
65 | 65 | 65 | Switzerland 40 | 1946-01-01 | 1946-12-31 | 10064 | Karl Kobelt | 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 | |||
98 | 98 | 98 | Switzerland 40 | 2003-01-01 | 2003-12-31 | 11791 | Pascal Couchepin | 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 | |||
107 | 107 | 107 | Switzerland 40 | 1959-01-01 | 1959-12-31 | 15763 | Paul Chaudet | 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 | |||
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 | |||
143 | 143 | 143 | Switzerland 40 | 1957-01-01 | 1957-12-31 | 2097 | Hans Streuli | 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 | |||
232 | 232 | 232 | Switzerland 40 | 1974-01-01 | 1974-12-31 | 3877 | Ernst Brugger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
258 | 258 | 258 | Switzerland 40 | 1954-01-01 | 1954-12-31 | 4722 | Rodolphe Rubattel | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
259 | 259 | 260 | Switzerland 40 | 2014-01-01 | 2014-12-31 | 17105 | Didier Burkhalter | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
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 | |||
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 | ||
2 | 2 | 2 | Ireland 37 | 1974-12-19 | 1976-10-22 | 17075 | Cearbhall Ó Dálaigh | no party affiliation 30 | |||
43 | 43 | 43 | Switzerland 40 | 1970-01-01 | 1970-12-31 | 5600 | Hans-Peter Tschudi | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
75 | 75 | 75 | Switzerland 40 | 2006-01-01 | 2006-12-31 | 7580 | Moritz Leuenberger | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
112 | 112 | 112 | Switzerland 40 | 1949-01-01 | 1949-12-31 | 1853 | Ernst Nobs | 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 | |||
125 | 125 | 125 | Switzerland 40 | 1978-01-01 | 1978-12-31 | 1691 | Willy Ritschard | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
138 | 138 | 138 | Switzerland 40 | 2007-01-01 | 2007-12-31 | 10350 | Micheline Calmy-Rey | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
149 | 149 | 149 | Switzerland 40 | 1968-01-01 | 1968-12-31 | 1245 | Willy Spühler | 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 | |||
177 | 177 | 177 | Switzerland 40 | 1988-01-01 | 1988-12-31 | 7645 | Otto Stich | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
182 | 182 | 182 | Switzerland 40 | 1987-01-01 | 1987-12-31 | 677 | Pierre Aubert | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
188 | 188 | 188 | Switzerland 40 | 1992-01-01 | 1992-12-31 | 13678 | René Felber | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
191 | 191 | 191 | Switzerland 40 | 2001-01-01 | 2001-12-31 | 7580 | Moritz Leuenberger | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
199 | 199 | 199 | Switzerland 40 | 1994-01-01 | 1994-12-31 | 7645 | Otto Stich | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
201 | 201 | 201 | Switzerland 40 | 1975-01-01 | 1975-12-31 | 14075 | Pierre Graber | 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 | |||
228 | 228 | 228 | Switzerland 40 | 1999-01-01 | 1999-12-31 | 14596 | Ruth Dreifuss | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
231 | 231 | 231 | Switzerland 40 | 1963-01-01 | 1963-12-31 | 1245 | Willy Spühler | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
319 | 319 | 321 | Switzerland 40 | 2015-01-01 | 2015-12-31 | 17168 | Simonetta Sommaruga | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
322 | 322 | 324 | Switzerland 40 | 2018-01-01 | 2018-12-31 | 17170 | Alain Berset | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
324 | 324 | 326 | Switzerland 40 | 2020-01-01 | 2020-12-31 | 17168 | Simonetta Sommaruga | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
21 | 21 | 21 | Greece 41 | 1975-06-20 | 1980-05-15 | 17066 | Konstantinos Tsatsos | Néa Đimokratía 47 | |||
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 | |||
110 | 110 | 110 | Greece 41 | 1974-12-18 | 1975-06-19 | 17067 | Michail Stasinopoulos | Néa Đimokratía 47 | |||
288 | 288 | 289 | Greece 41 | 2015-03-13 | 2020-03-13 | 12516 | Prokopis Pavlopoulos | Néa Đimokratía 47 | |||
192 | 192 | 192 | Lithuania 15 | 1998-02-26 | 2003-02-26 | 17087 | Valdas Adamkus | no party affiliation 58 | |||
207 | 207 | 207 | Lithuania 15 | 2004-07-12 | 2009-07-12 | 17087 | Valdas Adamkus | no party affiliation 58 | |||
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 | |||
317 | 317 | 319 | Lithuania 15 | 2019-07-12 | 17167 | Gitanas Nausėda | no party affiliation 58 | ||||
248 | 248 | 248 | France 43 | 1974-05-27 | 1981-05-21 | 8320 | Valéry Giscard d'Estaing | Independants républicains | Démocratie libérale 59 | |||
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 | |||
292 | 292 | 293 | Finland 67 | 1925-03-02 | 1931-03-02 | 17145 | Lauri Kristian Relander | Keskusta 94 | no-2010 | ||
294 | 294 | 295 | Finland 67 | 1937-03-01 | 1940-12-19 | 17148 | Kyösti Kallio | Keskusta 94 | |||
14 | 14 | 14 | Poland 74 | 1990-12-22 | 1995-12-22 | 17094 | Lech Wałęsa | Solidarność 108 | |||
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 | |||
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 | |||
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 | |||
193 | 193 | 193 | Iceland 56 | 1944-06-17 | 1952-01-25 | 17081 | Sveinn Björnsson | no party affiliation 134 | |||
306 | 306 | 308 | Iceland 56 | 2016-08-01 | 2020-06-28 | 17159 | no party affiliation 134 | dpa | |||
337 | 337 | 339 | Iceland 56 | 2020-06-28 | 17159 | no party affiliation 134 | review | ||||
249 | 249 | 249 | France 43 | 1995-05-17 | 2002-05-05 | 1103 | Jacques Chirac | Rassemblement pour la république 138 | |||
166 | 166 | 166 | Italy 26 | 1964-12-28 | 1971-12-24 | 6049 | Giuseppe Saragat | Partito Socialista Democratico Italiano 242 | |||
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 | |||
271 | 271 | 272 | Israel 34 | 1952-12-16 | 1957-10-28 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
272 | 272 | 273 | Israel 34 | 1957-10-28 | 1962-10-30 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
273 | 273 | 274 | Israel 34 | 1962-10-30 | 1963-04-23 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
274 | 274 | 275 | Israel 34 | 1963-05-21 | 1968-03-26 | 17126 | Zalman Shazar | HaMa'arakh | HaAvoda 244 | |||
275 | 275 | 276 | Israel 34 | 1968-03-26 | 1973-05-24 | 17126 | Zalman Shazar | HaMa'arakh | HaAvoda 244 | |||
276 | 276 | 277 | Israel 34 | 1973-05-24 | 1978-05-29 | 17127 | Ephraim Katzir | HaMa'arakh | HaAvoda 244 | |||
277 | 277 | 278 | Israel 34 | 1978-05-29 | 1983-05-05 | 17128 | Yitzhak Navon | HaMa'arakh | HaAvoda 244 | |||
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 | |||
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 | |||
336 | 336 | 338 | Israel 34 | 2021-07-07 | 17185 | Isaac Herzog | HaMa'arakh | HaAvoda 244 | reuters | |||
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 | |||
287 | 287 | 288 | Croatia 62 | 2015-02-15 | 2020-02-18 | 17142 | Kolinda Grabar-Kitarovic | Hrvatska demokratska zajednica 276 | reuters | ||
61 | 61 | 61 | Ireland 37 | 1959-06-25 | 1966-06-01 | 12332 | Éamon de Valera | Fianna Fáil 280 | |||
62 | 62 | 62 | Ireland 37 | 1966-06-01 | 1973-06-24 | 12332 | Éamon de Valera | Fianna Fáil 280 | |||
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 | |||
118 | 118 | 118 | Ireland 37 | 1945-06-24 | 1952-01-01 | 17078 | Seán T. O'Kelly | Fianna Fáil 280 |
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]) );