external_commissioner_doering

Table actions

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

2 rows where highest_position = "junior minister industry"

✎ 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
123 123   1989 1 social affairs 123 1 Greece 41 Delors II 0 13865 Papandreou, Vasso 1989-01-06 1993-01-05 0.5 Panellinio Sosialistikó Kínima 1338 0 junior minister industry doering 10 Papandreou A III 39
172 172   1999 1 employment and social affairs 172 1 Greece 41 Prodi 0 16154 Diamantopoulou, Anna 1999-09-16 2004-03-10 0.5 Panellinio Sosialistikó Kínima 1338 0 junior minister industry doering 10 Simitis II 33

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