external_commissioner_doering

Table actions

Data source: ParlGov · About: simonw/parlgov-datasette

1 row where comment = "Lemaignen had been the vice-president of the French employers federation http://www.fep.up.pt/investigacao/seminarios/04.10.15_Maes.pdf; maj_party missing"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: start_date (date), end_date (date)

comment 1 ✖

  • Lemaignen had been the vice-president of the French employers federation http://www.fep.up.pt/investigacao/seminarios/04.10.15_Maes.pdf; maj_party missing · 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
3 3 Lemaignen had been the vice-president of the French employers federation http://www.fep.up.pt/investigacao/seminarios/04.10.15_Maes.pdf; maj_party missing 1958 0 overseas countries and territories 3 0 France 43 Hallstein I 0 12874 Lemaignen, Robert 1958-01-10 1962-01-09 0.2 sans étiquette 947 0 vice president of the French employers federation doering 12 Gaillard 458

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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])
);