view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by election_type
This data as json, CSV (advanced)
election_date (date) >30 ✖
- 2014-05-25 239
- 2019-05-26 234
- 2009-06-07 217
- 2004-06-13 193
- 1999-06-13 148
- 1989-06-18 122
- 1994-06-12 109
- 1984-06-17 87
- 1979-06-10 85
- 1996-10-20 36
- 2014-05-24 36
- 2019-05-25 36
- 1992-06-06 30
- 2011-12-04 30
- 2022-11-01 30
- 2004-06-12 26
- 1991-10-20 25
- 2006-04-09 25
- 2019-05-23 25
- 2007-11-25 24
- 2009-06-04 24
- 2012-06-17 24
- 1993-06-06 23
- 1994-03-27 22
- 1995-10-01 22
- 1990-06-09 21
- 1991-10-27 21
- 1990-04-08 19
- 1996-11-03 19
- 2015-11-08 19
- …
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BEL | Belgium | ep | 1999-06-13 | 0.22 | 1 | 25 | CSP | Christlich Soziale Partei | Christian Social Party | 6.2 | 64 | 624 | 332 | 95 | 119 |
BEL | Belgium | ep | 1999-06-13 | 1.52 | 0 | 25 | FN | Front National | National Front | 9.655 | 64 | 624 | 332 | 95 | 171 |
BEL | Belgium | ep | 1999-06-13 | 1.99 | 0 | 25 | V | Vivant | Alive | 6.0 | 64 | 624 | 332 | 95 | 620 |
BEL | Belgium | ep | 2004-06-13 | 17.43 | 4 | 24 | CD+NVA | Christen-Democratisch & Vlaams / Nieuw-Vlaams Alliantie | Christian-Democrat and Flemish / New Flemish Alliance | 6.2 | 64 | 656 | 143 | 449 | 972 |
BEL | Belgium | ep | 2004-06-13 | 13.54 | 4 | 24 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 656 | 143 | 449 | 1378 |
BEL | Belgium | ep | 2004-06-13 | 11.04 | 3 | 24 | SPa+Spi | Socialistische Partij Anders / Sociaal-Liberale Partij | Socialist Party Different / Social Liberal Party | 3.255 | 64 | 656 | 143 | 449 | 1113 |
BEL | Belgium | ep | 2004-06-13 | 14.34 | 3 | 24 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 656 | 143 | 449 | 993 |
BEL | Belgium | ep | 2004-06-13 | 13.56 | 3 | 24 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 656 | 143 | 449 | 1110 |
BEL | Belgium | ep | 2004-06-13 | 10.35 | 3 | 24 | MR | Mouvement Réformateur | Reformist Movement | 6.6889 | 64 | 656 | 143 | 449 | 915 |
BEL | Belgium | ep | 2004-06-13 | 3.69 | 1 | 24 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 656 | 143 | 449 | 161 |
BEL | Belgium | ep | 2004-06-13 | 4.94 | 1 | 24 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 656 | 143 | 449 | 1594 |
BEL | Belgium | ep | 2004-06-13 | 5.68 | 1 | 24 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 656 | 143 | 449 | 1192 |
BEL | Belgium | ep | 2004-06-13 | 0.24 | 1 | 24 | CSP | Christlich Soziale Partei | Christian Social Party | 6.2 | 64 | 656 | 143 | 449 | 119 |
BEL | Belgium | ep | 2004-06-13 | 2.79 | 0 | 24 | FN | Front National | National Front | 9.655 | 64 | 656 | 143 | 449 | 171 |
BEL | Belgium | ep | 2009-06-07 | 10.88 | 3 | 22 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 638 | 401 | 80 | 1378 |
BEL | Belgium | ep | 2009-06-07 | 12.75 | 3 | 22 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 638 | 401 | 80 | 1110 |
BEL | Belgium | ep | 2009-06-07 | 14.43 | 3 | 22 | CVP|CD&V | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Flemish Christian Peoples Party | Christian Democrats & Flemish | 5.7667 | 64 | 638 | 401 | 80 | 723 |
BEL | Belgium | ep | 2009-06-07 | 8.21 | 2 | 22 | SP | Socialistische Partij | Socialist Party | 3.2459 | 64 | 638 | 401 | 80 | 1029 |
BEL | Belgium | ep | 2009-06-07 | 9.85 | 2 | 22 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 638 | 401 | 80 | 993 |
BEL | Belgium | ep | 2009-06-07 | 9.74 | 2 | 22 | MR | Mouvement Réformateur | Reformist Movement | 6.6889 | 64 | 638 | 401 | 80 | 915 |
BEL | Belgium | ep | 2009-06-07 | 8.55 | 2 | 22 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 638 | 401 | 80 | 161 |
BEL | Belgium | ep | 2009-06-07 | 4.9 | 1 | 22 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 638 | 401 | 80 | 1594 |
BEL | Belgium | ep | 2009-06-07 | 6.13 | 1 | 22 | N-VA | Nieuw-Vlaamse Alliantie | New Flemish Alliance | 6.5321 | 64 | 638 | 401 | 80 | 501 |
BEL | Belgium | ep | 2009-06-07 | 4.99 | 1 | 22 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 638 | 401 | 80 | 1192 |
BEL | Belgium | ep | 2009-06-07 | 0.19 | 1 | 22 | CSP | Christlich Soziale Partei | Christian Social Party | 6.2 | 64 | 638 | 401 | 80 | 119 |
BEL | Belgium | ep | 2009-06-07 | 4.51 | 1 | 22 | LD|LDD | Lijst Dedecker | Libertair, Direct, Democratisch | List Dedecker | Libertarian, Direct, Democratic | 6.0 | 64 | 638 | 401 | 80 | 221 |
BEL | Belgium | ep | 2009-06-07 | 1.33 | 0 | 22 | FN | Front National | National Front | 9.655 | 64 | 638 | 401 | 80 | 171 |
BEL | Belgium | ep | 2014-05-25 | 16.79 | 4 | 21 | N-VA | Nieuw-Vlaamse Alliantie | New Flemish Alliance | 6.5321 | 64 | 832 | 486 | 987 | 501 |
BEL | Belgium | ep | 2014-05-25 | 12.84 | 3 | 21 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 832 | 486 | 987 | 1110 |
BEL | Belgium | ep | 2014-05-25 | 9.88 | 3 | 21 | MR | Mouvement Réformateur | Reformist Movement | 6.6889 | 64 | 832 | 486 | 987 | 915 |
BEL | Belgium | ep | 2014-05-25 | 10.68 | 3 | 21 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 832 | 486 | 987 | 1378 |
BEL | Belgium | ep | 2014-05-25 | 12.57 | 2 | 21 | CVP|CD&V | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Flemish Christian Peoples Party | Christian Democrats & Flemish | 5.7667 | 64 | 832 | 486 | 987 | 723 |
BEL | Belgium | ep | 2014-05-25 | 8.3 | 1 | 21 | SP | Socialistische Partij | Socialist Party | 3.2459 | 64 | 832 | 486 | 987 | 1029 |
BEL | Belgium | ep | 2014-05-25 | 4.26 | 1 | 21 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 832 | 486 | 987 | 993 |
BEL | Belgium | ep | 2014-05-25 | 6.69 | 1 | 21 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 832 | 486 | 987 | 1594 |
BEL | Belgium | ep | 2014-05-25 | 4.26 | 1 | 21 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 832 | 486 | 987 | 161 |
BEL | Belgium | ep | 2014-05-25 | 4.14 | 1 | 21 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 832 | 486 | 987 | 1192 |
BEL | Belgium | ep | 2014-05-25 | 0.18 | 1 | 21 | CSP | Christlich Soziale Partei | Christian Social Party | 6.2 | 64 | 832 | 486 | 987 | 119 |
BEL | Belgium | ep | 2014-05-25 | 3.51 | 0 | 21 | PA-PTB | Partij van de Arbeid – Parti du Travail de Belgique | Workers' Party of Belgium | 1.3 | 64 | 832 | 486 | 987 | 256 |
BEL | Belgium | ep | 2014-05-25 | 1.23 | 0 | 21 | FDF | Front Démocratique des Francophones | DéFI | Francophone Democratic Front | 6.1259 | 64 | 832 | 486 | 987 | 969 |
BEL | Belgium | ep | 2014-05-25 | 2.18 | 0 | 21 | Pp | Parti populaire | People's Party | 7.4 | 64 | 832 | 486 | 987 | 438 |
BEL | Belgium | ep | 2014-05-25 | 1.09 | 0 | 21 | DLB | Debout Les Belges! | Belgians, Rise Up! | 8.8 | 64 | 832 | 486 | 987 | 2368 |
BEL | Belgium | ep | 2019-05-26 | 14.17 | 3 | 21 | N-VA | Nieuw-Vlaamse Alliantie | New Flemish Alliance | 6.5321 | 64 | 1058 | 816 | 1586 | 501 |
BEL | Belgium | ep | 2019-05-26 | 12.05 | 3 | 21 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 1058 | 816 | 1586 | 993 |
BEL | Belgium | ep | 2019-05-26 | 9.74 | 2 | 21 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 1058 | 816 | 1586 | 1378 |
BEL | Belgium | ep | 2019-05-26 | 10.07 | 2 | 21 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 1058 | 816 | 1586 | 1110 |
BEL | Belgium | ep | 2019-05-26 | 9.17 | 2 | 21 | CVP|CD&V | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Flemish Christian Peoples Party | Christian Democrats & Flemish | 5.7667 | 64 | 1058 | 816 | 1586 | 723 |
BEL | Belgium | ep | 2019-05-26 | 7.31 | 2 | 21 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 1058 | 816 | 1586 | 161 |
BEL | Belgium | ep | 2019-05-26 | 7.06 | 2 | 21 | MR | Mouvement Réformateur | Reformist Movement | 6.6889 | 64 | 1058 | 816 | 1586 | 915 |
BEL | Belgium | ep | 2019-05-26 | 3.45 | 2 | 21 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 1058 | 816 | 1586 | 1192 |
BEL | Belgium | ep | 2019-05-26 | 7.81 | 1 | 21 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 1058 | 816 | 1586 | 1594 |
BEL | Belgium | ep | 2019-05-26 | 6.45 | 1 | 21 | SP | Socialistische Partij | Socialist Party | 3.2459 | 64 | 1058 | 816 | 1586 | 1029 |
BEL | Belgium | ep | 2019-05-26 | 8.42 | 1 | 21 | PA-PTB | Partij van de Arbeid – Parti du Travail de Belgique | Workers' Party of Belgium | 1.3 | 64 | 1058 | 816 | 1586 | 256 |
BEL | Belgium | ep | 2019-05-26 | 2.15 | 0 | 21 | FDF | Front Démocratique des Francophones | DéFI | Francophone Democratic Front | 6.1259 | 64 | 1058 | 816 | 1586 | 969 |
BEL | Belgium | ep | 2019-05-26 | 1.69 | 0 | 21 | Pp | Parti populaire | People's Party | 7.4 | 64 | 1058 | 816 | 1586 | 438 |
BGR | Bulgaria | ep | 2007-01-01 | 6 | 18 | KzB|DL | Koalitsiya za Balgariya | Demokratichna Levitsa | Coalition for Bulgaria | Democratic Left | 2.8982 | 10 | 449 | 618 | 425 | 1160 | |
BGR | Bulgaria | ep | 2007-01-01 | 4 | 18 | NDSV | Natsionalno Dvizhenie Simeon Vtori | National Movement Simeon II | 5.7567 | 10 | 449 | 618 | 425 | 544 | |
BGR | Bulgaria | ep | 2007-01-01 | 3 | 18 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 449 | 618 | 425 | 1286 | |
BGR | Bulgaria | ep | 2007-01-01 | 2 | 18 | ODS | Obedineni Demokratichni Sili | United Democratic Forces | 6.9611 | 10 | 449 | 618 | 425 | 784 | |
BGR | Bulgaria | ep | 2007-01-01 | 1 | 18 | BNS | Balgarski Naroden Suyuz | Bulgarian People's Union | 5.8 | 10 | 449 | 618 | 425 | 1375 | |
BGR | Bulgaria | ep | 2007-01-01 | 1 | 18 | Ataka | Ataka | Attack | 5.46 | 10 | 449 | 618 | 425 | 535 | |
BGR | Bulgaria | ep | 2007-01-01 | 1 | 18 | DSB|DB | Demokrati za Silna Balgariya | Demokratichna Balgariya | Democrats for a Strong Bulgaria | Democratic Bulgaria | 7.85 | 10 | 449 | 618 | 425 | 57 | |
BGR | Bulgaria | ep | 2007-05-20 | 21.41 | 5 | 18 | KzB|DL | Koalitsiya za Balgariya | Demokratichna Levitsa | Coalition for Bulgaria | Democratic Left | 2.8982 | 10 | 468 | 618 | 425 | 1160 |
BGR | Bulgaria | ep | 2007-05-20 | 21.68 | 5 | 18 | GERB | Grazhdani za Evropeysko Razvitie na Balgariya | Citizens for European Development of Bulgaria | 8.8 | 10 | 468 | 618 | 425 | 1541 |
BGR | Bulgaria | ep | 2007-05-20 | 20.26 | 4 | 18 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 468 | 618 | 425 | 1286 |
BGR | Bulgaria | ep | 2007-05-20 | 14.2 | 3 | 18 | Ataka | Ataka | Attack | 5.46 | 10 | 468 | 618 | 425 | 535 |
BGR | Bulgaria | ep | 2007-05-20 | 6.27 | 1 | 18 | NDSV | Natsionalno Dvizhenie Simeon Vtori | National Movement Simeon II | 5.7567 | 10 | 468 | 618 | 425 | 544 |
BGR | Bulgaria | ep | 2007-05-20 | 1.54 | 0 | 18 | ZNS | Zemedelski Naroden Suyuz | Agrarian People's Union | 5.5263 | 10 | 468 | 618 | 425 | 353 |
BGR | Bulgaria | ep | 2007-05-20 | 4.74 | 0 | 18 | SDS | Suyuz na Demokratichnite Sili | Union of Democratic Forces | 6.1111 | 10 | 468 | 618 | 425 | 423 |
BGR | Bulgaria | ep | 2007-05-20 | 4.35 | 0 | 18 | DSB|DB | Demokrati za Silna Balgariya | Demokratichna Balgariya | Democrats for a Strong Bulgaria | Democratic Bulgaria | 7.85 | 10 | 468 | 618 | 425 | 57 |
BGR | Bulgaria | ep | 2007-05-20 | 1.94 | 0 | 18 | PBSD | Partiya Balgarski Sotsialdemokrati | Party of Bulgarian Social Democrats | 3.7778 | 10 | 468 | 618 | 425 | 1161 |
BGR | Bulgaria | ep | 2009-06-07 | 24.36 | 5 | 17 | GERB | Grazhdani za Evropeysko Razvitie na Balgariya | Citizens for European Development of Bulgaria | 8.8 | 10 | 432 | 618 | 425 | 1541 |
BGR | Bulgaria | ep | 2009-06-07 | 18.5 | 4 | 17 | KzB|DL | Koalitsiya za Balgariya | Demokratichna Levitsa | Coalition for Bulgaria | Democratic Left | 2.8982 | 10 | 432 | 618 | 425 | 1160 |
BGR | Bulgaria | ep | 2009-06-07 | 14.14 | 3 | 17 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 432 | 618 | 425 | 1286 |
BGR | Bulgaria | ep | 2009-06-07 | 11.96 | 2 | 17 | Ataka | Ataka | Attack | 5.46 | 10 | 432 | 618 | 425 | 535 |
BGR | Bulgaria | ep | 2009-06-07 | 7.96 | 2 | 17 | NDSV | Natsionalno Dvizhenie Simeon Vtori | National Movement Simeon II | 5.7567 | 10 | 432 | 618 | 425 | 544 |
BGR | Bulgaria | ep | 2009-06-07 | 7.95 | 1 | 17 | SK | Sinyata Koalitsiya | Blue Coalition | 7.4 | 10 | 432 | 618 | 425 | 1254 |
BGR | Bulgaria | ep | 2009-06-07 | 4.67 | 0 | 17 | RZS | Red, zakonnost i spravedlivost | Order, Lawfulness and Justice | 8.8 | 10 | 432 | 618 | 425 | 636 |
BGR | Bulgaria | ep | 2009-06-07 | 5.7 | 0 | 17 | Lider | Lider | Lider | 6.0 | 10 | 432 | 618 | 425 | 566 |
BGR | Bulgaria | ep | 2009-06-07 | 2.25 | 0 | 17 | ZNS | Zemedelski Naroden Suyuz | Agrarian People's Union | 5.5263 | 10 | 432 | 618 | 425 | 353 |
BGR | Bulgaria | ep | 2014-05-25 | 30.4 | 6 | 17 | GERB | Grazhdani za Evropeysko Razvitie na Balgariya | Citizens for European Development of Bulgaria | 8.8 | 10 | 830 | 799 | 1058 | 1541 |
BGR | Bulgaria | ep | 2014-05-25 | 18.935 | 4 | 17 | KzB|DL | Koalitsiya za Balgariya | Demokratichna Levitsa | Coalition for Bulgaria | Democratic Left | 2.8982 | 10 | 830 | 799 | 1058 | 1160 |
BGR | Bulgaria | ep | 2014-05-25 | 17.27 | 4 | 17 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 830 | 799 | 1058 | 1286 |
BGR | Bulgaria | ep | 2014-05-25 | 10.656 | 2 | 17 | BBZ | Balgarija bes Zensura | Bulgaria Without Censorship | 7.4 | 10 | 830 | 799 | 1058 | 2362 |
BGR | Bulgaria | ep | 2014-05-25 | 6.45 | 1 | 17 | RB | Reformatorski Blok | Reformist Bloc | 7.4 | 10 | 830 | 799 | 1058 | 2363 |
BGR | Bulgaria | ep | 2014-05-25 | 4.02 | 0 | 17 | ABV | Alternativa za balgarsko vazrazhdane | Alternative for Bulgarian Revival | 3.3 | 10 | 830 | 799 | 1058 | 2364 |
BGR | Bulgaria | ep | 2014-05-25 | 3.05 | 0 | 17 | NFSB | Natsionalen Front za Spasenie na Balgariya | National Front for the Salvation of Bulgaria | 8.8 | 10 | 830 | 799 | 1058 | 2211 |
BGR | Bulgaria | ep | 2014-05-25 | 2.957 | 0 | 17 | Ataka | Ataka | Attack | 5.46 | 10 | 830 | 799 | 1058 | 535 |
BGR | Bulgaria | ep | 2019-05-26 | 31.07 | 6 | 17 | GERB | Grazhdani za Evropeysko Razvitie na Balgariya | Citizens for European Development of Bulgaria | 8.8 | 10 | 1059 | 1011 | 1505 | 1541 |
BGR | Bulgaria | ep | 2019-05-26 | 24.26 | 5 | 17 | KzB|DL | Koalitsiya za Balgariya | Demokratichna Levitsa | Coalition for Bulgaria | Democratic Left | 2.8982 | 10 | 1059 | 1011 | 1505 | 1160 |
BGR | Bulgaria | ep | 2019-05-26 | 16.55 | 3 | 17 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 1059 | 1011 | 1505 | 1286 |
BGR | Bulgaria | ep | 2019-05-26 | 7.36 | 2 | 17 | VMRO | VMRO – Balgarsko Natsionalno Dvizhenie | IMRO -- Bulgarian National Movement | 7.4 | 10 | 1059 | 1011 | 1505 | 2212 |
BGR | Bulgaria | ep | 2019-05-26 | 6.06 | 1 | 17 | DSB|DB | Demokrati za Silna Balgariya | Demokratichna Balgariya | Democrats for a Strong Bulgaria | Democratic Bulgaria | 7.85 | 10 | 1059 | 1011 | 1505 | 57 |
BGR | Bulgaria | ep | 2019-05-26 | 3.62 | 0 | 17 | Volya | Volya | Will | 8.8 | 10 | 1059 | 1011 | 1505 | 2637 |
BGR | Bulgaria | ep | 2019-05-26 | 1.15 | 0 | 17 | NFSB | Natsionalen Front za Spasenie na Balgariya | National Front for the Salvation of Bulgaria | 8.8 | 10 | 1059 | 1011 | 1505 | 2211 |
BGR | Bulgaria | ep | 2019-05-26 | 1.07 | 0 | 17 | Ataka | Ataka | Attack | 5.46 | 10 | 1059 | 1011 | 1505 | 535 |
BGR | Bulgaria | ep | 2019-05-26 | 1.18 | 0 | 17 | I-MK | Independent – Mincho Kuminev | Independent -- Mincho Kuminev | 10 | 1059 | 1011 | 1505 | 2774 | |
BGR | Bulgaria | ep | 2019-05-26 | 1.09 | 0 | 17 | NDSV | Natsionalno Dvizhenie Simeon Vtori | National Movement Simeon II | 5.7567 | 10 | 1059 | 1011 | 1505 | 544 |
BGR | Bulgaria | ep | 2019-05-26 | 1.04 | 0 | 17 | R | Vazrazhdane | Revival | 8.8 | 10 | 1059 | 1011 | 1505 | 2640 |
CYP | Cyprus | ep | 2004-06-13 | 27.89 | 2 | 6 | AKEL | Anorthotikó Kómma Ergazómenou Laoú | Progressive Party of Working People | 1.0526 | 51 | 397 | 339 | 342 | 572 |
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;