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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUT | Austria | parliament | 1923-10-21 | 2.88 | 0 | 165 | etc | others | others | 59 | 1027 | 1026 | 1542 | 2687 | |
BEL | Belgium | parliament | 1900-05-27 | 2 | 152 | etc | others | others | 64 | 868 | 2488 | ||||
BEL | Belgium | parliament | 1919-11-16 | 4.7 | 186 | etc | others | others | 64 | 876 | 875 | 1281 | 2488 | ||
BEL | Belgium | parliament | 1925-08-05 | 2.5 | 3 | 187 | etc | others | others | 64 | 878 | 877 | 1277 | 2488 | |
BEL | Belgium | parliament | 1939-04-02 | 0.54 | 1 | 202 | etc | others | others | 64 | 882 | 881 | 1301 | 2488 | |
CAN | Canada | parliament | 1911-09-21 | 5 | 221 | etc | others | others | 29 | 863 | 885 | 1468 | 2577 | ||
CAN | Canada | parliament | 1921-12-06 | 1 | 235 | etc | others | others | 29 | 861 | 862 | 1169 | 2577 | ||
CAN | Canada | parliament | 1925-10-29 | 2 | 245 | etc | others | others | 29 | 860 | 861 | 1168 | 2577 | ||
CAN | Canada | parliament | 1926-09-14 | 1 | 245 | etc | others | others | 29 | 859 | 860 | 1168 | 2577 | ||
CAN | Canada | parliament | 1935-10-14 | 7 | 245 | etc | others | others | 29 | 857 | 858 | 1166 | 2577 | ||
CAN | Canada | parliament | 1940-03-26 | 5 | 245 | etc | others | others | 29 | 854 | 857 | 1165 | 2577 | ||
CHE | Switzerland | parliament | 1911-10-29 | 2 | 189 | etc | others | others | 40 | 979 | 980 | 1458 | 2579 | ||
CHE | Switzerland | parliament | 1914-10-25 | 2 | 189 | etc | others | others | 40 | 978 | 979 | 1459 | 2579 | ||
CHE | Switzerland | parliament | 1917-10-28 | 5 | 189 | etc | others | others | 40 | 977 | 978 | 1463 | 2579 | ||
CHE | Switzerland | parliament | 2015-10-18 | 1 | 200 | etc | others | others | 40 | 995 | 779 | 989 | 2579 | ||
DNK | Denmark | parliament | 1994-09-21 | 1 | 179 | etc | others | others | 21 | 89 | 157 | 740 | 2576 | ||
ESP | Spain | parliament | 1977-06-15 | 0.16 | 1 | 350 | etc | others | others | 27 | 42 | 1377 | |||
ESP | Spain | ep | 1986-01-01 | 7 | 60 | etc | others | others | 27 | 38 | 85 | 238 | 1377 | ||
FRA | France | parliament | 1910-05-08 | 2 | 580 | etc | divers | others | 43 | 988 | 986 | 1391 | 1328 | ||
FRA | France | parliament | 1919-10-16 | 2 | 616 | etc | divers | others | 43 | 990 | 989 | 1359 | 1328 | ||
FRA | France | parliament | 1928-04-29 | 2 | 602 | etc | divers | others | 43 | 985 | 991 | 1347 | 1328 | ||
FRA | France | parliament | 1956-01-02 | 3 | 544 | etc | divers | others | 43 | 312 | 293 | 397 | 1328 | ||
FRA | France | parliament | 1993-03-28 | 3.7 | 1 | 577 | etc | divers | others | 43 | 664 | 643 | 199 | 1328 | |
FRA | France | parliament | 1997-06-01 | 1.4 | 1 | 577 | etc | divers | others | 43 | 479 | 664 | 422 | 1328 | |
FRA | France | parliament | 2017-06-18 | 3 | 577 | etc | divers | others | 43 | 1014 | 782 | 1508 | 1328 | ||
FRA | France | parliament | 2022-06-19 | 0.85 | 1 | 577 | etc | divers | others | 43 | 1110 | 1014 | 1673 | 1328 | |
GBR | United Kingdom | parliament | 1918-12-14 | 8 | 707 | etc | others | others | 44 | 905 | 453 | ||||
GBR | United Kingdom | parliament | 1922-11-15 | 2.62 | 10 | 615 | etc | others | others | 44 | 906 | 905 | 1294 | 453 | |
GBR | United Kingdom | parliament | 1923-12-06 | 1.0 | 5 | 615 | etc | others | others | 44 | 907 | 906 | 1293 | 453 | |
GBR | United Kingdom | parliament | 1924-10-29 | 0.49 | 3 | 615 | etc | others | others | 44 | 908 | 907 | 1292 | 453 | |
GBR | United Kingdom | parliament | 1929-05-30 | 1.03 | 6 | 615 | etc | others | others | 44 | 909 | 908 | 1291 | 453 | |
GBR | United Kingdom | parliament | 1931-10-27 | 0.54 | 3 | 615 | etc | others | others | 44 | 910 | 909 | 1290 | 453 | |
GBR | United Kingdom | parliament | 1935-11-14 | 0.53 | 4 | 615 | etc | others | others | 44 | 911 | 910 | 1287 | 453 | |
GBR | United Kingdom | parliament | 1945-07-05 | 19 | 640 | etc | others | others | 44 | 609 | 911 | 1520 | 453 | ||
GBR | United Kingdom | parliament | 1950-02-23 | 1 | 625 | etc | others | others | 44 | 625 | 609 | 99 | 453 | ||
GBR | United Kingdom | parliament | 1959-10-08 | 1 | 630 | etc | others | others | 44 | 161 | 678 | 404 | 453 | ||
GBR | United Kingdom | parliament | 1970-06-18 | 1 | 630 | etc | others | others | 44 | 311 | 583 | 733 | 453 | ||
GBR | United Kingdom | parliament | 1974-02-28 | 2 | 635 | etc | others | others | 44 | 568 | 311 | 216 | 453 | ||
GBR | United Kingdom | parliament | 1979-05-03 | 2 | 635 | etc | others | others | 44 | 243 | 40 | 590 | 453 | ||
GBR | United Kingdom | parliament | 1997-05-01 | 1 | 659 | etc | others | others | 44 | 315 | 514 | 678 | 453 | ||
GBR | United Kingdom | parliament | 2001-06-07 | 2 | 659 | etc | others | others | 44 | 208 | 315 | 838 | 453 | ||
GBR | United Kingdom | parliament | 2005-05-05 | 3 | 646 | etc | others | others | 44 | 233 | 208 | 19 | 453 | ||
GBR | United Kingdom | parliament | 2010-05-06 | 1 | 650 | etc | others | others | 44 | 582 | 233 | 119 | 453 | ||
ITA | Italy | parliament | 1976-06-20 | 0.07 | 1 | 630 | etc | diversi | others | 26 | 502 | 65 | 842 | 825 | |
ITA | Italy | parliament | 2022-09-25 | 3 | 400 | etc | diversi | others | 26 | 1113 | 1024 | 1681 | 825 | ||
JPN | Japan | parliament | 1946-04-10 | 33 | 464 | etc | others | others | 5 | 697 | 1055 | ||||
JPN | Japan | parliament | 1947-04-25 | 33 | 466 | etc | others | others | 5 | 696 | 697 | 891 | 1055 | ||
JPN | Japan | parliament | 1949-01-23 | 24 | 466 | etc | others | others | 5 | 695 | 696 | 894 | 1055 | ||
JPN | Japan | parliament | 1952-10-01 | 24 | 466 | etc | others | others | 5 | 694 | 695 | 895 | 1055 | ||
JPN | Japan | parliament | 1953-04-19 | 12 | 466 | etc | others | others | 5 | 693 | 694 | 896 | 1055 | ||
JPN | Japan | parliament | 1955-02-27 | 8 | 467 | etc | others | others | 5 | 692 | 693 | 898 | 1055 | ||
JPN | Japan | parliament | 1960-11-20 | 1 | 467 | etc | others | others | 5 | 345 | 645 | 241 | 1055 | ||
JPN | Japan | parliament | 1972-12-10 | 2 | 491 | etc | others | others | 5 | 333 | 603 | 656 | 1055 | ||
LTU | Lithuania | parliament | 1996-10-20 | 4 | 141 | etc | others | others | 15 | 566 | 439 | 91 | 2802 | ||
NOR | Norway | parliament | 1927-10-17 | 1 | 150 | etc | others | others | 9 | 867 | 951 | 1231 | 2578 | ||
NOR | Norway | parliament | 1930-10-20 | 2 | 150 | etc | others | others | 9 | 866 | 867 | 1229 | 2578 | ||
NZL | New Zealand | parliament | 1902-11-25 | 4 | 80 | etc | others | others | 11 | 974 | 1365 | ||||
NZL | New Zealand | parliament | 1931-12-02 | 10.51 | 4 | 80 | etc | others | others | 11 | 958 | 957 | 1315 | 1365 | |
FRA | France | ep | 1979-06-10 | 1.4 | 0 | 81 | d-droite | divers droite | other right | 7.6583 | 43 | 677 | 496 | 72 | 285 |
FRA | France | parliament | 1986-03-16 | 1.3 | 4 | 556 | d-droite | divers droite | other right | 7.6583 | 43 | 623 | 20 | 843 | 285 |
FRA | France | parliament | 1988-06-12 | 2.5 | 8 | 555 | d-droite | divers droite | other right | 7.6583 | 43 | 643 | 623 | 1150 | 285 |
FRA | France | parliament | 1993-03-28 | 4.7 | 22 | 577 | d-droite | divers droite | other right | 7.6583 | 43 | 664 | 643 | 199 | 285 |
FRA | France | parliament | 1997-06-01 | 6.61 | 6 | 577 | d-droite | divers droite | other right | 7.6583 | 43 | 479 | 664 | 422 | 285 |
FRA | France | ep | 1999-06-13 | 1.77 | 0 | 87 | d-droite | divers droite | other right | 7.6583 | 43 | 273 | 479 | 481 | 285 |
FRA | France | parliament | 2002-06-16 | 3.65 | 7 | 577 | d-droite | divers droite | other right | 7.6583 | 43 | 403 | 479 | 711 | 285 |
FRA | France | parliament | 2007-06-17 | 2.47 | 9 | 577 | d-droite | divers droite | other right | 7.6583 | 43 | 171 | 403 | 807 | 285 |
FRA | France | parliament | 2012-06-17 | 3.51 | 15 | 577 | d-droite | divers droite | other right | 7.6583 | 43 | 782 | 171 | 1037 | 285 |
FRA | France | ep | 2014-05-24 | 1.41 | 0 | 74 | d-droite | divers droite | other right | 7.6583 | 43 | 824 | 782 | 1103 | 285 |
FRA | France | parliament | 2017-06-18 | 2.76 | 6 | 577 | d-droite | divers droite | other right | 7.6583 | 43 | 1014 | 782 | 1508 | 285 |
FRA | France | parliament | 2022-06-19 | 2.33 | 10 | 577 | d-droite | divers droite | other right | 7.6583 | 43 | 1110 | 1014 | 1673 | 285 |
FRA | France | parliament | 1978-03-19 | 1.4 | 10 | 474 | d-gauche | divers gauche | other left | 3.3 | 43 | 496 | 357 | 21 | 177 |
FRA | France | ep | 1994-06-12 | 1.57 | 0 | 87 | d-gauche | divers gauche | other left | 3.3 | 43 | 680 | 664 | 318 | 177 |
FRA | France | ep | 1999-06-13 | 1.01 | 0 | 87 | d-gauche | divers gauche | other left | 3.3 | 43 | 273 | 479 | 481 | 177 |
FRA | France | parliament | 2002-06-16 | 1.09 | 3 | 577 | d-gauche | divers gauche | other left | 3.3 | 43 | 403 | 479 | 711 | 177 |
FRA | France | parliament | 2007-06-17 | 1.97 | 15 | 577 | d-gauche | divers gauche | other left | 3.3 | 43 | 171 | 403 | 807 | 177 |
FRA | France | parliament | 2012-06-17 | 3.4 | 22 | 577 | d-gauche | divers gauche | other left | 3.3 | 43 | 782 | 171 | 1037 | 177 |
FRA | France | ep | 2014-05-24 | 2.9 | 0 | 74 | d-gauche | divers gauche | other left | 3.3 | 43 | 824 | 782 | 1103 | 177 |
FRA | France | parliament | 2017-06-18 | 1.6 | 12 | 577 | d-gauche | divers gauche | other left | 3.3 | 43 | 1014 | 782 | 1508 | 177 |
FRA | France | parliament | 2022-06-19 | 3.14 | 22 | 577 | d-gauche | divers gauche | other left | 3.3 | 43 | 1110 | 1014 | 1673 | 177 |
FRA | France | parliament | 1956-01-02 | 1.2 | 0 | 544 | ex-dro | extrême droite | other far-right | 8.8 | 43 | 312 | 293 | 397 | 2079 |
FRA | France | parliament | 1958-11-30 | 1.1 | 0 | 465 | ex-dro | extrême droite | other far-right | 8.8 | 43 | 375 | 312 | 197 | 2079 |
FRA | France | parliament | 1962-11-25 | 0.5 | 0 | 465 | ex-dro | extrême droite | other far-right | 8.8 | 43 | 407 | 375 | 526 | 2079 |
FRA | France | parliament | 1967-03-12 | 0.6 | 0 | 470 | ex-dro | extrême droite | other far-right | 8.8 | 43 | 291 | 407 | 349 | 2079 |
FRA | France | parliament | 2012-06-17 | 0.19 | 1 | 577 | ex-dro | extrême droite | other far-right | 8.8 | 43 | 782 | 171 | 1037 | 2079 |
FRA | France | parliament | 2017-06-18 | 0.3 | 1 | 577 | ex-dro | extrême droite | other far-right | 8.8 | 43 | 1014 | 782 | 1508 | 2079 |
FRA | France | parliament | 1993-03-28 | 1.8 | 0 | 577 | ex-gau | extrême gauche | other far-left | 1.3 | 43 | 664 | 643 | 199 | 2083 |
FRA | France | parliament | 1997-06-01 | 2.53 | 0 | 577 | ex-gau | extrême gauche | other far-left | 1.3 | 43 | 479 | 664 | 422 | 2083 |
FRA | France | parliament | 2007-06-17 | 3.41 | 0 | 577 | ex-gau | extrême gauche | other far-left | 1.3 | 43 | 171 | 403 | 807 | 2083 |
FRA | France | parliament | 2017-06-18 | 0.77 | 0 | 577 | ex-gau | extrême gauche | other far-left | 1.3 | 43 | 1014 | 782 | 1508 | 2083 |
FRA | France | parliament | 2022-06-19 | 1.17 | 0 | 577 | ex-gau | extrême gauche | other far-left | 1.3 | 43 | 1110 | 1014 | 1673 | 2083 |
FRA | France | ep | 1989-06-18 | 1.04 | 0 | 81 | d-eco | divers ecologistes | other ecologists | 2.5 | 43 | 360 | 643 | 712 | 2249 |
FRA | France | ep | 1999-06-13 | 1.52 | 0 | 87 | d-eco | divers ecologistes | other ecologists | 2.5 | 43 | 273 | 479 | 481 | 2249 |
FRA | France | parliament | 2002-06-16 | 1.17 | 0 | 577 | d-eco | divers ecologistes | other ecologists | 2.5 | 43 | 403 | 479 | 711 | 2249 |
FRA | France | ep | 2004-06-13 | 1.55 | 0 | 78 | d-eco | divers ecologistes | other ecologists | 2.5 | 43 | 160 | 403 | 802 | 2249 |
FRA | France | ep | 2009-06-07 | 3.63 | 0 | 72 | d-eco | divers ecologistes | other ecologists | 2.5 | 43 | 219 | 171 | 306 | 2249 |
FRA | France | ep | 2014-05-24 | 1.12 | 0 | 74 | d-eco | divers ecologistes | other ecologists | 2.5 | 43 | 824 | 782 | 1103 | 2249 |
FRA | France | ep | 2019-05-26 | 1.82 | 0 | 74 | d-eco | divers ecologistes | other ecologists | 2.5 | 43 | 1054 | 1014 | 1509 | 2249 |
FRA | France | parliament | 2022-06-19 | 1.25 | 4 | 577 | d-center | divers centre | other centre | 6.0 | 43 | 1110 | 1014 | 1673 | 2858 |
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 |
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;