certifications

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

235 rows where political_party_id = 9

✖
✖

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
17 17 17 Co-operative Party 9 16 16
141 143 143 Co-operative Party 9 140 140
661 683 683 Co-operative Party 9 660 660
874 904 904 Co-operative Party 9 873 873
917 947 947 Co-operative Party 9 916 916
1208 1247 1247 Co-operative Party 9 1207 1207
1235 1273 1273 Co-operative Party 9 1234 1234
1322 1365 1365 Co-operative Party 9 1321 1321
1440 1485 1485 Co-operative Party 9 1439 1439
1447 1491 1491 Co-operative Party 9 1446 1446
1525 1573 1573 Co-operative Party 9 1524 1524
1590 1641 1641 Co-operative Party 9 1589 1589
1607 1659 1659 Co-operative Party 9 1606 1606
1723 1777 1777 Co-operative Party 9 1722 1722
1745 1799 1799 Co-operative Party 9 1744 1744
1786 1840 1840 Co-operative Party 9 1785 1785
1827 1880 1880 Co-operative Party 9 1826 1826
1867 1919 1919 Co-operative Party 9 1866 1866
1935 1989 1989 Co-operative Party 9 1934 1934
2004 2060 2060 Co-operative Party 9 2003 2003
2017 2074 2074 Co-operative Party 9 2016 2016
2024 2080 2080 Co-operative Party 9 2023 2023
2066 2123 2123 Co-operative Party 9 2065 2065
2101 2160 2160 Co-operative Party 9 2100 2100
2209 2273 2273 Co-operative Party 9 2208 2208
2250 2314 2314 Co-operative Party 9 2249 2249
2488 2557 2557 Co-operative Party 9 2487 2487
2525 2600 2600 Co-operative Party 9 2524 2524
2651 2728 2728 Co-operative Party 9 2650 2650
2700 2778 2778 Co-operative Party 9 2699 2699
2734 2813 2813 Co-operative Party 9 2733 2733
2850 2935 2935 Co-operative Party 9 2849 2849
3133 3232 3232 Co-operative Party 9 3132 3132
3202 3302 3302 Co-operative Party 9 3201 3201
3209 3309 3309 Co-operative Party 9 3208 3208
3232 3332 3332 Co-operative Party 9 3231 3231
3295 3399 3399 Co-operative Party 9 3294 3294
3335 3441 3441 Co-operative Party 9 3334 3334
3530 3645 3645 Co-operative Party 9 3529 3529
3630 3748 3748 Co-operative Party 9 3629 3629
3640 3758 3758 Co-operative Party 9 3639 3639
3830 3962 3962 Co-operative Party 9 3829 3829
3957 4093 4093 Co-operative Party 9 3956 3956
3976 4112 4112 Co-operative Party 9 3975 3975
4032 4172 4172 Co-operative Party 9 4031 4031
4065 4205 4205 Co-operative Party 9 4064 4064
4258 4411 4411 Co-operative Party 9 4257 4257
4380 4539 4539 Co-operative Party 9 4379 4379
4594 4764 4764 Co-operative Party 9 4593 4593
4722 4898 4898 Co-operative Party 9 4721 4721
4831 5013 5013 Co-operative Party 9 4830 4830
4850 5031 5031 Co-operative Party 9 4849 4849
4926 5111 5111 Co-operative Party 9 4925 4925
5003 5191 5191 Co-operative Party 9 5002 5002
5017 5204 5204 Co-operative Party 9 5016 5016
5079 5272 5272 Co-operative Party 9 5078 5078
5135 5335 5335 Co-operative Party 9 5134 5134
5203 5405 5405 Co-operative Party 9 5202 5202
5257 5461 5461 Co-operative Party 9 5256 5256
5273 5478 5478 Co-operative Party 9 5272 5272
5310 5518 5518 Co-operative Party 9 5309 5309
5417 5630 5630 Co-operative Party 9 5416 5416
5430 5644 5644 Co-operative Party 9 5429 5429
5443 5657 5657 Co-operative Party 9 5442 5442
5485 5701 5701 Co-operative Party 9 5484 5484
5494 5710 5710 Co-operative Party 9 5493 5493
5502 5719 5719 Co-operative Party 9 5501 5501
5535 5752 5752 Co-operative Party 9 5534 5534
5568 5791 5791 Co-operative Party 9 5567 5567
5690 5917 5917 Co-operative Party 9 5689 5689
5707 5933 5933 Co-operative Party 9 5706 5706
5927 6161 6161 Co-operative Party 9 5926 5926
5933 6166 6166 Co-operative Party 9 5932 5932
5970 6202 6202 Co-operative Party 9 5969 5969
5983 6216 6216 Co-operative Party 9 5982 5982
6029 6264 6264 Co-operative Party 9 6028 6028
6067 6303 6303 Co-operative Party 9 6066 6066
6073 6308 6308 Co-operative Party 9 6072 6072
6098 6335 6335 Co-operative Party 9 6097 6097
6195 6437 6437 Co-operative Party 9 6194 6194
6394 6645 6645 Co-operative Party 9 6393 6393
6410 6661 6661 Co-operative Party 9 6409 6409
6488 6742 6742 Co-operative Party 9 6487 6487
6494 6747 6747 Co-operative Party 9 6493 6493
6520 6773 6773 Co-operative Party 9 6519 6519
6531 6783 6783 Co-operative Party 9 6530 6530
6564 6817 6817 Co-operative Party 9 6563 6563
6596 6851 6851 Co-operative Party 9 6595 6595
6672 6930 6930 Co-operative Party 9 6671 6671
6751 7011 7011 Co-operative Party 9 6750 6750
6763 7022 7022 Co-operative Party 9 6762 6762
6835 7097 7097 Co-operative Party 9 6834 6834
7001 7270 7270 Co-operative Party 9 7000 7000
7144 7419 7419 Co-operative Party 9 7143 7143
7222 7498 7498 Co-operative Party 9 7221 7221
7307 7587 7587 Co-operative Party 9 7306 7306
7418 7710 7710 Co-operative Party 9 7417 7417
7551 7853 7853 Co-operative Party 9 7550 7550
7751 8059 8059 Co-operative Party 9 7750 7750
7880 8196 8196 Co-operative Party 9 7879 7879

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