external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
308 rows sorted by person_id
This data as json, CSV (advanced)
Suggested facets: comment, commission_year, elected, commission_name, incumbent, president, data_source, government_party, start_date (date), end_date (date)
country_id 28 ✖
- Italy 35
- France 32
- Germany 31
- United Kingdom 20
- Belgium 19
- Luxembourg 17
- Netherlands 17
- Spain 16
- Ireland 13
- Denmark 12
- Greece 11
- Portugal 9
- Finland 7
- Sweden 6
- Austria 6
- Slovakia 5
- Bulgaria 5
- Lithuania 5
- Cyprus 5
- Malta 5
- Poland 5
- Romania 4
- Hungary 4
- Latvia 4
- Slovenia 4
- Czech Republic 4
- Estonia 4
- Croatia 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |
155 | 155 | 1995 | 1 | transport | 155 | 0 | United Kingdom 44 | Santer | 0 | 217 | Kinnock, Neil | 1995-01-06 | 1999-03-15 | 1.0 | Labour Party 1556 | 0 | leader oppostion party | doering | Aliança Povo Unido 11 | Major II 678 | |
175 | 175 | 1999 | 1 | transport | 175 | 0 | United Kingdom 44 | Prodi | 1 | 217 | Kinnock, Neil | 1999-09-16 | 2004-11-21 | 1.0 | Labour Party 1556 | 0 | leader oppostion party | doering | Aliança Povo Unido 11 | Blair I 838 | |
5 | 5 | 1958 | 1 | internal market | 5 | 0 | Italy 26 | Hallstein I | 0 | 366 | Malvestiti, Piero | 1958-01-10 | 1959-10-15 | 0.87 | Democrazia Cristiana 1633 | 0 | minister industry and trade | doering | 10 | Zoli 280 | |
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 |
206 | 206 | 2004 | 1 | internal market and services | 207 | 1 | Ireland 37 | Barroso I | 0 | 506 | McCreevy, Charly | 2004-11-22 | 2009-10-31 | 1.83 | Fianna Fáil 280 | 0 | minister finance | doering | 10 | Ahern II 179 | |
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 | |
195 | 195 | 2004 | 1 | external relations + european neighbourhood policy | 195 | 1 | Austria 59 | Barroso I | 0 | 706 | Ferrero-Waldner, Benita | 2004-11-22 | 2009-10-31 | 1.18 | Österreichische Volkspartei 1013 | 0 | minister foreign affairs | doering | 10 | Schuessel III 257 | |
64 | 64 | 1977 | 1 | taxation/consumer affairs/transport/EP relations | 64 | 1 | Ireland 37 | Jenkins | 0 | 726 | Burke, Richard | 1977-01-06 | 1981-01-05 | 1.19 | Fine Gael 1393 | 0 | minister education | doering | 10 | Cosgrave L 315 | |
77 | 77 | time as commissioner was interrupted | 1981 | 1 | taxation/consumer affairs/transport/EP relations | 77 | 1 | Ireland 37 | Thorn | 0 | 726 | Burke, Richard | 1982-04-01 | 1985-01-05 | 1.19 | Fine Gael 1393 | 0 | minister education | doering | 10 | Haughey II 54 |
9 | 9 | 1958 | 1 | external affairs | 9 | 1 | Belgium 64 | Hallstein I | 0 | 801 | Rey, Jean | 1958-01-10 | 1962-01-09 | 1.02 | Liberale Partij – Parti libéral 63 | 0 | minister economic affairs | doering | 10 | Van Acker IV 745 | |
18 | 18 | 1962 | 1 | external affairs | 18 | 1 | Belgium 64 | Hallstein II | 1 | 801 | Rey, Jean | 1962-01-10 | 1967-07-05 | 1.02 | Liberale Partij – Parti libéral 63 | 0 | minister economic affairs | doering | Aliança Povo Unido 11 | Lefevre 613 | |
35 | 35 | 1967 | 1 | president | 35 | 1 | Belgium 64 | Rey | 1 | 801 | Rey, Jean | 1967-07-06 | 1970-06-30 | 1.02 | Liberale Partij – Parti libéral 63 | 1 | minister economic affairs | doering | 10 | Vanden Boeynants I 353 | |
197 | 197 | 2004 | 0 | agriculture and rural development | 197 | 1 | Denmark 21 | Barroso I | 0 | 1017 | Fischer Boel, Mariann | 2004-11-22 | 2009-10-31 | 1.0 | Venstre 1605 | 0 | minister food. agriculture and fisheries | doering | 10 | Rasmussen F I 482 | |
57 | 57 | 1973 | 1 | taxation/financial institutions/energy/EURATOM | 57 | 1 | Belgium 64 | Ortoli | 0 | 1047 | Simonet, Henri | 1973-01-06 | 1977-01-05 | 1.02 | Belgische Socialistische Partij – Parti Socialiste Belge 167 | 0 | minister economy | doering | 10 | Eyskens G V 448 | |
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 | |
137 | 137 | 1993 | 1 | energy and transport | 137 | 0 | Spain 27 | Delors III | 0 | 1092 | Oreja Aguirre, Marcelino | 1994-04-27 | 1995-01-05 | 1.43 | Alianza-Partido Popular 645 | 0 | junior minister foreign affairs | doering | Aliança Povo Unido 11 | Gonzalez IV 654 | |
160 | 160 | 1995 | 1 | relations with ep | 160 | 0 | Spain 27 | Santer | 1 | 1092 | Oreja Aguirre, Marcelino | 1995-01-06 | 1999-03-15 | 1.43 | Alianza-Partido Popular 645 | 0 | minister foreign affairs | doering | Aliança Povo Unido 11 | Gonzalez IV 654 | |
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 | |
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 | |
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 | |
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 | |
42 | 42 | 1970 | 1 | agriculture | 42 | 0 | Italy 26 | Malfatti/Manshold | 0 | 1158 | Scarascia-Mugnozza, Carlo | 1972-03-22 | 1973-01-05 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister justice | doering | 10 | Andreotti I 398 | |
56 | 56 | 1973 | 1 | environment consumer protection transport informat | 56 | 0 | Italy 26 | Ortoli | 1 | 1158 | Scarascia-Mugnozza, Carlo | 1973-01-06 | 1977-01-05 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister justice | doering | 10 | Andreotti II 439 | |
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 | |
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 | |
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 | |
199 | 199 | 2004 | 1 | financial programming and budget | 199 | 1 | Lithuania 15 | Barroso I | 0 | 1266 | Grybauskaite, Dalia | 2004-11-22 | 2009-07-01 | 1.74 | no party affiliation 58 | 0 | minister finance | doering | 10 | Brazauskas III 1634 | |
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 | |
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 | |
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 |
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 | ||
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 | |||
217 | 217 | 2004 | 0 | multilingualism | 221 | 1 | Romania 23 | Barroso I | 0 | 1763 | Orban, Leonard | 2007-01-01 | 2009-10-31 | 0.2 | no party affiliation 761 | 0 | chief accession negotiator | doering | 12 | Popescu-Tariceanu II 28 | |
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 | |
216 | 216 | 2004 | 1 | consumer protection | 220 | 1 | Bulgaria 10 | Barroso I | 0 | 2129 | Kunewa, Meglena | 2007-01-01 | 2009-10-31 | 1.29 | Natsionalno Dvizhenie Simeon Vtori 544 | 0 | minister european affairs | doering | Aliança Povo Unido 11 | Stanishev 425 | |
27 | 27 | 1967 | 1 | energy | 27 | 0 | Germany 54 | Rey | 0 | 2142 | Haferkamp, Wilhelm | 1967-07-06 | 1970-06-30 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | member state assembly (NRW) | doering | 10 | Kiesinger 170 | |
41 | 41 | 1970 | 1 | energy | 41 | 0 | Germany 54 | Malfatti/Manshold | 1 | 2142 | Haferkamp, Wilhelm | 1970-07-01 | 1973-01-05 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | member state assembly (NRW) | doering | 10 | Brandt I 358 | |
53 | 53 | 1973 | 1 | economic/financial affairs. credit/investment | 53 | 0 | Germany 54 | Ortoli | 1 | 2142 | Haferkamp, Wilhelm | 1973-01-06 | 1977-01-05 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | member state assembly (NRW) | doering | 10 | Brandt II 871 | |
69 | 69 | 1977 | 1 | external relations | 69 | 0 | Germany 54 | Jenkins | 1 | 2142 | Haferkamp, Wilhelm | 1977-01-06 | 1981-01-05 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | member state assembly (NRW) | doering | 10 | Schmidt II 459 | |
84 | 84 | 1981 | 1 | external relations | 84 | 0 | Germany 54 | Thorn | 1 | 2142 | Haferkamp, Wilhelm | 1981-01-06 | 1985-01-05 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | member state assembly (NRW) | doering | 10 | Schmidt III 343 | |
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 | |
176 | 176 | 1999 | 0 | trade | 176 | 0 | France 43 | Prodi | 0 | 2329 | Lamy, Pascal | 1999-09-16 | 2004-11-21 | 0.2 | Parti socialiste 1539 | 0 | administrative career | doering | 10 | Jospin 481 | |
120 | 120 | 1989 | 1 | transport | 120 | 1 | Belgium 64 | Delors II | 0 | 2416 | Miert, Karl van | 1989-01-06 | 1993-01-05 | 1.0 | Socialistische Partij 1029 | 0 | leader oppostion party | doering | 10 | Martens VIII 457 | |
135 | 135 | 1993 | 1 | competition | 135 | 1 | Belgium 64 | Delors III | 1 | 2416 | Miert, Karl van | 1993-01-06 | 1995-01-05 | 1.0 | Socialistische Partij 1029 | 0 | leader oppostion party | doering | 10 | Dehaene I 624 | |
158 | 158 | 1995 | 1 | competition | 158 | 1 | Belgium 64 | Santer | 1 | 2416 | Miert, Karl van | 1995-01-06 | 1999-03-15 | 1.0 | Socialistische Partij 1029 | 0 | leader oppostion party | doering | 10 | Dehaene I 624 | |
161 | 161 | 1995 | 1 | energy and EURATOM | 161 | 1 | Greece 41 | Santer | 0 | 2471 | Papaoutsis, Christos | 1995-01-06 | 1999-03-15 | 0.33 | Panellinio Sosialistikó Kínima 1338 | 0 | mep | doering | 10 | Papandreou A IV 74 | |
152 | 152 | 1995 | 1 | agriculture and rural development | 152 | 1 | Austria 59 | Santer | 0 | 2619 | Fischler, Franz | 1995-01-06 | 1999-03-15 | 0.86 | Österreichische Volkspartei 1013 | 0 | minister agriculture and forestry | doering | 10 | Vranitzky IV 294 | |
174 | 174 | 1999 | 1 | agriculture and rural development | 174 | 1 | Austria 59 | Prodi | 1 | 2619 | Fischler, Franz | 1999-09-16 | 2004-11-21 | 0.86 | Österreichische Volkspartei 1013 | 0 | minister agriculture and forestry | doering | 10 | Klima I 412 | |
11 | 11 | 1958 | 1 | president | 11 | 0 | Germany 54 | Hallstein I | 0 | 2737 | Hallstein, Walter | 1958-01-10 | 1962-01-09 | 0.84 | Christlich Demokratische Union 808 | 1 | junior minister foreign affairs | doering | 10 | Adenauer V 793 | |
21 | 21 | 1962 | 1 | president | 21 | 0 | Germany 54 | Hallstein II | 1 | 2737 | Hallstein, Walter | 1962-01-10 | 1967-07-05 | 0.84 | Christlich Demokratische Union 808 | 1 | junior minister foreign affairs | doering | 10 | Adenauer VII 62 | |
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 | |
112 | 112 | 1989 | 1 | industry and single market | 112 | 0 | Germany 54 | Delors II | 0 | 2913 | Bangemann, Martin | 1989-01-06 | 1993-01-05 | 0.99 | Freie Demokratische Partei 543 | 0 | minister economic affairs | doering | 10 | Kohl III 286 | |
128 | 128 | 1993 | 1 | industry | 128 | 0 | Germany 54 | Delors III | 1 | 2913 | Bangemann, Martin | 1993-01-06 | 1995-01-05 | 0.99 | Freie Demokratische Partei 543 | 0 | minister economic affairs | doering | 10 | Kohl IV 862 | |
146 | 146 | 1995 | 1 | industry | 146 | 0 | Germany 54 | Santer | 1 | 2913 | Bangemann, Martin | 1995-01-06 | 1999-03-15 | 0.99 | Freie Demokratische Partei 543 | 0 | minister economic affairs | doering | 10 | Kohl V 778 | |
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 | |
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 | |
221 | 221 | 2004 | 1 | financial programming and budget | 225 | 1 | Lithuania 15 | Barroso I | 0 | 3567 | Šemeta, Algirdas | 2009-07-01 | 2009-10-31 | 1.74 | Tėvynės sąjunga 1045 | 1 | minister finance | munzinger | 10 | Kubilius II 688 | |
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 | |
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 | |
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 | |
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 | |
31 | 31 | 1967 | 1 | External Affairs | 31 | 0 | Italy 26 | Rey | 0 | 3980 | Martino, Edoardo | 1967-07-06 | 1970-06-30 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister foreign affairs | doering | 10 | Moro III 433 | |
10 | 10 | 1958 | 1 | 10 | 1 | Luxembourg 7 | Hallstein I | 0 | 4128 | Schaus, Lambert | 1958-01-10 | 1962-01-09 | 1.07 | Chrëschtlech Sozial Vollekspartei 1234 | 0 | minister economy and defense | doering | 10 | Bech V 500 | ||
20 | 20 | 1962 | 1 | 20 | 1 | Luxembourg 7 | Hallstein II | 1 | 4128 | Schaus, Lambert | 1962-01-10 | 1967-07-05 | 1.07 | Chrëschtlech Sozial Vollekspartei 1234 | 0 | minister economy and defense | doering | 10 | Werner I 832 | ||
200 | 200 | no party affiliation but government member | 2004 | 1 | regional policy | 200 | 1 | Poland 74 | Barroso I | 0 | 4141 | Huebner, Danuta | 2004-11-22 | 2009-07-04 | 1.03 | no party affiliation 1011 | 0 | minister european affairs | doering | 10 | Belka 322 |
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 | |
181 | 181 | 1999 | 0 | relations with ep. transport and energy | 181 | 0 | Spain 27 | Prodi | 0 | 4322 | Loyola de Palacio | 1999-09-16 | 2004-11-21 | 0.92 | Alianza-Partido Popular 645 | 0 | minister agriculture. fisheries and food | doering | 10 | Aznar I 370 | |
1 | 1 | 1958 | 1 | internal market | 1 | 0 | Italy 26 | Hallstein I | 0 | 4616 | Caron, Giuseppe | 1959-12-09 | 1962-01-09 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister civilian aviation | doering | 10 | Segni II 372 | |
12 | 12 | 1962 | 1 | internal market | 12 | 0 | Italy 26 | Hallstein II | 1 | 4616 | Caron, Giuseppe | 1962-01-10 | 1963-05-16 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister civilian aviation | doering | 10 | Fanfani III 810 | |
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 | |
62 | 62 | 1973 | 1 | president | 62 | 0 | France 43 | Ortoli | 0 | 4661 | Ortoli, Francois-Xavier | 1973-01-06 | 1977-01-05 | 1.92 | Gaulliste 1094 | 1 | minister economy and finance | doering | 10 | Messmer I 430 | |
71 | 71 | 1977 | 0 | economics + finance/credits + investment/statistical office | 71 | 0 | France 43 | Jenkins | 1 | 4661 | Ortoli, Francois-Xavier | 1977-01-06 | 1981-01-05 | 1.92 | Gaulliste 1094 | 0 | minister economy and finance | doering | 10 | Barre I 21 | |
88 | 88 | 1981 | 0 | economics+finance/credits+investment/statistical office | 88 | 0 | France 43 | Thorn | 1 | 4661 | Ortoli, Francois-Xavier | 1981-01-06 | 1984-10-26 | 1.92 | Gaulliste 1094 | 0 | minister economy and finance | doering | 10 | Barre II 72 | |
75 | 75 | 1977 | 1 | president | 75 | 0 | United Kingdom 44 | Jenkins | 0 | 4731 | Jenkins, Roy | 1977-01-06 | 1981-01-05 | 1.64 | Labour Party 1556 | 1 | chancellor of the exchequer | doering | 10 | Callaghan 590 | |
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 | ||
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 |
156 | 156 | 1995 | 1 | budget | 156 | 1 | Finland 67 | Santer | 0 | 5160 | Liikanen, Erkki Antero | 1995-01-06 | 1999-03-15 | 2.01 | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | 0 | minister finance | doering | Aliança Povo Unido 11 | Aho II 206 | |
177 | 177 | 1999 | 1 | budget | 177 | 1 | Finland 67 | Prodi | 1 | 5160 | Liikanen, Erkki Antero | 1999-09-16 | 2004-07-11 | 2.01 | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | 0 | minister finance | doering | 10 | Lipponen II 352 | |
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 | |
143 | 143 | 1993 | 1 | agriculture | 143 | 1 | Luxembourg 7 | Delors III | 0 | 5363 | Steichen, Rene | 1993-01-06 | 1995-01-05 | 1.07 | Chrëschtlech Sozial Vollekspartei 1234 | 0 | minister agriculture | doering | 10 | Santer II 418 | |
196 | 196 | 2004 | 1 | education. training. culture and mulitlingualism | 196 | 1 | Slovakia 1 | Barroso I | 0 | 5535 | Figel, Jan | 2004-11-22 | 2009-10-01 | 0.5 | Kresťanskodemokratické hnutie 1432 | 0 | junior minister foreign affairs | doering | 10 | Dzurinda II 547 | |
126 | 126 | 1989 | 1 | taxation (fiscal hamonisation) | 126 | 0 | France 43 | Delors II | 0 | 5704 | Scrivener, Christiane | 1989-01-06 | 1993-01-05 | 0.5 | Union pour la démocratie française | Mouvement démocrate 509 | 0 | junior minister cosummer affairs | doering | Aliança Povo Unido 11 | Rocard II 712 | |
142 | 142 | 1993 | 1 | customs. taxation | 142 | 0 | France 43 | Delors III | 1 | 5704 | Scrivener, Christiane | 1993-01-06 | 1995-01-05 | 0.5 | Union pour la démocratie française | Mouvement démocrate 509 | 0 | junior minister consumer affairs | doering | Aliança Povo Unido 11 | Beregovoy I 199 | |
187 | 187 | 1999 | 1 | enlargement | 187 | 0 | Germany 54 | Prodi | 0 | 5799 | Verheugen, Guenther | 1999-09-16 | 2004-11-21 | 0.82 | Sozialdemokratische Partei Deutschlands 558 | 0 | junior minister foreign affairs | doering | 10 | Schroeder I 107 | |
213 | 213 | 2004 | 1 | enterprise and industry | 214 | 1 | Germany 54 | Barroso I | 1 | 5799 | Verheugen, Guenther | 2004-11-22 | 2009-10-31 | 0.82 | Sozialdemokratische Partei Deutschlands 558 | 0 | junior minister foreign affairs | doering | 10 | Schroeder II 529 | |
110 | 110 | 1985 | 1 | president | 110 | 0 | France 43 | Delors I | 0 | 5804 | Delors, Jacques | 1985-01-06 | 1989-01-05 | 1.92 | Parti socialiste 1539 | 1 | minister economy and defense | doering | 10 | Fabius 843 | |
127 | 127 | 1989 | 1 | president and monetary affairs | 127 | 0 | France 43 | Delors II | 1 | 5804 | Delors, Jacques | 1989-01-06 | 1993-01-05 | 1.92 | Parti socialiste 1539 | 1 | minister economy and defense | doering | 10 | Rocard II 712 | |
145 | 145 | 1993 | 1 | president | 145 | 0 | France 43 | Delors III | 1 | 5804 | Delors, Jacques | 1993-01-06 | 1995-01-05 | 1.92 | Parti socialiste 1539 | 1 | minister economy and defense | doering | 10 | Beregovoy I 199 | |
72 | 72 | 1977 | 1 | budget a financial control. finacial institutions | 72 | 0 | United Kingdom 44 | Jenkins | 0 | 5942 | Tugendhat, Christopher S. | 1977-01-06 | 1981-01-05 | 0.33 | Conservatives 773 | 0 | mep | doering | Aliança Povo Unido 11 | Callaghan 590 | |
91 | 91 | 1981 | 1 | budget a financial control. finacial institutions | 91 | 0 | United Kingdom 44 | Thorn | 1 | 5942 | Tugendhat, Christopher S. | 1981-01-06 | 1985-01-05 | 0.33 | Conservatives 773 | 0 | mep | doering | 10 | Thatcher I 273 | |
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 | |
87 | 87 | 1981 | 1 | personnel and community budget | 87 | 1 | Ireland 37 | Thorn | 0 | 6073 | O'Kennedy, Michael | 1981-01-06 | 1982-03-03 | 1.83 | Fianna Fáil 280 | 0 | minister for foreign affairs and finance | doering | 10 | Haughey I 442 | |
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 | |
70 | 70 | 1977 | 1 | enlargement/environment protection/nuclear safety | 70 | 0 | Italy 26 | Jenkins | 0 | 6114 | Natali, Lorenzo | 1977-01-06 | 1981-01-05 | 0.83 | Democrazia Cristiana 1633 | 0 | minister agriculture | doering | 10 | Andreotti III 140 |
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]) );