Interests for members and their partners ('Spouse/Civil Partner/Living as such') from the Register of Interests.

Data source: See col-scraper on GitHub

16 rows where member_id = 1957

View and edit SQL

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
836 member Support from City of London Branch of the Labour Party for election expenses Sponsorship d9d60c21 Mary Durcan 1957
837 member 48 Andrewes House, London EC2Y 8AX (leaseholder) Land d9df90d8 Mary Durcan 1957
838 partner 48 Andrewes House, London EC2Y 8AX (leaseholder) Land d9df90d8 Mary Durcan 1957
839 member Own car parking space in Andrewes House Licences 613aec30 Mary Durcan 1957
840 partner Own car parking space in Andrewes House Licences 613aec30 Mary Durcan 1957
841 member Various investments, unit trust holdings and ETFs in my ISAs and general investment account which may exceed £25,000 each and may invest in institutions based in the City. These investments are professionally managed on my behalf. Securities 4bd97394 Mary Durcan 1957
842 partner Various investments, unit trust holdings and ETFs in my ISAs and general investment account which may exceed £25,000 each and may invest in institutions based in the City. These investments are professionally managed on my behalf. Also has a SIPP. Securities 4bd97394 Mary Durcan 1957
843 member Member - Barbican Association Non-pecuniary interests e9002d25 Mary Durcan 1957
844 member Member - Andrewes House Group Non-pecuniary interests e9002d25 Mary Durcan 1957
845 member Member - Labour Party Non-pecuniary interests e9002d25 Mary Durcan 1957
846 member Member - Co-op Party Non-pecuniary interests e9002d25 Mary Durcan 1957
847 member Member - British Humanist Association Non-pecuniary interests e9002d25 Mary Durcan 1957
848 member Member - Labour Friends of Israel Non-pecuniary interests e9002d25 Mary Durcan 1957
849 member Member - Woodland Trust Non-pecuniary interests e9002d25 Mary Durcan 1957
850 member Member - Tate Non-pecuniary interests e9002d25 Mary Durcan 1957
851 member Member - Jewish Labour Movement Non-pecuniary interests e9002d25 Mary Durcan 1957

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