certifications

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

3,780 rows where political_party_id = 4

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
4 5 5 Liberal Democrat 4  
12 13 13 Liberal Democrat 4  
18 18 18 Liberal Democrat 4  
25 26 26 Liberal Democrat 4  
30 32 32 Liberal Democrat 4  
36 38 38 Liberal Democrat 4  
41 43 43 Liberal Democrat 4  
47 49 49 Liberal Democrat 4  
52 54 54 Liberal Democrat 4  
58 60 60 Liberal Democrat 4  
63 65 65 Liberal Democrat 4  
68 70 70 Liberal Democrat 4  
74 76 76 Liberal Democrat 4  
80 82 82 Liberal Democrat 4  
85 87 87 Liberal Democrat 4  
90 92 92 Liberal Democrat 4  
95 97 97 Liberal Democrat 4  
100 102 102 Liberal Democrat 4  
104 106 106 Liberal Democrat 4  
110 112 112 Liberal Democrat 4  
115 117 117 Liberal Democrat 4  
120 122 122 Liberal Democrat 4  
127 129 129 Liberal Democrat 4  
133 135 135 Liberal Democrat 4  
142 144 144 Liberal Democrat 4  
146 148 148 Liberal Democrat 4  
150 153 153 Liberal Democrat 4  
155 158 158 Liberal Democrat 4  
161 165 165 Liberal Democrat 4  
166 170 170 Liberal Democrat 4  
173 177 177 Liberal Democrat 4  
178 182 182 Liberal Democrat 4  
183 187 187 Liberal Democrat 4  
188 193 193 Liberal Democrat 4  
224 231 231 Liberal Democrat 4  
230 238 238 Liberal Democrat 4  
237 245 245 Liberal Democrat 4  
245 253 253 Liberal Democrat 4  
253 261 261 Liberal Democrat 4  
259 267 267 Liberal Democrat 4  
265 273 273 Liberal Democrat 4  
270 278 278 Liberal Democrat 4  
276 285 285 Liberal Democrat 4  
281 290 290 Liberal Democrat 4  
287 296 296 Liberal Democrat 4  
294 303 303 Liberal Democrat 4  
299 308 308 Liberal Democrat 4  
305 314 314 Liberal Democrat 4  
310 319 319 Liberal Democrat 4  
316 325 325 Liberal Democrat 4  
321 330 330 Liberal Democrat 4  
329 338 338 Liberal Democrat 4  
333 342 342 Liberal Democrat 4  
338 347 347 Liberal Democrat 4  
343 352 352 Liberal Democrat 4  
349 360 360 Liberal Democrat 4  
354 365 365 Liberal Democrat 4  
360 371 371 Liberal Democrat 4  
365 376 376 Liberal Democrat 4  
370 381 381 Liberal Democrat 4  
374 385 385 Liberal Democrat 4  
379 390 390 Liberal Democrat 4  
384 395 395 Liberal Democrat 4  
388 400 400 Liberal Democrat 4  
394 406 406 Liberal Democrat 4  
402 415 415 Liberal Democrat 4  
407 420 420 Liberal Democrat 4  
413 426 426 Liberal Democrat 4  
418 431 431 Liberal Democrat 4  
424 437 437 Liberal Democrat 4  
430 443 443 Liberal Democrat 4  
435 448 448 Liberal Democrat 4  
441 455 455 Liberal Democrat 4  
448 463 463 Liberal Democrat 4  
453 468 468 Liberal Democrat 4  
460 476 476 Liberal Democrat 4  
466 483 483 Liberal Democrat 4  
471 488 488 Liberal Democrat 4  
477 494 494 Liberal Democrat 4  
482 500 500 Liberal Democrat 4  
491 509 509 Liberal Democrat 4  
497 516 516 Liberal Democrat 4  
502 522 522 Liberal Democrat 4  
508 529 529 Liberal Democrat 4  
514 535 535 Liberal Democrat 4  
520 541 541 Liberal Democrat 4  
526 547 547 Liberal Democrat 4  
534 555 555 Liberal Democrat 4  
539 560 560 Liberal Democrat 4  
544 565 565 Liberal Democrat 4  
549 570 570 Liberal Democrat 4  
554 575 575 Liberal Democrat 4  
560 581 581 Liberal Democrat 4  
567 589 589 Liberal Democrat 4  
572 594 594 Liberal Democrat 4  
577 599 599 Liberal Democrat 4  
583 605 605 Liberal Democrat 4  
588 610 610 Liberal Democrat 4  
593 615 615 Liberal Democrat 4  
599 621 621 Liberal Democrat 4  

Next page

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