election
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where "date" is on date 1946-04-10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
604 | 604 | 697 | 13 | Japan 5 | 1946-04-10 | 0 | http://en.wikipedia.org/wiki/Japanese_general_election,_1946 | 464 | 36878417 | 26582175 | 26100175 | no-2001 | In this election voters were entitled to one, two or three votes, depending on the size of their constintuency. Here, the number of votes cast means ballots cast. The total number of valid votes is 55,448,879. |
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]) );