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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NZL | New Zealand | parliament | 1972-11-25 | 48.37 | 55 | 87 | LP | Labour Party | Labour Party | 4.483 | 11 | 1 | 120 | 569 | 878 |
NZL | New Zealand | parliament | 1972-11-25 | 41.5 | 32 | 87 | NP | National Party | National Party | 6.7193 | 11 | 1 | 120 | 569 | 997 |
NZL | New Zealand | parliament | 1972-11-25 | 6.65 | 0 | 87 | SC|DP | Social Credit | Democratic Party | Social Credit | Democratic Party | 5.6 | 11 | 1 | 120 | 569 | 1636 |
NZL | New Zealand | parliament | 1972-11-25 | 1.96 | 0 | 87 | VP | Values Party | Values Party | 2.5 | 11 | 1 | 120 | 569 | 1761 |
BEL | Belgium | parliament | 1999-06-13 | 14.3 | 23 | 150 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 2 | 332 | 95 | 1110 |
BEL | Belgium | parliament | 1999-06-13 | 14.09 | 22 | 150 | CVP|CD&V | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Flemish Christian Peoples Party | Christian Democrats & Flemish | 5.7667 | 64 | 2 | 332 | 95 | 723 |
BEL | Belgium | parliament | 1999-06-13 | 10.16 | 19 | 150 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 2 | 332 | 95 | 1378 |
BEL | Belgium | parliament | 1999-06-13 | 10.14 | 18 | 150 | PRL | Parti Réformateur Libéral | Liberal Reformist Party | 6.8551 | 64 | 2 | 332 | 95 | 454 |
BEL | Belgium | parliament | 1999-06-13 | 9.87 | 15 | 150 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 2 | 332 | 95 | 993 |
BEL | Belgium | parliament | 1999-06-13 | 9.55 | 14 | 150 | SP | Socialistische Partij | Socialist Party | 3.2459 | 64 | 2 | 332 | 95 | 1029 |
BEL | Belgium | parliament | 1999-06-13 | 7.3 | 11 | 150 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 2 | 332 | 95 | 161 |
BEL | Belgium | parliament | 1999-06-13 | 5.88 | 10 | 150 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 2 | 332 | 95 | 1192 |
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 | parliament | 1999-06-13 | 5.56 | 8 | 150 | VU | Volksunie | People's Union | 6.5321 | 64 | 2 | 332 | 95 | 290 |
BEL | Belgium | parliament | 1999-06-13 | 1.45 | 1 | 150 | FN | Front National | National Front | 9.655 | 64 | 2 | 332 | 95 | 171 |
BEL | Belgium | parliament | 1999-06-13 | 2.1 | 0 | 150 | V | Vivant | Alive | 6.0 | 64 | 2 | 332 | 95 | 620 |
NOR | Norway | parliament | 2005-09-12 | 32.7 | 61 | 169 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 3 | 328 | 300 | 104 |
NOR | Norway | parliament | 2005-09-12 | 22.1 | 38 | 169 | Fr | Fremskrittspartiet | Progress Party | 8.7595 | 9 | 3 | 328 | 300 | 351 |
NOR | Norway | parliament | 2005-09-12 | 14.1 | 23 | 169 | H | Høyre | Conservative Party | 7.8994 | 9 | 3 | 328 | 300 | 1435 |
NOR | Norway | parliament | 2005-09-12 | 8.8 | 15 | 169 | SV | Sosialistisk Venstreparti | Socialist Left Party | 1.5839 | 9 | 3 | 328 | 300 | 81 |
NOR | Norway | parliament | 2005-09-12 | 6.8 | 11 | 169 | KrF | Kristelig Folkeparti | Christian Democratic Party | 5.8516 | 9 | 3 | 328 | 300 | 1538 |
NOR | Norway | parliament | 2005-09-12 | 6.5 | 11 | 169 | Sp | Senterpartiet | Centre Party | 4.6565 | 9 | 3 | 328 | 300 | 702 |
NOR | Norway | parliament | 2005-09-12 | 5.9 | 10 | 169 | V | Venstre | Liberal Party of Norway | 5.1467 | 9 | 3 | 328 | 300 | 647 |
NOR | Norway | parliament | 2005-09-12 | 1.2 | 0 | 169 | RV | Rød Valgallianse | Red Electoral Alliance | 0.4089 | 9 | 3 | 328 | 300 | 1638 |
ROU | Romania | ep | 2007-01-01 | 12 | 35 | PSD | Partidul Social Democrat | Social Democratic Party | 3.2325 | 23 | 4 | 165 | 28 | 1120 | |
ROU | Romania | ep | 2007-01-01 | 6 | 35 | PNL | Partidul Naţional Liberal | National Liberal Party | 6.0543 | 23 | 4 | 165 | 28 | 1015 | |
ROU | Romania | ep | 2007-01-01 | 5 | 35 | PD | Partidul Democrat | Democratic Party | 5.3875 | 23 | 4 | 165 | 28 | 419 | |
ROU | Romania | ep | 2007-01-01 | 5 | 35 | PRM | Partidul România Mare | Greater Romania Party | 6.6618 | 23 | 4 | 165 | 28 | 713 | |
ROU | Romania | ep | 2007-01-01 | 3 | 35 | UDMR | Uniunea Democrată Maghiară din România | Democratic Union of Hungarians in Romania | 6.016 | 23 | 4 | 165 | 28 | 948 | |
ROU | Romania | ep | 2007-01-01 | 2 | 35 | PU|PC | Partidul Umanist | Partidul Conservator | Humanist Party | Conservative Party | 4.7622 | 23 | 4 | 165 | 28 | 5 | |
ROU | Romania | ep | 2007-01-01 | 1 | 35 | none | no party affiliation | no party affiliation | 23 | 4 | 165 | 28 | 761 | ||
ROU | Romania | ep | 2007-01-01 | 1 | 35 | etnice | Partidele minorităţilor etnice din România | Romanian ethnic minorities parties | 23 | 4 | 165 | 28 | 425 | ||
PRT | Portugal | ep | 2009-06-07 | 33.95 | 8 | 22 | PSD | Partido Social Democrata | Social Democratic Party | 6.2949 | 63 | 5 | 210 | 169 | 1273 |
PRT | Portugal | ep | 2009-06-07 | 28.41 | 7 | 22 | PS | Partido Socialista | Socialist Party | 4.0492 | 63 | 5 | 210 | 169 | 725 |
PRT | Portugal | ep | 2009-06-07 | 11.48 | 3 | 22 | BE | Bloco de Esquerda | Bloc of the Left | 1.6425 | 63 | 5 | 210 | 169 | 557 |
PRT | Portugal | ep | 2009-06-07 | 2 | 22 | PCP | Partido Comunista Português | Portuguese Communist Party | 2.1754 | 63 | 5 | 210 | 169 | 514 | |
PRT | Portugal | ep | 2009-06-07 | 8.95 | 2 | 22 | CDS-PP | Centro Democrático e Social – Partido Popular | Democratic and Social Centre -- People's Party | 8.0222 | 63 | 5 | 210 | 169 | 251 |
PRT | Portugal | ep | 2009-06-07 | 1.29 | 0 | 22 | PCTP/MRPP | Comunista dos Trabalhadores Portugueses / Movimento Reorganizativo do Partido do Proletariado | Communist Party of the Portuguese Workers / Reorganizative Movement of the Party of the Proletariat | 1.3 | 63 | 5 | 210 | 169 | 281 |
PRT | Portugal | ep | 2009-06-07 | 11.39 | 0 | 22 | CDU | Coligação Democrático Unitária | Unified Democratic Coalition | 2.2233 | 63 | 5 | 210 | 169 | 1295 |
PRT | Portugal | ep | 2009-06-07 | 1.65 | 0 | 22 | MEP | Movimento Esperança Portugal | Hope for Portugal Movement | 6.0 | 63 | 5 | 210 | 169 | 925 |
IRL | Ireland | parliament | 1977-06-16 | 50.63 | 84 | 148 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 6 | 283 | 315 | 280 |
IRL | Ireland | parliament | 1977-06-16 | 30.49 | 43 | 148 | FG | Fine Gael | Fine Gael (Familiy of the Irish) | 6.4372 | 37 | 6 | 283 | 315 | 1393 |
IRL | Ireland | parliament | 1977-06-16 | 11.63 | 17 | 148 | Lab | Labour Party | Labour Party | 3.6252 | 37 | 6 | 283 | 315 | 318 |
IRL | Ireland | parliament | 1977-06-16 | 4 | 148 | none | no party affiliation | no party affiliation | 37 | 6 | 283 | 315 | 30 | ||
IRL | Ireland | parliament | 1977-06-16 | 1.7 | 0 | 148 | SFWP | Sinn Féin The Workers' Party | Sinn Fein The Workers' Party | 1.3 | 37 | 6 | 283 | 315 | 433 |
MLT | Malta | parliament | 1971-06-14 | 50.84 | 28 | 55 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 8 | 419 | 681 | 1003 |
MLT | Malta | parliament | 1971-06-14 | 48.05 | 27 | 55 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 8 | 419 | 681 | 984 |
MLT | Malta | parliament | 1971-06-14 | 1.04 | 0 | 55 | PKP | Partit Kostituzzjonali Progressiv | Progressive Constitutionalist Party | 7.4 | 72 | 8 | 419 | 681 | 217 |
BEL | Belgium | ep | 1984-06-17 | 13.32 | 5 | 24 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 10 | 501 | 724 | 1378 |
BEL | Belgium | ep | 1984-06-17 | 17.12 | 4 | 24 | SP | Socialistische Partij | Socialist Party | 3.2459 | 64 | 10 | 501 | 724 | 1029 |
BEL | Belgium | ep | 1984-06-17 | 19.8 | 4 | 24 | CVP|CD&V | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Flemish Christian Peoples Party | Christian Democrats & Flemish | 5.7667 | 64 | 10 | 501 | 724 | 723 |
BEL | Belgium | ep | 1984-06-17 | 9.45 | 3 | 24 | PRL | Parti Réformateur Libéral | Liberal Reformist Party | 6.8551 | 64 | 10 | 501 | 724 | 454 |
BEL | Belgium | ep | 1984-06-17 | 8.64 | 2 | 24 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 10 | 501 | 724 | 1110 |
BEL | Belgium | ep | 1984-06-17 | 7.62 | 2 | 24 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 10 | 501 | 724 | 1192 |
BEL | Belgium | ep | 1984-06-17 | 8.47 | 2 | 24 | VU | Volksunie | People's Union | 6.5321 | 64 | 10 | 501 | 724 | 290 |
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 | ep | 1984-06-17 | 3.86 | 1 | 24 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 10 | 501 | 724 | 161 |
BEL | Belgium | ep | 1984-06-17 | 1.28 | 0 | 24 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 10 | 501 | 724 | 993 |
BEL | Belgium | ep | 1984-06-17 | 1.53 | 0 | 24 | KPB-PCB | Kommunistische Partij – Parti Communiste | Communist Party | 1.4 | 64 | 10 | 501 | 724 | 708 |
BEL | Belgium | ep | 1984-06-17 | 2.5 | 0 | 24 | FDF | Front Démocratique des Francophones | DéFI | Francophone Democratic Front | 6.1259 | 64 | 10 | 501 | 724 | 969 |
AUT | Austria | parliament | 1953-02-22 | 41.3 | 74 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 11 | 67 | 560 | 1013 |
AUT | Austria | parliament | 1953-02-22 | 42.1 | 73 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 11 | 67 | 560 | 973 |
AUT | Austria | parliament | 1953-02-22 | 10.9 | 14 | 165 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 11 | 67 | 560 | 50 |
AUT | Austria | parliament | 1953-02-22 | 5.3 | 4 | 165 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 11 | 67 | 560 | 769 |
AUT | Austria | parliament | 1953-02-22 | 0.13 | 0 | 165 | no-seat | no seat | no seat | 59 | 11 | 67 | 560 | 2055 | |
AUT | Austria | ep | 1995-01-01 | 8 | 21 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 13 | 66 | 294 | 973 | |
AUT | Austria | ep | 1995-01-01 | 6 | 21 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 13 | 66 | 294 | 1013 | |
AUT | Austria | ep | 1995-01-01 | 5 | 21 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 13 | 66 | 294 | 50 | |
AUT | Austria | ep | 1995-01-01 | 1 | 21 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 13 | 66 | 294 | 955 | |
AUT | Austria | ep | 1995-01-01 | 1 | 21 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 13 | 66 | 294 | 1429 | |
PRT | Portugal | ep | 1994-06-12 | 35.99 | 10 | 25 | PS | Partido Socialista | Socialist Party | 4.0492 | 63 | 14 | 90 | 282 | 725 |
PRT | Portugal | ep | 1994-06-12 | 35.49 | 9 | 25 | PSD | Partido Social Democrata | Social Democratic Party | 6.2949 | 63 | 14 | 90 | 282 | 1273 |
PRT | Portugal | ep | 1994-06-12 | 12.85 | 3 | 25 | CDS-PP | Centro Democrático e Social – Partido Popular | Democratic and Social Centre -- People's Party | 8.0222 | 63 | 14 | 90 | 282 | 251 |
PRT | Portugal | ep | 1994-06-12 | 11.55 | 3 | 25 | CDU | Coligação Democrático Unitária | Unified Democratic Coalition | 2.2233 | 63 | 14 | 90 | 282 | 1295 |
PRT | Portugal | ep | 1994-06-12 | 0.81 | 0 | 25 | PCTP/MRPP | Comunista dos Trabalhadores Portugueses / Movimento Reorganizativo do Partido do Proletariado | Communist Party of the Portuguese Workers / Reorganizative Movement of the Party of the Proletariat | 1.3 | 63 | 14 | 90 | 282 | 281 |
FIN | Finland | parliament | 1999-03-21 | 22.9 | 51 | 200 | SSDP | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti | Social Democratic Party of Finland | 3.5595 | 67 | 15 | 24 | 100 | 395 |
FIN | Finland | parliament | 1999-03-21 | 22.4 | 48 | 200 | KESK | Keskusta | Centre Party | 5.8027 | 67 | 15 | 24 | 100 | 94 |
FIN | Finland | parliament | 1999-03-21 | 21.0 | 46 | 200 | KOK | Kansallinen Kokoomus – Samlingspartiet | National Coalition Party | 7.2451 | 67 | 15 | 24 | 100 | 1118 |
FIN | Finland | parliament | 1999-03-21 | 10.9 | 20 | 200 | DL|VAS | Demokraattinen Liitto – Demokratiska Förbundet | Vasemmistoliitto – Vänsterförbundet | Democratic Union | Left Alliance | 2.1843 | 67 | 15 | 24 | 100 | 1292 |
FIN | Finland | parliament | 1999-03-21 | 5.1 | 11 | 200 | RKP-SFP | Ruotsalainen Kansanpuolue – Svenska Folkepartiet i Finland | Swedish People's Party | 6.3906 | 67 | 15 | 24 | 100 | 585 |
FIN | Finland | parliament | 1999-03-21 | 7.3 | 11 | 200 | VIHR | Vihreä Liitto – Gröna Förbundet | Green League | 3.6465 | 67 | 15 | 24 | 100 | 1062 |
FIN | Finland | parliament | 1999-03-21 | 4.2 | 10 | 200 | KD | Kristillisdemokraatit – Kristdemokraterna | Christian Democrats | 7.1884 | 67 | 15 | 24 | 100 | 1463 |
FIN | Finland | parliament | 1999-03-21 | 1.0 | 1 | 200 | SP|P | Suomen Puolue | Perussuomalaiset | Finnish Party | True Finns | 6.6331 | 67 | 15 | 24 | 100 | 200 |
FIN | Finland | parliament | 1999-03-21 | 0.4 | 1 | 200 | AS | Åländsk Samling | Aland Coalition | 67 | 15 | 24 | 100 | 66 | |
FIN | Finland | parliament | 1999-03-21 | 1.1 | 1 | 200 | Rt | Remonttiryhmä | Reform Group | 6.6 | 67 | 15 | 24 | 100 | 638 |
FIN | Finland | parliament | 1999-03-21 | 1.0 | 0 | 200 | NSP | Nuorsuomalaiset – Ungfinnarna | Young Finns | 6.0 | 67 | 15 | 24 | 100 | 1009 |
AUT | Austria | ep | 1999-06-13 | 31.71 | 7 | 21 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 16 | 162 | 412 | 973 |
AUT | Austria | ep | 1999-06-13 | 30.67 | 7 | 21 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 16 | 162 | 412 | 1013 |
AUT | Austria | ep | 1999-06-13 | 23.4 | 5 | 21 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 16 | 162 | 412 | 50 |
AUT | Austria | ep | 1999-06-13 | 9.29 | 2 | 21 | Gruene | Die Grünen – Die Grüne Alternative | The Greens -- The Green Alternative | 2.4604 | 59 | 16 | 162 | 412 | 1429 |
AUT | Austria | ep | 1999-06-13 | 2.66 | 0 | 21 | LIF | Liberales Forum | Liberal Forum | 4.8806 | 59 | 16 | 162 | 412 | 955 |
AUT | Austria | ep | 1999-06-13 | 1.54 | 0 | 21 | CSA | Christlich Soziale Allianz (Liste Karl Habsburg) | Christian Social Alliance (Karl Habsburg List) | 6.2 | 59 | 16 | 162 | 412 | 1752 |
ITA | Italy | parliament | 1987-06-14 | 34.3 | 234 | 630 | DC | Democrazia Cristiana | Christian Democrats | 5.6611 | 26 | 17 | 617 | 737 | 1633 |
ITA | Italy | parliament | 1987-06-14 | 26.6 | 177 | 630 | PCI | Partito Comunista Italiano | Communist Party | 1.6 | 26 | 17 | 617 | 737 | 1088 |
ITA | Italy | parliament | 1987-06-14 | 14.3 | 94 | 630 | PSI | Partito Socialista Italiano | Italian Socialist Party | 3.7722 | 26 | 17 | 617 | 737 | 1475 |
ITA | Italy | parliament | 1987-06-14 | 5.9 | 35 | 630 | MSI | Movimento Sociale Italiano | Italian Social Movement | 9.1778 | 26 | 17 | 617 | 737 | 831 |
ITA | Italy | parliament | 1987-06-14 | 3.7 | 21 | 630 | PRI | Partito Repubblicano Italiano | Republican Party | 4.9704 | 26 | 17 | 617 | 737 | 93 |
ITA | Italy | parliament | 1987-06-14 | 3.0 | 17 | 630 | PSDI | Partito Socialista Democratico Italiano | Italian Democratic Socialist Party | 4.6206 | 26 | 17 | 617 | 737 | 242 |
ITA | Italy | parliament | 1987-06-14 | 2.6 | 13 | 630 | R | Radicali | Radicals | 3.9732 | 26 | 17 | 617 | 737 | 1296 |
ITA | Italy | parliament | 1987-06-14 | 2.5 | 13 | 630 | FdLV | Federazione delle Liste Verdi | Green Lists | 1.7778 | 26 | 17 | 617 | 737 | 1304 |
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;