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
14414 10134 Saleem Kapadi     Male 1967.0 82 party:52 Conservative and Unionist Party UTW:E05001620 Audley ward             https://static-candidates.democracyclub.org.uk/media/images/images/10134.png   profile-photo alexsdutton   2016-05-05 0 0           PP52   0
14415 10135 Raja Basharat Hussin Khan         82 ynmp-party:2 Independent UTW:E05001620 Audley ward                       2016-05-05 0 0           ynmp-party:2   0
14416 10136 Zamir Khan         82 party:53 Labour Party UTW:E05001620 Audley ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/10136.png   other alexsdutton From http://blackburn.cmis.uk.com/blackburn/Councillors/tabid/63/ctl/ViewCMIS_Person/mid/383/id/51/Default.aspx?dnn_ctr383_ViewCMIS_Person_grdRadCommitteesPastChangePage=3_5 - a council member listing 2016-05-05 0 0           PP53   0
14417 10137 Sabir Esa     Male 1961.0 82 party:52 Conservative and Unionist Party UTW:E05001621 Bastwell ward           https://www.linkedin.com/in/sabir-esa-74a44327 https://static-candidates.democracyclub.org.uk/media/images/images/10137.png   profile-photo alexsdutton On campaign page; cropped from http://blackburnconservatives.co.uk/wp-content/uploads/2016/02/Sabir-Esa.jpg 2016-05-05 0 0           PP52   0
14418 10138 Shaukat Hussain     Male   82 party:53 Labour Party UTW:E05001621 Bastwell ward   1.0 http://blackburnlabour.org/whereyoulive/bastwell/     https://www.linkedin.com/in/shaukat-hussain-60740695 https://static-candidates.democracyclub.org.uk/media/images/images/10138.png   profile-photo alexsdutton Twitter profile pic: https://twitter.com/cllrshaukat 2016-05-05 0 0           PP53   0
14419 10139 Julie Margaret Daley         82 party:52 Conservative and Unionist Party UTW:E05001622 Beardwood with Lammack ward   1.0                   2016-05-05 0 0           PP52   0
14420 10140 Paul Mason         82 party:53 Labour Party UTW:E05001622 Beardwood with Lammack ward                       2016-05-05 0 0           PP53   0
14421 11251 Tassy Fazal         82 party:53 Labour Party UTW:E05001623 Corporation Park ward   1.0                   2016-05-05 0 0           PP53   0
14422 11252 Riaz Valli         82 party:52 Conservative and Unionist Party UTW:E05001623 Corporation Park ward                       2016-05-05 0 0           PP52   0
14423 11253 Stephanie Rose Brookfield         82 party:53 Labour Party UTW:E05001624 Earcroft ward   1.0                   2016-05-05 0 0           PP53   0
14424 11254 John East         82 party:90 Liberal Democrats UTW:E05001624 Earcroft ward                       2016-05-05 0 0           PP90   0
14425 11255 Lynn Perkins         82 party:52 Conservative and Unionist Party UTW:E05001624 Earcroft ward                       2016-05-05 0 0           PP52   0
14426 11256 Jamie Groves         82 party:53 Labour Party UTW:E05001626 Ewood ward   1.0                   2016-05-05 0 0           PP53   0
14427 11257 Eleanor Sutcliffe         82 party:52 Conservative and Unionist Party UTW:E05001626 Ewood ward                       2016-05-05 0 0           PP52   0
14428 11258 John Slater         82 party:52 Conservative and Unionist Party UTW:E05001627 Fernhurst ward   1.0                   2016-05-05 0 0           PP52   0
14429 11259 Donna Marie Talbot         82 party:53 Labour Party UTW:E05001627 Fernhurst ward                       2016-05-05 0 0           PP53   0
14430 11260 Michael Aaron Brooks         82 party:52 Conservative and Unionist Party UTW:E05001628 Higher Croft                       2016-05-05 0 0           PP52   0
14431 11261 Don McKinlay         82 party:53 Labour Party UTW:E05001628 Higher Croft   1.0                   2016-05-05 0 0           PP53   0
14432 11262 Liz Lawson         82 party:85 UK Independence Party (UKIP) UTW:E05001629 Little Harwood ward                       2016-05-05 0 0           PP85   0
14433 11263 Abdul Samad Patel         82 party:53 Labour Party UTW:E05001629 Little Harwood ward   1.0                   2016-05-05 0 0           PP53   0
14434 11264 Ghulam Sabir         82 party:52 Conservative and Unionist Party UTW:E05001629 Little Harwood ward                       2016-05-05 0 0           PP52   0
14435 11265 Adam Holden         82 party:53 Labour Party UTW:E05001630 Livesey with Pleasington ward                       2016-05-05 0 0           PP53   0
14436 11266 Paul Marrow         82 party:52 Conservative and Unionist Party UTW:E05001630 Livesey with Pleasington ward   1.0                   2016-05-05 0 0   42368.0       PP52   0
14437 11267 Madeline Allen-Holmes         82 party:85 UK Independence Party (UKIP) UTW:E05001631 Marsh House                       2016-05-05 0 0           PP85   0
14438 11268 Frank Connor         82 party:53 Labour Party UTW:E05001631 Marsh House                       2016-05-05 0 0           PP53   0
14439 11269 Simon Huggill         82 party:90 Liberal Democrats UTW:E05001631 Marsh House                       2016-05-05 0 0           PP90   0
14440 11270 Neil Slater         82 party:52 Conservative and Unionist Party UTW:E05001631 Marsh House   1.0                   2016-05-05 0 0           PP52   0
14441 11271 Keith Murray         82 party:52 Conservative and Unionist Party UTW:E05001632 Meadowhead ward   1.0                   2016-05-05 0 0           PP52   0
14442 11272 Ashley Richard Whalley         82 party:53 Labour Party UTW:E05001632 Meadowhead ward                       2016-05-05 0 0           PP53   0
14443 11277 Michael Longbottom         82 party:85 UK Independence Party (UKIP) UTW:E05001633 Mill Hill ward                       2016-05-05 0 0           PP85   0
14444 11278 Carl Peter Nuttall         82 party:53 Labour Party UTW:E05001633 Mill Hill ward   1.0                   2016-05-05 0 0           PP53   0
14445 11279 Ann Marie Tolley     female   82 party:52 Conservative and Unionist Party UTW:E05001633 Mill Hill ward                       2016-05-05 0 0           PP52   0
14446 11280 Phil McDermott         82 ynmp-party:2 Independent UTW:E05001634 North Turton with Tockholes ward                       2016-05-05 0 0           ynmp-party:2   0
14447 11281 Colin Rigby         82 party:52 Conservative and Unionist Party UTW:E05001634 North Turton with Tockholes ward   1.0                   2016-05-05 0 0           PP52   0
14448 11282 Diane Cathrine Waddington         82 party:53 Labour Party UTW:E05001634 North Turton with Tockholes ward                       2016-05-05 0 0           PP53   0
14449 11283 Faryad Hussain         82 party:53 Labour Party UTW:E05001635 Queen's Park ward   1.0                   2016-05-05 0 0           PP53   0
14450 11284 Imraan Valimulla         82 party:52 Conservative and Unionist Party UTW:E05001635 Queen's Park ward                       2016-05-05 0 0           PP52   0
14451 11285 Sylvia Liddle         82 party:53 Labour Party UTW:E05001636 Roe Lee ward   1.0                   2016-05-05 0 0           PP53   0
14452 11286 Maureen McGarvey         82 party:52 Conservative and Unionist Party UTW:E05001636 Roe Lee ward                       2016-05-05 0 0           PP52   0
14453 11287 Michael Andrew Madigan         82 party:85 UK Independence Party (UKIP) UTW:E05001637 Shadsworth with Whitebirk ward                       2016-05-05 0 0           PP85   0
14454 11288 Vicky McGurk Mrs   Female 1981-03-24 82 party:53 Labour Party UTW:E05001637 Shadsworth with Whitebirk ward   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/11288.png   public-domain vickyandgeorge It’s my photo 2016-05-05 0 0           PP53 Digestive 0
14455 11289 Margaret Rawlinson         82 party:52 Conservative and Unionist Party UTW:E05001637 Shadsworth with Whitebirk ward                       2016-05-05 0 0           PP52   0
14456 11292 Irfan Mohmed Balapatel         82 party:52 Conservative and Unionist Party UTW:E05001638 Shear Brow ward                       2016-05-05 0 0           PP52   0
14457 11293 Suleman Khonat         82 party:53 Labour Party UTW:E05001638 Shear Brow ward   1.0                   2016-05-05 0 0           PP53   0
14458 11295 Jean Brindle         82 party:52 Conservative and Unionist Party UTW:E05001639 Sudell ward                       2016-05-05 0 0           PP52   0
14459 11296 Roy Davies         82 party:90 Liberal Democrats UTW:E05001639 Sudell ward   1.0                   2016-05-05 0 0   42920.0       PP90   0
14460 11297 Kate Stirton         82 party:53 Labour Party UTW:E05001639 Sudell ward                       2016-05-05 0 0           PP53   0
14461 11298 Travis Frain         82 party:52 Conservative and Unionist Party UTW:E05001640 Sunnyhurst ward                       2016-05-05 0 0           PP52   0
14462 11299 Ian Grimshaw     male   82 party:85 UK Independence Party (UKIP) UTW:E05001640 Sunnyhurst ward                       2016-05-05 0 0           PP85   0
14463 11300 Peter Andrew Hollings         82 party:53 Labour Party UTW:E05001640 Sunnyhurst ward   1.0                   2016-05-05 0 0           PP53   0
14464 11301 Ros Myers         82 party:90 Liberal Democrats UTW:E05001640 Sunnyhurst ward                       2016-05-05 0 0           PP90   0
14465 11302 Dave Harling         82 party:53 Labour Party UTW:E05001641 Wensley Fold ward   1.0                   2016-05-05 0 0           PP53   0
14466 11303 Tariq Mahmood         82 party:52 Conservative and Unionist Party UTW:E05001641 Wensley Fold ward                       2016-05-05 0 0           PP52   0
14467 11304 Joanne Sarah Birkner         82 party:53 Labour Party UTW:E05001642 Whitehall ward                       2016-05-05 0 0           PP53   0
14468 11305 Steve Duncan         82 party:52 Conservative and Unionist Party UTW:E05001642 Whitehall ward                       2016-05-05 0 0           PP52   0
14469 11306 Karimeh Foster         82 party:90 Liberal Democrats UTW:E05001642 Whitehall ward   1.0                   2016-05-05 0 0           PP90   0
14470 11307 Austin Molloy         82 party:85 UK Independence Party (UKIP) UTW:E05001642 Whitehall ward                       2016-05-05 0 0           PP85   0
Powered by Datasette · Query took 0.756ms