certifications

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

15 rows where political_party_id = 57

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
767 793 793 The Peace Party 57  
1510 1558 1558 The Peace Party 57  
1706 1760 1760 The Peace Party 57  
3436 3546 3546 The Peace Party 57  
5070 5262 5262 The Peace Party 57  
5238 5441 5441 The Peace Party 57  
8243 8574 8574 The Peace Party 57  
8404 8746 8746 The Peace Party 57  
11574 12122 12122 The Peace Party 57  
11779 12345 12345 The Peace Party 57  
14942 15777 15777 The Peace Party 57  
15140 15998 15998 The Peace Party 57  
17166 18171 18171 The Peace Party 57  
18892 20075 20075 The Peace Party 57  
19118 20318 20318 The Peace Party 57  

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