election
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where "date" is on date 2010-10-02
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
598 | 598 | 690 | 13 | Latvia 55 | 2010-10-02 | 0 | http://en.wikipedia.org/wiki/Latvian_parliamentary_election,_2010 | 100 | 1491735 | 965538 | 944841 | cvk, parline | President Zatlers dissolved parliament on 28 May 2011 following a corruption scandal. The dissolution was approved in a mandatory referendum on 23 July. | Vote shares differ in comparison to results provided by Central Election Commission Latvia (cvk). We use the number of valid votes (944 841) to calculate the vote share and not the number of votes cast (965 538). | 52 52 | 302 302 | Dombrovskis II 519 |
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]) );