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

6 rows where member_id = 1222

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
733 733 member Global Head of Internal Communications Cristal Pigments UK Ltd Stallingborough PO Box 26, Grimsby. DN41 8DP Employment, office, trade, profession or vocation e938d3aa Karina Dostalova 1222
734 734 member Liveryman - Worshipful Company of Marketors Non-pecuniary interests e9002d25 Karina Dostalova 1222
735 735 member Member, Eight Members Club Non-pecuniary interests e9002d25 Karina Dostalova 1222
736 736 member Member, Hampstead and Kilburn Conservative Association Non-pecuniary interests e9002d25 Karina Dostalova 1222
737 737 member Institute of Internal Communications (IOIC) Non-pecuniary interests e9002d25 Karina Dostalova 1222
738 738 member Titanium Dioxide Manufacturers Association Non-pecuniary interests e9002d25 Karina Dostalova 1222

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