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
11993 1375 Andrew Gray     male 1968.0 55 party:63 Green Party MTW:E05001106 South Heaton     https://neengland.greenparty.org.uk/ http://tyneside.motd.org/     https://static-candidates.democracyclub.org.uk/media/images/54e50abe5fb5e7f7244fca09.png         2016-05-05 0 0   7671;35775       PP63 bourbon 0
11994 1829 Martin Levy     male   55 party:78 Communist Party of Britain MTW:E05001109 Walkergate                       2016-05-05 0 0   13284.0       PP78   0
11995 3665 John Pearson     male   55 party:63 Green Party MTW:E05001113 Wingrove             https://static-candidates.democracyclub.org.uk/media/images/images/3665.png   profile-photo JeniT used in news story at https://magpienewcastle.com/2015/04/25/wingrove-ward-election-profile-john-pearson-green-party/ - looks like official campaign photo 2016-05-05 0 0   13335.0       PP63   0
11996 4028 Wendy Taylor Cllr Dr MBE female   55 party:90 Liberal Democrats MTW:E05001093 Dene   1.0 http://www.libdems.org.uk/wendy_taylor       https://static-candidates.democracyclub.org.uk/media/images/5517f32f249b917507bee507.png   public-domain wendle55   2016-05-05 0 0   13178.0       PP90   0
11997 4947 Nick Cott     male   55 party:90 Liberal Democrats MTW:E05001112 West Gosforth   1.0         https://static-candidates.democracyclub.org.uk/media/images/54f76d2cc689026478f43689.png   profile-photo gmadden http://newcastle-libdems.org.uk/en/contact/cllr-nick-cott 2016-05-05 0 0   13323.0       PP90   0
11998 5711 Duncan Crute     male 1971.0 55 party:52 Conservative and Unionist Party MTW:E05001103 North Jesmond     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Crute_Duncan.aspx http://www.duncancrute.org/   http://uk.linkedin.com/pub/duncan-crute/6/556/994/en https://static-candidates.democracyclub.org.uk/media/images/54cd19a6668e142f73d3b495.png   profile-photo     2016-05-05 0 0   13251.0       PP52   0
11999 6286 David Robinson-Young     male   55 party:85 UK Independence Party (UKIP) MTW:E05001091 Byker           http://uk.linkedin.com/pub/david-robinson-young/21/a35/225/en https://static-candidates.democracyclub.org.uk/media/images/553ba32a10284be476aae895.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/DRY10 2016-05-05 0 0   13156.0       PP85   0
12000 11131 Ann Veronica Schofield         55 party:53 Labour Party MTW:E05001096 Elswick   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/11131.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
12001 11195 Marc James Donnelly         55 ynmp-party:2 Independent MTW:E05001110 Westerhope   1.0                   2016-05-05 0 0           ynmp-party:2   0
12002 13127 Neville Douthwaite Armstrong         55 party:52 Conservative and Unionist Party MTW:E05001089 Benwell and Scotswood                       2016-05-05 0 0           PP52   0
12003 13128 Mark Bickerton         55 party:85 UK Independence Party (UKIP) MTW:E05001089 Benwell and Scotswood                       2016-05-05 0 0           PP85   0
12004 13129 Rob Higgins         55 party:53 Labour Party MTW:E05001089 Benwell and Scotswood   1.0                   2016-05-05 0 0           PP53   0
12005 13130 Lee Daniel Irving         55 party:63 Green Party MTW:E05001089 Benwell and Scotswood                       2016-05-05 0 0           PP63   0
12006 13131 Helen Laverick         55 party:90 Liberal Democrats MTW:E05001089 Benwell and Scotswood                       2016-05-05 0 0           PP90   0
12007 13136 Brendan Derham         55 party:63 Green Party MTW:E05001090 Blakelaw                       2016-05-05 0 0           PP63   0
12008 13137 Ritchie Lane         55 party:85 UK Independence Party (UKIP) MTW:E05001090 Blakelaw                       2016-05-05 0 0           PP85   0
12009 13138 James Gerard Langley         55 party:52 Conservative and Unionist Party MTW:E05001090 Blakelaw                       2016-05-05 0 0           PP52   0
12010 13139 Bill Schardt         55 party:90 Liberal Democrats MTW:E05001090 Blakelaw                       2016-05-05 0 0           PP90   0
12011 13140 David Stockdale         55 party:53 Labour Party MTW:E05001090 Blakelaw   1.0                   2016-05-05 0 0           PP53   0
12012 13152 George Alfred Allison         55 party:53 Labour Party MTW:E05001091 Byker   1.0                   2016-05-05 0 0           PP53   0
12013 13153 Nick Morphet         55 party:63 Green Party MTW:E05001091 Byker                       2016-05-05 0 0           PP63   0
12014 13154 Mark Nelson         55 party:90 Liberal Democrats MTW:E05001091 Byker                       2016-05-05 0 0           PP90   0
12015 13155 Donald Robinson         55 party:52 Conservative and Unionist Party MTW:E05001091 Byker                       2016-05-05 0 0           PP52   0
12016 13161 Ian Graham         55 party:90 Liberal Democrats MTW:E05001092 Castle   1.0                   2016-05-05 0 0           PP90   0
12017 13162 Timothy Thomas Marron         55 party:85 UK Independence Party (UKIP) MTW:E05001092 Castle                       2016-05-05 0 0           PP85   0
12018 13163 Andrew Jonathan Thorp         55 party:63 Green Party MTW:E05001092 Castle                       2016-05-05 0 0           PP63   0
12019 13164 Mary Toward         55 party:52 Conservative and Unionist Party MTW:E05001092 Castle                       2016-05-05 0 0           PP52   0
12020 13165 Jacqui Turner         55 party:53 Labour Party MTW:E05001092 Castle                       2016-05-05 0 0           PP53   0
12021 13174 Tab Bailey         55 party:63 Green Party MTW:E05001093 Dene                       2016-05-05 0 0           PP63   0
12022 13175 Tim Monckton         55 party:52 Conservative and Unionist Party MTW:E05001093 Dene                       2016-05-05 0 0           PP52   0
12023 13176 David Muat     male 1954.0 55 party:85 UK Independence Party (UKIP) MTW:E05001093 Dene             https://static-candidates.democracyclub.org.uk/media/images/images/13176.png   profile-photo yanbad13257   2016-05-05 0 0           PP85   0
12024 13177 Sheila Claire Spencer         55 party:53 Labour Party MTW:E05001093 Dene                       2016-05-05 0 0           PP53   0
12025 13196 Sarah Jane Armstrong     Female   55 party:905 Newcastle upon Tyne Community First Party MTW:E05001094 Denton       http://www.newcastlefirst.co.uk               2016-05-05 0 0   38206.0       PP905   0
12026 13197 Alan Henry Birkmyre         55 party:52 Conservative and Unionist Party MTW:E05001094 Denton                       2016-05-05 0 0           PP52   0
12027 13198 Colin Thomas Daglish         55 party:90 Liberal Democrats MTW:E05001094 Denton                       2016-05-05 0 0           PP90   0
12028 13199 Dan Greenhough         55 party:53 Labour Party MTW:E05001094 Denton   1.0                   2016-05-05 0 0           PP53   0
12029 13200 Brian David Moore     male 1960.0 55 party:85 UK Independence Party (UKIP) MTW:E05001094 Denton       http://www.northernengland.uk/newcastle     https://static-candidates.democracyclub.org.uk/media/images/images/13200.png   profile-photo fbrc from party page (is person on left) 2016-05-05 0 0           PP85   0
12030 13201 Spinoza Pitman         55 party:63 Green Party MTW:E05001094 Denton                       2016-05-05 0 0           PP63   0
12031 13209 Peter John Dunne         55 party:85 UK Independence Party (UKIP) MTW:E05001095 East Gosforth                       2016-05-05 0 0           PP85   0
12032 13210 Nicholas Alan Fray         55 party:804 Trade Unionist and Socialist Coalition MTW:E05001095 East Gosforth                       2016-05-05 0 0           PP804   0
12033 13211 Frances Christine Hinton         55 party:63 Green Party MTW:E05001095 East Gosforth                       2016-05-05 0 0           PP63   0
12034 13212 Gareth James Hughes         55 party:53 Labour Party MTW:E05001095 East Gosforth                       2016-05-05 0 0           PP53   0
12035 13213 Dominic Mark Raymont         55 party:90 Liberal Democrats MTW:E05001095 East Gosforth   1.0                   2016-05-05 0 0           PP90   0
12036 13214 Alison Wake         55 party:52 Conservative and Unionist Party MTW:E05001095 East Gosforth                       2016-05-05 0 0           PP52   0
12037 13215 James Peter Kenyon         55 party:90 Liberal Democrats MTW:E05001096 Elswick                       2016-05-05 0 0           PP90   0
12038 13216 Mark Page         55 party:85 UK Independence Party (UKIP) MTW:E05001096 Elswick                       2016-05-05 0 0           PP85   0
12039 13217 Taymar Gem Pitman         55 party:63 Green Party MTW:E05001096 Elswick                       2016-05-05 0 0           PP63   0
12040 13218 Ron Toward         55 party:52 Conservative and Unionist Party MTW:E05001096 Elswick                       2016-05-05 0 0           PP52   0
12041 13219 Steve Axford         55 party:52 Conservative and Unionist Party MTW:E05001097 Fawdon                       2016-05-05 0 0           PP52   0
12042 13220 Alexis Fernandes         55 party:85 UK Independence Party (UKIP) MTW:E05001097 Fawdon                       2016-05-05 0 0           PP85   0
12043 13221 Michael James Gardner         55 party:63 Green Party MTW:E05001097 Fawdon                       2016-05-05 0 0           PP63   0
12044 13222 Brenda Hindmarsh         55 party:90 Liberal Democrats MTW:E05001097 Fawdon   1.0                   2016-05-05 0 0           PP90   0
12045 13223 Clare Penny-Evans         55 party:53 Labour Party MTW:E05001097 Fawdon             https://static-candidates.democracyclub.org.uk/media/images/images/13223.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=20272372 2016-05-05 0 0           PP53   0
12046 13224 Christopher Thomas Ballantyne         55 party:85 UK Independence Party (UKIP) MTW:E05001098 Fenham                       2016-05-05 0 0           PP85   0
12047 13225 Christine Morrissey         55 party:90 Liberal Democrats MTW:E05001098 Fenham                       2016-05-05 0 0           PP90   0
12048 13226 Andrew Arthur Stark         55 party:63 Green Party MTW:E05001098 Fenham                       2016-05-05 0 0           PP63   0
12049 13227 Marion Elizabeth Talbot     Female   55 party:53 Labour Party MTW:E05001098 Fenham   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/13227.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=577936327 2016-05-05 0 0           PP53   0
12050 13228 Kenneth Wake         55 party:52 Conservative and Unionist Party MTW:E05001098 Fenham                       2016-05-05 0 0   46125.0       PP52   0
12051 13229 Simon Bell         55 party:52 Conservative and Unionist Party MTW:E05001099 Kenton                       2016-05-05 0 0           PP52   0
12052 13230 Ian Kilgour Christie         55 party:63 Green Party MTW:E05001099 Kenton                       2016-05-05 0 0           PP63   0
12053 13231 Tracy Connell         55 party:90 Liberal Democrats MTW:E05001099 Kenton                       2016-05-05 0 0           PP90   0
12054 13232 Oisin Gourley         55 party:804 Trade Unionist and Socialist Coalition MTW:E05001099 Kenton                       2016-05-05 0 0           PP804   0
12055 13233 Penelope Stansfield         55 party:85 UK Independence Party (UKIP) MTW:E05001099 Kenton                       2016-05-05 0 0           PP85   0
12056 13234 Jane Louise Streather         55 party:53 Labour Party MTW:E05001099 Kenton   1.0                   2016-05-05 0 0           PP53   0
12057 13235 Mike Adie         55 party:85 UK Independence Party (UKIP) MTW:E05001100 Lemington                       2016-05-05 0 0           PP85   0
12058 13236 Kim McGuinness         55 party:53 Labour Party MTW:E05001100 Lemington   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/13236.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=183190003 2016-05-05 0 0           PP53   0
12059 13237 PJ Morrissey         55 party:90 Liberal Democrats MTW:E05001100 Lemington                       2016-05-05 0 0           PP90   0
12060 13238 Alison Robinson         55 party:52 Conservative and Unionist Party MTW:E05001100 Lemington                       2016-05-05 0 0           PP52   0
12061 13239 Jason Smith     Male   55 party:905 Newcastle upon Tyne Community First Party MTW:E05001100 Lemington       http://www.newcastlefirst.co.uk     https://static-candidates.democracyclub.org.uk/media/images/images/13239.png   copyright-assigned jasons1973uk   2016-05-05 0 0           PP905 Golden crunch or Gold Bar 0
12062 13240 Ross Anthony Spray         55 party:63 Green Party MTW:E05001100 Lemington                       2016-05-05 0 0           PP63   0
12063 13241 Christopher Brewster         55 party:52 Conservative and Unionist Party MTW:E05001101 Newburn                       2016-05-05 0 0           PP52   0
12064 13242 Steve Fairlie         55 party:53 Labour Party MTW:E05001101 Newburn   1.0                   2016-05-05 0 0           PP53   0
12065 13243 John Alan Gordon         55 party:905 Newcastle upon Tyne Community First Party MTW:E05001101 Newburn                       2016-05-05 0 0           PP905   0
12066 13244 Lawrence Hunter         55 party:90 Liberal Democrats MTW:E05001101 Newburn                       2016-05-05 0 0           PP90   0
12067 13245 James Douglas Robertson         55 party:85 UK Independence Party (UKIP) MTW:E05001101 Newburn                       2016-05-05 0 0           PP85   0
12068 13247 Nora Maebh Casey         55 party:53 Labour Party MTW:E05001102 North Heaton                       2016-05-05 0 0           PP53   0
12069 13248 Elisabeth Margery Edmundson         55 party:85 UK Independence Party (UKIP) MTW:E05001102 North Heaton                       2016-05-05 0 0           PP85   0
12070 13249 Joe Herbert         55 party:63 Green Party MTW:E05001102 North Heaton                       2016-05-05 0 0           PP63   0
12071 13250 Doreen Huddart         55 party:90 Liberal Democrats MTW:E05001102 North Heaton   1.0                   2016-05-05 0 0           PP90   0
12072 13252 Gerard Francis Keating         55 party:90 Liberal Democrats MTW:E05001103 North Jesmond                       2016-05-05 0 0           PP90   0
12073 13253 Mark Barton Lewis         55 party:85 UK Independence Party (UKIP) MTW:E05001103 North Jesmond                       2016-05-05 0 0           PP85   0
12074 13254 Shehla Khatoon Naqvi         55 party:63 Green Party MTW:E05001103 North Jesmond                       2016-05-05 0 0           PP63   0
12075 13255 Stella Rogers Postlethwaite         55 party:53 Labour Party MTW:E05001103 North Jesmond   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/13255.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=3582689777 2016-05-05 0 0           PP53   0
12076 13256 Paula Holland         55 party:53 Labour Party MTW:E05001104 Ouseburn   1.0                   2016-05-05 0 0           PP53   0
12077 13257 Stephen Howse         55 party:90 Liberal Democrats MTW:E05001104 Ouseburn                       2016-05-05 0 0           PP90   0
12078 13258 Marian Julie Kyte         55 party:52 Conservative and Unionist Party MTW:E05001104 Ouseburn                       2016-05-05 0 0           PP52   0
12079 13259 Sarah Kate O'Hare         55 party:63 Green Party MTW:E05001104 Ouseburn                       2016-05-05 0 0           PP63   0
12080 13261 Matthew Wilson-Boddy         55 party:804 Trade Unionist and Socialist Coalition MTW:E05001104 Ouseburn                       2016-05-05 0 0           PP804   0
12081 13262 Pauline Allen         55 party:90 Liberal Democrats MTW:E05001105 Parklands   1.0                   2016-05-05 0 0           PP90   0
12082 13263 John William James Atkinson         55 party:85 UK Independence Party (UKIP) MTW:E05001105 Parklands                       2016-05-05 0 0           PP85   0
12083 13264 Sandy Irvine         55 party:63 Green Party MTW:E05001105 Parklands                       2016-05-05 0 0           PP63   0
12084 13265 Karen Jewers         55 party:52 Conservative and Unionist Party MTW:E05001105 Parklands                       2016-05-05 0 0           PP52   0
12085 13266 Shumel Rahman         55 party:53 Labour Party MTW:E05001105 Parklands                       2016-05-05 0 0           PP53   0
12086 13267 Sam Boam     male   55 party:52 Conservative and Unionist Party MTW:E05001106 South Heaton             https://static-candidates.democracyclub.org.uk/media/images/images/13267.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   30874.0       PP52   0
12087 13268 Max Elliott Peacock         55 party:85 UK Independence Party (UKIP) MTW:E05001106 South Heaton                       2016-05-05 0 0           PP85   0
12088 13269 Catherine Smith         55 party:90 Liberal Democrats MTW:E05001106 South Heaton                       2016-05-05 0 0           PP90   0
12089 13270 John-Paul Stephenson     Male 1978.0 55 party:53 Labour Party MTW:E05001106 South Heaton   1.0       https://uk.linkedin.com/in/john-paul-stephenson-a984b921 https://static-candidates.democracyclub.org.uk/media/images/images/36899.png   copyright-assigned john-paul   2016-05-05 0 0   36899.0       PP53 Cookie 0
12090 13271 James Lee Askwith         55 party:85 UK Independence Party (UKIP) MTW:E05001107 South Jesmond                       2016-05-05 0 0           PP85   0
12091 13272 Matt Busby         55 party:63 Green Party MTW:E05001107 South Jesmond                       2016-05-05 0 0           PP63   0
12092 13273 Matthew Thomas McPherson     Male   55 party:52 Conservative and Unionist Party MTW:E05001107 South Jesmond             https://static-candidates.democracyclub.org.uk/media/images/images/13273.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP52   0
12093 13274 Felicity Ann Mendelson         55 party:53 Labour Party MTW:E05001107 South Jesmond   1.0                   2016-05-05 0 0           PP53   0
Powered by Datasette · Query took 1.122ms