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
9400 1884 Bill Wakeham     male   23 party:85 UK Independence Party (UKIP) UTW:E05002095 Southway                       2016-05-05 0 0           PP85   0
9401 3461 Wendy Miller     female 1957.0 23 party:63 Green Party UTW:E05002087 Peverell                       2016-05-05 0 0   14228.0       PP63   0
9402 5349 Louise Parker     female   23 party:804 Trade Unionist and Socialist Coalition UTW:E05002097 Sutton and Mount Gould     http://tusc2015.com/louise-parker-for-plymouth-moor-view/       https://static-candidates.democracyclub.org.uk/media/images/55479596a57e7ec942ad8e29.png   profile-photo andylolz From party PPC page: http://tusc2015.com/louise-parker-for-plymouth-moor-view/ 2016-05-05 0 0           PP804   0
9403 8862 Fleur Olivia Stoner Ball         23 party:90 Liberal Democrats UTW:E05002080 Devonport                       2016-05-05 0 0           PP90   0
9404 14225 Peter Geoffrey Brooksbank         23 party:3940 Plymouth Independents UTW:E05002087 Peverell                       2016-05-05 0 0           PP3940   0
9405 14226 Tony Carson         23 party:52 Conservative and Unionist Party UTW:E05002087 Peverell                       2016-05-05 0 0           PP52   0
9406 14227 Jeremy Goslin         23 party:53 Labour Party UTW:E05002087 Peverell                       2016-05-05 0 0           PP53   0
9407 14229 Justin Pollard         23 joint-party:804-2045 Left Unity - Trade Unionists and Socialists UTW:E05002087 Peverell                       2016-05-05 0 0           joint-party:804-2045   0
9408 14230 Charlotte Jane Radmore         23 party:90 Liberal Democrats UTW:E05002087 Peverell                       2016-05-05 0 0           PP90   0
9409 14614 Richard Bray         23 party:90 Liberal Democrats UTW:E05002086 Moor View                       2016-05-05 0 0           PP90   0
9410 14615 Chris Mavin         23 party:53 Labour Party UTW:E05002086 Moor View                       2016-05-05 0 0           PP53   0
9411 14616 Philip Partridge         23 party:85 UK Independence Party (UKIP) UTW:E05002086 Moor View                       2016-05-05 0 0           PP85   0
9412 14617 Bethan Roberts         23 party:52 Conservative and Unionist Party UTW:E05002086 Moor View                       2016-05-05 0 0           PP52   0
9413 14618 Arthur Nicoll Watson         23 party:3940 Plymouth Independents UTW:E05002086 Moor View                       2016-05-05 0 0           PP3940   0
9414 16707 Richard Ball         23 party:52 Conservative and Unionist Party UTW:E05002079 Compton                       2016-05-05 0 0           PP52   0
9415 16708 Nigel Buckley         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002079 Compton                       2016-05-05 0 0           PP804   0
9416 16709 Steven Guy         23 party:90 Liberal Democrats UTW:E05002079 Compton                       2016-05-05 0 0           PP90   0
9417 16710 John Petrie         23 party:53 Labour Party UTW:E05002079 Compton                       2016-05-05 0 0           PP53   0
9418 16711 Grace Stickland         23 party:3940 Plymouth Independents UTW:E05002079 Compton                       2016-05-05 0 0           PP3940   0
9419 16712 Colin Trier         23 party:63 Green Party UTW:E05002079 Compton                       2016-05-05 0 0           PP63   0
9420 17575 Charlotte Bladen         23 party:52 Conservative and Unionist Party UTW:E05002078 Budshead                       2016-05-05 0 0           PP52   0
9421 17576 Gordon Charles Miller         23 party:85 UK Independence Party (UKIP) UTW:E05002078 Budshead                       2016-05-05 0 0           PP85   0
9422 17577 Roger James Mitchell         23 party:90 Liberal Democrats UTW:E05002078 Budshead                       2016-05-05 0 0           PP90   0
9423 17578 Joshua George Pope     male 1997-12-08 23 party:63 Green Party UTW:E05002078 Budshead       https://www.joshuapope.org/     https://static-candidates.democracyclub.org.uk/media/images/images/17578.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63 Pink Wafers 0
9424 17579 Jon Taylor     male   23 joint-party:53-119 Labour and Co-operative Party UTW:E05002078 Budshead             https://static-candidates.democracyclub.org.uk/media/images/images/17579.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=816238800569507842 2016-05-05 0 0           joint-party:53-119   0
9425 17580 Andrew White         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002078 Budshead                       2016-05-05 0 0           PP804   0
9426 17581 Sandy Borthwick         23 party:52 Conservative and Unionist Party UTW:E05002080 Devonport                       2016-05-05 0 0           PP52   0
9427 17582 Michael Ellison         23 party:85 UK Independence Party (UKIP) UTW:E05002080 Devonport                       2016-05-05 0 0           PP85   0
9428 17583 Simon Gomery         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002080 Devonport                       2016-05-05 0 0           PP804   0
9429 17584 Andrew Robert Pratt         23 party:63 Green Party UTW:E05002080 Devonport                       2016-05-05 0 0           PP63   0
9430 17585 Kate Taylor         23 party:53 Labour Party UTW:E05002080 Devonport                       2016-05-05 0 0           PP53   0
9431 17586 Scott Aiden Wardle         23 party:3940 Plymouth Independents UTW:E05002080 Devonport                       2016-05-05 0 0           PP3940   0
9432 17587 George Davis         23 party:52 Conservative and Unionist Party UTW:E05002082 Efford and Lipson                       2016-05-05 0 0           PP52   0
9433 17588 Rafiqul Mazed Haque         23 party:90 Liberal Democrats UTW:E05002082 Efford and Lipson                       2016-05-05 0 0           PP90   0
9434 17589 Hannah Marie Lewis         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002082 Efford and Lipson                       2016-05-05 0 0           PP804   0
9435 17590 Terry Luscombe         23 party:3940 Plymouth Independents UTW:E05002082 Efford and Lipson                       2016-05-05 0 0           PP3940   0
9436 17591 Brian Vincent         23 joint-party:53-119 Labour and Co-operative Party UTW:E05002082 Efford and Lipson                       2016-05-05 0 0           joint-party:53-119   0
9437 17592 Heath Cook         23 party:52 Conservative and Unionist Party UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP52   0
9438 17593 Hugh Scott Davies         23 party:85 UK Independence Party (UKIP) UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP85   0
9439 17594 Sam Down         23 party:63 Green Party UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP63   0
9440 17595 Lesley Duncan         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP804   0
9441 17596 Paul Charles McNamara     male   23 joint-party:53-119 Labour and Co-operative Party UTW:E05002083 Eggbuckland                       2016-05-05 0 0           joint-party:53-119   0
9442 17597 Richard John Simpson         23 party:90 Liberal Democrats UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP90   0
9443 17598 Chris Treise         23 party:3940 Plymouth Independents UTW:E05002083 Eggbuckland                       2016-05-05 0 0           PP3940   0
9444 17599 Ryan John Aldred         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002084 Ham                       2016-05-05 0 0           PP804   0
9445 17600 Stuart Bernard Charles         23 party:85 UK Independence Party (UKIP) UTW:E05002084 Ham                       2016-05-05 0 0           PP85   0
9446 17601 Matthew Charles Radmore         23 party:90 Liberal Democrats UTW:E05002084 Ham                       2016-05-05 0 0           PP90   0
9447 17602 Dean Seddon         23 party:52 Conservative and Unionist Party UTW:E05002084 Ham                       2016-05-05 0 0           PP52   0
9448 17603 Jason Shopland Mr   male 1972-05-30 23 party:3940 Plymouth Independents UTW:E05002084 Ham     http://www.forplymouth.co.uk/the-team/ http://www.forplymouth.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/17603.png   copyright-assigned Jannerpolitics It is me 2016-05-05 0 0           PP3940 Digestive 0
9449 17604 Tina Tuohy         23 joint-party:53-119 Labour and Co-operative Party UTW:E05002084 Ham                       2016-05-05 0 0           joint-party:53-119   0
9450 17615 Nikki Bale         23 party:85 UK Independence Party (UKIP) UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP85   0
9451 17616 Carl Evans         23 party:3940 Plymouth Independents UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP3940   0
9452 17617 Joshua Gray         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP804   0
9453 17618 Dylan Harry Morris         23 party:90 Liberal Democrats UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP90   0
9454 17619 Pete Smith         23 party:53 Labour Party UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP53   0
9455 17620 Sally Walker         23 party:52 Conservative and Unionist Party UTW:E05002085 Honicknowle                       2016-05-05 0 0           PP52   0
9456 17628 Jonathan Brian Frost         23 party:85 UK Independence Party (UKIP) UTW:E05002088 Plympton Chaddlewood                       2016-05-05 0 0           PP85   0
9457 17629 Samantha Jane Leaves         23 party:52 Conservative and Unionist Party UTW:E05002088 Plympton Chaddlewood                       2016-05-05 0 0           PP52   0
9458 17630 Connor Smart         23 party:53 Labour Party UTW:E05002088 Plympton Chaddlewood                       2016-05-05 0 0           PP53   0
9459 17631 Teresa Stuart         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002088 Plympton Chaddlewood                       2016-05-05 0 0           PP804   0
9460 17632 Louise Caroline Alldridge         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002089 Plympton Erle                       2016-05-05 0 0           PP804   0
9461 17633 Ian Patrick Darcy         23 party:52 Conservative and Unionist Party UTW:E05002089 Plympton Erle                       2016-05-05 0 0           PP52   0
9462 17634 Peter Endean         23 party:3940 Plymouth Independents UTW:E05002089 Plympton Erle                       2016-05-05 0 0           PP3940   0
9463 17635 Christianne Louise Pollock         23 party:90 Liberal Democrats UTW:E05002089 Plympton Erle                       2016-05-05 0 0           PP90   0
9464 17636 Janet Denise Wise         23 joint-party:53-119 Labour and Co-operative Party UTW:E05002089 Plympton Erle                       2016-05-05 0 0           joint-party:53-119   0
9465 17637 Andrea Victoria Loveridge         23 party:52 Conservative and Unionist Party UTW:E05002090 Plympton St Mary                       2016-05-05 0 0           PP52   0
9466 17638 Tom Nally         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002090 Plympton St Mary                       2016-05-05 0 0           PP804   0
9467 17639 Roger David Williams         23 party:53 Labour Party UTW:E05002090 Plympton St Mary                       2016-05-05 0 0           PP53   0
9468 17647 Roxy Castell         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002091 Plymstock Dunstone                       2016-05-05 0 0           PP804   0
9469 17648 Sima Katie Davarian-Dehsorkhe         23 party:90 Liberal Democrats UTW:E05002091 Plymstock Dunstone                       2016-05-05 0 0           PP90   0
9470 17649 Dena Rafati         23 joint-party:53-119 Labour and Co-operative Party UTW:E05002091 Plymstock Dunstone                       2016-05-05 0 0           joint-party:53-119   0
9471 17650 David Salmon         23 party:85 UK Independence Party (UKIP) UTW:E05002091 Plymstock Dunstone                       2016-05-05 0 0           PP85   0
9472 17651 Kevin Charles Wigens         23 party:52 Conservative and Unionist Party UTW:E05002091 Plymstock Dunstone                       2016-05-05 0 0           PP52   0
9473 17652 Vince Barry     Male 1997.0 23 joint-party:53-119 Labour and Co-operative Party UTW:E05002092 Plymstock Radford     https://vote.labour.org.uk/vince-barry       https://static-candidates.democracyclub.org.uk/media/images/images/17652.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           joint-party:53-119   0
9474 17653 Connor Clarke         23 party:63 Green Party UTW:E05002092 Plymstock Radford     https://plymouth.lib.dm/en/article/2018/1269850/our-local-candidate-for-stoke-by-election-on-26th-july       https://static-candidates.democracyclub.org.uk/media/images/images/17653.png   profile-photo j0e_m https://plymouth.lib.dm/en/article/2018/1269850/our-local-candidate-for-stoke-by-election-on-26th-july 2016-05-05 0 0   49013.0       PP63   0
9475 17654 Jeffrey Hall         23 party:90 Liberal Democrats UTW:E05002092 Plymstock Radford                       2016-05-05 0 0           PP90   0
9476 17655 Michael John Edward Leaves         23 party:52 Conservative and Unionist Party UTW:E05002092 Plymstock Radford                       2016-05-05 0 0           PP52   0
9477 17656 Thomas Michael Sloman         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002092 Plymstock Radford                       2016-05-05 0 0           PP804   0
9478 17657 John Edwin Wheeler         23 party:85 UK Independence Party (UKIP) UTW:E05002092 Plymstock Radford                       2016-05-05 0 0           PP85   0
9479 17668 Stan Beal         23 party:63 Green Party UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP63   0
9480 17669 Dan Bothwick         23 party:52 Conservative and Unionist Party UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP52   0
9481 17670 Adam Lloyd Duffield         23 party:3940 Plymouth Independents UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP3940   0
9482 17671 Stephen David Luscombe         23 party:90 Liberal Democrats UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP90   0
9483 17672 Aaron Bradley Smith         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP804   0
9484 17673 Margaret Louise Storer         23 party:85 UK Independence Party (UKIP) UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP85   0
9485 17674 Darren Mark Winter         23 party:53 Labour Party UTW:E05002093 St Budeaux                       2016-05-05 0 0           PP53   0
9486 17675 Bob Brice         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002094 St Peter and the Waterfront                       2016-05-05 0 0           PP804   0
9487 17676 Jessica Rose Horner     female   23 party:63 Green Party UTW:E05002094 St Peter and the Waterfront             https://static-candidates.democracyclub.org.uk/media/images/images/17676.png   profile-photo DetachedOwl   2016-05-05 0 0           PP63   0
9488 17677 Hugh Janes         23 party:90 Liberal Democrats UTW:E05002094 St Peter and the Waterfront                       2016-05-05 0 0           PP90   0
9489 17679 Karen Elizabeth Thurston         23 party:52 Conservative and Unionist Party UTW:E05002094 St Peter and the Waterfront                       2016-05-05 0 0           PP52   0
9490 17680 Ian Glenn Tuffin         23 joint-party:53-119 Labour and Co-operative Party UTW:E05002094 St Peter and the Waterfront                       2016-05-05 0 0           joint-party:53-119   0
9491 17691 Nik Brookson         23 party:804 Trade Unionist and Socialist Coalition UTW:E05002095 Southway                       2016-05-05 0 0           PP804   0
9492 17692 Storm Norman         23 party:90 Liberal Democrats UTW:E05002095 Southway                       2016-05-05 0 0           PP90   0
9493 17693 Lorraine Parker         23 party:53 Labour Party UTW:E05002095 Southway                       2016-05-05 0 0           PP53   0
9494 17694 Daniel Michael Sheaff     male   23 party:63 Green Party UTW:E05002095 Southway             https://static-candidates.democracyclub.org.uk/media/images/images/17694.png   public-domain ElPopey97   2016-05-05 0 0           PP63   0
9495 17695 Rebecca Jane Smith         23 party:52 Conservative and Unionist Party UTW:E05002095 Southway                       2016-05-05 0 0           PP52   0
9496 17696 Natasha Anne Squires         23 party:3940 Plymouth Independents UTW:E05002095 Southway                       2016-05-05 0 0           PP3940   0
9497 17697 Sam Davey         23 party:53 Labour Party UTW:E05002096 Stoke                       2016-05-05 0 0           PP53   0
9498 17698 Ramon Philip Fereday         23 party:85 UK Independence Party (UKIP) UTW:E05002096 Stoke                       2016-05-05 0 0           PP85   0
9499 17699 Andrew Ford         23 party:52 Conservative and Unionist Party UTW:E05002096 Stoke                       2016-05-05 0 0           PP52   0
9500 17700 Helen Catherine Guy         23 party:90 Liberal Democrats UTW:E05002096 Stoke                       2016-05-05 0 0           PP90   0
Powered by Datasette · Query took 1.087ms