view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by previous_parliament_election_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
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 |
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 |
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 | |
AUS | Australia | parliament | 2022-05-21 | 32.58 | 77 | 151 | ALP | Australian Labor Party | Australian Labor Party | 3.8833 | 33 | 1111 | 1087 | 1616 | 1253 |
AUS | Australia | parliament | 2022-05-21 | 58 | 151 | C | Coalition | Coalition | 7.4 | 33 | 1111 | 1087 | 1616 | 1428 | |
AUS | Australia | parliament | 2022-05-21 | 23.89 | 27 | 151 | LPA | Liberal Party of Australia | Liberal Party of Australia | 7.3903 | 33 | 1111 | 1087 | 1616 | 1411 |
AUS | Australia | parliament | 2022-05-21 | 8.0 | 21 | 151 | LNPQ | Liberal National Party of Queensland | Liberal National Party of Queensland | 6.0 | 33 | 1111 | 1087 | 1616 | 154 |
AUS | Australia | parliament | 2022-05-21 | 3.6 | 10 | 151 | NCP|NPA | National (Country) Party | National Party of Australia | National (Country) Party | National Party of Australia | 7.8222 | 33 | 1111 | 1087 | 1616 | 184 |
AUS | Australia | parliament | 2022-05-21 | 5.29 | 10 | 151 | none | no party affiliation | no party affiliation | 33 | 1111 | 1087 | 1616 | 1396 | |
AUS | Australia | parliament | 2022-05-21 | 12.25 | 4 | 151 | AG | Australian Greens | Australian Greens | 1.5439 | 33 | 1111 | 1087 | 1616 | 751 |
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 |
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 |
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 | |
ISR | Israel | parliament | 2020-03-02 | 29.46 | 36 | 120 | L | Likud | The Consolidation | 6.6788 | 34 | 1090 | 1079 | 1613 | 678 |
ISR | Israel | parliament | 2020-03-02 | 26.59 | 33 | 120 | KL | Kahol Lavan | Blue and White | 6.0 | 34 | 1090 | 1079 | 1613 | 2725 |
ISR | Israel | parliament | 2020-03-02 | 12.67 | 15 | 120 | R|H | Rakah | Hadash | New Communist List | Democratic Front | 1.3 | 34 | 1090 | 1079 | 1613 | 732 |
ISR | Israel | parliament | 2020-03-02 | 7.69 | 9 | 120 | Shas | Shomrei Sfarad | Sephardi Guardians | 7.0417 | 34 | 1090 | 1079 | 1613 | 788 |
ISR | Israel | parliament | 2020-03-02 | 5.98 | 7 | 120 | YaToMe | Yahadut HaTora HaMeuhedet | United Torah Judaism | 6.9396 | 34 | 1090 | 1079 | 1613 | 1303 |
ISR | Israel | parliament | 2020-03-02 | 5.24 | 7 | 120 | YB | Yisrael Beiteinu | Israel Our Home | 8.8 | 34 | 1090 | 1079 | 1613 | 1816 |
ISR | Israel | parliament | 2020-03-02 | 5.83 | 7 | 120 | Ma|Av | HaMa'arakh | HaAvoda | Alignment | Labor | 3.3 | 34 | 1090 | 1079 | 1613 | 244 |
ISR | Israel | parliament | 2020-03-02 | 5.24 | 6 | 120 | Y | Yamina | Rightwards | 8.8 | 34 | 1090 | 1079 | 1613 | 2726 |
ISR | Israel | parliament | 2020-03-02 | 0.42 | 0 | 120 | OL | Otzma Leyisrael | Jewish Power | 34 | 1090 | 1079 | 1613 | 2322 | |
DNK | Denmark | parliament | 2022-11-01 | 27.5 | 50 | 179 | Sd | Socialdemokraterne | Social Democrats | 3.8011 | 21 | 1116 | 1077 | 1598 | 1629 |
DNK | Denmark | parliament | 2022-11-01 | 13.3 | 23 | 179 | V | Venstre | Liberal Party | 7.292 | 21 | 1116 | 1077 | 1598 | 1605 |
DNK | Denmark | parliament | 2022-11-01 | 9.3 | 16 | 179 | M | Moderaterne | Moderates | 6.0 | 21 | 1116 | 1077 | 1598 | 2887 |
DNK | Denmark | parliament | 2022-11-01 | 8.3 | 15 | 179 | SF | Socialistisk Folkeparti | Socialist Peoples Party | 2.1347 | 21 | 1116 | 1077 | 1598 | 1644 |
DNK | Denmark | parliament | 2022-11-01 | 7.9 | 14 | 179 | NLA | Ny-Liberal Alliance | New-Liberal Alliance | 6.0 | 21 | 1116 | 1077 | 1598 | 376 |
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 | 5.5 | 10 | 179 | KF | Konservative | Conservatives | 7.2186 | 21 | 1116 | 1077 | 1598 | 590 |
DNK | Denmark | parliament | 2022-11-01 | 5.1 | 9 | 179 | En-O | Enhedslisten – De Rød-Grønne | Red-Green Alliance | 0.8912 | 21 | 1116 | 1077 | 1598 | 306 |
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;