english_region_general_election_party_performances

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

116 rows where english_region_id = 6

✎ 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
319 19 0 5596 2 2 Trade Unionist and Socialist Coalition 7 Yorkshire and The Humber 6
320 1 0 86 2 2 National Front 10 Yorkshire and The Humber 6
321 1 0 162 2 2 Official Monster Raving Loony Party 12 Yorkshire and The Humber 6
322 1 0 252 4 4 Official Monster Raving Loony Party 12 Yorkshire and The Humber 6
323 15 0 4035 2 2 English Democrats 15 Yorkshire and The Humber 6
324 4 0 1238 3 3 English Democrats 15 Yorkshire and The Humber 6
325 1 0 309 4 4 English Democrats 15 Yorkshire and The Humber 6
326 1 0 103 2 2 Vapers In Power 16 Yorkshire and The Humber 6
327 14 0 6811 2 2 Yorkshire First 17 Yorkshire and The Humber 6
328 1 0 53 2 2 Patriotic Socialist Party 18 Yorkshire and The Humber 6
329 3 0 707 2 2 Cannabis Is Safer Than Alcohol 29 Yorkshire and The Humber 6
330 1 0 312 2 2 Christian Party, Proclaiming Christ's Lordship 34 Yorkshire and The Humber 6
331 2 0 9022 2 2 Respect Party 35 Yorkshire and The Humber 6
332 1 0 119 2 2 Communist Party of Britain 36 Yorkshire and The Humber 6
333 1 0 54 2 2 Social Democratic Party 38 Yorkshire and The Humber 6
334 5 0 321 3 3 Social Democratic Party 38 Yorkshire and The Humber 6
335 6 0 1033 4 4 Social Democratic Party 38 Yorkshire and The Humber 6
336 1 0 225 2 2 British National Party 40 Yorkshire and The Humber 6
337 1 0 28 2 2 Independence from Europe 41 Yorkshire and The Humber 6
338 1 0 210 2 2 British Democratic Party 45 Yorkshire and The Humber 6
339 1 0 113 2 2 Pirate Party UK 46 Yorkshire and The Humber 6
340 1 0 91 3 3 Pirate Party UK 46 Yorkshire and The Humber 6
341 1 0 165 2 2 World Peace Through Song 49 Yorkshire and The Humber 6
342 1 0 33 2 2 Workers Revolutionary Party 50 Yorkshire and The Humber 6
343 1 0 137 3 3 Workers Revolutionary Party 50 Yorkshire and The Humber 6
344 1 0 94 2 2 Christian Peoples Alliance 54 Yorkshire and The Humber 6
345 2 0 224 3 3 Christian Peoples Alliance 54 Yorkshire and The Humber 6
346 2 0 66 2 2 The Above and Beyond Party 55 Yorkshire and The Humber 6
347 1 0 1127 2 2 Liberal 56 Yorkshire and The Humber 6
348 1 0 753 3 3 Liberal 56 Yorkshire and The Humber 6
349 1 0 721 4 4 Liberal 56 Yorkshire and The Humber 6
350 1 0 28 4 4 Socialist Equality Party 74 Yorkshire and The Humber 6
351 3 0 737 2 2 Alliance for Green Socialism 84 Yorkshire and The Humber 6
352 2 0 163 3 3 Alliance for Green Socialism 84 Yorkshire and The Humber 6
353 2 0 207 4 4 Alliance for Green Socialism 84 Yorkshire and The Humber 6
354 45 0 86471 2 2 Green Party 2 Yorkshire and The Humber 6
355 34 0 32661 3 3 Green Party 2 Yorkshire and The Humber 6
356 42 0 57362 4 4 Green Party 2 Yorkshire and The Humber 6
357 54 33 956837 2 2 Labour 3 Yorkshire and The Humber 6
358 54 37 1276912 3 3 Labour 3 Yorkshire and The Humber 6
359 54 28 989787 4 4 Labour 3 Yorkshire and The Humber 6
360 54 2 174069 2 2 Liberal Democrat 4 Yorkshire and The Humber 6
361 53 0 129687 3 3 Liberal Democrat 4 Yorkshire and The Humber 6
362 54 0 205225 4 4 Liberal Democrat 4 Yorkshire and The Humber 6
363 54 0 391923 2 2 UK Independence Party 8 Yorkshire and The Humber 6
364 33 0 67801 3 3 UK Independence Party 8 Yorkshire and The Humber 6
365 3 0 983 4 4 UK Independence Party 8 Yorkshire and The Humber 6
366 21 0 20958 3 3 The Yorkshire Party 129 Yorkshire and The Humber 6
367 28 0 29201 4 4 The Yorkshire Party 129 Yorkshire and The Humber 6
368 1 0 67 3 3 Libertarian Party 130 Yorkshire and The Humber 6
369 1 0 420 3 3 Better for Bradford 135 Yorkshire and The Humber 6
370 1 0 1040 3 3 Women's Equality Party 141 Yorkshire and The Humber 6
371 37 0 150561 4 4 The Brexit Party 153 Yorkshire and The Humber 6
372 1 0 6432 4 4 Heavy Woollen District Independents 154 Yorkshire and The Humber 6
373 54 19 796822 2 2 Conservative 1 Yorkshire and The Humber 6
374 54 17 1054099 3 3 Conservative 1 Yorkshire and The Humber 6
375 54 26 1097376 4 4 Conservative 1 Yorkshire and The Humber 6
601 1 0 252 5 5 Official Monster Raving Loony Party 12 Yorkshire and The Humber 6
602 1 0 309 5 5 English Democrats 15 Yorkshire and The Humber 6
603 31 0 29201 5 5 Yorkshire First 17 Yorkshire and The Humber 6
604 6 0 1033 5 5 Social Democratic Party 38 Yorkshire and The Humber 6
605 1 0 721 5 5 Liberal 56 Yorkshire and The Humber 6
606 1 0 28 5 5 Socialist Equality Party 74 Yorkshire and The Humber 6
607 2 0 207 5 5 Alliance for Green Socialism 84 Yorkshire and The Humber 6
608 49 0 57362 5 5 Green Party 2 Yorkshire and The Humber 6
609 54 27 989787 5 5 Labour 3 Yorkshire and The Humber 6
610 54 0 205225 5 5 Liberal Democrat 4 Yorkshire and The Humber 6
611 3 0 983 5 5 UK Independence Party 8 Yorkshire and The Humber 6
612 42 0 150561 5 5 The Brexit Party 153 Yorkshire and The Humber 6
613 2 0 6432 5 5 Heavy Woollen District Independents 154 Yorkshire and The Humber 6
614 54 27 1097376 5 5 Conservative 1 Yorkshire and The Humber 6
819 2 0 957 1 1 Socialist Labour Party 6 Yorkshire and The Humber 6
820 5 0 2047 1 1 Trade Unionist and Socialist Coalition 7 Yorkshire and The Humber 6
821 3 0 1237 1 1 National Front 10 Yorkshire and The Humber 6
822 2 0 318 1 1 Official Monster Raving Loony Party 12 Yorkshire and The Humber 6
823 13 0 11722 1 1 English Democrats 15 Yorkshire and The Humber 6
824 1 0 250 1 1 Christian Party, Proclaiming Christ's Lordship 34 Yorkshire and The Humber 6
825 1 0 1245 1 1 Respect Party 35 Yorkshire and The Humber 6
826 1 0 139 1 1 Communist Party of Britain 36 Yorkshire and The Humber 6
827 1 0 914 1 1 Social Democratic Party 38 Yorkshire and The Humber 6
828 48 0 104167 1 1 British National Party 40 Yorkshire and The Humber 6
829 1 0 1418 1 1 Liberal 56 Yorkshire and The Humber 6
830 4 0 1257 1 1 Alliance for Green Socialism 84 Yorkshire and The Humber 6
831 21 0 20824 1 1 Green Party 2 Yorkshire and The Humber 6
832 54 32 826537 1 1 Labour 3 Yorkshire and The Humber 6
833 54 3 551738 1 1 Liberal Democrat 4 Yorkshire and The Humber 6
834 42 0 68378 1 1 UK Independence Party 8 Yorkshire and The Humber 6
835 54 19 790062 1 1 Conservative 1 Yorkshire and The Humber 6
836 2 0 753 1 1 Democratic Nationalists 197 Yorkshire and The Humber 6
837 1 0 72 1 1 Citizens for Undead Rights and Equality 198 Yorkshire and The Humber 6
838 1 0 331 1 1 The P.N.D.P. 219 Yorkshire and The Humber 6
839 1 0 722 1 1 Independent Voice for Halifax 223 Yorkshire and The Humber 6
840 1 0 95 1 1 The Youth Party 241 Yorkshire and The Humber 6
841 1 0 84 1 1 Virtue Currency Cognitive Appraisal Party 242 Yorkshire and The Humber 6
2344 1 0 227 6 6 Socialist Labour Party 6 Yorkshire and The Humber 6
2345 6 0 1689 6 6 Trade Unionist and Socialist Coalition 7 Yorkshire and The Humber 6
2346 1 0 99 6 6 Official Monster Raving Loony Party 12 Yorkshire and The Humber 6
2347 3 0 439 6 6 English Democrats 15 Yorkshire and The Humber 6
2348 23 0 9738 6 6 Social Democratic Party 38 Yorkshire and The Humber 6
2349 1 0 1160 6 6 British Democratic Party 45 Yorkshire and The Humber 6

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]);