view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
11 rows where "election_date" is on date 1981-05-26
This data as json, CSV (advanced)
Suggested facets: vote_share, election_date (date)
country_name_short | country_name | election_type | election_date | vote_share | seats | seats_total | party_name_short | party_name | party_name_english | left_right | country_id | election_id | previous_parliament_election_id | previous_cabinet_id | party_id |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NLD | Netherlands | parliament | 1981-05-26 | 30.81 | 48 | 150 | CDA | Christen Democratisch Appèl | Christian Democratic Appeal | 5.9376 | 8 | 81 | 635 | 563 | 235 |
NLD | Netherlands | parliament | 1981-05-26 | 28.29 | 44 | 150 | PvdA | Partij van de Arbeid | Labour Party | 3.6118 | 8 | 81 | 635 | 563 | 742 |
NLD | Netherlands | parliament | 1981-05-26 | 17.32 | 26 | 150 | VVD | Volkspartij voor Vrijheid en Democratie | People's Party for Freedom and Democracy | 7.3482 | 8 | 81 | 635 | 563 | 1409 |
NLD | Netherlands | parliament | 1981-05-26 | 11.06 | 17 | 150 | D66 | Democraten 66 | Democrats 66 | 4.5066 | 8 | 81 | 635 | 563 | 345 |
NLD | Netherlands | parliament | 1981-05-26 | 2.05 | 3 | 150 | CPN | Communistische Partij Nederland | Communist Party of the Netherlands | 0.8 | 8 | 81 | 635 | 563 | 1194 |
NLD | Netherlands | parliament | 1981-05-26 | 2.12 | 3 | 150 | PSP | Pacifistisch Socialistische Partij | Pacifist Socialist Party | 0.6 | 8 | 81 | 635 | 563 | 1452 |
NLD | Netherlands | parliament | 1981-05-26 | 1.97 | 3 | 150 | PPR | Politieke Partij Radikalen | Radical Political Party | 1.6 | 8 | 81 | 635 | 563 | 342 |
NLD | Netherlands | parliament | 1981-05-26 | 1.97 | 3 | 150 | SGP | Staatkundig Gereformeerde Partij | Political Reformed Party | 8.7531 | 8 | 81 | 635 | 563 | 1251 |
NLD | Netherlands | parliament | 1981-05-26 | 1.25 | 2 | 150 | RPF | Reformatorische Politieke Federati | Reformatory Political Federation | 8.2963 | 8 | 81 | 635 | 563 | 212 |
NLD | Netherlands | parliament | 1981-05-26 | 0.82 | 1 | 150 | GPV | Gereformeerd Politiek Verbond | Reformed Political League | 8.1444 | 8 | 81 | 635 | 563 | 625 |
NLD | Netherlands | parliament | 1981-05-26 | 0.56 | 0 | 150 | DS70 | Democratisch Socialisten 70 | Democratic Socialists 70 | 3.8433 | 8 | 81 | 635 | 563 | 402 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW view_election AS SELECT c.name_short AS country_name_short, c.name AS country_name, ii.short AS election_type, e.date AS election_date, vote_share, seats, seats_total, p.name_short AS party_name_short, p.name AS party_name, p.name_english AS party_name_english, vpp.left_right AS left_right, e.country_id AS country_id, er.election_id AS election_id, e.previous_parliament_election_id AS previous_parliament_election_id, e.previous_cabinet_id AS previous_cabinet_id, er.party_id AS party_id FROM (SELECT * FROM election_result WHERE vote_share NOT NULL OR seats NOT NULL) er LEFT OUTER JOIN election e ON er.election_id = e.id LEFT OUTER JOIN party p ON er.party_id = p.id LEFT OUTER JOIN viewcalc_party_position AS vpp ON er.party_id = vpp.party_id LEFT OUTER JOIN country c ON e.country_id = c.id LEFT OUTER JOIN info_id ii ON e.type_id = ii.id ORDER BY c.name_short, e.date, er.seats DESC;