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 | 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 | |||
GBR | United Kingdom | parliament | 1922-11-15 | 38.23 | 344 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 906 | 905 | 1294 | 773 |
GBR | United Kingdom | parliament | 1922-11-15 | 29.44 | 142 | 615 | Lab | Labour Party | Labour | 4.3562 | 44 | 906 | 905 | 1294 | 1556 |
GBR | United Kingdom | parliament | 1922-11-15 | 18.54 | 62 | 615 | Lib | Liberals | Liberals | 4.2875 | 44 | 906 | 905 | 1294 | 659 |
GBR | United Kingdom | parliament | 1922-11-15 | 10.22 | 53 | 615 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 906 | 905 | 1294 | 1017 |
GBR | United Kingdom | parliament | 1922-11-15 | 2.62 | 10 | 615 | etc | others | others | 44 | 906 | 905 | 1294 | 453 | |
GBR | United Kingdom | parliament | 1922-11-15 | 0.71 | 3 | 615 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 906 | 905 | 1294 | 332 |
GBR | United Kingdom | parliament | 1922-11-15 | 0.1 | 1 | 615 | C | Constitutionalist | Constitutionalist | 7.4 | 44 | 906 | 905 | 1294 | 2514 |
GBR | United Kingdom | parliament | 1923-12-06 | 38.0 | 258 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 907 | 906 | 1293 | 773 |
GBR | United Kingdom | parliament | 1923-12-06 | 30.7 | 191 | 615 | Lab | Labour Party | Labour | 4.3562 | 44 | 907 | 906 | 1293 | 1556 |
GBR | United Kingdom | parliament | 1923-12-06 | 29.7 | 158 | 615 | Lib | Liberals | Liberals | 4.2875 | 44 | 907 | 906 | 1293 | 659 |
GBR | United Kingdom | parliament | 1923-12-06 | 1.0 | 5 | 615 | etc | others | others | 44 | 907 | 906 | 1293 | 453 | |
GBR | United Kingdom | parliament | 1923-12-06 | 0.4 | 3 | 615 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 907 | 906 | 1293 | 332 |
GBR | United Kingdom | parliament | 1923-12-06 | 0.2 | 0 | 615 | CPGB | Communist Party of Great Britain | Communist Party of Great Britain | 1.3 | 44 | 907 | 906 | 1293 | 1276 |
GBR | United Kingdom | parliament | 1924-10-29 | 47.2 | 412 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 908 | 907 | 1292 | 773 |
GBR | United Kingdom | parliament | 1924-10-29 | 32.99 | 151 | 615 | Lab | Labour Party | Labour | 4.3562 | 44 | 908 | 907 | 1292 | 1556 |
GBR | United Kingdom | parliament | 1924-10-29 | 17.6 | 40 | 615 | Lib | Liberals | Liberals | 4.2875 | 44 | 908 | 907 | 1292 | 659 |
GBR | United Kingdom | parliament | 1924-10-29 | 1.11 | 7 | 615 | C | Constitutionalist | Constitutionalist | 7.4 | 44 | 908 | 907 | 1292 | 2514 |
GBR | United Kingdom | parliament | 1924-10-29 | 0.49 | 3 | 615 | etc | others | others | 44 | 908 | 907 | 1292 | 453 | |
GBR | United Kingdom | parliament | 1924-10-29 | 0.33 | 1 | 615 | CPGB | Communist Party of Great Britain | Communist Party of Great Britain | 1.3 | 44 | 908 | 907 | 1292 | 1276 |
GBR | United Kingdom | parliament | 1924-10-29 | 1 | 615 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 908 | 907 | 1292 | 332 | |
GBR | United Kingdom | parliament | 1924-10-29 | 0.28 | 0 | 615 | SF | Sinn Féin | Sinn Fein | 1.3 | 44 | 908 | 907 | 1292 | 689 |
GBR | United Kingdom | parliament | 1929-05-30 | 36.96 | 287 | 615 | Lab | Labour Party | Labour | 4.3562 | 44 | 909 | 908 | 1291 | 1556 |
GBR | United Kingdom | parliament | 1929-05-30 | 38.22 | 260 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 909 | 908 | 1291 | 773 |
GBR | United Kingdom | parliament | 1929-05-30 | 23.44 | 59 | 615 | Lib | Liberals | Liberals | 4.2875 | 44 | 909 | 908 | 1291 | 659 |
GBR | United Kingdom | parliament | 1929-05-30 | 1.03 | 6 | 615 | etc | others | others | 44 | 909 | 908 | 1291 | 453 | |
GBR | United Kingdom | parliament | 1929-05-30 | 0.11 | 3 | 615 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 909 | 908 | 1291 | 332 |
GBR | United Kingdom | parliament | 1929-05-30 | 0.22 | 0 | 615 | CPGB | Communist Party of Great Britain | Communist Party of Great Britain | 1.3 | 44 | 909 | 908 | 1291 | 1276 |
GBR | United Kingdom | parliament | 1931-10-27 | 54.98 | 470 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 910 | 909 | 1290 | 773 |
GBR | United Kingdom | parliament | 1931-10-27 | 30.71 | 52 | 615 | Lab | Labour Party | Labour | 4.3562 | 44 | 910 | 909 | 1290 | 1556 |
GBR | United Kingdom | parliament | 1931-10-27 | 3.74 | 35 | 615 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 910 | 909 | 1290 | 1017 |
GBR | United Kingdom | parliament | 1931-10-27 | 6.34 | 32 | 615 | Lib | Liberals | Liberals | 4.2875 | 44 | 910 | 909 | 1290 | 659 |
GBR | United Kingdom | parliament | 1931-10-27 | 1.58 | 13 | 615 | NLO | National Labour Organisation | National Labour Organisation | 3.3 | 44 | 910 | 909 | 1290 | 2479 |
GBR | United Kingdom | parliament | 1931-10-27 | 0.48 | 4 | 615 | IL | Independent Liberal | Independent Liberal | 6.0 | 44 | 910 | 909 | 1290 | 2517 |
GBR | United Kingdom | parliament | 1931-10-27 | 0.05 | 4 | 615 | Na | National | National | 7.4 | 44 | 910 | 909 | 1290 | 2518 |
GBR | United Kingdom | parliament | 1931-10-27 | 0.54 | 3 | 615 | etc | others | others | 44 | 910 | 909 | 1290 | 453 | |
GBR | United Kingdom | parliament | 1931-10-27 | 0.57 | 2 | 615 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 910 | 909 | 1290 | 332 |
GBR | United Kingdom | parliament | 1931-10-27 | 0.35 | 0 | 615 | CPGB | Communist Party of Great Britain | Communist Party of Great Britain | 1.3 | 44 | 910 | 909 | 1290 | 1276 |
GBR | United Kingdom | parliament | 1935-11-14 | 47.72 | 387 | 615 | Con | Conservatives | Conservatives | 7.4261 | 44 | 911 | 910 | 1287 | 773 |
GBR | United Kingdom | parliament | 1935-11-14 | 37.85 | 154 | 615 | Lab | Labour Party | Labour | 4.3562 | 44 | 911 | 910 | 1287 | 1556 |
GBR | United Kingdom | parliament | 1935-11-14 | 3.94 | 33 | 615 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 911 | 910 | 1287 | 1017 |
GBR | United Kingdom | parliament | 1935-11-14 | 6.56 | 21 | 615 | Lib | Liberals | Liberals | 4.2875 | 44 | 911 | 910 | 1287 | 659 |
GBR | United Kingdom | parliament | 1935-11-14 | 1.54 | 8 | 615 | NLO | National Labour Organisation | National Labour Organisation | 3.3 | 44 | 911 | 910 | 1287 | 2479 |
GBR | United Kingdom | parliament | 1935-11-14 | 0.63 | 4 | 615 | ILP | Independent Labour Party | Independent Labour Party | 1.3 | 44 | 911 | 910 | 1287 | 1205 |
GBR | United Kingdom | parliament | 1935-11-14 | 0.53 | 4 | 615 | etc | others | others | 44 | 911 | 910 | 1287 | 453 | |
GBR | United Kingdom | parliament | 1935-11-14 | 0.46 | 2 | 615 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 911 | 910 | 1287 | 332 |
GBR | United Kingdom | parliament | 1935-11-14 | 0.3 | 1 | 615 | Na | National | National | 7.4 | 44 | 911 | 910 | 1287 | 2518 |
GBR | United Kingdom | parliament | 1935-11-14 | 0.12 | 1 | 615 | CPGB | Communist Party of Great Britain | Communist Party of Great Britain | 1.3 | 44 | 911 | 910 | 1287 | 1276 |
GBR | United Kingdom | parliament | 1945-07-05 | 48.0 | 393 | 640 | Lab | Labour Party | Labour | 4.3562 | 44 | 609 | 911 | 1520 | 1556 |
GBR | United Kingdom | parliament | 1945-07-05 | 36.2 | 197 | 640 | Con | Conservatives | Conservatives | 7.4261 | 44 | 609 | 911 | 1520 | 773 |
GBR | United Kingdom | parliament | 1945-07-05 | 19 | 640 | etc | others | others | 44 | 609 | 911 | 1520 | 453 | ||
GBR | United Kingdom | parliament | 1945-07-05 | 9.0 | 12 | 640 | Lib | Liberals | Liberals | 4.2875 | 44 | 609 | 911 | 1520 | 659 |
GBR | United Kingdom | parliament | 1945-07-05 | 2.9 | 11 | 640 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 609 | 911 | 1520 | 1017 |
GBR | United Kingdom | parliament | 1945-07-05 | 0.2 | 3 | 640 | ILP | Independent Labour Party | Independent Labour Party | 1.3 | 44 | 609 | 911 | 1520 | 1205 |
GBR | United Kingdom | parliament | 1945-07-05 | 0.4 | 2 | 640 | CPGB | Communist Party of Great Britain | Communist Party of Great Britain | 1.3 | 44 | 609 | 911 | 1520 | 1276 |
GBR | United Kingdom | parliament | 1945-07-05 | 0.4 | 2 | 640 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 609 | 911 | 1520 | 332 |
GBR | United Kingdom | parliament | 1945-07-05 | 0.5 | 1 | 640 | one-seat | one seat | one seat | 44 | 609 | 911 | 1520 | 2296 | |
GBR | United Kingdom | parliament | 1945-07-05 | 0.1 | 0 | 640 | SNP | Scottish National Party – Pàrtaidh Nàiseanta na h-Alba | Scottish National Party | 3.5871 | 44 | 609 | 911 | 1520 | 1284 |
GBR | United Kingdom | parliament | 1950-02-23 | 46.1 | 315 | 625 | Lab | Labour Party | Labour | 4.3562 | 44 | 625 | 609 | 99 | 1556 |
GBR | United Kingdom | parliament | 1950-02-23 | 282 | 625 | Con | Conservatives | Conservatives | 7.4261 | 44 | 625 | 609 | 99 | 773 | |
GBR | United Kingdom | parliament | 1950-02-23 | 16 | 625 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 625 | 609 | 99 | 1017 | |
GBR | United Kingdom | parliament | 1950-02-23 | 9.1 | 9 | 625 | Lib | Liberals | Liberals | 4.2875 | 44 | 625 | 609 | 99 | 659 |
GBR | United Kingdom | parliament | 1950-02-23 | 0.2 | 2 | 625 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 625 | 609 | 99 | 332 |
GBR | United Kingdom | parliament | 1950-02-23 | 1 | 625 | etc | others | others | 44 | 625 | 609 | 99 | 453 | ||
GBR | United Kingdom | parliament | 1950-02-23 | 0.3 | 0 | 625 | CPGB | Communist Party of Great Britain | Communist Party of Great Britain | 1.3 | 44 | 625 | 609 | 99 | 1276 |
GBR | United Kingdom | parliament | 1950-02-23 | 43.4 | 625 | CNL | Conservatives and National Liberals | Conservatives and National Liberals | 7.8 | 44 | 625 | 609 | 99 | 1496 | |
GBR | United Kingdom | parliament | 1951-10-25 | 302 | 625 | Con | Conservatives | Conservatives | 7.4261 | 44 | 102 | 625 | 88 | 773 | |
GBR | United Kingdom | parliament | 1951-10-25 | 48.8 | 295 | 625 | Lab | Labour Party | Labour | 4.3562 | 44 | 102 | 625 | 88 | 1556 |
GBR | United Kingdom | parliament | 1951-10-25 | 19 | 625 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 102 | 625 | 88 | 1017 | |
GBR | United Kingdom | parliament | 1951-10-25 | 2.6 | 6 | 625 | Lib | Liberals | Liberals | 4.2875 | 44 | 102 | 625 | 88 | 659 |
GBR | United Kingdom | parliament | 1951-10-25 | 0.3 | 2 | 625 | N | Nationalist Party | Nationalist Party | 3.3 | 44 | 102 | 625 | 88 | 332 |
GBR | United Kingdom | parliament | 1951-10-25 | 0.1 | 1 | 625 | one-seat | one seat | one seat | 44 | 102 | 625 | 88 | 2296 | |
GBR | United Kingdom | parliament | 1951-10-25 | 0.1 | 0 | 625 | CPGB | Communist Party of Great Britain | Communist Party of Great Britain | 1.3 | 44 | 102 | 625 | 88 | 1276 |
GBR | United Kingdom | parliament | 1951-10-25 | 48.0 | 625 | CNL | Conservatives and National Liberals | Conservatives and National Liberals | 7.8 | 44 | 102 | 625 | 88 | 1496 | |
GBR | United Kingdom | parliament | 1955-05-26 | 324 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 678 | 102 | 729 | 773 | |
GBR | United Kingdom | parliament | 1955-05-26 | 46.4 | 277 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 678 | 102 | 729 | 1556 |
GBR | United Kingdom | parliament | 1955-05-26 | 21 | 630 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 678 | 102 | 729 | 1017 | |
GBR | United Kingdom | parliament | 1955-05-26 | 2.7 | 6 | 630 | Lib | Liberals | Liberals | 4.2875 | 44 | 678 | 102 | 729 | 659 |
GBR | United Kingdom | parliament | 1955-05-26 | 0.6 | 2 | 630 | SF | Sinn Féin | Sinn Fein | 1.3 | 44 | 678 | 102 | 729 | 689 |
GBR | United Kingdom | parliament | 1955-05-26 | 0.2 | 0 | 630 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 678 | 102 | 729 | 311 |
GBR | United Kingdom | parliament | 1955-05-26 | 49.7 | 630 | CNL | Conservatives and National Liberals | Conservatives and National Liberals | 7.8 | 44 | 678 | 102 | 729 | 1496 | |
GBR | United Kingdom | parliament | 1959-10-08 | 345 | 630 | Con | Conservatives | Conservatives | 7.4261 | 44 | 161 | 678 | 404 | 773 | |
GBR | United Kingdom | parliament | 1959-10-08 | 43.8 | 258 | 630 | Lab | Labour Party | Labour | 4.3562 | 44 | 161 | 678 | 404 | 1556 |
GBR | United Kingdom | parliament | 1959-10-08 | 20 | 630 | NLP | National Liberal Party | National Liberal Party | 6.0 | 44 | 161 | 678 | 404 | 1017 | |
GBR | United Kingdom | parliament | 1959-10-08 | 5.9 | 6 | 630 | Lib | Liberals | Liberals | 4.2875 | 44 | 161 | 678 | 404 | 659 |
GBR | United Kingdom | parliament | 1959-10-08 | 1 | 630 | etc | others | others | 44 | 161 | 678 | 404 | 453 | ||
GBR | United Kingdom | parliament | 1959-10-08 | 0.3 | 0 | 630 | Plaid | Plaid Cymru | Plaid Cymru | 3.1183 | 44 | 161 | 678 | 404 | 311 |
GBR | United Kingdom | parliament | 1959-10-08 | 49.4 | 630 | CNL | Conservatives and National Liberals | Conservatives and National Liberals | 7.8 | 44 | 161 | 678 | 404 | 1496 |
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;