view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
16 rows where "election_date" is on date 2019-10-20
This data as json, CSV (advanced)
Suggested facets: seats, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CHE | Switzerland | parliament | 2019-10-20 | 25.59 | 53 | 200 | SVP-UDC | Schweizerische Volkspartei – Union Démocratique du Centre | Swiss People's Party | 7.3575 | 40 | 1083 | 995 | 1212 | 750 |
CHE | Switzerland | parliament | 2019-10-20 | 16.84 | 39 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 1083 | 995 | 1212 | 35 |
CHE | Switzerland | parliament | 2019-10-20 | 15.11 | 29 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 1083 | 995 | 1212 | 26 |
CHE | Switzerland | parliament | 2019-10-20 | 13.2 | 28 | 200 | Grue | Grüne – Écologiste | Greens | 1.6886 | 40 | 1083 | 995 | 1212 | 141 |
CHE | Switzerland | parliament | 2019-10-20 | 11.38 | 25 | 200 | KK/CVP | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Catholic Conservative / Christian Democratic Peoples Party | 4.7288 | 40 | 1083 | 995 | 1212 | 531 |
CHE | Switzerland | parliament | 2019-10-20 | 7.8 | 16 | 200 | GPL-PVL | Grünliberale Partei der Schweiz – Parti Vert-Libéral | Green Liberal Party | 2.5 | 40 | 1083 | 995 | 1212 | 308 |
CHE | Switzerland | parliament | 2019-10-20 | 2.08 | 3 | 200 | EVP-PEP | Evangelische Volkspartei der Schweiz – Parti Populaire Evangelique Suisse | Protestant Peoples Party | 4.9248 | 40 | 1083 | 995 | 1212 | 602 |
CHE | Switzerland | parliament | 2019-10-20 | 2.44 | 3 | 200 | BDP | Bürgerlich–Demokratische Partei (BDP) Graubünden | Conservative Democratic Party of Switzerland | 7.4 | 40 | 1083 | 995 | 1212 | 1213 |
CHE | Switzerland | parliament | 2019-10-20 | 1.05 | 1 | 200 | PdA | Partei der Arbeit der Schweiz | Swiss Party of Labour | 0.5263 | 40 | 1083 | 995 | 1212 | 1167 |
CHE | Switzerland | parliament | 2019-10-20 | 1 | 200 | S | solidaritéS | Solidarity | 1.3 | 40 | 1083 | 995 | 1212 | 1226 | |
CHE | Switzerland | parliament | 2019-10-20 | 1.0 | 1 | 200 | EDU-UDF | Eidgenössisch-Demokratische Union – Union Démocratique Fédérale | Federal Democratic Union of Switzerland | 8.6579 | 40 | 1083 | 995 | 1212 | 1318 |
CHE | Switzerland | parliament | 2019-10-20 | 0.75 | 1 | 200 | LdT | Lega dei Ticinesi | Ticino League | 8.8 | 40 | 1083 | 995 | 1212 | 1500 |
CHE | Switzerland | parliament | 2019-10-20 | 0.26 | 0 | 200 | CsP-PCS | Christlich-soziale Partei – Parti chrétien-social | Christian Social Party | 6.2 | 40 | 1083 | 995 | 1212 | 1012 |
CHE | Switzerland | parliament | 2019-10-20 | 0.32 | 0 | 200 | FGr-ASF | Feministische und grün-alternative Gruppierungen – Alternative socialiste verte et groupements féministes | Feminists and Green-Alternative Groups | 2.5 | 40 | 1083 | 995 | 1212 | 569 |
CHE | Switzerland | parliament | 2019-10-20 | 0.13 | 0 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 1083 | 995 | 1212 | 628 |
CHE | Switzerland | parliament | 2019-10-20 | 0.22 | 0 | 200 | MCR | Mouvement Citoyens Genevois | Geneva Citizens' Movement | 8.8 | 40 | 1083 | 995 | 1212 | 2599 |
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;