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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
1194 1194 member Flat 21 Tudor Rose Court, 35 Fann Street, London EC2Y 8DY Land d9df90d8 Peter Gordon Bennett 1888
1195 1195 partner Flat 21 Tudor Rose Court, 35 Fann Street, London EC2Y 8DY Land d9df90d8 Peter Gordon Bennett 1888
1196 1196 member Friend of City Gardens Non-pecuniary interests e9002d25 Peter Gordon Bennett 1888
1197 1197 member Walbrook Ward Club (application submitted) Non-pecuniary interests e9002d25 Peter Gordon Bennett 1888
1198 1198 member Worshipful Company of Chartered Surveyors Non-pecuniary interests e9002d25 Peter Gordon Bennett 1888
1199 1199 member Royal Institution of Chartered Surveyors Non-pecuniary interests e9002d25 Peter Gordon Bennett 1888
1200 1200 member Chairman, Tudor Rose Court Residents' Association Non-pecuniary interests e9002d25 Peter Gordon Bennett 1888

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