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

9 rows where member_id = 287

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
1713 1713 partner Co-Director - Nigerian Duty-Free Shop, Lagos, Nigeria Employment, office, trade, profession or vocation e938d3aa Vivienne Littlechild 287
1714 1714 member 58 Andrewes House, Barbican, London. EC2Y 8AX Land d9df90d8 Vivienne Littlechild 287
1715 1715 member Car parking space and store cupboards (x 2), Barbican Licences 613aec30 Vivienne Littlechild 287
1716 1716 member 58 Andrewes House, Barbican, London. EC2Y 8AX Corporate Tenancies 8948e857 Vivienne Littlechild 287
1717 1717 member Member - Friends of The Guildhall Art Gallery Non-pecuniary interests e9002d25 Vivienne Littlechild 287
1718 1718 member Member - Cripplegate Ward Club Non-pecuniary interests e9002d25 Vivienne Littlechild 287
1719 1719 member Liveryman - Worshipful Company of Glovers Non-pecuniary interests e9002d25 Vivienne Littlechild 287
1720 1720 member Member - Magistrates' Association Non-pecuniary interests e9002d25 Vivienne Littlechild 287
1721 1721 member Member - National Union of Farmers Non-pecuniary interests e9002d25 Vivienne Littlechild 287

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