english_region_general_election_party_performances

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

25 rows where political_party_id = 56

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: constituency_contested_count, cumulative_vote_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
144 1 0 2049 2 2 Liberal 56 North West 3
145 2 0 2449 3 3 Liberal 56 North West 3
146 8 0 4910 4 4 Liberal 56 North West 3
197 1 0 304 4 4 Liberal 56 East Midlands 4
265 1 0 101 4 4 Liberal 56 London 5
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
395 2 0 1304 2 2 Liberal 56 East of England 7
445 1 0 470 3 3 Liberal 56 South West 8
446 7 0 4225 4 4 Liberal 56 South West 8
487 1 0 615 4 4 Liberal 56 North East 9
547 8 0 4910 5 5 Liberal 56 North West 3
566 1 0 304 5 5 Liberal 56 East Midlands 4
586 1 0 101 5 5 Liberal 56 London 5
605 1 0 721 5 5 Liberal 56 Yorkshire and The Humber 6
635 7 0 4225 5 5 Liberal 56 South West 8
651 1 0 615 5 5 Liberal 56 North East 9
739 1 0 3327 1 1 Liberal 56 North West 3
788 1 0 539 1 1 Liberal 56 London 5
829 1 0 1418 1 1 Liberal 56 Yorkshire and The Humber 6
872 1 0 1108 1 1 Liberal 56 South West 8
2270 5 0 3924 6 6 Liberal 56 North West 3
2297 1 0 278 6 6 Liberal 56 East Midlands 4
2398 5 0 1692 6 6 Liberal 56 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]);