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

18 rows where member_id = 1935

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
1117 1117 member Barrister at Chambers of Stephen Hockman QC Employment, office, trade, profession or vocation e938d3aa William Upton QC 1935
1118 1118 partner Classical Musican Employment, office, trade, profession or vocation e938d3aa William Upton QC 1935
1119 1119 member Director, Upton Underwriting Limited Employment, office, trade, profession or vocation e938d3aa William Upton QC 1935
1120 1120 partner Instrumental Professor at Royal Academy of Music Employment, office, trade, profession or vocation e938d3aa William Upton QC 1935
1121 1121 partner Instrumental Staff at Purcell School Employment, office, trade, profession or vocation e938d3aa William Upton QC 1935
1122 1122 partner Associate Director, Youth Chamber Orchestra Employment, office, trade, profession or vocation e938d3aa William Upton QC 1935
1123 1123 member Tenant Barrister at Pump Court Temple Corporate Tenancies 8948e857 William Upton QC 1935
1124 1124 member Upton Underwriting Securities 4bd97394 William Upton QC 1935
1125 1125 member Planning Aid Trust (RIPI) Non-pecuniary interests e9002d25 William Upton QC 1935
1126 1126 member Sir James Reckitt Charity Trust Non-pecuniary interests e9002d25 William Upton QC 1935
1127 1127 member Fellow of Royal Society of Arts Non-pecuniary interests e9002d25 William Upton QC 1935
1128 1128 member Member of Town and Country Planning Association Non-pecuniary interests e9002d25 William Upton QC 1935
1129 1129 member Member of Amnesty International Non-pecuniary interests e9002d25 William Upton QC 1935
1130 1130 member Member of Planning Local Government & Environmental Bar Association Non-pecuniary interests e9002d25 William Upton QC 1935
1131 1131 member Honourable Society of the Inner Temple Non-pecuniary interests e9002d25 William Upton QC 1935
1132 1132 member Constitutional and Administrative Law Bar Association Non-pecuniary interests e9002d25 William Upton QC 1935
1133 1133 member UK Environmental Law Association Non-pecuniary interests e9002d25 William Upton QC 1935
1134 1134 member Member - Temple and Farringdon Together Non-pecuniary interests e9002d25 William Upton QC 1935

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