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

9 rows where member_id = 200

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
698 698 member Director of CHAPTER CHAMBERS MANAGEMENT LIMITED (From October 2015, freehold company of flat) Employment, office, trade, profession or vocation e938d3aa Peter Gerard Dunphy 200
699 699 member Director, Gizmo Films Productions, London SW1 Employment, office, trade, profession or vocation e938d3aa Peter Gerard Dunphy 200
700 700 member Director, Compliance Recruitment Solutions, 11-12 Tokenhouse Yard, London EC2R 7AS Employment, office, trade, profession or vocation e938d3aa Peter Gerard Dunphy 200
701 701 member Consultant, Change UK - The Independent Group Employment, office, trade, profession or vocation e938d3aa Peter Gerard Dunphy 200
702 702 member Member, Change UK - The Independent Group Non-pecuniary interests e9002d25 Peter Gerard Dunphy 200
703 703 member Member, Lime Street and Cornhill Ward Club Non-pecuniary interests e9002d25 Peter Gerard Dunphy 200
704 704 member Member CAMRA Non-pecuniary interests e9002d25 Peter Gerard Dunphy 200
705 705 member Liveryman, Drapers’ Company Non-pecuniary interests e9002d25 Peter Gerard Dunphy 200
706 706 member Trustee, The Honourable The Irish Society Non-pecuniary interests e9002d25 Peter Gerard Dunphy 200

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