external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
308 rows
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
147 | 147 | 1995 | 1 | environment and nuclear safety | 147 | 1 | Denmark 21 | Santer | 0 | 4640 | Bjerregaard, Ritt | 1995-01-06 | 1999-03-15 | 1.09 | Socialdemokraterne 1629 | 0 | minister social affairs | doering | 10 | Rasmussen N II 189 | |
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 |
149 | 149 | 1995 | 1 | external economic affairs | 149 | 0 | United Kingdom 44 | Santer | 1 | 14789 | Brittan, Leon | 1995-01-06 | 1999-03-15 | 1.32 | Conservatives 773 | 0 | minister interior | doering | 10 | Major II 678 | |
150 | 150 | 1995 | 1 | external political relations (Europe) | 150 | 1 | Netherlands 8 | Santer | 1 | 14964 | Broek, Hans van den | 1995-01-06 | 1999-03-15 | 1.16 | Christen Democratisch Appèl 235 | 0 | minister foreign affairs | doering | Aliança Povo Unido 11 | Kok I 637 | |
151 | 151 | 1995 | 1 | science. research and development | 151 | 0 | France 43 | Santer | 0 | 12350 | Cresson, Edith | 1995-01-06 | 1999-03-15 | 2.75 | Parti socialiste 1539 | 0 | prime minister | doering | Aliança Povo Unido 11 | Balladur 318 | |
152 | 152 | 1995 | 1 | agriculture and rural development | 152 | 1 | Austria 59 | Santer | 0 | 2619 | Fischler, Franz | 1995-01-06 | 1999-03-15 | 0.86 | Österreichische Volkspartei 1013 | 0 | minister agriculture and forestry | doering | 10 | Vranitzky IV 294 | |
153 | 153 | 1995 | 1 | employment and social affairs | 153 | 1 | Ireland 37 | Santer | 1 | 6689 | Flynn, Padraig | 1995-01-06 | 1999-03-15 | 1.24 | Fianna Fáil 280 | 0 | minister justice | doering | Aliança Povo Unido 11 | Bruton 573 | |
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 | |
155 | 155 | 1995 | 1 | transport | 155 | 0 | United Kingdom 44 | Santer | 0 | 217 | Kinnock, Neil | 1995-01-06 | 1999-03-15 | 1.0 | Labour Party 1556 | 0 | leader oppostion party | doering | Aliança Povo Unido 11 | Major II 678 | |
156 | 156 | 1995 | 1 | budget | 156 | 1 | Finland 67 | Santer | 0 | 5160 | Liikanen, Erkki Antero | 1995-01-06 | 1999-03-15 | 2.01 | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | 0 | minister finance | doering | Aliança Povo Unido 11 | Aho II 206 | |
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 | |
158 | 158 | 1995 | 1 | competition | 158 | 1 | Belgium 64 | Santer | 1 | 2416 | Miert, Karl van | 1995-01-06 | 1999-03-15 | 1.0 | Socialistische Partij 1029 | 0 | leader oppostion party | doering | 10 | Dehaene I 624 | |
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 | |
160 | 160 | 1995 | 1 | relations with ep | 160 | 0 | Spain 27 | Santer | 1 | 1092 | Oreja Aguirre, Marcelino | 1995-01-06 | 1999-03-15 | 1.43 | Alianza-Partido Popular 645 | 0 | minister foreign affairs | doering | Aliança Povo Unido 11 | Gonzalez IV 654 | |
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 | |
162 | 162 | 1995 | 1 | external relations with africa and asia | 162 | 1 | Portugal 63 | Santer | 1 | 9061 | Pinheiro, Joao de Deus | 1995-01-06 | 1999-03-15 | 1.33 | Partido Social Democrata 1273 | 0 | minister foreign affairs | doering | 10 | Silva III 282 | |
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 |
165 | 165 | 1995 | 1 | president | 165 | 1 | Luxembourg 7 | Santer | 0 | 6273 | Santer, Jacques | 1995-01-06 | 1999-03-15 | 2.75 | Chrëschtlech Sozial Vollekspartei 1234 | 1 | prime minister | doering | 10 | Santer III 222 | |
166 | 166 | 1999 | 1 | economic and monetary affairs | 166 | 0 | Spain 27 | Prodi | 0 | 15779 | Almunia, Joaquin | 2004-04-26 | 2009-10-31 | 1.03 | Partido Socialista Obrero Español 902 | 0 | minister employment | doering | Aliança Povo Unido 11 | Zapatero I 806 | |
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 | |
168 | 168 | 1999 | 1 | regional policy | 168 | 0 | France 43 | Prodi | 0 | 10419 | Barrot, Jacques | 1999-09-16 | 2004-11-21 | 1.13 | Union pour la démocratie française | Mouvement démocrate 509 | 0 | minister for labour and social affairs | doering | 10 | Jospin 481 | |
169 | 169 | 1999 | 1 | internal market | 169 | 1 | Netherlands 8 | Prodi | 0 | 10011 | Bolkestein, Frederik | 1999-09-16 | 2004-11-21 | 1.0 | Volkspartij voor Vrijheid en Democratie 1409 | 0 | leader party group. minister defence | doering | 10 | Kok II 749 | |
170 | 170 | 1999 | 1 | research | 170 | 1 | Belgium 64 | Prodi | 0 | 1146 | Busquin, Philippe | 1999-09-16 | 2004-08-13 | 1.13 | Parti Socialiste 1378 | 0 | minister social affairs | doering | 10 | Verhofstadt I 193 | |
171 | 171 | check munzinger | 1999 | 1 | health and consumer protection | 171 | 1 | Ireland 37 | Prodi | 0 | 376 | Byrne, David | 1999-09-16 | 2004-11-21 | 0.9 | Fianna Fáil 280 | 0 | attorney general | doering | 10 | Ahern I 126 |
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 | |
173 | 173 | 1999 | 1 | employment and social affairs | 173 | 1 | Greece 41 | Prodi | 0 | 15665 | Dimas, Stavros | 2004-03-11 | 2009-10-31 | 0.99 | Néa Đimokratía 47 | 0 | minister industry | doering | 10 | Karamanlis Kos I 876 | |
174 | 174 | 1999 | 1 | agriculture and rural development | 174 | 1 | Austria 59 | Prodi | 1 | 2619 | Fischler, Franz | 1999-09-16 | 2004-11-21 | 0.86 | Österreichische Volkspartei 1013 | 0 | minister agriculture and forestry | doering | 10 | Klima I 412 | |
175 | 175 | 1999 | 1 | transport | 175 | 0 | United Kingdom 44 | Prodi | 1 | 217 | Kinnock, Neil | 1999-09-16 | 2004-11-21 | 1.0 | Labour Party 1556 | 0 | leader oppostion party | doering | Aliança Povo Unido 11 | Blair I 838 | |
176 | 176 | 1999 | 0 | trade | 176 | 0 | France 43 | Prodi | 0 | 2329 | Lamy, Pascal | 1999-09-16 | 2004-11-21 | 0.2 | Parti socialiste 1539 | 0 | administrative career | doering | 10 | Jospin 481 | |
177 | 177 | 1999 | 1 | budget | 177 | 1 | Finland 67 | Prodi | 1 | 5160 | Liikanen, Erkki Antero | 1999-09-16 | 2004-07-11 | 2.01 | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti 395 | 0 | minister finance | doering | 10 | Lipponen II 352 | |
178 | 178 | 1999 | 1 | research | 178 | 1 | Belgium 64 | Prodi | 0 | 14013 | Michel, Louis | 2004-08-12 | 2004-11-21 | 1.28 | Mouvement Réformateur 915 | 0 | minister foreign affairs | doering | 10 | Verhofstadt II 449 | |
179 | 179 | 1999 | 0 | internal market | 179 | 0 | Italy 26 | Prodi | 1 | 12444 | Monti, Mario | 1999-09-16 | 2004-11-21 | 0.2 | senzo partito 1552 | 0 | professor | doering | 12 | D'Alema I 214 | |
180 | 180 | 1999 | 1 | development and humanitarian aid | 180 | 1 | Denmark 21 | Prodi | 0 | 11480 | Nielson, Poul | 1999-09-16 | 2004-11-21 | 0.83 | Socialdemokraterne 1629 | 0 | minister energy | doering | 10 | Rasmussen N IV 630 | |
181 | 181 | 1999 | 0 | relations with ep. transport and energy | 181 | 0 | Spain 27 | Prodi | 0 | 4322 | Loyola de Palacio | 1999-09-16 | 2004-11-21 | 0.92 | Alianza-Partido Popular 645 | 0 | minister agriculture. fisheries and food | doering | 10 | Aznar I 370 | |
182 | 182 | 1999 | 1 | external relations | 182 | 0 | United Kingdom 44 | Prodi | 0 | 3329 | Patten, Chris | 1999-09-16 | 2004-11-21 | 0.5 | Conservatives 773 | 0 | minister without portfolio | doering | Aliança Povo Unido 11 | Blair I 838 | |
183 | 183 | 1999 | 1 | education and culture | 183 | 1 | Luxembourg 7 | Prodi | 0 | 1129 | Reding, Viviane | 1999-09-16 | 2004-11-21 | 0.33 | Chrëschtlech Sozial Vollekspartei 1234 | 0 | mp/mep | doering | 10 | Juncker II 196 | |
184 | 184 | 1999 | 0 | enterprise and information society | 184 | 1 | Finland 67 | Prodi | 0 | 1265 | Rehn, Olli | 2004-07-12 | 2004-11-21 | 0.33 | Keskusta 94 | 0 | mp/mep | doering | 10 | Vanhanen I 759 | |
185 | 185 | 1999 | 1 | budget | 185 | 0 | Germany 54 | Prodi | 0 | 2882 | Schreyer, Michaele | 1999-09-16 | 2004-11-21 | 0.2 | Bündnis 90 / Die Grünen 772 | 0 | minister of a german state | doering | 10 | Schroeder I 107 | |
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 |
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]) );
comment 18 ✖