view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
193 rows where "election_date" is on date 2004-06-13 sorted by party_name_english
This data as json, CSV (advanced)
Suggested facets: country_name_short, election_type, seats_total, country_id, election_id, previous_cabinet_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LUX | Luxembourg | parliament | 2004-06-13 | 9.04 | 5 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 383 | 299 | 196 | 1582 |
LUX | Luxembourg | ep | 2004-06-13 | 8.03 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 593 | 299 | 196 | 1582 |
BEL | Belgium | ep | 2004-06-13 | 4.94 | 1 | 24 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 656 | 143 | 449 | 1594 |
DEU | Germany | ep | 2004-06-13 | 11.9 | 13 | 99 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 18 | 385 | 529 | 772 |
HUN | Hungary | ep | 2004-06-13 | 7.74 | 2 | 24 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 224 | 463 | 302 | 1426 |
SVK | Slovakia | ep | 2004-06-13 | 4.65 | 0 | 14 | ANO | Aliancia nového občana | Alliance of the New Citizen | 7.2404 | 1 | 124 | 218 | 547 | 1200 |
FRA | France | ep | 2004-06-13 | 0.64 | 1 | 78 | AO | Alliances des outre-mers | Alliance of the Overseas | 1.3 | 43 | 160 | 403 | 802 | 2400 |
DEU | Germany | ep | 2004-06-13 | 1.3 | 0 | 99 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 18 | 385 | 529 | 301 | |
AUT | Austria | ep | 2004-06-13 | 32.7 | 6 | 18 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 45 | 365 | 257 | 1013 |
PRT | Portugal | ep | 2004-06-13 | 5.12 | 1 | 24 | BE | Bloco de Esquerda | Bloc of the Left | 1.6425 | 63 | 140 | 657 | 381 | 557 |
FIN | Finland | ep | 2004-06-13 | 23.4 | 4 | 14 | KESK | Keskusta | Centre Party | 5.8027 | 67 | 198 | 253 | 759 | 94 |
SWE | Sweden | ep | 2004-06-13 | 6.26 | 1 | 19 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 104 | 156 | 641 | 1461 |
LTU | Lithuania | ep | 2004-06-13 | 2.57 | 0 | 13 | KKSS | Krikščionių konservatorių socialinė sąjunga | Christian Conservative Social Union | 6.4579 | 15 | 539 | 59 | 1631 | 709 |
NLD | Netherlands | ep | 2004-06-13 | 24.43 | 7 | 27 | CDA | Christen Democratisch Appèl | Christian Democratic Appeal | 5.9376 | 8 | 519 | 335 | 124 | 235 |
SVK | Slovakia | ep | 2004-06-13 | 16.19 | 3 | 14 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 124 | 218 | 547 | 1432 |
DEU | Germany | ep | 2004-06-13 | 36.5 | 40 | 99 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 18 | 385 | 529 | 808 |
FIN | Finland | ep | 2004-06-13 | 4.3 | 0 | 14 | KD | Kristillisdemokraatit – Kristdemokraterna | Christian Democrats | 7.1884 | 67 | 198 | 253 | 759 | 1463 |
SWE | Sweden | ep | 2004-06-13 | 5.68 | 1 | 19 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 104 | 156 | 641 | 282 |
DNK | Denmark | ep | 2004-06-13 | 1.3 | 0 | 14 | KrF | Kristeligt Folkeparti | Christian People's Party | 5.6982 | 21 | 168 | 632 | 482 | 1331 |
BEL | Belgium | ep | 2004-06-13 | 0.24 | 1 | 24 | CSP | Christlich Soziale Partei | Christian Social Party | 6.2 | 64 | 656 | 143 | 449 | 119 |
LUX | Luxembourg | parliament | 2004-06-13 | 35.81 | 24 | 60 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 383 | 299 | 196 | 1234 |
LUX | Luxembourg | ep | 2004-06-13 | 37.13 | 3 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 593 | 299 | 196 | 1234 |
DEU | Germany | ep | 2004-06-13 | 8.0 | 9 | 99 | CSU | Christlich Soziale Union | Christian Social Union | 7.2871 | 54 | 18 | 385 | 529 | 1180 |
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 |
NLD | Netherlands | ep | 2004-06-13 | 5.87 | 2 | 27 | CU | ChristenUnie | ChristianUnion | 6.1732 | 8 | 519 | 335 | 124 | 1206 |
SVK | Slovakia | ep | 2004-06-13 | 1.0 | 0 | 14 | OKS | Obcianska konzervatívna strana | Civic Conservative Party | 8.4211 | 1 | 124 | 218 | 547 | 1645 |
POL | Poland | ep | 2004-06-13 | 24.1 | 15 | 54 | PO | Platforma Obywatelska | Civic Platform | 6.2355 | 74 | 199 | 565 | 322 | 512 |
GRC | Greece | ep | 2004-06-13 | 4.16 | 1 | 24 | SYRIZA | Synaspismós Rizospastikís Aristerás | Coalition of the Radical Left | 2.8947 | 41 | 672 | 201 | 876 | 1592 |
AUT | Austria | ep | 2004-06-13 | 0.78 | 0 | 18 | KPO | Kommunistische Partei Österreichs | Communist Party of Austria | 0.5 | 59 | 45 | 365 | 257 | 769 |
GRC | Greece | ep | 2004-06-13 | 9.48 | 3 | 24 | KKE | Kommounistikó Kómma Elládas | Communist Party of Greece | 1.253 | 41 | 672 | 201 | 876 | 614 |
LUX | Luxembourg | ep | 2004-06-13 | 1.17 | 0 | 6 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 593 | 299 | 196 | 151 |
LUX | Luxembourg | parliament | 2004-06-13 | 1.15 | 0 | 60 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 383 | 299 | 196 | 151 |
SVK | Slovakia | ep | 2004-06-13 | 4.54 | 0 | 14 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 124 | 218 | 547 | 44 |
PRT | Portugal | ep | 2004-06-13 | 1.11 | 0 | 24 | 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 | 140 | 657 | 381 | 281 |
ESP | Spain | ep | 2004-06-13 | 4.15 | 2 | 54 | PCE|IU | Partido Communista | Izquierda Unida | Communist Party | United Left | 2.0183 | 27 | 368 | 164 | 806 | 118 |
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 |
LVA | Latvia | ep | 2004-06-13 | 1.69 | 0 | 9 | K | Konservatīvā partija | Conservative Party | 7.4 | 55 | 145 | 260 | 153 | 1351 |
DNK | Denmark | ep | 2004-06-13 | 11.3 | 1 | 14 | KF | Konservative | Conservatives | 7.2186 | 21 | 168 | 632 | 482 | 590 |
DNK | Denmark | ep | 2004-06-13 | 6.8 | 1 | 14 | DF | Dansk Folkeparti | Danish Peoples Party | 8.2269 | 21 | 168 | 632 | 482 | 1418 |
DNK | Denmark | ep | 2004-06-13 | 6.4 | 1 | 14 | RV | Det Radikale Venstre | Danish Social Liberal Party | 4.8736 | 21 | 168 | 632 | 482 | 211 |
MLT | Malta | ep | 2004-06-13 | 9.33 | 0 | 5 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 346 | 509 | 298 | 360 |
POL | Poland | ep | 2004-06-13 | 9.35 | 4 | 54 | SLD | Sojusz Lewicy Demokratycznej | Democratic Left Alliance | 2.8299 | 74 | 199 | 565 | 322 | 629 |
CYP | Cyprus | ep | 2004-06-13 | 17.09 | 1 | 6 | DIKO | Dimokratikó Kómma | Democratic Party | 5.1316 | 51 | 397 | 339 | 342 | 851 |
LUX | Luxembourg | parliament | 2004-06-13 | 14.94 | 10 | 60 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 383 | 299 | 196 | 967 |
LUX | Luxembourg | ep | 2004-06-13 | 14.87 | 1 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 593 | 299 | 196 | 967 |
CYP | Cyprus | ep | 2004-06-13 | 28.23 | 2 | 6 | DISY | Dimokratikós Sinayermós | Democratic Rally | 8.6842 | 51 | 397 | 339 | 342 | 1575 |
FIN | Finland | ep | 2004-06-13 | 9.1 | 1 | 14 | DL|VAS | Demokraattinen Liitto – Demokratiska Förbundet | Vasemmistoliitto – Vänsterförbundet | Democratic Union | Left Alliance | 2.1843 | 67 | 198 | 253 | 759 | 1292 |
POL | Poland | ep | 2004-06-13 | 7.33 | 4 | 54 | D|W|U | Demokratyczna | Wolności | Unia | Democratic | Freedom | Union | 5.2295 | 74 | 199 | 565 | 322 | 1104 |
NLD | Netherlands | ep | 2004-06-13 | 4.25 | 1 | 27 | D66 | Democraten 66 | Democrats 66 | 4.5066 | 8 | 519 | 335 | 124 | 345 |
SVK | Slovakia | ep | 2004-06-13 | 16.89 | 3 | 14 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 124 | 218 | 547 | 220 |
LTU | Lithuania | ep | 2004-06-13 | 5.71 | 0 | 13 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 539 | 59 | 1631 | 28 |
EST | Estonia | ep | 2004-06-13 | 1.2 | 0 | 6 | ESE-D | Eesti Sinine Erakond – Demokraadid | Estonian Blue Party -- Democrats | 6.0 | 75 | 130 | 423 | 138 | 2267 |
EST | Estonia | ep | 2004-06-13 | 17.5 | 1 | 6 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 130 | 423 | 138 | 1137 |
EST | Estonia | ep | 2004-06-13 | 12.2 | 1 | 6 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 130 | 423 | 138 | 113 |
NLD | Netherlands | ep | 2004-06-13 | 7.33 | 2 | 27 | EuTr | Europa Transparant | Europe Transparent | 8 | 519 | 335 | 124 | 339 | |
ESP | Spain | ep | 2004-06-13 | 2.45 | 1 | 54 | EP-V | Europa de los Pueblos – Verdes | Europe of the People -- The Greens | 2.5 | 27 | 368 | 164 | 806 | 1657 |
ESP | Spain | ep | 2004-06-13 | 1.27 | 0 | 54 | C-NE | Coalicion Nacionalista-Europea | European-Nationalist Coalition | 27 | 368 | 164 | 806 | 2172 | |
DEU | Germany | ep | 2004-06-13 | 1.0 | 0 | 99 | Fam | Familien-Partei Deutschlands | Family Party of Germany | 7.4 | 54 | 18 | 385 | 529 | 1235 |
IRL | Ireland | ep | 2004-06-13 | 29.45 | 4 | 13 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 123 | 408 | 179 | 280 |
HUN | Hungary | ep | 2004-06-13 | 47.4 | 12 | 24 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 224 | 463 | 302 | 921 |
IRL | Ireland | ep | 2004-06-13 | 27.76 | 5 | 13 | FG | Fine Gael | Fine Gael (Familiy of the Irish) | 6.4372 | 37 | 123 | 408 | 179 | 1393 |
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 |
CYP | Cyprus | ep | 2004-06-13 | 10.8 | 1 | 6 | GTE | Gia tin Evropi | For Europe | 7.4 | 51 | 397 | 339 | 342 | 768 |
LVA | Latvia | ep | 2004-06-13 | 10.66 | 1 | 9 | PCTVL | Par cilvēka tiesībām vienotā Latvijā | For Human Rights in a United Latvia | 1.25 | 55 | 145 | 260 | 153 | 1520 |
ESP | Spain | ep | 2004-06-13 | 5.15 | 2 | 54 | CEP | Coalición por la Europa de los Pueblos | For the Europe of the Peoples | 27 | 368 | 164 | 806 | 771 | |
NLD | Netherlands | ep | 2004-06-13 | 2.55 | 0 | 27 | LPF | Lijst Pim Fortuyn | Fortuyn List | 8.5609 | 8 | 519 | 335 | 124 | 456 |
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 |
DEU | Germany | ep | 2004-06-13 | 6.1 | 7 | 99 | FDP | Freie Demokratische Partei | Free Democratic Party | 5.9233 | 54 | 18 | 385 | 529 | 543 |
SVK | Slovakia | ep | 2004-06-13 | 3.25 | 0 | 14 | SF | Slobodné fórum | Free Forum | 5.46 | 1 | 124 | 218 | 547 | 752 |
AUT | Austria | ep | 2004-06-13 | 6.31 | 1 | 18 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 45 | 365 | 257 | 50 |
FRA | France | ep | 2004-06-13 | 5.25 | 2 | 78 | PCF | Parti communiste française | French Communist Party | 1.3741 | 43 | 160 | 403 | 802 | 686 |
FIN | Finland | ep | 2004-06-13 | 10.4 | 1 | 14 | VIHR | Vihreä Liitto – Gröna Förbundet | Green League | 3.6465 | 67 | 198 | 253 | 759 | 1062 |
IRL | Ireland | ep | 2004-06-13 | 4.32 | 0 | 13 | Green | Green Party – Comhaontas Glas | Green Party | 2.435 | 37 | 123 | 408 | 179 | 1573 |
LVA | Latvia | ep | 2004-06-13 | 4.25 | 0 | 9 | ZZS | Zaļo un Zemnieku savienība | Green and Farmers' Union | 5.2632 | 55 | 145 | 260 | 153 | 466 |
NLD | Netherlands | ep | 2004-06-13 | 7.39 | 2 | 27 | GL | GroenLinks | GreenLeft | 2.0454 | 8 | 519 | 335 | 124 | 756 |
FRA | France | ep | 2004-06-13 | 7.5 | 6 | 78 | V | Les Verts | Greens | 3.155 | 43 | 160 | 403 | 802 | 873 |
SWE | Sweden | ep | 2004-06-13 | 5.96 | 1 | 19 | MP | Miljöpartiet de Gröna | Greens | 3.3789 | 35 | 104 | 156 | 641 | 1154 |
AUT | Austria | ep | 2004-06-13 | 13.98 | 2 | 18 | Martin | Liste Dr. Hans-Peter Martin | Hans-Peter Martin's List | 4.2 | 59 | 45 | 365 | 257 | 669 |
LTU | Lithuania | ep | 2004-06-13 | 12.58 | 2 | 13 | TS-LK | Tėvynės sąjunga | Homeland Union | 7.4004 | 15 | 539 | 59 | 1631 | 1045 |
SVK | Slovakia | ep | 2004-06-13 | 13.24 | 2 | 14 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 124 | 218 | 547 | 559 |
HUN | Hungary | ep | 2004-06-13 | 5.33 | 1 | 24 | MDF | Magyar Demokrata Fórum | Hungarian Democratic Forum | 6.4826 | 39 | 224 | 463 | 302 | 546 |
HUN | Hungary | ep | 2004-06-13 | 2.35 | 0 | 24 | MIEP | Magyar Igazság és Élet Pártja | Hungarian Justice and Life Party | 9.6065 | 39 | 224 | 463 | 302 | 95 |
HUN | Hungary | ep | 2004-06-13 | 34.3 | 9 | 24 | MSZP | Magyar Szocialista Párt | Hungarian Socialist Party | 2.8743 | 39 | 224 | 463 | 302 | 1591 |
HUN | Hungary | ep | 2004-06-13 | 1.83 | 0 | 24 | MMP | Magyar Munkáspárt | Hungarian Workers' Party | 0.6316 | 39 | 224 | 463 | 302 | 1202 |
FRA | France | ep | 2004-06-13 | 1.7 | 0 | 78 | CPNT | Chasse, pêche, nature, traditions | Hunting, Fishing, Nature, Tradition | 7.8 | 43 | 160 | 403 | 802 | 259 |
IRL | Ireland | ep | 2004-06-13 | 3.74 | 1 | 13 | I-MH | Independent – Marian Harkin | Independent -- Marian Harkin | 37 | 123 | 408 | 179 | 2329 | |
POL | Poland | ep | 2004-06-13 | 1.45 | 0 | 54 | IdP | Inicjatywa dla Polski | Initiative for Poland | 7.4 | 74 | 199 | 565 | 322 | 1680 |
SWE | Sweden | ep | 2004-06-13 | 14.47 | 3 | 19 | Jl | Junilistan | June List | 5.67 | 35 | 104 | 156 | 641 | 404 |
DNK | Denmark | ep | 2004-06-13 | 9.1 | 1 | 14 | JuBe | JuniBevægelsen | June Movement | 2.585 | 21 | 168 | 632 | 482 | 1450 |
IRL | Ireland | ep | 2004-06-13 | 10.56 | 1 | 13 | Lab | Labour Party | Labour Party | 3.6252 | 37 | 123 | 408 | 179 | 318 |
LTU | Lithuania | ep | 2004-06-13 | 30.16 | 5 | 13 | DP | Darbo partija | Labour Party | 3.86 | 15 | 539 | 59 | 1631 | 581 |
NLD | Netherlands | ep | 2004-06-13 | 23.6 | 7 | 27 | PvdA | Partij van de Arbeid | Labour Party | 3.6118 | 8 | 519 | 335 | 124 | 742 |
POL | Poland | ep | 2004-06-13 | 1 | 54 | UP | Unia Pracy | Labour Union | 2.0348 | 74 | 199 | 565 | 322 | 838 | |
LVA | Latvia | ep | 2004-06-13 | 3.24 | 0 | 9 | LPP | Latvijas Pirmā partija | Latvia's First Party | 6.3377 | 55 | 145 | 260 | 153 | 1043 |
LVA | Latvia | ep | 2004-06-13 | 4.77 | 0 | 9 | LSDSP | Latvijas Sociāldemokrātiskā Strādnieku Partija | Latvian Social Democratic Workers' Party | 2.5 | 55 | 145 | 260 | 153 | 1656 |
LVA | Latvia | ep | 2004-06-13 | 6.55 | 1 | 9 | LC | Latvijas Ceļš | Latvian Way | 6.125 | 55 | 145 | 260 | 153 | 526 |
POL | Poland | ep | 2004-06-13 | 12.67 | 7 | 54 | PiS | Prawo i Sprawiedliwość | Law and Justice | 7.6997 | 74 | 199 | 565 | 322 | 528 |
POL | Poland | ep | 2004-06-13 | 15.92 | 10 | 54 | LPR | Liga Polskich Rodzin | League of Polish Families | 8.8852 | 74 | 199 | 565 | 322 | 987 |
SWE | Sweden | ep | 2004-06-13 | 12.79 | 2 | 19 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 104 | 156 | 641 | 882 |
SVN | Slovenia | ep | 2004-06-13 | 21.91 | 2 | 7 | LDS | Liberalna demokracija Slovenije | Liberal Democracy of Slovenia | 3.7351 | 60 | 659 | 525 | 292 | 1252 |
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;