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

7 rows where member_id = 362

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
308 308 member Interactive Brokers Group Ltd, Carey Lane, London EC2 Employment, office, trade, profession or vocation e938d3aa Stephen Douglas Quilter 362
309 309 member Andrewes House, Barbican, London EC2 Land d9df90d8 Stephen Douglas Quilter 362
310 310 member Member Barbican Association Non-pecuniary interests e9002d25 Stephen Douglas Quilter 362
311 311 member Member Cripplegate Ward Club Non-pecuniary interests e9002d25 Stephen Douglas Quilter 362
312 312 member Member Broad Street Ward Club Non-pecuniary interests e9002d25 Stephen Douglas Quilter 362
313 313 member Member Guildhall Lodge Non-pecuniary interests e9002d25 Stephen Douglas Quilter 362
314 314 member Member Society of Technical Analysts Non-pecuniary interests e9002d25 Stephen Douglas Quilter 362

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