certifications

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

15 rows where political_party_id = 263

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
17389 18408 18408 Climate Party 263  
17395 18415 18415 Climate Party 263  
17856 18938 18938 Climate Party 263  
18151 19258 19258 Climate Party 263  
18184 19294 19294 Climate Party 263  
18339 19458 19458 Climate Party 263  
18648 19811 19811 Climate Party 263  
18885 20067 20067 Climate Party 263  
19312 20529 20529 Climate Party 263  
19608 20854 20854 Climate Party 263  
19996 21271 21271 Climate Party 263  
20377 21691 21691 Climate Party 263  
21322 22736 22736 Climate Party 263  
21501 22943 22943 Climate Party 263  
21520 22966 22966 Climate Party 263  

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