election
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where "date" is on date 1931-06-07
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
838 | 838 | 934 | 13 | Luxembourg 7 | 1931-06-07 | 0 | https://en.wikipedia.org/wiki/Luxembourg_general_election,_1931 | 54 | 69498 | 65620 | no-2010 | The percentage of votes is not related to the number of valid votes, as voters could cast more votes in some constituencies than others, and is instead calculated based on the proportion of votes received in each constituency (Nohlen/Stöver 2010: 1254). | 933 933 | Bech I 1450 |
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]) );