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

8 rows where member_id = 408

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1022 1022 member Managing Director & Owner - C&E Capital Consulting Ltd Employment, office, trade, profession or vocation e938d3aa James Henry George Pollard 408
1023 1023 member Head of Closed End Funds, Premier Asset Management Employment, office, trade, profession or vocation e938d3aa James Henry George Pollard 408
1024 1024 member Liveryman - Skinners' Company Non-pecuniary interests e9002d25 James Henry George Pollard 408
1025 1025 member Member - Conservative Party Non-pecuniary interests e9002d25 James Henry George Pollard 408
1026 1026 member Freemason Non-pecuniary interests e9002d25 James Henry George Pollard 408
1027 1027 member Member - The Honourable The Irish Society Non-pecuniary interests e9002d25 James Henry George Pollard 408
1028 1028 member Member - Vintry & Dowgate Wards Club Non-pecuniary interests e9002d25 James Henry George Pollard 408
1029 1029 member Court Member - Guild of Investment Managers Non-pecuniary interests e9002d25 James Henry George Pollard 408

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