Data source: mySociety Data · About: simonw/register-of-members-interests-datasette

2,690 rows where person_id = "uk.org.publicwhip/person/10088" sorted by date descending

View and edit SQL

Suggested facets: category_id, member_id, sort_order, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
57c1ad139f104982a2e1397922838527fc9e50ca Scottish American Investment Company PLC (£15,001–£20,000). My Directorship came to an end on 31st March 2014. (Updated 29 April 2014) : Remunerated directorships ead1ca87 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-30-ead1ca87-10088-0
ee8772564884b19d9e5cba4ef3bbdf0fb7b77e18 Payment of £5,000 gross (£3,000 net) received on 31 March 2014.  Hours: 12 hrs. (Registered 29 April 2014) Remunerated directorships ead1ca87 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-03-30-ead1ca87-10088-0
daae730e706a75dd3e58ed58c60dc1b07751b1d3 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 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-30-1f359ece-10088-0
70a7cbd5b248231d0a094867c762f9a440e46fae Payments received from BBC for appearances on ‘Any Questions’. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL: Remunerated employment, office, profession etc 1f359ece 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-30-1f359ece-10088-1
2a1a41da1cb68dfadf406db28a4dffaafded56cb Payment of £150 received on 23 May 2014 for appearance on 16 May 2014. Hours: 5 hrs. (Registered 5 June 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-03-30-1f359ece-10088-1
5dfb16420aa9ba09d965bd5987f50e0752e699d2 Payment of £150 received on 13 February 2015. Hours: 2 hrs. (Registered 4 March 2015) Remunerated employment, office, profession etc 1f359ece 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 2 2015-03-30-1f359ece-10088-1
bfef9c58d19949385811b872eaa82e61a9ac4994 13 June 2014, received twelve bottles of wine, of unknown value but over £66, in return for a speech made on 20 May 2014 to Fleming Family and Partners, 15 Suffolk Street, London SW1Y 4HG. Hours: 5 hrs, including preparation. (Registered 8 July 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-30-1f359ece-10088-2
a493c08ff24458d2c879fef4cc35dbd911730267 6 July 2014, received £2,325 from the literary agents Maggie Pearlstine Associates, 31 Ashley Gardens, London SW1P 1QE, in respect of my participation in a panel discussion on 15 May 2014, at the annual conference in Manchester of the British Insurance Brokers Association, John Stow House, 18 Bevis Marks, London EC3A 7JB. Hours: 16 hrs including travel and overnight stay. (Registered 4 August 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-30-1f359ece-10088-3
53b331418f4c456487c86014e80a2cc5445d97ef 4 September 2014, £150 received from the Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR, for two appearances. Hours: 6 hrs. (Registered 10 September 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-30-1f359ece-10088-4
3d1c530802df0e577c2dc24f3138022f4c572c34 4 November 2014, £100 received from BBC Parliament, Broadcasting House, Portland Place, London W1A 1AA, for a panel discussion recorded on 3 November 2014. Hours: 3 hrs. (Registered 12 November 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-30-1f359ece-10088-5
6eb91c9eb0b68c543d6a45c3203d4cd9fe30542d 3 December 2014, £300 received from Wroxton College, Wroxton OX15 6PX, for participating in a seminar on 26 November 2014. Hours: 2 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-30-1f359ece-10088-6
23f440adef4373b3030e93a8b648de9fd1da4a8b 3 December 2014, £300 received from GovNet, 10 Buckingham Place, London SW1E 6HX for travel and accommodation costs related to my participation in a panel discussion at the Liberal Democrat party conference on 8 October 2014. Hours: 4 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-30-1f359ece-10088-7
19d4edd2d90ebf29b556142e548ac3453fadaf3a £2,400 received from J P Morgan Securities Plc, 25 Bank Street, Floor 22, London E14 5JP, for participation on a panel as part of the JP Morgan Casenove Best of British Conference on 13 November 2014. Hours: approx. 3 hrs. (Registered 19 February 2015) Remunerated employment, office, profession etc 1f359ece 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-30-1f359ece-10088-8
3f3bb693dc780777e8b0b120c5d6a350fb99d67b As a former Leader of the Liberal Democrats, I enjoy Honorary Membership for life of the National Liberal Club . (Registered 29 August 2013) Gifts, benefits and hospitality (UK) 84642823 2015-03-30 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-30-84642823-10088-0
a6c091e31e286aa44c8269532af42c850b7b9169 Scottish American Investment Company PLC (£15,001–£20,000). My Directorship came to an end on 31st March 2014. (Updated 29 April 2014) : Remunerated directorships ead1ca87 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-09-ead1ca87-10088-0
7e9c427b374626f0f1be8e424bf41065132a6ab7 Payment of £5,000 gross (£3,000 net) received on 31 March 2014.  Hours: 12 hrs. (Registered 29 April 2014) Remunerated directorships ead1ca87 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-03-09-ead1ca87-10088-0
a044844f064a7d3a64eba24553a1e26956f2156f 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 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-09-1f359ece-10088-0
dc9f8000e5f3107f212c1457ce967cddfb48e1e2 Payments received from BBC for appearances on ‘Any Questions’. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL: Remunerated employment, office, profession etc 1f359ece 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-09-1f359ece-10088-1
6a52d70c1b1c7fc0e8cc5698012ffc4360f48341 Payment of £150 received on 23 May 2014 for appearance on 16 May 2014. Hours: 5 hrs. (Registered 5 June 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-03-09-1f359ece-10088-1
c920930e8b3342f8732d7bd10fb5fcdef8dc2b3c Payment of £150 received on 13 February 2015. Hours: 2 hrs. (Registered 4 March 2015) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 2 2015-03-09-1f359ece-10088-1
4a633875c9c152acf46a63545a2344f033bfdae8 13 June 2014, received twelve bottles of wine, of unknown value but over £66, in return for a speech made on 20 May 2014 to Fleming Family and Partners, 15 Suffolk Street, London SW1Y 4HG. Hours: 5 hrs, including preparation. (Registered 8 July 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-09-1f359ece-10088-2
673720873330ae99788c70a2dbb244b09c7d0cad 6 July 2014, received £2,325 from the literary agents Maggie Pearlstine Associates, 31 Ashley Gardens, London SW1P 1QE, in respect of my participation in a panel discussion on 15 May 2014, at the annual conference in Manchester of the British Insurance Brokers Association, John Stow House, 18 Bevis Marks, London EC3A 7JB. Hours: 16 hrs including travel and overnight stay. (Registered 4 August 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-09-1f359ece-10088-3
d3f753a8b517334e3ccefe8c0a97b2be7b29c9c7 4 September 2014, £150 received from the Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR, for two appearances. Hours: 6 hrs. (Registered 10 September 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-09-1f359ece-10088-4
1fe063e7885749e93fcea05f3b8d8faa0d2ae6ec 4 November 2014, £100 received from BBC Parliament, Broadcasting House, Portland Place, London W1A 1AA, for a panel discussion recorded on 3 November 2014. Hours: 3 hrs. (Registered 12 November 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-09-1f359ece-10088-5
197ced373f99ef2801101b2598edb062c9b16c0c 3 December 2014, £300 received from Wroxton College, Wroxton OX15 6PX, for participating in a seminar on 26 November 2014. Hours: 2 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-09-1f359ece-10088-6
cc0ae856f53008d69c8319ab0e6ce61910d62171 3 December 2014, £300 received from GovNet, 10 Buckingham Place, London SW1E 6HX for travel and accommodation costs related to my participation in a panel discussion at the Liberal Democrat party conference on 8 October 2014. Hours: 4 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-09-1f359ece-10088-7
6a83e98bf105e3ed55c9dd30a80a633b2d57497e £2,400 received from J P Morgan Securities Plc, 25 Bank Street, Floor 22, London E14 5JP, for participation on a panel as part of the JP Morgan Casenove Best of British Conference on 13 November 2014. Hours: approx. 3 hrs. (Registered 19 February 2015) Remunerated employment, office, profession etc 1f359ece 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-09-1f359ece-10088-8
5f4701ad9cdfc51aa576222dd4a8eeb16143cf95 As a former Leader of the Liberal Democrats, I enjoy Honorary Membership for life of the National Liberal Club . (Registered 29 August 2013) Gifts, benefits and hospitality (UK) 84642823 2015-03-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-03-09-84642823-10088-0
9bec7615e5efca4d0c3c7d3f92092da4834b9e72 Scottish American Investment Company PLC (£15,001–£20,000). My Directorship came to an end on 31st March 2014. (Updated 29 April 2014) : Remunerated directorships ead1ca87 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-23-ead1ca87-10088-0
c84d79c5a49ae8032bf94259696082ccdb2449c9 Payment of £5,000 gross (£3,000 net) received on 31 March 2014.  Hours: 12 hrs. (Registered 29 April 2014) Remunerated directorships ead1ca87 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-02-23-ead1ca87-10088-0
42bdf1214bc024053725c54a2fc140e9221b0af3 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 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-23-1f359ece-10088-0
1fd9d8a6091dd4bafeb651f170ea728aa0aaa198 Payments received from BBC for appearances on ‘Any Questions’. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL: Remunerated employment, office, profession etc 1f359ece 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-23-1f359ece-10088-1
e2f8565a4dfe9ad6b0f4d1c0a87766fe7016f3f7 Payment of £150 received on 23 May 2014 for appearance on 16 May 2014. Hours: 5 hrs. (Registered 5 June 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-02-23-1f359ece-10088-1
8a2c046a854e462f8c596358f11b8d8d8dcb80cb 13 June 2014, received twelve bottles of wine, of unknown value but over £66, in return for a speech made on 20 May 2014 to Fleming Family and Partners, 15 Suffolk Street, London SW1Y 4HG. Hours: 5 hrs, including preparation. (Registered 8 July 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-23-1f359ece-10088-2
bf6cd8bd2b654e25b673d155b2e6dc035569d4c0 6 July 2014, received £2,325 from the literary agents Maggie Pearlstine Associates, 31 Ashley Gardens, London SW1P 1QE, in respect of my participation in a panel discussion on 15 May 2014, at the annual conference in Manchester of the British Insurance Brokers Association, John Stow House, 18 Bevis Marks, London EC3A 7JB. Hours: 16 hrs including travel and overnight stay. (Registered 4 August 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-23-1f359ece-10088-3
0fee9556b56d5ec3c6452159a5394444da4d796c 4 September 2014, £150 received from the Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR, for two appearances. Hours: 6 hrs. (Registered 10 September 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-23-1f359ece-10088-4
568b3ebd482df7dbe36e923eab4dc020c1035933 4 November 2014, £100 received from BBC Parliament, Broadcasting House, Portland Place, London W1A 1AA, for a panel discussion recorded on 3 November 2014. Hours: 3 hrs. (Registered 12 November 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-23-1f359ece-10088-5
e7bfa24e51c0eddaa9c51c824161f17e361191e4 3 December 2014, £300 received from Wroxton College, Wroxton OX15 6PX, for participating in a seminar on 26 November 2014. Hours: 2 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-23-1f359ece-10088-6
be95be500e7440108e2b777ed441c064350dd4b4 3 December 2014, £300 received from GovNet, 10 Buckingham Place, London SW1E 6HX for travel and accommodation costs related to my participation in a panel discussion at the Liberal Democrat party conference on 8 October 2014. Hours: 4 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-23-1f359ece-10088-7
ac53a5e74d32330023ed8fb3bc3e91568543827e £2,400 received from J P Morgan Securities Plc, 25 Bank Street, Floor 22, London E14 5JP, for participation on a panel as part of the JP Morgan Casenove Best of British Conference on 13 November 2014. Hours: approx. 3 hrs. (Registered 19 February 2015) Remunerated employment, office, profession etc 1f359ece 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-23-1f359ece-10088-8
934995f547528990f82260c2060bee8d106f6728 As a former Leader of the Liberal Democrats, I enjoy Honorary Membership for life of the National Liberal Club . (Registered 29 August 2013) Gifts, benefits and hospitality (UK) 84642823 2015-02-23 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-23-84642823-10088-0
d8874b5b65fc405cc99d512c2a08ff8180e3188d Scottish American Investment Company PLC (£15,001–£20,000). My Directorship came to an end on 31st March 2014. (Updated 29 April 2014) : Remunerated directorships ead1ca87 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-09-ead1ca87-10088-0
7d0912027f796fdc6e149b27e6dc0189977fc926 Payment of £5,000 gross (£3,000 net) received on 31 March 2014.  Hours: 12 hrs. (Registered 29 April 2014) Remunerated directorships ead1ca87 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-02-09-ead1ca87-10088-0
cfd992dc7fec64766ac778e2cc19bbfe29a73705 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 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-09-1f359ece-10088-0
67ac52c8400f3114c93c4be075b136ff76b3d69a Payments received from BBC for appearances on ‘Any Questions’. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL: Remunerated employment, office, profession etc 1f359ece 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-09-1f359ece-10088-1
987a210387be374786899d607ca46d65d97f9397 Payment of £150 received on 23 May 2014 for appearance on 16 May 2014. Hours: 5 hrs. (Registered 5 June 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-02-09-1f359ece-10088-1
b4a4d791e3a8328a83373de3edaa8d94be286d49 13 June 2014, received twelve bottles of wine, of unknown value but over £66, in return for a speech made on 20 May 2014 to Fleming Family and Partners, 15 Suffolk Street, London SW1Y 4HG. Hours: 5 hrs, including preparation. (Registered 8 July 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-09-1f359ece-10088-2
82e962f00fa8037f91212283ecdde06579ec6211 6 July 2014, received £2,325 from the literary agents Maggie Pearlstine Associates, 31 Ashley Gardens, London SW1P 1QE, in respect of my participation in a panel discussion on 15 May 2014, at the annual conference in Manchester of the British Insurance Brokers Association, John Stow House, 18 Bevis Marks, London EC3A 7JB. Hours: 16 hrs including travel and overnight stay. (Registered 4 August 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-09-1f359ece-10088-3
e241ea2f91cfd78170c60880738e71092b0b69a1 4 September 2014, £150 received from the Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR, for two appearances. Hours: 6 hrs. (Registered 10 September 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-09-1f359ece-10088-4
f48af4d3942c6a6406aef2ea6c5fe28bedb1f56e 4 November 2014, £100 received from BBC Parliament, Broadcasting House, Portland Place, London W1A 1AA, for a panel discussion recorded on 3 November 2014. Hours: 3 hrs. (Registered 12 November 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-09-1f359ece-10088-5
e1d54a678d5dc0d723f9e8b7d4829f0b727a5a6f 3 December 2014, £300 received from Wroxton College, Wroxton OX15 6PX, for participating in a seminar on 26 November 2014. Hours: 2 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-09-1f359ece-10088-6
6d74dae8c2bc0ddfd5d726c4e1660cfdfeaef1fc 3 December 2014, £300 received from GovNet, 10 Buckingham Place, London SW1E 6HX for travel and accommodation costs related to my participation in a panel discussion at the Liberal Democrat party conference on 8 October 2014. Hours: 4 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-09-1f359ece-10088-7
5320b9e0e659911b9a98856876eeed3c7a30ac70 As a former Leader of the Liberal Democrats, I enjoy Honorary Membership for life of the National Liberal Club . (Registered 29 August 2013) Gifts, benefits and hospitality (UK) 84642823 2015-02-09 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-02-09-84642823-10088-0
14947e42661d4a97d18ef6551832cddc3141e072 Scottish American Investment Company PLC (£15,001–£20,000). My Directorship came to an end on 31st March 2014. (Updated 29 April 2014) : Remunerated directorships ead1ca87 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-26-ead1ca87-10088-0
fcccf92f8b0ea27b677aba2e3a3bcd5561f72c61 Payment of £5,000 gross (£3,000 net) received on 31 December 2013.  Hours: 12 hrs. (Registered 7 January 2014) Remunerated directorships ead1ca87 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-01-26-ead1ca87-10088-0
c7125b046f5432d3e10b18ebf9d21f8b4873da96 Payment of £5,000 gross (£3,000 net) received on 31 March 2014.  Hours: 12 hrs. (Registered 29 April 2014) Remunerated directorships ead1ca87 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 2 2015-01-26-ead1ca87-10088-0
76fb02591a6755bd4ae28b131b70ec55ea2f22b5 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 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-26-1f359ece-10088-0
ef06153c6c543f1000699e0994007c4137c06e0c Payments received from BBC for appearances on ‘Any Questions’. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL: Remunerated employment, office, profession etc 1f359ece 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-26-1f359ece-10088-1
7026b0a0e33ef25ba48ad25ddef0c770559d3eaa Payment of £150 received on 23 May 2014 for appearance on 16 May 2014. Hours: 5 hrs. (Registered 5 June 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-01-26-1f359ece-10088-1
880897b70e8aec878e558b80512814dfae1494cb 13 June 2014, received twelve bottles of wine, of unknown value but over £66, in return for a speech made on 20 May 2014 to Fleming Family and Partners, 15 Suffolk Street, London SW1Y 4HG. Hours: 5 hrs, including preparation. (Registered 8 July 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-26-1f359ece-10088-2
d082cf35961d82deea4fadd22c7cb7ead0c75e4f 6 July 2014, received £2,325 from the literary agents Maggie Pearlstine Associates, 31 Ashley Gardens, London SW1P 1QE, in respect of my participation in a panel discussion on 15 May 2014, at the annual conference in Manchester of the British Insurance Brokers Association, John Stow House, 18 Bevis Marks, London EC3A 7JB. Hours: 16 hrs including travel and overnight stay. (Registered 4 August 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-26-1f359ece-10088-3
afd0a4e8bea3afd11be947cb1640307123350909 4 September 2014, £150 received from the Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR, for two appearances. Hours: 6 hrs. (Registered 10 September 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-26-1f359ece-10088-4
8e211b08c6d4eafb913c1073d440406a79c60b03 4 November 2014, £100 received from BBC Parliament, Broadcasting House, Portland Place, London W1A 1AA, for a panel discussion recorded on 3 November 2014. Hours: 3 hrs. (Registered 12 November 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-26-1f359ece-10088-5
66ba8740401148c44b7d602f7b86113640b885c6 3 December 2014, £300 received from Wroxton College, Wroxton OX15 6PX, for participating in a seminar on 26 November 2014. Hours: 2 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-26-1f359ece-10088-6
4ab258ee2f6fa6b543bb8a35401d0a6f2a8b257a 3 December 2014, £300 received from GovNet, 10 Buckingham Place, London SW1E 6HX for travel and accommodation costs related to my participation in a panel discussion at the Liberal Democrat party conference on 8 October 2014. Hours: 4 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-26-1f359ece-10088-7
e869c5426f3cd28723b8ac27eaad9c630c46a5c1 As a former Leader of the Liberal Democrats, I enjoy Honorary Membership for life of the National Liberal Club . (Registered 29 August 2013) Gifts, benefits and hospitality (UK) 84642823 2015-01-26 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-26-84642823-10088-0
0504732f1dd018646a34e685e0e1fcecd1638839 Scottish American Investment Company PLC (£15,001–£20,000). My Directorship came to an end on 31st March 2014. (Updated 29 April 2014) : Remunerated directorships ead1ca87 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-06-ead1ca87-10088-0
a1978c81e62da1039ca7f1d1f03104383efa7942 Payment of £5,000 gross (£3,000 net) received on 31 December 2013.  Hours: 12 hrs. (Registered 7 January 2014) Remunerated directorships ead1ca87 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-01-06-ead1ca87-10088-0
cb7ce02856422cefb8d252d3dd69c7a47d58b2df Payment of £5,000 gross (£3,000 net) received on 31 March 2014.  Hours: 12 hrs. (Registered 29 April 2014) Remunerated directorships ead1ca87 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 2 2015-01-06-ead1ca87-10088-0
5e12f6359233e1594bcda0741715b1cd220a0dda 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 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-06-1f359ece-10088-0
db6d10d2c4f0fa483b7d89e317a9c86823b15a6f Payments received from BBC for appearances on ‘Any Questions’. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL: Remunerated employment, office, profession etc 1f359ece 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2015-01-06-1f359ece-10088-0
715b8d54740ccdda794b3fa3466e2f01d99e6ccf Payment of £150 received on 23 May 2014 for appearance on 16 May 2014. Hours: 5 hrs. (Registered 5 June 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 2 2015-01-06-1f359ece-10088-0
df831fc422e96337c7187b912fdee2e94bbeb4e0 13 June 2014, received twelve bottles of wine, of unknown value but over £66, in return for a speech made on 20 May 2014 to Fleming Family and Partners, 15 Suffolk Street, London SW1Y 4HG. Hours: 5 hrs, including preparation. (Registered 8 July 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 3 2015-01-06-1f359ece-10088-0
0e82f65ceb3f18f59bbf47655ea71d6dd1cbe76c 6 July 2014, received £2,325 from the literary agents Maggie Pearlstine Associates, 31 Ashley Gardens, London SW1P 1QE, in respect of my participation in a panel discussion on 15 May 2014, at the annual conference in Manchester of the British Insurance Brokers Association, John Stow House, 18 Bevis Marks, London EC3A 7JB. Hours: 16 hrs including travel and overnight stay. (Registered 4 August 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 4 2015-01-06-1f359ece-10088-0
4448679222287d57e75315483970df4818dd5668 4 September 2014, £150 received from the Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR, for two appearances. Hours: 6 hrs. (Registered 10 September 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 5 2015-01-06-1f359ece-10088-0
7f44b1de5ef35bb31b79740ff02bf3f71b227d92 4 November 2014, £100 received from BBC Parliament, Broadcasting House, Portland Place, London W1A 1AA, for a panel discussion recorded on 3 November 2014. Hours: 3 hrs. (Registered 12 November 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 6 2015-01-06-1f359ece-10088-0
ea42064006c4ccaaaeb5a07d498ab1082fc37ebd 3 December 2014, £300 received from Wroxton College, Wroxton OX15 6PX, for participating in a seminar on 26 November 2014. Hours: 2 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 7 2015-01-06-1f359ece-10088-0
24f658bfc66f9cfa2df4e2738171ff42a809b6e0 3 December 2014, £300 received from GovNet, 10 Buckingham Place, London SW1E 6HX for travel and accommodation costs related to my participation in a panel discussion at the Liberal Democrat party conference on 8 October 2014. Hours: 4 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 8 2015-01-06-1f359ece-10088-0
ab58a9df90cc030bc3b377317c9971c227f643b6 As a former Leader of the Liberal Democrats, I enjoy Honorary Membership for life of the National Liberal Club . (Registered 29 August 2013) Gifts, benefits and hospitality (UK) 84642823 2015-01-06 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2015-01-06-84642823-10088-0
a383eb60902b21cfe24b920404db8002032751fa Scottish American Investment Company PLC (£15,001–£20,000). My Directorship came to an end on 31st March 2014. (Updated 29 April 2014) : Remunerated directorships ead1ca87 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2014-12-08-ead1ca87-10088-0
ebfcca038aae38a9b1d5959c5ec29cd144b30ddb Payment of £5,000 gross (£3,000 net) received on 31 December 2013.  Hours: 12 hrs. (Registered 7 January 2014) Remunerated directorships ead1ca87 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2014-12-08-ead1ca87-10088-0
aefc222511b8018d275cbb77212b16c3267c065a Payment of £5,000 gross (£3,000 net) received on 31 March 2014.  Hours: 12 hrs. (Registered 29 April 2014) Remunerated directorships ead1ca87 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 2 2014-12-08-ead1ca87-10088-0
ee1b1ae22047390e91cd6afc174eff2ddc4403a0 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 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2014-12-08-1f359ece-10088-0
b88031ce96c9d68f59156da41f3282165c1f3a72 Payments received from BBC for appearances on ‘Any Questions’. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL: Remunerated employment, office, profession etc 1f359ece 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2014-12-08-1f359ece-10088-0
c198c32ce654ed90c6db63fecb9cd4baa01ee982 Payment of £150 received on 23 May 2014 for appearance on 16 May 2014. Hours: 5 hrs. (Registered 5 June 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 2 2014-12-08-1f359ece-10088-0
a268e7cfbbb290a1fcb42504500ab59fa579c07a 13 June 2014, received twelve bottles of wine, of unknown value but over £66, in return for a speech made on 20 May 2014 to Fleming Family and Partners, 15 Suffolk Street, London SW1Y 4HG. Hours: 5 hrs, including preparation. (Registered 8 July 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 3 2014-12-08-1f359ece-10088-0
8c5d07b680f9b0615cba29a915e99ca70c83a63e 6 July 2014, received £2,325 from the literary agents Maggie Pearlstine Associates, 31 Ashley Gardens, London SW1P 1QE, in respect of my participation in a panel discussion on 15 May 2014, at the annual conference in Manchester of the British Insurance Brokers Association, John Stow House, 18 Bevis Marks, London EC3A 7JB. Hours: 16 hrs including travel and overnight stay. (Registered 4 August 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 4 2014-12-08-1f359ece-10088-0
fb5d588b8cc657de18c61049562213911fc803b1 4 September 2014, £150 received from the Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR, for two appearances. Hours: 6 hrs. (Registered 10 September 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 5 2014-12-08-1f359ece-10088-0
a1d4afc2fc6b6e3148e735c8e10b606f069cb6b2 4 November 2014, £100 received from BBC Parliament, Broadcasting House, Portland Place, London W1A 1AA, for a panel discussion recorded on 3 November 2014. Hours: 3 hrs. (Registered 12 November 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 6 2014-12-08-1f359ece-10088-0
33a5d8617d6f9f0a7e99ddeb3f0ad3068ae94a83 3 December 2014, £300 received from Wroxton College, Wroxton OX15 6PX, for participating in a seminar on 26 November 2014. Hours: 2 hrs. (Registered 4 December 2014) Remunerated employment, office, profession etc 1f359ece 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 7 2014-12-08-1f359ece-10088-0
1f93adc28879df2669bec000a958bc23ffff1e7c As a former Leader of the Liberal Democrats, I enjoy Honorary Membership for life of the National Liberal Club . (Registered 29 August 2013) Gifts, benefits and hospitality (UK) 84642823 2014-12-08 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2014-12-08-84642823-10088-0
37e200aec1877f0930ba0bf09ee68dacffc3b52c Scottish American Investment Company PLC (£15,001–£20,000). My Directorship came to an end on 31st March 2014. (Updated 29 April 2014) : Remunerated directorships ead1ca87 2014-11-24 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2014-11-24-ead1ca87-10088-0
15c6706c86f03b4f24f83c4ba41bff46477c0e6e Payment of £5,000 gross (£3,000 net) received on 31 December 2013.  Hours: 12 hrs. (Registered 7 January 2014) Remunerated directorships ead1ca87 2014-11-24 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2014-11-24-ead1ca87-10088-0
3a32ac65bd95f9998d245972a0af86e47c66a1c1 Payment of £5,000 gross (£3,000 net) received on 31 March 2014.  Hours: 12 hrs. (Registered 29 April 2014) Remunerated directorships ead1ca87 2014-11-24 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 2 2014-11-24-ead1ca87-10088-0
ef560750745372d77495142751395364f9bb88a0 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 2014-11-24 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 0 2014-11-24-1f359ece-10088-0
dae2cc951de929456ac18540425cb93b6726c9e9 Payments received from BBC for appearances on ‘Any Questions’. Address: BBC Contributor Payments, PO Box 480, Manchester M14 0EL: Remunerated employment, office, profession etc 1f359ece 2014-11-24 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 1 2014-11-24-1f359ece-10088-0
a455561893bb40b8651ea39c97fc4ef469d2de42 Payment of £150 received on 23 May 2014 for appearance on 16 May 2014. Hours: 5 hrs. (Registered 5 June 2014) Remunerated employment, office, profession etc 1f359ece 2014-11-24 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 2 2014-11-24-1f359ece-10088-0
b8f7686264976e747a7ac140b0e91111cd47d406 13 June 2014, received twelve bottles of wine, of unknown value but over £66, in return for a speech made on 20 May 2014 to Fleming Family and Partners, 15 Suffolk Street, London SW1Y 4HG. Hours: 5 hrs, including preparation. (Registered 8 July 2014) Remunerated employment, office, profession etc 1f359ece 2014-11-24 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 3 2014-11-24-1f359ece-10088-0
c4dd749a3df3e918b07d79627c1571b526c487ac 6 July 2014, received £2,325 from the literary agents Maggie Pearlstine Associates, 31 Ashley Gardens, London SW1P 1QE, in respect of my participation in a panel discussion on 15 May 2014, at the annual conference in Manchester of the British Insurance Brokers Association, John Stow House, 18 Bevis Marks, London EC3A 7JB. Hours: 16 hrs including travel and overnight stay. (Registered 4 August 2014) Remunerated employment, office, profession etc 1f359ece 2014-11-24 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 4 2014-11-24-1f359ece-10088-0
d1518ac73b6097a6abeda3e64b926cef8c4acd90 4 September 2014, £150 received from the Edinburgh International Book Festival, 5a Charlotte Square, Edinburgh EH2 4DR, for two appearances. Hours: 6 hrs. (Registered 10 September 2014) Remunerated employment, office, profession etc 1f359ece 2014-11-24 Menzies Campbell uk.org.publicwhip/member/40438 Menzies Campbell uk.org.publicwhip/person/10088 5 2014-11-24-1f359ece-10088-0

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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");