items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
404 rows where person_id = "uk.org.publicwhip/person/10088" and sort_order = 1 sorted by category_id
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 |
---|---|---|---|---|---|---|---|
13a5bd46a2f7ff0baa507032614873f0bad62284 | 26 January 2004, fee for a speech at the annual lunch of the Northern Housing Consortium. (Up to £5,000) (Registered 6 February 2004) | Remunerated employment, office, profession etc.. 12405e8c | 2005-01-28 | Menzies Campbell uk.org.publicwhip/member/781 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2005-01-28-12405e8c-10088-0 |
11104a860c6d39a923ded75bc6ff437ebd82efe4 | Occasional income from journalism, broadcasting and lecturing, and opinion poll surveys. Fees from opinion poll surveys are paid to charity or to my local Liberal Democrat Association. | Remunerated employment, office, profession etc 1f359ece | 2000-11-10 | Menzies Campbell uk.org.publicwhip/member/88 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2000-11-10-1f359ece-10088-0 |
ad5088c93d09a7d93fe4f78e56bace13faeb2dc9 | Occasional income from journalism, broadcasting and lecturing, and opinion poll surveys. Fees from opinion poll surveys are paid to charity or to my local Liberal Democrat Association. | Remunerated employment, office, profession etc 1f359ece | 2001-05-14 | Menzies Campbell uk.org.publicwhip/member/88 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2001-05-14-1f359ece-10088-0 |
f8ff0148f3479682471e68c1d40ac3fb59332461 | Occasional income from journalism, broadcasting and lecturing, and opinion poll surveys. Fees from opinion poll surveys are paid to charity or to my local Liberal Democrat Association. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Menzies Campbell uk.org.publicwhip/member/781 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2002-05-14-1f359ece-10088-0 |
72495223e05bb5645a9b9a70c0a7f4434388626a | 26 January 2004, fee for a speech at the annual lunch of the Northern Housing Consortium. (Up to £5,000) (Registered 6 February 2004) | Remunerated employment, office, profession etc 1f359ece | 2004-05-21 | Menzies Campbell uk.org.publicwhip/member/781 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2004-05-21-1f359ece-10088-0 |
201ee2be159c2d82d03d9326f76a8b04c1897a0c | 26 January 2004, fee for a speech at the annual lunch of the Northern Housing Consortium. (Up to £5,000) (Registered 6 February 2004) | Remunerated employment, office, profession etc 1f359ece | 2004-07-16 | Menzies Campbell uk.org.publicwhip/member/781 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2004-07-16-1f359ece-10088-0 |
816f26b9ba271923fd76f7e802a7189eb6537c51 | 26 January 2004, fee for a speech at the annual lunch of the Northern Housing Consortium. (Up to £5,000) (Registered 6 February 2004) | Remunerated employment, office, profession etc 1f359ece | 2004-09-08 | Menzies Campbell uk.org.publicwhip/member/781 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2004-09-08-1f359ece-10088-0 |
5e368b718b5d71060206fe50337e4b74a9fa079c | 26 January 2004, fee for a speech at the annual lunch of the Northern Housing Consortium. (Up to £5,000) (Registered 6 February 2004) | Remunerated employment, office, profession etc 1f359ece | 2004-10-22 | Menzies Campbell uk.org.publicwhip/member/781 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2004-10-22-1f359ece-10088-0 |
57b9387550384a1520ed751a146258aacf351764 | 26 January 2004, fee for a speech at the annual lunch of the Northern Housing Consortium. (Up to £5,000) (Registered 6 February 2004) | Remunerated employment, office, profession etc 1f359ece | 2004-12-03 | Menzies Campbell uk.org.publicwhip/member/781 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2004-12-03-1f359ece-10088-0 |
c76e9eafcacba935086483d92c14b6d44461352c | 16 November 2004, fee for a lecture delivered at the invitation of Proudfoot Consulting in London. (Up to £5,000) (Registered 9 December 2004) | Remunerated employment, office, profession etc 1f359ece | 2005-04-11 | Menzies Campbell uk.org.publicwhip/member/781 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2005-04-11-1f359ece-10088-0 |
367eb5a9d13b74c2afce03af089106941334bd38 | 16 November 2004, fee for a lecture delivered at the invitation of Proudfoot Consulting in London. (Up to £5,000) (Registered 9 December 2004) | Remunerated employment, office, profession etc 1f359ece | 2005-11-01 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2005-11-01-1f359ece-10088-0 |
3acf360853a2fc8773026e9f40a789f2e1f2fe87 | 21 December 2004, fee for a speech at the annual dinner of the Oil Industries Club. (Up to £5,000) (Registered 28 December 2004) | Remunerated employment, office, profession etc 1f359ece | 2005-12-14 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2005-12-14-1f359ece-10088-0 |
5b82763ff900107d0a3a60edd07c6a1e23830f37 | Fee for speech made near Zurich for the Civil Society Association. (Up to £5,000) (Registered 12 December 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-02-13 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2006-02-13-1f359ece-10088-0 |
5cffab991853a181222772fbb17cc73ddb65de20 | Fee for speech made near Zurich for the Civil Society Association. (Up to £5,000) (Registered 12 December 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-02-14 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2006-02-14-1f359ece-10088-0 |
207a293caa42ca9014f8bc4fe5cdf0a237f206b0 | Fee for speech made near Zurich for the Civil Society Association. (Up to £5,000) (Registered 12 December 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-03-24 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2006-03-24-1f359ece-10088-0 |
85dc7a8bbd09b637cb0c2395ce524d5069eefec7 | Fee for speech made near Zurich for the Civil Society Association. (Up to £5,000) (Registered 12 December 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-05-12 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2006-05-12-1f359ece-10088-0 |
1a4643d3a1f58ad2b197879382fc17d1639ee50f | Fee for speech made near Zurich for the Civil Society Association. (Up to £5,000) (Registered 12 December 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-06-21 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2006-06-21-1f359ece-10088-0 |
7a9c0cc013bee6866c2cbe3c87d50943860cb076 | Fee for speech made near Zurich for the Civil Society Association. (Up to £5,000) (Registered 12 December 2005) | Remunerated employment, office, profession etc 1f359ece | 2006-07-25 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2006-07-25-1f359ece-10088-0 |
df10c49bfcbe5dc74acbf992ec5bc5d89f227318 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) (Registered 28 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-09-19 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2006-09-19-1f359ece-10088-0 |
989d842a0fb2d60554255e5464d6c7b3242f0a11 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) (Registered 28 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-11-06 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2006-11-06-1f359ece-10088-0 |
ea5092dced0eee2ba758700f0bcc64d3b31d041f | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) (Registered 28 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-11-27 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2006-11-27-1f359ece-10088-0 |
b0ba62307041859d93f0907ce770902bbc71e2e3 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) (Registered 28 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2006-12-11 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2006-12-11-1f359ece-10088-0 |
eb9ea0b0fe0fb007065fc4089f5bd171ac2b857b | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) (Registered 28 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-01-09 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2007-01-09-1f359ece-10088-0 |
b4f60c15de2cb425104ce16972f86f93dd43b551 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) (Registered 28 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-01-23 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2007-01-23-1f359ece-10088-0 |
fa3afcd5fb26935ee2591d64a30315c659d8aa7d | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) (Registered 28 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-02-06 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2007-02-06-1f359ece-10088-0 |
a4ba1f40cbe46f5a7134ef558b212ba74efaf8d6 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) (Registered 28 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-02-27 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2007-02-27-1f359ece-10088-0 |
fc831e114ba93add92473681cb98285cdd886e38 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) (Registered 28 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-03-13 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2007-03-13-1f359ece-10088-0 |
c23fcecf5b0b13dbeab752be44c2af730eb629dc | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) (Registered 28 June 2006) | Remunerated employment, office, profession etc 1f359ece | 2007-03-26 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2007-03-26-1f359ece-10088-0 |
5ad896346d983c78770125971657a5764e489fdc | Further instalment of the advance of my autobiography. (£15,001-£20,000) (Registered 1April 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-04-23 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2008-04-23-1f359ece-10088-0 |
5d70f5ab0a9aa9e50b3d71b95b5727cb7e797807 | Further instalment of the advance of my autobiography. (£15,001-£20,000) (Registered 1April 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-06-16 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2008-06-16-1f359ece-10088-0 |
b24880f7e667dcb8143574879858e4827e61682f | Further instalment of the advance of my autobiography. (£15,001-£20,000) (Registered 1April 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-07-08 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2008-07-08-1f359ece-10088-0 |
463d3fab7f86f7f051a3f7f98515aecb9a2acfcf | Further instalment of the advance of my autobiography. (£15,001-£20,000) (Registered 1April 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-07-22 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2008-07-22-1f359ece-10088-0 |
e0607a31f68f440bcb158437ca93ca44a4352c7c | Further instalment of the advance of my autobiography. (£15,001-£20,000) (Registered 1April 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-09-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2008-09-03-1f359ece-10088-0 |
c86e8cdd9be1286ab178a87e99af986eb1f87c2a | Further instalment of the advance of my autobiography. (£15,001-£20,000) (Registered 1April 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-10-08 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2008-10-08-1f359ece-10088-0 |
b1b584a0e3238927bf35114f1a9060127e789881 | Further instalment of the advance of my autobiography. (£15,001-£20,000) (Registered 1April 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-10-22 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2008-10-22-1f359ece-10088-0 |
43962c421d38bd135fc6a6e8c888fee28f0ccb80 | Further instalment of the advance of my autobiography. (£15,001-£20,000) (Registered 1April 2008) | Remunerated employment, office, profession etc 1f359ece | 2008-11-05 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2008-11-05-1f359ece-10088-0 |
3e1e6a29da0d4964b00510c9e8768582c1171bc7 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2008-11-19 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2008-11-19-1f359ece-10088-0 |
d1d9f22f315cc403c534fceb8dfd27636c427713 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2008-12-03 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2008-12-03-1f359ece-10088-0 |
e2f47ed21710b8e80e1952b905d0f89fb99305a0 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2008-12-17 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2008-12-17-1f359ece-10088-0 |
7014ec05fbd1b4f23e2c99c4721d2c6ca4af2267 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-01-14 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-01-14-1f359ece-10088-0 |
966a1df4a035739e1c709b3e11a655a62c481148 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-01-28 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-01-28-1f359ece-10088-0 |
03675c9b5915dfa05ad02a4a04e53dbc53e8d3f8 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-02-11 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-02-11-1f359ece-10088-0 |
facb34de81aeee2d5e30687f7fc674d0aa213ebc | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-02-25 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-02-25-1f359ece-10088-0 |
026ebc76c62307c3fa5bea087d3cdc77506527fc | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-03-11 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-03-11-1f359ece-10088-0 |
0b363bd38c98ce75463e4df6c2f75b75b5e7927b | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-03-25 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-03-25-1f359ece-10088-0 |
e80444579201f5fcc0464a6b2249ecbb2bcd2386 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-04-22 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-04-22-1f359ece-10088-0 |
5a5a1d931cc638ccbbc10a5226594e13e731341e | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-05-06 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-05-06-1f359ece-10088-0 |
45ec264a89e508bf543f94bc621564aaf0404202 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-05-20 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-05-20-1f359ece-10088-0 |
95da12e920abfe1cc58a490eb51433c529569142 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-06-10 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-06-10-1f359ece-10088-0 |
9869dd8be17f11182d8571200e83e40cbb5accff | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-06-24 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-06-24-1f359ece-10088-0 |
5bbac683287b745fc65c0d622500c6eafa36c71f | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-07-08 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-07-08-1f359ece-10088-0 |
6ca9411f3b57864c1346f0ab1cefb2f69c021000 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-07-21 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-07-21-1f359ece-10088-0 |
393006fcdcb08094731f7600738bfc81dc920c1c | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-09-02 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-09-02-1f359ece-10088-0 |
ca5fcf6a356e581c96e98f7a7d01adbf51f7f6c4 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-10-14 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-10-14-1f359ece-10088-0 |
632b8e013fa1c7bf95c9465b2f621459d8ea1e71 | Advance under contract with Hodder & Stoughton for autobiographical book. (£35,001-£40,000) | Remunerated employment, office, profession etc 1f359ece | 2009-10-28 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-10-28-1f359ece-10088-0 |
bbc3b92eb2b736fd9250f16cd13fa4c8cfaed235 | Under contract with Hodder & Stoughton for autobiographical book. | Remunerated employment, office, profession etc 1f359ece | 2009-11-11 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-11-11-1f359ece-10088-0 |
f7f16b477700b3b731438817dc2956d666f2edb2 | Under contract with Hodder & Stoughton for autobiographical book. | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-11-25-1f359ece-10088-0 |
03baef5635bdc1106d83cab4a8c4bdf238e01e08 | Under contract with Hodder & Stoughton for autobiographical book. | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2009-12-10-1f359ece-10088-0 |
ee81d524d9d8f5c1a9b92f2af898edde65dfd8fc | Under contract with Hodder & Stoughton for autobiographical book. | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-01-06-1f359ece-10088-0 |
1a6828110ad309de1de79c67cff5e2254dd3adc7 | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. The payment was 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. (Registered 14 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 | 1 | 2010-02-03-1f359ece-10088-0 |
009dbf25a53baaf98656e2c528170ac8037c743a | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. The payment was 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. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-02-24-1f359ece-10088-0 |
95688cb126eecd1a9270973df5b5ac21529737c7 | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. The payment was 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. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-03-10-1f359ece-10088-0 |
2b8fb5fe0deee02c40217228163d89ce89097665 | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. The payment was 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. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-03-24-1f359ece-10088-0 |
4566d8404a1d7a02c835b8c7e5ef575bc02ed04a | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. The payment was 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. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Menzies Campbell uk.org.publicwhip/member/1984 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-04-12-1f359ece-10088-0 |
2c9adfe649e2ff040c0ebe2f3662c354234afd4e | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-09-06 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-09-06-1f359ece-10088-0 |
0f5cd524c391015d3cc5fca8a97029fc3d175beb | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-10-25 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-10-25-1f359ece-10088-0 |
eb01cc7e4c1dde8926090b7542c860472e7f31e1 | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-08 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-11-08-1f359ece-10088-0 |
5df4f9d037e4c251fdc39bafbb48d5a90e3a20c1 | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-11-22 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-11-22-1f359ece-10088-0 |
0e9a72ed890753380e2756dbf970f6fc919a51a8 | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-06 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-12-06-1f359ece-10088-0 |
a8032d106afb6848522ac93ebcae98a816c065a7 | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-12-20 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2010-12-20-1f359ece-10088-0 |
b476959611dced7465c99d99978247f7aa429291 | Payment of £3,950 gross in respect of 20 hours work carried out between 1 July and 16 December 2009 entitled BP Oil v. Glasgow Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 14 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-10 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-01-10-1f359ece-10088-0 |
2ae23e5b438a7ed3304fceb296f3d6489178e08b | Payment of £4,000 gross in respect of 20 hours’ work carried out between 1 January and 17 March 2010 entitled Kaur v. Glasgow Licensing Board, on the instruction of John Batters and Co, Solicitors, Glasgow. (Registered 19 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-01-24 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-01-24-1f359ece-10088-0 |
acbe8acef87701a6cb4c49624fea7a48b47396dd | Payment of £4,000 gross in respect of 20 hours’ work carried out between 1 January and 17 March 2010 entitled Kaur v. Glasgow Licensing Board, on the instruction of John Batters and Co, Solicitors, Glasgow. (Registered 19 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-07 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-02-07-1f359ece-10088-0 |
194ede1ffa285576edf5b626b18224d2add9e651 | Payment of £4,000 gross in respect of 20 hours’ work carried out between 1 January and 17 March 2010 entitled Kaur v. Glasgow Licensing Board, on the instruction of John Batters and Co, Solicitors, Glasgow. (Registered 19 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-02-28 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-02-28-1f359ece-10088-0 |
29937fd1be3044250df8cafe6cbc769bfc047b1d | Payment of £4,000 gross in respect of 20 hours’ work carried out between 1 January and 17 March 2010 entitled Kaur v. Glasgow Licensing Board, on the instruction of John Batters and Co, Solicitors, Glasgow. (Registered 19 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-03-14 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-03-14-1f359ece-10088-0 |
46f5c6478935e86b1e6e98f8696cec50dfd7a9ce | Payment of £4,000 gross in respect of 20 hours’ work carried out between 1 January and 17 March 2010 entitled Kaur v. Glasgow Licensing Board, on the instruction of John Batters and Co, Solicitors, Glasgow. (Registered 19 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-03-28 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-03-28-1f359ece-10088-0 |
29c63f792154679ac5b1db4dda49523af1e0bf53 | Payment of £4,000 gross in respect of 20 hours’ work carried out between 1 January and 17 March 2010 entitled Kaur v. Glasgow Licensing Board, on the instruction of John Batters and Co, Solicitors, Glasgow. (Registered 19 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-04-18 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-04-18-1f359ece-10088-0 |
a64ee14036c59b7aa2c56db3dc821cf615315518 | Payment of £4,000 gross in respect of 20 hours’ work carried out between 1 January and 17 March 2010 entitled Kaur v. Glasgow Licensing Board, on the instruction of John Batters and Co, Solicitors, Glasgow. (Registered 19 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-03 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-05-03-1f359ece-10088-0 |
ec514bfec1a158116bee0aa55621aa1cf9e49280 | Payment of £4,000 gross in respect of 20 hours’ work carried out between 1 January and 17 March 2010 entitled Kaur v. Glasgow Licensing Board, on the instruction of John Batters and Co, Solicitors, Glasgow. (Registered 19 May 2010) | Remunerated employment, office, profession etc 1f359ece | 2011-05-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-05-16-1f359ece-10088-0 |
f0980223bcf342c023b25095b1f376b5870fffa4 | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (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 | 1 | 2011-06-06-1f359ece-10088-0 |
b59f24f18c738ef80f795be797f5ff0dc0d2d5ce | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (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 | 1 | 2011-06-20-1f359ece-10088-0 |
162975cc9fee5606e96ee95ee9900a971b1695de | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (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 | 1 | 2011-07-06-1f359ece-10088-0 |
76f16bf59e86e13e52f9bb43091af58d9e863aa2 | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (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 | 1 | 2011-07-19-1f359ece-10088-0 |
75246d1fa7c534e1efabaee71b2ed1ed6ccd2e24 | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-08-30 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-08-30-1f359ece-10088-0 |
76220be2a1606589c0ebdbaa64c2335490cdc694 | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-09-28 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-09-28-1f359ece-10088-0 |
048b0bd27bc996fb777f2ecbb83957080ac2bd08 | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-17 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-10-17-1f359ece-10088-0 |
33cb13a4faadc375f89e9c13f31c6f62b2bf5548 | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-10-31 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-10-31-1f359ece-10088-0 |
3a33d603b15412cbd9284e6fa36056fa3492d243 | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-11-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-11-16-1f359ece-10088-0 |
2dfd7dd0e1579d2c84d69bc31424048aacab2829 | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-11-29 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-11-29-1f359ece-10088-0 |
a1b4978a80866f31fb5c3be14c8876b8bcb9b764 | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2011-12-13 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2011-12-13-1f359ece-10088-0 |
4c9c820404162a1d94087e4e48d44701d5502395 | Payment of £28,200 gross (£22,852 net) in respect of 80 hours work carried out between 18 March and 16 December 2010 entitled BP Oil against Glasgow Licensing board and BP Oil against Edinburgh Licensing Board, on the instructions of Harper Macleod Solicitors, Glasgow. (Registered 12 January 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2012-01-13-1f359ece-10088-0 |
0d3a7bc9d2a48e54b0e6b694a0a96ba2d6cd9455 | Payment of £944.61 from the Court of Arbitration for Sport for acting as a member of the arbitration panel set up by the Court, over the period 1 September 2010 until 14 February 2011. Payment made through RBS, 36 St Andrew’s Square, Edinburgh EH2 2YB. Hours: 8 hours. (Registered 28 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2012-01-30-1f359ece-10088-0 |
002a481f22e761ea8be915c6980a162705041d0b | Payment of £944.61 from the Court of Arbitration for Sport for acting as a member of the arbitration panel set up by the Court, over the period 1 September 2010 until 14 February 2011. Payment made through RBS, 36 St Andrew’s Square, Edinburgh EH2 2YB. Hours: 8 hours. (Registered 28 February 2011) | Remunerated employment, office, profession etc 1f359ece | 2012-02-20 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2012-02-20-1f359ece-10088-0 |
e860101d2b08d0054e354dc12881f2ddf7dbbbdd | Payments in respect of seminars given to students of Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX: | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2012-03-05-1f359ece-10088-0 |
0a54dad07b699d0c2f8b7013429fe861bbfb8f36 | Payments in respect of seminars given to students of Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX: | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2012-03-19-1f359ece-10088-0 |
c72db6f50ce2a3cedd22142447b58bb9a90b15c6 | Payments in respect of seminars given to students of Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX: | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2012-04-16-1f359ece-10088-0 |
6dd01613999d74722316ecfed90e745978fe86ff | Payments in respect of seminars given to students of Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX: | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2012-04-30-1f359ece-10088-0 |
87dc27144dfdc4143af44b00086e20b691d58949 | Payments in respect of seminars given to students of Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX: | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2012-05-14-1f359ece-10088-0 |
04fa0c93ac074a6dbebde025ff7e52c207e57002 | Payments in respect of seminars given to students of Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX: | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2012-06-11-1f359ece-10088-0 |
63d4b40a66fcbd91b3f9dc5fb18e03a13f09ba73 | Payments in respect of seminars given to students of Wroxton College, Wroxton, Nr Banbury, Oxfordshire OX15 6PX: | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | Menzies Campbell uk.org.publicwhip/member/40438 | Menzies Campbell uk.org.publicwhip/person/10088 | 1 | 2012-06-25-1f359ece-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");