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
12390 502 Zac Goldsmith     male 1975-01-20 59 party:52 Conservative and Unionist Party mayor:london Mayor of London     https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Goldsmith_Zac.aspx http://www.zacgoldsmith.com/ https://en.wikipedia.org/wiki/Zac_Goldsmith   https://static-candidates.democracyclub.org.uk/media/images/55351f40b247335574a42e7e.png   other andylolz License: Creative Commons Attribution 2.0 Generic license Source: https://commons.wikimedia.org/wiki/File:Zac_Goldsmith_KewGardens.jpg Author: Annie Mole 2016-05-05 0 0       uk.org.publicwhip/person/uk.org.publicwhip/person/24911 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/24911 PP52 Chocolate digestive 0
12391 1551 Paul Golding     male   59 party:2214 Britain First mayor:london Mayor of London     https://www.britainfirst.org/people/paul-golding/   https://en.wikipedia.org/wiki/Paul_Golding https://uk.linkedin.com/in/paul-golding-410426ab https://static-candidates.democracyclub.org.uk/media/images/images/7927.png   profile-photo carlc Facebook profile photo: https://www.facebook.com/people/Paul-Golding/100009362546312 2016-05-05 0 0   7927;7963       PP2214   0
12392 3068 Dave Furness     male 1966.0 59 party:3960 British National Party mayor:london Mayor of London     https://bnp.org.uk/bnp-candidate-david-furness/       https://static-candidates.democracyclub.org.uk/media/images/images/3068.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=784900120563290112 2016-05-05 0 0   7926;34739       PP3960   0
12393 4754 George Galloway     male 1954-08-16 59 party:362 The Respect Party mayor:london Mayor of London       http://georgegalloway.com/v2/ https://en.wikipedia.org/wiki/George_Galloway   https://static-candidates.democracyclub.org.uk/media/images/54b9e5cfcb19ebca71e2af6e.png         2016-05-05 0 0   1175.0   uk.org.publicwhip/person/uk.org.publicwhip/person/10218 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/10218 PP362   0
12394 7455 Sadiq Khan     male 1970-10-08 59 party:53 Labour Party mayor:london Mayor of London   1.0 http://www.sadiq.london/ http://www.sadiqkhan.org.uk/ https://en.wikipedia.org/wiki/Sadiq_Khan   https://static-candidates.democracyclub.org.uk/media/images/images/7455.png   other tfgg From https://en.wikipedia.org/wiki/Sadiq_Khan#/media/File:Sadiq_Khan.jpg , under OGL 2016-05-05 0 0   3385.0   uk.org.publicwhip/person/uk.org.publicwhip/person/11878 http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/11878 PP53 Chocolate Hobnob 0
12395 7456 Caroline Pidgeon   MBE female 1972-09-29 59 party:90 Liberal Democrats mayor:london Mayor of London     http://www.londonlibdems.org.uk/caroline_pidgeon http://www.carolinepidgeon.org/ https://en.wikipedia.org/wiki/Caroline_Pidgeon   https://static-candidates.democracyclub.org.uk/media/images/images/7456.png   profile-photo j0e_m Caroline's official twitter directed me to this photo. https://twitter.com/CarolinePidgeon/status/706872961538658304 2016-05-05 0 0   2173;7853       PP90   0
12396 7457 Peter Whittle     male 1961-01-06 59 party:85 UK Independence Party (UKIP) mayor:london Mayor of London       http://www.peterwhittle.london/ https://en.wikipedia.org/wiki/Peter_Whittle_(British_politician)   https://static-candidates.democracyclub.org.uk/media/images/images/7457.png   profile-photo tfgg From www.peterwhittle.london 2016-05-05 0 0   4936.0       PP85   0
12397 7545 Sophie Walker     Female 1971-05-27 59 party:2755 Women's Equality Party mayor:london Mayor of London     http://www.womensequality.org.uk/shipley_announcement   https://en.wikipedia.org/wiki/Sophie_Walker https://www.linkedin.com/in/sophie-walker-2117a847 https://static-candidates.democracyclub.org.uk/media/images/images/7545.png   profile-photo louisecrow   2016-05-05 0 0           PP2755   0
12398 7647 John Zylinski Prince   male 1951.0 59 ynmp-party:2 Independent mayor:london Mayor of London       http://www.zylinski.london     https://static-candidates.democracyclub.org.uk/media/images/images/7647.png   profile-photo carlc Official photo from facebook: https://www.facebook.com/JanZylinskiUK/photos/a.761385753974837.1073741827.761383517308394/874783709301707/?type=3&theater 2016-05-05 0 0           ynmp-party:2   0
12399 7677 Lee Harris     male 1936.0 59 party:2552 Cannabis is Safer than Alcohol mayor:london Mayor of London     http://cista.org/candidates/34 http://lee4mayor.com https://en.wikipedia.org/wiki/Lee_Harris_(South_African_artist)   https://static-candidates.democracyclub.org.uk/media/images/images/7677.png   profile-photo Zhyl Used on his Twitter 2016-05-05 0 0           PP2552   0
12400 7928 Ankit Love     male 1983-08-07 59 party:2838 One Love Party mayor:london Mayor of London     http://oneloveparty.eu/london2016 http://ankitlove.com/   https://www.linkedin.com/in/ankit-love-58085372 https://static-candidates.democracyclub.org.uk/media/images/images/7928.png   profile-photo carlc Facebook Page profile photo:https://www.facebook.com/ankitlove/?pnref=story 2016-05-05 0 0           PP2838   0
12401 34835 Siân Berry     female 1974-07-09 59 party:63 Green Party mayor:london Mayor of London     https://my.greenparty.org.uk/candidates/106004 http://sianberry.london/ https://en.wikipedia.org/wiki/Si%C3%A2n_Berry https://www.linkedin.com/in/sian-berry-23917524/ https://static-candidates.democracyclub.org.uk/media/images/images/7452.png   public-domain tfgg Declared public domain here https://en.wikipedia.org/wiki/Si%C3%A2n_Berry#/media/File:Sian_berry.jpg 2016-05-05 0 0   7452.0       PP63   0
Powered by Datasette · Query took 0.481ms