view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
193 rows where "election_date" is on date 2004-06-13
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LTU | Lithuania | ep | 2004-06-13 | 7.41 | 1 | 13 | LVLS | Lietuvos valstiečių sąjunga | Lithuanian Peasant Union | 3.2687 | 15 | 539 | 59 | 1631 | 191 |
LTU | Lithuania | ep | 2004-06-13 | 6.83 | 1 | 13 | TT-LDP | Tvarka ir teisingumas – Liberalų demokratų partija | Order and Justice -- Liberal Democratic Party | 5.2955 | 15 | 539 | 59 | 1631 | 1421 |
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 |
LTU | Lithuania | ep | 2004-06-13 | 4.85 | 0 | 13 | NS-SL | Naujoji sąjunga (socialliberalai) | New Union (Social Liberals) | 4.2686 | 15 | 539 | 59 | 1631 | 856 |
LTU | Lithuania | ep | 2004-06-13 | 2.75 | 0 | 13 | LKDP | Lietuvos krikščionys demokratai | Lithuanian Christian Democrats | 6.2385 | 15 | 539 | 59 | 1631 | 675 |
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 |
LTU | Lithuania | ep | 2004-06-13 | 1.18 | 0 | 13 | Tpp | Tautos pažangos partija | Party of National Progress | 8.8 | 15 | 539 | 59 | 1631 | 2026 |
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 | parliament | 2004-06-13 | 25.43 | 14 | 60 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 383 | 299 | 196 | 701 |
LUX | Luxembourg | parliament | 2004-06-13 | 14.94 | 10 | 60 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 383 | 299 | 196 | 967 |
LUX | Luxembourg | parliament | 2004-06-13 | 11.54 | 7 | 60 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 383 | 299 | 196 | 310 |
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 | 37.13 | 3 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 593 | 299 | 196 | 1234 |
LUX | Luxembourg | ep | 2004-06-13 | 14.87 | 1 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 593 | 299 | 196 | 967 |
LUX | Luxembourg | ep | 2004-06-13 | 15.02 | 1 | 6 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 593 | 299 | 196 | 310 |
LUX | Luxembourg | ep | 2004-06-13 | 22.09 | 1 | 6 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 593 | 299 | 196 | 701 |
LUX | Luxembourg | parliament | 2004-06-13 | 2.01 | 0 | 60 | DL | Déi Lénk | The Left | 0.5263 | 7 | 383 | 299 | 196 | 457 |
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 |
LUX | Luxembourg | ep | 2004-06-13 | 1.69 | 0 | 6 | DL | Déi Lénk | The Left | 0.5263 | 7 | 593 | 299 | 196 | 457 |
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 |
LVA | Latvia | ep | 2004-06-13 | 29.82 | 4 | 9 | NA/TB/LNNK | Nacionālā apvienība / Tēvzemei un Brīvībai / LNNK | National Alliance / For Fatherland and Freedom / LNNK | 8.2588 | 55 | 145 | 260 | 153 | 521 |
LVA | Latvia | ep | 2004-06-13 | 19.71 | 2 | 9 | JL | Jaunais Laiks | New Era | 7.3026 | 55 | 145 | 260 | 153 | 1518 |
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 |
LVA | Latvia | ep | 2004-06-13 | 6.65 | 1 | 9 | TP | Tautas Partija | People's Party | 7.7544 | 55 | 145 | 260 | 153 | 811 |
LVA | Latvia | ep | 2004-06-13 | 6.55 | 1 | 9 | LC | Latvijas Ceļš | Latvian Way | 6.125 | 55 | 145 | 260 | 153 | 526 |
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 |
LVA | Latvia | ep | 2004-06-13 | 2.23 | 0 | 9 | SDLP | Sociāldemokrātiskā Labklājības partija | Social Democratic Welfare Party | 3.3 | 55 | 145 | 260 | 153 | 257 |
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 | TSP | Tautas Saskaņas Partija | National Harmony Party | 1.864 | 55 | 145 | 260 | 153 | 32 |
LVA | Latvia | ep | 2004-06-13 | 1.65 | 0 | 9 | LSP | Latvijas Sociālistiskā partija | Socialist Party of Latvia | 1.25 | 55 | 145 | 260 | 153 | 309 |
LVA | Latvia | ep | 2004-06-13 | 1.46 | 0 | 9 | LG | Latgales Gaisma | Light of Latgale | 55 | 145 | 260 | 153 | 956 | |
LVA | Latvia | ep | 2004-06-13 | 1.69 | 0 | 9 | K | Konservatīvā partija | Conservative Party | 7.4 | 55 | 145 | 260 | 153 | 1351 |
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 |
MLT | Malta | ep | 2004-06-13 | 48.42 | 3 | 5 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 346 | 509 | 298 | 1003 |
MLT | Malta | ep | 2004-06-13 | 39.75 | 2 | 5 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 346 | 509 | 298 | 984 |
MLT | Malta | ep | 2004-06-13 | 9.33 | 0 | 5 | AD | Alternattiva Demokratika | Democratic Alternative | 3.7895 | 72 | 346 | 509 | 298 | 360 |
NLD | Netherlands | ep | 2004-06-13 | 23.6 | 7 | 27 | PvdA | Partij van de Arbeid | Labour Party | 3.6118 | 8 | 519 | 335 | 124 | 742 |
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 |
NLD | Netherlands | ep | 2004-06-13 | 13.2 | 4 | 27 | VVD | Volkspartij voor Vrijheid en Democratie | People's Party for Freedom and Democracy | 7.3482 | 8 | 519 | 335 | 124 | 1409 |
NLD | Netherlands | ep | 2004-06-13 | 7.33 | 2 | 27 | EuTr | Europa Transparant | Europe Transparent | 8 | 519 | 335 | 124 | 339 | |
NLD | Netherlands | ep | 2004-06-13 | 6.97 | 2 | 27 | SP | Socialistiese Partij | Socialist Party | 1.3682 | 8 | 519 | 335 | 124 | 357 |
NLD | Netherlands | ep | 2004-06-13 | 7.39 | 2 | 27 | GL | GroenLinks | GreenLeft | 2.0454 | 8 | 519 | 335 | 124 | 756 |
NLD | Netherlands | ep | 2004-06-13 | 5.87 | 2 | 27 | CU | ChristenUnie | ChristianUnion | 6.1732 | 8 | 519 | 335 | 124 | 1206 |
NLD | Netherlands | ep | 2004-06-13 | 4.25 | 1 | 27 | D66 | Democraten 66 | Democrats 66 | 4.5066 | 8 | 519 | 335 | 124 | 345 |
NLD | Netherlands | ep | 2004-06-13 | 2.55 | 0 | 27 | LPF | Lijst Pim Fortuyn | Fortuyn List | 8.5609 | 8 | 519 | 335 | 124 | 456 |
NLD | Netherlands | ep | 2004-06-13 | 3.22 | 0 | 27 | PvdD | Partij voor de Dieren | Party for the Animals | 8 | 519 | 335 | 124 | 990 | |
POL | Poland | ep | 2004-06-13 | 24.1 | 15 | 54 | PO | Platforma Obywatelska | Civic Platform | 6.2355 | 74 | 199 | 565 | 322 | 512 |
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 |
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 | 10.78 | 6 | 54 | SRP | Samoobrona Rzeczypospolitej Polskiej | Self-Defense of the Republic Poland | 3.997 | 74 | 199 | 565 | 322 | 207 |
POL | Poland | ep | 2004-06-13 | 6.34 | 4 | 54 | PSL | Polskie Stronnictwo Ludowe | Polish People's Party | 4.1856 | 74 | 199 | 565 | 322 | 664 |
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 |
POL | Poland | ep | 2004-06-13 | 9.35 | 4 | 54 | SLD | Sojusz Lewicy Demokratycznej | Democratic Left Alliance | 2.8299 | 74 | 199 | 565 | 322 | 629 |
POL | Poland | ep | 2004-06-13 | 5.33 | 3 | 54 | SDPL | Socjaldemokracja Polska | Social Democracy of Poland | 3.0 | 74 | 199 | 565 | 322 | 1140 |
POL | Poland | ep | 2004-06-13 | 1 | 54 | UP | Unia Pracy | Labour Union | 2.0348 | 74 | 199 | 565 | 322 | 838 | |
POL | Poland | ep | 2004-06-13 | 1.87 | 0 | 54 | UPR|KNP | Unia Polityki Realnej | Kongres Nowej Prawicy | Real Politics Union | Congress of the New Right | 9.7368 | 74 | 199 | 565 | 322 | 1549 |
POL | Poland | ep | 2004-06-13 | 1.56 | 0 | 54 | NKWW | Narodowy Komitet Wyborczy Wyborców | National Voters Committee | 6.2 | 74 | 199 | 565 | 322 | 1678 |
POL | Poland | ep | 2004-06-13 | 1.45 | 0 | 54 | IdP | Inicjatywa dla Polski | Initiative for Poland | 7.4 | 74 | 199 | 565 | 322 | 1680 |
PRT | Portugal | ep | 2004-06-13 | 46.36 | 12 | 24 | PS | Partido Socialista | Socialist Party | 4.0492 | 63 | 140 | 657 | 381 | 725 |
PRT | Portugal | ep | 2004-06-13 | 34.64 | 9 | 24 | PSD | Partido Social Democrata | Social Democratic Party | 6.2949 | 63 | 140 | 657 | 381 | 1273 |
PRT | Portugal | ep | 2004-06-13 | 9.46 | 2 | 24 | CDU | Coligação Democrático Unitária | Unified Democratic Coalition | 2.2233 | 63 | 140 | 657 | 381 | 1295 |
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 |
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 |
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 |
SVK | Slovakia | ep | 2004-06-13 | 17.04 | 3 | 14 | HZDS | Hnutie za demokratické Slovensko | Movement for a Democratic Slovakia | 4.8914 | 1 | 124 | 218 | 547 | 1142 |
SVK | Slovakia | ep | 2004-06-13 | 16.19 | 3 | 14 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 124 | 218 | 547 | 1432 |
SVK | Slovakia | ep | 2004-06-13 | 17.09 | 3 | 14 | SDKU-DS | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovak Democratic and Christian Union -- Democratic Party | 7.3591 | 1 | 124 | 218 | 547 | 131 |
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 |
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 |
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 |
SVK | Slovakia | ep | 2004-06-13 | 3.25 | 0 | 14 | SF | Slobodné fórum | Free Forum | 5.46 | 1 | 124 | 218 | 547 | 752 |
SVK | Slovakia | ep | 2004-06-13 | 2.01 | 0 | 14 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 124 | 218 | 547 | 1072 |
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 |
SVK | Slovakia | ep | 2004-06-13 | 1.69 | 0 | 14 | Lu+Ls | Ludová únia – Liberálna strana | People's Union -- Liberal Party | 7.3684 | 1 | 124 | 218 | 547 | 1615 |
SVN | Slovenia | ep | 2004-06-13 | 23.57 | 2 | 7 | NSI | Nova Slovenija – Krščanska ljudska stranka | New Slovenia -- Christian People's Party | 7.9345 | 60 | 659 | 525 | 292 | 1047 |
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 |
SVN | Slovenia | ep | 2004-06-13 | 17.65 | 2 | 7 | SDS | Slovenska demokratska stranka | Slovenian Democratic Party | 6.9996 | 60 | 659 | 525 | 292 | 179 |
SVN | Slovenia | ep | 2004-06-13 | 14.15 | 1 | 7 | ZL-SD | Združena lista – Socialni demokrati | United List -- Social Democrats | 3.0637 | 60 | 659 | 525 | 292 | 706 |
SVN | Slovenia | ep | 2004-06-13 | 8.41 | 0 | 7 | SLS | Slovenska ljudska stranka | Slovenian People's Party | 6.6953 | 60 | 659 | 525 | 292 | 16 |
SVN | Slovenia | ep | 2004-06-13 | 5.02 | 0 | 7 | SNS | Slovenska nacionalna stranka | Slovenian National Party | 4.7941 | 60 | 659 | 525 | 292 | 981 |
SVN | Slovenia | ep | 2004-06-13 | 4.11 | 0 | 7 | SO | Slovenija je naša | Slovenia is Ours | 60 | 659 | 525 | 292 | 2019 | |
SVN | Slovenia | ep | 2004-06-13 | 2.3 | 0 | 7 | SMS | Stranka mladih Slovenije | Youth Party of Slovenia | 4.2263 | 60 | 659 | 525 | 292 | 1512 |
SVN | Slovenia | ep | 2004-06-13 | 1.2 | 0 | 7 | GZS | Glas žensk Slovenije | Voice of Slovenian women | 60 | 659 | 525 | 292 | 2022 | |
SWE | Sweden | ep | 2004-06-13 | 24.56 | 5 | 19 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 104 | 156 | 641 | 904 |
SWE | Sweden | ep | 2004-06-13 | 18.25 | 4 | 19 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 104 | 156 | 641 | 657 |
SWE | Sweden | ep | 2004-06-13 | 14.47 | 3 | 19 | Jl | Junilistan | June List | 5.67 | 35 | 104 | 156 | 641 | 404 |
SWE | Sweden | ep | 2004-06-13 | 12.79 | 2 | 19 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 104 | 156 | 641 | 882 |
SWE | Sweden | ep | 2004-06-13 | 9.86 | 2 | 19 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 104 | 156 | 641 | 892 |
SWE | Sweden | ep | 2004-06-13 | 5.96 | 1 | 19 | MP | Miljöpartiet de Gröna | Greens | 3.3789 | 35 | 104 | 156 | 641 | 1154 |
SWE | Sweden | ep | 2004-06-13 | 5.68 | 1 | 19 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 104 | 156 | 641 | 282 |
SWE | Sweden | ep | 2004-06-13 | 6.26 | 1 | 19 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 104 | 156 | 641 | 1461 |
SWE | Sweden | ep | 2004-06-13 | 1.13 | 0 | 19 | SD | Sverigedemokraterna | Sweden Democrats | 8.8 | 35 | 104 | 156 | 641 | 1546 |
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;