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 = 2058

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
398 398 member Chief Operating Officer UBS Investment Bank 5 Broadgate London EC2M 2QS Employment, office, trade, profession or vocation e938d3aa Benjamin Daniel Murphy 2058
399 399 member 5 Broadgate, London. EC2M 2QS Land d9df90d8 Benjamin Daniel Murphy 2058
400 400 member Cripplegate House, 1 Golden Lane, London. EC1Y 0RR Land d9df90d8 Benjamin Daniel Murphy 2058
401 401 member Chairman of the Board of Governors, Epping St. John's Church of England School, Bury Lane, Epping, Essex, CM16 5JB (a member of the Burnt Mill Multi Academy Trust who operates schools within London) Non-pecuniary interests e9002d25 Benjamin Daniel Murphy 2058
402 402 member Member - Bishopsgate Ward Club Non-pecuniary interests e9002d25 Benjamin Daniel Murphy 2058

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