view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_name_english
This data as json, CSV (advanced)
election_date (date) >30 ✖
- 2014-05-25 239
- 2019-05-26 234
- 2009-06-07 217
- 2004-06-13 193
- 1999-06-13 148
- 1989-06-18 122
- 1994-06-12 109
- 1984-06-17 87
- 1979-06-10 85
- 1996-10-20 36
- 2014-05-24 36
- 2019-05-25 36
- 1992-06-06 30
- 2011-12-04 30
- 2022-11-01 30
- 2004-06-12 26
- 1991-10-20 25
- 2006-04-09 25
- 2019-05-23 25
- 2007-11-25 24
- 2009-06-04 24
- 2012-06-17 24
- 1993-06-06 23
- 1994-03-27 22
- 1995-10-01 22
- 1990-06-09 21
- 1991-10-27 21
- 1990-04-08 19
- 1996-11-03 19
- 2015-11-08 19
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ISR | Israel | parliament | 1981-06-30 | 0.88 | 0 | 120 | PAY | Poalei Agudat Yisrael | Agudat Israel Workers | 34 | 713 | 712 | 946 | 1832 | |
FIN | Finland | parliament | 1948-07-02 | 0.4 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 187 | 101 | 125 | 66 | |
FIN | Finland | parliament | 1951-07-03 | 0.3 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 575 | 187 | 639 | 66 | |
FIN | Finland | parliament | 1954-03-08 | 0.2 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 71 | 575 | 738 | 66 | |
FIN | Finland | parliament | 1958-07-07 | 0.3 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 616 | 71 | 791 | 66 | |
FIN | Finland | parliament | 1962-02-05 | 0.3 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 354 | 616 | 598 | 66 | |
FIN | Finland | parliament | 1966-03-21 | 0.3 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 460 | 354 | 139 | 66 | |
FIN | Finland | parliament | 1970-03-16 | 0.4 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 77 | 460 | 203 | 66 | |
FIN | Finland | parliament | 1972-01-03 | 0.3 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 636 | 77 | 391 | 66 | |
FIN | Finland | parliament | 1975-09-22 | 0.3 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 98 | 636 | 143 | 66 | |
FIN | Finland | parliament | 1979-03-19 | 0.3 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 84 | 98 | 492 | 66 | |
FIN | Finland | parliament | 1983-03-21 | 0.3 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 133 | 84 | 34 | 66 | |
FIN | Finland | parliament | 1987-03-16 | 0.3 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 527 | 133 | 650 | 66 | |
FIN | Finland | parliament | 1991-03-17 | 0.3 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 602 | 527 | 41 | 66 | |
FIN | Finland | parliament | 1995-03-19 | 0.4 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 24 | 602 | 206 | 66 | |
FIN | Finland | parliament | 1999-03-21 | 0.4 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 15 | 24 | 100 | 66 | |
FIN | Finland | parliament | 2003-03-16 | 0.4 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 253 | 15 | 663 | 66 | |
FIN | Finland | parliament | 2007-03-18 | 0.4 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 314 | 253 | 759 | 66 | |
FIN | Finland | parliament | 2011-04-17 | 0.2 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 700 | 314 | 383 | 66 | |
FIN | Finland | parliament | 2019-04-14 | 0.38 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 1045 | 855 | 1510 | 66 | |
ISR | Israel | parliament | 1949-01-25 | 35.7 | 46 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 704 | 244 | ||
ISR | Israel | parliament | 1951-07-30 | 37.3 | 45 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 705 | 704 | 1137 | 244 |
ISR | Israel | parliament | 1955-07-26 | 32.2 | 40 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 706 | 705 | 928 | 244 |
ISR | Israel | parliament | 1959-11-03 | 38.2 | 47 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 707 | 706 | 1083 | 244 |
ISR | Israel | parliament | 1961-08-15 | 34.7 | 42 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 708 | 707 | 1136 | 244 |
ISR | Israel | parliament | 1965-11-01 | 36.7 | 45 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 709 | 708 | 935 | 244 |
ISR | Israel | parliament | 1969-10-28 | 46.2 | 56 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 710 | 709 | 938 | 244 |
ISR | Israel | parliament | 1973-12-31 | 39.6 | 51 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 711 | 710 | 940 | 244 |
ISR | Israel | parliament | 1977-05-17 | 24.6 | 32 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 712 | 711 | 944 | 244 |
ISR | Israel | parliament | 1981-06-30 | 36.6 | 47 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 713 | 712 | 946 | 244 |
ISR | Israel | parliament | 1984-07-23 | 34.9 | 44 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 714 | 713 | 1114 | 244 |
ISR | Israel | parliament | 1988-11-01 | 30.0 | 39 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 715 | 714 | 1108 | 244 |
ISR | Israel | parliament | 1992-06-23 | 34.7 | 44 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 716 | 715 | 957 | 244 |
ISR | Israel | parliament | 1996-05-29 | 26.8 | 34 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 717 | 716 | 960 | 244 |
ISR | Israel | parliament | 1999-05-17 | 20.2 | 26 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 718 | 717 | 1159 | 244 |
ISR | Israel | parliament | 2003-01-28 | 14.46 | 19 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 719 | 718 | 1124 | 244 |
ISR | Israel | parliament | 2006-03-28 | 15.1 | 19 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 720 | 719 | 1129 | 244 |
ISR | Israel | parliament | 2009-02-10 | 9.9 | 13 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 721 | 720 | 1135 | 244 |
ISR | Israel | parliament | 2013-01-22 | 11.39 | 15 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 815 | 721 | 1107 | 244 |
ISR | Israel | parliament | 2015-03-17 | 18.67 | 24 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 852 | 815 | 1155 | 244 |
ISR | Israel | parliament | 2019-04-09 | 4.43 | 6 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 1047 | 852 | 1589 | 244 |
ISR | Israel | parliament | 2019-09-17 | 4.8 | 6 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 1079 | 1047 | 1602 | 244 |
ISR | Israel | parliament | 2020-03-02 | 5.83 | 7 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 1090 | 1079 | 1613 | 244 |
ISR | Israel | parliament | 2021-03-23 | 6.09 | 7 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 1100 | 1090 | 1645 | 244 |
ISR | Israel | parliament | 2022-11-01 | 3.69 | 4 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 1117 | 1100 | 1677 | 244 |
BEL | Belgium | parliament | 1999-06-13 | 2.1 | 0 | 150 | V | Vivant | Alive | 6.0 | 64 | 2 | 332 | 95 | 620 |
BEL | Belgium | ep | 1999-06-13 | 1.99 | 0 | 25 | V | Vivant | Alive | 6.0 | 64 | 624 | 332 | 95 | 620 |
LVA | Latvia | parliament | 2006-10-07 | 1.48 | 0 | 100 | VL | Visu Latvijai! | All For Latvia! | 7.4 | 55 | 52 | 260 | 535 | 801 |
LVA | Latvia | ep | 2009-06-07 | 2.81 | 0 | 8 | VL | Visu Latvijai! | All For Latvia! | 7.4 | 55 | 302 | 52 | 477 | 801 |
ISR | Israel | parliament | 2015-03-17 | 7.49 | 10 | 120 | Kulanu | Kulanu | All of Us | 6.0 | 34 | 852 | 815 | 1155 | 2410 |
ISR | Israel | parliament | 2019-04-09 | 3.54 | 4 | 120 | Kulanu | Kulanu | All of Us | 6.0 | 34 | 1047 | 852 | 1589 | 2410 |
DEU | Germany | parliament | 1953-09-06 | 5.9 | 27 | 487 | GB/BHE | Gesamtdeutscher Block / Bund der Heimatvertriebenen und Entrechteten | All-German Bloc / League of Expellees and Deprived of Rights | 8.8 | 54 | 103 | 581 | 147 | 1507 |
DEU | Germany | parliament | 1957-09-15 | 4.6 | 0 | 497 | GB/BHE | Gesamtdeutscher Block / Bund der Heimatvertriebenen und Entrechteten | All-German Bloc / League of Expellees and Deprived of Rights | 8.8 | 54 | 331 | 103 | 633 | 1507 |
DEU | Germany | parliament | 1961-09-17 | 2.8 | 0 | 499 | GDP | Gesamtdeutsche Partei | All-German Party | 7.4 | 54 | 381 | 331 | 906 | 1701 |
DEU | Germany | parliament | 1953-09-06 | 1.2 | 0 | 487 | GVP | Gesamtdeutsche Volkspartei | All-German People's Party | 6.2 | 54 | 103 | 581 | 147 | 238 |
NZL | New Zealand | parliament | 1993-11-06 | 18.21 | 2 | 99 | A | Alliance | Alliance | 2.0757 | 11 | 634 | 350 | 473 | 1444 |
NZL | New Zealand | parliament | 1996-10-12 | 10.1 | 13 | 120 | A | Alliance | Alliance | 2.0757 | 11 | 561 | 634 | 830 | 1444 |
NZL | New Zealand | parliament | 1999-11-27 | 7.74 | 10 | 120 | A | Alliance | Alliance | 2.0757 | 11 | 451 | 561 | 388 | 1444 |
NZL | New Zealand | parliament | 2002-07-27 | 1.27 | 0 | 120 | A | Alliance | Alliance | 2.0757 | 11 | 572 | 451 | 212 | 1444 |
PRT | Portugal | ep | 2019-05-26 | 2.0 | 0 | 21 | A | Aliança | Alliance | 6.0 | 63 | 1068 | 993 | 1198 | 2756 |
PRT | Portugal | parliament | 2019-10-06 | 0.81 | 0 | 230 | A | Aliança | Alliance | 6.0 | 63 | 1081 | 993 | 1198 | 2756 |
DEU | Germany | ep | 1979-06-10 | 3.2 | 0 | 81 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 361 | 163 | 459 | 772 |
DEU | Germany | parliament | 1980-10-05 | 1.5 | 0 | 497 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 547 | 163 | 459 | 772 |
DEU | Germany | parliament | 1983-03-06 | 5.6 | 27 | 498 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 484 | 547 | 642 | 772 |
DEU | Germany | ep | 1984-06-17 | 8.2 | 7 | 81 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 610 | 484 | 346 | 772 |
DEU | Germany | parliament | 1987-01-25 | 8.3 | 42 | 497 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 588 | 484 | 346 | 772 |
DEU | Germany | ep | 1989-06-18 | 8.4 | 8 | 81 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 296 | 588 | 286 | 772 |
DEU | Germany | parliament | 1990-12-02 | 3.8 | 0 | 662 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 445 | 588 | 286 | 772 |
DEU | Germany | ep | 1994-06-12 | 10.1 | 12 | 99 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 540 | 445 | 862 | 772 |
DEU | Germany | parliament | 1994-10-16 | 7.3 | 49 | 672 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 595 | 445 | 862 | 772 |
DEU | Germany | parliament | 1998-09-27 | 6.7 | 47 | 669 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 679 | 595 | 778 | 772 |
DEU | Germany | ep | 1999-06-13 | 6.4 | 7 | 99 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 417 | 679 | 107 | 772 |
DEU | Germany | parliament | 2002-09-22 | 8.6 | 55 | 603 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 385 | 679 | 107 | 772 |
DEU | Germany | ep | 2004-06-13 | 11.9 | 13 | 99 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 18 | 385 | 529 | 772 |
DEU | Germany | parliament | 2005-09-18 | 8.1 | 51 | 614 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 118 | 385 | 529 | 772 |
DEU | Germany | ep | 2009-06-07 | 12.1 | 14 | 99 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 231 | 118 | 85 | 772 |
DEU | Germany | parliament | 2009-09-27 | 10.7 | 68 | 622 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 93 | 118 | 85 | 772 |
DEU | Germany | parliament | 2013-09-22 | 8.4 | 63 | 631 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 800 | 93 | 472 | 772 |
DEU | Germany | ep | 2014-05-25 | 10.7 | 11 | 96 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 825 | 800 | 1071 | 772 |
DEU | Germany | parliament | 2017-09-24 | 8.9 | 67 | 709 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 1016 | 800 | 1071 | 772 |
DEU | Germany | ep | 2019-05-26 | 20.5 | 21 | 96 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 1055 | 1016 | 1528 | 772 |
DEU | Germany | parliament | 2021-09-26 | 14.75 | 118 | 736 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 1096 | 1016 | 1528 | 772 |
DEU | Germany | parliament | 1990-12-02 | 1.2 | 8 | 662 | B90/Gr | Bündnis 90 / Grüne – BürgerInnenbewegung | Alliance 90 / Greens -- Citizens' Movement | 2.5 | 54 | 445 | 588 | 286 | 255 |
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 | parliament | 2019-12-12 | 0.42 | 1 | 650 | APoNI | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | 6.0 | 44 | 1086 | 1013 | 1599 | 2731 |
ROU | Romania | parliament | 2000-11-26 | 4.07 | 0 | 345 | ApR | Alianta pentru Romania | Alliance for Romania | 3.3 | 23 | 336 | 49 | 171 | 2040 |
AUT | Austria | parliament | 2006-10-01 | 4.1 | 7 | 183 | BZO | Bündnis Zukunft Österreich | Alliance for the Future of Austria | 8.83 | 59 | 197 | 365 | 888 | 1536 |
AUT | Austria | parliament | 2008-09-28 | 10.7 | 21 | 183 | BZO | Bündnis Zukunft Österreich | Alliance for the Future of Austria | 8.83 | 59 | 607 | 197 | 583 | 1536 |
AUT | Austria | ep | 2009-06-07 | 4.6 | 0 | 17 | BZO | Bündnis Zukunft Österreich | Alliance for the Future of Austria | 8.83 | 59 | 232 | 607 | 268 | 1536 |
AUT | Austria | parliament | 2013-09-29 | 3.5 | 0 | 183 | BZO | Bündnis Zukunft Österreich | Alliance for the Future of Austria | 8.83 | 59 | 802 | 607 | 268 | 1536 |
ROU | Romania | parliament | 2020-12-06 | 9.08 | 33 | 330 | AUR | Alianța pentru Unirea Românilor | Alliance for the Unity of Romanians | 8.8 | 23 | 1093 | 1015 | 1626 | 2807 |
SVN | Slovenia | parliament | 2014-07-13 | 4.38 | 4 | 90 | ZaAB | Zavezništvo Alenke Bratušek | Alliance of Alenka Bratusek | 3.3 | 60 | 817 | 778 | 1047 | 2337 |
SVN | Slovenia | parliament | 2018-06-03 | 5.11 | 5 | 90 | ZaAB | Zavezništvo Alenke Bratušek | Alliance of Alenka Bratusek | 3.3 | 60 | 1025 | 817 | 1144 | 2337 |
SVN | Slovenia | ep | 2019-05-26 | 4.02 | 0 | 8 | ZaAB | Zavezništvo Alenke Bratušek | Alliance of Alenka Bratusek | 3.3 | 60 | 1071 | 1025 | 1555 | 2337 |
SVN | Slovenia | parliament | 2022-04-22 | 2.61 | 0 | 90 | ZaAB | Zavezništvo Alenke Bratušek | Alliance of Alenka Bratusek | 3.3 | 60 | 1108 | 1025 | 1668 | 2337 |
SVK | Slovakia | parliament | 1990-06-09 | 2.52 | 0 | 150 | SPV | Spojenestvo poľnohospodárov a vidieka | Alliance of Farmers and the Countryside | 5.3 | 1 | 538 | 2233 | ||
HUN | Hungary | parliament | 1990-04-08 | 21.4 | 93 | 386 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 257 | 1426 | ||
HUN | Hungary | parliament | 1994-05-29 | 19.7 | 69 | 386 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 620 | 257 | 13 | 1426 |
HUN | Hungary | parliament | 1998-05-24 | 7.6 | 24 | 386 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 671 | 620 | 488 | 1426 |
HUN | Hungary | parliament | 2002-04-21 | 5.57 | 20 | 386 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 463 | 671 | 827 | 1426 |
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;