external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
308 rows sorted by portfolio
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108 | 108 | 1985 | 1 | competition. social affairs | 108 | 1 | Ireland 37 | Delors I | 0 | 12520 | Sutherland, Peter D. | 1985-01-06 | 1989-01-05 | 0.9 | Fine Gael 1393 | 0 | attorney general | doering | 10 | Fitzgerald II 867 | |
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 | |
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 | |
116 | 116 | 1989 | 0 | cultural affairs (broadcasting policy) | 116 | 1 | Luxembourg 7 | Delors II | 0 | 8707 | Dondelinger, Jean | 1989-01-06 | 1993-01-05 | 0.33 | no party affiliation 1002 | 0 | MEP 1974-79; diplomat -- Luxembourgs 'top diplomat' (FT) | doering | 12 | Santer I 175 | |
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 | |
133 | 133 | 1993 | 1 | development | 133 | 0 | Spain 27 | Delors III | 1 | 10937 | Marin, Manuel | 1993-01-06 | 1995-01-05 | 0.5 | Partido Socialista Obrero Español 902 | 0 | junior minister relations to EC | doering | 10 | Gonzalez III 37 | |
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 | |
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 |
89 | 89 | 1981 | 1 | development aid | 89 | 0 | France 43 | Thorn | 0 | 12643 | Pisani, Edgard | 1981-01-06 | 1984-12-03 | 1.24 | Parti socialiste 1539 | 0 | minister agriculture | doering | Aliança Povo Unido 11 | Barre II 72 | |
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 |
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 |
180 | 180 | 1999 | 1 | development and humanitarian aid | 180 | 1 | Denmark 21 | Prodi | 0 | 11480 | Nielson, Poul | 1999-09-16 | 2004-11-21 | 0.83 | Socialdemokraterne 1629 | 0 | minister energy | doering | 10 | Rasmussen N IV 630 | |
207 | 207 | 2004 | 1 | development and humanitarian aid | 208 | 1 | Belgium 64 | Barroso I | 1 | 14013 | Michel, Louis | 2004-11-22 | 2009-07-17 | 1.28 | Mouvement Réformateur 915 | 0 | minister foreign affairs | doering | 10 | Verhofstadt II 449 | |
224 | 224 | 2004 | 1 | development and humanitarian aid | 228 | 1 | Belgium 64 | Barroso I | 0 | 15520 | De Gucht, Karel | 2009-07-17 | 2009-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 | Rompuy 80 | |
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 |
104 | 104 | 1985 | 1 | development. enlargement | 104 | 0 | Italy 26 | Delors I | 1 | 6114 | Natali, Lorenzo | 1985-01-06 | 1989-01-05 | 0.83 | Democrazia Cristiana 1633 | 0 | minister agriculture | doering | 10 | Craxi I 334 | |
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 | |
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 | |
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 | |
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 | |
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 |
115 | 115 | 1989 | 1 | economic and financial affairs | 115 | 1 | Denmark 21 | Delors II | 1 | 6634 | Christophersen, Henning | 1989-01-06 | 1993-01-05 | 1.88 | Venstre 1605 | 0 | minister finance | doering | 10 | Schluter IV 57 | |
131 | 131 | 1993 | 1 | economic and financial affairs | 131 | 1 | Denmark 21 | Delors III | 1 | 6634 | Christophersen, Henning | 1993-01-06 | 1995-01-05 | 1.88 | Venstre 1605 | 0 | minister finance | doering | 10 | Schluter V 11 | |
163 | 163 | 1995 | 0 | economic and financial affairs | 163 | 0 | France 43 | Santer | 0 | 11538 | Silguy, Yves-Thibault de | 1995-01-06 | 1999-03-15 | 0.2 | Rassemblement pour la république 138 | 0 | diplomat | doering | 10 | Balladur 318 | |
166 | 166 | 1999 | 1 | economic and monetary affairs | 166 | 0 | Spain 27 | Prodi | 0 | 15779 | Almunia, Joaquin | 2004-04-26 | 2009-10-31 | 1.03 | Partido Socialista Obrero Español 902 | 0 | minister employment | doering | Aliança Povo Unido 11 | Zapatero I 806 | |
186 | 186 | no formal party member | 1999 | 1 | economic and monetary affairs | 186 | 0 | Spain 27 | Prodi | 0 | 12745 | Solbes, Pedro | 1999-09-16 | 2004-04-25 | 1.64 | Partido Socialista Obrero Español 902 | 0 | minister economic and financial affairs | doering | Aliança Povo Unido 11 | Aznar I 370 |
191 | 191 | 2004 | 1 | economic and monetary affairs | 191 | 1 | Spain 27 | Barroso I | 1 | 15779 | Almunia, Joaquin | 2004-11-22 | 2009-10-31 | 1.03 | Partido Socialista Obrero Español 902 | 0 | minister employment | doering | 10 | Zapatero I 806 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 |
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 | |
172 | 172 | 1999 | 1 | employment and social affairs | 172 | 1 | Greece 41 | Prodi | 0 | 16154 | Diamantopoulou, Anna | 1999-09-16 | 2004-03-10 | 0.5 | Panellinio Sosialistikó Kínima 1338 | 0 | junior minister industry | doering | 10 | Simitis II 33 | |
173 | 173 | 1999 | 1 | employment and social affairs | 173 | 1 | Greece 41 | Prodi | 0 | 15665 | Dimas, Stavros | 2004-03-11 | 2009-10-31 | 0.99 | Néa Đimokratía 47 | 0 | minister industry | doering | 10 | Karamanlis Kos I 876 | |
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 | |
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 | |
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 | |
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 | |
114 | 114 | 1989 | 1 | energy | 114 | 1 | Portugal 63 | Delors II | 0 | 13398 | Cardoso e Cunha, Antonio | 1989-01-06 | 1993-01-05 | 0.83 | Partido Social Democrata 1273 | 0 | minister agriculture and fisheries | doering | 10 | Silva II 718 | |
208 | 208 | 2004 | 1 | energy | 209 | 1 | Latvia 55 | Barroso I | 0 | 16359 | Piebalgs, Andris | 2004-11-22 | 2009-10-31 | 1.64 | Latvijas Ceļš 526 | 0 | minister finance | doering | Aliança Povo Unido 11 | Emsis 153 | |
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 | |
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 | |
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 | |
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 | |
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 | |
47 | 47 | 1973 | 0 | energy. research/science and education | 47 | 0 | Germany 54 | Ortoli | 0 | 16418 | Brunner, Guido | 1974-11-11 | 1977-01-05 | 0.2 | Freie Demokratische Partei 543 | 0 | diplomat | doering | 10 | Schmidt I 252 | |
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 | |
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 | |
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 | |
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 | |
86 | 86 | 1981 | 1 | enlargement/environment protection/nuclear safety | 86 | 0 | Italy 26 | Thorn | 1 | 6114 | Natali, Lorenzo | 1981-01-06 | 1985-01-05 | 0.83 | Democrazia Cristiana 1633 | 0 | minister agriculture | doering | 10 | Forlani 464 | |
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 | |
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 | |
124 | 124 | 1989 | 1 | environment | 124 | 0 | Italy 26 | Delors II | 1 | 10310 | Ripa di Meana, Carlo | 1989-01-06 | 1992-06-01 | 0.33 | Partito Socialista Italiano 1475 | 0 | mep | doering | 10 | De Mita 809 | |
138 | 138 | 1993 | 1 | environment | 138 | 1 | Greece 41 | Delors III | 0 | 9502 | Paleokrassas, Ioannis L. | 1993-01-06 | 1995-01-05 | 1.64 | Néa Đimokratía 47 | 0 | minister finance | doering | 10 | Mitsotakis Kon 362 | |
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 | |
194 | 194 | 2004 | 1 | environment | 194 | 1 | Greece 41 | Barroso I | 1 | 15665 | Dimas, Stavros | 2004-11-22 | 2009-10-31 | 0.99 | Néa Đimokratía 47 | 0 | minister industry | doering | 10 | Karamanlis Kos I 876 | |
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 |
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 | |
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 | |
98 | 98 | 1985 | 1 | environment. forests. transport | 98 | 0 | United Kingdom 44 | Delors I | 0 | 16674 | Clinton Davis, Stanley | 1985-01-06 | 1989-01-05 | 0.5 | Labour Party 1556 | 0 | junior minister | doering | Aliança Povo Unido 11 | Thatcher II 646 | |
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 | |
129 | 129 | 1993 | 1 | external economic affairs | 129 | 0 | United Kingdom 44 | Delors III | 1 | 14789 | Brittan, Leon | 1993-01-06 | 1995-01-05 | 1.32 | Conservatives 773 | 0 | minister interior | doering | 10 | Major II 678 | |
149 | 149 | 1995 | 1 | external economic affairs | 149 | 0 | United Kingdom 44 | Santer | 1 | 14789 | Brittan, Leon | 1995-01-06 | 1999-03-15 | 1.32 | Conservatives 773 | 0 | minister interior | doering | 10 | Major II 678 | |
130 | 130 | 1993 | 1 | external political relations | 130 | 1 | Netherlands 8 | Delors III | 0 | 14964 | Broek, Hans van den | 1993-01-06 | 1995-01-05 | 1.16 | Christen Democratisch Appèl 235 | 0 | minister foreign affairs | doering | 10 | Lubbers III 148 | |
150 | 150 | 1995 | 1 | external political relations (Europe) | 150 | 1 | Netherlands 8 | Santer | 1 | 14964 | Broek, Hans van den | 1995-01-06 | 1999-03-15 | 1.16 | Christen Democratisch Appèl 235 | 0 | minister foreign affairs | doering | Aliança Povo Unido 11 | Kok I 637 | |
58 | 58 | 1973 | 1 | external relations | 58 | 0 | United Kingdom 44 | Ortoli | 0 | 8804 | Soames, Christopher | 1973-01-06 | 1977-01-05 | 0.92 | Conservatives 773 | 0 | minister agriculture and fisheries | doering | 10 | Heath 216 | |
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 | |
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 | |
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 | |
111 | 111 | 1989 | 0 | external relations and trade | 111 | 1 | Netherlands 8 | Delors II | 1 | 13160 | Andriessen, Frans | 1989-01-06 | 1993-01-05 | 2.02 | Christen Democratisch Appèl 235 | 0 | minister finance | doering | 10 | Lubbers II 550 | |
162 | 162 | 1995 | 1 | external relations with africa and asia | 162 | 1 | Portugal 63 | Santer | 1 | 9061 | Pinheiro, Joao de Deus | 1995-01-06 | 1999-03-15 | 1.33 | Partido Social Democrata 1273 | 0 | minister foreign affairs | doering | 10 | Silva III 282 | |
97 | 97 | 1985 | 1 | external relations. trade | 97 | 1 | Belgium 64 | Delors I | 0 | 11859 | Clercq, Willy de | 1985-01-06 | 1989-01-05 | 1.35 | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten 1110 | 1 | minister finance | doering | 10 | Martens V 724 | |
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 | |
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 | |
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 | |
94 | 94 | 1985 | 1 | fisheries | 94 | 1 | Portugal 63 | Delors I | 1 | 13398 | Cardoso e Cunha, Antonio | 1986-01-01 | 1989-01-05 | 0.83 | Partido Social Democrata 1273 | 0 | minister agriculture and fisheries | doering | 10 | Silva I 734 | |
193 | 193 | 2004 | 1 | fisheries and maritim affairs | 193 | 1 | Malta 72 | Barroso I | 0 | 9806 | Borg, Joe | 2004-11-22 | 2009-10-31 | 1.43 | Partit Nazzjonalista 984 | 0 | minister foreign affairs | doering | 10 | Gonzi I 298 | |
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 |
39 | 39 | 1970 | 1 | foreign trade and foreign affairs | 39 | 0 | Germany 54 | Malfatti/Manshold | 0 | 6242 | Dahrendorf, Ralf | 1970-07-01 | 1973-01-05 | 0.82 | Freie Demokratische Partei 543 | 0 | junior minister foreign affairs | doering | 10 | Brandt I 358 | |
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 |
204 | 204 | 2004 | 1 | health and consumer affairs | 204 | 1 | Cyprus 51 | Barroso I | 0 | 8533 | Kyprianou, Markos | 2004-11-22 | 2008-03-02 | 1.64 | Dimokratikó Kómma 851 | 0 | minister finance | doering | 10 | Papadopoulos I 342 | |
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 |
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 |
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 | |
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 | |
241 | 241 | position score 0.65 second or subordinate ministers | 2010 | 1 | home affairs | 245 | 1 | Sweden 35 | Barroso II | 0 | 9042 | Malmström, Cecilia | 2010-02-10 | 2014-10-31 | 0.65 | Folkpartiet 892 | 0 | minister european affairs | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Reinfeldt I 475 |
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 | |
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 |
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]) );