items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where record_id = "2011-01-10-1f359ece-10088-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
5067897c728be57d9f0c9358a27da67ef122fdb7 | Queen’s Counsel. (Resumed practice at the Bar with effect from 1 January 2008.) Payments are made through Faculty Services Ltd, Advocates Library, Parliament House, Edinburgh EH1 1RF, and the payment figure is subject to deductions to reflect overheads due to the Faculty of Advocates. | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2011-01-10-1f359ece-10088-0 |
b476959611dced7465c99d99978247f7aa429291 | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-01-10-1f359ece-10088-0 |
24ad6a43e1e4d4361aa6b2eaad0c54e830a4b7e5 | Payment of £11,300 gross in respect of 35 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2011-01-10-1f359ece-10088-0 |
3ce571681ca695b95dd209af4815194717387d74 | Payment of £4,000 gross in respect of 20 hours’ work carried out between 1 January and 17 March 2010 entitled Kaur v. Glasgow Licensing Board, on the instruction of John Batters and Co, Solicitors, Glasgow. (Registered 19 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2011-01-10-1f359ece-10088-0 |
99c48d427103606a23e19cb344530d454b222dc9 | Payment of £900 gross in respect of 5 hours’ work carried out between 1 January and 17 March 2010 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 19 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 4 | 2011-01-10-1f359ece-10088-0 |
3686f790e32e8cd9168b12f8233cbf96ec4b9ce9 | 3 November 2009, received £150 gross (£115.50 net) for appearing on BBC’s "The Big Questions". Address of payer: MBCP Ltd., 77 Fulham Palace Road, Elsinore House, London W6 8JA. Hours: 3 hrs. (Registered 11 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 5 | 2011-01-10-1f359ece-10088-0 |
81a0113f8dca590a157d5da4a86d30cf5c687e56 | 9 December 2009, received £100 for appearing on Sky Television. Address: British Sky Broadcasting Ltd, Accounts Payable Department, 1 Macintosh Road, Kirkton Campus, Livingston, West Lothian EH54 7BW. Hours: 4 hrs. (Registered 14 December 2009) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 6 | 2011-01-10-1f359ece-10088-0 |
e0766be7659997857f9fbc5acd4a90a9305f3801 | 11 January 2010, received £150 for speech at Centre for Parliamentary Studies seminar on 25 November 2009. Hours: 1.5 hrs. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 7 | 2011-01-10-1f359ece-10088-0 |
299943e39c52ebbf3e631c9db6386ef988fd640a | Payment of £150 received for appearance on BBC’s Any Questions? on 23 April 2010. Hours: 4 hrs. Address: BBC, PO Box 480, Manchester, M14 0EL. (Registered 19 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 8 | 2011-01-10-1f359ece-10088-0 |
e7d42055e1160055242bceceb1de60e676078658 | 13 August 2010, payment of £100 for appearance on the Adam Boulton Show on Sky TV on 11 July 2010. Hours: 4 hrs. (Registered 31 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 9 | 2011-01-10-1f359ece-10088-0 |
336f8919505dbc71b8b97116205e32aa8db92c22 | 18 August 2010, payment of £15 for speech at the Probus Club of Auchtermuchty, Fife on 18. Hours: 3 hrs. Fee donated to charity. (Registered 31 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 10 | 2011-01-10-1f359ece-10088-0 |
08a90eb89c098455ff30e2cf29a9046bc1ec8a80 | Payment of £100 received on 16 September 2010 in respect of my appearance at the Edinburgh Book Festival on 14 August 2010: Address of payer: Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR. Hours: 4 hours. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-01-10-1f359ece-10088-0 |
b4fffc7d822571bf5f90b6f937ce072696a6943c | Payment of £250 received on 16 October 2010 for an article for Scotland on Sunday on 5 September 2010. Address: Barclay House, 108 Holyrood Road, Edinburgh EH8 8AS. Hours: 4 hrs. (Registered 21 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2011-01-10-1f359ece-10088-0 |
ccb42b2f4559cc7bf7863ea11d246796ee31b986 | Payment of £250 received on 10 November 2010 in relation to my accommodation and subsistence expenses for an appearance at a GovNet Communications fringe meeting on 20 September 2010 at the Liberal Party Conference. Address of payer: GovNet Communications, St James Building, Oxford Street, Manchester 1 6PP. Hours: 4 hrs. (Registered 26 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2011-01-10-1f359ece-10088-0 |
45b88e13a05b9e750ac7d2b878c3b2b6511cab0c | Payment of £250 received as speaker’s fee at the Annual Conference of Employers in Voluntary Housing on 29 October 2010. Hours: 5 hrs. Fee donated to charity. (Registered 25 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 14 | 2011-01-10-1f359ece-10088-0 |
75db0b6c63e8b907e627d13f141e71e69df6122e | Payment of £400 received on 8 December 2010 for an article for The Times on 11 November 2010. Address of payer: News International Supply Company Ltd, PO Box 151, Peterborough PE7 8YT. Hours: 4 hrs. (Registered 10 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 15 | 2011-01-10-1f359ece-10088-0 |
766ef221bec0b17702d33f495547380efcb34c52 | Payment of £100 received on 15 December 2010 for an article in The Scotsman on 14 November 2010. Address of payer: Barclay House, 108 Holyrood Road, Edinburgh EH8 8AS. Hours: 3 hrs. (Registered 23 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 16 | 2011-01-10-1f359ece-10088-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");