/
ge2015.sql
4792 lines (4785 loc) · 346 KB
/
ge2015.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*!40101 SET NAMES utf8 */;
CREATE DATABASE `ge2015` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `ge2015`;
DROP TABLE IF EXISTS `candidates`;
CREATE TABLE `candidates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`constituency` int(11) NOT NULL,
`candidate_name` varchar(255) NOT NULL,
`party` varchar(255) NOT NULL,
`votes` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3972 DEFAULT CHARSET=utf8;
INSERT INTO `candidates` VALUES (1,1,'Stephen Kinnock','Lab',15416);
INSERT INTO `candidates` VALUES (2,1,'Peter Bush','UKIP',4971);
INSERT INTO `candidates` VALUES (3,1,'Edward Yi He','Con',3742);
INSERT INTO `candidates` VALUES (4,1,'Duncan Higgitt','PC',3663);
INSERT INTO `candidates` VALUES (5,1,'Helen Ceri Clarke','LD',1397);
INSERT INTO `candidates` VALUES (6,1,'Captain Beany','Ind',1137);
INSERT INTO `candidates` VALUES (7,1,'Jonathan Tier','Green',711);
INSERT INTO `candidates` VALUES (8,1,'Andrew Jordan','Soc Lab',352);
INSERT INTO `candidates` VALUES (9,1,'Owen Herbert','TUSC',134);
INSERT INTO `candidates` VALUES (10,2,'Guto Bebb','Con',12513);
INSERT INTO `candidates` VALUES (11,2,'Mary Wimbury','Lab',8514);
INSERT INTO `candidates` VALUES (12,2,'Dafydd Meurig','PC',3536);
INSERT INTO `candidates` VALUES (13,2,'Andrew Haigh','UKIP',3467);
INSERT INTO `candidates` VALUES (14,2,'Victor Babu','LD',1391);
INSERT INTO `candidates` VALUES (15,2,'Petra Haig','Green',727);
INSERT INTO `candidates` VALUES (16,3,'Kirsty Blackman','SNP',24793);
INSERT INTO `candidates` VALUES (17,3,'Richard Baker','Lab',11397);
INSERT INTO `candidates` VALUES (18,3,'Sanjoy Sen','Con',5304);
INSERT INTO `candidates` VALUES (19,3,'Euan Davidson','LD',2050);
INSERT INTO `candidates` VALUES (20,3,'Tyrinne Rutherford','TUSC',206);
INSERT INTO `candidates` VALUES (21,3,'Christopher Willett','NF',186);
INSERT INTO `candidates` VALUES (22,4,'Callum McCaig','SNP',20221);
INSERT INTO `candidates` VALUES (23,4,'Anne Begg','Lab',12991);
INSERT INTO `candidates` VALUES (24,4,'Ross Thomson','Con',11087);
INSERT INTO `candidates` VALUES (25,4,'Denis Rixon','LD',2252);
INSERT INTO `candidates` VALUES (26,4,'Dan Yeats','Green',964);
INSERT INTO `candidates` VALUES (27,4,'Sandra Skinner','UKIP',897);
INSERT INTO `candidates` VALUES (28,4,'Christopher Gray','Ind',139);
INSERT INTO `candidates` VALUES (29,5,'Stuart Donaldson','SNP',22949);
INSERT INTO `candidates` VALUES (30,5,'Alexander Burnett','Con',15916);
INSERT INTO `candidates` VALUES (31,5,'Robert Smith','LD',11812);
INSERT INTO `candidates` VALUES (32,5,'Barry Black','Lab',2487);
INSERT INTO `candidates` VALUES (33,5,'David Lansdell','UKIP',1006);
INSERT INTO `candidates` VALUES (34,5,'Richard Openshaw','Green',885);
INSERT INTO `candidates` VALUES (35,5,'Graham Reid','Ind',141);
INSERT INTO `candidates` VALUES (36,6,'Neil Gray','SNP',23887);
INSERT INTO `candidates` VALUES (37,6,'Pamela Nash','Lab',15108);
INSERT INTO `candidates` VALUES (38,6,'Eric Holford','Con',3389);
INSERT INTO `candidates` VALUES (39,6,'Matt Williams','UKIP',1088);
INSERT INTO `candidates` VALUES (40,6,'John Love','LD',678);
INSERT INTO `candidates` VALUES (41,6,'Deryck Beaumont','Ind',136);
INSERT INTO `candidates` VALUES (42,7,'Gerald Howarth','Con',23369);
INSERT INTO `candidates` VALUES (43,7,'Gary Puffett','Lab',8468);
INSERT INTO `candidates` VALUES (44,7,'Bill Walker','UKIP',8253);
INSERT INTO `candidates` VALUES (45,7,'Alan Hilliar','LD',4076);
INSERT INTO `candidates` VALUES (46,7,'Carl Hewitt','Green',2025);
INSERT INTO `candidates` VALUES (47,8,'Wendy Morton','Con',20558);
INSERT INTO `candidates` VALUES (48,8,'John Fisher','Lab',8835);
INSERT INTO `candidates` VALUES (49,8,'Anthony Thompson','UKIP',7751);
INSERT INTO `candidates` VALUES (50,8,'Ian Garrett','LD',1330);
INSERT INTO `candidates` VALUES (51,8,'Martyn Curzey','Green',826);
INSERT INTO `candidates` VALUES (52,8,'Mark Beech','Loony',197);
INSERT INTO `candidates` VALUES (53,9,'Graham Brady','Con',26771);
INSERT INTO `candidates` VALUES (54,9,'James Wright','Lab',13481);
INSERT INTO `candidates` VALUES (55,9,'Jane Brophy','LD',4235);
INSERT INTO `candidates` VALUES (56,9,'Chris Frost','UKIP',4047);
INSERT INTO `candidates` VALUES (57,9,'Nick Robertson-Brown','Green',1983);
INSERT INTO `candidates` VALUES (58,10,'Mark Tami','Lab',16540);
INSERT INTO `candidates` VALUES (59,10,'Laura Knightly','Con',13197);
INSERT INTO `candidates` VALUES (60,10,'Blair Smillie','UKIP',7260);
INSERT INTO `candidates` VALUES (61,10,'Tudor Jones','LD',1733);
INSERT INTO `candidates` VALUES (62,10,'Jacqueline Hurst','PC',1608);
INSERT INTO `candidates` VALUES (63,10,'Alasdair Ibbotson','Green',976);
INSERT INTO `candidates` VALUES (64,11,'Nigel Mills','Con',20106);
INSERT INTO `candidates` VALUES (65,11,'Kevin Gillott','Lab',15901);
INSERT INTO `candidates` VALUES (66,11,'Stuart Bent','UKIP',7263);
INSERT INTO `candidates` VALUES (67,11,'Kate Smith','LD',1360);
INSERT INTO `candidates` VALUES (68,11,'John Devine','Green',1087);
INSERT INTO `candidates` VALUES (69,12,'Mike Weir','SNP',24130);
INSERT INTO `candidates` VALUES (70,12,'Derek Wann','Con',12900);
INSERT INTO `candidates` VALUES (71,12,'Gerard McMahon','Lab',3919);
INSERT INTO `candidates` VALUES (72,12,'Calum Walker','UKIP',1355);
INSERT INTO `candidates` VALUES (73,12,'Sanjay Samani','LD',1216);
INSERT INTO `candidates` VALUES (74,12,'David Mumford','Green',965);
INSERT INTO `candidates` VALUES (75,13,'Sammy Wilson','DUP',12103);
INSERT INTO `candidates` VALUES (76,13,'Roy Beggs','UUP',6308);
INSERT INTO `candidates` VALUES (77,13,'Stewart Dickson','Alliance',5021);
INSERT INTO `candidates` VALUES (78,13,'Noel Jordan','UKIP',3660);
INSERT INTO `candidates` VALUES (79,13,'Oliver McMullan','SF',2314);
INSERT INTO `candidates` VALUES (80,13,'Ruth Wilson','TUV',1903);
INSERT INTO `candidates` VALUES (81,13,'Margaret Anne McKillop','SDLP',1639);
INSERT INTO `candidates` VALUES (82,13,'Alex Wilson','Con',549);
INSERT INTO `candidates` VALUES (83,14,'Ian Paisley','DUP',18107);
INSERT INTO `candidates` VALUES (84,14,'Timothy Gaston','TUV',6561);
INSERT INTO `candidates` VALUES (85,14,'Daithi McKay','SF',5143);
INSERT INTO `candidates` VALUES (86,14,'Robin Swann','UUP',5054);
INSERT INTO `candidates` VALUES (87,14,'Declan O\'Loan','SDLP',2925);
INSERT INTO `candidates` VALUES (88,14,'Jayne Dunlop','Alliance',2351);
INSERT INTO `candidates` VALUES (89,14,'Robert Hill','UKIP',1341);
INSERT INTO `candidates` VALUES (90,14,'Carol Freeman','Con',368);
INSERT INTO `candidates` VALUES (91,14,'Thomas Palmer','Ind',57);
INSERT INTO `candidates` VALUES (92,15,'Danny Kinahan','UUP',11942);
INSERT INTO `candidates` VALUES (93,15,'William McCrea','DUP',10993);
INSERT INTO `candidates` VALUES (94,15,'Declan Kearney','SF',4699);
INSERT INTO `candidates` VALUES (95,15,'Neil Kelly','Alliance',3576);
INSERT INTO `candidates` VALUES (96,15,'Roisin Lynch','SDLP',2990);
INSERT INTO `candidates` VALUES (97,15,'Richard Cairns','TUV',1908);
INSERT INTO `candidates` VALUES (98,15,'Alan Dunlop','Con',415);
INSERT INTO `candidates` VALUES (99,16,'Hywel Williams','PC',11790);
INSERT INTO `candidates` VALUES (100,16,'Alun Pugh','Lab',8122);
INSERT INTO `candidates` VALUES (101,16,'Anwen Barry','Con',3521);
INSERT INTO `candidates` VALUES (102,16,'Simon Wall','UKIP',2277);
INSERT INTO `candidates` VALUES (103,16,'Mohammed Shultan','LD',718);
INSERT INTO `candidates` VALUES (104,16,'Kathrine Jones','Soc Lab',409);
INSERT INTO `candidates` VALUES (105,17,'Brendan O\'Hara','SNP',22959);
INSERT INTO `candidates` VALUES (106,17,'Alan Reid','LD',14486);
INSERT INTO `candidates` VALUES (107,17,'Alastair Redman','Con',7733);
INSERT INTO `candidates` VALUES (108,17,'Mary Galbraith','Lab',5394);
INSERT INTO `candidates` VALUES (109,17,'Caroline Santos','UKIP',1311);
INSERT INTO `candidates` VALUES (110,18,'Nick Herbert','Con',34331);
INSERT INTO `candidates` VALUES (111,18,'Peter Grace','UKIP',8154);
INSERT INTO `candidates` VALUES (112,18,'Christopher Wellbelove','Lab',6324);
INSERT INTO `candidates` VALUES (113,18,'Shweta Kapadia','LD',4062);
INSERT INTO `candidates` VALUES (114,18,'Isabel Thurston','Green',3606);
INSERT INTO `candidates` VALUES (115,19,'Gloria De Piero','Lab',19448);
INSERT INTO `candidates` VALUES (116,19,'Helen Harrison','Con',10628);
INSERT INTO `candidates` VALUES (117,19,'Simon Ashcroft','UKIP',10150);
INSERT INTO `candidates` VALUES (118,19,'Philip Smith','LD',7030);
INSERT INTO `candidates` VALUES (119,19,'Mike Buchanan','JMB',153);
INSERT INTO `candidates` VALUES (120,20,'Damian Green','Con',30094);
INSERT INTO `candidates` VALUES (121,20,'Gerald O\'Brien','UKIP',10798);
INSERT INTO `candidates` VALUES (122,20,'Brendan Chilton','Lab',10580);
INSERT INTO `candidates` VALUES (123,20,'Debbie Enever','LD',3433);
INSERT INTO `candidates` VALUES (124,20,'Mandy Rossi','Green',2467);
INSERT INTO `candidates` VALUES (125,21,'Angela Rayner','Lab',19366);
INSERT INTO `candidates` VALUES (126,21,'Tracy Sutton','Con',8610);
INSERT INTO `candidates` VALUES (127,21,'Maurice Jackson','UKIP',8468);
INSERT INTO `candidates` VALUES (128,21,'Charlotte Hughes','Green',1531);
INSERT INTO `candidates` VALUES (129,21,'Carly Hicks','LD',943);
INSERT INTO `candidates` VALUES (130,22,'David Lidington','Con',28083);
INSERT INTO `candidates` VALUES (131,22,'Chris Adams','UKIP',10925);
INSERT INTO `candidates` VALUES (132,22,'Will Cass','Lab',8391);
INSERT INTO `candidates` VALUES (133,22,'Steven Lambert','LD',5885);
INSERT INTO `candidates` VALUES (134,22,'David Lyons','Green',2135);
INSERT INTO `candidates` VALUES (135,23,'Corri Wilson','SNP',25492);
INSERT INTO `candidates` VALUES (136,23,'Sandra Osborne','Lab',14227);
INSERT INTO `candidates` VALUES (137,23,'Lee Lyons','Con',10355);
INSERT INTO `candidates` VALUES (138,23,'Joseph Adam-Smith','UKIP',1280);
INSERT INTO `candidates` VALUES (139,23,'Richard Brodie','LD',855);
INSERT INTO `candidates` VALUES (140,24,'Philippa Whitford','SNP',26999);
INSERT INTO `candidates` VALUES (141,24,'Brian Donohoe','Lab',13410);
INSERT INTO `candidates` VALUES (142,24,'Marc Hope','Con',8803);
INSERT INTO `candidates` VALUES (143,24,'Gordon Bain','LD',917);
INSERT INTO `candidates` VALUES (144,24,'Veronika Tudhope','Green',645);
INSERT INTO `candidates` VALUES (145,25,'Patricia Gibson','SNP',28641);
INSERT INTO `candidates` VALUES (146,25,'Katy Clark','Lab',15068);
INSERT INTO `candidates` VALUES (147,25,'Jamie Greene','Con',7968);
INSERT INTO `candidates` VALUES (148,25,'Sharon McGonigal','UKIP',1296);
INSERT INTO `candidates` VALUES (149,25,'Ruby Kirkwood','LD',896);
INSERT INTO `candidates` VALUES (150,26,'Victoria Prentis','Con',30749);
INSERT INTO `candidates` VALUES (151,26,'Sean Woodcock','Lab',12354);
INSERT INTO `candidates` VALUES (152,26,'Dickie Bird','UKIP',8050);
INSERT INTO `candidates` VALUES (153,26,'John Howson','LD',3440);
INSERT INTO `candidates` VALUES (154,26,'Ian Middleton','Green',2686);
INSERT INTO `candidates` VALUES (155,26,'Roseanne Edwards','NHAP',729);
INSERT INTO `candidates` VALUES (156,27,'Eilidh Whiteford','SNP',27487);
INSERT INTO `candidates` VALUES (157,27,'Alex Johnstone','Con',13148);
INSERT INTO `candidates` VALUES (158,27,'Sumon Hoque','Lab',2647);
INSERT INTO `candidates` VALUES (159,27,'David Evans','LD',2347);
INSERT INTO `candidates` VALUES (160,28,'Margaret Hodge','Lab',24826);
INSERT INTO `candidates` VALUES (161,28,'Roger Gravett','UKIP',9554);
INSERT INTO `candidates` VALUES (162,28,'Mina Rahman','Con',7019);
INSERT INTO `candidates` VALUES (163,28,'Tony Rablen','Green',879);
INSERT INTO `candidates` VALUES (164,28,'Peter Wilcock','LD',562);
INSERT INTO `candidates` VALUES (165,28,'Joseph Mambuliya','TUSC',183);
INSERT INTO `candidates` VALUES (166,29,'Dan Jarvis','Lab',20376);
INSERT INTO `candidates` VALUES (167,29,'Lee Hunter','UKIP',7941);
INSERT INTO `candidates` VALUES (168,29,'Kay Carter','Con',5485);
INSERT INTO `candidates` VALUES (169,29,'Michael Short','Green',938);
INSERT INTO `candidates` VALUES (170,29,'David Ridgway','LD',770);
INSERT INTO `candidates` VALUES (171,29,'Dave Gibson','TUSC',573);
INSERT INTO `candidates` VALUES (172,29,'Ian Sutton','Eng Dem',477);
INSERT INTO `candidates` VALUES (173,30,'Michael Dugher','Lab',21079);
INSERT INTO `candidates` VALUES (174,30,'Robert Swiffen','UKIP',9045);
INSERT INTO `candidates` VALUES (175,30,'Katharine Harborne','Con',5622);
INSERT INTO `candidates` VALUES (176,30,'Ruth Coleman-Taylor','LD',1217);
INSERT INTO `candidates` VALUES (177,30,'Tony Devoy','Yorks',647);
INSERT INTO `candidates` VALUES (178,30,'Kevin Riddiough','Eng Dem',440);
INSERT INTO `candidates` VALUES (179,30,'Ralph Dyson','TUSC',364);
INSERT INTO `candidates` VALUES (180,30,'Billy Marsden','Vapers',103);
INSERT INTO `candidates` VALUES (181,31,'John Woodcock','Lab',18320);
INSERT INTO `candidates` VALUES (182,31,'Simon Fell','Con',17525);
INSERT INTO `candidates` VALUES (183,31,'Nigel Cecil','UKIP',5070);
INSERT INTO `candidates` VALUES (184,31,'Clive Peaple','LD',1169);
INSERT INTO `candidates` VALUES (185,31,'Robert O\'Hara','Green',1061);
INSERT INTO `candidates` VALUES (186,31,'Ian Jackson','Ind',130);
INSERT INTO `candidates` VALUES (187,32,'John Baron','Con',22668);
INSERT INTO `candidates` VALUES (188,32,'Gavin Callaghan','Lab',10186);
INSERT INTO `candidates` VALUES (189,32,'George Konstantinidis','UKIP',8538);
INSERT INTO `candidates` VALUES (190,32,'Martin Thompson','LD',1636);
INSERT INTO `candidates` VALUES (191,33,'Stephen Metcalfe','Con',19788);
INSERT INTO `candidates` VALUES (192,33,'Ian Luder','UKIP',12097);
INSERT INTO `candidates` VALUES (193,33,'Mike Le-Surf','Lab',11493);
INSERT INTO `candidates` VALUES (194,33,'Geoff Williams','LD',1356);
INSERT INTO `candidates` VALUES (195,33,'Kerry Smith','Ind',401);
INSERT INTO `candidates` VALUES (196,33,'None Of The Above X','ND',253);
INSERT INTO `candidates` VALUES (197,33,'Stuart Hooper','Ind',205);
INSERT INTO `candidates` VALUES (198,34,'Maria Miller','Con',25769);
INSERT INTO `candidates` VALUES (199,34,'Paul Harvey','Lab',14706);
INSERT INTO `candidates` VALUES (200,34,'Alan Stone','UKIP',8290);
INSERT INTO `candidates` VALUES (201,34,'Janice Spalding','LD',3919);
INSERT INTO `candidates` VALUES (202,34,'Omar Selim','Ind',392);
INSERT INTO `candidates` VALUES (203,35,'John Mann','Lab',23965);
INSERT INTO `candidates` VALUES (204,35,'Sarah Downes','Con',15122);
INSERT INTO `candidates` VALUES (205,35,'David Scott','UKIP',7865);
INSERT INTO `candidates` VALUES (206,35,'Leon Duveen','LD',1331);
INSERT INTO `candidates` VALUES (207,35,'Kris Wragg','Green',1006);
INSERT INTO `candidates` VALUES (208,36,'Ben Howlett','Con',17833);
INSERT INTO `candidates` VALUES (209,36,'Steve Bradley','LD',14000);
INSERT INTO `candidates` VALUES (210,36,'Ollie Middleton','Lab',6216);
INSERT INTO `candidates` VALUES (211,36,'Dominic Tristram','Green',5634);
INSERT INTO `candidates` VALUES (212,36,'Julian Deverell','UKIP',2922);
INSERT INTO `candidates` VALUES (213,36,'Loraine Morgan-Brinkhurst','Ind',499);
INSERT INTO `candidates` VALUES (214,36,'Jenny Knight','Eng Dem',63);
INSERT INTO `candidates` VALUES (215,37,'Jo Cox','Lab',21826);
INSERT INTO `candidates` VALUES (216,37,'Imtiaz Ameen','Con',15769);
INSERT INTO `candidates` VALUES (217,37,'Aleks Lukic','UKIP',9080);
INSERT INTO `candidates` VALUES (218,37,'John Lawson','LD',2396);
INSERT INTO `candidates` VALUES (219,37,'Ian Bullock','Green',1232);
INSERT INTO `candidates` VALUES (220,37,'Dawn Wheelhouse','TUSC',123);
INSERT INTO `candidates` VALUES (221,37,'Karl Varley','PSP',53);
INSERT INTO `candidates` VALUES (222,38,'Jane Ellison','Con',26730);
INSERT INTO `candidates` VALUES (223,38,'Will Martindale','Lab',18792);
INSERT INTO `candidates` VALUES (224,38,'Luke Taylor','LD',2241);
INSERT INTO `candidates` VALUES (225,38,'Joe Stuart','Green',1682);
INSERT INTO `candidates` VALUES (226,38,'Christopher Howe','UKIP',1586);
INSERT INTO `candidates` VALUES (227,39,'Dominic Grieve','Con',33621);
INSERT INTO `candidates` VALUES (228,39,'Tim Scott','UKIP',7310);
INSERT INTO `candidates` VALUES (229,39,'Tony Clements','Lab',6074);
INSERT INTO `candidates` VALUES (230,39,'Peter Chapman','LD',3927);
INSERT INTO `candidates` VALUES (231,39,'Dave Hampton','Green',2231);
INSERT INTO `candidates` VALUES (232,40,'Bob Stewart','Con',27955);
INSERT INTO `candidates` VALUES (233,40,'Marina Ahmad','Lab',9484);
INSERT INTO `candidates` VALUES (234,40,'Rob Bryant','UKIP',6108);
INSERT INTO `candidates` VALUES (235,40,'Anuja Prashar','LD',3378);
INSERT INTO `candidates` VALUES (236,40,'Ruth Fabricant','Green',1878);
INSERT INTO `candidates` VALUES (237,41,'Richard Fuller','Con',19625);
INSERT INTO `candidates` VALUES (238,41,'Patrick Hall','Lab',18528);
INSERT INTO `candidates` VALUES (239,41,'Charlie Smith','UKIP',4434);
INSERT INTO `candidates` VALUES (240,41,'Mahmud Henry Rogers','LD',1958);
INSERT INTO `candidates` VALUES (241,41,'Ben Foley','Green',1412);
INSERT INTO `candidates` VALUES (242,41,'Faruk Choudhury','Ind',129);
INSERT INTO `candidates` VALUES (243,42,'Nadine Dorries','Con',32544);
INSERT INTO `candidates` VALUES (244,42,'Charlynne Pullen','Lab',9217);
INSERT INTO `candidates` VALUES (245,42,'Nigel Wickens','UKIP',8966);
INSERT INTO `candidates` VALUES (246,42,'Linda Jack','LD',4193);
INSERT INTO `candidates` VALUES (247,42,'Gareth Ellis','Green',2462);
INSERT INTO `candidates` VALUES (248,42,'Tim Ireland','Ind',384);
INSERT INTO `candidates` VALUES (249,42,'Ann Kelly','Loony',294);
INSERT INTO `candidates` VALUES (250,43,'Alistair Burt','Con',34891);
INSERT INTO `candidates` VALUES (251,43,'Saqhib Ali','Lab',9247);
INSERT INTO `candidates` VALUES (252,43,'Adrianne Smyth','UKIP',8579);
INSERT INTO `candidates` VALUES (253,43,'Peter Morris','LD',3418);
INSERT INTO `candidates` VALUES (254,43,'Mark Bowler','Green',2537);
INSERT INTO `candidates` VALUES (255,44,'Andrew Selous','Con',28212);
INSERT INTO `candidates` VALUES (256,44,'Daniel Scott','Lab',10399);
INSERT INTO `candidates` VALUES (257,44,'John Van Weenen','UKIP',7941);
INSERT INTO `candidates` VALUES (258,44,'Stephen Rutherford','LD',2646);
INSERT INTO `candidates` VALUES (259,44,'Emily Lawrence','Green',2106);
INSERT INTO `candidates` VALUES (260,45,'Gavin Robinson','DUP',19575);
INSERT INTO `candidates` VALUES (261,45,'Naomi Long','Alliance',16978);
INSERT INTO `candidates` VALUES (262,45,'Neil Wilson','Con',1121);
INSERT INTO `candidates` VALUES (263,45,'Ross Brown','Green',1058);
INSERT INTO `candidates` VALUES (264,45,'Niall O Donnghaile','SF',823);
INSERT INTO `candidates` VALUES (265,45,'Mary Muldoon','SDLP',127);
INSERT INTO `candidates` VALUES (266,46,'Nigel Dodds','DUP',19096);
INSERT INTO `candidates` VALUES (267,46,'Gerry Kelly','SF',13770);
INSERT INTO `candidates` VALUES (268,46,'Alban Maginness','SDLP',3338);
INSERT INTO `candidates` VALUES (269,46,'Jason O\'Neill','Alliance',2941);
INSERT INTO `candidates` VALUES (270,46,'Gemma Weir','WP',919);
INSERT INTO `candidates` VALUES (271,46,'Fra Hughes','Ind',529);
INSERT INTO `candidates` VALUES (272,47,'Alasdair McDonnell','SDLP',9560);
INSERT INTO `candidates` VALUES (273,47,'Jonathan Bell','DUP',8654);
INSERT INTO `candidates` VALUES (274,47,'Paula Bradshaw','Alliance',6711);
INSERT INTO `candidates` VALUES (275,47,'Mairtin O Muilleoir','SF',5402);
INSERT INTO `candidates` VALUES (276,47,'Rodney McCune','UUP',3549);
INSERT INTO `candidates` VALUES (277,47,'Clare Bailey','Green',2238);
INSERT INTO `candidates` VALUES (278,47,'Bob Stoker','UKIP',1900);
INSERT INTO `candidates` VALUES (279,47,'Ben Manton','Con',582);
INSERT INTO `candidates` VALUES (280,47,'Lily Kerr','WP',361);
INSERT INTO `candidates` VALUES (281,48,'Paul Maskey','SF',19163);
INSERT INTO `candidates` VALUES (282,48,'Gerry Carroll','PBP',6798);
INSERT INTO `candidates` VALUES (283,48,'Alex Attwood','SDLP',3475);
INSERT INTO `candidates` VALUES (284,48,'Frank McCoubrey','DUP',2773);
INSERT INTO `candidates` VALUES (285,48,'Bill Manwaring','UUP',1088);
INSERT INTO `candidates` VALUES (286,48,'Brian Higginson','UKIP',765);
INSERT INTO `candidates` VALUES (287,48,'Gerard Catney','Alliance',636);
INSERT INTO `candidates` VALUES (288,48,'John Lowry','WP',597);
INSERT INTO `candidates` VALUES (289,48,'Paul Shea','Con',34);
INSERT INTO `candidates` VALUES (290,49,'Neil Coyle','Lab',22146);
INSERT INTO `candidates` VALUES (291,49,'Simon Hughes','LD',17657);
INSERT INTO `candidates` VALUES (292,49,'JP Floru','Con',6051);
INSERT INTO `candidates` VALUES (293,49,'Andrew Beadle','UKIP',3254);
INSERT INTO `candidates` VALUES (294,49,'William Lavin','Green',2023);
INSERT INTO `candidates` VALUES (295,49,'Kingsley Abrams','TUSC',142);
INSERT INTO `candidates` VALUES (296,49,'Lucy Hall','Ind',72);
INSERT INTO `candidates` VALUES (297,49,'Donald Cole','AP',59);
INSERT INTO `candidates` VALUES (298,49,'Steve Freeman','Rep Soc',20);
INSERT INTO `candidates` VALUES (299,50,'Anne-Marie Trevelyan','Con',16603);
INSERT INTO `candidates` VALUES (300,50,'Julie Porksen','LD',11689);
INSERT INTO `candidates` VALUES (301,50,'Scott Dickinson','Lab',6042);
INSERT INTO `candidates` VALUES (302,50,'Nigel Coghill-Marshall','UKIP',4513);
INSERT INTO `candidates` VALUES (303,50,'Rachael Roberts','Green',1488);
INSERT INTO `candidates` VALUES (304,50,'Neil Humphrey','Eng Dem',88);
INSERT INTO `candidates` VALUES (305,51,'Calum Kerr','SNP',20145);
INSERT INTO `candidates` VALUES (306,51,'John Lamont','Con',19817);
INSERT INTO `candidates` VALUES (307,51,'Michael Moore','LD',10294);
INSERT INTO `candidates` VALUES (308,51,'Kenryck Lloyd-Jones','Lab',2700);
INSERT INTO `candidates` VALUES (309,51,'Peter Neilson','UKIP',1316);
INSERT INTO `candidates` VALUES (310,51,'Pauline Stewart','Green',631);
INSERT INTO `candidates` VALUES (311,51,'Jesse Rae','Ind',135);
INSERT INTO `candidates` VALUES (312,52,'Rushanara Ali','Lab',32387);
INSERT INTO `candidates` VALUES (313,52,'Matt Smith','Con',8070);
INSERT INTO `candidates` VALUES (314,52,'Alistair Polson','Green',4906);
INSERT INTO `candidates` VALUES (315,52,'Paula McQueen','UKIP',3219);
INSERT INTO `candidates` VALUES (316,52,'Teena Lashmore','LD',2395);
INSERT INTO `candidates` VALUES (317,52,'Glyn Robbins','TUSC',949);
INSERT INTO `candidates` VALUES (318,52,'M Rowshan Ali','Community',356);
INSERT INTO `candidates` VALUES (319,52,'Jonathan Dewey','CSA',303);
INSERT INTO `candidates` VALUES (320,52,'Alasdair Henderson','Whig',203);
INSERT INTO `candidates` VALUES (321,52,'Elliot Ball','30-50',78);
INSERT INTO `candidates` VALUES (322,52,'Jason Pavlou','RFAC',58);
INSERT INTO `candidates` VALUES (323,53,'Graham Stuart','Con',25363);
INSERT INTO `candidates` VALUES (324,53,'Margaret Pinder','Lab',13160);
INSERT INTO `candidates` VALUES (325,53,'Gary Shores','UKIP',8794);
INSERT INTO `candidates` VALUES (326,53,'Denis Healy','LD',2900);
INSERT INTO `candidates` VALUES (327,53,'Richard Howarth','Green',1802);
INSERT INTO `candidates` VALUES (328,53,'Lee Walton','Yorks',658);
INSERT INTO `candidates` VALUES (329,54,'Huw Merriman','Con',30245);
INSERT INTO `candidates` VALUES (330,54,'Geoffrey Bastin','UKIP',10170);
INSERT INTO `candidates` VALUES (331,54,'Michelle Thew','Lab',7797);
INSERT INTO `candidates` VALUES (332,54,'Rachel Sadler','LD',4199);
INSERT INTO `candidates` VALUES (333,54,'Jonathan Kent','Green',2807);
INSERT INTO `candidates` VALUES (334,55,'David Evennett','Con',20643);
INSERT INTO `candidates` VALUES (335,55,'Stef Borella','Lab',11451);
INSERT INTO `candidates` VALUES (336,55,'Chris Attard','UKIP',9182);
INSERT INTO `candidates` VALUES (337,55,'Richard Davis','LD',1308);
INSERT INTO `candidates` VALUES (338,55,'Stella Gardiner','Green',950);
INSERT INTO `candidates` VALUES (339,55,'Maggi Young','Eng Dem',151);
INSERT INTO `candidates` VALUES (340,56,'Frank Field','Lab',26468);
INSERT INTO `candidates` VALUES (341,56,'Clark Vasey','Con',5816);
INSERT INTO `candidates` VALUES (342,56,'Wayne Harling','UKIP',3838);
INSERT INTO `candidates` VALUES (343,56,'Allan Brame','LD',1396);
INSERT INTO `candidates` VALUES (344,56,'Kenny Peers','Green',162);
INSERT INTO `candidates` VALUES (345,57,'Gisela Stuart','Lab',18518);
INSERT INTO `candidates` VALUES (346,57,'Luke Evans','Con',15812);
INSERT INTO `candidates` VALUES (347,57,'Graham Short','UKIP',4154);
INSERT INTO `candidates` VALUES (348,57,'Phil Simpson','Green',1371);
INSERT INTO `candidates` VALUES (349,57,'Lee Dargue','LD',1184);
INSERT INTO `candidates` VALUES (350,57,'Gabriel Ukandu','Christian',163);
INSERT INTO `candidates` VALUES (351,57,'Henna Rai','Ind',91);
INSERT INTO `candidates` VALUES (352,58,'Jack Dromey','Lab',15824);
INSERT INTO `candidates` VALUES (353,58,'Robert Alden','Con',10695);
INSERT INTO `candidates` VALUES (354,58,'Andrew Garcarz','UKIP',6040);
INSERT INTO `candidates` VALUES (355,58,'Ann Holtom','LD',965);
INSERT INTO `candidates` VALUES (356,58,'Joe Belcher','Green',948);
INSERT INTO `candidates` VALUES (357,58,'Ted Woodley','TUSC',212);
INSERT INTO `candidates` VALUES (358,59,'Roger Godsiff','Lab',28147);
INSERT INTO `candidates` VALUES (359,59,'James Bird','Con',8329);
INSERT INTO `candidates` VALUES (360,59,'Jerry Evans','LD',5459);
INSERT INTO `candidates` VALUES (361,59,'Elly Stanton','Green',2200);
INSERT INTO `candidates` VALUES (362,59,'Rashpal Mondair','UKIP',2131);
INSERT INTO `candidates` VALUES (363,59,'Shiraz Peer','Respect',780);
INSERT INTO `candidates` VALUES (364,60,'Liam Byrne','Lab',28069);
INSERT INTO `candidates` VALUES (365,60,'Kieran Mullan','Con',4707);
INSERT INTO `candidates` VALUES (366,60,'Albert Duffen','UKIP',4651);
INSERT INTO `candidates` VALUES (367,60,'Phil Bennion','LD',2624);
INSERT INTO `candidates` VALUES (368,60,'Chris Nash','Green',835);
INSERT INTO `candidates` VALUES (369,60,'Andy Chaffer','Comm Brit',153);
INSERT INTO `candidates` VALUES (370,61,'Shabana Mahmood','Lab',26444);
INSERT INTO `candidates` VALUES (371,61,'Isabel Sigmac','Con',4576);
INSERT INTO `candidates` VALUES (372,61,'Clair Braund','UKIP',1805);
INSERT INTO `candidates` VALUES (373,61,'Margaret Okole','Green',1501);
INSERT INTO `candidates` VALUES (374,61,'Shazad Iqbal','LD',1374);
INSERT INTO `candidates` VALUES (375,61,'Timothy Burton','Lib GB',216);
INSERT INTO `candidates` VALUES (376,62,'Richard Burden','Lab',17673);
INSERT INTO `candidates` VALUES (377,62,'Rachel Maclean','Con',15164);
INSERT INTO `candidates` VALUES (378,62,'Keith Rowe','UKIP',7106);
INSERT INTO `candidates` VALUES (379,62,'Steven Haynes','LD',1349);
INSERT INTO `candidates` VALUES (380,62,'Anna Masters','Green',1169);
INSERT INTO `candidates` VALUES (381,63,'Khalid Mahmood','Lab',23697);
INSERT INTO `candidates` VALUES (382,63,'Charlotte Hodivala','Con',8869);
INSERT INTO `candidates` VALUES (383,63,'Harjinder Singh','UKIP',5032);
INSERT INTO `candidates` VALUES (384,63,'Arjun Singh','LD',2001);
INSERT INTO `candidates` VALUES (385,63,'James Lovatt','Green',1330);
INSERT INTO `candidates` VALUES (386,63,'Robert Punton','TUSC',331);
INSERT INTO `candidates` VALUES (387,64,'Steve McCabe','Lab',21584);
INSERT INTO `candidates` VALUES (388,64,'Alex Boulter','Con',13137);
INSERT INTO `candidates` VALUES (389,64,'Steven Brookes','UKIP',5755);
INSERT INTO `candidates` VALUES (390,64,'Colin Green','LD',2517);
INSERT INTO `candidates` VALUES (391,64,'Clare Thomas','Green',2301);
INSERT INTO `candidates` VALUES (392,65,'Jess Phillips','Lab',17129);
INSERT INTO `candidates` VALUES (393,65,'John Hemming','LD',10534);
INSERT INTO `candidates` VALUES (394,65,'Paul Clayton','UKIP',6637);
INSERT INTO `candidates` VALUES (395,65,'Arun Photay','Con',5760);
INSERT INTO `candidates` VALUES (396,65,'Grant Bishop','Green',698);
INSERT INTO `candidates` VALUES (397,65,'Teval Stephens','Respect',187);
INSERT INTO `candidates` VALUES (398,65,'Eamonn Flynn','TUSC',135);
INSERT INTO `candidates` VALUES (399,65,'Peter Johnson','Soc Dem',71);
INSERT INTO `candidates` VALUES (400,66,'Helen Goodman','Lab',16307);
INSERT INTO `candidates` VALUES (401,66,'Christopher Adams','Con',12799);
INSERT INTO `candidates` VALUES (402,66,'Rhys Burriss','UKIP',7015);
INSERT INTO `candidates` VALUES (403,66,'Stephen White','LD',1723);
INSERT INTO `candidates` VALUES (404,66,'Thom Robinson','Green',1545);
INSERT INTO `candidates` VALUES (405,67,'Kate Hollern','Lab',24762);
INSERT INTO `candidates` VALUES (406,67,'Bob Eastwood','Con',12002);
INSERT INTO `candidates` VALUES (407,67,'Dayle Taylor','UKIP',6280);
INSERT INTO `candidates` VALUES (408,67,'Gordon Lishman','LD',955);
INSERT INTO `candidates` VALUES (409,68,'Graham Stringer','Lab',22982);
INSERT INTO `candidates` VALUES (410,68,'Martin Power','UKIP',6108);
INSERT INTO `candidates` VALUES (411,68,'Michelle Tanfield-Johnson','Con',5581);
INSERT INTO `candidates` VALUES (412,68,'David Jones','Green',1567);
INSERT INTO `candidates` VALUES (413,68,'Richard Gadsden','LD',874);
INSERT INTO `candidates` VALUES (414,69,'Paul Maynard','Con',17508);
INSERT INTO `candidates` VALUES (415,69,'Sam Rushworth','Lab',14168);
INSERT INTO `candidates` VALUES (416,69,'Simon Noble','UKIP',5823);
INSERT INTO `candidates` VALUES (417,69,'Sue Close','LD',948);
INSERT INTO `candidates` VALUES (418,69,'John Warnock','Green',889);
INSERT INTO `candidates` VALUES (419,69,'James Walsh','Northern',57);
INSERT INTO `candidates` VALUES (420,70,'Gordon Marsden','Lab',13548);
INSERT INTO `candidates` VALUES (421,70,'Peter Anthony','Con',10963);
INSERT INTO `candidates` VALUES (422,70,'Peter Wood','UKIP',5613);
INSERT INTO `candidates` VALUES (423,70,'Duncan Royle','Green',841);
INSERT INTO `candidates` VALUES (424,70,'Bill Greene','LD',743);
INSERT INTO `candidates` VALUES (425,70,'Andy Higgins','Ind',655);
INSERT INTO `candidates` VALUES (426,70,'Lawrence Chard','Ind',73);
INSERT INTO `candidates` VALUES (427,71,'Nick Smith','Lab',18380);
INSERT INTO `candidates` VALUES (428,71,'Susan Boucher','UKIP',5677);
INSERT INTO `candidates` VALUES (429,71,'Tracey West','Con',3419);
INSERT INTO `candidates` VALUES (430,71,'Steffan Lewis','PC',2849);
INSERT INTO `candidates` VALUES (431,71,'Mark Pond','Green',738);
INSERT INTO `candidates` VALUES (432,71,'Sam Rees','LD',620);
INSERT INTO `candidates` VALUES (433,72,'David Anderson','Lab',22090);
INSERT INTO `candidates` VALUES (434,72,'Mark Bell','UKIP',7863);
INSERT INTO `candidates` VALUES (435,72,'Alison Griffiths','Con',7838);
INSERT INTO `candidates` VALUES (436,72,'Jonathan Wallace','LD',5497);
INSERT INTO `candidates` VALUES (437,72,'Paul McNally','Green',1648);
INSERT INTO `candidates` VALUES (438,73,'Ronnie Campbell','Lab',17813);
INSERT INTO `candidates` VALUES (439,73,'Barry Elliott','UKIP',8584);
INSERT INTO `candidates` VALUES (440,73,'Greg Munro','Con',8346);
INSERT INTO `candidates` VALUES (441,73,'Philip Latham','LD',2265);
INSERT INTO `candidates` VALUES (442,73,'Dawn Furness','Green',1453);
INSERT INTO `candidates` VALUES (443,74,'Nick Gibb','Con',24185);
INSERT INTO `candidates` VALUES (444,74,'Graham Jones','UKIP',10241);
INSERT INTO `candidates` VALUES (445,74,'Alan Butcher','Lab',6508);
INSERT INTO `candidates` VALUES (446,74,'Francis Oppler','LD',4240);
INSERT INTO `candidates` VALUES (447,74,'Simon McDougall','Green',1942);
INSERT INTO `candidates` VALUES (448,75,'Dennis Skinner','Lab',22542);
INSERT INTO `candidates` VALUES (449,75,'Peter Bedford','Con',10764);
INSERT INTO `candidates` VALUES (450,75,'Ray Calladine','UKIP',9228);
INSERT INTO `candidates` VALUES (451,75,'David Lomax','LD',1464);
INSERT INTO `candidates` VALUES (452,76,'David Crausby','Lab',18541);
INSERT INTO `candidates` VALUES (453,76,'James Daly','Con',14164);
INSERT INTO `candidates` VALUES (454,76,'Harry Lamb','UKIP',8117);
INSERT INTO `candidates` VALUES (455,76,'Stephen Rock','LD',1236);
INSERT INTO `candidates` VALUES (456,76,'Laura Diggle','Green',1103);
INSERT INTO `candidates` VALUES (457,77,'Yasmin Qureshi','Lab',20555);
INSERT INTO `candidates` VALUES (458,77,'Jeff Armstrong','UKIP',9627);
INSERT INTO `candidates` VALUES (459,77,'Mudasir Dean','Con',8289);
INSERT INTO `candidates` VALUES (460,77,'Alan Johnson','Green',1200);
INSERT INTO `candidates` VALUES (461,77,'Darren Reynolds','LD',1072);
INSERT INTO `candidates` VALUES (462,78,'Chris Green','Con',19744);
INSERT INTO `candidates` VALUES (463,78,'Julie Hilling','Lab',18943);
INSERT INTO `candidates` VALUES (464,78,'Bob Horsefield','UKIP',7428);
INSERT INTO `candidates` VALUES (465,78,'Andrew Martin','LD',1947);
INSERT INTO `candidates` VALUES (466,78,'Andy Smith','Ind',321);
INSERT INTO `candidates` VALUES (467,78,'John Vickers','TUSC',209);
INSERT INTO `candidates` VALUES (468,79,'Peter Dowd','Lab',33619);
INSERT INTO `candidates` VALUES (469,79,'Paul Nuttall','UKIP',4915);
INSERT INTO `candidates` VALUES (470,79,'Jade Marsden','Con',3639);
INSERT INTO `candidates` VALUES (471,79,'Lisa Tallis','Green',1501);
INSERT INTO `candidates` VALUES (472,79,'David Newman','LD',978);
INSERT INTO `candidates` VALUES (473,79,'Pete Glover','TUSC',500);
INSERT INTO `candidates` VALUES (474,80,'Matt Warman','Con',18981);
INSERT INTO `candidates` VALUES (475,80,'Robin Hunter-Clarke','UKIP',14645);
INSERT INTO `candidates` VALUES (476,80,'Paul Kenny','Lab',7142);
INSERT INTO `candidates` VALUES (477,80,'David Watts','LD',1015);
INSERT INTO `candidates` VALUES (478,80,'Victoria Percival','Green',800);
INSERT INTO `candidates` VALUES (479,80,'Chris Pain','IE',324);
INSERT INTO `candidates` VALUES (480,80,'Peter Johnson','ND',170);
INSERT INTO `candidates` VALUES (481,80,'Lyn Luxton','Pilgrim',143);
INSERT INTO `candidates` VALUES (482,80,'Robert West','BNP',119);
INSERT INTO `candidates` VALUES (483,81,'David Tredinnick','Con',22939);
INSERT INTO `candidates` VALUES (484,81,'Michael Mullaney','LD',11951);
INSERT INTO `candidates` VALUES (485,81,'Chris Kealey','Lab',9354);
INSERT INTO `candidates` VALUES (486,81,'David Sprason','UKIP',9338);
INSERT INTO `candidates` VALUES (487,82,'Tobias Ellwood','Con',22060);
INSERT INTO `candidates` VALUES (488,82,'Peter Stokes','Lab',7448);
INSERT INTO `candidates` VALUES (489,82,'David Hughes','UKIP',7401);
INSERT INTO `candidates` VALUES (490,82,'Jon Nicholas','LD',3752);
INSERT INTO `candidates` VALUES (491,82,'Alasdair Keddie','Green',3263);
INSERT INTO `candidates` VALUES (492,82,'David Ross','Bournemouth',903);
INSERT INTO `candidates` VALUES (493,83,'Conor Burns','Con',20155);
INSERT INTO `candidates` VALUES (494,83,'Martin Houlden','UKIP',7745);
INSERT INTO `candidates` VALUES (495,83,'David Stokes','Lab',7386);
INSERT INTO `candidates` VALUES (496,83,'Mike Plummer','LD',3281);
INSERT INTO `candidates` VALUES (497,83,'Elizabeth McManus','Green',3107);
INSERT INTO `candidates` VALUES (498,83,'Dick Franklin','Patria',99);
INSERT INTO `candidates` VALUES (499,84,'Phillip Lee','Con',29606);
INSERT INTO `candidates` VALUES (500,84,'James Walsh','Lab',8956);
INSERT INTO `candidates` VALUES (501,84,'Richard Thomas','UKIP',8339);
INSERT INTO `candidates` VALUES (502,84,'Patrick Smith','LD',3983);
INSERT INTO `candidates` VALUES (503,84,'Derek Florey','Green',2202);
INSERT INTO `candidates` VALUES (504,85,'Imran Hussain','Lab',19312);
INSERT INTO `candidates` VALUES (505,85,'David Ward','LD',12228);
INSERT INTO `candidates` VALUES (506,85,'Iftikhar Ahmed','Con',4682);
INSERT INTO `candidates` VALUES (507,85,'Owais Rajput','UKIP',4103);
INSERT INTO `candidates` VALUES (508,85,'Dave Stevens','Green',871);
INSERT INTO `candidates` VALUES (509,85,'James Lewthwaite','Brit Dem',210);
INSERT INTO `candidates` VALUES (510,86,'Judith Cummins','Lab',16328);
INSERT INTO `candidates` VALUES (511,86,'Tanya Graham','Con',9878);
INSERT INTO `candidates` VALUES (512,86,'Jason Smith','UKIP',9057);
INSERT INTO `candidates` VALUES (513,86,'Andrew Robinson','Green',1243);
INSERT INTO `candidates` VALUES (514,86,'Andrew Tear','LD',1094);
INSERT INTO `candidates` VALUES (515,87,'Naseem Shah','Lab',19977);
INSERT INTO `candidates` VALUES (516,87,'George Galloway','Respect',8557);
INSERT INTO `candidates` VALUES (517,87,'George Grant','Con',6160);
INSERT INTO `candidates` VALUES (518,87,'Harry Boota','UKIP',3140);
INSERT INTO `candidates` VALUES (519,87,'Alun Griffiths','LD',1173);
INSERT INTO `candidates` VALUES (520,87,'Celia Hickson','Green',1085);
INSERT INTO `candidates` VALUES (521,87,'James Kirkcaldy','Ind',100);
INSERT INTO `candidates` VALUES (522,87,'Therese Hirst','Eng Dem',98);
INSERT INTO `candidates` VALUES (523,88,'James Cleverly','Con',27071);
INSERT INTO `candidates` VALUES (524,88,'Richard Bingley','UKIP',9461);
INSERT INTO `candidates` VALUES (525,88,'Malcolm Fincken','Lab',9296);
INSERT INTO `candidates` VALUES (526,88,'Matthew Klesel','LD',2488);
INSERT INTO `candidates` VALUES (527,88,'Paul Jeater','Green',1564);
INSERT INTO `candidates` VALUES (528,88,'Toby Pereira','Ind',295);
INSERT INTO `candidates` VALUES (529,88,'Paul Hooks','BNP',108);
INSERT INTO `candidates` VALUES (530,89,'Chris Davies','Con',16453);
INSERT INTO `candidates` VALUES (531,89,'Roger Williams','LD',11351);
INSERT INTO `candidates` VALUES (532,89,'Matthew Dorrance','Lab',5904);
INSERT INTO `candidates` VALUES (533,89,'Darran Thomas','UKIP',3338);
INSERT INTO `candidates` VALUES (534,89,'Freddy Greaves','PC',1767);
INSERT INTO `candidates` VALUES (535,89,'Chris Carmichael','Green',1261);
INSERT INTO `candidates` VALUES (536,90,'Dawn Butler','Lab',29216);
INSERT INTO `candidates` VALUES (537,90,'Alan Mendoza','Con',9567);
INSERT INTO `candidates` VALUES (538,90,'Lauren Keith','LD',3937);
INSERT INTO `candidates` VALUES (539,90,'Shahrar Ali','Green',1912);
INSERT INTO `candidates` VALUES (540,90,'Stephen Priestley','UKIP',1850);
INSERT INTO `candidates` VALUES (541,90,'John Boyle','TUSC',235);
INSERT INTO `candidates` VALUES (542,90,'Kamran Malik','Community',170);
INSERT INTO `candidates` VALUES (543,90,'Noel Coonan','Ind',145);
INSERT INTO `candidates` VALUES (544,91,'Barry Gardiner','Lab',28351);
INSERT INTO `candidates` VALUES (545,91,'Luke Parker','Con',17517);
INSERT INTO `candidates` VALUES (546,91,'Paul Lorber','LD',2607);
INSERT INTO `candidates` VALUES (547,91,'Alan Craig','UKIP',2024);
INSERT INTO `candidates` VALUES (548,91,'Scott Bartle','Green',1539);
INSERT INTO `candidates` VALUES (549,91,'Elcena Jeffers','Ind',197);
INSERT INTO `candidates` VALUES (550,92,'Ruth Cadbury','Lab',25096);
INSERT INTO `candidates` VALUES (551,92,'Mary Macleod','Con',24631);
INSERT INTO `candidates` VALUES (552,92,'Richard Hendron','UKIP',3203);
INSERT INTO `candidates` VALUES (553,92,'Joe Bourke','LD',2305);
INSERT INTO `candidates` VALUES (554,92,'Daniel Goldsmith','Green',2120);
INSERT INTO `candidates` VALUES (555,93,'Eric Pickles','Con',30534);
INSERT INTO `candidates` VALUES (556,93,'Michael McGough','UKIP',8724);
INSERT INTO `candidates` VALUES (557,93,'Liam Preston','Lab',6492);
INSERT INTO `candidates` VALUES (558,93,'David Kendall','LD',4577);
INSERT INTO `candidates` VALUES (559,93,'Reza Hossain','Green',1397);
INSERT INTO `candidates` VALUES (560,93,'Robin Tilbrook','Eng Dem',173);
INSERT INTO `candidates` VALUES (561,94,'Madeleine Moon','Lab',14624);
INSERT INTO `candidates` VALUES (562,94,'Meirion Jenkins','Con',12697);
INSERT INTO `candidates` VALUES (563,94,'Caroline Jones','UKIP',5911);
INSERT INTO `candidates` VALUES (564,94,'James Radcliffe','PC',2784);
INSERT INTO `candidates` VALUES (565,94,'Anita Davies','LD',1648);
INSERT INTO `candidates` VALUES (566,94,'Les Tallon-Morris','Ind',763);
INSERT INTO `candidates` VALUES (567,94,'Tony White','Green',736);
INSERT INTO `candidates` VALUES (568,94,'Aaron David','TUSC',118);
INSERT INTO `candidates` VALUES (569,94,'David Elston','Pirate',106);
INSERT INTO `candidates` VALUES (570,94,'Adam Lloyd','NF',66);
INSERT INTO `candidates` VALUES (571,95,'Ian Liddell-Grainger','Con',25020);
INSERT INTO `candidates` VALUES (572,95,'Stephen Fitzgerald','UKIP',10437);
INSERT INTO `candidates` VALUES (573,95,'Mick Lerry','Lab',9589);
INSERT INTO `candidates` VALUES (574,95,'Theodore Butt Phillip','LD',6765);
INSERT INTO `candidates` VALUES (575,95,'Julie Harvey-Smith','Green',2636);
INSERT INTO `candidates` VALUES (576,96,'Andrew Percy','Con',22946);
INSERT INTO `candidates` VALUES (577,96,'Jacky Crawford','Lab',11770);
INSERT INTO `candidates` VALUES (578,96,'David Jeffreys','UKIP',6694);
INSERT INTO `candidates` VALUES (579,96,'Natalie Hurst','Green',915);
INSERT INTO `candidates` VALUES (580,96,'Liz Leffman','LD',764);
INSERT INTO `candidates` VALUES (581,96,'Trevor Dixon','Ind',153);
INSERT INTO `candidates` VALUES (582,96,'Ray Spalding','IE',28);
INSERT INTO `candidates` VALUES (583,97,'Simon Kirby','Con',18428);
INSERT INTO `candidates` VALUES (584,97,'Nancy Platts','Lab',17738);
INSERT INTO `candidates` VALUES (585,97,'Ian Buchanan','UKIP',4446);
INSERT INTO `candidates` VALUES (586,97,'Davy Jones','Green',3187);
INSERT INTO `candidates` VALUES (587,97,'Paul Chandler','LD',1365);
INSERT INTO `candidates` VALUES (588,97,'Jacqueline Shodeke','SPGB',73);
INSERT INTO `candidates` VALUES (589,97,'Matt Taylor','Ind',69);
INSERT INTO `candidates` VALUES (590,98,'Caroline Lucas','Green',22871);
INSERT INTO `candidates` VALUES (591,98,'Purna Sen','Lab',14904);
INSERT INTO `candidates` VALUES (592,98,'Clarence Mitchell','Con',12448);
INSERT INTO `candidates` VALUES (593,98,'Nigel Carter','UKIP',2724);
INSERT INTO `candidates` VALUES (594,98,'Chris Bowers','LD',1525);
INSERT INTO `candidates` VALUES (595,98,'Nick Yeomans','Ind',116);
INSERT INTO `candidates` VALUES (596,98,'Howard Pilott','SPGB',88);
INSERT INTO `candidates` VALUES (597,99,'Kerry McCarthy','Lab',18148);
INSERT INTO `candidates` VALUES (598,99,'Theo Clarke','Con',14168);
INSERT INTO `candidates` VALUES (599,99,'James McMurray','UKIP',7152);
INSERT INTO `candidates` VALUES (600,99,'Lorraine Francis','Green',3827);
INSERT INTO `candidates` VALUES (601,99,'Abdul Malik','LD',2689);
INSERT INTO `candidates` VALUES (602,99,'Matt Gordon','TUSC',229);
INSERT INTO `candidates` VALUES (603,100,'Charlotte Leslie','Con',22767);
INSERT INTO `candidates` VALUES (604,100,'Darren Jones','Lab',17823);
INSERT INTO `candidates` VALUES (605,100,'Michael Frost','UKIP',4889);
INSERT INTO `candidates` VALUES (606,100,'Clare Campion-Smith','LD',3214);
INSERT INTO `candidates` VALUES (607,100,'Justin Quinnell','Green',2952);
INSERT INTO `candidates` VALUES (608,100,'Anne Lemon','TUSC',160);
INSERT INTO `candidates` VALUES (609,101,'Karin Smyth','Lab',19505);
INSERT INTO `candidates` VALUES (610,101,'Isobel Grant','Con',12377);
INSERT INTO `candidates` VALUES (611,101,'Steve Wood','UKIP',8381);
INSERT INTO `candidates` VALUES (612,101,'Tony Dyer','Green',5861);
INSERT INTO `candidates` VALUES (613,101,'Mark Wright','LD',4416);
INSERT INTO `candidates` VALUES (614,101,'Tom Baldwin','TUSC',302);
INSERT INTO `candidates` VALUES (615,102,'Thangam Debbonaire','Lab',22900);
INSERT INTO `candidates` VALUES (616,102,'Darren Hall','Green',17227);
INSERT INTO `candidates` VALUES (617,102,'Stephen Williams','LD',12103);
INSERT INTO `candidates` VALUES (618,102,'Claire Hiscott','Con',9752);
INSERT INTO `candidates` VALUES (619,102,'Paul Turner','UKIP',1940);
INSERT INTO `candidates` VALUES (620,102,'Dawn Parry','Bristol',204);
INSERT INTO `candidates` VALUES (621,102,'Stewart Weston','LU',92);
INSERT INTO `candidates` VALUES (622,103,'Keith Simpson','Con',26808);
INSERT INTO `candidates` VALUES (623,103,'Chris Jones','Lab',9970);
INSERT INTO `candidates` VALUES (624,103,'Stuart Agnew','UKIP',8881);
INSERT INTO `candidates` VALUES (625,103,'Steve Riley','LD',5178);
INSERT INTO `candidates` VALUES (626,103,'Andrew Boswell','Green',2252);
INSERT INTO `candidates` VALUES (627,104,'Bob Neill','Con',23343);
INSERT INTO `candidates` VALUES (628,104,'John Courtneidge','Lab',9779);
INSERT INTO `candidates` VALUES (629,104,'Emmett Jenner','UKIP',6285);
INSERT INTO `candidates` VALUES (630,104,'Sam Webber','LD',2836);
INSERT INTO `candidates` VALUES (631,104,'Roisin Robertson','Green',1823);
INSERT INTO `candidates` VALUES (632,105,'Sajid Javid','Con',28133);
INSERT INTO `candidates` VALUES (633,105,'Tom Ebbutt','Lab',11604);
INSERT INTO `candidates` VALUES (634,105,'Stuart Cross','UKIP',8163);
INSERT INTO `candidates` VALUES (635,105,'Bart Ricketts','LD',2616);
INSERT INTO `candidates` VALUES (636,105,'Spoz Esposito','Green',1729);
INSERT INTO `candidates` VALUES (637,106,'Charles Walker','Con',25797);
INSERT INTO `candidates` VALUES (638,106,'David Platt','UKIP',9074);
INSERT INTO `candidates` VALUES (639,106,'Edward Robinson','Lab',8470);
INSERT INTO `candidates` VALUES (640,106,'Anthony Rowlands','LD',1467);
INSERT INTO `candidates` VALUES (641,106,'Russell Secker','Green',1216);
INSERT INTO `candidates` VALUES (642,107,'Anna Soubry','Con',24163);
INSERT INTO `candidates` VALUES (643,107,'Nick Palmer','Lab',19876);
INSERT INTO `candidates` VALUES (644,107,'Frank Dunne','UKIP',5674);
INSERT INTO `candidates` VALUES (645,107,'Stan Heptinstall','LD',2120);
INSERT INTO `candidates` VALUES (646,107,'David Kirwan','Green',1544);
INSERT INTO `candidates` VALUES (647,107,'Ray Barry','JMB',63);
INSERT INTO `candidates` VALUES (648,108,'John Bercow','Con',34617);
INSERT INTO `candidates` VALUES (649,108,'David Fowler','UKIP',11675);
INSERT INTO `candidates` VALUES (650,108,'Alan Francis','Green',7400);
INSERT INTO `candidates` VALUES (651,109,'Julie Cooper','Lab',14951);
INSERT INTO `candidates` VALUES (652,109,'Gordon Birtwistle','LD',11707);
INSERT INTO `candidates` VALUES (653,109,'Tom Commis','UKIP',6864);
INSERT INTO `candidates` VALUES (654,109,'Sarah Cockburn-Price','Con',5374);
INSERT INTO `candidates` VALUES (655,109,'Mike Hargreaves','Green',850);
INSERT INTO `candidates` VALUES (656,110,'Andrew Griffiths','Con',24736);
INSERT INTO `candidates` VALUES (657,110,'Jon Wheale','Lab',13484);
INSERT INTO `candidates` VALUES (658,110,'Mike Green','UKIP',8658);
INSERT INTO `candidates` VALUES (659,110,'David MacDonald','LD',1232);
INSERT INTO `candidates` VALUES (660,110,'Sam Patrone','Green',1224);
INSERT INTO `candidates` VALUES (661,111,'David Nuttall','Con',18970);
INSERT INTO `candidates` VALUES (662,111,'James Frith','Lab',18592);
INSERT INTO `candidates` VALUES (663,111,'Ian Henderson','UKIP',5595);
INSERT INTO `candidates` VALUES (664,111,'John Southworth','Green',1141);
INSERT INTO `candidates` VALUES (665,111,'Richard Baum','LD',932);
INSERT INTO `candidates` VALUES (666,112,'Ivan Lewis','Lab',21272);
INSERT INTO `candidates` VALUES (667,112,'Daniel Critchlow','Con',16350);
INSERT INTO `candidates` VALUES (668,112,'Seamus Martin','UKIP',6299);
INSERT INTO `candidates` VALUES (669,112,'Paul Ankers','LD',1690);
INSERT INTO `candidates` VALUES (670,112,'Glyn Heath','Green',1434);
INSERT INTO `candidates` VALUES (671,112,'Valerie Morris','Eng Dem',170);
INSERT INTO `candidates` VALUES (672,113,'Jo Churchill','Con',31815);
INSERT INTO `candidates` VALUES (673,113,'Bill Edwards','Lab',10514);
INSERT INTO `candidates` VALUES (674,113,'John Howlett','UKIP',8739);
INSERT INTO `candidates` VALUES (675,113,'Helen Geake','Green',4692);
INSERT INTO `candidates` VALUES (676,113,'David Chappell','LD',3581);
INSERT INTO `candidates` VALUES (677,114,'Wayne David','Lab',17864);
INSERT INTO `candidates` VALUES (678,114,'Sam Gould','UKIP',7791);
INSERT INTO `candidates` VALUES (679,114,'Leo Docherty','Con',6683);
INSERT INTO `candidates` VALUES (680,114,'Beci Newton','PC',5895);
INSERT INTO `candidates` VALUES (681,114,'Katy Beddoe','Green',937);
INSERT INTO `candidates` VALUES (682,114,'Aladdin Ayesh','LD',935);
INSERT INTO `candidates` VALUES (683,114,'Jaime Davies','TUSC',178);
INSERT INTO `candidates` VALUES (684,115,'Paul Monaghan','SNP',15831);
INSERT INTO `candidates` VALUES (685,115,'John Thurso','LD',11987);
INSERT INTO `candidates` VALUES (686,115,'John Erskine','Lab',3061);
INSERT INTO `candidates` VALUES (687,115,'Alastair Graham','Con',2326);
INSERT INTO `candidates` VALUES (688,115,'Ann Therese Murray','UKIP',981);
INSERT INTO `candidates` VALUES (689,116,'Craig Whittaker','Con',23354);
INSERT INTO `candidates` VALUES (690,116,'Josh Fenton-Glynn','Lab',18927);
INSERT INTO `candidates` VALUES (691,116,'Paul Rogan','UKIP',5950);
INSERT INTO `candidates` VALUES (692,116,'Alisdair Calder McGregor','LD',2666);
INSERT INTO `candidates` VALUES (693,116,'Jenny Shepherd','Green',2090);
INSERT INTO `candidates` VALUES (694,116,'Rod Sutcliffe','Yorks',389);
INSERT INTO `candidates` VALUES (695,116,'Joe Stead','Song',165);
INSERT INTO `candidates` VALUES (696,117,'Harriet Harman','Lab',32614);
INSERT INTO `candidates` VALUES (697,117,'Naomi Newstead','Con',6790);
INSERT INTO `candidates` VALUES (698,117,'Amelia Womack','Green',5187);
INSERT INTO `candidates` VALUES (699,117,'Yahaya Kiingi','LD',2580);
INSERT INTO `candidates` VALUES (700,117,'David Kurten','UKIP',2413);
INSERT INTO `candidates` VALUES (701,117,'Prem Goyal','AP',829);
INSERT INTO `candidates` VALUES (702,117,'Rebecca Fox','NHAP',466);
INSERT INTO `candidates` VALUES (703,117,'Nick Wrack','TUSC',292);
INSERT INTO `candidates` VALUES (704,117,'Alex Robertson','CSA',197);
INSERT INTO `candidates` VALUES (705,117,'Joshua Ogunleye','WRP',107);
INSERT INTO `candidates` VALUES (706,117,'Felicity Anscomb','Whig',86);
INSERT INTO `candidates` VALUES (707,118,'George Eustice','Con',18452);
INSERT INTO `candidates` VALUES (708,118,'Michael Foster','Lab',11448);
INSERT INTO `candidates` VALUES (709,118,'Bob Smith','UKIP',6776);
INSERT INTO `candidates` VALUES (710,118,'Julia Goldsworthy','LD',5687);
INSERT INTO `candidates` VALUES (711,118,'Geoff Garbett','Green',2608);
INSERT INTO `candidates` VALUES (712,118,'Loveday Jenkin','Meb Ker',897);
INSERT INTO `candidates` VALUES (713,119,'Daniel Zeichner','Lab',18646);
INSERT INTO `candidates` VALUES (714,119,'Julian Huppert','LD',18047);
INSERT INTO `candidates` VALUES (715,119,'Chamali Fernando','Con',8117);
INSERT INTO `candidates` VALUES (716,119,'Rupert Read','Green',4109);
INSERT INTO `candidates` VALUES (717,119,'Patrick O\'Flynn','UKIP',2668);
INSERT INTO `candidates` VALUES (718,119,'Keith Garrett','RTP',187);
INSERT INTO `candidates` VALUES (719,120,'Stephen Barclay','Con',28524);
INSERT INTO `candidates` VALUES (720,120,'Andrew Charalambous','UKIP',11650);
INSERT INTO `candidates` VALUES (721,120,'Ken Rustidge','Lab',7476);
INSERT INTO `candidates` VALUES (722,120,'Lucy Nethsingha','LD',2314);
INSERT INTO `candidates` VALUES (723,120,'Helen Scott-Daniels','Green',1816);
INSERT INTO `candidates` VALUES (724,121,'Shailesh Vara','Con',32070);
INSERT INTO `candidates` VALUES (725,121,'Peter Reeve','UKIP',12275);
INSERT INTO `candidates` VALUES (726,121,'Nick Thulbourn','Lab',10927);
INSERT INTO `candidates` VALUES (727,121,'Nicholas Sandford','LD',3479);
INSERT INTO `candidates` VALUES (728,121,'Nicola Day','Green',2159);
INSERT INTO `candidates` VALUES (729,121,'Fay Belham','CPA',190);
INSERT INTO `candidates` VALUES (730,122,'Heidi Allen','Con',31454);
INSERT INTO `candidates` VALUES (731,122,'Dan Greef','Lab',10860);
INSERT INTO `candidates` VALUES (732,122,'Sebastian Kindersley','LD',9368);
INSERT INTO `candidates` VALUES (733,122,'Marion Mason','UKIP',6010);
INSERT INTO `candidates` VALUES (734,122,'Simon Saggers','Green',3848);
INSERT INTO `candidates` VALUES (735,123,'Lucy Frazer','Con',28845);
INSERT INTO `candidates` VALUES (736,123,'Jonathan Chatfield','LD',12008);
INSERT INTO `candidates` VALUES (737,123,'Huw Jones','Lab',9013);
INSERT INTO `candidates` VALUES (738,123,'Deborah Rennie','UKIP',6593);
INSERT INTO `candidates` VALUES (739,123,'Clive Semmens','Green',3047);
INSERT INTO `candidates` VALUES (740,124,'Amanda Milling','Con',20811);
INSERT INTO `candidates` VALUES (741,124,'Janos Toth','Lab',15888);
INSERT INTO `candidates` VALUES (742,124,'Grahame Wiggin','UKIP',8224);
INSERT INTO `candidates` VALUES (743,124,'Ian Jackson','LD',1270);
INSERT INTO `candidates` VALUES (744,124,'Paul Woodhead','Green',906);
INSERT INTO `candidates` VALUES (745,125,'Julian Brazier','Con',22918);
INSERT INTO `candidates` VALUES (746,125,'Hugh Lanning','Lab',13120);
INSERT INTO `candidates` VALUES (747,125,'Jim Gascoyne','UKIP',7289);
INSERT INTO `candidates` VALUES (748,125,'James Flanagan','LD',6227);
INSERT INTO `candidates` VALUES (749,125,'Stuart Jeffery','Green',3746);
INSERT INTO `candidates` VALUES (750,125,'Robert Cox','SPGB',165);
INSERT INTO `candidates` VALUES (751,126,'Jo Stevens','Lab',15462);
INSERT INTO `candidates` VALUES (752,126,'Jenny Willott','LD',10481);
INSERT INTO `candidates` VALUES (753,126,'Richard Hopkin','Con',5674);
INSERT INTO `candidates` VALUES (754,126,'Anthony Raybould','UKIP',2499);
INSERT INTO `candidates` VALUES (755,126,'Christopher von Ruhland','Green',2461);
INSERT INTO `candidates` VALUES (756,126,'Martin Pollard','PC',1925);
INSERT INTO `candidates` VALUES (757,126,'Steve Williams','TUSC',110);
INSERT INTO `candidates` VALUES (758,126,'Kazimir Hubert','Ind',34);
INSERT INTO `candidates` VALUES (759,127,'Craig Williams','Con',21709);
INSERT INTO `candidates` VALUES (760,127,'Mari Williams','Lab',19572);
INSERT INTO `candidates` VALUES (761,127,'Ethan Wilkinson','UKIP',3953);
INSERT INTO `candidates` VALUES (762,127,'Elin Walker Jones','PC',2301);
INSERT INTO `candidates` VALUES (763,127,'Elizabeth Clark','LD',1953);
INSERT INTO `candidates` VALUES (764,127,'Ruth Osner','Green',1254);
INSERT INTO `candidates` VALUES (765,127,'Jeff Green','Ch P',331);
INSERT INTO `candidates` VALUES (766,127,'Shaun Jenkins','Change',78);
INSERT INTO `candidates` VALUES (767,128,'Stephen Doughty','Lab',19966);
INSERT INTO `candidates` VALUES (768,128,'Emma Warman','Con',12513);
INSERT INTO `candidates` VALUES (769,128,'John Rees-Evans','UKIP',6423);
INSERT INTO `candidates` VALUES (770,128,'Ben Foday','PC',3443);
INSERT INTO `candidates` VALUES (771,128,'Nigel Howells','LD',2318);
INSERT INTO `candidates` VALUES (772,128,'Anthony Slaughter','Green',1746);
INSERT INTO `candidates` VALUES (773,128,'Ross Saunders','TUSC',258);
INSERT INTO `candidates` VALUES (774,129,'Kevin Brennan','Lab',17803);
INSERT INTO `candidates` VALUES (775,129,'James Taghdissian','Con',11014);
INSERT INTO `candidates` VALUES (776,129,'Neil McEvoy','PC',6096);
INSERT INTO `candidates` VALUES (777,129,'Brian Morris','UKIP',4923);
INSERT INTO `candidates` VALUES (778,129,'Cadan ap Tomos','LD',2069);
INSERT INTO `candidates` VALUES (779,129,'Ken Barker','Green',1704);
INSERT INTO `candidates` VALUES (780,129,'Helen Jones','TUSC',183);
INSERT INTO `candidates` VALUES (781,130,'John Stevenson','Con',18873);
INSERT INTO `candidates` VALUES (782,130,'Lee Sherriff','Lab',16099);
INSERT INTO `candidates` VALUES (783,130,'Fiona Mills','UKIP',5277);
INSERT INTO `candidates` VALUES (784,130,'Helen Davison','Green',1125);
INSERT INTO `candidates` VALUES (785,130,'Loraine Birchall','LD',1087);
INSERT INTO `candidates` VALUES (786,130,'Alfred Okam','Ind',126);
INSERT INTO `candidates` VALUES (787,131,'Jonathan Edwards','PC',15140);
INSERT INTO `candidates` VALUES (788,131,'Calum Higgins','Lab',9541);
INSERT INTO `candidates` VALUES (789,131,'Matthew Paul','Con',8336);
INSERT INTO `candidates` VALUES (790,131,'Norma Woodward','UKIP',4363);
INSERT INTO `candidates` VALUES (791,131,'Ben Rice','Green',1091);
INSERT INTO `candidates` VALUES (792,131,'Sara Lloyd-Williams','LD',928);
INSERT INTO `candidates` VALUES (793,132,'Simon Hart','Con',17626);
INSERT INTO `candidates` VALUES (794,132,'Delyth Evans','Lab',11572);
INSERT INTO `candidates` VALUES (795,132,'John Atkinson','UKIP',4698);
INSERT INTO `candidates` VALUES (796,132,'Elwyn Williams','PC',4201);
INSERT INTO `candidates` VALUES (797,132,'Gary Tapley','Green',1290);
INSERT INTO `candidates` VALUES (798,132,'Selwyn Runnett','LD',963);
INSERT INTO `candidates` VALUES (799,133,'Tom Brake','LD',16603);
INSERT INTO `candidates` VALUES (800,133,'Matthew Maxwell Scott','Con',15093);
INSERT INTO `candidates` VALUES (801,133,'Siobhan Tate','Lab',7150);
INSERT INTO `candidates` VALUES (802,133,'Bill Main-Ian','UKIP',7049);
INSERT INTO `candidates` VALUES (803,133,'Ross Hemingway','Green',1492);
INSERT INTO `candidates` VALUES (804,133,'Ashley Dickenson','CPA',177);
INSERT INTO `candidates` VALUES (805,133,'Richard Edmonds','NF',49);
INSERT INTO `candidates` VALUES (806,134,'Rebecca Harris','Con',23112);
INSERT INTO `candidates` VALUES (807,134,'Jamie Huntman','UKIP',14178);
INSERT INTO `candidates` VALUES (808,134,'Joe Cooke','Lab',6283);
INSERT INTO `candidates` VALUES (809,134,'Dominic Ellis','Green',1076);
INSERT INTO `candidates` VALUES (810,134,'Sereena Davey','LD',801);
INSERT INTO `candidates` VALUES (811,135,'Mark Williams','LD',13414);
INSERT INTO `candidates` VALUES (812,135,'Mike Parker','PC',10347);
INSERT INTO `candidates` VALUES (813,135,'Henrietta Hensher','Con',4123);
INSERT INTO `candidates` VALUES (814,135,'Gethin James','UKIP',3829);
INSERT INTO `candidates` VALUES (815,135,'Huw Thomas','Lab',3615);
INSERT INTO `candidates` VALUES (816,135,'Daniel Thompson','Green',2088);
INSERT INTO `candidates` VALUES (817,136,'Edward Argar','Con',28384);
INSERT INTO `candidates` VALUES (818,136,'Sean Kelly-Walsh','Lab',11453);
INSERT INTO `candidates` VALUES (819,136,'Lynton Yates','UKIP',8330);
INSERT INTO `candidates` VALUES (820,136,'Simon Sansome','LD',3605);
INSERT INTO `candidates` VALUES (821,136,'Cathy Duffy','BNP',489);
INSERT INTO `candidates` VALUES (822,137,'Tracey Crouch','Con',21614);
INSERT INTO `candidates` VALUES (823,137,'Tristan Osborne','Lab',10159);
INSERT INTO `candidates` VALUES (824,137,'Ian Wallace','UKIP',8581);
INSERT INTO `candidates` VALUES (825,137,'Thomas Quinton','LD',1360);
INSERT INTO `candidates` VALUES (826,137,'Luke Balnave','Green',1101);
INSERT INTO `candidates` VALUES (827,137,'John-Wesley Gibson','CPA',133);
INSERT INTO `candidates` VALUES (828,137,'Ivor Riddell','TUSC',125);
INSERT INTO `candidates` VALUES (829,138,'Mary Robinson','Con',22889);
INSERT INTO `candidates` VALUES (830,138,'Mark Hunter','LD',16436);
INSERT INTO `candidates` VALUES (831,138,'Martin Miller','Lab',8673);
INSERT INTO `candidates` VALUES (832,138,'Shaun Hopkins','UKIP',4423);
INSERT INTO `candidates` VALUES (833,138,'Matthew Torbitt','Ind',390);
INSERT INTO `candidates` VALUES (834,138,'Drew Carswell','Above',208);
INSERT INTO `candidates` VALUES (835,138,'Helen Bashford','IE',76);
INSERT INTO `candidates` VALUES (836,139,'Simon Burns','Con',27732);
INSERT INTO `candidates` VALUES (837,139,'Chris Vince','Lab',9482);
INSERT INTO `candidates` VALUES (838,139,'Mark Gough','UKIP',7652);
INSERT INTO `candidates` VALUES (839,139,'Stephen Robinson','LD',6394);
INSERT INTO `candidates` VALUES (840,139,'Angela Thomson','Green',1892);
INSERT INTO `candidates` VALUES (841,139,'Henry Boyle','Lib',665);
INSERT INTO `candidates` VALUES (842,140,'Greg Hands','Con',25322);
INSERT INTO `candidates` VALUES (843,140,'Alexandra Sanderson','Lab',9300);
INSERT INTO `candidates` VALUES (844,140,'Simon Bailey','LD',2091);
INSERT INTO `candidates` VALUES (845,140,'Adrian Noble','UKIP',2039);
INSERT INTO `candidates` VALUES (846,140,'Guy Rubin','Green',1474);
INSERT INTO `candidates` VALUES (847,141,'Alex Chalk','Con',24790);
INSERT INTO `candidates` VALUES (848,141,'Martin Horwood','LD',18274);
INSERT INTO `candidates` VALUES (849,141,'Paul Gilbert','Lab',3902);
INSERT INTO `candidates` VALUES (850,141,'Christina Simmonds','UKIP',3808);
INSERT INTO `candidates` VALUES (851,141,'Adam Van Coevorden','Green',2689);
INSERT INTO `candidates` VALUES (852,141,'Richard Lupson-Darnell','Ind',272);
INSERT INTO `candidates` VALUES (853,142,'Cheryl Gillan','Con',31138);
INSERT INTO `candidates` VALUES (854,142,'Alan Stevens','UKIP',7218);
INSERT INTO `candidates` VALUES (855,142,'Benjamin Davies','Lab',6712);
INSERT INTO `candidates` VALUES (856,142,'Kirsten Johnson','LD',4761);
INSERT INTO `candidates` VALUES (857,142,'Gill Walker','Green',2902);
INSERT INTO `candidates` VALUES (858,143,'Chris Matheson','Lab',22118);
INSERT INTO `candidates` VALUES (859,143,'Stephen Mosley','Con',22025);
INSERT INTO `candidates` VALUES (860,143,'Stephen Ingram','UKIP',4148);
INSERT INTO `candidates` VALUES (861,143,'Bob Thompson','LD',2870);
INSERT INTO `candidates` VALUES (862,144,'Toby Perkins','Lab',21829);
INSERT INTO `candidates` VALUES (863,144,'Mark Vivis','Con',8231);
INSERT INTO `candidates` VALUES (864,144,'Stuart Yeowart','UKIP',7523);
INSERT INTO `candidates` VALUES (865,144,'Julia Cambridge','LD',6301);
INSERT INTO `candidates` VALUES (866,144,'Matthew Genn','Green',1352);
INSERT INTO `candidates` VALUES (867,144,'Matt Whale','TUSC',202);
INSERT INTO `candidates` VALUES (868,144,'Tommy Holgate','Peace',129);
INSERT INTO `candidates` VALUES (869,145,'Andrew Tyrie','Con',32953);
INSERT INTO `candidates` VALUES (870,145,'Andrew Moncreiff','UKIP',8540);
INSERT INTO `candidates` VALUES (871,145,'Mark Farwell','Lab',6933);
INSERT INTO `candidates` VALUES (872,145,'Andrew Smith','LD',4865);
INSERT INTO `candidates` VALUES (873,145,'Jasper Richmond','Green',3742);
INSERT INTO `candidates` VALUES (874,145,'Andrew Emerson','Patria',106);
INSERT INTO `candidates` VALUES (875,146,'Iain Duncan Smith','Con',20999);
INSERT INTO `candidates` VALUES (876,146,'Bilal Mahmood','Lab',12613);
INSERT INTO `candidates` VALUES (877,146,'Freddy Vachha','UKIP',5644);
INSERT INTO `candidates` VALUES (878,146,'Anne Crook','LD',2400);
INSERT INTO `candidates` VALUES (879,146,'Rebecca Tully','Green',1854);
INSERT INTO `candidates` VALUES (880,146,'Len Hockey','TUSC',241);
INSERT INTO `candidates` VALUES (881,146,'Lisa McKenzie','Class War',53);
INSERT INTO `candidates` VALUES (882,147,'Michelle Donelan','Con',26354);
INSERT INTO `candidates` VALUES (883,147,'Duncan Hames','LD',16278);
INSERT INTO `candidates` VALUES (884,147,'Julia Reid','UKIP',5884);
INSERT INTO `candidates` VALUES (885,147,'Andy Newman','Lab',4561);
INSERT INTO `candidates` VALUES (886,147,'Tina Johnston','Green',2330);
INSERT INTO `candidates` VALUES (887,148,'Theresa Villiers','Con',25759);
INSERT INTO `candidates` VALUES (888,148,'Amy Trevethan','Lab',18103);
INSERT INTO `candidates` VALUES (889,148,'Victor Kaye','UKIP',4151);
INSERT INTO `candidates` VALUES (890,148,'AM Poppy','Green',2501);
INSERT INTO `candidates` VALUES (891,148,'Marisha Ray','LD',2381);
INSERT INTO `candidates` VALUES (892,148,'Mehdi Akhavan','ND',118);
INSERT INTO `candidates` VALUES (893,149,'Lindsay Hoyle','Lab',23322);
INSERT INTO `candidates` VALUES (894,149,'Rob Loughenbury','Con',18792);
INSERT INTO `candidates` VALUES (895,149,'Mark Smith','UKIP',6995);
INSERT INTO `candidates` VALUES (896,149,'Stephen Fenn','LD',1354);
INSERT INTO `candidates` VALUES (897,149,'Alistair Straw','Green',1111);
INSERT INTO `candidates` VALUES (898,149,'Adrian Maudsley','Ind',138);
INSERT INTO `candidates` VALUES (899,150,'Christopher Chope','Con',28887);
INSERT INTO `candidates` VALUES (900,150,'Robin Grey','UKIP',10663);
INSERT INTO `candidates` VALUES (901,150,'Andrew Satherley','Lab',4745);
INSERT INTO `candidates` VALUES (902,150,'Andy Canning','LD',3263);
INSERT INTO `candidates` VALUES (903,150,'Shona Dunn','Green',2149);
INSERT INTO `candidates` VALUES (904,151,'Mark Field','Con',19570);
INSERT INTO `candidates` VALUES (905,151,'Nik Slingsby','Lab',9899);
INSERT INTO `candidates` VALUES (906,151,'Belinda Brooks-Gordon','LD',2521);
INSERT INTO `candidates` VALUES (907,151,'Hugh Small','Green',1953);
INSERT INTO `candidates` VALUES (908,151,'Robert Stephenson','UKIP',1894);
INSERT INTO `candidates` VALUES (909,151,'Edouard-Henri Desforges','CSA',160);
INSERT INTO `candidates` VALUES (910,151,'Jill McLachlan','CPA',129);
INSERT INTO `candidates` VALUES (911,151,'Adam Clifford','Class War',59);
INSERT INTO `candidates` VALUES (912,152,'Douglas Carswell','UKIP',19642);
INSERT INTO `candidates` VALUES (913,152,'Giles Watling','Con',16205);
INSERT INTO `candidates` VALUES (914,152,'Tim Young','Lab',6364);
INSERT INTO `candidates` VALUES (915,152,'Chris Southall','Green',1184);
INSERT INTO `candidates` VALUES (916,152,'David Grace','LD',812);
INSERT INTO `candidates` VALUES (917,153,'Martin Vickers','Con',21026);
INSERT INTO `candidates` VALUES (918,153,'Peter Keith','Lab',13133);
INSERT INTO `candidates` VALUES (919,153,'Stephen Harness','UKIP',8356);
INSERT INTO `candidates` VALUES (920,153,'Roy Horobin','LD',1346);
INSERT INTO `candidates` VALUES (921,153,'Carol Thornton','Green',1013);
INSERT INTO `candidates` VALUES (922,153,'Malcolm Morland','TUSC',215);
INSERT INTO `candidates` VALUES (923,154,'Susan Elan Jones','Lab',13051);
INSERT INTO `candidates` VALUES (924,154,'David Nicholls','Con',10649);
INSERT INTO `candidates` VALUES (925,154,'Mandy Jones','UKIP',5480);
INSERT INTO `candidates` VALUES (926,154,'Mabon ap Gwynfor','PC',3620);
INSERT INTO `candidates` VALUES (927,154,'Bruce Roberts','LD',1349);
INSERT INTO `candidates` VALUES (928,154,'Duncan Rees','Green',915);
INSERT INTO `candidates` VALUES (929,155,'David Jones','Con',16463);
INSERT INTO `candidates` VALUES (930,155,'Gareth Thomas','Lab',9733);
INSERT INTO `candidates` VALUES (931,155,'Warwick Nicholson','UKIP',4988);
INSERT INTO `candidates` VALUES (932,155,'Marc Jones','PC',4651);
INSERT INTO `candidates` VALUES (933,155,'Sarah Lesiter-Burgess','LD',1387);
INSERT INTO `candidates` VALUES (934,155,'Bob English','Soc Lab',612);
INSERT INTO `candidates` VALUES (935,155,'Rory Jepson','Above',194);
INSERT INTO `candidates` VALUES (936,156,'Phil Boswell','SNP',28696);
INSERT INTO `candidates` VALUES (937,156,'Tom Clarke','Lab',17195);
INSERT INTO `candidates` VALUES (938,156,'Mhairi Fraser','Con',3209);
INSERT INTO `candidates` VALUES (939,156,'Scott Cairns','UKIP',1049);
INSERT INTO `candidates` VALUES (940,156,'Robert Simpson','LD',549);
INSERT INTO `candidates` VALUES (941,157,'Will Quince','Con',18919);
INSERT INTO `candidates` VALUES (942,157,'Bob Russell','LD',13344);
INSERT INTO `candidates` VALUES (943,157,'Jordan Newell','Lab',7852);
INSERT INTO `candidates` VALUES (944,157,'John Pitts','UKIP',5870);
INSERT INTO `candidates` VALUES (945,157,'Mark Goacher','Green',2499);
INSERT INTO `candidates` VALUES (946,157,'Ken Scrimshaw','CPA',109);
INSERT INTO `candidates` VALUES (947,158,'Jason McCartney','Con',25246);
INSERT INTO `candidates` VALUES (948,158,'Jane East','Lab',19868);
INSERT INTO `candidates` VALUES (949,158,'Melanie Roberts','UKIP',5734);
INSERT INTO `candidates` VALUES (950,158,'Cahal Burke','LD',3407);
INSERT INTO `candidates` VALUES (951,158,'Chas Ball','Green',1919);
INSERT INTO `candidates` VALUES (952,158,'Paul Salveson','Yorks',572);
INSERT INTO `candidates` VALUES (953,158,'Melodie Staniforth','ND',54);
INSERT INTO `candidates` VALUES (954,159,'Fiona Bruce','Con',27164);
INSERT INTO `candidates` VALUES (955,159,'Darren Price','Lab',10391);
INSERT INTO `candidates` VALUES (956,159,'Lee Slaughter','UKIP',6922);
INSERT INTO `candidates` VALUES (957,159,'Peter Hirst','LD',4623);
INSERT INTO `candidates` VALUES (958,159,'Alec Heath','Green',1876);
INSERT INTO `candidates` VALUES (959,160,'Jamie Reed','Lab',16750);
INSERT INTO `candidates` VALUES (960,160,'Stephen Haraldsen','Con',14186);
INSERT INTO `candidates` VALUES (961,160,'Michael Pye','UKIP',6148);
INSERT INTO `candidates` VALUES (962,160,'Danny Gallagher','LD',1368);
INSERT INTO `candidates` VALUES (963,160,'Allan Todd','Green',1179);
INSERT INTO `candidates` VALUES (964,161,'Tom Pursglove','Con',24023);
INSERT INTO `candidates` VALUES (965,161,'Andy Sawford','Lab',21611);
INSERT INTO `candidates` VALUES (966,161,'Margot Parker','UKIP',7708);
INSERT INTO `candidates` VALUES (967,161,'Peter Harris','LD',1458);
INSERT INTO `candidates` VALUES (968,161,'Jonathan Hornett','Green',1374);
INSERT INTO `candidates` VALUES (969,162,'Scott Mann','Con',21689);
INSERT INTO `candidates` VALUES (970,162,'Dan Rogerson','LD',15068);
INSERT INTO `candidates` VALUES (971,162,'Julie Lingard','UKIP',6121);
INSERT INTO `candidates` VALUES (972,162,'John Whitby','Lab',2621);
INSERT INTO `candidates` VALUES (973,162,'Amanda Pennington','Green',2063);
INSERT INTO `candidates` VALUES (974,162,'Jeremy Jefferies','Meb Ker',631);
INSERT INTO `candidates` VALUES (975,162,'John Allman','Restore',52);
INSERT INTO `candidates` VALUES (976,163,'Sheryll Murray','Con',25516);
INSERT INTO `candidates` VALUES (977,163,'Phil Hutty','LD',8521);
INSERT INTO `candidates` VALUES (978,163,'Bradley Monk','UKIP',7698);
INSERT INTO `candidates` VALUES (979,163,'Declan Lloyd','Lab',4692);
INSERT INTO `candidates` VALUES (980,163,'Martin Corney','Green',2718);
INSERT INTO `candidates` VALUES (981,163,'Andrew Long','Meb Ker',1003);
INSERT INTO `candidates` VALUES (982,163,'George Trubody','Ind',350);
INSERT INTO `candidates` VALUES (983,164,'Geoffrey Clifton-Brown','Con',32045);
INSERT INTO `candidates` VALUES (984,164,'Paul Hodgkinson','LD',10568);
INSERT INTO `candidates` VALUES (985,164,'Chris Harlow','UKIP',6188);