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

22 rows where member_id = 256

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
769 769 member Self employed solicitor Employment, office, trade, profession or vocation e938d3aa Michael Hudson 256
770 770 partner Office manager for mhlaw Employment, office, trade, profession or vocation e938d3aa Michael Hudson 256
771 771 member Company Secretary Gamespati plc Employment, office, trade, profession or vocation e938d3aa Michael Hudson 256
772 772 member Lease from City of London Corporation dated 27.10.16 (further details contained under Corporate Tenancies) Contracts 32767bc8 Michael Hudson 256
773 773 member Lease from City of London Corporation of office at 5 London Wall Buildings, London EC2M 5NS (further details contained under Corporate Tenancies) Land d9df90d8 Michael Hudson 256
774 774 member Lease from City of London Corporation dated 27.10.16 of office at 5 London Wall Buildings, London EC2M 5NS for 2 years from 29.9.2014 at a rent of £6862 pa plus service charge, insurance and VAT Corporate Tenancies 8948e857 Michael Hudson 256
775 775 member J M Parkinson Charitable Trust Non-pecuniary interests e9002d25 Michael Hudson 256
776 776 member Castle Baynard Ward Club (Past Chairman) Non-pecuniary interests e9002d25 Michael Hudson 256
777 777 member Farringdon Ward Club (Past President) Non-pecuniary interests e9002d25 Michael Hudson 256
778 778 member Bishopsgate Ward Club Non-pecuniary interests e9002d25 Michael Hudson 256
779 779 member Broad Street Ward Club Non-pecuniary interests e9002d25 Michael Hudson 256
780 780 member City Livery Club (Past President) Non-pecuniary interests e9002d25 Michael Hudson 256
781 781 member Guild of Freemen Non-pecuniary interests e9002d25 Michael Hudson 256
782 782 member Masonic Lodges 1745 and 3116 C1745 Non-pecuniary interests e9002d25 Michael Hudson 256
783 783 member Painter-Stainers Company (liveryman) Non-pecuniary interests e9002d25 Michael Hudson 256
784 784 member City of London Solicitors Company (freeman) Non-pecuniary interests e9002d25 Michael Hudson 256
785 785 member Law Society Non-pecuniary interests e9002d25 Michael Hudson 256
786 786 member City Livery Club Non-pecuniary interests e9002d25 Michael Hudson 256
787 787 member Diamonds Past Masters’ Association. Non-pecuniary interests e9002d25 Michael Hudson 256
788 788 member Richard Reeves Foundation Non-pecuniary interests e9002d25 Michael Hudson 256
789 789 member Castle Baynard Educational Foundation Non-pecuniary interests e9002d25 Michael Hudson 256
790 790 member Samuel Wilson Trust Non-pecuniary interests e9002d25 Michael Hudson 256

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