view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by election_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ITA | Italy | parliament | 1987-06-14 | 2.1 | 11 | 630 | PLI | Partito Liberale Italiano | Italian Liberal Party | 6.45 | 26 | 17 | 617 | 737 | 487 |
ITA | Italy | parliament | 1987-06-14 | 1.7 | 8 | 630 | DP | Democrazia Proletaria | Proletarian Democracy | 0.5 | 26 | 17 | 617 | 737 | 1424 |
ITA | Italy | parliament | 1987-06-14 | 0.52 | 3 | 630 | SVP | Südtiroler Volkspartei | South Tyrol Peoples Party | 5.4 | 26 | 17 | 617 | 737 | 1030 |
ITA | Italy | parliament | 1987-06-14 | 0.44 | 2 | 630 | PSA | Partito Sardo d'Azione | Sardinian Action Party | 4.2 | 26 | 17 | 617 | 737 | 335 |
ITA | Italy | parliament | 1987-06-14 | 0.48 | 1 | 630 | LL | Liga Lombarda | Lombard League | 26 | 17 | 617 | 737 | 1560 | |
ITA | Italy | parliament | 1987-06-14 | 0.11 | 1 | 630 | UV | Union Valdôtaine | Valdotanian Union | 26 | 17 | 617 | 737 | 974 | |
ITA | Italy | parliament | 1987-06-14 | 0.77 | 0 | 630 | LV | Liga Veneta | Venetian League | 26 | 17 | 617 | 737 | 1080 | |
DEU | Germany | ep | 2004-06-13 | 36.5 | 40 | 99 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 18 | 385 | 529 | 808 |
DEU | Germany | ep | 2004-06-13 | 21.5 | 23 | 99 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 18 | 385 | 529 | 558 |
DEU | Germany | ep | 2004-06-13 | 11.9 | 13 | 99 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 18 | 385 | 529 | 772 |
DEU | Germany | ep | 2004-06-13 | 8.0 | 9 | 99 | CSU | Christlich Soziale Union | Christian Social Union | 7.2871 | 54 | 18 | 385 | 529 | 1180 |
DEU | Germany | ep | 2004-06-13 | 6.1 | 7 | 99 | FDP | Freie Demokratische Partei | Free Democratic Party | 5.9233 | 54 | 18 | 385 | 529 | 543 |
DEU | Germany | ep | 2004-06-13 | 6.1 | 7 | 99 | PDS|Li | PDS | Die Linke | PDS | The Left | 1.2152 | 54 | 18 | 385 | 529 | 791 |
DEU | Germany | ep | 2004-06-13 | 1.9 | 0 | 99 | Rep | Die Republikaner | The Republicans | 9.2752 | 54 | 18 | 385 | 529 | 524 |
DEU | Germany | ep | 2004-06-13 | 1.3 | 0 | 99 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 18 | 385 | 529 | 301 | |
DEU | Germany | ep | 2004-06-13 | 1.2 | 0 | 99 | Grau | Die Grauen – Graue Panther | The Grays -- Gray Panthers | 54 | 18 | 385 | 529 | 292 | |
DEU | Germany | ep | 2004-06-13 | 1.0 | 0 | 99 | Fam | Familien-Partei Deutschlands | Family Party of Germany | 7.4 | 54 | 18 | 385 | 529 | 1235 |
BEL | Belgium | parliament | 1946-02-17 | 42.54 | 92 | 202 | PSC-CVP | Parti Social Chrétien – Christelijke Volkspartij | Francophone Christian Social Party and Flemish Christian People's Party | 6.2 | 64 | 19 | 882 | 204 | 1051 |
BEL | Belgium | parliament | 1946-02-17 | 31.6 | 66 | 202 | BSP-PSB | Belgische Socialistische Partij – Parti Socialiste Belge | Belgian Socialist Party | 2.5 | 64 | 19 | 882 | 204 | 167 |
BEL | Belgium | parliament | 1946-02-17 | 12.69 | 23 | 202 | KPB-PCB | Kommunistische Partij – Parti Communiste | Communist Party | 1.4 | 64 | 19 | 882 | 204 | 708 |
BEL | Belgium | parliament | 1946-02-17 | 8.9 | 16 | 202 | LP-PL | Liberale Partij – Parti libéral | Liberal Party | 6.0 | 64 | 19 | 882 | 204 | 63 |
BEL | Belgium | parliament | 1946-02-17 | 1.6 | 4 | 202 | KLS | Kartel Liberale en Socialistische | Cartel of Liberals and Socialists | 3.3 | 64 | 19 | 882 | 204 | 1335 |
BEL | Belgium | parliament | 1946-02-17 | 2.16 | 1 | 202 | UDB | Union Democratique Belge | Belgian Democratic Union | 64 | 19 | 882 | 204 | 1181 | |
BEL | Belgium | parliament | 1946-02-17 | 0.14 | 0 | 202 | no-seat | no seat | no seat | 64 | 19 | 882 | 204 | 2052 | |
FRA | France | parliament | 1981-06-21 | 36.0 | 268 | 474 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 20 | 496 | 1148 | 1539 |
FRA | France | parliament | 1981-06-21 | 20.7 | 80 | 474 | RPR | Rassemblement pour la république | Rally for the Republic | 7.4997 | 43 | 20 | 496 | 1148 | 138 |
FRA | France | parliament | 1981-06-21 | 2.2 | 59 | 474 | UDF|MD | Union pour la démocratie française | Mouvement démocrate | Union for French Democracy | Democratic Movement | 6.1017 | 43 | 20 | 496 | 1148 | 509 |
FRA | France | parliament | 1981-06-21 | 16.1 | 43 | 474 | PCF | Parti communiste française | French Communist Party | 1.3741 | 43 | 20 | 496 | 1148 | 686 |
FRA | France | parliament | 1981-06-21 | 1.1 | 14 | 474 | PRG | Parti radical de gauche | Radical Party of the Left | 4.0813 | 43 | 20 | 496 | 1148 | 1492 |
FRA | France | parliament | 1981-06-21 | 2.6 | 10 | 474 | CNIP | Centre national des indépendants et paysans | National Centre of Independents and Peasants [Conservatives] | 7.5636 | 43 | 20 | 496 | 1148 | 1414 |
FRA | France | parliament | 1981-06-21 | 10.6 | 0 | 474 | PR | Parti radical-socialiste | Radical Socialist Party | 3.9896 | 43 | 20 | 496 | 1148 | 401 |
FRA | France | parliament | 1981-06-21 | 5.3 | 0 | 474 | CDS | Centre des démocrates sociaux | Centre of Social Democrats | 6.2 | 43 | 20 | 496 | 1148 | 2265 |
FRA | France | parliament | 1981-06-21 | 1.1 | 0 | 474 | V | Les Verts | Greens | 3.155 | 43 | 20 | 496 | 1148 | 873 |
CHE | Switzerland | parliament | 1951-10-28 | 24.0 | 51 | 196 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 21 | 684 | 556 | 26 |
CHE | Switzerland | parliament | 1951-10-28 | 26.0 | 49 | 196 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 21 | 684 | 556 | 35 |
CHE | Switzerland | parliament | 1951-10-28 | 22.5 | 48 | 196 | KK/CVP | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Catholic Conservative / Christian Democratic Peoples Party | 4.7288 | 40 | 21 | 684 | 556 | 531 |
CHE | Switzerland | parliament | 1951-10-28 | 12.6 | 23 | 196 | SVP-UDC | Schweizerische Volkspartei – Union Démocratique du Centre | Swiss People's Party | 7.3575 | 40 | 21 | 684 | 556 | 750 |
CHE | Switzerland | parliament | 1951-10-28 | 5.1 | 10 | 196 | LdU-ADI | Landesring der Unabhängigen – Alliance des Indépendants | Independents Alliance | 3.3 | 40 | 21 | 684 | 556 | 1264 |
CHE | Switzerland | parliament | 1951-10-28 | 2.7 | 5 | 196 | PdA | Partei der Arbeit der Schweiz | Swiss Party of Labour | 0.5263 | 40 | 21 | 684 | 556 | 1167 |
CHE | Switzerland | parliament | 1951-10-28 | 2.6 | 5 | 196 | LPS | Liberale Partei der Schweiz – Parti liberal suisse | Liberal Party of Switzerland | 7.2961 | 40 | 21 | 684 | 556 | 458 |
CHE | Switzerland | parliament | 1951-10-28 | 2.2 | 4 | 196 | DG | Gruppe der Demokraten – Groupe des democrates | Democratic Group | 3.3 | 40 | 21 | 684 | 556 | 886 |
CHE | Switzerland | parliament | 1951-10-28 | 1.0 | 1 | 196 | EVP-PEP | Evangelische Volkspartei der Schweiz – Parti Populaire Evangelique Suisse | Protestant Peoples Party | 4.9248 | 40 | 21 | 684 | 556 | 602 |
CHE | Switzerland | parliament | 1951-10-28 | 0.83 | 0 | 196 | LF/PEB | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung – Parti d'économie franche | Liberal Socialist Party | 6.0 | 40 | 21 | 684 | 556 | 1960 |
AUT | Austria | ep | 1996-10-13 | 29.65 | 7 | 21 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 22 | 162 | 323 | 1013 |
AUT | Austria | ep | 1996-10-13 | 27.53 | 6 | 21 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 22 | 162 | 323 | 50 |
AUT | Austria | ep | 1996-10-13 | 29.15 | 6 | 21 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 22 | 162 | 323 | 973 |
AUT | Austria | ep | 1996-10-13 | 4.26 | 1 | 21 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 22 | 162 | 323 | 955 |
AUT | Austria | ep | 1996-10-13 | 6.81 | 1 | 21 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 22 | 162 | 323 | 1429 |
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 | |
NLD | Netherlands | ep | 1979-06-10 | 35.6 | 10 | 25 | CDA | Christen Democratisch Appèl | Christian Democratic Appeal | 5.9376 | 8 | 23 | 635 | 563 | 235 |
NLD | Netherlands | ep | 1979-06-10 | 30.39 | 9 | 25 | PvdA | Partij van de Arbeid | Labour Party | 3.6118 | 8 | 23 | 635 | 563 | 742 |
NLD | Netherlands | ep | 1979-06-10 | 16.14 | 4 | 25 | VVD | Volkspartij voor Vrijheid en Democratie | People's Party for Freedom and Democracy | 7.3482 | 8 | 23 | 635 | 563 | 1409 |
NLD | Netherlands | ep | 1979-06-10 | 9.03 | 2 | 25 | D66 | Democraten 66 | Democrats 66 | 4.5066 | 8 | 23 | 635 | 563 | 345 |
NLD | Netherlands | ep | 1979-06-10 | 1.72 | 0 | 25 | CPN | Communistische Partij Nederland | Communist Party of the Netherlands | 0.8 | 8 | 23 | 635 | 563 | 1194 |
NLD | Netherlands | ep | 1979-06-10 | 1.1 | 0 | 25 | GPV | Gereformeerd Politiek Verbond | Reformed Political League | 8.1444 | 8 | 23 | 635 | 563 | 625 |
NLD | Netherlands | ep | 1979-06-10 | 1.62 | 0 | 25 | PPR | Politieke Partij Radikalen | Radical Political Party | 1.6 | 8 | 23 | 635 | 563 | 342 |
NLD | Netherlands | ep | 1979-06-10 | 1.72 | 0 | 25 | PSP | Pacifistisch Socialistische Partij | Pacifist Socialist Party | 0.6 | 8 | 23 | 635 | 563 | 1452 |
NLD | Netherlands | ep | 1979-06-10 | 2.23 | 0 | 25 | SGP | Staatkundig Gereformeerde Partij | Political Reformed Party | 8.7531 | 8 | 23 | 635 | 563 | 1251 |
FIN | Finland | parliament | 1995-03-19 | 28.3 | 63 | 200 | SSDP | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti | Social Democratic Party of Finland | 3.5595 | 67 | 24 | 602 | 206 | 395 |
FIN | Finland | parliament | 1995-03-19 | 19.8 | 44 | 200 | KESK | Keskusta | Centre Party | 5.8027 | 67 | 24 | 602 | 206 | 94 |
FIN | Finland | parliament | 1995-03-19 | 17.9 | 39 | 200 | KOK | Kansallinen Kokoomus – Samlingspartiet | National Coalition Party | 7.2451 | 67 | 24 | 602 | 206 | 1118 |
FIN | Finland | parliament | 1995-03-19 | 11.2 | 22 | 200 | DL|VAS | Demokraattinen Liitto – Demokratiska Förbundet | Vasemmistoliitto – Vänsterförbundet | Democratic Union | Left Alliance | 2.1843 | 67 | 24 | 602 | 206 | 1292 |
FIN | Finland | parliament | 1995-03-19 | 5.1 | 11 | 200 | RKP-SFP | Ruotsalainen Kansanpuolue – Svenska Folkepartiet i Finland | Swedish People's Party | 6.3906 | 67 | 24 | 602 | 206 | 585 |
FIN | Finland | parliament | 1995-03-19 | 6.5 | 9 | 200 | VIHR | Vihreä Liitto – Gröna Förbundet | Green League | 3.6465 | 67 | 24 | 602 | 206 | 1062 |
FIN | Finland | parliament | 1995-03-19 | 3.0 | 7 | 200 | KD | Kristillisdemokraatit – Kristdemokraterna | Christian Democrats | 7.1884 | 67 | 24 | 602 | 206 | 1463 |
FIN | Finland | parliament | 1995-03-19 | 2.8 | 2 | 200 | NSP | Nuorsuomalaiset – Ungfinnarna | Young Finns | 6.0 | 67 | 24 | 602 | 206 | 1009 |
FIN | Finland | parliament | 1995-03-19 | 0.4 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 24 | 602 | 206 | 66 | |
FIN | Finland | parliament | 1995-03-19 | 1.3 | 1 | 200 | SP|P | Suomen Puolue | Perussuomalaiset | Finnish Party | True Finns | 6.6331 | 67 | 24 | 602 | 206 | 200 |
FIN | Finland | parliament | 1995-03-19 | 0.3 | 1 | 200 | Eko | Ekologinen puolue – Ekologiska partiet | Ecological Party | 4.75 | 67 | 24 | 602 | 206 | 1105 |
FIN | Finland | parliament | 1995-03-19 | 1.01 | 0 | 200 | VSL | Vapaan Suomen Liitto – Självständighetspartiet | League for Free Finland | 67 | 24 | 602 | 206 | 979 | |
JPN | Japan | parliament | 1990-02-18 | 46.16 | 275 | 512 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 25 | 506 | 106 | 1193 |
JPN | Japan | parliament | 1990-02-18 | 24.35 | 136 | 512 | JSP | Nihon Shakai-tō | Japan Socialist Party | 2.6344 | 5 | 25 | 506 | 106 | 940 |
JPN | Japan | parliament | 1990-02-18 | 7.98 | 45 | 512 | K | Kōmeitō | Komeito Party | 5.6871 | 5 | 25 | 506 | 106 | 837 |
JPN | Japan | parliament | 1990-02-18 | 7.32 | 21 | 512 | none | no party affiliation | no party affiliation | 5 | 25 | 506 | 106 | 905 | |
JPN | Japan | parliament | 1990-02-18 | 7.96 | 16 | 512 | JCP | Nihon Kyōsan-tō | Japan Communist Party | 1.148 | 5 | 25 | 506 | 106 | 1540 |
JPN | Japan | parliament | 1990-02-18 | 4.84 | 14 | 512 | DSP | Minshu Shakai-tō | Democratic Socialist Party | 6.1556 | 5 | 25 | 506 | 106 | 1053 |
JPN | Japan | parliament | 1990-02-18 | 0.86 | 4 | 512 | SDF | Shaminren | Socialist Democratic Federation | 3.3 | 5 | 25 | 506 | 106 | 86 |
JPN | Japan | parliament | 1990-02-18 | 0.43 | 1 | 512 | one-seat | one seat | one seat | 5 | 25 | 506 | 106 | 2297 | |
CZE | Czech Republic | parliament | 1998-06-20 | 32.31 | 74 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 27 | 301 | 76 | 789 |
CZE | Czech Republic | parliament | 1998-06-20 | 27.74 | 63 | 200 | ODS | Občanská demokratická strana | Civic Democratic Party | 7.3637 | 68 | 27 | 301 | 76 | 829 |
CZE | Czech Republic | parliament | 1998-06-20 | 11.03 | 24 | 200 | KSCM | Komunistická strana Cech a Moravy | Communist Party of Bohemia and Moravia | 0.7498 | 68 | 27 | 301 | 76 | 1173 |
CZE | Czech Republic | parliament | 1998-06-20 | 9.0 | 20 | 200 | KDU-CSL | Křesťanská a demokratická unie – Československá strana lidová | Christian Democratic Union -- People's Party | 5.8099 | 68 | 27 | 301 | 76 | 1245 |
CZE | Czech Republic | parliament | 1998-06-20 | 8.6 | 19 | 200 | US | Unie svobody | Freedom Union | 7.2204 | 68 | 27 | 301 | 76 | 688 |
CZE | Czech Republic | parliament | 1998-06-20 | 3.06 | 0 | 200 | DZJ | Důchodci za životní jistoty | Pensioners for a Secure Living | 3.3 | 68 | 27 | 301 | 76 | 77 |
CZE | Czech Republic | parliament | 1998-06-20 | 1.45 | 0 | 200 | DU | Demokratická unie | Democratic Union | 6.0 | 68 | 27 | 301 | 76 | 1616 |
CZE | Czech Republic | parliament | 1998-06-20 | 3.9 | 0 | 200 | SPR-RSC | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Rally for the Republic -- Republican Party of Czechoslovakia | 9.7778 | 68 | 27 | 301 | 76 | 872 |
CZE | Czech Republic | parliament | 1998-06-20 | 1.12 | 0 | 200 | SZ | Strana zelených | Green Party | 4.123 | 68 | 27 | 301 | 76 | 196 |
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 | ep | 2009-06-06 | 35.65 | 2 | 6 | DISY | Dimokratikós Sinayermós | Democratic Rally | 8.6842 | 51 | 28 | 556 | 289 | 1575 |
CYP | Cyprus | ep | 2009-06-06 | 9.85 | 1 | 6 | EDEK | Kinima Sosialdimokraton EDEK | Movement for Social Democracy EDEK | 3.2895 | 51 | 28 | 556 | 289 | 945 |
CYP | Cyprus | ep | 2009-06-06 | 12.28 | 1 | 6 | DIKO | Dimokratikó Kómma | Democratic Party | 5.1316 | 51 | 28 | 556 | 289 | 851 |
CYP | Cyprus | ep | 2009-06-06 | 1.5 | 0 | 6 | KOP | Kinima Oikologoi Perivallontistoi | Ecological and Environmental Movement | 5.7895 | 51 | 28 | 556 | 289 | 1621 |
CYP | Cyprus | ep | 2009-06-06 | 4.12 | 0 | 6 | EK | Evropaiko Komma | European Party | 6.0 | 51 | 28 | 556 | 289 | 491 |
CHE | Switzerland | parliament | 1955-10-30 | 27.0 | 53 | 196 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 30 | 21 | 814 | 35 |
CHE | Switzerland | parliament | 1955-10-30 | 23.3 | 50 | 196 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 30 | 21 | 814 | 26 |
CHE | Switzerland | parliament | 1955-10-30 | 23.2 | 47 | 196 | KK/CVP | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Catholic Conservative / Christian Democratic Peoples Party | 4.7288 | 40 | 30 | 21 | 814 | 531 |
CHE | Switzerland | parliament | 1955-10-30 | 12.1 | 22 | 196 | SVP-UDC | Schweizerische Volkspartei – Union Démocratique du Centre | Swiss People's Party | 7.3575 | 40 | 30 | 21 | 814 | 750 |
CHE | Switzerland | parliament | 1955-10-30 | 5.5 | 10 | 196 | LdU-ADI | Landesring der Unabhängigen – Alliance des Indépendants | Independents Alliance | 3.3 | 40 | 30 | 21 | 814 | 1264 |
CHE | Switzerland | parliament | 1955-10-30 | 2.2 | 5 | 196 | LPS | Liberale Partei der Schweiz – Parti liberal suisse | Liberal Party of Switzerland | 7.2961 | 40 | 30 | 21 | 814 | 458 |
CHE | Switzerland | parliament | 1955-10-30 | 2.2 | 4 | 196 | DG | Gruppe der Demokraten – Groupe des democrates | Democratic Group | 3.3 | 40 | 30 | 21 | 814 | 886 |
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;