view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
36 rows where "election_date" is on date 1996-10-20 sorted by party_name_english
This data as json, CSV (advanced)
Suggested facets: country_name_short, country_name, seats, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
LTU | Lithuania | parliament | 1996-10-20 | 2.55 | 0 | 141 | LTMA | Lietuvos tautinių mažumų aljansas | Alliance of the Lithuanian National Minorities | 15 | 566 | 439 | 91 | 2036 | |
FIN | Finland | ep | 1996-10-20 | 2.1 | 0 | 16 | VEU | Vaihtoehto EU:Lle | Anti-EU Movement | 67 | 652 | 24 | 100 | 1649 | |
FIN | Finland | ep | 1996-10-20 | 24.4 | 4 | 16 | KESK | Keskusta | Centre Party | 5.8027 | 67 | 652 | 24 | 100 | 94 |
LTU | Lithuania | parliament | 1996-10-20 | 8.67 | 13 | 141 | LCS | Lietuvos centro sąjunga | Centre Union of Lithuania | 4.8833 | 15 | 566 | 439 | 91 | 887 |
LTU | Lithuania | parliament | 1996-10-20 | 3.24 | 1 | 141 | KDS | Krikščionių demokratų sąjunga | Christian Democratic Union | 6.2 | 15 | 566 | 439 | 91 | 493 |
FIN | Finland | ep | 1996-10-20 | 2.8 | 0 | 16 | KD | Kristillisdemokraatit – Kristdemokraterna | Christian Democrats | 7.1884 | 67 | 652 | 24 | 100 | 1463 |
LTU | Lithuania | parliament | 1996-10-20 | 10.01 | 12 | 141 | LDDP | Lietuvos demokratinė darbo partija | Democratic Labour Party of Lithuania | 3.3333 | 15 | 566 | 439 | 91 | 519 |
JPN | Japan | parliament | 1996-10-20 | 16.1 | 52 | 500 | DPJ | Minshutō | Democratic Party of Japan | 5.5717 | 5 | 628 | 57 | 800 | 439 |
JPN | Japan | parliament | 1996-10-20 | 0.03 | 1 | 500 | DRP | Min-kai-ren | Democratic Reform Party | 3.3 | 5 | 628 | 57 | 800 | 163 |
FIN | Finland | ep | 1996-10-20 | 10.5 | 2 | 16 | DL|VAS | Demokraattinen Liitto – Demokratiska Förbundet | Vasemmistoliitto – Vänsterförbundet | Democratic Union | Left Alliance | 2.1843 | 67 | 652 | 24 | 100 | 1292 |
LTU | Lithuania | parliament | 1996-10-20 | 3.13 | 1 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 566 | 439 | 91 | 28 |
FIN | Finland | ep | 1996-10-20 | 7.6 | 1 | 16 | VIHR | Vihreä Liitto – Gröna Förbundet | Green League | 3.6465 | 67 | 652 | 24 | 100 | 1062 |
LTU | Lithuania | parliament | 1996-10-20 | 31.34 | 70 | 141 | TS-LK | Tėvynės sąjunga | Homeland Union | 7.4004 | 15 | 566 | 439 | 91 | 1045 |
JPN | Japan | parliament | 1996-10-20 | 13.08 | 26 | 500 | JCP | Nihon Kyōsan-tō | Japan Communist Party | 1.148 | 5 | 628 | 57 | 800 | 1540 |
JPN | Japan | parliament | 1996-10-20 | 6.38 | 15 | 500 | JSP | Nihon Shakai-tō | Japan Socialist Party | 2.6344 | 5 | 628 | 57 | 800 | 940 |
JPN | Japan | parliament | 1996-10-20 | 32.76 | 239 | 500 | LDP | Jiyū Minshutō | Liberal Democratic Party | 8.0252 | 5 | 628 | 57 | 800 | 1193 |
LTU | Lithuania | parliament | 1996-10-20 | 1.93 | 1 | 141 | LiCS | Liberalų ir centro sąjunga | Liberal and Centre Union | 7.7562 | 15 | 566 | 439 | 91 | 983 |
LTU | Lithuania | parliament | 1996-10-20 | 10.43 | 16 | 141 | LKDP | Lietuvos krikščionys demokratai | Lithuanian Christian Democrats | 6.2385 | 15 | 566 | 439 | 91 | 675 |
LTU | Lithuania | parliament | 1996-10-20 | 2.2 | 3 | 141 | LDP | Lietuvos demokratų partija | Lithuanian Democratic Party | 5.8333 | 15 | 566 | 439 | 91 | 1144 |
LTU | Lithuania | parliament | 1996-10-20 | 1.57 | 0 | 141 | LLaS | Lietuvos laisvės sąjunga | Lithuanian Liberty Union | 7.8 | 15 | 566 | 439 | 91 | 1562 |
LTU | Lithuania | parliament | 1996-10-20 | 1.26 | 0 | 141 | LUP | Lietuvos ūkio partijos | Lithuanian Party of Economy | 15 | 566 | 439 | 91 | 2037 | |
LTU | Lithuania | parliament | 1996-10-20 | 1.75 | 1 | 141 | LVP | Lietuvos valstiečių partija | Lithuanian Peasant Party | 2.645 | 15 | 566 | 439 | 91 | 1632 |
LTU | Lithuania | parliament | 1996-10-20 | 1.71 | 0 | 141 | LRS | Lietuvos rusų sąjunga | Lithuanian Russian Union | 2.2 | 15 | 566 | 439 | 91 | 863 |
LTU | Lithuania | parliament | 1996-10-20 | 6.94 | 12 | 141 | LSDP-89 | Lietuvos socialdemokratų partija – 1989 | Lithuanian Social Democratic Party -- 1989 | 4.0 | 15 | 566 | 439 | 91 | 1408 |
LTU | Lithuania | parliament | 1996-10-20 | 3.86 | 1 | 141 | LMP-NDP | Lietuvos moterų partija – Naujosios demokratijos partija | Lithuanian Womens Party -- New Democratic Party | 3.2 | 15 | 566 | 439 | 91 | 1261 |
FIN | Finland | ep | 1996-10-20 | 20.2 | 4 | 16 | KOK | Kansallinen Kokoomus – Samlingspartiet | National Coalition Party | 7.2451 | 67 | 652 | 24 | 100 | 1118 |
JPN | Japan | parliament | 1996-10-20 | 28.04 | 156 | 500 | NFP | Shinshin-to | New Frontier Party | 8.2556 | 5 | 628 | 57 | 800 | 1136 |
JPN | Japan | parliament | 1996-10-20 | 1.1 | 2 | 500 | NPS | Shinto Sakigake | New Party Sakigake | 7.4 | 5 | 628 | 57 | 800 | 1146 |
FIN | Finland | ep | 1996-10-20 | 21.5 | 4 | 16 | SSDP | Suomen Sosialidemokraattinen Puolue – Finlands Socialdemokratiska Parti | Social Democratic Party of Finland | 3.5595 | 67 | 652 | 24 | 100 | 395 |
FIN | Finland | ep | 1996-10-20 | 5.8 | 1 | 16 | RKP-SFP | Ruotsalainen Kansanpuolue – Svenska Folkepartiet i Finland | Swedish People's Party | 6.3906 | 67 | 652 | 24 | 100 | 585 |
LTU | Lithuania | parliament | 1996-10-20 | 1.57 | 1 | 141 | LPKTS | Lietuvos politinių kalinių ir terminių sąjunga | Union of Lithuanian Political Prisoners and Deportees | 9.8 | 15 | 566 | 439 | 91 | 1447 |
FIN | Finland | ep | 1996-10-20 | 3.0 | 0 | 16 | NSP | Nuorsuomalaiset – Ungfinnarna | Young Finns | 6.0 | 67 | 652 | 24 | 100 | 1009 |
LTU | Lithuania | parliament | 1996-10-20 | 4.01 | 1 | 141 | JL | Jaunoji Lietuva | Young Lithuania | 9.8 | 15 | 566 | 439 | 91 | 383 |
JPN | Japan | parliament | 1996-10-20 | 9 | 500 | none | no party affiliation | no party affiliation | 5 | 628 | 57 | 800 | 905 | ||
LTU | Lithuania | parliament | 1996-10-20 | 4 | 141 | none | no party affiliation | no party affiliation | 15 | 566 | 439 | 91 | 58 | ||
LTU | Lithuania | parliament | 1996-10-20 | 4 | 141 | etc | others | others | 15 | 566 | 439 | 91 | 2802 |
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;