view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_id
This data as json, CSV (advanced)
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CZE | Czech Republic | parliament | 2010-05-29 | 16.7 | 38 | 200 | TOP09 | Tradice Odpovědnost Prosperita 09 | Tradition Responsibility Prosperity 09 | 7.4 | 68 | 599 | 50 | 157 | 2 |
CZE | Czech Republic | parliament | 2013-10-25 | 11.99 | 21 | 200 | TOP09 | Tradice Odpovědnost Prosperita 09 | Tradition Responsibility Prosperity 09 | 7.4 | 68 | 805 | 599 | 1062 | 2 |
CZE | Czech Republic | ep | 2014-05-24 | 15.95 | 4 | 21 | TOP09 | Tradice Odpovědnost Prosperita 09 | Tradition Responsibility Prosperity 09 | 7.4 | 68 | 820 | 805 | 1072 | 2 |
CZE | Czech Republic | parliament | 2017-10-21 | 5.31 | 7 | 200 | TOP09 | Tradice Odpovědnost Prosperita 09 | Tradition Responsibility Prosperity 09 | 7.4 | 68 | 1020 | 805 | 1072 | 2 |
CZE | Czech Republic | ep | 2019-05-25 | 11.65 | 3 | 21 | TOP09 | Tradice Odpovědnost Prosperita 09 | Tradition Responsibility Prosperity 09 | 7.4 | 68 | 1057 | 1020 | 1534 | 2 |
NLD | Netherlands | parliament | 1948-07-07 | 1.26 | 1 | 100 | KNP | Katholieke Nationale Partij | Catholic National Party | 6.2 | 8 | 497 | 182 | 96 | 3 |
NLD | Netherlands | parliament | 1952-06-25 | 2.71 | 2 | 100 | KNP | Katholieke Nationale Partij | Catholic National Party | 6.2 | 8 | 543 | 497 | 243 | 3 |
JPN | Japan | parliament | 2005-09-11 | 1.74 | 4 | 480 | PNP | Kokumin Shinto | People's New Party | 7.4 | 5 | 554 | 511 | 770 | 4 |
JPN | Japan | parliament | 2009-08-30 | 1.73 | 3 | 480 | PNP | Kokumin Shinto | People's New Party | 7.4 | 5 | 327 | 554 | 494 | 4 |
JPN | Japan | parliament | 2012-12-16 | 0.1 | 1 | 480 | PNP | Kokumin Shinto | People's New Party | 7.4 | 5 | 788 | 327 | 969 | 4 |
ROU | Romania | ep | 2007-01-01 | 2 | 35 | PU|PC | Partidul Umanist | Partidul Conservator | Humanist Party | Conservative Party | 4.7622 | 23 | 4 | 165 | 28 | 5 | |
ROU | Romania | ep | 2007-11-25 | 2.9 | 0 | 35 | PU|PC | Partidul Umanist | Partidul Conservator | Humanist Party | Conservative Party | 4.7622 | 23 | 676 | 165 | 118 | 5 |
ROU | Romania | parliament | 2008-11-30 | 4 | 334 | PU|PC | Partidul Umanist | Partidul Conservator | Humanist Party | Conservative Party | 4.7622 | 23 | 319 | 165 | 118 | 5 | |
ROU | Romania | ep | 2009-06-07 | 1 | 33 | PU|PC | Partidul Umanist | Partidul Conservator | Humanist Party | Conservative Party | 4.7622 | 23 | 229 | 319 | 599 | 5 | |
ROU | Romania | parliament | 2012-12-09 | 13 | 412 | PU|PC | Partidul Umanist | Partidul Conservator | Humanist Party | Conservative Party | 4.7622 | 23 | 787 | 319 | 1033 | 5 | |
ROU | Romania | parliament | 2020-12-06 | 1.01 | 0 | 330 | PU|PC | Partidul Umanist | Partidul Conservator | Humanist Party | Conservative Party | 4.7622 | 23 | 1093 | 1015 | 1626 | 5 |
CYP | Cyprus | parliament | 1996-05-26 | 1.7 | 0 | 56 | NO | Neoi Orizontes | New Horizons | 9.3421 | 51 | 330 | 342 | 645 | 6 |
CYP | Cyprus | parliament | 2001-05-27 | 3.0 | 1 | 56 | NO | Neoi Orizontes | New Horizons | 9.3421 | 51 | 339 | 330 | 731 | 6 |
CYP | Cyprus | ep | 2004-06-13 | 1.65 | 0 | 6 | NO | Neoi Orizontes | New Horizons | 9.3421 | 51 | 397 | 339 | 342 | 6 |
PRT | Portugal | parliament | 1979-12-02 | 19.33 | 250 | APU | Aliança Povo Unido | United People Alliance | 1.3 | 63 | 248 | 200 | 384 | 11 | |
PRT | Portugal | parliament | 1980-10-05 | 17.14 | 250 | APU | Aliança Povo Unido | United People Alliance | 1.3 | 63 | 281 | 248 | 549 | 11 | |
PRT | Portugal | parliament | 1983-04-25 | 18.55 | 250 | APU | Aliança Povo Unido | United People Alliance | 1.3 | 63 | 598 | 281 | 135 | 11 | |
PRT | Portugal | parliament | 1985-10-06 | 15.89 | 250 | APU | Aliança Povo Unido | United People Alliance | 1.3 | 63 | 106 | 598 | 885 | 11 | |
BGR | Bulgaria | parliament | 2001-06-18 | 3.44 | 0 | 240 | KSII | Koalitsiya Simeon II | Simeon II Coalition | 6.86 | 10 | 681 | 126 | 792 | 15 |
SVN | Slovenia | parliament | 1990-04-12 | 12.6 | 11 | 80 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 129 | 16 | ||
SVN | Slovenia | parliament | 1992-12-06 | 8.69 | 10 | 90 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 382 | 129 | 9 | 16 |
SVN | Slovenia | parliament | 1996-11-10 | 19.38 | 19 | 90 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 338 | 382 | 562 | 16 |
SVN | Slovenia | parliament | 2000-10-15 | 9.54 | 9 | 90 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 525 | 338 | 768 | 16 |
SVN | Slovenia | ep | 2004-06-13 | 8.41 | 0 | 7 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 659 | 525 | 292 | 16 |
SVN | Slovenia | parliament | 2004-10-03 | 6.82 | 7 | 90 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 80 | 525 | 292 | 16 |
SVN | Slovenia | parliament | 2008-09-21 | 5.21 | 5 | 90 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 522 | 80 | 407 | 16 |
SVN | Slovenia | ep | 2009-06-07 | 3.58 | 0 | 7 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 195 | 522 | 803 | 16 |
SVN | Slovenia | parliament | 2011-12-04 | 6.83 | 6 | 90 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 778 | 522 | 907 | 16 |
SVN | Slovenia | parliament | 2014-07-13 | 3.95 | 0 | 90 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 817 | 778 | 1047 | 16 |
SVN | Slovenia | parliament | 2018-06-03 | 2.62 | 0 | 90 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 1025 | 817 | 1144 | 16 |
POL | Poland | parliament | 1991-10-27 | 2.1 | 4 | 460 | SoPr | Solidarność Pracy | Labour Solidarity | 3.3 | 74 | 211 | 158 | 75 | 18 |
CZE | Czech Republic | parliament | 1990-06-09 | 10.03 | 22 | 200 | HSD-SMS | Hnutí za samosprávnou demokracii – Společnost pro Moravu a Slezsko | Movement for Self-Governing Democracy -- Society for Moravia and Silesia | 68 | 63 | 19 | |||
CZE | Czech Republic | parliament | 1992-06-06 | 5.87 | 14 | 200 | HSD-SMS | Hnutí za samosprávnou demokracii – Společnost pro Moravu a Slezsko | Movement for Self-Governing Democracy -- Society for Moravia and Silesia | 68 | 39 | 63 | 262 | 19 | |
SVK | Slovakia | parliament | 2002-09-21 | 3.65 | 0 | 150 | PSNS | Pravá Slovenská národná strana | Real Slovak National Party | 8.5 | 1 | 218 | 349 | 699 | 20 |
LTU | Lithuania | parliament | 1990-03-10 | 4 | 135 | LZP | Lietuvos žalioji partija | Lithuanian Green Party | 2.5 | 15 | 462 | 21 | |||
LTU | Lithuania | ep | 2014-05-25 | 3.56 | 0 | 11 | LZP | Lietuvos žalioji partija | Lithuanian Green Party | 2.5 | 15 | 842 | 786 | 1042 | 21 |
LTU | Lithuania | parliament | 2016-10-09 | 2.03 | 1 | 141 | LZP | Lietuvos žalioji partija | Lithuanian Green Party | 2.5 | 15 | 1009 | 786 | 1633 | 21 |
LTU | Lithuania | ep | 2019-05-26 | 2.27 | 0 | 11 | LZP | Lietuvos žalioji partija | Lithuanian Green Party | 2.5 | 15 | 1064 | 1009 | 1614 | 21 |
LTU | Lithuania | parliament | 2020-10-11 | 1.7 | 1 | 141 | LZP | Lietuvos žalioji partija | Lithuanian Green Party | 2.5 | 15 | 1091 | 1009 | 1615 | 21 |
EST | Estonia | parliament | 1992-09-20 | 7.12 | 8 | 101 | SK | Sõltumatud Kuningriiklased | Independent Royalists | 75 | 670 | 25 | |||
CHE | Switzerland | parliament | 1902-10-26 | 50.39 | 100 | 167 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 982 | 26 | ||
CHE | Switzerland | parliament | 1905-10-29 | 49.25 | 104 | 167 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 981 | 982 | 1456 | 26 |
CHE | Switzerland | parliament | 1908-10-25 | 50.91 | 105 | 167 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 980 | 981 | 1457 | 26 |
CHE | Switzerland | parliament | 1911-10-29 | 49.47 | 114 | 189 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 979 | 980 | 1458 | 26 |
CHE | Switzerland | parliament | 1914-10-25 | 56.15 | 112 | 189 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 978 | 979 | 1459 | 26 |
CHE | Switzerland | parliament | 1917-10-28 | 40.84 | 103 | 189 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 977 | 978 | 1463 | 26 |
CHE | Switzerland | parliament | 1919-10-26 | 28.8 | 60 | 189 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 770 | 977 | 1464 | 26 |
CHE | Switzerland | parliament | 1922-10-29 | 28.3 | 60 | 198 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 773 | 770 | 981 | 26 |
CHE | Switzerland | parliament | 1925-10-25 | 27.8 | 60 | 198 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 774 | 773 | 980 | 26 |
CHE | Switzerland | parliament | 1928-10-28 | 27.4 | 58 | 198 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 772 | 774 | 979 | 26 |
CHE | Switzerland | parliament | 1931-10-25 | 26.9 | 52 | 187 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 768 | 772 | 978 | 26 |
CHE | Switzerland | parliament | 1935-10-27 | 23.7 | 48 | 187 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 769 | 768 | 975 | 26 |
CHE | Switzerland | parliament | 1939-10-29 | 20.7 | 49 | 187 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 767 | 769 | 974 | 26 |
CHE | Switzerland | parliament | 1943-10-31 | 22.5 | 47 | 194 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 771 | 767 | 973 | 26 |
CHE | Switzerland | parliament | 1947-10-26 | 23.0 | 52 | 194 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 684 | 771 | 972 | 26 |
CHE | Switzerland | parliament | 1951-10-28 | 24.0 | 51 | 196 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 21 | 684 | 556 | 26 |
CHE | Switzerland | parliament | 1955-10-30 | 23.3 | 50 | 196 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 30 | 21 | 814 | 26 |
CHE | Switzerland | parliament | 1959-10-25 | 23.7 | 51 | 196 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 674 | 30 | 635 | 26 |
CHE | Switzerland | parliament | 1963-10-27 | 23.9 | 51 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 108 | 674 | 623 | 26 |
CHE | Switzerland | parliament | 1967-10-29 | 23.2 | 49 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 373 | 108 | 513 | 26 |
CHE | Switzerland | parliament | 1971-10-31 | 21.8 | 49 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 176 | 373 | 777 | 26 |
CHE | Switzerland | parliament | 1975-10-26 | 22.2 | 47 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 371 | 176 | 79 | 26 |
CHE | Switzerland | parliament | 1979-10-21 | 24.0 | 51 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 435 | 371 | 20 | 26 |
CHE | Switzerland | parliament | 1983-10-23 | 23.3 | 54 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 631 | 435 | 723 | 26 |
CHE | Switzerland | parliament | 1987-10-18 | 22.9 | 51 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 358 | 631 | 129 | 26 |
CHE | Switzerland | parliament | 1991-10-20 | 21.0 | 44 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 521 | 358 | 426 | 26 |
CHE | Switzerland | parliament | 1995-10-22 | 20.2 | 45 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 105 | 521 | 773 | 26 |
CHE | Switzerland | parliament | 1999-10-24 | 19.9 | 43 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 427 | 105 | 38 | 26 |
CHE | Switzerland | parliament | 2003-10-19 | 17.3 | 36 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 206 | 427 | 198 | 26 |
CHE | Switzerland | parliament | 2007-10-21 | 15.8 | 31 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 310 | 206 | 855 | 26 |
CHE | Switzerland | parliament | 2011-10-23 | 15.1 | 30 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 779 | 310 | 903 | 26 |
CHE | Switzerland | parliament | 2015-10-18 | 16.4 | 33 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 995 | 779 | 989 | 26 |
CHE | Switzerland | parliament | 2019-10-20 | 15.11 | 29 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 1083 | 995 | 1212 | 26 |
NOR | Norway | parliament | 1924-10-21 | 6.1 | 6 | 150 | NKP | Norges Kommunistiske Parti | Communist Party of Norway | 1.3 | 9 | 951 | 950 | 1233 | 27 |
NOR | Norway | parliament | 1927-10-17 | 4.01 | 3 | 150 | NKP | Norges Kommunistiske Parti | Communist Party of Norway | 1.3 | 9 | 867 | 951 | 1231 | 27 |
NOR | Norway | parliament | 1930-10-20 | 1.7 | 0 | 150 | NKP | Norges Kommunistiske Parti | Communist Party of Norway | 1.3 | 9 | 866 | 867 | 1229 | 27 |
NOR | Norway | parliament | 1933-10-16 | 1.82 | 0 | 150 | NKP | Norges Kommunistiske Parti | Communist Party of Norway | 1.3 | 9 | 865 | 866 | 1225 | 27 |
NOR | Norway | parliament | 1945-10-08 | 11.9 | 11 | 150 | NKP | Norges Kommunistiske Parti | Communist Party of Norway | 1.3 | 9 | 220 | 864 | 666 | 27 |
NOR | Norway | parliament | 1949-10-10 | 5.84 | 0 | 150 | NKP | Norges Kommunistiske Parti | Communist Party of Norway | 1.3 | 9 | 478 | 220 | 58 | 27 |
NOR | Norway | parliament | 1953-10-12 | 5.08 | 3 | 150 | NKP | Norges Kommunistiske Parti | Communist Party of Norway | 1.3 | 9 | 167 | 478 | 487 | 27 |
NOR | Norway | parliament | 1957-10-07 | 3.4 | 1 | 150 | NKP | Norges Kommunistiske Parti | Communist Party of Norway | 1.3 | 9 | 429 | 167 | 221 | 27 |
NOR | Norway | parliament | 1961-09-11 | 2.9 | 0 | 150 | NKP | Norges Kommunistiske Parti | Communist Party of Norway | 1.3 | 9 | 622 | 429 | 61 | 27 |
NOR | Norway | parliament | 1965-09-12 | 1.4 | 0 | 150 | NKP | Norges Kommunistiske Parti | Communist Party of Norway | 1.3 | 9 | 517 | 622 | 510 | 27 |
NOR | Norway | parliament | 1969-09-07 | 1.0 | 0 | 150 | NKP | Norges Kommunistiske Parti | Communist Party of Norway | 1.3 | 9 | 580 | 517 | 284 | 27 |
LTU | Lithuania | parliament | 1992-11-15 | 2.14 | 4 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 439 | 462 | 512 | 28 |
LTU | Lithuania | parliament | 1996-10-20 | 3.13 | 1 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 566 | 439 | 91 | 28 |
LTU | Lithuania | parliament | 2000-10-08 | 1.95 | 2 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 59 | 566 | 735 | 28 |
LTU | Lithuania | ep | 2004-06-13 | 5.71 | 0 | 13 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 539 | 59 | 1631 | 28 |
LTU | Lithuania | parliament | 2004-10-24 | 3.79 | 2 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 214 | 59 | 1634 | 28 |
LTU | Lithuania | parliament | 2008-10-12 | 4.79 | 3 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 646 | 214 | 579 | 28 |
LTU | Lithuania | ep | 2009-06-07 | 8.42 | 1 | 12 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 337 | 646 | 688 | 28 |
LTU | Lithuania | parliament | 2012-10-14 | 5.83 | 8 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 786 | 646 | 1026 | 28 |
LTU | Lithuania | ep | 2014-05-25 | 8.05 | 1 | 11 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 842 | 786 | 1042 | 28 |
LTU | Lithuania | parliament | 2016-10-09 | 5.72 | 8 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 1009 | 786 | 1633 | 28 |
LTU | Lithuania | ep | 2019-05-26 | 5.5 | 1 | 11 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 1064 | 1009 | 1614 | 28 |
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;