home / psephology

certifications

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

11 rows where political_party_id = 68

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
1107 1142 1142 The North East Party 68  
2309 2374 2374 The North East Party 68  
2736 2815 2815 The North East Party 68  
3227 3327 3327 The North East Party 68  
4744 4920 4920 The North East Party 68  
7908 8223 8223 The North East Party 68  
9653 10067 10067 The North East Party 68  
11260 11784 11784 The North East Party 68  
12918 13580 13580 The North East Party 68  
18457 19590 19590 The North East Party 68  
21372 22799 22799 The North East Party 68  

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]);
Powered by Datasette · Queries took 5.536ms · Data license: Open Parliament Licence · Data source: UK Parliament election results website