view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
239 rows where "election_date" is on date 2014-05-25 sorted by previous_cabinet_id
This data as json, CSV (advanced)
Suggested facets: country_name_short, election_type, seats, election_id, previous_parliament_election_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SWE | Sweden | ep | 2014-05-25 | 24.19 | 5 | 20 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 843 | 512 | 854 | 904 |
SWE | Sweden | ep | 2014-05-25 | 15.41 | 4 | 20 | MP | Miljöpartiet de Gröna | Greens | 3.3789 | 35 | 843 | 512 | 854 | 1154 |
SWE | Sweden | ep | 2014-05-25 | 13.65 | 3 | 20 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 843 | 512 | 854 | 657 |
SWE | Sweden | ep | 2014-05-25 | 9.91 | 2 | 20 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 843 | 512 | 854 | 892 |
SWE | Sweden | ep | 2014-05-25 | 9.67 | 2 | 20 | SD | Sverigedemokraterna | Sweden Democrats | 8.8 | 35 | 843 | 512 | 854 | 1546 |
SWE | Sweden | ep | 2014-05-25 | 6.49 | 1 | 20 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 843 | 512 | 854 | 1461 |
SWE | Sweden | ep | 2014-05-25 | 5.93 | 1 | 20 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 843 | 512 | 854 | 282 |
SWE | Sweden | ep | 2014-05-25 | 6.3 | 1 | 20 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 843 | 512 | 854 | 882 |
SWE | Sweden | ep | 2014-05-25 | 5.49 | 1 | 20 | Fi | Feministiskt initiativ | Feminist Initiative | 35 | 843 | 512 | 854 | 1521 | |
SWE | Sweden | ep | 2014-05-25 | 2.23 | 0 | 20 | Pi | Piratpartiet | Pirate Party | 35 | 843 | 512 | 854 | 721 | |
PRT | Portugal | ep | 2014-05-25 | 34.01 | 8 | 21 | PS | Partido Socialista | Socialist Party | 4.0492 | 63 | 838 | 702 | 917 | 725 |
PRT | Portugal | ep | 2014-05-25 | 29.95 | 7 | 21 | PSD | Partido Social Democrata | Social Democratic Party | 6.2949 | 63 | 838 | 702 | 917 | 1273 |
PRT | Portugal | ep | 2014-05-25 | 13.71 | 3 | 21 | CDU | Coligação Democrático Unitária | Unified Democratic Coalition | 2.2233 | 63 | 838 | 702 | 917 | 1295 |
PRT | Portugal | ep | 2014-05-25 | 7.72 | 2 | 21 | MPT | Partido da Terra | Earth Party | 2.5 | 63 | 838 | 702 | 917 | 2373 |
PRT | Portugal | ep | 2014-05-25 | 4.93 | 1 | 21 | BE | Bloco de Esquerda | Bloc of the Left | 1.6425 | 63 | 838 | 702 | 917 | 557 |
PRT | Portugal | ep | 2014-05-25 | 2.35 | 0 | 21 | L | Livre – Liberdade, Esquerda, Europa e Ecologia | Livre | 3.3 | 63 | 838 | 702 | 917 | 2374 |
PRT | Portugal | ep | 2014-05-25 | 1.72 | 0 | 21 | PAN | Partido pelos Animais e pela Natureza | Party for Animals and Nature | 2.5 | 63 | 838 | 702 | 917 | 1781 |
PRT | Portugal | ep | 2014-05-25 | 1.67 | 0 | 21 | PCTP/MRPP | Comunista dos Trabalhadores Portugueses / Movimento Reorganizativo do Partido do Proletariado | Communist Party of the Portuguese Workers / Reorganizative Movement of the Party of the Proletariat | 1.3 | 63 | 838 | 702 | 917 | 281 |
POL | Poland | ep | 2014-05-25 | 32.13 | 19 | 51 | PO | Platforma Obywatelska | Civic Platform | 6.2355 | 74 | 837 | 766 | 985 | 512 |
POL | Poland | ep | 2014-05-25 | 31.78 | 19 | 51 | PiS | Prawo i Sprawiedliwość | Law and Justice | 7.6997 | 74 | 837 | 766 | 985 | 528 |
POL | Poland | ep | 2014-05-25 | 9.44 | 4 | 51 | SLD | Sojusz Lewicy Demokratycznej | Democratic Left Alliance | 2.8299 | 74 | 837 | 766 | 985 | 629 |
POL | Poland | ep | 2014-05-25 | 7.15 | 4 | 51 | UPR|KNP | Unia Polityki Realnej | Kongres Nowej Prawicy | Real Politics Union | Congress of the New Right | 9.7368 | 74 | 837 | 766 | 985 | 1549 |
POL | Poland | ep | 2014-05-25 | 6.8 | 4 | 51 | PSL | Polskie Stronnictwo Ludowe | Polish People's Party | 4.1856 | 74 | 837 | 766 | 985 | 664 |
POL | Poland | ep | 2014-05-25 | 1 | 51 | UP | Unia Pracy | Labour Union | 2.0348 | 74 | 837 | 766 | 985 | 838 | |
POL | Poland | ep | 2014-05-25 | 3.98 | 0 | 51 | SP | Solidarna Polska | United Poland | 8.8 | 74 | 837 | 766 | 985 | 2372 |
POL | Poland | ep | 2014-05-25 | 3.16 | 0 | 51 | PR|A | Polska Razem | Porozumienie | Poland Together | Agreement | 7.4 | 74 | 837 | 766 | 985 | 2331 |
POL | Poland | ep | 2014-05-25 | 3.58 | 0 | 51 | RP | Twój Ruch (Palikota) | Your (Palikot's) Movement | 6.0 | 74 | 837 | 766 | 985 | 1945 |
POL | Poland | ep | 2014-05-25 | 1.4 | 0 | 51 | RN | Ruch Narodowy | National Movement | 8.8 | 74 | 837 | 766 | 985 | 2398 |
BEL | Belgium | parliament | 2014-05-25 | 20.26 | 33 | 150 | N-VA | Nieuw-Vlaamse Alliantie | New Flemish Alliance | 6.5321 | 64 | 816 | 486 | 987 | 501 |
BEL | Belgium | parliament | 2014-05-25 | 11.67 | 23 | 150 | PS | Parti Socialiste | Socialist Party [Francophone] | 2.9307 | 64 | 816 | 486 | 987 | 1378 |
BEL | Belgium | parliament | 2014-05-25 | 9.64 | 20 | 150 | MR | Mouvement Réformateur | Reformist Movement | 6.6889 | 64 | 816 | 486 | 987 | 915 |
BEL | Belgium | parliament | 2014-05-25 | 11.61 | 18 | 150 | CVP|CD&V | Christelijke Volkspartij | Christen-Democratisch en Vlaams | Flemish Christian Peoples Party | Christian Democrats & Flemish | 5.7667 | 64 | 816 | 486 | 987 | 723 |
BEL | Belgium | parliament | 2014-05-25 | 9.78 | 14 | 150 | PVV|VLD | Partij voor Vrijheid en Vooruitgang | Vlaamse Liberalen en Democraten | Party of Liberty and Progress | Flemish Liberals and Democrats | 7.0053 | 64 | 816 | 486 | 987 | 1110 |
BEL | Belgium | parliament | 2014-05-25 | 8.83 | 13 | 150 | SP | Socialistische Partij | Socialist Party | 3.2459 | 64 | 816 | 486 | 987 | 1029 |
BEL | Belgium | parliament | 2014-05-25 | 4.98 | 9 | 150 | PSC-CDH | Parti Social Chrétien – Centre Democrate Humaniste | Francophone Christian Social Party -- Humanist Democratic Centre | 5.4974 | 64 | 816 | 486 | 987 | 1192 |
BEL | Belgium | parliament | 2014-05-25 | 5.32 | 6 | 150 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 816 | 486 | 987 | 1594 |
BEL | Belgium | parliament | 2014-05-25 | 3.3 | 6 | 150 | Ecolo | Écologistes Confédérés pour l'organisation de luttes originales | Confederated ecologists for the organisation of original struggles | 2.641 | 64 | 816 | 486 | 987 | 161 |
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 | parliament | 2014-05-25 | 3.67 | 3 | 150 | VB | Vlaams Blok | Vlaams Belang | Flemish Block | Flemish Interest | 9.6622 | 64 | 816 | 486 | 987 | 993 |
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 | parliament | 2014-05-25 | 3.72 | 2 | 150 | PA-PTB | Partij van de Arbeid – Parti du Travail de Belgique | Workers' Party of Belgium | 1.3 | 64 | 816 | 486 | 987 | 256 |
BEL | Belgium | parliament | 2014-05-25 | 1.8 | 2 | 150 | FDF | Front Démocratique des Francophones | DéFI | Francophone Democratic Front | 6.1259 | 64 | 816 | 486 | 987 | 969 |
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 | parliament | 2014-05-25 | 1.52 | 1 | 150 | Pp | Parti populaire | People's Party | 7.4 | 64 | 816 | 486 | 987 | 438 |
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 | parliament | 2014-05-25 | 0.86 | 0 | 150 | DLB | Debout Les Belges! | Belgians, Rise Up! | 8.8 | 64 | 816 | 486 | 987 | 2368 |
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 |
ESP | Spain | ep | 2014-05-25 | 26.09 | 16 | 54 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 839 | 777 | 988 | 645 |
ESP | Spain | ep | 2014-05-25 | 23.01 | 14 | 54 | PSOE | Partido Socialista Obrero Español | Spanish Socialist Workers Party | 3.7377 | 27 | 839 | 777 | 988 | 902 |
ESP | Spain | ep | 2014-05-25 | 10.03 | 6 | 54 | PCE|IU | Partido Communista | Izquierda Unida | Communist Party | United Left | 2.0183 | 27 | 839 | 777 | 988 | 118 |
ESP | Spain | ep | 2014-05-25 | 7.98 | 5 | 54 | P | Podemos | We Can | 1.3 | 27 | 839 | 777 | 988 | 2376 |
ESP | Spain | ep | 2014-05-25 | 6.51 | 4 | 54 | UPyD | Unión Progreso y Democracia | Union, Progress and Democracy | 6.0 | 27 | 839 | 777 | 988 | 551 |
ESP | Spain | ep | 2014-05-25 | 5.42 | 3 | 54 | CEP | Coalición por la Europa de los Pueblos | For the Europe of the Peoples | 27 | 839 | 777 | 988 | 771 | |
ESP | Spain | ep | 2014-05-25 | 4.01 | 2 | 54 | ERC | Esquerra Republicana de Catalunya | Republican Left of Catalonia | 3.1072 | 27 | 839 | 777 | 988 | 757 |
ESP | Spain | ep | 2014-05-25 | 3.16 | 2 | 54 | Cs | Ciudadanos – Partido de la Ciudadanía | Citizens -- Party of the Citizenry | 6.0 | 27 | 839 | 777 | 988 | 2375 |
ESP | Spain | ep | 2014-05-25 | 1.92 | 1 | 54 | EP-V | Europa de los Pueblos – Verdes | Europe of the People -- The Greens | 2.5 | 27 | 839 | 777 | 988 | 1657 |
ESP | Spain | ep | 2014-05-25 | 2.08 | 1 | 54 | BNG | Bloque Nacionalista Galego | Galician Nationalist Bloc | 2.9117 | 27 | 839 | 777 | 988 | 520 |
ESP | Spain | ep | 2014-05-25 | 1.57 | 0 | 54 | Vox | Vox | Voice | 8.8 | 27 | 839 | 777 | 988 | 2380 |
ESP | Spain | ep | 2014-05-25 | 1.13 | 0 | 54 | PACMA | Partido Animalista Contra el Maltrato Animal | Animalist Party Against Mistreatment to Animals | 27 | 839 | 777 | 988 | 2381 | |
SVK | Slovakia | ep | 2014-05-25 | 24.1 | 4 | 13 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 847 | 781 | 1027 | 220 |
SVK | Slovakia | ep | 2014-05-25 | 13.22 | 2 | 13 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 847 | 781 | 1027 | 1432 |
SVK | Slovakia | ep | 2014-05-25 | 7.75 | 2 | 13 | SDKU-DS | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovak Democratic and Christian Union -- Democratic Party | 7.3591 | 1 | 847 | 781 | 1027 | 131 |
SVK | Slovakia | ep | 2014-05-25 | 5.83 | 1 | 13 | MH | Most-Híd | Most-Hid | 7.4 | 1 | 847 | 781 | 1027 | 1620 |
SVK | Slovakia | ep | 2014-05-25 | 6.67 | 1 | 13 | SaS | Sloboda a solidarita | Freedom and Solidarity | 6.0 | 1 | 847 | 781 | 1027 | 1460 |
SVK | Slovakia | ep | 2014-05-25 | 6.83 | 1 | 13 | OKS | Obcianska konzervatívna strana | Civic Conservative Party | 8.4211 | 1 | 847 | 781 | 1027 | 1645 |
SVK | Slovakia | ep | 2014-05-25 | 6.53 | 1 | 13 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 847 | 781 | 1027 | 559 |
SVK | Slovakia | ep | 2014-05-25 | 7.46 | 1 | 13 | OLaNO | Obyčajní ľudia a nezávislé osobnosti | Ordinary People and Independent | 7.4 | 1 | 847 | 781 | 1027 | 1759 |
SVK | Slovakia | ep | 2014-05-25 | 3.61 | 0 | 13 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 847 | 781 | 1027 | 1072 |
SVK | Slovakia | ep | 2014-05-25 | 1.52 | 0 | 13 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 847 | 781 | 1027 | 44 |
SVK | Slovakia | ep | 2014-05-25 | 1.74 | 0 | 13 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 847 | 781 | 1027 | 586 |
SVK | Slovakia | ep | 2014-05-25 | 1.49 | 0 | 13 | SDSS | Sociálnodemokratická strana Slovenska | Social Democratic Party of Slovakia | 4.8111 | 1 | 847 | 781 | 1027 | 1651 |
SVK | Slovakia | ep | 2014-05-25 | 1.66 | 0 | 13 | PaS | Právo a spravodlivost | Law and Justice | 1.3 | 1 | 847 | 781 | 1027 | 2389 |
SVK | Slovakia | ep | 2014-05-25 | 3.7 | 0 | 13 | TIP | Strana TIP – Tvoríme inú politiku | TIP Party -- We create another policy | 6.0 | 1 | 847 | 781 | 1027 | 2388 |
SVK | Slovakia | ep | 2014-05-25 | 1.19 | 0 | 13 | MS | Magnificat Slovakia | Beautiful Slovakia | 6.2 | 1 | 847 | 781 | 1027 | 2390 |
SVK | Slovakia | ep | 2014-05-25 | 1.38 | 0 | 13 | NaS-NS | Národ a spravodlivosť – Naša strana | Nation and Justice -- Our Party | 8.8 | 1 | 847 | 781 | 1027 | 2391 |
NLD | Netherlands | ep | 2014-05-25 | 15.18 | 5 | 26 | CDA | Christen Democratisch Appèl | Christian Democratic Appeal | 5.9376 | 8 | 846 | 785 | 1041 | 235 |
NLD | Netherlands | ep | 2014-05-25 | 15.48 | 4 | 26 | D66 | Democraten 66 | Democrats 66 | 4.5066 | 8 | 846 | 785 | 1041 | 345 |
NLD | Netherlands | ep | 2014-05-25 | 13.32 | 4 | 26 | PVV | Partij voor de Vrijheid | Party for Freedom | 8.8 | 8 | 846 | 785 | 1041 | 1501 |
NLD | Netherlands | ep | 2014-05-25 | 12.02 | 3 | 26 | VVD | Volkspartij voor Vrijheid en Democratie | People's Party for Freedom and Democracy | 7.3482 | 8 | 846 | 785 | 1041 | 1409 |
NLD | Netherlands | ep | 2014-05-25 | 9.4 | 3 | 26 | PvdA | Partij van de Arbeid | Labour Party | 3.6118 | 8 | 846 | 785 | 1041 | 742 |
NLD | Netherlands | ep | 2014-05-25 | 9.64 | 2 | 26 | SP | Socialistiese Partij | Socialist Party | 1.3682 | 8 | 846 | 785 | 1041 | 357 |
NLD | Netherlands | ep | 2014-05-25 | 7.67 | 2 | 26 | CU | ChristenUnie | ChristianUnion | 6.1732 | 8 | 846 | 785 | 1041 | 1206 |
NLD | Netherlands | ep | 2014-05-25 | 6.98 | 2 | 26 | GL | GroenLinks | GreenLeft | 2.0454 | 8 | 846 | 785 | 1041 | 756 |
NLD | Netherlands | ep | 2014-05-25 | 4.21 | 1 | 26 | PvdD | Partij voor de Dieren | Party for the Animals | 8 | 846 | 785 | 1041 | 990 | |
NLD | Netherlands | ep | 2014-05-25 | 3.69 | 0 | 26 | 50+ | 50PLUS | 50PLUS | 8 | 846 | 785 | 1041 | 2109 | |
LTU | Lithuania | ep | 2014-05-25 | 17.43 | 2 | 11 | TS-LK | Tėvynės sąjunga | Homeland Union | 7.4004 | 15 | 842 | 786 | 1042 | 1045 |
LTU | Lithuania | ep | 2014-05-25 | 17.26 | 2 | 11 | LSDP | Lietuvos socialdemokratų partija | Lithuanian Social Democratic Party | 3.1972 | 15 | 842 | 786 | 1042 | 1277 |
LTU | Lithuania | ep | 2014-05-25 | 16.55 | 2 | 11 | LRLS | Lietuvos Respublikos liberalų sąjūdis | Liberals Movement of the Republic of Lithuania | 7.7562 | 15 | 842 | 786 | 1042 | 482 |
LTU | Lithuania | ep | 2014-05-25 | 14.25 | 2 | 11 | TT-LDP | Tvarka ir teisingumas – Liberalų demokratų partija | Order and Justice -- Liberal Democratic Party | 5.2955 | 15 | 842 | 786 | 1042 | 1421 |
LTU | Lithuania | ep | 2014-05-25 | 12.81 | 1 | 11 | DP | Darbo partija | Labour Party | 3.86 | 15 | 842 | 786 | 1042 | 581 |
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;