country_general_election_party_performances

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

18 rows where political_party_id = 38

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: constituency_contested_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
33 2 0 125 2 2 Social Democratic Party 38 Great Britain 1
34 6 0 469 3 3 Social Democratic Party 38 Great Britain 1
35 20 0 3295 4 4 Social Democratic Party 38 Great Britain 1
270 2 0 125 2 2 Social Democratic Party 38 England 2
271 5 0 321 3 3 Social Democratic Party 38 England 2
272 17 0 3000 4 4 Social Democratic Party 38 England 2
501 1 0 148 3 3 Social Democratic Party 38 Scotland 5
502 1 0 114 4 4 Social Democratic Party 38 Scotland 5
544 2 0 181 4 4 Social Democratic Party 38 Wales 6
585 20 0 3295 5 5 Social Democratic Party 38 Great Britain 1
645 17 0 3000 5 5 Social Democratic Party 38 England 2
705 1 0 114 5 5 Social Democratic Party 38 Scotland 5
720 2 0 181 5 5 Social Democratic Party 38 Wales 6
738 2 0 1551 1 1 Social Democratic Party 38 Great Britain 1
861 2 0 1551 1 1 Social Democratic Party 38 England 2
2342 122 0 33811 6 6 Social Democratic Party 38 Great Britain 1
2428 120 0 33385 6 6 Social Democratic Party 38 England 2
2511 2 0 426 6 6 Social Democratic Party 38 Scotland 5

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