english_region_general_election_party_performances

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

186 rows where english_region_id = 5

✎ 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
229 23 0 6814 2 2 Trade Unionist and Socialist Coalition 7 London 5
230 1 0 49 2 2 National Front 10 London 5
231 1 0 72 2 2 Official Monster Raving Loony Party 12 London 5
232 2 0 274 3 3 Official Monster Raving Loony Party 12 London 5
233 4 0 736 4 4 Official Monster Raving Loony Party 12 London 5
234 3 0 2027 2 2 National Health Action Party 14 London 5
235 3 0 410 2 2 English Democrats 15 London 5
236 1 0 93 3 3 English Democrats 15 London 5
237 1 0 520 4 4 English Democrats 15 London 5
238 3 0 950 2 2 All People's Party 26 London 5
239 4 0 1571 2 2 Left Unity 27 London 5
240 1 0 20 2 2 The Republican Socialist Party 28 London 5
241 9 0 2085 2 2 Cannabis Is Safer Than Alcohol 29 London 5
242 5 0 1102 2 2 Communities United Party 30 London 5
243 2 0 393 4 4 Communities United Party 30 London 5
244 2 0 147 2 2 Red Flag - Anti-Corruption 31 London 5
245 1 0 78 2 2 The 30-50 Coalition 32 London 5
246 3 0 392 2 2 The Whig Party 33 London 5
247 3 0 571 2 2 Christian Party, Proclaiming Christ's Lordship 34 London 5
248 1 0 125 2 2 Communist Party of Britain 36 London 5
249 1 0 44 2 2 Liberty GB 37 London 5
250 2 0 168 4 4 Social Democratic Party 38 London 5
251 3 0 562 2 2 British National Party 40 London 5
252 5 0 1909 3 3 British National Party 40 London 5
253 1 0 510 4 4 British National Party 40 London 5
254 1 0 201 2 2 Pirate Party UK 46 London 5
255 1 0 172 3 3 Pirate Party UK 46 London 5
256 2 0 194 2 2 The Socialist Party of Great Britain 47 London 5
257 2 0 53 3 3 The Socialist Party of Great Britain 47 London 5
258 6 0 455 2 2 Workers Revolutionary Party 50 London 5
259 4 0 634 3 3 Workers Revolutionary Party 50 London 5
260 5 0 524 4 4 Workers Revolutionary Party 50 London 5
261 11 0 2488 2 2 Christian Peoples Alliance 54 London 5
262 13 0 2719 3 3 Christian Peoples Alliance 54 London 5
263 19 0 4407 4 4 Christian Peoples Alliance 54 London 5
264 1 0 54 2 2 The Above and Beyond Party 55 London 5
265 1 0 101 4 4 Liberal 56 London 5
266 1 0 291 2 2 The Peace Party - Non-violence, Justice, Environment 57 London 5
267 3 0 177 2 2 Class War 58 London 5
268 1 0 57 2 2 The UK Progressive Democracy Party 61 London 5
269 1 0 221 2 2 Putting Croydon First! 62 London 5
270 1 0 39 2 2 Europeans Party 66 London 5
271 2 0 627 2 2 National Liberal Party - True Liberalism 67 London 5
272 1 0 43 3 3 Young People's Party 72 London 5
273 1 0 50 4 4 Young People's Party 72 London 5
274 1 0 108 2 2 Socialist Equality Party 74 London 5
275 1 0 37 4 4 Socialist Equality Party 74 London 5
276 4 0 736 2 2 Animal Welfare Party 76 London 5
277 3 0 673 3 3 Animal Welfare Party 76 London 5
278 3 0 1264 4 4 Animal Welfare Party 76 London 5
279 1 0 102 2 2 Communist League Election Campaign 77 London 5
280 1 0 7 3 3 Communist League Election Campaign 77 London 5
281 1 0 42 4 4 Communist League Election Campaign 77 London 5
282 1 0 28 2 2 Campaign 78 London 5
283 1 0 77 2 2 The U(niversal) Party 79 London 5
284 1 0 45 2 2 Hoi Polloi 81 London 5
285 1 0 115 2 2 Alliance for Green Socialism 84 London 5
286 1 0 49 3 3 Alliance for Green Socialism 84 London 5
287 1 0 71 4 4 Alliance for Green Socialism 84 London 5
288 1 0 23 2 2 New Independent Centralists 85 London 5
289 2 0 1056 2 2 People Before Profit 86 London 5
290 1 0 74 2 2 Democratic Reform Party 87 London 5
291 73 0 171670 2 2 Green Party 2 London 5
292 67 0 67561 3 3 Green Party 2 London 5
293 65 0 115527 4 4 Green Party 2 London 5
294 73 45 1545048 2 2 Labour 3 London 5
295 73 49 2086595 3 3 Labour 3 London 5
296 73 49 1812810 4 4 Labour 3 London 5
297 73 1 272544 2 2 Liberal Democrat 4 London 5
298 73 3 336725 3 3 Liberal Democrat 4 London 5
299 72 3 562564 4 4 Liberal Democrat 4 London 5
300 73 0 286981 2 2 UK Independence Party 8 London 5
301 48 0 49369 3 3 UK Independence Party 8 London 5
302 5 0 1060 4 4 UK Independence Party 8 London 5
303 1 0 26 2 2 Magna Carta Conservation Party Great Britain 117 London 5
304 1 0 50 2 2 The Eccentric Party of Great Britain 118 London 5
305 1 0 18 2 2 The Realists' Party 119 London 5
306 1 0 61 3 3 The Realists' Party 119 London 5
307 1 0 85 3 3 Concordia 137 London 5
308 3 0 435 3 3 Friends Party 138 London 5
309 2 0 1090 3 3 Women's Equality Party 141 London 5
310 1 0 50 3 3 Populist Party 142 London 5
311 50 0 51735 4 4 The Brexit Party 153 London 5
312 2 0 270 4 4 Renew 159 London 5
313 1 0 3891 4 4 The Independent Group for Change 160 London 5
314 1 0 71 4 4 Advance Together 163 London 5
315 1 0 47 4 4 Touch Love Worldwide (UK) 169 London 5
316 73 27 1233386 2 2 Conservative 1 London 5
317 73 21 1268800 3 3 Conservative 1 London 5
318 73 21 1205129 4 4 Conservative 1 London 5
578 1 0 71 5 5 Trade Unionist and Socialist Coalition 7 London 5
579 4 0 736 5 5 Official Monster Raving Loony Party 12 London 5
580 1 0 520 5 5 English Democrats 15 London 5
581 2 0 393 5 5 Communities United Party 30 London 5
582 2 0 168 5 5 Social Democratic Party 38 London 5
583 1 0 510 5 5 British National Party 40 London 5
584 5 0 524 5 5 Workers Revolutionary Party 50 London 5
585 19 0 4407 5 5 Christian Peoples Alliance 54 London 5
586 1 0 101 5 5 Liberal 56 London 5
587 1 0 50 5 5 Young People's Party 72 London 5

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