cabinet
Data source: ParlGov · About: simonw/parlgov-datasette
1,609 rows sorted by wikipedia descending
This data as json, CSV (advanced)
Suggested facets: caretaker
start_date (date) >30 ✖
- 1993-01-12 3
- 1920-11-20 2
- 1932-06-03 2
- 1933-01-31 2
- 1935-06-07 2
- 1937-06-29 2
- 1939-12-13 2
- 1940-05-10 2
- 1958-07-01 2
- 1959-12-17 2
- 1963-12-18 2
- 1966-11-22 2
- 1983-06-09 2
- 1991-11-05 2
- 1993-06-25 2
- 1995-04-13 2
- 1996-01-11 2
- 1998-10-21 2
- 1999-05-28 2
- 1999-12-21 2
- 2000-06-07 2
- 2001-10-19 2
- 2002-07-30 2
- 2002-10-16 2
- 2003-02-28 2
- 2005-10-17 2
- 2005-10-31 2
- 2006-07-04 2
- 2007-04-05 2
- 2011-12-14 2
- …
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]) );