home / democracyclub

candidates

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

70 rows where election = 20

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: honorific_prefix, gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, homepage_url, image_url, image_copyright, 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
9116 9116 291 Howard Thomas     male   local.reading.2016-05-05 20 party:85 UK Independence Party (UKIP) UTW:E05002324 Kentwood                       2016-05-05 0 0           PP85   0
9117 9117 4523 Jenny Woods Dr   Female   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002325 Mapledurham ward     http://www.libdems.org.uk/jenny_woods       https://static-candidates.democracyclub.org.uk/media/images/images/4523.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
9118 9118 4524 Meri O'Connell Ms   Female   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002333 Tilehurst   1.0 http://www.libdems.org.uk/meri_o_connell http://merioconnell.mycouncillor.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/4524.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   18173.0       PP90   0
9119 9119 4857 Emma Warman     female   local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002324 Kentwood     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Warman_Emma.aspx http://emmawarman.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/5524a282f0e9e2c82406ebb5.png   profile-photo TimPatmore Facebook profile picture: https://www.facebook.com/photo.php?fbid=10153600349509045&set=a.10150104954099045.311643.773084044&type=1&theater 2016-05-05 0 0   34554.0       PP52   0
9120 9120 5931 Miriam Kennet     female   local.reading.2016-05-05 20 party:63 Green Party UTW:E05002333 Tilehurst     https://my.greenparty.org.uk/candidates/106144   https://en.wikipedia.org/wiki/Miriam_Kennet   https://static-candidates.democracyclub.org.uk/media/images/554877ca05a4783b28981e92.png   profile-photo andylolz From party PPC page: https://my.greenparty.org.uk/candidates/106144 2016-05-05 0 0   3919.0       PP63   0
9121 9121 6780 Neil Adams     male   local.reading.2016-05-05 20 party:804 Trade Unionist and Socialist Coalition UTW:E05002334 Whitley     http://tusc2015.com/neil-adams-for-reading-west2/                 2016-05-05 0 0           PP804   0
9122 9122 8859 Stephen Graham     male   local.reading.2016-05-05 20 party:54 The Liberal Party UTW:E05002327 Norcot                       2016-05-05 0 0           PP54   0
9123 9123 9020 Kirsten Bayes Ms       local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002319 Abbey     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/9020.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP90   0
9124 9124 13944 Syed Abbas     male   local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002323 Katesgrove     http://www.readingeastconservatives.com/person/syed-abbas-katesgrove-candidate       https://static-candidates.democracyclub.org.uk/media/images/images/13944.png   profile-photo chrisspargo It is used as the official candidate photo on Readingeastconservatives.com - http://www.readingeastconservatives.com/person/syed-abbas-katesgrove-candidate 2016-05-05 0 0           PP52   0
9125 9125 13945 Louise Keane         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002323 Katesgrove                       2016-05-05 0 0           PP63   0
9126 9126 13946 Margaret McNeill     Female   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002323 Katesgrove     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9127 9127 13947 Rose Williams     female   local.reading.2016-05-05 20 joint-party:53-119 Labour and Co-operative Party UTW:E05002323 Katesgrove   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/13947.png   profile-photo chrisspargo It is used on Readinglabour.org.uk - http://www.readinglabour.org.uk/katesgrove.html 2016-05-05 0 0           joint-party:53-119   0
9128 9128 15201 Paul Carnell         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002322 Church                       2016-05-05 0 0           PP52   0
9129 9129 15202 Kathryn McCann         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002322 Church                       2016-05-05 0 0           PP63   0
9130 9130 15203 Eileen McElligott         local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002322 Church   1.0                   2016-05-05 0 0           PP53   0
9131 9131 15204 Ben Thomas     Male   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002322 Church     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9132 9132 16236 Doug Cresswell         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002331 Southcote                       2016-05-05 0 0           PP63   0
9133 9133 16237 Debs Edwards         local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002331 Southcote   1.0                   2016-05-05 0 0           PP53   0
9134 9134 16238 Russell Martin         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002331 Southcote                       2016-05-05 0 0           PP52   0
9135 9135 18045 John Grout     Male   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002320 Battle     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9136 9136 18046 Michael Hey         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002320 Battle                       2016-05-05 0 0           PP52   0
9137 9137 18047 Gul Khan         local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002320 Battle   1.0                   2016-05-05 0 0           PP53   0
9138 9138 18048 Alan Lockey         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002320 Battle                       2016-05-05 0 0           PP63   0
9139 9139 18049 Tony Page         local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002319 Abbey   1.0                   2016-05-05 0 0           PP53   0
9140 9140 18050 Trevor Slack         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002319 Abbey                       2016-05-05 0 0           PP52   0
9141 9141 18051 Joe Sylvester         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002319 Abbey                       2016-05-05 0 0           PP63   0
9142 9142 18059 Christopher Burden     Male   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002321 Caversham     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9143 9143 18060 Richard Davies     male   local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002321 Caversham   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/18060.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP53   0
9144 9144 18061 David Foster     male   local.reading.2016-05-05 20 party:63 Green Party UTW:E05002321 Caversham     https://reading.greenparty.org.uk/people/david-foster.html       https://static-candidates.democracyclub.org.uk/media/images/images/18061.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63   0
9145 9145 18062 Ed Hogan         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002321 Caversham                       2016-05-05 0 0           PP52   0
9146 9146 18087 Glenn Goodall Dr   Male   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002324 Kentwood     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9147 9147 18088 Ruth Shaffrey         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002324 Kentwood     https://reading.greenparty.org.uk/people/ruth-shaffrey-%28kentwood-ward-candidate%29.html                 2016-05-05 0 0           PP63   0
9148 9148 18089 Daya Pal Singh         local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002324 Kentwood   1.0                   2016-05-05 0 0           PP53   0
9149 9149 18099 Isobel Ballsdon         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002325 Mapledurham ward   1.0                   2016-05-05 0 0           PP52   0
9150 9150 18100 Simon Rogers         local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002325 Mapledurham ward                       2016-05-05 0 0           PP53   0
9151 9151 18101 Brent Smith         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002325 Mapledurham ward                       2016-05-05 0 0           PP63   0
9152 9152 18102 Linda Ann Giles         local.reading.2016-05-05 20 party:85 UK Independence Party (UKIP) UTW:E05002326 Minster                       2016-05-05 0 0           PP85   0
9153 9153 18103 Keith Johnson         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002326 Minster                       2016-05-05 0 0           PP63   0
9154 9154 18104 James Moore     Male 1983-04-13 local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002326 Minster     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9155 9155 18105 Alanzo Seville         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002326 Minster                       2016-05-05 0 0           PP52   0
9156 9156 18106 Liz Terry         local.reading.2016-05-05 20 joint-party:53-119 Labour and Co-operative Party UTW:E05002326 Minster   1.0                   2016-05-05 0 0           joint-party:53-119   0
9157 9157 18118 Philip Martin Giles         local.reading.2016-05-05 20 party:85 UK Independence Party (UKIP) UTW:E05002327 Norcot                       2016-05-05 0 0           PP85   0
9158 9158 18119 Jo Lovelock         local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002327 Norcot   1.0                   2016-05-05 0 0           PP53   0
9159 9159 18120 Robert Masterson         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002327 Norcot                       2016-05-05 0 0           PP52   0
9160 9160 18121 Jon Walls     Male   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002327 Norcot     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9161 9161 18122 Jill Wigmore-Welsh         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002327 Norcot                       2016-05-05 0 0           PP63   0
9162 9162 18133 Dave Dymond         local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002328 Park                       2016-05-05 0 0           PP53   0
9163 9163 18134 Roland Hazell         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002328 Park                       2016-05-05 0 0           PP52   0
9164 9164 18135 Brenda McGonigle         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002328 Park   1.0                   2016-05-05 0 0           PP63   0
9165 9165 18136 Rebecca Rye     Female   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002328 Park     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9166 9166 18137 Peter Boardley     Male   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002329 Peppard     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9167 9167 18138 Sally Newman         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002329 Peppard                       2016-05-05 0 0           PP63   0
9168 9168 18139 Jane Stanford-Beale         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002329 Peppard   1.0                   2016-05-05 0 0           PP52   0
9169 9169 18140 Leighton Yeo         local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002329 Peppard                       2016-05-05 0 0           PP53   0
9170 9170 18141 Natalie Greenstreet         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002330 Redlands                       2016-05-05 0 0           PP52   0
9171 9171 18142 Francis Jakeman Rev   Male   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002330 Redlands     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9172 9172 18143 Tony Jones         local.reading.2016-05-05 20 joint-party:53-119 Labour and Co-operative Party UTW:E05002330 Redlands   1.0                   2016-05-05 0 0           joint-party:53-119   0
9173 9173 18144 Kizzi Johannessen     female 1986.0 local.reading.2016-05-05 20 party:63 Green Party UTW:E05002330 Redlands     https://my.greenparty.org.uk/candidates/106143 https://reading.greenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/18144.png   profile-photo IanGReeve   2016-05-05 0 0           PP63   0
9174 9174 18157 Ed Hopper         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002332 Thames   1.0                   2016-05-05 0 0           PP52   0
9175 9175 18158 Sarah McNamara         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002332 Thames                       2016-05-05 0 0           PP63   0
9176 9176 18159 Guy Penman     Male   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002332 Thames     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9177 9177 18160 Karen Rowland Ms.   female 1961-12-28 local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002332 Thames     https://www.facebook.com/KarenRowlandRDG/ https://readinglabour.org.uk/reading-local-elections-may-3/karen-rowland/     https://static-candidates.democracyclub.org.uk/media/images/images/18160.png   profile-photo KarenRowlandRDG https://www.facebook.com/KarenRowlandRDG/?ref=settings 2016-05-05 0 0           PP53 when I'm hungry- anything will do! 0
9178 9178 18171 Matt Harrison Mr.       local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002333 Tilehurst             https://static-candidates.democracyclub.org.uk/media/images/images/18171.png   copyright-assigned Voteforharrison   2016-05-05 0 0           PP53   0
9179 9179 18172 Stephen George James         local.reading.2016-05-05 20 party:85 UK Independence Party (UKIP) UTW:E05002333 Tilehurst                       2016-05-05 0 0           PP85   0
9180 9180 18174 Robert Vickers         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002333 Tilehurst                       2016-05-05 0 0           PP52   0
9181 9181 18175 Richard Black         local.reading.2016-05-05 20 party:63 Green Party UTW:E05002334 Whitley                       2016-05-05 0 0           PP63   0
9182 9182 18176 Roy Haines     Male   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002334 Whitley     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0
9183 9183 18177 James Kiriamiti         local.reading.2016-05-05 20 party:52 Conservative and Unionist Party UTW:E05002334 Whitley                       2016-05-05 0 0           PP52   0
9184 9184 18178 Emmett McKenna         local.reading.2016-05-05 20 party:53 Labour Party UTW:E05002334 Whitley   1.0                   2016-05-05 0 0           PP53   0
9185 9185 19111 Mark Cole     Male   local.reading.2016-05-05 20 party:90 Liberal Democrats UTW:E05002331 Southcote     http://readinglibdems.org.uk/2016/04/16/announcing-2016-local-election-candidates-manifesto/ http://www.readinglibdems.org.uk/               2016-05-05 0 0           PP90   0

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.446ms · Data license: CC-BY-SA · Data source: Democracy Club