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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
759 759 member Director, UK Ship Register, Maritime & Coastguard Agency, 105 Commercial Road, Southampton, SO15 1EG Employment, office, trade, profession or vocation e938d3aa Douglas Barrow 128
760 760 member Director, Crusader Marine Ltd, 13 Whinneys Road, Loudwater. HP10 9RJ Employment, office, trade, profession or vocation e938d3aa Douglas Barrow 128
761 761 member Aldgate Ward Club Non-pecuniary interests e9002d25 Douglas Barrow 128
762 762 member Royal National Lifeboat Institution Non-pecuniary interests e9002d25 Douglas Barrow 128
763 763 member Freemason Non-pecuniary interests e9002d25 Douglas Barrow 128
764 764 member The Worshipful Company of Shipwrights - Past Master Non-pecuniary interests e9002d25 Douglas Barrow 128
765 765 member The Worshipful Company of Fuellers - Past Master Non-pecuniary interests e9002d25 Douglas Barrow 128
766 766 member International Bunker Industry Association (IBIA) - Honorary Member Non-pecuniary interests e9002d25 Douglas Barrow 128
767 767 member Trinity House Non-pecuniary interests e9002d25 Douglas Barrow 128
768 768 member Shipwrights Charitable Trust Non-pecuniary interests e9002d25 Douglas Barrow 128

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