external_commissioner_doering

Table actions

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

4 rows where "end_date" is on date 2009-10-31 and highest_position = "mp/mep"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: elected, incumbent, start_date, data_source, government_party, 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
210 210   2004 1 information society and media 211 1 Luxembourg 7 Barroso I 1 1129 Reding, Viviane 2004-11-22 2009-10-31 0.33 Chrëschtlech Sozial Vollekspartei 1234 0 mp/mep doering 10 Juncker III 12
211 211   2004 0 enlargement 212 1 Finland 67 Barroso I 1 1265 Rehn, Olli 2004-11-22 2009-10-31 0.33 Keskusta 94 0 mp/mep doering 10 Vanhanen I 759
218 218   2004 1 Health 222 1 Cyprus 51 Barroso I 0 12688 Vassiliou, Androulla 2008-03-03 2009-10-31 0.33 Enomeni Dimokrates 1523 0 mp/mep ec.europa.eu Aliança Povo Unido 11 Christofias I 289
219 219   2004 1 transport 223 1 Italy 26 Barroso I 0 6887 Tajani, Antonio 2008-05-08 2009-10-31 0.33 Forza Italia – Il Popolo della Libertà 596 0 mp/mep ec.europa.eu Aliança Povo Unido 11 Berlusconi IV 823

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