english_region_general_election_party_performances

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

21 rows where political_party_id = 40

✎ 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
138 1 0 718 3 3 British National Party 40 North West 3
193 2 0 608 2 2 British National Party 40 East Midlands 4
194 1 0 322 3 3 British National Party 40 East Midlands 4
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
336 1 0 225 2 2 British National Party 40 Yorkshire and The Humber 6
386 1 0 108 2 2 British National Party 40 East of England 7
387 2 0 640 3 3 British National Party 40 East of England 7
437 1 0 164 2 2 British National Party 40 South West 8
484 1 0 991 3 3 British National Party 40 North East 9
583 1 0 510 5 5 British National Party 40 London 5
666 26 0 30618 1 1 British National Party 40 South East 1
708 38 0 73394 1 1 British National Party 40 West Midlands 2
735 38 0 70032 1 1 British National Party 40 North West 3
760 34 0 69706 1 1 British National Party 40 East Midlands 4
783 34 0 52095 1 1 British National Party 40 London 5
828 48 0 104167 1 1 British National Party 40 Yorkshire and The Humber 6
845 40 0 59505 1 1 British National Party 40 East of England 7
870 19 0 20866 1 1 British National Party 40 South West 8
889 29 0 51940 1 1 British National Party 40 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]);