external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
17 rows where commission_name = "Delors II" sorted by highest_position
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
114 | 114 | 1989 | 1 | energy | 114 | 1 | Portugal 63 | Delors II | 0 | 13398 | Cardoso e Cunha, Antonio | 1989-01-06 | 1993-01-05 | 0.83 | Partido Social Democrata 1273 | 0 | minister agriculture and fisheries | doering | 10 | Silva II 718 | |
112 | 112 | 1989 | 1 | industry and single market | 112 | 0 | Germany 54 | Delors II | 0 | 2913 | Bangemann, Martin | 1989-01-06 | 1993-01-05 | 0.99 | Freie Demokratische Partei 543 | 0 | minister economic affairs | doering | 10 | Kohl III 286 | |
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 | |
111 | 111 | 1989 | 0 | external relations and trade | 111 | 1 | Netherlands 8 | Delors II | 1 | 13160 | Andriessen, Frans | 1989-01-06 | 1993-01-05 | 2.02 | Christen Democratisch Appèl 235 | 0 | minister finance | doering | 10 | Lubbers II 550 | |
115 | 115 | 1989 | 1 | economic and financial affairs | 115 | 1 | Denmark 21 | Delors II | 1 | 6634 | Christophersen, Henning | 1989-01-06 | 1993-01-05 | 1.88 | Venstre 1605 | 0 | minister finance | doering | 10 | Schluter IV 57 | |
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 | |
113 | 113 | 1989 | 1 | competition policy and finacial services | 113 | 0 | United Kingdom 44 | Delors II | 0 | 14789 | Brittan, Leon | 1989-01-06 | 1993-01-05 | 1.32 | Conservatives 773 | 0 | minister interior | doering | 10 | 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 | |
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 | |
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 |
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]) );