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

6 rows where member_id = 1227

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1374 1374 member SELF EMPLOYED LAWYER 42 BRETON HOUSE LONDONEC2Y 8DQ Employment, office, trade, profession or vocation e938d3aa Randall Keith Anderson 1227
1375 1375 member 42 BRETON HOUSE, LONDON EC2Y 8DQ Corporate Tenancies 8948e857 Randall Keith Anderson 1227
1376 1376 member Board Member Assima AG Non-pecuniary interests e9002d25 Randall Keith Anderson 1227
1377 1377 member Board Member Assima A/S Non-pecuniary interests e9002d25 Randall Keith Anderson 1227
1378 1378 member Member - American Bar Association Non-pecuniary interests e9002d25 Randall Keith Anderson 1227
1379 1379 member Member - Varndean Corporation (Governor; Sixth Form College) Non-pecuniary interests e9002d25 Randall Keith Anderson 1227

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