election
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where comment = "Elections took only place in 1987. Results reflect the initial composition of Portuguese MEPs, based on the party composition of the Assembly of the Republic."
This data as json, CSV (advanced)
Suggested facets: date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
273 | 273 | 317 | 1 | Portugal 63 | 1986-01-01 | 0 | http://en.wikipedia.org/wiki/European_Parliament_election,_1987_(Portugal) | 24 | Elections took only place in 1987. Results reflect the initial composition of Portuguese MEPs, based on the party composition of the Assembly of the Republic. | 106 106 | Silva I 734 | 620 | 1019860 |
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]) );