interests

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

Data source: See col-scraper on GitHub

10 rows where member_id = 1955

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1342 1342 member CEO, MS Amlin Underwriting Limited, 122 Leadenhall Street, London. EC3V 4AG and Director of various other MS Amlin Group companies Employment, office, trade, profession or vocation e938d3aa Thomas Cowley Clementi 1955
1343 1343 member None other than through investment portfolios (managed on a discretionary basis by Coutts and Ruffer) which may comprise property companies etc. Land d9df90d8 Thomas Cowley Clementi 1955
1344 1344 member None other than through the Mercers Company or investment portfolios managed on a discretionary basis. Corporate Tenancies 8948e857 Thomas Cowley Clementi 1955
1345 1345 member None other than via investment portfolios managed on a discretionary basis. Securities 4bd97394 Thomas Cowley Clementi 1955
1346 1346 member Governor of Bute House Primary School, Hammersmith Non-pecuniary interests e9002d25 Thomas Cowley Clementi 1955
1347 1347 member Life Member of the National Trust Non-pecuniary interests e9002d25 Thomas Cowley Clementi 1955
1348 1348 member Liveryman - Mercers Company Non-pecuniary interests e9002d25 Thomas Cowley Clementi 1955
1349 1349 member Director - Lloyd's Market Association (Professional and Trade Association) Non-pecuniary interests e9002d25 Thomas Cowley Clementi 1955
1350 1350 member Board Member, Lloyd's Market Association Non-pecuniary interests e9002d25 Thomas Cowley Clementi 1955
1351 1351 member Board Member, Lloyd's Community Board Non-pecuniary interests e9002d25 Thomas Cowley Clementi 1955

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