external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
27 rows where "end_date" is on date 2014-10-31 sorted by score_position
This data as json, CSV (advanced)
Suggested facets: comment, elected, incumbent, start_date, score_position, president, highest_position, data_source, government_party, start_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
226 | 226 | 2010 | 0 | employment. social affairs and inclusion | 230 | 1 | Hungary 39 | Barroso II | 0 | 16866 | Andor, László | 2010-02-10 | 2014-10-31 | 0.2 | Magyar Szocialista Párt 1591 | 0 | member of the board of directors EBRD | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Bajnai 162 | |
235 | 235 | close to Citizens for European Development of Bulgaria (GERB) | 2010 | 0 | international cooperation. humanitarian aid and crisis response | 239 | 1 | Bulgaria 10 | Barroso II | 0 | 16870 | Georgieva, Kristalina | 2010-02-10 | 2014-10-31 | 0.2 | Grazhdani za Evropeysko Razvitie na Balgariya 1541 | 0 | vice president and corporate secretary of the World Bank Group | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Borisov I 805 |
247 | 247 | according to Wikipedia close to SMER http://de.wikipedia.org/wiki/Europ%C3%A4ische_Kommission | 2010 | 0 | inter-institutional relations and administration | 251 | 1 | Slovakia 1 | Barroso II | 1 | 16865 | Šefčovič, Maroš | 2010-02-10 | 2014-10-31 | 0.2 | no party affiliation 1359 | 0 | Ambassador. Slovakian permanent representative to the EU | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Fico I 269 |
230 | 230 | 2010 | 1 | maritime affairs and fisheries | 234 | 1 | Greece 41 | Barroso II | 0 | 16868 | Damanaki, Maria | 2010-02-10 | 2014-10-31 | 0.33 | Panellinio Sosialistikó Kínima 1338 | 0 | mp/mep | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Papandreou G 224 | |
245 | 245 | 2010 | 1 | justice. fundamental rights and citizenship | 249 | 1 | Luxembourg 7 | Barroso II | 1 | 1129 | Reding, Viviane | 2010-02-10 | 2014-10-31 | 0.33 | Chrëschtlech Sozial Vollekspartei 1234 | 0 | mp/mep | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Juncker IV 601 | |
249 | 249 | 2010 | 1 | industry and entrepreneurship | 253 | 1 | Italy 26 | Barroso II | 1 | 6887 | Tajani, Antonio | 2010-02-10 | 2014-10-31 | 0.33 | Forza Italia – Il Popolo della Libertà 596 | 0 | mp/mep | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Berlusconi IV 823 | |
250 | 250 | 2010 | 1 | education. culture. multilingualism and youth | 254 | 1 | Cyprus 51 | Barroso II | 1 | 12688 | Vassiliou, Androulla | 2010-02-10 | 2014-10-31 | 0.33 | Enomeni Dimokrates 1523 | 0 | mp/mep | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Christofias I 289 | |
241 | 241 | position score 0.65 second or subordinate ministers | 2010 | 1 | home affairs | 245 | 1 | Sweden 35 | Barroso II | 0 | 9042 | Malmström, Cecilia | 2010-02-10 | 2014-10-31 | 0.65 | Folkpartiet 892 | 0 | minister european affairs | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Reinfeldt I 475 |
236 | 236 | 2010 | 0 | regional policy | 240 | 1 | Austria 59 | Barroso II | 0 | 1416 | Hahn, Johannes | 2010-02-10 | 2014-10-31 | 0.89 | Österreichische Volkspartei 1013 | 0 | minister science and research | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Faymann I 268 | |
239 | 239 | 2010 | 1 | digital agenda | 243 | 1 | Netherlands 8 | Barroso II | 1 | 10749 | Kroes, Neelie | 2010-02-10 | 2014-10-31 | 0.92 | Volkspartij voor Vrijheid en Democratie 1409 | 0 | minister transport | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Balkenende V 69 | |
229 | 229 | member cabinett Popescu-Tariceanu III; Duration: 2007-04-05 – 2008-11-30. at the time of nomination other parties were in power | 2010 | 1 | agriculture and rural development | 233 | 1 | Romania 23 | Barroso II | 0 | 16867 | Cioloş, Dacian | 2010-02-10 | 2014-10-31 | 0.97 | no party affiliation 761 | 0 | minister agriculture and rural development | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Boc II 993 |
227 | 227 | 2010 | 1 | high representative of the union for foreign affairs and security policy | 231 | 1 | United Kingdom 44 | Barroso II | 1 | 9961 | Ashton, Catherine | 2010-02-10 | 2014-10-31 | 1.0 | Labour Party 1556 | 0 | leader of the house of lords | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Brown 119 | |
233 | 233 | 2010 | 1 | enlargement and european neighbourhood policy | 237 | 1 | Czech Republic 68 | Barroso II | 0 | 16869 | Füle, Štefan | 2010-02-10 | 2014-10-31 | 1.0 | no party affiliation 1567 | 0 | minister european affairs | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Fischer 157 | |
242 | 242 | 2010 | 1 | energy | 246 | 1 | Germany 54 | Barroso II | 0 | 16863 | Oettinger, Günther | 2010-02-10 | 2014-10-31 | 1.0 | Christlich Demokratische Union 808 | 0 | minister-president of Baden-Württemberg | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Merkel II 472 | |
225 | 225 | 2010 | 1 | competition | 229 | 1 | Spain 27 | Barroso II | 1 | 15779 | Almunia, Joaquin | 2010-02-10 | 2014-10-31 | 1.03 | Partido Socialista Obrero Español 902 | 0 | minister employment | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Zapatero II 497 | |
244 | 244 | close to LDS according to Wikipedia | 2010 | 1 | environment | 248 | 1 | Slovenia 60 | Barroso II | 1 | 12406 | Potocnik, Janez | 2010-02-10 | 2014-10-31 | 1.07 | no party affiliation 1370 | 0 | minister without portfolio (European affairs) | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Pahor I 803 |
240 | 240 | 2010 | 1 | financial programming and budget | 244 | 1 | Poland 74 | Barroso II | 0 | 14860 | Lewandowski, Janusz | 2010-02-10 | 2014-10-31 | 1.14 | Platforma Obywatelska 512 | 0 | minister privatisation | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Tusk I 164 | |
280 | 280 | 2010 | 1 | Consumer Policy | 284 | 1 | Croatia 62 | Barroso II | 0 | 17109 | Mimica, Neven | 2010-02-10 | 2014-10-31 | 1.16 | Socijaldemokratska partija Hrvatske 1493 | 0 | deputy prime minister | dr-08, dw-05, ec.europa.eu, parlgov | 10 | Kosor I 1055 | |
234 | 234 | 2010 | 1 | research, innovation and science | 238 | 1 | Ireland 37 | Barroso II | 0 | 8185 | Geoghegan-Quinn, Máire | 2010-02-10 | 2014-10-31 | 1.24 | Fianna Fáil 280 | 0 | minister justice | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Cowen 173 | |
232 | 232 | 2010 | 1 | trade | 236 | 1 | Belgium 64 | Barroso II | 1 | 15520 | De Gucht, Karel | 2010-02-10 | 2014-10-31 | 1.28 | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten 1110 | 0 | minister foreign affairs and european affairs | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Leterme II 431 | |
237 | 237 | 2010 | 1 | climate action | 241 | 1 | Denmark 21 | Barroso II | 0 | 6095 | Hedegaard, Connie | 2010-02-10 | 2014-10-31 | 1.33 | Konservative 590 | 0 | minister environment | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Rasmussen L I 71 | |
228 | 228 | 2010 | 1 | internal market and services | 232 | 1 | France 43 | Barroso II | 0 | 6420 | Barnier, Michel | 2010-02-10 | 2014-10-31 | 1.45 | Union pour un mouvement populaire | Les Républicains 658 | 0 | minister foreign affairs | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Fillon II 306 | |
243 | 243 | 2010 | 1 | development | 247 | 1 | Latvia 55 | Barroso II | 1 | 16359 | Piebalgs, Andris | 2010-02-10 | 2014-10-31 | 1.64 | Latvijas Pirmā partija / Latvijas Ceļš 662 | 0 | minister finance | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Dombrovskis I 477 | |
252 | 252 | Malta is not coded in Druckman/Warwick; average position score of finance minister (1.64) used; see codebook | 2010 | 1 | health | 256 | 1 | Malta 72 | Barroso II | 1 | 16218 | Borg, Tonio | 2012-11-28 | 2014-10-31 | 1.64 | Partit Nazzjonalista 984 | 0 | minister finance and economic affairs, foreign minister | afp, dw-05 | Aliança Povo Unido 11 | Gonzi II 468 |
248 | 248 | 2010 | 1 | taxation and customs union. audit and anti-fraud | 252 | 1 | Lithuania 15 | Barroso II | 1 | 3567 | Šemeta, Algirdas | 2010-02-10 | 2014-10-31 | 1.74 | Tėvynės sąjunga 1045 | 1 | minister finance | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Kubilius III 1632 | |
251 | 251 | 2010 | 1 | president | 255 | 1 | Portugal 63 | Barroso II | 1 | 3890 | Barroso, Jose Manuel | 2010-02-10 | 2014-10-31 | 2.2 | Partido Social Democrata 1273 | 1 | prime minister | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | Aliança Povo Unido 11 | Socrates II 858 | |
238 | 238 | 2010 | 1 | transport | 242 | 1 | Estonia 75 | Barroso II | 1 | 16396 | Kallas, Siim | 2010-02-10 | 2014-10-31 | 2.25 | Eesti Reformierakond 113 | 0 | prime minister | dr-08, dw-05, ec.europa.eu, munzinger, parlgov | 10 | Ansip III 902 |
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]) );