certifications

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

25 rows where political_party_id = 46

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
484 502 502 Pirate Party UK 46  
2103 2162 2162 Pirate Party UK 46  
2110 2169 2169 Pirate Party UK 46  
2869 2955 2955 Pirate Party UK 46  
2916 3005 3005 Pirate Party UK 46  
3500 3615 3615 Pirate Party UK 46  
4191 4336 4336 Pirate Party UK 46  
4381 4540 4540 Pirate Party UK 46  
4820 5003 5003 Pirate Party UK 46  
5043 5231 5231 Pirate Party UK 46  
5564 5788 5788 Pirate Party UK 46  
5714 5940 5940 Pirate Party UK 46  
5916 6151 6151 Pirate Party UK 46  
6250 6495 6495 Pirate Party UK 46  
6722 6982 6982 Pirate Party UK 46  
6727 6987 6987 Pirate Party UK 46  
13651 14378 14378 Pirate Party UK 46  
14012 14773 14773 Pirate Party UK 46  
14242 15022 15022 Pirate Party UK 46  
14414 15211 15211 Pirate Party UK 46  
14830 15661 15661 Pirate Party UK 46  
15377 16252 16252 Pirate Party UK 46  
15551 16436 16436 Pirate Party UK 46  
16551 17508 17508 Pirate Party UK 46  
17195 18203 18203 Pirate Party UK 46  

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