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 |
---|---|---|---|---|---|---|---|---|---|---|---|
43 | 43 | 43 | Switzerland 40 | 1970-01-01 | 1970-12-31 | 5600 | Hans-Peter Tschudi | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
234 | 234 | 234 | Austria 59 | 1965-06-09 | 1971-04-25 | 6238 | Franz Jonas | Sozialdemokratische Partei Österreichs 973 | |||
166 | 166 | 166 | Italy 26 | 1964-12-28 | 1971-12-24 | 6049 | Giuseppe Saragat | Partito Socialista Democratico Italiano 242 | |||
194 | 194 | 194 | Switzerland 40 | 1971-01-01 | 1971-12-31 | 11772 | Rudolf Gnägi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
144 | 144 | 144 | Iceland 56 | 1968-08-01 | 1972-01-01 | 17080 | Kristján Eldjárn | no party affiliation 134 | |||
24 | 24 | 24 | Switzerland 40 | 1972-01-01 | 1972-12-31 | 10045 | Nello Celio | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
275 | 275 | 276 | Israel 34 | 1968-03-26 | 1973-05-24 | 17126 | Zalman Shazar | HaMa'arakh | HaAvoda 244 | |||
62 | 62 | 62 | Ireland 37 | 1966-06-01 | 1973-06-24 | 12332 | Éamon de Valera | Fianna Fáil 280 | |||
42 | 42 | 42 | Switzerland 40 | 1973-01-01 | 1973-12-31 | 6582 | Roger Bonvin | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
218 | 218 | 218 | Finland 67 | 1968-01-16 | 1974-01-01 | 14223 | Urho Kekkonen | Keskusta 94 | |||
106 | 106 | 106 | France 43 | 1969-06-20 | 1974-04-02 | 12102 | Georges Pompidou | Gaulliste 1094 | |||
235 | 235 | 235 | Austria 59 | 1971-04-25 | 1974-04-24 | 6238 | Franz Jonas | Sozialdemokratische Partei Österreichs 973 | |||
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). | |
39 | 39 | 39 | Cyprus 51 | 1960-08-16 | 1974-07-15 | 17052 | Archbishop Makarios III | no party affiliation 534 | |||
229 | 229 | 229 | Ireland 37 | 1973-06-25 | 1974-11-17 | 15420 | Erskine Hamilton Childers | Fianna Fáil 280 | |||
232 | 232 | 232 | Switzerland 40 | 1974-01-01 | 1974-12-31 | 3877 | Ernst Brugger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
110 | 110 | 110 | Greece 41 | 1974-12-18 | 1975-06-19 | 17067 | Michail Stasinopoulos | Néa Đimokratía 47 | |||
201 | 201 | 201 | Switzerland 40 | 1975-01-01 | 1975-12-31 | 14075 | Pierre Graber | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
145 | 145 | 145 | Iceland 56 | 1972-01-01 | 1976-01-01 | 17080 | Kristján Eldjárn | no party affiliation 134 | |||
2 | 2 | 2 | Ireland 37 | 1974-12-19 | 1976-10-22 | 17075 | Cearbhall Ó Dálaigh | no party affiliation 30 | |||
78 | 78 | 78 | Malta 72 | 1974-12-13 | 1976-12-27 | 17091 | Anthony Mamo | no party affiliation 1572 | |||
13 | 13 | 13 | Switzerland 40 | 1976-01-01 | 1976-12-31 | 11772 | Rudolf Gnägi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
203 | 203 | 203 | Cyprus 51 | 1974-12-08 | 1977-08-03 | 17052 | Archbishop Makarios III | no party affiliation 534 | |||
89 | 89 | 89 | Switzerland 40 | 1977-01-01 | 1977-12-31 | 15161 | Kurt Furgler | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
219 | 219 | 219 | Finland 67 | 1974-01-01 | 1978-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
276 | 276 | 277 | Israel 34 | 1973-05-24 | 1978-05-29 | 17127 | Ephraim Katzir | HaMa'arakh | HaAvoda 244 | |||
44 | 44 | 44 | Italy 26 | 1971-12-24 | 1978-06-15 | 612 | Giovanni Leone | Democrazia Cristiana 1633 | |||
125 | 125 | 125 | Switzerland 40 | 1978-01-01 | 1978-12-31 | 1691 | Willy Ritschard | 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 | |||
111 | 111 | 111 | Switzerland 40 | 1979-01-01 | 1979-12-31 | 15713 | Hans Hürlimann | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
21 | 21 | 21 | Greece 41 | 1975-06-20 | 1980-05-15 | 17066 | Konstantinos Tsatsos | Néa Đimokratía 47 | |||
7 | 7 | 7 | Austria 59 | 1974-07-08 | 1980-05-18 | 4021 | Rudolf Kirchschläger | Parteilose 272 | |||
146 | 146 | 146 | Iceland 56 | 1976-01-01 | 1980-08-01 | 17080 | Kristján Eldjárn | no party affiliation 134 | |||
141 | 141 | 141 | Switzerland 40 | 1980-01-01 | 1980-12-31 | 6836 | Georges-André Chevallaz | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
163 | 163 | 163 | Portugal 63 | 1976-07-14 | 1981-03-09 | 17096 | António Ramalho Eanes | no party affiliation 729 | |||
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 | |||
30 | 30 | 30 | Malta 72 | 1976-12-27 | 1981-12-27 | 5990 | Anton Buttigieg | Partit Laburista 1003 | |||
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 | |||
220 | 220 | 220 | Finland 67 | 1978-01-16 | 1982-01-27 | 14223 | Urho Kekkonen | Keskusta 94 | |||
54 | 54 | 54 | Switzerland 40 | 1982-01-01 | 1982-12-31 | 61 | Fritz Honegger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
209 | 209 | 209 | Ireland 37 | 1976-12-03 | 1983-01-01 | 16552 | Patrick Hillery | Fianna Fáil 280 | |||
102 | 102 | 102 | Cyprus 51 | 1977-09-03 | 1983-02-13 | 16017 | Spyros Kyprianou | Dimokratikó Kómma 851 | |||
277 | 277 | 278 | Israel 34 | 1978-05-29 | 1983-05-05 | 17128 | Yitzhak Navon | HaMa'arakh | HaAvoda 244 | |||
124 | 124 | 124 | Switzerland 40 | 1983-01-01 | 1983-12-31 | 677 | Pierre Aubert | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
46 | 46 | 46 | Iceland 56 | 1980-08-01 | 1984-01-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
85 | 85 | 85 | Germany 54 | 1979-07-01 | 1984-06-30 | 2172 | Karl Carstens | Christlich Demokratische Union 808 | |||
15 | 15 | 15 | Switzerland 40 | 1984-01-01 | 1984-12-31 | 11125 | Leon Schlumpf | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
73 | 73 | 73 | Greece 41 | 1980-05-15 | 1985-03-10 | 2324 | Konstantinos Karamanlis | Néa Đimokratía 47 | |||
233 | 233 | 233 | Italy 26 | 1978-07-08 | 1985-06-23 | 17085 | Sandro Pertini | Partito Socialista Italiano 1475 | |||
64 | 64 | 64 | Switzerland 40 | 1985-01-01 | 1985-12-31 | 15161 | Kurt Furgler | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
164 | 164 | 164 | Portugal 63 | 1981-03-09 | 1986-03-09 | 17096 | António Ramalho Eanes | Partido Renovador Democrático 341 | |||
8 | 8 | 8 | Austria 59 | 1980-05-18 | 1986-07-08 | 4021 | Rudolf Kirchschläger | Parteilose 272 | |||
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 | |||
52 | 52 | 52 | Malta 72 | 1982-02-15 | 1987-02-15 | 15060 | Agatha Barbara | Partit Laburista 1003 | |||
182 | 182 | 182 | Switzerland 40 | 1987-01-01 | 1987-12-31 | 677 | Pierre Aubert | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
223 | 223 | 223 | Finland 67 | 1982-01-27 | 1988-02-01 | 12508 | Mauno Koivisto | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
278 | 278 | 279 | Israel 34 | 1983-05-05 | 1988-02-23 | 17129 | Chaim Herzog | HaMa'arakh | HaAvoda 244 | |||
103 | 103 | 103 | Cyprus 51 | 1983-02-13 | 1988-02-28 | 16017 | Spyros Kyprianou | Dimokratikó Kómma 851 | |||
205 | 205 | 205 | France 43 | 1981-05-21 | 1988-05-08 | 13638 | François Mitterrand | Parti socialiste 1539 | |||
47 | 47 | 47 | Iceland 56 | 1984-01-01 | 1988-06-25 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
177 | 177 | 177 | Switzerland 40 | 1988-01-01 | 1988-12-31 | 7645 | Otto Stich | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
37 | 37 | 37 | Germany 54 | 1984-07-01 | 1989-05-23 | 6753 | Richard von Weizsäcker | Christlich Demokratische Union 808 | |||
263 | 263 | 264 | Turkey 20 | 1982-11-09 | 1989-11-09 | 17134 | Kenan Evren | bağımsız 1399 | |||
132 | 132 | 132 | Switzerland 40 | 1989-01-01 | 1989-12-31 | 6502 | Jean-Pascal Delamuraz | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
36 | 36 | 36 | Greece 41 | 1985-03-30 | 1990-05-04 | 17064 | Christos Sartzetakis | no party affiliation 1358 | |||
121 | 121 | 121 | Romania 23 | 1989-12-26 | 1990-05-20 | 17099 | Ion Iliescu | Partidul Democrat 419 | |||
210 | 210 | 210 | Ireland 37 | 1983-01-01 | 1990-12-02 | 16552 | Patrick Hillery | Fianna Fáil 280 | |||
3 | 3 | 3 | Poland 74 | 1989-12-31 | 1990-12-22 | 17095 | Wojciech Jaruzelski | Polska Zjednoczone Partia Robotnicza 1077 | |||
45 | 45 | 45 | Switzerland 40 | 1990-01-01 | 1990-12-31 | 10927 | Arnold Koller | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
87 | 87 | 87 | Portugal 63 | 1986-03-09 | 1991-03-09 | 11089 | Mário Soares | Partido Socialista 725 | |||
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 | |||
48 | 48 | 48 | Iceland 56 | 1988-06-25 | 1992-01-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
155 | 155 | 155 | Italy 26 | 1985-06-23 | 1992-04-28 | 11964 | Francesco Cossiga | Democrazia Cristiana 1633 | |||
99 | 99 | 99 | Austria 59 | 1986-07-08 | 1992-07-08 | 1495 | Kurt Waldheim | Österreichische Volkspartei 1013 | |||
122 | 122 | 122 | Romania 23 | 1990-05-20 | 1992-10-11 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
92 | 92 | 92 | Lithuania 15 | 1990-03-11 | 1992-11-25 | 2628 | Vytautas Landsbergis | Tėvynės sąjunga 1045 | |||
66 | 66 | 66 | Slovenia 60 | 1990-05-10 | 1992-12-06 | 17104 | Milan Kučan | no party affiliation 1370 | |||
188 | 188 | 188 | Switzerland 40 | 1992-01-01 | 1992-12-31 | 13678 | René Felber | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
134 | 134 | 134 | Cyprus 51 | 1988-02-28 | 1993-02-28 | 17054 | George Vasiliou | Enomeni Dimokrates 1523 | |||
264 | 264 | 265 | Turkey 20 | 1989-11-09 | 1993-04-17 | 17135 | Turgut Özal | Anavatan Partisi 1334 | |||
279 | 279 | 280 | Israel 34 | 1988-02-23 | 1993-05-13 | 17129 | Chaim Herzog | HaMa'arakh | HaAvoda 244 | |||
109 | 109 | 109 | Switzerland 40 | 1993-01-01 | 1993-12-31 | 2775 | Adolf Ogi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
224 | 224 | 224 | Finland 67 | 1988-02-01 | 1994-03-01 | 12508 | Mauno Koivisto | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | |||
120 | 120 | 120 | Malta 72 | 1989-04-04 | 1994-04-04 | 8235 | Vincent Tabone | Partit Nazzjonalista 984 | |||
38 | 38 | 38 | Germany 54 | 1989-05-23 | 1994-06-30 | 6753 | Richard von Weizsäcker | Christlich Demokratische Union 808 | |||
199 | 199 | 199 | Switzerland 40 | 1994-01-01 | 1994-12-31 | 7645 | Otto Stich | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
81 | 81 | 81 | Greece 41 | 1990-05-04 | 1995-03-10 | 2324 | Konstantinos Karamanlis | Néa Đimokratía 47 | |||
206 | 206 | 206 | France 43 | 1988-05-08 | 1995-05-17 | 13638 | François Mitterrand | Parti socialiste 1539 | |||
170 | 170 | 170 | Hungary 39 | 1990-08-04 | 1995-08-04 | 17070 | Árpád Göncz | Szabad Demokraták Szövetsége 1426 | |||
14 | 14 | 14 | Poland 74 | 1990-12-22 | 1995-12-22 | 17094 | Lech Wałęsa | Solidarność 108 | |||
18 | 18 | 18 | Switzerland 40 | 1995-01-01 | 1995-12-31 | 14593 | Kaspar Villiger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
88 | 88 | 88 | Portugal 63 | 1991-03-09 | 1996-03-09 | 11089 | Mário Soares | Partido Socialista 725 | |||
184 | 184 | 184 | Latvia 55 | 1993-07-07 | 1996-06-18 | 17088 | Guntis Ulmanis | Latvijas Zemnieku Savienība 1368 | |||
49 | 49 | 49 | Iceland 56 | 1992-01-01 | 1996-08-01 | 17082 | Vigdís Finnbogadóttir | no party affiliation 134 | |||
83 | 83 | 83 | Estonia 75 | 1992-10-06 | 1996-09-20 | 13837 | Lennart Meri | Rahvuslik Koonderakond "Isamaa" 243 | |||
123 | 123 | 123 | Romania 23 | 1992-10-11 | 1996-11-29 | 17099 | Ion Iliescu | Partidul Social Democrat 1120 | |||
41 | 41 | 41 | Switzerland 40 | 1996-01-01 | 1996-12-31 | 6502 | Jean-Pascal Delamuraz | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
243 | 243 | 243 | Bulgaria 10 | 1990-08-01 | 1997-01-22 | 17033 | Zhelyu Zhelev | Suyuz na Demokratichnite Sili 423 | |||
127 | 127 | 127 | Ireland 37 | 1990-12-03 | 1997-09-12 | 17077 | Mary Robinson | Labour Party 318 | |||
67 | 67 | 67 | Slovenia 60 | 1992-12-06 | 1997-12-23 | 17104 | Milan Kučan | no party affiliation 1370 |
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]) );