view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
36 rows where "election_date" is on date 2014-05-24 sorted by election_type
This data as json, CSV (advanced)
Suggested facets: country_name_short, country_name, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CZE | Czech Republic | ep | 2014-05-24 | 16.13 | 4 | 21 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 820 | 805 | 1072 | 2263 |
CZE | Czech Republic | ep | 2014-05-24 | 15.95 | 4 | 21 | TOP09 | Tradice Odpovědnost Prosperita 09 | Tradition Responsibility Prosperity 09 | 7.4 | 68 | 820 | 805 | 1072 | 2 |
CZE | Czech Republic | ep | 2014-05-24 | 14.17 | 4 | 21 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 820 | 805 | 1072 | 789 |
CZE | Czech Republic | ep | 2014-05-24 | 10.98 | 3 | 21 | KSCM | Komunistická strana Cech a Moravy | Communist Party of Bohemia and Moravia | 0.7498 | 68 | 820 | 805 | 1072 | 1173 |
CZE | Czech Republic | ep | 2014-05-24 | 9.95 | 3 | 21 | KDU-CSL | Křesťanská a demokratická unie – Československá strana lidová | Christian Democratic Union -- People's Party | 5.8099 | 68 | 820 | 805 | 1072 | 1245 |
CZE | Czech Republic | ep | 2014-05-24 | 7.67 | 2 | 21 | ODS | Občanská demokratická strana | Civic Democratic Party | 7.3637 | 68 | 820 | 805 | 1072 | 829 |
CZE | Czech Republic | ep | 2014-05-24 | 5.24 | 1 | 21 | SSO | Strana svobodných občanů | Party of Free Citizens | 8.8 | 68 | 820 | 805 | 1072 | 363 |
CZE | Czech Republic | ep | 2014-05-24 | 4.78 | 0 | 21 | Pi | Ceska piratska strana | Czech Pirate Party | 68 | 820 | 805 | 1072 | 2261 | |
CZE | Czech Republic | ep | 2014-05-24 | 3.77 | 0 | 21 | SZ | Strana zelených | Green Party | 4.123 | 68 | 820 | 805 | 1072 | 196 |
CZE | Czech Republic | ep | 2014-05-24 | 3.12 | 0 | 21 | UPD | Úsvit přímé demokracie | Dawn of Direct Democracy | 7.4 | 68 | 820 | 805 | 1072 | 2262 |
CZE | Czech Republic | ep | 2014-05-24 | 1.63 | 0 | 21 | S-JB | Suverenita – blok Jany Bobošíkové | Sovereignty -- Jana Bobosikova Bloc | 8.8 | 68 | 820 | 805 | 1072 | 1613 |
FRA | France | ep | 2014-05-24 | 24.86 | 24 | 74 | FN | Rassemblement National | National Rally | 9.6854 | 43 | 824 | 782 | 1103 | 270 |
FRA | France | ep | 2014-05-24 | 20.81 | 20 | 74 | UMP|LR | Union pour un mouvement populaire | Les Républicains | Union for a Popular Movement | The Republicans | 7.4997 | 43 | 824 | 782 | 1103 | 658 |
FRA | France | ep | 2014-05-24 | 13.98 | 12 | 74 | PS | Parti socialiste | Socialist Party | 3.2493 | 43 | 824 | 782 | 1103 | 1539 |
FRA | France | ep | 2014-05-24 | 8.95 | 6 | 74 | V | Les Verts | Greens | 3.155 | 43 | 824 | 782 | 1103 | 873 |
FRA | France | ep | 2014-05-24 | 9.94 | 4 | 74 | UDF|MD | Union pour la démocratie française | Mouvement démocrate | Union for French Democracy | Democratic Movement | 6.1017 | 43 | 824 | 782 | 1103 | 509 |
FRA | France | ep | 2014-05-24 | 6.33 | 3 | 74 | PCF | Parti communiste française | French Communist Party | 1.3741 | 43 | 824 | 782 | 1103 | 686 |
FRA | France | ep | 2014-05-24 | 1 | 74 | PRG | Parti radical de gauche | Radical Party of the Left | 4.0813 | 43 | 824 | 782 | 1103 | 1492 | |
FRA | France | ep | 2014-05-24 | 1 | 74 | PR | Parti radical-socialiste | Radical Socialist Party | 3.9896 | 43 | 824 | 782 | 1103 | 401 | |
FRA | France | ep | 2014-05-24 | 1 | 74 | AC | Alliance centriste | Centrist Alliance | 6.0 | 43 | 824 | 782 | 1103 | 2078 | |
FRA | France | ep | 2014-05-24 | 1 | 74 | NC | Nouveau centre | New Centre | 6.0 | 43 | 824 | 782 | 1103 | 1058 | |
FRA | France | ep | 2014-05-24 | 0.27 | 1 | 74 | AO | Alliances des outre-mers | Alliance of the Overseas | 1.3 | 43 | 824 | 782 | 1103 | 2400 |
FRA | France | ep | 2014-05-24 | 3.82 | 0 | 74 | DLR|DLF | Debout la république | Debout la France | Republic Arise | France Arise | 7.4 | 43 | 824 | 782 | 1103 | 2399 |
FRA | France | ep | 2014-05-24 | 1.12 | 0 | 74 | d-eco | divers ecologistes | other ecologists | 2.5 | 43 | 824 | 782 | 1103 | 2249 |
FRA | France | ep | 2014-05-24 | 1.17 | 0 | 74 | LO | Lutte ouvrière | Workers' Struggle | 0.0 | 43 | 824 | 782 | 1103 | 1176 |
FRA | France | ep | 2014-05-24 | 1.41 | 0 | 74 | d-droite | divers droite | other right | 7.6583 | 43 | 824 | 782 | 1103 | 285 |
FRA | France | ep | 2014-05-24 | 2.9 | 0 | 74 | d-gauche | divers gauche | other left | 3.3 | 43 | 824 | 782 | 1103 | 177 |
LVA | Latvia | ep | 2014-05-24 | 46.19 | 4 | 8 | V | Vienotība | Unity | 7.4 | 55 | 848 | 765 | 1073 | 1666 |
LVA | Latvia | ep | 2014-05-24 | 13.04 | 1 | 8 | S | Saskaņas | Harmony | 3.0 | 55 | 848 | 765 | 1073 | 1100 |
LVA | Latvia | ep | 2014-05-24 | 14.25 | 1 | 8 | NA/TB/LNNK | Nacionālā apvienība / Tēvzemei un Brīvībai / LNNK | National Alliance / For Fatherland and Freedom / LNNK | 8.2588 | 55 | 848 | 765 | 1073 | 521 |
LVA | Latvia | ep | 2014-05-24 | 8.26 | 1 | 8 | ZZS | Zaļo un Zemnieku savienība | Green and Farmers' Union | 5.2632 | 55 | 848 | 765 | 1073 | 466 |
LVA | Latvia | ep | 2014-05-24 | 6.38 | 1 | 8 | PCTVL | Par cilvēka tiesībām vienotā Latvijā | For Human Rights in a United Latvia | 1.25 | 55 | 848 | 765 | 1073 | 1520 |
LVA | Latvia | ep | 2014-05-24 | 2.49 | 0 | 8 | LRa | Latvijas Reģionu apvienība | Latvian Association of Regions | 7.4 | 55 | 848 | 765 | 1073 | 2366 |
LVA | Latvia | ep | 2014-05-24 | 1.54 | 0 | 8 | LSP | Latvijas Sociālistiskā partija | Socialist Party of Latvia | 1.25 | 55 | 848 | 765 | 1073 | 309 |
LVA | Latvia | ep | 2014-05-24 | 2.12 | 0 | 8 | LA | Latvijas attīstībai | For Latvia's Development | 6.0 | 55 | 848 | 765 | 1073 | 2392 |
LVA | Latvia | ep | 2014-05-24 | 3.73 | 0 | 8 | PPA | Politiskā Partija "Alternative" | Political Party "Alternative" | 3.3 | 55 | 848 | 765 | 1073 | 2393 |
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;