external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
308 rows sorted by highest_position descending
This data as json, CSV (advanced)
Suggested facets: comment, commission_year, elected, one_seat, country_id, commission_name, incumbent, data_source, government_party, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
61 | 61 | 1973 | 1 | competition policy | 61 | 1 | Luxembourg 7 | Ortoli | 0 | 12256 | Vouel, Raymond | 1976-07-20 | 1977-01-05 | 1.53 | Lëtzebuerger Sozialistesch Aarbechterpartei 701 | 0 | vice prime minister and finance minister | doering | 10 | Thorn 655 | |
73 | 73 | 1977 | 1 | competition | 73 | 1 | Luxembourg 7 | Jenkins | 1 | 12256 | Vouel, Raymond | 1977-01-06 | 1981-01-05 | 1.53 | Lëtzebuerger Sozialistesch Aarbechterpartei 701 | 0 | vice prime minister and finance minister | doering | 10 | Thorn 655 | |
74 | 74 | 1977 | 1 | employment/social affairs/Tripartite Conference | 74 | 1 | Netherlands 8 | Jenkins | 0 | 14619 | Vredeling, Henk | 1977-01-06 | 1981-01-05 | 1.53 | Partij van de Arbeid 742 | 0 | vice prime minister and Finance | doering | 10 | Den Uyl I 765 | |
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 | |
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 |
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 |
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 |
105 | 105 | 1985 | 0 | economic affairs. employment. credit + investment | 105 | 0 | Germany 54 | Delors I | 0 | 14842 | Pfeiffer, Alois | 1985-01-06 | 1987-08-01 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | union elite | doering | Aliança Povo Unido 11 | Kohl II 346 | |
90 | 90 | 1981 | 1 | social affairs | 90 | 0 | United Kingdom 44 | Thorn | 0 | 3740 | Richard, Ivor | 1981-01-06 | 1985-01-05 | 0.5 | Labour Party 1556 | 0 | under secretary of state defence | doering | Aliança Povo Unido 11 | Thatcher I 273 | |
107 | 107 | 1985 | 1 | economic affairs. employment. credit + investment | 107 | 0 | Germany 54 | Delors I | 0 | 12760 | Schmidhuber, Peter | 1987-09-22 | 1989-01-05 | 0.2 | Christlich Soziale Union 1180 | 0 | state junior minister in Bavaria | doering | 10 | Kohl III 286 | |
125 | 125 | 1989 | 1 | EC budget and financial control | 125 | 0 | Germany 54 | Delors II | 1 | 12760 | Schmidhuber, Peter | 1989-01-06 | 1993-01-05 | 0.2 | Christlich Soziale Union 1180 | 0 | state junior minister in Bavaria | doering | 10 | Kohl III 286 | |
141 | 141 | 1993 | 1 | budget | 141 | 0 | Germany 54 | Delors III | 1 | 12760 | Schmidhuber, Peter | 1993-01-06 | 1995-01-05 | 0.2 | Christlich Soziale Union 1180 | 0 | state junior minister in Bavaria | doering | 10 | Kohl IV 862 | |
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 | |
154 | 154 | 1995 | 1 | immigration. home affairs and justice | 154 | 1 | Sweden 35 | Santer | 0 | 16361 | Gradin, Anita | 1995-01-06 | 1999-03-15 | 0.65 | Socialdemokraterna 904 | 0 | second or subordinate minister | doering | 10 | Carlsson IV 528 | |
22 | 22 | 1967 | 0 | economic affairs | 22 | 0 | France 43 | Rey | 0 | 7144 | Barre, Raymond | 1967-07-06 | 1970-06-30 | 0.2 | sans étiquette 947 | 0 | professor | doering | 12 | Pompidou IV 662 | |
36 | 36 | 1970 | 0 | economic affairs | 36 | 0 | France 43 | Malfatti/Manshold | 1 | 7144 | Barre, Raymond | 1970-07-01 | 1973-01-05 | 0.2 | sans étiquette 947 | 0 | professor | doering | 12 | Chaban-Delmas 111 | |
159 | 159 | 1995 | 0 | internal market | 159 | 0 | Italy 26 | Santer | 0 | 12444 | Monti, Mario | 1995-01-06 | 1999-03-15 | 0.2 | senzo partito 1552 | 0 | professor | doering | 12 | Berlusconi I 672 | |
179 | 179 | 1999 | 0 | internal market | 179 | 0 | Italy 26 | Prodi | 1 | 12444 | Monti, Mario | 1999-09-16 | 2004-11-21 | 0.2 | senzo partito 1552 | 0 | professor | doering | 12 | D'Alema I 214 | |
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 |
92 | 92 | 1981 | 1 | president | 92 | 1 | Luxembourg 7 | Thorn | 0 | 2048 | Thorn, Gaston | 1981-01-06 | 1985-01-05 | 2.17 | Demokratesch Partei 967 | 1 | prime minister | doering | 10 | Werner IV 27 | |
151 | 151 | 1995 | 1 | science. research and development | 151 | 0 | France 43 | Santer | 0 | 12350 | Cresson, Edith | 1995-01-06 | 1999-03-15 | 2.75 | Parti socialiste 1539 | 0 | prime minister | doering | Aliança Povo Unido 11 | Balladur 318 | |
165 | 165 | 1995 | 1 | president | 165 | 1 | Luxembourg 7 | Santer | 0 | 6273 | Santer, Jacques | 1995-01-06 | 1999-03-15 | 2.75 | Chrëschtlech Sozial Vollekspartei 1234 | 1 | prime minister | doering | 10 | Santer III 222 | |
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 |
201 | 201 | 2004 | 1 | administrative affairs. audit and anti-fraud | 201 | 1 | Estonia 75 | Barroso I | 0 | 16396 | Kallas, Siim | 2004-11-22 | 2009-10-31 | 2.25 | Eesti Reformierakond 113 | 0 | prime minister | doering | 10 | Parts 138 | |
212 | 212 | 2004 | 1 | employment. social affairs and equal opportunitis | 213 | 1 | Czech Republic 68 | Barroso I | 0 | 2947 | Spidla, Vladimir | 2004-11-22 | 2009-10-31 | 1.96 | Česká strana sociálně demokratická 789 | 0 | prime minister | doering | 10 | Gross 580 | |
215 | 215 | 2004 | 1 | president | 216 | 1 | Portugal 63 | Barroso I | 0 | 3890 | Barroso, Jose Manuel | 2004-11-22 | 2009-10-31 | 2.2 | Partido Social Democrata 1273 | 1 | prime minister | doering | 10 | Santana Lopes 755 | |
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 | |
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 | |
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 | |
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 | |||
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 | ||
8 | 8 | 1958 | 0 | social affairs | 8 | 0 | Italy 26 | Hallstein I | 0 | 584 | Petrilli, Giuseppe | 1958-01-10 | 1961-02-08 | 0.2 | Democrazia Cristiana 1633 | 0 | president of national schools for social policy | doering | 10 | Zoli 280 | |
4 | 4 | 1958 | 0 | social affairs | 4 | 0 | Italy 26 | Hallstein I | 0 | 14658 | Levi Sandri, Lionello | 1961-02-22 | 1962-01-09 | 0.2 | Partito Socialista Italiano 1475 | 0 | party elite (no outstanding position) | doering | Aliança Povo Unido 11 | Fanfani III 810 | |
14 | 14 | 1962 | 0 | social affairs | 14 | 0 | Italy 26 | Hallstein II | 1 | 14658 | Levi Sandri, Lionello | 1962-01-10 | 1967-07-05 | 0.2 | Partito Socialista Italiano 1475 | 0 | party elite (no outstanding position) | doering | Aliança Povo Unido 11 | Fanfani III 810 | |
29 | 29 | 1967 | 0 | social affairs | 29 | 0 | Italy 26 | Rey | 1 | 14658 | Levi Sandri, Lionello | 1967-07-06 | 1970-06-30 | 0.2 | Partito Socialista Italiano 1475 | 0 | party elite (no outstanding position) | doering | 10 | Moro III 433 | |
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 |
183 | 183 | 1999 | 1 | education and culture | 183 | 1 | Luxembourg 7 | Prodi | 0 | 1129 | Reding, Viviane | 1999-09-16 | 2004-11-21 | 0.33 | Chrëschtlech Sozial Vollekspartei 1234 | 0 | mp/mep | doering | 10 | Juncker II 196 | |
184 | 184 | 1999 | 0 | enterprise and information society | 184 | 1 | Finland 67 | Prodi | 0 | 1265 | Rehn, Olli | 2004-07-12 | 2004-11-21 | 0.33 | Keskusta 94 | 0 | mp/mep | doering | 10 | Vanhanen I 759 | |
210 | 210 | 2004 | 1 | information society and media | 211 | 1 | Luxembourg 7 | Barroso I | 1 | 1129 | Reding, Viviane | 2004-11-22 | 2009-10-31 | 0.33 | Chrëschtlech Sozial Vollekspartei 1234 | 0 | mp/mep | doering | 10 | Juncker III 12 | |
211 | 211 | 2004 | 0 | enlargement | 212 | 1 | Finland 67 | Barroso I | 1 | 1265 | Rehn, Olli | 2004-11-22 | 2009-10-31 | 0.33 | Keskusta 94 | 0 | mp/mep | doering | 10 | Vanhanen I 759 | |
218 | 218 | 2004 | 1 | Health | 222 | 1 | Cyprus 51 | Barroso I | 0 | 12688 | Vassiliou, Androulla | 2008-03-03 | 2009-10-31 | 0.33 | Enomeni Dimokrates 1523 | 0 | mp/mep | ec.europa.eu | Aliança Povo Unido 11 | Christofias I 289 | |
219 | 219 | 2004 | 1 | transport | 223 | 1 | Italy 26 | Barroso I | 0 | 6887 | Tajani, Antonio | 2008-05-08 | 2009-10-31 | 0.33 | Forza Italia – Il Popolo della Libertà 596 | 0 | mp/mep | ec.europa.eu | Aliança Povo Unido 11 | Berlusconi IV 823 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
102 | 102 | 1985 | 1 | energy. Euratom | 102 | 1 | Luxembourg 7 | Delors I | 0 | 9661 | Mosar, Nicolas | 1985-01-06 | 1989-01-05 | 0.33 | Chrëschtlech Sozial Vollekspartei 1234 | 0 | mp -- secretary general of socialist party | doering | 10 | Santer I 175 | |
85 | 85 | 1981 | 0 | internal market/customs services+industrial innovation | 85 | 0 | Germany 54 | Thorn | 0 | 6286 | Narjes, Karl-Heinz | 1981-01-06 | 1985-01-05 | 0.33 | Christlich Demokratische Union 808 | 0 | mp | doering | Aliança Povo Unido 11 | Schmidt III 343 | |
101 | 101 | 1985 | 1 | small&medium businesses. investment policy | 101 | 0 | Spain 27 | Delors I | 0 | 15606 | Matutes, Abel | 1986-01-01 | 1989-01-05 | 0.33 | Alianza-Partido Popular 645 | 0 | mp | doering | Aliança Povo Unido 11 | Gonzalez I 238 | |
103 | 103 | 1985 | 1 | industry. it. research and science | 103 | 0 | Germany 54 | Delors I | 1 | 6286 | Narjes, Karl-Heinz | 1985-01-06 | 1989-01-05 | 0.33 | Christlich Demokratische Union 808 | 0 | mp | doering | 10 | Kohl II 346 | |
118 | 118 | 1989 | 1 | mediterranean policy and north-south relations | 118 | 0 | Spain 27 | Delors II | 1 | 15606 | Matutes, Abel | 1989-01-06 | 1993-01-05 | 0.33 | Alianza-Partido Popular 645 | 0 | mp | doering | Aliança Povo Unido 11 | Gonzalez II 834 | |
134 | 134 | 1993 | 1 | energy and transport | 134 | 0 | Spain 27 | Delors III | 1 | 15606 | Matutes, Abel | 1993-01-06 | 1994-04-27 | 0.33 | Alianza-Partido Popular 645 | 0 | mp | doering | Aliança Povo Unido 11 | Gonzalez III 37 | |
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 | |||
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 |
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 | |
209 | 209 | 2004 | 1 | science and research | 210 | 1 | Slovenia 60 | Barroso I | 0 | 12406 | Potocnik, Janez | 2004-11-22 | 2009-10-31 | 1.07 | no party affiliation 1370 | 0 | minister without portfolio (European affairs) | doering | 10 | Rop II 292 | |
244 | 244 | close to LDS according to Wikipedia | 2010 | 1 | environment | 248 | 1 | Slovenia 60 | Barroso II | 1 | 12406 | Potocnik, Janez | 2010-02-10 | 2014-10-31 | 1.07 | no party affiliation 1370 | 0 | minister without portfolio (European affairs) | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Pahor I 803 |
60 | 60 | 1973 | 1 | regional policy | 60 | 0 | United Kingdom 44 | Ortoli | 0 | 7552 | Thomson, George Morgan | 1973-01-06 | 1977-01-05 | 0.5 | Labour Party 1556 | 0 | minister without portfolio | doering | Aliança Povo Unido 11 | Heath 216 | |
182 | 182 | 1999 | 1 | external relations | 182 | 0 | United Kingdom 44 | Prodi | 0 | 3329 | Patten, Chris | 1999-09-16 | 2004-11-21 | 0.5 | Conservatives 773 | 0 | minister without portfolio | doering | Aliança Povo Unido 11 | Blair I 838 | |
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 | |
140 | 140 | 1993 | 1 | science. research and development | 140 | 0 | Italy 26 | Delors III | 0 | 1353 | Ruberti, Antonio | 1993-01-06 | 1995-01-05 | 0.52 | Partito Socialista Italiano 1475 | 0 | minister universities and scientific research | doering | 10 | Amato I 176 | |
122 | 122 | 1989 | 1 | science and research | 122 | 0 | Italy 26 | Delors II | 0 | 5166 | Pandolfi, Filippo Maria | 1989-01-06 | 1993-01-05 | 1.64 | Democrazia Cristiana 1633 | 0 | minister treasury | doering | 10 | De Mita 809 | |
203 | 203 | 2004 | 1 | competiton | 203 | 1 | Netherlands 8 | Barroso I | 0 | 10749 | Kroes, Neelie | 2004-11-22 | 2009-10-31 | 0.92 | Volkspartij voor Vrijheid en Democratie 1409 | 0 | minister transport | doering | 10 | Balkenende III 124 | |
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 | |
99 | 99 | 1985 | 1 | internal market. taxation. customs union | 99 | 0 | United Kingdom 44 | Delors I | 0 | 13788 | Cockfield, Francis A. | 1985-01-06 | 1989-01-05 | 0.99 | Conservatives 773 | 0 | minister trade | doering | 10 | Thatcher II 646 | |
44 | 44 | 1970 | 1 | president | 44 | 0 | Italy 26 | Malfatti/Manshold | 0 | 6848 | Malfatti, Franco Maria | 1970-07-01 | 1972-03-21 | 1.18 | Democrazia Cristiana 1633 | 1 | minister state participation in industry | doering | 10 | Rumor III 113 | |
147 | 147 | 1995 | 1 | environment and nuclear safety | 147 | 1 | Denmark 21 | Santer | 0 | 4640 | Bjerregaard, Ritt | 1995-01-06 | 1999-03-15 | 1.09 | Socialdemokraterne 1629 | 0 | minister social affairs | doering | 10 | Rasmussen N II 189 | |
170 | 170 | 1999 | 1 | research | 170 | 1 | Belgium 64 | Prodi | 0 | 1146 | Busquin, Philippe | 1999-09-16 | 2004-08-13 | 1.13 | Parti Socialiste 1378 | 0 | minister social affairs | doering | 10 | Verhofstadt I 193 | |
189 | 189 | 1999 | 1 | environment | 189 | 1 | Sweden 35 | Prodi | 0 | 1056 | Wallstroem, Margot | 1999-09-16 | 2004-11-21 | 1.22 | Socialdemokraterna 904 | 0 | minister social affairs | doering | 10 | Persson II 503 | |
214 | 214 | 2004 | 1 | institutional relations and communication strategy | 215 | 1 | Sweden 35 | Barroso I | 1 | 1056 | Wallstroem, Margot | 2004-11-22 | 2009-10-31 | 1.22 | Socialdemokraterna 904 | 0 | minister social affairs | doering | 10 | Persson III 641 | |
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 | |
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 | |
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 | |
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 | ||
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 | |
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 | |
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 | |||
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 | |||
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 | ||
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 | |
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 | |||
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 | |
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 | ||
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 | ||
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 | |||
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 | |
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 | ||
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 | |||||
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 | |
185 | 185 | 1999 | 1 | budget | 185 | 0 | Germany 54 | Prodi | 0 | 2882 | Schreyer, Michaele | 1999-09-16 | 2004-11-21 | 0.2 | Bündnis 90 / Die Grünen 772 | 0 | minister of a german state | doering | 10 | Schroeder I 107 | |
23 | 23 | 1967 | 1 | Transport policy | 23 | 1 | Luxembourg 7 | Rey | 0 | 6040 | Bodson, Victor | 1967-07-06 | 1970-06-30 | 1.07 | Lëtzebuerger Sozialistesch Aarbechterpartei 701 | 0 | minister justice | doering | 10 | Werner II 491 | |
132 | 132 | 1993 | 1 | social affairs and employment | 132 | 1 | Ireland 37 | Delors III | 0 | 6689 | Flynn, Padraig | 1993-01-06 | 1995-01-05 | 1.24 | Fianna Fáil 280 | 0 | minister justice | doering | 10 | Reynolds I 870 | |
153 | 153 | 1995 | 1 | employment and social affairs | 153 | 1 | Ireland 37 | Santer | 1 | 6689 | Flynn, Padraig | 1995-01-06 | 1999-03-15 | 1.24 | Fianna Fáil 280 | 0 | minister justice | doering | Aliança Povo Unido 11 | Bruton 573 |
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]) );