external_commissioner_doering
Data source: ParlGov · About: simonw/parlgov-datasette
10 rows where commission_name = "Malfatti/Manshold" 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
41 | 41 | 1970 | 1 | energy | 41 | 0 | Germany 54 | Malfatti/Manshold | 1 | 2142 | Haferkamp, Wilhelm | 1970-07-01 | 1973-01-05 | 0.2 | Sozialdemokratische Partei Deutschlands 558 | 0 | member state assembly (NRW) | doering | 10 | Brandt I 358 | |
44 | 44 | 1970 | 1 | president | 44 | 0 | Italy 26 | Malfatti/Manshold | 0 | 6848 | Malfatti, Franco Maria | 1970-07-01 | 1972-03-21 | 1.18 | Democrazia Cristiana 1633 | 1 | minister state participation in industry | doering | 10 | Rumor III 113 | |
45 | 45 | 1970 | 1 | agriculture | 45 | 1 | Netherlands 8 | Malfatti/Manshold | 1 | 11499 | Mansholt, Sicco Leendert | 1970-07-01 | 1973-01-05 | 0.74 | Partij van de Arbeid 742 | 1 | minister agriculture | doering | Aliança Povo Unido 11 | De Jong 172 | |
42 | 42 | 1970 | 1 | agriculture | 42 | 0 | Italy 26 | Malfatti/Manshold | 0 | 1158 | Scarascia-Mugnozza, Carlo | 1972-03-22 | 1973-01-05 | 0.46 | Democrazia Cristiana 1633 | 0 | junior minister justice | doering | 10 | Andreotti I 398 | |
43 | 43 | 1970 | 0 | industry | 43 | 0 | Italy 26 | Malfatti/Manshold | 0 | 10089 | Spinelli, Altiero | 1970-07-01 | 1973-01-05 | 0.2 | Partito Socialista Italiano 1475 | 0 | adviser to foreign minister | doering | 10 | Rumor III 113 |
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]) );