view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
14 rows where "election_date" is on date 2008-10-12
This data as json, CSV (advanced)
Suggested facets: seats, left_right, election_date (date)
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 | 2008-10-12 | 19.72 | 45 | 141 | TS-LK | Tėvynės sąjunga | Homeland Union | 7.4004 | 15 | 646 | 214 | 579 | 1045 |
LTU | Lithuania | parliament | 2008-10-12 | 11.72 | 25 | 141 | LSDP | Lietuvos socialdemokratų partija | Lithuanian Social Democratic Party | 3.1972 | 15 | 646 | 214 | 579 | 1277 |
LTU | Lithuania | parliament | 2008-10-12 | 15.09 | 16 | 141 | TPP | Tautos prisikėlimo partija | National Resurrection Party | 6.0 | 15 | 646 | 214 | 579 | 1502 |
LTU | Lithuania | parliament | 2008-10-12 | 12.68 | 15 | 141 | TT-LDP | Tvarka ir teisingumas – Liberalų demokratų partija | Order and Justice -- Liberal Democratic Party | 5.2955 | 15 | 646 | 214 | 579 | 1421 |
LTU | Lithuania | parliament | 2008-10-12 | 5.73 | 11 | 141 | LRLS | Lietuvos Respublikos liberalų sąjūdis | Liberals Movement of the Republic of Lithuania | 7.7562 | 15 | 646 | 214 | 579 | 482 |
LTU | Lithuania | parliament | 2008-10-12 | 8.99 | 10 | 141 | DP | Darbo partija | Labour Party | 3.86 | 15 | 646 | 214 | 579 | 581 |
LTU | Lithuania | parliament | 2008-10-12 | 5.34 | 8 | 141 | LiCS | Liberalų ir centro sąjunga | Liberal and Centre Union | 7.7562 | 15 | 646 | 214 | 579 | 983 |
LTU | Lithuania | parliament | 2008-10-12 | 4 | 141 | none | no party affiliation | no party affiliation | 15 | 646 | 214 | 579 | 58 | ||
LTU | Lithuania | parliament | 2008-10-12 | 4.79 | 3 | 141 | LLRA | Lietuvos lenkų rinkimų akcija | Election Action of Lithuania's Poles | 3.865 | 15 | 646 | 214 | 579 | 28 |
LTU | Lithuania | parliament | 2008-10-12 | 3.73 | 3 | 141 | LVLS | Lietuvos valstiečių sąjunga | Lithuanian Peasant Union | 3.2687 | 15 | 646 | 214 | 579 | 191 |
LTU | Lithuania | parliament | 2008-10-12 | 3.64 | 1 | 141 | NS-SL | Naujoji sąjunga (socialliberalai) | New Union (Social Liberals) | 4.2686 | 15 | 646 | 214 | 579 | 856 |
LTU | Lithuania | parliament | 2008-10-12 | 3.24 | 0 | 141 | SPF | Socialist People's Front | Socialist People's Front | 1.3 | 15 | 646 | 214 | 579 | 1056 |
LTU | Lithuania | parliament | 2008-10-12 | 1.75 | 0 | 141 | JL | Jaunoji Lietuva | Young Lithuania | 9.8 | 15 | 646 | 214 | 579 | 383 |
LTU | Lithuania | parliament | 2008-10-12 | 1.11 | 0 | 141 | PDP | Pilietinės demokratijos partija | Civic Democratic Party | 6.0 | 15 | 646 | 214 | 579 | 676 |
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;