cabinet
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where description = "Cabinet was appointed on 30 December 2008 and won an investiture vote on 2 January 2009 (yes: 88, no: 45). Cabinet ended on 19 November 2009 after PM van Rompuy was chosen as President of the European Council and cabinet resigned on 24 November."
This data as json, CSV (advanced)
Suggested facets: start_date (date)
Link | rowid ▼ | id | country_id | start_date | name | caretaker | wikipedia | data_source | description | comment | previous_cabinet_id | previous_parliament_election_id | previous_ep_election_id | old_countryID | old_cabID |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77 | 77 | 80 | Belgium 64 | 2008-12-30 | Rompuy | 0 | http://en.wikipedia.org/wiki/Van_Rompuy_I_Government | afp, nzz | Cabinet was appointed on 30 December 2008 and won an investiture vote on 2 January 2009 (yes: 88, no: 45). Cabinet ended on 19 November 2009 after PM van Rompuy was chosen as President of the European Council and cabinet resigned on 24 November. | Leterme I 264 | 401 401 | 656 656 | 56 | 20081 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE cabinet("id", "country_id", "start_date", "name", "caretaker", "wikipedia", "data_source", "description", "comment", "previous_cabinet_id", "previous_parliament_election_id", "previous_ep_election_id", "old_countryID", "old_cabID", FOREIGN KEY([country_id]) REFERENCES [country]([id]), FOREIGN KEY([data_source]) REFERENCES [info_data_source]([key]), FOREIGN KEY([previous_cabinet_id]) REFERENCES [cabinet]([id]), FOREIGN KEY([previous_parliament_election_id]) REFERENCES [election]([id]), FOREIGN KEY([previous_ep_election_id]) REFERENCES [election]([id]) );