certifications

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

12 rows where political_party_id = 74

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
1399 1445 1445 Socialist Equality Party 74  
1685 1738 1738 Socialist Equality Party 74  
8386 8727 8727 Socialist Equality Party 74  
8749 9108 9108 Socialist Equality Party 74  
9409 9809 9809 Socialist Equality Party 74  
11757 12321 12321 Socialist Equality Party 74  
12155 12748 12748 Socialist Equality Party 74  
12721 13366 13366 Socialist Equality Party 74  
15543 16428 16428 Socialist Equality Party 74  
16027 16943 16943 Socialist Equality Party 74  
19091 20287 20287 Socialist Equality Party 74  
19168 20373 20373 Socialist Equality Party 74  

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