election
Data source: ParlGov · About: simonw/parlgov-datasette
2 rows where "date" is on date 1980-10-05 sorted by comment
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 |
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]) );