election
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where "date" is on date 1937-06-06
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
840 | 840 | 936 | 13 | Luxembourg 7 | 1937-06-06 | 0 | https://en.wikipedia.org/wiki/Luxembourg_general_election,_1937 | 55 | 78220 | 73801 | no-2010 | The percentage of votes is not related to the number of votes in the table, 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). | 935 935 | Bech II 1451 |
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]) );