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

Search:

descending

Link	rowid ▼	kind	name	category_id	member_id
989	989	member	Retired. Part time consultant for surgical awards - voluntary	Employment, office, trade, profession or vocation e938d3aa	Richard David Regan 367
990	990	member	Lower Ground Floor, Cutler's Hall, Warwick Lane, London EC4	Land d9df90d8	Richard David Regan 367
991	991	member	Board of Governors of the King Edward School	Non-pecuniary interests e9002d25	Richard David Regan 367
992	992	member	Trustee of St John's Ambulance	Non-pecuniary interests e9002d25	Richard David Regan 367
993	993	member	Board of Governors of Barrowhills School	Non-pecuniary interests e9002d25	Richard David Regan 367
994	994	member	Farringdon Ward Club	Non-pecuniary interests e9002d25	Richard David Regan 367
995	995	member	Royal Society of St George	Non-pecuniary interests e9002d25	Richard David Regan 367
996	996	member	Freemason	Non-pecuniary interests e9002d25	Richard David Regan 367
997	997	member	Worshipful Company of Cutlers	Non-pecuniary interests e9002d25	Richard David Regan 367
998	998	member	Worshipful Company of Blacksmiths	Non-pecuniary interests e9002d25	Richard David Regan 367
999	999	member	Worshipful Company of Chartered Accountants	Non-pecuniary interests e9002d25	Richard David Regan 367
1000	1000	member	The Association of Chartered Certified Accountants	Non-pecuniary interests e9002d25	Richard David Regan 367

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