view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_name_english
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HUN | Hungary | ep | 2004-06-13 | 7.74 | 2 | 24 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 224 | 463 | 302 | 1426 |
HUN | Hungary | parliament | 2006-04-09 | 6.5 | 20 | 386 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 194 | 463 | 188 | 1426 |
HUN | Hungary | ep | 2009-06-07 | 2.16 | 0 | 22 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 249 | 194 | 162 | 1426 |
HRV | Croatia | parliament | 2000-01-03 | 2 | 151 | PGS | Primorsko goranski savez | Alliance of Primorje-Gorski | 62 | 797 | 2196 | ||||
HRV | Croatia | parliament | 2003-11-23 | 1 | 152 | PGS | Primorsko goranski savez | Alliance of Primorje-Gorski | 62 | 795 | 797 | 1051 | 2196 | ||
HRV | Croatia | parliament | 2011-12-04 | 2.8 | 0 | 151 | PGS | Primorsko goranski savez | Alliance of Primorje-Gorski | 62 | 792 | 793 | 1057 | 2196 | |
ISL | Iceland | parliament | 1983-04-23 | 7.3 | 4 | 60 | BJ | Bandalag jafnaðarmanna | Alliance of Social Democrats | 3.3 | 56 | 114 | 436 | 752 | 988 |
ISL | Iceland | parliament | 1987-04-25 | 0.2 | 0 | 63 | BJ | Bandalag jafnaðarmanna | Alliance of Social Democrats | 3.3 | 56 | 673 | 114 | 393 | 988 |
LTU | Lithuania | parliament | 1996-10-20 | 2.55 | 0 | 141 | LTMA | Lietuvos tautinių mažumų aljansas | Alliance of the Lithuanian National Minorities | 15 | 566 | 439 | 91 | 2036 | |
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 |
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 |
GRC | Greece | ep | 1989-06-18 | 1.1 | 0 | 24 | OE | Oikolόgoi Enallaktikoί | Alternative Ecologists | 2.5 | 41 | 518 | 453 | 39 | 2163 |
GRC | Greece | parliament | 1989-11-05 | 0.6 | 1 | 300 | OE | Oikolόgoi Enallaktikoί | Alternative Ecologists | 2.5 | 41 | 508 | 205 | 721 | 2163 |
GRC | Greece | parliament | 1990-04-08 | 0.8 | 1 | 300 | OE | Oikolόgoi Enallaktikoί | Alternative Ecologists | 2.5 | 41 | 284 | 508 | 716 | 2163 |
AUT | Austria | parliament | 1983-04-24 | 1.4 | 0 | 183 | ALO | Alternative Liste Österreichs | Alternative List Austria | 2.5 | 59 | 456 | 452 | 463 | 1739 |
ROU | Romania | parliament | 1996-11-03 | 3 | 343 | PAR | Partidul Alternativa României | Alternative Party of Romania | 7.4 | 23 | 49 | 416 | 102 | 2087 | |
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 |
DEU | Germany | parliament | 2013-09-22 | 4.7 | 0 | 631 | AfD | Alternative für Deutschland | Alternative for Germany | 8.8 | 54 | 800 | 93 | 472 | 2253 |
DEU | Germany | ep | 2014-05-25 | 7.1 | 7 | 96 | AfD | Alternative für Deutschland | Alternative for Germany | 8.8 | 54 | 825 | 800 | 1071 | 2253 |
DEU | Germany | parliament | 2017-09-24 | 12.6 | 94 | 709 | AfD | Alternative für Deutschland | Alternative for Germany | 8.8 | 54 | 1016 | 800 | 1071 | 2253 |
DEU | Germany | ep | 2019-05-26 | 11.0 | 11 | 96 | AfD | Alternative für Deutschland | Alternative for Germany | 8.8 | 54 | 1055 | 1016 | 1528 | 2253 |
DEU | Germany | parliament | 2021-09-26 | 10.34 | 83 | 736 | AfD | Alternative für Deutschland | Alternative for Germany | 8.8 | 54 | 1096 | 1016 | 1528 | 2253 |
GBR | United Kingdom | ep | 2014-05-22 | 1.49 | 0 | 73 | IE | An Independence from Europe | An Independence from Europe | 8.8 | 44 | 845 | 582 | 874 | 2387 |
ESP | Spain | parliament | 1979-03-01 | 1.82 | 5 | 350 | PA | Partidu Andalucista | Andalusian Party | 4.85 | 27 | 493 | 42 | 205 | 370 |
ESP | Spain | ep | 1987-06-10 | 0.97 | 0 | 60 | PA | Partidu Andalucista | Andalusian Party | 4.85 | 27 | 557 | 254 | 834 | 370 |
ESP | Spain | ep | 1989-06-18 | 1.88 | 1 | 60 | PA | Partidu Andalucista | Andalusian Party | 4.85 | 27 | 474 | 254 | 834 | 370 |
ESP | Spain | parliament | 1989-10-29 | 1.05 | 2 | 350 | PA | Partidu Andalucista | Andalusian Party | 4.85 | 27 | 289 | 254 | 834 | 370 |
ESP | Spain | parliament | 1996-03-03 | 0.54 | 0 | 350 | PA | Partidu Andalucista | Andalusian Party | 4.85 | 27 | 99 | 252 | 654 | 370 |
ESP | Spain | parliament | 2000-03-12 | 0.9 | 1 | 350 | PA | Partidu Andalucista | Andalusian Party | 4.85 | 27 | 687 | 99 | 370 | 370 |
ESP | Spain | parliament | 2004-03-14 | 0.71 | 0 | 350 | PA | Partidu Andalucista | Andalusian Party | 4.85 | 27 | 164 | 687 | 309 | 370 |
CYP | Cyprus | parliament | 2016-05-22 | 1.16 | 0 | 56 | KGTZTK | Kinima gia ta zoa tis Kíprou | Animal Party Cyprus | 51 | 1004 | 701 | 1086 | 2627 | |
CYP | Cyprus | parliament | 2021-05-30 | 1.0 | 0 | 56 | KGTZTK | Kinima gia ta zoa tis Kíprou | Animal Party Cyprus | 51 | 1095 | 1004 | 1628 | 2627 | |
DEU | Germany | ep | 2004-06-13 | 1.3 | 0 | 99 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 18 | 385 | 529 | 301 | |
DEU | Germany | ep | 2009-06-07 | 1.1 | 0 | 99 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 231 | 118 | 85 | 301 | |
DEU | Germany | ep | 2014-05-25 | 1.2 | 1 | 96 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 825 | 800 | 1071 | 301 | |
DEU | Germany | ep | 2019-05-26 | 1.4 | 1 | 96 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 1055 | 1016 | 1528 | 301 | |
DEU | Germany | parliament | 2021-09-26 | 1.45 | 0 | 736 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 1096 | 1016 | 1528 | 301 | |
FRA | France | ep | 2019-05-26 | 2.16 | 0 | 74 | PA | Parti animaliste | Animalist Party | 43 | 1054 | 1014 | 1509 | 2733 | |
ESP | Spain | ep | 2014-05-25 | 1.13 | 0 | 54 | PACMA | Partido Animalista Contra el Maltrato Animal | Animalist Party Against Mistreatment to Animals | 27 | 839 | 777 | 988 | 2381 | |
ESP | Spain | parliament | 2015-12-20 | 0.87 | 0 | 350 | PACMA | Partido Animalista Contra el Maltrato Animal | Animalist Party Against Mistreatment to Animals | 27 | 998 | 777 | 988 | 2381 | |
ESP | Spain | parliament | 2016-06-26 | 1.19 | 0 | 350 | PACMA | Partido Animalista Contra el Maltrato Animal | Animalist Party Against Mistreatment to Animals | 27 | 1005 | 998 | 1421 | 2381 | |
ESP | Spain | parliament | 2019-04-28 | 1.25 | 0 | 350 | PACMA | Partido Animalista Contra el Maltrato Animal | Animalist Party Against Mistreatment to Animals | 27 | 1046 | 1005 | 1533 | 2381 | |
ESP | Spain | ep | 2019-05-26 | 1.32 | 0 | 54 | PACMA | Partido Animalista Contra el Maltrato Animal | Animalist Party Against Mistreatment to Animals | 27 | 1072 | 1046 | 1601 | 2381 | |
ESP | Spain | parliament | 2019-11-10 | 0.94 | 0 | 350 | PACMA | Partido Animalista Contra el Maltrato Animal | Animalist Party Against Mistreatment to Animals | 27 | 1085 | 1046 | 1601 | 2381 | |
IRL | Ireland | parliament | 1981-06-11 | 2.429 | 2 | 166 | H-B | Anti H-Block | Anti H-Block | 37 | 47 | 6 | 442 | 1323 | |
FIN | Finland | ep | 1996-10-20 | 2.1 | 0 | 16 | VEU | Vaihtoehto EU:Lle | Anti-EU Movement | 67 | 652 | 24 | 100 | 1649 | |
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 |
NLD | Netherlands | parliament | 1971-04-28 | 8.59 | 13 | 150 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 125 | 204 | 172 | 300 |
NLD | Netherlands | parliament | 1972-11-29 | 8.84 | 14 | 150 | ARP | Anti-Revolutionaire Partij | Anti-Revolutionary Party | 5.8067 | 8 | 51 | 125 | 291 | 300 |
IRL | Ireland | parliament | 2020-02-08 | 1.9 | 1 | 160 | A | Aontú | Aontu | 7.4 | 37 | 1088 | 1002 | 1511 | 2795 |
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 | |
ISR | Israel | parliament | 1988-11-01 | 1.2 | 1 | 120 | Mada | Miflaga Demokratit Aravit – al-Hizb al-Dimuqrati al-Arabi | Arab Democratic Party | 1.0526 | 34 | 715 | 714 | 1108 | 1150 |
ISR | Israel | parliament | 1992-06-23 | 1.6 | 2 | 120 | Mada | Miflaga Demokratit Aravit – al-Hizb al-Dimuqrati al-Arabi | Arab Democratic Party | 1.0526 | 34 | 716 | 715 | 957 | 1150 |
ISR | Israel | parliament | 1973-12-31 | 1.0 | 1 | 120 | RALEV | Reshima Aravit LeBedouim VeKfariym | Arab List for Bedouin and Villagers | 34 | 711 | 710 | 940 | 2357 | |
ESP | Spain | parliament | 2000-03-12 | 0.33 | 1 | 350 | CA | Chunta Aragonesista | Aragonese Council | 2.75 | 27 | 687 | 99 | 370 | 1367 |
ESP | Spain | parliament | 2004-03-14 | 0.37 | 1 | 350 | CA | Chunta Aragonesista | Aragonese Council | 2.75 | 27 | 164 | 687 | 309 | 1367 |
ESP | Spain | parliament | 1977-06-15 | 0.2 | 1 | 350 | PAR | Partido Aragonés Regionalista | Aragonese Regionalist Party | 7.1909 | 27 | 42 | 1221 | ||
ESP | Spain | parliament | 1979-03-01 | 0.21 | 1 | 350 | PAR | Partido Aragonés Regionalista | Aragonese Regionalist Party | 7.1909 | 27 | 493 | 42 | 205 | 1221 |
ESP | Spain | parliament | 1986-06-22 | 0.36 | 1 | 350 | PAR | Partido Aragonés Regionalista | Aragonese Regionalist Party | 7.1909 | 27 | 254 | 85 | 238 | 1221 |
ESP | Spain | parliament | 1989-10-29 | 0.35 | 1 | 350 | PAR | Partido Aragonés Regionalista | Aragonese Regionalist Party | 7.1909 | 27 | 289 | 254 | 834 | 1221 |
ESP | Spain | parliament | 1993-06-06 | 0.62 | 1 | 350 | PAR | Partido Aragonés Regionalista | Aragonese Regionalist Party | 7.1909 | 27 | 252 | 289 | 37 | 1221 |
ISL | Iceland | parliament | 1987-04-25 | 1.2 | 1 | 63 | Sjf | Samtök um jatnrétti og félagshyggju | Association for Equality and Justice | 5.3 | 56 | 673 | 114 | 393 | 817 |
SVK | Slovakia | parliament | 1994-10-01 | 7.35 | 13 | 150 | ZRS | Združenie robotníkov Slovenska | Association of Workers of Slovakia | 1.3 | 1 | 119 | 294 | 817 | 1563 |
SVK | Slovakia | parliament | 1998-09-26 | 1.3 | 0 | 150 | ZRS | Združenie robotníkov Slovenska | Association of Workers of Slovakia | 1.3 | 1 | 349 | 119 | 26 | 1563 |
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 | |
BGR | Bulgaria | parliament | 2005-06-25 | 8.14 | 21 | 240 | Ataka | Ataka | Attack | 5.46 | 10 | 618 | 681 | 575 | 535 |
BGR | Bulgaria | ep | 2007-01-01 | 1 | 18 | Ataka | Ataka | Attack | 5.46 | 10 | 449 | 618 | 425 | 535 | |
BGR | Bulgaria | ep | 2007-05-20 | 14.2 | 3 | 18 | Ataka | Ataka | Attack | 5.46 | 10 | 468 | 618 | 425 | 535 |
BGR | Bulgaria | ep | 2009-06-07 | 11.96 | 2 | 17 | Ataka | Ataka | Attack | 5.46 | 10 | 432 | 618 | 425 | 535 |
BGR | Bulgaria | parliament | 2009-07-05 | 9.36 | 21 | 240 | Ataka | Ataka | Attack | 5.46 | 10 | 79 | 618 | 425 | 535 |
BGR | Bulgaria | parliament | 2013-05-12 | 7.297 | 23 | 240 | Ataka | Ataka | Attack | 5.46 | 10 | 799 | 79 | 1045 | 535 |
BGR | Bulgaria | ep | 2014-05-25 | 2.957 | 0 | 17 | Ataka | Ataka | Attack | 5.46 | 10 | 830 | 799 | 1058 | 535 |
BGR | Bulgaria | parliament | 2014-10-05 | 4.52 | 11 | 240 | Ataka | Ataka | Attack | 5.46 | 10 | 840 | 799 | 1139 | 535 |
BGR | Bulgaria | ep | 2019-05-26 | 1.07 | 0 | 17 | Ataka | Ataka | Attack | 5.46 | 10 | 1059 | 1011 | 1505 | 535 |
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 |
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 |
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;