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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ITA | Italy | parliament | 1948-04-18 | 48.5 | 305 | 574 | DC | Democrazia Cristiana | Christian Democrats | 5.6611 | 26 | 467 | 503 | 501 | 1633 |
MLT | Malta | parliament | 1976-09-18 | 48.46 | 31 | 65 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 533 | 8 | 816 | 984 |
NZL | New Zealand | parliament | 1946-11-27 | 48.43 | 38 | 80 | NP | National Party | National Party | 6.7193 | 11 | 586 | 775 | 1036 | 997 |
MLT | Malta | ep | 2004-06-13 | 48.42 | 3 | 5 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 346 | 509 | 298 | 1003 |
AUT | Austria | parliament | 1970-03-01 | 48.4 | 81 | 165 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 377 | 608 | 561 | 973 |
GBR | United Kingdom | ep | 1979-06-10 | 48.4 | 60 | 81 | Con | Conservatives | Conservatives | 7.4261 | 44 | 37 | 243 | 273 | 773 |
NZL | New Zealand | parliament | 1972-11-25 | 48.37 | 55 | 87 | LP | Labour Party | Labour Party | 4.483 | 11 | 1 | 120 | 569 | 878 |
AUT | Austria | parliament | 1966-03-06 | 48.35 | 85 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 608 | 495 | 1035 | 1013 |
ESP | Spain | parliament | 1982-10-28 | 48.34 | 202 | 350 | PSOE | Partido Socialista Obrero Español | Spanish Socialist Workers Party | 3.7377 | 27 | 85 | 493 | 406 | 902 |
IRL | Ireland | parliament | 1957-03-05 | 48.33 | 78 | 147 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 469 | 584 | 626 | 280 |
NZL | New Zealand | parliament | 1957-11-30 | 48.31 | 41 | 80 | LP | Labour Party | Labour Party | 4.483 | 11 | 421 | 321 | 629 | 878 |
NOR | Norway | parliament | 1957-10-07 | 48.3 | 78 | 150 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 429 | 167 | 221 | 104 |
AUT | Austria | parliament | 1927-04-24 | 48.24 | 73 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 1028 | 1027 | 1546 | 1013 |
GRC | Greece | parliament | 1981-10-18 | 48.1 | 172 | 300 | PASOK | Panellinio Sosialistikó Kínima | Panhellenic Socialist Movement | 4.4968 | 41 | 227 | 596 | 531 | 1338 |
MLT | Malta | parliament | 1971-06-14 | 48.05 | 27 | 55 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 8 | 419 | 681 | 984 |
AUS | Australia | parliament | 1961-12-09 | 48.0 | 62 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 740 | 749 | 627 | 1253 |
GBR | United Kingdom | parliament | 1945-07-05 | 48.0 | 393 | 640 | Lab | Labour Party | Labour | 4.3562 | 44 | 609 | 911 | 1520 | 1556 |
GBR | United Kingdom | parliament | 1951-10-25 | 48.0 | 625 | CNL | Conservatives and National Liberals | Conservatives and National Liberals | 7.8 | 44 | 102 | 625 | 88 | 1496 | |
GBR | United Kingdom | parliament | 1966-03-31 | 48.0 | 364 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 583 | 223 | 760 | 1556 |
ISL | Iceland | parliament | 1933-07-16 | 48.0 | 20 | 42 | Sj | Sjálfstæðisflokkurinn | Independence Party | 7.4854 | 56 | 926 | 925 | 1431 | 1342 |
NZL | New Zealand | parliament | 1987-08-15 | 47.96 | 58 | 97 | LP | Labour Party | Labour Party | 4.483 | 11 | 322 | 56 | 121 | 878 |
JPN | Japan | parliament | 1952-10-01 | 47.9 | 240 | 466 | JLP | Nihon Jiyūtō | Japan Liberal Party | 7.4 | 5 | 694 | 695 | 895 | 1726 |
JPN | Japan | parliament | 1980-06-22 | 47.9 | 284 | 511 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 113 | 433 | 727 | 1193 |
MLT | Malta | parliament | 1966-03-28 | 47.89 | 28 | 50 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 419 | 658 | 589 | 984 |
NZL | New Zealand | parliament | 1990-10-27 | 47.82 | 67 | 97 | NP | National Party | National Party | 6.7193 | 11 | 350 | 322 | 571 | 997 |
MLT | Malta | parliament | 1996-10-26 | 47.8 | 34 | 69 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 483 | 520 | 881 | 984 |
SWE | Sweden | parliament | 1960-09-18 | 47.8 | 114 | 232 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 295 | 251 | 208 | 904 |
GBR | United Kingdom | parliament | 1935-11-14 | 47.72 | 387 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 911 | 910 | 1287 | 773 |
AUS | Australia | parliament | 1951-04-28 | 47.7 | 54 | 123 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 763 | 734 | 450 | 1253 |
CAN | Canada | parliament | 1911-09-21 | 47.69 | 82 | 221 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 863 | 885 | 1468 | 368 |
BEL | Belgium | parliament | 1950-06-04 | 47.68 | 108 | 212 | PSC-CVP | Parti Social Chrétien – Christelijke Volkspartij | Francophone Christian Social Party and Flemish Christian People's Party | 6.2 | 64 | 217 | 644 | 746 | 1051 |
IRL | Ireland | parliament | 1965-04-07 | 47.67 | 72 | 144 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 323 | 413 | 667 | 280 |
NZL | New Zealand | parliament | 1943-09-25 | 47.65 | 46 | 80 | LP | Labour Party | Labour Party | 4.483 | 11 | 775 | 960 | 1317 | 878 |
JPN | Japan | parliament | 1969-12-27 | 47.63 | 288 | 486 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 603 | 367 | 787 | 1193 |
AUT | Austria | parliament | 1983-04-24 | 47.6 | 90 | 183 | SPO | Sozialdemokratische Partei Österreichs | Social Democratic Party of Austria | 3.7293 | 59 | 456 | 452 | 463 | 973 |
NZL | New Zealand | parliament | 1960-11-26 | 47.59 | 46 | 80 | NP | National Party | National Party | 6.7193 | 11 | 666 | 421 | 869 | 997 |
PRT | Portugal | parliament | 1980-10-05 | 47.59 | 250 | AD | Aliança Democrática | Democratic Alliance | 6.0 | 63 | 281 | 248 | 549 | 1543 | |
MLT | Malta | parliament | 2003-04-12 | 47.51 | 30 | 65 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 509 | 173 | 582 | 1003 |
AUS | Australia | parliament | 1984-12-01 | 47.5 | 82 | 148 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 733 | 751 | 576 | 1253 |
NZL | New Zealand | parliament | 1975-11-29 | 47.44 | 55 | 87 | NP | National Party | National Party | 6.7193 | 11 | 459 | 1 | 413 | 997 |
CAN | Canada | parliament | 1900-11-07 | 47.41 | 80 | 213 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 883 | 794 | ||
HUN | Hungary | ep | 2004-06-13 | 47.4 | 12 | 24 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 224 | 463 | 302 | 921 |
NZL | New Zealand | parliament | 2011-11-26 | 47.31 | 59 | 121 | NP | National Party | National Party | 6.7193 | 11 | 776 | 660 | 251 | 997 |
SWE | Sweden | parliament | 1964-09-20 | 47.3 | 113 | 233 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 41 | 295 | 424 | 904 |
IRL | Ireland | parliament | 1982-02-18 | 47.26 | 81 | 166 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 228 | 47 | 335 | 280 |
AUS | Australia | parliament | 1914-09-05 | 47.2 | 32 | 75 | CLP | Commonwealth Liberal Party | Commonwealth Liberal Party | 7.4 | 33 | 724 | 748 | 1004 | 2285 |
GBR | United Kingdom | parliament | 1924-10-29 | 47.2 | 412 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 908 | 907 | 1292 | 773 |
NZL | New Zealand | parliament | 1925-11-04 | 47.18 | 55 | 80 | RP | Reform Party | Reform Party | 7.4 | 11 | 956 | 955 | 1313 | 2471 |
NZL | New Zealand | parliament | 1949-11-30 | 47.16 | 34 | 80 | LP | Labour Party | Labour Party | 4.483 | 11 | 94 | 586 | 474 | 878 |
DNK | Denmark | parliament | 1903-06-16 | 47.14 | 73 | 114 | V | Venstre | Liberal Party | 7.292 | 21 | 887 | 886 | 1365 | 1605 |
GRC | Greece | parliament | 1993-10-10 | 47.1 | 170 | 300 | PASOK | Panellinio Sosialistikó Kínima | Panhellenic Socialist Movement | 4.4968 | 41 | 654 | 284 | 362 | 1338 |
NZL | New Zealand | parliament | 1963-11-30 | 47.07 | 45 | 80 | NP | National Party | National Party | 6.7193 | 11 | 117 | 666 | 701 | 997 |
NZL | New Zealand | parliament | 2014-09-20 | 47.04 | 60 | 121 | NP | National Party | National Party | 6.7193 | 11 | 829 | 776 | 986 | 997 |
AUS | Australia | parliament | 1969-10-25 | 47.0 | 59 | 125 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 735 | 764 | 795 | 1253 |
MLT | Malta | parliament | 1998-09-05 | 46.97 | 30 | 65 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 173 | 483 | 299 | 1003 |
GRC | Greece | parliament | 1990-04-08 | 46.9 | 150 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 284 | 508 | 716 | 47 |
JPN | Japan | parliament | 1972-12-10 | 46.85 | 271 | 491 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 333 | 603 | 656 | 1193 |
NOR | Norway | parliament | 1961-09-11 | 46.8 | 74 | 150 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 622 | 429 | 61 | 104 |
NOR | Norway | parliament | 1953-10-12 | 46.66 | 77 | 150 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 167 | 478 | 487 | 104 |
TUR | Turkey | parliament | 2007-07-22 | 46.66 | 341 | 550 | AKP | Adalet ve Kalkınma Partisi | Justice and Development Party | 6.9873 | 20 | 807 | 808 | 1077 | 901 |
BEL | Belgium | parliament | 1958-06-01 | 46.5 | 104 | 212 | PSC-CVP | Parti Social Chrétien – Christelijke Volkspartij | Francophone Christian Social Party and Flemish Christian People's Party | 6.2 | 64 | 573 | 545 | 745 | 1051 |
MLT | Malta | parliament | 1992-02-22 | 46.5 | 31 | 65 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 520 | 370 | 3 | 1003 |
NOR | Norway | parliament | 1969-09-07 | 46.5 | 74 | 150 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 580 | 517 | 284 | 104 |
SWE | Sweden | parliament | 1944-09-17 | 46.5 | 115 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 485 | 971 | 1180 | 904 |
CAN | Canada | parliament | 1925-10-29 | 46.48 | 116 | 245 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 860 | 861 | 1168 | 794 |
CAN | Canada | parliament | 1904-11-03 | 46.44 | 75 | 214 | PCP | Progressive Conservative Party of Canada | Progressive Conservative Party of Canada | 6.7112 | 29 | 884 | 883 | 1466 | 794 |
GBR | United Kingdom | parliament | 1955-05-26 | 46.4 | 277 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 678 | 102 | 729 | 1556 |
GBR | United Kingdom | parliament | 1970-06-18 | 46.4 | 330 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 311 | 583 | 733 | 773 |
ITA | Italy | parliament | 1994-03-27 | 46.4 | 630 | CeD | Centro-destra | Centre Right | 7.4 | 26 | 146 | 605 | 801 | 67 | |
PRT | Portugal | parliament | 2005-02-20 | 46.4 | 121 | 230 | PS | Partido Socialista | Socialist Party | 4.0492 | 63 | 210 | 657 | 755 | 725 |
PRT | Portugal | ep | 2004-06-13 | 46.36 | 12 | 24 | PS | Partido Socialista | Socialist Party | 4.0492 | 63 | 140 | 657 | 381 | 725 |
IRL | Ireland | parliament | 1951-05-30 | 46.28 | 69 | 147 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 515 | 60 | 154 | 280 |
IRL | Ireland | parliament | 1973-02-28 | 46.24 | 69 | 144 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 283 | 641 | 863 | 280 |
GRC | Greece | parliament | 1989-11-05 | 46.2 | 148 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 508 | 205 | 721 | 47 |
ISR | Israel | parliament | 1969-10-28 | 46.2 | 56 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 710 | 709 | 938 | 244 |
SWE | Sweden | parliament | 1958-06-01 | 46.2 | 111 | 231 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 251 | 450 | 380 | 904 |
LVA | Latvia | ep | 2014-05-24 | 46.19 | 4 | 8 | V | Vienotība | Unity | 7.4 | 55 | 848 | 765 | 1073 | 1666 |
JPN | Japan | parliament | 1990-02-18 | 46.16 | 275 | 512 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 25 | 506 | 106 | 1193 |
DNK | Denmark | parliament | 1935-10-22 | 46.1 | 68 | 148 | Sd | Socialdemokraterne | Social Democrats | 3.8011 | 21 | 899 | 898 | 1243 | 1629 |
GBR | United Kingdom | parliament | 1950-02-23 | 46.1 | 315 | 625 | Lab | Labour Party | Labour | 4.3562 | 44 | 625 | 609 | 99 | 1556 |
SWE | Sweden | parliament | 1948-09-19 | 46.1 | 112 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 431 | 485 | 628 | 904 |
CAN | Canada | parliament | 1926-09-14 | 46.07 | 128 | 245 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 859 | 860 | 1168 | 368 |
AUS | Australia | parliament | 1949-12-10 | 46.0 | 48 | 123 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 734 | 739 | 490 | 1253 |
AUT | Austria | parliament | 1956-05-13 | 46.0 | 82 | 165 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 169 | 11 | 659 | 1013 |
LUX | Luxembourg | parliament | 1931-06-07 | 46.0 | 26 | 54 | PD | Rietspartei | Party of the Right | 7.4 | 7 | 934 | 933 | 1450 | 2527 |
SWE | Sweden | parliament | 1952-09-21 | 46.0 | 110 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 234 | 431 | 361 | 904 |
SWE | Sweden | parliament | 1936-09-20 | 45.9 | 112 | 230 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 970 | 969 | 1182 | 904 |
NZL | New Zealand | parliament | 1951-09-01 | 45.87 | 30 | 80 | LP | Labour Party | Labour Party | 4.483 | 11 | 366 | 94 | 717 | 878 |
AUS | Australia | parliament | 1987-07-11 | 45.8 | 86 | 148 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 732 | 733 | 401 | 1253 |
DEU | Germany | parliament | 1972-11-19 | 45.8 | 230 | 496 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 95 | 447 | 358 | 558 |
GRC | Greece | parliament | 1985-06-02 | 45.8 | 161 | 300 | PASOK | Panellinio Sosialistikó Kínima | Panhellenic Socialist Movement | 4.4968 | 41 | 453 | 227 | 713 | 1338 |
ISL | Iceland | parliament | 1919-11-15 | 45.8 | 16 | 40 | He | Heimastjórnarflokkurinn | Home Rule Party | 6.0 | 56 | 922 | 2440 | ||
JPN | Japan | parliament | 1983-12-18 | 45.76 | 250 | 511 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 138 | 113 | 242 | 1193 |
NZL | New Zealand | parliament | 1935-11-27 | 45.73 | 53 | 80 | LP | Labour Party | Labour Party | 4.483 | 11 | 959 | 958 | 1319 | 878 |
NOR | Norway | parliament | 1949-10-10 | 45.69 | 85 | 150 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 478 | 220 | 58 | 104 |
IRL | Ireland | parliament | 1969-06-18 | 45.66 | 75 | 144 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 641 | 323 | 602 | 280 |
LUX | Luxembourg | parliament | 1937-06-06 | 45.6 | 25 | 55 | PD | Rietspartei | Party of the Right | 7.4 | 7 | 936 | 935 | 1451 | 2527 |
SWE | Sweden | parliament | 1982-09-19 | 45.6 | 166 | 349 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 175 | 473 | 142 | 904 |
AUS | Australia | parliament | 1963-11-30 | 45.5 | 52 | 124 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 741 | 740 | 288 | 1253 |
CAN | Canada | parliament | 1968-06-25 | 45.5 | 155 | 264 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 91 | 282 | 565 | 368 |
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;