view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by previous_cabinet_id 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NLD | Netherlands | parliament | 2021-03-17 | 5.73 | 9 | 150 | PvdA | Partij van de Arbeid | Labour Party | 3.6118 | 8 | 1097 | 1012 | 1648 | 742 |
NLD | Netherlands | parliament | 2021-03-17 | 5.16 | 8 | 150 | GL | GroenLinks | GreenLeft | 2.0454 | 8 | 1097 | 1012 | 1648 | 756 |
NLD | Netherlands | parliament | 2021-03-17 | 5.02 | 8 | 150 | FvD | Forum voor Democratie | Forum for Democracy | 8.8 | 8 | 1097 | 1012 | 1648 | 2642 |
NLD | Netherlands | parliament | 2021-03-17 | 3.84 | 6 | 150 | PvdD | Partij voor de Dieren | Party for the Animals | 8 | 1097 | 1012 | 1648 | 990 | |
NLD | Netherlands | parliament | 2021-03-17 | 3.37 | 5 | 150 | CU | ChristenUnie | ChristianUnion | 6.1732 | 8 | 1097 | 1012 | 1648 | 1206 |
NLD | Netherlands | parliament | 2021-03-17 | 2.07 | 3 | 150 | SGP | Staatkundig Gereformeerde Partij | Political Reformed Party | 8.7531 | 8 | 1097 | 1012 | 1648 | 1251 |
NLD | Netherlands | parliament | 2021-03-17 | 2.03 | 3 | 150 | DENK | Beweging DENK | Think | 3.3 | 8 | 1097 | 1012 | 1648 | 2641 |
NLD | Netherlands | parliament | 2021-03-17 | 2.42 | 3 | 150 | VN | Volt Nederland | Volt Netherlands | 8 | 1097 | 1012 | 1648 | 2735 | |
NLD | Netherlands | parliament | 2021-03-17 | 2.37 | 3 | 150 | JA21 | Juiste Antwoord21 | Right Answer 2021 | 8.8 | 8 | 1097 | 1012 | 1648 | 2823 |
NLD | Netherlands | parliament | 2021-03-17 | 1.02 | 1 | 150 | 50+ | 50PLUS | 50PLUS | 8 | 1097 | 1012 | 1648 | 2109 | |
NLD | Netherlands | parliament | 2021-03-17 | 1.0 | 1 | 150 | BBB | BoerBurgerBeweging | Farmer-Citizen Movement | 5.3 | 8 | 1097 | 1012 | 1648 | 2824 |
NLD | Netherlands | parliament | 2021-03-17 | 0.84 | 1 | 150 | one-seat | one seat | one seat | 8 | 1097 | 1012 | 1648 | 2288 | |
NLD | Netherlands | parliament | 2021-03-17 | 0.39 | 0 | 150 | no-seat | no seat | no seat | 8 | 1097 | 1012 | 1648 | 2110 | |
JPN | Japan | parliament | 2021-10-31 | 34.66 | 72 | 176 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 1098 | 1022 | 1647 | 1193 |
JPN | Japan | parliament | 2021-10-31 | 20.0 | 39 | 176 | CDP | Rikken Minshutō | Constitutional Democratic Party of Japan | 3.3 | 5 | 1098 | 1022 | 1647 | 2657 |
JPN | Japan | parliament | 2021-10-31 | 14.01 | 25 | 176 | JaRep | Nippon Ishin no Kai | Japan Innovation Party | 8.8 | 5 | 1098 | 1022 | 1647 | 2826 |
JPN | Japan | parliament | 2021-10-31 | 12.38 | 23 | 176 | K | Kōmeitō | Komeito Party | 5.6871 | 5 | 1098 | 1022 | 1647 | 837 |
JPN | Japan | parliament | 2021-10-31 | 7.25 | 9 | 176 | JCP | Nihon Kyōsan-tō | Japan Communist Party | 1.148 | 5 | 1098 | 1022 | 1647 | 1540 |
JPN | Japan | parliament | 2021-10-31 | 4.51 | 5 | 176 | DPP | Kokumin Minshu-tō | Democratic Party for the People | 7.4 | 5 | 1098 | 1022 | 1647 | 2827 |
JPN | Japan | parliament | 2021-10-31 | 3.86 | 3 | 176 | ReiShin | Reiwa Shinsengumi | Reiwa Shinsengumi | 1.3 | 5 | 1098 | 1022 | 1647 | 2828 |
JPN | Japan | parliament | 2021-10-31 | 1.77 | 0 | 176 | JSP | Nihon Shakai-tō | Japan Socialist Party | 2.6344 | 5 | 1098 | 1022 | 1647 | 940 |
JPN | Japan | parliament | 2021-10-31 | 1.39 | 0 | 176 | NHK | NHK jushinryō o shiharawanai kokumin o mamoru tō | The party that protects those who do not pay the NHK license fee | 5 | 1098 | 1022 | 1647 | 2853 | |
ISR | Israel | parliament | 2021-03-23 | 24.19 | 30 | 120 | L | Likud | The Consolidation | 6.6788 | 34 | 1100 | 1090 | 1645 | 678 |
ISR | Israel | parliament | 2021-03-23 | 13.93 | 17 | 120 | YA | Yesh Atid | There is a Future | 6.0 | 34 | 1100 | 1090 | 1645 | 2321 |
ISR | Israel | parliament | 2021-03-23 | 7.17 | 9 | 120 | Shas | Shomrei Sfarad | Sephardi Guardians | 7.0417 | 34 | 1100 | 1090 | 1645 | 788 |
ISR | Israel | parliament | 2021-03-23 | 6.63 | 8 | 120 | KL | Kahol Lavan | Blue and White | 6.0 | 34 | 1100 | 1090 | 1645 | 2725 |
ISR | Israel | parliament | 2021-03-23 | 6.21 | 7 | 120 | Y | Yamina | Rightwards | 8.8 | 34 | 1100 | 1090 | 1645 | 2726 |
ISR | Israel | parliament | 2021-03-23 | 6.09 | 7 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 1100 | 1090 | 1645 | 244 |
ISR | Israel | parliament | 2021-03-23 | 5.63 | 7 | 120 | YaToMe | Yahadut HaTora HaMeuhedet | United Torah Judaism | 6.9396 | 34 | 1100 | 1090 | 1645 | 1303 |
ISR | Israel | parliament | 2021-03-23 | 5.63 | 7 | 120 | YB | Yisrael Beiteinu | Israel Our Home | 8.8 | 34 | 1100 | 1090 | 1645 | 1816 |
ISR | Israel | parliament | 2021-03-23 | 5.12 | 6 | 120 | HaLe-T|RZP | HaIhud HaLeumi–Tkuma | HaTzionut HaDatit | National Union--Tkuma | Religious Zionist Party | 9.5906 | 34 | 1100 | 1090 | 1645 | 1357 |
ISR | Israel | parliament | 2021-03-23 | 4.82 | 6 | 120 | R|H | Rakah | Hadash | New Communist List | Democratic Front | 1.3 | 34 | 1100 | 1090 | 1645 | 732 |
ISR | Israel | parliament | 2021-03-23 | 4.74 | 6 | 120 | NH | Tikva Hadasha | New Hope | 8.8 | 34 | 1100 | 1090 | 1645 | 2835 |
ISR | Israel | parliament | 2021-03-23 | 4.59 | 6 | 120 | Meretz | Meretz | Energy | 1.7786 | 34 | 1100 | 1090 | 1645 | 1419 |
ISR | Israel | parliament | 2021-03-23 | 3.79 | 4 | 120 | Raam | al-Qā'ima al-'Arabiyya al-Muwaḥḥada | United Arab List | 34 | 1100 | 1090 | 1645 | 1846 | |
ISR | Israel | parliament | 2021-03-23 | 0.79 | 0 | 120 | no-seat | no seat | no seat | 34 | 1100 | 1090 | 1645 | 2308 | |
LTU | Lithuania | parliament | 2004-10-24 | 28.44 | 39 | 141 | DP | Darbo partija | Labour Party | 3.86 | 15 | 214 | 59 | 1634 | 581 |
LTU | Lithuania | parliament | 2004-10-24 | 14.75 | 25 | 141 | TS-LK | Tėvynės sąjunga | Homeland Union | 7.4004 | 15 | 214 | 59 | 1634 | 1045 |
LTU | Lithuania | parliament | 2004-10-24 | 20.65 | 20 | 141 | LSDP | Lietuvos socialdemokratų partija | Lithuanian Social Democratic Party | 3.1972 | 15 | 214 | 59 | 1634 | 1277 |
LTU | Lithuania | parliament | 2004-10-24 | 9.19 | 18 | 141 | LiCS | Liberalų ir centro sąjunga | Liberal and Centre Union | 7.7562 | 15 | 214 | 59 | 1634 | 983 |
LTU | Lithuania | parliament | 2004-10-24 | 11 | 141 | NS-SL | Naujoji sąjunga (socialliberalai) | New Union (Social Liberals) | 4.2686 | 15 | 214 | 59 | 1634 | 856 | |
LTU | Lithuania | parliament | 2004-10-24 | 11.36 | 10 | 141 | TT-LDP | Tvarka ir teisingumas – Liberalų demokratų partija | Order and Justice -- Liberal Democratic Party | 5.2955 | 15 | 214 | 59 | 1634 | 1421 |
LTU | Lithuania | parliament | 2004-10-24 | 6.6 | 10 | 141 | LVLS | Lietuvos valstiečių sąjunga | Lithuanian Peasant Union | 3.2687 | 15 | 214 | 59 | 1634 | 191 |
LTU | Lithuania | parliament | 2004-10-24 | 6 | 141 | none | no party affiliation | no party affiliation | 15 | 214 | 59 | 1634 | 58 | ||
LTU | Lithuania | parliament | 2004-10-24 | 3.79 | 2 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 214 | 59 | 1634 | 28 |
LTU | Lithuania | parliament | 2004-10-24 | 1.37 | 0 | 141 | LKDP | Lietuvos krikščionys demokratai | Lithuanian Christian Democrats | 6.2385 | 15 | 214 | 59 | 1634 | 675 |
LTU | Lithuania | parliament | 2004-10-24 | 1.96 | 0 | 141 | KKSS | Krikščionių konservatorių socialinė sąjunga | Christian Conservative Social Union | 6.4579 | 15 | 214 | 59 | 1634 | 709 |
LTU | Lithuania | parliament | 2016-10-09 | 22.45 | 54 | 141 | LVLS | Lietuvos valstiečių sąjunga | Lithuanian Peasant Union | 3.2687 | 15 | 1009 | 786 | 1633 | 191 |
LTU | Lithuania | parliament | 2016-10-09 | 22.63 | 31 | 141 | TS-LK | Tėvynės sąjunga | Homeland Union | 7.4004 | 15 | 1009 | 786 | 1633 | 1045 |
LTU | Lithuania | parliament | 2016-10-09 | 15.04 | 17 | 141 | LSDP | Lietuvos socialdemokratų partija | Lithuanian Social Democratic Party | 3.1972 | 15 | 1009 | 786 | 1633 | 1277 |
LTU | Lithuania | parliament | 2016-10-09 | 9.45 | 14 | 141 | LRLS | Lietuvos Respublikos liberalų sąjūdis | Liberals Movement of the Republic of Lithuania | 7.7562 | 15 | 1009 | 786 | 1633 | 482 |
LTU | Lithuania | parliament | 2016-10-09 | 5.72 | 8 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 1009 | 786 | 1633 | 28 |
LTU | Lithuania | parliament | 2016-10-09 | 5.55 | 8 | 141 | TT-LDP | Tvarka ir teisingumas – Liberalų demokratų partija | Order and Justice -- Liberal Democratic Party | 5.2955 | 15 | 1009 | 786 | 1633 | 1421 |
LTU | Lithuania | parliament | 2016-10-09 | 4 | 141 | none | no party affiliation | no party affiliation | 15 | 1009 | 786 | 1633 | 58 | ||
LTU | Lithuania | parliament | 2016-10-09 | 4.88 | 2 | 141 | DP | Darbo partija | Labour Party | 3.86 | 15 | 1009 | 786 | 1633 | 581 |
LTU | Lithuania | parliament | 2016-10-09 | 6.32 | 1 | 141 | LCP | Lietuvos Centro Partija | Lithuanian Centre Party | 8.8 | 15 | 1009 | 786 | 1633 | 2635 |
LTU | Lithuania | parliament | 2016-10-09 | 2.03 | 1 | 141 | LZP | Lietuvos žalioji partija | Lithuanian Green Party | 2.5 | 15 | 1009 | 786 | 1633 | 21 |
LTU | Lithuania | parliament | 2016-10-09 | 1.8 | 1 | 141 | one-seat | one seat | one seat | 15 | 1009 | 786 | 1633 | 652 | |
LTU | Lithuania | parliament | 2016-10-09 | 2.23 | 0 | 141 | LLS | Lietuvos laisvės sąjunga (liberalai) | Lithuanian Freedom Union (Liberals) | 6.0 | 15 | 1009 | 786 | 1633 | 2634 |
LTU | Lithuania | parliament | 2016-10-09 | 1.05 | 0 | 141 | no-seat | no seat | no seat | 15 | 1009 | 786 | 1633 | 2636 | |
LTU | Lithuania | ep | 2004-06-13 | 30.16 | 5 | 13 | DP | Darbo partija | Labour Party | 3.86 | 15 | 539 | 59 | 1631 | 581 |
LTU | Lithuania | ep | 2004-06-13 | 12.58 | 2 | 13 | TS-LK | Tėvynės sąjunga | Homeland Union | 7.4004 | 15 | 539 | 59 | 1631 | 1045 |
LTU | Lithuania | ep | 2004-06-13 | 11.23 | 2 | 13 | LiCS | Liberalų ir centro sąjunga | Liberal and Centre Union | 7.7562 | 15 | 539 | 59 | 1631 | 983 |
LTU | Lithuania | ep | 2004-06-13 | 14.43 | 2 | 13 | LSDP | Lietuvos socialdemokratų partija | Lithuanian Social Democratic Party | 3.1972 | 15 | 539 | 59 | 1631 | 1277 |
LTU | Lithuania | ep | 2004-06-13 | 7.41 | 1 | 13 | LVLS | Lietuvos valstiečių sąjunga | Lithuanian Peasant Union | 3.2687 | 15 | 539 | 59 | 1631 | 191 |
LTU | Lithuania | ep | 2004-06-13 | 6.83 | 1 | 13 | TT-LDP | Tvarka ir teisingumas – Liberalų demokratų partija | Order and Justice -- Liberal Democratic Party | 5.2955 | 15 | 539 | 59 | 1631 | 1421 |
LTU | Lithuania | ep | 2004-06-13 | 5.71 | 0 | 13 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 539 | 59 | 1631 | 28 |
LTU | Lithuania | ep | 2004-06-13 | 4.85 | 0 | 13 | NS-SL | Naujoji sąjunga (socialliberalai) | New Union (Social Liberals) | 4.2686 | 15 | 539 | 59 | 1631 | 856 |
LTU | Lithuania | ep | 2004-06-13 | 2.75 | 0 | 13 | LKDP | Lietuvos krikščionys demokratai | Lithuanian Christian Democrats | 6.2385 | 15 | 539 | 59 | 1631 | 675 |
LTU | Lithuania | ep | 2004-06-13 | 2.57 | 0 | 13 | KKSS | Krikščionių konservatorių socialinė sąjunga | Christian Conservative Social Union | 6.4579 | 15 | 539 | 59 | 1631 | 709 |
LTU | Lithuania | ep | 2004-06-13 | 1.18 | 0 | 13 | Tpp | Tautos pažangos partija | Party of National Progress | 8.8 | 15 | 539 | 59 | 1631 | 2026 |
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 |
CYP | Cyprus | parliament | 2021-05-30 | 27.77 | 17 | 56 | DISY | Dimokratikós Sinayermós | Democratic Rally | 8.6842 | 51 | 1095 | 1004 | 1628 | 1575 |
CYP | Cyprus | parliament | 2021-05-30 | 22.34 | 15 | 56 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 1095 | 1004 | 1628 | 572 |
CYP | Cyprus | parliament | 2021-05-30 | 11.29 | 9 | 56 | DIKO | Dimokratikó Kómma | Democratic Party | 5.1316 | 51 | 1095 | 1004 | 1628 | 851 |
CYP | Cyprus | parliament | 2021-05-30 | 6.78 | 4 | 56 | ELAM | Ethniko Laiko Metopo | National Popular Front | 8.8 | 51 | 1095 | 1004 | 1628 | 1768 |
CYP | Cyprus | parliament | 2021-05-30 | 6.72 | 4 | 56 | EDEK | Kinima Sosialdimokraton EDEK | Movement for Social Democracy EDEK | 3.2895 | 51 | 1095 | 1004 | 1628 | 945 |
CYP | Cyprus | parliament | 2021-05-30 | 6.1 | 4 | 56 | DP | Dimokratiki Parataxi | Democratic Alignment | 6.0 | 51 | 1095 | 1004 | 1628 | 2741 |
CYP | Cyprus | parliament | 2021-05-30 | 4.41 | 3 | 56 | KOP | Kinima Oikologoi Perivallontistoi | Ecological and Environmental Movement | 5.7895 | 51 | 1095 | 1004 | 1628 | 1621 |
CYP | Cyprus | parliament | 2021-05-30 | 1.0 | 0 | 56 | KGTZTK | Kinima gia ta zoa tis Kíprou | Animal Party Cyprus | 51 | 1095 | 1004 | 1628 | 2627 | |
CYP | Cyprus | parliament | 2021-05-30 | 2.31 | 0 | 56 | KINHMA | Kinima Allileggiis | Solidarity Movement | 8.8 | 51 | 1095 | 1004 | 1628 | 2626 |
CYP | Cyprus | parliament | 2021-05-30 | 3.27 | 0 | 56 | EP | Energi Polites | Active Citizens | 1.3 | 51 | 1095 | 1004 | 1628 | 2815 |
CYP | Cyprus | parliament | 2021-05-30 | 2.82 | 0 | 56 | Anex | Independents Movement | Independents Movement | 6.0 | 51 | 1095 | 1004 | 1628 | 2817 |
CYP | Cyprus | parliament | 2021-05-30 | 1.35 | 0 | 56 | AM | Afypnisis 2020 | Awakening 2020 | 51 | 1095 | 1004 | 1628 | 2819 | |
CYP | Cyprus | parliament | 2021-05-30 | 1.56 | 56 | AK | Ammókhostos yia tin Kípro | Famagusta for Cyprus | 6.0 | 51 | 1095 | 1004 | 1628 | 2818 | |
CYP | Cyprus | parliament | 2021-05-30 | 1.28 | 56 | PL | Pní Laoú | People's Breath | 8.8 | 51 | 1095 | 1004 | 1628 | 2820 | |
ROU | Romania | parliament | 2020-12-06 | 28.9 | 110 | 330 | PSD | Partidul Social Democrat | Social Democratic Party | 3.2325 | 23 | 1093 | 1015 | 1626 | 1120 |
ROU | Romania | parliament | 2020-12-06 | 25.19 | 93 | 330 | PNL | Partidul Naţional Liberal | National Liberal Party | 6.0543 | 23 | 1093 | 1015 | 1626 | 1015 |
ROU | Romania | parliament | 2020-12-06 | 15.37 | 55 | 330 | USR|PLUS | Uniunea Salvați România | Partidul Libertate, Unitate și Solidaritate | Save Romania Union | Party of Liberty, Unity and Solidarity | 6.0 | 23 | 1093 | 1015 | 1626 | 2646 |
ROU | Romania | parliament | 2020-12-06 | 9.08 | 33 | 330 | AUR | Alianța pentru Unirea Românilor | Alliance for the Unity of Romanians | 8.8 | 23 | 1093 | 1015 | 1626 | 2807 |
ROU | Romania | parliament | 2020-12-06 | 5.74 | 21 | 330 | UDMR | Uniunea Democrată Maghiară din România | Democratic Union of Hungarians in Romania | 6.016 | 23 | 1093 | 1015 | 1626 | 948 |
ROU | Romania | parliament | 2020-12-06 | 18 | 330 | etnice | Partidele minorităţilor etnice din România | Romanian ethnic minorities parties | 23 | 1093 | 1015 | 1626 | 425 | ||
ROU | Romania | parliament | 2020-12-06 | 4.82 | 0 | 330 | PMP | Partidul Mișcarea Populară | People's Movement Party | 6.2 | 23 | 1093 | 1015 | 1626 | 2395 |
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;