home / democracyclub

democracyclub

Custom SQL query returning 63 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
11503 279 Adrian Pitfield     male   46 party:85 UK Independence Party (UKIP) UTW:E05009407 Bletchley Park                       2016-05-05 0 0           PP85   0
11504 5223 Jennifer Marklew     female 1985-10-10 46 party:63 Green Party UTW:E05009423 Wolverton     http://mk.greenparty.org.uk/your-candidates/jennifer-marklew.html       https://static-candidates.democracyclub.org.uk/media/images/54e9cf7a65800edc25acc144.png         2016-05-05 0 0   13318.0       PP63   0
11505 5889 Vince Peddle     Male 1959.0 46 party:85 UK Independence Party (UKIP) UTW:E05009408 Bletchley West     http://www.ukipmk.org/bletchley-east.html       https://static-candidates.democracyclub.org.uk/media/images/images/5889.png   profile-photo sjorford http://www.ukipmk.org/bletchley-east.html 2016-05-05 0 0   49044.0       PP85   0
11506 12984 Martin Gowans         46 party:53 Labour Party UTW:E05009406 Bletchley East   1.0                   2016-05-05 0 0           PP53   0
11507 12985 Ronald Haine         46 party:85 UK Independence Party (UKIP) UTW:E05009406 Bletchley East                       2016-05-05 0 0           PP85   0
11508 12986 Masood Jehangir         46 party:90 Liberal Democrats UTW:E05009406 Bletchley East                       2016-05-05 0 0           PP90   0
11509 12987 Angela Susan Kennedy     female   46 party:52 Conservative and Unionist Party UTW:E05009406 Bletchley East     https://www.miltonkeynesconservatives.co.uk/news/candidate-profile-angela-kennedy-bletchley-east       https://static-candidates.democracyclub.org.uk/media/images/images/12987.png   profile-photo fbrc https://twitter.com/MKConservatives/status/1008294504015826944 2016-05-05 0 0           PP52   0
11510 12988 Ian Nuttall         46 party:90 Liberal Democrats UTW:E05009406 Bletchley East                       2016-05-05 0 0           PP90   0
11511 12989 David William Priest         46 party:52 Conservative and Unionist Party UTW:E05009406 Bletchley East                       2016-05-05 0 0           PP52   0
11512 12990 Alan Robert Webb         46 party:53 Labour Party UTW:E05009406 Bletchley East   1.0                   2016-05-05 0 0           PP53   0
11513 12991 Matthew Neil Drewett         46 party:90 Liberal Democrats UTW:E05009407 Bletchley Park                       2016-05-05 0 0           PP90   0
11514 12992 Kevin Joseph Geaney         46 party:52 Conservative and Unionist Party UTW:E05009407 Bletchley Park                       2016-05-05 0 0           PP52   0
11515 12993 Elaine June Wales         46 party:53 Labour Party UTW:E05009407 Bletchley Park   1.0                   2016-05-05 0 0           PP53   0
11516 12994 Gina Bariah         46 party:52 Conservative and Unionist Party UTW:E05009408 Bletchley West                       2016-05-05 0 0           PP52   0
11517 12995 Colin Howarth         46 party:90 Liberal Democrats UTW:E05009408 Bletchley West                       2016-05-05 0 0           PP90   0
11518 12996 Nigel Matthew Long         46 joint-party:53-119 Labour and Co-operative Party UTW:E05009408 Bletchley West   1.0                   2016-05-05 0 0           joint-party:53-119   0
11519 12997 Marie Bradburn         46 party:90 Liberal Democrats UTW:E05009409 Bradwell   1.0                   2016-05-05 0 0           PP90   0
11520 12998 Max Chaudhry         46 party:52 Conservative and Unionist Party UTW:E05009409 Bradwell                       2016-05-05 0 0           PP52   0
11521 12999 David Lloyd Lewis         46 party:53 Labour Party UTW:E05009409 Bradwell                       2016-05-05 0 0           PP53   0
11522 13000 Binta Bah-Pokawa         46 party:53 Labour Party UTW:E05009410 Broughton                       2016-05-05 0 0           PP53   0
11523 13001 John Bint         46 party:52 Conservative and Unionist Party UTW:E05009410 Broughton   1.0                   2016-05-05 0 0           PP52   0
11524 13002 Kerrie Cheri Bradburn         46 party:90 Liberal Democrats UTW:E05009410 Broughton                       2016-05-05 0 0           PP90   0
11525 13007 Terry James Baines         46 party:52 Conservative and Unionist Party UTW:E05009412 Central Milton Keynes                       2016-05-05 0 0           PP52   0
11526 13008 Darron James Kendrick         46 ynmp-party:2 Independent UTW:E05009412 Central Milton Keynes                       2016-05-05 0 0           ynmp-party:2   0
11527 13009 Ian Morrall         46 party:90 Liberal Democrats UTW:E05009412 Central Milton Keynes                       2016-05-05 0 0           PP90   0
11528 13010 Pauline Ann Wallis     female   46 party:53 Labour Party UTW:E05009412 Central Milton Keynes   1.0 http://www.mklabour.org.uk/pauline_wallis_central_milton_keynes       https://static-candidates.democracyclub.org.uk/media/images/images/13010.png   profile-photo paul5 Photo used on campaign website. 2016-05-05 0 0           PP53   0
11529 13011 Tate Andrew Ballard         46 party:53 Labour Party UTW:E05009413 Danesborough & Walton                       2016-05-05 0 0           PP53   0
11530 13012 Richard Michael Greenwood         46 party:90 Liberal Democrats UTW:E05009413 Danesborough & Walton                       2016-05-05 0 0   49043.0       PP90   0
11531 13013 Victoria Susan Hopkins         46 party:52 Conservative and Unionist Party UTW:E05009413 Danesborough & Walton   1.0                   2016-05-05 0 0           PP52   0
11532 13014 Russell Frederick Houchin         46 party:90 Liberal Democrats UTW:E05009414 Loughton & Shenley                       2016-05-05 0 0           PP90   0
11533 13015 John Stewart Howe         46 party:52 Conservative and Unionist Party UTW:E05009414 Loughton & Shenley                       2016-05-05 0 0           PP52   0
11534 13016 Zoe Nolan     female   46 party:53 Labour Party UTW:E05009414 Loughton & Shenley   1.0 http://www.mklabour.org.uk/zoe_nolan_loughton_and_shenley       https://static-candidates.democracyclub.org.uk/media/images/images/13016.png   profile-photo paul5 Used on Facebook campaign site 2016-05-05 0 0           PP53   0
11535 13017 Vikas Chandra         46 party:53 Labour Party UTW:E05009415 Monkston                       2016-05-05 0 0           PP53   0
11536 13018 Vicki McLean         46 party:52 Conservative and Unionist Party UTW:E05009415 Monkston                       2016-05-05 0 0           PP52   0
11537 13019 Vanessa McPake         46 party:90 Liberal Democrats UTW:E05009415 Monkston   1.0                   2016-05-05 0 0           PP90   0
11538 13027 Nigel Birrell         46 party:85 UK Independence Party (UKIP) UTW:E05009417 Newport Pagnell South                       2016-05-05 0 0           PP85   0
11539 13028 William Andrew Davies         46 party:52 Conservative and Unionist Party UTW:E05009417 Newport Pagnell South                       2016-05-05 0 0           PP52   0
11540 13029 Paul William Day         46 party:53 Labour Party UTW:E05009417 Newport Pagnell South                       2016-05-05 0 0           PP53   0
11541 13030 Douglas McCall         46 party:90 Liberal Democrats UTW:E05009417 Newport Pagnell South   1.0                   2016-05-05 0 0           PP90   0
11542 13287 Dee Bethune         46 party:53 Labour Party UTW:E05009418 Olney                       2016-05-05 0 0           PP53   0
11543 13288 Dana Green         46 party:85 UK Independence Party (UKIP) UTW:E05009418 Olney                       2016-05-05 0 0           PP85   0
11544 13289 Donald Keith McLean         46 party:52 Conservative and Unionist Party UTW:E05009418 Olney   1.0                   2016-05-05 0 0           PP52   0
11545 13290 Tony Oyakhire         46 party:90 Liberal Democrats UTW:E05009418 Olney                       2016-05-05 0 0           PP90   0
11546 13291 Catherine Jean Rose         46 party:63 Green Party UTW:E05009418 Olney                       2016-05-05 0 0           PP63   0
11547 13292 Peter Paul Cannon         46 party:90 Liberal Democrats UTW:E05009419 Shenley Brook End   1.0                   2016-05-05 0 0           PP90   0
11548 13293 Rachel May Pallett         46 party:53 Labour Party UTW:E05009419 Shenley Brook End                       2016-05-05 0 0           PP53   0
11549 13294 Jenny Richards         46 party:52 Conservative and Unionist Party UTW:E05009419 Shenley Brook End                       2016-05-05 0 0   42485.0       PP52   0
11550 13295 Geoffrey Winter         46 party:85 UK Independence Party (UKIP) UTW:E05009419 Shenley Brook End                       2016-05-05 0 0           PP85   0
11551 13301 Robert Charles Benning         46 party:90 Liberal Democrats UTW:E05009420 Stantonbury                       2016-05-05 0 0           PP90   0
11552 13302 Alexander Watson Fraser         46 party:63 Green Party UTW:E05009420 Stantonbury                       2016-05-05 0 0           PP63   0
11553 13303 Martin Ronald Petchey     male   46 party:53 Labour Party UTW:E05009420 Stantonbury   1.0 http://www.mklabour.org.uk/martin_petchey_stantonbury       https://static-candidates.democracyclub.org.uk/media/images/images/13303.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
11554 13304 Michael James Somerton         46 party:52 Conservative and Unionist Party UTW:E05009420 Stantonbury                       2016-05-05 0 0           PP52   0
11555 13305 Kathleen Ruth Greenwood         46 party:90 Liberal Democrats UTW:E05009421 Stony Stratford                       2016-05-05 0 0           PP90   0
11556 13306 Simon Felix Hawton         46 party:52 Conservative and Unionist Party UTW:E05009421 Stony Stratford                       2016-05-05 0 0           PP52   0
11557 13307 David Tavener         46 party:85 UK Independence Party (UKIP) UTW:E05009421 Stony Stratford                       2016-05-05 0 0           PP85   0
11558 13308 Charlie Wilson         46 party:53 Labour Party UTW:E05009421 Stony Stratford   1.0                   2016-05-05 0 0           PP53   0
11559 13314 Anthony James Brown         46 party:53 Labour Party UTW:E05009422 Tattenhoe                       2016-05-05 0 0           PP53   0
11560 13315 Jane Carr         46 party:90 Liberal Democrats UTW:E05009422 Tattenhoe                       2016-05-05 0 0           PP90   0
11561 13316 Leslie Ive         46 party:85 UK Independence Party (UKIP) UTW:E05009422 Tattenhoe                       2016-05-05 0 0           PP85   0
11562 13317 Gerald Small         46 party:52 Conservative and Unionist Party UTW:E05009422 Tattenhoe   1.0                   2016-05-05 0 0           PP52   0
11563 13319 Norman Leslie Miles         46 joint-party:53-119 Labour and Co-operative Party UTW:E05009423 Wolverton   1.0                   2016-05-05 0 0           joint-party:53-119   0
11564 13320 Shouket Mirza         46 party:52 Conservative and Unionist Party UTW:E05009423 Wolverton                       2016-05-05 0 0           PP52   0
11565 13321 Chris Thompson         46 party:90 Liberal Democrats UTW:E05009423 Wolverton                       2016-05-05 0 0           PP90   0
Powered by Datasette · Query took 0.805ms