certifications

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

10 rows where political_party_id = 159

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
7455 7748 7748 Renew 159  
7997 8317 8317 Renew 159  
8248 8580 8580 Renew 159  
9393 9791 9791 Renew 159  
10694 11177 11177 Renew 159  
11296 11821 11821 Renew 159  
11580 12129 12129 Renew 159  
12699 13343 13343 Renew 159  
21604 23067 23067 Renew 159  
21620 23084 23084 Renew 159  

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