Data license: CC-BY-SA · Data source: Democracy Club
This data as JSON, CSV (advanced)
Suggested facets: honorific_prefix, gender, birth_date, party_id, party_name, email, twitter_username, facebook_page_url, homepage_url, wikipedia_url, image_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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10156 | 10156 | 779 | Tom Baldwin | male | 1983-06-21 | mayor.bristol.2016-05-05 35 | party:804 | Trade Unionist and Socialist Coalition | mayor:bristol | Mayor of Bristol | tomobaldwin@gmail.com | TomAgainstCuts | https://www.facebook.com/TUSCBristol | https://static-candidates.democracyclub.org.uk/media/images/55042aef1b7be75c206f17d6.png | 921316777 | 2016-05-05 | 0 | 0 | 7713.0 | PP804 | 0 | ||||||||||||||||||
| 10157 | 10157 | 5408 | Tony Dyer | Mr | male | 1964-10-04 | mayor.bristol.2016-05-05 35 | party:63 | Green Party | mayor:bristol | Mayor of Bristol | tony.dyer@greenparty.org.uk | TonyDDyer | https://www.facebook.com/TonyDyerforBristolSouth | https://my.greenparty.org.uk/candidates/105855 | https://www.facebook.com/tony.dyer.946 | http://www.bristolgreenparty.org.uk/tony-dyer-for-bristol-south1?p=859 | https://static-candidates.democracyclub.org.uk/media/images/5516cb55929f1bbe286be039.png | profile-photo | TonyDyer | 23225946 | 2016-05-05 | 0 | 0 | 34438.0 | PP63 | 0 | ||||||||||||
| 10158 | 10158 | 6857 | Paul Anthony Turner | Male | mayor.bristol.2016-05-05 35 | party:85 | UK Independence Party (UKIP) | mayor:bristol | Mayor of Bristol | paul.turner@ukiplocal.org | https://static-candidates.democracyclub.org.uk/media/images/5526409759bbc5c063445b5a.png | profile-photo | JPCarrington | As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-a-b.html | 2016-05-05 | 0 | 0 | 10485.0 | PP85 | 0 | |||||||||||||||||||
| 10159 | 10159 | 7715 | Kay Barnard | Dr | mayor.bristol.2016-05-05 35 | party:90 | Liberal Democrats | mayor:bristol | Mayor of Bristol | kay@bristollibdems.org | Kay_Barnard | http://www.facebook.com/Kay4Mayor | http://www.kaybarnard.org | https://static-candidates.democracyclub.org.uk/media/images/images/7715.png | profile-photo | Thomoli | 798883908 | 2016-05-05 | 0 | 0 | PP90 | 0 | |||||||||||||||||
| 10160 | 10160 | 7716 | George Ferguson | male | 1947-03-22 | mayor.bristol.2016-05-05 35 | party:2611 | Bristol First | mayor:bristol | Mayor of Bristol | GeorgeFergusonx | https://en.wikipedia.org/wiki/George_Ferguson_(politician) | https://static-candidates.democracyclub.org.uk/media/images/images/7716.png | other | j0e_m | Maltaman67 • CC BY-SA 4.0 (via wikipedia) | 448938496 | 2016-05-05 | 0 | 0 | PP2611 | 0 | |||||||||||||||||
| 10161 | 10161 | 7717 | John Langley | male | 1956.0 | mayor.bristol.2016-05-05 35 | ynmp-party:2 | Independent | mayor:bristol | Mayor of Bristol | https://static-candidates.democracyclub.org.uk/media/images/images/7717.png | profile-photo | yanbad13257 | 2016-05-05 | 0 | 0 | ynmp-party:2 | 0 | |||||||||||||||||||||
| 10162 | 10162 | 7718 | Charles Lucas | male | mayor.bristol.2016-05-05 35 | party:52 | Conservative and Unionist Party | mayor:bristol | Mayor of Bristol | info@bsgconservatives.com | Clrcharleslucas | http://www.charleslucas4mayor.co.uk/ | https://static-candidates.democracyclub.org.uk/media/images/images/7718.png | profile-photo | Auto imported from Twitter | 1435229688 | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||
| 10163 | 10163 | 7719 | Marvin Johnathan Rees | male | mayor.bristol.2016-05-05 35 | party:53 | Labour Party | mayor:bristol | Mayor of Bristol | 1.0 | marvinformayor@gmail.com | MarvinJRees | https://www.facebook.com/Marvin-Rees-for-Mayor-of-Bristol-473589042789807/ | http://www.marvinrees.co.uk/ | https://en.wikipedia.org/wiki/Marvin_Rees | https://static-candidates.democracyclub.org.uk/media/images/images/7719.png | profile-photo | Auto imported from Twitter | 217992827 | 2016-05-05 | 0 | 0 | PP53 | 0 | |||||||||||||||
| 10164 | 10164 | 7720 | Paul Saville | mayor.bristol.2016-05-05 35 | ynmp-party:2 | Independent | mayor:bristol | Mayor of Bristol | 2016-05-05 | 0 | 0 | ynmp-party:2 | 0 | ||||||||||||||||||||||||||
| 10165 | 10165 | 7721 | Christine Charlotte Townsend | female | mayor.bristol.2016-05-05 35 | ynmp-party:2 | Independent | mayor:bristol | Mayor of Bristol | IfBChristine | https://static-candidates.democracyclub.org.uk/media/images/images/7721.png | profile-photo | j0e_m | twitter profile photo @IfBChristine | 1247242782 | 2016-05-05 | 0 | 0 | ynmp-party:2 | 0 | |||||||||||||||||||
| 10166 | 10166 | 10431 | Stoney Garnett | male | mayor.bristol.2016-05-05 35 | ynmp-party:2 | Independent | mayor:bristol | Mayor of Bristol | 2016-05-05 | 0 | 0 | ynmp-party:2 | 0 | |||||||||||||||||||||||||
| 10167 | 10167 | 10622 | Tony Britt | Male | 1968.0 | mayor.bristol.2016-05-05 35 | ynmp-party:2 | Independent | mayor:bristol | Mayor of Bristol | http://mayorbritt.co.uk/ | https://static-candidates.democracyclub.org.uk/media/images/images/10622.png | profile-photo | j0e_m | http://mayorbritt.co.uk/photos/ | 2016-05-05 | 0 | 0 | ynmp-party:2 | 0 | |||||||||||||||||||
| 10168 | 10168 | 10623 | Mayor Festus Kudehinbu | Male | mayor.bristol.2016-05-05 35 | ynmp-party:2 | Independent | mayor:bristol | Mayor of Bristol | https://www.facebook.com/Mayor-Festus-Kudehinbu-540999166081550/ | https://static-candidates.democracyclub.org.uk/media/images/images/10623.png | profile-photo | j0e_m | facebook photo: https://www.facebook.com/540999166081550/photos/a.541012132746920.1073741825.540999166081550/545432552304878/?type=3&theater | 2016-05-05 | 0 | 0 | ynmp-party:2 | 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))