external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
217 rows where data_source = "doering" sorted by government_party
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
23 | 23 | 1967 | 1 | Transport policy | 23 | 1 | Luxembourg 7 | Rey | 0 | 6040 | Bodson, Victor | 1967-07-06 | 1970-06-30 | 1.07 | Lëtzebuerger Sozialistesch Aarbechterpartei 701 | 0 | minister justice | doering | 10 | Werner II 491 | |
24 | 24 | 1967 | 1 | budget and finance | 24 | 1 | Belgium 64 | Rey | 0 | 8852 | Coppe, Albert | 1967-07-06 | 1970-06-30 | 1.02 | Christelijke Volkspartij | Christen-Democratisch en Vlaams 723 | 0 | minister economy | doering | 10 | Vanden Boeynants I 353 | |
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 | |
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 | |
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 | |
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 | |
33 | 33 | Munzinger gives no party information. though he was member of a government. I gave him the party score of the government he was a member of. | 1967 | 1 | development policy | 33 | 0 | France 43 | Rey | 1 | 7051 | Rochereau, Henri | 1967-07-06 | 1970-06-30 | 1.24 | sans étiquette 947 | 0 | minister agriculture | doering | 10 | Pompidou IV 662 |
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 | |
35 | 35 | 1967 | 1 | president | 35 | 1 | Belgium 64 | Rey | 1 | 801 | Rey, Jean | 1967-07-06 | 1970-06-30 | 1.02 | Liberale Partij – Parti libéral 63 | 1 | minister economic affairs | doering | 10 | Vanden Boeynants I 353 | |
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 | |
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 | |
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 | |
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 | |
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 | |
57 | 57 | 1973 | 1 | taxation/financial institutions/energy/EURATOM | 57 | 1 | Belgium 64 | Ortoli | 0 | 1047 | Simonet, Henri | 1973-01-06 | 1977-01-05 | 1.02 | Belgische Socialistische Partij – Parti Socialiste Belge 167 | 0 | minister economy | doering | 10 | Eyskens G V 448 | |
58 | 58 | 1973 | 1 | external relations | 58 | 0 | United Kingdom 44 | Ortoli | 0 | 8804 | Soames, Christopher | 1973-01-06 | 1977-01-05 | 0.92 | Conservatives 773 | 0 | minister agriculture and fisheries | doering | 10 | Heath 216 | |
61 | 61 | 1973 | 1 | competition policy | 61 | 1 | Luxembourg 7 | Ortoli | 0 | 12256 | Vouel, Raymond | 1976-07-20 | 1977-01-05 | 1.53 | Lëtzebuerger Sozialistesch Aarbechterpartei 701 | 0 | vice prime minister and finance minister | doering | 10 | Thorn 655 | |
62 | 62 | 1973 | 1 | president | 62 | 0 | France 43 | Ortoli | 0 | 4661 | Ortoli, Francois-Xavier | 1973-01-06 | 1977-01-05 | 1.92 | Gaulliste 1094 | 1 | minister economy and finance | doering | 10 | Messmer I 430 | |
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 | |
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 | |
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 | |
76 | 76 | 1981 | 0 | competition | 76 | 1 | Netherlands 8 | Thorn | 0 | 13160 | Andriessen, Frans | 1981-01-06 | 1985-01-05 | 2.02 | Christen Democratisch Appèl 235 | 0 | minister finance | doering | 10 | Van Agt I 563 | |
77 | 77 | time as commissioner was interrupted | 1981 | 1 | taxation/consumer affairs/transport/EP relations | 77 | 1 | Ireland 37 | Thorn | 0 | 726 | Burke, Richard | 1982-04-01 | 1985-01-05 | 1.19 | Fine Gael 1393 | 0 | minister education | doering | 10 | Haughey II 54 |
80 | 80 | 1981 | 1 | agriculture | 80 | 1 | Denmark 21 | Thorn | 0 | 16571 | Dalsager, Poul | 1981-01-20 | 1985-01-05 | 1.0 | Socialdemokraterne 1629 | 0 | minister agriculture | doering | 10 | Jorgensen V 379 | |
82 | 82 | 1981 | 1 | community funds and regional policy | 82 | 0 | Italy 26 | Thorn | 1 | 8614 | Giolitti, Antonio | 1981-01-06 | 1985-01-05 | 0.98 | Partito Socialista Italiano 1475 | 0 | minister budget and economic planning | doering | 10 | Forlani 464 | |
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 | |
86 | 86 | 1981 | 1 | enlargement/environment protection/nuclear safety | 86 | 0 | Italy 26 | Thorn | 1 | 6114 | Natali, Lorenzo | 1981-01-06 | 1985-01-05 | 0.83 | Democrazia Cristiana 1633 | 0 | minister agriculture | doering | 10 | Forlani 464 | |
87 | 87 | 1981 | 1 | personnel and community budget | 87 | 1 | Ireland 37 | Thorn | 0 | 6073 | O'Kennedy, Michael | 1981-01-06 | 1982-03-03 | 1.83 | Fianna Fáil 280 | 0 | minister for foreign affairs and finance | doering | 10 | Haughey I 442 | |
88 | 88 | 1981 | 0 | economics+finance/credits+investment/statistical office | 88 | 0 | France 43 | Thorn | 1 | 4661 | Ortoli, Francois-Xavier | 1981-01-06 | 1984-10-26 | 1.92 | Gaulliste 1094 | 0 | minister economy and finance | doering | 10 | Barre II 72 | |
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 | |
92 | 92 | 1981 | 1 | president | 92 | 1 | Luxembourg 7 | Thorn | 0 | 2048 | Thorn, Gaston | 1981-01-06 | 1985-01-05 | 2.17 | Demokratesch Partei 967 | 1 | prime minister | doering | 10 | Werner IV 27 | |
93 | 93 | 1985 | 0 | agriculture. fisheries | 93 | 1 | Netherlands 8 | Delors I | 1 | 13160 | Andriessen, Frans | 1985-01-06 | 1989-01-05 | 2.02 | Christen Democratisch Appèl 235 | 0 | minister finance | doering | 10 | Lubbers I 270 | |
94 | 94 | 1985 | 1 | fisheries | 94 | 1 | Portugal 63 | Delors I | 1 | 13398 | Cardoso e Cunha, Antonio | 1986-01-01 | 1989-01-05 | 0.83 | Partido Social Democrata 1273 | 0 | minister agriculture and fisheries | doering | 10 | Silva I 734 | |
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 |
96 | 96 | 1985 | 1 | budget. financial control. personnel | 96 | 1 | Denmark 21 | Delors I | 0 | 6634 | Christophersen, Henning | 1985-01-06 | 1989-01-05 | 1.88 | Venstre 1605 | 0 | minister finance | doering | 10 | Schluter II 195 | |
97 | 97 | 1985 | 1 | external relations. trade | 97 | 1 | Belgium 64 | Delors I | 0 | 11859 | Clercq, Willy de | 1985-01-06 | 1989-01-05 | 1.35 | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten 1110 | 1 | minister finance | doering | 10 | Martens V 724 | |
99 | 99 | 1985 | 1 | internal market. taxation. customs union | 99 | 0 | United Kingdom 44 | Delors I | 0 | 13788 | Cockfield, Francis A. | 1985-01-06 | 1989-01-05 | 0.99 | Conservatives 773 | 0 | minister trade | doering | 10 | 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 | |
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 | |
104 | 104 | 1985 | 1 | development. enlargement | 104 | 0 | Italy 26 | Delors I | 1 | 6114 | Natali, Lorenzo | 1985-01-06 | 1989-01-05 | 0.83 | Democrazia Cristiana 1633 | 0 | minister agriculture | doering | 10 | Craxi I 334 | |
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 | |
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 | |
108 | 108 | 1985 | 1 | competition. social affairs | 108 | 1 | Ireland 37 | Delors I | 0 | 12520 | Sutherland, Peter D. | 1985-01-06 | 1989-01-05 | 0.9 | Fine Gael 1393 | 0 | attorney general | doering | 10 | Fitzgerald II 867 | |
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 |
110 | 110 | 1985 | 1 | president | 110 | 0 | France 43 | Delors I | 0 | 5804 | Delors, Jacques | 1985-01-06 | 1989-01-05 | 1.92 | Parti socialiste 1539 | 1 | minister economy and defense | doering | 10 | Fabius 843 | |
111 | 111 | 1989 | 0 | external relations and trade | 111 | 1 | Netherlands 8 | Delors II | 1 | 13160 | Andriessen, Frans | 1989-01-06 | 1993-01-05 | 2.02 | Christen Democratisch Appèl 235 | 0 | minister finance | doering | 10 | Lubbers II 550 | |
112 | 112 | 1989 | 1 | industry and single market | 112 | 0 | Germany 54 | Delors II | 0 | 2913 | Bangemann, Martin | 1989-01-06 | 1993-01-05 | 0.99 | Freie Demokratische Partei 543 | 0 | minister economic affairs | doering | 10 | Kohl III 286 | |
113 | 113 | 1989 | 1 | competition policy and finacial services | 113 | 0 | United Kingdom 44 | Delors II | 0 | 14789 | Brittan, Leon | 1989-01-06 | 1993-01-05 | 1.32 | Conservatives 773 | 0 | minister interior | doering | 10 | Thatcher III 297 | |
114 | 114 | 1989 | 1 | energy | 114 | 1 | Portugal 63 | Delors II | 0 | 13398 | Cardoso e Cunha, Antonio | 1989-01-06 | 1993-01-05 | 0.83 | Partido Social Democrata 1273 | 0 | minister agriculture and fisheries | doering | 10 | Silva II 718 | |
115 | 115 | 1989 | 1 | economic and financial affairs | 115 | 1 | Denmark 21 | Delors II | 1 | 6634 | Christophersen, Henning | 1989-01-06 | 1993-01-05 | 1.88 | Venstre 1605 | 0 | minister finance | doering | 10 | Schluter IV 57 | |
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 | |
119 | 119 | 1989 | 1 | agriculture | 119 | 1 | Ireland 37 | Delors II | 0 | 16728 | McSharry, Ray | 1989-01-06 | 1993-01-05 | 1.83 | Fianna Fáil 280 | 0 | minister finance | doering | 10 | Haughey III 77 | |
120 | 120 | 1989 | 1 | transport | 120 | 1 | Belgium 64 | Delors II | 0 | 2416 | Miert, Karl van | 1989-01-06 | 1993-01-05 | 1.0 | Socialistische Partij 1029 | 0 | leader oppostion party | doering | 10 | Martens VIII 457 | |
122 | 122 | 1989 | 1 | science and research | 122 | 0 | Italy 26 | Delors II | 0 | 5166 | Pandolfi, Filippo Maria | 1989-01-06 | 1993-01-05 | 1.64 | Democrazia Cristiana 1633 | 0 | minister treasury | doering | 10 | De Mita 809 | |
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 | |
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 | |
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 | |
127 | 127 | 1989 | 1 | president and monetary affairs | 127 | 0 | France 43 | Delors II | 1 | 5804 | Delors, Jacques | 1989-01-06 | 1993-01-05 | 1.92 | Parti socialiste 1539 | 1 | minister economy and defense | doering | 10 | Rocard II 712 | |
128 | 128 | 1993 | 1 | industry | 128 | 0 | Germany 54 | Delors III | 1 | 2913 | Bangemann, Martin | 1993-01-06 | 1995-01-05 | 0.99 | Freie Demokratische Partei 543 | 0 | minister economic affairs | doering | 10 | Kohl IV 862 | |
129 | 129 | 1993 | 1 | external economic affairs | 129 | 0 | United Kingdom 44 | Delors III | 1 | 14789 | Brittan, Leon | 1993-01-06 | 1995-01-05 | 1.32 | Conservatives 773 | 0 | minister interior | doering | 10 | Major II 678 | |
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 | |
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 | |
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 | |
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 | |
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 | |
146 | 146 | 1995 | 1 | industry | 146 | 0 | Germany 54 | Santer | 1 | 2913 | Bangemann, Martin | 1995-01-06 | 1999-03-15 | 0.99 | Freie Demokratische Partei 543 | 0 | minister economic affairs | doering | 10 | Kohl V 778 |
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]) );