home / democracyclub

democracyclub

Custom SQL query returning 101 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
10220 779 Tom Baldwin     male 1983-06-21 37 party:804 Trade Unionist and Socialist Coalition UTW:E05010918 Windmill Hill ward             https://static-candidates.democracyclub.org.uk/media/images/55042aef1b7be75c206f17d6.png         2016-05-05 0 0   7713.0       PP804   0
10221 1155 Mark Wright Dr   male   37 party:90 Liberal Democrats UTW:E05010905 Hotwells and Harbourside ward   1.0 http://www.libdems.org.uk/mark_wright http://www.bristolsouth-libdems.org.uk/ https://en.wikipedia.org/wiki/Mark_Wright_%28politician%29 http://uk.linkedin.com/pub/mark-wright/34/149/398/en https://static-candidates.democracyclub.org.uk/media/images/5481e8dbb150e238702c0609.png   profile-photo     2016-05-05 0 0   7892.0       PP90   0
10222 3984 Paul Hinton Smith     male   37 party:53 Labour Party UTW:E05010892 Central ward   1.0   https://bristolwestpaul.wordpress.com/     https://static-candidates.democracyclub.org.uk/media/images/images/3984.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   9770.0       PP53   0
10223 5018 Clare Campion-Smith     Female   37 party:90 Liberal Democrats UTW:E05010917 Westbury-on-Trym & Henleaze   1.0 http://www.libdems.org.uk/clare_campion_smith     http://uk.linkedin.com/pub/clare-campion-smith/54/508/63/en https://static-candidates.democracyclub.org.uk/media/images/images/5018.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
10224 5507 Ann-Marie Mason     female   37 party:52 Conservative and Unionist Party UTW:E05010902 Hengrove and Whitchurch Park ward     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Mason_Ann-Marie.aspx http://pontypriddconservatives.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/55491180928393ab513ec901.png   other andylolz From local party website: http://pontypriddconservatives.co.uk/ 2016-05-05 0 0   10479;33732       PP52   0
10225 5702 Lorraine Francis     female   37 party:63 Green Party UTW:E05010912 St George West ward     http://www.swgreen.org.uk/swviewcon.php?n=92&a=bristoleast       https://static-candidates.democracyclub.org.uk/media/images/553b5033a621e036281d573d.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/bristoleastgrn 2016-05-05 0 0   34445.0       PP63   0
10226 5830 Dawn Parry     female   37 ynmp-party:2 Independent UTW:E05010894 Clifton Down ward       http://www.dawnparry.com/   http://uk.linkedin.com/pub/dawn-parry/25/8a2/340/en https://static-candidates.democracyclub.org.uk/media/images/54e20605438d6af41666ea82.png         2016-05-05 0 0   1370.0       ynmp-party:2   0
10227 6683 Michael Frost   PPC Male   37 party:85 UK Independence Party (UKIP) UTW:E05010886 Avonmouth and Lawrence Weston ward       http://bristolukip.org/     https://static-candidates.democracyclub.org.uk/media/images/550bf23136b6dcb123cb433b.png   profile-photo adrian2 It is from the Bristol UKIP website http://www.bristolukip.org/your-future-ukip-members-of-parliament/ 2016-05-05 0 0           PP85   0
10228 6857 Paul Anthony Turner     Male   37 party:85 UK Independence Party (UKIP) UTW:E05010902 Hengrove and Whitchurch Park ward             https://static-candidates.democracyclub.org.uk/media/images/5526409759bbc5c063445b5a.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-a-b.html 2016-05-05 0 0   10485.0       PP85   0
10229 7479 Mark Weston     male   37 party:52 Conservative and Unionist Party UTW:E05010901 Henbury and Brentry ward   1.0   http://markweston.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/7479.png   profile-photo tfgg From his campaign Facebook https://www.facebook.com/717530348380086/photos/a.719062241560230.1073741825.717530348380086/719062261560228/?type=3&theater 2016-05-05 0 0   10471.0       PP52   0
10230 7480 Kerry Barker     Male   37 party:53 Labour Party UTW:E05010901 Henbury and Brentry ward     http://www.laboursouthwest.org.uk/our_police_and_crime_commissioner_candidates http://www.kerrybarker.org/     https://static-candidates.democracyclub.org.uk/media/images/images/7480.png   profile-photo subutcher http://www.laboursouthwest.org.uk/our_police_and_crime_commissioner_candidates 2016-05-05 0 0           PP53   0
10231 7874 Timothy James Leaman Mr   Male   37 party:90 Liberal Democrats UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           PP90   0
10232 7876 Wendie Michelle Smith         37 party:90 Liberal Democrats UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           PP90   0
10233 7878 Darren Moore     Male 1973.0 37 party:90 Liberal Democrats UTW:E05010886 Avonmouth and Lawrence Weston ward       http://www.yourlibdems.co.uk               2016-05-05 0 0           PP90   0
10234 7880 Kate Alexandra Bowman         37 party:90 Liberal Democrats UTW:E05010888 Bishopston and Ashley Down ward                       2016-05-05 0 0           PP90   0
10235 7881 Rebecca Anne Lockyer         37 party:90 Liberal Democrats UTW:E05010888 Bishopston and Ashley Down ward                       2016-05-05 0 0           PP90   0
10236 7882 Tom Stubbs         37 party:90 Liberal Democrats UTW:E05010894 Clifton Down ward             https://static-candidates.democracyclub.org.uk/media/images/images/7882.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
10237 7883 Joshua Warwick-Smith         37 party:90 Liberal Democrats UTW:E05010894 Clifton Down ward                       2016-05-05 0 0           PP90   0
10238 7884 Ian James Townsend Mr   Male   37 party:90 Liberal Democrats UTW:E05010912 St George West ward             https://static-candidates.democracyclub.org.uk/media/images/images/7884.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
10239 7887 Andrew Charles Brown Mr   MAle 1974-11-18 37 party:90 Liberal Democrats UTW:E05010918 Windmill Hill ward             https://static-candidates.democracyclub.org.uk/media/images/images/7887.png   copyright-assigned oneexwidow   2016-05-05 0 0           PP90   0
10240 7893 Gary Hopkins Mr       37 party:90 Liberal Democrats UTW:E05010906 Knowle ward   1.0   http://www.knowlelibdems.com/               2016-05-05 0 0           PP90   0
10241 7894 Christopher Davies Mr       37 party:90 Liberal Democrats UTW:E05010906 Knowle ward   1.0   http://www.knowlelibdems.com/               2016-05-05 0 0           PP90   0
10242 9714 Donald Philip Alexander         37 party:53 Labour Party UTW:E05010886 Avonmouth and Lawrence Weston ward   1.0                   2016-05-05 0 0           PP53   0
10243 9715 Don Brown         37 party:63 Green Party UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           PP63   0
10244 9716 Geoff Collard         37 party:63 Green Party UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           PP63   0
10245 9717 Laurence Duncan         37 ynmp-party:2 Independent UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           ynmp-party:2   0
10246 9718 Claire Francesca Frost         37 party:85 UK Independence Party (UKIP) UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           PP85   0
10247 9719 John Stephen Geater         37 ynmp-party:2 Independent UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           ynmp-party:2   0
10248 9720 Darien Luke Jay         37 party:52 Conservative and Unionist Party UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           PP52   0
10249 9721 Mo McManus         37 party:63 Green Party UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           PP63   0
10250 9722 Matt Melias         37 party:52 Conservative and Unionist Party UTW:E05010886 Avonmouth and Lawrence Weston ward   1.0                   2016-05-05 0 0           PP52   0
10251 9728 Henry Michallat         37 party:52 Conservative and Unionist Party UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           PP52   0
10252 9729 Stephen Kenneth James Norman         37 ynmp-party:2 Independent UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           ynmp-party:2   0
10253 9730 Jo Sergeant         37 party:53 Labour Party UTW:E05010886 Avonmouth and Lawrence Weston ward   1.0                   2016-05-05 0 0           PP53   0
10254 9731 Jerry Williams         37 party:53 Labour Party UTW:E05010886 Avonmouth and Lawrence Weston ward                       2016-05-05 0 0           PP53   0
10255 9759 Tom Brook         37 party:53 Labour Party UTW:E05010888 Bishopston and Ashley Down ward   1.0                   2016-05-05 0 0           PP53   0
10256 9760 Eleanor Jane Combley     Female 1971-09-28 37 party:63 Green Party UTW:E05010888 Bishopston and Ashley Down ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/9760.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63   0
10257 9761 David Thomas Harrison Lewis     male   37 party:52 Conservative and Unionist Party UTW:E05010888 Bishopston and Ashley Down ward                       2016-05-05 0 0           PP52   0
10258 9762 David John McLeod     male   37 party:53 Labour Party UTW:E05010888 Bishopston and Ashley Down ward                       2016-05-05 0 0           PP53   0
10259 9763 Daniella Elsa Radice         37 party:63 Green Party UTW:E05010888 Bishopston and Ashley Down ward                       2016-05-05 0 0           PP63   0
10260 9764 Pat Wyatt         37 party:52 Conservative and Unionist Party UTW:E05010888 Bishopston and Ashley Down ward                       2016-05-05 0 0           PP52   0
10261 9765 Pauline Mary Allen         37 party:90 Liberal Democrats UTW:E05010892 Central ward                       2016-05-05 0 0           PP90   0
10262 9766 Suzi Best         37 party:52 Conservative and Unionist Party UTW:E05010892 Central ward                       2016-05-05 0 0           PP52   0
10263 9767 Sylvia Kathleen Doubell         37 party:90 Liberal Democrats UTW:E05010892 Central ward                       2016-05-05 0 0           PP90   0
10264 9768 Kye Daniel Dudd         37 party:53 Labour Party UTW:E05010892 Central ward   1.0                   2016-05-05 0 0           PP53   0
10265 9769 Ann Margaret Pulteney         37 party:52 Conservative and Unionist Party UTW:E05010892 Central ward                       2016-05-05 0 0           PP52   0
10266 9771 Ani Stafford-Townsend         37 party:63 Green Party UTW:E05010892 Central ward                       2016-05-05 0 0           PP63   0
10267 9772 Rob Telford         37 party:63 Green Party UTW:E05010892 Central ward                       2016-05-05 0 0           PP63   0
10268 9773 Sarah Helen Cleave         37 party:52 Conservative and Unionist Party UTW:E05010894 Clifton Down ward                       2016-05-05 0 0           PP52   0
10269 9774 Carla Suzanne Denyer         37 party:63 Green Party UTW:E05010894 Clifton Down ward   1.0                   2016-05-05 0 0           PP63   0
10270 9775 Philip John Jardine         37 party:53 Labour Party UTW:E05010894 Clifton Down ward                       2016-05-05 0 0           PP53   0
10271 9776 Satnam Singh         37 party:53 Labour Party UTW:E05010894 Clifton Down ward                       2016-05-05 0 0           PP53   0
10272 9777 Steve Smith         37 party:52 Conservative and Unionist Party UTW:E05010894 Clifton Down ward                       2016-05-05 0 0           PP52   0
10273 9778 Clive Stevens         37 party:63 Green Party UTW:E05010894 Clifton Down ward   1.0                   2016-05-05 0 0           PP63   0
10274 9779 Lesley Ann Alexander         37 party:52 Conservative and Unionist Party UTW:E05010899 Frome Vale ward   1.0                   2016-05-05 0 0           PP52   0
10275 9780 Nicola Jane Bowden-Jones         37 party:53 Labour Party UTW:E05010899 Frome Vale ward   1.0                   2016-05-05 0 0           PP53   0
10276 9781 Benjamin Goldstrom         37 party:90 Liberal Democrats UTW:E05010899 Frome Vale ward                       2016-05-05 0 0           PP90   0
10277 9782 John Patrick Hassell         37 party:90 Liberal Democrats UTW:E05010899 Frome Vale ward                       2016-05-05 0 0           PP90   0
10278 9783 James Charles Hinchcliffe         37 party:52 Conservative and Unionist Party UTW:E05010899 Frome Vale ward                       2016-05-05 0 0           PP52   0
10279 9784 Paul Masri         37 party:63 Green Party UTW:E05010899 Frome Vale ward                       2016-05-05 0 0           PP63   0
10280 9785 Bill Payne         37 party:53 Labour Party UTW:E05010899 Frome Vale ward                       2016-05-05 0 0           PP53   0
10281 9786 Cath Thomas         37 party:63 Green Party UTW:E05010899 Frome Vale ward                       2016-05-05 0 0           PP63   0
10282 10433 Nadeem Ashraf         37 party:52 Conservative and Unionist Party UTW:E05010900 Hartcliffe and Withywood ward                       2016-05-05 0 0           PP52   0
10283 10434 Mark Royston Brain         37 party:53 Labour Party UTW:E05010900 Hartcliffe and Withywood ward   1.0                   2016-05-05 0 0           PP53   0
10284 10435 Robert John Coxon         37 party:85 UK Independence Party (UKIP) UTW:E05010900 Hartcliffe and Withywood ward                       2016-05-05 0 0           PP85   0
10285 10436 Paul Elvin         37 party:90 Liberal Democrats UTW:E05010900 Hartcliffe and Withywood ward                       2016-05-05 0 0           PP90   0
10286 10437 Paul Goggin         37 party:53 Labour Party UTW:E05010900 Hartcliffe and Withywood ward   1.0                   2016-05-05 0 0           PP53   0
10287 10438 Michael Alan Goulden         37 party:90 Liberal Democrats UTW:E05010900 Hartcliffe and Withywood ward                       2016-05-05 0 0           PP90   0
10288 10439 Samuel Frederick Michael Head         37 party:90 Liberal Democrats UTW:E05010900 Hartcliffe and Withywood ward                       2016-05-05 0 0           PP90   0
10289 10440 Helen Holland         37 party:53 Labour Party UTW:E05010900 Hartcliffe and Withywood ward   1.0                   2016-05-05 0 0           PP53   0
10290 10441 Jonathan Robert Hucker         37 party:52 Conservative and Unionist Party UTW:E05010900 Hartcliffe and Withywood ward                       2016-05-05 0 0           PP52   0
10291 10442 Andrew John Lawrence         37 party:63 Green Party UTW:E05010900 Hartcliffe and Withywood ward                       2016-05-05 0 0           PP63   0
10292 10443 Robert Anthony Nash     male   37 party:804 Trade Unionist and Socialist Coalition UTW:E05010900 Hartcliffe and Withywood ward                       2016-05-05 0 0           PP804   0
10293 10444 Jonathan David Russell Price     male   37 party:52 Conservative and Unionist Party UTW:E05010900 Hartcliffe and Withywood ward                       2016-05-05 0 0           PP52   0
10294 10453 Ian Humfrey Campion-Smith         37 party:90 Liberal Democrats UTW:E05010904 Horfield ward                       2016-05-05 0 0           PP90   0
10295 10454 Nigel John Currie     male   37 party:52 Conservative and Unionist Party UTW:E05010904 Horfield ward                       2016-05-05 0 0           PP52   0
10296 10456 Olly Mead         37 party:53 Labour Party UTW:E05010904 Horfield ward   1.0                   2016-05-05 0 0           PP53   0
10297 10457 Ian Edward Moss         37 party:63 Green Party UTW:E05010904 Horfield ward             https://static-candidates.democracyclub.org.uk/media/images/images/10457.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=989164904266559488 2016-05-05 0 0           PP63   0
10298 10458 Teresa Stratford         37 party:53 Labour Party UTW:E05010904 Horfield ward                       2016-05-05 0 0           PP53   0
10299 10459 Christopher John Waller         37 party:63 Green Party UTW:E05010904 Horfield ward                       2016-05-05 0 0           PP63   0
10300 10460 Luke Walton         37 party:90 Liberal Democrats UTW:E05010904 Horfield ward                       2016-05-05 0 0           PP90   0
10301 10466 Sterling Dresman         37 party:90 Liberal Democrats UTW:E05010901 Henbury and Brentry ward                       2016-05-05 0 0           PP90   0
10302 10467 Christian Adam Martin         37 party:90 Liberal Democrats UTW:E05010901 Henbury and Brentry ward                       2016-05-05 0 0           PP90   0
10303 10468 Lela Helen McTernan         37 party:63 Green Party UTW:E05010901 Henbury and Brentry ward                       2016-05-05 0 0           PP63   0
10304 10469 Robert James Alexander Triggs         37 party:63 Green Party UTW:E05010901 Henbury and Brentry ward                       2016-05-05 0 0           PP63   0
10305 10470 Kathleen Rosalie Walker         37 party:53 Labour Party UTW:E05010901 Henbury and Brentry ward                       2016-05-05 0 0           PP53   0
10306 10472 Chris Windows         37 party:52 Conservative and Unionist Party UTW:E05010901 Henbury and Brentry ward   1.0                   2016-05-05 0 0           PP52   0
10307 10473 Barry David Clark         37 party:53 Labour Party UTW:E05010902 Hengrove and Whitchurch Park ward   1.0                   2016-05-05 0 0           PP53   0
10308 10474 Harriet Eva Clough         37 party:90 Liberal Democrats UTW:E05010902 Hengrove and Whitchurch Park ward   1.0                   2016-05-05 0 0           PP90   0
10309 10475 Nigel Joseph Emery         37 party:90 Liberal Democrats UTW:E05010902 Hengrove and Whitchurch Park ward                       2016-05-05 0 0           PP90   0
10310 10476 Daniel Matthew Fear         37 party:85 UK Independence Party (UKIP) UTW:E05010902 Hengrove and Whitchurch Park ward                       2016-05-05 0 0           PP85   0
10311 10477 Esther Lucia Keller         37 party:53 Labour Party UTW:E05010902 Hengrove and Whitchurch Park ward                       2016-05-05 0 0           PP53   0
10312 10478 Tim Kent         37 party:90 Liberal Democrats UTW:E05010902 Hengrove and Whitchurch Park ward   1.0                   2016-05-05 0 0           PP90   0
10313 10480 June Pamela Mitchell         37 party:85 UK Independence Party (UKIP) UTW:E05010902 Hengrove and Whitchurch Park ward                       2016-05-05 0 0           PP85   0
10314 10481 Sam Perrin         37 party:52 Conservative and Unionist Party UTW:E05010902 Hengrove and Whitchurch Park ward                       2016-05-05 0 0           PP52   0
10315 10482 Hadleigh Vaughan Roberts         37 party:53 Labour Party UTW:E05010902 Hengrove and Whitchurch Park ward                       2016-05-05 0 0           PP53   0
10316 10483 Antony Skelding         37 party:52 Conservative and Unionist Party UTW:E05010902 Hengrove and Whitchurch Park ward                       2016-05-05 0 0           PP52   0
10317 10484 Barney Smith         37 party:63 Green Party UTW:E05010902 Hengrove and Whitchurch Park ward                       2016-05-05 0 0           PP63   0
10318 10486 Pearl Christine Lavinia Abraham         37 party:52 Conservative and Unionist Party UTW:E05010903 Hillfields ward                       2016-05-05 0 0           PP52   0
10319 10487 Craig Cheney         37 party:53 Labour Party UTW:E05010903 Hillfields ward                       2016-05-05 0 0           PP53   0
10320 10488 Phil Hanby         37 ynmp-party:2 Independent UTW:E05010903 Hillfields ward                       2016-05-05 0 0           ynmp-party:2   0
Powered by Datasette · Query took 1.153ms