colmem: interests: 12 rows where member

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

12 rows where member_id = 217

Search:

descending

Link	rowid ▼	kind	name	category_id	member_id
721	721	member	Public Affairs Manager, Atos UK+I, 71 MidCity Place, High Holborn, London	Employment, office, trade, profession or vocation e938d3aa	Sophie Anne Fernandes 217
722	722	member	Trust for London	Non-pecuniary interests e9002d25	Sophie Anne Fernandes 217
723	723	member	Sir John Cass Foundation	Non-pecuniary interests e9002d25	Sophie Anne Fernandes 217
724	724	member	Co-Chair - Young Tiffany Circle, British Red Cross	Non-pecuniary interests e9002d25	Sophie Anne Fernandes 217
725	725	member	Richard Cobden Primary School, Camden	Non-pecuniary interests e9002d25	Sophie Anne Fernandes 217
726	726	member	Coleman Street Ward Club	Non-pecuniary interests e9002d25	Sophie Anne Fernandes 217
727	727	member	Worshipful Company of Tallow Chandlers	Non-pecuniary interests e9002d25	Sophie Anne Fernandes 217
728	728	member	Chartered Institute of Public Relations	Non-pecuniary interests e9002d25	Sophie Anne Fernandes 217
729	729	member	Association of Professional Political Consultants	Non-pecuniary interests e9002d25	Sophie Anne Fernandes 217
730	730	member	Public Relations Consultants Association	Non-pecuniary interests e9002d25	Sophie Anne Fernandes 217
731	731	member	Member - Conservative Party	Non-pecuniary interests e9002d25	Sophie Anne Fernandes 217
732	732	member	Ulysses Trust	Non-pecuniary interests e9002d25	Sophie Anne Fernandes 217

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