cabinet
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where "start_date" is on date 1933-01-31 sorted by wikipedia
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
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 |
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]) );