view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
24 rows where "election_date" is on date 2012-06-17 sorted by election_type
This data as json, CSV (advanced)
Suggested facets: country_name_short, country_name, seats, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
FRA | France | parliament | 2012-06-17 | 29.35 | 280 | 577 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 782 | 171 | 1037 | 1539 |
FRA | France | parliament | 2012-06-17 | 27.12 | 194 | 577 | UMP|LR | Union pour un mouvement populaire | Les Républicains | Union for a Popular Movement | The Republicans | 7.4997 | 43 | 782 | 171 | 1037 | 658 |
FRA | France | parliament | 2012-06-17 | 3.4 | 22 | 577 | d-gauche | divers gauche | other left | 3.3 | 43 | 782 | 171 | 1037 | 177 |
FRA | France | parliament | 2012-06-17 | 5.46 | 17 | 577 | V | Les Verts | Greens | 3.155 | 43 | 782 | 171 | 1037 | 873 |
FRA | France | parliament | 2012-06-17 | 3.51 | 15 | 577 | d-droite | divers droite | other right | 7.6583 | 43 | 782 | 171 | 1037 | 285 |
FRA | France | parliament | 2012-06-17 | 1.65 | 12 | 577 | PRG | Parti radical de gauche | Radical Party of the Left | 4.0813 | 43 | 782 | 171 | 1037 | 1492 |
FRA | France | parliament | 2012-06-17 | 2.2 | 12 | 577 | NC | Nouveau centre | New Centre | 6.0 | 43 | 782 | 171 | 1037 | 1058 |
FRA | France | parliament | 2012-06-17 | 6.91 | 10 | 577 | PCF | Parti communiste française | French Communist Party | 1.3741 | 43 | 782 | 171 | 1037 | 686 |
FRA | France | parliament | 2012-06-17 | 1.24 | 6 | 577 | PR | Parti radical-socialiste | Radical Socialist Party | 3.9896 | 43 | 782 | 171 | 1037 | 401 |
FRA | France | parliament | 2012-06-17 | 0.56 | 2 | 577 | MIM | Mouvement independantiste martiniquais | Martinican Independence Movement | 43 | 782 | 171 | 1037 | 2077 | |
FRA | France | parliament | 2012-06-17 | 1.77 | 2 | 577 | UDF|MD | Union pour la démocratie française | Mouvement démocrate | Union for French Democracy | Democratic Movement | 6.1017 | 43 | 782 | 171 | 1037 | 509 |
FRA | France | parliament | 2012-06-17 | 0.6 | 2 | 577 | AC | Alliance centriste | Centrist Alliance | 6.0 | 43 | 782 | 171 | 1037 | 2078 |
FRA | France | parliament | 2012-06-17 | 13.6 | 2 | 577 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 782 | 171 | 1037 | 270 |
FRA | France | parliament | 2012-06-17 | 0.19 | 1 | 577 | ex-dro | extrême droite | other far-right | 8.8 | 43 | 782 | 171 | 1037 | 2079 |
FRA | France | parliament | 2012-06-17 | 0.96 | 0 | 577 | no-seat | no seat | no seat | 43 | 782 | 171 | 1037 | 2080 | |
GRC | Greece | parliament | 2012-06-17 | 29.66 | 129 | 300 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 784 | 783 | 1039 | 47 |
GRC | Greece | parliament | 2012-06-17 | 26.89 | 71 | 300 | SYRIZA | Synaspismós Rizospastikís Aristerás | Coalition of the Radical Left | 2.8947 | 41 | 784 | 783 | 1039 | 1592 |
GRC | Greece | parliament | 2012-06-17 | 12.28 | 33 | 300 | PASOK | Panellinio Sosialistikó Kínima | Panhellenic Socialist Movement | 4.4968 | 41 | 784 | 783 | 1039 | 1338 |
GRC | Greece | parliament | 2012-06-17 | 7.51 | 20 | 300 | ANEL | Anexartitoi Ellines | Independent Greeks | 8.8 | 41 | 784 | 783 | 1039 | 2091 |
GRC | Greece | parliament | 2012-06-17 | 6.92 | 18 | 300 | LS-CA | Laikos Syndesmos – Chrysi Avg | Peoples Association -- Golden Dawn | 8.8 | 41 | 784 | 783 | 1039 | 2092 |
GRC | Greece | parliament | 2012-06-17 | 6.26 | 17 | 300 | DIMAR | Dimokratiki Aristera | Democratic Left | 3.3 | 41 | 784 | 783 | 1039 | 2093 |
GRC | Greece | parliament | 2012-06-17 | 4.5 | 12 | 300 | KKE | Kommounistikó Kómma Elládas | Communist Party of Greece | 1.253 | 41 | 784 | 783 | 1039 | 614 |
GRC | Greece | parliament | 2012-06-17 | 1.59 | 0 | 300 | DX | Dimiourgia Xana | Recreate Greece | 7.4 | 41 | 784 | 783 | 1039 | 2095 |
GRC | Greece | parliament | 2012-06-17 | 1.58 | 0 | 300 | LAOS | Laïkós Orthódoxos Synagermós | Popular Orthodox Rally | 9.11 | 41 | 784 | 783 | 1039 | 1179 |
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;