english_region_general_election_party_performances

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

51 rows where political_party_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: constituency_contested_count, constituency_won_count, general_election_id, english_region_id

id ▼ constituency_contested_count constituency_won_count cumulative_vote_count general_election_id political_party_id english_region_id
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
109 59 0 412770 2 2 UK Independence Party 8 West Midlands 2
110 32 0 50106 3 3 UK Independence Party 8 West Midlands 2
111 2 0 1068 4 4 UK Independence Party 8 West Midlands 2
166 75 0 459071 2 2 UK Independence Party 8 North West 3
167 42 0 68946 3 3 UK Independence Party 8 North West 3
168 4 0 2333 4 4 UK Independence Party 8 North West 3
215 46 0 351777 2 2 UK Independence Party 8 East Midlands 4
216 33 0 56358 3 3 UK Independence Party 8 East Midlands 4
217 2 0 1508 4 4 UK Independence Party 8 East Midlands 4
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
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
411 58 1 478517 2 2 UK Independence Party 8 East of England 7
412 36 0 77793 3 3 UK Independence Party 8 East of England 7
413 2 0 1169 4 4 UK Independence Party 8 East of England 7
459 55 0 384546 2 2 UK Independence Party 8 South West 8
460 24 0 33160 3 3 UK Independence Party 8 South West 8
461 2 0 1227 4 4 UK Independence Party 8 South West 8
502 29 0 198823 2 2 UK Independence Party 8 North East 9
503 25 0 49348 3 3 UK Independence Party 8 North East 9
504 2 0 1736 4 4 UK Independence Party 8 North East 9
527 13 0 7807 5 5 UK Independence Party 8 South East 1
540 2 0 1068 5 5 UK Independence Party 8 West Midlands 2
554 5 0 2333 5 5 UK Independence Party 8 North West 3
571 2 0 1508 5 5 UK Independence Party 8 East Midlands 4
595 5 0 1060 5 5 UK Independence Party 8 London 5
611 3 0 983 5 5 UK Independence Party 8 Yorkshire and The Humber 6
625 2 0 1169 5 5 UK Independence Party 8 East of England 7
640 2 0 1227 5 5 UK Independence Party 8 South West 8
656 2 0 1736 5 5 UK Independence Party 8 North East 9
677 82 0 177260 1 1 UK Independence Party 8 South East 1
714 57 0 105685 1 1 UK Independence Party 8 West Midlands 2
745 70 0 103782 1 1 UK Independence Party 8 North West 3
767 44 0 72659 1 1 UK Independence Party 8 East Midlands 4
797 60 0 59452 1 1 UK Independence Party 8 London 5
834 42 0 68378 1 1 UK Independence Party 8 Yorkshire and The Humber 6
851 56 0 123177 1 1 UK Independence Party 8 East of England 7
876 55 0 123975 1 1 UK Independence Party 8 South West 8
893 24 0 32196 1 1 UK Independence Party 8 North East 9
2225 5 0 723 6 6 UK Independence Party 8 South East 1
2253 5 0 3368 6 6 UK Independence Party 8 West Midlands 2
2274 1 0 124 6 6 UK Independence Party 8 North West 3
2328 2 0 239 6 6 UK Independence Party 8 London 5
2376 3 0 445 6 6 UK Independence Party 8 East of England 7
2402 4 0 718 6 6 UK Independence Party 8 South West 8

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