view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_name_english 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 | |
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 | 1910-04-13 | 0.4 | 0 | 75 | no-seat | no seat | no seat | 33 | 747 | 725 | 1002 | 2057 | |
AUS | Australia | parliament | 1922-12-16 | 0.7 | 0 | 76 | no-seat | no seat | no seat | 33 | 726 | 723 | 1011 | 2057 | |
AUT | Austria | parliament | 1945-11-25 | 0.2 | 0 | 165 | no-seat | no seat | no seat | 59 | 402 | 1029 | 452 | 2055 | |
AUT | Austria | parliament | 1949-10-09 | 0.28 | 0 | 165 | no-seat | no seat | no seat | 59 | 67 | 402 | 884 | 2055 | |
AUT | Austria | parliament | 1953-02-22 | 0.13 | 0 | 165 | no-seat | no seat | no seat | 59 | 11 | 67 | 560 | 2055 | |
AUT | Austria | parliament | 1956-05-13 | 0.04 | 0 | 165 | no-seat | no seat | no seat | 59 | 169 | 11 | 659 | 2055 | |
BEL | Belgium | parliament | 1919-11-16 | 0.1 | 186 | no-seat | no seat | no seat | 64 | 876 | 875 | 1281 | 2052 | ||
BEL | Belgium | parliament | 1921-11-20 | 0.3 | 186 | no-seat | no seat | no seat | 64 | 877 | 876 | 1279 | 2052 | ||
BEL | Belgium | parliament | 1936-05-24 | 0.63 | 0 | 202 | no-seat | no seat | no seat | 64 | 881 | 880 | 1270 | 2052 | |
BEL | Belgium | parliament | 1939-04-02 | 0.41 | 0 | 202 | no-seat | no seat | no seat | 64 | 882 | 881 | 1301 | 2052 | |
BEL | Belgium | parliament | 1946-02-17 | 0.14 | 0 | 202 | no-seat | no seat | no seat | 64 | 19 | 882 | 204 | 2052 | |
BEL | Belgium | parliament | 1950-06-04 | 0.03 | 0 | 212 | no-seat | no seat | no seat | 64 | 217 | 644 | 746 | 2052 | |
BEL | Belgium | parliament | 1954-04-11 | 0.2 | 0 | 212 | no-seat | no seat | no seat | 64 | 545 | 217 | 389 | 2052 | |
BEL | Belgium | parliament | 1961-03-26 | 0.63 | 0 | 212 | no-seat | no seat | no seat | 64 | 425 | 573 | 144 | 2052 | |
BEL | Belgium | parliament | 1965-05-23 | 0.8 | 0 | 212 | no-seat | no seat | no seat | 64 | 150 | 425 | 613 | 2052 | |
BEL | Belgium | parliament | 1971-11-07 | 0.42 | 0 | 212 | no-seat | no seat | no seat | 64 | 591 | 184 | 586 | 2052 | |
CAN | Canada | parliament | 1945-06-11 | 0.09 | 0 | 245 | no-seat | no seat | no seat | 29 | 189 | 854 | 1164 | 2067 | |
CAN | Canada | parliament | 1974-07-08 | 0.17 | 0 | 264 | no-seat | no seat | no seat | 29 | 276 | 552 | 25 | 2067 | |
CAN | Canada | parliament | 2011-05-02 | 0.1 | 0 | 308 | no-seat | no seat | no seat | 29 | 703 | 601 | 612 | 2067 | |
DEU | Germany | parliament | 1949-08-14 | 0.9 | 0 | 402 | no-seat | no seat | no seat | 54 | 581 | 1040 | 1578 | 2034 | |
DEU | Germany | ep | 2019-05-26 | 0.3 | 0 | 96 | no-seat | no seat | no seat | 54 | 1055 | 1016 | 1528 | 2034 | |
DNK | Denmark | parliament | 1918-04-22 | 0.5 | 0 | 139 | no-seat | no seat | no seat | 21 | 892 | 999 | 1252 | 2058 | |
DNK | Denmark | parliament | 1920-04-26 | 0.9 | 0 | 139 | no-seat | no seat | no seat | 21 | 893 | 892 | 1481 | 2058 | |
DNK | Denmark | parliament | 1920-07-06 | 0.86 | 0 | 139 | no-seat | no seat | no seat | 21 | 1000 | 893 | 1248 | 2058 |
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;