view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
217 rows where "election_date" is on date 2009-06-07
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GRC | Greece | ep | 2009-06-07 | 1.26 | 0 | 22 | KEK | Kómma Ellênòn Kynègôn | Party of Greek Hunters | 7.4 | 41 | 264 | 466 | 581 | 2167 |
GRC | Greece | ep | 2009-06-07 | 1.27 | 0 | 22 | PMM | Panellήnio Makedonikό Metwpo | Panhellenic Macedonian Front | 41 | 264 | 466 | 581 | 2169 | |
HUN | Hungary | ep | 2009-06-07 | 13 | 22 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 249 | 194 | 162 | 921 | |
HUN | Hungary | ep | 2009-06-07 | 17.37 | 4 | 22 | MSZP | Magyar Szocialista Párt | Hungarian Socialist Party | 2.8743 | 39 | 249 | 194 | 162 | 1591 |
HUN | Hungary | ep | 2009-06-07 | 14.77 | 3 | 22 | Jobbik | Jobbik Magyarországért Mozgalom | Jobbik Movement for a Better Hungary | 8.8 | 39 | 249 | 194 | 162 | 600 |
HUN | Hungary | ep | 2009-06-07 | 5.31 | 1 | 22 | MDF | Magyar Demokrata Fórum | Hungarian Democratic Forum | 6.4826 | 39 | 249 | 194 | 162 | 546 |
HUN | Hungary | ep | 2009-06-07 | 1 | 22 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 249 | 194 | 162 | 434 | |
HUN | Hungary | ep | 2009-06-07 | 2.16 | 0 | 22 | SzDSz | Szabad Demokraták Szövetsége | Alliance of Free Democrats | 3.9659 | 39 | 249 | 194 | 162 | 1426 |
HUN | Hungary | ep | 2009-06-07 | 56.36 | 22 | Fi+KDNP | Fidesz – Magyar Polgári Szövetség / Kereszténydemokrata Néppárt | Fidesz -- Hungarian Civic Party / Christian Democratic People's Party | 6.5432 | 39 | 249 | 194 | 162 | 437 | |
ITA | Italy | ep | 2009-06-07 | 35.26 | 29 | 72 | FI-PdL | Forza Italia – Il Popolo della Libertà | Go Italy -- The People of Freedom | 7.1459 | 26 | 549 | 111 | 823 | 596 |
ITA | Italy | ep | 2009-06-07 | 26.12 | 21 | 72 | PD | Partito Democratico | Democratic Party | 2.6216 | 26 | 549 | 111 | 823 | 382 |
ITA | Italy | ep | 2009-06-07 | 10.21 | 9 | 72 | LN | Lega Nord | North League | 7.8007 | 26 | 549 | 111 | 823 | 1436 |
ITA | Italy | ep | 2009-06-07 | 8.0 | 7 | 72 | IdV | Italia dei Valori | Italy of Values | 4.8712 | 26 | 549 | 111 | 823 | 693 |
ITA | Italy | ep | 2009-06-07 | 6.51 | 5 | 72 | UC | Unione / Centro | Union / Centre | 6.1092 | 26 | 549 | 111 | 823 | 226 |
ITA | Italy | ep | 2009-06-07 | 0.46 | 1 | 72 | SVP | Südtiroler Volkspartei | South Tyrol Peoples Party | 5.4 | 26 | 549 | 111 | 823 | 1030 |
ITA | Italy | ep | 2009-06-07 | 2.22 | 0 | 72 | MpA | Movimento per l'Autonomia | Movement for Autonomy | 6.2 | 26 | 549 | 111 | 823 | 1040 |
ITA | Italy | ep | 2009-06-07 | 3.39 | 0 | 72 | PRC | Partito della Rifondazione Comunista | Communist Refoundation Party | 0.8849 | 26 | 549 | 111 | 823 | 1321 |
ITA | Italy | ep | 2009-06-07 | 2.43 | 0 | 72 | R | Radicali | Radicals | 3.9732 | 26 | 549 | 111 | 823 | 1296 |
ITA | Italy | ep | 2009-06-07 | 3.13 | 0 | 72 | S | Sinistra | Left | 1.3 | 26 | 549 | 111 | 823 | 465 |
LTU | Lithuania | ep | 2009-06-07 | 26.86 | 4 | 12 | TS-LK | Tėvynės sąjunga | Homeland Union | 7.4004 | 15 | 337 | 646 | 688 | 1045 |
LTU | Lithuania | ep | 2009-06-07 | 18.61 | 3 | 12 | LSDP | Lietuvos socialdemokratų partija | Lithuanian Social Democratic Party | 3.1972 | 15 | 337 | 646 | 688 | 1277 |
LTU | Lithuania | ep | 2009-06-07 | 12.22 | 2 | 12 | TT-LDP | Tvarka ir teisingumas – Liberalų demokratų partija | Order and Justice -- Liberal Democratic Party | 5.2955 | 15 | 337 | 646 | 688 | 1421 |
LTU | Lithuania | ep | 2009-06-07 | 8.79 | 1 | 12 | DP | Darbo partija | Labour Party | 3.86 | 15 | 337 | 646 | 688 | 581 |
LTU | Lithuania | ep | 2009-06-07 | 8.42 | 1 | 12 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 337 | 646 | 688 | 28 |
LTU | Lithuania | ep | 2009-06-07 | 7.36 | 1 | 12 | LRLS | Lietuvos Respublikos liberalų sąjūdis | Liberals Movement of the Republic of Lithuania | 7.7562 | 15 | 337 | 646 | 688 | 482 |
LTU | Lithuania | ep | 2009-06-07 | 3.47 | 0 | 12 | LiCS | Liberalų ir centro sąjunga | Liberal and Centre Union | 7.7562 | 15 | 337 | 646 | 688 | 983 |
LTU | Lithuania | ep | 2009-06-07 | 1.87 | 0 | 12 | LVLS | Lietuvos valstiečių sąjunga | Lithuanian Peasant Union | 3.2687 | 15 | 337 | 646 | 688 | 191 |
LTU | Lithuania | ep | 2009-06-07 | 3.09 | 0 | 12 | LCS | Lietuvos centro sąjunga | Centre Union of Lithuania | 4.8833 | 15 | 337 | 646 | 688 | 887 |
LTU | Lithuania | ep | 2009-06-07 | 2.93 | 0 | 12 | KKSS | Krikščionių konservatorių socialinė sąjunga | Christian Conservative Social Union | 6.4579 | 15 | 337 | 646 | 688 | 709 |
LTU | Lithuania | ep | 2009-06-07 | 2.43 | 0 | 12 | SPF | Socialist People's Front | Socialist People's Front | 1.3 | 15 | 337 | 646 | 688 | 1056 |
LTU | Lithuania | ep | 2009-06-07 | 1.35 | 0 | 12 | PDP | Pilietinės demokratijos partija | Civic Democratic Party | 6.0 | 15 | 337 | 646 | 688 | 676 |
LTU | Lithuania | ep | 2009-06-07 | 1.04 | 0 | 12 | TPP | Tautos prisikėlimo partija | National Resurrection Party | 6.0 | 15 | 337 | 646 | 688 | 1502 |
LTU | Lithuania | ep | 2009-06-07 | 1.27 | 0 | 12 | Zp | Žemaičių partija | Samogitian Party | 15 | 337 | 646 | 688 | 2025 | |
LUX | Luxembourg | parliament | 2009-06-07 | 38.04 | 26 | 60 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 172 | 383 | 12 | 1234 |
LUX | Luxembourg | parliament | 2009-06-07 | 21.56 | 13 | 60 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 172 | 383 | 12 | 701 |
LUX | Luxembourg | parliament | 2009-06-07 | 14.98 | 9 | 60 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 172 | 383 | 12 | 967 |
LUX | Luxembourg | parliament | 2009-06-07 | 11.71 | 7 | 60 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 172 | 383 | 12 | 310 |
LUX | Luxembourg | parliament | 2009-06-07 | 8.13 | 4 | 60 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 172 | 383 | 12 | 1582 |
LUX | Luxembourg | ep | 2009-06-07 | 31.32 | 3 | 6 | CSV | Chrëschtlech Sozial Vollekspartei | Christian Social People's Party | 6.4474 | 7 | 662 | 383 | 12 | 1234 |
LUX | Luxembourg | ep | 2009-06-07 | 16.82 | 1 | 6 | Greng | Déi Gréng | The Greens | 2.5 | 7 | 662 | 383 | 12 | 310 |
LUX | Luxembourg | ep | 2009-06-07 | 18.65 | 1 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 662 | 383 | 12 | 967 |
LUX | Luxembourg | ep | 2009-06-07 | 19.49 | 1 | 6 | LSAP | Lëtzebuerger Sozialistesch Aarbechterpartei | Luxembourg Socialist Workers' Party | 3.2895 | 7 | 662 | 383 | 12 | 701 |
LUX | Luxembourg | parliament | 2009-06-07 | 3.29 | 1 | 60 | DL | Déi Lénk | The Left | 0.5263 | 7 | 172 | 383 | 12 | 457 |
LUX | Luxembourg | ep | 2009-06-07 | 1.54 | 0 | 6 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 662 | 383 | 12 | 151 |
LUX | Luxembourg | parliament | 2009-06-07 | 1.47 | 0 | 60 | KPL | Kommunistesch Partei Lëtzebuerg | Communist Party of Luxembourg | 1.3 | 7 | 172 | 383 | 12 | 151 |
LUX | Luxembourg | ep | 2009-06-07 | 7.38 | 0 | 6 | AR|ADR | Aktiounskomitee Rente | Alternativ Demokratesch Reformpartei | Action Committee Pensions | Alternative Democratic Reform Party | 8.8158 | 7 | 662 | 383 | 12 | 1582 |
LUX | Luxembourg | ep | 2009-06-07 | 3.41 | 0 | 6 | DL | Déi Lénk | The Left | 0.5263 | 7 | 662 | 383 | 12 | 457 |
LUX | Luxembourg | ep | 2009-06-07 | 1.38 | 0 | 6 | Bl | Biergerlëscht | Citizens' List | 7 | 662 | 383 | 12 | 1130 | |
LVA | Latvia | ep | 2009-06-07 | 19.57 | 2 | 8 | S | Saskaņas | Harmony | 3.0 | 55 | 302 | 52 | 477 | 1100 |
LVA | Latvia | ep | 2009-06-07 | 24.32 | 2 | 8 | PS | Pilsoniskā savienība | Civic Union | 7.4 | 55 | 302 | 52 | 477 | 445 |
LVA | Latvia | ep | 2009-06-07 | 7.45 | 1 | 8 | NA/TB/LNNK | Nacionālā apvienība / Tēvzemei un Brīvībai / LNNK | National Alliance / For Fatherland and Freedom / LNNK | 8.2588 | 55 | 302 | 52 | 477 | 521 |
LVA | Latvia | ep | 2009-06-07 | 9.66 | 1 | 8 | PCTVL | Par cilvēka tiesībām vienotā Latvijā | For Human Rights in a United Latvia | 1.25 | 55 | 302 | 52 | 477 | 1520 |
LVA | Latvia | ep | 2009-06-07 | 6.66 | 1 | 8 | JL | Jaunais Laiks | New Era | 7.3026 | 55 | 302 | 52 | 477 | 1518 |
LVA | Latvia | ep | 2009-06-07 | 7.49 | 1 | 8 | LPP/LC | Latvijas Pirmā partija / Latvijas Ceļš | Latvian First Party / Latvian Way Party | 7.4 | 55 | 302 | 52 | 477 | 662 |
LVA | Latvia | ep | 2009-06-07 | 3.85 | 0 | 8 | SCP | Sabiedrība citai politikai | Society for Other Politics | 6.0 | 55 | 302 | 52 | 477 | 962 |
LVA | Latvia | ep | 2009-06-07 | 2.78 | 0 | 8 | TP | Tautas Partija | People's Party | 7.7544 | 55 | 302 | 52 | 477 | 811 |
LVA | Latvia | ep | 2009-06-07 | 2.81 | 0 | 8 | VL | Visu Latvijai! | All For Latvia! | 7.4 | 55 | 302 | 52 | 477 | 801 |
LVA | Latvia | ep | 2009-06-07 | 3.79 | 0 | 8 | LSDSP | Latvijas Sociāldemokrātiskā Strādnieku Partija | Latvian Social Democratic Workers' Party | 2.5 | 55 | 302 | 52 | 477 | 1656 |
LVA | Latvia | ep | 2009-06-07 | 4.3 | 0 | 8 | Lib | Libertas.lv | Libertas.lv | 7.4 | 55 | 302 | 52 | 477 | 500 |
LVA | Latvia | ep | 2009-06-07 | 3.72 | 0 | 8 | ZZS | Zaļo un Zemnieku savienība | Green and Farmers' Union | 5.2632 | 55 | 302 | 52 | 477 | 466 |
POL | Poland | ep | 2009-06-07 | 44.43 | 25 | 50 | PO | Platforma Obywatelska | Civic Platform | 6.2355 | 74 | 255 | 560 | 164 | 512 |
POL | Poland | ep | 2009-06-07 | 27.4 | 15 | 50 | PiS | Prawo i Sprawiedliwość | Law and Justice | 7.6997 | 74 | 255 | 560 | 164 | 528 |
POL | Poland | ep | 2009-06-07 | 12.34 | 6 | 50 | SLD | Sojusz Lewicy Demokratycznej | Democratic Left Alliance | 2.8299 | 74 | 255 | 560 | 164 | 629 |
POL | Poland | ep | 2009-06-07 | 7.01 | 3 | 50 | PSL | Polskie Stronnictwo Ludowe | Polish People's Party | 4.1856 | 74 | 255 | 560 | 164 | 664 |
POL | Poland | ep | 2009-06-07 | 1 | 50 | UP | Unia Pracy | Labour Union | 2.0348 | 74 | 255 | 560 | 164 | 838 | |
POL | Poland | ep | 2009-06-07 | 1.46 | 0 | 50 | SRP | Samoobrona Rzeczypospolitej Polskiej | Self-Defense of the Republic Poland | 3.997 | 74 | 255 | 560 | 164 | 207 |
POL | Poland | ep | 2009-06-07 | 1.1 | 0 | 50 | UPR|KNP | Unia Polityki Realnej | Kongres Nowej Prawicy | Real Politics Union | Congress of the New Right | 9.7368 | 74 | 255 | 560 | 164 | 1549 |
POL | Poland | ep | 2009-06-07 | 1.14 | 0 | 50 | LP | Libertas Polska | Libertas Poland | 7.4 | 74 | 255 | 560 | 164 | 1671 |
POL | Poland | ep | 2009-06-07 | 1.95 | 0 | 50 | PrRz | Prawica Rzeczypospolitej | Republic Right Party | 7.4 | 74 | 255 | 560 | 164 | 1283 |
POL | Poland | ep | 2009-06-07 | 2.44 | 0 | 50 | D|W|U | Demokratyczna | Wolności | Unia | Democratic | Freedom | Union | 5.2295 | 74 | 255 | 560 | 164 | 1104 |
PRT | Portugal | ep | 2009-06-07 | 33.95 | 8 | 22 | PSD | Partido Social Democrata | Social Democratic Party | 6.2949 | 63 | 5 | 210 | 169 | 1273 |
PRT | Portugal | ep | 2009-06-07 | 28.41 | 7 | 22 | PS | Partido Socialista | Socialist Party | 4.0492 | 63 | 5 | 210 | 169 | 725 |
PRT | Portugal | ep | 2009-06-07 | 11.48 | 3 | 22 | BE | Bloco de Esquerda | Bloc of the Left | 1.6425 | 63 | 5 | 210 | 169 | 557 |
PRT | Portugal | ep | 2009-06-07 | 2 | 22 | PCP | Partido Comunista Português | Portuguese Communist Party | 2.1754 | 63 | 5 | 210 | 169 | 514 | |
PRT | Portugal | ep | 2009-06-07 | 8.95 | 2 | 22 | CDS-PP | Centro Democrático e Social – Partido Popular | Democratic and Social Centre -- People's Party | 8.0222 | 63 | 5 | 210 | 169 | 251 |
PRT | Portugal | ep | 2009-06-07 | 1.29 | 0 | 22 | 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 | 5 | 210 | 169 | 281 |
PRT | Portugal | ep | 2009-06-07 | 11.39 | 0 | 22 | CDU | Coligação Democrático Unitária | Unified Democratic Coalition | 2.2233 | 63 | 5 | 210 | 169 | 1295 |
PRT | Portugal | ep | 2009-06-07 | 1.65 | 0 | 22 | MEP | Movimento Esperança Portugal | Hope for Portugal Movement | 6.0 | 63 | 5 | 210 | 169 | 925 |
ROU | Romania | ep | 2009-06-07 | 31.07 | 10 | 33 | PSD | Partidul Social Democrat | Social Democratic Party | 3.2325 | 23 | 229 | 319 | 599 | 1120 |
ROU | Romania | ep | 2009-06-07 | 29.71 | 10 | 33 | PD-L | Partidul Democrat-Liberal | Democratic Liberal Party | 5.3875 | 23 | 229 | 319 | 599 | 958 |
ROU | Romania | ep | 2009-06-07 | 14.52 | 5 | 33 | PNL | Partidul Naţional Liberal | National Liberal Party | 6.0543 | 23 | 229 | 319 | 599 | 1015 |
ROU | Romania | ep | 2009-06-07 | 8.92 | 3 | 33 | UDMR | Uniunea Democrată Maghiară din România | Democratic Union of Hungarians in Romania | 6.016 | 23 | 229 | 319 | 599 | 948 |
ROU | Romania | ep | 2009-06-07 | 8.65 | 3 | 33 | PRM | Partidul România Mare | Greater Romania Party | 6.6618 | 23 | 229 | 319 | 599 | 713 |
ROU | Romania | ep | 2009-06-07 | 4.22 | 1 | 33 | none | no party affiliation | no party affiliation | 23 | 229 | 319 | 599 | 761 | |
ROU | Romania | ep | 2009-06-07 | 1 | 33 | PU|PC | Partidul Umanist | Partidul Conservator | Humanist Party | Conservative Party | 4.7622 | 23 | 229 | 319 | 599 | 5 | |
ROU | Romania | ep | 2009-06-07 | 1.45 | 0 | 33 | PNT-CD | Partidul Naţional Ţărănesc Creştin Democrat | Christian-Democratic National Peasants' Party | 5.5341 | 23 | 229 | 319 | 599 | 888 |
SVK | Slovakia | ep | 2009-06-07 | 32.01 | 5 | 13 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 441 | 192 | 269 | 220 |
SVK | Slovakia | ep | 2009-06-07 | 16.98 | 2 | 13 | SDKU-DS | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovak Democratic and Christian Union -- Democratic Party | 7.3591 | 1 | 441 | 192 | 269 | 131 |
SVK | Slovakia | ep | 2009-06-07 | 11.33 | 2 | 13 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 441 | 192 | 269 | 559 |
SVK | Slovakia | ep | 2009-06-07 | 10.87 | 2 | 13 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 441 | 192 | 269 | 1432 |
SVK | Slovakia | ep | 2009-06-07 | 8.97 | 1 | 13 | HZDS | Hnutie za demokratické Slovensko | Movement for a Democratic Slovakia | 4.8914 | 1 | 441 | 192 | 269 | 1142 |
SVK | Slovakia | ep | 2009-06-07 | 5.55 | 1 | 13 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 441 | 192 | 269 | 1072 |
SVK | Slovakia | ep | 2009-06-07 | 4.71 | 0 | 13 | SaS | Sloboda a solidarita | Freedom and Solidarity | 6.0 | 1 | 441 | 192 | 269 | 1460 |
SVK | Slovakia | ep | 2009-06-07 | 2.11 | 0 | 13 | SZS | Strana zelených | Green Party | 2.5 | 1 | 441 | 192 | 269 | 874 |
SVK | Slovakia | ep | 2009-06-07 | 2.1 | 0 | 13 | OKS | Obcianska konzervatívna strana | Civic Conservative Party | 8.4211 | 1 | 441 | 192 | 269 | 1645 |
SVK | Slovakia | ep | 2009-06-07 | 1.65 | 0 | 13 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 441 | 192 | 269 | 44 |
SVK | Slovakia | ep | 2009-06-07 | 1.57 | 0 | 13 | SF | Slobodné fórum | Free Forum | 5.46 | 1 | 441 | 192 | 269 | 752 |
SVN | Slovenia | ep | 2009-06-07 | 26.66 | 2 | 7 | SDS | Slovenska demokratska stranka | Slovenian Democratic Party | 6.9996 | 60 | 195 | 522 | 803 | 179 |
SVN | Slovenia | ep | 2009-06-07 | 18.43 | 2 | 7 | ZL-SD | Združena lista – Socialni demokrati | United List -- Social Democrats | 3.0637 | 60 | 195 | 522 | 803 | 706 |
SVN | Slovenia | ep | 2009-06-07 | 9.76 | 1 | 7 | Zares | Zares | For Real | 3.3 | 60 | 195 | 522 | 803 | 326 |
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;