external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
25 rows where commission_name = "Prodi" sorted by data_source
This data as json, CSV (advanced)
Link | rowid | comment | commission_year | elected | portfolio | id | one_seat | country_id | commission_name | incumbent | person_id | person_id_source | start_date | end_date | score_position | party_id | president | highest_position | data_source ▼ | government_party | previous_cabinet_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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]) );