items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
23 rows where "date" is on date 2013-07-08 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, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
2123d339f5e830249809ca54aa75d812c7d21b65 | Scottish American Investment Company PLC (£15,001–£20,000) | Remunerated directorships ead1ca87 | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2013-07-08-ead1ca87-10088-0 |
5f4da1987ba22991762d778c8eb27989ecc79c63 | Payment of £4,375 gross (£2,625 net) received on 31 March 2012. Hours: 12 hrs. (Registered 20 April 2012) | Remunerated directorships ead1ca87 | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2013-07-08-ead1ca87-10088-0 |
f9a7c3023697d0687b7cb2f8c60e3cab6cc51975 | Payment of £4,375 gross (£2,625 net) received on 30 June 2012. Hours: 12 hrs. (Registered 14 August 2012) | Remunerated directorships ead1ca87 | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2013-07-08-ead1ca87-10088-0 |
622a2cec334be18ce63f55ab7c32dce46fbb87ac | Payment of £4,375 gross (£2,625 net) received on 30 September 2012. Hours: 12 hrs. (Registered 11 October 2012) | Remunerated directorships ead1ca87 | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2013-07-08-ead1ca87-10088-0 |
402967c4051bbd56cd14cb61eb937dc7259c85e7 | Payment of £4,375 gross (£2,625 net) received on 31 December 2012. Hours: 12 hrs. (Registered 16 January 2013) | Remunerated directorships ead1ca87 | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 4 | 2013-07-08-ead1ca87-10088-0 |
7aa589093849a45e74b19a7cf6b3173e23913113 | Payment of £5,000 gross (£3,000 net) received on 31 March 2013. Hours: 12 hrs. (Registered 15 April 2013) | Remunerated directorships ead1ca87 | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 5 | 2013-07-08-ead1ca87-10088-0 |
3f33c392e9abf597c61f19bb80b62be08adedcc6 | 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-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2013-07-08-1f359ece-10088-0 |
e3a9631ec6519d1f343f2a87e260567b75907bf3 | Payments in respect of seminars given to students of Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX: | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2013-07-08-1f359ece-10088-0 |
bdca9893c2dcc51e4ac0ba40253e86019a573dd2 | £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-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2013-07-08-1f359ece-10088-0 |
fb1f2bc6f4671c9a8296001c4ffd460e5f339b97 | 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-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2013-07-08-1f359ece-10088-0 |
b5a93bf86c0142c05599e80f9e8cc3d17566e5da | 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-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 4 | 2013-07-08-1f359ece-10088-0 |
907586f017cb755d73801002c3778d37075974b7 | 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-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 5 | 2013-07-08-1f359ece-10088-0 |
9ef3115222aabf250ad8de8b544188d128cdffa5 | Payments received via my literary agent Maggie Pearlstine Associates, 31 Ashley Gardens, London SW1P 1QE: | Remunerated employment, office, profession etc 1f359ece | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 6 | 2013-07-08-1f359ece-10088-0 |
8dfb71ee4865a701812d7015cf03fcfc8630a287 | £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-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 7 | 2013-07-08-1f359ece-10088-0 |
acea0bb3594de6736bdf07fe2e8c68e0c2910b23 | £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-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 8 | 2013-07-08-1f359ece-10088-0 |
89fae6957420c76451bd9c65207e852e884a50ac | Name of donor: (1) Friedrich Ebert Stiftung (2) European Leadership Network | Overseas visits 80ef1083 | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2013-07-08-80ef1083-10088-0 |
b1ddc48d49e137d900c3975953e8fffd95938d6f | 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-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2013-07-08-80ef1083-10088-0 |
b6967d02ce8b1f1c6588676e3fc5590a36efbd9a | 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-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 2 | 2013-07-08-80ef1083-10088-0 |
536fd3d1b0394ba7b2450f5dffe8892d60de7216 | Destination of visit: Washington DC | Overseas visits 80ef1083 | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 3 | 2013-07-08-80ef1083-10088-0 |
f54d3a104ab6eed4ec25b79c5cdffa67d9184b36 | Date of visit: 16-18 April 2012 | Overseas visits 80ef1083 | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 4 | 2013-07-08-80ef1083-10088-0 |
33ad05b8d5959976c848d682e9ba36694510b22c | 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-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 5 | 2013-07-08-80ef1083-10088-0 |
5b6f200fc8a039cedaa84e8825211f39b8312687 | (Registered 24 April 2012) | Overseas visits 80ef1083 | 2013-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 6 | 2013-07-08-80ef1083-10088-0 |
2df107ee9120dec19bf58b2e138bd32caa85697c | 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-07-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 0 | 2013-07-08-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");