items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2013-09-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 |
---|---|---|---|---|---|---|---|
c3d6273f33d4c684c3befb5955ccb0fc24a23c4c | Fees for completing opinion surveys for ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 0 | 2013-09-30-1f359ece-10027-0 |
3da8f4d33bd1d5f8c128cb8d85d74f7246a7949f | Received £75 for April 2013 survey. Hours: 45 mins. Fee donated to charity. (Registered 10 June 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 1 | 2013-09-30-1f359ece-10027-0 |
f6b9667349d9165e3af7ef2bff44b3b4bb0ebab9 | 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 | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 2 | 2013-09-30-1f359ece-10027-0 |
8a30292defd11174491945a4c71c19db268fd19e | Astellas Ltd | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 3 | 2013-09-30-1f359ece-10027-0 |
e525c4d017f5c23533c992632cac149b8846cb72 | Chugai Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 4 | 2013-09-30-1f359ece-10027-0 |
cfddfbd33e943448c7637ec87c7ac5b18d6bf5b9 | Daiichi Sankyo UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 5 | 2013-09-30-1f359ece-10027-0 |
0913f40336d1461ffb30f2d8712c54d692f7c0e2 | Dainippon Sumitomo Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 6 | 2013-09-30-1f359ece-10027-0 |
2516500b79f810f7d505bb9aa84d4cf08b81bab0 | Eisai Ltd | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 7 | 2013-09-30-1f359ece-10027-0 |
96ebed71f4b0f2751370681fa71861973354dea8 | Kowa Pharmaceutical Europe Co Ltd | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 8 | 2013-09-30-1f359ece-10027-0 |
b6e6af333fe38deee421ddb7df59ca5bbf524525 | Mitsubishi Pharma Europe ltd | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 9 | 2013-09-30-1f359ece-10027-0 |
d52ee620901b2a19a39de1cab3898e7896a06e18 | Otsuka Pharmaceutical Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 10 | 2013-09-30-1f359ece-10027-0 |
a1c088008030106ff834c22a0eb5f2c191a89dde | Takeda . | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 11 | 2013-09-30-1f359ece-10027-0 |
eb17b4506f244440d61f753647f8d327b2f4ed6c | 26 September 2012, payment of £3,000 made direct to charity. Hours: 20 hrs. (Registered 26 September 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 12 | 2013-09-30-1f359ece-10027-0 |
32e9c0f9aa41a0c508bb79378a239f4012562734 | Payment of £150 from Ipsos MORI, 79-81 Borough Road, London SE1 1FY. for interview in December 2012. Hours: 1 hr. Fee paid to charity. (Registered 9 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-09-30 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 13 | 2013-09-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");