external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
17 rows where commission_name = "Ortoli" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51 | 51 | Information provided by Fabio Franchino | 1973 | 0 | industry and technology | 51 | 0 | Italy 26 | Ortoli | 0 | 12568 | Guazzaroni, Cesidio | 1976-07-13 | 1977-01-05 | 0.2 | senzo partito 1552 | 0 | Career diplomat, ambassador and top rank bureaucrat, expert, no specific party affiliation | doering | 12 | Moro V 842 |
52 | 52 | 1973 | 0 | internal market/customs union | 52 | 1 | Denmark 21 | Ortoli | 0 | 14835 | Gundelach, Finn Olav | 1973-01-06 | 1977-01-05 | 0.2 | ingen 1128 | 0 | diplomat | doering | 12 | Jorgensen I 320 | |
53 | 53 | 1973 | 1 | economic/financial affairs. credit/investment | 53 | 0 | Germany 54 | Ortoli | 1 | 2142 | Haferkamp, Wilhelm | 1973-01-06 | 1977-01-05 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | member state assembly (NRW) | doering | 10 | Brandt II 871 | |
54 | 54 | 1973 | 1 | social affairs | 54 | 1 | Ireland 37 | Ortoli | 0 | 16552 | Hillery, Patrick J. | 1973-01-06 | 1977-01-05 | 1.46 | Fianna Fáil 280 | 0 | minister foreign affairs | doering | 10 | Lynch II 863 | |
55 | 55 | 1973 | 1 | Agriculture | 55 | 1 | Netherlands 8 | Ortoli | 0 | 16291 | Lardinois, Petrus J. | 1973-01-06 | 1977-01-05 | 0.74 | Katholieke Volkspartij 451 | 0 | minister agriculture | doering | 10 | Biesheuvel II 291 | |
62 | 62 | 1973 | 1 | president | 62 | 0 | France 43 | Ortoli | 0 | 4661 | Ortoli, Francois-Xavier | 1973-01-06 | 1977-01-05 | 1.92 | Gaulliste 1094 | 1 | minister economy and finance | doering | 10 | Messmer I 430 | |
56 | 56 | 1973 | 1 | environment consumer protection transport informat | 56 | 0 | Italy 26 | Ortoli | 1 | 1158 | Scarascia-Mugnozza, Carlo | 1973-01-06 | 1977-01-05 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister justice | doering | 10 | Andreotti II 439 | |
57 | 57 | 1973 | 1 | taxation/financial institutions/energy/EURATOM | 57 | 1 | Belgium 64 | Ortoli | 0 | 1047 | Simonet, Henri | 1973-01-06 | 1977-01-05 | 1.02 | Belgische Socialistische Partij – Parti Socialiste Belge 167 | 0 | minister economy | doering | 10 | Eyskens G V 448 | |
58 | 58 | 1973 | 1 | external relations | 58 | 0 | United Kingdom 44 | Ortoli | 0 | 8804 | Soames, Christopher | 1973-01-06 | 1977-01-05 | 0.92 | Conservatives 773 | 0 | minister agriculture and fisheries | doering | 10 | Heath 216 | |
59 | 59 | 1973 | 0 | industry and technology | 59 | 0 | Italy 26 | Ortoli | 1 | 10089 | Spinelli, Altiero | 1973-01-06 | 1976-07-01 | 0.2 | Partito Socialista Italiano 1475 | 0 | adviser to foreign minister | doering | Aliança Povo Unido 11 | Andreotti II 439 | |
60 | 60 | 1973 | 1 | regional policy | 60 | 0 | United Kingdom 44 | Ortoli | 0 | 7552 | Thomson, George Morgan | 1973-01-06 | 1977-01-05 | 0.5 | Labour Party 1556 | 0 | minister without portfolio | doering | Aliança Povo Unido 11 | Heath 216 | |
61 | 61 | 1973 | 1 | competition policy | 61 | 1 | Luxembourg 7 | Ortoli | 0 | 12256 | Vouel, Raymond | 1976-07-20 | 1977-01-05 | 1.53 | Lëtzebuerger Sozialistesch Aarbechterpartei 701 | 0 | vice prime minister and finance minister | doering | 10 | Thorn 655 |
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]) );