external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
3 rows where data_source = "ec.europa.eu, parlgov" sorted by rowid descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
268 | 268 | 2014 | 1 | Migration & Home Affairs | 272 | 1 | Greece 41 | Juncker | 0 | 8210 | Avramopoulos, Dimitris | 2014-11-01 | 2019-11-30 | 0.91 | Néa Đimokratía 47 | 0 | minister of defence | ec.europa.eu, parlgov | 10 | Samaras II 1060 | |
266 | 266 | 2014 | 1 | Environment, Maritime Affairs and Fisheries | 270 | 1 | Malta 72 | Juncker | 0 | 10616 | Vella, Karmenu | 2014-11-01 | 2019-11-30 | 0.68 | Partit Laburista 1003 | 0 | minister of tourism | ec.europa.eu, parlgov | 10 | Muscat I 1046 | |
265 | 265 | 2014 | 1 | Climate Action & Energy | 269 | 1 | Spain 27 | Juncker | 0 | 4248 | Arias Cañete, Miguel | 2014-11-01 | 2019-11-30 | 0.92 | Alianza-Partido Popular 645 | 0 | minister for agriculture, food and environment | ec.europa.eu, parlgov | 10 | Rajoy I 988 |
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]) );