certifications

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

10 rows where political_party_id = 27

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
223 230 230 Left Unity 27  
244 252 252 Left Unity 27  
533 554 554 Left Unity 27  
614 636 636 Left Unity 27  
1209 1248 1248 Left Unity 27  
1242 1281 1281 Left Unity 27  
1299 1341 1341 Left Unity 27  
1947 2001 2001 Left Unity 27  
3221 3321 3321 Left Unity 27  
3498 3613 3613 Left Unity 27  

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