parlgov
Data source: ParlGov · About: simonw/parlgov-datasette
rowid | id | country_id | start_date | end_date | person_id | person_id_source | party_id | data_source | description | comment |
---|---|---|---|---|---|---|---|---|---|---|
341 | 343 | 40 | 2022-01-01 | 2022-12-31 | 17188 | Ignazio Cassis | 26 | dpa | ||
331 | 333 | 60 | 2017-12-22 | 2022-12-22 | 8781 | Borut Pahor | 1370 | |||
309 | 311 | 59 | 2017-01-26 | 2022-10-09 | 10383 | Alexander Van der Bellen | 1429 | reuters | ||
328 | 330 | 39 | 2017-05-08 | 2022-05-09 | 17072 | János Áder | 921 | |||
286 | 287 | 26 | 2015-02-03 | 2022-01-29 | 8465 | Sergio Mattarella | 382 | reuters | Mattarella was one of the founders of the Democratic Party (PD) in 2007 and was officially endorsed by the party. | |
339 | 341 | 40 | 2021-01-01 | 2021-12-31 | 17186 | Guy Parmelin | 750 | afp | ||
307 | 309 | 75 | 2016-10-10 | 2021-10-10 | 17160 | 846 | ||||
284 | 285 | 34 | 2014-07-24 | 2021-07-07 | 17133 | Reuven Rivlin | 678 | |||
324 | 326 | 40 | 2020-01-01 | 2020-12-31 | 17168 | Simonetta Sommaruga | 35 | |||
290 | 291 | 74 | 2015-08-06 | 2020-08-06 | 17143 | 528 | dpa, reuters | |||
306 | 308 | 56 | 2016-08-01 | 2020-06-28 | 17159 | 134 | dpa | |||
288 | 289 | 41 | 2015-03-13 | 2020-03-13 | 12516 | Prokopis Pavlopoulos | 47 | |||
287 | 288 | 62 | 2015-02-15 | 2020-02-18 | 17142 | Kolinda Grabar-Kitarovic | 276 | reuters | ||
323 | 325 | 40 | 2019-01-01 | 2019-12-31 | 17051 | Ueli Maurer | 750 | |||
285 | 286 | 23 | 2014-12-21 | 2019-12-21 | 17141 | Iohannis, Klaus | 1015 | |||
260 | 261 | 15 | 2014-05-25 | 2019-07-12 | 1266 | Dalia Grybauskaitė | 58 | |||
289 | 290 | 55 | 2015-07-08 | 2019-07-08 | 5018 | Raimonds Vejonis | 466 | reuters | ||
262 | 263 | 1 | 2014-06-15 | 2019-06-15 | 17123 | Andrej Kiska | 1359 | |||
261 | 262 | 72 | 2014-04-04 | 2019-04-04 | 17122 | Marie Louise Coleiro Preca | 1003 | |||
322 | 324 | 40 | 2018-01-01 | 2018-12-31 | 17170 | Alain Berset | 35 | |||
246 | 246 | 37 | 2011-11-11 | 2018-11-26 | 10553 | Michael D. Higgins | 318 | |||
268 | 269 | 20 | 2014-08-28 | 2018-07-09 | 17139 | Recep Tayyip Erdoğan | 901 | |||
10 | 10 | 51 | 2013-02-28 | 2018-02-04 | 17056 | Nicos Anastasiades | 851 | |||
20 | 20 | 67 | 2012-03-01 | 2018-01-28 | 6495 | Sauli Niinistö | 1118 | |||
126 | 126 | 68 | 2013-03-08 | 2018-01-27 | 11721 | Miloš Zeman | 406 | |||
321 | 323 | 40 | 2017-01-01 | 2017-12-31 | 17048 | Doris Leuthard | 531 | |||
180 | 180 | 60 | 2012-12-22 | 2017-12-22 | 8781 | Borut Pahor | 706 | |||
189 | 189 | 43 | 2012-05-15 | 2017-06-14 | 9979 | François Hollande | 1539 | |||
197 | 197 | 39 | 2012-05-10 | 2017-05-08 | 17072 | János Áder | 921 | |||
240 | 240 | 54 | 2012-03-18 | 2017-03-19 | 15583 | Joachim Gauck | 610 | |||
247 | 247 | 10 | 2012-01-22 | 2017-01-19 | 17032 | Rosen Plevneliev | 1541 | |||
320 | 322 | 40 | 2016-01-01 | 2016-12-31 | 17169 | Johann Schneider-Ammann | 26 | |||
115 | 115 | 75 | 2011-08-29 | 2016-10-10 | 10876 | Toomas Hendrik Ilves | 1448 | |||
29 | 29 | 56 | 2012-06-30 | 2016-08-01 | 2403 | Ólafur Ragnar Grímsson | 1360 | |||
137 | 137 | 59 | 2010-04-25 | 2016-05-21 | 16906 | Heinz Fischer | 973 | |||
151 | 151 | 63 | 2011-03-09 | 2016-03-09 | 2839 | Aníbal Cavaco Silva | 1273 | |||
319 | 321 | 40 | 2015-01-01 | 2015-12-31 | 17168 | Simonetta Sommaruga | 35 | |||
190 | 190 | 74 | 2010-08-06 | 2015-08-06 | 17093 | Bronisław Komorowski | 512 | |||
105 | 105 | 55 | 2011-07-08 | 2015-07-08 | 10508 | Andris Bērziņš | 466 | |||
77 | 77 | 41 | 2010-02-03 | 2015-03-13 | 11021 | Karolos Papoulias | 1338 | |||
135 | 135 | 62 | 2010-02-18 | 2015-02-15 | 17068 | Ivo Josipović | 1493 | |||
175 | 175 | 26 | 2013-04-20 | 2015-01-14 | 5240 | Giorgio Napolitano | 1552 | |||
259 | 260 | 40 | 2014-01-01 | 2014-12-31 | 17105 | Didier Burkhalter | 26 | |||
101 | 101 | 23 | 2009-12-21 | 2014-12-21 | 17100 | Traian Băsescu | 958 | |||
267 | 268 | 20 | 2007-08-28 | 2014-08-28 | 17138 | Abdullah Gül | 901 | |||
283 | 284 | 34 | 2007-07-15 | 2014-07-24 | 17132 | Shimon Peres | 1870 | |||
23 | 23 | 1 | 2009-04-04 | 2014-06-15 | 17101 | Ivan Gašparovič | 2160 | |||
239 | 239 | 15 | 2009-07-12 | 2014-05-25 | 1266 | Dalia Grybauskaitė | 58 | |||
215 | 215 | 72 | 2009-04-04 | 2014-04-04 | 17090 | George Abela | 1003 | |||
183 | 183 | 40 | 2013-01-01 | 2013-12-31 | 17051 | Ueli Maurer | 750 | |||
174 | 174 | 26 | 2006-05-15 | 2013-04-20 | 5240 | Giorgio Napolitano | 809 | |||
91 | 91 | 68 | 2008-02-09 | 2013-03-07 | 14341 | Václav Klaus | 829 | |||
142 | 142 | 51 | 2008-02-28 | 2013-02-28 | 17053 | Dimitris Christofias | 572 | |||
257 | 257 | 40 | 2012-01-01 | 2012-12-31 | 17049 | Eveline Widmer-Schlumpf | 750 | |||
60 | 60 | 60 | 2007-12-22 | 2012-12-22 | 17103 | Danilo Türk | 1370 | |||
28 | 28 | 56 | 2008-06-28 | 2012-06-30 | 2403 | Ólafur Ragnar Grímsson | 1360 | |||
255 | 255 | 43 | 2007-05-16 | 2012-05-15 | 4507 | Nicolas Sarkozy | 658 | |||
117 | 117 | 39 | 2010-08-06 | 2012-04-02 | 17074 | Pál Schmitt | 921 | |||
214 | 214 | 67 | 2006-01-29 | 2012-03-01 | 5505 | Tarja Halonen | 395 | |||
82 | 82 | 54 | 2010-06-30 | 2012-02-07 | 17058 | Christian Wulff | 808 | |||
159 | 159 | 10 | 2006-10-29 | 2012-01-22 | 17030 | Georgi Parvanov | 982 | |||
225 | 225 | 40 | 2011-01-01 | 2011-12-31 | 10350 | Micheline Calmy-Rey | 35 | |||
95 | 95 | 37 | 2004-10-01 | 2011-11-10 | 17076 | Mary McAleese | 280 | |||
114 | 114 | 75 | 2006-10-09 | 2011-08-29 | 10876 | Toomas Hendrik Ilves | 1448 | |||
291 | 292 | 55 | 2007-07-08 | 2011-07-08 | 17144 | Valdis Zatlers | 288 | |||
150 | 150 | 63 | 2006-03-09 | 2011-03-09 | 2839 | Aníbal Cavaco Silva | 1273 | |||
139 | 139 | 40 | 2010-01-01 | 2010-12-31 | 17048 | Doris Leuthard | 531 | |||
97 | 97 | 39 | 2005-08-05 | 2010-08-06 | 17073 | László Sólyom | 1617 | |||
157 | 157 | 54 | 2009-05-23 | 2010-05-31 | 17059 | Horst Köhler | 808 | |||
136 | 136 | 59 | 2004-07-08 | 2010-04-25 | 16906 | Heinz Fischer | 973 | |||
55 | 55 | 74 | 2005-12-23 | 2010-04-10 | 9684 | Lech Kaczyński | 528 | |||
187 | 187 | 62 | 2005-02-28 | 2010-02-18 | 17069 | Stjepan Mesić | 1384 | |||
76 | 76 | 41 | 2005-03-12 | 2010-02-03 | 11021 | Karolos Papoulias | 1338 | |||
63 | 63 | 40 | 2009-01-01 | 2009-12-31 | 14793 | Hans-Rudolf Merz | 26 | |||
100 | 100 | 23 | 2004-12-20 | 2009-12-21 | 17100 | Traian Băsescu | 958 | |||
207 | 207 | 15 | 2004-07-12 | 2009-07-12 | 17087 | Valdas Adamkus | 58 | |||
156 | 156 | 54 | 2004-07-01 | 2009-05-23 | 17059 | Horst Köhler | 808 | |||
17 | 17 | 72 | 2004-04-04 | 2009-04-04 | 11793 | Edward Fenech Adami | 984 | |||
22 | 22 | 1 | 2004-06-15 | 2009-04-04 | 17101 | Ivan Gašparovič | 2160 | |||
6 | 6 | 40 | 2008-01-01 | 2008-12-31 | 11791 | Pascal Couchepin | 26 | |||
27 | 27 | 56 | 2004-06-26 | 2008-06-28 | 2403 | Ólafur Ragnar Grímsson | 1360 | |||
256 | 256 | 51 | 2003-02-28 | 2008-02-28 | 4856 | Tassos Papadopoulos | 851 | |||
90 | 90 | 68 | 2003-03-07 | 2008-02-09 | 14341 | Václav Klaus | 829 | |||
138 | 138 | 40 | 2007-01-01 | 2007-12-31 | 10350 | Micheline Calmy-Rey | 35 | |||
86 | 86 | 60 | 2002-12-22 | 2007-12-22 | 9847 | Janez Drnovšek | 1252 | |||
266 | 267 | 20 | 2000-05-15 | 2007-08-28 | 17140 | Ahmet Necdet Sezer | 1399 | |||
32 | 32 | 55 | 2003-06-20 | 2007-07-08 | 17089 | Vaira Vīķe-Freiberga | 288 | |||
282 | 283 | 34 | 2000-08-01 | 2007-07-01 | 17131 | Moshe Katsav | 678 | |||
250 | 250 | 43 | 2002-05-05 | 2007-05-16 | 1103 | Jacques Chirac | 658 | |||
75 | 75 | 40 | 2006-01-01 | 2006-12-31 | 7580 | Moritz Leuenberger | 35 | |||
158 | 158 | 10 | 2002-01-22 | 2006-10-29 | 17030 | Georgi Parvanov | 982 | |||
58 | 58 | 75 | 2001-10-08 | 2006-10-09 | 17062 | Arnold Rüütel | 417 | reuters | President Rüütel was elected (yes: 186, no: 155) on 21 September 2001. | |
93 | 93 | 26 | 1999-05-13 | 2006-05-15 | 8419 | Carlo Azeglio Ciampi | 1552 | Previously a Governor of the Bank of Italy and PM of a technical cabinet. | ||
57 | 57 | 63 | 2001-03-09 | 2006-03-09 | 17097 | Jorge Sampaio | 725 | |||
213 | 213 | 67 | 2000-03-01 | 2006-01-29 | 5505 | Tarja Halonen | 395 | |||
40 | 40 | 40 | 2005-01-01 | 2005-12-31 | 7606 | Samuel Schmid | 750 | |||
70 | 70 | 74 | 2000-10-08 | 2005-12-23 | 17092 | Aleksander Kwaśniewski | 629 | |||
169 | 169 | 39 | 2000-08-04 | 2005-08-05 | 17071 | Ferenc Mádl | 1617 | |||
162 | 162 | 41 | 2000-02-08 | 2005-03-12 | 17065 | Konstantinos Stephanopoulos | 1358 | |||
186 | 186 | 62 | 2000-02-18 | 2005-02-28 | 17069 | Stjepan Mesić | 1384 | |||
204 | 204 | 40 | 2004-01-01 | 2004-12-31 | 9888 | Joseph Deiss | 531 |