items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2014-07-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 |
---|---|---|---|---|---|---|---|
b5805c345d821bea3704f3e53a484623bca4fef4 | Fees for completing opinion surveys for ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 0 | 2014-07-14-1f359ece-10027-0 |
188d3c58c1cf02cf6dc09e4a48e76540774c0d8f | Received £75 for November 2013 survey. Hours: 35 mins. Fee donated to charity. (Registered 20 January 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 1 | 2014-07-14-1f359ece-10027-0 |
80225444b25d3747e9f28f2ea22bfc461d81beaf | Received £75 for January 2014 survey. Hours: 35 mins. Fee donated to charity. (Registered 10 March 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 2 | 2014-07-14-1f359ece-10027-0 |
faf1cd2db427ad4131fcb1ca4d0c81018e5ee070 | 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 | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 3 | 2014-07-14-1f359ece-10027-0 |
bff6102f9dc26c7cebc217ef5ffc4942197ed6fc | Astellas Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 4 | 2014-07-14-1f359ece-10027-0 |
33b47c8bd9c3e3be475dc57cbd36b2b297cbb969 | Chugai Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 5 | 2014-07-14-1f359ece-10027-0 |
2ac0967240181c39eaf807eebd2f8e50ae8ee59b | Daiichi Sankyo UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 6 | 2014-07-14-1f359ece-10027-0 |
0af1c7a42767d5738500b735e946a0e25d5539c2 | Eisai Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 7 | 2014-07-14-1f359ece-10027-0 |
73ef60b68e122efb20941df5f2ed91014a267207 | Kowa Pharmaceutical Europe Co Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 8 | 2014-07-14-1f359ece-10027-0 |
05c87873b12f3b5e3ba18d970c528be7212feadd | Mitsubishi Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 9 | 2014-07-14-1f359ece-10027-0 |
181363986da3997c4c6bd97304e33ba4945f8610 | Otsuka Pharmaceutical Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 10 | 2014-07-14-1f359ece-10027-0 |
a3296cb7835627abec524329bf1ebfd377842029 | Shiongi Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 11 | 2014-07-14-1f359ece-10027-0 |
3be8615f2eb648857b071cd85dc44523da4e15e9 | Sunovion Pharmaceuticals Europe Ltd (formerly Dainippon Sumitomo) | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 12 | 2014-07-14-1f359ece-10027-0 |
48ff7a011e3176bdd9e29741f4bf255fbcd3afdf | Takeda UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 13 | 2014-07-14-1f359ece-10027-0 |
6e32584fde40f31cf9eb64e78110ae8f4a9997ba | April 2014, received £3,000 for 2014/15, paid direct to charity. Hours: 20 hrs. (Registered 30 April 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 14 | 2014-07-14-1f359ece-10027-0 |
23f752b43da723b0df21ac98e36ad11c90262cf9 | Payment of £150 for article written for the Guardian Newspaper, published on 17 January 2014. Address: Guardian News & Media, Kings Place, 90 York Way, London N1 9GU. Fee donated to charity. Hours: 2 hrs. (Registered 24 February 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-07-14 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 15 | 2014-07-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");