election
Data source: ParlGov · About: simonw/parlgov-datasette
1 row where "date" is on date 2012-12-09
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
694 | 694 | 787 | 13 | Romania 23 | 2012-12-09 | 0 | http://en.wikipedia.org/wiki/Romanian_legislative_election,_2012 | 412 | 18423066 | 7694180 | 7409626 | bec | The seats (json) of parties in alliances based on the candidate list of the Central Election Bureau (12. Lista candidaţilor care au primit mandat de deputat grupaţi pe circumscripţii electorale şi colegii uninominale). | 319 319 | 229 229 | Ponta I 1033 |
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]) );