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 = "ec8872e8"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ kind name category_id member_id
46 46 member Justice of the Peace, Central London Justice Area Other non-remunerated directorship etc. ec8872e8 Edward Lord 292
47 47 member Member, Honourable Society of The Middle Temple Other non-remunerated directorship etc. ec8872e8 Edward Lord 292
48 48 member Governor, Christ’s Hospital Other non-remunerated directorship etc. ec8872e8 Edward Lord 292
49 49 member Court Member, The University of Essex Other non-remunerated directorship etc. ec8872e8 Edward Lord 292
50 50 member Audit and Risk Management Committee Member, University of Essex Other non-remunerated directorship etc. ec8872e8 Edward Lord 292
51 51 member Advisory Board Member, British German Forum, Foreign and Commonwealth Office Other non-remunerated directorship etc. ec8872e8 Edward Lord 292
52 52 member Board Member, BiUK Other non-remunerated directorship etc. ec8872e8 Edward Lord 292
53 53 member Role Model, Stonewall Equality Limited Other non-remunerated directorship etc. ec8872e8 Edward Lord 292
54 54 member Voting Member, Liberty Other non-remunerated directorship etc. ec8872e8 Edward Lord 292
55 55 member Voting Member, Amnesty International Other non-remunerated directorship etc. ec8872e8 Edward Lord 292

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