certifications
Data license: Open Parliament Licence · Data source: Original Data Source
18 rows where political_party_id = 69
This data as json, CSV (advanced)
id ▼ | candidacy_id | political_party_id | adjunct_to_certification_id |
---|---|---|---|
1115 | 1150 1150 | Traditional Unionist Voice 69 | |
1881 | 1934 1934 | Traditional Unionist Voice 69 | |
2175 | 2238 2238 | Traditional Unionist Voice 69 | |
2349 | 2416 2416 | Traditional Unionist Voice 69 | |
2382 | 2450 2450 | Traditional Unionist Voice 69 | |
3004 | 3096 3096 | Traditional Unionist Voice 69 | |
3268 | 3372 3372 | Traditional Unionist Voice 69 | |
5771 | 5998 5998 | Traditional Unionist Voice 69 | |
13613 | 14334 14334 | Traditional Unionist Voice 69 | |
14543 | 15348 15348 | Traditional Unionist Voice 69 | |
14573 | 15380 15380 | Traditional Unionist Voice 69 | |
15314 | 16184 16184 | Traditional Unionist Voice 69 | |
15615 | 16505 16505 | Traditional Unionist Voice 69 | |
15780 | 16681 16681 | Traditional Unionist Voice 69 | |
15809 | 16715 16715 | Traditional Unionist Voice 69 | |
16429 | 17377 17377 | Traditional Unionist Voice 69 | |
16456 | 17406 17406 | Traditional Unionist Voice 69 | |
16696 | 17665 17665 | Traditional Unionist Voice 69 |
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]);