politician_president

Table actions

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

1 row where "end_date" is on date 2014-12-21

✎ 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
101 101 101 Romania 23 2009-12-21 2014-12-21 17100 Traian Băsescu Partidul Democrat-Liberal 958      

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