view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by seats
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUS | Australia | parliament | 1975-12-13 | 1.3 | 0 | 127 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 757 | 758 | 720 | 1306 |
AUS | Australia | parliament | 1977-12-10 | 1.4 | 0 | 124 | none | no party affiliation | no party affiliation | 33 | 755 | 757 | 836 | 1396 | |
AUS | Australia | parliament | 1977-12-10 | 1.4 | 0 | 124 | DLP | Democratic Labour Party | Democratic Labour Party | 4.1667 | 33 | 755 | 757 | 836 | 1306 |
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 | 1.7 | 0 | 125 | none | no party affiliation | no party affiliation | 33 | 736 | 755 | 421 | 1396 | |
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 | 1983-03-05 | 1.7 | 0 | 125 | none | no party affiliation | no party affiliation | 33 | 751 | 736 | 774 | 1396 | |
AUS | Australia | parliament | 1984-12-01 | 1.4 | 0 | 148 | none | no party affiliation | no party affiliation | 33 | 733 | 751 | 576 | 1396 | |
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 | 1987-07-11 | 2.0 | 0 | 148 | none | no party affiliation | no party affiliation | 33 | 732 | 733 | 401 | 1396 | |
AUS | Australia | parliament | 1990-03-24 | 1.4 | 0 | 148 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 752 | 732 | 875 | 751 |
AUS | Australia | parliament | 1990-03-24 | 1.0 | 0 | 148 | CDP | Christian Democratic Party | Christian Democratic Party | 6.2 | 33 | 752 | 732 | 875 | 1650 |
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 | 1993-03-13 | 1.9 | 0 | 147 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 753 | 752 | 725 | 751 |
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 | 1996-03-02 | 2.9 | 0 | 148 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 754 | 753 | 49 | 751 |
AUS | Australia | parliament | 1998-10-03 | 2.6 | 0 | 148 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 756 | 754 | 402 | 751 |
AUS | Australia | parliament | 1998-10-03 | 8.4 | 0 | 148 | ONP | One Nation Party | One Nation Party | 8.1579 | 33 | 756 | 754 | 402 | 386 |
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 | 2001-11-10 | 5.0 | 0 | 150 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 760 | 756 | 423 | 751 |
AUS | Australia | parliament | 2001-11-10 | 4.3 | 0 | 150 | ONP | One Nation Party | One Nation Party | 8.1579 | 33 | 760 | 756 | 423 | 386 |
AUS | Australia | parliament | 2004-10-09 | 2.0 | 0 | 150 | FFP | Family First Party | Family First Party | 7.4 | 33 | 762 | 760 | 812 | 446 |
AUS | Australia | parliament | 2004-10-09 | 1.2 | 0 | 150 | ONP | One Nation Party | One Nation Party | 8.1579 | 33 | 762 | 760 | 812 | 386 |
AUS | Australia | parliament | 2004-10-09 | 1.2 | 0 | 150 | AD | Australian Democrats | Australian Democrats | 3.7004 | 33 | 762 | 760 | 812 | 120 |
AUS | Australia | parliament | 2004-10-09 | 7.2 | 0 | 150 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 762 | 760 | 812 | 751 |
AUS | Australia | parliament | 2007-11-24 | 2.0 | 0 | 150 | FFP | Family First Party | Family First Party | 7.4 | 33 | 761 | 762 | 234 | 446 |
AUS | Australia | parliament | 2007-11-24 | 7.8 | 0 | 150 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 761 | 762 | 234 | 751 |
AUS | Australia | parliament | 2010-08-21 | 2.25 | 0 | 150 | FFP | Family First Party | Family First Party | 7.4 | 33 | 246 | 761 | 736 | 446 |
AUS | Australia | parliament | 2013-09-07 | 1.41 | 0 | 150 | FFP | Family First Party | Family First Party | 7.4 | 33 | 804 | 246 | 1061 | 446 |
AUS | Australia | parliament | 2016-07-02 | 1.49 | 0 | 150 | FFP | Family First Party | Family First Party | 7.4 | 33 | 1006 | 804 | 1174 | 446 |
AUS | Australia | parliament | 2016-07-02 | 1.31 | 0 | 150 | CDP | Christian Democratic Party | Christian Democratic Party | 6.2 | 33 | 1006 | 804 | 1174 | 1650 |
AUS | Australia | parliament | 2016-07-02 | 1.29 | 0 | 150 | ONP | One Nation Party | One Nation Party | 8.1579 | 33 | 1006 | 804 | 1174 | 386 |
AUS | Australia | parliament | 2019-05-18 | 3.43 | 0 | 151 | PUP | Palmer United Party | Palmer United Party | 6.0 | 33 | 1087 | 1006 | 1585 | 2259 |
AUS | Australia | parliament | 2019-05-18 | 3.08 | 0 | 151 | ONP | One Nation Party | One Nation Party | 8.1579 | 33 | 1087 | 1006 | 1585 | 386 |
AUS | Australia | parliament | 2022-05-21 | 4.12 | 0 | 151 | UAP | United Australia Party | United Australia Party | 7.4 | 33 | 1111 | 1087 | 1616 | 1912 |
AUS | Australia | parliament | 2022-05-21 | 4.96 | 0 | 151 | ONP | One Nation Party | One Nation Party | 8.1579 | 33 | 1111 | 1087 | 1616 | 386 |
AUS | Australia | parliament | 2022-05-21 | 1.73 | 0 | 151 | LD-NSW | Liberal Democratic Party (New South Wales) | Liberal Democratic Party (New South Wales) | 6.0 | 33 | 1111 | 1087 | 1616 | 1927 |
AUT | Austria | parliament | 1919-02-16 | 1.57 | 0 | 170 | NDP | Nationaldemokratische Partei | National Democratic Party | 8.8 | 59 | 1030 | 2679 | ||
AUT | Austria | parliament | 1920-10-17 | 0 | 183 | KB | Kärtner Bauernbund | Carinthian Farmers' Association | 5.3 | 59 | 1026 | 1030 | 1537 | 2678 | |
AUT | Austria | parliament | 1920-10-17 | 0 | 183 | DNSAP | Nationalsozialistische Arbeiterpartei | National Socialist Workers' Party | 8.8 | 59 | 1026 | 1030 | 1537 | 2684 | |
AUT | Austria | parliament | 1923-10-21 | 2.88 | 0 | 165 | etc | others | others | 59 | 1027 | 1026 | 1542 | 2687 | |
AUT | Austria | parliament | 1927-04-24 | 1.0 | 0 | 165 | UV | Udeverband, Bund gegen Korruption | Udeverband, Association against Corruption | 6.2 | 59 | 1028 | 1027 | 1546 | 2683 |
AUT | Austria | parliament | 1930-11-09 | 3.03 | 0 | 165 | DNSAP | Nationalsozialistische Arbeiterpartei | National Socialist Workers' Party | 8.8 | 59 | 1029 | 1028 | 1550 | 2684 |
AUT | Austria | parliament | 1945-11-25 | 0.2 | 0 | 165 | no-seat | no seat | no seat | 59 | 402 | 1029 | 452 | 2055 | |
AUT | Austria | parliament | 1949-10-09 | 0.28 | 0 | 165 | no-seat | no seat | no seat | 59 | 67 | 402 | 884 | 2055 | |
AUT | Austria | parliament | 1953-02-22 | 0.13 | 0 | 165 | no-seat | no seat | no seat | 59 | 11 | 67 | 560 | 2055 | |
AUT | Austria | parliament | 1956-05-13 | 0.04 | 0 | 165 | no-seat | no seat | no seat | 59 | 169 | 11 | 659 | 2055 | |
AUT | Austria | parliament | 1959-05-10 | 3.3 | 0 | 165 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 347 | 169 | 105 | 769 |
AUT | Austria | parliament | 1962-11-18 | 3.0 | 0 | 165 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 495 | 347 | 533 | 769 |
AUT | Austria | parliament | 1966-03-06 | 3.28 | 0 | 165 | DFP | Demokratische Fortschrittliche Partei | Democratic Progressive Party | 8.8 | 59 | 608 | 495 | 1035 | 1743 |
AUT | Austria | parliament | 1970-03-01 | 1.0 | 0 | 165 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 377 | 608 | 561 | 769 |
AUT | Austria | parliament | 1971-10-10 | 1.4 | 0 | 183 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 185 | 377 | 354 | 769 |
AUT | Austria | parliament | 1975-10-05 | 1.2 | 0 | 183 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 221 | 185 | 365 | 769 |
AUT | Austria | parliament | 1979-05-06 | 1.0 | 0 | 183 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 452 | 221 | 350 | 769 |
AUT | Austria | parliament | 1983-04-24 | 1.4 | 0 | 183 | ALO | Alternative Liste Österreichs | Alternative List Austria | 2.5 | 59 | 456 | 452 | 463 | 1739 |
AUT | Austria | parliament | 1983-04-24 | 2.0 | 0 | 183 | VGO | Vereinte Grüne Österreichs | United Greens Austria | 2.5 | 59 | 456 | 452 | 463 | 1740 |
AUT | Austria | parliament | 1986-11-23 | 0.7 | 0 | 183 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 235 | 456 | 828 | 769 |
AUT | Austria | parliament | 1990-10-07 | 2.0 | 0 | 183 | VGO | Vereinte Grüne Österreichs | United Greens Austria | 2.5 | 59 | 325 | 235 | 873 | 1740 |
AUT | Austria | parliament | 1994-10-09 | 0.9 | 0 | 183 | Nein | Nein – Bürgerinitiative gegen die EU Mitgliedschaft | No -- Citizens' Initiative against EU membership | 59 | 66 | 325 | 524 | 1744 | |
AUT | Austria | parliament | 1995-12-17 | 1.1 | 0 | 183 | Nein | Nein – Bürgerinitiative gegen die EU Mitgliedschaft | No -- Citizens' Initiative against EU membership | 59 | 162 | 66 | 294 | 1744 | |
AUT | Austria | ep | 1996-10-13 | 1.28 | 0 | 21 | N | Die Neutralen – Bürgerinitiative | Citizens' Initiative for the retention of neutrality | 59 | 22 | 162 | 323 | 1750 | |
AUT | Austria | ep | 1999-06-13 | 2.66 | 0 | 21 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 16 | 162 | 412 | 955 |
AUT | Austria | ep | 1999-06-13 | 1.54 | 0 | 21 | CSA | Christlich Soziale Allianz (Liste Karl Habsburg) | Christian Social Alliance (Karl Habsburg List) | 6.2 | 59 | 16 | 162 | 412 | 1752 |
AUT | Austria | parliament | 1999-10-03 | 1.0 | 0 | 183 | DU | Die Unabhängigen – Liste Lugner | The Independents -- Lugner's List | 59 | 492 | 162 | 412 | 1745 | |
AUT | Austria | parliament | 1999-10-03 | 3.7 | 0 | 183 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 492 | 162 | 412 | 955 |
AUT | Austria | parliament | 2002-11-24 | 0.98 | 0 | 183 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 365 | 492 | 722 | 955 |
AUT | Austria | ep | 2004-06-13 | 0.78 | 0 | 18 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 45 | 365 | 257 | 769 |
AUT | Austria | parliament | 2006-10-01 | 1.0 | 0 | 183 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 197 | 365 | 888 | 769 |
AUT | Austria | parliament | 2006-10-01 | 2.8 | 0 | 183 | Martin | Liste Dr. Hans-Peter Martin | Hans-Peter Martin's List | 4.2 | 59 | 197 | 365 | 888 | 669 |
AUT | Austria | parliament | 2008-09-28 | 2.09 | 0 | 183 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 607 | 197 | 583 | 955 |
AUT | Austria | parliament | 2008-09-28 | 1.76 | 0 | 183 | Fritz | Bürgerforum Österreich – Liste Fritz Dinkhauser | The Citizens' Forum Austria | 3.3 | 59 | 607 | 197 | 583 | 1746 |
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 |
AUT | Austria | parliament | 2013-09-29 | 1.0 | 0 | 183 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 802 | 607 | 268 | 769 |
AUT | Austria | ep | 2014-05-25 | 1.18 | 0 | 18 | REKOS | Die Reformkonservativen – REKOS | The Reform Conservatives | 7.4 | 59 | 818 | 802 | 1070 | 2339 |
AUT | Austria | ep | 2014-05-25 | 2.14 | 0 | 18 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 818 | 802 | 1070 | 769 |
AUT | Austria | ep | 2014-05-25 | 2.76 | 0 | 18 | EU-STOP | EU-Austritt, Direkte Demokratie, Neutralität | EU Withdrawal, Direct Democracy, Neutrality | 59 | 818 | 802 | 1070 | 2340 | |
AUT | Austria | parliament | 2017-10-15 | 3.8 | 0 | 183 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 1019 | 802 | 1485 | 1429 |
AUT | Austria | parliament | 2017-10-15 | 1.0 | 0 | 183 | GILT | Liste Roland Düringer – Meine Stimme GILT | My Vote Counts! | 59 | 1019 | 802 | 1485 | 2652 | |
AUT | Austria | ep | 2019-05-26 | 1.0 | 0 | 18 | PILZ | JETZT – Liste Pilz | JETZT -- Pilz List | 2.5 | 59 | 1074 | 1019 | 1521 | 2651 |
AUT | Austria | parliament | 2019-09-29 | 1.9 | 0 | 183 | PILZ | JETZT – Liste Pilz | JETZT -- Pilz List | 2.5 | 59 | 1080 | 1019 | 1600 | 2651 |
BEL | Belgium | parliament | 1906-05-27 | 1.0 | 0 | 85 | CV | Christene Volkspartij | Christian Peoples' Party [Daens] | 6.2 | 64 | 871 | 870 | 1376 | 2481 |
BEL | Belgium | parliament | 1910-05-22 | 2.1 | 0 | 85 | CV | Christene Volkspartij | Christian Peoples' Party [Daens] | 6.2 | 64 | 873 | 872 | 1372 | 2481 |
BEL | Belgium | parliament | 1936-05-24 | 0.63 | 0 | 202 | no-seat | no seat | no seat | 64 | 881 | 880 | 1270 | 2052 | |
BEL | Belgium | parliament | 1939-04-02 | 0.41 | 0 | 202 | no-seat | no seat | no seat | 64 | 882 | 881 | 1301 | 2052 | |
BEL | Belgium | parliament | 1946-02-17 | 0.14 | 0 | 202 | no-seat | no seat | no seat | 64 | 19 | 882 | 204 | 2052 | |
BEL | Belgium | parliament | 1949-06-26 | 2.1 | 0 | 212 | VU | Volksunie | People's Union | 6.5321 | 64 | 644 | 19 | 40 | 290 |
BEL | Belgium | parliament | 1950-06-04 | 0.03 | 0 | 212 | no-seat | no seat | no seat | 64 | 217 | 644 | 746 | 2052 | |
BEL | Belgium | parliament | 1954-04-11 | 0.2 | 0 | 212 | no-seat | no seat | no seat | 64 | 545 | 217 | 389 | 2052 | |
BEL | Belgium | parliament | 1961-03-26 | 0.63 | 0 | 212 | no-seat | no seat | no seat | 64 | 425 | 573 | 144 | 2052 | |
BEL | Belgium | parliament | 1965-05-23 | 0.8 | 0 | 212 | no-seat | no seat | no seat | 64 | 150 | 425 | 613 | 2052 | |
BEL | Belgium | parliament | 1971-11-07 | 0.42 | 0 | 212 | no-seat | no seat | no seat | 64 | 591 | 184 | 586 | 2052 | |
BEL | Belgium | parliament | 1974-03-10 | 0.3 | 0 | 212 | PA-PTB | Partij van de Arbeid – Parti du Travail de Belgique | Workers' Party of Belgium | 1.3 | 64 | 384 | 591 | 859 | 256 |
BEL | Belgium | parliament | 1977-04-17 | 0.4 | 0 | 212 | PA-PTB | Partij van de Arbeid – Parti du Travail de Belgique | Workers' Party of Belgium | 1.3 | 64 | 420 | 384 | 451 | 256 |
BEL | Belgium | parliament | 1978-12-17 | 0.79 | 0 | 212 | PA-PTB | Partij van de Arbeid – Parti du Travail de Belgique | Workers' Party of Belgium | 1.3 | 64 | 663 | 420 | 233 | 256 |
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 |
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;