view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by election_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
PRT | Portugal | parliament | 2022-01-30 | 42.5 | 120 | 230 | PS | Partido Socialista | Socialist Party | 4.0492 | 63 | 1109 | 1081 | 1610 | 725 |
PRT | Portugal | parliament | 2022-01-30 | 28.41 | 72 | 230 | PSD | Partido Social Democrata | Social Democratic Party | 6.2949 | 63 | 1109 | 1081 | 1610 | 1273 |
PRT | Portugal | parliament | 2022-01-30 | 7.38 | 12 | 230 | CH | Chega | Enough | 8.8 | 63 | 1109 | 1081 | 1610 | 2789 |
PRT | Portugal | parliament | 2022-01-30 | 5.05 | 8 | 230 | IL | Iniciativa Liberal | Liberal Initiative | 6.0 | 63 | 1109 | 1081 | 1610 | 2788 |
PRT | Portugal | parliament | 2022-01-30 | 4.41 | 6 | 230 | PCP | Partido Comunista Português | Portuguese Communist Party | 2.1754 | 63 | 1109 | 1081 | 1610 | 514 |
PRT | Portugal | parliament | 2022-01-30 | 4.52 | 5 | 230 | BE | Bloco de Esquerda | Bloc of the Left | 1.6425 | 63 | 1109 | 1081 | 1610 | 557 |
PRT | Portugal | parliament | 2022-01-30 | 1.65 | 3 | 230 | CDS-PP | Centro Democrático e Social – Partido Popular | Democratic and Social Centre -- People's Party | 8.0222 | 63 | 1109 | 1081 | 1610 | 251 |
PRT | Portugal | parliament | 2022-01-30 | 0.51 | 2 | 230 | PPM | Partido Popular Monárquico | Popular Monarchist Party | 7.4 | 63 | 1109 | 1081 | 1610 | 107 |
PRT | Portugal | parliament | 2022-01-30 | 1.31 | 1 | 230 | L | Livre – Liberdade, Esquerda, Europa e Ecologia | Livre | 3.3 | 63 | 1109 | 1081 | 1610 | 2374 |
PRT | Portugal | parliament | 2022-01-30 | 1.63 | 1 | 230 | PAN | Partido pelos Animais e pela Natureza | Party for Animals and Nature | 2.5 | 63 | 1109 | 1081 | 1610 | 1781 |
PRT | Portugal | parliament | 2022-01-30 | 0.43 | 0 | 230 | no-seat | no seat | no seat | 63 | 1109 | 1081 | 1610 | 2864 | |
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 | |
HUN | Hungary | parliament | 2022-04-03 | 117 | 199 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 1107 | 1023 | 1531 | 921 | |
HUN | Hungary | parliament | 2022-04-03 | 18 | 199 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 1107 | 1023 | 1531 | 434 | |
HUN | Hungary | parliament | 2022-04-03 | 35.74 | 15 | 199 | DK | Demokratikus Koalíció | Democratic Coalition | 3.3 | 39 | 1107 | 1023 | 1531 | 1970 |
HUN | Hungary | parliament | 2022-04-03 | 10 | 199 | MSZP | Magyar Szocialista Párt | Hungarian Socialist Party | 2.8743 | 39 | 1107 | 1023 | 1531 | 1591 | |
HUN | Hungary | parliament | 2022-04-03 | 10 | 199 | Jobbik | Jobbik Magyarországért Mozgalom | Jobbik Movement for a Better Hungary | 8.8 | 39 | 1107 | 1023 | 1531 | 600 | |
HUN | Hungary | parliament | 2022-04-03 | 10 | 199 | MM | Momentum Mozgalom | Momentum Movement | 7.4 | 39 | 1107 | 1023 | 1531 | 2659 | |
HUN | Hungary | parliament | 2022-04-03 | 5.88 | 6 | 199 | MHM | Mi Hazánk Mozgalom | Our Homeland Movement | 8.8 | 39 | 1107 | 1023 | 1531 | 2745 |
HUN | Hungary | parliament | 2022-04-03 | 6 | 199 | PM | Párbeszéd Magyarországért | Dialogue for Hungary | 2.5 | 39 | 1107 | 1023 | 1531 | 2349 | |
HUN | Hungary | parliament | 2022-04-03 | 5 | 199 | LMP | Lehet Más a Politika | Politics Can Be Different | 2.5 | 39 | 1107 | 1023 | 1531 | 403 | |
HUN | Hungary | parliament | 2022-04-03 | 1 | 199 | one-seat | one seat | one seat | 39 | 1107 | 1023 | 1531 | 952 | ||
HUN | Hungary | parliament | 2022-04-03 | 1 | 199 | none | független | no party affiliation | 39 | 1107 | 1023 | 1531 | 1617 | ||
HUN | Hungary | parliament | 2022-04-03 | 3.27 | 0 | 199 | MKKP | Magyar Kétfarkú Kutya Párt | Hungarian Two-tailed Dog Party | 39 | 1107 | 1023 | 1531 | 2660 | |
HUN | Hungary | parliament | 2022-04-03 | 1.04 | 0 | 199 | MEMO | Megoldás Mozgalom | Solution Movement | 6.0 | 39 | 1107 | 1023 | 1531 | 2855 |
HUN | Hungary | parliament | 2022-04-03 | 54.13 | 199 | Fi+KDNP | Fidesz – Magyar Polgári Szövetség / Kereszténydemokrata Néppárt | Fidesz -- Hungarian Civic Party / Christian Democratic People's Party | 6.5432 | 39 | 1107 | 1023 | 1531 | 437 | |
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 |
ISL | Iceland | parliament | 2021-09-25 | 24.4 | 16 | 63 | Sj | Sjálfstæðisflokkurinn | Independence Party | 7.4854 | 56 | 1105 | 1021 | 1524 | 1342 |
ISL | Iceland | parliament | 2021-09-25 | 17.3 | 13 | 63 | F | Framsóknarflokkurinn | Progressive Party | 5.0365 | 56 | 1105 | 1021 | 1524 | 1455 |
ISL | Iceland | parliament | 2021-09-25 | 12.6 | 8 | 63 | Graen | Vinstrihreyfingin – grænt framboð | Left-Green Movement | 1.1842 | 56 | 1105 | 1021 | 1524 | 210 |
ISL | Iceland | parliament | 2021-09-25 | 9.9 | 6 | 63 | Sam | Samfylkingin | Social Democratic Alliance | 4.0789 | 56 | 1105 | 1021 | 1524 | 1006 |
ISL | Iceland | parliament | 2021-09-25 | 8.8 | 6 | 63 | FlF | Flokkur fólksins | People's Party | 56 | 1105 | 1021 | 1524 | 2632 | |
ISL | Iceland | parliament | 2021-09-25 | 8.6 | 6 | 63 | Pi | Pírata | Pirate Party | 2.5 | 56 | 1105 | 1021 | 1524 | 2205 |
ISL | Iceland | parliament | 2021-09-25 | 8.3 | 5 | 63 | V | Viðreisn | Revival | 7.4 | 56 | 1105 | 1021 | 1524 | 2633 |
ISL | Iceland | parliament | 2021-09-25 | 5.4 | 3 | 63 | M | Miðflokkurinn | Centre Party | 6.0 | 56 | 1105 | 1021 | 1524 | 2655 |
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 |
NOR | Norway | parliament | 2021-09-13 | 26.3 | 48 | 169 | DNA | Det norske Arbeiderparti | Norwegian Labour Party | 3.3706 | 9 | 1104 | 1017 | 1617 | 104 |
NOR | Norway | parliament | 2021-09-13 | 20.4 | 36 | 169 | H | Høyre | Conservative Party | 7.8994 | 9 | 1104 | 1017 | 1617 | 1435 |
NOR | Norway | parliament | 2021-09-13 | 13.5 | 28 | 169 | Sp | Senterpartiet | Centre Party | 4.6565 | 9 | 1104 | 1017 | 1617 | 702 |
NOR | Norway | parliament | 2021-09-13 | 11.6 | 21 | 169 | Fr | Fremskrittspartiet | Progress Party | 8.7595 | 9 | 1104 | 1017 | 1617 | 351 |
NOR | Norway | parliament | 2021-09-13 | 7.6 | 13 | 169 | SV | Sosialistisk Venstreparti | Socialist Left Party | 1.5839 | 9 | 1104 | 1017 | 1617 | 81 |
NOR | Norway | parliament | 2021-09-13 | 4.7 | 8 | 169 | RV | Rød Valgallianse | Red Electoral Alliance | 0.4089 | 9 | 1104 | 1017 | 1617 | 1638 |
NOR | Norway | parliament | 2021-09-13 | 4.6 | 8 | 169 | V | Venstre | Liberal Party of Norway | 5.1467 | 9 | 1104 | 1017 | 1617 | 647 |
NOR | Norway | parliament | 2021-09-13 | 3.9 | 3 | 169 | MDG | Miljøpartiet De Grønne | Green Party | 2.5 | 9 | 1104 | 1017 | 1617 | 2254 |
NOR | Norway | parliament | 2021-09-13 | 3.8 | 3 | 169 | KrF | Kristelig Folkeparti | Christian Democratic Party | 5.8516 | 9 | 1104 | 1017 | 1617 | 1538 |
NOR | Norway | parliament | 2021-09-13 | 0.2 | 1 | 169 | one-seat | one seat | one seat | 9 | 1104 | 1017 | 1617 | 474 | |
NOR | Norway | parliament | 2021-09-13 | 1.1 | 0 | 169 | D | Demokratene | Democrats | 7.4 | 9 | 1104 | 1017 | 1617 | 2816 |
CAN | Canada | parliament | 2021-09-20 | 32.7 | 160 | 338 | LP | Liberal Party of Canada | Liberal Party of Canada | 5.0552 | 29 | 1103 | 1084 | 1620 | 368 |
CAN | Canada | parliament | 2021-09-20 | 33.83 | 119 | 338 | CPC | Conservative Party of Canada | Conservative Party of Canada | 8.6608 | 29 | 1103 | 1084 | 1620 | 1255 |
CAN | Canada | parliament | 2021-09-20 | 7.66 | 32 | 338 | BQ | Bloc Québécois | Quebec Bloc | 3.0215 | 29 | 1103 | 1084 | 1620 | 448 |
CAN | Canada | parliament | 2021-09-20 | 17.87 | 25 | 338 | CCF|NDP | Co-operative Commonwealth Federation | New Democratic Party | Co-operative Commonwealth Federation | New Democratic Party | 2.46 | 29 | 1103 | 1084 | 1620 | 296 |
CAN | Canada | parliament | 2021-09-20 | 2.34 | 2 | 338 | GPC | Green Party of Canada | Green Party of Canada | 1.9018 | 29 | 1103 | 1084 | 1620 | 1259 |
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 |
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 |
BGR | Bulgaria | parliament | 2021-04-04 | 26.18 | 75 | 240 | GERB | Grazhdani za Evropeysko Razvitie na Balgariya | Citizens for European Development of Bulgaria | 8.8 | 10 | 1101 | 1011 | 1505 | 1541 |
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-04-04 | 15.01 | 43 | 240 | KzB|DL | Koalitsiya za Balgariya | Demokratichna Levitsa | Coalition for Bulgaria | Democratic Left | 2.8982 | 10 | 1101 | 1011 | 1505 | 1160 |
BGR | Bulgaria | parliament | 2021-04-04 | 10.51 | 30 | 240 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 1101 | 1011 | 1505 | 1286 |
BGR | Bulgaria | parliament | 2021-04-04 | 9.45 | 27 | 240 | DSB|DB | Demokrati za Silna Balgariya | Demokratichna Balgariya | Democrats for a Strong Bulgaria | Democratic Bulgaria | 7.85 | 10 | 1101 | 1011 | 1505 | 57 |
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-04-04 | 1.3 | 0 | 240 | RzB | Republikantsi za Balgariya | Republicans for Bulgaria | 7.4 | 10 | 1101 | 1011 | 1505 | 2814 |
BGR | Bulgaria | parliament | 2021-04-04 | 2.45 | 0 | 240 | R | Vazrazhdane | Revival | 8.8 | 10 | 1101 | 1011 | 1505 | 2640 |
BGR | Bulgaria | parliament | 2021-04-04 | 2.37 | 0 | 240 | NFSB | Natsionalen Front za Spasenie na Balgariya | National Front for the Salvation of Bulgaria | 8.8 | 10 | 1101 | 1011 | 1505 | 2211 |
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;