politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
12 rows where data_source = "reuters" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
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. | |
289 | 289 | 290 | Latvia 55 | 2015-07-08 | 2019-07-08 | 5018 | Raimonds Vejonis | Zaļo un Zemnieku savienība 466 | reuters | ||
287 | 287 | 288 | Croatia 62 | 2015-02-15 | 2020-02-18 | 17142 | Kolinda Grabar-Kitarovic | Hrvatska demokratska zajednica 276 | reuters | ||
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. | |
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 |
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]) );