certifications

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

9 rows where political_party_id = 25

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
213 219 219 People Before Profit Alliance 25  
4021 4161 4161 People Before Profit Alliance 25  
4954 5142 5142 People Before Profit Alliance 25  
7178 7455 7455 People Before Profit Alliance 25  
8123 8451 8451 People Before Profit Alliance 25  
14784 15613 15613 People Before Profit Alliance 25  
17494 18524 18524 People Before Profit Alliance 25  
17514 18545 18545 People Before Profit Alliance 25  
18722 19893 19893 People Before Profit Alliance 25  

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