certifications
Data license: Open Parliament Licence · Data source: Original Data Source
15 rows where political_party_id = 36
This data as json, CSV (advanced)
id ▼ | candidacy_id | political_party_id | adjunct_to_certification_id |
---|---|---|---|
290 | 299 299 | Communist Party of Britain 36 | |
913 | 943 943 | Communist Party of Britain 36 | |
1425 | 1471 1471 | Communist Party of Britain 36 | |
2135 | 2195 2195 | Communist Party of Britain 36 | |
2298 | 2363 2363 | Communist Party of Britain 36 | |
2364 | 2431 2431 | Communist Party of Britain 36 | |
2647 | 2725 2725 | Communist Party of Britain 36 | |
2910 | 2999 2999 | Communist Party of Britain 36 | |
3414 | 3524 3524 | Communist Party of Britain 36 | |
14098 | 14869 14869 | Communist Party of Britain 36 | |
14359 | 15151 15151 | Communist Party of Britain 36 | |
14859 | 15690 15690 | Communist Party of Britain 36 | |
15741 | 16638 16638 | Communist Party of Britain 36 | |
15801 | 16705 16705 | Communist Party of Britain 36 | |
16351 | 17295 17295 | Communist Party of Britain 36 |
Advanced export
JSON shape: default, array, newline-delimited, object
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]);