items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
32 rows where person_id = "uk.org.publicwhip/person/10088" and sort_order = 12 sorted by category_id
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 |
---|---|---|---|---|---|---|---|
2c0b5b3a0700acd1067a7a2de460025e2c63ddef | 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-09-06 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2010-09-06-1f359ece-10088-0 |
ed491b498408c656c49a34bd22d58909c9109efb | 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-10-25 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2010-10-25-1f359ece-10088-0 |
2dd3a357cf85f4f32754ee67d9d9e6a7e5731657 | Payment of £250 received on 16 October 2010 for an article for Scotland on Sunday on 5 September 2010. Address: Barclay House, 108 Holyrood Road, Edinburgh EH8 8AS. Hours: 4 hrs. (Registered 21 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 | 12 | 2010-11-08-1f359ece-10088-0 |
1baf865c48b750c336b2c80193f250bf1790efe2 | Payment of £250 received on 16 October 2010 for an article for Scotland on Sunday on 5 September 2010. Address: Barclay House, 108 Holyrood Road, Edinburgh EH8 8AS. Hours: 4 hrs. (Registered 21 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 | 12 | 2010-11-22-1f359ece-10088-0 |
e39d5cf00b31dfe4290aaad3a4fcc41a82ef29e9 | Payment of £250 received on 16 October 2010 for an article for Scotland on Sunday on 5 September 2010. Address: Barclay House, 108 Holyrood Road, Edinburgh EH8 8AS. Hours: 4 hrs. (Registered 21 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 | 12 | 2010-12-06-1f359ece-10088-0 |
2a6fe60ebc1654dfe3110a37ff57106b48d622eb | Payment of £250 received on 16 October 2010 for an article for Scotland on Sunday on 5 September 2010. Address: Barclay House, 108 Holyrood Road, Edinburgh EH8 8AS. Hours: 4 hrs. (Registered 21 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 | 12 | 2010-12-20-1f359ece-10088-0 |
b4fffc7d822571bf5f90b6f937ce072696a6943c | Payment of £250 received on 16 October 2010 for an article for Scotland on Sunday on 5 September 2010. Address: Barclay House, 108 Holyrood Road, Edinburgh EH8 8AS. Hours: 4 hrs. (Registered 21 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 | 12 | 2011-01-10-1f359ece-10088-0 |
b2b7e52d67dfc947a1dbe3519b6fd230a26a84d6 | Payment of £100 received on 15 December 2010 for an article in The Scotsman on 14 November 2010. Address of payer: Barclay House, 108 Holyrood Road, Edinburgh EH8 8AS. Hours: 3 hrs. (Registered 23 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 | 12 | 2011-01-24-1f359ece-10088-0 |
9b94f6a9d6cde476bf83ea725741093117bd4699 | Payment of £100 received on 15 December 2010 for an article in The Scotsman on 14 November 2010. Address of payer: Barclay House, 108 Holyrood Road, Edinburgh EH8 8AS. Hours: 3 hrs. (Registered 23 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 | 12 | 2011-02-07-1f359ece-10088-0 |
af6f4944f8af9e91411ecebb1bbbf8afa79aa70b | 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-28 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2011-02-28-1f359ece-10088-0 |
d0207fe58902b0cda57afc359c1a925906345696 | 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-03-14 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2011-03-14-1f359ece-10088-0 |
282269c2fd48861b8cd37baa7c6cf8672eace101 | 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-03-28 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2011-03-28-1f359ece-10088-0 |
27d70ac101eae92cd56ec83b098d5b6752930736 | 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-04-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2011-04-18-1f359ece-10088-0 |
fdb268a843579f9bfdbe40b841e3692496a8a1c7 | 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-05-03 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2011-05-03-1f359ece-10088-0 |
2c0b4229caa43aa9d1f9812f1601afac1e30a34d | 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-05-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2011-05-16-1f359ece-10088-0 |
48a6d068560fdb1c85b3e213c287562df7128034 | Payment of £400 received on 16 March 2011 in respect of a seminar I gave to students of Wroxton College on 9 March 2011. Address: Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX. Hours: 1.5 hrs. (Registered 17 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-06 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2011-06-06-1f359ece-10088-0 |
3fc6de2b18e353964b9a755a4ce6ec4a4eae8ecf | Payment of £400 received on 16 March 2011 in respect of a seminar I gave to students of Wroxton College on 9 March 2011. Address: Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX. Hours: 1.5 hrs. (Registered 17 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-06-20 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2011-06-20-1f359ece-10088-0 |
0c8a7f094e02e8d2318e73161084a4c7426d36c0 | Payment of £400 received on 16 March 2011 in respect of a seminar I gave to students of Wroxton College on 9 March 2011. Address: Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX. Hours: 1.5 hrs. (Registered 17 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-06 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2011-07-06-1f359ece-10088-0 |
87405218a18b15a8a503473a64b3e606ff8fee35 | Payment of £400 received on 16 March 2011 in respect of a seminar I gave to students of Wroxton College on 9 March 2011. Address: Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX. Hours: 1.5 hrs. (Registered 17 March 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-07-19 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 12 | 2011-07-19-1f359ece-10088-0 |
6b5bb821aa5bbff9611d65e9d4cac76762436529 | Mr Reg B. Clark (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 | 12 | 2006-05-12-9e46def6-10088-0 |
179563f21c341f4dd3bfe3ed6533fcbf8b3ce809 | Mr Reg B. Clark (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 | 12 | 2006-06-21-9e46def6-10088-0 |
863de62ccd321fad093e71bb8176df32a5034f46 | Mr Reg B. Clark (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 | 12 | 2006-07-25-9e46def6-10088-0 |
b219afd2dd08a6710179905908ed3bbb1447148b | Mr Reg B. Clark (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 | 12 | 2006-09-19-9e46def6-10088-0 |
c7e22ab9b0805aefa1f1aec8e53fde76bb6e74b6 | Mr Reg B. Clark (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 | 12 | 2006-11-06-9e46def6-10088-0 |
d53ca55d428c71c8ad63f155a8a9ba485254611e | Mr Reg B. Clark (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 | 12 | 2006-11-27-9e46def6-10088-0 |
9316a4c2975b462cdaaf3b5834f7c7bf9edf2d6a | Mr Reg B. Clark (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 | 12 | 2006-12-11-9e46def6-10088-0 |
fe225f77247301de22741371fe766f383352d9bb | Mr Reg B. Clark (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 | 12 | 2007-01-09-9e46def6-10088-0 |
320a7c83aecf70d65e4bd2abdd6bef65715ab230 | Mr Reg B. Clark (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 | 12 | 2007-01-23-9e46def6-10088-0 |
3f3909758129cc488e35182c660b0c79b1eac2bf | Mr Reg B. Clark (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 | 12 | 2007-02-06-9e46def6-10088-0 |
5e3bdf78e57b2b863b5378d9f3a5dd82c654397a | Mr Reg B. Clark (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 | 12 | 2007-02-27-9e46def6-10088-0 |
6117729aae6cfb0c8253f9835332013865dd082b | Mr Reg B. Clark (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 | 12 | 2007-03-13-9e46def6-10088-0 |
b1cdf816285e8d8245ae144ce4e9c54ebe02abf5 | Mr Reg B. Clark (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 | 12 | 2007-03-26-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");