cabinet
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where "start_date" is on date 2005-10-17 sorted by description
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
664 | 664 | 693 | Norway 9 | 2005-10-17 | Stoltenberg II | 0 | http://en.wikipedia.org/wiki/Second_cabinet_Stoltenberg | ejpr | Bondevik II 300 | 3 3 | 578 | 20050 | |||
408 | 408 | 427 | New Zealand 11 | 2005-10-17 | Clark III | 0 | http://en.wikipedia.org/wiki/Fifth_Labour_Government_of_New_Zealand | ejpr | Minority cabinet with confidence and supply from New Zealand First Party and United Future. The Greens agreed to abstain on votes of confidence and supply. The Māori Party also abstained on confidence and supply votes without a formal agreement. | Clark II 845 | 675 675 | 554 | 20050 |
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]) );