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

15 rows where member_id = 151

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
1201 1201 member Non-executive Director, Adept 4 PLC Employment, office, trade, profession or vocation e938d3aa Simon D'Olier Duckworth 151
1202 1202 partner Director, Hampden and Co Employment, office, trade, profession or vocation e938d3aa Simon D'Olier Duckworth 151
1203 1203 member Chair, Advisory Board, Barings Targeted Returns Fund Employment, office, trade, profession or vocation e938d3aa Simon D'Olier Duckworth 151
1204 1204 member Non-Executive Director, Association of Police and Crime Commissioners Employment, office, trade, profession or vocation e938d3aa Simon D'Olier Duckworth 151
1205 1205 member Non-executive Director, Serious Fraud Office Employment, office, trade, profession or vocation e938d3aa Simon D'Olier Duckworth 151
1206 1206 member Non-executive Director, Bell Integration Ltd. Employment, office, trade, profession or vocation e938d3aa Simon D'Olier Duckworth 151
1207 1207 member Address at Wormwood Street, London EC2 Land d9df90d8 Simon D'Olier Duckworth 151
1208 1208 partner Address at Wormwood Street, London EC2 Land d9df90d8 Simon D'Olier Duckworth 151
1209 1209 member Lord Mayor's 800th Anniversary Awards Trust Non-pecuniary interests e9002d25 Simon D'Olier Duckworth 151
1210 1210 member City Pickwick Club Non-pecuniary interests e9002d25 Simon D'Olier Duckworth 151
1211 1211 member The Skinners' Company Non-pecuniary interests e9002d25 Simon D'Olier Duckworth 151
1212 1212 member The Worshipful Company of Parish Clerks Non-pecuniary interests e9002d25 Simon D'Olier Duckworth 151
1213 1213 member Reserve Forces' and Cadets' Association Non-pecuniary interests e9002d25 Simon D'Olier Duckworth 151
1214 1214 member Honorary Colonel - Royal Military Police Non-pecuniary interests e9002d25 Simon D'Olier Duckworth 151
1215 1215 member Masonic Charitable Foundation Non-pecuniary interests e9002d25 Simon D'Olier Duckworth 151

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