view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by election_date 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
AUS | Australia | parliament | 2022-05-21 | 0.25 | 1 | 151 | NXT | Nick Xenophon Team | Nick Xenophon Team | 6.0 | 33 | 1111 | 1087 | 1616 | 2630 |
AUS | Australia | parliament | 2022-05-21 | 0.38 | 1 | 151 | Katter | Katter's Australian Party | Katter's Australian Party | 3.3 | 33 | 1111 | 1087 | 1616 | 2258 |
AUS | Australia | parliament | 2022-05-21 | 4.12 | 0 | 151 | UAP | United Australia Party | United Australia Party | 7.4 | 33 | 1111 | 1087 | 1616 | 1912 |
AUS | Australia | parliament | 2022-05-21 | 4.96 | 0 | 151 | ONP | One Nation Party | One Nation Party | 8.1579 | 33 | 1111 | 1087 | 1616 | 386 |
AUS | Australia | parliament | 2022-05-21 | 1.73 | 0 | 151 | LD-NSW | Liberal Democratic Party (New South Wales) | Liberal Democratic Party (New South Wales) | 6.0 | 33 | 1111 | 1087 | 1616 | 1927 |
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 | |
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 | |
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 |
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 | |
CZE | Czech Republic | parliament | 2021-10-09 | 27.13 | 72 | 200 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 1099 | 1020 | 1534 | 2263 |
CZE | Czech Republic | parliament | 2021-10-09 | 27.79 | 71 | 200 | ODS | Občanská demokratická strana | Civic Democratic Party | 7.3637 | 68 | 1099 | 1020 | 1534 | 829 |
CZE | Czech Republic | parliament | 2021-10-09 | 15.62 | 37 | 200 | STAN | Starostové a nezávislí | Mayors and Independents | 6.0 | 68 | 1099 | 1020 | 1534 | 2024 |
CZE | Czech Republic | parliament | 2021-10-09 | 9.56 | 20 | 200 | SPD | Svoboda a přímá demokracie | Freedom and Direct Democracy | 8.8 | 68 | 1099 | 1020 | 1534 | 2654 |
CZE | Czech Republic | parliament | 2021-10-09 | 4.66 | 0 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 1099 | 1020 | 1534 | 789 |
CZE | Czech Republic | parliament | 2021-10-09 | 3.61 | 0 | 200 | KSCM | Komunistická strana Cech a Moravy | Communist Party of Bohemia and Moravia | 0.7498 | 68 | 1099 | 1020 | 1534 | 1173 |
CZE | Czech Republic | parliament | 2021-10-09 | 4.68 | 0 | 200 | P | Přísaha | Oath | 68 | 1099 | 1020 | 1534 | 2831 | |
CZE | Czech Republic | parliament | 2021-10-09 | 1.33 | 0 | 200 | VB | Volný blok | Free Bloc | 8.8 | 68 | 1099 | 1020 | 1534 | 2854 |
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 | 0.99 | 0 | 200 | SZ | Strana zelených | Green Party | 4.123 | 68 | 1099 | 1020 | 1534 | 196 |
DEU | Germany | parliament | 2021-09-26 | 25.74 | 206 | 736 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 1096 | 1016 | 1528 | 558 |
DEU | Germany | parliament | 2021-09-26 | 18.9 | 152 | 736 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 1096 | 1016 | 1528 | 808 |
DEU | Germany | parliament | 2021-09-26 | 14.75 | 118 | 736 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 1096 | 1016 | 1528 | 772 |
DEU | Germany | parliament | 2021-09-26 | 11.46 | 92 | 736 | FDP | Freie Demokratische Partei | Free Democratic Party | 5.9233 | 54 | 1096 | 1016 | 1528 | 543 |
DEU | Germany | parliament | 2021-09-26 | 10.34 | 83 | 736 | AfD | Alternative für Deutschland | Alternative for Germany | 8.8 | 54 | 1096 | 1016 | 1528 | 2253 |
DEU | Germany | parliament | 2021-09-26 | 5.17 | 45 | 736 | CSU | Christlich Soziale Union | Christian Social Union | 7.2871 | 54 | 1096 | 1016 | 1528 | 1180 |
DEU | Germany | parliament | 2021-09-26 | 4.89 | 39 | 736 | PDS|Li | PDS | Die Linke | PDS | The Left | 1.2152 | 54 | 1096 | 1016 | 1528 | 791 |
DEU | Germany | parliament | 2021-09-26 | 0.12 | 1 | 736 | SSW | Südschleswigscher Wählerverband | South Schleswig Voter League | 54 | 1096 | 1016 | 1528 | 2850 | |
DEU | Germany | parliament | 2021-09-26 | 2.43 | 0 | 736 | FW | Freie Wähler | Free Voters | 7.4 | 54 | 1096 | 1016 | 1528 | 41 |
DEU | Germany | parliament | 2021-09-26 | 0.99 | 0 | 736 | PARTEI | Die PARTEI | The PARTY | 54 | 1096 | 1016 | 1528 | 2649 | |
DEU | Germany | parliament | 2021-09-26 | 1.36 | 0 | 736 | dieBasis | Basisdemokratische Partei Deutschland | Grassroots Democratic Party of Germany | 54 | 1096 | 1016 | 1528 | 2821 | |
DEU | Germany | parliament | 2021-09-26 | 1.45 | 0 | 736 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 1096 | 1016 | 1528 | 301 | |
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 |
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 |
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;