country_general_election_party_performances

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

25 rows where political_party_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: constituency_contested_count, constituency_won_count, cumulative_vote_count, general_election_id, country_id

id ▼ constituency_contested_count constituency_won_count cumulative_vote_count general_election_id political_party_id country_id
151 614 1 3862775 2 2 UK Independence Party 8 Great Britain 1
152 378 0 594068 3 3 UK Independence Party 8 Great Britain 1
153 42 0 22194 4 4 UK Independence Party 8 Great Britain 1
378 533 1 3611367 2 2 UK Independence Party 8 England 2
379 336 0 557390 3 3 UK Independence Party 8 England 2
380 35 0 18891 4 4 UK Independence Party 8 England 2
471 10 0 18324 2 2 UK Independence Party 8 Northern Ireland 4
472 2 0 623 4 4 UK Independence Party 8 Northern Ireland 4
516 41 0 47078 2 2 UK Independence Party 8 Scotland 5
517 10 0 5302 3 3 UK Independence Party 8 Scotland 5
518 7 0 3303 4 4 UK Independence Party 8 Scotland 5
569 40 0 204330 2 2 UK Independence Party 8 Wales 6
570 32 0 31376 3 3 UK Independence Party 8 Wales 6
607 43 0 22194 5 5 UK Independence Party 8 Great Britain 1
666 36 0 18891 5 5 UK Independence Party 8 England 2
696 2 0 623 5 5 UK Independence Party 8 Northern Ireland 4
711 7 0 3303 5 5 UK Independence Party 8 Scotland 5
765 558 0 919471 1 1 UK Independence Party 8 Great Britain 1
886 490 0 866564 1 1 UK Independence Party 8 England 2
986 28 0 17223 1 1 UK Independence Party 8 Scotland 5
1006 40 0 35684 1 1 UK Independence Party 8 Wales 6
2361 24 0 6530 6 6 UK Independence Party 8 Great Britain 1
2445 20 0 5617 6 6 UK Independence Party 8 England 2
2516 3 0 313 6 6 UK Independence Party 8 Scotland 5
2538 1 0 600 6 6 UK Independence Party 8 Wales 6

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "country_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]),
   [country_id] INTEGER REFERENCES [countries]([id])
);
CREATE INDEX [idx_country_general_election_party_performances_country_id]
    ON [country_general_election_party_performances] ([country_id]);
CREATE INDEX [idx_country_general_election_party_performances_political_party_id]
    ON [country_general_election_party_performances] ([political_party_id]);
CREATE INDEX [idx_country_general_election_party_performances_general_election_id]
    ON [country_general_election_party_performances] ([general_election_id]);