certifications

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

212 rows where political_party_id = 7

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
7 8 8 Trade Unionist and Socialist Coalition 7  
21 21 21 Trade Unionist and Socialist Coalition 7  
121 123 123 Trade Unionist and Socialist Coalition 7  
128 130 130 Trade Unionist and Socialist Coalition 7  
134 136 136 Trade Unionist and Socialist Coalition 7  
168 172 172 Trade Unionist and Socialist Coalition 7  
282 291 291 Trade Unionist and Socialist Coalition 7  
311 320 320 Trade Unionist and Socialist Coalition 7  
324 333 333 Trade Unionist and Socialist Coalition 7  
389 401 401 Trade Unionist and Socialist Coalition 7  
395 407 407 Trade Unionist and Socialist Coalition 7  
461 477 477 Trade Unionist and Socialist Coalition 7  
486 504 504 Trade Unionist and Socialist Coalition 7  
515 536 536 Trade Unionist and Socialist Coalition 7  
521 542 542 Trade Unionist and Socialist Coalition 7  
527 548 548 Trade Unionist and Socialist Coalition 7  
595 617 617 Trade Unionist and Socialist Coalition 7  
648 671 671 Trade Unionist and Socialist Coalition 7  
664 686 686 Trade Unionist and Socialist Coalition 7  
671 693 693 Trade Unionist and Socialist Coalition 7  
734 758 758 Trade Unionist and Socialist Coalition 7  
768 794 794 Trade Unionist and Socialist Coalition 7  
781 807 807 Trade Unionist and Socialist Coalition 7  
829 859 859 Trade Unionist and Socialist Coalition 7  
882 912 912 Trade Unionist and Socialist Coalition 7  
888 918 918 Trade Unionist and Socialist Coalition 7  
895 925 925 Trade Unionist and Socialist Coalition 7  
911 941 941 Trade Unionist and Socialist Coalition 7  
919 949 949 Trade Unionist and Socialist Coalition 7  
950 981 981 Trade Unionist and Socialist Coalition 7  
984 1016 1016 Trade Unionist and Socialist Coalition 7  
1008 1040 1040 Trade Unionist and Socialist Coalition 7  
1014 1046 1046 Trade Unionist and Socialist Coalition 7  
1022 1054 1054 Trade Unionist and Socialist Coalition 7  
1034 1066 1066 Trade Unionist and Socialist Coalition 7  
1046 1079 1079 Trade Unionist and Socialist Coalition 7  
1065 1098 1098 Trade Unionist and Socialist Coalition 7  
1071 1104 1104 Trade Unionist and Socialist Coalition 7  
1095 1130 1130 Trade Unionist and Socialist Coalition 7  
1133 1169 1169 Trade Unionist and Socialist Coalition 7  
1190 1230 1230 Trade Unionist and Socialist Coalition 7  
1203 1243 1243 Trade Unionist and Socialist Coalition 7  
1237 1275 1275 Trade Unionist and Socialist Coalition 7  
1260 1299 1299 Trade Unionist and Socialist Coalition 7  
1345 1388 1388 Trade Unionist and Socialist Coalition 7  
1391 1437 1437 Trade Unionist and Socialist Coalition 7  
1400 1446 1446 Trade Unionist and Socialist Coalition 7  
1415 1461 1461 Trade Unionist and Socialist Coalition 7  
1423 1469 1469 Trade Unionist and Socialist Coalition 7  
1436 1482 1482 Trade Unionist and Socialist Coalition 7  
1455 1499 1499 Trade Unionist and Socialist Coalition 7  
1473 1519 1519 Trade Unionist and Socialist Coalition 7  
1490 1538 1538 Trade Unionist and Socialist Coalition 7  
1502 1550 1550 Trade Unionist and Socialist Coalition 7  
1527 1575 1575 Trade Unionist and Socialist Coalition 7  
1574 1625 1625 Trade Unionist and Socialist Coalition 7  
1585 1636 1636 Trade Unionist and Socialist Coalition 7  
1718 1773 1773 Trade Unionist and Socialist Coalition 7  
1725 1779 1779 Trade Unionist and Socialist Coalition 7  
1790 1844 1844 Trade Unionist and Socialist Coalition 7  
1796 1850 1850 Trade Unionist and Socialist Coalition 7  
1835 1888 1888 Trade Unionist and Socialist Coalition 7  
1855 1908 1908 Trade Unionist and Socialist Coalition 7  
1862 1915 1915 Trade Unionist and Socialist Coalition 7  
1898 1952 1952 Trade Unionist and Socialist Coalition 7  
1924 1978 1978 Trade Unionist and Socialist Coalition 7  
1930 1985 1985 Trade Unionist and Socialist Coalition 7  
1937 1991 1991 Trade Unionist and Socialist Coalition 7  
1943 1997 1997 Trade Unionist and Socialist Coalition 7  
1967 2022 2022 Trade Unionist and Socialist Coalition 7  
1976 2032 2032 Trade Unionist and Socialist Coalition 7  
1993 2050 2050 Trade Unionist and Socialist Coalition 7  
2006 2062 2062 Trade Unionist and Socialist Coalition 7  
2019 2076 2076 Trade Unionist and Socialist Coalition 7  
2039 2095 2095 Trade Unionist and Socialist Coalition 7  
2104 2163 2163 Trade Unionist and Socialist Coalition 7  
2111 2170 2170 Trade Unionist and Socialist Coalition 7  
2122 2182 2182 Trade Unionist and Socialist Coalition 7  
2203 2267 2267 Trade Unionist and Socialist Coalition 7  
2303 2368 2368 Trade Unionist and Socialist Coalition 7  
2338 2404 2404 Trade Unionist and Socialist Coalition 7  
2461 2531 2531 Trade Unionist and Socialist Coalition 7  
2467 2537 2537 Trade Unionist and Socialist Coalition 7  
2532 2607 2607 Trade Unionist and Socialist Coalition 7  
2538 2613 2613 Trade Unionist and Socialist Coalition 7  
2545 2620 2620 Trade Unionist and Socialist Coalition 7  
2557 2632 2632 Trade Unionist and Socialist Coalition 7  
2593 2669 2669 Trade Unionist and Socialist Coalition 7  
2608 2684 2684 Trade Unionist and Socialist Coalition 7  
2645 2723 2723 Trade Unionist and Socialist Coalition 7  
2660 2737 2737 Trade Unionist and Socialist Coalition 7  
2673 2751 2751 Trade Unionist and Socialist Coalition 7  
2680 2758 2758 Trade Unionist and Socialist Coalition 7  
2687 2766 2766 Trade Unionist and Socialist Coalition 7  
2729 2809 2809 Trade Unionist and Socialist Coalition 7  
2782 2866 2866 Trade Unionist and Socialist Coalition 7  
2810 2896 2896 Trade Unionist and Socialist Coalition 7  
2822 2908 2908 Trade Unionist and Socialist Coalition 7  
2828 2914 2914 Trade Unionist and Socialist Coalition 7  
2835 2921 2921 Trade Unionist and Socialist Coalition 7  

Next page

Advanced export

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

CSV options: 

CREATE TABLE "certifications" (
   [id] INTEGER PRIMARY KEY,
   [candidacy_id] INTEGER REFERENCES [candidacies]([id]),
   [political_party_id] INTEGER REFERENCES [political_parties]([id]),
   [adjunct_to_certification_id] INTEGER REFERENCES [certifications]([id])
);
CREATE INDEX [idx_certifications_adjunct_to_certification_id]
    ON [certifications] ([adjunct_to_certification_id]);
CREATE INDEX [idx_certifications_political_party_id]
    ON [certifications] ([political_party_id]);
CREATE INDEX [idx_certifications_candidacy_id]
    ON [certifications] ([candidacy_id]);