certifications

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

10 rows where political_party_id = 260

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
17297 18312 18312 Hampshire Independents 260  
17438 18460 18460 Hampshire Independents 260  
18479 19616 19616 Hampshire Independents 260  
18662 19828 19828 Hampshire Independents 260  
18668 19834 19834 Hampshire Independents 260  
18847 20024 20024 Hampshire Independents 260  
18924 20108 20108 Hampshire Independents 260  
19913 21178 21178 Hampshire Independents 260  
19974 21246 21246 Hampshire Independents 260  
21238 22643 22643 Hampshire Independents 260  

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