certifications

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

16 rows where political_party_id = 71

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
1218 1257 1257 Scottish Socialist Party 71  
1407 1453 1453 Scottish Socialist Party 71  
1443 1488 1488 Scottish Socialist Party 71  
2613 2689 2689 Scottish Socialist Party 71  
13440 14144 14144 Scottish Socialist Party 71  
14369 15162 15162 Scottish Socialist Party 71  
14498 15300 15300 Scottish Socialist Party 71  
14644 15456 15456 Scottish Socialist Party 71  
14828 15659 15659 Scottish Socialist Party 71  
14836 15667 15667 Scottish Socialist Party 71  
14851 15682 15682 Scottish Socialist Party 71  
15466 16344 16344 Scottish Socialist Party 71  
16039 16956 16956 Scottish Socialist Party 71  
16044 16962 16962 Scottish Socialist Party 71  
18762 19938 19938 Scottish Socialist Party 71  
20358 21672 21672 Scottish Socialist Party 71  

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