items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
40 rows where person_id = "uk.org.publicwhip/person/10088" and sort_order = 11 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, member_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
b8cd93c9eab933ec349f2b09b74ea14f451f4212 | £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-05-20 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2013-05-20-1f359ece-10088-0 |
becf698686ab3cd0ad84e1bf13fd61e62697024d | 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-01-13 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2012-01-13-1f359ece-10088-0 |
a70065f146914fc6616b8e401cfe42c369c8b7b8 | 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 | 2011-12-13 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-12-13-1f359ece-10088-0 |
9342932fe1f96c05da037fa7175e417f54ec8997 | 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 | 2011-11-29 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-11-29-1f359ece-10088-0 |
66c49e6f63f154229ac03403f2d77d3e199a46ea | 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 | 2011-11-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-11-16-1f359ece-10088-0 |
3982f7aba0f4825611aab28885abaf5e22df6085 | 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 | 2011-10-31 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-10-31-1f359ece-10088-0 |
4e0316d5d6bfdeb871c4982ec99674d4d0519f76 | 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 | 2011-10-17 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-10-17-1f359ece-10088-0 |
b478bc26bf3809d5fa221b846e9051ecdeb9f749 | Payment of £300 received on 29 December 2010 in respect of an article for the Independent on Sunday on 3 November 2010. Address: 2 Derry Street, London, W8 5HF. Hours: 4 hrs. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-07-19-1f359ece-10088-0 |
186745b2d90ac6faa040bdb05b91342195df1df1 | Payment of £300 received on 29 December 2010 in respect of an article for the Independent on Sunday on 3 November 2010. Address: 2 Derry Street, London, W8 5HF. Hours: 4 hrs. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-07-06-1f359ece-10088-0 |
1fb99b37e577227540d877311b3623c6175cbebb | Payment of £300 received on 29 December 2010 in respect of an article for the Independent on Sunday on 3 November 2010. Address: 2 Derry Street, London, W8 5HF. Hours: 4 hrs. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-06-20-1f359ece-10088-0 |
45addc3e815867cad2dc1b9383b62daa7859d65a | Payment of £300 received on 29 December 2010 in respect of an article for the Independent on Sunday on 3 November 2010. Address: 2 Derry Street, London, W8 5HF. Hours: 4 hrs. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-06-06-1f359ece-10088-0 |
4d2c26313e260cc582926f6d304ff9f3041e8ed7 | Payment of £250 received as speaker’s fee at the Annual Conference of Employers in Voluntary Housing on 29 October 2010. Address of payer: 137 Sauchiehall Street, Glasgow G2 3EW. Hours: 5 hrs. Fee donated to charity. (Registered 25 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-05-16-1f359ece-10088-0 |
3aac50cf014dd797f3eb708f0c5667d8bdc34027 | Payment of £250 received as speaker’s fee at the Annual Conference of Employers in Voluntary Housing on 29 October 2010. Address of payer: 137 Sauchiehall Street, Glasgow G2 3EW. Hours: 5 hrs. Fee donated to charity. (Registered 25 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-05-03-1f359ece-10088-0 |
9f86955c686e6c5602f1be4ca8d5e344f51546ce | Payment of £250 received as speaker’s fee at the Annual Conference of Employers in Voluntary Housing on 29 October 2010. Address of payer: 137 Sauchiehall Street, Glasgow G2 3EW. Hours: 5 hrs. Fee donated to charity. (Registered 25 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-04-18-1f359ece-10088-0 |
6737b47536fbc91497ba22106c908ac43b701c6b | Payment of £250 received as speaker’s fee at the Annual Conference of Employers in Voluntary Housing on 29 October 2010. Address of payer: 137 Sauchiehall Street, Glasgow G2 3EW. Hours: 5 hrs. Fee donated to charity. (Registered 25 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-03-28-1f359ece-10088-0 |
8bd52029c3ad1846c857bc6ed1e6407276c734e0 | Payment of £250 received as speaker’s fee at the Annual Conference of Employers in Voluntary Housing on 29 October 2010. Address of payer: 137 Sauchiehall Street, Glasgow G2 3EW. Hours: 5 hrs. Fee donated to charity. (Registered 25 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-03-14-1f359ece-10088-0 |
aa7f846a29183a0d920dbff2510c0e766f465f5a | Payment of £250 received as speaker’s fee at the Annual Conference of Employers in Voluntary Housing on 29 October 2010. Address of payer: 137 Sauchiehall Street, Glasgow G2 3EW. Hours: 5 hrs. Fee donated to charity. (Registered 25 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-02-28-1f359ece-10088-0 |
e3b19aab7321aa0183e2cc8028faa8c2710f669d | Payment of £400 received on 8 December 2010 for an article for The Times on 11 November 2010. Address of payer: News International Supply Company Ltd, PO Box 151, Peterborough PE7 8YT. Hours: 4 hrs. (Registered 10 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-02-07-1f359ece-10088-0 |
c84a55453ddfe3863c8114c4eb56e728f840ee07 | Payment of £400 received on 8 December 2010 for an article for The Times on 11 November 2010. Address of payer: News International Supply Company Ltd, PO Box 151, Peterborough PE7 8YT. Hours: 4 hrs. (Registered 10 December 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-01-24-1f359ece-10088-0 |
08a90eb89c098455ff30e2cf29a9046bc1ec8a80 | Payment of £100 received on 16 September 2010 in respect of my appearance at the Edinburgh Book Festival on 14 August 2010: Address of payer: Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR. Hours: 4 hours. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2011-01-10-1f359ece-10088-0 |
665eb3e22369f95da5ffbfadc2c16a3daf88a61a | Payment of £100 received on 16 September 2010 in respect of my appearance at the Edinburgh Book Festival on 14 August 2010: Address of payer: Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR. Hours: 4 hours. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2010-12-20-1f359ece-10088-0 |
9f46f2fc747a1739754e3490c5c5ab38f3eaba27 | Payment of £100 received on 16 September 2010 in respect of my appearance at the Edinburgh Book Festival on 14 August 2010: Address of payer: Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR. Hours: 4 hours. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-06 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2010-12-06-1f359ece-10088-0 |
d73a67ad2cc68c8bf3dd8cf5985666f13c1a0096 | Payment of £100 received on 16 September 2010 in respect of my appearance at the Edinburgh Book Festival on 14 August 2010: Address of payer: Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR. Hours: 4 hours. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2010-11-22-1f359ece-10088-0 |
47f69f2a7f34cdeb0f082421081941cec2bf60db | Payment of £100 received on 16 September 2010 in respect of my appearance at the Edinburgh Book Festival on 14 August 2010: Address of payer: Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR. Hours: 4 hours. (Registered 1 October 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2010-11-08-1f359ece-10088-0 |
b876660c3adce685456faedc95d54fe278693e46 | 18 August 2010, payment of £15 for speech at the Probus Club of Auchtermuchty, Fife on 18. Hours: 3 hrs. Fee donated to charity. (Registered 31 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-10-25 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2010-10-25-1f359ece-10088-0 |
89af72848ef2eda6d5af152c8ce973a65462ed43 | 13 August 2010, payment of £100 for appearance on the Adam Boulton Show on Sky TV on 11 July 2010. Hours: 4 hrs. (Registered 31 August 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2010-09-06-1f359ece-10088-0 |
36e9df56377deef168bfa4abd963dda354731ad1 | 11 January 2010, received £150 for speech at Centre for Parliamentary Studies seminar on 25 November 2009. Hours: 1.5 hrs. (Registered 12 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2010-02-03-1f359ece-10088-0 |
8694c05ac50f5b160febc75e27685c1ee927f285 | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-03-26 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2007-03-26-9e46def6-10088-0 |
5b4ce331ff04689317bcd3230bbfa0fde4ab6dc0 | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-03-13 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2007-03-13-9e46def6-10088-0 |
ae63cacd4a5f5b893e3bf9d9c6fc070abce6f5c0 | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-02-27 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2007-02-27-9e46def6-10088-0 |
3ee001fb13a9e6ce8fd54535754a173818fdcded | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-02-06 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2007-02-06-9e46def6-10088-0 |
032708ef1049a2b796d834618c8672a37c96382e | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-01-23 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2007-01-23-9e46def6-10088-0 |
16d426aa26c7cd5c6970c3194bf2787ddf7e4f33 | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-01-09 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2007-01-09-9e46def6-10088-0 |
1dfa3518d80fde76fe2fa67e5fd1517714632f88 | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-12-11 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2006-12-11-9e46def6-10088-0 |
6b5912ba12b1818622ba03e81eeaa94db374240a | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-11-27 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2006-11-27-9e46def6-10088-0 |
56ba3cb72bd5b43edf96a1378e5bc00c5a771dee | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-11-06 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2006-11-06-9e46def6-10088-0 |
e9a451cda2f4eccd1c368b27b1999862eebd04b0 | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-09-19 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2006-09-19-9e46def6-10088-0 |
da517cf8f7c05474ed973d08a2fc0c029f361b16 | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-07-25 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2006-07-25-9e46def6-10088-0 |
37ef50762f20759bc6725fa888aba2e90276a83f | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2006-06-21-9e46def6-10088-0 |
84daf8175db948a250b415dab83b7638be8cba45 | Mr Christopher Bones (personal donation) | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 11 | 2006-05-12-9e46def6-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");