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

7 rows where member_id = 2104

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1531 1531 member SM Ventures Limited, Director. 13 Harbour Reach, Imperial Wharf London. SW6 2SS. Employment, office, trade, profession or vocation e938d3aa Shravan Jashvantrai Joshi 2104
1532 1532 member Freemason Non-pecuniary interests e9002d25 Shravan Jashvantrai Joshi 2104
1533 1533 member Cadogan Lodge no.162 Non-pecuniary interests e9002d25 Shravan Jashvantrai Joshi 2104
1534 1534 member Worshipful Company of Fuellers Non-pecuniary interests e9002d25 Shravan Jashvantrai Joshi 2104
1535 1535 member Worshipful Company of Blacksmiths Non-pecuniary interests e9002d25 Shravan Jashvantrai Joshi 2104
1536 1536 member Member - Coleman Street Ward Club Non-pecuniary interests e9002d25 Shravan Jashvantrai Joshi 2104
1537 1537 member Member - Bishopsgate Ward Club Non-pecuniary interests e9002d25 Shravan Jashvantrai Joshi 2104

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