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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
1044 1044 member Charles Stanley & Company Limited, 55 Bishopsgate, London EC2N 3AS Employment, office, trade, profession or vocation e938d3aa Robert Picton Seymour Howard 255
1045 1045 member Charles Stanley Group PLC Securities 4bd97394 Robert Picton Seymour Howard 255
1046 1046 partner Charles Stanley Group PLC Securities 4bd97394 Robert Picton Seymour Howard 255
1047 1047 member Worshipful Company of Gardeners Non-pecuniary interests e9002d25 Robert Picton Seymour Howard 255
1048 1048 member Worshipful Company of Fletchers Non-pecuniary interests e9002d25 Robert Picton Seymour Howard 255
1049 1049 member Member, Lime Street & Cornhill Ward Club Non-pecuniary interests e9002d25 Robert Picton Seymour Howard 255
1050 1050 member Chartered Institute for Securities and Investment (CISI), Member Non-pecuniary interests e9002d25 Robert Picton Seymour Howard 255
1051 1051 member City of London Club Non-pecuniary interests e9002d25 Robert Picton Seymour Howard 255
1052 1052 member Governor, Capel Manor College Non-pecuniary interests e9002d25 Robert Picton Seymour Howard 255
1053 1053 member Governor of City of London Academy, Shoreditch Park Non-pecuniary interests e9002d25 Robert Picton Seymour Howard 255

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