certifications

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

6 rows where political_party_id = 272

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
17868 18951 18951 English Constitution Party 272  
18124 19227 19227 English Constitution Party 272  
20299 21605 21605 English Constitution Party 272  
20702 22056 22056 English Constitution Party 272  
21437 22870 22870 English Constitution Party 272  
21635 23101 23101 English Constitution Party 272  

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