cabinet
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where "start_date" is on date 1933-01-31 sorted by previous_cabinet_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1274 | 1274 | 1335 | France 43 | 1933-01-31 | Daladier I | 0 | https://fr.wikipedia.org/wiki/Gouvernement_Édouard_Daladier_(1) | Cabinet lost a confidence vote (yes: 241, no: 329) over finance policy. | Paul-Boncour 1336 | 984 984 | |||||
1504 | 1504 | 1578 | Germany 54 | 1933-01-31 | Hitler | 0 | https://en.wikipedia.org/wiki/Hitler_Cabinet | vs14 | Cabinet took office on 31 January 1933. All non-NSDAP members were later removed from the government. With the Enabling Act of 24 March 1933, the government was able to pass laws without the Reichstag, which meant the end of the Weimar Republic. | Schleicher 1577 | 1039 1039 |
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]) );