certifications

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

13 rows where political_party_id = 73

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
1370 1414 1414 Lincolnshire Independents Lincolnshire First 73  
1479 1526 1526 Lincolnshire Independents Lincolnshire First 73  
1992 2049 2049 Lincolnshire Independents Lincolnshire First 73  
2050 2106 2106 Lincolnshire Independents Lincolnshire First 73  
2980 3071 3071 Lincolnshire Independents Lincolnshire First 73  
9461 9867 9867 Lincolnshire Independents Lincolnshire First 73  
11549 12093 12093 Lincolnshire Independents Lincolnshire First 73  
12776 13427 13427 Lincolnshire Independents Lincolnshire First 73  
14909 15742 15742 Lincolnshire Independents Lincolnshire First 73  
15483 16361 16361 Lincolnshire Independents Lincolnshire First 73  
16405 17352 17352 Lincolnshire Independents Lincolnshire First 73  
18861 20040 20040 Lincolnshire Independents Lincolnshire First 73  
20485 21810 21810 Lincolnshire Independents Lincolnshire First 73  

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