politician_president
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where data_source = "dpa, reuters" sorted by description
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|
290 | 290 | 291 | Poland 74 | 2015-08-06 | 2020-08-06 | 17143 | Prawo i Sprawiedliwość 528 | dpa, reuters | |||
342 | 342 | 344 | Austria 59 | 2022-10-09 | 10383 | Alexander Van der Bellen | Die Grünen – Die Grüne Alternative 1429 | dpa, 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]) );