external_commissioner_doering

Table actions

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

1 row where commission_name = "Thorn" and end_date = "1984-10-26"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: start_date (date), end_date (date)

Link rowid ▼ comment commission_year elected portfolio id one_seat country_id commission_name incumbent person_id person_id_source start_date end_date score_position party_id president highest_position data_source government_party previous_cabinet_id
88 88   1981 0 economics+finance/credits+investment/statistical office 88 0 France 43 Thorn 1 4661 Ortoli, Francois-Xavier 1981-01-06 1984-10-26 1.92 Gaulliste 1094 0 minister economy and finance doering 10 Barre II 72

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE external_commissioner_doering("comment", "commission_year", "elected", "portfolio", "id", "one_seat", "country_id", "commission_name", "incumbent", "person_id", "person_id_source", "start_date", "end_date", "score_position", "party_id", "president", "highest_position", "data_source", "government_party", "previous_cabinet_id",
   FOREIGN KEY([country_id]) REFERENCES [country]([id]),
   FOREIGN KEY([party_id]) REFERENCES [party]([id]),
   FOREIGN KEY([data_source]) REFERENCES [info_data_source]([key]),
   FOREIGN KEY([government_party]) REFERENCES [party]([id]),
   FOREIGN KEY([previous_cabinet_id]) REFERENCES [cabinet]([id])
);