politician_president

Table actions

Data source: ParlGov · About: simonw/parlgov-datasette

1 row where data_source = "dpa" and "start_date" is on date 2016-08-01

✎ View and edit SQL

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
306 306 308 Iceland 56 2016-08-01 2020-06-28 17159   no party affiliation 134 dpa    

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);