election
Data source: ParlGov · About: simonw/parlgov-datasette
24 rows where "date" is on date 2014-05-25
This data as json, CSV (advanced)
Suggested facets: type_id, country_id, seats_total, data_source, previous_parliament_election_id, previous_ep_election_id
previous_cabinet_id 23 ✖
- Di Rupo 2
- Reinfeldt II 1
- Passos Coelho I 1
- Tusk II 1
- Rajoy I 1
- Fico II 1
- Rutte III 1
- Butkevicius I 1
- Muscat I 1
- Bratusek 1
- Milanovic 1
- Oresharski 1
- Samaras II 1
- Bettel I 1
- Faymann II 1
- Merkel III 1
- Thorning-Schmidt II 1
- Renzi 1
- Ponta III 1
- Anastasiades II 1
- Katainen II 1
- Roivas I 1
- Orban III 1
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]) );