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

10 rows where category_id = "e938d3aa" and member_id = 1224

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind

Link rowid ▼ kind name category_id member_id
368 368 member Landlord (carried on in my own name) Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
369 369 partner Employee of Capital International Ltd of 40 Grosvenor Place, London, SW1X 7GG Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
370 370 member Trustee Member - Clockwork Pharmacy Group SSAS Chalfont Court, Hill Avenue, Amersham HP6 5BB Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
371 371 member Partner - Clockwork Underwriting LLP (an admitted underwriting member of The Society of Lloyd's and capital provider to a number of syndicates open to third parties) 3 Catlegate, Grantham, Lincolnshire NG31 6SF Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
372 372 member Company Secretary, shareholder - Clockwork Retail Ltd 215-217 Victoria Park Road, London E9 7HD Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
373 373 member Company Secretary - Clockwork Pharmacy Ltd 215-217 Victoria Park Road, London E9 7HD Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
374 374 member Partner - Clockwork Hotels LLP 215-217 Victoria Park Road, London E9 7HD Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
375 375 member Director, shareholder - D P Facility Management Limited 334-336 Goswell Road, London EC1V 7RP Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
376 376 member Director, shareholder - Clockwork Farms Limited 215-217 Victoria Park Road, London E9 7HD Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224
377 377 member Company Secretary - P & A Developments (London) Ltd, 215-217 Victoria Park Road, London E9 7HD Employment, office, trade, profession or vocation e938d3aa Dhruv Patel 1224

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