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

7 rows where category_id = "8948e857" and kind = "partner"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: member_id

Link rowid ▼ kind name category_id member_id
636 636 partner This is a Sensitive Interest, the details of which are withheld under Section 32 of the Localism Act 2011 Corporate Tenancies 8948e857 Jason Paul Pritchard 1937
746 746 partner Tenant at 301 Gilbert House, Barbican. London. EC2Y 8BD. Corporate Tenancies 8948e857 Natasha Maria Cabrera Lloyd-Owen 2224
977 977 partner 2/4 & 25 LONDON CENTRAL MARKETS SMITHFIELD Corporate Tenancies 8948e857 Paul Nicholas Martinelli 1217
979 979 partner 206 LONDON CENTRAL MARKETS SMITHFIELD Corporate Tenancies 8948e857 Paul Nicholas Martinelli 1217
980 980 partner 210 - 213 LONDON CENTRAL MARKETS SMITHFIELD Corporate Tenancies 8948e857 Paul Nicholas Martinelli 1217
1039 1039 partner 20% Leaseholder 815 Frobisher Crescent, London, EC2Y 8HD Corporate Tenancies 8948e857 Mark Bostock 1958
1468 1468 partner Flat 409, Queen's Qauy, 58 Upper Thames Street, London, EC4 Corporate Tenancies 8948e857 Ian Christopher Norman Seaton 402

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