certifications

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

24 rows where political_party_id = 10

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
19 19 19 National Front 10  
483 501 501 National Front 10  
695 718 718 National Front 10  
1841 1894 1894 National Front 10  
1998 2055 2055 National Front 10  
2460 2530 2530 National Front 10  
2775 2859 2859 National Front 10  
13687 14418 14418 National Front 10  
13730 14462 14462 National Front 10  
13845 14587 14587 National Front 10  
14470 15273 15273 National Front 10  
14745 15568 15568 National Front 10  
15050 15893 15893 National Front 10  
15244 16111 16111 National Front 10  
15278 16145 16145 National Front 10  
15524 16406 16406 National Front 10  
15678 16573 16573 National Front 10  
15888 16799 16799 National Front 10  
16205 17134 17134 National Front 10  
16240 17174 17174 National Front 10  
16263 17199 17199 National Front 10  
16832 17804 17804 National Front 10  
16910 17891 17891 National Front 10  
17077 18070 18070 National Front 10  

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