view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by country_id descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
EST | Estonia | parliament | 1992-09-20 | 22.0 | 29 | 101 | RKI | Rahvuslik Koonderakond "Isamaa" | National Coalition Party "Pro Patria" | 7.4 | 75 | 670 | 243 | ||
EST | Estonia | parliament | 1992-09-20 | 13.6 | 17 | 101 | EKK | Eesti Koonderakond | Estonian Coalition Party | 7.2222 | 75 | 670 | 486 | ||
EST | Estonia | parliament | 1992-09-20 | 12.25 | 15 | 101 | R | Rahvarinne | Popular Front | 3.3333 | 75 | 670 | 450 | ||
EST | Estonia | parliament | 1992-09-20 | 9.73 | 12 | 101 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 670 | 1448 | ||
EST | Estonia | parliament | 1992-09-20 | 8.79 | 10 | 101 | ERSP | Eesti Rahvusliku Sõltumatuse Partei | Estonian National Independence Party | 7.7778 | 75 | 670 | 552 | ||
EST | Estonia | parliament | 1992-09-20 | 6.89 | 8 | 101 | EKo | Eesti Kodanik | Estonian Citizens | 8.8 | 75 | 670 | 1064 | ||
EST | Estonia | parliament | 1992-09-20 | 7.12 | 8 | 101 | SK | Sõltumatud Kuningriiklased | Independent Royalists | 75 | 670 | 25 | |||
EST | Estonia | parliament | 1992-09-20 | 2.39 | 1 | 101 | EEE | Eesti Ettevõtjate Erakond | Estonian Entrepreneur Party | 8.3333 | 75 | 670 | 1516 | ||
EST | Estonia | parliament | 1992-09-20 | 2.62 | 1 | 101 | EER-91 | Eesti Rohelised – 1991 | Estonian Greens -- 1991 | 5.5556 | 75 | 670 | 2631 | ||
EST | Estonia | parliament | 1992-09-20 | 2.91 | 0 | 101 | PK | Põllumeeste Kogu | Union of Farmers | 2.2222 | 75 | 670 | 1553 | ||
EST | Estonia | parliament | 1992-09-20 | 3.71 | 0 | 101 | EPL | Eesti Pensionaride Liit | Estonian Pensioners' Union | 75 | 670 | 1792 | |||
EST | Estonia | parliament | 1992-09-20 | 1.61 | 0 | 101 | EVP | Eesti Vasakpartei | Estonian Left Party | 1.3 | 75 | 670 | 2416 | ||
EST | Estonia | parliament | 1995-03-05 | 32.23 | 41 | 101 | EKK | Eesti Koonderakond | Estonian Coalition Party | 7.2222 | 75 | 600 | 670 | 4 | 486 |
EST | Estonia | parliament | 1995-03-05 | 16.19 | 19 | 101 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 600 | 670 | 4 | 113 |
EST | Estonia | parliament | 1995-03-05 | 14.17 | 16 | 101 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 600 | 670 | 4 | 1137 |
EST | Estonia | parliament | 1995-03-05 | 7.86 | 8 | 101 | RKI | Rahvuslik Koonderakond "Isamaa" | National Coalition Party "Pro Patria" | 7.4 | 75 | 600 | 670 | 4 | 243 |
EST | Estonia | parliament | 1995-03-05 | 5.87 | 6 | 101 | K-EUR | Konstitutsioonierakond – Eestimaa Ühendatud Rahvapartei | Constitution Party -- Estonian United People's Party | 2.0282 | 75 | 600 | 670 | 4 | 1590 |
EST | Estonia | parliament | 1995-03-05 | 5.99 | 6 | 101 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 600 | 670 | 4 | 1448 |
EST | Estonia | parliament | 1995-03-05 | 5.0 | 5 | 101 | VKR | Vabariiklaste ja Konservatiivide Rahvaerakond | People's Party of Republicans and Conservatives | 7.4 | 75 | 600 | 670 | 4 | 1395 |
EST | Estonia | parliament | 1995-03-05 | 3.61 | 0 | 101 | EKo | Eesti Kodanik | Estonian Citizens | 8.8 | 75 | 600 | 670 | 4 | 1064 |
EST | Estonia | parliament | 1995-03-05 | 2.57 | 0 | 101 | TEE | Tuleviku Eesti | Iseseisvuspartei | Future Estonia | Independence | 8.8 | 75 | 600 | 670 | 4 | 1794 |
EST | Estonia | parliament | 1995-03-05 | 1.51 | 0 | 101 | ETE | Eesti Talurahva Erakond | Estonian Farmers Party | 5.3 | 75 | 600 | 670 | 4 | 1796 |
EST | Estonia | parliament | 1995-03-05 | 2.27 | 0 | 101 | EVP | Eesti Vasakpartei | Estonian Left Party | 1.3 | 75 | 600 | 670 | 4 | 2416 |
EST | Estonia | parliament | 1999-03-07 | 23.41 | 28 | 101 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 239 | 600 | 303 | 1137 |
EST | Estonia | parliament | 1999-03-07 | 15.92 | 18 | 101 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 239 | 600 | 303 | 113 |
EST | Estonia | parliament | 1999-03-07 | 16.09 | 18 | 101 | I | Isamaaliit | Pro Patria Union | 7.6169 | 75 | 239 | 600 | 303 | 846 |
EST | Estonia | parliament | 1999-03-07 | 15.21 | 17 | 101 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 239 | 600 | 303 | 1448 |
EST | Estonia | parliament | 1999-03-07 | 7.58 | 7 | 101 | EKK | Eesti Koonderakond | Estonian Coalition Party | 7.2222 | 75 | 239 | 600 | 303 | 486 |
EST | Estonia | parliament | 1999-03-07 | 7.27 | 7 | 101 | ERa/EKR | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | People's Union of Estonia / Conservative People's Party | 4.5812 | 75 | 239 | 600 | 303 | 417 |
EST | Estonia | parliament | 1999-03-07 | 6.13 | 6 | 101 | K-EUR | Konstitutsioonierakond – Eestimaa Ühendatud Rahvapartei | Constitution Party -- Estonian United People's Party | 2.0282 | 75 | 239 | 600 | 303 | 1590 |
EST | Estonia | parliament | 1999-03-07 | 2.43 | 0 | 101 | EKD | Eesti Kristlikud Demokraadid | Estonian Christian Democrats | 7.5789 | 75 | 239 | 600 | 303 | 609 |
EST | Estonia | parliament | 1999-03-07 | 2.03 | 0 | 101 | VEE | Vene Erakond Eestis | Russian Party in Estonia | 7.4 | 75 | 239 | 600 | 303 | 2266 |
EST | Estonia | parliament | 1999-03-07 | 1.6 | 101 | ESE-D | Eesti Sinine Erakond – Demokraadid | Estonian Blue Party -- Democrats | 6.0 | 75 | 239 | 600 | 303 | 2267 | |
EST | Estonia | parliament | 2003-03-02 | 24.6 | 28 | 101 | ERP | Erakond Res Publica | Res Publica Party | 8.4962 | 75 | 423 | 239 | 152 | 428 |
EST | Estonia | parliament | 2003-03-02 | 25.4 | 28 | 101 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 423 | 239 | 152 | 1137 |
EST | Estonia | parliament | 2003-03-02 | 17.7 | 19 | 101 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 423 | 239 | 152 | 113 |
EST | Estonia | parliament | 2003-03-02 | 13.0 | 13 | 101 | ERa/EKR | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | People's Union of Estonia / Conservative People's Party | 4.5812 | 75 | 423 | 239 | 152 | 417 |
EST | Estonia | parliament | 2003-03-02 | 7.3 | 7 | 101 | I | Isamaaliit | Pro Patria Union | 7.6169 | 75 | 423 | 239 | 152 | 846 |
EST | Estonia | parliament | 2003-03-02 | 7.0 | 6 | 101 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 423 | 239 | 152 | 1448 |
EST | Estonia | parliament | 2003-03-02 | 2.2 | 0 | 101 | K-EUR | Konstitutsioonierakond – Eestimaa Ühendatud Rahvapartei | Constitution Party -- Estonian United People's Party | 2.0282 | 75 | 423 | 239 | 152 | 1590 |
EST | Estonia | parliament | 2003-03-02 | 1.1 | 0 | 101 | EKD | Eesti Kristlikud Demokraadid | Estonian Christian Democrats | 7.5789 | 75 | 423 | 239 | 152 | 609 |
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 | parliament | 2007-03-04 | 27.8 | 31 | 101 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 83 | 423 | 274 | 113 |
EST | Estonia | parliament | 2007-03-04 | 26.1 | 29 | 101 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 83 | 423 | 274 | 1137 |
EST | Estonia | parliament | 2007-03-04 | 17.9 | 19 | 101 | IRL | Erakond Isamaa ja Res Publica Liit | Union of Pro Patria and Res Publica | 8.4962 | 75 | 83 | 423 | 274 | 1597 |
EST | Estonia | parliament | 2007-03-04 | 10.6 | 10 | 101 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 83 | 423 | 274 | 1448 |
EST | Estonia | parliament | 2007-03-04 | 7.1 | 6 | 101 | ERa/EKR | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | People's Union of Estonia / Conservative People's Party | 4.5812 | 75 | 83 | 423 | 274 | 417 |
EST | Estonia | parliament | 2007-03-04 | 7.1 | 6 | 101 | EER | Erakond Eestimaa Rohelised | Estonian Greens | 2.5 | 75 | 83 | 423 | 274 | 219 |
EST | Estonia | parliament | 2007-03-04 | 1.7 | 0 | 101 | EKD | Eesti Kristlikud Demokraadid | Estonian Christian Democrats | 7.5789 | 75 | 83 | 423 | 274 | 609 |
EST | Estonia | parliament | 2007-03-04 | 1.0 | 0 | 101 | K-EUR | Konstitutsioonierakond – Eestimaa Ühendatud Rahvapartei | Constitution Party -- Estonian United People's Party | 2.0282 | 75 | 83 | 423 | 274 | 1590 |
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 | parliament | 2011-03-06 | 28.6 | 33 | 101 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 699 | 83 | 902 | 113 |
EST | Estonia | parliament | 2011-03-06 | 23.3 | 26 | 101 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 699 | 83 | 902 | 1137 |
EST | Estonia | parliament | 2011-03-06 | 20.5 | 23 | 101 | IRL | Erakond Isamaa ja Res Publica Liit | Union of Pro Patria and Res Publica | 8.4962 | 75 | 699 | 83 | 902 | 1597 |
EST | Estonia | parliament | 2011-03-06 | 17.1 | 19 | 101 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 699 | 83 | 902 | 1448 |
EST | Estonia | parliament | 2011-03-06 | 3.8 | 0 | 101 | EER | Erakond Eestimaa Rohelised | Estonian Greens | 2.5 | 75 | 699 | 83 | 902 | 219 |
EST | Estonia | parliament | 2011-03-06 | 2.1 | 0 | 101 | ERa/EKR | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | People's Union of Estonia / Conservative People's Party | 4.5812 | 75 | 699 | 83 | 902 | 417 |
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 | parliament | 2015-03-01 | 27.69 | 30 | 101 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 853 | 699 | 1095 | 113 |
EST | Estonia | parliament | 2015-03-01 | 24.81 | 27 | 101 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 853 | 699 | 1095 | 1137 |
EST | Estonia | parliament | 2015-03-01 | 15.19 | 15 | 101 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 853 | 699 | 1095 | 1448 |
EST | Estonia | parliament | 2015-03-01 | 13.71 | 14 | 101 | IRL | Erakond Isamaa ja Res Publica Liit | Union of Pro Patria and Res Publica | 8.4962 | 75 | 853 | 699 | 1095 | 1597 |
EST | Estonia | parliament | 2015-03-01 | 8.69 | 8 | 101 | EV | Eesti Vabaerakond | Free Party | 7.4 | 75 | 853 | 699 | 1095 | 2409 |
EST | Estonia | parliament | 2015-03-01 | 8.15 | 7 | 101 | ERa/EKR | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | People's Union of Estonia / Conservative People's Party | 4.5812 | 75 | 853 | 699 | 1095 | 417 |
EST | Estonia | parliament | 2015-03-01 | 0.9 | 0 | 101 | EER | Erakond Eestimaa Rohelised | Estonian Greens | 2.5 | 75 | 853 | 699 | 1095 | 219 |
EST | Estonia | parliament | 2019-03-03 | 28.9 | 34 | 101 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 1044 | 853 | 1495 | 113 |
EST | Estonia | parliament | 2019-03-03 | 23.1 | 26 | 101 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 1044 | 853 | 1495 | 1137 |
EST | Estonia | parliament | 2019-03-03 | 17.8 | 19 | 101 | ERa/EKR | Eestimaa Rahvalliit / Eesti Konservatiivne Rahvaerakond | People's Union of Estonia / Conservative People's Party | 4.5812 | 75 | 1044 | 853 | 1495 | 417 |
EST | Estonia | parliament | 2019-03-03 | 11.4 | 12 | 101 | IRL | Erakond Isamaa ja Res Publica Liit | Union of Pro Patria and Res Publica | 8.4962 | 75 | 1044 | 853 | 1495 | 1597 |
EST | Estonia | parliament | 2019-03-03 | 9.8 | 10 | 101 | SDE|M | Sotsiaaldemokraatlik Erakond | Mõõdukad | Social Democratic Party | Moderates | 4.1915 | 75 | 1044 | 853 | 1495 | 1448 |
EST | Estonia | parliament | 2019-03-03 | 4.4 | 0 | 101 | E200 | Erakond Eesti 200 | Estonia 200 | 6.0 | 75 | 1044 | 853 | 1495 | 2720 |
EST | Estonia | parliament | 2019-03-03 | 1.8 | 0 | 101 | EER | Erakond Eestimaa Rohelised | Estonian Greens | 2.5 | 75 | 1044 | 853 | 1495 | 219 |
EST | Estonia | parliament | 2019-03-03 | 1.2 | 0 | 101 | ELE | Elurikkuse Erakond | Richness of Life | 2.5 | 75 | 1044 | 853 | 1495 | 2721 |
EST | Estonia | parliament | 2019-03-03 | 1.2 | 0 | 101 | EV | Eesti Vabaerakond | Free Party | 7.4 | 75 | 1044 | 853 | 1495 | 2409 |
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 |
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;