cabinet
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where "start_date" is on date 1977-05-25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310 | 310 | 324 | Netherlands 8 | 1977-05-25 | Den Uyl II | 1 | http://en.wikipedia.org/wiki/Netherlands_cabinet_Den_Uyl | Election date (25 June 1977) set as start date because caretaker cabinet remains in office for more than three months after election but elections took place within three months after resignation (22 March 1977). | Den Uyl I 765 | 635 635 | 528 | 19771 |
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]) );