home / democracyclub

democracyclub

Custom SQL query returning 70 rows

Query parameters

rowididnamehonorific_prefixhonorific_suffixgenderbirth_dateelectionparty_idparty_namepost_idmapit_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                     2016-05-05 0 0           PP85   0
9117 4523 Jenny Woods Dr   Female   20 party:90 Liberal Democrats UTW:E05002325     http://www.libdems.org.uk/jenny_woods       https://static-candidates.democracyclub.org.uk/media/images/images/4523.png     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   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     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     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   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     https://my.greenparty.org.uk/candidates/106144   https://en.wikipedia.org/wiki/Miriam_Kennet   https://static-candidates.democracyclub.org.uk/media/images/554877ca05a4783b28981e92.png   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     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                     2016-05-05 0 0           PP54   0
9123 9020 Kirsten Bayes Ms       20 party:90 Liberal Democrats UTW:E05002319     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     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     http://www.readingeastconservatives.com/person/syed-abbas-katesgrove-candidate       https://static-candidates.democracyclub.org.uk/media/images/images/13944.png   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                     2016-05-05 0 0           PP63   0
9126 13946 Margaret McNeill     Female   20 party:90 Liberal Democrats UTW:E05002323     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   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/13947.png   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                     2016-05-05 0 0           PP52   0
9129 15202 Kathryn McCann         20 party:63 Green Party UTW:E05002322                     2016-05-05 0 0           PP63   0
9130 15203 Eileen McElligott         20 party:53 Labour Party UTW:E05002322   1.0                 2016-05-05 0 0           PP53   0
9131 15204 Ben Thomas     Male   20 party:90 Liberal Democrats UTW:E05002322     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                     2016-05-05 0 0           PP63   0
9133 16237 Debs Edwards         20 party:53 Labour Party UTW:E05002331   1.0                 2016-05-05 0 0           PP53   0
9134 16238 Russell Martin         20 party:52 Conservative and Unionist Party UTW:E05002331                     2016-05-05 0 0           PP52   0
9135 18045 John Grout     Male   20 party:90 Liberal Democrats UTW:E05002320     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                     2016-05-05 0 0           PP52   0
9137 18047 Gul Khan         20 party:53 Labour Party UTW:E05002320   1.0                 2016-05-05 0 0           PP53   0
9138 18048 Alan Lockey         20 party:63 Green Party UTW:E05002320                     2016-05-05 0 0           PP63   0
9139 18049 Tony Page         20 party:53 Labour Party UTW:E05002319   1.0                 2016-05-05 0 0           PP53   0
9140 18050 Trevor Slack         20 party:52 Conservative and Unionist Party UTW:E05002319                     2016-05-05 0 0           PP52   0
9141 18051 Joe Sylvester         20 party:63 Green Party UTW:E05002319                     2016-05-05 0 0           PP63   0
9142 18059 Christopher Burden     Male   20 party:90 Liberal Democrats UTW:E05002321     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   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/18060.png     Auto imported from Twitter 2016-05-05 0 0           PP53   0
9144 18061 David Foster     male   20 party:63 Green Party UTW:E05002321     https://reading.greenparty.org.uk/people/david-foster.html       https://static-candidates.democracyclub.org.uk/media/images/images/18061.png     Auto imported from Twitter 2016-05-05 0 0           PP63   0
9145 18062 Ed Hogan         20 party:52 Conservative and Unionist Party UTW:E05002321                     2016-05-05 0 0           PP52   0
9146 18087 Glenn Goodall Dr   Male   20 party:90 Liberal Democrats UTW:E05002324     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     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   1.0                 2016-05-05 0 0           PP53   0
9149 18099 Isobel Ballsdon         20 party:52 Conservative and Unionist Party UTW:E05002325   1.0                 2016-05-05 0 0           PP52   0
9150 18100 Simon Rogers         20 party:53 Labour Party UTW:E05002325                     2016-05-05 0 0           PP53   0
9151 18101 Brent Smith         20 party:63 Green Party UTW:E05002325                     2016-05-05 0 0           PP63   0
9152 18102 Linda Ann Giles         20 party:85 UK Independence Party (UKIP) UTW:E05002326                     2016-05-05 0 0           PP85   0
9153 18103 Keith Johnson         20 party:63 Green Party UTW:E05002326                     2016-05-05 0 0           PP63   0
9154 18104 James Moore     Male 1983-04-13 20 party:90 Liberal Democrats UTW:E05002326     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                     2016-05-05 0 0           PP52   0
9156 18106 Liz Terry         20 joint-party:53-119 Labour and Co-operative Party UTW:E05002326   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                     2016-05-05 0 0           PP85   0
9158 18119 Jo Lovelock         20 party:53 Labour Party UTW:E05002327   1.0                 2016-05-05 0 0           PP53   0
9159 18120 Robert Masterson         20 party:52 Conservative and Unionist Party UTW:E05002327                     2016-05-05 0 0           PP52   0
9160 18121 Jon Walls     Male   20 party:90 Liberal Democrats UTW:E05002327     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                     2016-05-05 0 0           PP63   0
9162 18133 Dave Dymond         20 party:53 Labour Party UTW:E05002328                     2016-05-05 0 0           PP53   0
9163 18134 Roland Hazell         20 party:52 Conservative and Unionist Party UTW:E05002328                     2016-05-05 0 0           PP52   0
9164 18135 Brenda McGonigle         20 party:63 Green Party UTW:E05002328   1.0                 2016-05-05 0 0           PP63   0
9165 18136 Rebecca Rye     Female   20 party:90 Liberal Democrats UTW:E05002328     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     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                     2016-05-05 0 0           PP63   0
9168 18139 Jane Stanford-Beale         20 party:52 Conservative and Unionist Party UTW:E05002329   1.0                 2016-05-05 0 0           PP52   0
9169 18140 Leighton Yeo         20 party:53 Labour Party UTW:E05002329                     2016-05-05 0 0           PP53   0
9170 18141 Natalie Greenstreet         20 party:52 Conservative and Unionist Party UTW:E05002330                     2016-05-05 0 0           PP52   0
9171 18142 Francis Jakeman Rev   Male   20 party:90 Liberal Democrats UTW:E05002330     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   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     https://my.greenparty.org.uk/candidates/106143 https://reading.greenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/18144.png   IanGReeve   2016-05-05 0 0           PP63   0
9174 18157 Ed Hopper         20 party:52 Conservative and Unionist Party UTW:E05002332   1.0                 2016-05-05 0 0           PP52   0
9175 18158 Sarah McNamara         20 party:63 Green Party UTW:E05002332                     2016-05-05 0 0           PP63   0
9176 18159 Guy Penman     Male   20 party:90 Liberal Democrats UTW:E05002332     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     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   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             https://static-candidates.democracyclub.org.uk/media/images/images/18171.png   Voteforharrison   2016-05-05 0 0           PP53   0
9179 18172 Stephen George James         20 party:85 UK Independence Party (UKIP) UTW:E05002333                     2016-05-05 0 0           PP85   0
9180 18174 Robert Vickers         20 party:52 Conservative and Unionist Party UTW:E05002333                     2016-05-05 0 0           PP52   0
9181 18175 Richard Black         20 party:63 Green Party UTW:E05002334                     2016-05-05 0 0           PP63   0
9182 18176 Roy Haines     Male   20 party:90 Liberal Democrats UTW:E05002334     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                     2016-05-05 0 0           PP52   0
9184 18178 Emmett McKenna         20 party:53 Labour Party UTW:E05002334   1.0                 2016-05-05 0 0           PP53   0
9185 19111 Mark Cole     Male   20 party:90 Liberal Democrats UTW:E05002331     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