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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
1589 1589 member International Banker J P Morgan Chase Bank N.A., Bank Street, E14 Employment, office, trade, profession or vocation e938d3aa Robert Allan Merrett 377
1590 1590 member J P Morgan Chase & Co Securities 4bd97394 Robert Allan Merrett 377
1591 1591 member National Grid PLC Securities 4bd97394 Robert Allan Merrett 377
1592 1592 member Member and Vice-President, Bassishaw Ward Club Non-pecuniary interests e9002d25 Robert Allan Merrett 377
1593 1593 partner Member, English Heritage Non-pecuniary interests e9002d25 Robert Allan Merrett 377
1594 1594 member Liveryman and Court Assistant, The Worshipful Company of International Bankers Non-pecuniary interests e9002d25 Robert Allan Merrett 377
1595 1595 member Member - Youth Hostel Association Non-pecuniary interests e9002d25 Robert Allan Merrett 377
1596 1596 member Member - Royal National Lifeboat Association Non-pecuniary interests e9002d25 Robert Allan Merrett 377
1597 1597 member Member - Automobile Association Non-pecuniary interests e9002d25 Robert Allan Merrett 377
1598 1598 member Member, English Heritage Non-pecuniary interests e9002d25 Robert Allan Merrett 377

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