items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2014-10-27-1f359ece-10088-0" sorted by sort_order descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▲ | record_id |
---|---|---|---|---|---|---|---|
0914f35a37cc44162f65204f7967a83066df389a | 4 September 2014, £150 received from the Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR, for two appearances. Hours: 6 hrs. (Registered 10 September 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-10-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 6 | 2014-10-27-1f359ece-10088-0 |
61cf4c4af1f670cc847d7e372d974e9136683da5 | 6 July 2014, received £2,325 from the literary agents Maggie Pearlstine Associates, 31 Ashley Gardens, London SW1P 1QE, in respect of my participation in a panel discussion on 15 May 2014, at the annual conference in Manchester of the British Insurance Brokers Association, John Stow House, 18 Bevis Marks, London EC3A 7JB. Hours: 16 hrs including travel and overnight stay. (Registered 4 August 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-10-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 5 | 2014-10-27-1f359ece-10088-0 |
b9b1fa2d2549c6c13b8e43f91708ca70aa79e28e | 13 June 2014, received twelve bottles of wine, of unknown value but over £66, in return for a speech made on 20 May 2014 to Fleming Family and Partners, 15 Suffolk Street, London SW1Y 4HG. Hours: 5 hrs, including preparation. (Registered 8 July 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-10-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 4 | 2014-10-27-1f359ece-10088-0 |
5d9bcf42c1b9796f0a3924039970a3e7aec6342e | Payment of £150 received on 23 May 2014 for appearance on 16 May 2014. Hours: 5 hrs. (Registered 5 June 2014) | Remunerated employment, office, profession etc 1f359ece | 2014-10-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2014-10-27-1f359ece-10088-0 |
4f6fcff2fe37610dd63c5cba254d3de7138ad01c | Payment of £150 received on 30 September 2013 for appearance on 20 September 2013. Hours: 5 hrs. (Registered 14 October 2013) | Remunerated employment, office, profession etc 1f359ece | 2014-10-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2014-10-27-1f359ece-10088-0 |
ba32042ba7d892a9a16903a664cc935240f6e8e2 | Payments received from BBC for appearances on ‘Any Questions’. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL: | Remunerated employment, office, profession etc 1f359ece | 2014-10-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2014-10-27-1f359ece-10088-0 |
bf53b8de845733fb7275de1d678f0369fe9aaf07 | 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 | 2014-10-27 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2014-10-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");