items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16,990 rows where category_id = "1aeb07b2" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: sort_order, date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
cc2d91d72de93691ad8e414fa81cda296cc043da | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2009-07-08 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2009-07-08-1aeb07b2-11506-0 |
d65ad956ecf4eabdcc15848ba91c02aec160440c | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2009-07-21 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2009-07-21-1aeb07b2-11506-0 |
a0dee00da238fc352194d118773e17ae5171c45d | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2009-09-02 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2009-09-02-1aeb07b2-11506-0 |
d36c2e60270914ffb9d8c0d2977b082a3724e347 | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2009-10-14 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2009-10-14-1aeb07b2-11506-0 |
5279e40c48eecfbd5cc0a9f5772a2499669f8061 | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2009-10-28 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2009-10-28-1aeb07b2-11506-0 |
6fb2f9268afd92a809be5ecbdaa6af17ad83ce40 | Chair of National Housing Federation, a limited company operating on a not for profit basis; the representative body for independent non-profit social landlords in England, whose principal role is to provide and manage affordable housing. The Federation supports and promotes the work of Housing Associations, and campaigns for better housing and neighbourhoods. (£10,001-£15,000) Time commitment is 3 days a month, and payment made through Taylor & Garner Ltd (see category 2 below). | Directorships 1aeb07b2 | 2009-10-28 | Matthew Taylor uk.org.publicwhip/member/1883 | Matthew Taylor uk.org.publicwhip/person/10590 | 0 | 2009-10-28-1aeb07b2-10590-0 |
ffca73e565f8349988a1a9138bcda91a11631285 | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2009-11-11 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2009-11-11-1aeb07b2-11506-0 |
c9b2aef3a1a10695ee9c53aef14f6692761a0fed | Chair of National Housing Federation, a limited company operating on a not for profit basis; the representative body for independent non-profit social landlords in England, whose principal role is to provide and manage affordable housing. The Federation supports and promotes the work of Housing Associations, and campaigns for better housing and neighbourhoods. (£10,001-£15,000) Time commitment is 3 days a month, and payment made through Taylor & Garner Ltd (see category 2 below). | Directorships 1aeb07b2 | 2009-11-11 | Matthew Taylor uk.org.publicwhip/member/1883 | Matthew Taylor uk.org.publicwhip/person/10590 | 0 | 2009-11-11-1aeb07b2-10590-0 |
b360a047cbe94fb35aa9c44ccc19ef1f77dc8b8c | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2009-11-25 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2009-11-25-1aeb07b2-11506-0 |
eab37fc1eb95d996bca05c4d77468ae0003ca490 | Chair of National Housing Federation, a limited company operating on a not for profit basis; the representative body for independent non-profit social landlords in England, whose principal role is to provide and manage affordable housing. The Federation supports and promotes the work of Housing Associations, and campaigns for better housing and neighbourhoods. (£10,001-£15,000) Time commitment is 3 days a month, and payment made through Taylor & Garner Ltd (see category 2 below). | Directorships 1aeb07b2 | 2009-11-25 | Matthew Taylor uk.org.publicwhip/member/1883 | Matthew Taylor uk.org.publicwhip/person/10590 | 0 | 2009-11-25-1aeb07b2-10590-0 |
dfd38e6579e85f80f8e38b0a9802ceb10534ff03 | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2009-12-10 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2009-12-10-1aeb07b2-11506-0 |
8ff5a778ba21a02bede65951eaa697d2a2630429 | Chair of National Housing Federation, a limited company operating on a not for profit basis; the representative body for independent non-profit social landlords in England, whose principal role is to provide and manage affordable housing. The Federation supports and promotes the work of Housing Associations, and campaigns for better housing and neighbourhoods. (£10,001-£15,000) Time commitment is 3 days a month, and payment made through Taylor & Garner Ltd (see category 2 below). | Directorships 1aeb07b2 | 2009-12-10 | Matthew Taylor uk.org.publicwhip/member/1883 | Matthew Taylor uk.org.publicwhip/person/10590 | 0 | 2009-12-10-1aeb07b2-10590-0 |
3332ed91b64c6470ba707cdd619ddbcd8672fa97 | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2010-01-06 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2010-01-06-1aeb07b2-11506-0 |
18be2730ec30f5f515128bc358c07be5561622b0 | Chair of National Housing Federation, a limited company operating on a not for profit basis; the representative body for independent non-profit social landlords in England, whose principal role is to provide and manage affordable housing. The Federation supports and promotes the work of Housing Associations, and campaigns for better housing and neighbourhoods. (£10,001-£15,000) Time commitment is 3 days a month, and payment made through Taylor & Garner Ltd (see category 2 below). | Directorships 1aeb07b2 | 2010-01-06 | Matthew Taylor uk.org.publicwhip/member/1883 | Matthew Taylor uk.org.publicwhip/person/10590 | 0 | 2010-01-06-1aeb07b2-10590-0 |
e073682c84c92247ec9b93ac47f780f76fda9ed1 | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2010-02-03 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2010-02-03-1aeb07b2-11506-0 |
c0f9ad2b4f023977c20baf0c9f4208db8f08cbaa | Chair of National Housing Federation, a limited company operating on a not for profit basis; the representative body for independent non-profit social landlords in England, whose principal role is to provide and manage affordable housing. The Federation supports and promotes the work of Housing Associations, and campaigns for better housing and neighbourhoods. (£10,001-£15,000) Time commitment is 3 days a month, and payment made through Taylor & Garner Ltd (see category 2 below). | Directorships 1aeb07b2 | 2010-02-03 | Matthew Taylor uk.org.publicwhip/member/1883 | Matthew Taylor uk.org.publicwhip/person/10590 | 0 | 2010-02-03-1aeb07b2-10590-0 |
428074cdf709663e5ef02d20ad0e35401b4e4296 | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2010-02-24-1aeb07b2-11506-0 |
47806a91ed29710610c53b7721ba4bef9df804d5 | Chair of National Housing Federation, a limited company operating on a not for profit basis; the representative body for independent non-profit social landlords in England, whose principal role is to provide and manage affordable housing. The Federation supports and promotes the work of Housing Associations, and campaigns for better housing and neighbourhoods. (£10,001-£15,000) Time commitment is 3 days a month, and payment made through Taylor & Garner Ltd (see category 2 below). | Directorships 1aeb07b2 | 2010-02-24 | Matthew Taylor uk.org.publicwhip/member/1883 | Matthew Taylor uk.org.publicwhip/person/10590 | 0 | 2010-02-24-1aeb07b2-10590-0 |
363cd7c191a8de003a08fa5164e505c04c0d4af6 | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2010-03-10 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2010-03-10-1aeb07b2-11506-0 |
d0044c74fda63d48469bb332f849753aa35502bd | Chair of National Housing Federation, a limited company operating on a not for profit basis; the representative body for independent non-profit social landlords in England, whose principal role is to provide and manage affordable housing. The Federation supports and promotes the work of Housing Associations, and campaigns for better housing and neighbourhoods. (£10,001-£15,000) Time commitment is 3 days a month, and payment made through Taylor & Garner Ltd (see category 2 below). | Directorships 1aeb07b2 | 2010-03-10 | Matthew Taylor uk.org.publicwhip/member/1883 | Matthew Taylor uk.org.publicwhip/person/10590 | 0 | 2010-03-10-1aeb07b2-10590-0 |
52e47b86b3204a9752e214780b5ccbd3ad2d7295 | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2010-03-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2010-03-24-1aeb07b2-11506-0 |
6108e3b623588986599adb3d24c27f31d492d5be | Chair of National Housing Federation, a limited company operating on a not for profit basis; the representative body for independent non-profit social landlords in England, whose principal role is to provide and manage affordable housing. The Federation supports and promotes the work of Housing Associations, and campaigns for better housing and neighbourhoods. (£10,001-£15,000) Time commitment is 3 days a month, and payment made through Taylor & Garner Ltd (see category 2 below). | Directorships 1aeb07b2 | 2010-03-24 | Matthew Taylor uk.org.publicwhip/member/1883 | Matthew Taylor uk.org.publicwhip/person/10590 | 0 | 2010-03-24-1aeb07b2-10590-0 |
e544826606d8c0adee7e5c7de0e799b545e414fd | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2010-04-12 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 0 | 2010-04-12-1aeb07b2-11506-0 |
2bdd4119de9bd8894f8ef1568202977602db9015 | Chair of National Housing Federation, a limited company operating on a not for profit basis; the representative body for independent non-profit social landlords in England, whose principal role is to provide and manage affordable housing. The Federation supports and promotes the work of Housing Associations, and campaigns for better housing and neighbourhoods. Time commitment is 3 days a month, and payment made through Taylor & Garner Ltd (see category 2 below). | Directorships 1aeb07b2 | 2010-04-12 | Matthew Taylor uk.org.publicwhip/member/1883 | Matthew Taylor uk.org.publicwhip/person/10590 | 0 | 2010-04-12-1aeb07b2-10590-0 |
3ba0df45d8bd39bd508f8770ad0665c43d203a0b | Director of NGC Networks Ltd, 1285 Century Way, Thorpe Park, Leeds LS15 8ZB. Supplier of telecommunications products and services to businesses. | Directorships 1aeb07b2 | 2010-09-06 | Nigel Adams uk.org.publicwhip/member/40523 | Nigel Adams uk.org.publicwhip/person/24878 | 0 | 2010-09-06-1aeb07b2-24878-0 |
98f9e5f8c4700b2bb2a94fa820858fbfbd473401 | Ambriel Consulting; software consultancy (not trading), Treluswell Hill Main Street The Lizard Cornwall TR12 7NZ. | Directorships 1aeb07b2 | 2010-09-06 | Steven Baker uk.org.publicwhip/member/40676 | Steven Baker uk.org.publicwhip/person/24786 | 0 | 2010-09-06-1aeb07b2-24786-0 |
b7a84419dae6b8ff0cd0d2d3b2afbe684ff23ad6 | Social Investment Business, 5th Floor, 6 St Andrew Street, London EC4A 3AE; investing in charities and social enterprises. Three days per month chairing Investment Committee for Futurebuilders Fund and as Vice Chair of the Board. | Directorships 1aeb07b2 | 2010-09-06 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 0 | 2010-09-06-1aeb07b2-24785-0 |
b02b6ab0facbb40468e84282c986b24a580a39bb | AB produce PLC (non-executive chairman); fresh vegetable processing and distribution. Address: Enterprise House, Repton Road, Westminster Industrial Estate, Measham, Swadlincote, Derbyshire DE12 7DT. I attend board meetings once a month and communicate with the managing director weekly. | Directorships 1aeb07b2 | 2010-09-06 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 0 | 2010-09-06-1aeb07b2-24741-0 |
22638f591ddcdade896893d031f3a3d8ba2bec5f | Athena Communications and Consulting Ltd Manor Farmhouse Springhill Lane Wolverhampton WV4 4UH. Not currently trading. | Directorships 1aeb07b2 | 2010-09-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 0 | 2010-09-06-1aeb07b2-24849-0 |
070334280667df0f935f8edf8e87dc946792f29f | Tees Valley Communicators Ltd, 10 Lapwing Lane, Norton, Stockton on Tees, Cleveland TS20 1LT. Communications and web design. | Directorships 1aeb07b2 | 2010-09-06 | Alex Cunningham uk.org.publicwhip/member/40579 | Alex Cunningham uk.org.publicwhip/person/24742 | 0 | 2010-09-06-1aeb07b2-24742-0 |
f53dbbcbc767d447b9b91514f0b1b111f145f04d | Vision Twenty-One, Milton Hall, 244 Deansgate, Manchester M3 4BQ (Urban Visions Ltd) (social research) | Directorships 1aeb07b2 | 2010-09-06 | Simon Danczuk uk.org.publicwhip/member/40501 | Simon Danczuk uk.org.publicwhip/person/24808 | 0 | 2010-09-06-1aeb07b2-24808-0 |
739840fe74cf803242fd9fa6a1a590be053ebc9b | Rapier Design Group, event management company and medical communications, Rapier House, Crane Mead Ware SG12 9PW, and subsidiaries Rapier Group Inc (US division), Joan Carol Inc, Hampton Medical Conferences, OPUS and .Rapier Design Ltd. | Directorships 1aeb07b2 | 2010-09-06 | Nick de Bois uk.org.publicwhip/member/40247 | Nick de Bois uk.org.publicwhip/person/24859 | 0 | 2010-09-06-1aeb07b2-24859-0 |
c963d76a41d28a0a65a09f4d3935b8216bb64afe | Dinenages Ltd, trading as Recognition Express Southern London Road Horndean PO8 0BL, manufacturer of corporate identity products. | Directorships 1aeb07b2 | 2010-09-06 | Caroline Dinenage uk.org.publicwhip/member/40281 | Caroline Dinenage uk.org.publicwhip/person/24873 | 0 | 2010-09-06-1aeb07b2-24873-0 |
b5ce644d55575691b7d19b87ccf50a60d33cb5d8 | Morden Estates Company Limited, The Estate Office, Charborough Park, Wareham, Dorset, BH20 7EN; property company that manages a number of family-owned properties. | Directorships 1aeb07b2 | 2010-09-06 | Richard Drax uk.org.publicwhip/member/40543 | Richard Drax uk.org.publicwhip/person/24903 | 0 | 2010-09-06-1aeb07b2-24903-0 |
fe69ba581fe6d1f1332f8af03bfc801e80de9872 | Non-executive Chairman of Phoenix Life Holdings Limited and Pearl Group Holdings (No.2) Limited and of their UK subsidiary companies: London Life Limited, Pearl Assurance Plc, National Provident Life Limited, NPI Limited, Phoenix and London Assurance Limited, Phoenix Life Limited, Phoenix Pensions Limited, all of Juxon House, 100 St Paul’s Churchyard, London EC4M 8BU. These companies are long-established life assurance and pensions companies, closed to new business and now owned by Phoenix Group (formerly Pearl Group) of which I was Group Chairman from 2005 to 2009. These companies are regulated by the UK Financial Services Authority. I am an FSA approved person in respect of this appointment. I attend and chair monthly consolidated Board meetings in London as well as regularly advising the executive officers. | Directorships 1aeb07b2 | 2010-09-06 | Jonathan Evans uk.org.publicwhip/member/40146 | Jonathan Evans uk.org.publicwhip/person/22650 | 0 | 2010-09-06-1aeb07b2-22650-0 |
7eb44104d206fbf65f32a4eff8217e80c1b4a352 | 4D Biomedical Ltd, 21 Hill St, Feltwell, Thetford, Norfolk IP26 4AB; biomedical innovation advisory business. | Directorships 1aeb07b2 | 2010-09-06 | George Freeman uk.org.publicwhip/member/40396 | George Freeman uk.org.publicwhip/person/24817 | 0 | 2010-09-06-1aeb07b2-24817-0 |
d2f1083e28789319c52bbddcf53a5d7159a5fc72 | Arkolas Limited; social work without accommodation. Address: Oakwood Cottage, Lyme Park, Disley SK12 2AE. | Directorships 1aeb07b2 | 2010-09-06 | Richard Fuller uk.org.publicwhip/member/40067 | Richard Fuller uk.org.publicwhip/person/24787 | 0 | 2010-09-06-1aeb07b2-24787-0 |
0c6681d6bdc4553332292ea6d6f74dc0f8b984d2 | Reynolds Partners Ltd, Grand Buildings 1-3 The Strand, London WC2N 5HE; investment bank. (£15,001–£20,000) | Directorships 1aeb07b2 | 2010-09-06 | Barry Gardiner uk.org.publicwhip/member/40114 | Barry Gardiner uk.org.publicwhip/person/10220 | 0 | 2010-09-06-1aeb07b2-10220-0 |
c29af62a19ef300f5e9f79f77ee94fceecdd2ba9 | Partner in Severn Capital LLP, Orchard Cottage Belle Vue, Newlyn, Penzance, Cornwall TR18 5EB. Manages US-listed equity investments and processes payments from Augmentor. Hours: approx 5 hours per month. (Registered 27 May 2010) | Directorships 1aeb07b2 | 2010-09-06 | Mark Garnier uk.org.publicwhip/member/40678 | Mark Garnier uk.org.publicwhip/person/24824 | 0 | 2010-09-06-1aeb07b2-24824-0 |
595fa3e0d766b5ca79f155d1e3ccb3fe6cf2faa7 | Eden Group Ltd 155 Moorgate London EC2M 6XB | Directorships 1aeb07b2 | 2010-09-06 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 0 | 2010-09-06-1aeb07b2-24954-0 |
4178fc85143e27dc6dda6571189bb5d148478868 | Whistle Blower Ltd (dormant). | Directorships 1aeb07b2 | 2010-09-06 | Chris Heaton-Harris uk.org.publicwhip/member/40198 | Chris Heaton-Harris uk.org.publicwhip/person/24841 | 0 | 2010-09-06-1aeb07b2-24841-0 |
84a52a3f16727f522333f02c9120f464e1a2b8a2 | Revecon Ltd; general business consulting, mainly in the travel and leisure sectors. Address: 7 Park Road, Bowdon, Cheshire WA14 3JG. | Directorships 1aeb07b2 | 2010-09-06 | Damian Hinds uk.org.publicwhip/member/40227 | Damian Hinds uk.org.publicwhip/person/24782 | 0 | 2010-09-06-1aeb07b2-24782-0 |
6145332a7c5977bcaf69abcfb7f7cb5e39918faf | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2010-09-06 | David Jones uk.org.publicwhip/member/40178 | David Jones uk.org.publicwhip/person/11506 | 0 | 2010-09-06-1aeb07b2-11506-0 |
6106829d9cdb3ac975e9f5294eb5e532f57ca125 | Keltruck Limited; truck dealership (non-executive), Kenrick Way, West Bromwich, West Midlands B71 4JW. | Directorships 1aeb07b2 | 2010-09-06 | Chris Kelly uk.org.publicwhip/member/40211 | Chris Kelly uk.org.publicwhip/person/24838 | 0 | 2010-09-06-1aeb07b2-24838-0 |
0f9140d992bab827ad9aedd5f9fd656dabab78b2 | Executive director for African Speciality Products Ltd, 9 Highway Lane, Keele, Staffordshire, ST5 5AN. Supplier of coffee and cocoa; management services. Remuneration ceased on 31 May 2010. | Directorships 1aeb07b2 | 2010-09-06 | Jeremy Lefroy uk.org.publicwhip/member/40573 | Jeremy Lefroy uk.org.publicwhip/person/24760 | 0 | 2010-09-06-1aeb07b2-24760-0 |
b8a5fdf4f07c5e413a9286f4495881bb37770c35 | Director of Woodlands Schools Ltd, 428 Rayleigh Road, Hutton CM13 1SD. Private primary schools. | Directorships 1aeb07b2 | 2010-09-06 | Brandon Lewis uk.org.publicwhip/member/40286 | Brandon Lewis uk.org.publicwhip/person/24879 | 0 | 2010-09-06-1aeb07b2-24879-0 |
5a0bb136b40e7278f164d865a187826a9ebf7761 | RKL Geological Services, 4 Grove Road, Wrexham LL11; geological consultancy company. | Directorships 1aeb07b2 | 2010-09-06 | Karen Lumley uk.org.publicwhip/member/40495 | Karen Lumley uk.org.publicwhip/person/24856 | 0 | 2010-09-06-1aeb07b2-24856-0 |
27224c20ddc7c4d93f555d5807f464a4f90f790c | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2010-09-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-09-06-1aeb07b2-24913-0 |
d912d43351b72b86a9c3fe05b40ee3a6ffbb943e | ML Systems Ltd (IT management and consultancy), of which until August 2010 I was also an employee. | Directorships 1aeb07b2 | 2010-09-06 | Karl McCartney uk.org.publicwhip/member/40368 | Karl McCartney uk.org.publicwhip/person/24790 | 0 | 2010-09-06-1aeb07b2-24790-0 |
3ea21f36810cc46e4ec33c44933b1f2848013f49 | Making It (UK) Ltd, 27 Seymour Terrace Liverpool L3 5PE. Provision of serviced offices. | Directorships 1aeb07b2 | 2010-09-06 | Esther McVey uk.org.publicwhip/member/40663 | Esther McVey uk.org.publicwhip/person/24882 | 0 | 2010-09-06-1aeb07b2-24882-0 |
a6a5154bf1791ca31cc71c92dc82c626c43ea923 | 100MPH Events Ltd. Address: 37 St Patrick Square, Edinburgh, Lothian, EH8 9EU. | Directorships 1aeb07b2 | 2010-09-06 | Ian Murray uk.org.publicwhip/member/40240 | Ian Murray uk.org.publicwhip/person/24872 | 0 | 2010-09-06-1aeb07b2-24872-0 |
b451147a93c244b346091694f7a8c80839092dec | Somerset Capital Management LLP (partner), 146 Buckingham Palace Road, London SW1W 9TR; investment management | Directorships 1aeb07b2 | 2010-09-06 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 0 | 2010-09-06-1aeb07b2-24926-0 |
d38d00d79f21d3bf1316a1c7a0e2eb5dd2972482 | Motion Picture Licensing Co Ltd (studio and partner relations), 4 Saffrons Rd Eastbourne, BN 21 1DG, and subsidiaries Christian Video Licensing (Europe) Ltd, Motion Picture Licensing Company Poland, Film Lisensiering AS, Motion Picture Licensing Company Norge AS, Motion Picture Licensing Company Spain, Motion Picture Licensing Company International and Motion Picture Licensing Company Denmark A/S. | Directorships 1aeb07b2 | 2010-09-06 | Mike Weatherley uk.org.publicwhip/member/40324 | Mike Weatherley uk.org.publicwhip/person/24889 | 0 | 2010-09-06-1aeb07b2-24889-0 |
5abbaccd3d40c0879a524be62de406af750f170f | Whittaker Consultants, 8 King Cross Street Halifax West Yorkshire HX1 2SH (not trading) | Directorships 1aeb07b2 | 2010-09-06 | Craig Whittaker uk.org.publicwhip/member/40139 | Craig Whittaker uk.org.publicwhip/person/24944 | 0 | 2010-09-06-1aeb07b2-24944-0 |
c2f42b8afbcf8391b0e27e8077c79c1d3df36998 | SThree, 41-44 Great Windmill Street, London W1D 7NB; an international specialist recruitment business. I attend monthly board meetings in my capacity as a non-executive director. | Directorships 1aeb07b2 | 2010-09-06 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 0 | 2010-09-06-1aeb07b2-24822-0 |
d5b45bc2ffe1fd9d917a8861cbaf63ffec9c034f | Director of NGC Networks Ltd, 1285 Century Way, Thorpe Park, Leeds LS15 8ZB. Supplier of telecommunications products and services to businesses. | Directorships 1aeb07b2 | 2010-10-25 | Nigel Adams uk.org.publicwhip/member/40523 | Nigel Adams uk.org.publicwhip/person/24878 | 0 | 2010-10-25-1aeb07b2-24878-0 |
3b04f057d7528909ba92a9e7db8ff4adf88dee5e | Ambriel Consulting; software consultancy (not trading), Treluswell Hill Main Street The Lizard Cornwall TR12 7NZ. | Directorships 1aeb07b2 | 2010-10-25 | Steven Baker uk.org.publicwhip/member/40676 | Steven Baker uk.org.publicwhip/person/24786 | 0 | 2010-10-25-1aeb07b2-24786-0 |
9b9a1642de421791df75c7e3dfd400e01e1e0305 | Social Investment Business, 5th Floor, 6 St Andrew Street, London EC4A 3AE; investing in charities and social enterprises. Three days per month chairing Investment Committee for Futurebuilders Fund and as Vice Chair of the Board. | Directorships 1aeb07b2 | 2010-10-25 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 0 | 2010-10-25-1aeb07b2-24785-0 |
371693a36c065d40cbbde138a748d21c9456a2f8 | AB produce PLC (non-executive chairman); fresh vegetable processing and distribution. Address: Enterprise House, Repton Road, Westminster Industrial Estate, Measham, Swadlincote, Derbyshire DE12 7DT. I attend board meetings once a month and communicate with the managing director weekly. | Directorships 1aeb07b2 | 2010-10-25 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 0 | 2010-10-25-1aeb07b2-24741-0 |
97beff86bcb6a1be192ae50cadc89393e8a94ffa | Athena Communications and Consulting Ltd Manor Farmhouse Springhill Lane Wolverhampton WV4 4UH. Not currently trading. | Directorships 1aeb07b2 | 2010-10-25 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 0 | 2010-10-25-1aeb07b2-24849-0 |
efba941886fb0aa560b43dd900a83f2c9b365427 | Tees Valley Communicators Ltd, 10 Lapwing Lane, Norton, Stockton on Tees, Cleveland TS20 1LT. Communications and web design. | Directorships 1aeb07b2 | 2010-10-25 | Alex Cunningham uk.org.publicwhip/member/40579 | Alex Cunningham uk.org.publicwhip/person/24742 | 0 | 2010-10-25-1aeb07b2-24742-0 |
7e0ea3540dcbfa13e083764ffef78501eb897fcf | Vision Twenty-One, Milton Hall, 244 Deansgate, Manchester M3 4BQ (Urban Visions Ltd) (social research) | Directorships 1aeb07b2 | 2010-10-25 | Simon Danczuk uk.org.publicwhip/member/40501 | Simon Danczuk uk.org.publicwhip/person/24808 | 0 | 2010-10-25-1aeb07b2-24808-0 |
527d7719106b8286d6c4bcbd4f3991b8427b4362 | Rapier Design Group, event management company and medical communications, Rapier House, Crane Mead Ware SG12 9PW, and subsidiaries Rapier Group Inc (US division), Joan Carol Inc, Hampton Medical Conferences, OPUS and .Rapier Design Ltd. | Directorships 1aeb07b2 | 2010-10-25 | Nick de Bois uk.org.publicwhip/member/40247 | Nick de Bois uk.org.publicwhip/person/24859 | 0 | 2010-10-25-1aeb07b2-24859-0 |
6e69e6727d8c4e36bf5419b29c4cfa3290c9c3e6 | Dinenages Ltd, trading as Recognition Express Southern London Road Horndean PO8 0BL, manufacturer of corporate identity products. | Directorships 1aeb07b2 | 2010-10-25 | Caroline Dinenage uk.org.publicwhip/member/40281 | Caroline Dinenage uk.org.publicwhip/person/24873 | 0 | 2010-10-25-1aeb07b2-24873-0 |
c40b021bc0f6a3566350caf264fcc776c51b86e3 | Morden Estates Company Limited, The Estate Office, Charborough Park, Wareham, Dorset, BH20 7EN; property company that manages a number of family-owned properties. | Directorships 1aeb07b2 | 2010-10-25 | Richard Drax uk.org.publicwhip/member/40543 | Richard Drax uk.org.publicwhip/person/24903 | 0 | 2010-10-25-1aeb07b2-24903-0 |
f0c6e042014968edc21cb182a5113b4f84381042 | Non-executive Chairman of Phoenix Life Holdings Limited and Pearl Group Holdings (No.2) Limited and of their UK subsidiary companies: London Life Limited, Pearl Assurance Plc, National Provident Life Limited, NPI Limited, Phoenix and London Assurance Limited, Phoenix Life Limited, Phoenix Pensions Limited, all of Juxon House, 100 St Paul’s Churchyard, London EC4M 8BU. These companies are long-established life assurance and pensions companies, closed to new business and now owned by Phoenix Group (formerly Pearl Group) of which I was Group Chairman from 2005 to 2009. These companies are regulated by the UK Financial Services Authority. I am an FSA approved person in respect of this appointment. I attend and chair monthly consolidated Board meetings in London as well as regularly advising the executive officers. | Directorships 1aeb07b2 | 2010-10-25 | Jonathan Evans uk.org.publicwhip/member/40146 | Jonathan Evans uk.org.publicwhip/person/22650 | 0 | 2010-10-25-1aeb07b2-22650-0 |
748cfa45eb408b3f646debd1790c5bfff56770ce | 4D Biomedical Ltd, 21 Hill St, Feltwell, Thetford, Norfolk IP26 4AB; biomedical innovation advisory business. | Directorships 1aeb07b2 | 2010-10-25 | George Freeman uk.org.publicwhip/member/40396 | George Freeman uk.org.publicwhip/person/24817 | 0 | 2010-10-25-1aeb07b2-24817-0 |
b702f7ff72c3d0d1bd54e4579a9fe0486f6b5211 | Arkolas Limited; social work without accommodation. Address: Oakwood Cottage, Lyme Park, Disley SK12 2AE. | Directorships 1aeb07b2 | 2010-10-25 | Richard Fuller uk.org.publicwhip/member/40067 | Richard Fuller uk.org.publicwhip/person/24787 | 0 | 2010-10-25-1aeb07b2-24787-0 |
5d8d5d04b530609c9ad5cf0bcf5d6e191307e299 | Reynolds Partners Ltd, Grand Buildings 1-3 The Strand, London WC2N 5HE; investment bank. (£15,001–£20,000) | Directorships 1aeb07b2 | 2010-10-25 | Barry Gardiner uk.org.publicwhip/member/40114 | Barry Gardiner uk.org.publicwhip/person/10220 | 0 | 2010-10-25-1aeb07b2-10220-0 |
fcc873236b0251aaefea8936f81984cab4fd6a81 | Partner in Severn Capital LLP, Orchard Cottage Belle Vue, Newlyn, Penzance, Cornwall TR18 5EB. Manages US-listed equity investments and processes payments from Augmentor. Hours: approx 5 hours per month. (Registered 27 May 2010) | Directorships 1aeb07b2 | 2010-10-25 | Mark Garnier uk.org.publicwhip/member/40678 | Mark Garnier uk.org.publicwhip/person/24824 | 0 | 2010-10-25-1aeb07b2-24824-0 |
6617ac9b117f5eeee8eb1f955069aae3f80f3d0d | Eden Group Ltd 155 Moorgate London EC2M 6XB | Directorships 1aeb07b2 | 2010-10-25 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 0 | 2010-10-25-1aeb07b2-24954-0 |
dd04fee9ac2e28afead2bb00d339601e683fd0a3 | Whistle Blower Ltd (dormant), Pelican House, 86 High Street Hythe Kent CT21 5AJ Received £15,000 following winding-up of company. No hours. (Registered 6 October 2010) | Directorships 1aeb07b2 | 2010-10-25 | Chris Heaton-Harris uk.org.publicwhip/member/40198 | Chris Heaton-Harris uk.org.publicwhip/person/24841 | 0 | 2010-10-25-1aeb07b2-24841-0 |
be305fcebca7d163c65d034bbd196bb5a7f09ee4 | Revecon Ltd; general business consulting, mainly in the travel and leisure sectors. Address: 7 Park Road, Bowdon, Cheshire WA14 3JG. | Directorships 1aeb07b2 | 2010-10-25 | Damian Hinds uk.org.publicwhip/member/40227 | Damian Hinds uk.org.publicwhip/person/24782 | 0 | 2010-10-25-1aeb07b2-24782-0 |
4e832ccc2b480a69237eef572a206fedae3b7943 | David Jones (Solicitors) Limited, 22 Trinity Square, Llandudno, LL30 2RH Llandudno. | Directorships 1aeb07b2 | 2010-10-25 | David Jones uk.org.publicwhip/member/40178 | David Jones uk.org.publicwhip/person/11506 | 0 | 2010-10-25-1aeb07b2-11506-0 |
9df0ad98cdeb458bec54187c7645fa756de3db10 | Keltruck Limited; truck dealership (non-executive), Kenrick Way, West Bromwich, West Midlands B71 4JW. | Directorships 1aeb07b2 | 2010-10-25 | Chris Kelly uk.org.publicwhip/member/40211 | Chris Kelly uk.org.publicwhip/person/24838 | 0 | 2010-10-25-1aeb07b2-24838-0 |
85d54aa52b9180dc10f99219698a4b5e5c057d38 | Executive director for African Speciality Products Ltd, 9 Highway Lane, Keele, Staffordshire, ST5 5AN. Supplier of coffee and cocoa; management services. Remuneration ceased on 31 May 2010. | Directorships 1aeb07b2 | 2010-10-25 | Jeremy Lefroy uk.org.publicwhip/member/40573 | Jeremy Lefroy uk.org.publicwhip/person/24760 | 0 | 2010-10-25-1aeb07b2-24760-0 |
4ef651a1bc331661ef6bfcd11768a314890f7e1a | Director of Woodlands Schools Ltd, 428 Rayleigh Road, Hutton CM13 1SD. Private primary schools. | Directorships 1aeb07b2 | 2010-10-25 | Brandon Lewis uk.org.publicwhip/member/40286 | Brandon Lewis uk.org.publicwhip/person/24879 | 0 | 2010-10-25-1aeb07b2-24879-0 |
779845573d6626e847d7c9fbd459f916e7cfa187 | RKL Geological Services, 4 Grove Road, Wrexham LL11; geological consultancy company. | Directorships 1aeb07b2 | 2010-10-25 | Karen Lumley uk.org.publicwhip/member/40495 | Karen Lumley uk.org.publicwhip/person/24856 | 0 | 2010-10-25-1aeb07b2-24856-0 |
9e7a4ad50123bd7b6852f561d39da22b09c25427 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2010-10-25 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-10-25-1aeb07b2-24913-0 |
45bcd1af577bb4fd7ed20a3b50ab3e63727ea4aa | ML Systems Ltd (IT management and consultancy), of which until August 2010 I was also an employee. | Directorships 1aeb07b2 | 2010-10-25 | Karl McCartney uk.org.publicwhip/member/40368 | Karl McCartney uk.org.publicwhip/person/24790 | 0 | 2010-10-25-1aeb07b2-24790-0 |
d9b834b4317fbfde33a67e7a0dd4be4b584256d9 | Making It (UK) Ltd, 27 Seymour Terrace Liverpool L3 5PE. Provision of serviced offices. | Directorships 1aeb07b2 | 2010-10-25 | Esther McVey uk.org.publicwhip/member/40663 | Esther McVey uk.org.publicwhip/person/24882 | 0 | 2010-10-25-1aeb07b2-24882-0 |
e2c14e27699f6899f6cd12f3709561353a49b6b6 | 100MPH Events Ltd. Address: 37 St Patrick Square, Edinburgh, Lothian, EH8 9EU. | Directorships 1aeb07b2 | 2010-10-25 | Ian Murray uk.org.publicwhip/member/40240 | Ian Murray uk.org.publicwhip/person/24872 | 0 | 2010-10-25-1aeb07b2-24872-0 |
b9f0b1eb928aa30e3dc36dce05ab941abb52c699 | Somerset Capital Management LLP (partner), 146 Buckingham Palace Road, London SW1W 9TR; investment management | Directorships 1aeb07b2 | 2010-10-25 | Jacob Rees-Mogg uk.org.publicwhip/member/40441 | Jacob Rees-Mogg uk.org.publicwhip/person/24926 | 0 | 2010-10-25-1aeb07b2-24926-0 |
b2aaa9b8c7877dde4ed3be1759b5b87e94ba90a3 | Motion Picture Licensing Co Ltd (studio and partner relations), 4 Saffrons Rd Eastbourne, BN 21 1DG, and subsidiaries Christian Video Licensing (Europe) Ltd, Motion Picture Licensing Company Poland, Film Lisensiering AS, Motion Picture Licensing Company Norge AS, Motion Picture Licensing Company Spain, Motion Picture Licensing Company International and Motion Picture Licensing Company Denmark A/S. Payments received; all gross: | Directorships 1aeb07b2 | 2010-10-25 | Mike Weatherley uk.org.publicwhip/member/40324 | Mike Weatherley uk.org.publicwhip/person/24889 | 0 | 2010-10-25-1aeb07b2-24889-0 |
7cd715ed6a29119481a37c7767c73f69c6a2c45f | Whittaker Consultants, 8 King Cross Street Halifax West Yorkshire HX1 2SH (not trading) | Directorships 1aeb07b2 | 2010-10-25 | Craig Whittaker uk.org.publicwhip/member/40139 | Craig Whittaker uk.org.publicwhip/person/24944 | 0 | 2010-10-25-1aeb07b2-24944-0 |
14f4eecec08010479d5d3d0221a7e61ab6e29698 | SThree, 41-44 Great Windmill Street, London W1D 7NB; an international specialist recruitment business. I attend monthly board meetings in my capacity as a non-executive director. | Directorships 1aeb07b2 | 2010-10-25 | Nadhim Zahawi uk.org.publicwhip/member/40587 | Nadhim Zahawi uk.org.publicwhip/person/24822 | 0 | 2010-10-25-1aeb07b2-24822-0 |
dbd2601e42ba4c893e517264e36d2e4215aafccf | Director of NGC Networks Ltd, 1285 Century Way, Thorpe Park, Leeds LS15 8ZB. Supplier of telecommunications products and services to businesses. | Directorships 1aeb07b2 | 2010-11-08 | Nigel Adams uk.org.publicwhip/member/40523 | Nigel Adams uk.org.publicwhip/person/24878 | 0 | 2010-11-08-1aeb07b2-24878-0 |
1ccfa14fdcccb8efcf73b2a5fb30ff3df86dca1e | Ambriel Consulting; software consultancy (not trading), Treluswell Hill Main Street The Lizard Cornwall TR12 7NZ. | Directorships 1aeb07b2 | 2010-11-08 | Steven Baker uk.org.publicwhip/member/40676 | Steven Baker uk.org.publicwhip/person/24786 | 0 | 2010-11-08-1aeb07b2-24786-0 |
55560e84f61b9e151fe7c319d07787f45519d0d5 | Social Investment Business, 5th Floor, 6 St Andrew Street, London EC4A 3AE; investing in charities and social enterprises. Three days per month chairing Investment Committee for Futurebuilders Fund and as Vice Chair of the Board. | Directorships 1aeb07b2 | 2010-11-08 | Harriett Baldwin uk.org.publicwhip/member/40654 | Harriett Baldwin uk.org.publicwhip/person/24785 | 0 | 2010-11-08-1aeb07b2-24785-0 |
5cda41b5127ddb3319923959acbb0710286c7986 | AB produce PLC (non-executive chairman); fresh vegetable processing and distribution. Address: Enterprise House, Repton Road, Westminster Industrial Estate, Measham, Swadlincote, Derbyshire DE12 7DT. I attend board meetings once a month and communicate with the managing director weekly. | Directorships 1aeb07b2 | 2010-11-08 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 0 | 2010-11-08-1aeb07b2-24741-0 |
431be2d12b74c9ca4daeb341d47c31145d49f5ae | Athena Communications and Consulting Ltd Manor Farmhouse Springhill Lane Wolverhampton WV4 4UH. Not currently trading. | Directorships 1aeb07b2 | 2010-11-08 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 0 | 2010-11-08-1aeb07b2-24849-0 |
31667c56001ac541821870bf96917963c727e025 | Tees Valley Communicators Ltd, 10 Lapwing Lane, Norton, Stockton on Tees, Cleveland TS20 1LT. Communications and web design. | Directorships 1aeb07b2 | 2010-11-08 | Alex Cunningham uk.org.publicwhip/member/40579 | Alex Cunningham uk.org.publicwhip/person/24742 | 0 | 2010-11-08-1aeb07b2-24742-0 |
d6dacfa93ec937412f7031f39d50adac8769f9de | Vision Twenty-One, Milton Hall, 244 Deansgate, Manchester M3 4BQ (Urban Visions Ltd) (social research) | Directorships 1aeb07b2 | 2010-11-08 | Simon Danczuk uk.org.publicwhip/member/40501 | Simon Danczuk uk.org.publicwhip/person/24808 | 0 | 2010-11-08-1aeb07b2-24808-0 |
c5ec81fa53ca26aaaeb006e1188b06e293e24e90 | Rapier Design Group, event management company and medical communications, Rapier House, Crane Mead Ware SG12 9PW, and subsidiaries Rapier Group Inc (US division), Joan Carol Inc, Hampton Medical Conferences, OPUS and .Rapier Design Ltd. | Directorships 1aeb07b2 | 2010-11-08 | Nick de Bois uk.org.publicwhip/member/40247 | Nick de Bois uk.org.publicwhip/person/24859 | 0 | 2010-11-08-1aeb07b2-24859-0 |
41e3f69818a9fe3dfb208321fbba10340c2fdc91 | Dinenages Ltd, trading as Recognition Express Southern London Road Horndean PO8 0BL, manufacturer of corporate identity products. | Directorships 1aeb07b2 | 2010-11-08 | Caroline Dinenage uk.org.publicwhip/member/40281 | Caroline Dinenage uk.org.publicwhip/person/24873 | 0 | 2010-11-08-1aeb07b2-24873-0 |
6718af843e1ef8d8d7164d0597a2ee61a0f9e1ae | Morden Estates Company Limited, The Estate Office, Charborough Park, Wareham, Dorset, BH20 7EN; property company that manages a number of family-owned properties. | Directorships 1aeb07b2 | 2010-11-08 | Richard Drax uk.org.publicwhip/member/40543 | Richard Drax uk.org.publicwhip/person/24903 | 0 | 2010-11-08-1aeb07b2-24903-0 |
56367e45bbd4a7403ae9696cc7528b3dbebc6dba | Non-executive Chairman of Phoenix Life Holdings Limited and Pearl Group Holdings (No.2) Limited and of their UK subsidiary companies: London Life Limited, Pearl Assurance Plc, National Provident Life Limited, NPI Limited, Phoenix and London Assurance Limited, Phoenix Life Limited, Phoenix Pensions Limited, all of Juxon House, 100 St Paul’s Churchyard, London EC4M 8BU. These companies are long-established life assurance and pensions companies, closed to new business and now owned by Phoenix Group (formerly Pearl Group) of which I was Group Chairman from 2005 to 2009. These companies are regulated by the UK Financial Services Authority. I am an FSA approved person in respect of this appointment. I attend and chair monthly consolidated Board meetings in London as well as regularly advising the executive officers. | Directorships 1aeb07b2 | 2010-11-08 | Jonathan Evans uk.org.publicwhip/member/40146 | Jonathan Evans uk.org.publicwhip/person/22650 | 0 | 2010-11-08-1aeb07b2-22650-0 |
0ac85c9ba9144224a993d1b2769edb5f0e590797 | 4D Biomedical Ltd, 21 Hill St, Feltwell, Thetford, Norfolk IP26 4AB; biomedical innovation advisory business. | Directorships 1aeb07b2 | 2010-11-08 | George Freeman uk.org.publicwhip/member/40396 | George Freeman uk.org.publicwhip/person/24817 | 0 | 2010-11-08-1aeb07b2-24817-0 |
f28d1b69524d2c2a9dc1c6767a070472f22790a0 | Arkolas Limited; social work without accommodation. Address: Oakwood Cottage, Lyme Park, Disley SK12 2AE. | Directorships 1aeb07b2 | 2010-11-08 | Richard Fuller uk.org.publicwhip/member/40067 | Richard Fuller uk.org.publicwhip/person/24787 | 0 | 2010-11-08-1aeb07b2-24787-0 |
f16dcff6d97badc44e8ca0a7f76b8792357083a4 | Reynolds Partners Ltd, Grand Buildings 1-3 The Strand, London WC2N 5HE; investment bank. (£15,001–£20,000) | Directorships 1aeb07b2 | 2010-11-08 | Barry Gardiner uk.org.publicwhip/member/40114 | Barry Gardiner uk.org.publicwhip/person/10220 | 0 | 2010-11-08-1aeb07b2-10220-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");