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

14 rows where member_id = 158

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
164 164 member EC Financial Associates - Management Consultancy Employment, office, trade, profession or vocation e938d3aa Roger Arthur Holden Chadwick 158
165 165 partner Honorary Ward Clerk, City of London Corporation, EC2P 2EJ Employment, office, trade, profession or vocation e938d3aa Roger Arthur Holden Chadwick 158
166 166 member Institute of Chartered Accountants in England & Wales (retired) Employment, office, trade, profession or vocation e938d3aa Roger Arthur Holden Chadwick 158
167 167 member Chartered Institute of Public Finance Accountants (retired) Employment, office, trade, profession or vocation e938d3aa Roger Arthur Holden Chadwick 158
168 168 member Co-operation Ireland - Chairman of GB Executive Contracts 32767bc8 Roger Arthur Holden Chadwick 158
169 169 member Tower Ward Club Non-pecuniary interests e9002d25 Roger Arthur Holden Chadwick 158
170 170 partner Tower Ward Club Non-pecuniary interests e9002d25 Roger Arthur Holden Chadwick 158
171 171 member Freemason Non-pecuniary interests e9002d25 Roger Arthur Holden Chadwick 158
172 172 member Liveryman Worshipful Company of Bowyers Non-pecuniary interests e9002d25 Roger Arthur Holden Chadwick 158
173 173 member Liveryman Worshipful Company of World Traders Non-pecuniary interests e9002d25 Roger Arthur Holden Chadwick 158
174 174 member Member of the Guild Church of St Lawrence Jewry Non-pecuniary interests e9002d25 Roger Arthur Holden Chadwick 158
175 175 member Trustee of The Honourable The Irish Society Non-pecuniary interests e9002d25 Roger Arthur Holden Chadwick 158
176 176 member Honorary Treasurer of the Guild Church of St Lawrence Jewry Non-pecuniary interests e9002d25 Roger Arthur Holden Chadwick 158
177 177 member Chairman of Governors - City of London Freemen's School Non-pecuniary interests e9002d25 Roger Arthur Holden Chadwick 158

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