certifications

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

13 rows where political_party_id = 72

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
1272 1311 1311 Young People's Party 72  
1347 1390 1390 Young People's Party 72  
4506 4668 4668 Young People's Party 72  
4512 4675 4675 Young People's Party 72  
4876 5057 5057 Young People's Party 72  
8053 8373 8373 Young People's Party 72  
8115 8443 8443 Young People's Party 72  
8634 8985 8985 Young People's Party 72  
10345 10800 10800 Young People's Party 72  
11344 11871 11871 Young People's Party 72  
11429 11967 11967 Young People's Party 72  
12026 12607 12607 Young People's Party 72  
21597 23060 23060 Young People's Party 72  

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