certifications

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

34 rows where political_party_id = 267

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
193 198 198 Green Party Northern Ireland 267  
204 210 210 Green Party Northern Ireland 267  
1326 1369 1369 Green Party Northern Ireland 267  
2379 2446 2446 Green Party Northern Ireland 267  
3665 3783 3783 Green Party Northern Ireland 267  
4003 4143 4143 Green Party Northern Ireland 267  
4010 4150 4150 Green Party Northern Ireland 267  
4012 4152 4152 Green Party Northern Ireland 267  
4932 5117 5117 Green Party Northern Ireland 267  
5795 6022 6022 Green Party Northern Ireland 267  
6541 6793 6793 Green Party Northern Ireland 267  
6867 7129 7129 Green Party Northern Ireland 267  
7912 8227 8227 Green Party Northern Ireland 267  
9683 10098 10098 Green Party Northern Ireland 267  
10007 10443 10443 Green Party Northern Ireland 267  
10220 10666 10666 Green Party Northern Ireland 267  
10387 10846 10846 Green Party Northern Ireland 267  
12947 13611 13611 Green Party Northern Ireland 267  
13141 13818 13818 Green Party Northern Ireland 267  
13623 14347 14347 Green Party Northern Ireland 267  
15810 16716 16716 Green Party Northern Ireland 267  
16457 17407 17407 Green Party Northern Ireland 267  
16698 17667 17667 Green Party Northern Ireland 267  
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

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