items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where record_id = "2014-06-30-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 |
---|---|---|---|---|---|---|---|
447ebfe96756673c53a811bcd3845be7025d0e5e | Fees for completing opinion surveys for ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 0 | 2014-06-30-1f359ece-10027-0 |
7b1ef07443d7c5e533084c0dfbde6687d169d78c | 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-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 1 | 2014-06-30-1f359ece-10027-0 |
b220c4542522a8ee8d43305c8df388d48566870e | 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-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 2 | 2014-06-30-1f359ece-10027-0 |
6f01747243884462c670732773e84fd93d5bedb3 | 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-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 3 | 2014-06-30-1f359ece-10027-0 |
6242d41e6aaf35838c75c28b0e10084205118648 | 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-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 4 | 2014-06-30-1f359ece-10027-0 |
92c68dad1b223966617681bf806c0b1116ad2938 | Astellas Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 5 | 2014-06-30-1f359ece-10027-0 |
db7430e569257b5096bc9065d0b41af7aaebe92f | Chugai Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 6 | 2014-06-30-1f359ece-10027-0 |
978915f50de1b6e3f83f43c375723a950e2a2edb | Daiichi Sankyo UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 7 | 2014-06-30-1f359ece-10027-0 |
1d3dec224e57d229feeed9ef726d4f47e3384620 | Eisai Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 8 | 2014-06-30-1f359ece-10027-0 |
f5757221183b782057d26b15707499dcb6f6164b | Kowa Pharmaceutical Europe Co Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 9 | 2014-06-30-1f359ece-10027-0 |
1e2d96de1f379fd8eb08f8245d85eb248c6d9efc | Mitsubishi Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 10 | 2014-06-30-1f359ece-10027-0 |
d445a7ca36d079f998cc9b2d9f34ddea442519a7 | Otsuka Pharmaceutical Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 11 | 2014-06-30-1f359ece-10027-0 |
08b65d3d3eaf74139121cc0bcc6eed86767178b7 | Shiongi Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 12 | 2014-06-30-1f359ece-10027-0 |
68944bf21de9235d8f7ddfa12ba2eb7fc9d90ce9 | Sunovion Pharmaceuticals Europe Ltd (formerly Dainippon Sumitomo) | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 13 | 2014-06-30-1f359ece-10027-0 |
49efdf3af89fc1a677fd81a4b62bd61a1b6df703 | Takeda UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-06-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 14 | 2014-06-30-1f359ece-10027-0 |
8e3fff8cfa57ad9f6bcda9bac40c9f8545dd42a7 | 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-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 15 | 2014-06-30-1f359ece-10027-0 |
c0e77553852e359b8e7d2eb6ca269e181dcba7a2 | 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-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 16 | 2014-06-30-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");