view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
16 rows where "election_date" is on date 1928-05-20
This data as json, CSV (advanced)
Suggested facets: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DEU | Germany | parliament | 1928-05-20 | 29.76 | 153 | 491 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 1036 | 1035 | 1575 | 558 |
DEU | Germany | parliament | 1928-05-20 | 14.25 | 73 | 491 | DNVP | Deutschnationale Volkspartei | German National People's Party | 8.8 | 54 | 1036 | 1035 | 1575 | 2692 |
DEU | Germany | parliament | 1928-05-20 | 11.88 | 61 | 491 | DZ | Deutsche Zentrumspartei | Centre Party | 6.2 | 54 | 1036 | 1035 | 1575 | 137 |
DEU | Germany | parliament | 1928-05-20 | 10.62 | 54 | 491 | KPD | Kommunistische Partei Deutschlands | Communist Party of Germany | 0.957 | 54 | 1036 | 1035 | 1575 | 649 |
DEU | Germany | parliament | 1928-05-20 | 8.71 | 45 | 491 | DVP | Deutsche Volkspartei | German People's Party | 7.4 | 54 | 1036 | 1035 | 1575 | 2693 |
DEU | Germany | parliament | 1928-05-20 | 4.81 | 25 | 491 | DDP | Deutsche Demokratische Partei | German Democratic Party | 6.0 | 54 | 1036 | 1035 | 1575 | 2691 |
DEU | Germany | parliament | 1928-05-20 | 4.51 | 23 | 491 | WP | Wirtschaftspartei | Economic Party | 7.4 | 54 | 1036 | 1035 | 1575 | 2698 |
DEU | Germany | parliament | 1928-05-20 | 3.27 | 17 | 491 | BVP | Bayerische Volkspartei | Bavarian People's Party | 6.2 | 54 | 1036 | 1035 | 1575 | 2697 |
DEU | Germany | parliament | 1928-05-20 | 2.63 | 12 | 491 | NSDAP | Nationalsozialistische Deutsche Arbeiterpartei | National Socialist German Workers' Party | 8.8 | 54 | 1036 | 1035 | 1575 | 2695 |
DEU | Germany | parliament | 1928-05-20 | 1.86 | 9 | 491 | CNBL | Christlich-Nationale Bauern- und Landvolkpartei | Christian-National Peasants' and Farmers' Party | 6.2 | 54 | 1036 | 1035 | 1575 | 2709 |
DEU | Germany | parliament | 1928-05-20 | 1.18 | 7 | 491 | BBB | Bayerischer Bauernbund | Bavarian Peasants' League | 6.0 | 54 | 1036 | 1035 | 1575 | 2701 |
DEU | Germany | parliament | 1928-05-20 | 0.64 | 4 | 491 | DHP | Deutsch-Hannoversche Partei | German-Hanoverian Party | 7.4 | 54 | 1036 | 1035 | 1575 | 2696 |
DEU | Germany | parliament | 1928-05-20 | 0.65 | 3 | 491 | BWB | Bauern- und Weingärtnerbund | Farmers and Wine Growers Association | 5.3 | 54 | 1036 | 1035 | 1575 | 2703 |
DEU | Germany | parliament | 1928-05-20 | 0.42 | 2 | 491 | SLV | Sächsisches Landvolk | Saxon Peasants | 5.3 | 54 | 1036 | 1035 | 1575 | 2708 |
DEU | Germany | parliament | 1928-05-20 | 1.57 | 2 | 491 | VRP | Reichspartei für Volksrecht und Aufwertung | Reich Party for Civil Rights and Deflation | 54 | 1036 | 1035 | 1575 | 2710 | |
DEU | Germany | parliament | 1928-05-20 | 0.39 | 1 | 491 | DBP | Deutsche Bauernpartei | German Farmers' Party | 5.3 | 54 | 1036 | 1035 | 1575 | 2712 |
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;