view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_name_short
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
DNK | Denmark | parliament | 2015-06-18 | 4.8 | 9 | 179 | A | Alternativet | The Alternative | 2.5 | 21 | 976 | 722 | 1074 | 2567 |
DNK | Denmark | ep | 2019-05-26 | 3.4 | 0 | 13 | A | Alternativet | The Alternative | 2.5 | 21 | 1049 | 976 | 1497 | 2567 |
DNK | Denmark | parliament | 2019-06-05 | 3.0 | 5 | 179 | A | Alternativet | The Alternative | 2.5 | 21 | 1077 | 976 | 1497 | 2567 |
DNK | Denmark | parliament | 2022-11-01 | 3.3 | 6 | 179 | A | Alternativet | The Alternative | 2.5 | 21 | 1116 | 1077 | 1598 | 2567 |
IRL | Ireland | parliament | 2020-02-08 | 1.9 | 1 | 160 | A | Aontú | Aontu | 7.4 | 37 | 1088 | 1002 | 1511 | 2795 |
ISL | Iceland | parliament | 1919-11-15 | 6.8 | 0 | 40 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 922 | 228 | ||
ISL | Iceland | parliament | 1923-10-27 | 16.2 | 1 | 40 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 923 | 922 | 1425 | 228 |
ISL | Iceland | parliament | 1927-07-09 | 19.0 | 5 | 42 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 924 | 923 | 1428 | 228 |
ISL | Iceland | parliament | 1931-06-12 | 16.1 | 4 | 42 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 925 | 924 | 1429 | 228 |
ISL | Iceland | parliament | 1933-07-16 | 19.2 | 5 | 42 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 926 | 925 | 1431 | 228 |
ISL | Iceland | parliament | 1934-06-24 | 21.7 | 10 | 49 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 927 | 926 | 1431 | 228 |
ISL | Iceland | parliament | 1937-06-29 | 19.0 | 8 | 49 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 928 | 927 | 1432 | 228 |
ISL | Iceland | parliament | 1942-07-05 | 15.4 | 6 | 49 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 929 | 928 | 1434 | 228 |
ISL | Iceland | parliament | 1942-10-19 | 14.2 | 7 | 52 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 780 | 929 | 1434 | 228 |
ISL | Iceland | parliament | 1946-06-30 | 17.8 | 9 | 52 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 35 | 780 | 435 | 228 |
ISL | Iceland | parliament | 1949-10-24 | 16.5 | 7 | 52 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 259 | 35 | 742 | 228 |
ISL | Iceland | parliament | 1953-06-28 | 15.6 | 6 | 52 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 88 | 259 | 766 | 228 |
ISL | Iceland | parliament | 1956-06-24 | 18.3 | 8 | 52 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 665 | 88 | 762 | 228 |
ISL | Iceland | parliament | 1959-06-28 | 12.5 | 6 | 52 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 393 | 665 | 446 | 228 |
ISL | Iceland | parliament | 1959-10-26 | 15.2 | 9 | 60 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 320 | 393 | 351 | 228 |
ISL | Iceland | parliament | 1963-06-09 | 14.2 | 8 | 60 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 379 | 320 | 331 | 228 |
ISL | Iceland | parliament | 1967-06-11 | 15.7 | 9 | 60 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 318 | 379 | 553 | 228 |
ISL | Iceland | parliament | 1971-06-13 | 10.5 | 6 | 60 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 225 | 318 | 321 | 228 |
ISL | Iceland | parliament | 1974-06-30 | 9.1 | 5 | 60 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 637 | 225 | 272 | 228 |
ISL | Iceland | parliament | 1978-06-25 | 22.0 | 14 | 60 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 275 | 637 | 849 | 228 |
ISL | Iceland | parliament | 1979-12-03 | 17.4 | 10 | 60 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 436 | 275 | 536 | 228 |
ISL | Iceland | parliament | 1983-04-23 | 11.7 | 6 | 60 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 114 | 436 | 752 | 228 |
ISL | Iceland | parliament | 1987-04-25 | 15.2 | 10 | 63 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 673 | 114 | 393 | 228 |
ISL | Iceland | parliament | 1991-04-20 | 15.5 | 10 | 63 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 274 | 673 | 127 | 228 |
ISL | Iceland | parliament | 1995-04-08 | 11.4 | 7 | 63 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 82 | 274 | 640 | 228 |
NOR | Norway | parliament | 1909-10-25 | 1.2 | 0 | 123 | A | Avholdspartiet | Teetotaler Party | 9 | 946 | 945 | 1382 | 2544 | |
NOR | Norway | parliament | 1915-10-21 | 0.1 | 0 | 123 | A | Avholdspartiet | Teetotaler Party | 9 | 948 | 947 | 1240 | 2544 | |
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 |
GRC | Greece | parliament | 2012-05-06 | 1.19 | 0 | 300 | AASA | Antikapitalistiki Aristeri Synergasia gia tin Anatropi | Front of the Greek Anticapitalist Left | 1.3 | 41 | 783 | 651 | 984 | 2097 |
BGR | Bulgaria | ep | 2014-05-25 | 4.02 | 0 | 17 | ABV | Alternativa za balgarsko vazrazhdane | Alternative for Bulgarian Revival | 3.3 | 10 | 830 | 799 | 1058 | 2364 |
BGR | Bulgaria | parliament | 2014-10-05 | 4.15 | 11 | 240 | ABV | Alternativa za balgarsko vazrazhdane | Alternative for Bulgarian Revival | 3.3 | 10 | 840 | 799 | 1139 | 2364 |
BGR | Bulgaria | parliament | 2017-03-26 | 1.59 | 0 | 240 | ABV | Alternativa za balgarsko vazrazhdane | Alternative for Bulgarian Revival | 3.3 | 10 | 1011 | 840 | 1503 | 2364 |
FRA | France | parliament | 2012-06-17 | 0.6 | 2 | 577 | AC | Alliance centriste | Centrist Alliance | 6.0 | 43 | 782 | 171 | 1037 | 2078 |
FRA | France | ep | 2014-05-24 | 1 | 74 | AC | Alliance centriste | Centrist Alliance | 6.0 | 43 | 824 | 782 | 1103 | 2078 | |
AUS | Australia | parliament | 1934-09-15 | 2.2 | 2 | 75 | ACP-V | Australian Country Party (Vic) | Australian Country Party (Vic) | 7.4 | 33 | 746 | 744 | 1016 | 1935 |
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 |
AUS | Australia | parliament | 1977-12-10 | 9.4 | 0 | 124 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 755 | 757 | 836 | 120 |
AUS | Australia | parliament | 1980-10-18 | 6.6 | 0 | 125 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 736 | 755 | 421 | 120 |
AUS | Australia | parliament | 1983-03-05 | 5.0 | 0 | 125 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 751 | 736 | 774 | 120 |
AUS | Australia | parliament | 1984-12-01 | 5.4 | 0 | 148 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 733 | 751 | 576 | 120 |
AUS | Australia | parliament | 1987-07-11 | 6.0 | 0 | 148 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 732 | 733 | 401 | 120 |
AUS | Australia | parliament | 1990-03-24 | 11.3 | 0 | 148 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 752 | 732 | 875 | 120 |
AUS | Australia | parliament | 1993-03-13 | 3.8 | 0 | 147 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 753 | 752 | 725 | 120 |
AUS | Australia | parliament | 1996-03-02 | 6.8 | 0 | 148 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 754 | 753 | 49 | 120 |
AUS | Australia | parliament | 1998-10-03 | 5.1 | 0 | 148 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 756 | 754 | 402 | 120 |
AUS | Australia | parliament | 2001-11-10 | 5.4 | 0 | 150 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 760 | 756 | 423 | 120 |
AUS | Australia | parliament | 2004-10-09 | 1.2 | 0 | 150 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 762 | 760 | 812 | 120 |
ITA | Italy | parliament | 1994-03-27 | 18 | 630 | AD | Alleanza Democratica | Democratic Alliance | 5.0 | 26 | 146 | 605 | 801 | 896 | |
MLT | Malta | parliament | 1992-02-22 | 1.69 | 0 | 65 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 520 | 370 | 3 | 360 |
MLT | Malta | parliament | 1996-10-26 | 1.46 | 0 | 69 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 483 | 520 | 881 | 360 |
MLT | Malta | parliament | 1998-09-05 | 1.21 | 0 | 65 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 173 | 483 | 299 | 360 |
MLT | Malta | parliament | 2003-04-12 | 0.68 | 0 | 65 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 509 | 173 | 582 | 360 |
MLT | Malta | ep | 2004-06-13 | 9.33 | 0 | 5 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 346 | 509 | 298 | 360 |
MLT | Malta | parliament | 2008-03-08 | 1.31 | 0 | 69 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 203 | 509 | 298 | 360 |
MLT | Malta | ep | 2009-06-06 | 2.34 | 0 | 5 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 555 | 203 | 468 | 360 |
MLT | Malta | parliament | 2013-03-09 | 1.8 | 0 | 69 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 790 | 203 | 468 | 360 |
MLT | Malta | ep | 2014-05-25 | 2.95 | 0 | 6 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 836 | 790 | 1046 | 360 |
MLT | Malta | parliament | 2017-06-03 | 0.83 | 0 | 67 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 1010 | 790 | 1046 | 360 |
PRT | Portugal | parliament | 1979-12-02 | 43.71 | 250 | AD | Aliança Democrática | Democratic Alliance | 6.0 | 63 | 248 | 200 | 384 | 1543 | |
PRT | Portugal | parliament | 1980-10-05 | 47.59 | 250 | AD | Aliança Democrática | Democratic Alliance | 6.0 | 63 | 281 | 248 | 549 | 1543 | |
CYP | Cyprus | parliament | 1991-05-19 | 2.4 | 0 | 56 | ADISOK | Anorthotiko Dimokratiko Sosialistiko Kinima | Democratic Socialist Renewal Movement | 1.3 | 51 | 342 | 127 | 784 | 1779 |
CYP | Cyprus | parliament | 1996-05-26 | 1.4 | 0 | 56 | ADISOK | Anorthotiko Dimokratiko Sosialistiko Kinima | Democratic Socialist Renewal Movement | 1.3 | 51 | 330 | 342 | 645 | 1779 |
CYP | Cyprus | parliament | 2001-05-27 | 2.2 | 1 | 56 | ADK | Agonistiko Dimokratiko Kinima | Fighting Democratic Movement | 7.7632 | 51 | 339 | 330 | 731 | 1049 |
NOR | Norway | parliament | 1903-09-16 | 2 | 117 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 944 | 943 | 1378 | 2415 | |
NOR | Norway | parliament | 1906-08-27 | 4.8 | 4 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 945 | 944 | 1380 | 2415 |
NOR | Norway | parliament | 1909-10-25 | 3.7 | 2 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 946 | 945 | 1382 | 2415 |
NOR | Norway | parliament | 1912-10-21 | 6 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 947 | 946 | 1384 | 2415 | |
NOR | Norway | parliament | 1915-10-21 | 4.2 | 6 | 123 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 948 | 947 | 1240 | 2415 |
NOR | Norway | parliament | 1918-10-21 | 3.3 | 3 | 126 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 949 | 948 | 1239 | 2415 |
NOR | Norway | parliament | 1921-10-24 | 2.5 | 2 | 150 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 950 | 949 | 1235 | 2415 |
NOR | Norway | parliament | 1924-10-21 | 1.8 | 2 | 150 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 951 | 950 | 1233 | 2415 |
NOR | Norway | parliament | 1927-10-17 | 1.35 | 1 | 150 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 867 | 951 | 1231 | 2415 |
NOR | Norway | parliament | 1930-10-20 | 0.77 | 1 | 150 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 866 | 867 | 1229 | 2415 |
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;