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

3 rows where category_id = "e938d3aa", kind = "member" and member_id = 296

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ kind name category_id member_id
1100 1100 member Panel Chairman, Nursing and Midwifery Council, 23 Portland Place, London W1 Employment, office, trade, profession or vocation e938d3aa Ian David Luder 296
1102 1102 member Independent Member (External) Audit and Transparency Committee, Royal Borough of Kensington and Chelsea, Town Hall, Hornton Street, London W8 Employment, office, trade, profession or vocation e938d3aa Ian David Luder 296
1103 1103 member Registrant Panel Member of the Taxation Disciplinary Board, of PO Box 224, Rushlake Green, Heathfield, TN21 1DQ Employment, office, trade, profession or vocation e938d3aa Ian David Luder 296

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