view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
17 rows where "election_date" is on date 1924-05-04
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DEU | Germany | parliament | 1924-05-04 | 20.45 | 100 | 472 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 1034 | 1033 | 1569 | 558 |
DEU | Germany | parliament | 1924-05-04 | 19.45 | 95 | 472 | DNVP | Deutschnationale Volkspartei | German National People's Party | 8.8 | 54 | 1034 | 1033 | 1569 | 2692 |
DEU | Germany | parliament | 1924-05-04 | 13.32 | 65 | 472 | DZ | Deutsche Zentrumspartei | Centre Party | 6.2 | 54 | 1034 | 1033 | 1569 | 137 |
DEU | Germany | parliament | 1924-05-04 | 12.57 | 62 | 472 | KPD | Kommunistische Partei Deutschlands | Communist Party of Germany | 0.957 | 54 | 1034 | 1033 | 1569 | 649 |
DEU | Germany | parliament | 1924-05-04 | 9.17 | 45 | 472 | DVP | Deutsche Volkspartei | German People's Party | 7.4 | 54 | 1034 | 1033 | 1569 | 2693 |
DEU | Germany | parliament | 1924-05-04 | 6.53 | 32 | 472 | NSDAP | Nationalsozialistische Deutsche Arbeiterpartei | National Socialist German Workers' Party | 8.8 | 54 | 1034 | 1033 | 1569 | 2695 |
DEU | Germany | parliament | 1924-05-04 | 5.63 | 28 | 472 | DDP | Deutsche Demokratische Partei | German Democratic Party | 6.0 | 54 | 1034 | 1033 | 1569 | 2691 |
DEU | Germany | parliament | 1924-05-04 | 3.22 | 16 | 472 | BVP | Bayerische Volkspartei | Bavarian People's Party | 6.2 | 54 | 1034 | 1033 | 1569 | 2697 |
DEU | Germany | parliament | 1924-05-04 | 1.69 | 7 | 472 | WP | Wirtschaftspartei | Economic Party | 7.4 | 54 | 1034 | 1033 | 1569 | 2698 |
DEU | Germany | parliament | 1924-05-04 | 1.06 | 5 | 472 | DHP | Deutsch-Hannoversche Partei | German-Hanoverian Party | 7.4 | 54 | 1034 | 1033 | 1569 | 2696 |
DEU | Germany | parliament | 1924-05-04 | 1.15 | 4 | 472 | DSP | Deutschsoziale Partei | German Social Party | 8.8 | 54 | 1034 | 1033 | 1569 | 2705 |
DEU | Germany | parliament | 1924-05-04 | 0.81 | 4 | 472 | BWB | Bauern- und Weingärtnerbund | Farmers and Wine Growers Association | 5.3 | 54 | 1034 | 1033 | 1569 | 2703 |
DEU | Germany | parliament | 1924-05-04 | 0.58 | 3 | 472 | BBB | Bayerischer Bauernbund | Bavarian Peasants' League | 6.0 | 54 | 1034 | 1033 | 1569 | 2701 |
DEU | Germany | parliament | 1924-05-04 | 0.49 | 2 | 472 | LBT | Landbund Thüringen | Rural Federation Thuringia | 5.3 | 54 | 1034 | 1033 | 1569 | 2704 |
DEU | Germany | parliament | 1924-05-04 | 0.3 | 2 | 472 | HBB | Hessischer Bauernbund | Hessian Farmers' Federation | 5.3 | 54 | 1034 | 1033 | 1569 | 2706 |
DEU | Germany | parliament | 1924-05-04 | 0.11 | 1 | 472 | one-seat | one seat | one seat | 54 | 1034 | 1033 | 1569 | 2289 | |
DEU | Germany | parliament | 1924-05-04 | 0.24 | 1 | 472 | BLB | Badischer Landbund | Baden Rural Federation | 5.3 | 54 | 1034 | 1033 | 1569 | 2707 |
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;