view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by party_id descending
This data as json, CSV (advanced)
These facets timed out: election_date
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 ▲ |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DNK | Denmark | parliament | 2022-11-01 | 8.1 | 14 | 179 | AE | Danmarksdemokraterne | Denmark Demokrats | 8.8 | 21 | 1116 | 1077 | 1598 | 2888 |
DNK | Denmark | parliament | 2022-11-01 | 9.3 | 16 | 179 | M | Moderaterne | Moderates | 6.0 | 21 | 1116 | 1077 | 1598 | 2887 |
SVN | Slovenia | parliament | 2022-04-22 | 1.76 | 0 | 90 | GZD | Gibanje Zdrava Družba | Healthy Society Movement | 60 | 1108 | 1025 | 1668 | 2886 | |
SVN | Slovenia | parliament | 2022-04-22 | 2.86 | 0 | 90 | Resni.ca | Resni.ca | Resni.ca | 60 | 1108 | 1025 | 1668 | 2885 | |
SVN | Slovenia | parliament | 2022-04-22 | 3.72 | 0 | 90 | PoS | Povežimo Slovenijo | Let's Connect Slovenia | 7.4 | 60 | 1108 | 1025 | 1668 | 2884 |
LVA | Latvia | parliament | 2022-10-01 | 1.13 | 0 | 100 | PP | Tautas varas spēks | Power of the People | 55 | 1115 | 1042 | 1592 | 2883 | |
LVA | Latvia | parliament | 2022-10-01 | 3.24 | 0 | 100 | SV | Suverēnā vara | Sovereign Power | 55 | 1115 | 1042 | 1592 | 2882 | |
LVA | Latvia | parliament | 2022-10-01 | 1.0 | 0 | 100 | TKL | Tautas kalpi Latvijai | People's Servants for Latvia | 55 | 1115 | 1042 | 1592 | 2881 | |
LVA | Latvia | parliament | 2022-10-01 | 3.67 | 0 | 100 | KuK | Katram un katrai | For Each and Every One | 8.8 | 55 | 1115 | 1042 | 1592 | 2880 |
LVA | Latvia | parliament | 2018-10-06 | 12.04 | 13 | 100 | AP! | Attīstībai/Par! | Development/For! | 55 | 1042 | 831 | 1407 | 2878 | |
LVA | Latvia | parliament | 2022-10-01 | 4.97 | 0 | 100 | AP! | Attīstībai/Par! | Development/For! | 55 | 1115 | 1042 | 1592 | 2878 | |
LVA | Latvia | parliament | 2022-10-01 | 1.76 | 0 | 100 | R | Republika | Republic | 3.3 | 55 | 1115 | 1042 | 1592 | 2877 |
LVA | Latvia | parliament | 2022-10-01 | 6.24 | 9 | 100 | LPV | Latvija pirmajā vietā | Latvia First | 8.8 | 55 | 1115 | 1042 | 1592 | 2876 |
LVA | Latvia | parliament | 2022-10-01 | 6.8 | 11 | 100 | S! | Stabilitātei! | For Stability! | 55 | 1115 | 1042 | 1592 | 2875 | |
ITA | Italy | parliament | 2022-09-25 | 1.24 | 0 | 400 | ISP | Italia sovrana e Popolare | Sovereign and Popular Italy | 8.8 | 26 | 1113 | 1024 | 1681 | 2874 |
ITA | Italy | parliament | 2022-09-25 | 1.9 | 0 | 400 | Italexit | Italext per l'Italia | Italexit for Italy | 7.4 | 26 | 1113 | 1024 | 1681 | 2873 |
BGR | Bulgaria | parliament | 2022-10-02 | 4.63 | 12 | 240 | BV | Balgarski vazhod | Bulgarian Rise | 7.4 | 10 | 1114 | 1106 | 1678 | 2871 |
SVN | Slovenia | parliament | 2022-04-22 | 1.5 | 0 | 90 | ND | Naša dežela | Our Country | 2.5 | 60 | 1108 | 1025 | 1668 | 2866 |
SVN | Slovenia | parliament | 2022-04-22 | 1.35 | 0 | 90 | VESNA | VESNA – zelena stranka | Vesna -- the Green Party | 2.5 | 60 | 1108 | 1025 | 1668 | 2865 |
PRT | Portugal | parliament | 2022-01-30 | 0.43 | 0 | 230 | no-seat | no seat | no seat | 63 | 1109 | 1081 | 1610 | 2864 | |
FRA | France | parliament | 2022-06-19 | 4.24 | 0 | 577 | R! | Reconquête | Reconquest | 8.8 | 43 | 1110 | 1014 | 1673 | 2860 |
FRA | France | parliament | 2022-06-19 | 0.9 | 1 | 577 | one-seat | one seat | one seat | 43 | 1110 | 1014 | 1673 | 2859 | |
FRA | France | parliament | 2022-06-19 | 1.25 | 4 | 577 | d-center | divers centre | other centre | 6.0 | 43 | 1110 | 1014 | 1673 | 2858 |
SVN | Slovenia | parliament | 2022-04-22 | 34.45 | 41 | 90 | GS | Gibanje Svoboda | Freedom Movement | 3.3 | 60 | 1108 | 1025 | 1668 | 2856 |
HUN | Hungary | parliament | 2022-04-03 | 1.04 | 0 | 199 | MEMO | Megoldás Mozgalom | Solution Movement | 6.0 | 39 | 1107 | 1023 | 1531 | 2855 |
CZE | Czech Republic | parliament | 2021-10-09 | 1.33 | 0 | 200 | VB | Volný blok | Free Bloc | 8.8 | 68 | 1099 | 1020 | 1534 | 2854 |
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 | |
ISL | Iceland | parliament | 2021-09-25 | 4.1 | 0 | 63 | SFI | Sósíalistaflokkur Íslands | Icelandic Socialist Party | 1.3 | 56 | 1105 | 1021 | 1524 | 2852 |
JPN | Japan | parliament | 2012-12-16 | 0.36 | 0 | 480 | HRP | Kōfuku Jitsugen-tō | Happiness Realization Party | 8.8 | 5 | 788 | 327 | 969 | 2851 |
JPN | Japan | parliament | 2017-10-22 | 0.52 | 0 | 465 | HRP | Kōfuku Jitsugen-tō | Happiness Realization Party | 8.8 | 5 | 1022 | 850 | 1156 | 2851 |
DEU | Germany | parliament | 1949-08-14 | 0.3 | 1 | 402 | SSW | Südschleswigscher Wählerverband | South Schleswig Voter League | 54 | 581 | 1040 | 1578 | 2850 | |
DEU | Germany | parliament | 2021-09-26 | 0.12 | 1 | 736 | SSW | Südschleswigscher Wählerverband | South Schleswig Voter League | 54 | 1096 | 1016 | 1528 | 2850 | |
BGR | Bulgaria | parliament | 2021-11-14 | 25.67 | 67 | 240 | PP | Prodalzhavame promyanata | We Continue the Change | 10 | 1106 | 1102 | 1658 | 2847 | |
BGR | Bulgaria | parliament | 2022-10-02 | 20.2 | 53 | 240 | PP | Prodalzhavame promyanata | We Continue the Change | 10 | 1114 | 1106 | 1678 | 2847 | |
BGR | Bulgaria | parliament | 2021-04-04 | 2.95 | 0 | 240 | BNO|BN | Bŭlgarsko natsionalno obedinenie | Balgarsko lyato | Bulgarian National Unification | Bulgarian Summer | 8.8 | 10 | 1101 | 1011 | 1505 | 2840 |
BGR | Bulgaria | parliament | 2021-07-11 | 1.82 | 0 | 240 | BNO|BN | Bŭlgarsko natsionalno obedinenie | Balgarsko lyato | Bulgarian National Unification | Bulgarian Summer | 8.8 | 10 | 1102 | 1101 | 1657 | 2840 |
BGR | Bulgaria | parliament | 2021-04-04 | 4.72 | 14 | 240 | IS | Izpravi se! | Stand up! | 3.3 | 10 | 1101 | 1011 | 1505 | 2838 |
BGR | Bulgaria | parliament | 2021-07-11 | 5.01 | 13 | 240 | IS | Izpravi se! | Stand up! | 3.3 | 10 | 1102 | 1101 | 1657 | 2838 |
BGR | Bulgaria | parliament | 2021-11-14 | 2.29 | 0 | 240 | IS | Izpravi se! | Stand up! | 3.3 | 10 | 1106 | 1102 | 1658 | 2838 |
BGR | Bulgaria | parliament | 2022-10-02 | 1.01 | 0 | 240 | IS | Izpravi se! | Stand up! | 3.3 | 10 | 1114 | 1106 | 1678 | 2838 |
BGR | Bulgaria | parliament | 2021-04-04 | 17.66 | 51 | 240 | ITN | Ima takav narod | There Is Such a People | 7.4 | 10 | 1101 | 1011 | 1505 | 2836 |
BGR | Bulgaria | parliament | 2021-07-11 | 24.08 | 65 | 240 | ITN | Ima takav narod | There Is Such a People | 7.4 | 10 | 1102 | 1101 | 1657 | 2836 |
BGR | Bulgaria | parliament | 2021-11-14 | 9.52 | 25 | 240 | ITN | Ima takav narod | There Is Such a People | 7.4 | 10 | 1106 | 1102 | 1658 | 2836 |
BGR | Bulgaria | parliament | 2022-10-02 | 3.83 | 0 | 240 | ITN | Ima takav narod | There Is Such a People | 7.4 | 10 | 1114 | 1106 | 1678 | 2836 |
ISR | Israel | parliament | 2021-03-23 | 4.74 | 6 | 120 | NH | Tikva Hadasha | New Hope | 8.8 | 34 | 1100 | 1090 | 1645 | 2835 |
CZE | Czech Republic | parliament | 2021-10-09 | 2.76 | 0 | 200 | Tri | Trikolóra | Tricolour Citizens' Movement | 8.8 | 68 | 1099 | 1020 | 1534 | 2832 |
CZE | Czech Republic | parliament | 2021-10-09 | 4.68 | 0 | 200 | P | Přísaha | Oath | 68 | 1099 | 1020 | 1534 | 2831 | |
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 | 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 | 14.01 | 25 | 176 | JaRep | Nippon Ishin no Kai | Japan Innovation Party | 8.8 | 5 | 1098 | 1022 | 1647 | 2826 |
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 | 2.37 | 3 | 150 | JA21 | Juiste Antwoord21 | Right Answer 2021 | 8.8 | 8 | 1097 | 1012 | 1648 | 2823 |
DEU | Germany | parliament | 2021-09-26 | 1.36 | 0 | 736 | dieBasis | Basisdemokratische Partei Deutschland | Grassroots Democratic Party of Germany | 54 | 1096 | 1016 | 1528 | 2821 | |
CYP | Cyprus | parliament | 2021-05-30 | 1.28 | 56 | PL | Pní Laoú | People's Breath | 8.8 | 51 | 1095 | 1004 | 1628 | 2820 | |
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 | 2.82 | 0 | 56 | Anex | Independents Movement | Independents Movement | 6.0 | 51 | 1095 | 1004 | 1628 | 2817 |
NOR | Norway | parliament | 2021-09-13 | 1.1 | 0 | 169 | D | Demokratene | Democrats | 7.4 | 9 | 1104 | 1017 | 1617 | 2816 |
CYP | Cyprus | parliament | 2021-05-30 | 3.27 | 0 | 56 | EP | Energi Polites | Active Citizens | 1.3 | 51 | 1095 | 1004 | 1628 | 2815 |
BGR | Bulgaria | parliament | 2021-04-04 | 1.3 | 0 | 240 | RzB | Republikantsi za Balgariya | Republicans for Bulgaria | 7.4 | 10 | 1101 | 1011 | 1505 | 2814 |
FRA | France | parliament | 2022-06-19 | 2.67 | 0 | 577 | PE | Parti écologiste | Ecologist Party | 2.5 | 43 | 1110 | 1014 | 1673 | 2813 |
ROU | Romania | ep | 2019-05-26 | 4 | 32 | PLUS | Partidul Libertate, Unitate și Solidaritate | Party of Liberty, Unity and Solidarity | 6.0 | 23 | 1069 | 1015 | 1527 | 2811 | |
HRV | Croatia | ep | 2019-05-26 | 1.79 | 0 | 11 | M! | Možemo! – politička platforma | We Can! -- Political Platform | 2.5 | 62 | 1062 | 1007 | 1512 | 2810 |
HRV | Croatia | parliament | 2020-07-05 | 6.99 | 7 | 151 | M! | Možemo! – politička platforma | We Can! -- Political Platform | 2.5 | 62 | 1094 | 1007 | 1512 | 2810 |
HRV | Croatia | parliament | 2020-07-05 | 10.89 | 16 | 151 | DP | Domovinski pokret | Homeland Movement | 8.8 | 62 | 1094 | 1007 | 1512 | 2809 |
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 |
NZL | New Zealand | parliament | 2020-10-17 | 1.48 | 0 | 120 | NC | New Conservative Party | New Conservative Party | 8.8 | 11 | 1092 | 1018 | 1518 | 2806 |
LTU | Lithuania | parliament | 2020-10-11 | 9.45 | 11 | 141 | LP | Laisvės partija | Freedom Party | 6.0 | 15 | 1091 | 1009 | 1615 | 2805 |
ESP | Spain | parliament | 2011-11-20 | 0.9 | 0 | 350 | Equo | Equo | Equo | 2.5 | 27 | 777 | 500 | 497 | 2804 |
ESP | Spain | parliament | 2019-11-10 | 1.46 | 2 | 350 | Equo | Equo | Equo | 2.5 | 27 | 1085 | 1046 | 1601 | 2804 |
LTU | Lithuania | parliament | 1996-10-20 | 4 | 141 | etc | others | others | 15 | 566 | 439 | 91 | 2802 | ||
FIN | Finland | parliament | 2019-04-14 | 2.25 | 1 | 200 | LN | Liike Nyt | Movement Now | 6.0 | 67 | 1045 | 855 | 1510 | 2801 |
SVK | Slovakia | parliament | 2020-02-29 | 2.93 | 0 | 150 | V | Vlasť | Homeland | 8.8 | 1 | 1089 | 1003 | 1529 | 2798 |
SVK | Slovakia | parliament | 2020-02-29 | 3.06 | 0 | 150 | DV | Dobrá voľba | Good Choice | 3.3 | 1 | 1089 | 1003 | 1529 | 2797 |
SVK | Slovakia | parliament | 2020-02-29 | 5.77 | 12 | 150 | ZAL | Za ľudí | For the People | 6.0 | 1 | 1089 | 1003 | 1529 | 2796 |
IRL | Ireland | parliament | 2020-02-08 | 1.9 | 1 | 160 | A | Aontú | Aontu | 7.4 | 37 | 1088 | 1002 | 1511 | 2795 |
ITA | Italy | parliament | 2022-09-25 | 7.79 | 21 | 400 | IV | Italia Viva | Italy Alive | 6.0 | 26 | 1113 | 1024 | 1681 | 2794 |
ESP | Spain | parliament | 2019-11-10 | 1.02 | 2 | 350 | CUP | Candidatura d'Unitat Popular | Popular Unity Candidacy | 1.3 | 27 | 1085 | 1046 | 1601 | 2792 |
CAN | Canada | parliament | 2019-10-21 | 1.62 | 0 | 338 | PPC | People's Party of Canada | People's Party of Canada | 8.8 | 29 | 1084 | 994 | 1176 | 2791 |
CAN | Canada | parliament | 2021-09-20 | 4.9 | 0 | 338 | PPC | People's Party of Canada | People's Party of Canada | 8.8 | 29 | 1103 | 1084 | 1620 | 2791 |
POL | Poland | parliament | 2019-10-13 | 6 | 460 | LR | Lewica Razem | Left Together | 3.3 | 74 | 1082 | 996 | 1526 | 2790 | |
PRT | Portugal | ep | 2019-05-26 | 1.6 | 0 | 21 | CH | Chega | Enough | 8.8 | 63 | 1068 | 993 | 1198 | 2789 |
PRT | Portugal | parliament | 2019-10-06 | 1.35 | 1 | 230 | CH | Chega | Enough | 8.8 | 63 | 1081 | 993 | 1198 | 2789 |
PRT | Portugal | parliament | 2022-01-30 | 7.38 | 12 | 230 | CH | Chega | Enough | 8.8 | 63 | 1109 | 1081 | 1610 | 2789 |
PRT | Portugal | parliament | 2019-10-06 | 1.35 | 1 | 230 | IL | Iniciativa Liberal | Liberal Initiative | 6.0 | 63 | 1081 | 993 | 1198 | 2788 |
PRT | Portugal | parliament | 2022-01-30 | 5.05 | 8 | 230 | IL | Iniciativa Liberal | Liberal Initiative | 6.0 | 63 | 1109 | 1081 | 1610 | 2788 |
ISR | Israel | parliament | 2019-04-09 | 1.73 | 0 | 120 | G | Gesher | Bridge | 6.0 | 34 | 1047 | 852 | 1589 | 2787 |
JPN | Japan | parliament | 2012-12-16 | 5.69 | 9 | 480 | TPJ | Nippon Mirai no Tō | Tomorrow Party of Japan | 2.5 | 5 | 788 | 327 | 969 | 2785 |
CYP | Cyprus | ep | 2019-05-26 | 1.7 | 0 | 6 | YH | Yasemin Hareketi | Jasmine Movement | 3.3 | 51 | 1075 | 1004 | 1628 | 2784 |
SVK | Slovakia | ep | 2019-05-25 | 2.06 | 0 | 13 | KDZP | Kresťanská demokracia – Život a prosperita | Christian Democracy -- Life and Prosperity | 6.2 | 1 | 1070 | 1003 | 1529 | 2783 |
DNK | Denmark | parliament | 2019-06-05 | 1.8 | 0 | 179 | SK | Stram Kurs | Hard Line | 8.8 | 21 | 1077 | 976 | 1497 | 2782 |
DNK | Denmark | parliament | 2019-06-05 | 2.4 | 4 | 179 | NB | Nye Borgerlige | The New Right | 8.8 | 21 | 1077 | 976 | 1497 | 2781 |
DNK | Denmark | parliament | 2022-11-01 | 3.7 | 6 | 179 | NB | Nye Borgerlige | The New Right | 8.8 | 21 | 1116 | 1077 | 1598 | 2781 |
GRC | Greece | ep | 2019-05-26 | 4.18 | 1 | 21 | EL | Elliniki Lisi | Greek Solution | 7.4 | 41 | 1060 | 992 | 1593 | 2780 |
GRC | Greece | parliament | 2019-07-07 | 3.7 | 10 | 300 | EL | Elliniki Lisi | Greek Solution | 7.4 | 41 | 1078 | 992 | 1593 | 2780 |
CZE | Czech Republic | ep | 2019-05-25 | 1.56 | 0 | 21 | ANO-VE | ANO, vytrollíme europarlament | Yes, We Will Troll the Euro-Parliament | 68 | 1057 | 1020 | 1534 | 2779 | |
IRL | Ireland | ep | 2019-05-24 | 2.53 | 0 | 11 | D-PRB | Dlúthphartíocht – Pobal Roimh Bhrabús | Solidarity -- People Before Profit | 1.3 | 37 | 1061 | 1002 | 1511 | 2776 |
IRL | Ireland | parliament | 2020-02-08 | 2.63 | 5 | 160 | D-PRB | Dlúthphartíocht – Pobal Roimh Bhrabús | Solidarity -- People Before Profit | 1.3 | 37 | 1088 | 1002 | 1511 | 2776 |
BGR | Bulgaria | ep | 2019-05-26 | 1.18 | 0 | 17 | I-MK | Independent – Mincho Kuminev | Independent -- Mincho Kuminev | 10 | 1059 | 1011 | 1505 | 2774 | |
HRV | Croatia | ep | 2019-05-26 | 1.4 | 0 | 11 | P | Pametno | Intelligently | 6.0 | 62 | 1062 | 1007 | 1512 | 2772 |
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;