view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
9 rows where "election_date" is on date 1958-11-30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FRA | France | parliament | 1958-11-30 | 20.6 | 198 | 465 | G | Gaulliste | Gaullists | 8.2 | 43 | 375 | 312 | 197 | 1094 |
FRA | France | parliament | 1958-11-30 | 20.0 | 133 | 465 | CNIP | Centre national des indépendants et paysans | National Centre of Independents and Peasants [Conservatives] | 7.5636 | 43 | 375 | 312 | 197 | 1414 |
FRA | France | parliament | 1958-11-30 | 11.1 | 57 | 465 | MRP | Mouvement républicain populaire | Popular Republican Movement | 8.2 | 43 | 375 | 312 | 197 | 1086 |
FRA | France | parliament | 1958-11-30 | 15.5 | 44 | 465 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 375 | 312 | 197 | 1539 |
FRA | France | parliament | 1958-11-30 | 9.7 | 23 | 465 | PR | Parti radical-socialiste | Radical Socialist Party | 3.9896 | 43 | 375 | 312 | 197 | 401 |
FRA | France | parliament | 1958-11-30 | 18.9 | 10 | 465 | PCF | Parti communiste française | French Communist Party | 1.3741 | 43 | 375 | 312 | 197 | 686 |
FRA | France | parliament | 1958-11-30 | 1.5 | 0 | 465 | UDCA | Union de défense des commerçants et artisans – Poujadists | Union for the Defence of Traders and Artisans -- Poujadists | 7.4 | 43 | 375 | 312 | 197 | 898 |
FRA | France | parliament | 1958-11-30 | 1.1 | 0 | 465 | ex-dro | extrême droite | other far-right | 8.8 | 43 | 375 | 312 | 197 | 2079 |
FRA | France | parliament | 1958-11-30 | 1.2 | 0 | 465 | UFD | Union des forces démocratiques | Union of Democratic Forces | 3.3 | 43 | 375 | 312 | 197 | 2269 |
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;