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

11 rows where member_id = 1458

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
108 108 member Barrister, No. 5 Chambers, Greenwood House, 4-7 Salisbury Court EC4Y 8AA Employment, office, trade, profession or vocation e938d3aa Emma Edhem 1458
109 109 partner Jagex Games Studio, Cambridge Sciene Park, 220 Milton CB4 0WA Employment, office, trade, profession or vocation e938d3aa Emma Edhem 1458
110 110 member Chairman of EMYA Global Employment, office, trade, profession or vocation e938d3aa Emma Edhem 1458
111 111 member City of London Committee of the Red Cross Non-pecuniary interests e9002d25 Emma Edhem 1458
112 112 member Royal Bridewell Hospital Non-pecuniary interests e9002d25 Emma Edhem 1458
113 113 member British Azerbaijan Law Association Non-pecuniary interests e9002d25 Emma Edhem 1458
114 114 member Board of the UK Hungarian Business Council Non-pecuniary interests e9002d25 Emma Edhem 1458
115 115 member Christ’s Hospital Non-pecuniary interests e9002d25 Emma Edhem 1458
116 116 member Board of Turkish British Chamber of Commerce and Industry Non-pecuniary interests e9002d25 Emma Edhem 1458
117 117 member City Giving Day Non-pecuniary interests e9002d25 Emma Edhem 1458
118 118 member Court Assistant of the Woolmen Non-pecuniary interests e9002d25 Emma Edhem 1458

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