This data as .json
| 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8322 | 2181 | James Blanchard | Mr | male | 1977.0 | 8 | party:90 | Liberal Democrats | police:north-yorkshire | Police and Crime Commissioner for North Yorkshire Police | jamesblanchard@yahoo.com | jamesblanchard | https://www.facebook.com/jamesblanchardyork | http://www.libdems.org.uk/james_blanchard_pcc | https://www.facebook.com/jamesblancharduk | http://jamesblanchard.lib.dm/ | https://static-candidates.democracyclub.org.uk/media/images/553c9e76dcfe1d5b5cf81469.png | profile-photo | edent | This is the candidate’s twitter profile image, from https://twitter.com/jamesblanchard | 35795737 | 2016-05-05 | 0 | 0 | 5058.0 | PP90 | 0 |
