view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
10 rows where "election_date" is on date 1996-06-01
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CZE | Czech Republic | parliament | 1996-06-01 | 29.62 | 68 | 200 | ODS | Občanská demokratická strana | Civic Democratic Party | 7.3637 | 68 | 301 | 39 | 835 | 829 |
CZE | Czech Republic | parliament | 1996-06-01 | 26.44 | 61 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 301 | 39 | 835 | 789 |
CZE | Czech Republic | parliament | 1996-06-01 | 10.33 | 22 | 200 | KSCM | Komunistická strana Cech a Moravy | Communist Party of Bohemia and Moravia | 0.7498 | 68 | 301 | 39 | 835 | 1173 |
CZE | Czech Republic | parliament | 1996-06-01 | 8.01 | 18 | 200 | SPR-RSC | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Rally for the Republic -- Republican Party of Czechoslovakia | 9.7778 | 68 | 301 | 39 | 835 | 872 |
CZE | Czech Republic | parliament | 1996-06-01 | 8.08 | 18 | 200 | KDU-CSL | Křesťanská a demokratická unie – Československá strana lidová | Christian Democratic Union -- People's Party | 5.8099 | 68 | 301 | 39 | 835 | 1245 |
CZE | Czech Republic | parliament | 1996-06-01 | 6.36 | 13 | 200 | ODA | Občanská demokratická aliance | Civic Democratic Alliance | 7.1111 | 68 | 301 | 39 | 835 | 1123 |
CZE | Czech Republic | parliament | 1996-06-01 | 2.05 | 0 | 200 | CNSP | Česká národně strana socialistická | Czech National Social(ist) Party | 8.8 | 68 | 301 | 39 | 835 | 29 |
CZE | Czech Republic | parliament | 1996-06-01 | 3.09 | 0 | 200 | DZJ | Důchodci za životní jistoty | Pensioners for a Secure Living | 3.3 | 68 | 301 | 39 | 835 | 77 |
CZE | Czech Republic | parliament | 1996-06-01 | 2.8 | 0 | 200 | DU | Demokratická unie | Democratic Union | 6.0 | 68 | 301 | 39 | 835 | 1616 |
CZE | Czech Republic | parliament | 1996-06-01 | 1.4 | 0 | 200 | LB | Levý Blok | Left Bloc | 1.3 | 68 | 301 | 39 | 835 | 2224 |
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;