view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
16 rows where "election_date" is on date 1979-10-21
This data as json, CSV (advanced)
Suggested facets: seats, left_right
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 | 1979-10-21 | 24.4 | 51 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 435 | 371 | 20 | 35 |
CHE | Switzerland | parliament | 1979-10-21 | 24.0 | 51 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 435 | 371 | 20 | 26 |
CHE | Switzerland | parliament | 1979-10-21 | 21.3 | 44 | 200 | KK/CVP | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Catholic Conservative / Christian Democratic Peoples Party | 4.7288 | 40 | 435 | 371 | 20 | 531 |
CHE | Switzerland | parliament | 1979-10-21 | 11.6 | 23 | 200 | SVP-UDC | Schweizerische Volkspartei – Union Démocratique du Centre | Swiss People's Party | 7.3575 | 40 | 435 | 371 | 20 | 750 |
CHE | Switzerland | parliament | 1979-10-21 | 2.8 | 8 | 200 | LPS | Liberale Partei der Schweiz – Parti liberal suisse | Liberal Party of Switzerland | 7.2961 | 40 | 435 | 371 | 20 | 458 |
CHE | Switzerland | parliament | 1979-10-21 | 4.1 | 8 | 200 | LdU-ADI | Landesring der Unabhängigen – Alliance des Indépendants | Independents Alliance | 3.3 | 40 | 435 | 371 | 20 | 1264 |
CHE | Switzerland | parliament | 1979-10-21 | 0.44 | 3 | 200 | PdA | Partei der Arbeit der Schweiz | Swiss Party of Labour | 0.5263 | 40 | 435 | 371 | 20 | 1167 |
CHE | Switzerland | parliament | 1979-10-21 | 2.2 | 3 | 200 | EVP-PEP | Evangelische Volkspartei der Schweiz – Parti Populaire Evangelique Suisse | Protestant Peoples Party | 4.9248 | 40 | 435 | 371 | 20 | 602 |
CHE | Switzerland | parliament | 1979-10-21 | 0.18 | 2 | 200 | POCH | Progressive Organisationen der Schweiz – Organisations progressistes de Suisse | Progressive Organisations of Switzerland | 1.3 | 40 | 435 | 371 | 20 | 964 |
CHE | Switzerland | parliament | 1979-10-21 | 1.32 | 2 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 435 | 371 | 20 | 628 |
CHE | Switzerland | parliament | 1979-10-21 | 0.63 | 1 | 200 | Grue | Grüne – Écologiste | Greens | 1.6886 | 40 | 435 | 371 | 20 | 141 |
CHE | Switzerland | parliament | 1979-10-21 | 0.6 | 1 | 200 | RB | Republikanische Bewegung | Republican Movement | 8.8 | 40 | 435 | 371 | 20 | 564 |
CHE | Switzerland | parliament | 1979-10-21 | 1.7 | 1 | 200 | PSA | Partito socialista autonomo | Autonomous Socialist Party | 1.3 | 40 | 435 | 371 | 20 | 224 |
CHE | Switzerland | parliament | 1979-10-21 | 1 | 200 | EJ | Entente jurassienne | Agreement Jura | 40 | 435 | 371 | 20 | 1964 | ||
CHE | Switzerland | parliament | 1979-10-21 | 1 | 200 | one-seat | one seat | one seat | 40 | 435 | 371 | 20 | 2303 | ||
CHE | Switzerland | parliament | 1979-10-21 | 0.3 | 0 | 200 | EDU-UDF | Eidgenössisch-Demokratische Union – Union Démocratique Fédérale | Federal Democratic Union of Switzerland | 8.6579 | 40 | 435 | 371 | 20 | 1318 |
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;