politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
201 | 201 | 201 | Switzerland 40 | 1975-01-01 | 1975-12-31 | 14075 | Pierre Graber | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
202 | 202 | 202 | Finland 67 | 1944-08-04 | 1946-03-04 | 17050 | Carl Gustaf Emil Mannerheim | ei kukaan – ingen 1119 | |||
203 | 203 | 203 | Cyprus 51 | 1974-12-08 | 1977-08-03 | 17052 | Archbishop Makarios III | no party affiliation 534 | |||
204 | 204 | 204 | Switzerland 40 | 2004-01-01 | 2004-12-31 | 9888 | Joseph Deiss | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
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 | |||
207 | 207 | 207 | Lithuania 15 | 2004-07-12 | 2009-07-12 | 17087 | Valdas Adamkus | no party affiliation 58 | |||
208 | 208 | 208 | Germany 54 | 1994-07-01 | 1999-06-30 | 17061 | Roman Herzog | Christlich Demokratische Union 808 | |||
209 | 209 | 209 | Ireland 37 | 1976-12-03 | 1983-01-01 | 16552 | Patrick Hillery | Fianna Fáil 280 | |||
210 | 210 | 210 | Ireland 37 | 1983-01-01 | 1990-12-02 | 16552 | Patrick Hillery | Fianna Fáil 280 | |||
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 | |||
212 | 212 | 212 | Germany 54 | 1999-07-01 | 2004-06-30 | 17060 | Johannes Rau | Sozialdemokratische Partei Deutschlands 558 | |||
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 | |||
215 | 215 | 215 | Malta 72 | 2009-04-04 | 2014-04-04 | 17090 | George Abela | Partit Laburista 1003 | |||
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 | |||
221 | 221 | 221 | Lithuania 15 | 2003-02-26 | 2004-04-06 | 13551 | Rolandas Paksas | Lietuvos demokratinė darbo partija 519 | |||
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 | |||
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 | |||
225 | 225 | 225 | Switzerland 40 | 2011-01-01 | 2011-12-31 | 10350 | Micheline Calmy-Rey | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
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 | |||
228 | 228 | 228 | Switzerland 40 | 1999-01-01 | 1999-12-31 | 14596 | Ruth Dreifuss | 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 | |||
230 | 230 | 230 | Switzerland 40 | 1956-01-01 | 1956-12-31 | 13646 | Markus Feldmann | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
231 | 231 | 231 | Switzerland 40 | 1963-01-01 | 1963-12-31 | 1245 | Willy Spühler | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
232 | 232 | 232 | Switzerland 40 | 1974-01-01 | 1974-12-31 | 3877 | Ernst Brugger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
233 | 233 | 233 | Italy 26 | 1978-07-08 | 1985-06-23 | 17085 | Sandro Pertini | Partito Socialista Italiano 1475 | |||
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 | |||
236 | 236 | 236 | Cyprus 51 | 1993-02-28 | 1998-02-15 | 17055 | Glafcos Clerides | Dimokratikó Kómma 851 | |||
237 | 237 | 237 | Cyprus 51 | 1998-02-15 | 2003-02-28 | 17055 | Glafcos Clerides | Dimokratikó Kómma 851 | |||
238 | 238 | 238 | Italy 26 | 1962-05-06 | 1964-08-10 | 8529 | Antonio Segni | Democrazia Cristiana 1633 | |||
239 | 239 | 239 | Lithuania 15 | 2009-07-12 | 2014-05-25 | 1266 | Dalia Grybauskaitė | no party affiliation 58 | |||
240 | 240 | 240 | Germany 54 | 2012-03-18 | 2017-03-19 | 15583 | Joachim Gauck | parteilos 610 | |||
241 | 241 | 241 | Malta 72 | 1999-04-04 | 2004-04-04 | 9784 | Guido de Marco | Partit Nazzjonalista 984 | |||
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 | |||
243 | 243 | 243 | Bulgaria 10 | 1990-08-01 | 1997-01-22 | 17033 | Zhelyu Zhelev | Suyuz na Demokratichnite Sili 423 | |||
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 | |||
246 | 246 | 246 | Ireland 37 | 2011-11-11 | 2018-11-26 | 10553 | Michael D. Higgins | Labour Party 318 | |||
247 | 247 | 247 | Bulgaria 10 | 2012-01-22 | 2017-01-19 | 17032 | Rosen Plevneliev | Grazhdani za Evropeysko Razvitie na Balgariya 1541 | |||
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 | |||
249 | 249 | 249 | France 43 | 1995-05-17 | 2002-05-05 | 1103 | Jacques Chirac | Rassemblement pour la république 138 | |||
250 | 250 | 250 | France 43 | 2002-05-05 | 2007-05-16 | 1103 | Jacques Chirac | Union pour un mouvement populaire | Les Républicains 658 | |||
251 | 251 | 251 | Lithuania 15 | 1992-11-25 | 1998-02-25 | 1634 | Algirdas Brazauskas | Lietuvos demokratinė darbo partija 519 | |||
252 | 252 | 252 | Slovakia 1 | 1993-03-02 | 1998-03-02 | 16261 | Michal Kováč | Hnutie za demokratické Slovensko 1142 | |||
253 | 253 | 253 | Germany 54 | 1949-09-13 | 1954-07-17 | 5953 | Theodor Heuss | Freie Demokratische Partei 543 | |||
254 | 254 | 254 | Germany 54 | 1954-07-17 | 1959-09-12 | 5953 | Theodor Heuss | Freie Demokratische Partei 543 | |||
255 | 255 | 255 | France 43 | 2007-05-16 | 2012-05-15 | 4507 | Nicolas Sarkozy | Union pour un mouvement populaire | Les Républicains 658 | |||
256 | 256 | 256 | Cyprus 51 | 2003-02-28 | 2008-02-28 | 4856 | Tassos Papadopoulos | Dimokratikó Kómma 851 | |||
257 | 257 | 257 | Switzerland 40 | 2012-01-01 | 2012-12-31 | 17049 | Eveline Widmer-Schlumpf | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
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 | |||
260 | 260 | 261 | Lithuania 15 | 2014-05-25 | 2019-07-12 | 1266 | Dalia Grybauskaitė | no party affiliation 58 | |||
261 | 261 | 262 | Malta 72 | 2014-04-04 | 2019-04-04 | 17122 | Marie Louise Coleiro Preca | Partit Laburista 1003 | |||
262 | 262 | 263 | Slovakia 1 | 2014-06-15 | 2019-06-15 | 17123 | Andrej Kiska | no party affiliation 1359 | |||
263 | 263 | 264 | Turkey 20 | 1982-11-09 | 1989-11-09 | 17134 | Kenan Evren | bağımsız 1399 | |||
264 | 264 | 265 | Turkey 20 | 1989-11-09 | 1993-04-17 | 17135 | Turgut Özal | Anavatan Partisi 1334 | |||
265 | 265 | 266 | Turkey 20 | 1993-05-16 | 2000-05-16 | 17136 | Süleyman Demirel | Doğru Yol Partisi 1141 | |||
266 | 266 | 267 | Turkey 20 | 2000-05-15 | 2007-08-28 | 17140 | Ahmet Necdet Sezer | bağımsız 1399 | |||
267 | 267 | 268 | Turkey 20 | 2007-08-28 | 2014-08-28 | 17138 | Abdullah Gül | Adalet ve Kalkınma Partisi 901 | |||
268 | 268 | 269 | Turkey 20 | 2014-08-28 | 2018-07-09 | 17139 | Recep Tayyip Erdoğan | Adalet ve Kalkınma Partisi 901 | |||
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 | |||
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 | |||
282 | 282 | 283 | Israel 34 | 2000-08-01 | 2007-07-01 | 17131 | Moshe Katsav | Likud 678 | |||
283 | 283 | 284 | Israel 34 | 2007-07-15 | 2014-07-24 | 17132 | Shimon Peres | Kadima 1870 | |||
284 | 284 | 285 | Israel 34 | 2014-07-24 | 2021-07-07 | 17133 | Reuven Rivlin | Likud 678 | |||
285 | 285 | 286 | Romania 23 | 2014-12-21 | 2019-12-21 | 17141 | Iohannis, Klaus | Partidul Naţional Liberal 1015 | |||
286 | 286 | 287 | Italy 26 | 2015-02-03 | 2022-01-29 | 8465 | Sergio Mattarella | Partito Democratico 382 | reuters | Mattarella was one of the founders of the Democratic Party (PD) in 2007 and was officially endorsed by the party. | |
287 | 287 | 288 | Croatia 62 | 2015-02-15 | 2020-02-18 | 17142 | Kolinda Grabar-Kitarovic | Hrvatska demokratska zajednica 276 | reuters | ||
288 | 288 | 289 | Greece 41 | 2015-03-13 | 2020-03-13 | 12516 | Prokopis Pavlopoulos | Néa Đimokratía 47 | |||
289 | 289 | 290 | Latvia 55 | 2015-07-08 | 2019-07-08 | 5018 | Raimonds Vejonis | Zaļo un Zemnieku savienība 466 | reuters | ||
290 | 290 | 291 | Poland 74 | 2015-08-06 | 2020-08-06 | 17143 | Prawo i Sprawiedliwość 528 | dpa, reuters | |||
291 | 291 | 292 | Latvia 55 | 2007-07-08 | 2011-07-08 | 17144 | Valdis Zatlers | no party affiliation 288 | |||
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 | ||
297 | 297 | 298 | France 43 | 1940-07-11 | 1944-08-09 | 17151 | Philippe Pétain | sans étiquette 947 | |||
298 | 298 | 299 | France 43 | 1932-05-10 | 1940-07-11 | 17152 | Albert Lebrun | Républicaine gauche 2587 | |||
299 | 299 | 300 | France 43 | 1931-06-13 | 1932-05-07 | 17153 | Paul Doumer | Parti radical-socialiste 401 | |||
300 | 300 | 301 | France 43 | 1924-06-13 | 1931-06-13 | 17154 | Gaston Doumergue | Parti radical-socialiste 401 |
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]) );