view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by vote_share
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GBR | United Kingdom | parliament | 1970-06-18 | 1 | 630 | etc | others | others | 44 | 311 | 583 | 733 | 453 | ||
GBR | United Kingdom | parliament | 1974-02-28 | 7 | 635 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 568 | 311 | 216 | 1210 | |
GBR | United Kingdom | parliament | 1974-02-28 | 3 | 635 | VUPP | Vanguard Unionist Progressive Party | Vanguard Unionist Progressive Party | 8.8 | 44 | 568 | 311 | 216 | 646 | |
GBR | United Kingdom | parliament | 1974-02-28 | 2 | 635 | etc | others | others | 44 | 568 | 311 | 216 | 453 | ||
GBR | United Kingdom | parliament | 1974-02-28 | 1 | 635 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 568 | 311 | 216 | 319 | |
GBR | United Kingdom | parliament | 1974-10-10 | 6 | 635 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 40 | 568 | 419 | 1210 | |
GBR | United Kingdom | parliament | 1974-10-10 | 3 | 635 | VUPP | Vanguard Unionist Progressive Party | Vanguard Unionist Progressive Party | 8.8 | 44 | 40 | 568 | 419 | 646 | |
GBR | United Kingdom | parliament | 1974-10-10 | 1 | 635 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 40 | 568 | 419 | 319 | |
GBR | United Kingdom | parliament | 1974-10-10 | 1 | 635 | none | no party affiliation | no party affiliation | 44 | 40 | 568 | 419 | 1599 | ||
GBR | United Kingdom | parliament | 1979-05-03 | 2 | 635 | etc | others | others | 44 | 243 | 40 | 590 | 453 | ||
GBR | United Kingdom | parliament | 1983-06-09 | 6 | 650 | SDP | Social Democratic Party | Social Democratic Party | 4.6 | 44 | 290 | 243 | 273 | 1547 | |
GBR | United Kingdom | parliament | 1987-06-11 | 5 | 650 | SDP | Social Democratic Party | Social Democratic Party | 4.6 | 44 | 490 | 290 | 646 | 1547 | |
GBR | United Kingdom | parliament | 1997-05-01 | 1 | 659 | etc | others | others | 44 | 315 | 514 | 678 | 453 | ||
GBR | United Kingdom | parliament | 2001-06-07 | 2 | 659 | etc | others | others | 44 | 208 | 315 | 838 | 453 | ||
GBR | United Kingdom | parliament | 2005-05-05 | 3 | 646 | etc | others | others | 44 | 233 | 208 | 19 | 453 | ||
GBR | United Kingdom | parliament | 2010-05-06 | 1 | 650 | etc | others | others | 44 | 582 | 233 | 119 | 453 | ||
GRC | Greece | parliament | 1977-11-20 | 1 | 300 | EDA | Eniaia Dimokratiki Aristera | United Democratic Left | 1.3 | 41 | 596 | 653 | 609 | 597 | |
GRC | Greece | ep | 1981-01-01 | 15 | 24 | ND | Néa Đimokratía | New Democracy | 6.7365 | 41 | 245 | 596 | 531 | 47 | |
GRC | Greece | ep | 1981-01-01 | 7 | 24 | PASOK | Panellinio Sosialistikó Kínima | Panhellenic Socialist Movement | 4.4968 | 41 | 245 | 596 | 531 | 1338 | |
GRC | Greece | ep | 1981-01-01 | 1 | 24 | KKE | Kommounistikó Kómma Elládas | Communist Party of Greece | 1.253 | 41 | 245 | 596 | 531 | 614 | |
GRC | Greece | ep | 1981-01-01 | 1 | 24 | EDIK | Enosi Dimokratikou Kentrou | Union of the Democratic Centre | 6.0 | 41 | 245 | 596 | 531 | 489 | |
GRC | Greece | parliament | 1990-04-08 | 4 | 300 | none | no party affiliation | no party affiliation | 41 | 284 | 508 | 716 | 1358 | ||
GRC | Greece | parliament | 2004-03-07 | 6 | 300 | SYN | Synaspismós tīs Aristerás | Coalition of the Left | 2.7683 | 41 | 201 | 475 | 190 | 1441 | |
HRV | Croatia | parliament | 2000-01-03 | 24 | 151 | HSLS | Hrvatska socijalno liberalna stranka | Croatian Social Liberal Party | 7.193 | 62 | 797 | 1102 | |||
HRV | Croatia | parliament | 2000-01-03 | 4 | 151 | IDS | Istarski demokratski sabor | Istrian Democratic Assembly | 3.4211 | 62 | 797 | 1627 | |||
HRV | Croatia | parliament | 2000-01-03 | 2 | 151 | PGS | Primorsko goranski savez | Alliance of Primorje-Gorski | 62 | 797 | 2196 | ||||
HRV | Croatia | parliament | 2000-01-03 | 2 | 151 | HNS-LD | Hrvatska narodna stranka – Liberalni demokrati | Croatian People's Party -- Liberal Democrats | 1.8421 | 62 | 797 | 1384 | |||
HRV | Croatia | parliament | 2000-01-03 | 2 | 151 | LS | Liberalna stranka | Liberal Party | 2.807 | 62 | 797 | 1457 | |||
HRV | Croatia | parliament | 2000-01-03 | 1 | 151 | one-seat | one seat | one seat | 62 | 797 | 2295 | ||||
HRV | Croatia | parliament | 2000-01-03 | 1 | 151 | ethnic | ethnic | ethnic | 62 | 797 | 2192 | ||||
HRV | Croatia | parliament | 2003-11-23 | 4 | 152 | IDS | Istarski demokratski sabor | Istrian Democratic Assembly | 3.4211 | 62 | 795 | 797 | 1051 | 1627 | |
HRV | Croatia | parliament | 2003-11-23 | 3 | 152 | LIBRA | LIBRA – Stranka liberalnih demokrata | Party of Liberal Democrats | 3.7719 | 62 | 795 | 797 | 1051 | 90 | |
HRV | Croatia | parliament | 2003-11-23 | 3 | 152 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 795 | 797 | 1051 | 2133 | |
HRV | Croatia | parliament | 2003-11-23 | 2 | 152 | LS | Liberalna stranka | Liberal Party | 2.807 | 62 | 795 | 797 | 1051 | 1457 | |
HRV | Croatia | parliament | 2003-11-23 | 1 | 152 | PGS | Primorsko goranski savez | Alliance of Primorje-Gorski | 62 | 795 | 797 | 1051 | 2196 | ||
HRV | Croatia | parliament | 2003-11-23 | 1 | 152 | SDA | Stranka demokratske akcije Hrvatske | Party of Democratic Action of Croatia | 7.4 | 62 | 795 | 797 | 1051 | 2270 | |
HRV | Croatia | parliament | 2007-11-25 | 4 | 153 | ethnic | ethnic | ethnic | 62 | 793 | 795 | 1053 | 2192 | ||
HRV | Croatia | parliament | 2007-11-25 | 2 | 153 | HSLS | Hrvatska socijalno liberalna stranka | Croatian Social Liberal Party | 7.193 | 62 | 793 | 795 | 1053 | 1102 | |
HRV | Croatia | parliament | 2007-11-25 | 1 | 153 | SDA | Stranka demokratske akcije Hrvatske | Party of Democratic Action of Croatia | 7.4 | 62 | 793 | 795 | 1053 | 2270 | |
HRV | Croatia | parliament | 2011-12-04 | 13 | 151 | HNS-LD | Hrvatska narodna stranka – Liberalni demokrati | Croatian People's Party -- Liberal Democrats | 1.8421 | 62 | 792 | 793 | 1057 | 1384 | |
HRV | Croatia | parliament | 2011-12-04 | 5 | 151 | ethnic | ethnic | ethnic | 62 | 792 | 793 | 1057 | 2192 | ||
HRV | Croatia | parliament | 2011-12-04 | 3 | 151 | abroad | abroad | abroad | 62 | 792 | 793 | 1057 | 2191 | ||
HRV | Croatia | parliament | 2011-12-04 | 3 | 151 | IDS | Istarski demokratski sabor | Istrian Democratic Assembly | 3.4211 | 62 | 792 | 793 | 1057 | 1627 | |
HRV | Croatia | parliament | 2011-12-04 | 3 | 151 | HSU | Hrvatska stranka umirovljenika | Croatian Party of Pensioners | 62 | 792 | 793 | 1057 | 2134 | ||
HRV | Croatia | parliament | 2011-12-04 | 3 | 151 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 792 | 793 | 1057 | 2133 | |
HRV | Croatia | parliament | 2011-12-04 | 2 | 151 | HGS | Hrvatska građanska stranka | Croatian Civic Party | 8.8 | 62 | 792 | 793 | 1057 | 2193 | |
HRV | Croatia | parliament | 2011-12-04 | 1 | 151 | DC | Demokratski centar | Democratic Centre | 5.9649 | 62 | 792 | 793 | 1057 | 1081 | |
HRV | Croatia | ep | 2013-04-14 | 1 | 12 | HSP-AS | Hrvatska stranka prava dr. Ante Starčević | Croatian Party of Rights -- Dr. Ante Starcevic | 8.8 | 62 | 791 | 792 | 1056 | 2181 | |
HRV | Croatia | parliament | 2015-11-08 | 9 | 151 | HNS-LD | Hrvatska narodna stranka – Liberalni demokrati | Croatian People's Party -- Liberal Democrats | 1.8421 | 62 | 1001 | 792 | 1056 | 1384 | |
HRV | Croatia | parliament | 2015-11-08 | 3 | 151 | HSP-AS | Hrvatska stranka prava dr. Ante Starčević | Croatian Party of Rights -- Dr. Ante Starcevic | 8.8 | 62 | 1001 | 792 | 1056 | 2181 | |
HRV | Croatia | parliament | 2015-11-08 | 3 | 151 | HL-LR | Hrvatski laburisti – Stranka rada | Croatian Labourists -- Labour Party | 1.3 | 62 | 1001 | 792 | 1056 | 2182 | |
HRV | Croatia | parliament | 2015-11-08 | 3 | 151 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 1001 | 792 | 1056 | 2133 | |
HRV | Croatia | parliament | 2015-11-08 | 2 | 151 | HSLS | Hrvatska socijalno liberalna stranka | Croatian Social Liberal Party | 7.193 | 62 | 1001 | 792 | 1056 | 1102 | |
HRV | Croatia | parliament | 2015-11-08 | 2 | 151 | HSU | Hrvatska stranka umirovljenika | Croatian Party of Pensioners | 62 | 1001 | 792 | 1056 | 2134 | ||
HRV | Croatia | parliament | 2015-11-08 | 2 | 151 | one-seat | one seat | one seat | 62 | 1001 | 792 | 1056 | 2295 | ||
HRV | Croatia | parliament | 2015-11-08 | 1 | 151 | HSS | Hrvatska seljačka stranka | Croatian Peasant Party | 6.2281 | 62 | 1001 | 792 | 1056 | 1465 | |
HRV | Croatia | parliament | 2015-11-08 | 1 | 151 | Hrast | Hrvatski rast | Croatian Growth | 6.2 | 62 | 1001 | 792 | 1056 | 2185 | |
HRV | Croatia | parliament | 2016-09-11 | 9 | 151 | HNS-LD | Hrvatska narodna stranka – Liberalni demokrati | Croatian People's Party -- Liberal Democrats | 1.8421 | 62 | 1007 | 1001 | 1408 | 1384 | |
HRV | Croatia | parliament | 2016-09-11 | 5 | 151 | HSS | Hrvatska seljačka stranka | Croatian Peasant Party | 6.2281 | 62 | 1007 | 1001 | 1408 | 1465 | |
HRV | Croatia | parliament | 2016-09-11 | 3 | 151 | SDSS | Samostalna demokratska srpska stranka | Independent Democratic Serb Party | 3.3 | 62 | 1007 | 1001 | 1408 | 2133 | |
HRV | Croatia | parliament | 2016-09-11 | 1 | 151 | HSU | Hrvatska stranka umirovljenika | Croatian Party of Pensioners | 62 | 1007 | 1001 | 1408 | 2134 | ||
HUN | Hungary | parliament | 2002-04-21 | 24 | 386 | MDF | Magyar Demokrata Fórum | Hungarian Democratic Forum | 6.4826 | 39 | 463 | 671 | 827 | 546 | |
HUN | Hungary | parliament | 2006-04-09 | 141 | 386 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 194 | 463 | 188 | 921 | |
HUN | Hungary | parliament | 2006-04-09 | 23 | 386 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 194 | 463 | 188 | 434 | |
HUN | Hungary | parliament | 2006-04-09 | 1 | 386 | one-seat | one seat | one seat | 39 | 194 | 463 | 188 | 952 | ||
HUN | Hungary | ep | 2009-06-07 | 13 | 22 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 249 | 194 | 162 | 921 | |
HUN | Hungary | ep | 2009-06-07 | 1 | 22 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 249 | 194 | 162 | 434 | |
HUN | Hungary | parliament | 2010-04-25 | 227 | 386 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 688 | 194 | 162 | 921 | |
HUN | Hungary | parliament | 2010-04-25 | 36 | 386 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 688 | 194 | 162 | 434 | |
HUN | Hungary | parliament | 2010-04-25 | 1 | 386 | none | független | no party affiliation | 39 | 688 | 194 | 162 | 1617 | ||
HUN | Hungary | parliament | 2014-04-06 | 117 | 199 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 814 | 688 | 846 | 921 | |
HUN | Hungary | parliament | 2014-04-06 | 16 | 199 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 814 | 688 | 846 | 434 | |
HUN | Hungary | parliament | 2014-04-06 | 4 | 199 | DK | Demokratikus Koalíció | Democratic Coalition | 3.3 | 39 | 814 | 688 | 846 | 1970 | |
HUN | Hungary | parliament | 2014-04-06 | 3 | 199 | Egyutt | Együtt – A Korszakváltók Pártja | Together -- Party for a New Era | 3.3 | 39 | 814 | 688 | 846 | 2318 | |
HUN | Hungary | parliament | 2014-04-06 | 1 | 199 | one-seat | one seat | one seat | 39 | 814 | 688 | 846 | 952 | ||
HUN | Hungary | parliament | 2014-04-06 | 1 | 199 | PM | Párbeszéd Magyarországért | Dialogue for Hungary | 2.5 | 39 | 814 | 688 | 846 | 2349 | |
HUN | Hungary | ep | 2014-05-25 | 11 | 21 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 827 | 814 | 1104 | 921 | |
HUN | Hungary | ep | 2014-05-25 | 1 | 21 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 827 | 814 | 1104 | 434 | |
HUN | Hungary | parliament | 2018-04-08 | 117 | 199 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 1023 | 814 | 1104 | 921 | |
HUN | Hungary | parliament | 2018-04-08 | 16 | 199 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 1023 | 814 | 1104 | 434 | |
HUN | Hungary | parliament | 2018-04-08 | 1 | 199 | FKgP | Független Kisgazda Párt | Independent Small Holders Party | 9.0186 | 39 | 1023 | 814 | 1104 | 870 | |
HUN | Hungary | ep | 2019-05-26 | 12 | 21 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 1076 | 1023 | 1531 | 921 | |
HUN | Hungary | ep | 2019-05-26 | 1 | 21 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 1076 | 1023 | 1531 | 434 | |
HUN | Hungary | parliament | 2022-04-03 | 117 | 199 | Fi-MPSz | Fidesz – Magyar Polgári Szövetség | Fidesz -- Hungarian Civic Union | 6.5432 | 39 | 1107 | 1023 | 1531 | 921 | |
HUN | Hungary | parliament | 2022-04-03 | 18 | 199 | KDNP | Kereszténydemokrata Néppárt | Christian Democratic People's Party | 7.4 | 39 | 1107 | 1023 | 1531 | 434 | |
HUN | Hungary | parliament | 2022-04-03 | 10 | 199 | MSZP | Magyar Szocialista Párt | Hungarian Socialist Party | 2.8743 | 39 | 1107 | 1023 | 1531 | 1591 | |
HUN | Hungary | parliament | 2022-04-03 | 10 | 199 | Jobbik | Jobbik Magyarországért Mozgalom | Jobbik Movement for a Better Hungary | 8.8 | 39 | 1107 | 1023 | 1531 | 600 | |
HUN | Hungary | parliament | 2022-04-03 | 10 | 199 | MM | Momentum Mozgalom | Momentum Movement | 7.4 | 39 | 1107 | 1023 | 1531 | 2659 | |
HUN | Hungary | parliament | 2022-04-03 | 6 | 199 | PM | Párbeszéd Magyarországért | Dialogue for Hungary | 2.5 | 39 | 1107 | 1023 | 1531 | 2349 | |
HUN | Hungary | parliament | 2022-04-03 | 5 | 199 | LMP | Lehet Más a Politika | Politics Can Be Different | 2.5 | 39 | 1107 | 1023 | 1531 | 403 | |
HUN | Hungary | parliament | 2022-04-03 | 1 | 199 | one-seat | one seat | one seat | 39 | 1107 | 1023 | 1531 | 952 | ||
HUN | Hungary | parliament | 2022-04-03 | 1 | 199 | none | független | no party affiliation | 39 | 1107 | 1023 | 1531 | 1617 | ||
IRL | Ireland | parliament | 1948-02-04 | 12 | 147 | none | no party affiliation | no party affiliation | 37 | 60 | 122 | 151 | 30 | ||
IRL | Ireland | parliament | 1951-05-30 | 14 | 147 | none | no party affiliation | no party affiliation | 37 | 515 | 60 | 154 | 30 | ||
IRL | Ireland | parliament | 1954-05-18 | 5 | 147 | none | no party affiliation | no party affiliation | 37 | 584 | 515 | 643 | 30 | ||
IRL | Ireland | parliament | 1957-03-05 | 9 | 147 | none | no party affiliation | no party affiliation | 37 | 469 | 584 | 626 | 30 | ||
IRL | Ireland | parliament | 1961-10-04 | 6 | 144 | none | no party affiliation | no party affiliation | 37 | 413 | 469 | 364 | 30 | ||
IRL | Ireland | parliament | 1965-04-07 | 2 | 144 | none | no party affiliation | no party affiliation | 37 | 323 | 413 | 667 | 30 | ||
IRL | Ireland | parliament | 1969-06-18 | 1 | 144 | none | no party affiliation | no party affiliation | 37 | 641 | 323 | 602 | 30 | ||
IRL | Ireland | parliament | 1973-02-28 | 2 | 144 | none | no party affiliation | no party affiliation | 37 | 283 | 641 | 863 | 30 |
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;