view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_name descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HRV | Croatia | parliament | 2015-11-08 | 4.19 | 1 | 151 | ZiZi | Živi zid | Human Shield | 8.8 | 62 | 1001 | 792 | 1056 | 2612 |
HRV | Croatia | parliament | 2016-09-11 | 5.92 | 8 | 151 | ZiZi | Živi zid | Human Shield | 8.8 | 62 | 1007 | 1001 | 1408 | 2612 |
HRV | Croatia | ep | 2019-05-26 | 5.66 | 1 | 11 | ZiZi | Živi zid | Human Shield | 8.8 | 62 | 1062 | 1007 | 1512 | 2612 |
HRV | Croatia | parliament | 2020-07-05 | 2.26 | 0 | 151 | ZiZi | Živi zid | Human Shield | 8.8 | 62 | 1094 | 1007 | 1512 | 2612 |
LTU | Lithuania | ep | 2009-06-07 | 1.27 | 0 | 12 | Zp | Žemaičių partija | Samogitian Party | 15 | 337 | 646 | 688 | 2025 | |
SVK | Slovakia | parliament | 2010-06-12 | 1.33 | 0 | 150 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 524 | 192 | 269 | 586 |
SVK | Slovakia | parliament | 2012-03-10 | 1.58 | 0 | 150 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 781 | 524 | 982 | 586 |
SVK | Slovakia | ep | 2014-05-25 | 1.74 | 0 | 13 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 847 | 781 | 1027 | 586 |
SVK | Slovakia | parliament | 2016-03-06 | 8.04 | 14 | 150 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 1003 | 781 | 1027 | 586 |
SVK | Slovakia | ep | 2019-05-25 | 12.07 | 2 | 13 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 1070 | 1003 | 1529 | 586 |
SVK | Slovakia | parliament | 2020-02-29 | 7.97 | 17 | 150 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 1089 | 1003 | 1529 | 586 |
TUR | Turkey | parliament | 2018-06-24 | 9.97 | 43 | 600 | IYI | İyi Parti | Iyi Party | 8.8 | 20 | 1032 | 997 | 1487 | 2702 |
CZE | Czech Republic | parliament | 1990-06-09 | 4.11 | 0 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 63 | 789 | ||
CZE | Czech Republic | parliament | 1992-06-06 | 6.53 | 16 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 39 | 63 | 262 | 789 |
CZE | Czech Republic | parliament | 1996-06-01 | 26.44 | 61 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 301 | 39 | 835 | 789 |
CZE | Czech Republic | parliament | 1998-06-20 | 32.31 | 74 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 27 | 301 | 76 | 789 |
CZE | Czech Republic | parliament | 2002-06-15 | 30.2 | 70 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 487 | 27 | 443 | 789 |
CZE | Czech Republic | ep | 2004-06-12 | 8.78 | 2 | 24 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 567 | 487 | 504 | 789 |
CZE | Czech Republic | parliament | 2006-06-03 | 32.32 | 74 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 50 | 487 | 15 | 789 |
CZE | Czech Republic | ep | 2009-06-07 | 22.38 | 7 | 22 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 516 | 50 | 157 | 789 |
CZE | Czech Republic | parliament | 2010-05-29 | 22.08 | 56 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 599 | 50 | 157 | 789 |
CZE | Czech Republic | parliament | 2013-10-25 | 20.45 | 50 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 805 | 599 | 1062 | 789 |
CZE | Czech Republic | ep | 2014-05-24 | 14.17 | 4 | 21 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 820 | 805 | 1072 | 789 |
CZE | Czech Republic | parliament | 2017-10-21 | 7.27 | 15 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 1020 | 805 | 1072 | 789 |
CZE | Czech Republic | ep | 2019-05-25 | 3.95 | 0 | 21 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 1057 | 1020 | 1534 | 789 |
CZE | Czech Republic | parliament | 2021-10-09 | 4.66 | 0 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 1099 | 1020 | 1534 | 789 |
CZE | Czech Republic | parliament | 1990-06-09 | 2.68 | 0 | 200 | CNSP | Česká národně strana socialistická | Czech National Social(ist) Party | 8.8 | 68 | 63 | 29 | ||
CZE | Czech Republic | parliament | 1996-06-01 | 2.05 | 0 | 200 | CNSP | Česká národně strana socialistická | Czech National Social(ist) Party | 8.8 | 68 | 301 | 39 | 835 | 29 |
ISL | Iceland | parliament | 1942-07-05 | 1.1 | 0 | 49 | Thve | Þjóðveldisflokkurinn | Common Wealth Party | 7.4 | 56 | 929 | 928 | 1434 | 2004 |
ISL | Iceland | parliament | 1942-10-19 | 2.15 | 0 | 52 | Thve | Þjóðveldisflokkurinn | Common Wealth Party | 7.4 | 56 | 780 | 929 | 1434 | 2004 |
ISL | Iceland | parliament | 1953-06-28 | 6.0 | 2 | 52 | Thva | Þjóðvarnarflokkurinn | National Preservation Party | 6.0 | 56 | 88 | 259 | 766 | 1172 |
ISL | Iceland | parliament | 1956-06-24 | 4.5 | 0 | 52 | Thva | Þjóðvarnarflokkurinn | National Preservation Party | 6.0 | 56 | 665 | 88 | 762 | 1172 |
ISL | Iceland | parliament | 1959-06-28 | 2.5 | 0 | 52 | Thva | Þjóðvarnarflokkurinn | National Preservation Party | 6.0 | 56 | 393 | 665 | 446 | 1172 |
ISL | Iceland | parliament | 1959-10-26 | 3.4 | 0 | 60 | Thva | Þjóðvarnarflokkurinn | National Preservation Party | 6.0 | 56 | 320 | 393 | 351 | 1172 |
ISL | Iceland | parliament | 1967-06-11 | 3.7 | 1 | 60 | Thva | Þjóðvarnarflokkurinn | National Preservation Party | 6.0 | 56 | 318 | 379 | 553 | 1172 |
ISL | Iceland | parliament | 1995-04-08 | 7.2 | 4 | 63 | Th-Ff | Þjóðvaki – Fylking fólksins | People's Movement | 3.3 | 56 | 82 | 274 | 640 | 205 |
ISL | Iceland | parliament | 1987-04-25 | 1.3 | 0 | 63 | Thod | Þjóðarflokkurinn | National Party | 5.3 | 56 | 673 | 114 | 393 | 2116 |
ISL | Iceland | parliament | 1991-04-20 | 1.8 | 0 | 63 | Thod | Þjóðarflokkurinn | National Party | 5.3 | 56 | 274 | 673 | 127 | 2116 |
CZE | Czech Republic | parliament | 2013-10-25 | 6.88 | 14 | 200 | UPD | Úsvit přímé demokracie | Dawn of Direct Democracy | 7.4 | 68 | 805 | 599 | 1062 | 2262 |
CZE | Czech Republic | ep | 2014-05-24 | 3.12 | 0 | 21 | UPD | Úsvit přímé demokracie | Dawn of Direct Democracy | 7.4 | 68 | 820 | 805 | 1072 | 2262 |
AUT | Austria | parliament | 1919-02-16 | 35.93 | 69 | 170 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1030 | 1013 | ||
AUT | Austria | parliament | 1920-10-17 | 41.79 | 85 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1026 | 1030 | 1537 | 1013 |
AUT | Austria | parliament | 1923-10-21 | 44.05 | 82 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1027 | 1026 | 1542 | 1013 |
AUT | Austria | parliament | 1927-04-24 | 48.24 | 73 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1028 | 1027 | 1546 | 1013 |
AUT | Austria | parliament | 1930-11-09 | 35.65 | 66 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1029 | 1028 | 1550 | 1013 |
AUT | Austria | parliament | 1945-11-25 | 49.8 | 85 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 402 | 1029 | 452 | 1013 |
AUT | Austria | parliament | 1949-10-09 | 44.0 | 77 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 67 | 402 | 884 | 1013 |
AUT | Austria | parliament | 1953-02-22 | 41.3 | 74 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 11 | 67 | 560 | 1013 |
AUT | Austria | parliament | 1956-05-13 | 46.0 | 82 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 169 | 11 | 659 | 1013 |
AUT | Austria | parliament | 1959-05-10 | 44.2 | 79 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 347 | 169 | 105 | 1013 |
AUT | Austria | parliament | 1962-11-18 | 45.4 | 81 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 495 | 347 | 533 | 1013 |
AUT | Austria | parliament | 1966-03-06 | 48.35 | 85 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 608 | 495 | 1035 | 1013 |
AUT | Austria | parliament | 1970-03-01 | 44.7 | 78 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 377 | 608 | 561 | 1013 |
AUT | Austria | parliament | 1971-10-10 | 43.1 | 80 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 185 | 377 | 354 | 1013 |
AUT | Austria | parliament | 1975-10-05 | 42.9 | 80 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 221 | 185 | 365 | 1013 |
AUT | Austria | parliament | 1979-05-06 | 41.9 | 77 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 452 | 221 | 350 | 1013 |
AUT | Austria | parliament | 1983-04-24 | 43.2 | 81 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 456 | 452 | 463 | 1013 |
AUT | Austria | parliament | 1986-11-23 | 41.3 | 77 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 235 | 456 | 828 | 1013 |
AUT | Austria | parliament | 1990-10-07 | 32.1 | 60 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 325 | 235 | 873 | 1013 |
AUT | Austria | parliament | 1994-10-09 | 27.7 | 52 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 66 | 325 | 524 | 1013 |
AUT | Austria | ep | 1995-01-01 | 6 | 21 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 13 | 66 | 294 | 1013 | |
AUT | Austria | parliament | 1995-12-17 | 28.3 | 52 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 162 | 66 | 294 | 1013 |
AUT | Austria | ep | 1996-10-13 | 29.65 | 7 | 21 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 22 | 162 | 323 | 1013 |
AUT | Austria | ep | 1999-06-13 | 30.67 | 7 | 21 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 16 | 162 | 412 | 1013 |
AUT | Austria | parliament | 1999-10-03 | 26.9 | 52 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 492 | 162 | 412 | 1013 |
AUT | Austria | parliament | 2002-11-24 | 42.3 | 79 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 365 | 492 | 722 | 1013 |
AUT | Austria | ep | 2004-06-13 | 32.7 | 6 | 18 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 45 | 365 | 257 | 1013 |
AUT | Austria | parliament | 2006-10-01 | 34.3 | 66 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 197 | 365 | 888 | 1013 |
AUT | Austria | parliament | 2008-09-28 | 25.98 | 51 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 607 | 197 | 583 | 1013 |
AUT | Austria | ep | 2009-06-07 | 30.0 | 6 | 17 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 232 | 607 | 268 | 1013 |
AUT | Austria | parliament | 2013-09-29 | 24.0 | 47 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 802 | 607 | 268 | 1013 |
AUT | Austria | ep | 2014-05-25 | 26.98 | 5 | 18 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 818 | 802 | 1070 | 1013 |
AUT | Austria | parliament | 2017-10-15 | 31.5 | 62 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1019 | 802 | 1485 | 1013 |
AUT | Austria | ep | 2019-05-26 | 34.6 | 7 | 18 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1074 | 1019 | 1521 | 1013 |
AUT | Austria | parliament | 2019-09-29 | 37.5 | 71 | 183 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1080 | 1019 | 1600 | 1013 |
DEU | Germany | ep | 2019-05-26 | 1.0 | 1 | 96 | ODP | Ökologisch-Demokratische Partei | Ecological Democratic Party | 2.5 | 54 | 1055 | 1016 | 1528 | 2736 |
ISL | Iceland | parliament | 2007-05-12 | 3.3 | 0 | 63 | IL | Íslandshreyfingin – lifandi land | Icelandic Movement -- Living Country | 2.5 | 56 | 265 | 178 | 246 | 2115 |
BEL | Belgium | ep | 1979-06-10 | 1.98 | 0 | 24 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 442 | 663 | 521 | 161 |
BEL | Belgium | parliament | 1981-11-08 | 2.5 | 2 | 212 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 501 | 663 | 429 | 161 |
BEL | Belgium | ep | 1984-06-17 | 3.86 | 1 | 24 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 10 | 501 | 724 | 161 |
BEL | Belgium | parliament | 1985-10-13 | 2.51 | 5 | 212 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 396 | 501 | 724 | 161 |
BEL | Belgium | parliament | 1987-12-13 | 2.57 | 3 | 212 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 191 | 396 | 92 | 161 |
BEL | Belgium | ep | 1989-06-18 | 6.29 | 2 | 24 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 553 | 191 | 457 | 161 |
BEL | Belgium | parliament | 1991-11-24 | 5.1 | 10 | 212 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 418 | 191 | 457 | 161 |
BEL | Belgium | ep | 1994-06-12 | 4.87 | 1 | 25 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 536 | 418 | 624 | 161 |
BEL | Belgium | parliament | 1995-05-21 | 4.01 | 6 | 150 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 332 | 418 | 624 | 161 |
BEL | Belgium | parliament | 1999-06-13 | 7.3 | 11 | 150 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 2 | 332 | 95 | 161 |
BEL | Belgium | ep | 1999-06-13 | 8.44 | 3 | 25 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 624 | 332 | 95 | 161 |
BEL | Belgium | parliament | 2003-05-18 | 3.06 | 4 | 150 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 143 | 2 | 193 | 161 |
BEL | Belgium | ep | 2004-06-13 | 3.69 | 1 | 24 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 656 | 143 | 449 | 161 |
BEL | Belgium | parliament | 2007-06-10 | 5.1 | 8 | 150 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 401 | 143 | 449 | 161 |
BEL | Belgium | ep | 2009-06-07 | 8.55 | 2 | 22 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 638 | 401 | 80 | 161 |
BEL | Belgium | parliament | 2010-06-13 | 4.8 | 8 | 150 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 486 | 401 | 431 | 161 |
BEL | Belgium | parliament | 2014-05-25 | 3.3 | 6 | 150 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 816 | 486 | 987 | 161 |
BEL | Belgium | ep | 2014-05-25 | 4.26 | 1 | 21 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 832 | 486 | 987 | 161 |
BEL | Belgium | parliament | 2019-05-26 | 6.14 | 13 | 150 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 1048 | 816 | 1586 | 161 |
BEL | Belgium | ep | 2019-05-26 | 7.31 | 2 | 21 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 1058 | 816 | 1586 | 161 |
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 |
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;