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 | 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 | |
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 | 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 | 1925-10-29 | 0.74 | 2 | 245 | none | no party affiliation | no party affiliation | 29 | 860 | 861 | 1168 | 1189 | |
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 | 1930-07-28 | 0.65 | 3 | 245 | none | no party affiliation | no party affiliation | 29 | 858 | 859 | 1167 | 1189 | |
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 | 1949-06-27 | 6 | 262 | none | no party affiliation | no party affiliation | 29 | 112 | 189 | 534 | 1189 | ||
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 | 1965-11-08 | 2 | 265 | none | no party affiliation | no party affiliation | 29 | 282 | 424 | 857 | 1189 | ||
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 | 1974-07-08 | 0.22 | 1 | 264 | none | no party affiliation | no party affiliation | 29 | 276 | 552 | 25 | 1189 | |
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 | 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 | 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 | |
CYP | Cyprus | parliament | 1976-09-05 | 1.2 | 1 | 35 | none | no party affiliation | no party affiliation | 51 | 528 | 534 | |||
DEU | Germany | parliament | 1949-08-14 | 4.8 | 3 | 402 | none | parteilos | no party affiliation | 54 | 581 | 1040 | 1578 | 610 | |
DNK | Denmark | parliament | 1903-06-16 | 1 | 114 | none | ingen | no party affiliation | 21 | 887 | 886 | 1365 | 1128 | ||
DNK | Denmark | parliament | 1906-05-29 | 3.0 | 4 | 114 | none | ingen | no party affiliation | 21 | 888 | 887 | 1364 | 1128 | |
DNK | Denmark | parliament | 1909-05-25 | 5.7 | 6 | 114 | none | ingen | no party affiliation | 21 | 889 | 888 | 1363 | 1128 | |
DNK | Denmark | parliament | 1910-05-20 | 0.4 | 0 | 114 | none | ingen | no party affiliation | 21 | 890 | 889 | 1361 | 1128 | |
DNK | Denmark | parliament | 1913-05-20 | 0.7 | 0 | 114 | none | ingen | no party affiliation | 21 | 891 | 890 | 1360 | 1128 | |
DNK | Denmark | parliament | 1915-05-07 | 1 | 114 | none | ingen | no party affiliation | 21 | 999 | 891 | 1253 | 1128 | ||
DNK | Denmark | parliament | 1943-03-23 | 0.0 | 0 | 148 | none | ingen | no party affiliation | 21 | 901 | 900 | 1241 | 1128 | |
DNK | Denmark | parliament | 1994-09-21 | 1.0 | 1 | 179 | none | ingen | no party affiliation | 21 | 89 | 157 | 740 | 1128 | |
FIN | Finland | parliament | 1983-03-21 | 0.5 | 1 | 200 | none | ei kukaan – ingen | no party affiliation | 67 | 133 | 84 | 34 | 1119 | |
FRA | France | parliament | 1945-10-21 | 2 | 522 | none | sans étiquette | no party affiliation | 43 | 471 | 983 | 329 | 947 | ||
FRA | France | parliament | 2007-06-17 | 1 | 577 | none | sans étiquette | no party affiliation | 43 | 171 | 403 | 807 | 947 | ||
FRA | France | parliament | 2017-06-18 | 5 | 577 | none | sans étiquette | no party affiliation | 43 | 1014 | 782 | 1508 | 947 | ||
FRA | France | parliament | 2022-06-19 | 1.28 | 10 | 577 | none | sans étiquette | no party affiliation | 43 | 1110 | 1014 | 1673 | 947 | |
GBR | United Kingdom | parliament | 1918-12-14 | 0.09 | 1 | 707 | none | no party affiliation | no party affiliation | 44 | 905 | 1599 | |||
GBR | United Kingdom | parliament | 1974-10-10 | 1 | 635 | none | no party affiliation | no party affiliation | 44 | 40 | 568 | 419 | 1599 | ||
GRC | Greece | parliament | 1990-04-08 | 4 | 300 | none | no party affiliation | no party affiliation | 41 | 284 | 508 | 716 | 1358 | ||
HRV | Croatia | parliament | 2000-01-03 | 0.7 | 3 | 151 | none | no party affiliation | no party affiliation | 62 | 797 | 2197 | |||
HRV | Croatia | parliament | 2003-11-23 | 2.3 | 4 | 152 | none | no party affiliation | no party affiliation | 62 | 795 | 797 | 1051 | 2197 | |
HUN | Hungary | parliament | 1990-04-08 | 1.0 | 7 | 386 | none | független | no party affiliation | 39 | 257 | 1617 | |||
HUN | Hungary | parliament | 1998-05-24 | 2.3 | 1 | 386 | none | független | no party affiliation | 39 | 671 | 620 | 488 | 1617 | |
HUN | Hungary | parliament | 2010-04-25 | 1 | 386 | none | független | no party affiliation | 39 | 688 | 194 | 162 | 1617 | ||
HUN | Hungary | parliament | 2022-04-03 | 1 | 199 | none | független | no party affiliation | 39 | 1107 | 1023 | 1531 | 1617 | ||
IRL | Ireland | parliament | 1922-06-22 | 7.8 | 9 | 128 | none | no party affiliation | no party affiliation | 37 | 912 | 30 | |||
IRL | Ireland | parliament | 1923-08-27 | 8.1 | 13 | 153 | none | no party affiliation | no party affiliation | 37 | 913 | 912 | 1446 | 30 | |
IRL | Ireland | parliament | 1927-06-09 | 13.4 | 16 | 153 | none | no party affiliation | no party affiliation | 37 | 914 | 913 | 1438 | 30 | |
IRL | Ireland | parliament | 1927-09-15 | 7.9 | 12 | 153 | none | no party affiliation | no party affiliation | 37 | 915 | 914 | 1439 | 30 | |
IRL | Ireland | parliament | 1932-02-16 | 10.4 | 14 | 153 | none | no party affiliation | no party affiliation | 37 | 917 | 915 | 1440 | 30 | |
IRL | Ireland | parliament | 1933-01-24 | 5.0 | 9 | 153 | none | no party affiliation | no party affiliation | 37 | 918 | 917 | 1441 | 30 | |
IRL | Ireland | parliament | 1937-07-01 | 9.7 | 8 | 138 | none | no party affiliation | no party affiliation | 37 | 919 | 918 | 1442 | 30 | |
IRL | Ireland | parliament | 1938-06-17 | 4.7 | 7 | 138 | none | no party affiliation | no party affiliation | 37 | 920 | 919 | 1443 | 30 | |
IRL | Ireland | parliament | 1943-06-23 | 8.7 | 11 | 138 | none | no party affiliation | no party affiliation | 37 | 921 | 920 | 1444 | 30 | |
IRL | Ireland | parliament | 1944-05-30 | 7.79 | 11 | 138 | none | no party affiliation | no party affiliation | 37 | 122 | 921 | 1445 | 30 | |
IRL | Ireland | parliament | 1948-02-04 | 12 | 147 | none | no party affiliation | no party affiliation | 37 | 60 | 122 | 151 | 30 | ||
IRL | Ireland | parliament | 1951-05-30 | 14 | 147 | none | no party affiliation | no party affiliation | 37 | 515 | 60 | 154 | 30 | ||
IRL | Ireland | parliament | 1954-05-18 | 5 | 147 | none | no party affiliation | no party affiliation | 37 | 584 | 515 | 643 | 30 | ||
IRL | Ireland | parliament | 1957-03-05 | 9 | 147 | none | no party affiliation | no party affiliation | 37 | 469 | 584 | 626 | 30 | ||
IRL | Ireland | parliament | 1961-10-04 | 6 | 144 | none | no party affiliation | no party affiliation | 37 | 413 | 469 | 364 | 30 | ||
IRL | Ireland | parliament | 1965-04-07 | 2 | 144 | none | no party affiliation | no party affiliation | 37 | 323 | 413 | 667 | 30 | ||
IRL | Ireland | parliament | 1969-06-18 | 1 | 144 | none | no party affiliation | no party affiliation | 37 | 641 | 323 | 602 | 30 | ||
IRL | Ireland | parliament | 1973-02-28 | 2 | 144 | none | no party affiliation | no party affiliation | 37 | 283 | 641 | 863 | 30 | ||
IRL | Ireland | parliament | 1977-06-16 | 4 | 148 | none | no party affiliation | no party affiliation | 37 | 6 | 283 | 315 | 30 | ||
IRL | Ireland | parliament | 1981-06-11 | 4 | 166 | none | no party affiliation | no party affiliation | 37 | 47 | 6 | 442 | 30 | ||
IRL | Ireland | parliament | 1982-02-18 | 4 | 166 | none | no party affiliation | no party affiliation | 37 | 228 | 47 | 335 | 30 | ||
IRL | Ireland | parliament | 1982-11-24 | 3 | 166 | none | no party affiliation | no party affiliation | 37 | 307 | 228 | 54 | 30 | ||
IRL | Ireland | parliament | 1987-02-17 | 3 | 166 | none | no party affiliation | no party affiliation | 37 | 43 | 307 | 867 | 30 | ||
IRL | Ireland | parliament | 1989-06-15 | 4 | 166 | none | no party affiliation | no party affiliation | 37 | 590 | 43 | 77 | 30 | ||
IRL | Ireland | parliament | 1992-11-25 | 5 | 166 | none | no party affiliation | no party affiliation | 37 | 359 | 590 | 870 | 30 | ||
IRL | Ireland | parliament | 1997-06-06 | 6 | 166 | none | no party affiliation | no party affiliation | 37 | 316 | 359 | 573 | 30 |
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;