certifications

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

10 rows where political_party_id = 268

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
17535 18574 18574 Alliance for Democracy and Freedom 268  
17643 18698 18698 Alliance for Democracy and Freedom 268  
18731 19904 19904 Alliance for Democracy and Freedom 268  
19055 20245 20245 Alliance for Democracy and Freedom 268  
19188 20393 20393 Alliance for Democracy and Freedom 268  
19207 20415 20415 Alliance for Democracy and Freedom 268  
19234 20445 20445 Alliance for Democracy and Freedom 268  
19576 20818 20818 Alliance for Democracy and Freedom 268  
20197 21495 21495 Alliance for Democracy and Freedom 268  
21577 23039 23039 Alliance for Democracy and Freedom 268  

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