view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
25 rows where "election_date" is on date 2019-05-23 sorted by party_name_english
This data as json, CSV (advanced)
Suggested facets: country_name_short, country_name, seats, left_right, election_id, previous_parliament_election_id
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 | ep | 2019-05-23 | 3.91 | 1 | 26 | 50+ | 50PLUS | 50PLUS | 8 | 1052 | 1012 | 1530 | 2109 | |
GBR | United Kingdom | ep | 2019-05-23 | 0.6 | 1 | 73 | APoNI | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | 6.0 | 44 | 1051 | 1013 | 1507 | 2731 |
GBR | United Kingdom | ep | 2019-05-23 | 31.6 | 29 | 73 | BP | Brexit Party | Brexit Party | 8.8 | 44 | 1051 | 1013 | 1507 | 2729 |
GBR | United Kingdom | ep | 2019-05-23 | 3.4 | 0 | 73 | CUK | Change UK | Change UK | 44 | 1051 | 1013 | 1507 | 2730 | |
NLD | Netherlands | ep | 2019-05-23 | 12.18 | 4 | 26 | CDA | Christen Democratisch Appèl | Christian Democratic Appeal | 5.9376 | 8 | 1052 | 1012 | 1530 | 235 |
NLD | Netherlands | ep | 2019-05-23 | 6.83 | 2 | 26 | CU | ChristenUnie | ChristianUnion | 6.1732 | 8 | 1052 | 1012 | 1530 | 1206 |
GBR | United Kingdom | ep | 2019-05-23 | 9.1 | 4 | 73 | Con | Conservatives | Conservatives | 7.4261 | 44 | 1051 | 1013 | 1507 | 773 |
GBR | United Kingdom | ep | 2019-05-23 | 0.7 | 1 | 73 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 1051 | 1013 | 1507 | 319 |
NLD | Netherlands | ep | 2019-05-23 | 7.09 | 2 | 26 | D66 | Democraten 66 | Democrats 66 | 4.5066 | 8 | 1052 | 1012 | 1530 | 345 |
NLD | Netherlands | ep | 2019-05-23 | 10.96 | 3 | 26 | FvD | Forum voor Democratie | Forum for Democracy | 8.8 | 8 | 1052 | 1012 | 1530 | 2642 |
GBR | United Kingdom | ep | 2019-05-23 | 12.1 | 7 | 73 | GP | Green Party | Green Party | 2.57 | 44 | 1051 | 1013 | 1507 | 467 |
NLD | Netherlands | ep | 2019-05-23 | 10.9 | 3 | 26 | GL | GroenLinks | GreenLeft | 2.0454 | 8 | 1052 | 1012 | 1530 | 756 |
GBR | United Kingdom | ep | 2019-05-23 | 14.1 | 10 | 73 | Lab | Labour Party | Labour | 4.3562 | 44 | 1051 | 1013 | 1507 | 1556 |
NLD | Netherlands | ep | 2019-05-23 | 19.01 | 6 | 26 | PvdA | Partij van de Arbeid | Labour Party | 3.6118 | 8 | 1052 | 1012 | 1530 | 742 |
GBR | United Kingdom | ep | 2019-05-23 | 20.3 | 16 | 73 | Lib | Liberals | Liberals | 4.2875 | 44 | 1051 | 1013 | 1507 | 659 |
NLD | Netherlands | ep | 2019-05-23 | 3.53 | 0 | 26 | PVV | Partij voor de Vrijheid | Party for Freedom | 8.8 | 8 | 1052 | 1012 | 1530 | 1501 |
NLD | Netherlands | ep | 2019-05-23 | 4.02 | 1 | 26 | PvdD | Partij voor de Dieren | Party for the Animals | 8 | 1052 | 1012 | 1530 | 990 | |
NLD | Netherlands | ep | 2019-05-23 | 14.64 | 4 | 26 | VVD | Volkspartij voor Vrijheid en Democratie | People's Party for Freedom and Democracy | 7.3482 | 8 | 1052 | 1012 | 1530 | 1409 |
GBR | United Kingdom | ep | 2019-05-23 | 1.0 | 1 | 73 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 1051 | 1013 | 1507 | 311 |
GBR | United Kingdom | ep | 2019-05-23 | 3.6 | 3 | 73 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 1051 | 1013 | 1507 | 1284 |
GBR | United Kingdom | ep | 2019-05-23 | 0.7 | 1 | 73 | SF | Sinn Féin | Sinn Fein | 1.3 | 44 | 1051 | 1013 | 1507 | 689 |
NLD | Netherlands | ep | 2019-05-23 | 3.37 | 0 | 26 | SP | Socialistiese Partij | Socialist Party | 1.3682 | 8 | 1052 | 1012 | 1530 | 357 |
NLD | Netherlands | ep | 2019-05-23 | 1.1 | 0 | 26 | DENK | Beweging DENK | Think | 3.3 | 8 | 1052 | 1012 | 1530 | 2641 |
GBR | United Kingdom | ep | 2019-05-23 | 3.3 | 0 | 73 | UKIP | United Kingdom Independence Party | United Kingdom Independence Party | 7.8429 | 44 | 1051 | 1013 | 1507 | 1272 |
NLD | Netherlands | ep | 2019-05-23 | 1.93 | 0 | 26 | VN | Volt Nederland | Volt Netherlands | 8 | 1052 | 1012 | 1530 | 2735 |
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;