items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
33 rows where record_id = "2011-07-06-1f359ece-10027-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
beab4e3053ef9e365b2dbb847795fe629973dd90 | Member of Advisory Board and speaking engagements for Centre for Parliamentary Studies (until October 2010), 14 Great College Street, London SW1P 3RX. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 0 | 2011-07-06-1f359ece-10027-0 |
03b744b071fe7104202a45b4dab56521c64c9e07 | Payment of £150 for speech on 4 January 2010. Hours: 1 hr. (Registered 29 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 1 | 2011-07-06-1f359ece-10027-0 |
e38270e22caee0c68e87ac86631f56319e02f713 | Payment of £150 for speech on 4 June 2010. Hours: 1 hr. (Registered 29 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 2 | 2011-07-06-1f359ece-10027-0 |
cfbe7a61696d98713f92f9d5b1f430bd193c9e1a | Payment of £150 for speech on 10 June 2010. Hours: 45 min. (Registered 19 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 3 | 2011-07-06-1f359ece-10027-0 |
766d9a7e9d0d925d7ef3f6df1d003eed57bef974 | Fees for completing opinion surveys for ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 4 | 2011-07-06-1f359ece-10027-0 |
f87bf1202f80c89dad855301f5fc9145c1148c66 | £75 for survey, October 2009. Hours: 25 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 5 | 2011-07-06-1f359ece-10027-0 |
087604d05db42cdd45d76650e5b85b32ad79306c | £75 for survey, November 2009. Hours: 25 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 6 | 2011-07-06-1f359ece-10027-0 |
8d4421a54eab2b468d68849ecd2ce7eb49723583 | £75 for survey, May 2010. Hours: 30 mins. (Fee paid to charity.) (Registered 20 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 7 | 2011-07-06-1f359ece-10027-0 |
62734046d7523a12cb27b2ce9c4b141eff0126a1 | £75 for survey, June 2010. Hours: 25 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 8 | 2011-07-06-1f359ece-10027-0 |
4c09346361d010d1e9bd73e23c390d5baba55386 | £75 for survey, September 2010. Hours: 25 mins. (Fee paid to charity.) (Registered 21 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 9 | 2011-07-06-1f359ece-10027-0 |
42e040674d416db85928d28c776cab4e6e322f2e | £75 for survey, November 2010. Hours: 25 mins. (Fee paid to charity.) (Registered 25 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 10 | 2011-07-06-1f359ece-10027-0 |
4c28c508875bb7424b11f6f56653e46ee9c0419f | £75 for telephone interview, December 2010 Hours: 20 mins. (Fee paid to charity.) (Registered 31 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 11 | 2011-07-06-1f359ece-10027-0 |
ebcc7290c7631695d148900033c9425355dc68e5 | Fees paid to charity for completing opinion surveys for Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT: | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 12 | 2011-07-06-1f359ece-10027-0 |
2ca8637b1356350c666b5f80c3a761b203806eac | £75 for survey, July 2009. Hours: 14 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 13 | 2011-07-06-1f359ece-10027-0 |
908f9a983612e78b6f381d548672cffc282485a1 | £50 for survey, November 2009. Hours: 20 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 14 | 2011-07-06-1f359ece-10027-0 |
74b5e33d92f5ec40b28645e49bd168e22370450e | Fees for completing opinion surveys for Ipsos Mori, 79-81 Borough Road, London SE1 1FY: | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 15 | 2011-07-06-1f359ece-10027-0 |
2580d2ebcf1b86a995127dfcefe8123f08616a54 | £150 for survey, July 2010. Hours: 1 hr. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 16 | 2011-07-06-1f359ece-10027-0 |
b7e692096891affef19d487c1284186740144239 | Fees for completing opinion surveys for BPRI, 24-28 Bloomsbury Way, London, WC1A 2PX: | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 17 | 2011-07-06-1f359ece-10027-0 |
13b70a0060b5c04e2ce3cdd842bf79b88b9f5cca | £75 for survey, November 2009. Hours: 40 mins. (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 18 | 2011-07-06-1f359ece-10027-0 |
ac01db97b04cffb6eb7e806212569b3ba190d017 | Fee of £300 for speaking engagement for Westminster Experience, Cumberlege Connections, Snells Cottage, Newick, Lewes BN8 4LA, on 15 July 2010. Hours: 1 hr. (Registered 11 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 19 | 2011-07-06-1f359ece-10027-0 |
974462c22bdd66485e63a4d0944c0925c85e4809 | Fee of £500 received 29 October 2010, from Westminster Explained, 21 Dartmouth St | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 20 | 2011-07-06-1f359ece-10027-0 |
8455518bfb5181aa61769e3ac132d214bc6c4e71 | London SW1H 9BP, for all day seminar. Fee donated to local charity. (Registered 1 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 21 | 2011-07-06-1f359ece-10027-0 |
27d1353394da3b7f555b90eae24933a660a05805 | Parliamentary adviser to the Japanese Pharmaceutical Group, 4 Old Bath Road, Sonning, RG4 6TA. (Up to £5,000) All remuneration is donated to charity. The companies in the Japanese Pharmaceutical Group are as follows: | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 22 | 2011-07-06-1f359ece-10027-0 |
d01b0272d51d317fdf1eaf7dabfae399ce64f01c | Astellas Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 23 | 2011-07-06-1f359ece-10027-0 |
ecc1bd6760ce6290284a13eb8968a640a0bd01af | Chugai Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 24 | 2011-07-06-1f359ece-10027-0 |
53b1f597152610fb23481f3640dbec22c729e68c | Daiichi Sankyo UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 25 | 2011-07-06-1f359ece-10027-0 |
de8b8f9430a4bc38ad9b64ee98c5f23ecc7f3d49 | Dainippon Sumitomo Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 26 | 2011-07-06-1f359ece-10027-0 |
3bba59f32a1e01ff9ed8f99d1410b385d234299b | Eisai Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 27 | 2011-07-06-1f359ece-10027-0 |
51b5d5a895869ebd8135632612cf4b076a8115ad | Kowa Pharmaceutical Europe Co Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 28 | 2011-07-06-1f359ece-10027-0 |
f47288078b79caac1d61b8e81d4b0990ab3239b7 | Mitsubishi Pharma Europe ltd | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 29 | 2011-07-06-1f359ece-10027-0 |
63310b29723d76e3d5f3e2e19ac26fc4a9c3cfd4 | Otsuka Pharmaceutical Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 30 | 2011-07-06-1f359ece-10027-0 |
661ed15a1a8b0f976ccaeda57cf1a60556111beb | Takeda | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 31 | 2011-07-06-1f359ece-10027-0 |
f5674b282b36de16a0772b87c96bc4da6b1d0351 | Payment of £3,000 from Japanese Pharmaceutical Group, donated to charity on 26 May 2011. Hours: approximately 20 hours over a year. (Registered 7 June 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 32 | 2011-07-06-1f359ece-10027-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE items ( hash VARCHAR(40) NOT NULL, item TEXT, category_id TEXT, date TEXT, member_id TEXT, person_id TEXT, sort_order INTEGER, record_id TEXT, PRIMARY KEY (hash), FOREIGN KEY ("category_id") REFERENCES [categories](id), FOREIGN KEY ("member_id") REFERENCES [members](id), FOREIGN KEY ("person_id") REFERENCES [people](id) ); CREATE INDEX items_date ON items("date"); CREATE INDEX items_category_id ON items("category_id"); CREATE INDEX items_member_id ON items("member_id"); CREATE INDEX items_person_id ON items("person_id"); CREATE INDEX items_record_id ON items("record_id");