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

17 rows where member_id = 396

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
7 7 member Partner, CMS Cameron McKenna Nabarro Olowang, Aldersgate Street, EC1 Employment, office, trade, profession or vocation e938d3aa Dame Fiona Woolf 396
8 8 member CMS Cameron McKenna Nabarro Olowang has provided legal advice to the City of London Corporation and may do so again in the future. Contracts 32767bc8 Dame Fiona Woolf 396
9 9 member CMS Cameron McKenna Nabarro Olowang has a Leasehold interest in a property in Canon Street. Land d9df90d8 Dame Fiona Woolf 396
10 10 member CMS Cameron McKenna has a Leasehold interest in a property in Canon Street. Corporate Tenancies 8948e857 Dame Fiona Woolf 396
11 11 member Tesco (through Tesco Personal Finance Investments) Securities 4bd97394 Dame Fiona Woolf 396
12 12 member Helical Bar Securities 4bd97394 Dame Fiona Woolf 396
13 13 member St Modwen Properties Securities 4bd97394 Dame Fiona Woolf 396
14 14 member Trustee, Science Museum Group Non-pecuniary interests e9002d25 Dame Fiona Woolf 396
15 15 member Lord Mayor's Appeal Non-pecuniary interests e9002d25 Dame Fiona Woolf 396
16 16 member City Livery Club Non-pecuniary interests e9002d25 Dame Fiona Woolf 396
17 17 member Candlewick Ward Club Non-pecuniary interests e9002d25 Dame Fiona Woolf 396
18 18 member Farringdon Ward Club Non-pecuniary interests e9002d25 Dame Fiona Woolf 396
19 19 member Livery Companies - Solicitors, Plumbers, Wax Chandlers, Arbitrators, Builders' Merchants, Paviors, Fuellers, Lightmongers, Turners, Tax Advisers and Security Professionals Non-pecuniary interests e9002d25 Dame Fiona Woolf 396
20 20 member Member, The Law Society of England and Wales Non-pecuniary interests e9002d25 Dame Fiona Woolf 396
21 21 member Member, Aldersgate Group Non-pecuniary interests e9002d25 Dame Fiona Woolf 396
22 22 member Member, Middle Temple Non-pecuniary interests e9002d25 Dame Fiona Woolf 396
23 23 member Trustee, Wexford Festival Opera (UK) Non-pecuniary interests e9002d25 Dame Fiona Woolf 396

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