cabinet
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where description = "PM Zapatero failed to win an absolute majority in an investiture vote on 9 April 2008 (yes: 168, no: 158, abstain: 23) and was elected by simple majority in a second vote (yes: 169, no: 158, abstain: 23) two days later. The prime minister was appointed on 12 April and the cabinet was presented two days after. Zapatero called early elections on 29 July 2011 and the cabinet ends with election on 20 November 2011."
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
473 | 473 | 497 | Spain 27 | 2008-04-12 | Zapatero II | 0 | afp | PM Zapatero failed to win an absolute majority in an investiture vote on 9 April 2008 (yes: 168, no: 158, abstain: 23) and was elected by simple majority in a second vote (yes: 169, no: 158, abstain: 23) two days later. The prime minister was appointed on 12 April and the cabinet was presented two days after. Zapatero called early elections on 29 July 2011 and the cabinet ends with election on 20 November 2011. | Zapatero I 806 | 500 500 | 368 368 | 724 | 20080 |
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]) );