items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
25 rows where person_id = "uk.org.publicwhip/person/10088" and sort_order = 13 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, member_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
d01789597c9181d441d530452df78e8b6cf5cb7f | 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-05-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2011-05-16-1f359ece-10088-0 |
cbcc373ea98e9e68c3d76717d4d6f84fb19c81c1 | 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-05-03 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2011-05-03-1f359ece-10088-0 |
35b01e301450616ea4558cc52e1d345ce8a03f69 | 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-04-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2011-04-18-1f359ece-10088-0 |
c88fca9889c2ad8394a2737e346b3c117b88b156 | 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-03-28 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2011-03-28-1f359ece-10088-0 |
bcabcd04a4b034fb1b2e3106738d0c5ba13676a7 | 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-03-14 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2011-03-14-1f359ece-10088-0 |
04e0a96a8ae5e3934e860a2bbcfe54e1c85a3810 | 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-28 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2011-02-28-1f359ece-10088-0 |
267d79c64f3dd101026953d45a91ecd86f63ba7e | 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-02-07 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2011-02-07-1f359ece-10088-0 |
e8d23bb3735abde9ba78ac9c888d148ff74e46cd | 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-01-24 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2011-01-24-1f359ece-10088-0 |
ccb42b2f4559cc7bf7863ea11d246796ee31b986 | Payment of £250 received on 10 November 2010 in relation to my accommodation and subsistence expenses for an appearance at a GovNet Communications fringe meeting on 20 September 2010 at the Liberal Party Conference. Address of payer: GovNet Communications, St James Building, Oxford Street, Manchester 1 6PP. Hours: 4 hrs. (Registered 26 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2011-01-10-1f359ece-10088-0 |
05c3f90af972c9d435a34b3e5af86eb3a573e80a | Payment of £250 received on 10 November 2010 in relation to my accommodation and subsistence expenses for an appearance at a GovNet Communications fringe meeting on 20 September 2010 at the Liberal Party Conference. Address of payer: GovNet Communications, St James Building, Oxford Street, Manchester 1 6PP. Hours: 4 hrs. (Registered 26 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2010-12-20-1f359ece-10088-0 |
379c904a3a8e235f7f4c35b982e46cd12e9b5a94 | Payment of £250 received on 10 November 2010 in relation to my accommodation and subsistence expenses for an appearance at a GovNet Communications fringe meeting on 20 September 2010 at the Liberal Party Conference. Address of payer: GovNet Communications, St James Building, Oxford Street, Manchester 1 6PP. Hours: 4 hrs. (Registered 26 November 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-06 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2010-12-06-1f359ece-10088-0 |
f3a20124a5ee41cc82323201284c8b194a6cf598 | 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-10-25 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 13 | 2010-10-25-1f359ece-10088-0 |
0f012f0c46ab781136f4b3297d276130385653cc | Mr Maitland Mackie (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 | 13 | 2007-03-26-9e46def6-10088-0 |
7cad37fdcf888ff1fd87d8d1b7f8c68da3dfbfa8 | Mr Maitland Mackie (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 | 13 | 2007-03-13-9e46def6-10088-0 |
3a9f0590b81a3e53cf6c1ad23d0026bde5063015 | Mr Maitland Mackie (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 | 13 | 2007-02-27-9e46def6-10088-0 |
84b977515e48261c62b2162e277a28a870fd4bfd | Mr Maitland Mackie (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 | 13 | 2007-02-06-9e46def6-10088-0 |
c6898f5da1c6f7efc15d4d3525b3c56ca9231734 | Mr Maitland Mackie (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 | 13 | 2007-01-23-9e46def6-10088-0 |
adcae1575d4f699f6d94c7ee5703a39241d4c4c1 | Mr Maitland Mackie (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 | 13 | 2007-01-09-9e46def6-10088-0 |
fad5afd517df8bffc1d06761d77645a4147f1f38 | Mr Maitland Mackie (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 | 13 | 2006-12-11-9e46def6-10088-0 |
f8eac20276491c7c9f319e22fbb4882cb77d764f | Mr Maitland Mackie (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 | 13 | 2006-11-27-9e46def6-10088-0 |
eca3921b6848bd3051c02c21d7e6cf1b34b3a9a1 | Mr Maitland Mackie (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 | 13 | 2006-11-06-9e46def6-10088-0 |
cc7598b5ca8eba9d7ec24edef000397ffdbbd711 | Mr Maitland Mackie (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 | 13 | 2006-09-19-9e46def6-10088-0 |
d77246f87586478e8a9f0b4393475608530af989 | Mr Maitland Mackie (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 | 13 | 2006-07-25-9e46def6-10088-0 |
03f60c866f7a56e14528f42e921f08668741831e | Mr Maitland Mackie (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 | 13 | 2006-06-21-9e46def6-10088-0 |
020853686e723e159ea6b0b4619977231be553d2 | Mr Maitland Mackie (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 | 13 | 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");