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