cabinet
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where "start_date" is on date 1991-11-05 sorted by description
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
240 | 240 | 253 | Japan 5 | 1991-11-05 | Miyazawa | 0 | afp, reuters | Miyazawa lost a confidence vote (yes: 220, no: 255) on 18 June 1993 and dissolved parliament. Cabinet resigned on 5 August 1993. | Kaifu II 213 | 25 25 | 392 | 19910 | |||
333 | 333 | 348 | Bulgaria 10 | 1991-11-05 | Dimitrov | 0 | http://en.wikipedia.org/wiki/Philip_Dimitrov | nyt, reuters | PM Dimitrov was appointed on 5 November 1991 and the cabinet was approved (yes: 128, no: 90) three days later. Cabinet resigned on 28 December 1992 after losing a confidence vote (yes:120, no: 111). | 32 32 | 100 | 19910 |
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]) );