home / democracyclub

democracyclub

Custom SQL query returning 71 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
12408 4373 Chris Worsey     male   61 party:53 Labour Party MTW:E05001266 Great Barr with Yew Tree     http://www.labour.org.uk/people/detail/chris-worsey       https://static-candidates.democracyclub.org.uk/media/images/5481e832b150e238702c05aa.png   profile-photo     2016-05-05 0 0           PP53   0
12409 5373 Rob Buckman Mr   male 1978-04-21 61 party:63 Green Party MTW:E05001278 Soho and Victoria     https://my.greenparty.org.uk/candidates/106270       https://static-candidates.democracyclub.org.uk/media/images/5517e05f249b917507bee500.png   profile-photo Rob_Buckman I am the candidate 2016-05-05 0 0   18385;34547       PP63   0
12410 5848 Pete Durnell Mr   Male 1963-07-13 61 party:85 UK Independence Party (UKIP) MTW:E05001262 Bristnall     http://www.myukip.com/parliamentary-candidates-t-z.html http://www.petedurnell.com/     https://static-candidates.democracyclub.org.uk/media/images/5534f139b247335574a42e1d.png   profile-photo pete6   2016-05-05 0 0           PP85   0
12411 6386 Mark Redding     Male 1972-06-12 61 party:63 Green Party MTW:E05001262 Bristnall     https://my.greenparty.org.uk/candidates/106270       https://static-candidates.democracyclub.org.uk/media/images/551aa9cee2ac8b7333e6a271.png   profile-photo markredding   2016-05-05 0 0   18971.0       PP63   0
12412 14094 Michael Gary Allen     Male 1968-02-16 61 party:63 Green Party MTW:E05001260 Abbey             https://static-candidates.democracyclub.org.uk/media/images/images/14094.png   profile-photo Mike Allen - GP The photo used here is my official profile image. 2016-05-05 0 0           PP63 Plain Chocolate Digestive 0
12413 14095 Ann Jaron     female   61 party:53 Labour Party MTW:E05001260 Abbey             https://static-candidates.democracyclub.org.uk/media/images/images/14095.png   other mike.astill Sandwell District Council web site 2016-05-05 0 0           PP53   0
12414 14096 Richard Antony Kemp         61 party:52 Conservative and Unionist Party MTW:E05001260 Abbey                       2016-05-05 0 0           PP52   0
12415 14145 Marie Louise Butler         61 party:85 UK Independence Party (UKIP) MTW:E05001279 Tipton Green                       2016-05-05 0 0           PP85   0
12416 14146 Donald Henry Griffiths         61 party:52 Conservative and Unionist Party MTW:E05001279 Tipton Green                       2016-05-05 0 0           PP52   0
12417 14147 Ian Jones         61 party:53 Labour Party MTW:E05001279 Tipton Green                       2016-05-05 0 0           PP53   0
12418 14810 John Anthony Edwards         61 party:53 Labour Party MTW:E05001268 Greets Green and Lyng                       2016-05-05 0 0           PP53   0
12419 14811 Sandra Vickers         61 party:52 Conservative and Unionist Party MTW:E05001268 Greets Green and Lyng                       2016-05-05 0 0           PP52   0
12420 18386 Farut Shaeen         61 party:53 Labour Party MTW:E05001278 Soho and Victoria                       2016-05-05 0 0           PP53   0
12421 18387 Derran Stokes         61 party:52 Conservative and Unionist Party MTW:E05001278 Soho and Victoria                       2016-05-05 0 0           PP52   0
12422 18870 Ray Crawford         61 party:85 UK Independence Party (UKIP) MTW:E05001267 Great Bridge                       2016-05-05 0 0           PP85   0
12423 18871 Ann Jarvis         61 party:53 Labour Party MTW:E05001267 Great Bridge                       2016-05-05 0 0           PP53   0
12424 18872 Steve Simcox         61 party:52 Conservative and Unionist Party MTW:E05001267 Great Bridge                       2016-05-05 0 0           PP52   0
12425 18873 David Dean Fisher         61 party:85 UK Independence Party (UKIP) MTW:E05001266 Great Barr with Yew Tree                       2016-05-05 0 0           PP85   0
12426 18874 Suki Nandra         61 party:52 Conservative and Unionist Party MTW:E05001266 Great Barr with Yew Tree                       2016-05-05 0 0           PP52   0
12427 18968 Kerry Carmichael         61 party:53 Labour Party MTW:E05001261 Blackheath                       2016-05-05 0 0           PP53   0
12428 18969 Shirley Lesley Ching         61 party:52 Conservative and Unionist Party MTW:E05001261 Blackheath                       2016-05-05 0 0           PP52   0
12429 18970 Elaine Mary Giles         61 party:53 Labour Party MTW:E05001262 Bristnall                       2016-05-05 0 0           PP53   0
12430 18972 Richard Toye         61 party:52 Conservative and Unionist Party MTW:E05001262 Bristnall                       2016-05-05 0 0           PP52   0
12431 18973 John Dell Macefield Mr   male 1979.0 61 party:63 Green Party MTW:E05001263 Charlemont with Grove Vale     https://sandwell.greenparty.org.uk/local-elections       https://static-candidates.democracyclub.org.uk/media/images/images/18973.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=283226910 2016-05-05 0 0           PP63   0
12432 18974 Graham Thomas Nock         61 party:85 UK Independence Party (UKIP) MTW:E05001263 Charlemont with Grove Vale                       2016-05-05 0 0           PP85   0
12433 18975 Liam Vincent Preece         61 party:53 Labour Party MTW:E05001263 Charlemont with Grove Vale                       2016-05-05 0 0           PP53   0
12434 18976 Tony Ward         61 party:52 Conservative and Unionist Party MTW:E05001263 Charlemont with Grove Vale                       2016-05-05 0 0           PP52   0
12435 18977 Ben Groom         61 party:63 Green Party MTW:E05001264 Cradley Heath and Old Hill                       2016-05-05 0 0           PP63   0
12436 18978 Robert Owen Johns         61 party:90 Liberal Democrats MTW:E05001264 Cradley Heath and Old Hill                       2016-05-05 0 0           PP90   0
12437 18979 Tilton Tobias Storer         61 party:52 Conservative and Unionist Party MTW:E05001264 Cradley Heath and Old Hill                       2016-05-05 0 0           PP52   0
12438 18980 Caroline Anne White         61 party:53 Labour Party MTW:E05001264 Cradley Heath and Old Hill                       2016-05-05 0 0           PP53   0
12439 18981 Geoff Lewis         61 party:53 Labour Party MTW:E05001265 Friar Park                       2016-05-05 0 0           PP53   0
12440 18982 Bal Singh         61 party:85 UK Independence Party (UKIP) MTW:E05001265 Friar Park                       2016-05-05 0 0           PP85   0
12441 18983 Robert White         61 party:52 Conservative and Unionist Party MTW:E05001265 Friar Park                       2016-05-05 0 0           PP52   0
12442 18984 Jacqueline Nock         61 party:85 UK Independence Party (UKIP) MTW:E05001269 Hateley Heath                       2016-05-05 0 0           PP85   0
12443 18985 Paul Sandars         61 party:53 Labour Party MTW:E05001269 Hateley Heath                       2016-05-05 0 0           PP53   0
12444 18986 John Vickers         61 party:52 Conservative and Unionist Party MTW:E05001269 Hateley Heath                       2016-05-05 0 0           PP52   0
12445 18987 Brian David Crockett         61 party:52 Conservative and Unionist Party MTW:E05001270 Langley                       2016-05-05 0 0           PP52   0
12446 18988 Sharon Pearl Davies         61 party:53 Labour Party MTW:E05001270 Langley                       2016-05-05 0 0           PP53   0
12447 18989 Joyce Underhill         61 party:53 Labour Party MTW:E05001271 Newton                       2016-05-05 0 0           PP53   0
12448 18990 Keith Victor Vaughan         61 party:52 Conservative and Unionist Party MTW:E05001271 Newton                       2016-05-05 0 0           PP52   0
12449 18991 Peter Shaw Banks         61 party:85 UK Independence Party (UKIP) MTW:E05001272 Old Warley                       2016-05-05 0 0           PP85   0
12450 18992 Sue Crumpton         61 party:53 Labour Party MTW:E05001272 Old Warley                       2016-05-05 0 0           PP53   0
12451 18993 Bryan Manley-Green     male   61 party:90 Liberal Democrats MTW:E05001272 Old Warley     http://www.libdems.org.uk/bryan_manley_green       https://static-candidates.democracyclub.org.uk/media/images/images/18993.png   profile-photo fholland http://www.libdems.org.uk/bryan_manley_green# 2016-05-05 0 0           PP90   0
12452 18994 John Duncan McHard         61 party:52 Conservative and Unionist Party MTW:E05001272 Old Warley                       2016-05-05 0 0           PP52   0
12453 18995 Aldo Mussi     male   61 party:63 Green Party MTW:E05001272 Old Warley     https://sandwell.greenparty.org.uk/local-elections       https://static-candidates.democracyclub.org.uk/media/images/images/18995.png   profile-photo john44 On party's site https://sandwell.greenparty.org.uk/local-elections 2016-05-05 0 0           PP63   0
12454 18996 Isa Luqman Darby         61 party:63 Green Party MTW:E05001273 Oldbury                       2016-05-05 0 0           PP63   0
12455 18997 Sue Downing         61 party:53 Labour Party MTW:E05001273 Oldbury                       2016-05-05 0 0           PP53   0
12456 18998 Richard Nicholas Williams         61 party:52 Conservative and Unionist Party MTW:E05001273 Oldbury                       2016-05-05 0 0           PP52   0
12457 18999 Scott Chapman         61 party:52 Conservative and Unionist Party MTW:E05001274 Princes End                       2016-05-05 0 0           PP52   0
12458 19000 Bill Cherrington         61 party:53 Labour Party MTW:E05001274 Princes End                       2016-05-05 0 0           PP53   0
12459 19001 Ric Keeling         61 party:85 UK Independence Party (UKIP) MTW:E05001274 Princes End                       2016-05-05 0 0           PP85   0
12460 19002 Zac Colledge         61 party:52 Conservative and Unionist Party MTW:E05001275 Rowley                       2016-05-05 0 0           PP52   0
12461 19003 Susan Eaves         61 party:53 Labour Party MTW:E05001275 Rowley                       2016-05-05 0 0           PP53   0
12462 19004 Monika Kasnickas         61 party:85 UK Independence Party (UKIP) MTW:E05001275 Rowley                       2016-05-05 0 0           PP85   0
12463 19005 Stephanie Buckman         61 party:63 Green Party MTW:E05001277 Smethwick                       2016-05-05 0 0           PP63   0
12464 19006 Colin Lloyd Clark         61 party:52 Conservative and Unionist Party MTW:E05001277 Smethwick                       2016-05-05 0 0           PP52   0
12465 19007 Linda Rosaleen Horton         61 party:53 Labour Party MTW:E05001277 Smethwick                       2016-05-05 0 0           PP53   0
12466 19008 Elizabeth Brown         61 party:52 Conservative and Unionist Party MTW:E05001276 St Pauls                       2016-05-05 0 0           PP52   0
12467 19009 Preet Gill     female 1972.0 61 party:53 Labour Party MTW:E05001276 St Pauls     https://party.coop/person/preet-gill/ http://www.preetkaurgill.com/ https://en.wikipedia.org/wiki/Preet_Gill   https://static-candidates.democracyclub.org.uk/media/images/images/19009_tc6cO5z.png   profile-photo kdcm87 http://preetkaurgill.com/about/ 2016-05-05 0 0           PP53   0
12468 19010 Ben Bebbington         61 party:63 Green Party MTW:E05001280 Tividale                       2016-05-05 0 0           PP63   0
12469 19011 Maria Crompton         61 party:53 Labour Party MTW:E05001280 Tividale                       2016-05-05 0 0           PP53   0
12470 19012 John Stockall         61 party:52 Conservative and Unionist Party MTW:E05001280 Tividale                       2016-05-05 0 0           PP52   0
12471 19013 Peter Hughes         61 party:53 Labour Party MTW:E05001281 Wednesbury North                       2016-05-05 0 0           PP53   0
12472 19014 Matthew Longville         61 party:52 Conservative and Unionist Party MTW:E05001281 Wednesbury North                       2016-05-05 0 0           PP52   0
12473 19015 Pam Hughes         61 party:53 Labour Party MTW:E05001282 Wednesbury South                       2016-05-05 0 0           PP53   0
12474 19016 Michael David Middleton         61 party:52 Conservative and Unionist Party MTW:E05001282 Wednesbury South                       2016-05-05 0 0           PP52   0
12475 19017 Mohammed Shariff Nadine Umar-Azeemi         61 party:85 UK Independence Party (UKIP) MTW:E05001282 Wednesbury South                       2016-05-05 0 0           PP85   0
12476 19018 Laura Maeve Hickey         61 party:53 Labour Party MTW:E05001283 West Bromwich Central                       2016-05-05 0 0           PP53   0
12477 19019 Anne Charlotte Hughes         61 party:52 Conservative and Unionist Party MTW:E05001283 West Bromwich Central                       2016-05-05 0 0           PP52   0
12478 19020 Neil Ashley Price         61 party:63 Green Party MTW:E05001283 West Bromwich Central                       2016-05-05 0 0           PP63   0
Powered by Datasette · Query took 0.888ms