candidacies

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

1,951 rows where candidate_gender_id = 1, candidate_is_sitting_mp = 1 and is_standing_as_independent = 0

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: is_standing_as_commons_speaker, result_position, is_winning_candidacy

id ▼ candidate_given_name candidate_family_name candidate_is_sitting_mp candidate_is_former_mp is_standing_as_commons_speaker is_standing_as_independent is_notional result_position is_winning_candidacy vote_count vote_share vote_change candidate_gender_id election_id member_id democracy_club_person_identifier
10 Guto Bebb 1 1 0 0 0 1 1 12513 0.415052 0.056846 Male 1 2 2 2 2  
35 Gerald Howarth 1 1 0 0 0 1 1 23369 0.505921 0.03873 Male 1 6 6 9 9  
46 Graham Brady 1 1 0 0 0 1 1 26771 0.52994 0.040478 Male 1 8 8 11 11  
53 Mark Tami 1 1 0 0 0 1 1 16540 0.400349 0.004487 Male 1 9 9 12 12  
57 Nigel Mills 1 1 0 0 0 1 1 20106 0.439793 0.053657 Male 1 10 10 13 13  
66 Mike Weir 1 1 0 0 0 1 1 24130 0.54243 0.14675 Male 1 11 11 14 14  
71 Hywel Williams 1 1 0 0 0 1 1 11790 0.439319 0.079514 Male 1 12 12 15 15  
76 Alan Reid 1 1 0 0 0 2 0 14486 0.279205 -0.036941 Male 1 13 13 16 16  
79 Nick Herbert 1 1 0 0 0 1 1 34331 0.607876 0.030315 Male 1 14 14 18 18  
89 Damian Green 1 1 0 0 0 1 1 30094 0.524542 -0.016874 Male 1 16 16 20 20  
99 David Lidington 1 1 0 0 0 1 1 28083 0.50674 -0.014986 Male 1 18 18 22 22  
128 Dan Jarvis 1 1 0 0 0 1 1 20376 0.55733 0.084722 Male 1 23 23 28 28  
134 Michael Dugher 1 1 0 0 0 1 1 21079 0.547265 0.076807 Male 1 24 24 29 29  
143 John Woodcock 1 1 0 0 0 1 1 18320 0.423339 -0.057714 Male 1 25 25 31 31  
146 John Baron 1 1 0 0 0 1 1 22668 0.52682 -0.000544 Male 1 26 26 32 32  
157 John Mann 1 1 0 0 0 1 1 23965 0.486214 -0.018415 Male 1 28 28 34 34  
179 Dominic Grieve 1 1 0 0 0 1 1 33621 0.632414 0.021764 Male 1 32 32 38 38  
184 Bob Stewart 1 1 0 0 0 1 1 27955 0.572813 -0.00591 Male 1 33 33 39 39  
189 Richard Fuller 1 1 0 0 0 1 1 19625 0.425834 0.036805 Male 1 34 34 40 40  
202 Nigel Dodds 1 1 0 0 0 1 1 19096 0.470426 0.070026 Male 1 36 36 44 44  
212 Alasdair McDonnell 1 1 0 0 0 1 1 9560 0.245399 -0.164886 Male 1 37 37 45 45  
220 Paul Maskey 1 1 0 0 0 1 1 19163 0.542416 -0.16838 Male 1 38 38 46 46  
231 Simon Hughes 1 1 0 0 0 2 0 17657 0.343361 -0.140167 Male 1 39 39 48 48  
238 Michael Moore 1 1 0 0 0 3 0 10294 0.187034 -0.266509 Male 1 40 40 50 50  
258 Graham Stuart 1 1 0 0 0 1 1 25363 0.481481 0.010364 Male 1 43 43 54 54  
269 David Evennett 1 1 0 0 0 1 1 20643 0.472542 -0.032159 Male 1 45 45 56 56  
277 Frank Field 1 1 0 0 0 1 1 26468 0.67617 0.051025 Male 1 46 46 57 57  
289 Jack Dromey 1 1 0 0 0 1 1 15824 0.456233 0.03793 Male 1 48 48 59 59  
295 Roger Godsiff 1 1 0 0 0 1 1 28147 0.598287 0.269126 Male 1 49 49 60 60  
302 Liam Byrne 1 1 0 0 0 1 1 28069 0.683959 0.164158 Male 1 50 50 62 62  
313 Richard Burden 1 1 0 0 0 1 1 17673 0.416217 0.013457 Male 1 52 52 65 65  
318 Khalid Mahmood 1 1 0 0 0 1 1 23697 0.574333 0.071491 Male 1 53 53 66 66  
324 Stephen McCabe 1 1 0 0 0 1 1 21584 0.476531 0.091032 Male 1 54 54 67 67  
330 John Hemming 1 1 0 0 0 2 0 10534 0.255984 -0.139659 Male 1 55 55 69 69  
346 Graham Stringer 1 1 0 0 0 1 1 22982 0.619261 0.076546 Male 1 58 58 73 73  
349 Paul Maynard 1 1 0 0 0 1 1 17508 0.444444 0.026519 Male 1 59 59 74 74  
359 Gordon Marsden 1 1 0 0 0 1 1 13548 0.417684 0.007108 Male 1 60 60 75 75  
364 Nick Smith 1 1 0 0 0 1 1 18380 0.580122 0.056152 Male 1 61 61 76 76  
370 David Anderson 1 1 0 0 0 1 1 22090 0.491588 -0.004861 Male 1 62 62 77 77  
375 Ronnie Campbell 1 1 0 0 0 1 1 17813 0.463144 0.018297 Male 1 63 63 78 78  
378 Nick Gibb 1 1 0 0 0 1 1 24185 0.513308 -0.000801 Male 1 64 64 79 79  
384 Dennis Skinner 1 1 0 0 0 1 1 22542 0.512341 0.012341 Male 1 65 65 81 81  
389 David Crausby 1 1 0 0 0 1 1 18541 0.429578 -0.029558 Male 1 66 66 83 83  
418 David Tredinnick 1 1 0 0 0 1 1 22939 0.42811 0.001902 Male 1 71 71 89 89  
423 Tobias Ellwood 1 1 0 0 0 1 1 22060 0.492114 0.007833 Male 1 72 72 90 90  
428 Conor Burns 1 1 0 0 0 1 1 20155 0.482489 0.031014 Male 1 73 73 91 91  
434 Phillip Lee 1 1 0 0 0 1 1 29606 0.557699 0.03355 Male 1 74 74 92 92  
443 David Ward 1 1 0 0 0 2 0 12228 0.29532 -0.041754 Male 1 75 75 94 94  
456 George Galloway 1 1 0 0 0 2 0 8557 0.212385 0.181702 Male 1 77 77 97 97  
468 Roger Williams 1 1 0 0 0 2 0 11351 0.283251 -0.178301 Male 1 79 79 100 100  
482 Barry Gardiner 1 1 0 0 0 1 1 28351 0.542759 0.074022 Male 1 81 81 102 102  
490 Eric Pickles 1 1 0 0 0 1 1 30534 0.588358 0.019236 Male 1 83 83 105 105  
506 Ian Liddell-Grainger 1 1 0 0 0 1 1 25020 0.459529 0.006719 Male 1 85 85 107 107  
511 Andrew Percy 1 1 0 0 0 1 1 22946 0.530298 0.081741 Male 1 86 86 108 108  
518 Simon Kirby 1 1 0 0 0 1 1 18428 0.406745 0.027 Male 1 87 87 109 109  
555 Stephen Williams 1 1 0 0 0 3 0 12103 0.188467 -0.29201 Male 1 92 92 117 117  
557 Keith Simpson 1 1 0 0 0 1 1 26808 0.504963 0.042931 Male 1 93 93 118 118  
562 Robert Neill 1 1 0 0 0 1 1 23343 0.529728 -0.005481 Male 1 94 94 119 119  
567 Sajid Javid 1 1 0 0 0 1 1 28133 0.538482 0.101566 Male 1 95 95 120 120  
572 Charles Walker 1 1 0 0 0 1 1 25797 0.560512 -0.027424 Male 1 96 96 121 121  
584 John Bercow 1 1 1 0 0 1 1 34617 0.644733 0.171784 Male 1 98 98 124 124  
589 Gordon Birtwistle 1 1 0 0 0 2 0 11707 0.294545 -0.062295 Male 1 99 99 126 126  
591 Andrew Griffiths 1 1 0 0 0 1 1 24376 0.497733 0.052397 Male 1 100 100 127 127  
596 David Nuttall 1 1 0 0 0 1 1 18970 0.419412 0.017508 Male 1 101 101 128 128  
604 Ivan Lewis 1 1 0 0 0 1 1 21272 0.450535 0.046366 Male 1 102 102 130 130  
614 Wayne David 1 1 0 0 0 1 1 17864 0.443463 -0.005648 Male 1 104 104 133 133  
621 John Thurso 1 1 0 0 0 2 0 11987 0.350641 -0.063257 Male 1 105 105 134 134  
624 Craig Whittaker 1 1 0 0 0 1 1 23354 0.436189 0.042273 Male 1 106 106 136 136  
642 George Eustice 1 1 0 0 0 1 1 18452 0.402285 0.026482 Male 1 108 108 138 138  
651 Julian Huppert 1 1 0 0 0 2 0 18047 0.348573 -0.04283 Male 1 109 109 141 141  
659 Julian Brazier 1 1 0 0 0 1 1 22918 0.428654 -0.019435 Male 1 111 111 143 143  
683 Stephen Doughty 1 1 0 0 0 1 1 19966 0.42784 0.038784 Male 1 114 114 147 147  
690 Kevin Brennan 1 1 0 0 0 1 1 17803 0.406535 -0.005936 Male 1 115 115 148 148  
695 John Stevenson 1 1 0 0 0 1 1 18873 0.443163 0.050059 Male 1 116 116 150 150  
705 Jonathan Edwards 1 1 0 0 0 1 1 15140 0.384274 0.027903 Male 1 117 117 151 151  
707 Simon Hart 1 1 0 0 0 1 1 17626 0.436828 0.025812 Male 1 118 118 152 152  
717 Tom Brake 1 1 0 0 0 1 1 16603 0.348707 -0.134328 Male 1 119 119 153 153  
727 Brian Donohoe 1 1 0 0 0 2 0 13410 0.264112 -0.212946 Male 1 121 121 155 155  
730 Mel Stride 1 1 0 0 0 1 1 28436 0.52226 0.007401 Male 1 122 122 157 157  
736 Daniel Poulter 1 1 0 0 0 1 1 30317 0.560502 0.052734 Male 1 123 123 158 158  
745 Mark Williams 1 1 0 0 0 1 1 13414 0.35851 -0.141752 Male 1 124 124 159 159  
764 Mark Hunter 1 1 0 0 0 2 0 16436 0.309558 -0.161134 Male 1 127 127 163 163  
767 Simon Burns 1 1 0 0 0 1 1 27732 0.515302 0.053576 Male 1 128 128 164 164  
773 Greg Hands 1 1 0 0 0 1 1 25322 0.629493 0.024992 Male 1 129 129 165 165  
782 Martin Horwood 1 1 0 0 0 2 0 18274 0.340076 -0.164963 Male 1 130 130 167 167  
791 Toby Perkins 1 1 0 0 0 1 1 21829 0.479053 0.088752 Male 1 132 132 169 169  
796 Andrew Tyrie 1 1 0 0 0 1 1 32953 0.576716 0.023298 Male 1 133 133 170 170  
803 Iain Duncan Smith 1 1 0 0 0 1 1 20999 0.479385 -0.048221 Male 1 134 134 172 172  
812 Duncan Hames 1 1 0 0 0 2 0 16278 0.29379 -0.163784 Male 1 135 135 174 174  
823 Lindsay Hoyle 1 1 0 0 0 1 1 23322 0.450998 0.018744 Male 1 137 137 176 176  
826 Christopher Chope 1 1 0 0 0 1 1 28887 0.581146 0.016794 Male 1 138 138 177 177  
834 Mark Field 1 1 0 0 0 1 1 19570 0.540832 0.01921 Male 1 139 139 178 178  
839 Stephen Mosley 1 1 0 0 0 2 0 22025 0.430504 0.024541 Male 1 140 140 179 179  
854 Douglas Carswell 1 1 0 0 0 1 1 19642 0.444319   Male 1 142 142 183 183  
855 Martin Vickers 1 1 0 0 0 1 1 21026 0.466322 0.045137 Male 1 143 143 184 184  
867 David Jones 1 1 0 0 0 1 1 16463 0.432918 0.017473 Male 1 145 145 72 72  
875 Tom Clarke 1 1 0 0 0 2 0 17195 0.339165 -0.326813 Male 1 146 146 187 187  
883 Bob Russell 1 1 0 0 0 2 0 13344 0.274607 -0.205485 Male 1 147 147 190 190  
885 Jason McCartney 1 1 0 0 0 1 1 25246 0.444472 0.074825 Male 1 148 148 191 191  
899 Jamie Reed 1 1 0 0 0 1 1 16750 0.422649 -0.037748 Male 1 150 150 193 193  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "candidacies" (
   [id] INTEGER PRIMARY KEY,
   [candidate_given_name] TEXT,
   [candidate_family_name] TEXT,
   [candidate_is_sitting_mp] INTEGER,
   [candidate_is_former_mp] INTEGER,
   [is_standing_as_commons_speaker] INTEGER,
   [is_standing_as_independent] INTEGER,
   [is_notional] INTEGER,
   [result_position] INTEGER,
   [is_winning_candidacy] INTEGER,
   [vote_count] INTEGER,
   [vote_share] FLOAT,
   [vote_change] FLOAT,
   [candidate_gender_id] INTEGER REFERENCES [genders]([id]),
   [election_id] INTEGER REFERENCES [elections]([id]),
   [member_id] INTEGER REFERENCES [members]([id]),
   [democracy_club_person_identifier] TEXT
);
CREATE INDEX [idx_candidacies_member_id]
    ON [candidacies] ([member_id]);
CREATE INDEX [idx_candidacies_election_id]
    ON [candidacies] ([election_id]);
CREATE INDEX [idx_candidacies_candidate_gender_id]
    ON [candidacies] ([candidate_gender_id]);