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

15 rows where member_id = 133

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
617 617 member Senior Director, KWM 150 Cheapside London, EC2 6ET Employment, office, trade, profession or vocation e938d3aa Nicholas Anstee 133
618 618 partner Self Employed Employment, office, trade, profession or vocation e938d3aa Nicholas Anstee 133
619 619 member Service Charges in respect of property at EC2 Contracts 32767bc8 Nicholas Anstee 133
620 620 partner Service Charges in respect of property at EC2 Contracts 32767bc8 Nicholas Anstee 133
621 621 member Freehold Townhouse, EC2 Land d9df90d8 Nicholas Anstee 133
622 622 partner Freehold Townhouse, EC2 Land d9df90d8 Nicholas Anstee 133
623 623 member Investec Bank plc 30 Gresham Street London EC2V 7QP Securities 4bd97394 Nicholas Anstee 133
624 624 member Director of London Marathon Events Ltd. Non-pecuniary interests e9002d25 Nicholas Anstee 133
625 625 member London Symphony Orchestra, Advisory Council Member Non-pecuniary interests e9002d25 Nicholas Anstee 133
626 626 member Member, Marylebone Cricket Club (MCC) Non-pecuniary interests e9002d25 Nicholas Anstee 133
627 627 member The Worshipful Company of Butchers, Member Non-pecuniary interests e9002d25 Nicholas Anstee 133
628 628 member The Worshipful Company of Plaisterers, Honorary Member Non-pecuniary interests e9002d25 Nicholas Anstee 133
629 629 member Barbican Association, Member Non-pecuniary interests e9002d25 Nicholas Anstee 133
630 630 member Aldersgate Ward Club, Member Non-pecuniary interests e9002d25 Nicholas Anstee 133
631 631 member ICAEW, Member Non-pecuniary interests e9002d25 Nicholas Anstee 133

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