certifications

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

14 rows where political_party_id = 17

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
137 139 139 Yorkshire First 17  
255 263 263 Yorkshire First 17  
608 630 630 Yorkshire First 17  
860 891 891 Yorkshire First 17  
1003 1035 1035 Yorkshire First 17  
1179 1218 1218 Yorkshire First 17  
1547 1595 1595 Yorkshire First 17  
1634 1687 1687 Yorkshire First 17  
1844 1897 1897 Yorkshire First 17  
1850 1903 1903 Yorkshire First 17  
1918 1972 1972 Yorkshire First 17  
2253 2317 2317 Yorkshire First 17  
2959 3050 3050 Yorkshire First 17  
3834 3966 3966 Yorkshire First 17  

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