view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
36 rows where "election_date" is on date 2019-05-25 sorted by election_type
This data as json, CSV (advanced)
Suggested facets: country_name_short, country_name, seats, seats_total, country_id, 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 | 2019-05-25 | 21.18 | 6 | 21 | ANO | Akce nespokojených občanů 2011 | Action of Dissatisfied Citizens 2011 | 6.0 | 68 | 1057 | 1020 | 1534 | 2263 |
CZE | Czech Republic | ep | 2019-05-25 | 14.54 | 4 | 21 | ODS | Občanská demokratická strana | Civic Democratic Party | 7.3637 | 68 | 1057 | 1020 | 1534 | 829 |
CZE | Czech Republic | ep | 2019-05-25 | 13.95 | 3 | 21 | Pi | Ceska piratska strana | Czech Pirate Party | 68 | 1057 | 1020 | 1534 | 2261 | |
CZE | Czech Republic | ep | 2019-05-25 | 11.65 | 3 | 21 | TOP09 | Tradice Odpovědnost Prosperita 09 | Tradition Responsibility Prosperity 09 | 7.4 | 68 | 1057 | 1020 | 1534 | 2 |
CZE | Czech Republic | ep | 2019-05-25 | 9.14 | 2 | 21 | SPD | Svoboda a přímá demokracie | Freedom and Direct Democracy | 8.8 | 68 | 1057 | 1020 | 1534 | 2654 |
CZE | Czech Republic | ep | 2019-05-25 | 7.24 | 2 | 21 | KDU-CSL | Křesťanská a demokratická unie – Československá strana lidová | Christian Democratic Union -- People's Party | 5.8099 | 68 | 1057 | 1020 | 1534 | 1245 |
CZE | Czech Republic | ep | 2019-05-25 | 6.94 | 1 | 21 | KSCM | Komunistická strana Cech a Moravy | Communist Party of Bohemia and Moravia | 0.7498 | 68 | 1057 | 1020 | 1534 | 1173 |
CZE | Czech Republic | ep | 2019-05-25 | 3.95 | 0 | 21 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 1057 | 1020 | 1534 | 789 |
CZE | Czech Republic | ep | 2019-05-25 | 2.38 | 0 | 21 | H | Hlas | Voice | 6.0 | 68 | 1057 | 1020 | 1534 | 2739 |
CZE | Czech Republic | ep | 2019-05-25 | 1.56 | 0 | 21 | ANO-VE | ANO, vytrollíme europarlament | Yes, We Will Troll the Euro-Parliament | 68 | 1057 | 1020 | 1534 | 2779 | |
LVA | Latvia | ep | 2019-05-25 | 26.24 | 2 | 8 | V | Vienotība | Unity | 7.4 | 55 | 1063 | 1042 | 1592 | 1666 |
LVA | Latvia | ep | 2019-05-25 | 16.4 | 2 | 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 | 1063 | 1042 | 1592 | 521 |
LVA | Latvia | ep | 2019-05-25 | 17.45 | 2 | 8 | S | Saskaņas | Harmony | 3.0 | 55 | 1063 | 1042 | 1592 | 1100 |
LVA | Latvia | ep | 2019-05-25 | 12.42 | 1 | 8 | LA | Latvijas attīstībai | For Latvia's Development | 6.0 | 55 | 1063 | 1042 | 1592 | 2392 |
LVA | Latvia | ep | 2019-05-25 | 6.24 | 1 | 8 | PCTVL | Par cilvēka tiesībām vienotā Latvijā | For Human Rights in a United Latvia | 1.25 | 55 | 1063 | 1042 | 1592 | 1520 |
LVA | Latvia | ep | 2019-05-25 | 5.34 | 0 | 8 | ZZS | Zaļo un Zemnieku savienība | Green and Farmers' Union | 5.2632 | 55 | 1063 | 1042 | 1592 | 466 |
LVA | Latvia | ep | 2019-05-25 | 4.98 | 0 | 8 | LRa | Latvijas Reģionu apvienība | Latvian Association of Regions | 7.4 | 55 | 1063 | 1042 | 1592 | 2366 |
LVA | Latvia | ep | 2019-05-25 | 4.35 | 0 | 8 | JKP | Jaunā konservatīvā partija | New Conservative Party | 7.4 | 55 | 1063 | 1042 | 1592 | 2717 |
LVA | Latvia | ep | 2019-05-25 | 2.9 | 0 | 8 | P | Progresīvie | The Progressive | 3.3 | 55 | 1063 | 1042 | 1592 | 2716 |
MLT | Malta | ep | 2019-05-25 | 54.29 | 4 | 6 | PL | Partit Laburista | Malta Labour Party | 4.2105 | 72 | 1066 | 1010 | 1504 | 1003 |
MLT | Malta | ep | 2019-05-25 | 37.9 | 2 | 6 | PN | Partit Nazzjonalista | Nationalist Party | 5.7143 | 72 | 1066 | 1010 | 1504 | 984 |
MLT | Malta | ep | 2019-05-25 | 2.03 | 0 | 6 | PD | Partit Demokratiku | Democratic Party | 6.0 | 72 | 1066 | 1010 | 1504 | 2759 |
MLT | Malta | ep | 2019-05-25 | 3.17 | 0 | 6 | IE | Imperu Ewropew | Imperium Europa | 8.8 | 72 | 1066 | 1010 | 1504 | 1400 |
SVK | Slovakia | ep | 2019-05-25 | 15.72 | 3 | 13 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 1070 | 1003 | 1529 | 220 |
SVK | Slovakia | ep | 2019-05-25 | 9.62 | 2 | 13 | SaS | Sloboda a solidarita | Freedom and Solidarity | 6.0 | 1 | 1070 | 1003 | 1529 | 1460 |
SVK | Slovakia | ep | 2019-05-25 | 12.07 | 2 | 13 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 1070 | 1003 | 1529 | 586 |
SVK | Slovakia | ep | 2019-05-25 | 20.11 | 2 | 13 | PS | Progresívne Slovensko | Progressive Slovakia | 6.0 | 1 | 1070 | 1003 | 1529 | 2751 |
SVK | Slovakia | ep | 2019-05-25 | 2 | 13 | SPOLU | SPOLU – občianska demokracia | TOGETHER -- Civic Democracy | 6.0 | 1 | 1070 | 1003 | 1529 | 2752 | |
SVK | Slovakia | ep | 2019-05-25 | 9.69 | 1 | 13 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 1070 | 1003 | 1529 | 1432 |
SVK | Slovakia | ep | 2019-05-25 | 5.25 | 1 | 13 | OLaNO | Obyčajní ľudia a nezávislé osobnosti | Ordinary People and Independent | 7.4 | 1 | 1070 | 1003 | 1529 | 1759 |
SVK | Slovakia | ep | 2019-05-25 | 4.09 | 0 | 13 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 1070 | 1003 | 1529 | 1072 |
SVK | Slovakia | ep | 2019-05-25 | 4.96 | 0 | 13 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 1070 | 1003 | 1529 | 559 |
SVK | Slovakia | ep | 2019-05-25 | 2.59 | 0 | 13 | MH | Most-Híd | Most-Hid | 7.4 | 1 | 1070 | 1003 | 1529 | 1620 |
SVK | Slovakia | ep | 2019-05-25 | 3.23 | 0 | 13 | SR | Sme Rodina – Boris Kollár | We are family -- Boris Kollar | 8.8 | 1 | 1070 | 1003 | 1529 | 2623 |
SVK | Slovakia | ep | 2019-05-25 | 3.85 | 0 | 13 | KU | Kresťanská únia | Christian Union | 6.2 | 1 | 1070 | 1003 | 1529 | 2750 |
SVK | Slovakia | ep | 2019-05-25 | 2.06 | 0 | 13 | KDZP | Kresťanská demokracia – Život a prosperita | Christian Democracy -- Life and Prosperity | 6.2 | 1 | 1070 | 1003 | 1529 | 2783 |
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;