politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|
243 | 243 | 243 | Bulgaria 10 | 1990-08-01 | 1997-01-22 | 17033 | Zhelyu Zhelev | Suyuz na Demokratichnite Sili 423 | |||
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 | |||
241 | 241 | 241 | Malta 72 | 1999-04-04 | 2004-04-04 | 9784 | Guido de Marco | Partit Nazzjonalista 984 | |||
240 | 240 | 240 | Germany 54 | 2012-03-18 | 2017-03-19 | 15583 | Joachim Gauck | parteilos 610 | |||
239 | 239 | 239 | Lithuania 15 | 2009-07-12 | 2014-05-25 | 1266 | Dalia Grybauskaitė | no party affiliation 58 | |||
238 | 238 | 238 | Italy 26 | 1962-05-06 | 1964-08-10 | 8529 | Antonio Segni | Democrazia Cristiana 1633 | |||
237 | 237 | 237 | Cyprus 51 | 1998-02-15 | 2003-02-28 | 17055 | Glafcos Clerides | Dimokratikó Kómma 851 | |||
236 | 236 | 236 | Cyprus 51 | 1993-02-28 | 1998-02-15 | 17055 | Glafcos Clerides | Dimokratikó Kómma 851 | |||
235 | 235 | 235 | Austria 59 | 1971-04-25 | 1974-04-24 | 6238 | Franz Jonas | Sozialdemokratische Partei Österreichs 973 | |||
234 | 234 | 234 | Austria 59 | 1965-06-09 | 1971-04-25 | 6238 | Franz Jonas | Sozialdemokratische Partei Österreichs 973 | |||
233 | 233 | 233 | Italy 26 | 1978-07-08 | 1985-06-23 | 17085 | Sandro Pertini | Partito Socialista Italiano 1475 | |||
232 | 232 | 232 | Switzerland 40 | 1974-01-01 | 1974-12-31 | 3877 | Ernst Brugger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
231 | 231 | 231 | Switzerland 40 | 1963-01-01 | 1963-12-31 | 1245 | Willy Spühler | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
230 | 230 | 230 | Switzerland 40 | 1956-01-01 | 1956-12-31 | 13646 | Markus Feldmann | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
229 | 229 | 229 | Ireland 37 | 1973-06-25 | 1974-11-17 | 15420 | Erskine Hamilton Childers | Fianna Fáil 280 | |||
228 | 228 | 228 | Switzerland 40 | 1999-01-01 | 1999-12-31 | 14596 | Ruth Dreifuss | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
227 | 227 | 227 | Austria 59 | 1963-04-28 | 1965-02-28 | 16653 | Adolf Schärf | Sozialdemokratische Partei Österreichs 973 | |||
226 | 226 | 226 | Austria 59 | 1957-05-22 | 1963-04-28 | 16653 | Adolf Schärf | Sozialdemokratische Partei Österreichs 973 | |||
225 | 225 | 225 | Switzerland 40 | 2011-01-01 | 2011-12-31 | 10350 | Micheline Calmy-Rey | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
224 | 224 | 224 | Finland 67 | 1988-02-01 | 1994-03-01 | 12508 | Mauno Koivisto | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
223 | 223 | 223 | Finland 67 | 1982-01-27 | 1988-02-01 | 12508 | Mauno Koivisto | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
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 | |||
221 | 221 | 221 | Lithuania 15 | 2003-02-26 | 2004-04-06 | 13551 | Rolandas Paksas | Lietuvos demokratinė darbo partija 519 | |||
220 | 220 | 220 | Finland 67 | 1978-01-16 | 1982-01-27 | 14223 | Urho Kekkonen | Keskusta 94 | |||
219 | 219 | 219 | Finland 67 | 1974-01-01 | 1978-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
218 | 218 | 218 | Finland 67 | 1968-01-16 | 1974-01-01 | 14223 | Urho Kekkonen | Keskusta 94 | |||
217 | 217 | 217 | Finland 67 | 1962-01-16 | 1968-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
216 | 216 | 216 | Finland 67 | 1956-03-01 | 1962-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
215 | 215 | 215 | Malta 72 | 2009-04-04 | 2014-04-04 | 17090 | George Abela | Partit Laburista 1003 | |||
214 | 214 | 214 | Finland 67 | 2006-01-29 | 2012-03-01 | 5505 | Tarja Halonen | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
213 | 213 | 213 | Finland 67 | 2000-03-01 | 2006-01-29 | 5505 | Tarja Halonen | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
212 | 212 | 212 | Germany 54 | 1999-07-01 | 2004-06-30 | 17060 | Johannes Rau | Sozialdemokratische Partei Deutschlands 558 | |||
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 | |||
210 | 210 | 210 | Ireland 37 | 1983-01-01 | 1990-12-02 | 16552 | Patrick Hillery | Fianna Fáil 280 | |||
209 | 209 | 209 | Ireland 37 | 1976-12-03 | 1983-01-01 | 16552 | Patrick Hillery | Fianna Fáil 280 | |||
208 | 208 | 208 | Germany 54 | 1994-07-01 | 1999-06-30 | 17061 | Roman Herzog | Christlich Demokratische Union 808 | |||
207 | 207 | 207 | Lithuania 15 | 2004-07-12 | 2009-07-12 | 17087 | Valdas Adamkus | no party affiliation 58 | |||
206 | 206 | 206 | France 43 | 1988-05-08 | 1995-05-17 | 13638 | François Mitterrand | Parti socialiste 1539 | |||
205 | 205 | 205 | France 43 | 1981-05-21 | 1988-05-08 | 13638 | François Mitterrand | Parti socialiste 1539 | |||
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 | |||
203 | 203 | 203 | Cyprus 51 | 1974-12-08 | 1977-08-03 | 17052 | Archbishop Makarios III | no party affiliation 534 | |||
202 | 202 | 202 | Finland 67 | 1944-08-04 | 1946-03-04 | 17050 | Carl Gustaf Emil Mannerheim | ei kukaan – ingen 1119 | |||
201 | 201 | 201 | Switzerland 40 | 1975-01-01 | 1975-12-31 | 14075 | Pierre Graber | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
200 | 200 | 200 | Switzerland 40 | 2000-01-01 | 2000-12-31 | 2775 | Adolf Ogi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
199 | 199 | 199 | Switzerland 40 | 1994-01-01 | 1994-12-31 | 7645 | Otto Stich | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
198 | 198 | 198 | Germany 54 | 1974-07-01 | 1979-06-30 | 6567 | Walter Scheel | Freie Demokratische Partei 543 | |||
197 | 197 | 197 | Hungary 39 | 2012-05-10 | 2017-05-08 | 17072 | János Áder | Fidesz – Magyar Polgári Szövetség 921 | |||
196 | 196 | 196 | France 43 | 1965-12-19 | 1969-04-28 | 11223 | Charles de Gaulle | Gaulliste 1094 | |||
195 | 195 | 195 | France 43 | 1959-01-08 | 1965-12-19 | 11223 | Charles de Gaulle | Gaulliste 1094 | |||
194 | 194 | 194 | Switzerland 40 | 1971-01-01 | 1971-12-31 | 11772 | Rudolf Gnägi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
193 | 193 | 193 | Iceland 56 | 1944-06-17 | 1952-01-25 | 17081 | Sveinn Björnsson | no party affiliation 134 | |||
192 | 192 | 192 | Lithuania 15 | 1998-02-26 | 2003-02-26 | 17087 | Valdas Adamkus | no party affiliation 58 | |||
191 | 191 | 191 | Switzerland 40 | 2001-01-01 | 2001-12-31 | 7580 | Moritz Leuenberger | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
190 | 190 | 190 | Poland 74 | 2010-08-06 | 2015-08-06 | 17093 | Bronisław Komorowski | Platforma Obywatelska 512 | |||
189 | 189 | 189 | France 43 | 2012-05-15 | 2017-06-14 | 9979 | François Hollande | Parti socialiste 1539 | |||
188 | 188 | 188 | Switzerland 40 | 1992-01-01 | 1992-12-31 | 13678 | René Felber | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
187 | 187 | 187 | Croatia 62 | 2005-02-28 | 2010-02-18 | 17069 | Stjepan Mesić | Hrvatska narodna stranka – Liberalni demokrati 1384 | |||
186 | 186 | 186 | Croatia 62 | 2000-02-18 | 2005-02-28 | 17069 | Stjepan Mesić | Hrvatska narodna stranka – Liberalni demokrati 1384 | |||
185 | 185 | 185 | Latvia 55 | 1996-06-18 | 1999-07-08 | 17088 | Guntis Ulmanis | Latvijas Zemnieku Savienība 1368 | |||
184 | 184 | 184 | Latvia 55 | 1993-07-07 | 1996-06-18 | 17088 | Guntis Ulmanis | Latvijas Zemnieku Savienība 1368 | |||
183 | 183 | 183 | Switzerland 40 | 2013-01-01 | 2013-12-31 | 17051 | Ueli Maurer | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
182 | 182 | 182 | Switzerland 40 | 1987-01-01 | 1987-12-31 | 677 | Pierre Aubert | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
181 | 181 | 181 | Switzerland 40 | 1953-01-01 | 1953-12-31 | 13717 | Philipp Etter | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
180 | 180 | 180 | Slovenia 60 | 2012-12-22 | 2017-12-22 | 8781 | Borut Pahor | Združena lista – Socialni demokrati 706 | |||
179 | 179 | 179 | Switzerland 40 | 1951-01-01 | 1951-12-31 | 9930 | Eduard von Steiger | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
178 | 178 | 178 | Switzerland 40 | 1997-01-01 | 1997-12-31 | 10927 | Arnold Koller | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
177 | 177 | 177 | Switzerland 40 | 1988-01-01 | 1988-12-31 | 7645 | Otto Stich | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
176 | 176 | 176 | Slovakia 1 | 1999-06-15 | 2004-06-15 | 17102 | Rudolf Schuster | Strana občianskeho porozumenia 1016 | |||
175 | 175 | 175 | Italy 26 | 2013-04-20 | 2015-01-14 | 5240 | Giorgio Napolitano | senzo partito 1552 | |||
174 | 174 | 174 | Italy 26 | 2006-05-15 | 2013-04-20 | 5240 | Giorgio Napolitano | Democratici di Sinistra 809 | |||
173 | 173 | 173 | Germany 54 | 1964-07-01 | 1969-06-30 | 4009 | Heinrich Lübke | Christlich Demokratische Union 808 | |||
172 | 172 | 172 | Germany 54 | 1959-09-12 | 1964-07-01 | 4009 | Heinrich Lübke | Christlich Demokratische Union 808 | |||
171 | 171 | 171 | Hungary 39 | 1995-08-04 | 2000-08-04 | 17070 | Árpád Göncz | Szabad Demokraták Szövetsége 1426 | |||
170 | 170 | 170 | Hungary 39 | 1990-08-04 | 1995-08-04 | 17070 | Árpád Göncz | Szabad Demokraták Szövetsége 1426 | |||
169 | 169 | 169 | Hungary 39 | 2000-08-04 | 2005-08-05 | 17071 | Ferenc Mádl | független 1617 | |||
168 | 168 | 168 | Switzerland 40 | 1965-01-01 | 1965-12-31 | 5600 | Hans-Peter Tschudi | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
167 | 167 | 167 | Switzerland 40 | 2002-01-01 | 2002-12-31 | 14593 | Kaspar Villiger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
166 | 166 | 166 | Italy 26 | 1964-12-28 | 1971-12-24 | 6049 | Giuseppe Saragat | Partito Socialista Democratico Italiano 242 | |||
165 | 165 | 165 | Bulgaria 10 | 1997-01-22 | 2002-01-22 | 17031 | Petar Stoyanov | Suyuz na Demokratichnite Sili 423 | |||
164 | 164 | 164 | Portugal 63 | 1981-03-09 | 1986-03-09 | 17096 | António Ramalho Eanes | Partido Renovador Democrático 341 | |||
163 | 163 | 163 | Portugal 63 | 1976-07-14 | 1981-03-09 | 17096 | António Ramalho Eanes | no party affiliation 729 | |||
162 | 162 | 162 | Greece 41 | 2000-02-08 | 2005-03-12 | 17065 | Konstantinos Stephanopoulos | no party affiliation 1358 | |||
161 | 161 | 161 | Greece 41 | 1995-03-10 | 2000-02-08 | 17065 | Konstantinos Stephanopoulos | no party affiliation 1358 | |||
160 | 160 | 160 | Switzerland 40 | 1948-01-01 | 1948-12-31 | 16326 | Enrico Celio | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
159 | 159 | 159 | Bulgaria 10 | 2006-10-29 | 2012-01-22 | 17030 | Georgi Parvanov | Balgarska Sotsialisticheska Partiya 982 | |||
158 | 158 | 158 | Bulgaria 10 | 2002-01-22 | 2006-10-29 | 17030 | Georgi Parvanov | Balgarska Sotsialisticheska Partiya 982 | |||
157 | 157 | 157 | Germany 54 | 2009-05-23 | 2010-05-31 | 17059 | Horst Köhler | Christlich Demokratische Union 808 | |||
156 | 156 | 156 | Germany 54 | 2004-07-01 | 2009-05-23 | 17059 | Horst Köhler | Christlich Demokratische Union 808 | |||
155 | 155 | 155 | Italy 26 | 1985-06-23 | 1992-04-28 | 11964 | Francesco Cossiga | Democrazia Cristiana 1633 | |||
154 | 154 | 154 | Switzerland 40 | 1945-01-01 | 1945-12-31 | 9930 | Eduard von Steiger | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
153 | 153 | 153 | Austria 59 | 1945-04-29 | 1950-12-31 | 5373 | Karl Renner | Sozialdemokratische Partei Österreichs 973 | |||
152 | 152 | 152 | Switzerland 40 | 1981-01-01 | 1981-12-31 | 15161 | Kurt Furgler | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
151 | 151 | 151 | Portugal 63 | 2011-03-09 | 2016-03-09 | 2839 | Aníbal Cavaco Silva | Partido Social Democrata 1273 | |||
150 | 150 | 150 | Portugal 63 | 2006-03-09 | 2011-03-09 | 2839 | Aníbal Cavaco Silva | Partido Social Democrata 1273 | |||
149 | 149 | 149 | Switzerland 40 | 1968-01-01 | 1968-12-31 | 1245 | Willy Spühler | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
148 | 148 | 148 | Germany 54 | 1969-07-01 | 1974-06-30 | 8422 | Gustav Heinemann | Sozialdemokratische Partei Deutschlands 558 | nyt | President Heinemann was elected (yes: 512, no: 506, abstain: 3) on 5 March 1969 with votes from the Social Democrats (SPD) and Free Democrats (FDP). | |
147 | 147 | 147 | Italy 26 | 1955-04-24 | 1962-05-06 | 17084 | Giovanni Gronchi | Democrazia Cristiana 1633 | |||
146 | 146 | 146 | Iceland 56 | 1976-01-01 | 1980-08-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 | |||
144 | 144 | 144 | Iceland 56 | 1968-08-01 | 1972-01-01 | 17080 | Kristján Eldjárn | no party affiliation 134 |
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]) );