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 - Non-violence, Justice, Environment 57  
1510 1558 1558 The Peace Party - Non-violence, Justice, Environment 57  
1706 1760 1760 The Peace Party - Non-violence, Justice, Environment 57  
3436 3546 3546 The Peace Party - Non-violence, Justice, Environment 57  
5070 5262 5262 The Peace Party - Non-violence, Justice, Environment 57  
5238 5441 5441 The Peace Party - Non-violence, Justice, Environment 57  
8243 8574 8574 The Peace Party - Non-violence, Justice, Environment 57  
8404 8746 8746 The Peace Party - Non-violence, Justice, Environment 57  
11574 12122 12122 The Peace Party - Non-violence, Justice, Environment 57  
11779 12345 12345 The Peace Party - Non-violence, Justice, Environment 57  
14942 15777 15777 The Peace Party - Non-violence, Justice, Environment 57  
15140 15998 15998 The Peace Party - Non-violence, Justice, Environment 57  
17166 18171 18171 The Peace Party - Non-violence, Justice, Environment 57  
18892 20075 20075 The Peace Party - Non-violence, Justice, Environment 57  
19118 20318 20318 The Peace Party - Non-violence, Justice, Environment 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]);