certifications

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

8 rows where political_party_id = 160

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
7469 7763 7763 The Independent Group for Change 160  
8443 8787 8787 The Independent Group for Change 160  
9089 9469 9469 The Independent Group for Change 160  
10711 11194 11194 The Independent Group for Change 160  
11827 12396 12396 The Independent Group for Change 160  
11833 12402 12402 The Independent Group for Change 160  
12387 12997 12997 The Independent Group for Change 160  
12393 13003 13003 The Independent Group for Change 160  

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