external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where "end_date" is on date 2019-07-01 sorted by data_source
This data as json, CSV (advanced)
Suggested facets: start_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
257 | 257 | 2014 | 1 | Digital Single Market | 261 | 1 | Estonia 75 | Juncker | 0 | 96 | Ansip, Andrus | 2014-11-01 | 2019-07-01 | 2.25 | Eesti Reformierakond 113 | 0 | prime minister | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Roivas I 1095 | |
277 | 277 | Maybe add party change? Cretu joined PRO Romania in 2019 (January/March ?), but was not able to get re-elected into the European Parliament in May 2019 | 2014 | 1 | Regional Policy | 281 | 1 | Romania 23 | Juncker | 0 | 17111 | Creţu, Corina | 2014-11-01 | 2019-07-01 | 0.33 | Partidul Social Democrat 1120 | 0 | mp/mep | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Ponta III 1085 |
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]) );