certifications

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

155 rows where political_party_id = 261

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
17308 18323 18323 Workers Party of Britain 261  
17316 18332 18332 Workers Party of Britain 261  
17370 18389 18389 Workers Party of Britain 261  
17375 18394 18394 Workers Party of Britain 261  
17405 18426 18426 Workers Party of Britain 261  
17449 18473 18473 Workers Party of Britain 261  
17465 18491 18491 Workers Party of Britain 261  
17482 18510 18510 Workers Party of Britain 261  
17589 18634 18634 Workers Party of Britain 261  
17617 18668 18668 Workers Party of Britain 261  
17629 18682 18682 Workers Party of Britain 261  
17650 18706 18706 Workers Party of Britain 261  
17678 18737 18737 Workers Party of Britain 261  
17687 18747 18747 Workers Party of Britain 261  
17696 18756 18756 Workers Party of Britain 261  
17737 18802 18802 Workers Party of Britain 261  
17761 18833 18833 Workers Party of Britain 261  
17768 18841 18841 Workers Party of Britain 261  
17773 18847 18847 Workers Party of Britain 261  
17791 18866 18866 Workers Party of Britain 261  
17862 18944 18944 Workers Party of Britain 261  
17875 18958 18958 Workers Party of Britain 261  
17893 18980 18980 Workers Party of Britain 261  
17900 18989 18989 Workers Party of Britain 261  
17906 18996 18996 Workers Party of Britain 261  
17919 19010 19010 Workers Party of Britain 261  
17956 19047 19047 Workers Party of Britain 261  
18008 19101 19101 Workers Party of Britain 261  
18037 19133 19133 Workers Party of Britain 261  
18047 19142 19142 Workers Party of Britain 261  
18053 19149 19149 Workers Party of Britain 261  
18059 19156 19156 Workers Party of Britain 261  
18068 19165 19165 Workers Party of Britain 261  
18079 19177 19177 Workers Party of Britain 261  
18095 19194 19194 Workers Party of Britain 261  
18137 19245 19245 Workers Party of Britain 261  
18208 19320 19320 Workers Party of Britain 261  
18220 19335 19335 Workers Party of Britain 261  
18244 19360 19360 Workers Party of Britain 261  
18250 19366 19366 Workers Party of Britain 261  
18262 19379 19379 Workers Party of Britain 261  
18270 19387 19387 Workers Party of Britain 261  
18310 19429 19429 Workers Party of Britain 261  
18332 19452 19452 Workers Party of Britain 261  
18359 19478 19478 Workers Party of Britain 261  
18373 19496 19496 Workers Party of Britain 261  
18398 19524 19524 Workers Party of Britain 261  
18429 19557 19557 Workers Party of Britain 261  
18437 19566 19566 Workers Party of Britain 261  
18446 19579 19579 Workers Party of Britain 261  
18583 19734 19734 Workers Party of Britain 261  
18595 19750 19750 Workers Party of Britain 261  
18608 19765 19765 Workers Party of Britain 261  
18631 19792 19792 Workers Party of Britain 261  
18681 19851 19851 Workers Party of Britain 261  
18818 19995 19995 Workers Party of Britain 261  
18842 20020 20020 Workers Party of Britain 261  
18886 20069 20069 Workers Party of Britain 261  
18905 20090 20090 Workers Party of Britain 261  
18918 20103 20103 Workers Party of Britain 261  
18937 20121 20121 Workers Party of Britain 261  
18975 20160 20160 Workers Party of Britain 261  
18988 20175 20175 Workers Party of Britain 261  
19000 20189 20189 Workers Party of Britain 261  
19007 20195 20195 Workers Party of Britain 261  
19014 20202 20202 Workers Party of Britain 261  
19032 20220 20220 Workers Party of Britain 261  
19111 20311 20311 Workers Party of Britain 261  
19156 20359 20359 Workers Party of Britain 261  
19248 20461 20461 Workers Party of Britain 261  
19279 20495 20495 Workers Party of Britain 261  
19298 20514 20514 Workers Party of Britain 261  
19317 20534 20534 Workers Party of Britain 261  
19331 20549 20549 Workers Party of Britain 261  
19346 20564 20564 Workers Party of Britain 261  
19387 20610 20610 Workers Party of Britain 261  
19395 20619 20619 Workers Party of Britain 261  
19402 20626 20626 Workers Party of Britain 261  
19409 20633 20633 Workers Party of Britain 261  
19422 20650 20650 Workers Party of Britain 261  
19503 20735 20735 Workers Party of Britain 261  
19509 20742 20742 Workers Party of Britain 261  
19543 20783 20783 Workers Party of Britain 261  
19553 20793 20793 Workers Party of Britain 261  
19557 20797 20797 Workers Party of Britain 261  
19588 20832 20832 Workers Party of Britain 261  
19620 20868 20868 Workers Party of Britain 261  
19663 20914 20914 Workers Party of Britain 261  
19691 20941 20941 Workers Party of Britain 261  
19759 21011 21011 Workers Party of Britain 261  
19782 21037 21037 Workers Party of Britain 261  
19828 21086 21086 Workers Party of Britain 261  
19888 21152 21152 Workers Party of Britain 261  
19894 21158 21158 Workers Party of Britain 261  
19953 21222 21222 Workers Party of Britain 261  
19990 21265 21265 Workers Party of Britain 261  
20016 21294 21294 Workers Party of Britain 261  
20027 21306 21306 Workers Party of Britain 261  
20033 21312 21312 Workers Party of Britain 261  
20047 21329 21329 Workers Party of Britain 261  

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