external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
217 rows where data_source = "doering" sorted by score_position
This data as json, CSV (advanced)
Suggested facets: comment, commission_year, elected, one_seat, country_id, commission_name, incumbent, president, government_party, start_date (date), end_date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 |
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 | |
25 | 25 | Check when party UDF was established. Was he a member of it before going to the Commission? | 1967 | 0 | trade policy | 25 | 0 | France 43 | Rey | 0 | 9096 | Deniau, Jean-Francois | 1967-07-06 | 1970-06-30 | 0.2 | Union pour la démocratie française | Mouvement démocrate 509 | 0 | bureaucrat | doering | Aliança Povo Unido 11 | Pompidou IV 662 |
26 | 26 | 1967 | 0 | competition | 26 | 0 | Germany 54 | Rey | 1 | 16293 | Groeben, Hans von der | 1967-07-06 | 1970-06-30 | 0.2 | Christlich Demokratische Union 808 | 0 | diplomat | doering | 10 | Kiesinger 170 | |
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 | |
29 | 29 | 1967 | 0 | social affairs | 29 | 0 | Italy 26 | Rey | 1 | 14658 | Levi Sandri, Lionello | 1967-07-06 | 1970-06-30 | 0.2 | Partito Socialista Italiano 1475 | 0 | party elite (no outstanding position) | doering | 10 | Moro III 433 | |
32 | 32 | Information provided by Fabio Franchino | 1967 | 0 | industry | 32 | 0 | Italy 26 | Rey | 1 | 14467 | Paliano, Guido Colonna Di | 1967-07-06 | 1970-06-30 | 0.2 | senzo partito 1552 | 0 | ambassador. vice general secretary NATO | doering | 12 | Moro III 433 |
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 | |
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 | |
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 | |
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 |
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 | |
59 | 59 | 1973 | 0 | industry and technology | 59 | 0 | Italy 26 | Ortoli | 1 | 10089 | Spinelli, Altiero | 1973-01-06 | 1976-07-01 | 0.2 | Partito Socialista Italiano 1475 | 0 | adviser to foreign minister | doering | Aliança Povo Unido 11 | Andreotti II 439 | |
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 | |
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 | |
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 | |
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 |
79 | 79 | 1981 | 0 | transport and fisheries | 79 | 1 | Greece 41 | Thorn | 0 | 10590 | Contogeorgis, Georges | 1981-01-06 | 1985-01-05 | 0.2 | Néa Đimokratía 47 | 0 | diplomat | doering | Aliança Povo Unido 11 | Rallis 531 | |
81 | 81 | 1981 | 0 | internal market and industrial affairs/energy | 81 | 1 | Belgium 64 | Thorn | 1 | 10947 | Davignon, Etienne | 1981-01-06 | 1985-01-05 | 0.2 | no party affiliation 1458 | 0 | diplomat and bureaucrat | doering | 12 | Martens IV 453 | |
83 | 83 | 1981 | 0 | agriculture | 83 | 1 | Denmark 21 | Thorn | 1 | 14835 | Gundelach, Finn Olav | 1981-01-06 | 1981-01-13 | 0.2 | ingen 1128 | 0 | diplomat | doering | 12 | Jorgensen V 379 | |
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 | |
95 | 95 | adviser to the cabinet of Alain Savary (Socialist) and later a member of the Socialist party | 1985 | 0 | mediterranean policy and north-south relations | 95 | 0 | France 43 | Delors I | 1 | 5019 | Cheysson, Claude | 1985-01-06 | 1989-01-05 | 0.2 | Parti socialiste 1539 | 0 | bureaucrat | doering | 10 | Fabius 843 |
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 | |
125 | 125 | 1989 | 1 | EC budget and financial control | 125 | 0 | Germany 54 | Delors II | 1 | 12760 | Schmidhuber, Peter | 1989-01-06 | 1993-01-05 | 0.2 | Christlich Soziale Union 1180 | 0 | state junior minister in Bavaria | doering | 10 | Kohl III 286 | |
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 | |
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 | |
159 | 159 | 1995 | 0 | internal market | 159 | 0 | Italy 26 | Santer | 0 | 12444 | Monti, Mario | 1995-01-06 | 1999-03-15 | 0.2 | senzo partito 1552 | 0 | professor | doering | 12 | Berlusconi I 672 | |
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 | |
164 | 164 | check munzinger | 1995 | 0 | regional policy | 164 | 0 | Germany 54 | Santer | 0 | 13908 | Wulf-Mathies, Monika | 1995-01-06 | 1999-03-15 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | union head | doering | Aliança Povo Unido 11 | Kohl V 778 |
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 | |
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 | |
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 | |
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 | |
28 | 28 | 1967 | 1 | research | 28 | 0 | Germany 54 | Rey | 0 | 13290 | Hellwig, Fritz | 1967-07-06 | 1970-06-30 | 0.33 | Christlich Demokratische Union 808 | 0 | mep | doering | 10 | Kiesinger 170 | |
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 | |
85 | 85 | 1981 | 0 | internal market/customs services+industrial innovation | 85 | 0 | Germany 54 | Thorn | 0 | 6286 | Narjes, Karl-Heinz | 1981-01-06 | 1985-01-05 | 0.33 | Christlich Demokratische Union 808 | 0 | mp | doering | Aliança Povo Unido 11 | Schmidt III 343 | |
91 | 91 | 1981 | 1 | budget a financial control. finacial institutions | 91 | 0 | United Kingdom 44 | Thorn | 1 | 5942 | Tugendhat, Christopher S. | 1981-01-06 | 1985-01-05 | 0.33 | Conservatives 773 | 0 | mep | doering | 10 | Thatcher I 273 | |
101 | 101 | 1985 | 1 | small&medium businesses. investment policy | 101 | 0 | Spain 27 | Delors I | 0 | 15606 | Matutes, Abel | 1986-01-01 | 1989-01-05 | 0.33 | Alianza-Partido Popular 645 | 0 | mp | doering | Aliança Povo Unido 11 | Gonzalez I 238 | |
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 | |
103 | 103 | 1985 | 1 | industry. it. research and science | 103 | 0 | Germany 54 | Delors I | 1 | 6286 | Narjes, Karl-Heinz | 1985-01-06 | 1989-01-05 | 0.33 | Christlich Demokratische Union 808 | 0 | mp | doering | 10 | Kohl II 346 | |
106 | 106 | 1985 | 1 | institutional questions. information. culture | 106 | 0 | Italy 26 | Delors I | 0 | 10310 | Ripa di Meana, Carlo | 1985-01-06 | 1989-01-05 | 0.33 | Partito Socialista Italiano 1475 | 0 | mep | doering | 10 | Craxi I 334 | |
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 | |
118 | 118 | 1989 | 1 | mediterranean policy and north-south relations | 118 | 0 | Spain 27 | Delors II | 1 | 15606 | Matutes, Abel | 1989-01-06 | 1993-01-05 | 0.33 | Alianza-Partido Popular 645 | 0 | mp | doering | Aliança Povo Unido 11 | Gonzalez II 834 | |
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 | |
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 | |
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 |
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 | |
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 | |
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 | |
34 | 34 | 1967 | 1 | competition | 34 | 1 | Netherlands 8 | Rey | 0 | 12016 | Sassen, Emmanuel | 1967-07-06 | 1970-06-30 | 0.35 | Katholieke Volkspartij 451 | 0 | minister colonies. head of ep party group | doering | 10 | De Jong 172 | |
1 | 1 | 1958 | 1 | internal market | 1 | 0 | Italy 26 | Hallstein I | 0 | 4616 | Caron, Giuseppe | 1959-12-09 | 1962-01-09 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister civilian aviation | doering | 10 | Segni II 372 | |
12 | 12 | 1962 | 1 | internal market | 12 | 0 | Italy 26 | Hallstein II | 1 | 4616 | Caron, Giuseppe | 1962-01-10 | 1963-05-16 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister civilian aviation | doering | 10 | Fanfani III 810 | |
31 | 31 | 1967 | 1 | External Affairs | 31 | 0 | Italy 26 | Rey | 0 | 3980 | Martino, Edoardo | 1967-07-06 | 1970-06-30 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister foreign affairs | doering | 10 | Moro III 433 | |
42 | 42 | 1970 | 1 | agriculture | 42 | 0 | Italy 26 | Malfatti/Manshold | 0 | 1158 | Scarascia-Mugnozza, Carlo | 1972-03-22 | 1973-01-05 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister justice | doering | 10 | Andreotti I 398 | |
56 | 56 | 1973 | 1 | environment consumer protection transport informat | 56 | 0 | Italy 26 | Ortoli | 1 | 1158 | Scarascia-Mugnozza, Carlo | 1973-01-06 | 1977-01-05 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister justice | doering | 10 | Andreotti II 439 | |
60 | 60 | 1973 | 1 | regional policy | 60 | 0 | United Kingdom 44 | Ortoli | 0 | 7552 | Thomson, George Morgan | 1973-01-06 | 1977-01-05 | 0.5 | Labour Party 1556 | 0 | minister without portfolio | doering | Aliança Povo Unido 11 | Heath 216 | |
90 | 90 | 1981 | 1 | social affairs | 90 | 0 | United Kingdom 44 | Thorn | 0 | 3740 | Richard, Ivor | 1981-01-06 | 1985-01-05 | 0.5 | Labour Party 1556 | 0 | under secretary of state defence | doering | Aliança Povo Unido 11 | Thatcher I 273 | |
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 | |
100 | 100 | 1985 | 1 | social affairs and employment | 100 | 0 | Spain 27 | Delors I | 0 | 10937 | Marin, Manuel | 1986-01-01 | 1989-01-05 | 0.5 | Partido Socialista Obrero Español 902 | 0 | junior minister relations to EC | doering | 10 | Gonzalez I 238 | |
109 | 109 | no party information but government member | 1985 | 1 | regional policy. relations with parliament | 109 | 1 | Greece 41 | Delors I | 0 | 9086 | Varfis, Grigorios | 1985-01-06 | 1989-01-05 | 0.5 | Panellinio Sosialistikó Kínima 1338 | 0 | deputy foreign minister | doering | 10 | Papandreou A I 713 |
117 | 117 | 1989 | 1 | overseas development and fisheries | 117 | 0 | Spain 27 | Delors II | 1 | 10937 | Marin, Manuel | 1989-01-06 | 1993-01-05 | 0.5 | Partido Socialista Obrero Español 902 | 0 | junior minister relations to EC | doering | 10 | Gonzalez II 834 | |
123 | 123 | 1989 | 1 | social affairs | 123 | 1 | Greece 41 | Delors II | 0 | 13865 | Papandreou, Vasso | 1989-01-06 | 1993-01-05 | 0.5 | Panellinio Sosialistikó Kínima 1338 | 0 | junior minister industry | doering | 10 | Papandreou A III 39 | |
126 | 126 | 1989 | 1 | taxation (fiscal hamonisation) | 126 | 0 | France 43 | Delors II | 0 | 5704 | Scrivener, Christiane | 1989-01-06 | 1993-01-05 | 0.5 | Union pour la démocratie française | Mouvement démocrate 509 | 0 | junior minister cosummer affairs | doering | Aliança Povo Unido 11 | Rocard II 712 | |
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 | |
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 | |
157 | 157 | 1995 | 1 | legal service | 157 | 0 | Spain 27 | Santer | 1 | 10937 | Marin, Manuel | 1995-01-06 | 1999-03-15 | 0.5 | Partido Socialista Obrero Español 902 | 0 | junior minister relations to EC | doering | 10 | Gonzalez IV 654 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
167 | 167 | 1999 | 1 | regional policy | 167 | 0 | France 43 | Prodi | 0 | 6420 | Barnier, Michel | 1999-09-16 | 2004-11-21 | 0.71 | Rassemblement pour la république 138 | 0 | minister environment | doering | Aliança Povo Unido 11 | Jospin 481 | |
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 | |
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 | |
30 | 30 | 1967 | 1 | agriculture | 30 | 1 | Netherlands 8 | Rey | 1 | 11499 | Mansholt, Sicco Leendert | 1967-07-06 | 1970-06-30 | 0.74 | Partij van de Arbeid 742 | 0 | minister agriculture | doering | Aliança Povo Unido 11 | De Jong 172 | |
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 | |
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 | |
121 | 121 | 1989 | 1 | regional policy | 121 | 0 | United Kingdom 44 | Delors II | 0 | 6598 | Millan, Bruce | 1989-01-06 | 1993-01-05 | 0.8 | Labour Party 1556 | 0 | Scottish secretary | doering | Aliança Povo Unido 11 | Thatcher III 297 | |
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 |
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]) );