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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NOR | Norway | parliament | 1933-10-16 | 0.55 | 1 | 150 | AD|DRF | Arbeiderdemokratene | Det radikale Folkeparti | Labour Democrats | Radical People's Party | 1.3 | 9 | 865 | 866 | 1225 | 2415 |
DNK | Denmark | parliament | 2022-11-01 | 8.1 | 14 | 179 | AE | Danmarksdemokraterne | Denmark Demokrats | 8.8 | 21 | 1116 | 1077 | 1598 | 2888 |
ISR | Israel | parliament | 1999-05-17 | 1.9 | 2 | 120 | AE | Am Ehad | One Nation | 2.9825 | 34 | 718 | 717 | 1159 | 615 |
ISR | Israel | parliament | 2003-01-28 | 2.76 | 3 | 120 | AE | Am Ehad | One Nation | 2.9825 | 34 | 719 | 718 | 1124 | 615 |
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 | 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 | 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 | 2001-11-10 | 5.0 | 0 | 150 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 760 | 756 | 423 | 751 |
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 | 7.8 | 0 | 150 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 761 | 762 | 234 | 751 |
AUS | Australia | parliament | 2010-08-21 | 11.76 | 1 | 150 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 246 | 761 | 736 | 751 |
AUS | Australia | parliament | 2013-09-07 | 8.65 | 1 | 150 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 804 | 246 | 1061 | 751 |
AUS | Australia | parliament | 2016-07-02 | 10.23 | 1 | 150 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 1006 | 804 | 1174 | 751 |
AUS | Australia | parliament | 2019-05-18 | 10.4 | 1 | 151 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 1087 | 1006 | 1585 | 751 |
AUS | Australia | parliament | 2022-05-21 | 12.25 | 4 | 151 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 1111 | 1087 | 1616 | 751 |
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 |
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 | |
ITA | Italy | parliament | 2006-04-09 | 0.25 | 1 | 630 | AIE | Associativo Italiani all'Estero | Associative Italians Abroad | 26 | 107 | 498 | 567 | 927 | |
ITA | Italy | parliament | 2008-04-13 | 0.24 | 1 | 630 | AIE | Associativo Italiani all'Estero | Associative Italians Abroad | 26 | 111 | 107 | 117 | 927 | |
ITA | Italy | parliament | 2013-02-25 | 0.41 | 2 | 630 | AIE | Associativo Italiani all'Estero | Associative Italians Abroad | 26 | 789 | 111 | 983 | 927 | |
ITA | Italy | parliament | 2018-03-04 | 0.33 | 1 | 630 | AIE | Associativo Italiani all'Estero | Associative Italians Abroad | 26 | 1024 | 789 | 1501 | 927 | |
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 | |
CYP | Cyprus | parliament | 1976-09-05 | 9 | 35 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 528 | 572 | |||
CYP | Cyprus | parliament | 1981-05-24 | 32.77 | 12 | 35 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 70 | 528 | 210 | 572 |
CYP | Cyprus | parliament | 1985-12-08 | 27.43 | 15 | 56 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 127 | 70 | 313 | 572 |
CYP | Cyprus | parliament | 1991-05-19 | 30.6 | 18 | 56 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 342 | 127 | 784 | 572 |
CYP | Cyprus | parliament | 1996-05-26 | 33.0 | 19 | 56 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 330 | 342 | 645 | 572 |
CYP | Cyprus | parliament | 2001-05-27 | 34.7 | 20 | 56 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 339 | 330 | 731 | 572 |
CYP | Cyprus | ep | 2004-06-13 | 27.89 | 2 | 6 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 397 | 339 | 342 | 572 |
CYP | Cyprus | parliament | 2006-05-21 | 31.13 | 18 | 56 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 556 | 339 | 342 | 572 |
CYP | Cyprus | ep | 2009-06-06 | 34.9 | 2 | 6 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 28 | 556 | 289 | 572 |
CYP | Cyprus | parliament | 2011-05-22 | 32.67 | 19 | 56 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 701 | 556 | 908 | 572 |
CYP | Cyprus | ep | 2014-05-25 | 26.98 | 2 | 6 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 819 | 701 | 1086 | 572 |
CYP | Cyprus | parliament | 2016-05-22 | 25.67 | 16 | 56 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 1004 | 701 | 1086 | 572 |
CYP | Cyprus | ep | 2019-05-26 | 27.49 | 2 | 6 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 1075 | 1004 | 1628 | 572 |
CYP | Cyprus | parliament | 2021-05-30 | 22.34 | 15 | 56 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 1095 | 1004 | 1628 | 572 |
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 |
NZL | New Zealand | parliament | 1996-10-12 | 1.66 | 0 | 120 | ALCP | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | 11 | 561 | 634 | 830 | 2073 | |
NZL | New Zealand | parliament | 1999-11-27 | 1.1 | 0 | 120 | ALCP | Aotearoa Legalise Cannabis Party | Aotearoa Legalise Cannabis Party | 11 | 451 | 561 | 388 | 2073 | |
ITA | Italy | parliament | 2006-04-09 | 0.09 | 1 | 630 | ALD | Autonomie Liberté Démocratie | Autonomy Liberty Democracy | 6.0 | 26 | 107 | 498 | 567 | 1063 |
ITA | Italy | parliament | 2008-04-13 | 0.08 | 1 | 630 | ALD | Autonomie Liberté Démocratie | Autonomy Liberty Democracy | 6.0 | 26 | 111 | 107 | 117 | 1063 |
AUT | Austria | parliament | 1983-04-24 | 1.4 | 0 | 183 | ALO | Alternative Liste Österreichs | Alternative List Austria | 2.5 | 59 | 456 | 452 | 463 | 1739 |
AUS | Australia | parliament | 1901-03-30 | 19.4 | 15 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 731 | 1253 | ||
AUS | Australia | parliament | 1903-12-16 | 31.0 | 23 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 730 | 731 | 997 | 1253 |
AUS | Australia | parliament | 1906-12-02 | 36.6 | 26 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 725 | 730 | 1000 | 1253 |
AUS | Australia | parliament | 1910-04-13 | 50.0 | 43 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 747 | 725 | 1002 | 1253 |
AUS | Australia | parliament | 1913-05-31 | 48.5 | 37 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 748 | 747 | 1003 | 1253 |
AUS | Australia | parliament | 1914-09-05 | 50.9 | 42 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 724 | 748 | 1004 | 1253 |
AUS | Australia | parliament | 1917-05-05 | 43.9 | 22 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 750 | 724 | 1008 | 1253 |
AUS | Australia | parliament | 1919-12-13 | 42.5 | 26 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 723 | 750 | 1010 | 1253 |
AUS | Australia | parliament | 1922-12-16 | 42.3 | 30 | 76 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 726 | 723 | 1011 | 1253 |
AUS | Australia | parliament | 1925-11-14 | 45.0 | 24 | 76 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 727 | 726 | 1012 | 1253 |
AUS | Australia | parliament | 1928-11-17 | 44.7 | 32 | 76 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 728 | 727 | 1013 | 1253 |
AUS | Australia | parliament | 1929-10-12 | 48.8 | 47 | 76 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 729 | 728 | 1014 | 1253 |
AUS | Australia | parliament | 1931-12-19 | 27.1 | 15 | 76 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 744 | 729 | 1015 | 1253 |
AUS | Australia | parliament | 1934-09-15 | 26.8 | 18 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 746 | 744 | 1016 | 1253 |
AUS | Australia | parliament | 1937-10-23 | 43.1 | 29 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 745 | 746 | 1017 | 1253 |
AUS | Australia | parliament | 1940-09-21 | 40.1 | 32 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 738 | 745 | 1021 | 1253 |
AUS | Australia | parliament | 1943-08-21 | 49.9 | 49 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 737 | 738 | 995 | 1253 |
AUS | Australia | parliament | 1946-09-28 | 49.7 | 43 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 739 | 737 | 574 | 1253 |
AUS | Australia | parliament | 1949-12-10 | 46.0 | 48 | 123 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 734 | 739 | 490 | 1253 |
AUS | Australia | parliament | 1951-04-28 | 47.7 | 54 | 123 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 763 | 734 | 450 | 1253 |
AUS | Australia | parliament | 1954-05-29 | 50.1 | 59 | 123 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 743 | 763 | 566 | 1253 |
AUS | Australia | parliament | 1955-12-10 | 44.7 | 49 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 742 | 743 | 178 | 1253 |
AUS | Australia | parliament | 1958-11-22 | 42.9 | 47 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 749 | 742 | 479 | 1253 |
AUS | Australia | parliament | 1961-12-09 | 48.0 | 62 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 740 | 749 | 627 | 1253 |
AUS | Australia | parliament | 1963-11-30 | 45.5 | 52 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 741 | 740 | 288 | 1253 |
AUS | Australia | parliament | 1966-11-26 | 40.0 | 41 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 764 | 741 | 261 | 1253 |
AUS | Australia | parliament | 1969-10-25 | 47.0 | 59 | 125 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 735 | 764 | 795 | 1253 |
AUS | Australia | parliament | 1972-12-02 | 49.6 | 67 | 125 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 759 | 735 | 671 | 1253 |
AUS | Australia | parliament | 1974-05-18 | 49.3 | 66 | 127 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 758 | 759 | 507 | 1253 |
AUS | Australia | parliament | 1975-12-13 | 42.8 | 36 | 127 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 757 | 758 | 720 | 1253 |
AUS | Australia | parliament | 1977-12-10 | 39.6 | 38 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 755 | 757 | 836 | 1253 |
AUS | Australia | parliament | 1980-10-18 | 45.1 | 51 | 125 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 736 | 755 | 421 | 1253 |
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;