certifications

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

17 rows where political_party_id = 14

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
111 113 113 National Health Action Party 14  
616 638 638 National Health Action Party 14  
1172 1211 1211 National Health Action Party 14  
2084 2143 2143 National Health Action Party 14  
2565 2640 2640 National Health Action Party 14  
2599 2675 2675 National Health Action Party 14  
3122 3222 3222 National Health Action Party 14  
3192 3293 3293 National Health Action Party 14  
3318 3424 3424 National Health Action Party 14  
3444 3555 3555 National Health Action Party 14  
3732 3858 3858 National Health Action Party 14  
4418 4578 4578 National Health Action Party 14  
4802 4985 4985 National Health Action Party 14  
6102 6339 6339 National Health Action Party 14  
6373 6625 6625 National Health Action Party 14  
6426 6677 6677 National Health Action Party 14  
19436 20665 20665 National Health Action Party 14  

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