view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
217 rows where "election_date" is on date 2009-06-07 sorted by party_name_english
This data as json, CSV (advanced)
Suggested facets: country_name_short, election_type, seats_total, country_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | 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 |
BEL | Belgium | ep | 2009-06-07 | 4.9 | 1 | 22 | AGL-Gr | Agalev – Groen | Agalev -- Green | 2.5762 | 64 | 638 | 401 | 80 | 1594 |
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 |
LVA | Latvia | ep | 2009-06-07 | 2.81 | 0 | 8 | VL | Visu Latvijai! | All For Latvia! | 7.4 | 55 | 302 | 52 | 477 | 801 |
DEU | Germany | ep | 2009-06-07 | 12.1 | 14 | 99 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 231 | 118 | 85 | 772 |
AUT | Austria | ep | 2009-06-07 | 4.6 | 0 | 17 | BZO | Bündnis Zukunft Österreich | Alliance for the Future of Austria | 8.83 | 59 | 232 | 607 | 268 | 1536 |
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 |
FRA | France | ep | 2009-06-07 | 0.46 | 1 | 72 | AO | Alliances des outre-mers | Alliance of the Overseas | 1.3 | 43 | 219 | 171 | 306 | 2400 |
DEU | Germany | ep | 2009-06-07 | 1.1 | 0 | 99 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 231 | 118 | 85 | 301 | |
BGR | Bulgaria | ep | 2009-06-07 | 11.96 | 2 | 17 | Ataka | Ataka | Attack | 5.46 | 10 | 432 | 618 | 425 | 535 |
AUT | Austria | ep | 2009-06-07 | 30.0 | 6 | 17 | OVP | Österreichische Volkspartei | Austrian People's Party | 6.4733 | 59 | 232 | 607 | 268 | 1013 |
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 |
BGR | Bulgaria | ep | 2009-06-07 | 7.95 | 1 | 17 | SK | Sinyata Koalitsiya | Blue Coalition | 7.4 | 10 | 432 | 618 | 425 | 1254 |
FIN | Finland | ep | 2009-06-07 | 19.0 | 3 | 13 | KESK | Keskusta | Centre Party | 5.8027 | 67 | 181 | 314 | 277 | 94 |
SWE | Sweden | ep | 2009-06-07 | 5.47 | 1 | 18 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 304 | 629 | 475 | 1461 |
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 |
SVK | Slovakia | ep | 2009-06-07 | 10.87 | 2 | 13 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 441 | 192 | 269 | 1432 |
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 | |
DEU | Germany | ep | 2009-06-07 | 30.7 | 34 | 99 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 231 | 118 | 85 | 808 |
CZE | Czech Republic | ep | 2009-06-07 | 7.64 | 2 | 22 | KDU-CSL | Křesťanská a demokratická unie – Československá strana lidová | Christian Democratic Union -- People's Party | 5.8099 | 68 | 516 | 50 | 157 | 1245 |
FIN | Finland | ep | 2009-06-07 | 4.2 | 1 | 13 | KD | Kristillisdemokraatit – Kristdemokraterna | Christian Democrats | 7.1884 | 67 | 181 | 314 | 277 | 1463 |
SWE | Sweden | ep | 2009-06-07 | 4.68 | 1 | 18 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 304 | 629 | 475 | 282 |
BEL | Belgium | ep | 2009-06-07 | 0.19 | 1 | 22 | CSP | Christlich Soziale Partei | Christian Social Party | 6.2 | 64 | 638 | 401 | 80 | 119 |
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 | 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 |
DEU | Germany | ep | 2009-06-07 | 7.2 | 8 | 99 | CSU | Christlich Soziale Union | Christian Social Union | 7.2871 | 54 | 231 | 118 | 85 | 1180 |
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 |
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 |
LUX | Luxembourg | ep | 2009-06-07 | 1.38 | 0 | 6 | Bl | Biergerlëscht | Citizens' List | 7 | 662 | 383 | 12 | 1130 | |
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 |
CZE | Czech Republic | ep | 2009-06-07 | 31.45 | 9 | 22 | ODS | Občanská demokratická strana | Civic Democratic Party | 7.3637 | 68 | 516 | 50 | 157 | 829 |
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 |
POL | Poland | ep | 2009-06-07 | 44.43 | 25 | 50 | PO | Platforma Obywatelska | Civic Platform | 6.2355 | 74 | 255 | 560 | 164 | 512 |
LVA | Latvia | ep | 2009-06-07 | 24.32 | 2 | 8 | PS | Pilsoniskā savienība | Civic Union | 7.4 | 55 | 302 | 52 | 477 | 445 |
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 |
GRC | Greece | ep | 2009-06-07 | 4.7 | 1 | 22 | SYRIZA | Synaspismós Rizospastikís Aristerás | Coalition of the Radical Left | 2.8947 | 41 | 264 | 466 | 581 | 1592 |
CZE | Czech Republic | ep | 2009-06-07 | 14.18 | 4 | 22 | KSCM | Komunistická strana Cech a Moravy | Communist Party of Bohemia and Moravia | 0.7498 | 68 | 516 | 50 | 157 | 1173 |
GRC | Greece | ep | 2009-06-07 | 8.35 | 2 | 22 | KKE | Kommounistikó Kómma Elládas | Communist Party of Greece | 1.253 | 41 | 264 | 466 | 581 | 614 |
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 |
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 |
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 |
ESP | Spain | ep | 2009-06-07 | 3.71 | 2 | 50 | PCE|IU | Partido Communista | Izquierda Unida | Communist Party | United Left | 2.0183 | 27 | 448 | 500 | 497 | 118 |
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 |
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 |
DNK | Denmark | ep | 2009-06-07 | 12.68 | 1 | 13 | KF | Konservative | Conservatives | 7.2186 | 21 | 309 | 174 | 71 | 590 |
CZE | Czech Republic | ep | 2009-06-07 | 22.38 | 7 | 22 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 516 | 50 | 157 | 789 |
DNK | Denmark | ep | 2009-06-07 | 15.28 | 2 | 13 | DF | Dansk Folkeparti | Danish Peoples Party | 8.2269 | 21 | 309 | 174 | 71 | 1418 |
DNK | Denmark | ep | 2009-06-07 | 4.3 | 0 | 13 | RV | Det Radikale Venstre | Danish Social Liberal Party | 4.8736 | 21 | 309 | 174 | 71 | 211 |
POL | Poland | ep | 2009-06-07 | 12.34 | 6 | 50 | SLD | Sojusz Lewicy Demokratycznej | Democratic Left Alliance | 2.8299 | 74 | 255 | 560 | 164 | 629 |
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 |
ITA | Italy | ep | 2009-06-07 | 26.12 | 21 | 72 | PD | Partito Democratico | Democratic Party | 2.6216 | 26 | 549 | 111 | 823 | 382 |
LUX | Luxembourg | parliament | 2009-06-07 | 14.98 | 9 | 60 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 172 | 383 | 12 | 967 |
LUX | Luxembourg | ep | 2009-06-07 | 18.65 | 1 | 6 | DP | Demokratesch Partei | Democratic Party | 6.5789 | 7 | 662 | 383 | 12 | 967 |
SVN | Slovenia | ep | 2009-06-07 | 7.18 | 0 | 7 | DeSUS | Demokratična stranka upokojencev Slovenije | Democratic Party of Pensioners of Slovenia | 3.2292 | 60 | 195 | 522 | 803 | 1587 |
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 |
FIN | Finland | ep | 2009-06-07 | 5.9 | 0 | 13 | DL|VAS | Demokraattinen Liitto – Demokratiska Förbundet | Vasemmistoliitto – Vänsterförbundet | Democratic Union | Left Alliance | 2.1843 | 67 | 181 | 314 | 277 | 1292 |
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 |
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 |
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 |
GRC | Greece | ep | 2009-06-07 | 3.49 | 1 | 22 | OP | Oikologoi Prasinoi | Ecologist Greens | 2.5 | 41 | 264 | 466 | 581 | 1280 |
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 |
EST | Estonia | ep | 2009-06-07 | 26.1 | 2 | 6 | EK | Eesti Keskerakond | Estonian Centre Party | 3.9562 | 75 | 395 | 83 | 902 | 1137 |
EST | Estonia | ep | 2009-06-07 | 2.7 | 6 | EER | Erakond Eestimaa Rohelised | Estonian Greens | 2.5 | 75 | 395 | 83 | 902 | 219 | |
EST | Estonia | ep | 2009-06-07 | 15.3 | 1 | 6 | ERe | Eesti Reformierakond | Estonian Reform Party | 7.8969 | 75 | 395 | 83 | 902 | 113 |
ESP | Spain | ep | 2009-06-07 | 2.49 | 1 | 50 | EP-V | Europa de los Pueblos – Verdes | Europe of the People -- The Greens | 2.5 | 27 | 448 | 500 | 497 | 1657 |
CZE | Czech Republic | ep | 2009-06-07 | 2.88 | 0 | 22 | EDS | Evropská demokratická strana | European Democratic Party | 6.0 | 68 | 516 | 50 | 157 | 1454 |
DEU | Germany | ep | 2009-06-07 | 1.0 | 0 | 99 | Fam | Familien-Partei Deutschlands | Family Party of Germany | 7.4 | 54 | 231 | 118 | 85 | 1235 |
SWE | Sweden | ep | 2009-06-07 | 2.22 | 0 | 18 | Fi | Feministiskt initiativ | Feminist Initiative | 35 | 304 | 629 | 475 | 1521 | |
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 | |
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 | |
FIN | Finland | ep | 2009-06-07 | 9.8 | 1 | 13 | SP|P | Suomen Puolue | Perussuomalaiset | Finnish Party | True Finns | 6.6331 | 67 | 181 | 314 | 277 | 200 |
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 | 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 |
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 |
SVN | Slovenia | ep | 2009-06-07 | 9.76 | 1 | 7 | Zares | Zares | For Real | 3.3 | 60 | 195 | 522 | 803 | 326 |
ESP | Spain | ep | 2009-06-07 | 5.1 | 2 | 50 | CEP | Coalición por la Europa de los Pueblos | For the Europe of the Peoples | 27 | 448 | 500 | 497 | 771 | |
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 |
DEU | Germany | ep | 2009-06-07 | 11.0 | 12 | 99 | FDP | Freie Demokratische Partei | Free Democratic Party | 5.9233 | 54 | 231 | 118 | 85 | 543 |
SVK | Slovakia | ep | 2009-06-07 | 1.57 | 0 | 13 | SF | Slobodné fórum | Free Forum | 5.46 | 1 | 441 | 192 | 269 | 752 |
DEU | Germany | ep | 2009-06-07 | 1.7 | 0 | 99 | FW | Freie Wähler | Free Voters | 7.4 | 54 | 231 | 118 | 85 | 41 |
AUT | Austria | ep | 2009-06-07 | 12.7 | 2 | 17 | FPO | Freiheitliche Partei Österreichs | Freedom Party of Austria | 8.3494 | 59 | 232 | 607 | 268 | 50 |
SVK | Slovakia | ep | 2009-06-07 | 4.71 | 0 | 13 | SaS | Sloboda a solidarita | Freedom and Solidarity | 6.0 | 1 | 441 | 192 | 269 | 1460 |
FRA | France | ep | 2009-06-07 | 6.05 | 4 | 72 | PCF | Parti communiste française | French Communist Party | 1.3741 | 43 | 219 | 171 | 306 | 686 |
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 |
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 |
FIN | Finland | ep | 2009-06-07 | 12.4 | 2 | 13 | VIHR | Vihreä Liitto – Gröna Förbundet | Green League | 3.6465 | 67 | 181 | 314 | 277 | 1062 |
CZE | Czech Republic | ep | 2009-06-07 | 2.06 | 0 | 22 | SZ | Strana zelených | Green Party | 4.123 | 68 | 516 | 50 | 157 | 196 |
SVK | Slovakia | ep | 2009-06-07 | 2.11 | 0 | 13 | SZS | Strana zelených | Green Party | 2.5 | 1 | 441 | 192 | 269 | 874 |
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 |
FRA | France | ep | 2009-06-07 | 16.28 | 14 | 72 | V | Les Verts | Greens | 3.155 | 43 | 219 | 171 | 306 | 873 |
SWE | Sweden | ep | 2009-06-07 | 11.02 | 2 | 18 | MP | Miljöpartiet de Gröna | Greens | 3.3789 | 35 | 304 | 629 | 475 | 1154 |
AUT | Austria | ep | 2009-06-07 | 17.7 | 3 | 17 | Martin | Liste Dr. Hans-Peter Martin | Hans-Peter Martin's List | 4.2 | 59 | 232 | 607 | 268 | 669 |
LVA | Latvia | ep | 2009-06-07 | 19.57 | 2 | 8 | S | Saskaņas | Harmony | 3.0 | 55 | 302 | 52 | 477 | 1100 |
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 |
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 | 1 | 33 | PU|PC | Partidul Umanist | Partidul Conservator | Humanist Party | Conservative Party | 4.7622 | 23 | 229 | 319 | 599 | 5 | |
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 |
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;