home / democracyclub

democracyclub

Custom SQL query returning 57 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
12333 6776 Richard Shattock Mr   male 1991-08-14 58 party:804 Trade Unionist and Socialist Coalition DIW:E05009432 Leavesden     http://tusc2015.com/richard-shattock-for-welwyn-hatfield/       https://static-candidates.democracyclub.org.uk/media/images/55292289b6a860ed1648be53.png   profile-photo richardshattock4welwynhatfield https://m.facebook.com/richard4welwynhatfieldmp?ref=bookmark 2016-05-05 0 0           PP804   0
12334 18905 Matthew Bedford         58 party:90 Liberal Democrats DIW:E05009425 Abbots Langley & Bedmond                       2016-05-05 0 0           PP90   0
12335 18906 Lee Martin Farrell         58 party:85 UK Independence Party (UKIP) DIW:E05009425 Abbots Langley & Bedmond                       2016-05-05 0 0           PP85   0
12336 18907 Leigh Fleming         58 party:52 Conservative and Unionist Party DIW:E05009425 Abbots Langley & Bedmond                       2016-05-05 0 0           PP52   0
12337 18908 Ian Holmes         58 party:53 Labour Party DIW:E05009425 Abbots Langley & Bedmond                       2016-05-05 0 0           PP53   0
12338 18909 David Edward Anthony Coltman         58 party:52 Conservative and Unionist Party DIW:E05009426 Carpenders Park                       2016-05-05 0 0           PP52   0
12339 18910 Valerie Evelyn Coltman         58 party:52 Conservative and Unionist Party DIW:E05009426 Carpenders Park                       2016-05-05 0 0           PP52   0
12340 18911 Paul Gordon         58 party:53 Labour Party DIW:E05009426 Carpenders Park                       2016-05-05 0 0           PP53   0
12341 18912 Christopher Green         58 party:53 Labour Party DIW:E05009426 Carpenders Park                       2016-05-05 0 0           PP53   0
12342 18913 Pam Hames Cllr       58 party:90 Liberal Democrats DIW:E05009426 Carpenders Park                       2016-05-05 0 0           PP90   0
12343 18914 Lee Osborne         58 party:85 UK Independence Party (UKIP) DIW:E05009426 Carpenders Park                       2016-05-05 0 0           PP85   0
12344 18915 Dennis Rogers         58 party:90 Liberal Democrats DIW:E05009426 Carpenders Park                       2016-05-05 0 0           PP90   0
12345 19021 Ashok Bhardwaj         58 party:90 Liberal Democrats DIW:E05009427 Chorleywood North & Sarratt                       2016-05-05 0 0           PP90   0
12346 19022 Marilyn Butler         58 party:52 Conservative and Unionist Party DIW:E05009427 Chorleywood North & Sarratt                       2016-05-05 0 0           PP52   0
12347 19023 Maureen Sedlacek         58 party:53 Labour Party DIW:E05009427 Chorleywood North & Sarratt                       2016-05-05 0 0           PP53   0
12348 19024 Andrew Wells         58 party:85 UK Independence Party (UKIP) DIW:E05009427 Chorleywood North & Sarratt                       2016-05-05 0 0           PP85   0
12349 19025 Barbara Dickens         58 party:52 Conservative and Unionist Party DIW:E05009428 Chorleywood South & Maple Cross                       2016-05-05 0 0           PP52   0
12350 19026 Fiona Goble         58 party:53 Labour Party DIW:E05009428 Chorleywood South & Maple Cross                       2016-05-05 0 0           PP53   0
12351 19027 Anne Lewis         58 party:85 UK Independence Party (UKIP) DIW:E05009428 Chorleywood South & Maple Cross                       2016-05-05 0 0           PP85   0
12352 19028 Ann Shaw Cllr OBE     58 party:90 Liberal Democrats DIW:E05009428 Chorleywood South & Maple Cross                       2016-05-05 0 0           PP90   0
12353 19029 Peter William Getkahn         58 party:90 Liberal Democrats DIW:E05009429 Dickinsons                       2016-05-05 0 0           PP90   0
12354 19030 Jussie Kaur Cllr   female   58 party:52 Conservative and Unionist Party DIW:E05009429 Dickinsons             https://static-candidates.democracyclub.org.uk/media/images/images/19030.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
12355 19031 David Wynne-Jones         58 party:53 Labour Party DIW:E05009429 Dickinsons                       2016-05-05 0 0           PP53   0
12356 19032 Sarah Linhart Cllr     1971.0 58 party:53 Labour Party DIW:E05009430 Durrants                       2016-05-05 0 0           PP53   0
12357 19033 Chris Lloyd         58 party:90 Liberal Democrats DIW:E05009430 Durrants                       2016-05-05 0 0           PP90   0
12358 19034 Brian Sainsbury         58 party:52 Conservative and Unionist Party DIW:E05009430 Durrants                       2016-05-05 0 0           PP52   0
12359 19035 Joy Mann         58 party:90 Liberal Democrats DIW:E05009431 Gade Valley                       2016-05-05 0 0           PP90   0
12360 19036 Bruce Prochnik         58 party:53 Labour Party DIW:E05009431 Gade Valley                       2016-05-05 0 0           PP53   0
12361 19037 Dee Ward         58 party:52 Conservative and Unionist Party DIW:E05009431 Gade Valley                       2016-05-05 0 0           PP52   0
12362 19039 Joanne Victoria Cox         58 party:53 Labour Party DIW:E05009432 Leavesden                       2016-05-05 0 0           PP53   0
12363 19041 Hitesh Tailor         58 party:52 Conservative and Unionist Party DIW:E05009432 Leavesden                       2016-05-05 0 0           PP52   0
12364 19042 Jeremy Edmund Campion Asquith Dr   male   58 party:90 Liberal Democrats DIW:E05009433 Moor Park & Eastbury     https://westhertslibdems.org.uk/en/article/2018/1264111/three-rivers-district-council-elections-may-3rd-2018-lib-dem-candidate-for-the-moor-park-and-eastbury-ward                 2016-05-05 0 0           PP90   0
12365 19043 Cameron Finch         58 party:85 UK Independence Party (UKIP) DIW:E05009433 Moor Park & Eastbury                       2016-05-05 0 0           PP85   0
12366 19044 Pamela King         58 party:53 Labour Party DIW:E05009433 Moor Park & Eastbury                       2016-05-05 0 0           PP53   0
12367 19045 Debbie Morris         58 party:52 Conservative and Unionist Party DIW:E05009433 Moor Park & Eastbury                       2016-05-05 0 0           PP52   0
12368 19046 John Kyles         58 party:52 Conservative and Unionist Party DIW:E05009434 Oxhey Hall & Hayling                       2016-05-05 0 0           PP52   0
12369 19048 Andrew Scarth         58 party:90 Liberal Democrats DIW:E05009434 Oxhey Hall & Hayling                       2016-05-05 0 0           PP90   0
12370 19049 James Stacey         58 party:85 UK Independence Party (UKIP) DIW:E05009434 Oxhey Hall & Hayling                       2016-05-05 0 0           PP85   0
12371 19050 Sarah Green         58 party:85 UK Independence Party (UKIP) DIW:E05009435 Penn & Mill End                       2016-05-05 0 0           PP85   0
12372 19051 James McEwan         58 party:53 Labour Party DIW:E05009435 Penn & Mill End                       2016-05-05 0 0           PP53   0
12373 19052 David Raw         58 party:52 Conservative and Unionist Party DIW:E05009435 Penn & Mill End                       2016-05-05 0 0           PP52   0
12374 19053 Roger Seabourne Cllr       58 party:90 Liberal Democrats DIW:E05009435 Penn & Mill End                       2016-05-05 0 0           PP90   0
12375 19054 Graham Dale         58 party:53 Labour Party DIW:E05009436 Rickmansworth Town                       2016-05-05 0 0           PP53   0
12376 19055 Pat Howell         58 party:90 Liberal Democrats DIW:E05009436 Rickmansworth Town                       2016-05-05 0 0           PP90   0
12377 19056 Francis Johnson         58 party:85 UK Independence Party (UKIP) DIW:E05009436 Rickmansworth Town                       2016-05-05 0 0           PP85   0
12378 19057 David Sansom         58 party:52 Conservative and Unionist Party DIW:E05009436 Rickmansworth Town                       2016-05-05 0 0           PP52   0
12379 19058 Yessica Gould Cllr       58 party:85 UK Independence Party (UKIP) DIW:E05009437 South Oxhey                       2016-05-05 0 0           PP85   0
12380 19059 Joan King Cllr       58 party:53 Labour Party DIW:E05009437 South Oxhey                       2016-05-05 0 0           PP53   0
12381 19060 Stephen Michael James King         58 party:53 Labour Party DIW:E05009437 South Oxhey                       2016-05-05 0 0           PP53   0
12382 19061 Shanti Maru         58 party:52 Conservative and Unionist Party DIW:E05009437 South Oxhey                       2016-05-05 0 0           PP52   0
12383 19062 Michael Ernest Matthewson     male   58 party:85 UK Independence Party (UKIP) DIW:E05009437 South Oxhey                       2016-05-05 0 0           PP85   0
12384 19063 Jill Marguerite Swainson         58 party:90 Liberal Democrats DIW:E05009437 South Oxhey                       2016-05-05 0 0           PP90   0
12385 19064 Ben Trevett         58 party:90 Liberal Democrats DIW:E05009437 South Oxhey                       2016-05-05 0 0           PP90   0
12386 19065 Elizabeth Willetts         58 party:52 Conservative and Unionist Party DIW:E05009437 South Oxhey                       2016-05-05 0 0           PP52   0
12387 19404 Brendan O'Brien         58 party:53 Labour Party DIW:E05009434 Oxhey Hall & Hayling                       2016-05-05 0 0           PP53   0
12388 26304 Stephen Bernard Albert Frederick Henry Giles-Medhurst Cllr       58 party:90 Liberal Democrats DIW:E05009432 Leavesden     https://hertslibdems.org.uk/en/contact/stephen-giles-medhurst                 2016-05-05 0 0   19040.0       PP90   0
12389 48205 David Bennett     male   58 party:85 UK Independence Party (UKIP) DIW:E05009432 Leavesden                       2016-05-05 0 0   19038.0       PP85   0
Powered by Datasette · Query took 0.771ms