politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
316 rows where data_source = "" sorted by end_date
This data as json, CSV (advanced)
Suggested facets: country_id, description, comment, start_date (date), end_date (date)
Link | rowid | id | country_id | start_date | end_date ▼ | person_id | person_id_source | party_id | data_source | description | comment |
---|---|---|---|---|---|---|---|---|---|---|---|
311 | 311 | 313 | France 43 | 2017-06-14 | 17162 | La République En Marche! | Renaissance 2643 | |||||
315 | 315 | 317 | Ireland 37 | 2018-11-26 | 10553 | Michael D. Higgins | Labour Party 318 | ||||
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 | ||||
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 | |||||
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 | ||||
332 | 332 | 334 | Turkey 20 | 2018-07-09 | 17139 | Recep Tayyip Erdoğan | Adalet ve Kalkınma Partisi 901 | ||||
335 | 335 | 337 | Estonia 75 | 2021-10-11 | 17184 | no party affiliation 426 | |||||
304 | 304 | 305 | France 43 | 1906-02-18 | 1913-02-18 | 17158 | Armand Fallières | Républicaine gauche 2587 | |||
303 | 303 | 304 | France 43 | 1913-02-18 | 1920-02-18 | 17157 | Raymond Poincaré | Républicaine gauche 2587 | |||
302 | 302 | 303 | France 43 | 1920-02-18 | 1920-09-21 | 17156 | Paul Deschanel | Républicaine gauche 2587 | |||
301 | 301 | 302 | France 43 | 1920-09-23 | 1924-06-11 | 17155 | Alexandre Millerand | sans étiquette 947 | |||
313 | 313 | 315 | Germany 54 | 1919-02-11 | 1925-02-28 | 17164 | Sozialdemokratische Partei Deutschlands 558 | ||||
300 | 300 | 301 | France 43 | 1924-06-13 | 1931-06-13 | 17154 | Gaston Doumergue | Parti radical-socialiste 401 | |||
299 | 299 | 300 | France 43 | 1931-06-13 | 1932-05-07 | 17153 | Paul Doumer | Parti radical-socialiste 401 | |||
314 | 314 | 316 | Germany 54 | 1925-05-12 | 1934-08-02 | 17165 | parteilos 610 | ||||
298 | 298 | 299 | France 43 | 1932-05-10 | 1940-07-11 | 17152 | Albert Lebrun | Républicaine gauche 2587 | |||
294 | 294 | 295 | Finland 67 | 1937-03-01 | 1940-12-19 | 17148 | Kyösti Kallio | Keskusta 94 | |||
297 | 297 | 298 | France 43 | 1940-07-11 | 1944-08-09 | 17151 | Philippe Pétain | sans étiquette 947 | |||
154 | 154 | 154 | Switzerland 40 | 1945-01-01 | 1945-12-31 | 9930 | Eduard von Steiger | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
202 | 202 | 202 | Finland 67 | 1944-08-04 | 1946-03-04 | 17050 | Carl Gustaf Emil Mannerheim | ei kukaan – ingen 1119 | |||
65 | 65 | 65 | Switzerland 40 | 1946-01-01 | 1946-12-31 | 10064 | Karl Kobelt | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
11 | 11 | 11 | Italy 26 | 1946-06-28 | 1947-06-25 | 17083 | Enrico De Nicola | Partito Liberale Italiano 487 | |||
140 | 140 | 140 | Switzerland 40 | 1947-01-01 | 1947-12-31 | 13717 | Philipp Etter | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
12 | 12 | 12 | Italy 26 | 1947-06-25 | 1948-05-11 | 17083 | Enrico De Nicola | Partito Liberale Italiano 487 | |||
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 | |||
112 | 112 | 112 | Switzerland 40 | 1949-01-01 | 1949-12-31 | 1853 | Ernst Nobs | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
244 | 244 | 244 | Finland 67 | 1946-03-11 | 1950-01-17 | 3432 | Juho Kusti Paasikivi | Kansallinen Kokoomus – Samlingspartiet 1118 | |||
104 | 104 | 104 | Switzerland 40 | 1950-01-01 | 1950-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
153 | 153 | 153 | Austria 59 | 1945-04-29 | 1950-12-31 | 5373 | Karl Renner | Sozialdemokratische Partei Österreichs 973 | |||
269 | 269 | 270 | Israel 34 | 1949-02-17 | 1951-11-25 | 17124 | Chaim Weizmann | no party affiliation 123 | |||
179 | 179 | 179 | Switzerland 40 | 1951-01-01 | 1951-12-31 | 9930 | Eduard von Steiger | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
118 | 118 | 118 | Ireland 37 | 1945-06-24 | 1952-01-01 | 17078 | Seán T. O'Kelly | Fianna Fáil 280 | |||
193 | 193 | 193 | Iceland 56 | 1944-06-17 | 1952-01-25 | 17081 | Sveinn Björnsson | no party affiliation 134 | |||
270 | 270 | 271 | Israel 34 | 1951-11-25 | 1952-11-09 | 17124 | Chaim Weizmann | no party affiliation 123 | |||
33 | 33 | 33 | Switzerland 40 | 1952-01-01 | 1952-12-31 | 10064 | Karl Kobelt | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
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 | |||
113 | 113 | 113 | France 43 | 1947-01-16 | 1954-01-16 | 6513 | Vincent Auriol | Parti socialiste 1539 | |||
253 | 253 | 253 | Germany 54 | 1949-09-13 | 1954-07-17 | 5953 | Theodor Heuss | Freie Demokratische Partei 543 | |||
258 | 258 | 258 | Switzerland 40 | 1954-01-01 | 1954-12-31 | 4722 | Rodolphe Rubattel | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
35 | 35 | 35 | Italy 26 | 1948-05-11 | 1955-04-24 | 14070 | Luigi Einaudi | Partito Liberale Italiano 487 | |||
50 | 50 | 50 | Switzerland 40 | 1955-01-01 | 1955-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
128 | 128 | 128 | Iceland 56 | 1952-08-01 | 1956-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
245 | 245 | 245 | Finland 67 | 1950-01-17 | 1956-03-01 | 3432 | Juho Kusti Paasikivi | Kansallinen Kokoomus – Samlingspartiet 1118 | |||
230 | 230 | 230 | Switzerland 40 | 1956-01-01 | 1956-12-31 | 13646 | Markus Feldmann | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
4 | 4 | 4 | Austria 59 | 1951-06-21 | 1957-01-04 | 12553 | Theodor Körner | Sozialdemokratische Partei Österreichs 973 | |||
271 | 271 | 272 | Israel 34 | 1952-12-16 | 1957-10-28 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
143 | 143 | 143 | Switzerland 40 | 1957-01-01 | 1957-12-31 | 2097 | Hans Streuli | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
74 | 74 | 74 | Switzerland 40 | 1958-01-01 | 1958-12-31 | 6560 | Thomas Holenstein | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
9 | 9 | 9 | France 43 | 1954-01-16 | 1959-01-08 | 199 | René Coty | Centre national des indépendants et paysans 1414 | |||
119 | 119 | 119 | Ireland 37 | 1952-01-01 | 1959-06-24 | 17078 | Seán T. O'Kelly | Fianna Fáil 280 | |||
254 | 254 | 254 | Germany 54 | 1954-07-17 | 1959-09-12 | 5953 | Theodor Heuss | Freie Demokratische Partei 543 | |||
107 | 107 | 107 | Switzerland 40 | 1959-01-01 | 1959-12-31 | 15763 | Paul Chaudet | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
129 | 129 | 129 | Iceland 56 | 1956-01-01 | 1960-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
96 | 96 | 96 | Switzerland 40 | 1960-01-01 | 1960-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
5 | 5 | 5 | Switzerland 40 | 1961-01-01 | 1961-12-31 | 3131 | Friedrich Traugott Wahlen | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
216 | 216 | 216 | Finland 67 | 1956-03-01 | 1962-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
147 | 147 | 147 | Italy 26 | 1955-04-24 | 1962-05-06 | 17084 | Giovanni Gronchi | Democrazia Cristiana 1633 | |||
272 | 272 | 273 | Israel 34 | 1957-10-28 | 1962-10-30 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
51 | 51 | 51 | Switzerland 40 | 1962-01-01 | 1962-12-31 | 15763 | Paul Chaudet | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
273 | 273 | 274 | Israel 34 | 1962-10-30 | 1963-04-23 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
226 | 226 | 226 | Austria 59 | 1957-05-22 | 1963-04-28 | 16653 | Adolf Schärf | Sozialdemokratische Partei Österreichs 973 | |||
231 | 231 | 231 | Switzerland 40 | 1963-01-01 | 1963-12-31 | 1245 | Willy Spühler | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
130 | 130 | 130 | Iceland 56 | 1960-01-01 | 1964-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
172 | 172 | 172 | Germany 54 | 1959-09-12 | 1964-07-01 | 4009 | Heinrich Lübke | Christlich Demokratische Union 808 | |||
238 | 238 | 238 | Italy 26 | 1962-05-06 | 1964-08-10 | 8529 | Antonio Segni | Democrazia Cristiana 1633 | |||
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 | |||
227 | 227 | 227 | Austria 59 | 1963-04-28 | 1965-02-28 | 16653 | Adolf Schärf | Sozialdemokratische Partei Österreichs 973 | |||
195 | 195 | 195 | France 43 | 1959-01-08 | 1965-12-19 | 11223 | Charles de Gaulle | Gaulliste 1094 | |||
168 | 168 | 168 | Switzerland 40 | 1965-01-01 | 1965-12-31 | 5600 | Hans-Peter Tschudi | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
61 | 61 | 61 | Ireland 37 | 1959-06-25 | 1966-06-01 | 12332 | Éamon de Valera | Fianna Fáil 280 | |||
1 | 1 | 1 | Switzerland 40 | 1966-01-01 | 1966-12-31 | 7243 | Hans Schaffner | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
53 | 53 | 53 | Switzerland 40 | 1967-01-01 | 1967-12-31 | 6582 | Roger Bonvin | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
217 | 217 | 217 | Finland 67 | 1962-01-16 | 1968-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
274 | 274 | 275 | Israel 34 | 1963-05-21 | 1968-03-26 | 17126 | Zalman Shazar | HaMa'arakh | HaAvoda 244 | |||
131 | 131 | 131 | Iceland 56 | 1964-01-01 | 1968-08-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
149 | 149 | 149 | Switzerland 40 | 1968-01-01 | 1968-12-31 | 1245 | Willy Spühler | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
196 | 196 | 196 | France 43 | 1965-12-19 | 1969-04-28 | 11223 | Charles de Gaulle | Gaulliste 1094 | |||
173 | 173 | 173 | Germany 54 | 1964-07-01 | 1969-06-30 | 4009 | Heinrich Lübke | Christlich Demokratische Union 808 | |||
59 | 59 | 59 | Switzerland 40 | 1969-01-01 | 1969-12-31 | 7634 | Ludwig von Moos | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien 531 | |||
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 | |||
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 |
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]) );