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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
220 220 member Bank Restructuring Consultant, EY, 25 Churchill Place, London, E14 5RB. Employment, office, trade, profession or vocation e938d3aa Thomas Alexander Anderson 1950
221 221 member Adviser to the Finance and General Purposes Committee - Walcot Foundation Non-pecuniary interests e9002d25 Thomas Alexander Anderson 1950
222 222 member Member - 20th Century Society Non-pecuniary interests e9002d25 Thomas Alexander Anderson 1950
223 223 member Member - Barbican Centre Non-pecuniary interests e9002d25 Thomas Alexander Anderson 1950
224 224 member Member - The Labour Party Non-pecuniary interests e9002d25 Thomas Alexander Anderson 1950
225 225 member Think Tank - Progress Non-pecuniary interests e9002d25 Thomas Alexander Anderson 1950
226 226 member Professional Association - Institute of Chartered Accountants Scotland Non-pecuniary interests e9002d25 Thomas Alexander Anderson 1950
227 227 member Trade Union membership - Unite Non-pecuniary interests e9002d25 Thomas Alexander Anderson 1950

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