colmem: interests: 42 rows where member

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

42 rows where member_id = 1323

Search:

descending

Link	rowid ▼	kind	name	category_id	member_id
1398	1398	member	Director Z/Yen Group Limited, 41 Lothbury London EC2R 7HG	Employment, office, trade, profession or vocation e938d3aa	Professor Michael Raymond Mainelli 1323
1399	1399	partner	Director Nymph Limited, Basinghall Street London EC2V 5AY	Employment, office, trade, profession or vocation e938d3aa	Professor Michael Raymond Mainelli 1323
1400	1400	member	Z/YEN GROUP RELATED: Z/Yen Adventures Limited; Z/Yen Communications Limited; Z/Yen Group Limited; Z/Yen Holdings Limited; Z/Yen Contents Limited; Indezy Limited; Z/Yen Partners Limited; Z/Yen Risk/Reward Limited; Z/Yen Ventures Limited; ExtZy Limited; XUMK Limited;	Employment, office, trade, profession or vocation e938d3aa	Professor Michael Raymond Mainelli 1323
1401	1401	partner	Entryway Limited Wellkit Property Management Limited Z/Yen Contents Limited	Employment, office, trade, profession or vocation e938d3aa	Professor Michael Raymond Mainelli 1323
1402	1402	member	FINANCIAL LABROATORY (dormant): Financial Laboratory Limited	Employment, office, trade, profession or vocation e938d3aa	Professor Michael Raymond Mainelli 1323
1403	1403	member	NON-Z/YEN: United Kingdom Accreditation Service; Wishbone Gold Plc; PCG Entertainment PLC; Lord Mayor's Show Limited	Employment, office, trade, profession or vocation e938d3aa	Professor Michael Raymond Mainelli 1323
1404	1404	member	CHARITABLE: Director, Gresham College, London; Almoner, Christ’s Hospital Foundation, Horsham, UK; Alderman, City of London Corporation, Broad Street Ward, UK; Council Member, City & Guilds, London UK; Trustee, Morden College, Greenwich, UK Fellow, Goodenough College, London, UK Trustee, Thames Match (traditional sailing race since 1863), UK Trustee, The Lord Mayor's 800th Anniversary Awards Trust	Employment, office, trade, profession or vocation e938d3aa	Professor Michael Raymond Mainelli 1323
1405	1405	member	Fellow: Chartered Association of Certified Accountants	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1406	1406	member	Fellow: Chartered Institute of Securities & Investment	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1407	1407	member	Fellow: British Computer Society	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1408	1408	member	Chartered Information Technology Professional	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1409	1409	member	Fellow: Institute of Consulting, Certified Management Consultant	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1410	1410	member	Member:Energy Institute (formerly Institute of Petroleum)	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1411	1411	member	Worshipful Company of World Traders, Liveryman	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1412	1412	member	Company of Watermen & Lightermen, Freeman	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1413	1413	member	Worshipful Company of Furniture Makers, Honorary Liveryman	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1414	1414	member	Broad Street Ward Club	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1415	1415	member	Lime Street Ward Club	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1416	1416	member	Farringdon Ward Club	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1417	1417	member	Gresham Society	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1418	1418	member	Old Mercers’ Club	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1419	1419	member	Editorial Board, Strategic Change: Briefings in Entrepreneurial Finance (formerly Journal of Strategic Change), John Wiley & Sons – London, England	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1420	1420	member	Advisory Council, Centre for the Study of Financial Innovation – London, England	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1421	1421	member	Trustee, Thames Match – Gravesend, England	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1422	1422	member	Editorial Board, Journal of Business Strategy, Emerald Group – Bradford, England	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1423	1423	member	Member, Professional & Business Services Council, UK Department for Business, Energy & Industrial Strategy – London, England	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1424	1424	member	Worshipful Company of Water Conservators, Honorary Liveryman	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1425	1425	member	Guildhall Historical Association	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1426	1426	member	Royal Ocean Racing Club	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1427	1427	member	Appeal Patron, Sea-Change Sailing Trust – Maldon, England	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1428	1428	member	Alderman of Broad Street Ward, City of London Corporation – London, England	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1429	1429	member	Trinity Square Club	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1430	1430	member	Classical Road Show, Patron	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1431	1431	member	Sea Change Sailing Trust, Patron	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1432	1432	member	Freemason, Guildhall Lodge	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1433	1433	member	Association of Bargemen	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1434	1434	member	Sailing Barge Association	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1435	1435	member	Thames Sailing Barge Trust	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1436	1436	member	Harvard Club of New York	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1437	1437	member	Trustee, Worshipful Company Of World Traders Charitable Trust	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1438	1438	member	Member, Guild Of Freemen	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323
1439	1439	member	Member, City Livery Club	Non-pecuniary interests e9002d25	Professor Michael Raymond Mainelli 1323

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