home / democracyclub

democracyclub

Custom SQL query returning 12 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
11115 2869 Spencer Pitfield     male   43 party:52 Conservative and Unionist Party 65601 Sheffield Brightside and Hillsborough             https://static-candidates.democracyclub.org.uk/media/images/images/2869.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   19651.0       PP52   0
11116 4457 Chris Elmore   MP male 1983.0 43 party:53 Labour Party 66107 Ogmore   1.0 http://www.labour.org.uk/people/detail/chris-elmore   https://en.wikipedia.org/wiki/Chris_Elmore   https://static-candidates.democracyclub.org.uk/media/images/5481e8a7b150e238702c05e9.png   profile-photo     2016-05-05 0 0   19643;34145       PP53   0
11117 5592 Glenda Marie Davies     female   43 party:85 UK Independence Party (UKIP) 66107 Ogmore       http://www.ukipbridgend.org/     https://static-candidates.democracyclub.org.uk/media/images/55256525413cb4432adffa42.png   profile-photo JSmith   2016-05-05 0 0   9153;19641       PP85   0
11118 6320 Janet Ellard     female   43 party:90 Liberal Democrats 66107 Ogmore     http://www.libdems.org.uk/janet_ellard       https://static-candidates.democracyclub.org.uk/media/images/5548ad5ae2efb2432db96524.png   profile-photo andylolz From party PPC page: http://www.libdems.org.uk/janet_ellard 2016-05-05 0 0   19642;34949       PP90   0
11119 6749 Steven Winstone     male 1974.0 43 party:85 UK Independence Party (UKIP) 65601 Sheffield Brightside and Hillsborough     http://sdpuk.nationbuilder.com/steve_winstone     https://www.linkedin.com/profile/view?id=95182951 https://static-candidates.democracyclub.org.uk/media/images/5517f7fb249b917507bee519.png   profile-photo gerv   2016-05-05 0 0   12476;19654;34952       PP85   0
11120 6930 Christine Gilligan     Female   43 party:63 Green Party 65601 Sheffield Brightside and Hillsborough     https://my.greenparty.org.uk/candidates/106173     https://www.linkedin.com/in/dr-christine-gilligan-232497b/ https://static-candidates.democracyclub.org.uk/media/images/images/6930.png   profile-photo Jagusti   2016-05-05 0 0   12389;19648       PP63   0
11121 7292 Bobby Elmo Smith     male 1982.0 43 party:2641 Give Me Back Elmo 65601 Sheffield Brightside and Hillsborough       http://www.givemebackelmo.co.uk/ http://en.wikipedia.org/wiki/Bobby_Smith_(activist)   https://static-candidates.democracyclub.org.uk/media/images/552cf2433d3371cf3592d9d5.png   public-domain bobby   2016-05-05 0 0   8330;19653       PP2641   0
11122 12326 Shaffaq Mohammed     male 1972.0 43 party:90 Liberal Democrats 65601 Sheffield Brightside and Hillsborough             https://static-candidates.democracyclub.org.uk/media/images/images/12326.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   19650.0       PP90   0
11123 19644 Abi Thomas     Female 1972.0 43 party:77 Plaid Cymru - The Party of Wales 66107 Ogmore             https://static-candidates.democracyclub.org.uk/media/images/images/19644.png   profile-photo j0e_m Facebook photo: https://www.facebook.com/photo.php?fbid=118490355214181&set=a.118490375214179.1073741826.100011596509347&type=3&theater 2016-05-05 0 0           PP77   0
11124 19646 Alex Williams     Male 1984.0 43 party:52 Conservative and Unionist Party 66107 Ogmore     http://www.ogmoreconservatives.org.uk/       https://static-candidates.democracyclub.org.uk/media/images/images/19646.png   profile-photo j0e_m Facebook photo: https://www.facebook.com/OgmoreConservatives/photos/pb.872317006147384.-2207520000.1460935389./900235180022233/?type=3&theater 2016-05-05 0 0           PP52   0
11125 19647 Gill Furniss     Female 1957.0 43 party:53 Labour Party 65601 Sheffield Brightside and Hillsborough   1.0   http://www.gillfurniss.com/ https://en.wikipedia.org/wiki/Gill_Furniss   https://static-candidates.democracyclub.org.uk/media/images/images/19647.png   other j0e_m facebook, twitter and website profile photo https://www.facebook.com/GillFurnissSheffield/ 2016-05-05 0 0   34169.0       PP53   0
11126 19649 Stevie Shaun Manion     male   43 party:2120 Yorkshire First 65601 Sheffield Brightside and Hillsborough     http://www.yorkshirefirst.org.uk/yorkshire_first_sheffield_candidate       https://static-candidates.democracyclub.org.uk/media/images/images/19649.png   profile-photo j0e_m official campaign page photo: http://www.yorkshirefirst.org.uk/yorkshire_first_sheffield_candidate 2016-05-05 0 0           PP2120   0
Powered by Datasette · Query took 0.442ms