items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2012-02-20-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 |
---|---|---|---|---|---|---|---|
254c9a671374fbdd80a13ed3e4e63e580f8d25fb | Fees for completing opinion surveys for ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 0 | 2012-02-20-1f359ece-10027-0 |
9321660fb055c452693204aff68e34a90217592b | £75 for survey, 5 December 2011. Hours: 25 mins. (Fee paid to charity). (Registered 6 December 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 1 | 2012-02-20-1f359ece-10027-0 |
5a4d4001ccc0440e3da5fb92cdeaa22be31dc8b3 | Fee of £500 received 29 October 2010, from Westminster Explained, 21 Dartmouth St | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 2 | 2012-02-20-1f359ece-10027-0 |
57072cc95b83386020f06c1af9be2c5b3d94246c | London SW1H 9BP, for all day seminar. Fee donated to local charity. (Registered 1 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 3 | 2012-02-20-1f359ece-10027-0 |
a9df9a1691f5f36627549f60ec802d9f093cb93e | 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-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 4 | 2012-02-20-1f359ece-10027-0 |
dcc82e03d7e5b8f3646a1832788d299c5d6fce89 | Astellas Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 5 | 2012-02-20-1f359ece-10027-0 |
3908d667f3cac82c140753af7c89eea43f1aceb6 | Chugai Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 6 | 2012-02-20-1f359ece-10027-0 |
b6e26f25967752f0b472f1a531bbe8423b98fc14 | Daiichi Sankyo UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 7 | 2012-02-20-1f359ece-10027-0 |
6faedd315807dc56e7189789503e1d9947ccb173 | Dainippon Sumitomo Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 8 | 2012-02-20-1f359ece-10027-0 |
29a41f5259d6ed827246c2646f29f5a20498fd91 | Eisai Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 9 | 2012-02-20-1f359ece-10027-0 |
50f7f137d6431b7bd7c2c8ea6abe466788292971 | Kowa Pharmaceutical Europe Co Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 10 | 2012-02-20-1f359ece-10027-0 |
078c8e4a244e595e82caabec565c38f49be621a0 | Mitsubishi Pharma Europe ltd | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 11 | 2012-02-20-1f359ece-10027-0 |
34edfd1a1744da88b042fae57142cc74052fd1d4 | Otsuka Pharmaceutical Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 12 | 2012-02-20-1f359ece-10027-0 |
a022e22bbf409e33c090bd3bb4998f6a3bed0645 | Takeda | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 13 | 2012-02-20-1f359ece-10027-0 |
c909db259acc961ce6c3330b2ebf7ccd2c2bd0bb | 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-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 14 | 2012-02-20-1f359ece-10027-0 |
2945837f47e733e11b194f4851e401491432bed7 | 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-02-20 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 15 | 2012-02-20-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");