external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
308 rows sorted by comment
This data as json, CSV (advanced)
commission_name 14 ✖
- Juncker 29
- Barroso II 28
- Von der Leyen 26
- Barroso I 3
- Hallstein II 3
- Ortoli 3
- Prodi 3
- Rey 3
- Delors I 2
- Hallstein I 2
- Santer 2
- Thorn 2
- Jenkins 1
- Malfatti/Manshold 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
226 | 226 | 2010 | 0 | employment. social affairs and inclusion | 230 | 1 | Hungary 39 | Barroso II | 0 | 16866 | Andor, László | 2010-02-10 | 2014-10-31 | 0.2 | Magyar Szocialista Párt 1591 | 0 | member of the board of directors EBRD | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Bajnai 162 | |
227 | 227 | 2010 | 1 | high representative of the union for foreign affairs and security policy | 231 | 1 | United Kingdom 44 | Barroso II | 1 | 9961 | Ashton, Catherine | 2010-02-10 | 2014-10-31 | 1.0 | Labour Party 1556 | 0 | leader of the house of lords | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Brown 119 | |
228 | 228 | 2010 | 1 | internal market and services | 232 | 1 | France 43 | Barroso II | 0 | 6420 | Barnier, Michel | 2010-02-10 | 2014-10-31 | 1.45 | Union pour un mouvement populaire | Les Républicains 658 | 0 | minister foreign affairs | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Fillon II 306 | |
230 | 230 | 2010 | 1 | maritime affairs and fisheries | 234 | 1 | Greece 41 | Barroso II | 0 | 16868 | Damanaki, Maria | 2010-02-10 | 2014-10-31 | 0.33 | Panellinio Sosialistikó Kínima 1338 | 0 | mp/mep | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Papandreou G 224 | |
232 | 232 | 2010 | 1 | trade | 236 | 1 | Belgium 64 | Barroso II | 1 | 15520 | De Gucht, Karel | 2010-02-10 | 2014-10-31 | 1.28 | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten 1110 | 0 | minister foreign affairs and european affairs | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Leterme II 431 | |
233 | 233 | 2010 | 1 | enlargement and european neighbourhood policy | 237 | 1 | Czech Republic 68 | Barroso II | 0 | 16869 | Füle, Štefan | 2010-02-10 | 2014-10-31 | 1.0 | no party affiliation 1567 | 0 | minister european affairs | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Fischer 157 | |
234 | 234 | 2010 | 1 | research, innovation and science | 238 | 1 | Ireland 37 | Barroso II | 0 | 8185 | Geoghegan-Quinn, Máire | 2010-02-10 | 2014-10-31 | 1.24 | Fianna Fáil 280 | 0 | minister justice | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Cowen 173 | |
236 | 236 | 2010 | 0 | regional policy | 240 | 1 | Austria 59 | Barroso II | 0 | 1416 | Hahn, Johannes | 2010-02-10 | 2014-10-31 | 0.89 | Österreichische Volkspartei 1013 | 0 | minister science and research | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Faymann I 268 | |
237 | 237 | 2010 | 1 | climate action | 241 | 1 | Denmark 21 | Barroso II | 0 | 6095 | Hedegaard, Connie | 2010-02-10 | 2014-10-31 | 1.33 | Konservative 590 | 0 | minister environment | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Rasmussen L I 71 | |
238 | 238 | 2010 | 1 | transport | 242 | 1 | Estonia 75 | Barroso II | 1 | 16396 | Kallas, Siim | 2010-02-10 | 2014-10-31 | 2.25 | Eesti Reformierakond 113 | 0 | prime minister | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Ansip III 902 | |
239 | 239 | 2010 | 1 | digital agenda | 243 | 1 | Netherlands 8 | Barroso II | 1 | 10749 | Kroes, Neelie | 2010-02-10 | 2014-10-31 | 0.92 | Volkspartij voor Vrijheid en Democratie 1409 | 0 | minister transport | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Balkenende V 69 | |
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 | |
242 | 242 | 2010 | 1 | energy | 246 | 1 | Germany 54 | Barroso II | 0 | 16863 | Oettinger, Günther | 2010-02-10 | 2014-10-31 | 1.0 | Christlich Demokratische Union 808 | 0 | minister-president of Baden-Württemberg | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Merkel II 472 | |
243 | 243 | 2010 | 1 | development | 247 | 1 | Latvia 55 | Barroso II | 1 | 16359 | Piebalgs, Andris | 2010-02-10 | 2014-10-31 | 1.64 | Latvijas Pirmā partija / Latvijas Ceļš 662 | 0 | minister finance | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Dombrovskis I 477 | |
245 | 245 | 2010 | 1 | justice. fundamental rights and citizenship | 249 | 1 | Luxembourg 7 | Barroso II | 1 | 1129 | Reding, Viviane | 2010-02-10 | 2014-10-31 | 0.33 | Chrëschtlech Sozial Vollekspartei 1234 | 0 | mp/mep | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Juncker IV 601 | |
246 | 246 | 2010 | 1 | economic and monetary affairs | 250 | 1 | Finland 67 | Barroso II | 1 | 1265 | Rehn, Olli | 2010-02-10 | 2014-07-01 | 0.33 | Keskusta 94 | 1 | mp/mep | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Vanhanen II 277 | |
248 | 248 | 2010 | 1 | taxation and customs union. audit and anti-fraud | 252 | 1 | Lithuania 15 | Barroso II | 1 | 3567 | Šemeta, Algirdas | 2010-02-10 | 2014-10-31 | 1.74 | Tėvynės sąjunga 1045 | 1 | minister finance | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Kubilius III 1632 | |
249 | 249 | 2010 | 1 | industry and entrepreneurship | 253 | 1 | Italy 26 | Barroso II | 1 | 6887 | Tajani, Antonio | 2010-02-10 | 2014-10-31 | 0.33 | Forza Italia – Il Popolo della Libertà 596 | 0 | mp/mep | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Berlusconi IV 823 | |
250 | 250 | 2010 | 1 | education. culture. multilingualism and youth | 254 | 1 | Cyprus 51 | Barroso II | 1 | 12688 | Vassiliou, Androulla | 2010-02-10 | 2014-10-31 | 0.33 | Enomeni Dimokrates 1523 | 0 | mp/mep | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Christofias I 289 | |
251 | 251 | 2010 | 1 | president | 255 | 1 | Portugal 63 | Barroso II | 1 | 3890 | Barroso, Jose Manuel | 2010-02-10 | 2014-10-31 | 2.2 | Partido Social Democrata 1273 | 1 | prime minister | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Socrates II 858 | |
253 | 253 | 2014 | 1 | president | 257 | 1 | Luxembourg 7 | Juncker | 0 | 2240 | Juncker, Jean-Claude | 2014-11-01 | 2019-11-30 | 2.17 | Chrëschtlech Sozial Vollekspartei 1234 | 1 | prime minister | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Bettel I 1069 | |
254 | 254 | 2014 | 1 | high representative of the union for foreign affairs and security policy | 258 | 1 | Italy 26 | Juncker | 0 | 17106 | Mogherini, Federica | 2014-11-01 | 2019-11-30 | 1.69 | Partito Democratico 382 | 0 | minister foreign affairs | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Renzi 1079 | |
255 | 255 | 2014 | 1 | Better Regulation, Inter-Institutional Relations, the Rule of Law and the Charter of Fundamental Rights | 259 | 1 | Netherlands 8 | Juncker | 0 | 17107 | Timmermans, Frans | 2014-11-01 | 2019-11-30 | 1.16 | Partij van de Arbeid 742 | 0 | minister foreign affairs | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Rutte III 1041 | |
256 | 256 | 2014 | 0 | Budget & Human Resources | 260 | 1 | Bulgaria 10 | Juncker | 1 | 16870 | Georgieva, Kristalina | 2014-11-01 | 2016-12-31 | 0.2 | Grazhdani za Evropeysko Razvitie na Balgariya 1541 | 0 | vice president world bank, professor | ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Bliznashki 1139 | |
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 | |
259 | 259 | 2014 | 1 | Jobs, Growth, Investment and Competitiveness | 263 | 1 | Finland 67 | Juncker | 1 | 16803 | Katainen, Jyrki | 2014-11-01 | 2019-11-30 | 2.53 | Kansallinen Kokoomus – Samlingspartiet 1118 | 0 | prime minister | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Stubb II 1145 | |
263 | 263 | 2014 | 1 | Trade | 267 | 1 | Sweden 35 | Juncker | 1 | 9042 | Malmström, Cecilia | 2014-11-01 | 2019-11-30 | 1.0 | Folkpartiet 892 | 0 | minister für eu affairs | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Lofven I 1149 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
270 | 270 | 2014 | 1 | Economic and Financial Affairs, Taxation and Customs | 274 | 1 | France 43 | Juncker | 0 | 7675 | Moscovici, Pierre | 2014-11-01 | 2019-11-30 | 1.92 | Parti socialiste 1539 | 0 | minister of finance | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Valls II 1141 | |
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 | |
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 | |
273 | 273 | 2014 | 1 | Financial Stability, Financial Services and Capital Markets Union | 277 | 1 | United Kingdom 44 | Juncker | 0 | 17115 | Hill, Jonathan | 2014-11-01 | 2016-07-15 | 1.0 | Conservatives 773 | 0 | leader of the house of Lords, chancelor of duekdom | ec.europa.eu, munzinger, parlgov | 10 | Cameron I 874 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
282 | 282 | 2014 | 1 | Digital Economy and Society | 286 | 1 | Bulgaria 10 | Juncker | 0 | 17163 | Gabriel, Mariya | 2017-07-07 | 2019-11-30 | 0.33 | Grazhdani za Evropeysko Razvitie na Balgariya 1541 | 0 | MEP | 10 | Borisov III 1505 | ||
283 | 283 | 2019 | 1 | president | 287 | 1 | Germany 54 | Von der Leyen | 0 | 11059 | Von der Leyen, Ursula | 2019-12-01 | 1.21 | Christlich Demokratische Union 808 | 1 | minister of labour and social affairs | dw-05 | 10 | Merkel V 1528 | ||
284 | 284 | 2019 | 1 | European Green Deal | 288 | 1 | Netherlands 8 | Von der Leyen | 1 | 17107 | Frans Timmermans | 2019-12-01 | 1.16 | Partij van de Arbeid 742 | 0 | minister of foreign affairs | Aliança Povo Unido 11 | Rutte V 1530 | |||
285 | 285 | 2019 | 1 | An Economy that Works for People | 289 | 1 | Latvia 55 | Von der Leyen | 1 | 11889 | Valdis Dombrovskis | 2019-12-01 | 2.14 | Vienotība 1666 | 0 | prime minister | 10 | Karins I 1592 | |||
286 | 286 | 2019 | 1 | A Stronger Europe in the World | 290 | 1 | Spain 27 | Von der Leyen | 0 | 1468 | Josep Borrell Fontelles | 2019-12-01 | 1.43 | Partido Socialista Obrero Español 902 | 0 | minister of foreign affairs | 10 | Sanchez II 1601 | |||
287 | 287 | 2019 | 0 | Interinstitutional Relations and Foresight | 291 | 1 | Slovakia 1 | Von der Leyen | 1 | 16865 | Šefčovič, Maroš | 2019-12-01 | 0.2 | Smer – sociálna demokracia 220 | 0 | diplomat | 10 | Pellegrini 1529 | |||
288 | 288 | 2019 | 1 | Values and Transparency | 292 | 1 | Czech Republic 68 | Von der Leyen | 1 | 17113 | Jourová, Vĕra | 2019-12-01 | 0.95 | Akce nespokojených občanů 2011 2263 | 0 | minister for regional development | dw-05 | 10 | Babis II 1534 | ||
289 | 289 | 2019 | 1 | Democracy and Demography | 293 | 1 | Croatia 62 | Von der Leyen | 0 | 17175 | Dubravka Šuica | 2019-12-01 | 0.2 | Hrvatska demokratska zajednica 276 | 0 | mayor | 10 | Plenkovic II 1512 | |||
290 | 290 | 2019 | 1 | Promoting our European Way of Life | 294 | 1 | Greece 41 | Von der Leyen | 0 | 7024 | Margaritis Schinas | 2019-12-01 | 0.33 | Néa Đimokratía 47 | 0 | mep | 10 | Mitsotakis Kyr 1597 | |||
291 | 291 | 2019 | 1 | Budget and Administration | 295 | 1 | Austria 59 | Von der Leyen | 1 | 1416 | Johannes Hahn | 2019-12-01 | 0.89 | Österreichische Volkspartei 1013 | 0 | federal minister of science and research | dr-08 | 10 | Bierlein II 1608 | ||
292 | 292 | 2019 | 1 | Trade | 296 | 1 | Ireland 37 | Von der Leyen | 1 | 16586 | Phil Hogan | 2019-12-01 | 0.93 | Fine Gael 1393 | 0 | minister of environment | dr-08 | 10 | Varadkar I 1511 | ||
293 | 293 | 2019 | 1 | Innovation, Research, Culture, Education and Youth | 297 | 1 | Bulgaria 10 | Von der Leyen | 1 | 17163 | Mariya Gabriel | 2019-12-01 | 0.33 | Grazhdani za Evropeysko Razvitie na Balgariya 1541 | 0 | mep | 10 | Borisov III 1505 | |||
294 | 294 | 2019 | 1 | Jobs and Social Rights | 298 | 1 | Luxembourg 7 | Von der Leyen | 0 | 17176 | Nicolas Schmitt | 2019-12-01 | 0.33 | Lëtzebuerger Sozialistesch Aarbechterpartei 701 | 0 | mep | 10 | Bettel II 1588 | |||
295 | 295 | 2019 | 1 | Economy | 299 | 1 | Italy 26 | Von der Leyen | 0 | 17177 | Paolo Gentiloni | 2019-12-01 | 2.48 | Partito Democratico 382 | 0 | prime minister | dw-05 | 10 | Conte II 1603 | ||
296 | 296 | 2019 | 1 | Agriculture | 300 | 1 | Poland 74 | Von der Leyen | 0 | 13482 | Janusz Wojciechowski | 2019-12-01 | 0.33 | Prawo i Sprawiedliwość 528 | 0 | mep | 10 | Morawiecki II 1611 | |||
297 | 297 | 2019 | Internal Market | 301 | 1 | France 43 | Von der Leyen | 0 | 8103 | Thierry Breton | 2019-12-01 | 1.92 | sans étiquette 947 | 0 | minister of economy, finance and industry | dw-05 | 12 | Philippe II 1509 | |||
298 | 298 | 2019 | 1 | Cohesion and Reforms | 302 | Portugal 63 | Von der Leyen | 0 | 7429 | Elisa Ferreira | 2019-12-01 | 0.81 | Partido Socialista 725 | 0 | minister for environment | 10 | Costa II 1610 | ||||
299 | 299 | 2019 | 1 | Health and Food Safety | 303 | 1 | Cyprus 51 | Von der Leyen | 0 | 17178 | Stella Kyriakides | 2019-12-01 | 0.33 | Dimokratikós Sinayermós 1575 | 0 | mp | 10 | Anastasiades IV 1628 | |||
300 | 300 | 2019 | Justice | 304 | 1 | Belgium 64 | Von der Leyen | 0 | 10682 | Didier Reynders | 2019-12-01 | 1.35 | Mouvement Réformateur 915 | 0 | minister of finance | dw-05 | 10 | Wilmes I 1622 | |||
301 | 301 | 2019 | 1 | Equality | 305 | 1 | Malta 72 | Von der Leyen | 0 | 17179 | Helena Dalli | 2019-12-01 | 1.0 | Partit Laburista 1003 | 0 | minister of european affairs and equality | 10 | Muscat II 1504 | |||
302 | 302 | 2019 | 1 | Home Affairs | 306 | 1 | Sweden 35 | Von der Leyen | 0 | 4867 | Ylva Johansson | 2019-12-01 | 1.26 | Socialdemokraterna 904 | 0 | minister of employment | dw-05 | 10 | Lofven III 1590 | ||
303 | 303 | 2019 | 0 | Crisis Management | 307 | 1 | Slovenia 60 | Von der Leyen | 0 | 17180 | Janez Lenarčič | 2019-12-01 | 0.2 | no party affiliation 1370 | 0 | diplomat | 12 | Sarec 1555 | |||
304 | 304 | 2019 | 1 | Transport | 308 | 1 | Romania 23 | Von der Leyen | 0 | 32 | Adina Vălean | 2019-12-01 | 0.33 | Partidul Naţional Liberal 1015 | 0 | mep/mp | 10 | Orban I 1619 | |||
305 | 305 | 2019 | 0 | Neighbourhood and Enlargement | 309 | 1 | Hungary 39 | Von der Leyen | 0 | 17181 | Olivér Várhelyi | 2019-12-01 | 0.2 | Fidesz – Magyar Polgári Szövetség 921 | 0 | bureaucrat | 10 | Orban IV 1531 | |||
306 | 306 | 2019 | 1 | International Partnerships | 310 | 1 | Finland 67 | Von der Leyen | 0 | 16990 | Jutta Urpilainen | 2019-12-01 | 1.0 | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | 0 | minister of finance and deputy minister | dw-05 | 10 | Rinne 1596 | ||
307 | 307 | 2019 | 311 | 1 | Estonia 75 | Von der Leyen | 0 | 17182 | Kadri Simson | 2019-12-01 | 1.21 | Eesti Keskerakond 1137 | 0 | minister of economic affairs and infrastructure | 10 | Ratas II 1595 | |||||
308 | 308 | 2019 | 1 | Environment, Oceans and Fisheries | 312 | 1 | Lithuania 15 | Von der Leyen | 0 | 17183 | Virginijus Sinkevičius | 2019-12-01 | 1.47 | Lietuvos valstiečių sąjunga 191 | 0 | minister of economy and innovation | dr-08 | 10 | Skvernelis III 1615 | ||
260 | 260 | Add second entry for succeeding Commission office of Andrus Ansip since 2019-07-03? (Digital Single Market) | 2014 | 0 | Transport & Space [+ Digital Single Market since 2019-07-03] | 264 | 1 | Slovakia 1 | Juncker | 1 | 16865 | Šefčovič, Maroš | 2014-11-01 | 2019-11-30 | 0.2 | Smer – sociálna demokracia 220 | 0 | diplomat | ec.europa.eu, munzinger, parlgov | 10 | Fico II 1027 |
262 | 262 | Add second entry for succeeding Commission office of Corina Cretu since 2019-07-03? (Regional Policy) | 2014 | 1 | European Neighbourhood Policy & Enlargement Negotiations [+ Regional Policy since 2019-07-03] | 266 | 1 | Austria 59 | Juncker | 1 | 1416 | Hahn, Johannes | 2014-11-01 | 2019-11-30 | 0.89 | Österreichische Volkspartei 1013 | 0 | federal minister of science and research | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Faymann II 1070 |
258 | 258 | Add second entry for succeeding Commission office of Jonathan Hill since 2016-07-16? (Financial Stability, Financial Services and Capital Markets Union) | 2014 | 1 | Euro & Social Dialogue [+ Financial Stability, Financial Services and Capital Markets Union since 2016-07-16] | 262 | 1 | Latvia 55 | Juncker | 0 | 11889 | Dombrovskis, Valdis | 2014-11-01 | 2019-11-30 | 2.14 | Vienotība 1666 | 0 | prime minister | ec.europa.eu, munzinger, parlgov | 10 | Straujuma I 1073 |
261 | 261 | Add second entry for succeeding Commission office of Kristalina Georgieva since 2017-01-01? (Budget and Human Resources) | 2014 | 1 | Digital Economy & Society [+ Budget and Human Resources since 2017-01-01] | 265 | 1 | Germany 54 | Juncker | 1 | 16863 | Oettinger, Günther | 2014-11-01 | 2019-11-30 | 1.0 | Christlich Demokratische Union 808 | 0 | minister-president of a federral German state | ec.europa.eu, munzinger, parlgov | 10 | Merkel III 1071 |
25 | 25 | Check when party UDF was established. Was he a member of it before going to the Commission? | 1967 | 0 | trade policy | 25 | 0 | France 43 | Rey | 0 | 9096 | Deniau, Jean-Francois | 1967-07-06 | 1970-06-30 | 0.2 | Union pour la démocratie française | Mouvement démocrate 509 | 0 | bureaucrat | doering | Aliança Povo Unido 11 | Pompidou IV 662 |
40 | 40 | Check when party UDF was established. Was he a member of it before going to the Commission? | 1970 | 0 | trade policy | 40 | 0 | France 43 | Malfatti/Manshold | 1 | 9096 | Deniau, Jean-Francois | 1970-07-01 | 1973-01-05 | 0.2 | Union pour la démocratie française | Mouvement démocrate 509 | 0 | bureaucrat | doering | Aliança Povo Unido 11 | Chaban-Delmas 111 |
50 | 50 | Check when party UDF was established. Was he a member of it before going to the commission? | 1973 | 0 | development aid/budgets and financial control. | 50 | 0 | France 43 | Ortoli | 1 | 9096 | Deniau, Jean-Francois | 1973-01-06 | 1973-04-11 | 0.2 | Union pour la démocratie française | Mouvement démocrate 509 | 0 | bureaucrat | doering | Aliança Povo Unido 11 | Messmer I 430 |
17 | 17 | Information provided by Fabio Franchino | 1962 | 0 | industry | 17 | 0 | Italy 26 | Hallstein II | 0 | 14467 | Paliano, Guido Colonna Di | 1964-09-09 | 1967-07-05 | 0.2 | senzo partito 1552 | 0 | ambassador. vice general secretary NATO | doering | 12 | Moro II 705 |
32 | 32 | Information provided by Fabio Franchino | 1967 | 0 | industry | 32 | 0 | Italy 26 | Rey | 1 | 14467 | Paliano, Guido Colonna Di | 1967-07-06 | 1970-06-30 | 0.2 | senzo partito 1552 | 0 | ambassador. vice general secretary NATO | doering | 12 | Moro III 433 |
51 | 51 | Information provided by Fabio Franchino | 1973 | 0 | industry and technology | 51 | 0 | Italy 26 | Ortoli | 0 | 12568 | Guazzaroni, Cesidio | 1976-07-13 | 1977-01-05 | 0.2 | senzo partito 1552 | 0 | Career diplomat, ambassador and top rank bureaucrat, expert, no specific party affiliation | doering | 12 | Moro V 842 |
3 | 3 | Lemaignen had been the vice-president of the French employers federation http://www.fep.up.pt/investigacao/seminarios/04.10.15_Maes.pdf; maj_party missing | 1958 | 0 | overseas countries and territories | 3 | 0 | France 43 | Hallstein I | 0 | 12874 | Lemaignen, Robert | 1958-01-10 | 1962-01-09 | 0.2 | sans étiquette 947 | 0 | vice president of the French employers federation | doering | 12 | Gaillard 458 |
231 | 231 | Malta is not coded in Druckman/Warwick; average position score of finance minister (1.64) used; see codebook | 2010 | 1 | health and consumer policy | 235 | 1 | Malta 72 | Barroso II | 0 | 11019 | Dalli, John | 2010-02-10 | 2012-10-16 | 1.64 | Partit Nazzjonalista 984 | 0 | minister finance and economic affairs, foreign minister | afp, dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Gonzi II 468 |
252 | 252 | Malta is not coded in Druckman/Warwick; average position score of finance minister (1.64) used; see codebook | 2010 | 1 | health | 256 | 1 | Malta 72 | Barroso II | 1 | 16218 | Borg, Tonio | 2012-11-28 | 2014-10-31 | 1.64 | Partit Nazzjonalista 984 | 0 | minister finance and economic affairs, foreign minister | afp, dw-05 | Aliança Povo Unido 11 | Gonzi II 468 |
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 |
19 | 19 | Munzinger gives no party information. though he was member of a government. I gave him the party score of the government he was a member of. | 1962 | 1 | development policy | 19 | 0 | France 43 | Hallstein II | 0 | 7051 | Rochereau, Henri | 1962-01-10 | 1967-07-05 | 1.24 | sans étiquette 947 | 0 | minister agriculture | doering | 10 | Debré 692 |
33 | 33 | Munzinger gives no party information. though he was member of a government. I gave him the party score of the government he was a member of. | 1967 | 1 | development policy | 33 | 0 | France 43 | Rey | 1 | 7051 | Rochereau, Henri | 1967-07-06 | 1970-06-30 | 1.24 | sans étiquette 947 | 0 | minister agriculture | doering | 10 | Pompidou IV 662 |
222 | 222 | according to Wikipedia close to PO http://de.wikipedia.org/wiki/Kommission_Barroso_I | 2004 | 1 | regional policy | 226 | 1 | Poland 74 | Barroso I | 0 | 16864 | Samecki, Pawel | 2009-07-04 | 2009-10-31 | 0.5 | no party affiliation 1011 | 0 | deputy minister of finance. acting secretary of the Committee for European Integration | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Tusk I 164 |
223 | 223 | according to Wikipedia close to SMER http://de.wikipedia.org/wiki/Europ%C3%A4ische_Kommission | 2004 | 0 | education. training. culture and mulitlingualism | 227 | 1 | Slovakia 1 | Barroso I | 0 | 16865 | Šefčovič, Maroš | 2009-10-01 | 2009-10-31 | 0.2 | no party affiliation 1359 | 0 | Ambassador. Slovakian permanent representative to the EU | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Fico I 269 |
247 | 247 | according to Wikipedia close to SMER http://de.wikipedia.org/wiki/Europ%C3%A4ische_Kommission | 2010 | 0 | inter-institutional relations and administration | 251 | 1 | Slovakia 1 | Barroso II | 1 | 16865 | Šefčovič, Maroš | 2010-02-10 | 2014-10-31 | 0.2 | no party affiliation 1359 | 0 | Ambassador. Slovakian permanent representative to the EU | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Fico I 269 |
7 | 7 | adviser to socialist minister, socialist candidate in 1962 election | 1958 | 0 | economic and financial affairs | 7 | 0 | France 43 | Hallstein I | 0 | 12005 | Marjolin, Robert | 1958-01-10 | 1962-01-09 | 0.2 | Parti socialiste 1539 | 0 | head of cabinet for minister of foreign affairs | doering | 10 | Gaillard 458 |
16 | 16 | adviser to socialist minister, socialist candidate in 1962 election | 1962 | 0 | economic and financial affairs | 16 | 0 | France 43 | Hallstein II | 1 | 12005 | Marjolin, Robert | 1962-01-10 | 1967-07-05 | 0.2 | Parti socialiste 1539 | 0 | head of cabinet for minister of foreign affairs | doering | Aliança Povo Unido 11 | Debré 692 |
48 | 48 | adviser to the cabinet of Alain Savary (Socialist) and later a member of the Socialist party | 1973 | 0 | development aid/budgets and financial control. | 48 | 0 | France 43 | Ortoli | 0 | 5019 | Cheysson, Claude | 1973-04-19 | 1977-01-05 | 0.2 | Parti socialiste 1539 | 0 | bureaucrat | doering | Aliança Povo Unido 11 | Messmer II 607 |
65 | 65 | adviser to the cabinet of Alain Savary (Socialist) and later a member of the Socialist party | 1977 | 0 | development aid | 65 | 0 | France 43 | Jenkins | 1 | 5019 | Cheysson, Claude | 1977-01-06 | 1981-01-05 | 0.2 | Parti socialiste 1539 | 0 | bureaucrat | doering | Aliança Povo Unido 11 | Barre I 21 |
78 | 78 | adviser to the cabinet of Alain Savary (Socialist) and later a member of the Socialist party | 1981 | 0 | development aid | 78 | 0 | France 43 | Thorn | 1 | 5019 | Cheysson, Claude | 1981-01-06 | 1981-06-23 | 0.2 | Parti socialiste 1539 | 0 | bureaucrat | doering | Aliança Povo Unido 11 | Barre II 72 |
95 | 95 | adviser to the cabinet of Alain Savary (Socialist) and later a member of the Socialist party | 1985 | 0 | mediterranean policy and north-south relations | 95 | 0 | France 43 | Delors I | 1 | 5019 | Cheysson, Claude | 1985-01-06 | 1989-01-05 | 0.2 | Parti socialiste 1539 | 0 | bureaucrat | doering | 10 | Fabius 843 |
148 | 148 | check munzinger | 1995 | 1 | fisheries. consumer policy | 148 | 0 | Italy 26 | Santer | 0 | 13774 | Bonino, Emma | 1995-01-06 | 1999-03-15 | 0.33 | Radicali 1296 | 0 | mp/mep | doering | 10 | Berlusconi I 672 |
164 | 164 | check munzinger | 1995 | 0 | regional policy | 164 | 0 | Germany 54 | Santer | 0 | 13908 | Wulf-Mathies, Monika | 1995-01-06 | 1999-03-15 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | union head | doering | Aliança Povo Unido 11 | Kohl V 778 |
171 | 171 | check munzinger | 1999 | 1 | health and consumer protection | 171 | 1 | Ireland 37 | Prodi | 0 | 376 | Byrne, David | 1999-09-16 | 2004-11-21 | 0.9 | Fianna Fáil 280 | 0 | attorney general | doering | 10 | Ahern I 126 |
190 | 190 | check munzinger | 1999 | 1 | president | 190 | 0 | Italy 26 | Prodi | 0 | 6321 | Prodi, Romani | 1999-09-16 | 2004-11-21 | 2.48 | Centro-sinistra 1048 | 1 | prime minister | doering | 10 | D'Alema I 214 |
235 | 235 | close to Citizens for European Development of Bulgaria (GERB) | 2010 | 0 | international cooperation. humanitarian aid and crisis response | 239 | 1 | Bulgaria 10 | Barroso II | 0 | 16870 | Georgieva, Kristalina | 2010-02-10 | 2014-10-31 | 0.2 | Grazhdani za Evropeysko Razvitie na Balgariya 1541 | 0 | vice president and corporate secretary of the World Bank Group | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Borisov I 805 |
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]) );