external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
25 rows where "start_date" is on date 2004-11-22
This data as json, CSV (advanced)
Suggested facets: comment, elected, incumbent, end_date, score_position, president, highest_position, government_party
end_date (date) 8 ✖
- 2009-10-31 18
- 2008-03-02 1
- 2008-04-23 1
- 2008-10-03 1
- 2009-07-01 1
- 2009-07-04 1
- 2009-07-17 1
- 2009-10-01 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
201 | 201 | 2004 | 1 | administrative affairs. audit and anti-fraud | 201 | 1 | Estonia 75 | Barroso I | 0 | 16396 | Kallas, Siim | 2004-11-22 | 2009-10-31 | 2.25 | Eesti Reformierakond 113 | 0 | prime minister | doering | 10 | Parts 138 | |
202 | 202 | 2004 | 1 | taxation and customs union | 202 | 1 | Hungary 39 | Barroso I | 0 | 6668 | Kovacs, Laszlo | 2004-11-22 | 2009-10-31 | 1.51 | Magyar Szocialista Párt 1591 | 0 | minister foreign affairs | doering | 10 | Gyurcsany I 188 | |
203 | 203 | 2004 | 1 | competiton | 203 | 1 | Netherlands 8 | Barroso I | 0 | 10749 | Kroes, Neelie | 2004-11-22 | 2009-10-31 | 0.92 | Volkspartij voor Vrijheid en Democratie 1409 | 0 | minister transport | doering | 10 | Balkenende III 124 | |
204 | 204 | 2004 | 1 | health and consumer affairs | 204 | 1 | Cyprus 51 | Barroso I | 0 | 8533 | Kyprianou, Markos | 2004-11-22 | 2008-03-02 | 1.64 | Dimokratikó Kómma 851 | 0 | minister finance | doering | 10 | Papadopoulos I 342 | |
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 | |
206 | 206 | 2004 | 1 | internal market and services | 207 | 1 | Ireland 37 | Barroso I | 0 | 506 | McCreevy, Charly | 2004-11-22 | 2009-10-31 | 1.83 | Fianna Fáil 280 | 0 | minister finance | doering | 10 | Ahern II 179 | |
207 | 207 | 2004 | 1 | development and humanitarian aid | 208 | 1 | Belgium 64 | Barroso I | 1 | 14013 | Michel, Louis | 2004-11-22 | 2009-07-17 | 1.28 | Mouvement Réformateur 915 | 0 | minister foreign affairs | doering | 10 | Verhofstadt II 449 | |
208 | 208 | 2004 | 1 | energy | 209 | 1 | Latvia 55 | Barroso I | 0 | 16359 | Piebalgs, Andris | 2004-11-22 | 2009-10-31 | 1.64 | Latvijas Ceļš 526 | 0 | minister finance | doering | Aliança Povo Unido 11 | Emsis 153 | |
209 | 209 | 2004 | 1 | science and research | 210 | 1 | Slovenia 60 | Barroso I | 0 | 12406 | Potocnik, Janez | 2004-11-22 | 2009-10-31 | 1.07 | no party affiliation 1370 | 0 | minister without portfolio (European affairs) | doering | 10 | Rop II 292 | |
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 | |
212 | 212 | 2004 | 1 | employment. social affairs and equal opportunitis | 213 | 1 | Czech Republic 68 | Barroso I | 0 | 2947 | Spidla, Vladimir | 2004-11-22 | 2009-10-31 | 1.96 | Česká strana sociálně demokratická 789 | 0 | prime minister | doering | 10 | Gross 580 | |
213 | 213 | 2004 | 1 | enterprise and industry | 214 | 1 | Germany 54 | Barroso I | 1 | 5799 | Verheugen, Guenther | 2004-11-22 | 2009-10-31 | 0.82 | Sozialdemokratische Partei Deutschlands 558 | 0 | junior minister foreign affairs | doering | 10 | Schroeder II 529 | |
214 | 214 | 2004 | 1 | institutional relations and communication strategy | 215 | 1 | Sweden 35 | Barroso I | 1 | 1056 | Wallstroem, Margot | 2004-11-22 | 2009-10-31 | 1.22 | Socialdemokraterna 904 | 0 | minister social affairs | doering | 10 | Persson III 641 | |
215 | 215 | 2004 | 1 | president | 216 | 1 | Portugal 63 | Barroso I | 0 | 3890 | Barroso, Jose Manuel | 2004-11-22 | 2009-10-31 | 2.2 | Partido Social Democrata 1273 | 1 | prime minister | doering | 10 | Santana Lopes 755 |
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]) );