home / democracyclub

democracyclub

Custom SQL query returning 74 rows

Query parameters

This data as JSON, CSV

rowididnamehonorific_prefixhonorific_suffixgenderbirth_dateelectionparty_idparty_namepost_idpost_labelmapit_urlelectedparty_ppc_page_urlhomepage_urlwikipedia_urllinkedin_urlimage_urlproxy_image_url_templateimage_copyrightimage_uploading_userimage_uploading_user_noteselection_dateelection_currentparty_lists_in_useparty_list_positionold_person_idsgss_codeparlparse_idtheyworkforyou_urlparty_ec_idfavourite_biscuitscancelled_poll
13176 1163 Sebastian Kindersley     male   73 party:90 Liberal Democrats DIW:E05002802 Gamlingay   1.0 http://sclibdems.org.uk/en/ http://sebastiankindersley.mycouncillor.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/553ca134dcfe1d5b5cf81470.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/seb4southcambs 2016-05-05 0 0   4768;12022       PP90   0
13177 1634 Simon Saggers Mr   male 1968-12-14 73 party:63 Green Party DIW:E05002794 Bassingbourn     https://my.greenparty.org.uk/candidates/106188 https://southcambs.greenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/55350ee4b247335574a42e73.png   profile-photo mdbigg Taken from the Green Party website: https://my.greenparty.org.uk/candidates/106188 2016-05-05 0 0   12009;34647       PP63   0
13178 7609 Gareth Mark Wright Mr   Male 1968-11-05 73 party:53 Labour Party DIW:E05002822 Waterbeach     http://www.beachlabour.co.uk/index.html http://www.secambslabour.org.uk/vote_gareth_wright               2016-05-05 0 0   19877;35616       PP53   0
13179 7614 Sophi Berridge Ms   Female   73 party:63 Green Party DIW:E05002820 The Shelfords and Stapleford       https://southcambs.greenparty.org.uk/               2016-05-05 0 0           PP63   0
13180 10940 Nigel Cathcart Mr   Male   73 party:53 Labour Party DIW:E05002794 Bassingbourn       http://www.southcambslabour.org.uk/               2016-05-05 0 0           PP53   0
13181 12008 Joshua Charles Huntingfield Lord   Male   73 party:52 Conservative and Unionist Party DIW:E05002794 Bassingbourn       http://www.southcambridgeshireconservatives.org.uk/               2016-05-05 0 0           PP52   0
13182 12010 Gavin Clayton Mr   Male   73 party:53 Labour Party DIW:E05002795 Bourn       http://www.southcambslabour.org.uk/               2016-05-05 0 0           PP53   0
13183 12011 Helene Yvette Green Mrs       73 party:85 UK Independence Party (UKIP) DIW:E05002795 Bourn                       2016-05-05 0 0   23062.0       PP85   0
13184 12012 Mervyn Benjamin Loynes     Male   73 party:52 Conservative and Unionist Party DIW:E05002795 Bourn   1.0   http://www.southcambridgeshireconservatives.org.uk/               2016-05-05 0 0           PP52   0
13185 12013 Marcus Pitcaithly     Male   73 party:63 Green Party DIW:E05002795 Bourn     https://southcambs.greenparty.org.uk/contacts.html     https://uk.linkedin.com/pub/marcus-pitcaithly/28/678/24           2016-05-05 0 0           PP63   0
13186 12014 Jeni Sawford Mrs   Female 1972-04-11 73 party:90 Liberal Democrats DIW:E05002795 Bourn             https://static-candidates.democracyclub.org.uk/media/images/images/12014.png   profile-photo JeniMSawford The photographer gave it to me to use as I wished. 2016-05-05 0 0           PP90   0
13187 12016 Simon Mark Edwards     Male   73 party:52 Conservative and Unionist Party DIW:E05002798 Cottenham   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/12016.png   profile-photo SimonEdwards It's a great likeness of me! 2016-05-05 0 0           PP52   0
13188 12017 Richard William Gymer     Male   73 party:90 Liberal Democrats DIW:E05002798 Cottenham       http://www.oe.phy.cam.ac.uk/people/oeassist/rwg11.htm               2016-05-05 0 0           PP90   0
13189 12018 Joyce Margaret Matheson     Female   73 party:53 Labour Party DIW:E05002798 Cottenham       http://www.southcambslabour.org.uk/               2016-05-05 0 0           PP53   0
13190 12019 John James Wilson         73 party:85 UK Independence Party (UKIP) DIW:E05002798 Cottenham                       2016-05-05 0 0           PP85   0
13191 12020 Alison Paula Elcox         73 party:52 Conservative and Unionist Party DIW:E05002802 Gamlingay                       2016-05-05 0 0           PP52   0
13192 12021 John Goodall         73 party:53 Labour Party DIW:E05002802 Gamlingay                       2016-05-05 0 0           PP53   0
13193 12023 Douglas Raymond De Lacey         73 ynmp-party:2 Independent DIW:E05002803 Girton   1.0                   2016-05-05 0 0           ynmp-party:2   0
13194 12024 Mark McCormack         73 party:53 Labour Party DIW:E05002803 Girton                       2016-05-05 0 0           PP53   0
13195 12025 Teal Riley         73 party:63 Green Party DIW:E05002803 Girton       https://southcambs.greenparty.org.uk/               2016-05-05 0 0           PP63   0
13196 12026 Alastair John Simpson         73 party:52 Conservative and Unionist Party DIW:E05002803 Girton                       2016-05-05 0 0           PP52   0
13197 12027 Paul Evans         73 party:63 Green Party DIW:E05002805 Harston and Hauxton                       2016-05-05 0 0           PP63   0
13198 12028 Janet Elizabeth Lockwood         73 party:90 Liberal Democrats DIW:E05002805 Harston and Hauxton   1.0                   2016-05-05 0 0           PP90   0
13199 12029 Bruce Phillips         73 party:53 Labour Party DIW:E05002805 Harston and Hauxton                       2016-05-05 0 0           PP53   0
13200 12030 Gina Kay Youens         73 party:52 Conservative and Unionist Party DIW:E05002805 Harston and Hauxton                       2016-05-05 0 0           PP52   0
13201 12031 Doug Cattermole         73 party:90 Liberal Democrats DIW:E05002806 Haslingfield and The Eversdens   1.0                   2016-05-05 0 0           PP90   0
13202 12032 Norman Crowther         73 party:53 Labour Party DIW:E05002806 Haslingfield and The Eversdens                       2016-05-05 0 0           PP53   0
13203 12033 Lina Maria Joseph         73 party:52 Conservative and Unionist Party DIW:E05002806 Haslingfield and The Eversdens                       2016-05-05 0 0           PP52   0
13204 12034 Matthew Thomas Bradney         73 party:52 Conservative and Unionist Party DIW:E05002807 Histon and Impington                       2016-05-05 0 0           PP52   0
13205 12035 Darren Paul Cotterell     Male 1966-11-26 73 party:63 Green Party DIW:E05002807 Histon and Impington     https://southcambs.greenparty.org.uk/people.html       https://static-candidates.democracyclub.org.uk/media/images/images/12035_eZ1fF5c.png   other darren4 Its mine 2016-05-05 0 0   24852.0       PP63 Bourbons 0
13206 12036 Neil Sinnett Davies         73 ynmp-party:2 Independent DIW:E05002807 Histon and Impington   1.0                   2016-05-05 0 0           ynmp-party:2   0
13207 12037 Yemi Macaulay         73 party:90 Liberal Democrats DIW:E05002807 Histon and Impington                       2016-05-05 0 0           PP90   0
13208 12038 Njoki Mahiaini     Female   73 party:53 Labour Party DIW:E05002807 Histon and Impington       http://www.secambslabour.org.uk/northernfringe     https://static-candidates.democracyclub.org.uk/media/images/images/12038.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
13209 12039 Enid Bald         73 party:52 Conservative and Unionist Party DIW:E05002808 Linton                       2016-05-05 0 0           PP52   0
13210 12040 John Dennis Batchelor         73 party:90 Liberal Democrats DIW:E05002808 Linton                       2016-05-05 0 0           PP90   0
13211 12041 Rosanna Evans         73 party:53 Labour Party DIW:E05002808 Linton                       2016-05-05 0 0           PP53   0
13212 12042 Paul Richardson         73 party:63 Green Party DIW:E05002808 Linton                       2016-05-05 0 0   28110.0       PP63   0
13213 12044 Simon Down         73 party:53 Labour Party DIW:E05002809 Longstanton                       2016-05-05 0 0           PP53   0
13214 12045 Callum Hatch         73 party:85 UK Independence Party (UKIP) DIW:E05002809 Longstanton                       2016-05-05 0 0           PP85   0
13215 12046 Alex Riley         73 party:52 Conservative and Unionist Party DIW:E05002809 Longstanton                       2016-05-05 0 0           PP52   0
13216 12047 Kirk Allen Taylor         73 party:90 Liberal Democrats DIW:E05002809 Longstanton                       2016-05-05 0 0           PP90   0
13217 12048 Val Barrett         73 party:52 Conservative and Unionist Party DIW:E05002810 Melbourn   1.0                   2016-05-05 0 0           PP52   0
13218 12049 Angela Patrick         73 party:53 Labour Party DIW:E05002810 Melbourn                       2016-05-05 0 0           PP53   0
13219 12051 Clare Delderfield         73 party:90 Liberal Democrats DIW:E05002814 Papworth and Elsworth                       2016-05-05 0 0           PP90   0
13220 12052 Mark Philip Howell         73 party:52 Conservative and Unionist Party DIW:E05002814 Papworth and Elsworth   1.0                   2016-05-05 0 0           PP52   0
13221 12053 Darren Macey         73 party:53 Labour Party DIW:E05002814 Papworth and Elsworth                       2016-05-05 0 0           PP53   0
13222 12054 Kevin Cuffley         73 party:52 Conservative and Unionist Party DIW:E05002815 Sawston                       2016-05-05 0 0           PP52   0
13223 12055 Rob Grayston Mr   Male   73 party:53 Labour Party DIW:E05002815 Sawston             https://static-candidates.democracyclub.org.uk/media/images/images/12055.png   copyright-assigned LabourChap   2016-05-05 0 0           PP53 Custard cream 0
13224 12056 Brian Milnes     Male 1956-12-13 73 party:90 Liberal Democrats DIW:E05002815 Sawston     http://www.sclibdems.org.uk/sawston http://sawston.biz   https://www.linkedin.com/in/brianmilnes/ https://static-candidates.democracyclub.org.uk/media/images/images/19986.png   copyright-assigned Brian_M It is my own photo 2016-05-05 0 0   19986.0       PP90   0
13225 12057 Helen Stocks         73 party:63 Green Party DIW:E05002815 Sawston                       2016-05-05 0 0           PP63   0
13226 12058 Cicely Anne Elsa Demain Murfitt         73 ynmp-party:2 Independent DIW:E05002819 The Mordens                       2016-05-05 0 0           ynmp-party:2   0
13227 12059 Robin Stern         73 party:53 Labour Party DIW:E05002819 The Mordens                       2016-05-05 0 0           PP53   0
13228 12060 Heather Rose Williams         73 party:52 Conservative and Unionist Party DIW:E05002819 The Mordens                       2016-05-05 0 0           PP52   0
13229 12061 Peter Robert Fane     Male   73 party:90 Liberal Democrats DIW:E05002820 The Shelfords and Stapleford                       2016-05-05 0 0   28094.0       PP90   0
13230 12062 Mike Nettleton     Male   73 party:53 Labour Party DIW:E05002820 The Shelfords and Stapleford       http://www.southcambslabour.org.uk/               2016-05-05 0 0           PP53   0
13231 12063 Charlie Nightingale         73 party:52 Conservative and Unionist Party DIW:E05002820 The Shelfords and Stapleford   1.0                   2016-05-05 0 0           PP52   0
13232 12064 June Ford         73 party:53 Labour Party DIW:E05002821 The Wilbrahams                       2016-05-05 0 0           PP53   0
13233 12065 Anthony John Holland         73 party:90 Liberal Democrats DIW:E05002821 The Wilbrahams                       2016-05-05 0 0           PP90   0
13234 12066 Rob Turner         73 party:52 Conservative and Unionist Party DIW:E05002821 The Wilbrahams   1.0                   2016-05-05 0 0           PP52   0
13235 12067 Myra Gaunt         73 ynmp-party:2 Independent DIW:E05002822 Waterbeach                       2016-05-05 0 0           ynmp-party:2   0
13236 12068 Mary Lachlan-Cope         73 party:63 Green Party DIW:E05002822 Waterbeach                       2016-05-05 0 0           PP63   0
13237 12069 Alan Kenneth Shipp         73 party:52 Conservative and Unionist Party DIW:E05002822 Waterbeach                       2016-05-05 0 0           PP52   0
13238 12070 Ingrid Jane Tregoing         73 party:90 Liberal Democrats DIW:E05002822 Waterbeach   1.0                   2016-05-05 0 0           PP90   0
13239 12071 Philippa MacGarry         73 party:53 Labour Party DIW:E05002823 Whittlesford                       2016-05-05 0 0           PP53   0
13240 12072 Peter John McDonald         73 party:90 Liberal Democrats DIW:E05002823 Whittlesford                       2016-05-05 0 0           PP90   0
13241 12073 Peter William Wilson Topping         73 party:52 Conservative and Unionist Party DIW:E05002823 Whittlesford   1.0                   2016-05-05 0 0           PP52   0
13242 12074 Eleanor Ruth Crane     female   73 party:63 Green Party DIW:E05002824 Willingham and Over                       2016-05-05 0 0   28087.0       PP63   0
13243 12075 Sue Gymer         73 party:90 Liberal Democrats DIW:E05002824 Willingham and Over                       2016-05-05 0 0           PP90   0
13244 12076 Martin John Hale         73 party:85 UK Independence Party (UKIP) DIW:E05002824 Willingham and Over                       2016-05-05 0 0           PP85   0
13245 12077 Ray Maurice Antony Manning         73 party:52 Conservative and Unionist Party DIW:E05002824 Willingham and Over                       2016-05-05 0 0           PP52   0
13246 12078 Ben Monks         73 party:53 Labour Party DIW:E05002824 Willingham and Over                       2016-05-05 0 0           PP53   0
13247 23073 Colin Cyril Coe     Male   73 party:63 Green Party DIW:E05002798 Cottenham     https://southcambs.greenparty.org.uk https://southcambs.greenparty.org.uk/contacts.html               2016-05-05 0 0   12015.0       PP63   0
13248 24512 Alex Wasyliw         73 party:90 Liberal Democrats DIW:E05002810 Melbourn                       2016-05-05 0 0   12050.0       PP90   0
13249 28107 Sandra Ann Archer         73 party:63 Green Party DIW:E05002809 Longstanton                       2016-05-05 0 0   12043.0       PP63   0
Powered by Datasette · Query took 0.951ms