election
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where "date" is on date 1972-11-25
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 1 | 13 | New Zealand 11 | 1972-11-25 | 0 | http://en.wikipedia.org/wiki/New_Zealand_general_election,_1972 | 87 | 1569937 | 1410240 | 1401152 | yb-nzl | The sources are inconsistent in the number of seats. The official yearbook 1974 notifies 53 seats for Labour Party and 34 seats for National Party. The following yearbooks and Nohlen 2001 notifies the stated distribution. | 120 120 | Marshall 569 | 554 | 19720 |
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]) );