view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by vote_share descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CYP | Cyprus | parliament | 1976-09-05 | 71.2 | 21 | 35 | DIKO | Dimokratikó Kómma | Democratic Party | 5.1316 | 51 | 528 | 851 | ||
LVA | Latvia | parliament | 1990-04-29 | 68.2 | 131 | 201 | LTF | Latvijas Tautas fronte | Popular Front of Latvia | 55 | 647 | 42 | |||
ROU | Romania | parliament | 1990-05-20 | 66.3 | 263 | 396 | PD | Partidul Democrat | Democratic Party | 5.3875 | 23 | 633 | 1604 | 419 | |
MLT | Malta | parliament | 1947-10-27 | 59.86 | 24 | 40 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 550 | 1003 | ||
JPN | Japan | parliament | 1958-05-22 | 59.0 | 298 | 467 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 645 | 692 | 887 | 1193 |
NZL | New Zealand | parliament | 1908-12-01 | 58.67 | 50 | 80 | NZLP | New Zealand Liberal Party | New Zealand Liberal Party | 6.0 | 11 | 972 | 973 | 1309 | 2469 |
ROU | Romania | parliament | 2012-12-09 | 58.63 | 150 | 412 | PSD | Partidul Social Democrat | Social Democratic Party | 3.2325 | 23 | 787 | 319 | 1033 | 1120 |
JPN | Japan | parliament | 1960-11-20 | 58.1 | 300 | 467 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 345 | 645 | 241 | 1193 |
CAN | Canada | parliament | 1917-12-17 | 57.0 | 153 | 235 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 862 | 863 | 1170 | 794 |
MLT | Malta | parliament | 1955-02-28 | 56.73 | 23 | 40 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 611 | 272 | 1473 | 1003 |
HUN | Hungary | ep | 2009-06-07 | 56.36 | 22 | Fi+KDNP | Fidesz – Magyar Polgári Szövetség / Kereszténydemokrata Néppárt | Fidesz -- Hungarian Civic Party / Christian Democratic People's Party | 6.5432 | 39 | 249 | 194 | 162 | 437 | |
CHE | Switzerland | parliament | 1914-10-25 | 56.15 | 112 | 189 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 978 | 979 | 1459 | 26 |
BEL | Belgium | parliament | 1902-05-25 | 56.0 | 54 | 85 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 869 | 868 | 1374 | 2423 |
JPN | Japan | parliament | 1963-11-21 | 56.0 | 294 | 467 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 640 | 345 | 48 | 1193 |
NZL | New Zealand | parliament | 1938-10-15 | 55.8 | 53 | 80 | LP | Labour Party | Labour Party | 4.483 | 11 | 960 | 959 | 1316 | 878 |
MLT | Malta | parliament | 2017-06-03 | 55.04 | 37 | 67 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 1010 | 790 | 1046 | 1003 |
GBR | United Kingdom | parliament | 1931-10-27 | 54.98 | 470 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 910 | 909 | 1290 | 773 |
MLT | Malta | parliament | 2013-03-09 | 54.83 | 39 | 69 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 790 | 203 | 468 | 1003 |
MLT | Malta | ep | 2009-06-06 | 54.77 | 3 | 5 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 555 | 203 | 468 | 1003 |
GRC | Greece | parliament | 1974-11-17 | 54.4 | 220 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 653 | 47 | ||
BEL | Belgium | parliament | 1906-05-27 | 54.3 | 50 | 85 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 871 | 870 | 1376 | 2423 |
MLT | Malta | ep | 2019-05-25 | 54.29 | 4 | 6 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 1066 | 1010 | 1504 | 1003 |
AUS | Australia | parliament | 1917-05-05 | 54.2 | 53 | 75 | NAT | Nationalist Party of Australia | Nationalist Party of Australia | 8.8 | 33 | 750 | 724 | 1008 | 1905 |
HUN | Hungary | parliament | 2022-04-03 | 54.13 | 199 | Fi+KDNP | Fidesz – Magyar Polgári Szövetség / Kereszténydemokrata Néppárt | Fidesz -- Hungarian Civic Party / Christian Democratic People's Party | 6.5432 | 39 | 1107 | 1023 | 1531 | 437 | |
NOR | Norway | parliament | 1900-07-01 | 54.0 | 77 | 114 | V | Venstre | Liberal Party of Norway | 5.1467 | 9 | 943 | 647 | ||
NZL | New Zealand | parliament | 1951-09-01 | 53.94 | 50 | 80 | NP | National Party | National Party | 6.7193 | 11 | 366 | 94 | 717 | 997 |
SWE | Sweden | parliament | 1940-09-15 | 53.8 | 134 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 971 | 970 | 1179 | 904 |
CAN | Canada | parliament | 1958-03-31 | 53.67 | 208 | 265 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 286 | 562 | 249 | 794 |
ISL | Iceland | parliament | 1923-10-27 | 53.6 | 23 | 40 | Sj | Sjálfstæðisflokkurinn | Independence Party | 7.4854 | 56 | 923 | 922 | 1425 | 1342 |
MLT | Malta | ep | 2014-05-25 | 53.39 | 3 | 6 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 836 | 790 | 1046 | 1003 |
NZL | New Zealand | parliament | 1905-12-06 | 53.12 | 58 | 80 | NZLP | New Zealand Liberal Party | New Zealand Liberal Party | 6.0 | 11 | 973 | 974 | 1325 | 2469 |
BEL | Belgium | parliament | 1910-05-22 | 53.1 | 49 | 85 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 873 | 872 | 1372 | 2423 |
LUX | Luxembourg | parliament | 1919-10-26 | 52.8 | 27 | 48 | PD | Rietspartei | Party of the Right | 7.4 | 7 | 930 | 2527 | ||
HUN | Hungary | parliament | 2010-04-25 | 52.73 | 386 | Fi+KDNP | Fidesz – Magyar Polgári Szövetség / Kereszténydemokrata Néppárt | Fidesz -- Hungarian Civic Party / Christian Democratic People's Party | 6.5432 | 39 | 688 | 194 | 162 | 437 | |
HUN | Hungary | ep | 2019-05-26 | 52.56 | 21 | Fi+KDNP | Fidesz – Magyar Polgári Szövetség / Kereszténydemokrata Néppárt | Fidesz -- Hungarian Civic Party / Christian Democratic People's Party | 6.5432 | 39 | 1076 | 1023 | 1531 | 437 | |
CAN | Canada | parliament | 1904-11-03 | 52.03 | 138 | 214 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 884 | 883 | 1466 | 368 |
IRL | Ireland | parliament | 1938-06-17 | 51.9 | 77 | 138 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 920 | 919 | 1443 | 280 |
NZL | New Zealand | parliament | 1949-11-30 | 51.88 | 46 | 80 | NP | National Party | National Party | 6.7193 | 11 | 94 | 586 | 474 | 997 |
MLT | Malta | parliament | 1998-09-05 | 51.81 | 35 | 65 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 173 | 483 | 299 | 984 |
MLT | Malta | parliament | 2003-04-12 | 51.79 | 35 | 65 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 509 | 173 | 582 | 984 |
MLT | Malta | parliament | 1992-02-22 | 51.77 | 34 | 65 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 520 | 370 | 3 | 984 |
NZL | New Zealand | parliament | 1902-11-25 | 51.77 | 47 | 80 | NZLP | New Zealand Liberal Party | New Zealand Liberal Party | 6.0 | 11 | 974 | 2469 | ||
PRT | Portugal | parliament | 1991-10-06 | 51.6 | 135 | 230 | PSD | Partido Social Democrata | Social Democratic Party | 6.2949 | 63 | 90 | 480 | 718 | 1273 |
CAN | Canada | parliament | 1940-03-26 | 51.54 | 181 | 245 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 854 | 857 | 1165 | 368 |
MLT | Malta | parliament | 1976-09-18 | 51.53 | 34 | 65 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 533 | 8 | 816 | 1003 |
HUN | Hungary | ep | 2014-05-25 | 51.48 | 21 | Fi+KDNP | Fidesz – Magyar Polgári Szövetség / Kereszténydemokrata Néppárt | Fidesz -- Hungarian Civic Party / Christian Democratic People's Party | 6.5432 | 39 | 827 | 814 | 1104 | 437 | |
PRT | Portugal | parliament | 1987-07-19 | 51.34 | 148 | 250 | PSD | Partido Social Democrata | Social Democratic Party | 6.2949 | 63 | 480 | 106 | 734 | 1273 |
NZL | New Zealand | parliament | 1946-11-27 | 51.28 | 42 | 80 | LP | Labour Party | Labour Party | 4.483 | 11 | 586 | 775 | 1036 | 878 |
CAN | Canada | parliament | 1900-11-07 | 51.24 | 133 | 213 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 883 | 368 | ||
AUT | Austria | parliament | 1979-05-06 | 51.0 | 95 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 452 | 221 | 350 | 973 |
BEL | Belgium | parliament | 1912-06-02 | 51.0 | 101 | 186 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 874 | 873 | 1285 | 2423 |
CAN | Canada | parliament | 1911-09-21 | 50.94 | 134 | 221 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 863 | 885 | 1468 | 794 |
MLT | Malta | parliament | 1981-12-12 | 50.92 | 31 | 65 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 136 | 533 | 606 | 984 |
CHE | Switzerland | parliament | 1908-10-25 | 50.91 | 105 | 167 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 980 | 981 | 1457 | 26 |
MLT | Malta | parliament | 1987-05-09 | 50.91 | 35 | 69 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 370 | 136 | 122 | 984 |
AUS | Australia | parliament | 1914-09-05 | 50.9 | 42 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 724 | 748 | 1004 | 1253 |
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 | 1996-10-26 | 50.7 | 35 | 69 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 483 | 520 | 881 | 1003 |
IRL | Ireland | parliament | 1977-06-16 | 50.63 | 84 | 148 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 6 | 283 | 315 | 280 |
CAN | Canada | parliament | 1908-10-26 | 50.45 | 135 | 221 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 885 | 884 | 1467 | 368 |
AUT | Austria | parliament | 1975-10-05 | 50.4 | 93 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 221 | 185 | 365 | 973 |
LUX | Luxembourg | parliament | 1922-05-28 | 50.4 | 26 | 48 | PD | Rietspartei | Party of the Right | 7.4 | 7 | 931 | 930 | 1448 | 2527 |
CHE | Switzerland | parliament | 1902-10-26 | 50.39 | 100 | 167 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 982 | 26 | ||
AUS | Australia | parliament | 1954-05-29 | 50.1 | 59 | 123 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 743 | 763 | 566 | 1253 |
SWE | Sweden | parliament | 1968-09-15 | 50.1 | 125 | 233 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 655 | 41 | 506 | 904 |
CAN | Canada | parliament | 1949-06-27 | 50.08 | 190 | 262 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 112 | 189 | 534 | 368 |
CAN | Canada | parliament | 1984-09-04 | 50.03 | 211 | 282 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 159 | 139 | 670 | 794 |
NZL | New Zealand | parliament | 2020-10-17 | 50.01 | 65 | 120 | LP | Labour Party | Labour Party | 4.483 | 11 | 1092 | 1018 | 1518 | 878 |
AUS | Australia | parliament | 1910-04-13 | 50.0 | 43 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 747 | 725 | 1002 | 1253 |
AUT | Austria | parliament | 1971-10-10 | 50.0 | 93 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 185 | 377 | 354 | 973 |
CAN | Canada | parliament | 1953-08-10 | 49.99 | 171 | 265 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 292 | 112 | 750 | 368 |
AUS | Australia | parliament | 1943-08-21 | 49.9 | 49 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 737 | 738 | 995 | 1253 |
TUR | Turkey | parliament | 2011-06-12 | 49.83 | 327 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 806 | 807 | 1076 | 901 |
AUT | Austria | parliament | 1945-11-25 | 49.8 | 85 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 402 | 1029 | 452 | 1013 |
AUS | Australia | parliament | 1946-09-28 | 49.7 | 43 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 739 | 737 | 574 | 1253 |
GBR | United Kingdom | parliament | 1955-05-26 | 49.7 | 630 | CNL | Conservatives and National Liberals | Conservatives and National Liberals | 7.8 | 44 | 678 | 102 | 729 | 1496 | |
IRL | Ireland | parliament | 1933-01-24 | 49.7 | 77 | 153 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 918 | 917 | 1441 | 280 |
AUS | Australia | parliament | 1972-12-02 | 49.6 | 67 | 125 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 759 | 735 | 671 | 1253 |
AUS | Australia | parliament | 1983-03-05 | 49.5 | 75 | 125 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 751 | 736 | 774 | 1253 |
CZE | Czech Republic | parliament | 1990-06-09 | 49.5 | 127 | 200 | OF | Obcanské fórum | Civic Forum | 6.0 | 68 | 63 | 743 | ||
TUR | Turkey | parliament | 2015-11-01 | 49.5 | 317 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 997 | 975 | 1173 | 901 |
CHE | Switzerland | parliament | 1911-10-29 | 49.47 | 114 | 189 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 979 | 980 | 1458 | 26 |
JPN | Japan | parliament | 1986-07-06 | 49.42 | 300 | 512 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 506 | 138 | 568 | 1193 |
GBR | United Kingdom | parliament | 1959-10-08 | 49.4 | 630 | CNL | Conservatives and National Liberals | Conservatives and National Liberals | 7.8 | 44 | 161 | 678 | 404 | 1496 | |
MLT | Malta | parliament | 2008-03-08 | 49.34 | 35 | 69 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 203 | 509 | 298 | 984 |
AUS | Australia | parliament | 1974-05-18 | 49.3 | 66 | 127 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 758 | 759 | 507 | 1253 |
HUN | Hungary | parliament | 2018-04-08 | 49.28 | 199 | Fi+KDNP | Fidesz – Magyar Polgári Szövetség / Kereszténydemokrata Néppárt | Fidesz -- Hungarian Civic Party / Christian Democratic People's Party | 6.5432 | 39 | 1023 | 814 | 1104 | 437 | |
CHE | Switzerland | parliament | 1905-10-29 | 49.25 | 104 | 167 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 981 | 982 | 1456 | 26 |
JPN | Japan | parliament | 1967-01-29 | 49.2 | 280 | 486 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 367 | 640 | 8 | 1193 |
BGR | Bulgaria | parliament | 1997-04-19 | 49.15 | 137 | 240 | ODS | Obedineni Demokratichni Sili | United Democratic Forces | 6.9611 | 10 | 126 | 355 | 714 | 784 |
MLT | Malta | parliament | 1981-12-12 | 49.07 | 34 | 65 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 136 | 533 | 606 | 1003 |
AUS | Australia | parliament | 1913-05-31 | 48.9 | 38 | 75 | CLP | Commonwealth Liberal Party | Commonwealth Liberal Party | 7.4 | 33 | 748 | 747 | 1003 | 2285 |
IRL | Ireland | parliament | 1944-05-30 | 48.9 | 76 | 138 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 122 | 921 | 1445 | 280 |
MLT | Malta | parliament | 1987-05-09 | 48.87 | 34 | 69 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 370 | 136 | 122 | 1003 |
CAN | Canada | parliament | 1930-07-28 | 48.83 | 137 | 245 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 858 | 859 | 1167 | 794 |
AUS | Australia | parliament | 1929-10-12 | 48.8 | 47 | 76 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 729 | 728 | 1014 | 1253 |
GBR | United Kingdom | parliament | 1951-10-25 | 48.8 | 295 | 625 | Lab | Labour Party | Labour | 4.3562 | 44 | 102 | 625 | 88 | 1556 |
MLT | Malta | parliament | 2008-03-08 | 48.79 | 34 | 69 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 203 | 509 | 298 | 1003 |
AUS | Australia | parliament | 1913-05-31 | 48.5 | 37 | 75 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 748 | 747 | 1003 | 1253 |
BEL | Belgium | parliament | 1900-05-27 | 48.5 | 86 | 152 | KP-PC | Katholieke Partij – Parti catholique | Catholic Party | 6.2 | 64 | 868 | 2423 |
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;