external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
17 rows where commission_name = "Delors II" sorted by comment
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
118 | 118 | 1989 | 1 | mediterranean policy and north-south relations | 118 | 0 | Spain 27 | Delors II | 1 | 15606 | Matutes, Abel | 1989-01-06 | 1993-01-05 | 0.33 | Alianza-Partido Popular 645 | 0 | mp | doering | Aliança Povo Unido 11 | Gonzalez II 834 | |
119 | 119 | 1989 | 1 | agriculture | 119 | 1 | Ireland 37 | Delors II | 0 | 16728 | McSharry, Ray | 1989-01-06 | 1993-01-05 | 1.83 | Fianna Fáil 280 | 0 | minister finance | doering | 10 | Haughey III 77 | |
120 | 120 | 1989 | 1 | transport | 120 | 1 | Belgium 64 | Delors II | 0 | 2416 | Miert, Karl van | 1989-01-06 | 1993-01-05 | 1.0 | Socialistische Partij 1029 | 0 | leader oppostion party | doering | 10 | Martens VIII 457 | |
121 | 121 | 1989 | 1 | regional policy | 121 | 0 | United Kingdom 44 | Delors II | 0 | 6598 | Millan, Bruce | 1989-01-06 | 1993-01-05 | 0.8 | Labour Party 1556 | 0 | Scottish secretary | doering | Aliança Povo Unido 11 | Thatcher III 297 | |
122 | 122 | 1989 | 1 | science and research | 122 | 0 | Italy 26 | Delors II | 0 | 5166 | Pandolfi, Filippo Maria | 1989-01-06 | 1993-01-05 | 1.64 | Democrazia Cristiana 1633 | 0 | minister treasury | doering | 10 | De Mita 809 | |
123 | 123 | 1989 | 1 | social affairs | 123 | 1 | Greece 41 | Delors II | 0 | 13865 | Papandreou, Vasso | 1989-01-06 | 1993-01-05 | 0.5 | Panellinio Sosialistikó Kínima 1338 | 0 | junior minister industry | doering | 10 | Papandreou A III 39 | |
124 | 124 | 1989 | 1 | environment | 124 | 0 | Italy 26 | Delors II | 1 | 10310 | Ripa di Meana, Carlo | 1989-01-06 | 1992-06-01 | 0.33 | Partito Socialista Italiano 1475 | 0 | mep | doering | 10 | De Mita 809 | |
125 | 125 | 1989 | 1 | EC budget and financial control | 125 | 0 | Germany 54 | Delors II | 1 | 12760 | Schmidhuber, Peter | 1989-01-06 | 1993-01-05 | 0.2 | Christlich Soziale Union 1180 | 0 | state junior minister in Bavaria | doering | 10 | Kohl III 286 | |
126 | 126 | 1989 | 1 | taxation (fiscal hamonisation) | 126 | 0 | France 43 | Delors II | 0 | 5704 | Scrivener, Christiane | 1989-01-06 | 1993-01-05 | 0.5 | Union pour la démocratie française | Mouvement démocrate 509 | 0 | junior minister cosummer affairs | doering | Aliança Povo Unido 11 | Rocard II 712 | |
127 | 127 | 1989 | 1 | president and monetary affairs | 127 | 0 | France 43 | Delors II | 1 | 5804 | Delors, Jacques | 1989-01-06 | 1993-01-05 | 1.92 | Parti socialiste 1539 | 1 | minister economy and defense | doering | 10 | Rocard II 712 |
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]) );