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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
250 250 member Chartered Accountant Employment, office, trade, profession or vocation e938d3aa Andrien Gereith Dominic Meyers 1946
251 251 member Investment & Management Professional Employment, office, trade, profession or vocation e938d3aa Andrien Gereith Dominic Meyers 1946
252 252 member Advisor to National/Local Government and Corporate Pension Funds Employment, office, trade, profession or vocation e938d3aa Andrien Gereith Dominic Meyers 1946
253 253 member Head of Treasury & Pensions, London Borough of Lambeth, Phoenix House, 10 Wandsworth Road, London, SW8 2LL Employment, office, trade, profession or vocation e938d3aa Andrien Gereith Dominic Meyers 1946
254 254 partner Marketing Coordinator, Sidley Austin LLP, Woolgate Exchange, 25 Basinghall Street, London, EC2V 5HA Employment, office, trade, profession or vocation e938d3aa Andrien Gereith Dominic Meyers 1946
255 255 member Managing Director, Andrien Meyers Rodrigues Ltd. Employment, office, trade, profession or vocation e938d3aa Andrien Gereith Dominic Meyers 1946
256 256 member Director, Prosap Technologies Ltd. Employment, office, trade, profession or vocation e938d3aa Andrien Gereith Dominic Meyers 1946
257 257 member Strategic Advisor at BFinance Employment, office, trade, profession or vocation e938d3aa Andrien Gereith Dominic Meyers 1946
258 258 member Association of Certified Chartered Accountants (ACCA) Non-pecuniary interests e9002d25 Andrien Gereith Dominic Meyers 1946
259 259 member Institute of Leadership and Management (ILM) Non-pecuniary interests e9002d25 Andrien Gereith Dominic Meyers 1946
260 260 member Member, Society of Local Authority Chief Executives (SOLACE) Non-pecuniary interests e9002d25 Andrien Gereith Dominic Meyers 1946
261 261 member Co-Founder, City Commonwealth Economic Forum Non-pecuniary interests e9002d25 Andrien Gereith Dominic Meyers 1946
262 262 member Trustee, South London Anglo Indian Association Non-pecuniary interests e9002d25 Andrien Gereith Dominic Meyers 1946
263 263 member Member, Chartered Institute of Securities and Investment (CISI) Non-pecuniary interests e9002d25 Andrien Gereith Dominic Meyers 1946
264 264 member Member, UNISON Non-pecuniary interests e9002d25 Andrien Gereith Dominic Meyers 1946
265 265 member Member, Clapham Old Xaverians Non-pecuniary interests e9002d25 Andrien Gereith Dominic Meyers 1946
266 266 member Brother of the Cantenians Non-pecuniary interests e9002d25 Andrien Gereith Dominic Meyers 1946
267 267 member Member, Aldgate Ward Club Non-pecuniary interests e9002d25 Andrien Gereith Dominic Meyers 1946

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