view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by left_right
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BGR | Bulgaria | parliament | 2005-06-25 | 1.25 | 0 | 240 | ER | Evroroma | Euroroma | 10 | 618 | 681 | 575 | 2178 | |
BGR | Bulgaria | parliament | 2013-05-12 | 1.339 | 0 | 240 | GN | Glas Naroden | People's Voice | 10 | 799 | 79 | 1045 | 2214 | |
BGR | Bulgaria | parliament | 2014-10-05 | 1.14 | 0 | 240 | GN | Glas Naroden | People's Voice | 10 | 840 | 799 | 1139 | 2214 | |
BGR | Bulgaria | ep | 2019-05-26 | 1.18 | 0 | 17 | I-MK | Independent – Mincho Kuminev | Independent -- Mincho Kuminev | 10 | 1059 | 1011 | 1505 | 2774 | |
BGR | Bulgaria | parliament | 2021-11-14 | 25.67 | 67 | 240 | PP | Prodalzhavame promyanata | We Continue the Change | 10 | 1106 | 1102 | 1658 | 2847 | |
BGR | Bulgaria | parliament | 2022-10-02 | 20.2 | 53 | 240 | PP | Prodalzhavame promyanata | We Continue the Change | 10 | 1114 | 1106 | 1678 | 2847 | |
CAN | Canada | parliament | 1900-11-07 | 0.28 | 0 | 213 | none | no party affiliation | no party affiliation | 29 | 883 | 1189 | |||
CAN | Canada | parliament | 1904-11-03 | 0.34 | 1 | 214 | none | no party affiliation | no party affiliation | 29 | 884 | 883 | 1466 | 1189 | |
CAN | Canada | parliament | 1908-10-26 | 1.26 | 1 | 221 | none | no party affiliation | no party affiliation | 29 | 885 | 884 | 1467 | 1189 | |
CAN | Canada | parliament | 1911-09-21 | 5 | 221 | etc | others | others | 29 | 863 | 885 | 1468 | 2577 | ||
CAN | Canada | parliament | 1911-09-21 | 0.55 | 0 | 221 | none | no party affiliation | no party affiliation | 29 | 863 | 885 | 1468 | 1189 | |
CAN | Canada | parliament | 1917-12-17 | 0.77 | 0 | 235 | none | no party affiliation | no party affiliation | 29 | 862 | 863 | 1170 | 1189 | |
CAN | Canada | parliament | 1921-12-06 | 2.9 | 2 | 235 | none | no party affiliation | no party affiliation | 29 | 861 | 862 | 1169 | 1189 | |
CAN | Canada | parliament | 1921-12-06 | 1 | 235 | etc | others | others | 29 | 861 | 862 | 1169 | 2577 | ||
CAN | Canada | parliament | 1925-10-29 | 0.74 | 2 | 245 | none | no party affiliation | no party affiliation | 29 | 860 | 861 | 1168 | 1189 | |
CAN | Canada | parliament | 1925-10-29 | 2 | 245 | etc | others | others | 29 | 860 | 861 | 1168 | 2577 | ||
CAN | Canada | parliament | 1926-09-14 | 0.65 | 2 | 245 | none | no party affiliation | no party affiliation | 29 | 859 | 860 | 1168 | 1189 | |
CAN | Canada | parliament | 1926-09-14 | 1 | 245 | etc | others | others | 29 | 859 | 860 | 1168 | 2577 | ||
CAN | Canada | parliament | 1930-07-28 | 0.65 | 3 | 245 | none | no party affiliation | no party affiliation | 29 | 858 | 859 | 1167 | 1189 | |
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 | ||
CAN | Canada | parliament | 1940-03-26 | 1.19 | 1 | 245 | none | no party affiliation | no party affiliation | 29 | 854 | 857 | 1165 | 1189 | |
CAN | Canada | parliament | 1945-06-11 | 8 | 245 | none | no party affiliation | no party affiliation | 29 | 189 | 854 | 1164 | 1189 | ||
CAN | Canada | parliament | 1945-06-11 | 3.6 | 2 | 245 | BPC | Bloc Populaire Canadien | Bloc Populaire Canadien | 29 | 189 | 854 | 1164 | 1307 | |
CAN | Canada | parliament | 1945-06-11 | 0.09 | 0 | 245 | no-seat | no seat | no seat | 29 | 189 | 854 | 1164 | 2067 | |
CAN | Canada | parliament | 1949-06-27 | 6 | 262 | none | no party affiliation | no party affiliation | 29 | 112 | 189 | 534 | 1189 | ||
CAN | Canada | parliament | 1949-06-27 | 1.47 | 0 | 262 | UE | Union [Candidats] des électeurs | Union of Electors | 29 | 112 | 189 | 534 | 2162 | |
CAN | Canada | parliament | 1953-08-10 | 4 | 265 | none | no party affiliation | no party affiliation | 29 | 292 | 112 | 750 | 1189 | ||
CAN | Canada | parliament | 1957-06-10 | 4 | 265 | none | no party affiliation | no party affiliation | 29 | 562 | 292 | 327 | 1189 | ||
CAN | Canada | parliament | 1957-06-10 | 0.12 | 0 | 265 | UE | Union [Candidats] des électeurs | Union of Electors | 29 | 562 | 292 | 327 | 2162 | |
CAN | Canada | parliament | 1965-11-08 | 4.66 | 9 | 265 | SCR | Ralliement créditiste | Social Credit Rally | 29 | 282 | 424 | 857 | 677 | |
CAN | Canada | parliament | 1965-11-08 | 2 | 265 | none | no party affiliation | no party affiliation | 29 | 282 | 424 | 857 | 1189 | ||
CAN | Canada | parliament | 1968-06-25 | 4.44 | 14 | 264 | SCR | Ralliement créditiste | Social Credit Rally | 29 | 91 | 282 | 565 | 677 | |
CAN | Canada | parliament | 1968-06-25 | 0.21 | 1 | 264 | none | no party affiliation | no party affiliation | 29 | 91 | 282 | 565 | 1189 | |
CAN | Canada | parliament | 1972-10-30 | 0.36 | 2 | 264 | none | no party affiliation | no party affiliation | 29 | 552 | 91 | 696 | 1189 | |
CAN | Canada | parliament | 1972-10-30 | 0.02 | 0 | 264 | PR | Parti Rhinoceros | Rhinoceros Party | 29 | 552 | 91 | 696 | 2148 | |
CAN | Canada | parliament | 1974-07-08 | 0.22 | 1 | 264 | none | no party affiliation | no party affiliation | 29 | 276 | 552 | 25 | 1189 | |
CAN | Canada | parliament | 1974-07-08 | 0.17 | 0 | 264 | no-seat | no seat | no seat | 29 | 276 | 552 | 25 | 2067 | |
CAN | Canada | parliament | 1979-05-22 | 0.55 | 0 | 282 | PR | Parti Rhinoceros | Rhinoceros Party | 29 | 683 | 276 | 783 | 2148 | |
CAN | Canada | parliament | 1980-02-18 | 1.01 | 0 | 282 | PR | Parti Rhinoceros | Rhinoceros Party | 29 | 139 | 683 | 751 | 2148 | |
CAN | Canada | parliament | 1984-09-04 | 0.26 | 1 | 282 | none | no party affiliation | no party affiliation | 29 | 159 | 139 | 670 | 1189 | |
CAN | Canada | parliament | 1984-09-04 | 0.79 | 0 | 282 | PR | Parti Rhinoceros | Rhinoceros Party | 29 | 159 | 139 | 670 | 2148 | |
CAN | Canada | parliament | 1993-10-25 | 0.15 | 1 | 295 | none | no party affiliation | no party affiliation | 29 | 546 | 96 | 704 | 1189 | |
CAN | Canada | parliament | 1997-06-02 | 0.13 | 1 | 301 | none | no party affiliation | no party affiliation | 29 | 650 | 546 | 785 | 1189 | |
CAN | Canada | parliament | 2004-06-28 | 0.11 | 1 | 308 | none | no party affiliation | no party affiliation | 29 | 240 | 455 | 103 | 1189 | |
CAN | Canada | parliament | 2006-01-23 | 0.14 | 1 | 308 | none | no party affiliation | no party affiliation | 29 | 137 | 240 | 308 | 1189 | |
CAN | Canada | parliament | 2008-10-14 | 0.31 | 2 | 308 | none | no party affiliation | no party affiliation | 29 | 601 | 137 | 610 | 1189 | |
CAN | Canada | parliament | 2011-05-02 | 0.1 | 0 | 308 | no-seat | no seat | no seat | 29 | 703 | 601 | 612 | 2067 | |
CAN | Canada | parliament | 2015-10-19 | 0.23 | 0 | 338 | none | no party affiliation | no party affiliation | 29 | 994 | 703 | 919 | 1189 | |
CAN | Canada | parliament | 2019-10-21 | 0.4 | 1 | 338 | none | no party affiliation | no party affiliation | 29 | 1084 | 994 | 1176 | 1189 | |
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 | 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 | EJ | Entente jurassienne | Agreement Jura | 40 | 435 | 371 | 20 | 1964 | ||
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 | KHM | Komitee Herbert Maeder | Committee Herbert Maeder | 40 | 631 | 435 | 723 | 1967 | ||
CHE | Switzerland | parliament | 1983-10-23 | 1 | 200 | one-seat | one seat | one seat | 40 | 631 | 435 | 723 | 2303 | ||
CHE | Switzerland | parliament | 1987-10-18 | 1 | 200 | KHM | Komitee Herbert Maeder | Committee Herbert Maeder | 40 | 358 | 631 | 129 | 1967 | ||
CHE | Switzerland | parliament | 1991-10-20 | 1 | 200 | EJ | Entente jurassienne | Agreement Jura | 40 | 521 | 358 | 426 | 1964 | ||
CHE | Switzerland | parliament | 1991-10-20 | 1 | 200 | KHM | Komitee Herbert Maeder | Committee Herbert Maeder | 40 | 521 | 358 | 426 | 1967 | ||
CHE | Switzerland | parliament | 2011-10-23 | 1 | 200 | one-seat | one seat | one seat | 40 | 779 | 310 | 903 | 2303 | ||
CHE | Switzerland | parliament | 2015-10-18 | 1 | 200 | etc | others | others | 40 | 995 | 779 | 989 | 2579 | ||
CYP | Cyprus | parliament | 1976-09-05 | 1.2 | 1 | 35 | none | no party affiliation | no party affiliation | 51 | 528 | 534 | |||
CYP | Cyprus | parliament | 1981-05-24 | 1.9 | 0 | 35 | NEDEPA | Nea Demokratiki Parataxi | New Democratic Front | 51 | 70 | 528 | 210 | 1778 | |
CYP | Cyprus | parliament | 2006-05-21 | 1.22 | 0 | 56 | KEP | K.E.P | Free Citizens Movement | 51 | 556 | 339 | 342 | 1735 | |
CYP | Cyprus | ep | 2014-05-25 | 1.05 | 0 | 6 | I-SL | Independent – Sener Levent | Independent -- Sener Levent | 51 | 819 | 701 | 1086 | 2343 | |
CYP | Cyprus | parliament | 2016-05-22 | 1.16 | 0 | 56 | KGTZTK | Kinima gia ta zoa tis Kíprou | Animal Party Cyprus | 51 | 1004 | 701 | 1086 | 2627 | |
CYP | Cyprus | parliament | 2021-05-30 | 1.0 | 0 | 56 | KGTZTK | Kinima gia ta zoa tis Kíprou | Animal Party Cyprus | 51 | 1095 | 1004 | 1628 | 2627 | |
CYP | Cyprus | parliament | 2021-05-30 | 1.35 | 0 | 56 | AM | Afypnisis 2020 | Awakening 2020 | 51 | 1095 | 1004 | 1628 | 2819 | |
CZE | Czech Republic | parliament | 1990-06-09 | 10.03 | 22 | 200 | HSD-SMS | Hnutí za samosprávnou demokracii – Společnost pro Moravu a Slezsko | Movement for Self-Governing Democracy -- Society for Moravia and Silesia | 68 | 63 | 19 | |||
CZE | Czech Republic | parliament | 1992-06-06 | 5.87 | 14 | 200 | HSD-SMS | Hnutí za samosprávnou demokracii – Společnost pro Moravu a Slezsko | Movement for Self-Governing Democracy -- Society for Moravia and Silesia | 68 | 39 | 63 | 262 | 19 | |
CZE | Czech Republic | parliament | 1992-06-06 | 1.37 | 0 | 200 | NEI | Nezávislá iniciativa | Independent Initiative | 68 | 39 | 63 | 262 | 2221 | |
CZE | Czech Republic | parliament | 1992-06-06 | 1.3 | 0 | 200 | SPP | Strana prátel piva | Party of the Friends of Beer | 68 | 39 | 63 | 262 | 2222 | |
CZE | Czech Republic | parliament | 2013-10-25 | 2.66 | 0 | 200 | Pi | Ceska piratska strana | Czech Pirate Party | 68 | 805 | 599 | 1062 | 2261 | |
CZE | Czech Republic | ep | 2014-05-24 | 4.78 | 0 | 21 | Pi | Ceska piratska strana | Czech Pirate Party | 68 | 820 | 805 | 1072 | 2261 | |
CZE | Czech Republic | parliament | 2017-10-21 | 10.79 | 22 | 200 | Pi | Ceska piratska strana | Czech Pirate Party | 68 | 1020 | 805 | 1072 | 2261 | |
CZE | Czech Republic | ep | 2019-05-25 | 13.95 | 3 | 21 | Pi | Ceska piratska strana | Czech Pirate Party | 68 | 1057 | 1020 | 1534 | 2261 | |
CZE | Czech Republic | ep | 2019-05-25 | 1.56 | 0 | 21 | ANO-VE | ANO, vytrollíme europarlament | Yes, We Will Troll the Euro-Parliament | 68 | 1057 | 1020 | 1534 | 2779 | |
CZE | Czech Republic | parliament | 2021-10-09 | 4.68 | 0 | 200 | P | Přísaha | Oath | 68 | 1099 | 1020 | 1534 | 2831 | |
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 | parliament | 1928-05-20 | 1.57 | 2 | 491 | VRP | Reichspartei für Volksrecht und Aufwertung | Reich Party for Civil Rights and Deflation | 54 | 1036 | 1035 | 1575 | 2710 | |
DEU | Germany | parliament | 1932-07-31 | 0.11 | 1 | 608 | VRP | Reichspartei für Volksrecht und Aufwertung | Reich Party for Civil Rights and Deflation | 54 | 1038 | 1037 | 1579 | 2710 | |
DEU | Germany | parliament | 1949-08-14 | 4.8 | 3 | 402 | none | parteilos | no party affiliation | 54 | 581 | 1040 | 1578 | 610 | |
DEU | Germany | parliament | 1949-08-14 | 0.3 | 1 | 402 | SSW | Südschleswigscher Wählerverband | South Schleswig Voter League | 54 | 581 | 1040 | 1578 | 2850 | |
DEU | Germany | parliament | 1949-08-14 | 0.9 | 0 | 402 | no-seat | no seat | no seat | 54 | 581 | 1040 | 1578 | 2034 | |
DEU | Germany | ep | 2004-06-13 | 1.3 | 0 | 99 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 18 | 385 | 529 | 301 | |
DEU | Germany | ep | 2004-06-13 | 1.2 | 0 | 99 | Grau | Die Grauen – Graue Panther | The Grays -- Gray Panthers | 54 | 18 | 385 | 529 | 292 | |
DEU | Germany | ep | 2009-06-07 | 1.1 | 0 | 99 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 231 | 118 | 85 | 301 | |
DEU | Germany | parliament | 2009-09-27 | 2.0 | 0 | 622 | Pi | Piratenpartei Deutschland | German Pirate Party | 54 | 93 | 118 | 85 | 865 | |
DEU | Germany | parliament | 2013-09-22 | 2.2 | 0 | 631 | Pi | Piratenpartei Deutschland | German Pirate Party | 54 | 800 | 93 | 472 | 865 | |
DEU | Germany | ep | 2014-05-25 | 2 | 96 | one-seat | one seat | one seat | 54 | 825 | 800 | 1071 | 2289 | ||
DEU | Germany | ep | 2014-05-25 | 1.2 | 1 | 96 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 825 | 800 | 1071 | 301 |
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;