external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
20 rows where commission_name = "Santer" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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]) );