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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ITA | Italy | parliament | 2022-09-25 | 26.0 | 118 | 400 | FdI | Fratelli d'Italia | Brothers of Italy | 8.8 | 26 | 1113 | 1024 | 1681 | 2154 |
ITA | Italy | parliament | 2022-09-25 | 19.07 | 69 | 400 | PD | Partito Democratico | Democratic Party | 2.6216 | 26 | 1113 | 1024 | 1681 | 382 |
ITA | Italy | parliament | 2022-09-25 | 8.77 | 66 | 400 | LN | Lega Nord | North League | 7.8007 | 26 | 1113 | 1024 | 1681 | 1436 |
ITA | Italy | parliament | 2022-09-25 | 15.43 | 52 | 400 | M5S | Movimento 5 Stelle | Five Star Movement | 26 | 1113 | 1024 | 1681 | 2155 | |
ITA | Italy | parliament | 2022-09-25 | 8.11 | 44 | 400 | FI-PdL | Forza Italia – Il Popolo della Libertà | Go Italy -- The People of Freedom | 7.1459 | 26 | 1113 | 1024 | 1681 | 596 |
ITA | Italy | parliament | 2022-09-25 | 7.79 | 21 | 400 | IV | Italia Viva | Italy Alive | 6.0 | 26 | 1113 | 1024 | 1681 | 2794 |
ITA | Italy | parliament | 2022-09-25 | 3.63 | 11 | 400 | P|SDI | Partito | Socialisti Democratici Italiani | Italian Democratic Socialists | Party | 3.9895 | 26 | 1113 | 1024 | 1681 | 1278 |
ITA | Italy | parliament | 2022-09-25 | 0.91 | 9 | 400 | UC | Unione / Centro | Union / Centre | 6.1092 | 26 | 1113 | 1024 | 1681 | 226 |
ITA | Italy | parliament | 2022-09-25 | 2.83 | 3 | 400 | +EU | +Europa | More Europe | 6.0 | 26 | 1113 | 1024 | 1681 | 2737 |
ITA | Italy | parliament | 2022-09-25 | 0.42 | 3 | 400 | SVP | Südtiroler Volkspartei | South Tyrol Peoples Party | 5.4 | 26 | 1113 | 1024 | 1681 | 1030 |
ITA | Italy | parliament | 2022-09-25 | 3 | 400 | etc | diversi | others | 26 | 1113 | 1024 | 1681 | 825 | ||
ITA | Italy | parliament | 2022-09-25 | 0.76 | 1 | 400 | one-seat | one seat | one seat | 26 | 1113 | 1024 | 1681 | 2302 | |
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 |
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.43 | 0 | 400 | PRC | Partito della Rifondazione Comunista | Communist Refoundation Party | 0.8849 | 26 | 1113 | 1024 | 1681 | 1321 |
BGR | Bulgaria | parliament | 2022-10-02 | 25.33 | 67 | 240 | GERB | Grazhdani za Evropeysko Razvitie na Balgariya | Citizens for European Development of Bulgaria | 8.8 | 10 | 1114 | 1106 | 1678 | 1541 |
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 | 2022-10-02 | 13.75 | 36 | 240 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 1114 | 1106 | 1678 | 1286 |
BGR | Bulgaria | parliament | 2022-10-02 | 10.18 | 27 | 240 | R | Vazrazhdane | Revival | 8.8 | 10 | 1114 | 1106 | 1678 | 2640 |
BGR | Bulgaria | parliament | 2022-10-02 | 9.3 | 25 | 240 | BSP | Balgarska Sotsialisticheska Partiya | Bulgarian Socialist Party | 3.0064 | 10 | 1114 | 1106 | 1678 | 982 |
BGR | Bulgaria | parliament | 2022-10-02 | 7.45 | 20 | 240 | DaB | Da Bulgaria! | Yes, Bulgaria! | 6.0 | 10 | 1114 | 1106 | 1678 | 2638 |
BGR | Bulgaria | parliament | 2022-10-02 | 4.63 | 12 | 240 | BV | Balgarski vazhod | Bulgarian Rise | 7.4 | 10 | 1114 | 1106 | 1678 | 2871 |
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 |
BGR | Bulgaria | parliament | 2022-10-02 | 1.01 | 0 | 240 | IS | Izpravi se! | Stand up! | 3.3 | 10 | 1114 | 1106 | 1678 | 2838 |
ISR | Israel | parliament | 2022-11-01 | 23.41 | 32 | 120 | L | Likud | The Consolidation | 6.6788 | 34 | 1117 | 1100 | 1677 | 678 |
ISR | Israel | parliament | 2022-11-01 | 17.79 | 24 | 120 | YA | Yesh Atid | There is a Future | 6.0 | 34 | 1117 | 1100 | 1677 | 2321 |
ISR | Israel | parliament | 2022-11-01 | 10.84 | 14 | 120 | HaLe-T|RZP | HaIhud HaLeumi–Tkuma | HaTzionut HaDatit | National Union--Tkuma | Religious Zionist Party | 9.5906 | 34 | 1117 | 1100 | 1677 | 1357 |
ISR | Israel | parliament | 2022-11-01 | 9.08 | 12 | 120 | KL | Kahol Lavan | Blue and White | 6.0 | 34 | 1117 | 1100 | 1677 | 2725 |
ISR | Israel | parliament | 2022-11-01 | 8.25 | 11 | 120 | Shas | Shomrei Sfarad | Sephardi Guardians | 7.0417 | 34 | 1117 | 1100 | 1677 | 788 |
ISR | Israel | parliament | 2022-11-01 | 5.88 | 7 | 120 | YaToMe | Yahadut HaTora HaMeuhedet | United Torah Judaism | 6.9396 | 34 | 1117 | 1100 | 1677 | 1303 |
ISR | Israel | parliament | 2022-11-01 | 4.48 | 6 | 120 | YB | Yisrael Beiteinu | Israel Our Home | 8.8 | 34 | 1117 | 1100 | 1677 | 1816 |
ISR | Israel | parliament | 2022-11-01 | 4.07 | 5 | 120 | Raam | al-Qā'ima al-'Arabiyya al-Muwaḥḥada | United Arab List | 34 | 1117 | 1100 | 1677 | 1846 | |
ISR | Israel | parliament | 2022-11-01 | 3.75 | 5 | 120 | R|H | Rakah | Hadash | New Communist List | Democratic Front | 1.3 | 34 | 1117 | 1100 | 1677 | 732 |
ISR | Israel | parliament | 2022-11-01 | 3.69 | 4 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 1117 | 1100 | 1677 | 244 |
ISR | Israel | parliament | 2022-11-01 | 3.16 | 0 | 120 | Meretz | Meretz | Energy | 1.7786 | 34 | 1117 | 1100 | 1677 | 1419 |
ISR | Israel | parliament | 2022-11-01 | 2.91 | 0 | 120 | Balad | Brit Le'umit Demokratit | National Democratic Assembly | 0.7407 | 34 | 1117 | 1100 | 1677 | 805 |
ISR | Israel | parliament | 2022-11-01 | 1.19 | 0 | 120 | MDL|HH | Miflaga Datit Leumit (Mafdal) | Habayit Hayehudi | National Religious Party | The Jewish Home | 8.6207 | 34 | 1117 | 1100 | 1677 | 214 |
FRA | France | parliament | 2022-06-19 | 25.75 | 245 | 577 | REM|R | La République En Marche! | Renaissance | The Republic Onwards! | Renaissance | 6.0 | 43 | 1110 | 1014 | 1673 | 2643 |
FRA | France | parliament | 2022-06-19 | 25.66 | 131 | 577 | FI | La France Insoumise | Unbowed France | 1.3 | 43 | 1110 | 1014 | 1673 | 2644 |
FRA | France | parliament | 2022-06-19 | 18.68 | 89 | 577 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 1110 | 1014 | 1673 | 270 |
FRA | France | parliament | 2022-06-19 | 10.42 | 61 | 577 | UMP|LR | Union pour un mouvement populaire | Les Républicains | Union for a Popular Movement | The Republicans | 7.4997 | 43 | 1110 | 1014 | 1673 | 658 |
FRA | France | parliament | 2022-06-19 | 3.14 | 22 | 577 | d-gauche | divers gauche | other left | 3.3 | 43 | 1110 | 1014 | 1673 | 177 |
FRA | France | parliament | 2022-06-19 | 2.33 | 10 | 577 | d-droite | divers droite | other right | 7.6583 | 43 | 1110 | 1014 | 1673 | 285 |
FRA | France | parliament | 2022-06-19 | 1.28 | 10 | 577 | none | sans étiquette | no party affiliation | 43 | 1110 | 1014 | 1673 | 947 | |
FRA | France | parliament | 2022-06-19 | 1.25 | 4 | 577 | d-center | divers centre | other centre | 6.0 | 43 | 1110 | 1014 | 1673 | 2858 |
FRA | France | parliament | 2022-06-19 | 0.87 | 3 | 577 | UDI | Union des démocrates et indépendants | Union of Democrats and Independents | 7.4 | 43 | 1110 | 1014 | 1673 | 2273 |
FRA | France | parliament | 2022-06-19 | 0.85 | 1 | 577 | etc | divers | others | 43 | 1110 | 1014 | 1673 | 1328 | |
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.17 | 0 | 577 | ex-gau | extrême gauche | other far-left | 1.3 | 43 | 1110 | 1014 | 1673 | 2083 |
FRA | France | parliament | 2022-06-19 | 2.67 | 0 | 577 | PE | Parti écologiste | Ecologist Party | 2.5 | 43 | 1110 | 1014 | 1673 | 2813 |
FRA | France | parliament | 2022-06-19 | 4.24 | 0 | 577 | R! | Reconquête | Reconquest | 8.8 | 43 | 1110 | 1014 | 1673 | 2860 |
SVN | Slovenia | parliament | 2022-04-22 | 34.45 | 41 | 90 | GS | Gibanje Svoboda | Freedom Movement | 3.3 | 60 | 1108 | 1025 | 1668 | 2856 |
SVN | Slovenia | parliament | 2022-04-22 | 23.48 | 27 | 90 | SDS | Slovenska demokratska stranka | Slovenian Democratic Party | 6.9996 | 60 | 1108 | 1025 | 1668 | 179 |
SVN | Slovenia | parliament | 2022-04-22 | 6.86 | 8 | 90 | NSI | Nova Slovenija – Krščanska ljudska stranka | New Slovenia -- Christian People's Party | 7.9345 | 60 | 1108 | 1025 | 1668 | 1047 |
SVN | Slovenia | parliament | 2022-04-22 | 6.69 | 7 | 90 | ZL-SD | Združena lista – Socialni demokrati | United List -- Social Democrats | 3.0637 | 60 | 1108 | 1025 | 1668 | 706 |
SVN | Slovenia | parliament | 2022-04-22 | 4.46 | 5 | 90 | L | Levica | The Left | 1.3 | 60 | 1108 | 1025 | 1668 | 2670 |
SVN | Slovenia | parliament | 2022-04-22 | 1 | 90 | Ita | Italijanska narodna skupnost | Italian national community | 60 | 1108 | 1025 | 1668 | 199 | ||
SVN | Slovenia | parliament | 2022-04-22 | 1 | 90 | Mad | Madžarska narodna skupnost | Hungarian national community | 60 | 1108 | 1025 | 1668 | 65 | ||
SVN | Slovenia | parliament | 2022-04-22 | 3.72 | 0 | 90 | LMS | Lista Marjana Šarca | List of Marjan Sarec | 3.3 | 60 | 1108 | 1025 | 1668 | 2668 |
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 |
SVN | Slovenia | parliament | 2022-04-22 | 1.49 | 0 | 90 | SNS | Slovenska nacionalna stranka | Slovenian National Party | 4.7941 | 60 | 1108 | 1025 | 1668 | 981 |
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.63 | 0 | 90 | PSS | Piratska stranka Slovenije | Slovenian Pirate Party | 60 | 1108 | 1025 | 1668 | 2338 | |
SVN | Slovenia | parliament | 2022-04-22 | 1.7 | 0 | 90 | DD | Dobra Drzava | Good Country | 3.3 | 60 | 1108 | 1025 | 1668 | 2669 |
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 |
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 | 2.61 | 0 | 90 | ZaAB | Zavezništvo Alenke Bratušek | Alliance of Alenka Bratusek | 3.3 | 60 | 1108 | 1025 | 1668 | 2337 |
SVN | Slovenia | parliament | 2022-04-22 | 1.76 | 0 | 90 | GZD | Gibanje Zdrava Družba | Healthy Society Movement | 60 | 1108 | 1025 | 1668 | 2886 | |
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 | 2021-11-14 | 22.74 | 59 | 240 | GERB | Grazhdani za Evropeysko Razvitie na Balgariya | Citizens for European Development of Bulgaria | 8.8 | 10 | 1106 | 1102 | 1658 | 1541 |
BGR | Bulgaria | parliament | 2021-11-14 | 13.0 | 34 | 240 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 1106 | 1102 | 1658 | 1286 |
BGR | Bulgaria | parliament | 2021-11-14 | 10.21 | 26 | 240 | KzB|DL | Koalitsiya za Balgariya | Demokratichna Levitsa | Coalition for Bulgaria | Democratic Left | 2.8982 | 10 | 1106 | 1102 | 1658 | 1160 |
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 | 2021-11-14 | 6.28 | 16 | 240 | DSB|DB | Demokrati za Silna Balgariya | Demokratichna Balgariya | Democrats for a Strong Bulgaria | Democratic Bulgaria | 7.85 | 10 | 1106 | 1102 | 1658 | 57 |
BGR | Bulgaria | parliament | 2021-11-14 | 4.86 | 13 | 240 | R | Vazrazhdane | Revival | 8.8 | 10 | 1106 | 1102 | 1658 | 2640 |
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 | 2021-11-14 | 1.08 | 0 | 240 | VMRO | VMRO – Balgarsko Natsionalno Dvizhenie | IMRO -- Bulgarian National Movement | 7.4 | 10 | 1106 | 1102 | 1658 | 2212 |
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-07-11 | 23.51 | 63 | 240 | GERB | Grazhdani za Evropeysko Razvitie na Balgariya | Citizens for European Development of Bulgaria | 8.8 | 10 | 1102 | 1101 | 1657 | 1541 |
BGR | Bulgaria | parliament | 2021-07-11 | 13.39 | 36 | 240 | KzB|DL | Koalitsiya za Balgariya | Demokratichna Levitsa | Coalition for Bulgaria | Democratic Left | 2.8982 | 10 | 1102 | 1101 | 1657 | 1160 |
BGR | Bulgaria | parliament | 2021-07-11 | 12.64 | 34 | 240 | DSB|DB | Demokrati za Silna Balgariya | Demokratichna Balgariya | Democrats for a Strong Bulgaria | Democratic Bulgaria | 7.85 | 10 | 1102 | 1101 | 1657 | 57 |
BGR | Bulgaria | parliament | 2021-07-11 | 10.71 | 29 | 240 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 1102 | 1101 | 1657 | 1286 |
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-07-11 | 3.01 | 0 | 240 | R | Vazrazhdane | Revival | 8.8 | 10 | 1102 | 1101 | 1657 | 2640 |
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-07-11 | 3.1 | 0 | 240 | VMRO | VMRO – Balgarsko Natsionalno Dvizhenie | IMRO -- Bulgarian National Movement | 7.4 | 10 | 1102 | 1101 | 1657 | 2212 |
SWE | Sweden | parliament | 2022-09-11 | 30.33 | 107 | 349 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 1112 | 1041 | 1652 | 904 |
SWE | Sweden | parliament | 2022-09-11 | 20.54 | 73 | 349 | SD | Sverigedemokraterna | Sweden Democrats | 8.8 | 35 | 1112 | 1041 | 1652 | 1546 |
SWE | Sweden | parliament | 2022-09-11 | 19.1 | 68 | 349 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 1112 | 1041 | 1652 | 657 |
SWE | Sweden | parliament | 2022-09-11 | 6.71 | 24 | 349 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 1112 | 1041 | 1652 | 1461 |
SWE | Sweden | parliament | 2022-09-11 | 6.75 | 24 | 349 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 1112 | 1041 | 1652 | 882 |
SWE | Sweden | parliament | 2022-09-11 | 5.34 | 19 | 349 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 1112 | 1041 | 1652 | 282 |
SWE | Sweden | parliament | 2022-09-11 | 5.08 | 18 | 349 | MP | Miljöpartiet de Gröna | Greens | 3.3789 | 35 | 1112 | 1041 | 1652 | 1154 |
SWE | Sweden | parliament | 2022-09-11 | 4.61 | 16 | 349 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 1112 | 1041 | 1652 | 892 |
SWE | Sweden | parliament | 2022-09-11 | 0.44 | 0 | 349 | no-seat | no seat | no seat | 35 | 1112 | 1041 | 1652 | 2405 | |
NLD | Netherlands | parliament | 2021-03-17 | 21.87 | 34 | 150 | VVD | Volkspartij voor Vrijheid en Democratie | People's Party for Freedom and Democracy | 7.3482 | 8 | 1097 | 1012 | 1648 | 1409 |
NLD | Netherlands | parliament | 2021-03-17 | 15.02 | 24 | 150 | D66 | Democraten 66 | Democrats 66 | 4.5066 | 8 | 1097 | 1012 | 1648 | 345 |
NLD | Netherlands | parliament | 2021-03-17 | 10.79 | 17 | 150 | PVV | Partij voor de Vrijheid | Party for Freedom | 8.8 | 8 | 1097 | 1012 | 1648 | 1501 |
NLD | Netherlands | parliament | 2021-03-17 | 9.5 | 15 | 150 | CDA | Christen Democratisch Appèl | Christian Democratic Appeal | 5.9376 | 8 | 1097 | 1012 | 1648 | 235 |
NLD | Netherlands | parliament | 2021-03-17 | 5.98 | 9 | 150 | SP | Socialistiese Partij | Socialist Party | 1.3682 | 8 | 1097 | 1012 | 1648 | 357 |
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;