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

5 rows where member_id = 1956

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
605 605 member Mattison Public Relations (UK) LLP, 3 Quastels House, 32 Long Lane, London. SE1 4AY Employment, office, trade, profession or vocation e938d3aa Richard Peter Crossan 1956
606 606 partner research Analyst, Mintel International Group Ltd, 11 Pilgrim Street, London. EC4V 6RN Employment, office, trade, profession or vocation e938d3aa Richard Peter Crossan 1956
607 607 member Member- Labour Party Non-pecuniary interests e9002d25 Richard Peter Crossan 1956
608 608 member Member - 20th Century Society Non-pecuniary interests e9002d25 Richard Peter Crossan 1956
609 609 member Member - Unite the Union Non-pecuniary interests e9002d25 Richard Peter Crossan 1956

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