english_region_general_election_party_performances

Data license: Open Parliament Licence · Data source: UK Parliament election results website

173 rows where english_region_id = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: constituency_contested_count, constituency_won_count, general_election_id

id ▼ constituency_contested_count constituency_won_count cumulative_vote_count general_election_id political_party_id english_region_id
1 14 0 2786 2 2 Trade Unionist and Socialist Coalition 7 South East 1
2 6 0 1555 2 2 Official Monster Raving Loony Party 12 South East 1
3 4 0 1304 3 3 Official Monster Raving Loony Party 12 South East 1
4 7 0 2873 4 4 Official Monster Raving Loony Party 12 South East 1
5 6 0 8745 2 2 National Health Action Party 14 South East 1
6 2 0 12668 3 3 National Health Action Party 14 South East 1
7 2 0 369 2 2 English Democrats 15 South East 1
8 1 0 194 4 4 English Democrats 15 South East 1
9 1 0 53 2 2 Patriotic Socialist Party 18 South East 1
10 3 0 821 2 2 Cannabis Is Safer Than Alcohol 29 South East 1
11 1 0 361 2 2 Christian Party, Proclaiming Christ's Lordship 34 South East 1
12 2 0 534 4 4 Social Democratic Party 38 South East 1
13 1 0 106 2 2 Patria 44 South East 1
14 1 0 84 3 3 Patria 44 South East 1
15 1 0 109 4 4 Patria 44 South East 1
16 1 0 483 3 3 Pirate Party UK 46 South East 1
17 6 0 510 2 2 The Socialist Party of Great Britain 47 South East 1
18 1 0 69 4 4 The Socialist Party of Great Britain 47 South East 1
19 1 0 133 2 2 Christian Peoples Alliance 54 South East 1
20 7 0 1031 3 3 Christian Peoples Alliance 54 South East 1
21 4 0 740 4 4 Christian Peoples Alliance 54 South East 1
22 2 0 537 2 2 The Peace Party - Non-violence, Justice, Environment 57 South East 1
23 2 0 468 3 3 The Peace Party - Non-violence, Justice, Environment 57 South East 1
24 2 0 960 4 4 The Peace Party - Non-violence, Justice, Environment 57 South East 1
25 1 0 55 2 2 Class War 58 South East 1
26 1 0 133 2 2 Beer, Baccy and Scratchings 70 South East 1
27 1 0 72 2 2 Young People's Party 72 South East 1
28 1 0 80 4 4 Young People's Party 72 South East 1
29 1 0 538 2 2 Guildford Greenbelt Group 75 South East 1
30 1 0 282 3 3 Animal Welfare Party 76 South East 1
31 1 0 675 4 4 Animal Welfare Party 76 South East 1
32 2 0 695 2 2 Something New 82 South East 1
33 1 0 375 3 3 Something New 82 South East 1
34 1 0 116 2 2 Keep It Real Party 91 South East 1
35 1 0 228 2 2 Apolitical Democrats 93 South East 1
36 1 0 304 3 3 Apolitical Democrats 93 South East 1
37 2 0 199 2 2 Party for a United Thanet 95 South East 1
38 2 0 171 2 2 The Justice & Anti-Corruption Party 97 South East 1
39 3 0 991 3 3 The Justice & Anti-Corruption Party 97 South East 1
40 3 0 728 4 4 The Justice & Anti-Corruption Party 97 South East 1
41 1 0 64 2 2 The Roman Party. Ave 100 South East 1
42 1 0 126 2 2 We Are The Reality Party 105 South East 1
43 83 1 227882 2 2 Green Party 2 South East 1
44 75 1 143873 3 3 Green Party 2 South East 1
45 70 1 183724 4 4 Green Party 2 South East 1
46 83 4 804774 2 2 Labour 3 South East 1
47 83 8 1326380 3 3 Labour 3 South East 1
48 84 8 1029966 4 4 Labour 3 South East 1
49 83 0 413586 2 2 Liberal Democrat 4 South East 1
50 82 2 487203 3 3 Liberal Democrat 4 South East 1
51 81 1 848382 4 4 Liberal Democrat 4 South East 1
52 84 0 646959 2 2 UK Independence Party 8 South East 1
53 63 0 104509 3 3 UK Independence Party 8 South East 1
54 13 0 7807 4 4 UK Independence Party 8 South East 1
55 1 0 142 3 3 Movement for Active Democracy (M.A.D.) 108 South East 1
56 1 0 30 2 2 Al-Zebabist Nation of Ooog 109 South East 1
57 1 0 191 2 2 Manston Airport Independent Party 110 South East 1
58 1 0 77 2 2 Magna Carta Conservation Party Great Britain 117 South East 1
59 1 0 37 2 2 Give Me Back Elmo 122 South East 1
60 1 0 35 2 2 Land Party 123 South East 1
61 1 0 56 2 2 Reduce VAT in Sport 124 South East 1
62 1 0 110 2 2 Wessex Regionalists 125 South East 1
63 1 0 41 2 2 The Evolution Party 126 South East 1
64 2 0 343 3 3 Libertarian Party 130 South East 1
65 2 0 519 4 4 Libertarian Party 130 South East 1
66 1 0 392 3 3 The Radical Party 140 South East 1
67 1 0 702 3 3 Women's Equality Party 141 South East 1
68 1 0 137 4 4 Women's Equality Party 141 South East 1
69 1 0 52 3 3 The Just Political Party 143 South East 1
70 1 0 816 3 3 Southampton Independents 149 South East 1
71 11 0 12868 4 4 The Brexit Party 153 South East 1
72 3 0 179 4 4 Advance Together 163 South East 1
73 1 0 1542 4 4 Independent Network 168 South East 1
74 1 0 926 4 4 Wycombe Independents 177 South East 1
75 83 78 2234360 2 2 Conservative 1 South East 1
76 83 72 2495350 3 3 Conservative 1 South East 1
77 84 74 2512869 4 4 Conservative 1 South East 1
513 3 0 179 5 5 Trade Unionist and Socialist Coalition 7 South East 1
514 7 0 2873 5 5 Official Monster Raving Loony Party 12 South East 1
515 1 0 194 5 5 English Democrats 15 South East 1
516 2 0 534 5 5 Social Democratic Party 38 South East 1
517 1 0 109 5 5 Patria 44 South East 1
518 1 0 69 5 5 The Socialist Party of Great Britain 47 South East 1
519 4 0 740 5 5 Christian Peoples Alliance 54 South East 1
520 2 0 960 5 5 The Peace Party - Non-violence, Justice, Environment 57 South East 1
521 1 0 80 5 5 Young People's Party 72 South East 1
522 1 0 675 5 5 Animal Welfare Party 76 South East 1
523 3 0 728 5 5 The Justice & Anti-Corruption Party 97 South East 1
524 86 1 183724 5 5 Green Party 2 South East 1
525 91 8 1029966 5 5 Labour 3 South East 1
526 87 1 848382 5 5 Liberal Democrat 4 South East 1
527 13 0 7807 5 5 UK Independence Party 8 South East 1
528 2 0 519 5 5 Libertarian Party 130 South East 1
529 1 0 137 5 5 Women's Equality Party 141 South East 1
530 18 0 12868 5 5 The Brexit Party 153 South East 1
531 2 0 1542 5 5 Independent Network 168 South East 1
532 1 0 926 5 5 Wycombe Independents 177 South East 1
533 91 81 2512869 5 5 Conservative 1 South East 1
660 1 0 148 1 1 Socialist Labour Party 6 South East 1
661 4 0 692 1 1 Trade Unionist and Socialist Coalition 7 South East 1

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "english_region_general_election_party_performances" (
   [id] INTEGER PRIMARY KEY,
   [constituency_contested_count] INTEGER,
   [constituency_won_count] INTEGER,
   [cumulative_vote_count] INTEGER,
   [general_election_id] INTEGER REFERENCES [general_elections]([id]),
   [political_party_id] INTEGER REFERENCES [political_parties]([id]),
   [english_region_id] INTEGER REFERENCES [english_regions]([id])
);
CREATE INDEX [idx_english_region_general_election_party_performances_english_region_id]
    ON [english_region_general_election_party_performances] ([english_region_id]);
CREATE INDEX [idx_english_region_general_election_party_performances_political_party_id]
    ON [english_region_general_election_party_performances] ([political_party_id]);
CREATE INDEX [idx_english_region_general_election_party_performances_general_election_id]
    ON [english_region_general_election_party_performances] ([general_election_id]);