certifications

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

19 rows where political_party_id = 141

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
5228 5431 5431 Women's Equality Party 141  
5579 5804 5804 Women's Equality Party 141  
6285 6530 6530 Women's Equality Party 141  
6499 6752 6752 Women's Equality Party 141  
6695 6954 6954 Women's Equality Party 141  
6726 6986 6986 Women's Equality Party 141  
6730 6990 6990 Women's Equality Party 141  
7495 7793 7793 Women's Equality Party 141  
7844 8160 8160 Women's Equality Party 141  
8717 9074 9074 Women's Equality Party 141  
10743 11230 11230 Women's Equality Party 141  
11166 11684 11684 Women's Equality Party 141  
12122 12710 12710 Women's Equality Party 141  
17920 19011 19011 Women's Equality Party 141  
18196 19306 19306 Women's Equality Party 141  
18824 20001 20001 Women's Equality Party 141  
19595 20839 20839 Women's Equality Party 141  
21373 22801 22801 Women's Equality Party 141  
21589 23051 23051 Women's Equality Party 141  

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