external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
25 rows where commission_name = "Prodi" sorted by person_id_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 | |
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 | |
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 | |
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 |
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 |
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]) );