english_region_general_election_party_performances

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

54 rows where political_party_id = 3

✎ 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
46 83 4 804774 2 2 Labour 3 South East 1
47 83 8 1326380 3 3 Labour 3 South East 1
48 84 8 1029966 4 4 Labour 3 South East 1
103 59 25 865075 2 2 Labour 3 West Midlands 2
104 59 24 1175095 3 3 Labour 3 West Midlands 2
105 59 15 918123 4 4 Labour 3 West Midlands 2
160 75 51 1502047 2 2 Labour 3 North West 3
161 75 54 1972632 3 3 Labour 3 North West 3
162 74 41 1638258 4 4 Labour 3 North West 3
209 46 14 705767 2 2 Labour 3 East Midlands 4
210 46 15 954635 3 3 Labour 3 East Midlands 4
211 46 8 740975 4 4 Labour 3 East Midlands 4
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
357 54 33 956837 2 2 Labour 3 Yorkshire and The Humber 6
358 54 37 1276912 3 3 Labour 3 Yorkshire and The Humber 6
359 54 28 989787 4 4 Labour 3 Yorkshire and The Humber 6
405 58 4 649321 2 2 Labour 3 East of England 7
406 58 7 1012357 3 3 Labour 3 East of England 7
407 58 5 749906 4 4 Labour 3 East of England 7
453 55 4 501684 2 2 Labour 3 South West 8
454 55 7 875213 3 3 Labour 3 South West 8
455 55 6 713226 4 4 Labour 3 South West 8
496 29 26 557100 2 2 Labour 3 North East 9
497 29 26 709738 3 3 Labour 3 North East 9
498 29 19 532127 4 4 Labour 3 North East 9
525 91 8 1029966 5 5 Labour 3 South East 1
538 57 14 918123 5 5 Labour 3 West Midlands 2
552 72 41 1638258 5 5 Labour 3 North West 3
569 47 8 740975 5 5 Labour 3 East Midlands 4
593 75 52 1812810 5 5 Labour 3 London 5
609 54 27 989787 5 5 Labour 3 Yorkshire and The Humber 6
623 61 5 749906 5 5 Labour 3 East of England 7
638 58 7 713226 5 5 Labour 3 South West 8
654 27 19 532127 5 5 Labour 3 North East 9
675 83 4 697567 1 1 Labour 3 South East 1
712 59 24 808101 1 1 Labour 3 West Midlands 2
743 75 47 1289934 1 1 Labour 3 North West 3
765 46 15 661869 1 1 Labour 3 East Midlands 4
795 73 38 1245625 1 1 Labour 3 London 5
832 54 32 826537 1 1 Labour 3 Yorkshire and The Humber 6
849 58 2 564581 1 1 Labour 3 East of England 7
874 55 4 426910 1 1 Labour 3 South West 8
891 29 25 518263 1 1 Labour 3 North East 9
2230 91 36 1067897 6 6 Labour 3 South East 1
2257 57 38 824433 6 6 Labour 3 West Midlands 2
2277 72 65 1361196 6 6 Labour 3 North West 3
2305 47 29 753723 6 6 Labour 3 East Midlands 4
2330 75 59 1432622 6 6 Labour 3 London 5
2356 54 43 907767 6 6 Labour 3 Yorkshire and The Humber 6
2380 61 27 834896 6 6 Labour 3 East of England 7
2405 58 24 682080 6 6 Labour 3 South West 8
2421 27 26 504569 6 6 Labour 3 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]);