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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1576 1576 member CHIEF EXECUTIVE, KEEPMOAT HOMES, THE WATERFRONT, LAKESIDE BOULEVARD, DONCASTER DN4 5PL Employment, office, trade, profession or vocation e938d3aa James Michael Douglas Thomson 1207
1577 1577 member CONTRACT FOR REFURBISHMENT OF BUILDING IN GREAT ARTHUR HOUSE (CONTRACT DUE TO START JAN 2015 WITH CONTRACT VALUE OF £5.9M) - FORMER GROUP COMPANY WAS SOLD ON 30 APRIL 2017 Contracts 32767bc8 James Michael Douglas Thomson 1207
1578 1578 member WALBROOK WARD CLUB, COMMITTEE MEMBER Non-pecuniary interests e9002d25 James Michael Douglas Thomson 1207
1579 1579 member THE GROCERS' COMPANY, COURT OF ASSISTANTS Non-pecuniary interests e9002d25 James Michael Douglas Thomson 1207
1580 1580 member INSTITUTE OF CHARTERED ACCOUNTANTS IN ENGLAND AND WALES - ACA Non-pecuniary interests e9002d25 James Michael Douglas Thomson 1207
1581 1581 member THE CHARTERED ACCOUNTANTS COMPANY Non-pecuniary interests e9002d25 James Michael Douglas Thomson 1207
1582 1582 member COURTS OF ASSISTANTS Non-pecuniary interests e9002d25 James Michael Douglas Thomson 1207
1583 1583 member FREEMAN Non-pecuniary interests e9002d25 James Michael Douglas Thomson 1207
1584 1584 member NON EXECUTIVE BOARD MEMBER, HOUSING & FINANCE INSTITUTE Non-pecuniary interests e9002d25 James Michael Douglas Thomson 1207

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