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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10599 | 6565 | Alex Johnstone | MSP | male | 1961-07-31 | 38 | party:52 | Conservative and Unionist Party | gss:S16000081 | Angus North and Mearns | alex.johnstone@live.co.uk | https://www.facebook.com/AlexJohnstoneBanffandBuchan2015?fref=ts | https://www.conservatives.com/OurTeam/Prospective_Parliamentary_Candidates/Johnstone_Alex_MSP.aspx | https://www.facebook.com/alex.johnstone.5688?fref=ts | https://en.wikipedia.org/wiki/Alex_Johnstone | https://static-candidates.democracyclub.org.uk/media/images/54fdeee11ccf185f0d8cc4c9.png | public-domain | alexjohnstone61 | 2016-05-05 | 0 | 0 | 2593.0 | uk.org.publicwhip/person/uk.org.publicwhip/person/14020 | http://www.theyworkforyou.com/mp/uk.org.publicwhip/person/14020 | PP52 | 0 |
