election
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where "date" is on date 2015-11-08
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
905 | 905 | 1001 | 13 | Croatia 62 | 2015-11-08 | 0 | https://en.wikipedia.org/wiki/Croatian_parliamentary_election,_2015 | 151 | 3788788 | 2304403 | 2262782 | ejpr | Votes are given on the alliance level as votes cast for each alliance party do not add up to the total votes cast for an alliance. Some voters did not indicate their preferential vote, but just voted for the whole alliance. | 792 792 | 841 841 | Milanovic 1056 |
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]) );