home / democracyclub

candidates

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

107 rows where election = 53

✎ 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_uploading_user, image_uploading_user_notes, twitter_user_id, old_person_ids, party_ec_id

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