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" sorted by name

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: member_id

kind 1 ✖

  • partner · 7 ✖

category_id 1 ✖

  • Corporate Tenancies · 7 ✖
Link rowid kind name ▼ category_id member_id
977 977 partner 2/4 & 25 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
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
1468 1468 partner Flat 409, Queen's Qauy, 58 Upper Thames Street, London, EC4 Corporate Tenancies 8948e857 Ian Christopher Norman Seaton 402
746 746 partner Tenant at 301 Gilbert House, Barbican. London. EC2Y 8BD. Corporate Tenancies 8948e857 Natasha Maria Cabrera Lloyd-Owen 2224
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

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