colmem: interests: 13 rows where member

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

13 rows where member_id = 380

Search:

descending

Link	rowid ▼	kind	name	category_id	member_id
78	78	partner	Healthcare Assistant	Employment, office, trade, profession or vocation e938d3aa	Hugh Fenton Morris 380
79	79	member	Chief Executive of Laureate Legal Services Ltd	Employment, office, trade, profession or vocation e938d3aa	Hugh Fenton Morris 380
80	80	member	Chief Executive of Lapwing Legal Services Ltd	Employment, office, trade, profession or vocation e938d3aa	Hugh Fenton Morris 380
81	81	member	Chief Executive of Laureate Group Holdings Ltd	Employment, office, trade, profession or vocation e938d3aa	Hugh Fenton Morris 380
82	82	member	Freelance Consultant for Wholesale Markets, Towergate	Employment, office, trade, profession or vocation e938d3aa	Hugh Fenton Morris 380
83	83	member	De minimus share holdings in Vodafone plc and Verizon Communications Inc	Employment, office, trade, profession or vocation e938d3aa	Hugh Fenton Morris 380
84	84	member	Fellow of the Learning and Performance Institute	Employment, office, trade, profession or vocation e938d3aa	Hugh Fenton Morris 380
85	85	member	Member of the Institute of Directors	Employment, office, trade, profession or vocation e938d3aa	Hugh Fenton Morris 380
86	86	member	Liveryman of the Worshipful Company of Management Consultants	Non-pecuniary interests e9002d25	Hugh Fenton Morris 380
87	87	member	Liveryman of the Worshipful Company of Makers of Playing Cards	Non-pecuniary interests e9002d25	Hugh Fenton Morris 380
88	88	member	Master Mason of the Guildhall Lodge of Freemasons	Non-pecuniary interests e9002d25	Hugh Fenton Morris 380
89	89	member	Chairman of Osprey Lodges Ltd	Non-pecuniary interests e9002d25	Hugh Fenton Morris 380
90	90	member	Contracted occasionally by TORI Global	Non-pecuniary interests e9002d25	Hugh Fenton Morris 380

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