items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2010-02-03-1f359ece-10088-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 |
---|---|---|---|---|---|---|---|
d149af8325a99e8e118797173c08cac75e931585 | Queen's Counsel. (Resumed practice at the Bar with effect from 1 January 2008.) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2010-02-03-1f359ece-10088-0 |
1a6828110ad309de1de79c67cff5e2254dd3adc7 | 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. The payment was 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. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-02-03-1f359ece-10088-0 |
1c9011ae567956ff556e61ec0257141ff5cee288 | 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. The payment was 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. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2010-02-03-1f359ece-10088-0 |
a181bf8770dfb91d721f15928294858622850997 | Under contract with Hodder & Stoughton for autobiographical book. | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2010-02-03-1f359ece-10088-0 |
83c50822b5479680b3c1308c8729fd4fd3b852ee | Fees for two appearances on ITV's 'The Book Quiz'. (Up to £5,000) (Registered 7 January 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 4 | 2010-02-03-1f359ece-10088-0 |
aa587152b41d353d78085c4407aef0bc7c8d0e32 | 30 July 2009, spoke at North Fife Rotary Club (Club Number 18759, District 1010) and received ball point pen, estimated value £1. Hours 5hrs 30mins. (Registered 17 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 5 | 2010-02-03-1f359ece-10088-0 |
97864909a99f52971ca2ccf0bfcc3bd7792e0ef8 | 6 August 2009, performed opening of new office for Edward Jones Stockbrokers, 8 South Street, St Andrews, Fife, KY16 9QD, and received bottle of whiskey, estimated value £20. Hours: 3hrs. (Registered 17 August 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 6 | 2010-02-03-1f359ece-10088-0 |
3d40a58339e9910155ecf1ed02e0ddf1a3fe4fa1 | Payment of £250 in respect of my appearance at the Edinburgh Book Festival. Hours: 6 hours. (Registered 13 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 7 | 2010-02-03-1f359ece-10088-0 |
d337bc0e41c8130ccfc1eb9be74a276046cd9401 | Received £222 for appearing on Any Questions? on 9 October 2009. Address: BBC, Talent Rights Group, Room 3205 White City, 201 Wood Lane, London. Hours: 9 hrs. (Registered 19 October 2009) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 8 | 2010-02-03-1f359ece-10088-0 |
76b6c580b2b98984f909ecacaab686fcb614a733 | 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 | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 9 | 2010-02-03-1f359ece-10088-0 |
a6775d36c81f592080958dd5a0bb3de3cd2c17ef | 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 | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 10 | 2010-02-03-1f359ece-10088-0 |
36e9df56377deef168bfa4abd963dda354731ad1 | 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 | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2010-02-03-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");