view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_name
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ISR | Israel | parliament | 2003-01-28 | 1.2 | 0 | 120 | AlYa | Ale Yarok | Green Leaf | 2.5 | 34 | 719 | 718 | 1124 | 2323 |
ISR | Israel | parliament | 2013-01-22 | 1.15 | 0 | 120 | AlYa | Ale Yarok | Green Leaf | 2.5 | 34 | 815 | 721 | 1107 | 2323 |
ISR | Israel | parliament | 2015-03-17 | 1.12 | 0 | 120 | AlYa | Ale Yarok | Green Leaf | 2.5 | 34 | 852 | 815 | 1155 | 2323 |
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 | |
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 |
ROU | Romania | parliament | 2000-11-26 | 4.07 | 0 | 345 | ApR | Alianta pentru Romania | Alliance for Romania | 3.3 | 23 | 336 | 49 | 171 | 2040 |
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 | 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 |
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 | |
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 | |
ROU | Romania | parliament | 2020-12-06 | 9.08 | 33 | 330 | AUR | Alianța pentru Unirea Românilor | Alliance for the Unity of Romanians | 8.8 | 23 | 1093 | 1015 | 1626 | 2807 |
ITA | Italy | parliament | 1994-03-27 | 18 | 630 | AD | Alleanza Democratica | Democratic Alliance | 5.0 | 26 | 146 | 605 | 801 | 896 | |
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 |
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 |
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 |
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 | |
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 |
ITA | Italy | ep | 2004-06-12 | 1.23 | 1 | 78 | ASM | Alternativa Sociale Mussolini | Social Alternative Mussolini | 8.8 | 26 | 329 | 498 | 256 | 323 |
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 |
AUT | Austria | parliament | 1983-04-24 | 1.4 | 0 | 183 | ALO | Alternative Liste Österreichs | Alternative List Austria | 2.5 | 59 | 456 | 452 | 463 | 1739 |
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 |
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 |
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 |
ISL | Iceland | parliament | 1956-06-24 | 19.2 | 8 | 52 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 665 | 88 | 762 | 1360 |
ISL | Iceland | parliament | 1959-06-28 | 15.2 | 7 | 52 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 393 | 665 | 446 | 1360 |
ISL | Iceland | parliament | 1959-10-26 | 16.0 | 10 | 60 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 320 | 393 | 351 | 1360 |
ISL | Iceland | parliament | 1963-06-09 | 16.0 | 9 | 60 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 379 | 320 | 331 | 1360 |
ISL | Iceland | parliament | 1967-06-11 | 13.9 | 9 | 60 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 318 | 379 | 553 | 1360 |
ISL | Iceland | parliament | 1971-06-13 | 17.1 | 10 | 60 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 225 | 318 | 321 | 1360 |
ISL | Iceland | parliament | 1974-06-30 | 18.3 | 11 | 60 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 637 | 225 | 272 | 1360 |
ISL | Iceland | parliament | 1978-06-25 | 22.9 | 14 | 60 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 275 | 637 | 849 | 1360 |
ISL | Iceland | parliament | 1979-12-03 | 19.7 | 11 | 60 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 436 | 275 | 536 | 1360 |
ISL | Iceland | parliament | 1983-04-23 | 17.3 | 10 | 60 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 114 | 436 | 752 | 1360 |
ISL | Iceland | parliament | 1987-04-25 | 13.3 | 8 | 63 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 673 | 114 | 393 | 1360 |
ISL | Iceland | parliament | 1991-04-20 | 14.4 | 9 | 63 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 274 | 673 | 127 | 1360 |
ISL | Iceland | parliament | 1995-04-08 | 14.3 | 9 | 63 | Ab | Alþýðubandalagið | People's Alliance | 2.2222 | 56 | 82 | 274 | 640 | 1360 |
ISL | Iceland | parliament | 1919-11-15 | 6.8 | 0 | 40 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 922 | 228 |
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;