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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUS | Australia | parliament | 1901-03-30 | 1.4 | 1 | 75 | none | no party affiliation | no party affiliation | 33 | 731 | 1396 | |||
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 | 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 | 1910-04-13 | 0.4 | 0 | 75 | no-seat | no seat | no seat | 33 | 747 | 725 | 1002 | 2057 | |
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 | 2.4 | 3 | 75 | NF-NSW | Nationalist and Farmers (NSW) | Nationalist and Farmers (NSW) | 33 | 723 | 750 | 1010 | 1918 | |
AUS | Australia | parliament | 1919-12-13 | 1.7 | 1 | 75 | INAT | Independet Nationalist | Independet Nationalist | 33 | 723 | 750 | 1010 | 1903 | |
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 | 1922-12-16 | 0.7 | 0 | 76 | no-seat | no seat | no seat | 33 | 726 | 723 | 1011 | 2057 | |
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 | 3.9 | 3 | 76 | INAT | Independet Nationalist | Independet Nationalist | 33 | 729 | 728 | 1014 | 1903 | |
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 | 1934-09-15 | 4.7 | 0 | 75 | SCP | Social Credit Party | Social Credit Party | 33 | 746 | 744 | 1016 | 1911 | |
AUS | Australia | parliament | 1937-10-23 | 0.7 | 1 | 75 | one-seat | one seat | one seat | 33 | 745 | 746 | 1017 | 2299 | |
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 | 1937-10-23 | 0.71 | 1 | 75 | IUAP-NSW | Independent UAP (NSW) | Independent UAP (NSW) | 33 | 745 | 746 | 1017 | 1941 | |
AUS | Australia | parliament | 1937-10-23 | 2.2 | 0 | 75 | SCP | Social Credit Party | Social Credit Party | 33 | 745 | 746 | 1017 | 1911 | |
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 | 1940-09-21 | 0.8 | 1 | 75 | one-seat | one seat | one seat | 33 | 738 | 745 | 1021 | 2299 | |
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 | 1943-08-21 | 2.1 | 0 | 75 | OPA | One Parliament for Australia | One Parliament for Australia | 33 | 737 | 738 | 995 | 1936 | |
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 | 1946-09-28 | 1.2 | 0 | 75 | SPA | Services Party of Australia | Services Party of Australia | 33 | 739 | 737 | 574 | 1897 | |
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 | |
AUS | Australia | parliament | 1958-11-22 | 1.3 | 0 | 124 | none | no party affiliation | no party affiliation | 33 | 749 | 742 | 479 | 1396 | |
AUS | Australia | parliament | 1961-12-09 | 1.4 | 0 | 124 | none | no party affiliation | no party affiliation | 33 | 740 | 749 | 627 | 1396 | |
AUS | Australia | parliament | 1963-11-30 | 1.0 | 0 | 124 | none | no party affiliation | no party affiliation | 33 | 741 | 740 | 288 | 1396 | |
AUS | Australia | parliament | 1966-11-26 | 2.7 | 1 | 124 | none | no party affiliation | no party affiliation | 33 | 764 | 741 | 261 | 1396 | |
AUS | Australia | parliament | 1969-10-25 | 2.8 | 0 | 125 | none | no party affiliation | no party affiliation | 33 | 735 | 764 | 795 | 1396 | |
AUS | Australia | parliament | 1972-12-02 | 1.3 | 0 | 125 | none | no party affiliation | no party affiliation | 33 | 759 | 735 | 671 | 1396 | |
AUS | Australia | parliament | 1975-12-13 | 1.7 | 0 | 127 | none | no party affiliation | no party affiliation | 33 | 757 | 758 | 720 | 1396 | |
AUS | Australia | parliament | 1977-12-10 | 1.4 | 0 | 124 | none | no party affiliation | no party affiliation | 33 | 755 | 757 | 836 | 1396 | |
AUS | Australia | parliament | 1980-10-18 | 1.7 | 0 | 125 | none | no party affiliation | no party affiliation | 33 | 736 | 755 | 421 | 1396 | |
AUS | Australia | parliament | 1983-03-05 | 1.7 | 0 | 125 | none | no party affiliation | no party affiliation | 33 | 751 | 736 | 774 | 1396 | |
AUS | Australia | parliament | 1984-12-01 | 1.4 | 0 | 148 | none | no party affiliation | no party affiliation | 33 | 733 | 751 | 576 | 1396 | |
AUS | Australia | parliament | 1987-07-11 | 2.0 | 0 | 148 | none | no party affiliation | no party affiliation | 33 | 732 | 733 | 401 | 1396 | |
AUS | Australia | parliament | 1990-03-24 | 3.4 | 1 | 148 | none | no party affiliation | no party affiliation | 33 | 752 | 732 | 875 | 1396 | |
AUS | Australia | parliament | 1993-03-13 | 4.7 | 2 | 147 | none | no party affiliation | no party affiliation | 33 | 753 | 752 | 725 | 1396 | |
AUS | Australia | parliament | 1996-03-02 | 4.3 | 5 | 148 | none | no party affiliation | no party affiliation | 33 | 754 | 753 | 49 | 1396 | |
AUS | Australia | parliament | 1998-10-03 | 4.2 | 1 | 148 | none | no party affiliation | no party affiliation | 33 | 756 | 754 | 402 | 1396 | |
AUS | Australia | parliament | 2001-11-10 | 4.4 | 3 | 150 | none | no party affiliation | no party affiliation | 33 | 760 | 756 | 423 | 1396 | |
AUS | Australia | parliament | 2004-10-09 | 4.0 | 3 | 150 | none | no party affiliation | no party affiliation | 33 | 762 | 760 | 812 | 1396 | |
AUS | Australia | parliament | 2007-11-24 | 3.7 | 2 | 150 | none | no party affiliation | no party affiliation | 33 | 761 | 762 | 234 | 1396 | |
AUS | Australia | parliament | 2010-08-21 | 2.52 | 4 | 150 | none | no party affiliation | no party affiliation | 33 | 246 | 761 | 736 | 1396 | |
AUS | Australia | parliament | 2013-09-07 | 1.37 | 2 | 150 | none | no party affiliation | no party affiliation | 33 | 804 | 246 | 1061 | 1396 | |
AUS | Australia | parliament | 2016-07-02 | 2.81 | 2 | 150 | none | no party affiliation | no party affiliation | 33 | 1006 | 804 | 1174 | 1396 | |
AUS | Australia | parliament | 2019-05-18 | 3.37 | 3 | 151 | none | no party affiliation | no party affiliation | 33 | 1087 | 1006 | 1585 | 1396 | |
AUS | Australia | parliament | 2022-05-21 | 5.29 | 10 | 151 | none | no party affiliation | no party affiliation | 33 | 1111 | 1087 | 1616 | 1396 | |
AUT | Austria | parliament | 1919-02-16 | 1.49 | 4 | 170 | one-seat | one-seat | one-seat | 59 | 1030 | 2686 | |||
AUT | Austria | parliament | 1919-02-16 | 2.27 | 1 | 170 | T | Tschechoslowaken | Czechoslovakians | 59 | 1030 | 2689 | |||
AUT | Austria | parliament | 1920-10-17 | 1.44 | 1 | 183 | one-seat | one-seat | one-seat | 59 | 1026 | 1030 | 1537 | 2686 | |
AUT | Austria | parliament | 1923-10-21 | 2.88 | 0 | 165 | etc | others | others | 59 | 1027 | 1026 | 1542 | 2687 | |
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 | |
AUT | Austria | parliament | 1994-10-09 | 0.9 | 0 | 183 | Nein | Nein – Bürgerinitiative gegen die EU Mitgliedschaft | No -- Citizens' Initiative against EU membership | 59 | 66 | 325 | 524 | 1744 | |
AUT | Austria | parliament | 1995-12-17 | 1.1 | 0 | 183 | Nein | Nein – Bürgerinitiative gegen die EU Mitgliedschaft | No -- Citizens' Initiative against EU membership | 59 | 162 | 66 | 294 | 1744 | |
AUT | Austria | ep | 1996-10-13 | 1.28 | 0 | 21 | N | Die Neutralen – Bürgerinitiative | Citizens' Initiative for the retention of neutrality | 59 | 22 | 162 | 323 | 1750 | |
AUT | Austria | parliament | 1999-10-03 | 1.0 | 0 | 183 | DU | Die Unabhängigen – Liste Lugner | The Independents -- Lugner's List | 59 | 492 | 162 | 412 | 1745 | |
AUT | Austria | ep | 2014-05-25 | 2.76 | 0 | 18 | EU-STOP | EU-Austritt, Direkte Demokratie, Neutralität | EU Withdrawal, Direct Democracy, Neutrality | 59 | 818 | 802 | 1070 | 2340 | |
AUT | Austria | parliament | 2017-10-15 | 1.0 | 0 | 183 | GILT | Liste Roland Düringer – Meine Stimme GILT | My Vote Counts! | 59 | 1019 | 802 | 1485 | 2652 | |
BEL | Belgium | parliament | 1900-05-27 | 2 | 152 | etc | others | others | 64 | 868 | 2488 | ||||
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 | 1919-11-16 | 4.7 | 186 | etc | others | others | 64 | 876 | 875 | 1281 | 2488 | ||
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.5 | 1 | 186 | one-seat | one seat | one seat | 64 | 877 | 876 | 1279 | 2300 | |
BEL | Belgium | parliament | 1921-11-20 | 0.3 | 186 | no-seat | no seat | no seat | 64 | 877 | 876 | 1279 | 2052 | ||
BEL | Belgium | parliament | 1925-08-05 | 2.5 | 3 | 187 | etc | others | others | 64 | 878 | 877 | 1277 | 2488 | |
BEL | Belgium | parliament | 1929-05-25 | 1.9 | 6 | 187 | one-seat | one seat | one seat | 64 | 879 | 878 | 1275 | 2300 | |
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.55 | 1 | 202 | one-seat | one seat | one seat | 64 | 882 | 881 | 1301 | 2300 | |
BEL | Belgium | parliament | 1939-04-02 | 0.54 | 1 | 202 | etc | others | others | 64 | 882 | 881 | 1301 | 2488 | |
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 | 2.16 | 1 | 202 | UDB | Union Democratique Belge | Belgian Democratic Union | 64 | 19 | 882 | 204 | 1181 | |
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.88 | 1 | 212 | one-seat | one seat | one seat | 64 | 425 | 573 | 144 | 2300 | |
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 | 2 | 212 | one-seat | one seat | one seat | 64 | 150 | 425 | 613 | 2300 | ||
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 | |
BGR | Bulgaria | parliament | 1991-10-13 | 1.82 | 0 | 240 | FTB | Federatsiya Tsarstvo Balgariya | Kingdom of Bulgaria Confederation | 10 | 32 | 800 | |||
BGR | Bulgaria | parliament | 1994-12-18 | 1.41 | 0 | 240 | FTB | Federatsiya Tsarstvo Balgariya | Kingdom of Bulgaria Confederation | 10 | 355 | 32 | 109 | 800 | |
BGR | Bulgaria | parliament | 1997-04-19 | 1.12 | 0 | 240 | OT-SII | Obedinenie za Tsar [Simeon II] | Union for Tzar [Simeon II] | 10 | 126 | 355 | 714 | 1149 | |
BGR | Bulgaria | parliament | 2001-06-18 | 1.7 | 0 | 240 | OT-SII | Obedinenie za Tsar [Simeon II] | Union for Tzar [Simeon II] | 10 | 681 | 126 | 792 | 1149 |
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;