items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2013-08-27-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 |
---|---|---|---|---|---|---|---|
b520e1e689969d750a85c621121b688d8aab0a70 | 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 | 2013-08-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2013-08-27-1f359ece-10088-0 |
1fae291220d42ef2adb2ee27091331cc58ee9761 | Payments in respect of seminars given to students of Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX: | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2013-08-27-1f359ece-10088-0 |
47fe2bf53cab0185f245c7ed5b4539a8b008ebb8 | £300 received on 3 December 2012 in respect of a talk on 28 November 2012. Hours: 2 hrs. (Registered 10 December 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2013-08-27-1f359ece-10088-0 |
75957cbbafb15727002ec39841c1a6fd9bc93421 | Payment of £150 received on 16 September 2011 in respect of my participation in an event at the Edinburgh Book Festival on 16 August 2012: Address of payer: Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR. Hours: 4 hrs. (Registered 20 September 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2013-08-27-1f359ece-10088-0 |
bba7ce59c6dd73205dd1a71f7f14479390855b45 | Payment of £250 received on 14 January 2013 from Partnership Media Group Ltd in respect of a speaking engagement organised by Govnet Communications, St James’ Buildings, Oxford St, Manchester M1 6PP at the Liberal Democrat conference on Monday 24 September 2012. Hours: 5 hrs. (Registered 16 January 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 4 | 2013-08-27-1f359ece-10088-0 |
5ba21188c47787dd7a9b8d7138170330eb8d09ce | Payment of £150 received on 5 May 2013 from BBC for appearance on ‘Any Questions’ on 26 April 2013. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL. Hours: 5 hrs. (Registered 13 May 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 5 | 2013-08-27-1f359ece-10088-0 |
e193e4d29856008bb7731ab6bd63a4845cd54cc9 | Payments received via my literary agent Maggie Pearlstine Associates, 31 Ashley Gardens, London SW1P 1QE: | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 6 | 2013-08-27-1f359ece-10088-0 |
593085cfd59b9a50fb57c312ed45d4c509914fbc | £2,280 received on 17 February 2013 for speech to BGC Partners, 1 Churchill Place, London E14 5RD on 9 January 2013. Hours: 8 hrs. (Registered 4 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 7 | 2013-08-27-1f359ece-10088-0 |
1bd2d157879dad062afa8c60633a7a68b3fe36c7 | £2,280 received on 1 March 2013 for speech to IMS Group, 2nd Floor, 130 Jermyn St, London SW1Y 4UR, on 23 January 2013. Hours: 8 hrs (Registered 4 April 2013) | Remunerated employment, office, profession etc 1f359ece | 2013-08-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 8 | 2013-08-27-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");