cabinet
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where "start_date" is on date 1919-02-13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1482 | 1482 | 1556 | Germany 54 | 1919-02-13 | Scheidemann | 0 | https://en.wikipedia.org/wiki/Scheidemann_cabinet | vs14 | Cabinet took office on 13 February 1919, through the provisional law "Gesetz über die vorläufige Reichsgewalt" by Reichspräsident Ebert. Scheidemann resigned on 20 June 1919, because he could not agree to the signing of the Treaty of Versailles. | 1031 1031 |
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]) );