politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
343 rows sorted by start_date
This data as json, CSV (advanced)
Suggested facets: country_id, data_source, comment, end_date (date)
start_date (date) >30 ✖
- 1952-01-01 2
- 1956-01-01 2
- 1960-01-01 2
- 1964-01-01 2
- 1972-01-01 2
- 1974-01-01 2
- 1976-01-01 2
- 1983-01-01 2
- 1984-01-01 2
- 1992-01-01 2
- 2000-01-01 2
- 2009-04-04 2
- 2010-08-06 2
- 1906-02-18 1
- 1913-02-18 1
- 1919-02-11 1
- 1919-07-26 1
- 1920-02-18 1
- 1920-09-23 1
- 1924-06-13 1
- 1925-03-02 1
- 1925-05-12 1
- 1931-03-02 1
- 1931-06-13 1
- 1932-05-10 1
- 1937-03-01 1
- 1940-07-11 1
- 1940-12-19 1
- 1944-06-17 1
- 1944-08-04 1
- …
Link | rowid | id | country_id | start_date ▼ | end_date | person_id | person_id_source | party_id | data_source | description | comment |
---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
313 | 313 | 315 | Germany 54 | 1919-02-11 | 1925-02-28 | 17164 | Sozialdemokratische Partei Deutschlands 558 | ||||
296 | 296 | 297 | Finland 67 | 1919-07-26 | 1925-03-02 | 17150 | Kaarlo Juho Ståhlberg | Kansallinen Edistyspuolue | [Suomen] Liberaalinen Kansanpuolue 1219 | no-2010 | ||
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 | |||
300 | 300 | 301 | France 43 | 1924-06-13 | 1931-06-13 | 17154 | Gaston Doumergue | Parti radical-socialiste 401 | |||
292 | 292 | 293 | Finland 67 | 1925-03-02 | 1931-03-02 | 17145 | Lauri Kristian Relander | Keskusta 94 | no-2010 | ||
314 | 314 | 316 | Germany 54 | 1925-05-12 | 1934-08-02 | 17165 | parteilos 610 | ||||
293 | 293 | 294 | Finland 67 | 1931-03-02 | 1937-03-01 | 17147 | Pehr Evind Svinhufvud | Kansallinen Kokoomus – Samlingspartiet 1118 | no-2010 | ||
299 | 299 | 300 | France 43 | 1931-06-13 | 1932-05-07 | 17153 | Paul Doumer | Parti radical-socialiste 401 | |||
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 | |||
295 | 295 | 296 | Finland 67 | 1940-12-19 | 1944-08-04 | 17149 | Risto Ryti | Kansallinen Edistyspuolue | [Suomen] Liberaalinen Kansanpuolue 1219 | no-2010 | ||
193 | 193 | 193 | Iceland 56 | 1944-06-17 | 1952-01-25 | 17081 | Sveinn Björnsson | no party affiliation 134 | |||
202 | 202 | 202 | Finland 67 | 1944-08-04 | 1946-03-04 | 17050 | Carl Gustaf Emil Mannerheim | ei kukaan – ingen 1119 | |||
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 | |||
118 | 118 | 118 | Ireland 37 | 1945-06-24 | 1952-01-01 | 17078 | Seán T. O'Kelly | Fianna Fáil 280 | |||
65 | 65 | 65 | Switzerland 40 | 1946-01-01 | 1946-12-31 | 10064 | Karl Kobelt | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
244 | 244 | 244 | Finland 67 | 1946-03-11 | 1950-01-17 | 3432 | Juho Kusti Paasikivi | Kansallinen Kokoomus – Samlingspartiet 1118 | |||
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 | |||
113 | 113 | 113 | France 43 | 1947-01-16 | 1954-01-16 | 6513 | Vincent Auriol | Parti socialiste 1539 | |||
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 | |||
35 | 35 | 35 | Italy 26 | 1948-05-11 | 1955-04-24 | 14070 | Luigi Einaudi | Partito Liberale Italiano 487 | |||
112 | 112 | 112 | Switzerland 40 | 1949-01-01 | 1949-12-31 | 1853 | Ernst Nobs | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
269 | 269 | 270 | Israel 34 | 1949-02-17 | 1951-11-25 | 17124 | Chaim Weizmann | no party affiliation 123 | |||
253 | 253 | 253 | Germany 54 | 1949-09-13 | 1954-07-17 | 5953 | Theodor Heuss | Freie Demokratische Partei 543 | |||
104 | 104 | 104 | Switzerland 40 | 1950-01-01 | 1950-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
245 | 245 | 245 | Finland 67 | 1950-01-17 | 1956-03-01 | 3432 | Juho Kusti Paasikivi | Kansallinen Kokoomus – Samlingspartiet 1118 | |||
179 | 179 | 179 | Switzerland 40 | 1951-01-01 | 1951-12-31 | 9930 | Eduard von Steiger | 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 | |||
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 | |||
119 | 119 | 119 | Ireland 37 | 1952-01-01 | 1959-06-24 | 17078 | Seán T. O'Kelly | Fianna Fáil 280 | |||
128 | 128 | 128 | Iceland 56 | 1952-08-01 | 1956-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
271 | 271 | 272 | Israel 34 | 1952-12-16 | 1957-10-28 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
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 | |||
258 | 258 | 258 | Switzerland 40 | 1954-01-01 | 1954-12-31 | 4722 | Rodolphe Rubattel | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
9 | 9 | 9 | France 43 | 1954-01-16 | 1959-01-08 | 199 | René Coty | Centre national des indépendants et paysans 1414 | |||
254 | 254 | 254 | Germany 54 | 1954-07-17 | 1959-09-12 | 5953 | Theodor Heuss | Freie Demokratische Partei 543 | |||
50 | 50 | 50 | Switzerland 40 | 1955-01-01 | 1955-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
147 | 147 | 147 | Italy 26 | 1955-04-24 | 1962-05-06 | 17084 | Giovanni Gronchi | Democrazia Cristiana 1633 | |||
129 | 129 | 129 | Iceland 56 | 1956-01-01 | 1960-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
230 | 230 | 230 | Switzerland 40 | 1956-01-01 | 1956-12-31 | 13646 | Markus Feldmann | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
216 | 216 | 216 | Finland 67 | 1956-03-01 | 1962-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
143 | 143 | 143 | Switzerland 40 | 1957-01-01 | 1957-12-31 | 2097 | Hans Streuli | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
226 | 226 | 226 | Austria 59 | 1957-05-22 | 1963-04-28 | 16653 | Adolf Schärf | Sozialdemokratische Partei Österreichs 973 | |||
272 | 272 | 273 | Israel 34 | 1957-10-28 | 1962-10-30 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
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 | |||
107 | 107 | 107 | Switzerland 40 | 1959-01-01 | 1959-12-31 | 15763 | Paul Chaudet | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
195 | 195 | 195 | France 43 | 1959-01-08 | 1965-12-19 | 11223 | Charles de Gaulle | Gaulliste 1094 | |||
61 | 61 | 61 | Ireland 37 | 1959-06-25 | 1966-06-01 | 12332 | Éamon de Valera | Fianna Fáil 280 | |||
172 | 172 | 172 | Germany 54 | 1959-09-12 | 1964-07-01 | 4009 | Heinrich Lübke | Christlich Demokratische Union 808 | |||
96 | 96 | 96 | Switzerland 40 | 1960-01-01 | 1960-12-31 | 404 | Max Petitpierre | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
130 | 130 | 130 | Iceland 56 | 1960-01-01 | 1964-01-01 | 17079 | Ásgeir Ásgeirsson | Framsóknarflokkurinn 1455 | |||
39 | 39 | 39 | Cyprus 51 | 1960-08-16 | 1974-07-15 | 17052 | Archbishop Makarios III | no party affiliation 534 | |||
5 | 5 | 5 | Switzerland 40 | 1961-01-01 | 1961-12-31 | 3131 | Friedrich Traugott Wahlen | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
51 | 51 | 51 | Switzerland 40 | 1962-01-01 | 1962-12-31 | 15763 | Paul Chaudet | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
217 | 217 | 217 | Finland 67 | 1962-01-16 | 1968-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
238 | 238 | 238 | Italy 26 | 1962-05-06 | 1964-08-10 | 8529 | Antonio Segni | Democrazia Cristiana 1633 | |||
273 | 273 | 274 | Israel 34 | 1962-10-30 | 1963-04-23 | 17125 | Yitzhak Ben-Zvi | HaMa'arakh | HaAvoda 244 | |||
231 | 231 | 231 | Switzerland 40 | 1963-01-01 | 1963-12-31 | 1245 | Willy Spühler | 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 | |||
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 | |||
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 | |||
173 | 173 | 173 | Germany 54 | 1964-07-01 | 1969-06-30 | 4009 | Heinrich Lübke | Christlich Demokratische Union 808 | |||
166 | 166 | 166 | Italy 26 | 1964-12-28 | 1971-12-24 | 6049 | Giuseppe Saragat | Partito Socialista Democratico Italiano 242 | |||
168 | 168 | 168 | Switzerland 40 | 1965-01-01 | 1965-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 | |||
196 | 196 | 196 | France 43 | 1965-12-19 | 1969-04-28 | 11223 | Charles de Gaulle | Gaulliste 1094 | |||
1 | 1 | 1 | Switzerland 40 | 1966-01-01 | 1966-12-31 | 7243 | Hans Schaffner | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
62 | 62 | 62 | Ireland 37 | 1966-06-01 | 1973-06-24 | 12332 | Éamon de Valera | Fianna Fáil 280 | |||
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 | |||
149 | 149 | 149 | Switzerland 40 | 1968-01-01 | 1968-12-31 | 1245 | Willy Spühler | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
218 | 218 | 218 | Finland 67 | 1968-01-16 | 1974-01-01 | 14223 | Urho Kekkonen | Keskusta 94 | |||
275 | 275 | 276 | Israel 34 | 1968-03-26 | 1973-05-24 | 17126 | Zalman Shazar | HaMa'arakh | HaAvoda 244 | |||
144 | 144 | 144 | Iceland 56 | 1968-08-01 | 1972-01-01 | 17080 | Kristján Eldjárn | no party affiliation 134 | |||
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 | |||
106 | 106 | 106 | France 43 | 1969-06-20 | 1974-04-02 | 12102 | Georges Pompidou | Gaulliste 1094 | |||
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). | |
43 | 43 | 43 | Switzerland 40 | 1970-01-01 | 1970-12-31 | 5600 | Hans-Peter Tschudi | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse 35 | |||
194 | 194 | 194 | Switzerland 40 | 1971-01-01 | 1971-12-31 | 11772 | Rudolf Gnägi | Schweizerische Volkspartei – Union Démocratique du Centre 750 | |||
235 | 235 | 235 | Austria 59 | 1971-04-25 | 1974-04-24 | 6238 | Franz Jonas | Sozialdemokratische Partei Österreichs 973 | |||
44 | 44 | 44 | Italy 26 | 1971-12-24 | 1978-06-15 | 612 | Giovanni Leone | Democrazia Cristiana 1633 | |||
24 | 24 | 24 | Switzerland 40 | 1972-01-01 | 1972-12-31 | 10045 | Nello Celio | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
145 | 145 | 145 | Iceland 56 | 1972-01-01 | 1976-01-01 | 17080 | Kristján Eldjárn | no party affiliation 134 | |||
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 | |||
276 | 276 | 277 | Israel 34 | 1973-05-24 | 1978-05-29 | 17127 | Ephraim Katzir | HaMa'arakh | HaAvoda 244 | |||
229 | 229 | 229 | Ireland 37 | 1973-06-25 | 1974-11-17 | 15420 | Erskine Hamilton Childers | Fianna Fáil 280 | |||
219 | 219 | 219 | Finland 67 | 1974-01-01 | 1978-01-16 | 14223 | Urho Kekkonen | Keskusta 94 | |||
232 | 232 | 232 | Switzerland 40 | 1974-01-01 | 1974-12-31 | 3877 | Ernst Brugger | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse 26 | |||
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 | |||
198 | 198 | 198 | Germany 54 | 1974-07-01 | 1979-06-30 | 6567 | Walter Scheel | Freie Demokratische Partei 543 | |||
7 | 7 | 7 | Austria 59 | 1974-07-08 | 1980-05-18 | 4021 | Rudolf Kirchschläger | Parteilose 272 | |||
203 | 203 | 203 | Cyprus 51 | 1974-12-08 | 1977-08-03 | 17052 | Archbishop Makarios III | no party affiliation 534 |
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]) );