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 |
---|---|---|---|---|---|---|---|---|---|---|---|
301 | 301 | 302 | France 43 | 1920-09-23 | 1924-06-11 | 17155 | Alexandre Millerand | sans étiquette 947 | |||
302 | 302 | 303 | France 43 | 1920-02-18 | 1920-09-21 | 17156 | Paul Deschanel | Républicaine gauche 2587 | |||
303 | 303 | 304 | France 43 | 1913-02-18 | 1920-02-18 | 17157 | Raymond Poincaré | Républicaine gauche 2587 | |||
304 | 304 | 305 | France 43 | 1906-02-18 | 1913-02-18 | 17158 | Armand Fallières | Républicaine gauche 2587 | |||
305 | 305 | 306 | Portugal 63 | 2016-03-09 | 11226 | Rebelo de Sousa, Marcelo | Partido Social Democrata 1273 | 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 | ||||
308 | 308 | 310 | Bulgaria 10 | 2017-01-19 | 17161 | Rumen Radev | Balgarska Sotsialisticheska Partiya 982 | ap | |||
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 | ||
310 | 310 | 312 | Germany 54 | 2017-03-19 | 14726 | Frank-Walter Steinmeier | Sozialdemokratische Partei Deutschlands 558 | reuters | |||
311 | 311 | 313 | France 43 | 2017-06-14 | 17162 | La République En Marche! | Renaissance 2643 | |||||
312 | 312 | 314 | Cyprus 51 | 2018-02-04 | 17056 | Nicos Anastasiades | Dimokratikó Kómma 851 | reuters | |||
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 | ||||
315 | 315 | 317 | Ireland 37 | 2018-11-26 | 10553 | Michael D. Higgins | Labour Party 318 | ||||
316 | 316 | 318 | Slovakia 1 | 2019-06-15 | 17166 | reuters | Progresívne Slovensko 2751 | reuters | |||
317 | 317 | 319 | Lithuania 15 | 2019-07-12 | 17167 | Gitanas Nausėda | no party affiliation 58 | ||||
318 | 318 | 320 | Romania 23 | 2019-12-21 | 17141 | Iohannis, Klaus | Partidul Naţional Liberal 1015 | ||||
319 | 319 | 321 | Switzerland 40 | 2015-01-01 | 2015-12-31 | 17168 | Simonetta Sommaruga | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
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 | |||
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 | |||
322 | 322 | 324 | Switzerland 40 | 2018-01-01 | 2018-12-31 | 17170 | Alain Berset | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
323 | 323 | 325 | Switzerland 40 | 2019-01-01 | 2019-12-31 | 17051 | Ueli Maurer | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
324 | 324 | 326 | Switzerland 40 | 2020-01-01 | 2020-12-31 | 17168 | Simonetta Sommaruga | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
325 | 325 | 327 | Czech Republic 68 | 2018-01-27 | 11721 | Miloš Zeman | Strana práv občanů – Zemanovci 406 | ||||
326 | 326 | 328 | Finland 67 | 2018-01-28 | 6495 | Sauli Niinistö | ei kukaan – ingen 1119 | ||||
327 | 327 | 329 | Greece 41 | 2020-03-13 | 17171 | no party affiliation 1358 | |||||
328 | 328 | 330 | Hungary 39 | 2017-05-08 | 2022-05-09 | 17072 | János Áder | Fidesz – Magyar Polgári Szövetség 921 | |||
329 | 329 | 331 | Latvia 55 | 2019-07-08 | 17172 | no party affiliation 288 | |||||
330 | 330 | 332 | Malta 72 | 2019-04-04 | 17173 | George Vella | Partit Laburista 1003 | ||||
331 | 331 | 333 | Slovenia 60 | 2017-12-22 | 2022-12-22 | 8781 | Borut Pahor | no party affiliation 1370 | |||
332 | 332 | 334 | Turkey 20 | 2018-07-09 | 17139 | Recep Tayyip Erdoğan | Adalet ve Kalkınma Partisi 901 | ||||
333 | 333 | 335 | Croatia 62 | 2020-02-18 | 17174 | Zoran Milanović | Socijaldemokratska partija Hrvatske 1493 | ap | |||
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 | |||||
336 | 336 | 338 | Israel 34 | 2021-07-07 | 17185 | Isaac Herzog | HaMa'arakh | HaAvoda 244 | reuters | |||
337 | 337 | 339 | Iceland 56 | 2020-06-28 | 17159 | no party affiliation 134 | review | ||||
338 | 338 | 340 | Italy 26 | 2022-01-29 | 8465 | Sergio Mattarella | Partito Democratico 382 | reuters | |||
339 | 339 | 341 | Switzerland 40 | 2021-01-01 | 2021-12-31 | 17186 | Guy Parmelin | Schweizerische Volkspartei – Union Démocratique du Centre 750 | afp | ||
340 | 340 | 342 | Hungary 39 | 2022-05-10 | 17187 | Katalin Novák | Fidesz – Magyar Polgári Szövetség 921 | dpa | |||
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 | ||
342 | 342 | 344 | Austria 59 | 2022-10-09 | 10383 | Alexander Van der Bellen | Die Grünen – Die Grüne Alternative 1429 | dpa, reuters | |||
343 | 343 | 345 | Slovenia 60 | 2022-12-23 | 17189 | Nataša Pirc Musar | no party affiliation 1370 | reuters |
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]) );