view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_id
This data as json, CSV (advanced)
election_date (date) >30 ✖
- 2014-05-25 239
- 2019-05-26 234
- 2009-06-07 217
- 2004-06-13 193
- 1999-06-13 148
- 1989-06-18 122
- 1994-06-12 109
- 1984-06-17 87
- 1979-06-10 85
- 1996-10-20 36
- 2014-05-24 36
- 2019-05-25 36
- 1992-06-06 30
- 2011-12-04 30
- 2022-11-01 30
- 2004-06-12 26
- 1991-10-20 25
- 2006-04-09 25
- 2019-05-23 25
- 2007-11-25 24
- 2009-06-04 24
- 2012-06-17 24
- 1993-06-06 23
- 1994-03-27 22
- 1995-10-01 22
- 1990-06-09 21
- 1991-10-27 21
- 1990-04-08 19
- 1996-11-03 19
- 2015-11-08 19
- …
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 ▼ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LTU | Lithuania | parliament | 2020-10-11 | 4.97 | 3 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 1091 | 1009 | 1615 | 28 |
CZE | Czech Republic | parliament | 1990-06-09 | 2.68 | 0 | 200 | CNSP | Česká národně strana socialistická | Czech National Social(ist) Party | 8.8 | 68 | 63 | 29 | ||
CZE | Czech Republic | parliament | 1996-06-01 | 2.05 | 0 | 200 | CNSP | Česká národně strana socialistická | Czech National Social(ist) Party | 8.8 | 68 | 301 | 39 | 835 | 29 |
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 | ||
IRL | Ireland | ep | 1999-06-13 | 3.67 | 1 | 15 | none | no party affiliation | no party affiliation | 37 | 491 | 316 | 126 | 30 | |
IRL | Ireland | parliament | 2002-05-17 | 12 | 166 | none | no party affiliation | no party affiliation | 37 | 408 | 316 | 126 | 30 | ||
IRL | Ireland | ep | 2004-06-13 | 5.0 | 1 | 13 | none | no party affiliation | no party affiliation | 37 | 123 | 408 | 179 | 30 | |
IRL | Ireland | parliament | 2007-05-24 | 5 | 166 | none | no party affiliation | no party affiliation | 37 | 190 | 408 | 179 | 30 | ||
IRL | Ireland | parliament | 2011-02-25 | 12.17 | 14 | 166 | none | no party affiliation | no party affiliation | 37 | 698 | 190 | 173 | 30 | |
IRL | Ireland | parliament | 2016-02-26 | 11.14 | 12 | 158 | none | no party affiliation | no party affiliation | 37 | 1002 | 698 | 904 | 30 | |
IRL | Ireland | ep | 2019-05-24 | 15.74 | 1 | 11 | none | no party affiliation | no party affiliation | 37 | 1061 | 1002 | 1511 | 30 | |
IRL | Ireland | parliament | 2020-02-08 | 12.2 | 19 | 160 | none | no party affiliation | no party affiliation | 37 | 1088 | 1002 | 1511 | 30 | |
ISR | Israel | parliament | 1984-07-23 | 1.6 | 2 | 120 | Mo | Morasha | Heritage | 34 | 714 | 713 | 1114 | 31 | |
LVA | Latvia | parliament | 1993-06-06 | 12.0 | 13 | 100 | TSP | Tautas Saskaņas Partija | National Harmony Party | 1.864 | 55 | 564 | 647 | 595 | 32 |
LVA | Latvia | parliament | 1995-10-01 | 5.55 | 6 | 100 | TSP | Tautas Saskaņas Partija | National Harmony Party | 1.864 | 55 | 534 | 564 | 201 | 32 |
LVA | Latvia | parliament | 1998-10-03 | 14.12 | 16 | 100 | TSP | Tautas Saskaņas Partija | National Harmony Party | 1.864 | 55 | 615 | 534 | 2 | 32 |
LVA | Latvia | ep | 2004-06-13 | 4.77 | 0 | 9 | TSP | Tautas Saskaņas Partija | National Harmony Party | 1.864 | 55 | 145 | 260 | 153 | 32 |
CHE | Switzerland | parliament | 1902-10-26 | 12.6 | 7 | 167 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 982 | 35 | ||
CHE | Switzerland | parliament | 1905-10-29 | 14.66 | 2 | 167 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 981 | 982 | 1456 | 35 |
CHE | Switzerland | parliament | 1908-10-25 | 17.58 | 7 | 167 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 980 | 981 | 1457 | 35 |
CHE | Switzerland | parliament | 1911-10-29 | 19.97 | 15 | 189 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 979 | 980 | 1458 | 35 |
CHE | Switzerland | parliament | 1914-10-25 | 10.05 | 19 | 189 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 978 | 979 | 1459 | 35 |
CHE | Switzerland | parliament | 1917-10-28 | 30.77 | 20 | 189 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 977 | 978 | 1463 | 35 |
CHE | Switzerland | parliament | 1919-10-26 | 23.5 | 41 | 189 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 770 | 977 | 1464 | 35 |
CHE | Switzerland | parliament | 1922-10-29 | 23.3 | 43 | 198 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 773 | 770 | 981 | 35 |
CHE | Switzerland | parliament | 1925-10-25 | 25.8 | 49 | 198 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 774 | 773 | 980 | 35 |
CHE | Switzerland | parliament | 1928-10-28 | 27.4 | 50 | 198 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 772 | 774 | 979 | 35 |
CHE | Switzerland | parliament | 1931-10-25 | 28.7 | 49 | 187 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 768 | 772 | 978 | 35 |
CHE | Switzerland | parliament | 1935-10-27 | 28.0 | 50 | 187 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 769 | 768 | 975 | 35 |
CHE | Switzerland | parliament | 1939-10-29 | 25.9 | 45 | 187 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 767 | 769 | 974 | 35 |
CHE | Switzerland | parliament | 1943-10-31 | 28.6 | 56 | 194 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 771 | 767 | 973 | 35 |
CHE | Switzerland | parliament | 1947-10-26 | 26.2 | 48 | 194 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 684 | 771 | 972 | 35 |
CHE | Switzerland | parliament | 1951-10-28 | 26.0 | 49 | 196 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 21 | 684 | 556 | 35 |
CHE | Switzerland | parliament | 1955-10-30 | 27.0 | 53 | 196 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 30 | 21 | 814 | 35 |
CHE | Switzerland | parliament | 1959-10-25 | 26.4 | 51 | 196 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 674 | 30 | 635 | 35 |
CHE | Switzerland | parliament | 1963-10-27 | 26.6 | 53 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 108 | 674 | 623 | 35 |
CHE | Switzerland | parliament | 1967-10-29 | 23.5 | 50 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 373 | 108 | 513 | 35 |
CHE | Switzerland | parliament | 1971-10-31 | 22.9 | 46 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 176 | 373 | 777 | 35 |
CHE | Switzerland | parliament | 1975-10-26 | 24.9 | 55 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 371 | 176 | 79 | 35 |
CHE | Switzerland | parliament | 1979-10-21 | 24.4 | 51 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 435 | 371 | 20 | 35 |
CHE | Switzerland | parliament | 1983-10-23 | 22.8 | 47 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 631 | 435 | 723 | 35 |
CHE | Switzerland | parliament | 1987-10-18 | 18.4 | 41 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 358 | 631 | 129 | 35 |
CHE | Switzerland | parliament | 1991-10-20 | 18.5 | 41 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 521 | 358 | 426 | 35 |
CHE | Switzerland | parliament | 1995-10-22 | 21.8 | 54 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 105 | 521 | 773 | 35 |
CHE | Switzerland | parliament | 1999-10-24 | 22.5 | 51 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 427 | 105 | 38 | 35 |
CHE | Switzerland | parliament | 2003-10-19 | 23.3 | 52 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 206 | 427 | 198 | 35 |
CHE | Switzerland | parliament | 2007-10-21 | 19.5 | 43 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 310 | 206 | 855 | 35 |
CHE | Switzerland | parliament | 2011-10-23 | 18.72 | 46 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 779 | 310 | 903 | 35 |
CHE | Switzerland | parliament | 2015-10-18 | 18.84 | 43 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 995 | 779 | 989 | 35 |
CHE | Switzerland | parliament | 2019-10-20 | 16.84 | 39 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 1083 | 995 | 1212 | 35 |
DEU | Germany | ep | 2009-06-07 | 1.7 | 0 | 99 | FW | Freie Wähler | Free Voters | 7.4 | 54 | 231 | 118 | 85 | 41 |
DEU | Germany | ep | 2014-05-25 | 1.5 | 1 | 96 | FW | Freie Wähler | Free Voters | 7.4 | 54 | 825 | 800 | 1071 | 41 |
DEU | Germany | parliament | 2017-09-24 | 1.0 | 0 | 709 | FW | Freie Wähler | Free Voters | 7.4 | 54 | 1016 | 800 | 1071 | 41 |
DEU | Germany | ep | 2019-05-26 | 2.2 | 2 | 96 | FW | Freie Wähler | Free Voters | 7.4 | 54 | 1055 | 1016 | 1528 | 41 |
DEU | Germany | parliament | 2021-09-26 | 2.43 | 0 | 736 | FW | Freie Wähler | Free Voters | 7.4 | 54 | 1096 | 1016 | 1528 | 41 |
LVA | Latvia | parliament | 1990-04-29 | 68.2 | 131 | 201 | LTF | Latvijas Tautas fronte | Popular Front of Latvia | 55 | 647 | 42 | |||
LVA | Latvia | parliament | 1993-06-06 | 2.63 | 0 | 100 | LTF | Latvijas Tautas fronte | Popular Front of Latvia | 55 | 564 | 647 | 595 | 42 | |
LVA | Latvia | parliament | 1995-10-01 | 1.16 | 0 | 100 | LTF | Latvijas Tautas fronte | Popular Front of Latvia | 55 | 534 | 564 | 201 | 42 | |
SVK | Slovakia | parliament | 1994-10-01 | 2.72 | 0 | 150 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 119 | 294 | 817 | 44 |
SVK | Slovakia | parliament | 1998-09-26 | 2.79 | 0 | 150 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 349 | 119 | 26 | 44 |
SVK | Slovakia | parliament | 2002-09-21 | 6.32 | 11 | 150 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 218 | 349 | 699 | 44 |
SVK | Slovakia | ep | 2004-06-13 | 4.54 | 0 | 14 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 124 | 218 | 547 | 44 |
SVK | Slovakia | parliament | 2006-06-17 | 3.88 | 0 | 150 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 192 | 218 | 185 | 44 |
SVK | Slovakia | ep | 2009-06-07 | 1.65 | 0 | 13 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 441 | 192 | 269 | 44 |
SVK | Slovakia | ep | 2014-05-25 | 1.52 | 0 | 13 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 847 | 781 | 1027 | 44 |
GRC | Greece | parliament | 1974-11-17 | 54.4 | 220 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 653 | 47 | ||
GRC | Greece | parliament | 1977-11-20 | 41.8 | 171 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 596 | 653 | 609 | 47 |
GRC | Greece | ep | 1981-01-01 | 15 | 24 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 245 | 596 | 531 | 47 | |
GRC | Greece | parliament | 1981-10-18 | 35.9 | 115 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 227 | 596 | 531 | 47 |
GRC | Greece | ep | 1981-10-18 | 31.3 | 8 | 24 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 147 | 596 | 531 | 47 |
GRC | Greece | ep | 1984-06-17 | 38.0 | 9 | 24 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 87 | 227 | 713 | 47 |
GRC | Greece | parliament | 1985-06-02 | 40.8 | 126 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 453 | 227 | 713 | 47 |
GRC | Greece | parliament | 1989-06-18 | 44.3 | 145 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 205 | 453 | 39 | 47 |
GRC | Greece | ep | 1989-06-18 | 40.4 | 10 | 24 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 518 | 453 | 39 | 47 |
GRC | Greece | parliament | 1989-11-05 | 46.2 | 148 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 508 | 205 | 721 | 47 |
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;