items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
1,115 rows where person_id = "uk.org.publicwhip/person/10069" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: category_id, member_id
date (date) >30 ✖
- 2010-09-06 29
- 2010-10-25 29
- 2010-11-08 29
- 2010-11-22 29
- 2010-12-06 29
- 2010-12-20 29
- 2011-01-10 29
- 2011-01-24 21
- 2011-02-07 21
- 2011-02-28 21
- 2011-03-14 21
- 2011-03-28 21
- 2011-04-18 21
- 2011-05-03 21
- 2011-05-16 21
- 2011-06-06 21
- 2010-01-06 9
- 2010-02-03 9
- 2010-02-24 9
- 2010-03-10 9
- 2010-03-24 9
- 2010-04-12 9
- 2011-06-20 7
- 2011-07-06 7
- 2014-08-26 7
- 2014-09-22 7
- 2014-10-13 7
- 2014-10-27 7
- 2014-11-10 7
- 2014-11-24 7
- …
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
78140e3aa2e7e0d37dab77d5ff47431fbc69e046 | February 2005, printing and distribution constituency-wide of a leaflet, paid for by the national GMB Union. (Registered 1 March 2005) | Sponsorship or financial or material support 9e46def6 | 2005-04-11 | Nick Brown uk.org.publicwhip/member/756 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2005-04-11-9e46def6-10069-0 |
cb064082ba8195edb0b422e0145afc327899799e | 21-27 January 2005, to South Africa with an all-party delegation, to visit Nestlé operation; food, nutrition and pre-school projects. My travel, food and hotel costs were met by Nestlé. (Registered 7 February 2005) | Overseas visits 80ef1083 | 2005-04-11 | Nick Brown uk.org.publicwhip/member/756 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2005-04-11-80ef1083-10069-0 |
a93304ca579ef97aecd136cb3f7a4d84675c0f8d | February 2005, printing and distribution constituency-wide of a leaflet, paid for by the national GMB Union. (Registered 1 March 2005) | Sponsorship or financial or material support 9e46def6 | 2005-11-01 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2005-11-01-9e46def6-10069-0 |
a2950f15b33590681c5bfb9bfb180c02497693d3 | 21-27 January 2005, to South Africa with an all-party delegation, to visit Nestlé operation; food, nutrition and pre-school projects. My travel, food and hotel costs were met by Nestlé. (Registered 7 February 2005) | Overseas visits 80ef1083 | 2005-11-01 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2005-11-01-80ef1083-10069-0 |
d3bb116e6d2e79e43586e7919ae77d5eab9b5b64 | February 2005, printing and distribution constituency-wide of a leaflet, paid for by the national GMB Union. (Registered 1 March 2005) | Sponsorship or financial or material support 9e46def6 | 2005-12-14 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2005-12-14-9e46def6-10069-0 |
17d4b8ba332dc7da6aecfb792bf067d2a7771ccf | 21-27 January 2005, to South Africa with an all-party delegation, to visit Nestlé operation; food, nutrition and pre-school projects. My travel, food and hotel costs were met by Nestlé. (Registered 7 February 2005) | Overseas visits 80ef1083 | 2005-12-14 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2005-12-14-80ef1083-10069-0 |
a09d1a338b46456ab337507e531216e6b0c8c25a | February 2005, printing and distribution constituency-wide of a leaflet, paid for by the national GMB Union. (Registered 1 March 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-13 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2006-02-13-9e46def6-10069-0 |
3939f3cc45d97eb8311ef5641a7f4d852a3bace7 | February 2005, printing and distribution constituency-wide of a leaflet, paid for by the national GMB Union. (Registered 1 March 2005) | Sponsorship or financial or material support 9e46def6 | 2006-02-14 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2006-02-14-9e46def6-10069-0 |
943f48c06f39b7d483e8f4a057d658fdd6dc4289 | March 2005, printing and distribution constituency-wide of a leaflet, paid for by the national GMB Union. (Registered 22 June 2005) | Sponsorship or financial or material support 9e46def6 | 2006-03-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2006-03-24-9e46def6-10069-0 |
d6529aee3048b927703c837136c5d256bb3a1f2e | March 2005, printing and distribution constituency-wide of a leaflet, paid for by the national GMB Union. (Registered 22 June 2005) | Sponsorship or financial or material support 9e46def6 | 2006-05-12 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2006-05-12-9e46def6-10069-0 |
dab8ebe2aa223b1f931c2dce820c4f843ce38efc | March 2005, printing and distribution constituency-wide of a leaflet, paid for by the national GMB Union. (Registered 22 June 2005) | Sponsorship or financial or material support 9e46def6 | 2006-06-21 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2006-06-21-9e46def6-10069-0 |
9ea1f5b9071c40399f5b1bb3fda022982906e58c | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-01-09 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-01-09-80ef1083-10069-0 |
3293be93c318df594f0596e1dd7c3b9fcdf7c767 | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-01-23 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-01-23-80ef1083-10069-0 |
a30fa4c7070294efe20a3c7372dbf85bc74f4e29 | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-02-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-02-06-80ef1083-10069-0 |
9925c10cb118b31c8630f61289e0148368b754d8 | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-02-27 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-02-27-80ef1083-10069-0 |
c4f4bfe84665b2c1d07b422bea8322649359a0ac | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-03-13 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-03-13-80ef1083-10069-0 |
16e685b2b614b64e87939b175407aad86e2419aa | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-03-26 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-03-26-80ef1083-10069-0 |
7179e1ff14668453b8829b2ec731fcaa5511475b | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-05-01 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-05-01-80ef1083-10069-0 |
5955f7bc7bb5d7e7fe9bc8dcd4de9f358f2c19c0 | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-05-15 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-05-15-80ef1083-10069-0 |
da2b168161ecfa59948b662b9448b6ce6a8a457e | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-06-05 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-06-05-1f359ece-10069-0 |
d11a813bb976a9f032e74b7c2299375b4d11dcee | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-06-05 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-06-05-80ef1083-10069-0 |
058cb685a9463776c4eb56d4a1e9f0c96e1f4a8e | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-06-19 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-06-19-1f359ece-10069-0 |
036a0d146b96792e3c8f90c011cdb759d50c65a2 | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-06-19 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-06-19-80ef1083-10069-0 |
6b0411503552972f5f80d003f553bbe94b4e8c01 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-07-03 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-07-03-1f359ece-10069-0 |
eae44982dad634305c341266c954722ee1482172 | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-07-03 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-07-03-80ef1083-10069-0 |
605502d5b8eca92d879232ecda2d53325173c5c7 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-07-17 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-07-17-1f359ece-10069-0 |
5b045aea0264f90f44b5a716aee450b8e8dd26ae | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-07-17 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-07-17-80ef1083-10069-0 |
443dff9c23342217dc7d5312786def22097f7f6a | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-07-30 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-07-30-1f359ece-10069-0 |
d509153ef09f7d15f4f9568daaea54c5eab78c9a | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-07-30 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-07-30-80ef1083-10069-0 |
f19ce28471eb60109514c6a013453596653078db | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-08-28 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-08-28-1f359ece-10069-0 |
272e76775a0e979863c586e284c07a370b33b812 | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-08-28 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-08-28-80ef1083-10069-0 |
c24c32e870ea89d4e851447b7094ee65d9baf0c9 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-10-09 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-10-09-1f359ece-10069-0 |
1b1b77b5a0a4e7b68b04f32e40aed9d0d27e9ecb | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-10-09 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-10-09-80ef1083-10069-0 |
df9f5279319be1cbb9fdc0438ad529ed519eb2f9 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-10-23 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-10-23-1f359ece-10069-0 |
09695b288d756faabca3084f734f4b842b1eb070 | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-10-23 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-10-23-80ef1083-10069-0 |
5a14e9c5fcf3fa96fce8cde16ae16344ff3db4d0 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-11-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-11-06-1f359ece-10069-0 |
dd700e694415ddd217c9f353c28bf8436693d9a5 | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-11-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-11-06-80ef1083-10069-0 |
684654ecd1cf856d5c53ead526ee9e9efe943bb5 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-11-20 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-11-20-1f359ece-10069-0 |
604c42778c927cad3a4163f2f2a1c2b88e085030 | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-11-20 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-11-20-80ef1083-10069-0 |
40974a19b7553653f200f47e5e05b9e527acc653 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-12-04 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-12-04-1f359ece-10069-0 |
d3c4f737e53a9df1e82846603d7b62310024c206 | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-12-04 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-12-04-84642823-10069-0 |
f268dc3155854eb5406898823678f1f0b8757a99 | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-12-04 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-12-04-80ef1083-10069-0 |
e6160279232c04d2b526287cfe767f5062612ea7 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2007-12-18 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-12-18-1f359ece-10069-0 |
e03e51da14bd524f7867e3cb0eb3e1dfab737400 | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2007-12-18 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-12-18-84642823-10069-0 |
bc65f876d7ec4a503520d3bccc3ad0f501c723ff | 22-26 August 2006, to Stavanger, Norway, to visit Offshore Northern Seas (ONS) conference and exhibition, with the British Offshore Oil and Gas Industry All-Party Parliamentary Group. Overseas flights, hotel accommodation, local transport and hospitality sponsored by the UK Offshore Operators Association (UKOOA), and individual member companies. (Registered 21 December 2006) | Overseas visits 80ef1083 | 2007-12-18 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2007-12-18-80ef1083-10069-0 |
ee3c3b45e78c441b4de971fd3227af68d4f66f54 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2008-01-09 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-01-09-1f359ece-10069-0 |
4935e1a04a8f6475a318e94029279c6fb068ef04 | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-01-09 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-01-09-84642823-10069-0 |
a02313dd3c5b09f76623e73805796667666aa995 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2008-01-22 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-01-22-1f359ece-10069-0 |
fcc03fce5e500e01394f8f40ab54af1cf650510a | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-01-22 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-01-22-84642823-10069-0 |
bd96ad76776584b8e8efd521b3447a0fde73ba58 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2008-02-05 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-02-05-1f359ece-10069-0 |
876eabaa00ad4092c2fa0bb34c64bf6e3b48974d | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-02-05 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-02-05-84642823-10069-0 |
acf35753b7b9b89e7f7ad27761fcd369cc59ac10 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2008-02-26 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-02-26-1f359ece-10069-0 |
f695ba8fcc22dfe669663532886b59b3870647fc | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-02-26 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-02-26-84642823-10069-0 |
f9b83c1ff3ed3304b9f8e7302049e16452324d13 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2008-03-11 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-03-11-1f359ece-10069-0 |
8d532bce28bd43ccddb8ba0709baa0a77a07c0ae | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-03-11 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-03-11-84642823-10069-0 |
e7df2a4f9eef96ff70c723febddf60b09d6a3531 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2008-03-25 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-03-25-1f359ece-10069-0 |
deb2e7b7dd3ade3b5586aee0ae08aa7e074d746c | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-03-25 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-03-25-84642823-10069-0 |
5715cd11312bb92780d068071484eeb259cb4e6c | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2008-04-23 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-04-23-1f359ece-10069-0 |
98cc6e4da8c3f2175ac54d3169d21ee88244ad7e | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-04-23 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-04-23-84642823-10069-0 |
6b0a0c3cfab54c5bf20bf33db08591422e3ceac0 | Occasional lecture to the Civil Service College. This involves no payment to myself, but a donation is made to the Newcastle East & Wallsend Parliamentary Association, which is the local political campaign fund. (Up to £5,000) (Registered 31 May 2007) | Remunerated employment, office, profession etc 1f359ece | 2008-06-16 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-06-16-1f359ece-10069-0 |
f07981e1626d1c36b35f652459ea850e308fd59f | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-06-16 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-06-16-84642823-10069-0 |
0ad43fa4437ba8b6b0f0504fa9e5989b1e7f69cf | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-07-08 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-07-08-84642823-10069-0 |
0a44e34050f813fcaaec630342b81a2b409dfe6e | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-07-22 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-07-22-84642823-10069-0 |
b6af64fc3634af4ae80a53780fc0e9f4a1f6ea5e | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-09-03 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-09-03-84642823-10069-0 |
561be92c6e87a6066f46fa2972060db0875b68ca | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-10-08 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-10-08-84642823-10069-0 |
dd743a3970801f922704358f97d94880ebfc9b99 | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-10-22 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-10-22-84642823-10069-0 |
fa4f1a2c9852dd5c11be91963561ffb44e21c39d | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-11-05 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-11-05-84642823-10069-0 |
eb33ebdbff7ae5e5728dfbbeed7a5ae1f9f19ad4 | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-11-19 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-11-19-84642823-10069-0 |
c0ab589bee9445bc1812c107e80c7e57a320a502 | October/November 2007, attended Royal Opera House, Covent Garden Ring Cycle, as a guest of Canary Wharf. (Registered 3 December 2007) | Gifts, benefits and hospitality (UK) 84642823 | 2008-12-03 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2008-12-03-84642823-10069-0 |
e731de0df5f3e028bd09c8f5a4905936ef9c4dc0 | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-01-06 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-01-06-8f616a6e-10069-0 |
acce64bbba459b55755de8c7cd9e7ca258d0810d | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-02-03 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-02-03-8f616a6e-10069-0 |
795e13b6a14e00b4504dfdabed44798fd5f54e4a | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-02-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-02-24-8f616a6e-10069-0 |
869b2d27dcca76cb6168d87d7a6d091849964c40 | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-03-10 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-03-10-8f616a6e-10069-0 |
9c4a746eb95fb75a0ac42dd3fe4dee4737c8bfc5 | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-03-24 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-03-24-8f616a6e-10069-0 |
ba5a33845563d8b74563b62cdc736948895c3c0c | Name of donor: Wellstream Holdings PLC; manufacture umbilicals for offshore industry. | Sponsorships 8f616a6e | 2010-04-12 | Nick Brown uk.org.publicwhip/member/1730 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-04-12-8f616a6e-10069-0 |
3f795d6327bdd51cec677f2e812d3a53442bda51 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-09-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-09-06-8f616a6e-10069-0 |
79434093c196909133fc6958b3f3ec739ba1c5ac | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-10-25 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-10-25-8f616a6e-10069-0 |
f33ab14ae45d9a3beac516ae9a894d988eac511e | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-11-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-11-08-8f616a6e-10069-0 |
6e8fc09b8dc8c54ab0f681656d43bfba922a5a66 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-11-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-11-22-8f616a6e-10069-0 |
7bdfda857a842a56a7ae2ff01bb6305c2db8a268 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-12-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-12-06-8f616a6e-10069-0 |
f9513ab8c0c814d512c44ff347a225430a1acec2 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-12-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2010-12-20-8f616a6e-10069-0 |
884c15cdd1ec161d20e770e187ebce4c47ea95f8 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-01-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-01-10-8f616a6e-10069-0 |
ef9b88a2920935ff6a253be29342b5e040141db6 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-01-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-01-24-8f616a6e-10069-0 |
ebac3d52d727f4dade342ec22f4963913c898e97 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-02-07 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-02-07-8f616a6e-10069-0 |
ad2f80e1dfcaeabbdcdec6d023de4abc24de0f31 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-02-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-02-28-8f616a6e-10069-0 |
de95e422f95d857e479a84f6de87ecb39c575def | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-03-14 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-03-14-8f616a6e-10069-0 |
80c478e317ded2843c522c97d7a0e1e57dd4341c | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-03-28-8f616a6e-10069-0 |
27f80931dcd3aaad856fde5ef355ffe05bf40228 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-04-18 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-04-18-8f616a6e-10069-0 |
01eecb4a739bd0211bfaea427251221af276f987 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-05-03 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-05-03-8f616a6e-10069-0 |
4a855c0ed5e1c2668afd094737d57f489e63730c | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-05-16 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-05-16-8f616a6e-10069-0 |
2607acebc9043be359c392bc829591eeb22eeb99 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-06-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-06-06-8f616a6e-10069-0 |
8c79ab9f0946ddd007dc3d1f366bba9391d5db6a | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-06-20 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-06-20-8f616a6e-10069-0 |
92205a3a642d57ebca7c892af6881609da499346 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-07-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-07-06-8f616a6e-10069-0 |
9413cb5bd50ba320e8b12bf1e6002f3c740eb293 | Name of donor (1) Japan Tobacco International; (2) Glyndebourne | Gifts, benefits and hospitality (UK) 84642823 | 2014-08-26 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2014-08-26-84642823-10069-0 |
1fa688174864ebfd744bd1962018afefb9d75036 | Name of donor (1) Japan Tobacco International; (2) Glyndebourne | Gifts, benefits and hospitality (UK) 84642823 | 2014-09-22 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2014-09-22-84642823-10069-0 |
de637cb7ea3d565a858dabc797d8098ef044c3ca | Name of donor (1) Japan Tobacco International; (2) Glyndebourne | Gifts, benefits and hospitality (UK) 84642823 | 2014-10-13 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2014-10-13-84642823-10069-0 |
87e18ec3e87a7a4f386ad2f14e9cae3a0d6c9478 | Name of donor (1) Japan Tobacco International; (2) Glyndebourne | Gifts, benefits and hospitality (UK) 84642823 | 2014-10-27 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2014-10-27-84642823-10069-0 |
17c68e8ec81c6915c49537d49b7c7b79ac23ca04 | Name of donor (1) Japan Tobacco International; (2) Glyndebourne | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-10 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2014-11-10-84642823-10069-0 |
9263f72720c430cca667bc948ebbe240335e1e87 | Name of donor (1) Japan Tobacco International; (2) Glyndebourne | Gifts, benefits and hospitality (UK) 84642823 | 2014-11-24 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2014-11-24-84642823-10069-0 |
e12b9f04c7093f54bab4d7ca10cc43ca18af51da | Name of donor (1) Japan Tobacco International; (2) Glyndebourne | Gifts, benefits and hospitality (UK) 84642823 | 2014-12-08 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2014-12-08-84642823-10069-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");