election
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where "date" is on date 1996-04-21
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
472 | 472 | 551 | 13 | Italy 26 | 1996-04-21 | 1 | http://en.wikipedia.org/wiki/Italian_general_election,_1996 | 630 | 48846238 | 40496438 | 37295109 | archivio | Alliances were mainly formed for the plurality single member district voting part of the elections. For proportional voting, parties competed outside their electoral alliances. Alliances that formed for plurality voting were The Prodi-List (POP SVP PRI UD PRODI), CCD-CDU and The Dini-List. | 146 146 | 326 326 | Dini II 991 | 380 | 19960 |
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]) );