view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_name_short 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUS | Australia | parliament | 1901-03-30 | 0.6 | 1 | 75 | one-seat | one seat | one seat | 33 | 731 | 2299 | |||
AUS | Australia | parliament | 1903-12-16 | 0.5 | 1 | 75 | one-seat | one seat | one seat | 33 | 730 | 731 | 997 | 2299 | |
AUS | Australia | parliament | 1937-10-23 | 0.7 | 1 | 75 | one-seat | one seat | one seat | 33 | 745 | 746 | 1017 | 2299 | |
AUS | Australia | parliament | 1940-09-21 | 0.8 | 1 | 75 | one-seat | one seat | one seat | 33 | 738 | 745 | 1021 | 2299 | |
AUT | Austria | parliament | 1919-02-16 | 1.49 | 4 | 170 | one-seat | one-seat | one-seat | 59 | 1030 | 2686 | |||
AUT | Austria | parliament | 1920-10-17 | 1.44 | 1 | 183 | one-seat | one-seat | one-seat | 59 | 1026 | 1030 | 1537 | 2686 | |
BEL | Belgium | parliament | 1904-05-29 | 2.9 | 1 | 81 | one-seat | one seat | one seat | 64 | 870 | 869 | 1376 | 2300 | |
BEL | Belgium | parliament | 1919-11-16 | 2.4 | 4 | 186 | one-seat | one seat | one seat | 64 | 876 | 875 | 1281 | 2300 | |
BEL | Belgium | parliament | 1921-11-20 | 0.5 | 1 | 186 | one-seat | one seat | one seat | 64 | 877 | 876 | 1279 | 2300 | |
BEL | Belgium | parliament | 1929-05-25 | 1.9 | 6 | 187 | one-seat | one seat | one seat | 64 | 879 | 878 | 1275 | 2300 | |
BEL | Belgium | parliament | 1939-04-02 | 0.55 | 1 | 202 | one-seat | one seat | one seat | 64 | 882 | 881 | 1301 | 2300 | |
BEL | Belgium | parliament | 1961-03-26 | 0.88 | 1 | 212 | one-seat | one seat | one seat | 64 | 425 | 573 | 144 | 2300 | |
BEL | Belgium | parliament | 1965-05-23 | 2 | 212 | one-seat | one seat | one seat | 64 | 150 | 425 | 613 | 2300 | ||
CHE | Switzerland | parliament | 1919-10-26 | 1 | 189 | one-seat | one seat | one seat | 40 | 770 | 977 | 1464 | 2303 | ||
CHE | Switzerland | parliament | 1922-10-29 | 1 | 198 | one-seat | one seat | one seat | 40 | 773 | 770 | 981 | 2303 | ||
CHE | Switzerland | parliament | 1931-10-25 | 1 | 187 | one-seat | one seat | one seat | 40 | 768 | 772 | 978 | 2303 | ||
CHE | Switzerland | parliament | 1935-10-27 | 3 | 187 | one-seat | one seat | one seat | 40 | 769 | 768 | 975 | 2303 | ||
CHE | Switzerland | parliament | 1943-10-31 | 2 | 194 | one-seat | one seat | one seat | 40 | 771 | 767 | 973 | 2303 | ||
CHE | Switzerland | parliament | 1967-10-29 | 1 | 200 | one-seat | one seat | one seat | 40 | 373 | 108 | 513 | 2303 | ||
CHE | Switzerland | parliament | 1979-10-21 | 1 | 200 | one-seat | one seat | one seat | 40 | 435 | 371 | 20 | 2303 | ||
CHE | Switzerland | parliament | 1983-10-23 | 1 | 200 | one-seat | one seat | one seat | 40 | 631 | 435 | 723 | 2303 | ||
CHE | Switzerland | parliament | 2011-10-23 | 1 | 200 | one-seat | one seat | one seat | 40 | 779 | 310 | 903 | 2303 | ||
DEU | Germany | parliament | 1919-01-19 | 0.38 | 2 | 423 | one-seat | one seat | one seat | 54 | 1031 | 2289 | |||
DEU | Germany | parliament | 1920-06-06 | 0.25 | 2 | 466 | one-seat | one seat | one seat | 54 | 1033 | 1031 | 1559 | 2289 | |
DEU | Germany | parliament | 1924-05-04 | 0.11 | 1 | 472 | one-seat | one seat | one seat | 54 | 1034 | 1033 | 1569 | 2289 | |
DEU | Germany | ep | 2014-05-25 | 2 | 96 | one-seat | one seat | one seat | 54 | 825 | 800 | 1071 | 2289 | ||
DEU | Germany | ep | 2019-05-26 | 0.7 | 1 | 96 | one-seat | one seat | one seat | 54 | 1055 | 1016 | 1528 | 2289 | |
ESP | Spain | parliament | 1979-03-01 | 2 | 350 | one-seat | one seat | one seat | 27 | 493 | 42 | 205 | 2294 | ||
ESP | Spain | parliament | 1986-06-22 | 0.4 | 1 | 350 | one-seat | one seat | one seat | 27 | 254 | 85 | 238 | 2294 | |
ESP | Spain | parliament | 2011-11-20 | 2 | 350 | one-seat | one seat | one seat | 27 | 777 | 500 | 497 | 2294 | ||
ESP | Spain | parliament | 2019-04-28 | 0.86 | 2 | 350 | one-seat | one seat | one seat | 27 | 1046 | 1005 | 1533 | 2294 | |
ESP | Spain | parliament | 2019-11-10 | 0.37 | 2 | 350 | one-seat | one seat | one seat | 27 | 1085 | 1046 | 1601 | 2294 | |
FIN | Finland | parliament | 2015-04-19 | 0.56 | 1 | 200 | one-seat | one seat | one seat | 67 | 855 | 700 | 1145 | 2413 | |
FRA | France | parliament | 2022-06-19 | 0.9 | 1 | 577 | one-seat | one seat | one seat | 43 | 1110 | 1014 | 1673 | 2859 | |
GBR | United Kingdom | parliament | 1918-12-14 | 0.3 | 1 | 707 | one-seat | one seat | one seat | 44 | 905 | 2296 | |||
GBR | United Kingdom | parliament | 1945-07-05 | 0.5 | 1 | 640 | one-seat | one seat | one seat | 44 | 609 | 911 | 1520 | 2296 | |
GBR | United Kingdom | parliament | 1951-10-25 | 0.1 | 1 | 625 | one-seat | one seat | one seat | 44 | 102 | 625 | 88 | 2296 | |
GBR | United Kingdom | parliament | 1970-06-18 | 0.1 | 1 | 630 | one-seat | one seat | one seat | 44 | 311 | 583 | 733 | 2296 | |
GBR | United Kingdom | parliament | 1979-05-03 | 0.13 | 1 | 635 | one-seat | one seat | one seat | 44 | 243 | 40 | 590 | 2296 | |
GBR | United Kingdom | parliament | 1997-05-01 | 0.04 | 1 | 659 | one-seat | one seat | one seat | 44 | 315 | 514 | 678 | 2296 | |
GBR | United Kingdom | parliament | 2010-05-06 | 0.14 | 1 | 650 | one-seat | one seat | one seat | 44 | 582 | 233 | 119 | 2296 | |
GBR | United Kingdom | parliament | 2015-05-07 | 0.54 | 1 | 650 | one-seat | one seat | one seat | 44 | 856 | 582 | 874 | 2296 | |
GBR | United Kingdom | parliament | 2017-06-08 | 0.58 | 1 | 650 | one-seat | one seat | one seat | 44 | 1013 | 856 | 1489 | 2296 | |
HRV | Croatia | parliament | 2000-01-03 | 1 | 151 | one-seat | one seat | one seat | 62 | 797 | 2295 | ||||
HRV | Croatia | parliament | 2015-11-08 | 2 | 151 | one-seat | one seat | one seat | 62 | 1001 | 792 | 1056 | 2295 | ||
HRV | Croatia | parliament | 2016-09-11 | 0.26 | 1 | 151 | one-seat | one seat | one seat | 62 | 1007 | 1001 | 1408 | 2295 | |
HUN | Hungary | parliament | 2006-04-09 | 1 | 386 | one-seat | one seat | one seat | 39 | 194 | 463 | 188 | 952 | ||
HUN | Hungary | parliament | 2014-04-06 | 1 | 199 | one-seat | one seat | one seat | 39 | 814 | 688 | 846 | 952 | ||
HUN | Hungary | parliament | 2018-04-08 | 0.46 | 1 | 199 | one-seat | one seat | one seat | 39 | 1023 | 814 | 1104 | 952 | |
HUN | Hungary | parliament | 2022-04-03 | 1 | 199 | one-seat | one seat | one seat | 39 | 1107 | 1023 | 1531 | 952 | ||
IRL | Ireland | parliament | 1943-06-23 | 0.3 | 1 | 138 | one-seat | one seat | one seat | 37 | 921 | 920 | 1444 | 2298 | |
IRL | Ireland | parliament | 1981-06-11 | 0.41 | 1 | 166 | one-seat | one seat | one seat | 37 | 47 | 6 | 442 | 2298 | |
IRL | Ireland | parliament | 2011-02-25 | 0.5 | 1 | 166 | one-seat | one seat | one seat | 37 | 698 | 190 | 173 | 2298 | |
IRL | Ireland | parliament | 2016-02-26 | 0.35 | 1 | 158 | one-seat | one seat | one seat | 37 | 1002 | 698 | 904 | 2298 | |
ITA | Italy | parliament | 1946-06-02 | 0.62 | 3 | 556 | one-seat | one seat | one seat | 26 | 503 | 2302 | |||
ITA | Italy | parliament | 1958-05-25 | 0.59 | 1 | 596 | one-seat | one seat | one seat | 26 | 507 | 642 | 280 | 2302 | |
ITA | Italy | parliament | 1994-03-27 | 1 | 630 | one-seat | one seat | one seat | 26 | 146 | 605 | 801 | 2302 | ||
ITA | Italy | parliament | 2001-05-13 | 3 | 630 | one-seat | one seat | one seat | 26 | 498 | 551 | 239 | 2302 | ||
ITA | Italy | parliament | 2006-04-09 | 0.18 | 1 | 630 | one-seat | one seat | one seat | 26 | 107 | 498 | 567 | 2302 | |
ITA | Italy | parliament | 2018-03-04 | 0.58 | 1 | 630 | one-seat | one seat | one seat | 26 | 1024 | 789 | 1501 | 2302 | |
ITA | Italy | parliament | 2022-09-25 | 0.76 | 1 | 400 | one-seat | one seat | one seat | 26 | 1113 | 1024 | 1681 | 2302 | |
JPN | Japan | parliament | 1990-02-18 | 0.43 | 1 | 512 | one-seat | one seat | one seat | 5 | 25 | 506 | 106 | 2297 | |
LTU | Lithuania | parliament | 2000-10-08 | 1 | 141 | one-seat | one seat | one seat | 15 | 59 | 566 | 735 | 652 | ||
LTU | Lithuania | parliament | 2016-10-09 | 1.8 | 1 | 141 | one-seat | one seat | one seat | 15 | 1009 | 786 | 1633 | 652 | |
LUX | Luxembourg | parliament | 1919-10-26 | 0.7 | 1 | 48 | one-seat | one seat | one seat | 7 | 930 | 2290 | |||
NLD | Netherlands | parliament | 1922-07-05 | 0.6 | 1 | 100 | one-seat | one seat | one seat | 8 | 938 | 937 | 1262 | 2288 | |
NLD | Netherlands | parliament | 1933-04-26 | 0.81 | 1 | 100 | one-seat | one seat | one seat | 8 | 941 | 940 | 1258 | 2288 | |
NLD | Netherlands | parliament | 1972-11-29 | 0.92 | 1 | 150 | one-seat | one seat | one seat | 8 | 51 | 125 | 291 | 2288 | |
NLD | Netherlands | parliament | 1982-09-08 | 0.69 | 1 | 150 | one-seat | one seat | one seat | 8 | 116 | 81 | 6 | 2288 | |
NLD | Netherlands | parliament | 1994-05-03 | 0.87 | 1 | 150 | one-seat | one seat | one seat | 8 | 570 | 627 | 148 | 2288 | |
NLD | Netherlands | parliament | 2021-03-17 | 0.84 | 1 | 150 | one-seat | one seat | one seat | 8 | 1097 | 1012 | 1648 | 2288 | |
NOR | Norway | parliament | 1989-09-11 | 0.3 | 1 | 165 | one-seat | one seat | one seat | 9 | 571 | 207 | 394 | 474 | |
NOR | Norway | parliament | 2021-09-13 | 0.2 | 1 | 169 | one-seat | one seat | one seat | 9 | 1104 | 1017 | 1617 | 474 | |
POL | Poland | parliament | 1991-10-27 | 10 | 460 | one-seat | one seat | one seat | 74 | 211 | 158 | 75 | 2287 | ||
POL | Poland | parliament | 1993-09-19 | 0.1 | 1 | 460 | one-seat | one seat | one seat | 74 | 268 | 211 | 730 | 2287 | |
POL | Poland | parliament | 2019-10-13 | 1 | 460 | one-seat | one seat | one seat | 74 | 1082 | 996 | 1526 | 2287 | ||
PRT | Portugal | parliament | 1975-04-25 | 1 | 250 | one-seat | one seat | one seat | 63 | 247 | 2291 | ||||
ROU | Romania | parliament | 1990-05-20 | 5 | 396 | one-seat | one seat | one seat | 23 | 633 | 1604 | 441 | |||
AUS | Australia | parliament | 1901-03-30 | 1.4 | 1 | 75 | none | no party affiliation | no party affiliation | 33 | 731 | 1396 | |||
AUS | Australia | parliament | 1903-12-16 | 4.5 | 0 | 75 | none | no party affiliation | no party affiliation | 33 | 730 | 731 | 997 | 1396 | |
AUS | Australia | parliament | 1906-12-02 | 1.2 | 0 | 75 | none | no party affiliation | no party affiliation | 33 | 725 | 730 | 1000 | 1396 | |
AUS | Australia | parliament | 1910-04-13 | 4.5 | 1 | 75 | none | no party affiliation | no party affiliation | 33 | 747 | 725 | 1002 | 1396 | |
AUS | Australia | parliament | 1913-05-31 | 2.6 | 0 | 75 | none | no party affiliation | no party affiliation | 33 | 748 | 747 | 1003 | 1396 | |
AUS | Australia | parliament | 1914-09-05 | 1.9 | 1 | 75 | none | no party affiliation | no party affiliation | 33 | 724 | 748 | 1004 | 1396 | |
AUS | Australia | parliament | 1917-05-05 | 1.8 | 0 | 75 | none | no party affiliation | no party affiliation | 33 | 750 | 724 | 1008 | 1396 | |
AUS | Australia | parliament | 1919-12-13 | 1.5 | 0 | 75 | none | no party affiliation | no party affiliation | 33 | 723 | 750 | 1010 | 1396 | |
AUS | Australia | parliament | 1922-12-16 | 4.6 | 1 | 76 | none | no party affiliation | no party affiliation | 33 | 726 | 723 | 1011 | 1396 | |
AUS | Australia | parliament | 1925-11-14 | 1.7 | 1 | 76 | none | no party affiliation | no party affiliation | 33 | 727 | 726 | 1012 | 1396 | |
AUS | Australia | parliament | 1928-11-17 | 4.2 | 1 | 76 | none | no party affiliation | no party affiliation | 33 | 728 | 727 | 1013 | 1396 | |
AUS | Australia | parliament | 1929-10-12 | 2.1 | 1 | 76 | none | no party affiliation | no party affiliation | 33 | 729 | 728 | 1014 | 1396 | |
AUS | Australia | parliament | 1931-12-19 | 7.9 | 1 | 76 | none | no party affiliation | no party affiliation | 33 | 744 | 729 | 1015 | 1396 | |
AUS | Australia | parliament | 1934-09-15 | 3.0 | 1 | 75 | none | no party affiliation | no party affiliation | 33 | 746 | 744 | 1016 | 1396 | |
AUS | Australia | parliament | 1937-10-23 | 4.2 | 1 | 75 | none | no party affiliation | no party affiliation | 33 | 745 | 746 | 1017 | 1396 | |
AUS | Australia | parliament | 1940-09-21 | 8.7 | 3 | 75 | none | no party affiliation | no party affiliation | 33 | 738 | 745 | 1021 | 1396 | |
AUS | Australia | parliament | 1943-08-21 | 12.8 | 3 | 75 | none | no party affiliation | no party affiliation | 33 | 737 | 738 | 995 | 1396 | |
AUS | Australia | parliament | 1946-09-28 | 2.3 | 2 | 75 | none | no party affiliation | no party affiliation | 33 | 739 | 737 | 574 | 1396 | |
AUS | Australia | parliament | 1949-12-10 | 3.9 | 1 | 123 | none | no party affiliation | no party affiliation | 33 | 734 | 739 | 490 | 1396 | |
AUS | Australia | parliament | 1951-04-28 | 2.1 | 0 | 123 | none | no party affiliation | no party affiliation | 33 | 763 | 734 | 450 | 1396 | |
AUS | Australia | parliament | 1954-05-29 | 2.9 | 0 | 123 | none | no party affiliation | no party affiliation | 33 | 743 | 763 | 566 | 1396 | |
AUS | Australia | parliament | 1955-12-10 | 2.6 | 0 | 124 | none | no party affiliation | no party affiliation | 33 | 742 | 743 | 178 | 1396 |
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;