view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by election_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CHE | Switzerland | parliament | 1955-10-30 | 2.6 | 4 | 196 | PdA | Partei der Arbeit der Schweiz | Swiss Party of Labour | 0.5263 | 40 | 30 | 21 | 814 | 1167 |
CHE | Switzerland | parliament | 1955-10-30 | 1.1 | 1 | 196 | EVP-PEP | Evangelische Volkspartei der Schweiz – Parti Populaire Evangelique Suisse | Protestant Peoples Party | 4.9248 | 40 | 30 | 21 | 814 | 602 |
CHE | Switzerland | parliament | 1955-10-30 | 0.35 | 0 | 196 | LF/PEB | Liberalsozialistische Partei / Freiwirtschaftliche Bewegung – Parti d'économie franche | Liberal Socialist Party | 6.0 | 40 | 30 | 21 | 814 | 1960 |
BGR | Bulgaria | parliament | 1991-10-13 | 34.36 | 110 | 240 | SDS | Suyuz na Demokratichnite Sili | Union of Democratic Forces | 6.1111 | 10 | 32 | 423 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 33.14 | 106 | 240 | KzB|DL | Koalitsiya za Balgariya | Demokratichna Levitsa | Coalition for Bulgaria | Democratic Left | 2.8982 | 10 | 32 | 1160 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 7.55 | 24 | 240 | DPS | Dvizhenie za Prava i Svobodi | Movement for Rights and Freedoms | 4.5828 | 10 | 32 | 1286 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 3.86 | 0 | 240 | ZNS | Zemedelski Naroden Suyuz | Agrarian People's Union | 5.5263 | 10 | 32 | 353 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 3.44 | 0 | 240 | BZNS-NP | Balgarski Zemedelski Naroden Suyuz – "Nikola Petkov" | Bulgarian Agrarian National Union -- "Nikola Petkov" | 5.3 | 10 | 32 | 2173 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 3.2 | 0 | 240 | SDS-ts | Suyuz na Demokratichnite Sili – Tsentur | Union of Democratic Forces -- Centre | 3.3 | 10 | 32 | 2174 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 1.82 | 0 | 240 | FTB | Federatsiya Tsarstvo Balgariya | Kingdom of Bulgaria Confederation | 10 | 32 | 800 | |||
BGR | Bulgaria | parliament | 1991-10-13 | 1.32 | 0 | 240 | BBB | Balgarski Biznes Blok | Bulgarian Business Bloc | 6.6784 | 10 | 32 | 599 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 1.13 | 0 | 240 | BNRP | Balgarska Natsionalnoradikalna Partiya | Bulgarian National Radical Party | 8.8 | 10 | 32 | 364 | ||
BGR | Bulgaria | parliament | 1991-10-13 | 2.81 | 0 | 240 | SDS-l | Suyuz na Demokratichnite Sili – Liberali | Union of Democratic Forces -- Liberal | 6.0 | 10 | 32 | 2175 | ||
SWE | Sweden | parliament | 1998-09-20 | 36.38 | 131 | 349 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 33 | 412 | 156 | 904 |
SWE | Sweden | parliament | 1998-09-20 | 22.9 | 82 | 349 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 33 | 412 | 156 | 657 |
SWE | Sweden | parliament | 1998-09-20 | 11.99 | 43 | 349 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 33 | 412 | 156 | 882 |
SWE | Sweden | parliament | 1998-09-20 | 11.76 | 42 | 349 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 33 | 412 | 156 | 282 |
SWE | Sweden | parliament | 1998-09-20 | 5.12 | 18 | 349 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 33 | 412 | 156 | 1461 |
SWE | Sweden | parliament | 1998-09-20 | 4.71 | 17 | 349 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 33 | 412 | 156 | 892 |
SWE | Sweden | parliament | 1998-09-20 | 4.49 | 16 | 349 | MP | Miljöpartiet de Gröna | Greens | 3.3789 | 35 | 33 | 412 | 156 | 1154 |
SWE | Sweden | parliament | 1998-09-20 | 1.0 | 0 | 349 | SPI | Sveriges pensionärers intresseparti | Swedish Senior Citizen Interest Party | 35 | 33 | 412 | 156 | 407 | |
IRL | Ireland | ep | 1994-06-12 | 35.0 | 7 | 15 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 34 | 359 | 748 | 280 |
IRL | Ireland | ep | 1994-06-12 | 24.27 | 4 | 15 | FG | Fine Gael | Fine Gael (Familiy of the Irish) | 6.4372 | 37 | 34 | 359 | 748 | 1393 |
IRL | Ireland | ep | 1994-06-12 | 7.92 | 2 | 15 | Green | Green Party – Comhaontas Glas | Green Party | 2.435 | 37 | 34 | 359 | 748 | 1573 |
IRL | Ireland | ep | 1994-06-12 | 2.45 | 1 | 15 | I-PC | Independent – Pat Cox | Independent -- Pat Cox | 6.0 | 37 | 34 | 359 | 748 | 2328 |
IRL | Ireland | ep | 1994-06-12 | 10.99 | 1 | 15 | Lab | Labour Party | Labour Party | 3.6252 | 37 | 34 | 359 | 748 | 318 |
IRL | Ireland | ep | 1994-06-12 | 3.49 | 0 | 15 | DLP | Democratic Left | Democratic Left | 1.8889 | 37 | 34 | 359 | 748 | 1580 |
IRL | Ireland | ep | 1994-06-12 | 2.97 | 0 | 15 | SF | Sinn Féin | Sinn Fein | 2.7935 | 37 | 34 | 359 | 748 | 2217 |
IRL | Ireland | ep | 1994-06-12 | 1.94 | 0 | 15 | SFWP | Sinn Féin The Workers' Party | Sinn Fein The Workers' Party | 1.3 | 37 | 34 | 359 | 748 | 433 |
IRL | Ireland | ep | 1994-06-12 | 6.48 | 0 | 15 | PD | Progressive Democrats | Progressive Democrats | 8.0109 | 37 | 34 | 359 | 748 | 651 |
ISL | Iceland | parliament | 1946-06-30 | 39.5 | 20 | 52 | Sj | Sjálfstæðisflokkurinn | Independence Party | 7.4854 | 56 | 35 | 780 | 435 | 1342 |
ISL | Iceland | parliament | 1946-06-30 | 23.1 | 13 | 52 | F | Framsóknarflokkurinn | Progressive Party | 5.0365 | 56 | 35 | 780 | 435 | 1455 |
ISL | Iceland | parliament | 1946-06-30 | 19.5 | 10 | 52 | SA-S | Sameiningarflokkur alþýðu – Sósíalistaflokkurinn | United Socialist Party | 1.3 | 56 | 35 | 780 | 435 | 1319 |
ISL | Iceland | parliament | 1946-06-30 | 17.8 | 9 | 52 | A | Alþýðuflokkurinn | Social Democratic Party | 4.4444 | 56 | 35 | 780 | 435 | 228 |
ISL | Iceland | parliament | 2009-04-25 | 29.8 | 20 | 63 | Sam | Samfylkingin | Social Democratic Alliance | 4.0789 | 56 | 36 | 265 | 538 | 1006 |
ISL | Iceland | parliament | 2009-04-25 | 23.7 | 16 | 63 | Sj | Sjálfstæðisflokkurinn | Independence Party | 7.4854 | 56 | 36 | 265 | 538 | 1342 |
ISL | Iceland | parliament | 2009-04-25 | 21.7 | 14 | 63 | Graen | Vinstrihreyfingin – grænt framboð | Left-Green Movement | 1.1842 | 56 | 36 | 265 | 538 | 210 |
ISL | Iceland | parliament | 2009-04-25 | 14.8 | 9 | 63 | F | Framsóknarflokkurinn | Progressive Party | 5.0365 | 56 | 36 | 265 | 538 | 1455 |
ISL | Iceland | parliament | 2009-04-25 | 7.2 | 4 | 63 | B-H | Borgarahreyfingin – Hreyfingin | Civic Movement -- The Movement | 6.0 | 56 | 36 | 265 | 538 | 587 |
ISL | Iceland | parliament | 2009-04-25 | 2.2 | 0 | 63 | Ff | Frjálslyndi flokkurinn | Liberal Party | 6.2201 | 56 | 36 | 265 | 538 | 506 |
GBR | United Kingdom | ep | 1979-06-10 | 48.4 | 60 | 81 | Con | Conservatives | Conservatives | 7.4261 | 44 | 37 | 243 | 273 | 773 |
GBR | United Kingdom | ep | 1979-06-10 | 31.6 | 17 | 81 | Lab | Labour Party | Labour | 4.3562 | 44 | 37 | 243 | 273 | 1556 |
GBR | United Kingdom | ep | 1979-06-10 | 1.9 | 1 | 81 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 37 | 243 | 273 | 1284 |
GBR | United Kingdom | ep | 1979-06-10 | 0.9 | 1 | 81 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 37 | 243 | 273 | 1210 |
GBR | United Kingdom | ep | 1979-06-10 | 1.3 | 1 | 81 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 37 | 243 | 273 | 319 |
GBR | United Kingdom | ep | 1979-06-10 | 1.1 | 1 | 81 | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | 3.3 | 44 | 37 | 243 | 273 | 1023 |
GBR | United Kingdom | ep | 1979-06-10 | 12.6 | 0 | 81 | Lib | Liberals | Liberals | 4.2875 | 44 | 37 | 243 | 273 | 659 |
ESP | Spain | ep | 1986-01-01 | 36 | 60 | PSOE | Partido Socialista Obrero Español | Spanish Socialist Workers Party | 3.7377 | 27 | 38 | 85 | 238 | 902 | |
ESP | Spain | ep | 1986-01-01 | 17 | 60 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 38 | 85 | 238 | 645 | |
ESP | Spain | ep | 1986-01-01 | 7 | 60 | etc | others | others | 27 | 38 | 85 | 238 | 1377 | ||
CZE | Czech Republic | parliament | 1992-06-06 | 29.73 | 66 | 200 | ODS | Občanská demokratická strana | Civic Democratic Party | 7.3637 | 68 | 39 | 63 | 262 | 829 |
CZE | Czech Republic | parliament | 1992-06-06 | 14.05 | 35 | 200 | KSCM | Komunistická strana Cech a Moravy | Communist Party of Bohemia and Moravia | 0.7498 | 68 | 39 | 63 | 262 | 1173 |
CZE | Czech Republic | parliament | 1992-06-06 | 6.52 | 16 | 200 | LSU | Liberálně sociální unie | Liberal Social Union | 2.9667 | 68 | 39 | 63 | 262 | 1218 |
CZE | Czech Republic | parliament | 1992-06-06 | 6.53 | 16 | 200 | CSSD | Česká strana sociálně demokratická | Czech Social Democratic Party | 3.0463 | 68 | 39 | 63 | 262 | 789 |
CZE | Czech Republic | parliament | 1992-06-06 | 6.28 | 15 | 200 | KDU-CSL | Křesťanská a demokratická unie – Československá strana lidová | Christian Democratic Union -- People's Party | 5.8099 | 68 | 39 | 63 | 262 | 1245 |
CZE | Czech Republic | parliament | 1992-06-06 | 5.87 | 14 | 200 | HSD-SMS | Hnutí za samosprávnou demokracii – Společnost pro Moravu a Slezsko | Movement for Self-Governing Democracy -- Society for Moravia and Silesia | 68 | 39 | 63 | 262 | 19 | |
CZE | Czech Republic | parliament | 1992-06-06 | 5.93 | 14 | 200 | ODA | Občanská demokratická aliance | Civic Democratic Alliance | 7.1111 | 68 | 39 | 63 | 262 | 1123 |
CZE | Czech Republic | parliament | 1992-06-06 | 5.98 | 14 | 200 | SPR-RSC | Sdruzení pro republiku – Republikánská strana Ceskoslovenska | Rally for the Republic -- Republican Party of Czechoslovakia | 9.7778 | 68 | 39 | 63 | 262 | 872 |
CZE | Czech Republic | parliament | 1992-06-06 | 10 | 200 | KDS | Krestanskodemokraticka strana | Christian Democratic Party | 8.1444 | 68 | 39 | 63 | 262 | 440 | |
CZE | Czech Republic | parliament | 1992-06-06 | 4.59 | 0 | 200 | OH|SD | Obcanské hnuti | Svobodní Demokraté | Civic Movement | Free Democrats | 4.1667 | 68 | 39 | 63 | 262 | 574 |
CZE | Czech Republic | parliament | 1992-06-06 | 3.77 | 0 | 200 | DZJ | Důchodci za životní jistoty | Pensioners for a Secure Living | 3.3 | 68 | 39 | 63 | 262 | 77 |
CZE | Czech Republic | parliament | 1992-06-06 | 3.15 | 0 | 200 | SCPZR | Strana československých podnikatelů, živnostníků a rolníků | Czechoslovak Businessmen's, Traders' and Farmers' Party | 6.0 | 68 | 39 | 63 | 262 | 2219 |
CZE | Czech Republic | parliament | 1992-06-06 | 2.69 | 0 | 200 | KAN | Klub angazovaných nestraníku | Club of committed Non-Party Members | 6.0 | 68 | 39 | 63 | 262 | 2220 |
CZE | Czech Republic | parliament | 1992-06-06 | 1.37 | 0 | 200 | NEI | Nezávislá iniciativa | Independent Initiative | 68 | 39 | 63 | 262 | 2221 | |
CZE | Czech Republic | parliament | 1992-06-06 | 1.3 | 0 | 200 | SPP | Strana prátel piva | Party of the Friends of Beer | 68 | 39 | 63 | 262 | 2222 | |
CZE | Czech Republic | parliament | 1992-06-06 | 1.08 | 0 | 200 | HSS | Hnutí za sociální spravedlnost | Movement for Social Justice | 3.3 | 68 | 39 | 63 | 262 | 2223 |
GBR | United Kingdom | parliament | 1974-10-10 | 39.2 | 319 | 635 | Lab | Labour Party | Labour | 4.3562 | 44 | 40 | 568 | 419 | 1556 |
GBR | United Kingdom | parliament | 1974-10-10 | 35.8 | 277 | 635 | Con | Conservatives | Conservatives | 7.4261 | 44 | 40 | 568 | 419 | 773 |
GBR | United Kingdom | parliament | 1974-10-10 | 18.3 | 13 | 635 | Lib | Liberals | Liberals | 4.2875 | 44 | 40 | 568 | 419 | 659 |
GBR | United Kingdom | parliament | 1974-10-10 | 2.9 | 11 | 635 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 40 | 568 | 419 | 1284 |
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 | 0.6 | 3 | 635 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 40 | 568 | 419 | 311 |
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 | 0.5 | 1 | 635 | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | 3.3 | 44 | 40 | 568 | 419 | 1023 |
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 | 1974-10-10 | 0.4 | 0 | 635 | NF | National Front | National Front | 8.8 | 44 | 40 | 568 | 419 | 1126 |
GBR | United Kingdom | parliament | 1974-10-10 | 1.4 | 635 | UUUC | United Ulster Unionist Coalition | United Ulster Unionist Coalition | 44 | 40 | 568 | 419 | 1363 | ||
SWE | Sweden | parliament | 1964-09-20 | 47.3 | 113 | 233 | SAP | Socialdemokraterna | Social Democrats | 3.4447 | 35 | 41 | 295 | 424 | 904 |
SWE | Sweden | parliament | 1964-09-20 | 17.0 | 42 | 233 | FP | Folkpartiet | People's Party | 6.2906 | 35 | 41 | 295 | 424 | 892 |
SWE | Sweden | parliament | 1964-09-20 | 13.2 | 33 | 233 | C | Centerpartiet | Centre Party | 5.8084 | 35 | 41 | 295 | 424 | 1461 |
SWE | Sweden | parliament | 1964-09-20 | 13.7 | 32 | 233 | M | Moderaterna | Moderate Party | 7.8907 | 35 | 41 | 295 | 424 | 657 |
SWE | Sweden | parliament | 1964-09-20 | 5.2 | 8 | 233 | V | Vänsterpartiet (kommunisterna) | Left Party (Communists) | 1.5464 | 35 | 41 | 295 | 424 | 882 |
SWE | Sweden | parliament | 1964-09-20 | 1.5 | 3 | 233 | MbS | Medborgerlig samling | Citizens Coalition | 7.4 | 35 | 41 | 295 | 424 | 802 |
SWE | Sweden | parliament | 1964-09-20 | 0.3 | 2 | 233 | Mi | Mittenpartierna | Middle Parties | 6.0 | 35 | 41 | 295 | 424 | 1010 |
SWE | Sweden | parliament | 1964-09-20 | 1.8 | 0 | 233 | KD | Kristdemokraterna | Christian Democrats | 7.195 | 35 | 41 | 295 | 424 | 282 |
ESP | Spain | parliament | 1977-06-15 | 34.52 | 166 | 350 | UCD | Unión de Centro Democrático | Union of the Democratic Centre | 7.1 | 27 | 42 | 135 | ||
ESP | Spain | parliament | 1977-06-15 | 29.39 | 118 | 350 | PSOE | Partido Socialista Obrero Español | Spanish Socialist Workers Party | 3.7377 | 27 | 42 | 902 | ||
ESP | Spain | parliament | 1977-06-15 | 9.35 | 19 | 350 | PCE|IU | Partido Communista | Izquierda Unida | Communist Party | United Left | 2.0183 | 27 | 42 | 118 | ||
ESP | Spain | parliament | 1977-06-15 | 8.23 | 16 | 350 | AP-P | Alianza-Partido Popular | People's Alliance-Party | 7.5969 | 27 | 42 | 645 | ||
ESP | Spain | parliament | 1977-06-15 | 2.82 | 11 | 350 | CiU | Convergència i Unió | Convergence and Union | 6.2564 | 27 | 42 | 894 | ||
ESP | Spain | parliament | 1977-06-15 | 1.62 | 8 | 350 | PNV | Partido Nacionalista Vasco – Euzko Alderdi Jeltzalea | Basque Nationalist Party | 6.2144 | 27 | 42 | 1361 | ||
ESP | Spain | parliament | 1977-06-15 | 4.47 | 6 | 350 | PSP | Partido Socialista Popular | People's Socialist Party | 4.2083 | 27 | 42 | 1790 | ||
ESP | Spain | parliament | 1977-06-15 | 0.95 | 2 | 350 | UCDCC | Unió del Centre i la Democràcia Cristiana de Catalunya | Union of Centre and Christian Democracy of Catalonia | 6.2 | 27 | 42 | 62 | ||
ESP | Spain | parliament | 1977-06-15 | 0.2 | 1 | 350 | PAR | Partido Aragonés Regionalista | Aragonese Regionalist Party | 7.1909 | 27 | 42 | 1221 | ||
ESP | Spain | parliament | 1977-06-15 | 0.16 | 1 | 350 | etc | others | others | 27 | 42 | 1377 | |||
ESP | Spain | parliament | 1977-06-15 | 0.34 | 1 | 350 | EE | Euzkadiko Ezkerra | Basque Left | 2.4 | 27 | 42 | 1026 | ||
ESP | Spain | parliament | 1977-06-15 | 0.79 | 1 | 350 | ERC | Esquerra Republicana de Catalunya | Republican Left of Catalonia | 3.1072 | 27 | 42 | 757 | ||
ESP | Spain | parliament | 1977-06-15 | 1.18 | 0 | 350 | EDC | Coalición Electoral Equipo de la Democracia Cristiana | Electoral Coalition of Christian Democratic Team | 6.2 | 27 | 42 | 2084 | ||
IRL | Ireland | parliament | 1987-02-17 | 44.15 | 81 | 166 | FF | Fianna Fáil | Fianna Fail | 6.0713 | 37 | 43 | 307 | 867 | 280 |
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;