certifications
Data license: Open Parliament Licence · Data source: UK Parliament election results website
11 rows where political_party_id = 267
This data as json, CSV (advanced)
id ▼ | candidacy_id | political_party_id | adjunct_to_certification_id |
---|---|---|---|
17489 | 18519 18519 | Green Party Northern Ireland 267 | |
17495 | 18525 18525 | Green Party Northern Ireland 267 | |
17501 | 18531 18531 | Green Party Northern Ireland 267 | |
17507 | 18538 18538 | Green Party Northern Ireland 267 | |
18461 | 19594 19594 | Green Party Northern Ireland 267 | |
18494 | 19631 19631 | Green Party Northern Ireland 267 | |
19285 | 20501 20501 | Green Party Northern Ireland 267 | |
19884 | 21147 21147 | Green Party Northern Ireland 267 | |
20510 | 21841 21841 | Green Party Northern Ireland 267 | |
20553 | 21893 21893 | Green Party Northern Ireland 267 | |
20805 | 22172 22172 | Green Party Northern Ireland 267 |
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]);