home / psephology

certifications

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

1,689 rows where political_party_id = 8

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
8 9 9 UK Independence Party 8  
14 15 15 UK Independence Party 8  
27 28 28 UK Independence Party 8  
32 34 34 UK Independence Party 8  
37 39 39 UK Independence Party 8  
43 45 45 UK Independence Party 8  
48 50 50 UK Independence Party 8  
54 56 56 UK Independence Party 8  
59 61 61 UK Independence Party 8  
65 67 67 UK Independence Party 8  
71 73 73 UK Independence Party 8  
76 78 78 UK Independence Party 8  
81 83 83 UK Independence Party 8  
86 88 88 UK Independence Party 8  
91 93 93 UK Independence Party 8  
96 98 98 UK Independence Party 8  
101 103 103 UK Independence Party 8  
106 108 108 UK Independence Party 8  
112 114 114 UK Independence Party 8  
122 124 124 UK Independence Party 8  
129 131 131 UK Independence Party 8  
135 137 137 UK Independence Party 8  
143 145 145 UK Independence Party 8  
147 149 149 UK Independence Party 8  
151 154 154 UK Independence Party 8  
156 159 159 UK Independence Party 8  
162 166 166 UK Independence Party 8  
169 173 173 UK Independence Party 8  
174 178 178 UK Independence Party 8  
179 183 183 UK Independence Party 8  
184 188 188 UK Independence Party 8  
189 194 194 UK Independence Party 8  
208 214 214 UK Independence Party 8  
217 223 223 UK Independence Party 8  
226 233 233 UK Independence Party 8  
232 240 240 UK Independence Party 8  
238 246 246 UK Independence Party 8  
249 257 257 UK Independence Party 8  
254 262 262 UK Independence Party 8  
260 268 268 UK Independence Party 8  
266 274 274 UK Independence Party 8  
271 279 279 UK Independence Party 8  
277 286 286 UK Independence Party 8  
283 292 292 UK Independence Party 8  
289 298 298 UK Independence Party 8  
295 304 304 UK Independence Party 8  
301 310 310 UK Independence Party 8  
306 315 315 UK Independence Party 8  
312 321 321 UK Independence Party 8  
317 326 326 UK Independence Party 8  
325 334 334 UK Independence Party 8  
330 339 339 UK Independence Party 8  
334 343 343 UK Independence Party 8  
339 348 348 UK Independence Party 8  
345 354 354 UK Independence Party 8  
350 361 361 UK Independence Party 8  
356 367 367 UK Independence Party 8  
361 372 372 UK Independence Party 8  
366 377 377 UK Independence Party 8  
371 382 382 UK Independence Party 8  
375 386 386 UK Independence Party 8  
380 391 391 UK Independence Party 8  
385 396 396 UK Independence Party 8  
390 402 402 UK Independence Party 8  
396 408 408 UK Independence Party 8  
404 417 417 UK Independence Party 8  
408 421 421 UK Independence Party 8  
414 427 427 UK Independence Party 8  
420 433 433 UK Independence Party 8  
425 438 438 UK Independence Party 8  
431 444 444 UK Independence Party 8  
436 449 449 UK Independence Party 8  
443 457 457 UK Independence Party 8  
449 464 464 UK Independence Party 8  
455 470 470 UK Independence Party 8  
462 478 478 UK Independence Party 8  
467 484 484 UK Independence Party 8  
472 489 489 UK Independence Party 8  
478 495 495 UK Independence Party 8  
487 505 505 UK Independence Party 8  
492 510 510 UK Independence Party 8  
498 517 517 UK Independence Party 8  
504 524 524 UK Independence Party 8  
510 531 531 UK Independence Party 8  
516 537 537 UK Independence Party 8  
522 543 543 UK Independence Party 8  
528 549 549 UK Independence Party 8  
535 556 556 UK Independence Party 8  
540 561 561 UK Independence Party 8  
545 566 566 UK Independence Party 8  
550 571 571 UK Independence Party 8  
555 576 576 UK Independence Party 8  
561 582 582 UK Independence Party 8  
563 585 585 UK Independence Party 8  
568 590 590 UK Independence Party 8  
573 595 595 UK Independence Party 8  
578 600 600 UK Independence Party 8  
584 606 606 UK Independence Party 8  
589 611 611 UK Independence Party 8  
596 618 618 UK Independence Party 8  

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