cabinet
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where "start_date" is on date 2011-12-14 sorted by name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
939 | 939 | 989 | Switzerland 40 | 2011-12-14 | Bundesrat 2011 | 0 | reuters | Federal Council was elected on 14 December 2011. Cabinet ended with election on 18 October 2015. | Bundesrat 2008 903 | 779 779 | |||||
936 | 936 | 986 | New Zealand 11 | 2011-12-14 | Key II | 0 | http://en.wikipedia.org/wiki/Fifth_National_Government_of_New_Zealand | nzhe, reuters | Cabinet was appointed on 14 December 2011. Minority cabinet was supported by confidence and supply agreements with ACT New Zealand, United New Zealand (signed on 5 Dec.) and the Maori Party (signed on 11 Dec.). | Key I 251 | 776 776 |
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]) );