english_region_general_election_party_performances

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

54 rows where political_party_id = 4

✎ 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
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
106 59 0 145009 2 2 Liberal Democrat 4 West Midlands 2
107 59 0 122287 3 3 Liberal Democrat 4 West Midlands 2
108 58 0 213903 4 4 Liberal Democrat 4 West Midlands 2
163 75 2 219998 2 2 Liberal Democrat 4 North West 3
164 75 1 193053 3 3 Liberal Democrat 4 North West 3
165 74 1 277505 4 4 Liberal Democrat 4 North West 3
212 46 0 124039 2 2 Liberal Democrat 4 East Midlands 4
213 46 0 101612 3 3 Liberal Democrat 4 East Midlands 4
214 45 0 182656 4 4 Liberal Democrat 4 East Midlands 4
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
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
408 58 1 243191 2 2 Liberal Democrat 4 East of England 7
409 58 1 244054 3 3 Liberal Democrat 4 East of England 7
410 56 1 410849 4 4 Liberal Democrat 4 East of England 7
456 55 0 428927 2 2 Liberal Democrat 4 South West 8
457 55 1 448730 3 3 Liberal Democrat 4 South West 8
458 51 1 554504 4 4 Liberal Democrat 4 South West 8
499 29 0 77095 2 2 Liberal Democrat 4 North East 9
500 29 0 58409 3 3 Liberal Democrat 4 North East 9
501 29 0 85243 4 4 Liberal Democrat 4 North East 9
526 87 1 848382 5 5 Liberal Democrat 4 South East 1
539 56 0 213903 5 5 Liberal Democrat 4 West Midlands 2
553 72 0 277505 5 5 Liberal Democrat 4 North West 3
570 47 0 182665 5 5 Liberal Democrat 4 East Midlands 4
594 75 3 562564 5 5 Liberal Democrat 4 London 5
610 54 0 205225 5 5 Liberal Democrat 4 Yorkshire and The Humber 6
624 61 1 410849 5 5 Liberal Democrat 4 East of England 7
639 56 1 554504 5 5 Liberal Democrat 4 South West 8
655 27 0 85243 5 5 Liberal Democrat 4 North East 9
676 83 4 1124786 1 1 Liberal Democrat 4 South East 1
713 59 2 540280 1 1 Liberal Democrat 4 West Midlands 2
744 75 6 707774 1 1 Liberal Democrat 4 North West 3
766 46 0 463068 1 1 Liberal Democrat 4 East Midlands 4
796 73 7 751613 1 1 Liberal Democrat 4 London 5
833 54 3 551738 1 1 Liberal Democrat 4 Yorkshire and The Humber 6
850 58 4 692932 1 1 Liberal Democrat 4 East of England 7
875 55 15 962954 1 1 Liberal Democrat 4 South West 8
892 29 2 280468 1 1 Liberal Democrat 4 North East 9
2224 91 24 951222 6 6 Liberal Democrat 4 South East 1
2252 57 2 214493 6 6 Liberal Democrat 4 West Midlands 2
2273 71 3 242662 6 6 Liberal Democrat 4 North West 3
2300 47 0 136929 6 6 Liberal Democrat 4 East Midlands 4
2327 75 6 367424 6 6 Liberal Democrat 4 London 5
2353 54 1 158326 6 6 Liberal Democrat 4 Yorkshire and The Humber 6
2375 61 7 375642 6 6 Liberal Democrat 4 East of England 7
2401 58 22 686921 6 6 Liberal Democrat 4 South West 8
2419 27 0 65385 6 6 Liberal Democrat 4 North East 9

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