home / democracyclub

democracyclub

Custom SQL query returning 70 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
9116 291 Howard Thomas     male   20 party:85 UK Independence Party (UKIP) UTW:E05002324 Kentwood                       2016-05-05 0 0           PP85   0
9117 4523 Jenny Woods Dr   Female   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 4524 Meri O'Connell Ms   Female   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 4857 Emma Warman     female   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 5931 Miriam Kennet     female   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 6780 Neil Adams     male   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 8859 Stephen Graham     male   20 party:54 The Liberal Party UTW:E05002327 Norcot                       2016-05-05 0 0           PP54   0
9123 9020 Kirsten Bayes Ms       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 13944 Syed Abbas     male   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 13945 Louise Keane         20 party:63 Green Party UTW:E05002323 Katesgrove                       2016-05-05 0 0           PP63   0
9126 13946 Margaret McNeill     Female   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 13947 Rose Williams     female   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 15201 Paul Carnell         20 party:52 Conservative and Unionist Party UTW:E05002322 Church                       2016-05-05 0 0           PP52   0
9129 15202 Kathryn McCann         20 party:63 Green Party UTW:E05002322 Church                       2016-05-05 0 0           PP63   0
9130 15203 Eileen McElligott         20 party:53 Labour Party UTW:E05002322 Church   1.0                   2016-05-05 0 0           PP53   0
9131 15204 Ben Thomas     Male   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 16236 Doug Cresswell         20 party:63 Green Party UTW:E05002331 Southcote                       2016-05-05 0 0           PP63   0
9133 16237 Debs Edwards         20 party:53 Labour Party UTW:E05002331 Southcote   1.0                   2016-05-05 0 0           PP53   0
9134 16238 Russell Martin         20 party:52 Conservative and Unionist Party UTW:E05002331 Southcote                       2016-05-05 0 0           PP52   0
9135 18045 John Grout     Male   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 18046 Michael Hey         20 party:52 Conservative and Unionist Party UTW:E05002320 Battle                       2016-05-05 0 0           PP52   0
9137 18047 Gul Khan         20 party:53 Labour Party UTW:E05002320 Battle   1.0                   2016-05-05 0 0           PP53   0
9138 18048 Alan Lockey         20 party:63 Green Party UTW:E05002320 Battle                       2016-05-05 0 0           PP63   0
9139 18049 Tony Page         20 party:53 Labour Party UTW:E05002319 Abbey   1.0                   2016-05-05 0 0           PP53   0
9140 18050 Trevor Slack         20 party:52 Conservative and Unionist Party UTW:E05002319 Abbey                       2016-05-05 0 0           PP52   0
9141 18051 Joe Sylvester         20 party:63 Green Party UTW:E05002319 Abbey                       2016-05-05 0 0           PP63   0
9142 18059 Christopher Burden     Male   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 18060 Richard Davies     male   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 18061 David Foster     male   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 18062 Ed Hogan         20 party:52 Conservative and Unionist Party UTW:E05002321 Caversham                       2016-05-05 0 0           PP52   0
9146 18087 Glenn Goodall Dr   Male   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 18088 Ruth Shaffrey         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 18089 Daya Pal Singh         20 party:53 Labour Party UTW:E05002324 Kentwood   1.0                   2016-05-05 0 0           PP53   0
9149 18099 Isobel Ballsdon         20 party:52 Conservative and Unionist Party UTW:E05002325 Mapledurham ward   1.0                   2016-05-05 0 0           PP52   0
9150 18100 Simon Rogers         20 party:53 Labour Party UTW:E05002325 Mapledurham ward                       2016-05-05 0 0           PP53   0
9151 18101 Brent Smith         20 party:63 Green Party UTW:E05002325 Mapledurham ward                       2016-05-05 0 0           PP63   0
9152 18102 Linda Ann Giles         20 party:85 UK Independence Party (UKIP) UTW:E05002326 Minster                       2016-05-05 0 0           PP85   0
9153 18103 Keith Johnson         20 party:63 Green Party UTW:E05002326 Minster                       2016-05-05 0 0           PP63   0
9154 18104 James Moore     Male 1983-04-13 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 18105 Alanzo Seville         20 party:52 Conservative and Unionist Party UTW:E05002326 Minster                       2016-05-05 0 0           PP52   0
9156 18106 Liz Terry         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 18118 Philip Martin Giles         20 party:85 UK Independence Party (UKIP) UTW:E05002327 Norcot                       2016-05-05 0 0           PP85   0
9158 18119 Jo Lovelock         20 party:53 Labour Party UTW:E05002327 Norcot   1.0                   2016-05-05 0 0           PP53   0
9159 18120 Robert Masterson         20 party:52 Conservative and Unionist Party UTW:E05002327 Norcot                       2016-05-05 0 0           PP52   0
9160 18121 Jon Walls     Male   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 18122 Jill Wigmore-Welsh         20 party:63 Green Party UTW:E05002327 Norcot                       2016-05-05 0 0           PP63   0
9162 18133 Dave Dymond         20 party:53 Labour Party UTW:E05002328 Park                       2016-05-05 0 0           PP53   0
9163 18134 Roland Hazell         20 party:52 Conservative and Unionist Party UTW:E05002328 Park                       2016-05-05 0 0           PP52   0
9164 18135 Brenda McGonigle         20 party:63 Green Party UTW:E05002328 Park   1.0                   2016-05-05 0 0           PP63   0
9165 18136 Rebecca Rye     Female   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 18137 Peter Boardley     Male   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 18138 Sally Newman         20 party:63 Green Party UTW:E05002329 Peppard                       2016-05-05 0 0           PP63   0
9168 18139 Jane Stanford-Beale         20 party:52 Conservative and Unionist Party UTW:E05002329 Peppard   1.0                   2016-05-05 0 0           PP52   0
9169 18140 Leighton Yeo         20 party:53 Labour Party UTW:E05002329 Peppard                       2016-05-05 0 0           PP53   0
9170 18141 Natalie Greenstreet         20 party:52 Conservative and Unionist Party UTW:E05002330 Redlands                       2016-05-05 0 0           PP52   0
9171 18142 Francis Jakeman Rev   Male   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 18143 Tony Jones         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 18144 Kizzi Johannessen     female 1986.0 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 18157 Ed Hopper         20 party:52 Conservative and Unionist Party UTW:E05002332 Thames   1.0                   2016-05-05 0 0           PP52   0
9175 18158 Sarah McNamara         20 party:63 Green Party UTW:E05002332 Thames                       2016-05-05 0 0           PP63   0
9176 18159 Guy Penman     Male   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 18160 Karen Rowland Ms.   female 1961-12-28 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 18171 Matt Harrison Mr.       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 18172 Stephen George James         20 party:85 UK Independence Party (UKIP) UTW:E05002333 Tilehurst                       2016-05-05 0 0           PP85   0
9180 18174 Robert Vickers         20 party:52 Conservative and Unionist Party UTW:E05002333 Tilehurst                       2016-05-05 0 0           PP52   0
9181 18175 Richard Black         20 party:63 Green Party UTW:E05002334 Whitley                       2016-05-05 0 0           PP63   0
9182 18176 Roy Haines     Male   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 18177 James Kiriamiti         20 party:52 Conservative and Unionist Party UTW:E05002334 Whitley                       2016-05-05 0 0           PP52   0
9184 18178 Emmett McKenna         20 party:53 Labour Party UTW:E05002334 Whitley   1.0                   2016-05-05 0 0           PP53   0
9185 19111 Mark Cole     Male   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
Powered by Datasette · Query took 1.001ms