certifications

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

8 rows where political_party_id = 168

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
8461 8807 8807 Independent Network 168  
11852 12421 12421 Independent Network 168  
11856 12427 12427 Independent Network 168  
17544 18583 18583 Independent Network 168  
18061 19158 19158 Independent Network 168  
19761 21014 21014 Independent Network 168  
20495 21823 21823 Independent Network 168  
21291 22702 22702 Independent Network 168  

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