items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2014-11-24-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 |
---|---|---|---|---|---|---|---|
29c45fe53ef4c2da9305f8d2cb4ebd0ed333364e | Fees for completing opinion surveys for ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 0 | 2014-11-24-1f359ece-10027-0 |
7634798fc297585413da4f28d492af481b5c2a31 | Received £75 for November 2013 survey. Hours: 35 mins. Fee donated to charity. (Registered 20 January 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 1 | 2014-11-24-1f359ece-10027-0 |
6ceb94812790f235a248f86fbde7b2f55fffbb48 | Received £75 for January 2014 survey. Hours: 35 mins. Fee donated to charity. (Registered 10 March 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 2 | 2014-11-24-1f359ece-10027-0 |
87d24eea312eea72ac00ae0c66dcb4be70cfc991 | 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-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 3 | 2014-11-24-1f359ece-10027-0 |
1c26aee715fdc5f5968d997a1f95402f9c94da90 | Astellas Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 4 | 2014-11-24-1f359ece-10027-0 |
ff3cfc127e6c01c56436ceb5e896a45fc7f5b906 | Chugai Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 5 | 2014-11-24-1f359ece-10027-0 |
4d4b1843d6b68f467f45ac6b389290d885c8bf0a | Daiichi Sankyo UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 6 | 2014-11-24-1f359ece-10027-0 |
11afcc156f45084d919a9c6f7d3d3681c86c33be | Eisai Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 7 | 2014-11-24-1f359ece-10027-0 |
6ca33197ab978e202658e1db61840fba8418271a | Kowa Pharmaceutical Europe Co Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 8 | 2014-11-24-1f359ece-10027-0 |
b4c0a317da7e79f2592501333f0bb7a0b97a6a32 | Mitsubishi Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 9 | 2014-11-24-1f359ece-10027-0 |
42c8ec7ef985be654b3760d189c846f62d3c6531 | Otsuka Pharmaceutical Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 10 | 2014-11-24-1f359ece-10027-0 |
fde5180d50e4176800886d46638d364166557b27 | Shiongi Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 11 | 2014-11-24-1f359ece-10027-0 |
6f0abe848ff82ef42cb48a36ee9d9a1b688ea143 | Sunovion Pharmaceuticals Europe Ltd (formerly Dainippon Sumitomo) | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 12 | 2014-11-24-1f359ece-10027-0 |
aa0f53d449f8c204d7719ca487e1a23fd6392774 | Takeda UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2014-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 13 | 2014-11-24-1f359ece-10027-0 |
d860e0208a48c450a39433b9dd28ab6d9d4eea3b | 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-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 14 | 2014-11-24-1f359ece-10027-0 |
05138fc9f451f80b432c448035fc0968ba674a34 | 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-11-24 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 15 | 2014-11-24-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");