cabinet
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where "start_date" is on date 2007-04-05 sorted by data_source
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
658 | 658 | 686 | Estonia 75 | 2007-04-05 | Ansip II | 0 | http://en.wikipedia.org/wiki/Andrus_Ansip%27s_cabinet | afp, reuters | Cabinet was appointed on 5 April 2007. Cabinet ended on 21 May 2009 when PM Ansip fired all three SDE ministers. | Ansip I 274 | 83 83 | 130 130 | 233 | 20070 | |
113 | 113 | 118 | Romania 23 | 2007-04-05 | Popescu-Tariceanu III | 0 | http://en.wikipedia.org/wiki/C%C4%83lin_Popescu-T%C4%83riceanu | ejpr | Cabinet won an investiture vote (yes: 303, no: 27) on 3 April 2007. | Popescu-Tariceanu II 28 | 165 165 | 4 4 | 642 | 20070 |
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]) );