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 = 374

Search:

descending

Link	rowid ▼	kind	name	category_id	member_id
323	323	member	Barrister at Bar of England and Wales, Henderson Chambers, 2 Harcourt Buildings, London EC4Y 9DB	Employment, office, trade, profession or vocation e938d3aa	Matthew Richardson 374
324	324	partner	Civil Servant, CFTC, Three Lafayette Centre, 1155 21st Street, NW Washington, DC 20581	Employment, office, trade, profession or vocation e938d3aa	Matthew Richardson 374
325	325	member	Director of Invicta Capital Funding, 60 Churchill Square, Kings Hill West, Malling, Kent ME19 4YU	Employment, office, trade, profession or vocation e938d3aa	Matthew Richardson 374
326	326	member	Liveryman of WaxChandlers, 6 Gresham Street ; Henderson Chambers, 2 Harcourt Buildings, Middle Temple Lane, RC4Y 9DB.	Land d9df90d8	Matthew Richardson 374
327	327	partner	Liveryman of Painter Stainers 9 Little Trinity Ln, London EC4V 2AD	Land d9df90d8	Matthew Richardson 374
328	328	member	Freemasonry	Non-pecuniary interests e9002d25	Matthew Richardson 374
329	329	member	Wax Chandlers	Non-pecuniary interests e9002d25	Matthew Richardson 374
330	330	member	St Mary at Hill Parochial Church Council	Non-pecuniary interests e9002d25	Matthew Richardson 374
331	331	member	Society of Computers and Law	Non-pecuniary interests e9002d25	Matthew Richardson 374
332	332	member	Law and Liberty Circle	Non-pecuniary interests e9002d25	Matthew Richardson 374
333	333	member	Honourable Society of Gray's Inn	Non-pecuniary interests e9002d25	Matthew Richardson 374
334	334	member	Barrister (Bar Council)	Non-pecuniary interests e9002d25	Matthew Richardson 374

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