home / democracyclub

democracyclub

Custom SQL query returning 73 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
11039 72 Ann Myatt     female   41 party:52 Conservative and Unionist Party DIW:E05003245 Hawkshead     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Myatt_Ann.aspx http://www.annmyatt.co.uk/about-ann/     https://static-candidates.democracyclub.org.uk/media/images/5481e78cb150e238702c0540.png   profile-photo     2016-05-05 0 0   15996.0       PP52   0
11040 4640 Chris Loynes     male 1952-09-12 41 party:63 Green Party DIW:E05003269 Ulverston Central     http://northwest.greenparty.org.uk/elections-2015.html       https://static-candidates.democracyclub.org.uk/media/images/553c977fe22f98bc5d30fa57.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/LoynesGreen 2016-05-05 0 0   4051.0       PP63   0
11041 5299 Robert O'Hara     male   41 party:63 Green Party DIW:E05003274 Ulverston West     https://my.greenparty.org.uk/candidates/105797       https://static-candidates.democracyclub.org.uk/media/images/5525efa4413cb4432adffa5b.png   profile-photo JPCarrington Used on party PPC page https://my.greenparty.org.uk/candidates/105797 2016-05-05 0 0   14694;34903       PP63   0
11042 5633 Loraine Birchall     female 1968-03-24 41 party:90 Liberal Democrats DIW:E05003272 Ulverston South     http://www.libdems.org.uk/_loraine_birchall       https://static-candidates.democracyclub.org.uk/media/images/5518407f249b917507bee579.png   profile-photo ljpfontana https://www.facebook.com/loraine.birchall 2016-05-05 0 0   34224.0       PP90   0
11043 6412 Stan Collins     male   41 party:90 Liberal Democrats DIW:E05003268 Staveley-in-Westmorland   1.0 http://www.libdems.org.uk/stan_collins       https://static-candidates.democracyclub.org.uk/media/images/55489ec991b24e48149a5d18.png   profile-photo andylolz From party PPC page: http://www.libdems.org.uk/stan_collins 2016-05-05 0 0   394.0       PP90   0
11044 7171 Alan Piper     male 1953-03-30 41 party:85 UK Independence Party (UKIP) DIW:E05003236 Arnside and Beetham           https://uk.linkedin.com/pub/alan-piper/8/842/634 https://static-candidates.democracyclub.org.uk/media/images/images/7171.png   profile-photo yanbad13257   2016-05-05 0 0   15247.0       PP85   0
11045 14691 Bob Brown         41 party:53 Labour Party DIW:E05003274 Ulverston West                       2016-05-05 0 0           PP53   0
11046 14692 Gordon Ellis Brown         41 party:90 Liberal Democrats DIW:E05003274 Ulverston West                       2016-05-05 0 0           PP90   0
11047 14693 Janette Ethel Jenkinson         41 party:52 Conservative and Unionist Party DIW:E05003274 Ulverston West   1.0                   2016-05-05 0 0           PP52   0
11048 15245 Jill Abel         41 party:63 Green Party DIW:E05003236 Arnside and Beetham                       2016-05-05 0 0           PP63   0
11049 15246 Pete McSweeney         41 party:90 Liberal Democrats DIW:E05003236 Arnside and Beetham   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/15246.png   profile-photo fbrc https://www.facebook.com/WestmorlandAndLonsdaleLibDems/photos/982726281928562/ 2016-05-05 0 0           PP90   0
11050 15248 Peter Smillie         41 party:52 Conservative and Unionist Party DIW:E05003236 Arnside and Beetham                       2016-05-05 0 0           PP52   0
11051 15249 Lois Katherine Sparling         41 party:53 Labour Party DIW:E05003236 Arnside and Beetham                       2016-05-05 0 0           PP53   0
11052 15250 Kate Barkes         41 party:63 Green Party DIW:E05003263 Lyth Valley                       2016-05-05 0 0           PP63   0
11053 15251 Bex Cooper         41 party:90 Liberal Democrats DIW:E05003263 Lyth Valley                       2016-05-05 0 0           PP90   0
11054 15252 Alison Faith Gilchrist         41 party:53 Labour Party DIW:E05003263 Lyth Valley                       2016-05-05 0 0           PP53   0
11055 15253 John Holmes         41 party:52 Conservative and Unionist Party DIW:E05003263 Lyth Valley   1.0                   2016-05-05 0 0           PP52   0
11056 15254 Stephen Willmott         41 party:85 UK Independence Party (UKIP) DIW:E05003263 Lyth Valley                       2016-05-05 0 0           PP85   0
11057 15979 Roger Kenneth Bingham         41 party:52 Conservative and Unionist Party DIW:E05003239 Burton and Holme   1.0                   2016-05-05 0 0           PP52   0
11058 15980 Andrew Robert Chapple         41 party:63 Green Party DIW:E05003239 Burton and Holme                       2016-05-05 0 0           PP63   0
11059 15981 Gordon Victor Higton         41 party:90 Liberal Democrats DIW:E05003239 Burton and Holme                       2016-05-05 0 0           PP90   0
11060 15982 Nigel Edward Warner         41 party:53 Labour Party DIW:E05003239 Burton and Holme                       2016-05-05 0 0           PP53   0
11061 15983 Anne Hall         41 party:52 Conservative and Unionist Party DIW:E05003241 Coniston and Crake Valley   1.0                   2016-05-05 0 0           PP52   0
11062 15984 Mark Kidd         41 party:63 Green Party DIW:E05003241 Coniston and Crake Valley                       2016-05-05 0 0           PP63   0
11063 15985 Val Sykes         41 party:90 Liberal Democrats DIW:E05003241 Coniston and Crake Valley                       2016-05-05 0 0           PP90   0
11064 15987 Sheila Eccles         41 party:90 Liberal Democrats DIW:E05003242 Crooklands   1.0                   2016-05-05 0 0           PP90   0
11065 15988 Meg Hill         41 party:63 Green Party DIW:E05003242 Crooklands                       2016-05-05 0 0           PP63   0
11066 15989 David Matthews         41 party:52 Conservative and Unionist Party DIW:E05003242 Crooklands                       2016-05-05 0 0           PP52   0
11067 15990 Malcolm James Hamilton Nightingale         41 party:85 UK Independence Party (UKIP) DIW:E05003242 Crooklands                       2016-05-05 0 0           PP85   0
11068 15994 David William Norman Fletcher         41 party:90 Liberal Democrats DIW:E05003245 Hawkshead   1.0                   2016-05-05 0 0           PP90   0
11069 15995 Gwen Harrison     female   41 party:63 Green Party DIW:E05003245 Hawkshead                       2016-05-05 0 0           PP63   0
11070 15997 David Rimmer Walker         41 party:85 UK Independence Party (UKIP) DIW:E05003245 Hawkshead                       2016-05-05 0 0           PP85   0
11071 16002 Dave Cope         41 party:53 Labour Party DIW:E05003261 Levens                       2016-05-05 0 0           PP53   0
11072 16003 Yana Doidge         41 party:85 UK Independence Party (UKIP) DIW:E05003261 Levens                       2016-05-05 0 0           PP85   0
11073 16004 Kevin Ronald Holmes         41 party:52 Conservative and Unionist Party DIW:E05003261 Levens                       2016-05-05 0 0           PP52   0
11074 16005 Annie Rawlinson         41 party:90 Liberal Democrats DIW:E05003261 Levens   1.0                   2016-05-05 0 0           PP90   0
11075 16006 Claire Wickham         41 party:63 Green Party DIW:E05003261 Levens                       2016-05-05 0 0           PP63   0
11076 16009 Rupert James Audland         41 party:90 Liberal Democrats DIW:E05003265 Milnthorpe   1.0                   2016-05-05 0 0           PP90   0
11077 16010 Steven Hurst         41 party:52 Conservative and Unionist Party DIW:E05003265 Milnthorpe                       2016-05-05 0 0           PP52   0
11078 16011 Shona Kathleen Kidd         41 party:63 Green Party DIW:E05003265 Milnthorpe                       2016-05-05 0 0           PP63   0
11079 16012 Jo Magne         41 party:53 Labour Party DIW:E05003265 Milnthorpe                       2016-05-05 0 0           PP53   0
11080 16013 Oksana Walker         41 party:85 UK Independence Party (UKIP) DIW:E05003265 Milnthorpe                       2016-05-05 0 0           PP85   0
11081 16014 Nick Cotton         41 party:90 Liberal Democrats DIW:E05003266 Sedbergh and Kirkby Lonsdale   1.0                   2016-05-05 0 0           PP90   0
11082 16015 Nick Cross         41 party:53 Labour Party DIW:E05003266 Sedbergh and Kirkby Lonsdale                       2016-05-05 0 0           PP53   0
11083 16016 Daphne Mary Jackson         41 party:63 Green Party DIW:E05003266 Sedbergh and Kirkby Lonsdale                       2016-05-05 0 0           PP63   0
11084 16017 Alex Toubas         41 party:52 Conservative and Unionist Party DIW:E05003266 Sedbergh and Kirkby Lonsdale                       2016-05-05 0 0           PP52   0
11085 16019 Ben John Barker         41 party:63 Green Party DIW:E05003267 Staveley-in-Cartmel                       2016-05-05 0 0           PP63   0
11086 16020 Sue Sanderson         41 party:90 Liberal Democrats DIW:E05003267 Staveley-in-Cartmel   1.0                   2016-05-05 0 0           PP90   0
11087 16021 Brian Donald Thornton         41 party:85 UK Independence Party (UKIP) DIW:E05003267 Staveley-in-Cartmel                       2016-05-05 0 0           PP85   0
11088 16022 Ted Walsh         41 party:52 Conservative and Unionist Party DIW:E05003267 Staveley-in-Cartmel                       2016-05-05 0 0           PP52   0
11089 16031 Fran Richardson         41 party:63 Green Party DIW:E05003268 Staveley-in-Westmorland                       2016-05-05 0 0           PP63   0
11090 16032 Harry Taylor         41 party:52 Conservative and Unionist Party DIW:E05003268 Staveley-in-Westmorland                       2016-05-05 0 0   31720.0       PP52   0
11091 16033 Albina Thornton         41 party:85 UK Independence Party (UKIP) DIW:E05003268 Staveley-in-Westmorland                       2016-05-05 0 0           PP85   0
11092 16034 Peter Train         41 party:53 Labour Party DIW:E05003268 Staveley-in-Westmorland                       2016-05-05 0 0           PP53   0
11093 16035 Norman Bishop-Rowe         41 party:52 Conservative and Unionist Party DIW:E05003269 Ulverston Central   1.0                   2016-05-05 0 0           PP52   0
11094 16036 Andrew Hudson         41 party:90 Liberal Democrats DIW:E05003269 Ulverston Central                       2016-05-05 0 0           PP90   0
11095 16037 Bharath Sundara Rajan         41 party:53 Labour Party DIW:E05003269 Ulverston Central                       2016-05-05 0 0           PP53   0
11096 16041 Judith Ann Filmore         41 party:63 Green Party DIW:E05003270 Ulverston East                       2016-05-05 0 0           PP63   0
11097 16042 Peter Hornby         41 party:52 Conservative and Unionist Party DIW:E05003270 Ulverston East                       2016-05-05 0 0           PP52   0
11098 16043 Maureen Frances Nicholson         41 party:90 Liberal Democrats DIW:E05003270 Ulverston East                       2016-05-05 0 0           PP90   0
11099 16044 Mark Wilson         41 party:53 Labour Party DIW:E05003270 Ulverston East   1.0                   2016-05-05 0 0           PP53   0
11100 16050 Ray Beecham         41 party:90 Liberal Democrats DIW:E05003271 Ulverston North                       2016-05-05 0 0           PP90   0
11101 16051 Simon James Filmore         41 party:63 Green Party DIW:E05003271 Ulverston North                       2016-05-05 0 0           PP63   0
11102 16052 Helen Irving         41 party:52 Conservative and Unionist Party DIW:E05003271 Ulverston North   1.0                   2016-05-05 0 0           PP52   0
11103 16053 Judith Ann Pickthall         41 party:53 Labour Party DIW:E05003271 Ulverston North                       2016-05-05 0 0           PP53   0
11104 16059 Joan Margaret Casson         41 party:53 Labour Party DIW:E05003272 Ulverston South                       2016-05-05 0 0           PP53   0
11105 16060 Bob Gerry         41 party:63 Green Party DIW:E05003272 Ulverston South                       2016-05-05 0 0           PP63   0
11106 16061 Peter Richards         41 party:85 UK Independence Party (UKIP) DIW:E05003272 Ulverston South                       2016-05-05 0 0           PP85   0
11107 16062 Amanda Rigg         41 party:52 Conservative and Unionist Party DIW:E05003272 Ulverston South   1.0                   2016-05-05 0 0           PP52   0
11108 16067 Reuben Allonby         41 party:52 Conservative and Unionist Party DIW:E05003273 Ulverston Town                       2016-05-05 0 0           PP52   0
11109 16068 John Victor Clough         41 party:53 Labour Party DIW:E05003273 Ulverston Town   1.0                   2016-05-05 0 0           PP53   0
11110 16069 Dave Khan         41 party:90 Liberal Democrats DIW:E05003273 Ulverston Town                       2016-05-05 0 0           PP90   0
11111 16070 Bill Shaw         41 party:63 Green Party DIW:E05003273 Ulverston Town                       2016-05-05 0 0           PP63   0
Powered by Datasette · Query took 0.866ms