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
11835 2189 Andy Redfern     male 1966-06-25 53 party:63 Green Party MTW:E05001079 Lobley Hill and Bensham     https://my.greenparty.org.uk/candidates/105963 http://www.gatesheadgreenparty.org.uk/blog/people/   https://www.linkedin.com/in/andyredfern https://static-candidates.democracyclub.org.uk/media/images/551ad80562426fe9b6b1512e.jpg         2016-05-05 0 0           PP63   0
11836 2231 Elaine Brunskill     female   53 party:804 Trade Unionist and Socialist Coalition MTW:E05001077 High Fell                       2016-05-05 0 0           PP804   0
11837 5443 Paul McNally     male   53 party:63 Green Party MTW:E05001088 Winlaton and High Spen     https://my.greenparty.org.uk/candidates/105828 http://www.gatesheadgreenparty.org.uk/blog/elections/paul-mcnally-blaydon/     https://static-candidates.democracyclub.org.uk/media/images/552384d0944e4aac612ace59.png   profile-photo markied Green Party website 2016-05-05 0 0   16460.0       PP63   0
11838 6177 Norman Hall     male 1955-08-23 53 party:804 Trade Unionist and Socialist Coalition MTW:E05001073 Deckham     http://tusc2015.com/norman-hall-for-jarrow/       https://static-candidates.democracyclub.org.uk/media/images/55477b3100f8947142645fd9.png   profile-photo andylolz From party PPC page: http://tusc2015.com/norman-hall-for-jarrow/ 2016-05-05 0 0           PP804   0
11839 6452 Peter Maughan     male   53 party:90 Liberal Democrats MTW:E05001075 Dunston Hill and Whickham East                       2016-05-05 0 0   13830.0       PP90   0
11840 6670 Mark Bell     male 1964.0 53 party:85 UK Independence Party (UKIP) MTW:E05001073 Deckham                       2016-05-05 0 0   16374.0       PP85   0
11841 8861 Kathy King     female   53 party:54 The Liberal Party MTW:E05001067 Birtley                       2016-05-05 0 0           PP54   0
11842 13827 Mary Blanchflower         53 party:63 Green Party MTW:E05001075 Dunston Hill and Whickham East                       2016-05-05 0 0           PP63   0
11843 13828 Adrian David Cantle-Jones         53 party:53 Labour Party MTW:E05001075 Dunston Hill and Whickham East                       2016-05-05 0 0           PP53   0
11844 13829 Jak Hocking         53 party:52 Conservative and Unionist Party MTW:E05001075 Dunston Hill and Whickham East                       2016-05-05 0 0           PP52   0
11845 13831 Andrea Wright         53 party:85 UK Independence Party (UKIP) MTW:E05001075 Dunston Hill and Whickham East                       2016-05-05 0 0           PP85   0
11846 16324 Tony Dodds         53 party:63 Green Party MTW:E05001067 Birtley                       2016-05-05 0 0           PP63   0
11847 16325 Paul Thomas Elliott         53 party:90 Liberal Democrats MTW:E05001067 Birtley                       2016-05-05 0 0           PP90   0
11848 16326 Chris Hook         53 party:85 UK Independence Party (UKIP) MTW:E05001067 Birtley                       2016-05-05 0 0           PP85   0
11849 16327 Catherine Mary Simcox         53 party:53 Labour Party MTW:E05001067 Birtley   1.0                   2016-05-05 0 0           PP53   0
11850 16328 Jeanne Waton         53 party:52 Conservative and Unionist Party MTW:E05001067 Birtley                       2016-05-05 0 0           PP52   0
11851 16329 Edward Ainscow         53 party:52 Conservative and Unionist Party MTW:E05001068 Blaydon                       2016-05-05 0 0           PP52   0
11852 16330 Simon David Murray Easton     male   53 party:63 Green Party MTW:E05001068 Blaydon                       2016-05-05 0 0           PP63   0
11853 16331 Glynis Leggatt         53 party:85 UK Independence Party (UKIP) MTW:E05001068 Blaydon                       2016-05-05 0 0           PP85   0
11854 16332 Stuart John McClurey         53 party:90 Liberal Democrats MTW:E05001068 Blaydon                       2016-05-05 0 0           PP90   0
11855 16333 Stephen Christopher Ronchetti         53 party:53 Labour Party MTW:E05001068 Blaydon   1.0                   2016-05-05 0 0           PP53   0
11856 16343 John Eagle         53 party:53 Labour Party MTW:E05001069 Bridges   1.0                   2016-05-05 0 0           PP53   0
11857 16344 John Gardiner         53 party:52 Conservative and Unionist Party MTW:E05001069 Bridges                       2016-05-05 0 0           PP52   0
11858 16345 David Lumsden         53 party:90 Liberal Democrats MTW:E05001069 Bridges                       2016-05-05 0 0           PP90   0
11859 16346 Rachel Eileen Shaw         53 party:63 Green Party MTW:E05001069 Bridges                       2016-05-05 0 0           PP63   0
11860 16350 Dave Castleton         53 party:63 Green Party MTW:E05009313 Chopwell and Rowlands Gill                       2016-05-05 0 0           PP63   0
11861 16351 John Walter Hamilton         53 party:53 Labour Party MTW:E05009313 Chopwell and Rowlands Gill   1.0                   2016-05-05 0 0           PP53   0
11862 16352 John Barry Lathan         53 party:52 Conservative and Unionist Party MTW:E05009313 Chopwell and Rowlands Gill                       2016-05-05 0 0           PP52   0
11863 16353 Elaine O'Neil         53 party:85 UK Independence Party (UKIP) MTW:E05009313 Chopwell and Rowlands Gill                       2016-05-05 0 0           PP85   0
11864 16354 Amelia Louise Ord         53 party:90 Liberal Democrats MTW:E05009313 Chopwell and Rowlands Gill                       2016-05-05 0 0           PP90   0
11865 16358 Laura Elizabeth Cunningham         53 party:90 Liberal Democrats MTW:E05001071 Chowdene                       2016-05-05 0 0           PP90   0
11866 16359 John McElroy         53 party:53 Labour Party MTW:E05001071 Chowdene   1.0                   2016-05-05 0 0           PP53   0
11867 16360 Marika Smith         53 party:804 Trade Unionist and Socialist Coalition MTW:E05001071 Chowdene                       2016-05-05 0 0           PP804   0
11868 16361 Nick Sundin         53 party:85 UK Independence Party (UKIP) MTW:E05001071 Chowdene                       2016-05-05 0 0           PP85   0
11869 16362 Alexander Taylor         53 party:63 Green Party MTW:E05001071 Chowdene                       2016-05-05 0 0           PP63   0
11870 16363 Eric Young         53 party:52 Conservative and Unionist Party MTW:E05001071 Chowdene                       2016-05-05 0 0           PP52   0
11871 16364 Leonard Davidson         53 party:52 Conservative and Unionist Party MTW:E05001072 Crawcrook and Greenside                       2016-05-05 0 0           PP52   0
11872 16365 David Henry Fereday         53 party:85 UK Independence Party (UKIP) MTW:E05001072 Crawcrook and Greenside                       2016-05-05 0 0           PP85   0
11873 16366 Kathleen McCartney         53 party:53 Labour Party MTW:E05001072 Crawcrook and Greenside                       2016-05-05 0 0           PP53   0
11874 16367 Sandra McClurey         53 party:90 Liberal Democrats MTW:E05001072 Crawcrook and Greenside                       2016-05-05 0 0           PP90   0
11875 16368 Ralf Russow         53 party:63 Green Party MTW:E05001072 Crawcrook and Greenside                       2016-05-05 0 0           PP63   0
11876 16373 May Ainscow         53 party:52 Conservative and Unionist Party MTW:E05001073 Deckham                       2016-05-05 0 0           PP52   0
11877 16375 Gary Brooks         53 party:63 Green Party MTW:E05001073 Deckham                       2016-05-05 0 0           PP63   0
11878 16376 Callum Hodgson         53 party:90 Liberal Democrats MTW:E05001073 Deckham                       2016-05-05 0 0           PP90   0
11879 16377 Leigh Kirton         53 party:53 Labour Party MTW:E05001073 Deckham                       2016-05-05 0 0           PP53   0
11880 16381 Andy Blanchflower         53 party:63 Green Party MTW:E05001074 Dunston and Teams                       2016-05-05 0 0           PP63   0
11881 16382 Brenda Lilian Clelland         53 party:53 Labour Party MTW:E05001074 Dunston and Teams                       2016-05-05 0 0           PP53   0
11882 16383 Josh Alan Knotts         53 party:85 UK Independence Party (UKIP) MTW:E05001074 Dunston and Teams                       2016-05-05 0 0           PP85   0
11883 16384 Susan Walker         53 party:90 Liberal Democrats MTW:E05001074 Dunston and Teams                       2016-05-05 0 0           PP90   0
11884 16385 Susan Wilson         53 party:52 Conservative and Unionist Party MTW:E05001074 Dunston and Teams                       2016-05-05 0 0           PP52   0
11885 16392 Sonya Dickie         53 party:53 Labour Party MTW:E05001076 Felling                       2016-05-05 0 0           PP53   0
11886 16393 Tony McConnell         53 party:90 Liberal Democrats MTW:E05001076 Felling                       2016-05-05 0 0           PP90   0
11887 16394 Michael McGuire         53 party:85 UK Independence Party (UKIP) MTW:E05001076 Felling                       2016-05-05 0 0           PP85   0
11888 16395 Trevor Charles Murray         53 party:52 Conservative and Unionist Party MTW:E05001076 Felling                       2016-05-05 0 0           PP52   0
11889 16399 Edward Bohill         53 party:52 Conservative and Unionist Party MTW:E05001077 High Fell                       2016-05-05 0 0           PP52   0
11890 16400 Jean Lee         53 party:53 Labour Party MTW:E05001077 High Fell                       2016-05-05 0 0           PP53   0
11891 16401 Norman Spours         53 party:90 Liberal Democrats MTW:E05001077 High Fell                       2016-05-05 0 0           PP90   0
11892 16402 Sean James Doherty         53 party:804 Trade Unionist and Socialist Coalition MTW:E05001078 Lamesley                       2016-05-05 0 0   36377.0       PP804   0
11893 16403 Sheila Everatt         53 party:52 Conservative and Unionist Party MTW:E05001078 Lamesley                       2016-05-05 0 0           PP52   0
11894 16404 Thomas Hall         53 party:85 UK Independence Party (UKIP) MTW:E05001078 Lamesley                       2016-05-05 0 0           PP85   0
11895 16405 Michael Hood         53 party:53 Labour Party MTW:E05001078 Lamesley                       2016-05-05 0 0           PP53   0
11896 16406 Callum Thomas Price         53 party:90 Liberal Democrats MTW:E05001078 Lamesley                       2016-05-05 0 0           PP90   0
11897 16414 Valerie Bond         53 party:52 Conservative and Unionist Party MTW:E05001079 Lobley Hill and Bensham                       2016-05-05 0 0           PP52   0
11898 16415 Catherine Donovan         53 party:53 Labour Party MTW:E05001079 Lobley Hill and Bensham                       2016-05-05 0 0           PP53   0
11899 16416 David Gilson Fawcett     male   53 party:90 Liberal Democrats MTW:E05001079 Lobley Hill and Bensham                       2016-05-05 0 0           PP90   0
11900 16417 Dot Lynch         53 party:85 UK Independence Party (UKIP) MTW:E05001079 Lobley Hill and Bensham                       2016-05-05 0 0           PP85   0
11901 16418 Daniel Stephen Duggan         53 party:90 Liberal Democrats MTW:E05001080 Low Fell                       2016-05-05 0 0           PP90   0
11902 16419 Miriam Evans         53 party:85 UK Independence Party (UKIP) MTW:E05001080 Low Fell                       2016-05-05 0 0           PP85   0
11903 16420 Ruth Christina Grant         53 party:63 Green Party MTW:E05001080 Low Fell                       2016-05-05 0 0           PP63   0
11904 16421 Ken Parkin         53 party:53 Labour Party MTW:E05001080 Low Fell                       2016-05-05 0 0           PP53   0
11905 16422 David Potts         53 party:52 Conservative and Unionist Party MTW:E05001080 Low Fell                       2016-05-05 0 0           PP52   0
11906 16426 John Morrow         53 party:804 Trade Unionist and Socialist Coalition MTW:E05001081 Pelaw and Heworth                       2016-05-05 0 0           PP804   0
11907 16427 Ian Patterson         53 party:90 Liberal Democrats MTW:E05001081 Pelaw and Heworth                       2016-05-05 0 0           PP90   0
11908 16428 Paul Sterling         53 party:52 Conservative and Unionist Party MTW:E05001081 Pelaw and Heworth                       2016-05-05 0 0           PP52   0
11909 16429 Allan David Verth         53 party:53 Labour Party MTW:E05001081 Pelaw and Heworth                       2016-05-05 0 0           PP53   0
11910 16430 Daniel George Biggins         53 party:52 Conservative and Unionist Party MTW:E05001082 Ryton, Crookhill and Stella                       2016-05-05 0 0           PP52   0
11911 16431 Ros Cooper         53 party:804 Trade Unionist and Socialist Coalition MTW:E05001082 Ryton, Crookhill and Stella                       2016-05-05 0 0           PP804   0
11912 16432 Alan Robert Craig         53 party:85 UK Independence Party (UKIP) MTW:E05001082 Ryton, Crookhill and Stella                       2016-05-05 0 0           PP85   0
11913 16433 Mark Groves         53 party:90 Liberal Democrats MTW:E05001082 Ryton, Crookhill and Stella                       2016-05-05 0 0           PP90   0
11914 16434 Carol Maize         53 party:63 Green Party MTW:E05001082 Ryton, Crookhill and Stella                       2016-05-05 0 0           PP63   0
11915 16435 Liz Twist     female   53 party:53 Labour Party MTW:E05001082 Ryton, Crookhill and Stella     https://vote.labour.org.uk/liz-twist   https://en.wikipedia.org/wiki/Liz_Twist   https://static-candidates.democracyclub.org.uk/media/images/images/16435.png   profile-photo brycx https://www.facebook.com/photo.php?fbid=112810142244552&set=a.112810108911222.1073741825.100005467003707&type=3&theater 2016-05-05 0 0           PP53   0
11916 16436 Alan Bond         53 party:52 Conservative and Unionist Party MTW:E05001083 Saltwell                       2016-05-05 0 0           PP52   0
11917 16437 Rob Hooper         53 party:804 Trade Unionist and Socialist Coalition MTW:E05001083 Saltwell                       2016-05-05 0 0           PP804   0
11918 16438 Ponchi Kantt-Neaz         53 party:85 UK Independence Party (UKIP) MTW:E05001083 Saltwell                       2016-05-05 0 0           PP85   0
11919 16439 Jeannie Kielty         53 party:53 Labour Party MTW:E05001083 Saltwell                       2016-05-05 0 0           PP53   0
11920 16440 Rachel Llewellyn         53 party:63 Green Party MTW:E05001083 Saltwell                       2016-05-05 0 0           PP63   0
11921 16441 Robinson Geoffrey Stanaway         53 party:90 Liberal Democrats MTW:E05001083 Saltwell                       2016-05-05 0 0           PP90   0
11922 16442 John Paul Diston         53 party:90 Liberal Democrats MTW:E05001084 Wardley and Leam Lane                       2016-05-05 0 0           PP90   0
11923 16443 Linda Green         53 party:53 Labour Party MTW:E05001084 Wardley and Leam Lane                       2016-05-05 0 0           PP53   0
11924 16444 John Robert McNeil         53 party:52 Conservative and Unionist Party MTW:E05001084 Wardley and Leam Lane                       2016-05-05 0 0           PP52   0
11925 16445 Stephen Watson         53 party:63 Green Party MTW:E05001084 Wardley and Leam Lane                       2016-05-05 0 0           PP63   0
11926 16446 Dot Burnett         53 party:53 Labour Party MTW:E05001085 Whickham North                       2016-05-05 0 0           PP53   0
11927 16447 John Callanan         53 party:52 Conservative and Unionist Party MTW:E05001085 Whickham North                       2016-05-05 0 0           PP52   0
11928 16448 Sonya Hawkins         53 party:90 Liberal Democrats MTW:E05001085 Whickham North                       2016-05-05 0 0           PP90   0
11929 16449 William Lynch         53 party:85 UK Independence Party (UKIP) MTW:E05001085 Whickham North                       2016-05-05 0 0           PP85   0
11930 16450 Trevor Edward Ashworth         53 party:85 UK Independence Party (UKIP) MTW:E05001086 Whickham South and Sunniside                       2016-05-05 0 0           PP85   0
11931 16451 Peter De-Vere         53 party:53 Labour Party MTW:E05001086 Whickham South and Sunniside                       2016-05-05 0 0           PP53   0
11932 16452 John McClurey         53 party:90 Liberal Democrats MTW:E05001086 Whickham South and Sunniside                       2016-05-05 0 0           PP90   0
11933 16453 Perry Wilson         53 party:52 Conservative and Unionist Party MTW:E05001086 Whickham South and Sunniside                       2016-05-05 0 0           PP52   0
11934 16454 Karen Therese Crozier         53 party:90 Liberal Democrats MTW:E05001087 Windy Nook and Whitehills                       2016-05-05 0 0           PP90   0
11935 16455 Mark Douglas         53 party:85 UK Independence Party (UKIP) MTW:E05001087 Windy Nook and Whitehills                       2016-05-05 0 0           PP85   0
Powered by Datasette · Query took 1.105ms