politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by end_date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
259 | 259 | 260 | Switzerland 40 | 2014-01-01 | 2014-12-31 | 17105 | Didier Burkhalter | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
175 | 175 | 175 | Italy 26 | 2013-04-20 | 2015-01-14 | 5240 | Giorgio Napolitano | senzo partito 1552 | |||
135 | 135 | 135 | Croatia 62 | 2010-02-18 | 2015-02-15 | 17068 | Ivo Josipović | Socijaldemokratska partija Hrvatske 1493 | |||
77 | 77 | 77 | Greece 41 | 2010-02-03 | 2015-03-13 | 11021 | Karolos Papoulias | Panellinio Sosialistikó Kínima 1338 | |||
105 | 105 | 105 | Latvia 55 | 2011-07-08 | 2015-07-08 | 10508 | Andris Bērziņš | Zaļo un Zemnieku savienība 466 | |||
190 | 190 | 190 | Poland 74 | 2010-08-06 | 2015-08-06 | 17093 | Bronisław Komorowski | Platforma Obywatelska 512 | |||
319 | 319 | 321 | Switzerland 40 | 2015-01-01 | 2015-12-31 | 17168 | Simonetta Sommaruga | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
151 | 151 | 151 | Portugal 63 | 2011-03-09 | 2016-03-09 | 2839 | Aníbal Cavaco Silva | Partido Social Democrata 1273 | |||
137 | 137 | 137 | Austria 59 | 2010-04-25 | 2016-05-21 | 16906 | Heinz Fischer | Sozialdemokratische Partei Österreichs 973 | |||
29 | 29 | 29 | Iceland 56 | 2012-06-30 | 2016-08-01 | 2403 | Ólafur Ragnar Grímsson | Alþýðubandalagið 1360 | |||
115 | 115 | 115 | Estonia 75 | 2011-08-29 | 2016-10-10 | 10876 | Toomas Hendrik Ilves | Sotsiaaldemokraatlik Erakond | Mõõdukad 1448 | |||
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 | |||
247 | 247 | 247 | Bulgaria 10 | 2012-01-22 | 2017-01-19 | 17032 | Rosen Plevneliev | Grazhdani za Evropeysko Razvitie na Balgariya 1541 | |||
240 | 240 | 240 | Germany 54 | 2012-03-18 | 2017-03-19 | 15583 | Joachim Gauck | parteilos 610 | |||
197 | 197 | 197 | Hungary 39 | 2012-05-10 | 2017-05-08 | 17072 | János Áder | Fidesz – Magyar Polgári Szövetség 921 | |||
189 | 189 | 189 | France 43 | 2012-05-15 | 2017-06-14 | 9979 | François Hollande | Parti socialiste 1539 | |||
180 | 180 | 180 | Slovenia 60 | 2012-12-22 | 2017-12-22 | 8781 | Borut Pahor | Združena lista – Socialni demokrati 706 | |||
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 | |||
126 | 126 | 126 | Czech Republic 68 | 2013-03-08 | 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 | |||
10 | 10 | 10 | Cyprus 51 | 2013-02-28 | 2018-02-04 | 17056 | Nicos Anastasiades | Dimokratikó Kómma 851 | |||
268 | 268 | 269 | Turkey 20 | 2014-08-28 | 2018-07-09 | 17139 | Recep Tayyip Erdoğan | Adalet ve Kalkınma Partisi 901 | |||
246 | 246 | 246 | Ireland 37 | 2011-11-11 | 2018-11-26 | 10553 | Michael D. Higgins | Labour Party 318 | |||
322 | 322 | 324 | Switzerland 40 | 2018-01-01 | 2018-12-31 | 17170 | Alain Berset | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
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 | |||
289 | 289 | 290 | Latvia 55 | 2015-07-08 | 2019-07-08 | 5018 | Raimonds Vejonis | Zaļo un Zemnieku savienība 466 | reuters | ||
260 | 260 | 261 | Lithuania 15 | 2014-05-25 | 2019-07-12 | 1266 | Dalia Grybauskaitė | no party affiliation 58 | |||
285 | 285 | 286 | Romania 23 | 2014-12-21 | 2019-12-21 | 17141 | Iohannis, Klaus | Partidul Naţional Liberal 1015 | |||
323 | 323 | 325 | Switzerland 40 | 2019-01-01 | 2019-12-31 | 17051 | Ueli Maurer | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
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 | |||
306 | 306 | 308 | Iceland 56 | 2016-08-01 | 2020-06-28 | 17159 | no party affiliation 134 | dpa | |||
290 | 290 | 291 | Poland 74 | 2015-08-06 | 2020-08-06 | 17143 | Prawo i Sprawiedliwość 528 | dpa, reuters | |||
324 | 324 | 326 | Switzerland 40 | 2020-01-01 | 2020-12-31 | 17168 | Simonetta Sommaruga | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
284 | 284 | 285 | Israel 34 | 2014-07-24 | 2021-07-07 | 17133 | Reuven Rivlin | Likud 678 | |||
307 | 307 | 309 | Estonia 75 | 2016-10-10 | 2021-10-10 | 17160 | Isamaaliit 846 | ||||
339 | 339 | 341 | Switzerland 40 | 2021-01-01 | 2021-12-31 | 17186 | Guy Parmelin | Schweizerische Volkspartei – Union Démocratique du Centre 750 | afp | ||
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. | |
328 | 328 | 330 | Hungary 39 | 2017-05-08 | 2022-05-09 | 17072 | János Áder | Fidesz – Magyar Polgári Szövetség 921 | |||
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 | ||
331 | 331 | 333 | Slovenia 60 | 2017-12-22 | 2022-12-22 | 8781 | Borut Pahor | no party affiliation 1370 | |||
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 |
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]) );