view_election (view)
Data source: ParlGov · About: simonw/parlgov-datasette
8,947 rows sorted by country_name 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GBR | United Kingdom | parliament | 1964-10-15 | 44.1 | 317 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 223 | 161 | 63 | 1556 |
GBR | United Kingdom | parliament | 1964-10-15 | 298 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 223 | 161 | 63 | 773 | |
GBR | United Kingdom | parliament | 1964-10-15 | 11.2 | 9 | 630 | Lib | Liberals | Liberals | 4.2875 | 44 | 223 | 161 | 63 | 659 |
GBR | United Kingdom | parliament | 1964-10-15 | 6 | 630 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 223 | 161 | 63 | 1017 | |
GBR | United Kingdom | parliament | 1964-10-15 | 0.2 | 0 | 630 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 223 | 161 | 63 | 311 |
GBR | United Kingdom | parliament | 1964-10-15 | 43.4 | 630 | CNL | Conservatives and National Liberals | Conservatives and National Liberals | 7.8 | 44 | 223 | 161 | 63 | 1496 | |
GBR | United Kingdom | parliament | 1966-03-31 | 48.0 | 364 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 583 | 223 | 760 | 1556 |
GBR | United Kingdom | parliament | 1966-03-31 | 250 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 583 | 223 | 760 | 773 | |
GBR | United Kingdom | parliament | 1966-03-31 | 8.6 | 12 | 630 | Lib | Liberals | Liberals | 4.2875 | 44 | 583 | 223 | 760 | 659 |
GBR | United Kingdom | parliament | 1966-03-31 | 3 | 630 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 583 | 223 | 760 | 1017 | |
GBR | United Kingdom | parliament | 1966-03-31 | 0.1 | 1 | 630 | RepLP | Republican Labour Party | Republican Labour Party | 44 | 583 | 223 | 760 | 1092 | |
GBR | United Kingdom | parliament | 1966-03-31 | 0.5 | 0 | 630 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 583 | 223 | 760 | 1284 |
GBR | United Kingdom | parliament | 1966-03-31 | 41.9 | 630 | CNL | Conservatives and National Liberals | Conservatives and National Liberals | 7.8 | 44 | 583 | 223 | 760 | 1496 | |
GBR | United Kingdom | parliament | 1970-06-18 | 46.4 | 330 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 311 | 583 | 733 | 773 |
GBR | United Kingdom | parliament | 1970-06-18 | 43.1 | 288 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 311 | 583 | 733 | 1556 |
GBR | United Kingdom | parliament | 1970-06-18 | 7.5 | 6 | 630 | Lib | Liberals | Liberals | 4.2875 | 44 | 311 | 583 | 733 | 659 |
GBR | United Kingdom | parliament | 1970-06-18 | 0.5 | 2 | 630 | U | Unity | Unity | 44 | 311 | 583 | 733 | 349 | |
GBR | United Kingdom | parliament | 1970-06-18 | 0.1 | 1 | 630 | RepLP | Republican Labour Party | Republican Labour Party | 44 | 311 | 583 | 733 | 1092 | |
GBR | United Kingdom | parliament | 1970-06-18 | 1 | 630 | etc | others | others | 44 | 311 | 583 | 733 | 453 | ||
GBR | United Kingdom | parliament | 1970-06-18 | 0.1 | 1 | 630 | one-seat | one seat | one seat | 44 | 311 | 583 | 733 | 2296 | |
GBR | United Kingdom | parliament | 1970-06-18 | 1.1 | 1 | 630 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 311 | 583 | 733 | 1284 |
GBR | United Kingdom | parliament | 1970-06-18 | 0.6 | 0 | 630 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 311 | 583 | 733 | 311 |
GBR | United Kingdom | parliament | 1974-02-28 | 37.2 | 301 | 635 | Lab | Labour Party | Labour | 4.3562 | 44 | 568 | 311 | 216 | 1556 |
GBR | United Kingdom | parliament | 1974-02-28 | 38.0 | 297 | 635 | Con | Conservatives | Conservatives | 7.4261 | 44 | 568 | 311 | 216 | 773 |
GBR | United Kingdom | parliament | 1974-02-28 | 19.3 | 14 | 635 | Lib | Liberals | Liberals | 4.2875 | 44 | 568 | 311 | 216 | 659 |
GBR | United Kingdom | parliament | 1974-02-28 | 2.0 | 7 | 635 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 568 | 311 | 216 | 1284 |
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 | 0.6 | 2 | 635 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 568 | 311 | 216 | 311 |
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-02-28 | 0.5 | 1 | 635 | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | 3.3 | 44 | 568 | 311 | 216 | 1023 |
GBR | United Kingdom | parliament | 1974-02-28 | 0.2 | 0 | 635 | NF | National Front | National Front | 8.8 | 44 | 568 | 311 | 216 | 1126 |
GBR | United Kingdom | parliament | 1974-02-28 | 1.17 | 635 | UUUC | United Ulster Unionist Coalition | United Ulster Unionist Coalition | 44 | 568 | 311 | 216 | 1363 | ||
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 | ||
GBR | United Kingdom | parliament | 1979-05-03 | 43.9 | 339 | 635 | Con | Conservatives | Conservatives | 7.4261 | 44 | 243 | 40 | 590 | 773 |
GBR | United Kingdom | parliament | 1979-05-03 | 36.9 | 269 | 635 | Lab | Labour Party | Labour | 4.3562 | 44 | 243 | 40 | 590 | 1556 |
GBR | United Kingdom | parliament | 1979-05-03 | 13.8 | 11 | 635 | Lib | Liberals | Liberals | 4.2875 | 44 | 243 | 40 | 590 | 659 |
GBR | United Kingdom | parliament | 1979-05-03 | 0.82 | 5 | 635 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 243 | 40 | 590 | 1210 |
GBR | United Kingdom | parliament | 1979-05-03 | 0.23 | 3 | 635 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 243 | 40 | 590 | 319 |
GBR | United Kingdom | parliament | 1979-05-03 | 2 | 635 | etc | others | others | 44 | 243 | 40 | 590 | 453 | ||
GBR | United Kingdom | parliament | 1979-05-03 | 1.6 | 2 | 635 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 243 | 40 | 590 | 1284 |
GBR | United Kingdom | parliament | 1979-05-03 | 0.4 | 2 | 635 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 243 | 40 | 590 | 311 |
GBR | United Kingdom | parliament | 1979-05-03 | 0.4 | 1 | 635 | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | 3.3 | 44 | 243 | 40 | 590 | 1023 |
GBR | United Kingdom | parliament | 1979-05-03 | 0.13 | 1 | 635 | one-seat | one seat | one seat | 44 | 243 | 40 | 590 | 2296 | |
GBR | United Kingdom | parliament | 1979-05-03 | 0.6 | 0 | 635 | NF | National Front | National Front | 8.8 | 44 | 243 | 40 | 590 | 1126 |
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 |
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 |
GBR | United Kingdom | parliament | 1983-06-09 | 0.07 | 1 | 650 | UPUP | Ulster Popular Unionist Party | Ulster Popular Unionist Party | 44 | 290 | 243 | 273 | 1566 | |
GBR | United Kingdom | ep | 1984-06-17 | 38.8 | 45 | 81 | Con | Conservatives | Conservatives | 7.4261 | 44 | 222 | 290 | 646 | 773 |
GBR | United Kingdom | ep | 1984-06-17 | 34.76 | 32 | 81 | Lab | Labour Party | Labour | 4.3562 | 44 | 222 | 290 | 646 | 1556 |
GBR | United Kingdom | ep | 1984-06-17 | 1.65 | 1 | 81 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 222 | 290 | 646 | 1284 |
GBR | United Kingdom | ep | 1984-06-17 | 1.05 | 1 | 81 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 222 | 290 | 646 | 1210 |
GBR | United Kingdom | ep | 1984-06-17 | 1.64 | 1 | 81 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 222 | 290 | 646 | 319 |
GBR | United Kingdom | ep | 1984-06-17 | 1.1 | 1 | 81 | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | 3.3 | 44 | 222 | 290 | 646 | 1023 |
GBR | United Kingdom | ep | 1984-06-17 | 18.5 | 0 | 81 | Lib | Liberals | Liberals | 4.2875 | 44 | 222 | 290 | 646 | 659 |
GBR | United Kingdom | parliament | 1987-06-11 | 42.3 | 376 | 650 | Con | Conservatives | Conservatives | 7.4261 | 44 | 490 | 290 | 646 | 773 |
GBR | United Kingdom | parliament | 1987-06-11 | 30.8 | 229 | 650 | Lab | Labour Party | Labour | 4.3562 | 44 | 490 | 290 | 646 | 1556 |
GBR | United Kingdom | parliament | 1987-06-11 | 22.6 | 17 | 650 | Lib | Liberals | Liberals | 4.2875 | 44 | 490 | 290 | 646 | 659 |
GBR | United Kingdom | parliament | 1987-06-11 | 0.85 | 9 | 650 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 490 | 290 | 646 | 1210 |
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 | 1987-06-11 | 0.26 | 3 | 650 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 490 | 290 | 646 | 319 |
GBR | United Kingdom | parliament | 1987-06-11 | 1.3 | 3 | 650 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 490 | 290 | 646 | 1284 |
GBR | United Kingdom | parliament | 1987-06-11 | 0.4 | 3 | 650 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 490 | 290 | 646 | 311 |
GBR | United Kingdom | parliament | 1987-06-11 | 0.5 | 3 | 650 | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | 3.3 | 44 | 490 | 290 | 646 | 1023 |
GBR | United Kingdom | parliament | 1987-06-11 | 0.06 | 1 | 650 | UPUP | Ulster Popular Unionist Party | Ulster Popular Unionist Party | 44 | 490 | 290 | 646 | 1566 | |
GBR | United Kingdom | parliament | 1987-06-11 | 0.26 | 1 | 650 | SF | Sinn Féin | Sinn Fein | 1.3 | 44 | 490 | 290 | 646 | 689 |
GBR | United Kingdom | parliament | 1987-06-11 | 0.3 | 0 | 650 | GP | Green Party | Green Party | 2.57 | 44 | 490 | 290 | 646 | 467 |
GBR | United Kingdom | ep | 1989-06-15 | 39.0 | 45 | 81 | Lab | Labour Party | Labour | 4.3562 | 44 | 682 | 490 | 297 | 1556 |
GBR | United Kingdom | ep | 1989-06-15 | 33.0 | 32 | 81 | Con | Conservatives | Conservatives | 7.4261 | 44 | 682 | 490 | 297 | 773 |
GBR | United Kingdom | ep | 1989-06-15 | 0.86 | 1 | 81 | SDLP | Social Democratic and Labour Party | Social Democratic and Labour Party | 3.3 | 44 | 682 | 490 | 297 | 1023 |
GBR | United Kingdom | ep | 1989-06-15 | 1.0 | 1 | 81 | DUP | Democratic Unionist Party | Democratic Unionist Party | 7.4 | 44 | 682 | 490 | 297 | 319 |
GBR | United Kingdom | ep | 1989-06-15 | 0.75 | 1 | 81 | UUP | Ulster Unionist Party | Ulster Unionist Party | 8.3 | 44 | 682 | 490 | 297 | 1210 |
GBR | United Kingdom | ep | 1989-06-15 | 2.6 | 1 | 81 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 682 | 490 | 297 | 1284 |
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;