election
Data source: ParlGov · About: simonw/parlgov-datasette
3 rows where "date" is on date 1996-10-20
This data as json, CSV (advanced)
Suggested facets: type_id, early, old_parlID
Link | rowid ▼ | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
485 | 485 | 566 | 13 | Lithuania 15 | 1996-10-20 | 0 | http://en.wikipedia.org/wiki/Lithuanian_parliamentary_election,_1996 | 141 | 2597530 | 1374673 | 1306922 | vrk | 439 439 | Stankevicius 91 | 440 | 19960 | ||||
540 | 540 | 628 | 13 | Japan 5 | 1996-10-20 | 1 | http://en.wikipedia.org/wiki/Japanese_general_election,_1996 | 500 | 97909655 | 57766696 | idea | 57 57 | Hashimoto I 800 | 392 | 19960 | |||||
561 | 561 | 652 | 1 | Finland 67 | 1996-10-20 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1996_(Finland) | 16 | 4108703 | 2366504 | 2249411 | tila | 24 24 | 193 193 | Lipponen I 100 | 246 | 1019960 |
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]) );