election
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where "date" is on date 1980-10-05 sorted by id
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
243 | 243 | 281 | 13 | Portugal 63 | 1980-10-05 | 0 | http://en.wikipedia.org/wiki/Portuguese_legislative_election,_1980 | 250 | 7179023 | 6026395 | 5888733 | cne | PSD and PS gained seats through membership in electoral alliances and by running separately in the constituencies of Azores and Madeira possible error in the primary source due to the valid votes | 248 248 | Carneiro I 549 | 620 | 19800 | |||
469 | 469 | 547 | 13 | Germany 54 | 1980-10-05 | 0 | http://en.wikipedia.org/wiki/West_German_federal_election,_1980 | 497 | 43231741 | 38292176 | 37938981 | bwl, dhbt | Parliament was dissolved on 6 January 1983 by President Carstens (Schindler 1999, 1246) after Kohl initiated a confidence vote to dissolve parliament. | 163 163 | 361 361 | Schmidt II 459 | 276 | 19800 |
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]) );