external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
308 rows sorted by end_date
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
178 | 178 | 1999 | 1 | research | 178 | 1 | Belgium 64 | Prodi | 0 | 14013 | Michel, Louis | 2004-08-12 | 2004-11-21 | 1.28 | Mouvement Réformateur 915 | 0 | minister foreign affairs | doering | 10 | Verhofstadt II 449 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
188 | 188 | 1999 | 1 | justice and home affairs | 188 | 1 | Portugal 63 | Prodi | 0 | 8039 | Vitorino, Antonio | 1999-09-16 | 2004-11-21 | 1.13 | Partido Socialista 725 | 0 | minister defence | doering | 10 | Guterres I 265 | |
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 | |
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 |
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 | |
198 | 198 | 2004 | 0 | justice. freedom and security | 198 | 1 | Italy 26 | Barroso I | 0 | 16235 | Frattini, Franco | 2004-11-22 | 2008-04-23 | 1.69 | Forza Italia – Il Popolo della Libertà 596 | 0 | minister foreign affairs | doering | 10 | Berlusconi II 256 | |
205 | 205 | 2004 | 1 | trade | 206 | 1 | United Kingdom 44 | Barroso I | 0 | 6255 | Mandelson, Peter | 2004-11-22 | 2008-10-03 | 0.5 | Labour Party 1556 | 0 | junior minister trade and industry (Northern Ireland) | doering | 10 | Blair II 19 | |
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 | |
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 |
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 | |
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 | |
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 | |
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 | |
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 | |
192 | 192 | 2004 | 1 | transport | 192 | 1 | France 43 | Barroso I | 1 | 10419 | Barrot, Jacques | 2004-11-22 | 2009-10-31 | 1.13 | Union pour un mouvement populaire | Les Républicains 658 | 0 | minister for labour and social affairs | doering | 10 | Raffarin III 802 | |
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 | |
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 | |
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 | |
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 | |
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 | |
202 | 202 | 2004 | 1 | taxation and customs union | 202 | 1 | Hungary 39 | Barroso I | 0 | 6668 | Kovacs, Laszlo | 2004-11-22 | 2009-10-31 | 1.51 | Magyar Szocialista Párt 1591 | 0 | minister foreign affairs | doering | 10 | Gyurcsany I 188 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
220 | 220 | 2004 | 1 | trade | 224 | 1 | United Kingdom 44 | Barroso I | 1 | 9961 | Ashton, Catherine | 2008-10-06 | 2009-10-31 | 1.0 | Labour Party 1556 | 0 | leader of the house of lords | ec.europa.eu | Aliança Povo Unido 11 | Brown 119 | |
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 | |
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 |
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 | |
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 |
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 | |
225 | 225 | 2010 | 1 | competition | 229 | 1 | Spain 27 | Barroso II | 1 | 15779 | Almunia, Joaquin | 2010-02-10 | 2014-10-31 | 1.03 | Partido Socialista Obrero Español 902 | 0 | minister employment | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Zapatero II 497 | |
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 | |
229 | 229 | member cabinett Popescu-Tariceanu III; Duration: 2007-04-05 – 2008-11-30. at the time of nomination other parties were in power | 2010 | 1 | agriculture and rural development | 233 | 1 | Romania 23 | Barroso II | 0 | 16867 | Cioloş, Dacian | 2010-02-10 | 2014-10-31 | 0.97 | no party affiliation 761 | 0 | minister agriculture and rural development | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Boc II 993 |
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 | |
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 |
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 | |
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 |
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 | |
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 |
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 | |
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 |
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 | |
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 |
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 | |
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 | |
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 | |
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 |
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 | |
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 |
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 | |
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 |
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 |
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 |
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 |
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]) );