certifications

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

21,640 rows

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ candidacy_id political_party_id adjunct_to_certification_id
1 1 1 Conservative 1  
2 2 2 Green Party 2  
3 4 4 Labour 3  
4 5 5 Liberal Democrat 4  
5 6 6 Plaid Cymru 5  
6 7 7 Socialist Labour Party 6  
7 8 8 Trade Unionist and Socialist Coalition 7  
8 9 9 UK Independence Party 8  
9 10 10 Conservative 1  
10 11 11 Green Party 2  
11 12 12 Labour 3  
12 13 13 Liberal Democrat 4  
13 14 14 Plaid Cymru 5  
14 15 15 UK Independence Party 8  
15 16 16 Conservative 1  
16 17 17 Labour 3  
17 17 17 Co-operative Party 9 16 16
18 18 18 Liberal Democrat 4  
19 19 19 National Front 10  
20 20 20 Scottish National Party 11  
21 21 21 Trade Unionist and Socialist Coalition 7  
22 22 22 Conservative 1  
23 23 23 Scottish Green Party 255  
24 25 25 Labour 3  
25 26 26 Liberal Democrat 4  
26 27 27 Scottish National Party 11  
27 28 28 UK Independence Party 8  
28 29 29 Conservative 1  
29 31 31 Labour 3  
30 32 32 Liberal Democrat 4  
31 33 33 Scottish National Party 11  
32 34 34 UK Independence Party 8  
33 35 35 Conservative 1  
34 36 36 Green Party 2  
35 37 37 Labour 3  
36 38 38 Liberal Democrat 4  
37 39 39 UK Independence Party 8  
38 40 40 Conservative 1  
39 41 41 Green Party 2  
40 42 42 Labour 3  
41 43 43 Liberal Democrat 4  
42 44 44 Official Monster Raving Loony Party 12  
43 45 45 UK Independence Party 8  
44 46 46 Conservative 1  
45 47 47 Green Party 2  
46 48 48 Labour 3  
47 49 49 Liberal Democrat 4  
48 50 50 UK Independence Party 8  
49 51 51 Conservative 1  
50 52 52 Green Party 2  
51 53 53 Labour 3  
52 54 54 Liberal Democrat 4  
53 55 55 Plaid Cymru 5  
54 56 56 UK Independence Party 8  
55 57 57 Conservative 1  
56 58 58 Green Party 2  
57 59 59 Labour 3  
58 60 60 Liberal Democrat 4  
59 61 61 UK Independence Party 8  
60 62 62 Conservative 1  
61 63 63 Scottish Green Party 255  
62 64 64 Labour 3  
63 65 65 Liberal Democrat 4  
64 66 66 Scottish National Party 11  
65 67 67 UK Independence Party 8  
66 68 68 Conservative 1  
67 69 69 Labour 3  
68 70 70 Liberal Democrat 4  
69 71 71 Plaid Cymru 5  
70 72 72 Socialist Labour Party 6  
71 73 73 UK Independence Party 8  
72 74 74 Conservative 1  
73 75 75 Labour 3  
74 76 76 Liberal Democrat 4  
75 77 77 Scottish National Party 11  
76 78 78 UK Independence Party 8  
77 79 79 Conservative 1  
78 80 80 Green Party 2  
79 81 81 Labour 3  
80 82 82 Liberal Democrat 4  
81 83 83 UK Independence Party 8  
82 84 84 Conservative 1  
83 85 85 Justice for Men & Boys 13  
84 86 86 Labour 3  
85 87 87 Liberal Democrat 4  
86 88 88 UK Independence Party 8  
87 89 89 Conservative 1  
88 90 90 Green Party 2  
89 91 91 Labour 3  
90 92 92 Liberal Democrat 4  
91 93 93 UK Independence Party 8  
92 94 94 Conservative 1  
93 95 95 Green Party 2  
94 96 96 Labour 3  
95 97 97 Liberal Democrat 4  
96 98 98 UK Independence Party 8  
97 99 99 Conservative 1  
98 100 100 Green Party 2  
99 101 101 Labour 3  
100 102 102 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]);