election
Data source: ParlGov · About: simonw/parlgov-datasette
1,021 rows sorted by seats_total
This data as json, CSV (advanced)
Suggested facets: type_id, early
date (date) >30 ✖
- 2014-05-25 24
- 2004-06-13 23
- 2009-06-07 23
- 2019-05-26 22
- 1999-06-13 16
- 1989-06-18 14
- 1994-06-12 12
- 1984-06-17 11
- 1979-06-10 10
- 2019-05-25 4
- 1995-01-01 3
- 1996-10-20 3
- 2014-05-24 3
- 1919-10-26 2
- 1945-10-21 2
- 1946-06-02 2
- 1958-06-01 2
- 1963-11-30 2
- 1966-11-26 2
- 1980-10-05 2
- 1981-10-18 2
- 1986-01-01 2
- 1987-07-19 2
- 1989-06-15 2
- 1990-04-08 2
- 1990-06-09 2
- 1991-10-20 2
- 1992-06-06 2
- 1993-06-06 2
- 1995-10-01 2
- …
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE election("id", "type_id", "country_id", "date", "first_round_election_id", "early", "wikipedia", "seats_total", "electorate", "votes_cast", "votes_valid", "data_source", "description", "comment", "previous_parliament_election_id", "previous_ep_election_id", "previous_cabinet_id", "old_countryID", "old_parlID", FOREIGN KEY([country_id]) REFERENCES [country]([id]), 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]) );