view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
25 rows where "election_date" is on date 1991-10-20 sorted by election_type
This data as json, CSV (advanced)
Suggested facets: country_name_short, vote_share, seats_total, left_right, country_id, previous_parliament_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CHE | Switzerland | parliament | 1991-10-20 | 21.0 | 44 | 200 | FDP-PRD | Freisinnig-Demokratische Partei der Schweiz – Parti Radical-Democratique Suisse | Radical Democratic Party | 6.3249 | 40 | 521 | 358 | 426 | 26 |
CHE | Switzerland | parliament | 1991-10-20 | 18.5 | 41 | 200 | SP-PS | Sozialdemokratische Partei der Schweiz – Parti Socialiste Suisse | Social Democratic Party of Switzerland | 1.8319 | 40 | 521 | 358 | 426 | 35 |
CHE | Switzerland | parliament | 1991-10-20 | 18.0 | 35 | 200 | KK/CVP | Katholische Konservative / Christlichdemokratische Volkspartei – Conservateurs catholiques / Parti démocrate-chrétien | Catholic Conservative / Christian Democratic Peoples Party | 4.7288 | 40 | 521 | 358 | 426 | 531 |
CHE | Switzerland | parliament | 1991-10-20 | 11.9 | 25 | 200 | SVP-UDC | Schweizerische Volkspartei – Union Démocratique du Centre | Swiss People's Party | 7.3575 | 40 | 521 | 358 | 426 | 750 |
CHE | Switzerland | parliament | 1991-10-20 | 6.1 | 14 | 200 | Grue | Grüne – Écologiste | Greens | 1.6886 | 40 | 521 | 358 | 426 | 141 |
CHE | Switzerland | parliament | 1991-10-20 | 3.0 | 10 | 200 | LPS | Liberale Partei der Schweiz – Parti liberal suisse | Liberal Party of Switzerland | 7.2961 | 40 | 521 | 358 | 426 | 458 |
CHE | Switzerland | parliament | 1991-10-20 | 5.1 | 8 | 200 | FPS | Auto-Partei | Freiheitspartei der Schweiz | Automobile Party | Freedom Party of Switzerland | 8.0556 | 40 | 521 | 358 | 426 | 1602 |
CHE | Switzerland | parliament | 1991-10-20 | 2.8 | 5 | 200 | LdU-ADI | Landesring der Unabhängigen – Alliance des Indépendants | Independents Alliance | 3.3 | 40 | 521 | 358 | 426 | 1264 |
CHE | Switzerland | parliament | 1991-10-20 | 3.4 | 5 | 200 | NA|SD | Nationale Aktion – Action Nationale | Schweizer Demokraten – Démocrates Suisses | National Action -- Swiss Democrats | 9.4247 | 40 | 521 | 358 | 426 | 628 |
CHE | Switzerland | parliament | 1991-10-20 | 1.9 | 3 | 200 | EVP-PEP | Evangelische Volkspartei der Schweiz – Parti Populaire Evangelique Suisse | Protestant Peoples Party | 4.9248 | 40 | 521 | 358 | 426 | 602 |
CHE | Switzerland | parliament | 1991-10-20 | 0.8 | 2 | 200 | PdA | Partei der Arbeit der Schweiz | Swiss Party of Labour | 0.5263 | 40 | 521 | 358 | 426 | 1167 |
CHE | Switzerland | parliament | 1991-10-20 | 1.4 | 2 | 200 | LdT | Lega dei Ticinesi | Ticino League | 8.8 | 40 | 521 | 358 | 426 | 1500 |
CHE | Switzerland | parliament | 1991-10-20 | 1 | 200 | EJ | Entente jurassienne | Agreement Jura | 40 | 521 | 358 | 426 | 1964 | ||
CHE | Switzerland | parliament | 1991-10-20 | 0.6 | 1 | 200 | PSA | Partito socialista autonomo | Autonomous Socialist Party | 1.3 | 40 | 521 | 358 | 426 | 224 |
CHE | Switzerland | parliament | 1991-10-20 | 0.4 | 1 | 200 | CsP-PCS | Christlich-soziale Partei – Parti chrétien-social | Christian Social Party | 6.2 | 40 | 521 | 358 | 426 | 1012 |
CHE | Switzerland | parliament | 1991-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 | 521 | 358 | 426 | 1318 |
CHE | Switzerland | parliament | 1991-10-20 | 1.3 | 1 | 200 | FGr-ASF | Feministische und grün-alternative Gruppierungen – Alternative socialiste verte et groupements féministes | Feminists and Green-Alternative Groups | 2.5 | 40 | 521 | 358 | 426 | 569 |
CHE | Switzerland | parliament | 1991-10-20 | 1 | 200 | KHM | Komitee Herbert Maeder | Committee Herbert Maeder | 40 | 521 | 358 | 426 | 1967 | ||
CHE | Switzerland | parliament | 1991-10-20 | 0.2 | 0 | 200 | POCH | Progressive Organisationen der Schweiz – Organisations progressistes de Suisse | Progressive Organisations of Switzerland | 1.3 | 40 | 521 | 358 | 426 | 964 |
TUR | Turkey | parliament | 1991-10-20 | 27.03 | 178 | 450 | DYP | Doğru Yol Partisi | Right Path Party | 6.8239 | 20 | 811 | 812 | 1090 | 1141 |
TUR | Turkey | parliament | 1991-10-20 | 24.01 | 115 | 450 | ANAP | Anavatan Partisi | Motherland Party | 6.213 | 20 | 811 | 812 | 1090 | 1334 |
TUR | Turkey | parliament | 1991-10-20 | 20.75 | 88 | 450 | SHP|CHP | Sosyal Demokrat Halçi Parti | Cumhuriyet Halk Partisi | Social Democratic Populist Party | Republican People's Party | 3.2661 | 20 | 811 | 812 | 1090 | 507 |
TUR | Turkey | parliament | 1991-10-20 | 16.879 | 62 | 450 | RP | Refah (Fazilet) Partisi | Welfare (Virtue) Party | 8.3333 | 20 | 811 | 812 | 1090 | 1122 |
TUR | Turkey | parliament | 1991-10-20 | 10.75 | 7 | 450 | DSP | Demokratik Sol Parti | Democratic Left Party | 3.8377 | 20 | 811 | 812 | 1090 | 329 |
TUR | Turkey | parliament | 1991-10-20 | 0.4 | 0 | 450 | no-seat | no seat | no seat | 20 | 811 | 812 | 1090 | 2316 |
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;