items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2012-05-14-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 |
---|---|---|---|---|---|---|---|
bc12b740d6412dc119afed399c7d04c0f70ccb8c | Fees for completing opinion surveys for ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 0 | 2012-05-14-1f359ece-10027-0 |
5e90629c661bfd51c430acbafebafce9de313bd2 | £75 for survey, 5 December 2011. Hours: 25 mins. (Fee paid to charity). (Registered 6 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 1 | 2012-05-14-1f359ece-10027-0 |
6959a53455f5b751be480f26ccc2116b564fd504 | 17 April 2012, received £75 for February/March 2012 survey. Hours: 30 mins. Fee paid to charity. (Registered 17 April 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 2 | 2012-05-14-1f359ece-10027-0 |
0a0a531086fc360261f28c2f9cc339081c1391cf | 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 | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 3 | 2012-05-14-1f359ece-10027-0 |
f1914817205e3a83914583ef655b968acef49aad | Astellas Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 4 | 2012-05-14-1f359ece-10027-0 |
b5f8c02089735748089fe081158265bbe074a2d2 | Chugai Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 5 | 2012-05-14-1f359ece-10027-0 |
1c327151e007b77b3d5d58717ba02954daedd60b | Daiichi Sankyo UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 6 | 2012-05-14-1f359ece-10027-0 |
d19497703ec20398bc11e91e3f51276f6f8e105b | Dainippon Sumitomo Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 7 | 2012-05-14-1f359ece-10027-0 |
c63540af9f3784cd7eeb188dac975b60ced82f76 | Eisai Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 8 | 2012-05-14-1f359ece-10027-0 |
f8ae3977f5f40680278629e53b846228cc9184d2 | Kowa Pharmaceutical Europe Co Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 9 | 2012-05-14-1f359ece-10027-0 |
940c9081f2ae263960e45ea115923da1eebcb7ff | Mitsubishi Pharma Europe ltd | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 10 | 2012-05-14-1f359ece-10027-0 |
95fb6eea0694bcc9baf904e316d856febc04e8bc | Otsuka Pharmaceutical Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 11 | 2012-05-14-1f359ece-10027-0 |
a501c6da98b6ed24c904ba764cdbbcce67231d89 | Takeda | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 12 | 2012-05-14-1f359ece-10027-0 |
8098dc715672fc720e3c9e9bcf5f32b9eb1fa82e | 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 | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 13 | 2012-05-14-1f359ece-10027-0 |
b69c70f4a2758f15482c9f8e7e340656ecdd8f9e | Payment of £150 from Britain Thinks, Somerset House, Strand, London WC2R 1LA, for interview. Hours: 45 mins. (Registered 6 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 14 | 2012-05-14-1f359ece-10027-0 |
d983ad5eae1b052f1f7cdee1e7e53f7c372bef75 | I spoke, as Chair of the All Party Group on Pharmacy, at the conference of Sigma Pharmaceuticals in Thailand on 11 February 2012. Address: Unit 1-7, Colonial Way, PO Box 233, Watford WD24 4YR. Hours: 1 hr plus travel. No fee was paid but the organisers paid for travel and attendance at the conference from 11 to 18 February 2012 for myself and my partner, estimated value £4,000. (Registered 20 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 15 | 2012-05-14-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");