items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
24 rows where "date" is on date 2013-01-18 and person_id = "uk.org.publicwhip/person/10088" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
9aa696b27f77c30254b20b39dac4b08f9a6bd5d4 | Scottish American Investment Company PLC (£15,001–£20,000) | Remunerated directorships ead1ca87 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2013-01-18-ead1ca87-10088-0 |
b24489a024e9bc138fd025658a7ce05f10c70f30 | Payment of £4,375 gross (£2,625 net) received on 31 December 2011. Hours: 12 hrs. (Registered 6 February 2012) | Remunerated directorships ead1ca87 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2013-01-18-ead1ca87-10088-0 |
e4fc2cfa5fb8e080c27bdae45936f72a58e0a7e1 | Payment of £4,375 gross (£2,625 net) received on 31 March 2012. Hours: 12 hrs. (Registered 20 April 2012) | Remunerated directorships ead1ca87 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2013-01-18-ead1ca87-10088-0 |
fe12db8a50ae0c7b33bb117530758065fee6119f | Payment of £4,375 gross (£2,625 net) received on 30 June 2012. Hours: 12 hrs. (Registered 14 August 2012) | Remunerated directorships ead1ca87 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2013-01-18-ead1ca87-10088-0 |
b9880d4ca41da4d5542af4cfdbb26297e82d744b | Payment of £4,375 gross (£2,625 net) received on 30 September 2012. Hours: 12 hrs. (Registered 11 October 2012) | Remunerated directorships ead1ca87 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 4 | 2013-01-18-ead1ca87-10088-0 |
8bb92c707f6bdbff27010ef4eb80156e65284d3e | Payment of £4,375 gross (£2,625 net) received on 31 December 2012. Hours: 12 hrs. (Registered 16 January 2013) | Remunerated directorships ead1ca87 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 5 | 2013-01-18-ead1ca87-10088-0 |
782eb25e4571e6db3ff77025f577e6613735e7a2 | 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-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2013-01-18-1f359ece-10088-0 |
f5e527bf2353eaf09b5e22003e3ca05a4635126b | Payments in respect of seminars given to students of Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX: | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2013-01-18-1f359ece-10088-0 |
3afeca30dfeae4245576839a77afad211699b16e | £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 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2013-01-18-1f359ece-10088-0 |
34900ff2007c7fcf9b57c10f933f98af2517a79b | £300 received on 30 April 2012 in respect of a talk on 25 April 2012. Hours: 2 hrs. (Registered 1 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2013-01-18-1f359ece-10088-0 |
b0b40896d207d855c6ebb6446fd409779768b7f5 | £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-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 4 | 2013-01-18-1f359ece-10088-0 |
0c955eefdf68d6bc6aadfe0e7bddba20a257be6d | 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 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 5 | 2013-01-18-1f359ece-10088-0 |
4509da4a48822fd7cf1119f3a190cc21dd478d78 | Payment of £150 received on 14 May 2012 in respect of my participation in a conference on sport and politics on 19 April 2012 for the Marylebone Cricket Club. Address of payer: Lord’s Cricket Ground, St John’s Wood Road, London NW8 8QN. Hours: 3 hrs. (Registered 16 May 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 6 | 2013-01-18-1f359ece-10088-0 |
2875fb660e0a55cd08c9f8bd958817f3dd047344 | Payment of £75 received on 9 June 2012 from BBC for participating in a programme for Radio 4 on 1 February 2012. Address of payer: BBC Contributor Payments, PO Box 480, Manchester M14 0EL. Hours: 30 mins. (Registered 18 June 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 7 | 2013-01-18-1f359ece-10088-0 |
c4acaab65ade2b5ccc21db04ae213fe94d8c6a17 | 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-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 8 | 2013-01-18-1f359ece-10088-0 |
d1afd1558d53c5f20d53650557f1f334a9c67066 | 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-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 9 | 2013-01-18-1f359ece-10088-0 |
955de035d3eec89f127cdf66aeef4c609a3f8d80 | Name of donor: (1) Friedrich Ebert Stiftung (2) European Leadership Network | Overseas visits 80ef1083 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2013-01-18-80ef1083-10088-0 |
1d37095b89aee4552eb36b1abd5f7522c6b299cc | Address of donor: (1) 1023 15th Street NW, Washington DC 20005; (2) Suite Seven, South Bank House, Black Prince Road, London SE1 7SJ | Overseas visits 80ef1083 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2013-01-18-80ef1083-10088-0 |
06ae92e7b6fd3f259c5f41172e1e9e60993bf794 | Amount of donation (or estimate of the probable value): (1) £2903.99 for flights ; (2) approx £535 for accommodation and incidental travel | Overseas visits 80ef1083 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2013-01-18-80ef1083-10088-0 |
67cdbeb0771863137d38eeb3678f986515bd34a3 | Destination of visit: Washington DC | Overseas visits 80ef1083 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2013-01-18-80ef1083-10088-0 |
2572c960267b207a5de284539c9fd8634b027d5d | Date of visit: 16-18 April 2012 | Overseas visits 80ef1083 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 4 | 2013-01-18-80ef1083-10088-0 |
55bb86d5977b0fa114cc0d2a19fa872884ab118e | Purpose of visit: to meet members of Congress, officials in the Obama administration and disarmament specialists to discuss multilateral nuclear disarmament. | Overseas visits 80ef1083 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 5 | 2013-01-18-80ef1083-10088-0 |
197dcb370996e3178ff0a091c15ce89b36ade3e8 | (Registered 24 April 2012) | Overseas visits 80ef1083 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 6 | 2013-01-18-80ef1083-10088-0 |
a47618f83cb583126ea374bccf6673f4cf4136e8 | As part of my unpaid role as Member of the Olympic Board , for which I was fully accredited, I attended various Olympic events between 3 and 11 August 2012. I also visited the Paralympic Village on 3 September and attended events in the stadium on 6 September , and the closing ceremonies on 12 August and 9 September. On these occasions I benefited from official transport to Stratford and official hospitality. All benefits were received from LOCOG, One Churchill Place, Canary Wharf, London E14 5LN. (Registered 13 September 2012) | Miscellaneous 5f2cbd10 | 2013-01-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2013-01-18-5f2cbd10-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");