items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
6 rows where record_id = "2012-03-19-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 |
---|---|---|---|---|---|---|---|
993070dfb8874bcd3443e7bd39035dd57489b223 | 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 | 2012-03-19 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2012-03-19-1f359ece-10088-0 |
0a54dad07b699d0c2f8b7013429fe861bbfb8f36 | Payments in respect of seminars given to students of Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX: | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2012-03-19-1f359ece-10088-0 |
7c427a29712c58d61a58e9388ddbd7912dafc47b | £400 received on 16 March 2011 in respect of a seminar on 9 March 2011. Hours: 1.5 hrs. (Registered 17 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2012-03-19-1f359ece-10088-0 |
7741f2bfc97177f3eed6d591ef12c32087833578 | £300 received on 20 January 2012 in respect of a talk on 19 January 2012. Hours: 1 hr. (Registered 31 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2012-03-19-1f359ece-10088-0 |
eed2994fc9df13b26f993e1d55d14326485dbff7 | Payment of £150 received on 16 September 2011 in respect of my participation in two events at the Edinburgh Book Festival in August 2011: Address of payer: Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR. Hours: 8 hrs. (Registered 10 October 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 4 | 2012-03-19-1f359ece-10088-0 |
a2c237bdc53b50389459c8bffd6ddd60ad45db0f | Payment of £4,739.85 (CHF 7045) received on 18 January 2012 from the Court of Arbitration for Sport, Lausanne, Switzerland, for services as a member of an arbitration panel set up by the Court over the period 1 May 2011 to 31 December 2011. Hours: 30 hrs. (Registered 9 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 5 | 2012-03-19-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");