politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
12 rows where data_source = "reuters"
This data as json, CSV (advanced)
Suggested facets: country_id, person_id, party_id, description, comment, start_date (date), end_date (date)
person_id_source 11 ✖
Link | rowid ▼ | id | country_id | start_date | end_date | person_id | person_id_source | party_id | data_source | description | comment |
---|---|---|---|---|---|---|---|---|---|---|---|
58 | 58 | 58 | Estonia 75 | 2001-10-08 | 2006-10-09 | 17062 | Arnold Rüütel | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond 417 | reuters | President Rüütel was elected (yes: 186, no: 155) on 21 September 2001. | |
286 | 286 | 287 | Italy 26 | 2015-02-03 | 2022-01-29 | 8465 | Sergio Mattarella | Partito Democratico 382 | reuters | Mattarella was one of the founders of the Democratic Party (PD) in 2007 and was officially endorsed by the party. | |
287 | 287 | 288 | Croatia 62 | 2015-02-15 | 2020-02-18 | 17142 | Kolinda Grabar-Kitarovic | Hrvatska demokratska zajednica 276 | reuters | ||
289 | 289 | 290 | Latvia 55 | 2015-07-08 | 2019-07-08 | 5018 | Raimonds Vejonis | Zaļo un Zemnieku savienība 466 | reuters | ||
305 | 305 | 306 | Portugal 63 | 2016-03-09 | 11226 | Rebelo de Sousa, Marcelo | Partido Social Democrata 1273 | reuters | |||
309 | 309 | 311 | Austria 59 | 2017-01-26 | 2022-10-09 | 10383 | Alexander Van der Bellen | Die Grünen – Die Grüne Alternative 1429 | reuters | ||
310 | 310 | 312 | Germany 54 | 2017-03-19 | 14726 | Frank-Walter Steinmeier | Sozialdemokratische Partei Deutschlands 558 | reuters | |||
312 | 312 | 314 | Cyprus 51 | 2018-02-04 | 17056 | Nicos Anastasiades | Dimokratikó Kómma 851 | reuters | |||
316 | 316 | 318 | Slovakia 1 | 2019-06-15 | 17166 | reuters | Progresívne Slovensko 2751 | reuters | |||
336 | 336 | 338 | Israel 34 | 2021-07-07 | 17185 | Isaac Herzog | HaMa'arakh | HaAvoda 244 | reuters | |||
338 | 338 | 340 | Italy 26 | 2022-01-29 | 8465 | Sergio Mattarella | Partito Democratico 382 | reuters | |||
343 | 343 | 345 | Slovenia 60 | 2022-12-23 | 17189 | Nataša Pirc Musar | no party affiliation 1370 | reuters |
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]) );