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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUS | Australia | parliament | 1983-03-05 | 49.5 | 75 | 125 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 751 | 736 | 774 | 1253 |
AUS | Australia | parliament | 1984-12-01 | 47.5 | 82 | 148 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 733 | 751 | 576 | 1253 |
AUS | Australia | parliament | 1987-07-11 | 45.8 | 86 | 148 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 732 | 733 | 401 | 1253 |
AUS | Australia | parliament | 1990-03-24 | 39.4 | 78 | 148 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 752 | 732 | 875 | 1253 |
AUS | Australia | parliament | 1993-03-13 | 44.9 | 80 | 147 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 753 | 752 | 725 | 1253 |
AUS | Australia | parliament | 1996-03-02 | 38.8 | 49 | 148 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 754 | 753 | 49 | 1253 |
AUS | Australia | parliament | 1998-10-03 | 40.1 | 67 | 148 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 756 | 754 | 402 | 1253 |
AUS | Australia | parliament | 2001-11-10 | 37.8 | 65 | 150 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 760 | 756 | 423 | 1253 |
AUS | Australia | parliament | 2004-10-09 | 37.6 | 60 | 150 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 762 | 760 | 812 | 1253 |
AUS | Australia | parliament | 2007-11-24 | 43.4 | 83 | 150 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 761 | 762 | 234 | 1253 |
AUS | Australia | parliament | 2010-08-21 | 37.99 | 72 | 150 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 246 | 761 | 736 | 1253 |
AUS | Australia | parliament | 2013-09-07 | 33.38 | 55 | 150 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 804 | 246 | 1061 | 1253 |
AUS | Australia | parliament | 2016-07-02 | 34.73 | 69 | 150 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 1006 | 804 | 1174 | 1253 |
AUS | Australia | parliament | 2019-05-18 | 33.34 | 68 | 151 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 1087 | 1006 | 1585 | 1253 |
AUS | Australia | parliament | 2022-05-21 | 32.58 | 77 | 151 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 1111 | 1087 | 1616 | 1253 |
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 |
CYP | Cyprus | parliament | 2021-05-30 | 1.35 | 0 | 56 | AM | Afypnisis 2020 | Awakening 2020 | 51 | 1095 | 1004 | 1628 | 2819 | |
HRV | Croatia | ep | 2013-04-14 | 1.49 | 0 | 12 | AM | Akcija mladih | Youth Action | 2.5 | 62 | 791 | 792 | 1056 | 2186 |
ITA | Italy | parliament | 1994-03-27 | 109 | 630 | AN | Alleanza Nazionale | National Alliance | 8.0871 | 26 | 146 | 605 | 801 | 373 | |
ITA | Italy | ep | 1994-06-12 | 12.47 | 11 | 87 | AN | Alleanza Nazionale | National Alliance | 8.0871 | 26 | 326 | 146 | 672 | 373 |
ITA | Italy | parliament | 1996-04-21 | 93 | 630 | AN | Alleanza Nazionale | National Alliance | 8.0871 | 26 | 551 | 146 | 991 | 373 | |
ITA | Italy | ep | 1999-06-13 | 10.3 | 9 | 87 | AN | Alleanza Nazionale | National Alliance | 8.0871 | 26 | 363 | 551 | 214 | 373 |
ITA | Italy | parliament | 2001-05-13 | 12.02 | 99 | 630 | AN | Alleanza Nazionale | National Alliance | 8.0871 | 26 | 498 | 551 | 239 | 373 |
ITA | Italy | ep | 2004-06-12 | 11.49 | 9 | 78 | AN | Alleanza Nazionale | National Alliance | 8.0871 | 26 | 329 | 498 | 256 | 373 |
ITA | Italy | parliament | 2006-04-09 | 12.01 | 71 | 630 | AN | Alleanza Nazionale | National Alliance | 8.0871 | 26 | 107 | 498 | 567 | 373 |
TUR | Turkey | parliament | 1983-11-06 | 45.14 | 211 | 399 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 813 | 1334 | ||
TUR | Turkey | parliament | 1987-10-29 | 36.31 | 292 | 450 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 812 | 813 | 1087 | 1334 |
TUR | Turkey | parliament | 1991-10-20 | 24.01 | 115 | 450 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 811 | 812 | 1090 | 1334 |
TUR | Turkey | parliament | 1995-12-24 | 19.651 | 132 | 550 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 810 | 811 | 1093 | 1334 |
TUR | Turkey | parliament | 1999-04-18 | 13.22 | 86 | 550 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 809 | 810 | 1100 | 1334 |
TUR | Turkey | parliament | 2002-11-03 | 5.13 | 0 | 550 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 808 | 809 | 1101 | 1334 |
GRC | Greece | parliament | 2012-05-06 | 10.62 | 33 | 300 | ANEL | Anexartitoi Ellines | Independent Greeks | 8.8 | 41 | 783 | 651 | 984 | 2091 |
GRC | Greece | parliament | 2012-06-17 | 7.51 | 20 | 300 | ANEL | Anexartitoi Ellines | Independent Greeks | 8.8 | 41 | 784 | 783 | 1039 | 2091 |
GRC | Greece | ep | 2014-05-25 | 3.46 | 1 | 21 | ANEL | Anexartitoi Ellines | Independent Greeks | 8.8 | 41 | 826 | 784 | 1060 | 2091 |
GRC | Greece | parliament | 2015-01-25 | 4.75 | 13 | 300 | ANEL | Anexartitoi Ellines | Independent Greeks | 8.8 | 41 | 851 | 784 | 1060 | 2091 |
GRC | Greece | parliament | 2015-09-20 | 3.69 | 10 | 300 | ANEL | Anexartitoi Ellines | Independent Greeks | 8.8 | 41 | 992 | 851 | 1157 | 2091 |
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 |
SVK | Slovakia | parliament | 2002-09-21 | 8.01 | 15 | 150 | ANO | Aliancia nového občana | Alliance of the New Citizen | 7.2404 | 1 | 218 | 349 | 699 | 1200 |
SVK | Slovakia | ep | 2004-06-13 | 4.65 | 0 | 14 | ANO | Aliancia nového občana | Alliance of the New Citizen | 7.2404 | 1 | 124 | 218 | 547 | 1200 |
SVK | Slovakia | parliament | 2006-06-17 | 1.42 | 0 | 150 | ANO | Aliancia nového občana | Alliance of the New Citizen | 7.2404 | 1 | 192 | 218 | 185 | 1200 |
SVK | Slovakia | parliament | 2012-03-10 | 1.22 | 0 | 150 | ANO | Aliancia nového občana | Alliance of the New Citizen | 7.2404 | 1 | 781 | 524 | 982 | 1200 |
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 | ep | 2004-06-13 | 0.64 | 1 | 78 | AO | Alliances des outre-mers | Alliance of the Overseas | 1.3 | 43 | 160 | 403 | 802 | 2400 |
FRA | France | ep | 2009-06-07 | 0.46 | 1 | 72 | AO | Alliances des outre-mers | Alliance of the Overseas | 1.3 | 43 | 219 | 171 | 306 | 2400 |
FRA | France | ep | 2014-05-24 | 0.27 | 1 | 74 | AO | Alliances des outre-mers | Alliance of the Overseas | 1.3 | 43 | 824 | 782 | 1103 | 2400 |
NLD | Netherlands | parliament | 1994-05-03 | 3.63 | 6 | 150 | AOV|VSP | Algemeen Ouderen Verbond | Verenigde Senioren Partij | General Senior Union | United Seniors Party | 8 | 570 | 627 | 148 | 112 | |
NLD | Netherlands | parliament | 2002-05-15 | 0.41 | 0 | 150 | AOV|VSP | Algemeen Ouderen Verbond | Verenigde Senioren Partij | General Senior Union | United Seniors Party | 8 | 74 | 372 | 749 | 112 | |
AUS | Australia | parliament | 1972-12-02 | 2.4 | 0 | 125 | AP | Australia Party | Australia Party | 6.0 | 33 | 759 | 735 | 671 | 1760 |
AUS | Australia | parliament | 1974-05-18 | 2.3 | 0 | 127 | AP | Australia Party | Australia Party | 6.0 | 33 | 758 | 759 | 507 | 1760 |
LVA | Latvia | parliament | 2018-10-06 | 12.04 | 13 | 100 | AP! | Attīstībai/Par! | Development/For! | 55 | 1042 | 831 | 1407 | 2878 | |
LVA | Latvia | parliament | 2022-10-01 | 4.97 | 0 | 100 | AP! | Attīstībai/Par! | Development/For! | 55 | 1115 | 1042 | 1592 | 2878 | |
ESP | Spain | parliament | 1977-06-15 | 8.23 | 16 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 42 | 645 | ||
ESP | Spain | parliament | 1979-03-01 | 5.91 | 9 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 493 | 42 | 205 | 645 |
ESP | Spain | parliament | 1982-10-28 | 26.48 | 107 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 85 | 493 | 406 | 645 |
ESP | Spain | ep | 1986-01-01 | 17 | 60 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 38 | 85 | 238 | 645 | |
ESP | Spain | parliament | 1986-06-22 | 26.13 | 105 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 254 | 85 | 238 | 645 |
ESP | Spain | ep | 1987-06-10 | 24.89 | 17 | 60 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 557 | 254 | 834 | 645 |
ESP | Spain | ep | 1989-06-18 | 21.68 | 15 | 60 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 474 | 254 | 834 | 645 |
ESP | Spain | parliament | 1989-10-29 | 25.97 | 107 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 289 | 254 | 834 | 645 |
ESP | Spain | parliament | 1993-06-06 | 35.04 | 141 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 252 | 289 | 37 | 645 |
ESP | Spain | ep | 1994-06-12 | 40.59 | 28 | 64 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 44 | 252 | 654 | 645 |
ESP | Spain | parliament | 1996-03-03 | 39.17 | 156 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 99 | 252 | 654 | 645 |
ESP | Spain | ep | 1999-06-13 | 40.42 | 27 | 64 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 585 | 99 | 370 | 645 |
ESP | Spain | parliament | 2000-03-12 | 45.24 | 183 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 687 | 99 | 370 | 645 |
ESP | Spain | parliament | 2004-03-14 | 38.31 | 148 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 164 | 687 | 309 | 645 |
ESP | Spain | ep | 2004-06-13 | 41.21 | 24 | 54 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 368 | 164 | 806 | 645 |
ESP | Spain | parliament | 2008-03-09 | 40.1 | 154 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 500 | 164 | 806 | 645 |
ESP | Spain | ep | 2009-06-07 | 42.12 | 23 | 50 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 448 | 500 | 497 | 645 |
ESP | Spain | parliament | 2011-11-20 | 41.9 | 186 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 777 | 500 | 497 | 645 |
ESP | Spain | ep | 2014-05-25 | 26.09 | 16 | 54 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 839 | 777 | 988 | 645 |
ESP | Spain | parliament | 2015-12-20 | 28.72 | 123 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 998 | 777 | 988 | 645 |
ESP | Spain | parliament | 2016-06-26 | 33.03 | 137 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 1005 | 998 | 1421 | 645 |
ESP | Spain | parliament | 2019-04-28 | 16.7 | 66 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 1046 | 1005 | 1533 | 645 |
ESP | Spain | ep | 2019-05-26 | 20.15 | 12 | 54 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 1072 | 1046 | 1601 | 645 |
ESP | Spain | parliament | 2019-11-10 | 20.81 | 89 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 1085 | 1046 | 1601 | 645 |
PRT | Portugal | parliament | 1979-12-02 | 19.33 | 250 | APU | Aliança Povo Unido | United People Alliance | 1.3 | 63 | 248 | 200 | 384 | 11 | |
PRT | Portugal | parliament | 1980-10-05 | 17.14 | 250 | APU | Aliança Povo Unido | United People Alliance | 1.3 | 63 | 281 | 248 | 549 | 11 | |
PRT | Portugal | parliament | 1983-04-25 | 18.55 | 250 | APU | Aliança Povo Unido | United People Alliance | 1.3 | 63 | 598 | 281 | 135 | 11 | |
PRT | Portugal | parliament | 1985-10-06 | 15.89 | 250 | APU | Aliança Povo Unido | United People Alliance | 1.3 | 63 | 106 | 598 | 885 | 11 | |
GBR | United Kingdom | ep | 2019-05-23 | 0.6 | 1 | 73 | APoNI | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | 6.0 | 44 | 1051 | 1013 | 1507 | 2731 |
GBR | United Kingdom | parliament | 2019-12-12 | 0.42 | 1 | 650 | APoNI | Alliance Party of Northern Ireland | Alliance Party of Northern Ireland | 6.0 | 44 | 1086 | 1013 | 1599 | 2731 |
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 | |
NLD | Netherlands | parliament | 1918-07-03 | 13.4 | 13 | 93 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 937 | 300 | ||
NLD | Netherlands | parliament | 1922-07-05 | 13.7 | 16 | 100 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 938 | 937 | 1262 | 300 |
NLD | Netherlands | parliament | 1925-07-01 | 12.2 | 13 | 100 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 939 | 938 | 1261 | 300 |
NLD | Netherlands | parliament | 1929-07-03 | 11.6 | 12 | 100 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 940 | 939 | 1259 | 300 |
NLD | Netherlands | parliament | 1933-04-26 | 13.4 | 14 | 100 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 941 | 940 | 1258 | 300 |
NLD | Netherlands | parliament | 1937-05-26 | 16.4 | 17 | 100 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 942 | 941 | 1256 | 300 |
NLD | Netherlands | parliament | 1946-05-17 | 12.9 | 13 | 100 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 182 | 942 | 767 | 300 |
NLD | Netherlands | parliament | 1948-07-07 | 13.21 | 13 | 100 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 497 | 182 | 96 | 300 |
NLD | Netherlands | parliament | 1952-06-25 | 11.31 | 12 | 100 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 543 | 497 | 243 | 300 |
NLD | Netherlands | parliament | 1956-06-13 | 9.91 | 15 | 150 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 437 | 543 | 366 | 300 |
NLD | Netherlands | parliament | 1959-03-12 | 9.39 | 14 | 150 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 667 | 437 | 741 | 300 |
NLD | Netherlands | parliament | 1963-05-15 | 8.72 | 13 | 150 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 529 | 667 | 694 | 300 |
NLD | Netherlands | parliament | 1967-02-15 | 9.9 | 15 | 150 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 204 | 529 | 455 | 300 |
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;