items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
33 rows where record_id = "2011-06-06-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 |
---|---|---|---|---|---|---|---|
2428e4d2750edfe47adee0c2c33cff1ad33848d1 | Member of Advisory Board and speaking engagements for Centre for Parliamentary Studies (until October 2010), 14 Great College Street, London SW1P 3RX. (Up to £5,000) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 0 | 2011-06-06-1f359ece-10027-0 |
2b7371f2131bd4d5d5e23f635d20def38111cead | Payment of £300 for Advisory Board meeting on 9 June 2010. Hours: 3 hrs. (Registered 28 June 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 1 | 2011-06-06-1f359ece-10027-0 |
820bb7349995869e13ce68755c1dbc5f0889b556 | Payment of £150 for speech on 4 January 2010. Hours: 1 hr. (Registered 29 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 2 | 2011-06-06-1f359ece-10027-0 |
af768f0fb47f6054548d3b94e9d6d3568c5ed653 | Payment of £150 for speech on 4 June 2010. Hours: 1 hr. (Registered 29 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 3 | 2011-06-06-1f359ece-10027-0 |
7f1921d2810e6d2a805323af15e1c8cc09c4ccb0 | Payment of £150 for speech on 10 June 2010. Hours: 45 min. (Registered 19 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 4 | 2011-06-06-1f359ece-10027-0 |
71e85f38965ab6eb4b16e1f4ecfcfdfa6954a3e7 | Fees for completing opinion surveys for ComRes, 4 Millbank, London, SW1P 3JA: | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 5 | 2011-06-06-1f359ece-10027-0 |
3287a3ebd5645d78a74b4e9db5755465ebdf094d | £75 for survey, October 2009. Hours: 25 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 6 | 2011-06-06-1f359ece-10027-0 |
0d15e9141347b8f81294dd190d4ca54d623861e4 | £75 for survey, November 2009. Hours: 25 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 7 | 2011-06-06-1f359ece-10027-0 |
5232fd380214452099cd9759ec21b706b4b18e80 | £75 for survey, May 2010. Hours: 30 mins. (Fee paid to charity.) (Registered 20 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 8 | 2011-06-06-1f359ece-10027-0 |
9c9491b7e1a7925b5a0ba0533185223a7eded931 | £75 for survey, June 2010. Hours: 25 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 9 | 2011-06-06-1f359ece-10027-0 |
3f3d4840e5767335489f3664e186357843d22195 | £75 for survey, September 2010. Hours: 25 mins. (Fee paid to charity.) (Registered 21 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 10 | 2011-06-06-1f359ece-10027-0 |
021c4ca25facc17f900f15fbb0e63244729bec8f | £75 for survey, November 2010. Hours: 25 mins. (Fee paid to charity.) (Registered 25 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 11 | 2011-06-06-1f359ece-10027-0 |
9fb6c37320320a61ca9b338d450cb379fa8d6356 | £75 for telephone interview, December 2010 Hours: 20 mins. (Fee paid to charity.) (Registered 31 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 12 | 2011-06-06-1f359ece-10027-0 |
09f8c8337413a9ed43cfe920dd20d35dcf663352 | Fees paid to charity for completing opinion surveys for Populus, Northburgh House, 10 Northburgh Street, London, EC1V 0AT: | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 13 | 2011-06-06-1f359ece-10027-0 |
c6fc19ee836b413fb27c5dd0d4fc0edc04a82b27 | £75 for survey, July 2009. Hours: 14 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 14 | 2011-06-06-1f359ece-10027-0 |
387d422ad8c85101b0d963fdb3f8b59a0afbfe8c | £50 for survey, November 2009. Hours: 20 mins. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 15 | 2011-06-06-1f359ece-10027-0 |
730c937b961dce3ad2cec1f4f99a84a873131264 | Fees for completing opinion surveys for Ipsos Mori, 79-81 Borough Road, London SE1 1FY: | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 16 | 2011-06-06-1f359ece-10027-0 |
aa733001f31544b51ad37c9a7b4099a8877058fb | £150 for survey, July 2010. Hours: 1 hr. (Fee paid to charity.) (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 17 | 2011-06-06-1f359ece-10027-0 |
e5d01a35602741d46ae5da43b19a0aa542b86426 | Fees for completing opinion surveys for BPRI, 24-28 Bloomsbury Way, London, WC1A 2PX: | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 18 | 2011-06-06-1f359ece-10027-0 |
3931c76e2f3b51e925dc5c0a1eaea4643424040c | £75 for survey, November 2009. Hours: 40 mins. (Registered 26 July 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 19 | 2011-06-06-1f359ece-10027-0 |
c8b6f465a7a95308162eb1d49fcbaa13d4e4c938 | Fee of £300 for speaking engagement for Westminster Experience, Cumberlege Connections, Snells Cottage, Newick, Lewes BN8 4LA, on 15 July 2010. Hours: 1 hr. (Registered 11 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 20 | 2011-06-06-1f359ece-10027-0 |
59eb41fd534dcb173565c46e39470683f8ea9ca1 | Fee of £500 received 29 October 2010, from Westminster Explained, 21 Dartmouth St | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 21 | 2011-06-06-1f359ece-10027-0 |
74e18799265be31de0d033f23627ed3a5510a246 | London SW1H 9BP, for all day seminar. Fee donated to local charity. (Registered 1 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 22 | 2011-06-06-1f359ece-10027-0 |
735a5cf7663d90468da457461f6ed06f7a37bfda | Parliamentary adviser to the Japanese Pharmaceutical Group, 4 Old Bath Road, Sonning, RG4 6TA. (Up to £5,000) Hours: approximately 20 hours a year. All remuneration is donated to charity. The companies in the Japanese Pharmaceutical Group are as follows: | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 23 | 2011-06-06-1f359ece-10027-0 |
18419369b74f5caeb15607192b80c028f622a197 | Astellas Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 24 | 2011-06-06-1f359ece-10027-0 |
f2a85e40ebbda3497017bc9cd08412fc51d83259 | Chugai Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 25 | 2011-06-06-1f359ece-10027-0 |
4055c59408436143744336d2ad9b89a27f45da72 | Daiichi Sankyo UK Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 26 | 2011-06-06-1f359ece-10027-0 |
448d7eb42571e0152e2f548f31dc0e9267dfdfd3 | Dainippon Sumitomo Pharma Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 27 | 2011-06-06-1f359ece-10027-0 |
56a4276b9978c85bb74bfc371cc9fe8c271faccd | Eisai Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 28 | 2011-06-06-1f359ece-10027-0 |
97738cbec5fcb2115c1d822fe5202f39cefce5dd | Kowa Pharmaceutical Europe Co Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 29 | 2011-06-06-1f359ece-10027-0 |
0edc19e17773eae56a59a8f270fa0fb08fc6b634 | Mitsubishi Pharma Europe ltd | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 30 | 2011-06-06-1f359ece-10027-0 |
a48c8a6e9e9480bc64ee038ae2df9aa57ca8f238 | Otsuka Pharmaceutical Europe Ltd | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 31 | 2011-06-06-1f359ece-10027-0 |
4f6aaad4540d00c42b613d28be6efcbef6762ef3 | Takeda | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Kevin Barron uk.org.publicwhip/member/40508 | Kevin Barron uk.org.publicwhip/person/10027 | 32 | 2011-06-06-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");