items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where record_id = "2014-06-16-1f359ece-10027-0" sorted by sort_order
This data as json, CSV (advanced)
date (date) 1 ✖
- 2014-06-16 17
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
146729e89e02c2eccbfe8944bced0b14a825860b | Fees for completing opinion surveys for ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 0 | 2014-06-16-1f359ece-10027-0 |
c53edeac70bb3830dbf8fc2efff65c8fee795031 | Received £75 for April 2013 survey. Hours: 45 mins. Fee donated to charity. (Registered 10 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 1 | 2014-06-16-1f359ece-10027-0 |
af452aa94acd429542aef964d806a164c14808cb | Received £75 for November 2013 survey. Hours: 35 mins. Fee donated to charity. (Registered 20 January 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 2 | 2014-06-16-1f359ece-10027-0 |
94aa4470166d68fd94243bd06fc35e5dd8e7d6ff | Received £75 for January 2014 survey. Hours: 35 mins. Fee donated to charity. (Registered 10 March 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 3 | 2014-06-16-1f359ece-10027-0 |
01456c486adb6c9eb9dc29c902b670fe416ebc3c | 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-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 4 | 2014-06-16-1f359ece-10027-0 |
fb5b0fe094b7cb8585ad454f320ef82cf49f8fa2 | Astellas Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 5 | 2014-06-16-1f359ece-10027-0 |
056c5a6205d66ceeff59725056f3a770a0925946 | Chugai Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 6 | 2014-06-16-1f359ece-10027-0 |
35b58b98ada09bb1e815051a301665f7d6149fc2 | Daiichi Sankyo UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 7 | 2014-06-16-1f359ece-10027-0 |
a05ce4d2bc7ad5634b1cc03ee2b8318776d8240a | Eisai Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 8 | 2014-06-16-1f359ece-10027-0 |
7e0d5430372af1c3b851aa5115093cfd9ea73f81 | Kowa Pharmaceutical Europe Co Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 9 | 2014-06-16-1f359ece-10027-0 |
5ed5568793ec37b4932592638e81361f4402ee2b | Mitsubishi Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 10 | 2014-06-16-1f359ece-10027-0 |
20efa487c6d5d0abc515f1469c68e74083563a7e | Otsuka Pharmaceutical Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 11 | 2014-06-16-1f359ece-10027-0 |
2b27f647cbe563f6d007da80c20c7c9e09f8188a | Shiongi Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 12 | 2014-06-16-1f359ece-10027-0 |
0565c088343dcf89dec834a7b550f2dadc4cf3b0 | Sunovion Pharmaceuticals Europe Ltd (formerly Dainippon Sumitomo) | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 13 | 2014-06-16-1f359ece-10027-0 |
fb86079a0cf2c10389c6c91e0645ae69a0d06ede | Takeda UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 14 | 2014-06-16-1f359ece-10027-0 |
25461b17573e3e60f3b5d0b82468eb121abde887 | 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-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 15 | 2014-06-16-1f359ece-10027-0 |
ebfaa28c07d2d3a57028e70446c367829f2e5116 | 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-06-16 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 16 | 2014-06-16-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");