external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
17 rows where commission_name = "Thorn"
This data as json, CSV (advanced)
Suggested facets: comment, elected, one_seat, country_id, incumbent, start_date, end_date, score_position, party_id, president, government_party, previous_cabinet_id, start_date (date), end_date (date)
portfolio 15 ✖
- agriculture 2
- development aid 2
- budget a financial control. finacial institutions 1
- community funds and regional policy 1
- competition 1
- economics+finance/credits+investment/statistical office 1
- enlargement/environment protection/nuclear safety 1
- external relations 1
- internal market and industrial affairs/energy 1
- internal market/customs services+industrial innovation 1
- personnel and community budget 1
- president 1
- social affairs 1
- taxation/consumer affairs/transport/EP relations 1
- transport and fisheries 1
highest_position 14 ✖
- minister agriculture 3
- diplomat 2
- bureaucrat 1
- diplomat and bureaucrat 1
- member state assembly (NRW) 1
- mep 1
- minister budget and economic planning 1
- minister economy and finance 1
- minister education 1
- minister finance 1
- minister for foreign affairs and finance 1
- mp 1
- prime minister 1
- under secretary of state defence 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
76 | 76 | 1981 | 0 | competition | 76 | 1 | Netherlands 8 | Thorn | 0 | 13160 | Andriessen, Frans | 1981-01-06 | 1985-01-05 | 2.02 | Christen Democratisch Appèl 235 | 0 | minister finance | doering | 10 | Van Agt I 563 | |
77 | 77 | time as commissioner was interrupted | 1981 | 1 | taxation/consumer affairs/transport/EP relations | 77 | 1 | Ireland 37 | Thorn | 0 | 726 | Burke, Richard | 1982-04-01 | 1985-01-05 | 1.19 | Fine Gael 1393 | 0 | minister education | doering | 10 | Haughey II 54 |
78 | 78 | adviser to the cabinet of Alain Savary (Socialist) and later a member of the Socialist party | 1981 | 0 | development aid | 78 | 0 | France 43 | Thorn | 1 | 5019 | Cheysson, Claude | 1981-01-06 | 1981-06-23 | 0.2 | Parti socialiste 1539 | 0 | bureaucrat | doering | Aliança Povo Unido 11 | Barre II 72 |
79 | 79 | 1981 | 0 | transport and fisheries | 79 | 1 | Greece 41 | Thorn | 0 | 10590 | Contogeorgis, Georges | 1981-01-06 | 1985-01-05 | 0.2 | Néa Đimokratía 47 | 0 | diplomat | doering | Aliança Povo Unido 11 | Rallis 531 | |
80 | 80 | 1981 | 1 | agriculture | 80 | 1 | Denmark 21 | Thorn | 0 | 16571 | Dalsager, Poul | 1981-01-20 | 1985-01-05 | 1.0 | Socialdemokraterne 1629 | 0 | minister agriculture | doering | 10 | Jorgensen V 379 | |
81 | 81 | 1981 | 0 | internal market and industrial affairs/energy | 81 | 1 | Belgium 64 | Thorn | 1 | 10947 | Davignon, Etienne | 1981-01-06 | 1985-01-05 | 0.2 | no party affiliation 1458 | 0 | diplomat and bureaucrat | doering | 12 | Martens IV 453 | |
82 | 82 | 1981 | 1 | community funds and regional policy | 82 | 0 | Italy 26 | Thorn | 1 | 8614 | Giolitti, Antonio | 1981-01-06 | 1985-01-05 | 0.98 | Partito Socialista Italiano 1475 | 0 | minister budget and economic planning | doering | 10 | Forlani 464 | |
83 | 83 | 1981 | 0 | agriculture | 83 | 1 | Denmark 21 | Thorn | 1 | 14835 | Gundelach, Finn Olav | 1981-01-06 | 1981-01-13 | 0.2 | ingen 1128 | 0 | diplomat | doering | 12 | Jorgensen V 379 | |
84 | 84 | 1981 | 1 | external relations | 84 | 0 | Germany 54 | Thorn | 1 | 2142 | Haferkamp, Wilhelm | 1981-01-06 | 1985-01-05 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | member state assembly (NRW) | doering | 10 | Schmidt III 343 | |
85 | 85 | 1981 | 0 | internal market/customs services+industrial innovation | 85 | 0 | Germany 54 | Thorn | 0 | 6286 | Narjes, Karl-Heinz | 1981-01-06 | 1985-01-05 | 0.33 | Christlich Demokratische Union 808 | 0 | mp | doering | Aliança Povo Unido 11 | Schmidt III 343 | |
86 | 86 | 1981 | 1 | enlargement/environment protection/nuclear safety | 86 | 0 | Italy 26 | Thorn | 1 | 6114 | Natali, Lorenzo | 1981-01-06 | 1985-01-05 | 0.83 | Democrazia Cristiana 1633 | 0 | minister agriculture | doering | 10 | Forlani 464 | |
87 | 87 | 1981 | 1 | personnel and community budget | 87 | 1 | Ireland 37 | Thorn | 0 | 6073 | O'Kennedy, Michael | 1981-01-06 | 1982-03-03 | 1.83 | Fianna Fáil 280 | 0 | minister for foreign affairs and finance | doering | 10 | Haughey I 442 | |
88 | 88 | 1981 | 0 | economics+finance/credits+investment/statistical office | 88 | 0 | France 43 | Thorn | 1 | 4661 | Ortoli, Francois-Xavier | 1981-01-06 | 1984-10-26 | 1.92 | Gaulliste 1094 | 0 | minister economy and finance | doering | 10 | Barre II 72 | |
89 | 89 | 1981 | 1 | development aid | 89 | 0 | France 43 | Thorn | 0 | 12643 | Pisani, Edgard | 1981-01-06 | 1984-12-03 | 1.24 | Parti socialiste 1539 | 0 | minister agriculture | doering | Aliança Povo Unido 11 | Barre II 72 | |
90 | 90 | 1981 | 1 | social affairs | 90 | 0 | United Kingdom 44 | Thorn | 0 | 3740 | Richard, Ivor | 1981-01-06 | 1985-01-05 | 0.5 | Labour Party 1556 | 0 | under secretary of state defence | doering | Aliança Povo Unido 11 | Thatcher I 273 | |
91 | 91 | 1981 | 1 | budget a financial control. finacial institutions | 91 | 0 | United Kingdom 44 | Thorn | 1 | 5942 | Tugendhat, Christopher S. | 1981-01-06 | 1985-01-05 | 0.33 | Conservatives 773 | 0 | mep | doering | 10 | Thatcher I 273 | |
92 | 92 | 1981 | 1 | president | 92 | 1 | Luxembourg 7 | Thorn | 0 | 2048 | Thorn, Gaston | 1981-01-06 | 1985-01-05 | 2.17 | Demokratesch Partei 967 | 1 | prime minister | doering | 10 | Werner IV 27 |
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]) );