Data license: CC-BY-SA · Data source: Democracy Club
This data as JSON, CSV (advanced)
Suggested facets: gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, facebook_personal_url, homepage_url, wikipedia_url, linkedin_url, image_copyright, image_uploading_user, image_uploading_user_notes, twitter_user_id, old_person_ids, party_ec_id
| Link | rowid | id | name | honorific_prefix | honorific_suffix | gender | birth_date | election | party_id | party_name | post_id | post_label | mapit_url | elected | twitter_username | facebook_page_url | party_ppc_page_url | facebook_personal_url | homepage_url | wikipedia_url | linkedin_url | image_url | proxy_image_url_template | image_copyright | image_uploading_user | image_uploading_user_notes | twitter_user_id | election_date | election_current | party_lists_in_use | party_list_position | old_person_ids | gss_code | parlparse_id | theyworkforyou_url | party_ec_id | favourite_biscuits | cancelled_poll | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11115 | 11115 | 2869 | Spencer Pitfield | male | parl.2016-05-05 43 | party:52 | Conservative and Unionist Party | 65601 | Sheffield Brightside and Hillsborough | spencer@spencerpitfield.co.uk | SpencerPitfield | https://static-candidates.democracyclub.org.uk/media/images/images/2869.png | profile-photo | Auto imported from Twitter | 74966852 | 2016-05-05 | 0 | 0 | 19651.0 | PP52 | 0 | ||||||||||||||||||
| 11116 | 11116 | 4457 | Chris Elmore | MP | male | 1983.0 | parl.2016-05-05 43 | party:53 | Labour Party | 66107 | Ogmore | 1.0 | christopher.elmore@yahoo.co.uk | CPJElmore | https://www.facebook.com/ChrisElmoreMP | 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 | 169898513 | 2016-05-05 | 0 | 0 | 19643;34145 | PP53 | 0 | |||||||||||||
| 11117 | 11117 | 5592 | Glenda Marie Davies | female | parl.2016-05-05 43 | party:85 | UK Independence Party (UKIP) | 66107 | Ogmore | glendamdavies@ukipbridgend.org | https://www.facebook.com/ukipabno | https://www.facebook.com/glenda.m.davies?fref=ts | 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 | 11118 | 6320 | Janet Ellard | female | parl.2016-05-05 43 | party:90 | Liberal Democrats | 66107 | Ogmore | janet.ellard@live.co.uk | 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 | 11119 | 6749 | Steven Winstone | male | 1974.0 | parl.2016-05-05 43 | party:85 | UK Independence Party (UKIP) | 65601 | Sheffield Brightside and Hillsborough | Steve.winstone@gmail.com | steven_winstone | 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 | 2798125167 | 2016-05-05 | 0 | 0 | 12476;19654;34952 | PP85 | 0 | |||||||||||||||
| 11120 | 11120 | 6930 | Christine Gilligan | Female | parl.2016-05-05 43 | party:63 | Green Party | 65601 | Sheffield Brightside and Hillsborough | christinegilligankubo@sheffieldgreenparty.org.uk | SheffieldGreens | https://www.facebook.com/SheffieldGreenParty/ | 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 | 78740575 | 2016-05-05 | 0 | 0 | 12389;19648 | PP63 | 0 | |||||||||||||||
| 11121 | 11121 | 7292 | Bobby Elmo Smith | male | 1982.0 | parl.2016-05-05 43 | party:2641 | Give Me Back Elmo | 65601 | Sheffield Brightside and Hillsborough | givemebackelmo@outlook.com | https://www.facebook.com/givemebackelmo?fref=ts | http://facebook.com/givemebackelmo | 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 | 11122 | 12326 | Shaffaq Mohammed | male | 1972.0 | parl.2016-05-05 43 | party:90 | Liberal Democrats | 65601 | Sheffield Brightside and Hillsborough | shaffaq@talk21.com | shaffaqmohd | https://static-candidates.democracyclub.org.uk/media/images/images/12326.png | profile-photo | Auto imported from Twitter | 529961793 | 2016-05-05 | 0 | 0 | 19650.0 | PP90 | 0 | |||||||||||||||||
| 11123 | 11123 | 19644 | Abi Thomas | Female | 1972.0 | parl.2016-05-05 43 | party:77 | Plaid Cymru - The Party of Wales | 66107 | Ogmore | Abithomas | https://www.facebook.com/abithomas.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 | 2591323712 | 2016-05-05 | 0 | 0 | PP77 | 0 | |||||||||||||||||
| 11124 | 11124 | 19646 | Alex Williams | Male | 1984.0 | parl.2016-05-05 43 | party:52 | Conservative and Unionist Party | 66107 | Ogmore | https://www.facebook.com/OgmoreConservatives/ | 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 | 11125 | 19647 | Gill Furniss | Female | 1957.0 | parl.2016-05-05 43 | party:53 | Labour Party | 65601 | Sheffield Brightside and Hillsborough | 1.0 | gill_furniss@labour.org.uk | GillFurnissMP | https://www.facebook.com/GillFurnissSheffield/ | 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/ | 700732124299714560 | 2016-05-05 | 0 | 0 | 34169.0 | PP53 | 0 | ||||||||||||
| 11126 | 11126 | 19649 | Stevie Shaun Manion | male | parl.2016-05-05 43 | party:2120 | Yorkshire First | 65601 | Sheffield Brightside and Hillsborough | campaigns@yorkshirefirst.org.uk | 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 |
JSON shape: default, array, newline-delimited
CREATE TABLE "candidates" (
"id" INTEGER,
"name" TEXT,
"honorific_prefix" REAL,
"honorific_suffix" REAL,
"gender" TEXT,
"birth_date" REAL,
"election" INTEGER,
"party_id" TEXT,
"party_name" TEXT,
"post_id" TEXT,
"post_label" TEXT,
"mapit_url" INTEGER,
"elected" REAL,
"email" TEXT,
"twitter_username" REAL,
"facebook_page_url" REAL,
"party_ppc_page_url" REAL,
"facebook_personal_url" REAL,
"homepage_url" REAL,
"wikipedia_url" REAL,
"linkedin_url" REAL,
"image_url" REAL,
"proxy_image_url_template" INTEGER,
"image_copyright" REAL,
"image_uploading_user" REAL,
"image_uploading_user_notes" REAL,
"twitter_user_id" INTEGER,
"election_date" TEXT,
"election_current" INTEGER,
"party_lists_in_use" INTEGER,
"party_list_position" INTEGER,
"old_person_ids" REAL,
"gss_code" INTEGER,
"parlparse_id" REAL,
"theyworkforyou_url" REAL,
"party_ec_id" TEXT,
"favourite_biscuits" REAL,
"cancelled_poll" INTEGER
,
FOREIGN KEY ("election") REFERENCES [election](id))