home / democracyclub

candidates

Data license: CC-BY-SA · Data source: Democracy Club

138 rows where election = 55

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, facebook_personal_url, homepage_url, linkedin_url, image_url, image_copyright, image_uploading_user, image_uploading_user_notes, twitter_user_id, old_person_ids, party_ec_id, favourite_biscuits

Link rowid id name honorific_prefix honorific_suffix gender birth_date election party_id party_name post_id post_label mapit_url elected party_ppc_page_url homepage_url wikipedia_url linkedin_url image_url proxy_image_url_template image_copyright image_uploading_user image_uploading_user_notes election_date election_current party_lists_in_use party_list_position old_person_ids gss_code parlparse_id theyworkforyou_url party_ec_id favourite_biscuits cancelled_poll
11993 11993 1375 Andrew Gray     male 1968.0 local.newcastle-upon-tyne.2016-05-05 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 11994 1829 Martin Levy     male   local.newcastle-upon-tyne.2016-05-05 55 party:78 Communist Party of Britain MTW:E05001109 Walkergate                       2016-05-05 0 0   13284.0       PP78   0
11995 11995 3665 John Pearson     male   local.newcastle-upon-tyne.2016-05-05 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 11996 4028 Wendy Taylor Cllr Dr MBE female   local.newcastle-upon-tyne.2016-05-05 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 11997 4947 Nick Cott     male   local.newcastle-upon-tyne.2016-05-05 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 11998 5711 Duncan Crute     male 1971.0 local.newcastle-upon-tyne.2016-05-05 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 11999 6286 David Robinson-Young     male   local.newcastle-upon-tyne.2016-05-05 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 12000 11131 Ann Veronica Schofield         local.newcastle-upon-tyne.2016-05-05 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 12001 11195 Marc James Donnelly         local.newcastle-upon-tyne.2016-05-05 55 ynmp-party:2 Independent MTW:E05001110 Westerhope   1.0                   2016-05-05 0 0           ynmp-party:2   0
12002 12002 13127 Neville Douthwaite Armstrong         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001089 Benwell and Scotswood                       2016-05-05 0 0           PP52   0
12003 12003 13128 Mark Bickerton         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001089 Benwell and Scotswood                       2016-05-05 0 0           PP85   0
12004 12004 13129 Rob Higgins         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001089 Benwell and Scotswood   1.0                   2016-05-05 0 0           PP53   0
12005 12005 13130 Lee Daniel Irving         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001089 Benwell and Scotswood                       2016-05-05 0 0           PP63   0
12006 12006 13131 Helen Laverick         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001089 Benwell and Scotswood                       2016-05-05 0 0           PP90   0
12007 12007 13136 Brendan Derham         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001090 Blakelaw                       2016-05-05 0 0           PP63   0
12008 12008 13137 Ritchie Lane         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001090 Blakelaw                       2016-05-05 0 0           PP85   0
12009 12009 13138 James Gerard Langley         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001090 Blakelaw                       2016-05-05 0 0           PP52   0
12010 12010 13139 Bill Schardt         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001090 Blakelaw                       2016-05-05 0 0           PP90   0
12011 12011 13140 David Stockdale         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001090 Blakelaw   1.0                   2016-05-05 0 0           PP53   0
12012 12012 13152 George Alfred Allison         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001091 Byker   1.0                   2016-05-05 0 0           PP53   0
12013 12013 13153 Nick Morphet         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001091 Byker                       2016-05-05 0 0           PP63   0
12014 12014 13154 Mark Nelson         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001091 Byker                       2016-05-05 0 0           PP90   0
12015 12015 13155 Donald Robinson         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001091 Byker                       2016-05-05 0 0           PP52   0
12016 12016 13161 Ian Graham         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001092 Castle   1.0                   2016-05-05 0 0           PP90   0
12017 12017 13162 Timothy Thomas Marron         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001092 Castle                       2016-05-05 0 0           PP85   0
12018 12018 13163 Andrew Jonathan Thorp         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001092 Castle                       2016-05-05 0 0           PP63   0
12019 12019 13164 Mary Toward         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001092 Castle                       2016-05-05 0 0           PP52   0
12020 12020 13165 Jacqui Turner         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001092 Castle                       2016-05-05 0 0           PP53   0
12021 12021 13174 Tab Bailey         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001093 Dene                       2016-05-05 0 0           PP63   0
12022 12022 13175 Tim Monckton         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001093 Dene                       2016-05-05 0 0           PP52   0
12023 12023 13176 David Muat     male 1954.0 local.newcastle-upon-tyne.2016-05-05 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 12024 13177 Sheila Claire Spencer         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001093 Dene                       2016-05-05 0 0           PP53   0
12025 12025 13196 Sarah Jane Armstrong     Female   local.newcastle-upon-tyne.2016-05-05 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 12026 13197 Alan Henry Birkmyre         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001094 Denton                       2016-05-05 0 0           PP52   0
12027 12027 13198 Colin Thomas Daglish         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001094 Denton                       2016-05-05 0 0           PP90   0
12028 12028 13199 Dan Greenhough         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001094 Denton   1.0                   2016-05-05 0 0           PP53   0
12029 12029 13200 Brian David Moore     male 1960.0 local.newcastle-upon-tyne.2016-05-05 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 12030 13201 Spinoza Pitman         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001094 Denton                       2016-05-05 0 0           PP63   0
12031 12031 13209 Peter John Dunne         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001095 East Gosforth                       2016-05-05 0 0           PP85   0
12032 12032 13210 Nicholas Alan Fray         local.newcastle-upon-tyne.2016-05-05 55 party:804 Trade Unionist and Socialist Coalition MTW:E05001095 East Gosforth                       2016-05-05 0 0           PP804   0
12033 12033 13211 Frances Christine Hinton         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001095 East Gosforth                       2016-05-05 0 0           PP63   0
12034 12034 13212 Gareth James Hughes         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001095 East Gosforth                       2016-05-05 0 0           PP53   0
12035 12035 13213 Dominic Mark Raymont         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001095 East Gosforth   1.0                   2016-05-05 0 0           PP90   0
12036 12036 13214 Alison Wake         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001095 East Gosforth                       2016-05-05 0 0           PP52   0
12037 12037 13215 James Peter Kenyon         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001096 Elswick                       2016-05-05 0 0           PP90   0
12038 12038 13216 Mark Page         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001096 Elswick                       2016-05-05 0 0           PP85   0
12039 12039 13217 Taymar Gem Pitman         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001096 Elswick                       2016-05-05 0 0           PP63   0
12040 12040 13218 Ron Toward         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001096 Elswick                       2016-05-05 0 0           PP52   0
12041 12041 13219 Steve Axford         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001097 Fawdon                       2016-05-05 0 0           PP52   0
12042 12042 13220 Alexis Fernandes         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001097 Fawdon                       2016-05-05 0 0           PP85   0
12043 12043 13221 Michael James Gardner         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001097 Fawdon                       2016-05-05 0 0           PP63   0
12044 12044 13222 Brenda Hindmarsh         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001097 Fawdon   1.0                   2016-05-05 0 0           PP90   0
12045 12045 13223 Clare Penny-Evans         local.newcastle-upon-tyne.2016-05-05 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 12046 13224 Christopher Thomas Ballantyne         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001098 Fenham                       2016-05-05 0 0           PP85   0
12047 12047 13225 Christine Morrissey         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001098 Fenham                       2016-05-05 0 0           PP90   0
12048 12048 13226 Andrew Arthur Stark         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001098 Fenham                       2016-05-05 0 0           PP63   0
12049 12049 13227 Marion Elizabeth Talbot     Female   local.newcastle-upon-tyne.2016-05-05 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 12050 13228 Kenneth Wake         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001098 Fenham                       2016-05-05 0 0   46125.0       PP52   0
12051 12051 13229 Simon Bell         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001099 Kenton                       2016-05-05 0 0           PP52   0
12052 12052 13230 Ian Kilgour Christie         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001099 Kenton                       2016-05-05 0 0           PP63   0
12053 12053 13231 Tracy Connell         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001099 Kenton                       2016-05-05 0 0           PP90   0
12054 12054 13232 Oisin Gourley         local.newcastle-upon-tyne.2016-05-05 55 party:804 Trade Unionist and Socialist Coalition MTW:E05001099 Kenton                       2016-05-05 0 0           PP804   0
12055 12055 13233 Penelope Stansfield         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001099 Kenton                       2016-05-05 0 0           PP85   0
12056 12056 13234 Jane Louise Streather         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001099 Kenton   1.0                   2016-05-05 0 0           PP53   0
12057 12057 13235 Mike Adie         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001100 Lemington                       2016-05-05 0 0           PP85   0
12058 12058 13236 Kim McGuinness         local.newcastle-upon-tyne.2016-05-05 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 12059 13237 PJ Morrissey         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001100 Lemington                       2016-05-05 0 0           PP90   0
12060 12060 13238 Alison Robinson         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001100 Lemington                       2016-05-05 0 0           PP52   0
12061 12061 13239 Jason Smith     Male   local.newcastle-upon-tyne.2016-05-05 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 12062 13240 Ross Anthony Spray         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001100 Lemington                       2016-05-05 0 0           PP63   0
12063 12063 13241 Christopher Brewster         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001101 Newburn                       2016-05-05 0 0           PP52   0
12064 12064 13242 Steve Fairlie         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001101 Newburn   1.0                   2016-05-05 0 0           PP53   0
12065 12065 13243 John Alan Gordon         local.newcastle-upon-tyne.2016-05-05 55 party:905 Newcastle upon Tyne Community First Party MTW:E05001101 Newburn                       2016-05-05 0 0           PP905   0
12066 12066 13244 Lawrence Hunter         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001101 Newburn                       2016-05-05 0 0           PP90   0
12067 12067 13245 James Douglas Robertson         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001101 Newburn                       2016-05-05 0 0           PP85   0
12068 12068 13247 Nora Maebh Casey         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001102 North Heaton                       2016-05-05 0 0           PP53   0
12069 12069 13248 Elisabeth Margery Edmundson         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001102 North Heaton                       2016-05-05 0 0           PP85   0
12070 12070 13249 Joe Herbert         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001102 North Heaton                       2016-05-05 0 0           PP63   0
12071 12071 13250 Doreen Huddart         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001102 North Heaton   1.0                   2016-05-05 0 0           PP90   0
12072 12072 13252 Gerard Francis Keating         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001103 North Jesmond                       2016-05-05 0 0           PP90   0
12073 12073 13253 Mark Barton Lewis         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001103 North Jesmond                       2016-05-05 0 0           PP85   0
12074 12074 13254 Shehla Khatoon Naqvi         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001103 North Jesmond                       2016-05-05 0 0           PP63   0
12075 12075 13255 Stella Rogers Postlethwaite         local.newcastle-upon-tyne.2016-05-05 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 12076 13256 Paula Holland         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001104 Ouseburn   1.0                   2016-05-05 0 0           PP53   0
12077 12077 13257 Stephen Howse         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001104 Ouseburn                       2016-05-05 0 0           PP90   0
12078 12078 13258 Marian Julie Kyte         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001104 Ouseburn                       2016-05-05 0 0           PP52   0
12079 12079 13259 Sarah Kate O'Hare         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001104 Ouseburn                       2016-05-05 0 0           PP63   0
12080 12080 13261 Matthew Wilson-Boddy         local.newcastle-upon-tyne.2016-05-05 55 party:804 Trade Unionist and Socialist Coalition MTW:E05001104 Ouseburn                       2016-05-05 0 0           PP804   0
12081 12081 13262 Pauline Allen         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001105 Parklands   1.0                   2016-05-05 0 0           PP90   0
12082 12082 13263 John William James Atkinson         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001105 Parklands                       2016-05-05 0 0           PP85   0
12083 12083 13264 Sandy Irvine         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001105 Parklands                       2016-05-05 0 0           PP63   0
12084 12084 13265 Karen Jewers         local.newcastle-upon-tyne.2016-05-05 55 party:52 Conservative and Unionist Party MTW:E05001105 Parklands                       2016-05-05 0 0           PP52   0
12085 12085 13266 Shumel Rahman         local.newcastle-upon-tyne.2016-05-05 55 party:53 Labour Party MTW:E05001105 Parklands                       2016-05-05 0 0           PP53   0
12086 12086 13267 Sam Boam     male   local.newcastle-upon-tyne.2016-05-05 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 12087 13268 Max Elliott Peacock         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001106 South Heaton                       2016-05-05 0 0           PP85   0
12088 12088 13269 Catherine Smith         local.newcastle-upon-tyne.2016-05-05 55 party:90 Liberal Democrats MTW:E05001106 South Heaton                       2016-05-05 0 0           PP90   0
12089 12089 13270 John-Paul Stephenson     Male 1978.0 local.newcastle-upon-tyne.2016-05-05 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 12090 13271 James Lee Askwith         local.newcastle-upon-tyne.2016-05-05 55 party:85 UK Independence Party (UKIP) MTW:E05001107 South Jesmond                       2016-05-05 0 0           PP85   0
12091 12091 13272 Matt Busby         local.newcastle-upon-tyne.2016-05-05 55 party:63 Green Party MTW:E05001107 South Jesmond                       2016-05-05 0 0           PP63   0
12092 12092 13273 Matthew Thomas McPherson     Male   local.newcastle-upon-tyne.2016-05-05 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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "candidates" (
"id" INTEGER,
  "name" TEXT,
  "honorific_prefix" REAL,
  "honorific_suffix" REAL,
  "gender" TEXT,
  "birth_date" REAL,
  "election" INTEGER,
  "party_id" TEXT,
  "party_name" TEXT,
  "post_id" TEXT,
  "post_label" TEXT,
  "mapit_url" INTEGER,
  "elected" REAL,
  "email" TEXT,
  "twitter_username" REAL,
  "facebook_page_url" REAL,
  "party_ppc_page_url" REAL,
  "facebook_personal_url" REAL,
  "homepage_url" REAL,
  "wikipedia_url" REAL,
  "linkedin_url" REAL,
  "image_url" REAL,
  "proxy_image_url_template" INTEGER,
  "image_copyright" REAL,
  "image_uploading_user" REAL,
  "image_uploading_user_notes" REAL,
  "twitter_user_id" INTEGER,
  "election_date" TEXT,
  "election_current" INTEGER,
  "party_lists_in_use" INTEGER,
  "party_list_position" INTEGER,
  "old_person_ids" REAL,
  "gss_code" INTEGER,
  "parlparse_id" REAL,
  "theyworkforyou_url" REAL,
  "party_ec_id" TEXT,
  "favourite_biscuits" REAL,
  "cancelled_poll" INTEGER
,
FOREIGN KEY ("election") REFERENCES [election](id))
Powered by Datasette · Query took 10.076ms · Data license: CC-BY-SA · Data source: Democracy Club