external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
3 rows where portfolio = "financial programming and budget"
This data as json, CSV (advanced)
Suggested facets: commission_year, country_id, commission_name, score_position, president, highest_position, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
199 | 199 | 2004 | 1 | financial programming and budget | 199 | 1 | Lithuania 15 | Barroso I | 0 | 1266 | Grybauskaite, Dalia | 2004-11-22 | 2009-07-01 | 1.74 | no party affiliation 58 | 0 | minister finance | doering | 10 | Brazauskas III 1634 | |
221 | 221 | 2004 | 1 | financial programming and budget | 225 | 1 | Lithuania 15 | Barroso I | 0 | 3567 | Šemeta, Algirdas | 2009-07-01 | 2009-10-31 | 1.74 | Tėvynės sąjunga 1045 | 1 | minister finance | munzinger | 10 | Kubilius II 688 | |
240 | 240 | 2010 | 1 | financial programming and budget | 244 | 1 | Poland 74 | Barroso II | 0 | 14860 | Lewandowski, Janusz | 2010-02-10 | 2014-10-31 | 1.14 | Platforma Obywatelska 512 | 0 | minister privatisation | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Tusk I 164 |
Advanced export
JSON shape: default, array, newline-delimited
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]) );