external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
13 rows where data_source = "dr-08, dw-05, ec.europa.eu, parlgov" sorted by party_id
This data as json, CSV (advanced)
Suggested facets: comment, commission_year, country_id, commission_name, person_id, start_date, end_date, score_position, party_id, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
278 | 278 | 2014 | 1 | Competition | 282 | 1 | Denmark 21 | Juncker | 0 | 15513 | Vestager, Margrethe | 2014-11-01 | 2019-11-30 | 1.27 | Det Radikale Venstre 211 | 0 | minister of economy and interior | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Thorning-Schmidt II 1074 | |
274 | 274 | 2014 | 1 | Internal Market, Industry, Entrepreneurship and SMEs | 278 | 1 | Poland 74 | Juncker | 0 | 17114 | Bieńkowska, Elżbieta | 2014-11-01 | 2019-11-30 | 1.42 | Platforma Obywatelska 512 | 0 | deputy prime minister | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Kopacz 1146 | |
269 | 269 | 2014 | 1 | Employment, Social Affairs, Skills and Labour Mobility | 273 | 1 | Belgium 64 | Juncker | 0 | 8076 | Thyssen, Marianne | 2014-11-01 | 2019-11-30 | 0.33 | Christelijke Volkspartij | Christen-Democratisch en Vlaams 723 | 0 | mp/mep | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Michel I 1147 | |
276 | 276 | 2014 | 1 | Education, Culture, Youth and Citizenship | 280 | 1 | Hungary 39 | Juncker | 0 | 17112 | Navracsics, Tibor | 2014-11-01 | 2019-11-30 | 1.51 | Fidesz – Magyar Polgári Szövetség 921 | 0 | minister of foreign affairs and trade | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Orban III 1104 | |
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 |
279 | 279 | 2014 | 1 | Research, Science and Innovation | 283 | 1 | Portugal 63 | Juncker | 0 | 17110 | Moedas, Carlos | 2014-11-01 | 2019-11-30 | 0.5 | Partido Social Democrata 1273 | 0 | secretary of state | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Passos Coelho I 917 | |
267 | 267 | 2014 | 1 | Health & Food Safety | 271 | 1 | Lithuania 15 | Juncker | 0 | 17117 | Andriukaitis, Vytenis | 2014-11-01 | 2019-11-30 | 0.97 | Lietuvos socialdemokratų partija 1277 | 0 | minister of health | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Butkevicius II 1633 | |
272 | 272 | 2014 | 1 | Agriculture & Rural Development | 276 | 1 | Ireland 37 | Juncker | 0 | 16586 | Hogan, Phil | 2014-11-01 | 2019-11-30 | 0.93 | Fine Gael 1393 | 0 | minister of environment | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Kenny I 904 | |
264 | 264 | 2014 | 1 | International Cooperation & Development | 268 | 1 | Croatia 62 | Juncker | 0 | 17109 | Mimica, Neven | 2014-11-01 | 2019-11-30 | 1.18 | Socijaldemokratska partija Hrvatske 1493 | 0 | minister for eu integration | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Milanovic 1056 | |
280 | 280 | 2010 | 1 | Consumer Policy | 284 | 1 | Croatia 62 | Barroso II | 0 | 17109 | Mimica, Neven | 2010-02-10 | 2014-10-31 | 1.16 | Socijaldemokratska partija Hrvatske 1493 | 0 | deputy prime minister | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Kosor I 1055 | |
271 | 271 | 2014 | 1 | Humanitarian Aid & Crisis Management | 275 | 1 | Cyprus 51 | Juncker | 0 | 17116 | Stylianides, Christos | 2014-11-01 | 2019-11-30 | 0.33 | Dimokratikós Sinayermós 1575 | 0 | mp/mep | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Anastasiades II 1086 | |
275 | 275 | druckman_roberts 2008: housing and regions | 2014 | 1 | Justice, Consumers and Gender Equality | 279 | 1 | Czech Republic 68 | Juncker | 0 | 17113 | Jourová, Vĕra | 2014-11-01 | 2019-11-30 | 0.95 | Akce nespokojených občanů 2011 2263 | 0 | minister for regional development | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Sobotka 1072 |
281 | 281 | 2014 | 1 | transport | 285 | 1 | Slovenia 60 | Juncker | 0 | 17121 | Bulc, Violeta | 2014-11-01 | 2019-11-30 | 1.07 | Stranka modernega 2333 | 0 | minister without portfolio | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Cerar 1144 |
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]) );