view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by seats_total descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
DEU | Germany | parliament | 2021-09-26 | 25.74 | 206 | 736 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 1096 | 1016 | 1528 | 558 |
DEU | Germany | parliament | 2021-09-26 | 18.9 | 152 | 736 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 1096 | 1016 | 1528 | 808 |
DEU | Germany | parliament | 2021-09-26 | 14.75 | 118 | 736 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 1096 | 1016 | 1528 | 772 |
DEU | Germany | parliament | 2021-09-26 | 11.46 | 92 | 736 | FDP | Freie Demokratische Partei | Free Democratic Party | 5.9233 | 54 | 1096 | 1016 | 1528 | 543 |
DEU | Germany | parliament | 2021-09-26 | 10.34 | 83 | 736 | AfD | Alternative für Deutschland | Alternative for Germany | 8.8 | 54 | 1096 | 1016 | 1528 | 2253 |
DEU | Germany | parliament | 2021-09-26 | 5.17 | 45 | 736 | CSU | Christlich Soziale Union | Christian Social Union | 7.2871 | 54 | 1096 | 1016 | 1528 | 1180 |
DEU | Germany | parliament | 2021-09-26 | 4.89 | 39 | 736 | PDS|Li | PDS | Die Linke | PDS | The Left | 1.2152 | 54 | 1096 | 1016 | 1528 | 791 |
DEU | Germany | parliament | 2021-09-26 | 0.12 | 1 | 736 | SSW | Südschleswigscher Wählerverband | South Schleswig Voter League | 54 | 1096 | 1016 | 1528 | 2850 | |
DEU | Germany | parliament | 2021-09-26 | 2.43 | 0 | 736 | FW | Freie Wähler | Free Voters | 7.4 | 54 | 1096 | 1016 | 1528 | 41 |
DEU | Germany | parliament | 2021-09-26 | 0.99 | 0 | 736 | PARTEI | Die PARTEI | The PARTY | 54 | 1096 | 1016 | 1528 | 2649 | |
DEU | Germany | parliament | 2021-09-26 | 1.36 | 0 | 736 | dieBasis | Basisdemokratische Partei Deutschland | Grassroots Democratic Party of Germany | 54 | 1096 | 1016 | 1528 | 2821 | |
DEU | Germany | parliament | 2021-09-26 | 1.45 | 0 | 736 | Tier | Tierschutzpartei | Animal Protection Party | 54 | 1096 | 1016 | 1528 | 301 | |
DEU | Germany | parliament | 2017-09-24 | 26.8 | 200 | 709 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 1016 | 800 | 1071 | 808 |
DEU | Germany | parliament | 2017-09-24 | 20.5 | 153 | 709 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 1016 | 800 | 1071 | 558 |
DEU | Germany | parliament | 2017-09-24 | 12.6 | 94 | 709 | AfD | Alternative für Deutschland | Alternative for Germany | 8.8 | 54 | 1016 | 800 | 1071 | 2253 |
DEU | Germany | parliament | 2017-09-24 | 10.7 | 80 | 709 | FDP | Freie Demokratische Partei | Free Democratic Party | 5.9233 | 54 | 1016 | 800 | 1071 | 543 |
DEU | Germany | parliament | 2017-09-24 | 9.2 | 69 | 709 | PDS|Li | PDS | Die Linke | PDS | The Left | 1.2152 | 54 | 1016 | 800 | 1071 | 791 |
DEU | Germany | parliament | 2017-09-24 | 8.9 | 67 | 709 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 1016 | 800 | 1071 | 772 |
DEU | Germany | parliament | 2017-09-24 | 6.2 | 46 | 709 | CSU | Christlich Soziale Union | Christian Social Union | 7.2871 | 54 | 1016 | 800 | 1071 | 1180 |
DEU | Germany | parliament | 2017-09-24 | 1.0 | 0 | 709 | FW | Freie Wähler | Free Voters | 7.4 | 54 | 1016 | 800 | 1071 | 41 |
DEU | Germany | parliament | 2017-09-24 | 1.0 | 0 | 709 | PARTEI | Die PARTEI | The PARTY | 54 | 1016 | 800 | 1071 | 2649 | |
GBR | United Kingdom | parliament | 1918-12-14 | 32.5 | 332 | 707 | Con | Conservatives | Conservatives | 7.4261 | 44 | 905 | 773 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 12.6 | 127 | 707 | CoLib | Coalition Liberal | Coalition Liberal | 6.0 | 44 | 905 | 2501 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 4.6 | 73 | 707 | SF | Sinn Féin | Sinn Fein | 1.3 | 44 | 905 | 689 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 20.8 | 57 | 707 | Lab | Labour Party | Labour | 4.3562 | 44 | 905 | 1556 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 5.9 | 50 | 707 | Con-18 | Conservatives [no coupon] | Conservatives | 7.4 | 44 | 905 | 2719 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 13.0 | 36 | 707 | Lib | Liberals | Liberals | 4.2875 | 44 | 905 | 659 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 1.45 | 9 | 707 | NDP | National Democratic and Labour Party | National Democratic and Labour Party | 8.8 | 44 | 905 | 2503 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 8 | 707 | etc | others | others | 44 | 905 | 453 | ||||
GBR | United Kingdom | parliament | 1918-12-14 | 2.21 | 7 | 707 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 905 | 332 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 0.5 | 4 | 707 | CoLab | Coalition Labour | Coalition Labour | 3.3 | 44 | 905 | 2508 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 0.9 | 2 | 707 | NP | National Party | National Party | 8.8 | 44 | 905 | 2504 | ||
GBR | United Kingdom | parliament | 1918-12-14 | 0.09 | 1 | 707 | none | no party affiliation | no party affiliation | 44 | 905 | 1599 | |||
GBR | United Kingdom | parliament | 1918-12-14 | 0.3 | 1 | 707 | one-seat | one seat | one seat | 44 | 905 | 2296 | |||
DEU | Germany | parliament | 1994-10-16 | 36.4 | 252 | 672 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 595 | 445 | 862 | 558 |
DEU | Germany | parliament | 1994-10-16 | 34.2 | 244 | 672 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 595 | 445 | 862 | 808 |
DEU | Germany | parliament | 1994-10-16 | 7.3 | 50 | 672 | CSU | Christlich Soziale Union | Christian Social Union | 7.2871 | 54 | 595 | 445 | 862 | 1180 |
DEU | Germany | parliament | 1994-10-16 | 7.3 | 49 | 672 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 595 | 445 | 862 | 772 |
DEU | Germany | parliament | 1994-10-16 | 6.9 | 47 | 672 | FDP | Freie Demokratische Partei | Free Democratic Party | 5.9233 | 54 | 595 | 445 | 862 | 543 |
DEU | Germany | parliament | 1994-10-16 | 4.4 | 30 | 672 | PDS|Li | PDS | Die Linke | PDS | The Left | 1.2152 | 54 | 595 | 445 | 862 | 791 |
DEU | Germany | parliament | 1994-10-16 | 1.9 | 0 | 672 | Rep | Die Republikaner | The Republicans | 9.2752 | 54 | 595 | 445 | 862 | 524 |
DEU | Germany | parliament | 1998-09-27 | 40.9 | 298 | 669 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 679 | 595 | 778 | 558 |
DEU | Germany | parliament | 1998-09-27 | 28.4 | 198 | 669 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 679 | 595 | 778 | 808 |
DEU | Germany | parliament | 1998-09-27 | 6.7 | 47 | 669 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 679 | 595 | 778 | 772 |
DEU | Germany | parliament | 1998-09-27 | 6.7 | 47 | 669 | CSU | Christlich Soziale Union | Christian Social Union | 7.2871 | 54 | 679 | 595 | 778 | 1180 |
DEU | Germany | parliament | 1998-09-27 | 6.2 | 43 | 669 | FDP | Freie Demokratische Partei | Free Democratic Party | 5.9233 | 54 | 679 | 595 | 778 | 543 |
DEU | Germany | parliament | 1998-09-27 | 5.1 | 36 | 669 | PDS|Li | PDS | Die Linke | PDS | The Left | 1.2152 | 54 | 679 | 595 | 778 | 791 |
DEU | Germany | parliament | 1998-09-27 | 1.2 | 0 | 669 | DVU | Deutsche Volksunion | German People's Union | 9.7256 | 54 | 679 | 595 | 778 | 1506 |
DEU | Germany | parliament | 1998-09-27 | 1.8 | 0 | 669 | Rep | Die Republikaner | The Republicans | 9.2752 | 54 | 679 | 595 | 778 | 524 |
DEU | Germany | parliament | 1990-12-02 | 36.7 | 268 | 662 | CDU | Christlich Demokratische Union | Christian Democratic Union | 6.2503 | 54 | 445 | 588 | 286 | 808 |
DEU | Germany | parliament | 1990-12-02 | 33.5 | 239 | 662 | SPD | Sozialdemokratische Partei Deutschlands | Social Democratic Party of Germany | 3.6451 | 54 | 445 | 588 | 286 | 558 |
DEU | Germany | parliament | 1990-12-02 | 11.1 | 79 | 662 | FDP | Freie Demokratische Partei | Free Democratic Party | 5.9233 | 54 | 445 | 588 | 286 | 543 |
DEU | Germany | parliament | 1990-12-02 | 7.1 | 51 | 662 | CSU | Christlich Soziale Union | Christian Social Union | 7.2871 | 54 | 445 | 588 | 286 | 1180 |
DEU | Germany | parliament | 1990-12-02 | 2.4 | 17 | 662 | PDS|Li | PDS | Die Linke | PDS | The Left | 1.2152 | 54 | 445 | 588 | 286 | 791 |
DEU | Germany | parliament | 1990-12-02 | 1.2 | 8 | 662 | B90/Gr | Bündnis 90 / Grüne – BürgerInnenbewegung | Alliance 90 / Greens -- Citizens' Movement | 2.5 | 54 | 445 | 588 | 286 | 255 |
DEU | Germany | parliament | 1990-12-02 | 3.8 | 0 | 662 | B90/Gru | Bündnis 90 / Die Grünen | Alliance 90 / Greens | 2.9308 | 54 | 445 | 588 | 286 | 772 |
DEU | Germany | parliament | 1990-12-02 | 2.1 | 0 | 662 | Rep | Die Republikaner | The Republicans | 9.2752 | 54 | 445 | 588 | 286 | 524 |
GBR | United Kingdom | parliament | 1997-05-01 | 43.2 | 419 | 659 | Lab | Labour Party | Labour | 4.3562 | 44 | 315 | 514 | 678 | 1556 |
GBR | United Kingdom | parliament | 1997-05-01 | 30.7 | 165 | 659 | Con | Conservatives | Conservatives | 7.4261 | 44 | 315 | 514 | 678 | 773 |
GBR | United Kingdom | parliament | 1997-05-01 | 16.8 | 46 | 659 | Lib | Liberals | Liberals | 4.2875 | 44 | 315 | 514 | 678 | 659 |
GBR | United Kingdom | parliament | 1997-05-01 | 0.83 | 10 | 659 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 315 | 514 | 678 | 1210 |
GBR | United Kingdom | parliament | 1997-05-01 | 2.0 | 6 | 659 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 315 | 514 | 678 | 1284 |
GBR | United Kingdom | parliament | 1997-05-01 | 0.51 | 4 | 659 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 315 | 514 | 678 | 311 |
GBR | United Kingdom | parliament | 1997-05-01 | 0.61 | 3 | 659 | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | 3.3 | 44 | 315 | 514 | 678 | 1023 |
GBR | United Kingdom | parliament | 1997-05-01 | 0.41 | 2 | 659 | SF | Sinn Féin | Sinn Fein | 1.3 | 44 | 315 | 514 | 678 | 689 |
GBR | United Kingdom | parliament | 1997-05-01 | 0.34 | 2 | 659 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 315 | 514 | 678 | 319 |
GBR | United Kingdom | parliament | 1997-05-01 | 0.04 | 1 | 659 | one-seat | one seat | one seat | 44 | 315 | 514 | 678 | 2296 | |
GBR | United Kingdom | parliament | 1997-05-01 | 1 | 659 | etc | others | others | 44 | 315 | 514 | 678 | 453 | ||
GBR | United Kingdom | parliament | 1997-05-01 | 2.6 | 0 | 659 | RP | Referendum Party | Referendum Party | 44 | 315 | 514 | 678 | 2103 | |
GBR | United Kingdom | parliament | 2001-06-07 | 40.7 | 412 | 659 | Lab | Labour Party | Labour | 4.3562 | 44 | 208 | 315 | 838 | 1556 |
GBR | United Kingdom | parliament | 2001-06-07 | 31.7 | 166 | 659 | Con | Conservatives | Conservatives | 7.4261 | 44 | 208 | 315 | 838 | 773 |
GBR | United Kingdom | parliament | 2001-06-07 | 18.3 | 52 | 659 | Lib | Liberals | Liberals | 4.2875 | 44 | 208 | 315 | 838 | 659 |
GBR | United Kingdom | parliament | 2001-06-07 | 0.8 | 6 | 659 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 208 | 315 | 838 | 1210 |
GBR | United Kingdom | parliament | 2001-06-07 | 0.7 | 5 | 659 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 208 | 315 | 838 | 319 |
GBR | United Kingdom | parliament | 2001-06-07 | 1.8 | 5 | 659 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 208 | 315 | 838 | 1284 |
GBR | United Kingdom | parliament | 2001-06-07 | 0.7 | 4 | 659 | SF | Sinn Féin | Sinn Fein | 1.3 | 44 | 208 | 315 | 838 | 689 |
GBR | United Kingdom | parliament | 2001-06-07 | 0.7 | 4 | 659 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 208 | 315 | 838 | 311 |
GBR | United Kingdom | parliament | 2001-06-07 | 0.6 | 3 | 659 | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | 3.3 | 44 | 208 | 315 | 838 | 1023 |
GBR | United Kingdom | parliament | 2001-06-07 | 2 | 659 | etc | others | others | 44 | 208 | 315 | 838 | 453 | ||
GBR | United Kingdom | parliament | 2001-06-07 | 1.5 | 0 | 659 | UKIP | United Kingdom Independence Party | United Kingdom Independence Party | 7.8429 | 44 | 208 | 315 | 838 | 1272 |
GBR | United Kingdom | parliament | 1992-04-09 | 41.9 | 336 | 651 | Con | Conservatives | Conservatives | 7.4261 | 44 | 514 | 490 | 515 | 773 |
GBR | United Kingdom | parliament | 1992-04-09 | 34.9 | 271 | 651 | Lab | Labour Party | Labour | 4.3562 | 44 | 514 | 490 | 515 | 1556 |
GBR | United Kingdom | parliament | 1992-04-09 | 17.8 | 20 | 651 | Lib | Liberals | Liberals | 4.2875 | 44 | 514 | 490 | 515 | 659 |
GBR | United Kingdom | parliament | 1992-04-09 | 0.8 | 9 | 651 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 514 | 490 | 515 | 1210 |
GBR | United Kingdom | parliament | 1992-04-09 | 0.5 | 4 | 651 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 514 | 490 | 515 | 311 |
GBR | United Kingdom | parliament | 1992-04-09 | 0.5 | 4 | 651 | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | 3.3 | 44 | 514 | 490 | 515 | 1023 |
GBR | United Kingdom | parliament | 1992-04-09 | 1.9 | 3 | 651 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 514 | 490 | 515 | 1284 |
GBR | United Kingdom | parliament | 1992-04-09 | 0.3 | 3 | 651 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 514 | 490 | 515 | 319 |
GBR | United Kingdom | parliament | 1992-04-09 | 0.1 | 1 | 651 | UPUP | Ulster Popular Unionist Party | Ulster Popular Unionist Party | 44 | 514 | 490 | 515 | 1566 | |
GBR | United Kingdom | parliament | 1992-04-09 | 0.5 | 0 | 651 | GP | Green Party | Green Party | 2.57 | 44 | 514 | 490 | 515 | 467 |
GBR | United Kingdom | parliament | 1983-06-09 | 42.4 | 397 | 650 | Con | Conservatives | Conservatives | 7.4261 | 44 | 290 | 243 | 273 | 773 |
GBR | United Kingdom | parliament | 1983-06-09 | 27.6 | 209 | 650 | Lab | Labour Party | Labour | 4.3562 | 44 | 290 | 243 | 273 | 1556 |
GBR | United Kingdom | parliament | 1983-06-09 | 25.4 | 17 | 650 | Lib | Liberals | Liberals | 4.2875 | 44 | 290 | 243 | 273 | 659 |
GBR | United Kingdom | parliament | 1983-06-09 | 0.85 | 11 | 650 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 290 | 243 | 273 | 1210 |
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 | 1983-06-09 | 0.5 | 3 | 650 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 290 | 243 | 273 | 319 |
GBR | United Kingdom | parliament | 1983-06-09 | 0.4 | 2 | 650 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 290 | 243 | 273 | 311 |
GBR | United Kingdom | parliament | 1983-06-09 | 1.1 | 2 | 650 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 290 | 243 | 273 | 1284 |
GBR | United Kingdom | parliament | 1983-06-09 | 0.33 | 1 | 650 | SF | Sinn Féin | Sinn Fein | 1.3 | 44 | 290 | 243 | 273 | 689 |
GBR | United Kingdom | parliament | 1983-06-09 | 0.4 | 1 | 650 | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | 3.3 | 44 | 290 | 243 | 273 | 1023 |
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;