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

Data source: See col-scraper on GitHub

14 rows where member_id = 1951

View and edit SQL

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
294 member Global Head of Private Markets and Real Estate Investment Oversight at Aberdeen Standard Investments (Aberdeen Asset Managers Ltd) Bow bells House, Bread Street, London. EC4M 9HH Employment, office, trade, profession or vocation e938d3aa Alexander Robertson Martin Barr 1951
295 partner Caterer - periodic event catering Employment, office, trade, profession or vocation e938d3aa Alexander Robertson Martin Barr 1951
296 partner Landlord - ownership and management of a freehold property in North Yorkshire. Employment, office, trade, profession or vocation e938d3aa Alexander Robertson Martin Barr 1951
297 member Employee of Aberdeen Asset Managers Ltd and shareholder in Standard Life Aberdeen PLC, both entities have having material presence at One Bread Street, London, EC4M 9HH Land d9df90d8 Alexander Robertson Martin Barr 1951
298 member Standard Life Aberdeen PLC Securities 4bd97394 Alexander Robertson Martin Barr 1951
299 member Associate, Chartered Institute of Securities and Investment Non-pecuniary interests e9002d25 Alexander Robertson Martin Barr 1951
300 member Member - Cordwainer Ward Club Non-pecuniary interests e9002d25 Alexander Robertson Martin Barr 1951
301 member Member – Bread Street Ward Club Non-pecuniary interests e9002d25 Alexander Robertson Martin Barr 1951
302 member Director -Sapphire IV (Investments) Ltd, 1 Le Truchot, St. Peter Port, Guernsey. GY1 1WD Non-pecuniary interests e9002d25 Alexander Robertson Martin Barr 1951
303 member Trustee, Thomas Carpenter's Trust (The Thomas Carpenter Educational and Apprenticing Foundation) Non-pecuniary interests e9002d25 Alexander Robertson Martin Barr 1951
304 member Freeman, Worshipful Company of Ironmongers Non-pecuniary interests e9002d25 Alexander Robertson Martin Barr 1951
305 member Director - Aberdeen Sapphire IV Ltd, 1 Le Truchot, St. Peter Port, Guernsey. GY1 1WD Non-pecuniary interests e9002d25 Alexander Robertson Martin Barr 1951
306 member Director - Sapphire (Investments) II Ltd, 1 Le Truchot, St. Peter Port, Guernsey. GY1 1WD Non-pecuniary interests e9002d25 Alexander Robertson Martin Barr 1951
307 member Director - Sapphire (PCC) Ltd, 1 Le Truchot, St. Peter Port, Guernsey. GY1 1WD Non-pecuniary interests e9002d25 Alexander Robertson Martin Barr 1951

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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