certifications

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

220 rows where political_party_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
5 6 6 Plaid Cymru 5  
13 14 14 Plaid Cymru 5  
53 55 55 Plaid Cymru 5  
69 71 71 Plaid Cymru 5  
355 366 366 Plaid Cymru 5  
454 469 469 Plaid Cymru 5  
485 503 503 Plaid Cymru 5  
594 616 616 Plaid Cymru 5  
647 670 670 Plaid Cymru 5  
656 679 679 Plaid Cymru 5  
663 685 685 Plaid Cymru 5  
670 692 692 Plaid Cymru 5  
682 705 705 Plaid Cymru 5  
688 711 711 Plaid Cymru 5  
722 746 746 Plaid Cymru 5  
835 865 865 Plaid Cymru 5  
840 870 870 Plaid Cymru 5  
936 966 966 Plaid Cymru 5  
967 998 998 Plaid Cymru 5  
1081 1115 1115 Plaid Cymru 5  
1472 1518 1518 Plaid Cymru 5  
1789 1843 1843 Plaid Cymru 5  
2038 2094 2094 Plaid Cymru 5  
2140 2201 2201 Plaid Cymru 5  
2228 2292 2292 Plaid Cymru 5  
2234 2298 2298 Plaid Cymru 5  
2268 2332 2332 Plaid Cymru 5  
2320 2386 2386 Plaid Cymru 5  
2327 2393 2393 Plaid Cymru 5  
2556 2631 2631 Plaid Cymru 5  
2658 2735 2735 Plaid Cymru 5  
2694 2773 2773 Plaid Cymru 5  
2752 2832 2832 Plaid Cymru 5  
3330 3436 3436 Plaid Cymru 5  
3337 3443 3443 Plaid Cymru 5  
3419 3529 3529 Plaid Cymru 5  
3485 3600 3600 Plaid Cymru 5  
3492 3607 3607 Plaid Cymru 5  
3791 3923 3923 Plaid Cymru 5  
3824 3957 3957 Plaid Cymru 5  
3840 3972 3972 Plaid Cymru 5  
3846 3978 3978 Plaid Cymru 5  
3876 4009 4009 Plaid Cymru 5  
3891 4025 4025 Plaid Cymru 5  
4129 4272 4272 Plaid Cymru 5  
4222 4372 4372 Plaid Cymru 5  
4244 4397 4397 Plaid Cymru 5  
4332 4491 4491 Plaid Cymru 5  
4367 4527 4527 Plaid Cymru 5  
4376 4536 4536 Plaid Cymru 5  
4385 4544 4544 Plaid Cymru 5  
4387 4546 4546 Plaid Cymru 5  
4396 4555 4555 Plaid Cymru 5  
4403 4562 4562 Plaid Cymru 5  
4433 4593 4593 Plaid Cymru 5  
4527 4692 4692 Plaid Cymru 5  
4534 4699 4699 Plaid Cymru 5  
4612 4782 4782 Plaid Cymru 5  
4637 4808 4808 Plaid Cymru 5  
4726 4902 4902 Plaid Cymru 5  
5042 5230 5230 Plaid Cymru 5  
5311 5519 5519 Plaid Cymru 5  
5508 5725 5725 Plaid Cymru 5  
5600 5826 5826 Plaid Cymru 5  
5670 5897 5897 Plaid Cymru 5  
5678 5905 5905 Plaid Cymru 5  
5708 5934 5934 Plaid Cymru 5  
5750 5977 5977 Plaid Cymru 5  
5752 5979 5979 Plaid Cymru 5  
5952 6185 6185 Plaid Cymru 5  
6032 6267 6267 Plaid Cymru 5  
6063 6300 6300 Plaid Cymru 5  
6111 6349 6349 Plaid Cymru 5  
6594 6850 6850 Plaid Cymru 5  
6597 6852 6852 Plaid Cymru 5  
6667 6926 6926 Plaid Cymru 5  
6718 6978 6978 Plaid Cymru 5  
6725 6985 6985 Plaid Cymru 5  
6967 7235 7235 Plaid Cymru 5  
6998 7268 7268 Plaid Cymru 5  
7011 7281 7281 Plaid Cymru 5  
7016 7286 7286 Plaid Cymru 5  
7049 7320 7320 Plaid Cymru 5  
7061 7332 7332 Plaid Cymru 5  
7295 7575 7575 Plaid Cymru 5  
7404 7697 7697 Plaid Cymru 5  
7501 7800 7800 Plaid Cymru 5  
7546 7849 7849 Plaid Cymru 5  
7553 7855 7855 Plaid Cymru 5  
7559 7861 7861 Plaid Cymru 5  
7567 7869 7869 Plaid Cymru 5  
7572 7874 7874 Plaid Cymru 5  
7598 7900 7900 Plaid Cymru 5  
7683 7990 7990 Plaid Cymru 5  
7688 7995 7995 Plaid Cymru 5  
7766 8074 8074 Plaid Cymru 5  
7791 8102 8102 Plaid Cymru 5  
7885 8201 8201 Plaid Cymru 5  
8213 8540 8540 Plaid Cymru 5  
8480 8825 8825 Plaid Cymru 5  

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