external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
308 rows sorted by commission_name
This data as json, CSV (advanced)
government_party 3 ✖
- 10 150
- Aliança Povo Unido 40
- 12 18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
132 | 132 | 1993 | 1 | social affairs and employment | 132 | 1 | Ireland 37 | Delors III | 0 | 6689 | Flynn, Padraig | 1993-01-06 | 1995-01-05 | 1.24 | Fianna Fáil 280 | 0 | minister justice | doering | 10 | Reynolds I 870 | |
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 | |
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 | |
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 | |
136 | 136 | 1993 | 1 | regional policy | 136 | 0 | United Kingdom 44 | Delors III | 1 | 6598 | Millan, Bruce | 1993-01-06 | 1995-01-05 | 0.8 | Labour Party 1556 | 0 | Scottish secretary | doering | Aliança Povo Unido 11 | Major II 678 | |
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 | |
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 | |
139 | 139 | 1993 | 1 | internal political relations | 139 | 1 | Portugal 63 | Delors III | 0 | 9061 | Pinheiro, Joao de Deus | 1993-01-06 | 1995-01-05 | 1.33 | Partido Social Democrata 1273 | 0 | minister foreign affairs | doering | 10 | Silva III 282 | |
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 | |
141 | 141 | 1993 | 1 | budget | 141 | 0 | Germany 54 | Delors III | 1 | 12760 | Schmidhuber, Peter | 1993-01-06 | 1995-01-05 | 0.2 | Christlich Soziale Union 1180 | 0 | state junior minister in Bavaria | doering | 10 | Kohl IV 862 | |
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 | |
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 | |
144 | 144 | 1993 | 0 | single market | 144 | 0 | Italy 26 | Delors III | 0 | 13813 | Vanni D'Archirafi, Raniero | 1993-01-06 | 1995-01-05 | 0.2 | senzo partito 1552 | 0 | diplomat | doering | 12 | Amato I 176 | |
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 | |
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 | |
2 | 2 | 1958 | 0 | competition | 2 | 0 | Germany 54 | Hallstein I | 0 | 16293 | Groeben, Hans von der | 1958-01-10 | 1962-01-09 | 0.2 | Christlich Demokratische Union 808 | 0 | diplomat | doering | 10 | Adenauer V 793 | |
3 | 3 | Lemaignen had been the vice-president of the French employers federation http://www.fep.up.pt/investigacao/seminarios/04.10.15_Maes.pdf; maj_party missing | 1958 | 0 | overseas countries and territories | 3 | 0 | France 43 | Hallstein I | 0 | 12874 | Lemaignen, Robert | 1958-01-10 | 1962-01-09 | 0.2 | sans étiquette 947 | 0 | vice president of the French employers federation | doering | 12 | Gaillard 458 |
4 | 4 | 1958 | 0 | social affairs | 4 | 0 | Italy 26 | Hallstein I | 0 | 14658 | Levi Sandri, Lionello | 1961-02-22 | 1962-01-09 | 0.2 | Partito Socialista Italiano 1475 | 0 | party elite (no outstanding position) | doering | Aliança Povo Unido 11 | Fanfani III 810 | |
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 | |
6 | 6 | 1958 | 1 | agriculture | 6 | 1 | Netherlands 8 | Hallstein I | 0 | 11499 | Mansholt, Sicco Leendert | 1958-01-10 | 1962-01-09 | 0.74 | Partij van de Arbeid 742 | 0 | minister agriculture | doering | 10 | Drees IV 761 | |
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 |
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 | |
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 | |
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 | ||
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 | |
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 | |
13 | 13 | 1962 | 0 | competition | 13 | 0 | Germany 54 | Hallstein II | 1 | 16293 | Groeben, Hans von der | 1962-01-10 | 1967-07-05 | 0.2 | Christlich Demokratische Union 808 | 0 | diplomat | doering | 10 | Adenauer VII 62 | |
14 | 14 | 1962 | 0 | social affairs | 14 | 0 | Italy 26 | Hallstein II | 1 | 14658 | Levi Sandri, Lionello | 1962-01-10 | 1967-07-05 | 0.2 | Partito Socialista Italiano 1475 | 0 | party elite (no outstanding position) | doering | Aliança Povo Unido 11 | Fanfani III 810 | |
15 | 15 | 1962 | 1 | agriculture | 15 | 1 | Netherlands 8 | Hallstein II | 1 | 11499 | Mansholt, Sicco Leendert | 1962-01-10 | 1967-07-05 | 0.74 | Partij van de Arbeid 742 | 0 | minister agriculture | doering | Aliança Povo Unido 11 | De Quay 694 | |
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 |
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 |
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 | |
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 |
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 | ||
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 | |
63 | 63 | 1977 | 0 | research/science and education | 63 | 0 | Germany 54 | Jenkins | 1 | 16418 | Brunner, Guido | 1977-01-06 | 1980-11-04 | 0.2 | Freie Demokratische Partei 543 | 0 | diplomat | doering | 10 | Schmidt II 459 | |
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 | |
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 |
66 | 66 | 1977 | 0 | internal market and industrial affairs | 66 | 1 | Belgium 64 | Jenkins | 0 | 10947 | Davignon, Etienne | 1977-01-06 | 1981-01-05 | 0.2 | no party affiliation 1458 | 0 | diplomat and bureaucrat | doering | 12 | Tindemans II 847 | |
67 | 67 | 1977 | 1 | community funds and regional policy | 67 | 0 | Italy 26 | Jenkins | 0 | 8614 | Giolitti, Antonio | 1977-01-06 | 1981-01-05 | 0.98 | Partito Socialista Italiano 1475 | 0 | minister budget and economic planning | doering | Aliança Povo Unido 11 | Andreotti III 140 | |
68 | 68 | 1977 | 0 | agriculture and fisheries | 68 | 1 | Denmark 21 | Jenkins | 1 | 14835 | Gundelach, Finn Olav | 1977-01-06 | 1981-01-05 | 0.2 | ingen 1128 | 0 | diplomat | doering | 12 | Jorgensen II 50 | |
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 | |
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 | |
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 | |
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 | |
73 | 73 | 1977 | 1 | competition | 73 | 1 | Luxembourg 7 | Jenkins | 1 | 12256 | Vouel, Raymond | 1977-01-06 | 1981-01-05 | 1.53 | Lëtzebuerger Sozialistesch Aarbechterpartei 701 | 0 | vice prime minister and finance minister | doering | 10 | Thorn 655 | |
74 | 74 | 1977 | 1 | employment/social affairs/Tripartite Conference | 74 | 1 | Netherlands 8 | Jenkins | 0 | 14619 | Vredeling, Henk | 1977-01-06 | 1981-01-05 | 1.53 | Partij van de Arbeid 742 | 0 | vice prime minister and Finance | doering | 10 | Den Uyl I 765 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
282 | 282 | 2014 | 1 | Digital Economy and Society | 286 | 1 | Bulgaria 10 | Juncker | 0 | 17163 | Gabriel, Mariya | 2017-07-07 | 2019-11-30 | 0.33 | Grazhdani za Evropeysko Razvitie na Balgariya 1541 | 0 | MEP | 10 | Borisov III 1505 | ||
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 | |
37 | 37 | 1970 | 0 | competition. regional policy | 37 | 1 | Luxembourg 7 | Malfatti/Manshold | 0 | 8219 | Borschette, Albert | 1970-07-01 | 1973-01-05 | 0.2 | no party affiliation 1002 | 0 | diplomat | doering | 12 | Werner III 101 | |
38 | 38 | 1970 | 1 | budget and finance | 38 | 1 | Belgium 64 | Malfatti/Manshold | 1 | 8852 | Coppe, Albert | 1970-07-01 | 1973-01-05 | 1.02 | Christelijke Volkspartij | Christen-Democratisch en Vlaams 723 | 0 | minister economy | doering | 10 | Eyskens G IV 586 | |
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 | |
40 | 40 | Check when party UDF was established. Was he a member of it before going to the Commission? | 1970 | 0 | trade policy | 40 | 0 | France 43 | Malfatti/Manshold | 1 | 9096 | Deniau, Jean-Francois | 1970-07-01 | 1973-01-05 | 0.2 | Union pour la démocratie française | Mouvement démocrate 509 | 0 | bureaucrat | doering | Aliança Povo Unido 11 | Chaban-Delmas 111 |
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 | |
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 | |
43 | 43 | 1970 | 0 | industry | 43 | 0 | Italy 26 | Malfatti/Manshold | 0 | 10089 | Spinelli, Altiero | 1970-07-01 | 1973-01-05 | 0.2 | Partito Socialista Italiano 1475 | 0 | adviser to foreign minister | doering | 10 | Rumor III 113 | |
44 | 44 | 1970 | 1 | president | 44 | 0 | Italy 26 | Malfatti/Manshold | 0 | 6848 | Malfatti, Franco Maria | 1970-07-01 | 1972-03-21 | 1.18 | Democrazia Cristiana 1633 | 1 | minister state participation in industry | doering | 10 | Rumor III 113 | |
45 | 45 | 1970 | 1 | agriculture | 45 | 1 | Netherlands 8 | Malfatti/Manshold | 1 | 11499 | Mansholt, Sicco Leendert | 1970-07-01 | 1973-01-05 | 0.74 | Partij van de Arbeid 742 | 1 | minister agriculture | doering | Aliança Povo Unido 11 | De Jong 172 | |
46 | 46 | 1973 | 0 | competition policy | 46 | 1 | Luxembourg 7 | Ortoli | 1 | 8219 | Borschette, Albert | 1973-01-06 | 1976-12-08 | 0.2 | no party affiliation 1002 | 0 | diplomat | doering | 12 | Werner III 101 | |
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 | |
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 |
49 | 49 | 1973 | 1 | research/science and education | 49 | 0 | Germany 54 | Ortoli | 1 | 6242 | Dahrendorf, Ralf | 1973-01-06 | 1974-10-31 | 0.82 | Freie Demokratische Partei 543 | 0 | junior minister foreign affairs | doering | 10 | Brandt II 871 | |
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 |
51 | 51 | Information provided by Fabio Franchino | 1973 | 0 | industry and technology | 51 | 0 | Italy 26 | Ortoli | 0 | 12568 | Guazzaroni, Cesidio | 1976-07-13 | 1977-01-05 | 0.2 | senzo partito 1552 | 0 | Career diplomat, ambassador and top rank bureaucrat, expert, no specific party affiliation | doering | 12 | Moro V 842 |
52 | 52 | 1973 | 0 | internal market/customs union | 52 | 1 | Denmark 21 | Ortoli | 0 | 14835 | Gundelach, Finn Olav | 1973-01-06 | 1977-01-05 | 0.2 | ingen 1128 | 0 | diplomat | doering | 12 | Jorgensen I 320 | |
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 | |
54 | 54 | 1973 | 1 | social affairs | 54 | 1 | Ireland 37 | Ortoli | 0 | 16552 | Hillery, Patrick J. | 1973-01-06 | 1977-01-05 | 1.46 | Fianna Fáil 280 | 0 | minister foreign affairs | doering | 10 | Lynch II 863 | |
55 | 55 | 1973 | 1 | Agriculture | 55 | 1 | Netherlands 8 | Ortoli | 0 | 16291 | Lardinois, Petrus J. | 1973-01-06 | 1977-01-05 | 0.74 | Katholieke Volkspartij 451 | 0 | minister agriculture | doering | 10 | Biesheuvel II 291 | |
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 |
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]) );