external_commissioner_doering

Table actions

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

0 rows where comment = "Add second entry for succeeding Commission office of Kristalina Georgieva since 2017-01-01? (Budget and Human Resources)" and commission_year = 2014

✎ View and edit SQL

This data as json

0 records

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