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

14 rows where member_id = 401

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
452 452 member Chairman, Historystore Ltd, Dorset Employment, office, trade, profession or vocation e938d3aa John George Stewart Scott 401
453 453 partner Managing Director, Historystore Ltd, Dorset Employment, office, trade, profession or vocation e938d3aa John George Stewart Scott 401
454 454 member Historystore Ltd has a contract for the provision of antique documents and reproduction menus[ Contracts 32767bc8 John George Stewart Scott 401
455 455 member Trustee of the City of London Archaeological Trust Non-pecuniary interests e9002d25 John George Stewart Scott 401
456 456 partner Ex-Officio Committee Member, Broad Street Ward Club Non-pecuniary interests e9002d25 John George Stewart Scott 401
457 457 member Representative of Historystore Ltd, Dorset's Membership of the Philatelic Traders’ Association Non-pecuniary interests e9002d25 John George Stewart Scott 401
458 458 partner Liveryman of the Worshipful Company of Arts Scholars Non-pecuniary interests e9002d25 John George Stewart Scott 401
459 459 member Ambassador of the British Postal Museum & Archive Non-pecuniary interests e9002d25 John George Stewart Scott 401
460 460 partner Member of the: The National Trust for Scotland. Chatham House. The Automobile Association. The Dogs Trust. Non-pecuniary interests e9002d25 John George Stewart Scott 401
461 461 member Membership of the Council of Gresham College Non-pecuniary interests e9002d25 John George Stewart Scott 401
462 462 partner Liveryman of the Worshipful Company of Stationers and Newspaper Makers Non-pecuniary interests e9002d25 John George Stewart Scott 401
463 463 member Royal Philatelic Society London Non-pecuniary interests e9002d25 John George Stewart Scott 401
464 464 member Broad Street Ward Club Non-pecuniary interests e9002d25 John George Stewart Scott 401
465 465 member Arts Scholars livery company Non-pecuniary interests e9002d25 John George Stewart Scott 401

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