certifications

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

15 rows where political_party_id = 35

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
288 297 297 Respect Party 35  
322 331 331 Respect Party 35  
442 456 456 Respect Party 35  
1540 1588 1588 Respect Party 35  
13647 14373 14373 Respect Party 35  
13690 14421 14421 Respect Party 35  
13747 14481 14481 Respect Party 35  
13856 14598 14598 Respect Party 35  
13879 14621 14621 Respect Party 35  
14358 15150 15150 Respect Party 35  
14687 15505 15505 Respect Party 35  
14800 15630 15630 Respect Party 35  
15548 16433 16433 Respect Party 35  
16009 16925 16925 Respect Party 35  
16102 17023 17023 Respect Party 35  

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