external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
308 rows sorted by data_source
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
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 |
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 | |
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 | |
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 | |
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 | |
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 |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
291 | 291 | 2019 | 1 | Budget and Administration | 295 | 1 | Austria 59 | Von der Leyen | 1 | 1416 | Johannes Hahn | 2019-12-01 | 0.89 | Österreichische Volkspartei 1013 | 0 | federal minister of science and research | dr-08 | 10 | Bierlein II 1608 | ||
292 | 292 | 2019 | 1 | Trade | 296 | 1 | Ireland 37 | Von der Leyen | 1 | 16586 | Phil Hogan | 2019-12-01 | 0.93 | Fine Gael 1393 | 0 | minister of environment | dr-08 | 10 | Varadkar I 1511 | ||
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 | ||
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
274 | 274 | 2014 | 1 | Internal Market, Industry, Entrepreneurship and SMEs | 278 | 1 | Poland 74 | Juncker | 0 | 17114 | Bieńkowska, Elżbieta | 2014-11-01 | 2019-11-30 | 1.42 | Platforma Obywatelska 512 | 0 | deputy prime minister | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Kopacz 1146 | |
275 | 275 | druckman_roberts 2008: housing and regions | 2014 | 1 | Justice, Consumers and Gender Equality | 279 | 1 | Czech Republic 68 | Juncker | 0 | 17113 | Jourová, Vĕra | 2014-11-01 | 2019-11-30 | 0.95 | Akce nespokojených občanů 2011 2263 | 0 | minister for regional development | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Sobotka 1072 |
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 | |
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 |
278 | 278 | 2014 | 1 | Competition | 282 | 1 | Denmark 21 | Juncker | 0 | 15513 | Vestager, Margrethe | 2014-11-01 | 2019-11-30 | 1.27 | Det Radikale Venstre 211 | 0 | minister of economy and interior | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Thorning-Schmidt II 1074 | |
279 | 279 | 2014 | 1 | Research, Science and Innovation | 283 | 1 | Portugal 63 | Juncker | 0 | 17110 | Moedas, Carlos | 2014-11-01 | 2019-11-30 | 0.5 | Partido Social Democrata 1273 | 0 | secretary of state | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Passos Coelho I 917 | |
280 | 280 | 2010 | 1 | Consumer Policy | 284 | 1 | Croatia 62 | Barroso II | 0 | 17109 | Mimica, Neven | 2010-02-10 | 2014-10-31 | 1.16 | Socijaldemokratska partija Hrvatske 1493 | 0 | deputy prime minister | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Kosor I 1055 | |
281 | 281 | 2014 | 1 | transport | 285 | 1 | Slovenia 60 | Juncker | 0 | 17121 | Bulc, Violeta | 2014-11-01 | 2019-11-30 | 1.07 | Stranka modernega 2333 | 0 | minister without portfolio | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Cerar 1144 | |
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 | ||
288 | 288 | 2019 | 1 | Values and Transparency | 292 | 1 | Czech Republic 68 | Von der Leyen | 1 | 17113 | Jourová, Vĕra | 2019-12-01 | 0.95 | Akce nespokojených občanů 2011 2263 | 0 | minister for regional development | dw-05 | 10 | Babis II 1534 | ||
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 | ||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |
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 |
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]) );