country_general_election_party_performances

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

98 rows where country_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: constituency_contested_count, constituency_won_count, general_election_id

country_id 1 ✖

  • Scotland · 98 ✖
id ▼ constituency_contested_count constituency_won_count cumulative_vote_count general_election_id political_party_id country_id
493 9 0 1720 2 2 Trade Unionist and Socialist Coalition 7 Scotland 5
494 2 0 289 2 2 National Front 10 Scotland 5
495 1 0 122 2 2 Left Unity 27 Scotland 5
496 8 0 1759 2 2 Cannabis Is Safer Than Alcohol 29 Scotland 5
497 2 0 1467 2 2 Christian Party, Proclaiming Christ's Lordship 34 Scotland 5
498 2 0 1720 3 3 Christian Party, Proclaiming Christ's Lordship 34 Scotland 5
499 1 0 460 4 4 Christian Party, Proclaiming Christ's Lordship 34 Scotland 5
500 1 0 136 2 2 Communist Party of Britain 36 Scotland 5
501 1 0 148 3 3 Social Democratic Party 38 Scotland 5
502 1 0 114 4 4 Social Democratic Party 38 Scotland 5
503 1 0 240 4 4 Christian Peoples Alliance 54 Scotland 5
504 4 0 875 2 2 Scottish Socialist Party 71 Scotland 5
505 1 0 58 2 2 Socialist Equality Party 74 Scotland 5
506 1 0 177 3 3 Something New 82 Scotland 5
510 59 1 707147 2 2 Labour 3 Scotland 5
511 59 7 717007 3 3 Labour 3 Scotland 5
512 59 1 511838 4 4 Labour 3 Scotland 5
513 59 1 219675 2 2 Liberal Democrat 4 Scotland 5
514 59 4 179062 3 3 Liberal Democrat 4 Scotland 5
515 59 4 263417 4 4 Liberal Democrat 4 Scotland 5
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
519 59 56 1454436 2 2 Scottish National Party 11 Scotland 5
520 59 35 977568 3 3 Scottish National Party 11 Scotland 5
521 59 48 1242380 4 4 Scottish National Party 11 Scotland 5
522 1 0 405 4 4 Libertarian Party 130 Scotland 5
523 1 0 132 3 3 Scotland's Independence Referendum Party 139 Scotland 5
524 1 0 337 3 3 Women's Equality Party 141 Scotland 5
525 1 0 224 3 3 Independent Sovereign Democratic Britain 145 Scotland 5
526 15 0 13243 4 4 The Brexit Party 153 Scotland 5
527 1 0 138 4 4 Renew 159 Scotland 5
528 2 0 465 4 4 Scottish Family Party 165 Scotland 5
529 1 0 588 4 4 Veterans and People's Party 167 Scotland 5
530 59 1 434097 2 2 Conservative 1 Scotland 5
531 59 13 757949 3 3 Conservative 1 Scotland 5
532 59 6 692939 4 4 Conservative 1 Scotland 5
704 1 0 460 5 5 Christian Party, Proclaiming Christ's Lordship 34 Scotland 5
705 1 0 114 5 5 Social Democratic Party 38 Scotland 5
706 1 0 240 5 5 Christian Peoples Alliance 54 Scotland 5
707 1 0 588 5 5 Young People's Party 72 Scotland 5
709 57 1 511838 5 5 Labour 3 Scotland 5
710 57 2 263417 5 5 Liberal Democrat 4 Scotland 5
711 7 0 3303 5 5 UK Independence Party 8 Scotland 5
712 57 48 1242380 5 5 Scottish National Party 11 Scotland 5
713 1 0 405 5 5 Libertarian Party 130 Scotland 5
714 26 0 13243 5 5 The Brexit Party 153 Scotland 5
715 1 0 138 5 5 Renew 159 Scotland 5
716 2 0 465 5 5 Scottish Family Party 165 Scotland 5
717 57 6 692939 5 5 Conservative 1 Scotland 5
974 5 0 1673 1 1 Socialist Labour Party 6 Scotland 5
975 10 0 3530 1 1 Trade Unionist and Socialist Coalition 7 Scotland 5
976 1 0 835 1 1 Christian Party, Proclaiming Christ's Lordship 34 Scotland 5
977 1 0 179 1 1 Communist Party of Britain 36 Scotland 5
978 13 0 8910 1 1 British National Party 40 Scotland 5
979 1 0 128 1 1 Pirate Party UK 46 Scotland 5
980 1 0 389 1 1 Liberal 56 Scotland 5
981 10 0 3157 1 1 Scottish Socialist Party 71 Scotland 5
982 1 0 48 1 1 Communist League Election Campaign 77 Scotland 5
984 59 41 1035528 1 1 Labour 3 Scotland 5
985 59 11 465471 1 1 Liberal Democrat 4 Scotland 5
986 28 0 17223 1 1 UK Independence Party 8 Scotland 5
987 59 6 491386 1 1 Scottish National Party 11 Scotland 5
988 1 0 57 1 1 Land Party 123 Scotland 5
989 59 1 412905 1 1 Conservative 1 Scotland 5
990 1 0 138 1 1 Scotland Against Crooked Lawyers 180 Scotland 5
991 2 0 290 1 1 The Scottish Jacobite Party 182 Scotland 5
992 1 0 534 1 1 Trust 188 Scotland 5
993 1 0 93 1 1 The Joy of Talk 228 Scotland 5
1030 31 0 39205 2 2 Scottish Green Party 255 Scotland 5
1031 3 0 5886 3 3 Scottish Green Party 255 Scotland 5
1032 22 0 28122 4 4 Scottish Green Party 255 Scotland 5
1033 32 0 28122 5 5 Scottish Green Party 255 Scotland 5
1034 20 0 16827 1 1 Scottish Green Party 255 Scotland 5
2507 3 0 788 6 6 Socialist Labour Party 6 Scotland 5
2508 4 0 1523 6 6 Trade Unionist and Socialist Coalition 7 Scotland 5
2509 2 0 806 6 6 Christian Party, Proclaiming Christ's Lordship 34 Scotland 5
2510 3 0 516 6 6 Communist Party of Britain 36 Scotland 5
2511 2 0 426 6 6 Social Democratic Party 38 Scotland 5
2512 1 0 481 6 6 Liberal 56 Scotland 5
2513 2 0 1007 6 6 Scottish Socialist Party 71 Scotland 5
2514 1 0 178 6 6 Socialist Equality Party 74 Scotland 5
2515 57 6 234228 6 6 Liberal Democrat 4 Scotland 5
2516 3 0 313 6 6 UK Independence Party 8 Scotland 5
2517 57 9 724758 6 6 Scottish National Party 11 Scotland 5
2518 16 0 5425 6 6 Scottish Family Party 165 Scotland 5
2519 57 5 307344 6 6 Conservative 1 Scotland 5
2520 57 37 851897 6 6 Labour 3 Scotland 5
2521 44 0 92685 6 6 Scottish Green Party 255 Scotland 5
2522 1 0 230 6 6 Heritage Party 256 Scotland 5
2523 19 0 11784 6 6 Alba Party 258 Scotland 5
2524 2 0 614 6 6 British Unionist Party B.U.P. 259 Scotland 5
2525 2 0 415 6 6 Workers Party of Britain 261 Scotland 5
2526 2 0 304 6 6 Sovereignty 262 Scotland 5
2527 2 0 678 6 6 Independence for Scotland Party 265 Scotland 5
2528 1 0 113 6 6 Freedom Alliance 269 Scotland 5
2529 4 0 536 6 6 Scottish Libertarian Party 276 Scotland 5
2530 57 0 167979 6 6 Reform UK 257 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]);