colmem: interests: 27 rows where member

Interests for members and their partners ('Spouse/Civil Partner/Living as such') from the Register of Interests.

27 rows where member_id = 385

Search:

descending

Link	rowid ▼	kind	name	category_id	member_id
1216	1216	member	Consultant - Kingston Smith LLP; Kingston Smith & Partners LLP	Employment, office, trade, profession or vocation e938d3aa	Sir Michael Snyder 385
1217	1217	member	Director - Metro Bank Plc	Employment, office, trade, profession or vocation e938d3aa	Sir Michael Snyder 385
1218	1218	member	Senior Partner - Bramdean Consultants LLP	Employment, office, trade, profession or vocation e938d3aa	Sir Michael Snyder 385
1219	1219	partner	Wife: Partner - Bramdean Consultants LLP	Employment, office, trade, profession or vocation e938d3aa	Sir Michael Snyder 385
1220	1220	member	Director and Trustee- Crossrail Arts Foundation (25 Canada Square, E14)	Contracts 32767bc8	Sir Michael Snyder 385
1221	1221	member	Lease of storage space at Gracechurch Street, EC3	Land d9df90d8	Sir Michael Snyder 385
1222	1222	member	Chairman of Governers - Brentwood School	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1223	1223	member	Vice President - Ward of Cordwainer Club	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1224	1224	member	Member - City Pickwick Club	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1225	1225	member	Life Member - The Imperial Society	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1226	1226	member	Freemason - United Grand Lodge of England, Guildhall Lodge and Metropolitan Grand Lodge of London	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1227	1227	member	Member of Court and Past Master - The Worshipful Company of Needlemakers	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1228	1228	member	Member of Court and Past Master - The Worshipful Company of Tallow Chandlers	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1229	1229	member	Fellow - The Royal Society of Arts, (Chatham House) Learned Society	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1230	1230	member	Fellow - Institute of Chartered Accountants in England and Wales	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1231	1231	member	Patron of Arcubus (associated with Just Share)	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1232	1232	member	Member - The Securities Institute	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1233	1233	member	Governor – City of London School for Girls	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1234	1234	member	Chairman - Tallow's Wine Appreciation Society (TWAS)	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1235	1235	member	Member - The Athenaeum Club	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1236	1236	member	Member - The British Association for Shooting and Conservation	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1237	1237	member	Member - The Country Landowners Association	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1238	1238	member	Member - The Inland Waterways Association	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1239	1239	member	Honorary Treasurer - Bowbells Association	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1240	1240	member	Member - Chartered Insurance Institute	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1241	1241	member	Subscriber - Campaign to Protect Rural England	Non-pecuniary interests e9002d25	Sir Michael Snyder 385
1242	1242	member	Life Member - The National Trust	Non-pecuniary interests e9002d25	Sir Michael Snyder 385

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE interests (
        kind VARCHAR(10),
        name TEXT,
        category_id VARCHAR(8) REFERENCES interest_categories(id),
        member_id INTEGER REFERENCES members(id)
    );
CREATE INDEX interests_category_id ON interests("category_id");
CREATE INDEX interests_member_id ON interests("member_id");