view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CYP | Cyprus | parliament | 2021-05-30 | 1.56 | 56 | AK | Ammókhostos yia tin Kípro | Famagusta for Cyprus | 6.0 | 51 | 1095 | 1004 | 1628 | 2818 | |
GRC | Greece | ep | 2019-05-26 | 1.24 | 0 | 21 | E-OAD | Ellada – O Allos Dromos | Greece, the Other Way | 7.4 | 41 | 1060 | 992 | 1593 | 2744 |
MLT | Malta | ep | 2009-06-06 | 1.47 | 0 | 5 | IE | Imperu Ewropew | Imperium Europa | 8.8 | 72 | 555 | 203 | 468 | 1400 |
MLT | Malta | ep | 2014-05-25 | 2.68 | 0 | 6 | IE | Imperu Ewropew | Imperium Europa | 8.8 | 72 | 836 | 790 | 1046 | 1400 |
MLT | Malta | ep | 2019-05-25 | 3.17 | 0 | 6 | IE | Imperu Ewropew | Imperium Europa | 8.8 | 72 | 1066 | 1010 | 1504 | 1400 |
LVA | Latvia | ep | 2014-05-24 | 2.12 | 0 | 8 | LA | Latvijas attīstībai | For Latvia's Development | 6.0 | 55 | 848 | 765 | 1073 | 2392 |
LVA | Latvia | ep | 2019-05-25 | 12.42 | 1 | 8 | LA | Latvijas attīstībai | For Latvia's Development | 6.0 | 55 | 1063 | 1042 | 1592 | 2392 |
PRT | Portugal | ep | 2019-05-26 | 1.1 | 0 | 21 | NC | Nós, Cidadãos! | We, the Citizens! | 6.0 | 63 | 1068 | 993 | 1198 | 2758 |
SVN | Slovenia | ep | 2014-05-25 | 2.56 | 0 | 8 | PSS | Piratska stranka Slovenije | Slovenian Pirate Party | 60 | 844 | 778 | 1047 | 2338 | |
SVN | Slovenia | parliament | 2014-07-13 | 1.34 | 0 | 90 | PSS | Piratska stranka Slovenije | Slovenian Pirate Party | 60 | 817 | 778 | 1047 | 2338 | |
SVN | Slovenia | parliament | 2018-06-03 | 2.15 | 0 | 90 | PSS | Piratska stranka Slovenije | Slovenian Pirate Party | 60 | 1025 | 817 | 1144 | 2338 | |
SVN | Slovenia | parliament | 2022-04-22 | 1.63 | 0 | 90 | PSS | Piratska stranka Slovenije | Slovenian Pirate Party | 60 | 1108 | 1025 | 1668 | 2338 | |
CYP | Cyprus | parliament | 2021-05-30 | 1.28 | 56 | PL | Pní Laoú | People's Breath | 8.8 | 51 | 1095 | 1004 | 1628 | 2820 | |
ITA | Italy | parliament | 2018-03-04 | 2.76 | 2 | 630 | +EU | +Europa | More Europe | 6.0 | 26 | 1024 | 789 | 1501 | 2737 |
ITA | Italy | ep | 2019-05-26 | 3.11 | 0 | 73 | +EU | +Europa | More Europe | 6.0 | 26 | 1053 | 1024 | 1532 | 2737 |
ITA | Italy | parliament | 2022-09-25 | 2.83 | 3 | 400 | +EU | +Europa | More Europe | 6.0 | 26 | 1113 | 1024 | 1681 | 2737 |
NLD | Netherlands | parliament | 2012-09-12 | 1.88 | 2 | 150 | 50+ | 50PLUS | 50PLUS | 8 | 785 | 530 | 1028 | 2109 | |
NLD | Netherlands | ep | 2014-05-25 | 3.69 | 0 | 26 | 50+ | 50PLUS | 50PLUS | 8 | 846 | 785 | 1041 | 2109 | |
NLD | Netherlands | parliament | 2017-03-15 | 3.1 | 4 | 150 | 50+ | 50PLUS | 50PLUS | 8 | 1012 | 785 | 1041 | 2109 | |
NLD | Netherlands | ep | 2019-05-23 | 3.91 | 1 | 26 | 50+ | 50PLUS | 50PLUS | 8 | 1052 | 1012 | 1530 | 2109 | |
NLD | Netherlands | parliament | 2021-03-17 | 1.02 | 1 | 150 | 50+ | 50PLUS | 50PLUS | 8 | 1097 | 1012 | 1648 | 2109 | |
SVK | Slovakia | parliament | 2012-03-10 | 1.58 | 0 | 150 | 99% | 99% – občiansky hlas | 99 Percent -- Civic Voice | 1.3 | 1 | 781 | 524 | 982 | 2015 |
NZL | New Zealand | parliament | 1996-10-12 | 6.1 | 8 | 120 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 561 | 634 | 830 | 617 |
NZL | New Zealand | parliament | 1999-11-27 | 7.04 | 9 | 120 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 451 | 561 | 388 | 617 |
NZL | New Zealand | parliament | 2002-07-27 | 7.14 | 9 | 120 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 572 | 451 | 212 | 617 |
NZL | New Zealand | parliament | 2005-09-17 | 1.51 | 2 | 121 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 675 | 572 | 845 | 617 |
NZL | New Zealand | parliament | 2008-11-08 | 3.65 | 5 | 122 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 660 | 675 | 427 | 617 |
NZL | New Zealand | parliament | 2011-11-26 | 1.07 | 1 | 121 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 776 | 660 | 251 | 617 |
NZL | New Zealand | parliament | 2014-09-20 | 0.69 | 1 | 121 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 829 | 776 | 986 | 617 |
NZL | New Zealand | parliament | 2017-09-23 | 0.5 | 1 | 120 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 1018 | 829 | 1499 | 617 |
NZL | New Zealand | parliament | 2020-10-17 | 7.59 | 10 | 120 | ACT | ACT New Zealand | ACT New Zealand | 9.0263 | 11 | 1092 | 1018 | 1518 | 617 |
CZE | Czech Republic | ep | 2019-05-25 | 1.56 | 0 | 21 | ANO-VE | ANO, vytrollíme europarlament | Yes, We Will Troll the Euro-Parliament | 68 | 1057 | 1020 | 1534 | 2779 | |
FRA | France | parliament | 1910-05-08 | 1.81 | 0 | 580 | ALP | Action libérale populaire | Liberal People's Action | 6.2 | 43 | 988 | 986 | 1391 | 2593 |
TUR | Turkey | parliament | 2002-11-03 | 34.28 | 363 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 808 | 809 | 1101 | 901 |
TUR | Turkey | parliament | 2007-07-22 | 46.66 | 341 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 807 | 808 | 1077 | 901 |
TUR | Turkey | parliament | 2011-06-12 | 49.83 | 327 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 806 | 807 | 1076 | 901 |
TUR | Turkey | parliament | 2015-06-07 | 40.87 | 258 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 975 | 806 | 1143 | 901 |
TUR | Turkey | parliament | 2015-11-01 | 49.5 | 317 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 997 | 975 | 1173 | 901 |
TUR | Turkey | parliament | 2018-06-24 | 42.62 | 295 | 600 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 1032 | 997 | 1487 | 901 |
CYP | Cyprus | parliament | 2021-05-30 | 1.35 | 0 | 56 | AM | Afypnisis 2020 | Awakening 2020 | 51 | 1095 | 1004 | 1628 | 2819 | |
BEL | Belgium | ep | 1979-06-10 | 1.43 | 0 | 24 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 442 | 663 | 521 | 1594 |
BEL | Belgium | parliament | 1981-11-08 | 2.3 | 2 | 212 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 501 | 663 | 429 | 1594 |
BEL | Belgium | ep | 1984-06-17 | 4.31 | 1 | 24 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 10 | 501 | 724 | 1594 |
BEL | Belgium | parliament | 1985-10-13 | 3.74 | 4 | 212 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 396 | 501 | 724 | 1594 |
BEL | Belgium | parliament | 1987-12-13 | 4.49 | 6 | 212 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 191 | 396 | 92 | 1594 |
BEL | Belgium | ep | 1989-06-18 | 7.57 | 1 | 24 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 553 | 191 | 457 | 1594 |
BEL | Belgium | parliament | 1991-11-24 | 4.9 | 7 | 212 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 418 | 191 | 457 | 1594 |
BEL | Belgium | ep | 1994-06-12 | 6.64 | 1 | 25 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 536 | 418 | 624 | 1594 |
BEL | Belgium | parliament | 1995-05-21 | 4.43 | 5 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 332 | 418 | 624 | 1594 |
BEL | Belgium | parliament | 1999-06-13 | 6.99 | 9 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 2 | 332 | 95 | 1594 |
BEL | Belgium | ep | 1999-06-13 | 7.46 | 2 | 25 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 624 | 332 | 95 | 1594 |
BEL | Belgium | parliament | 2003-05-18 | 2.47 | 0 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 143 | 2 | 193 | 1594 |
BEL | Belgium | ep | 2004-06-13 | 4.94 | 1 | 24 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 656 | 143 | 449 | 1594 |
BEL | Belgium | parliament | 2007-06-10 | 3.98 | 4 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 401 | 143 | 449 | 1594 |
BEL | Belgium | ep | 2009-06-07 | 4.9 | 1 | 22 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 638 | 401 | 80 | 1594 |
BEL | Belgium | parliament | 2010-06-13 | 4.38 | 5 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 486 | 401 | 431 | 1594 |
BEL | Belgium | parliament | 2014-05-25 | 5.32 | 6 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 816 | 486 | 987 | 1594 |
BEL | Belgium | ep | 2014-05-25 | 6.69 | 1 | 21 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 832 | 486 | 987 | 1594 |
BEL | Belgium | parliament | 2019-05-26 | 6.1 | 8 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 1048 | 816 | 1586 | 1594 |
BEL | Belgium | ep | 2019-05-26 | 7.81 | 1 | 21 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 1058 | 816 | 1586 | 1594 |
CYP | Cyprus | parliament | 2001-05-27 | 2.2 | 1 | 56 | ADK | Agonistiko Dimokratiko Kinima | Fighting Democratic Movement | 7.7632 | 51 | 339 | 330 | 731 | 1049 |
ESP | Spain | parliament | 1986-06-22 | 0.33 | 1 | 350 | AIC | Agrupacion Independientes de Canarias | Canary Islands Group | 27 | 254 | 85 | 238 | 411 | |
ESP | Spain | parliament | 1989-10-29 | 0.32 | 1 | 350 | AIC | Agrupacion Independientes de Canarias | Canary Islands Group | 27 | 289 | 254 | 834 | 411 | |
ESP | Spain | ep | 1989-06-18 | 3.89 | 2 | 60 | ARM | Agrupación Ruiz-Mateos | Ruiz-Mateos List | 27 | 474 | 254 | 834 | 73 | |
ESP | Spain | parliament | 1989-10-29 | 1.08 | 0 | 350 | ARM | Agrupación Ruiz-Mateos | Ruiz-Mateos List | 27 | 289 | 254 | 834 | 73 | |
HUN | Hungary | parliament | 1990-04-08 | 3.1 | 2 | 386 | ASZ | Agrárszövetség | Agrarian Alliance | 5.3 | 39 | 257 | 1183 | ||
HUN | Hungary | parliament | 1994-05-29 | 2.1 | 1 | 386 | ASZ | Agrárszövetség | Agrarian Alliance | 5.3 | 39 | 620 | 257 | 13 | 1183 |
ISR | Israel | parliament | 1951-07-30 | 2.0 | 3 | 120 | AY | Agudat Yisrael | Union of Israel | 34 | 705 | 704 | 1137 | 265 | |
ISR | Israel | parliament | 1961-08-15 | 3.7 | 4 | 120 | AY | Agudat Yisrael | Union of Israel | 34 | 708 | 707 | 1136 | 265 | |
ISR | Israel | parliament | 1965-11-01 | 3.3 | 4 | 120 | AY | Agudat Yisrael | Union of Israel | 34 | 709 | 708 | 935 | 265 | |
ISR | Israel | parliament | 1969-10-28 | 3.2 | 4 | 120 | AY | Agudat Yisrael | Union of Israel | 34 | 710 | 709 | 938 | 265 | |
ISR | Israel | parliament | 1977-05-17 | 3.3 | 4 | 120 | AY | Agudat Yisrael | Union of Israel | 34 | 712 | 711 | 944 | 265 | |
ISR | Israel | parliament | 1981-06-30 | 3.7 | 4 | 120 | AY | Agudat Yisrael | Union of Israel | 34 | 713 | 712 | 946 | 265 | |
ISR | Israel | parliament | 1984-07-23 | 1.7 | 2 | 120 | AY | Agudat Yisrael | Union of Israel | 34 | 714 | 713 | 1114 | 265 | |
ISR | Israel | parliament | 1988-11-01 | 4.5 | 5 | 120 | AY | Agudat Yisrael | Union of Israel | 34 | 715 | 714 | 1108 | 265 | |
ISR | Israel | parliament | 1955-07-26 | 8.2 | 10 | 120 | AhAv | Ahdut HaAvoda | Labour Unity | 3.3 | 34 | 706 | 705 | 928 | 1343 |
ISR | Israel | parliament | 1959-11-03 | 6.0 | 7 | 120 | AhAv | Ahdut HaAvoda | Labour Unity | 3.3 | 34 | 707 | 706 | 1083 | 1343 |
ISR | Israel | parliament | 1961-08-15 | 7.5 | 9 | 120 | AhAv | Ahdut HaAvoda | Labour Unity | 3.3 | 34 | 708 | 707 | 1136 | 1343 |
CZE | Czech Republic | parliament | 2013-10-25 | 18.65 | 47 | 200 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 805 | 599 | 1062 | 2263 |
CZE | Czech Republic | ep | 2014-05-24 | 16.13 | 4 | 21 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 820 | 805 | 1072 | 2263 |
CZE | Czech Republic | parliament | 2017-10-21 | 29.64 | 78 | 200 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 1020 | 805 | 1072 | 2263 |
CZE | Czech Republic | ep | 2019-05-25 | 21.18 | 6 | 21 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 1057 | 1020 | 1534 | 2263 |
CZE | Czech Republic | parliament | 2021-10-09 | 27.13 | 72 | 200 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 1099 | 1020 | 1534 | 2263 |
HRV | Croatia | ep | 2013-04-14 | 1.49 | 0 | 12 | AM | Akcija mladih | Youth Action | 2.5 | 62 | 791 | 792 | 1056 | 2186 |
POL | Poland | parliament | 1997-09-21 | 33.83 | 201 | 460 | AWS | Akcja Wyborcza Solidarność Prawicy | Solidarity Electoral Action | 7.1286 | 74 | 477 | 268 | 437 | 1355 |
POL | Poland | parliament | 2001-09-23 | 5.6 | 0 | 460 | AWS | Akcja Wyborcza Solidarność Prawicy | Solidarity Electoral Action | 7.1286 | 74 | 565 | 477 | 194 | 1355 |
LUX | Luxembourg | parliament | 1989-06-18 | 7.29 | 4 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 526 | 183 | 175 | 1582 |
LUX | Luxembourg | parliament | 1994-06-12 | 8.16 | 5 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 306 | 526 | 418 | 1582 |
LUX | Luxembourg | ep | 1994-06-12 | 6.94 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 594 | 526 | 418 | 1582 |
LUX | Luxembourg | parliament | 1999-06-13 | 10.36 | 7 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 299 | 306 | 621 | 1582 |
LUX | Luxembourg | ep | 1999-06-13 | 8.99 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 505 | 306 | 621 | 1582 |
LUX | Luxembourg | parliament | 2004-06-13 | 9.04 | 5 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 383 | 299 | 196 | 1582 |
LUX | Luxembourg | ep | 2004-06-13 | 8.03 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 593 | 299 | 196 | 1582 |
LUX | Luxembourg | parliament | 2009-06-07 | 8.13 | 4 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 172 | 383 | 12 | 1582 |
LUX | Luxembourg | ep | 2009-06-07 | 7.38 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 662 | 383 | 12 | 1582 |
LUX | Luxembourg | parliament | 2013-10-20 | 6.64 | 3 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 803 | 172 | 1063 | 1582 |
LUX | Luxembourg | ep | 2014-05-25 | 7.53 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 835 | 803 | 1069 | 1582 |
LUX | Luxembourg | parliament | 2018-10-14 | 8.02 | 4 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 1043 | 803 | 1069 | 1582 |
LUX | Luxembourg | ep | 2019-05-26 | 10.04 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 1065 | 1043 | 1588 | 1582 |
SVN | Slovenia | parliament | 2004-10-03 | 3.97 | 0 | 90 | AS | Aktivna Slovenija | Active Slovenia | 4.6 | 60 | 80 | 525 | 292 | 380 |
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;