certifications

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

16 rows where political_party_id = 264

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
17425 18447 18447 Party of Women 264  
17545 18584 18584 Party of Women 264  
17821 18900 18900 Party of Women 264  
18346 19465 19465 Party of Women 264  
18698 19868 19868 Party of Women 264  
19099 20297 20297 Party of Women 264  
19201 20408 20408 Party of Women 264  
19227 20437 20437 Party of Women 264  
19781 21036 21036 Party of Women 264  
20009 21285 21285 Party of Women 264  
20077 21361 21361 Party of Women 264  
20436 21754 21754 Party of Women 264  
20619 21965 21965 Party of Women 264  
20721 22077 22077 Party of Women 264  
21020 22406 22406 Party of Women 264  
21191 22590 22590 Party of Women 264  

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