certifications

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

358 rows where political_party_id = 40

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
397 409 409 British National Party 40  
444 458 458 British National Party 40  
724 748 748 British National Party 40  
939 969 969 British National Party 40  
1687 1740 1740 British National Party 40  
1857 1910 1910 British National Party 40  
2559 2634 2634 British National Party 40  
2817 2903 2903 British National Party 40  
4057 4198 4198 British National Party 40  
4109 4250 4250 British National Party 40  
4440 4600 4600 British National Party 40  
4619 4789 4789 British National Party 40  
4863 5044 5044 British National Party 40  
5224 5427 5427 British National Party 40  
5561 5785 5785 British National Party 40  
5957 6190 6190 British National Party 40  
6001 6235 6235 British National Party 40  
6324 6574 6574 British National Party 40  
8389 8730 8730 British National Party 40  
11768 12333 12333 British National Party 40  
13426 14129 14129 British National Party 40  
13439 14143 14143 British National Party 40  
13445 14149 14149 British National Party 40  
13471 14176 14176 British National Party 40  
13476 14181 14181 British National Party 40  
13502 14208 14208 British National Party 40  
13513 14220 14220 British National Party 40  
13532 14240 14240 British National Party 40  
13535 14243 14243 British National Party 40  
13545 14254 14254 British National Party 40  
13551 14262 14262 British National Party 40  
13559 14271 14271 British National Party 40  
13564 14277 14277 British National Party 40  
13584 14301 14301 British National Party 40  
13602 14321 14321 British National Party 40  
13609 14328 14328 British National Party 40  
13632 14356 14356 British National Party 40  
13644 14370 14370 British National Party 40  
13649 14375 14375 British National Party 40  
13656 14385 14385 British National Party 40  
13663 14393 14393 British National Party 40  
13667 14397 14397 British National Party 40  
13677 14407 14407 British National Party 40  
13685 14415 14415 British National Party 40  
13697 14429 14429 British National Party 40  
13708 14440 14440 British National Party 40  
13721 14453 14453 British National Party 40  
13728 14460 14460 British National Party 40  
13734 14466 14466 British National Party 40  
13740 14472 14472 British National Party 40  
13746 14480 14480 British National Party 40  
13754 14488 14488 British National Party 40  
13759 14493 14493 British National Party 40  
13767 14501 14501 British National Party 40  
13773 14507 14507 British National Party 40  
13777 14511 14511 British National Party 40  
13784 14519 14519 British National Party 40  
13788 14524 14524 British National Party 40  
13798 14534 14534 British National Party 40  
13812 14549 14549 British National Party 40  
13818 14555 14555 British National Party 40  
13822 14560 14560 British National Party 40  
13838 14578 14578 British National Party 40  
13844 14584 14584 British National Party 40  
13849 14591 14591 British National Party 40  
13855 14597 14597 British National Party 40  
13864 14606 14606 British National Party 40  
13891 14636 14636 British National Party 40  
13899 14645 14645 British National Party 40  
13906 14654 14654 British National Party 40  
13912 14660 14660 British National Party 40  
13918 14667 14667 British National Party 40  
13936 14685 14685 British National Party 40  
13950 14699 14699 British National Party 40  
13965 14715 14715 British National Party 40  
13971 14721 14721 British National Party 40  
13979 14729 14729 British National Party 40  
13983 14735 14735 British National Party 40  
13989 14741 14741 British National Party 40  
13993 14749 14749 British National Party 40  
14000 14758 14758 British National Party 40  
14005 14765 14765 British National Party 40  
14010 14770 14770 British National Party 40  
14016 14777 14777 British National Party 40  
14029 14790 14790 British National Party 40  
14038 14800 14800 British National Party 40  
14066 14834 14834 British National Party 40  
14108 14879 14879 British National Party 40  
14126 14899 14899 British National Party 40  
14132 14905 14905 British National Party 40  
14158 14932 14932 British National Party 40  
14163 14937 14937 British National Party 40  
14176 14950 14950 British National Party 40  
14185 14959 14959 British National Party 40  
14212 14987 14987 British National Party 40  
14219 14996 14996 British National Party 40  
14252 15034 15034 British National Party 40  
14257 15040 15040 British National Party 40  
14268 15052 15052 British National Party 40  
14284 15069 15069 British National Party 40  

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