view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by seats_total
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MLT | Malta | ep | 2004-06-13 | 48.42 | 3 | 5 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 346 | 509 | 298 | 1003 |
MLT | Malta | ep | 2004-06-13 | 39.75 | 2 | 5 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 346 | 509 | 298 | 984 |
MLT | Malta | ep | 2004-06-13 | 9.33 | 0 | 5 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 346 | 509 | 298 | 360 |
MLT | Malta | ep | 2009-06-06 | 54.77 | 3 | 5 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 555 | 203 | 468 | 1003 |
MLT | Malta | ep | 2009-06-06 | 40.49 | 2 | 5 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 555 | 203 | 468 | 984 |
MLT | Malta | ep | 2009-06-06 | 1.47 | 0 | 5 | IE | Imperu Ewropew | Imperium Europa | 8.8 | 72 | 555 | 203 | 468 | 1400 |
MLT | Malta | ep | 2009-06-06 | 2.34 | 0 | 5 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 555 | 203 | 468 | 360 |
CYP | Cyprus | ep | 2004-06-13 | 27.89 | 2 | 6 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 397 | 339 | 342 | 572 |
CYP | Cyprus | ep | 2004-06-13 | 28.23 | 2 | 6 | DISY | Dimokratikós Sinayermós | Democratic Rally | 8.6842 | 51 | 397 | 339 | 342 | 1575 |
CYP | Cyprus | ep | 2004-06-13 | 17.09 | 1 | 6 | DIKO | Dimokratikó Kómma | Democratic Party | 5.1316 | 51 | 397 | 339 | 342 | 851 |
CYP | Cyprus | ep | 2004-06-13 | 10.8 | 1 | 6 | GTE | Gia tin Evropi | For Europe | 7.4 | 51 | 397 | 339 | 342 | 768 |
CYP | Cyprus | ep | 2004-06-13 | 10.79 | 0 | 6 | EDEK | Kinima Sosialdimokraton EDEK | Movement for Social Democracy EDEK | 3.2895 | 51 | 397 | 339 | 342 | 945 |
CYP | Cyprus | ep | 2004-06-13 | 1.95 | 0 | 6 | ED | Enomeni Dimokrates | United Democrats | 7.1053 | 51 | 397 | 339 | 342 | 1523 |
CYP | Cyprus | ep | 2004-06-13 | 1.65 | 0 | 6 | NO | Neoi Orizontes | New Horizons | 9.3421 | 51 | 397 | 339 | 342 | 6 |
CYP | Cyprus | ep | 2009-06-06 | 34.9 | 2 | 6 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 28 | 556 | 289 | 572 |
CYP | Cyprus | ep | 2009-06-06 | 35.65 | 2 | 6 | DISY | Dimokratikós Sinayermós | Democratic Rally | 8.6842 | 51 | 28 | 556 | 289 | 1575 |
CYP | Cyprus | ep | 2009-06-06 | 9.85 | 1 | 6 | EDEK | Kinima Sosialdimokraton EDEK | Movement for Social Democracy EDEK | 3.2895 | 51 | 28 | 556 | 289 | 945 |
CYP | Cyprus | ep | 2009-06-06 | 12.28 | 1 | 6 | DIKO | Dimokratikó Kómma | Democratic Party | 5.1316 | 51 | 28 | 556 | 289 | 851 |
CYP | Cyprus | ep | 2009-06-06 | 1.5 | 0 | 6 | KOP | Kinima Oikologoi Perivallontistoi | Ecological and Environmental Movement | 5.7895 | 51 | 28 | 556 | 289 | 1621 |
CYP | Cyprus | ep | 2009-06-06 | 4.12 | 0 | 6 | EK | Evropaiko Komma | European Party | 6.0 | 51 | 28 | 556 | 289 | 491 |
CYP | Cyprus | ep | 2014-05-25 | 37.75 | 2 | 6 | DISY | Dimokratikós Sinayermós | Democratic Rally | 8.6842 | 51 | 819 | 701 | 1086 | 1575 |
CYP | Cyprus | ep | 2014-05-25 | 26.98 | 2 | 6 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 819 | 701 | 1086 | 572 |
CYP | Cyprus | ep | 2014-05-25 | 10.83 | 1 | 6 | DIKO | Dimokratikó Kómma | Democratic Party | 5.1316 | 51 | 819 | 701 | 1086 | 851 |
CYP | Cyprus | ep | 2014-05-25 | 7.68 | 1 | 6 | EDEK | Kinima Sosialdimokraton EDEK | Movement for Social Democracy EDEK | 3.2895 | 51 | 819 | 701 | 1086 | 945 |
CYP | Cyprus | ep | 2014-05-25 | 6.78 | 0 | 6 | SYM | Symmaxia | Citizen's Alliance | 3.3 | 51 | 819 | 701 | 1086 | 2341 |
CYP | Cyprus | ep | 2014-05-25 | 2.69 | 0 | 6 | ELAM | Ethniko Laiko Metopo | National Popular Front | 8.8 | 51 | 819 | 701 | 1086 | 1768 |
CYP | Cyprus | ep | 2014-05-25 | 3.83 | 0 | 6 | ME | Minima Elpidas | Message of Hope | 6.0 | 51 | 819 | 701 | 1086 | 2342 |
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 | ep | 2019-05-26 | 29.02 | 2 | 6 | DISY | Dimokratikós Sinayermós | Democratic Rally | 8.6842 | 51 | 1075 | 1004 | 1628 | 1575 |
CYP | Cyprus | ep | 2019-05-26 | 27.49 | 2 | 6 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 1075 | 1004 | 1628 | 572 |
CYP | Cyprus | ep | 2019-05-26 | 13.8 | 1 | 6 | DIKO | Dimokratikó Kómma | Democratic Party | 5.1316 | 51 | 1075 | 1004 | 1628 | 851 |
CYP | Cyprus | ep | 2019-05-26 | 10.58 | 1 | 6 | EDEK | Kinima Sosialdimokraton EDEK | Movement for Social Democracy EDEK | 3.2895 | 51 | 1075 | 1004 | 1628 | 945 |
CYP | Cyprus | ep | 2019-05-26 | 8.25 | 0 | 6 | ELAM | Ethniko Laiko Metopo | National Popular Front | 8.8 | 51 | 1075 | 1004 | 1628 | 1768 |
CYP | Cyprus | ep | 2019-05-26 | 3.8 | 0 | 6 | DP | Dimokratiki Parataxi | Democratic Alignment | 6.0 | 51 | 1075 | 1004 | 1628 | 2741 |
CYP | Cyprus | ep | 2019-05-26 | 3.29 | 0 | 6 | SYM | Symmaxia | Citizen's Alliance | 3.3 | 51 | 1075 | 1004 | 1628 | 2341 |
CYP | Cyprus | ep | 2019-05-26 | 1.7 | 0 | 6 | YH | Yasemin Hareketi | Jasmine Movement | 3.3 | 51 | 1075 | 1004 | 1628 | 2784 |
EST | Estonia | ep | 2004-06-13 | 36.8 | 3 | 6 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 130 | 423 | 138 | 1448 |
EST | Estonia | ep | 2004-06-13 | 12.2 | 1 | 6 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 130 | 423 | 138 | 113 |
EST | Estonia | ep | 2004-06-13 | 17.5 | 1 | 6 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 130 | 423 | 138 | 1137 |
EST | Estonia | ep | 2004-06-13 | 10.5 | 1 | 6 | I | Isamaaliit | Pro Patria Union | 7.6169 | 75 | 130 | 423 | 138 | 846 |
EST | Estonia | ep | 2004-06-13 | 8.0 | 0 | 6 | ERa/EKR | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | People's Union of Estonia / Conservative People's Party | 4.5812 | 75 | 130 | 423 | 138 | 417 |
EST | Estonia | ep | 2004-06-13 | 6.7 | 0 | 6 | ERP | Erakond Res Publica | Res Publica Party | 8.4962 | 75 | 130 | 423 | 138 | 428 |
EST | Estonia | ep | 2004-06-13 | 1.2 | 0 | 6 | ESE-D | Eesti Sinine Erakond – Demokraadid | Estonian Blue Party -- Democrats | 6.0 | 75 | 130 | 423 | 138 | 2267 |
EST | Estonia | ep | 2009-06-07 | 26.1 | 2 | 6 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 395 | 83 | 902 | 1137 |
EST | Estonia | ep | 2009-06-07 | 15.3 | 1 | 6 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 395 | 83 | 902 | 113 |
EST | Estonia | ep | 2009-06-07 | 25.8 | 1 | 6 | I-IT | Independent – Indrek Tarand | Independent -- Indrek Tarand | 75 | 395 | 83 | 902 | 2029 | |
EST | Estonia | ep | 2009-06-07 | 8.7 | 1 | 6 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 395 | 83 | 902 | 1448 |
EST | Estonia | ep | 2009-06-07 | 12.2 | 1 | 6 | IRL | Erakond Isamaa ja Res Publica Liit | Union of Pro Patria and Res Publica | 8.4962 | 75 | 395 | 83 | 902 | 1597 |
EST | Estonia | ep | 2009-06-07 | 2.7 | 6 | EER | Erakond Eestimaa Rohelised | Estonian Greens | 2.5 | 75 | 395 | 83 | 902 | 219 | |
EST | Estonia | ep | 2009-06-07 | 2.5 | 6 | I-MH | Independent – Martin Helme | Independent -- Martin Helme | 75 | 395 | 83 | 902 | 2030 | ||
EST | Estonia | ep | 2009-06-07 | 2.2 | 6 | ERa/EKR | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | People's Union of Estonia / Conservative People's Party | 4.5812 | 75 | 395 | 83 | 902 | 417 | |
EST | Estonia | ep | 2009-06-07 | 1.8 | 6 | I-DK | Independent – Dimitri Klenski | Independent -- Dimitri Klenski | 75 | 395 | 83 | 902 | 2031 | ||
EST | Estonia | ep | 2014-05-25 | 24.3 | 2 | 6 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 822 | 699 | 1095 | 113 |
EST | Estonia | ep | 2014-05-25 | 22.4 | 1 | 6 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 822 | 699 | 1095 | 1137 |
EST | Estonia | ep | 2014-05-25 | 13.9 | 1 | 6 | IRL | Erakond Isamaa ja Res Publica Liit | Union of Pro Patria and Res Publica | 8.4962 | 75 | 822 | 699 | 1095 | 1597 |
EST | Estonia | ep | 2014-05-25 | 13.6 | 1 | 6 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 822 | 699 | 1095 | 1448 |
EST | Estonia | ep | 2014-05-25 | 13.2 | 1 | 6 | I-IT | Independent – Indrek Tarand | Independent -- Indrek Tarand | 75 | 822 | 699 | 1095 | 2029 | |
EST | Estonia | ep | 2014-05-25 | 4.0 | 0 | 6 | ERa/EKR | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | People's Union of Estonia / Conservative People's Party | 4.5812 | 75 | 822 | 699 | 1095 | 417 |
EST | Estonia | ep | 2014-05-25 | 1.3 | 0 | 6 | TEE | Tuleviku Eesti | Iseseisvuspartei | Future Estonia | Independence | 8.8 | 75 | 822 | 699 | 1095 | 1794 |
EST | Estonia | ep | 2014-05-25 | 3.1 | 0 | 6 | I-TT | Independent – Tanel Talve | Independent -- Tanel Talve | 75 | 822 | 699 | 1095 | 2344 | |
EST | Estonia | ep | 2014-05-25 | 1.8 | 0 | 6 | I-SM | Independent – Silver Meikar | Independent -- Silver Meikar | 75 | 822 | 699 | 1095 | 2345 | |
EST | Estonia | ep | 2019-05-26 | 26.2 | 2 | 6 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 1056 | 1044 | 1595 | 113 |
EST | Estonia | ep | 2019-05-26 | 23.3 | 2 | 6 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 1056 | 1044 | 1595 | 1448 |
EST | Estonia | ep | 2019-05-26 | 14.4 | 1 | 6 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 1056 | 1044 | 1595 | 1137 |
EST | Estonia | ep | 2019-05-26 | 12.7 | 1 | 6 | ERa/EKR | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | People's Union of Estonia / Conservative People's Party | 4.5812 | 75 | 1056 | 1044 | 1595 | 417 |
EST | Estonia | ep | 2019-05-26 | 10.3 | 0 | 6 | IRL | Erakond Isamaa ja Res Publica Liit | Union of Pro Patria and Res Publica | 8.4962 | 75 | 1056 | 1044 | 1595 | 1597 |
EST | Estonia | ep | 2019-05-26 | 1.8 | 0 | 6 | EER | Erakond Eestimaa Rohelised | Estonian Greens | 2.5 | 75 | 1056 | 1044 | 1595 | 219 |
EST | Estonia | ep | 2019-05-26 | 3.2 | 0 | 6 | E200 | Erakond Eesti 200 | Estonia 200 | 6.0 | 75 | 1056 | 1044 | 1595 | 2720 |
EST | Estonia | ep | 2019-05-26 | 6.2 | 0 | 6 | I-RK | Independent – Raimond Kaljulaid | Independent -- Raimond Kaljulaid | 75 | 1056 | 1044 | 1595 | 2738 | |
LUX | Luxembourg | ep | 1979-06-10 | 36.1 | 3 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 589 | 446 | 655 | 1234 |
LUX | Luxembourg | ep | 1979-06-10 | 28.1 | 2 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 589 | 446 | 655 | 967 |
LUX | Luxembourg | ep | 1979-06-10 | 21.6 | 1 | 6 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 589 | 446 | 655 | 701 |
LUX | Luxembourg | ep | 1979-06-10 | 7.0 | 0 | 6 | SDP | Sozialdemokratesch Partei | Social Democratic Party | 3.3 | 7 | 589 | 446 | 655 | 1134 |
LUX | Luxembourg | ep | 1979-06-10 | 5.0 | 0 | 6 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 589 | 446 | 655 | 151 |
LUX | Luxembourg | ep | 1979-06-10 | 1.0 | 0 | 6 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 589 | 446 | 655 | 310 |
LUX | Luxembourg | ep | 1984-06-17 | 34.9 | 3 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 109 | 606 | 27 | 1234 |
LUX | Luxembourg | ep | 1984-06-17 | 29.9 | 2 | 6 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 109 | 606 | 27 | 701 |
LUX | Luxembourg | ep | 1984-06-17 | 22.1 | 1 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 109 | 606 | 27 | 967 |
LUX | Luxembourg | ep | 1984-06-17 | 6.1 | 0 | 6 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 109 | 606 | 27 | 310 |
LUX | Luxembourg | ep | 1984-06-17 | 4.1 | 0 | 6 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 109 | 606 | 27 | 151 |
LUX | Luxembourg | ep | 1984-06-17 | 2.6 | 0 | 6 | SI | Jean Gremling List – Socialistes Indépendants | Jean Gremling List -- Independent Socialists | 3.3 | 7 | 109 | 606 | 27 | 1339 |
LUX | Luxembourg | ep | 1989-06-18 | 34.9 | 3 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 238 | 183 | 175 | 1234 |
LUX | Luxembourg | ep | 1989-06-18 | 25.4 | 2 | 6 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 238 | 183 | 175 | 701 |
LUX | Luxembourg | ep | 1989-06-18 | 20.0 | 1 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 238 | 183 | 175 | 967 |
LUX | Luxembourg | ep | 1989-06-18 | 6.1 | 0 | 6 | GLEI | Greng Lëscht Ekologesch Initiativ | Green Left Ecological Initiative | 2.5 | 7 | 238 | 183 | 175 | 1158 |
LUX | Luxembourg | ep | 1989-06-18 | 4.7 | 0 | 6 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 238 | 183 | 175 | 151 |
LUX | Luxembourg | ep | 1989-06-18 | 4.3 | 0 | 6 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 238 | 183 | 175 | 310 |
LUX | Luxembourg | ep | 1989-06-18 | 2.9 | 0 | 6 | NB | National Bewegong | National Movement | 8.8 | 7 | 238 | 183 | 175 | 374 |
LUX | Luxembourg | ep | 1994-06-12 | 24.8 | 2 | 6 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 594 | 526 | 418 | 701 |
LUX | Luxembourg | ep | 1994-06-12 | 31.5 | 2 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 594 | 526 | 418 | 1234 |
LUX | Luxembourg | ep | 1994-06-12 | 10.93 | 1 | 6 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 594 | 526 | 418 | 310 |
LUX | Luxembourg | ep | 1994-06-12 | 18.83 | 1 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 594 | 526 | 418 | 967 |
LUX | Luxembourg | ep | 1994-06-12 | 6.94 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 594 | 526 | 418 | 1582 |
LUX | Luxembourg | ep | 1994-06-12 | 1.63 | 0 | 6 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 594 | 526 | 418 | 151 |
LUX | Luxembourg | ep | 1994-06-12 | 2.4 | 0 | 6 | NB | National Bewegong | National Movement | 8.8 | 7 | 594 | 526 | 418 | 374 |
LUX | Luxembourg | ep | 1994-06-12 | 1.2 | 0 | 6 | GLS | Groupement fir d'Lëtzebuerger Souveränitéit | Group for Luxembourgian Sovereignty | 7 | 594 | 526 | 418 | 2146 | |
LUX | Luxembourg | ep | 1999-06-13 | 23.58 | 2 | 6 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 505 | 306 | 621 | 701 |
LUX | Luxembourg | ep | 1999-06-13 | 31.67 | 2 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 505 | 306 | 621 | 1234 |
LUX | Luxembourg | ep | 1999-06-13 | 10.7 | 1 | 6 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 505 | 306 | 621 | 310 |
LUX | Luxembourg | ep | 1999-06-13 | 20.46 | 1 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 505 | 306 | 621 | 967 |
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;