view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by country_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SVK | Slovakia | parliament | 2010-06-12 | 4.32 | 0 | 150 | HZDS | Hnutie za demokratické Slovensko | Movement for a Democratic Slovakia | 4.8914 | 1 | 524 | 192 | 269 | 1142 |
SVK | Slovakia | parliament | 2010-06-12 | 1.33 | 0 | 150 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 524 | 192 | 269 | 586 |
SVK | Slovakia | parliament | 2010-06-12 | 4.33 | 0 | 150 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 524 | 192 | 269 | 559 |
SVK | Slovakia | parliament | 2012-03-10 | 44.41 | 83 | 150 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 781 | 524 | 982 | 220 |
SVK | Slovakia | parliament | 2012-03-10 | 8.82 | 16 | 150 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 781 | 524 | 982 | 1432 |
SVK | Slovakia | parliament | 2012-03-10 | 8.55 | 16 | 150 | OLaNO | Obyčajní ľudia a nezávislé osobnosti | Ordinary People and Independent | 7.4 | 1 | 781 | 524 | 982 | 1759 |
SVK | Slovakia | parliament | 2012-03-10 | 6.89 | 13 | 150 | MH | Most-Híd | Most-Hid | 7.4 | 1 | 781 | 524 | 982 | 1620 |
SVK | Slovakia | parliament | 2012-03-10 | 5.88 | 11 | 150 | SaS | Sloboda a solidarita | Freedom and Solidarity | 6.0 | 1 | 781 | 524 | 982 | 1460 |
SVK | Slovakia | parliament | 2012-03-10 | 6.09 | 11 | 150 | SDKU-DS | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovak Democratic and Christian Union -- Democratic Party | 7.3591 | 1 | 781 | 524 | 982 | 131 |
SVK | Slovakia | parliament | 2012-03-10 | 4.55 | 0 | 150 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 781 | 524 | 982 | 1072 |
SVK | Slovakia | parliament | 2012-03-10 | 1.58 | 0 | 150 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 781 | 524 | 982 | 586 |
SVK | Slovakia | parliament | 2012-03-10 | 1.29 | 0 | 150 | ZZ | Zmena zdola, DÚ | Change from the Bottom, DU | 6.0 | 1 | 781 | 524 | 982 | 2013 |
SVK | Slovakia | parliament | 2012-03-10 | 1.58 | 0 | 150 | 99% | 99% – občiansky hlas | 99 Percent -- Civic Voice | 1.3 | 1 | 781 | 524 | 982 | 2015 |
SVK | Slovakia | parliament | 2012-03-10 | 4.28 | 0 | 150 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 781 | 524 | 982 | 559 |
SVK | Slovakia | parliament | 2012-03-10 | 1.22 | 0 | 150 | ANO | Aliancia nového občana | Alliance of the New Citizen | 7.2404 | 1 | 781 | 524 | 982 | 1200 |
SVK | Slovakia | ep | 2014-05-25 | 24.1 | 4 | 13 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 847 | 781 | 1027 | 220 |
SVK | Slovakia | ep | 2014-05-25 | 13.22 | 2 | 13 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 847 | 781 | 1027 | 1432 |
SVK | Slovakia | ep | 2014-05-25 | 7.75 | 2 | 13 | SDKU-DS | Slovenská demokratická a kresťanská únia – Demokratická strana | Slovak Democratic and Christian Union -- Democratic Party | 7.3591 | 1 | 847 | 781 | 1027 | 131 |
SVK | Slovakia | ep | 2014-05-25 | 5.83 | 1 | 13 | MH | Most-Híd | Most-Hid | 7.4 | 1 | 847 | 781 | 1027 | 1620 |
SVK | Slovakia | ep | 2014-05-25 | 6.67 | 1 | 13 | SaS | Sloboda a solidarita | Freedom and Solidarity | 6.0 | 1 | 847 | 781 | 1027 | 1460 |
SVK | Slovakia | ep | 2014-05-25 | 6.83 | 1 | 13 | OKS | Obcianska konzervatívna strana | Civic Conservative Party | 8.4211 | 1 | 847 | 781 | 1027 | 1645 |
SVK | Slovakia | ep | 2014-05-25 | 6.53 | 1 | 13 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 847 | 781 | 1027 | 559 |
SVK | Slovakia | ep | 2014-05-25 | 7.46 | 1 | 13 | OLaNO | Obyčajní ľudia a nezávislé osobnosti | Ordinary People and Independent | 7.4 | 1 | 847 | 781 | 1027 | 1759 |
SVK | Slovakia | ep | 2014-05-25 | 3.61 | 0 | 13 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 847 | 781 | 1027 | 1072 |
SVK | Slovakia | ep | 2014-05-25 | 1.52 | 0 | 13 | KSS | Komunistická strana Slovenska | Communist Party of Slovakia | 0.5275 | 1 | 847 | 781 | 1027 | 44 |
SVK | Slovakia | ep | 2014-05-25 | 1.74 | 0 | 13 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 847 | 781 | 1027 | 586 |
SVK | Slovakia | ep | 2014-05-25 | 1.49 | 0 | 13 | SDSS | Sociálnodemokratická strana Slovenska | Social Democratic Party of Slovakia | 4.8111 | 1 | 847 | 781 | 1027 | 1651 |
SVK | Slovakia | ep | 2014-05-25 | 1.66 | 0 | 13 | PaS | Právo a spravodlivost | Law and Justice | 1.3 | 1 | 847 | 781 | 1027 | 2389 |
SVK | Slovakia | ep | 2014-05-25 | 3.7 | 0 | 13 | TIP | Strana TIP – Tvoríme inú politiku | TIP Party -- We create another policy | 6.0 | 1 | 847 | 781 | 1027 | 2388 |
SVK | Slovakia | ep | 2014-05-25 | 1.19 | 0 | 13 | MS | Magnificat Slovakia | Beautiful Slovakia | 6.2 | 1 | 847 | 781 | 1027 | 2390 |
SVK | Slovakia | ep | 2014-05-25 | 1.38 | 0 | 13 | NaS-NS | Národ a spravodlivosť – Naša strana | Nation and Justice -- Our Party | 8.8 | 1 | 847 | 781 | 1027 | 2391 |
SVK | Slovakia | parliament | 2016-03-06 | 28.28 | 49 | 150 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 1003 | 781 | 1027 | 220 |
SVK | Slovakia | parliament | 2016-03-06 | 12.1 | 21 | 150 | SaS | Sloboda a solidarita | Freedom and Solidarity | 6.0 | 1 | 1003 | 781 | 1027 | 1460 |
SVK | Slovakia | parliament | 2016-03-06 | 11.03 | 19 | 150 | OLaNO | Obyčajní ľudia a nezávislé osobnosti | Ordinary People and Independent | 7.4 | 1 | 1003 | 781 | 1027 | 1759 |
SVK | Slovakia | parliament | 2016-03-06 | 8.64 | 15 | 150 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 1003 | 781 | 1027 | 1072 |
SVK | Slovakia | parliament | 2016-03-06 | 8.04 | 14 | 150 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 1003 | 781 | 1027 | 586 |
SVK | Slovakia | parliament | 2016-03-06 | 6.63 | 11 | 150 | SR | Sme Rodina – Boris Kollár | We are family -- Boris Kollar | 8.8 | 1 | 1003 | 781 | 1027 | 2623 |
SVK | Slovakia | parliament | 2016-03-06 | 6.5 | 11 | 150 | MH | Most-Híd | Most-Hid | 7.4 | 1 | 1003 | 781 | 1027 | 1620 |
SVK | Slovakia | parliament | 2016-03-06 | 5.61 | 10 | 150 | S | Sieť | Network | 7.4 | 1 | 1003 | 781 | 1027 | 2624 |
SVK | Slovakia | parliament | 2016-03-06 | 4.94 | 0 | 150 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 1003 | 781 | 1027 | 1432 |
SVK | Slovakia | parliament | 2016-03-06 | 4.05 | 0 | 150 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 1003 | 781 | 1027 | 559 |
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 |
SVK | Slovakia | parliament | 2020-02-29 | 25.02 | 53 | 150 | OLaNO | Obyčajní ľudia a nezávislé osobnosti | Ordinary People and Independent | 7.4 | 1 | 1089 | 1003 | 1529 | 1759 |
SVK | Slovakia | parliament | 2020-02-29 | 18.29 | 38 | 150 | Smer | Smer – sociálna demokracia | Direction -- Social Democracy | 3.3799 | 1 | 1089 | 1003 | 1529 | 220 |
SVK | Slovakia | parliament | 2020-02-29 | 8.24 | 17 | 150 | SR | Sme Rodina – Boris Kollár | We are family -- Boris Kollar | 8.8 | 1 | 1089 | 1003 | 1529 | 2623 |
SVK | Slovakia | parliament | 2020-02-29 | 7.97 | 17 | 150 | LsNS | Ľudová strana Naše Slovensko | People's Party Our Slovakia | 8.8 | 1 | 1089 | 1003 | 1529 | 586 |
SVK | Slovakia | parliament | 2020-02-29 | 6.22 | 13 | 150 | SaS | Sloboda a solidarita | Freedom and Solidarity | 6.0 | 1 | 1089 | 1003 | 1529 | 1460 |
SVK | Slovakia | parliament | 2020-02-29 | 5.77 | 12 | 150 | ZAL | Za ľudí | For the People | 6.0 | 1 | 1089 | 1003 | 1529 | 2796 |
SVK | Slovakia | parliament | 2020-02-29 | 6.96 | 0 | 150 | PS | Progresívne Slovensko | Progressive Slovakia | 6.0 | 1 | 1089 | 1003 | 1529 | 2751 |
SVK | Slovakia | parliament | 2020-02-29 | 0 | 150 | SPOLU | SPOLU – občianska demokracia | TOGETHER -- Civic Democracy | 6.0 | 1 | 1089 | 1003 | 1529 | 2752 | |
SVK | Slovakia | parliament | 2020-02-29 | 4.65 | 0 | 150 | KDH | Kresťanskodemokratické hnutie | Christian Democratic Movement | 7.1082 | 1 | 1089 | 1003 | 1529 | 1432 |
SVK | Slovakia | parliament | 2020-02-29 | 3.9 | 0 | 150 | MK | Maďarskej koalície – Magyar koalíció | Hungarian Coalition | 6.5005 | 1 | 1089 | 1003 | 1529 | 559 |
SVK | Slovakia | parliament | 2020-02-29 | 3.16 | 0 | 150 | SNS | Slovenská národná strana | Slovak National Party | 7.0198 | 1 | 1089 | 1003 | 1529 | 1072 |
SVK | Slovakia | parliament | 2020-02-29 | 2.05 | 0 | 150 | MH | Most-Híd | Most-Hid | 7.4 | 1 | 1089 | 1003 | 1529 | 1620 |
SVK | Slovakia | parliament | 2020-02-29 | 3.06 | 0 | 150 | DV | Dobrá voľba | Good Choice | 3.3 | 1 | 1089 | 1003 | 1529 | 2797 |
SVK | Slovakia | parliament | 2020-02-29 | 2.93 | 0 | 150 | V | Vlasť | Homeland | 8.8 | 1 | 1089 | 1003 | 1529 | 2798 |
JPN | Japan | parliament | 1946-04-10 | 25.4 | 148 | 464 | JLP | Nihon Jiyūtō | Japan Liberal Party | 7.4 | 5 | 697 | 1726 | ||
JPN | Japan | parliament | 1946-04-10 | 20.3 | 110 | 464 | DP | Minshutō | Democratic Party | 7.4 | 5 | 697 | 1734 | ||
JPN | Japan | parliament | 1946-04-10 | 18.2 | 96 | 464 | JSP | Nihon Shakai-tō | Japan Socialist Party | 2.6344 | 5 | 697 | 940 | ||
JPN | Japan | parliament | 1946-04-10 | 6.3 | 45 | 464 | NCoP | Kokumin Kyôdô Tô | National Cooperative Party | 6.0 | 5 | 697 | 1733 | ||
JPN | Japan | parliament | 1946-04-10 | 33 | 464 | etc | others | others | 5 | 697 | 1055 | ||||
JPN | Japan | parliament | 1946-04-10 | 14.0 | 26 | 464 | none | no party affiliation | no party affiliation | 5 | 697 | 905 | |||
JPN | Japan | parliament | 1946-04-10 | 3.8 | 6 | 464 | JCP | Nihon Kyōsan-tō | Japan Communist Party | 1.148 | 5 | 697 | 1540 | ||
JPN | Japan | parliament | 1947-04-25 | 26.2 | 143 | 466 | JSP | Nihon Shakai-tō | Japan Socialist Party | 2.6344 | 5 | 696 | 697 | 891 | 940 |
JPN | Japan | parliament | 1947-04-25 | 26.7 | 131 | 466 | JLP | Nihon Jiyūtō | Japan Liberal Party | 7.4 | 5 | 696 | 697 | 891 | 1726 |
JPN | Japan | parliament | 1947-04-25 | 25.4 | 124 | 466 | DP | Minshutō | Democratic Party | 7.4 | 5 | 696 | 697 | 891 | 1734 |
JPN | Japan | parliament | 1947-04-25 | 33 | 466 | etc | others | others | 5 | 696 | 697 | 891 | 1055 | ||
JPN | Japan | parliament | 1947-04-25 | 7.0 | 31 | 466 | NCoP | Kokumin Kyôdô Tô | National Cooperative Party | 6.0 | 5 | 696 | 697 | 891 | 1733 |
JPN | Japan | parliament | 1947-04-25 | 3.7 | 4 | 466 | JCP | Nihon Kyōsan-tō | Japan Communist Party | 1.148 | 5 | 696 | 697 | 891 | 1540 |
JPN | Japan | parliament | 1949-01-23 | 43.9 | 264 | 466 | JLP | Nihon Jiyūtō | Japan Liberal Party | 7.4 | 5 | 695 | 696 | 894 | 1726 |
JPN | Japan | parliament | 1949-01-23 | 15.7 | 69 | 466 | DP | Minshutō | Democratic Party | 7.4 | 5 | 695 | 696 | 894 | 1734 |
JPN | Japan | parliament | 1949-01-23 | 13.5 | 48 | 466 | JSP | Nihon Shakai-tō | Japan Socialist Party | 2.6344 | 5 | 695 | 696 | 894 | 940 |
JPN | Japan | parliament | 1949-01-23 | 9.8 | 35 | 466 | JCP | Nihon Kyōsan-tō | Japan Communist Party | 1.148 | 5 | 695 | 696 | 894 | 1540 |
JPN | Japan | parliament | 1949-01-23 | 24 | 466 | etc | others | others | 5 | 695 | 696 | 894 | 1055 | ||
JPN | Japan | parliament | 1949-01-23 | 3.4 | 14 | 466 | NCoP | Kokumin Kyôdô Tô | National Cooperative Party | 6.0 | 5 | 695 | 696 | 894 | 1733 |
JPN | Japan | parliament | 1949-01-23 | 2.0 | 7 | 466 | LFP | Rōdōnōmintō | Labour Farmer Party | 1.3 | 5 | 695 | 696 | 894 | 1736 |
JPN | Japan | parliament | 1949-01-23 | 1.3 | 5 | 466 | SRP | Yakaikakushintou zu | Social Reform Party | 1.3 | 5 | 695 | 696 | 894 | 1737 |
JPN | Japan | parliament | 1952-10-01 | 47.9 | 240 | 466 | JLP | Nihon Jiyūtō | Japan Liberal Party | 7.4 | 5 | 694 | 695 | 895 | 1726 |
JPN | Japan | parliament | 1952-10-01 | 18.2 | 85 | 466 | DP | Minshutō | Democratic Party | 7.4 | 5 | 694 | 695 | 895 | 1734 |
JPN | Japan | parliament | 1952-10-01 | 11.4 | 57 | 466 | RWSP | Uha Shakai Tô | Right Wing Socialist Party | 3.3 | 5 | 694 | 695 | 895 | 1724 |
JPN | Japan | parliament | 1952-10-01 | 9.9 | 54 | 466 | LWSP | Saha Shakai Tô | Left Wing Socialist Party | 1.3 | 5 | 694 | 695 | 895 | 1723 |
JPN | Japan | parliament | 1952-10-01 | 24 | 466 | etc | others | others | 5 | 694 | 695 | 895 | 1055 | ||
JPN | Japan | parliament | 1952-10-01 | 0.7 | 4 | 466 | LFP | Rōdōnōmintō | Labour Farmer Party | 1.3 | 5 | 694 | 695 | 895 | 1736 |
JPN | Japan | parliament | 1952-10-01 | 1.1 | 2 | 466 | CoP | Kyoudoutou | Cooperative Party | 3.3 | 5 | 694 | 695 | 895 | 1738 |
JPN | Japan | parliament | 1952-10-01 | 2.5 | 0 | 466 | JCP | Nihon Kyōsan-tō | Japan Communist Party | 1.148 | 5 | 694 | 695 | 895 | 1540 |
JPN | Japan | parliament | 1953-04-19 | 38.9 | 199 | 466 | JLP | Nihon Jiyūtō | Japan Liberal Party | 7.4 | 5 | 693 | 694 | 896 | 1726 |
JPN | Japan | parliament | 1953-04-19 | 17.9 | 76 | 466 | DP | Minshutō | Democratic Party | 7.4 | 5 | 693 | 694 | 896 | 1734 |
JPN | Japan | parliament | 1953-04-19 | 13.1 | 72 | 466 | LWSP | Saha Shakai Tô | Left Wing Socialist Party | 1.3 | 5 | 693 | 694 | 896 | 1723 |
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;