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

28 rows where member_id = 1658

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
523 523 member Director and Head of Investment Trusts Janus Henderson Investors 201 Bishopsgate London EC2M 3AE Employment, office, trade, profession or vocation e938d3aa James de Sausmarez 1658
524 524 member Tenancy at will - 7B Amen Court, Warwick Lane, London. EC4M 7BU Licences 613aec30 James de Sausmarez 1658
525 525 member Via Janus Henderson Group PLC Corporate Tenancies 8948e857 James de Sausmarez 1658
526 526 member Janus Henderson Group plc, 201 Bishopsgate, London EC2M 3AE Securities 4bd97394 James de Sausmarez 1658
527 527 member The Bankers Investment Trust plc, 201 Bishopsgate, London EC2M 3AE Securities 4bd97394 James de Sausmarez 1658
528 528 member The City of London Investment Trust plc, 201 Bishopsgate, London EC2M 3AE Securities 4bd97394 James de Sausmarez 1658
529 529 member Henderson European Focus Trust plc, 201 Bishopsgate, London EC2M 3AE Securities 4bd97394 James de Sausmarez 1658
530 530 member Henderson Alternative Strategies Trust plc, 201 Bishopsgate, London EC2M 3AE Securities 4bd97394 James de Sausmarez 1658
531 531 member Henderson International Income Trust plc, 201 Bishopsgate, London EC2M 3AE Securities 4bd97394 James de Sausmarez 1658
532 532 member Henderson Far East Income Limited, 201 Bishopsgate, London EC2M 3AE Securities 4bd97394 James de Sausmarez 1658
533 533 member The Henderson Smaller Companies Investment Trust plc, 201 Bishopsgate, London EC2M 3AE Securities 4bd97394 James de Sausmarez 1658
534 534 member Henderson Opportunities Trust plc, 201 Bishopsgate, London EC2M 3AE Securities 4bd97394 James de Sausmarez 1658
535 535 member The Law Debenture Corporation plc, 5th Floor, 100 Wood Street, London EC2V 7EX Securities 4bd97394 James de Sausmarez 1658
536 536 member TR European Growth Trust plc, 201 Bishopsgate, London EC2M 3AE Securities 4bd97394 James de Sausmarez 1658
537 537 member Queenswood School, Brookmans Park, Hatfield Non-pecuniary interests e9002d25 James de Sausmarez 1658
538 538 member Member, Council of St Paul's Cathedral Non-pecuniary interests e9002d25 James de Sausmarez 1658
539 539 member Member, Bishopsgate Ward Club Non-pecuniary interests e9002d25 James de Sausmarez 1658
540 540 member Member, Castle Baynard Ward Club Non-pecuniary interests e9002d25 James de Sausmarez 1658
541 541 member Member, Candlewick Ward Club Non-pecuniary interests e9002d25 James de Sausmarez 1658
542 542 member Member, Royal Society of St George, City of London Branch Non-pecuniary interests e9002d25 James de Sausmarez 1658
543 543 member Liveryman, Worshipful Company of Joiners and Ceilers Non-pecuniary interests e9002d25 James de Sausmarez 1658
544 544 member Liveryman, Worshipful Company of Chartered Secretaries and Administrators Non-pecuniary interests e9002d25 James de Sausmarez 1658
545 545 member The Guild of Freemen of the City of London Non-pecuniary interests e9002d25 James de Sausmarez 1658
546 546 member Independent member - St. Paul's Cathedral, Finance, Audit and Risk Committee Non-pecuniary interests e9002d25 James de Sausmarez 1658
547 547 member Member - Institute of Chartered Secretaries and Administrators Non-pecuniary interests e9002d25 James de Sausmarez 1658
548 548 member Member - Institute of Directors Non-pecuniary interests e9002d25 James de Sausmarez 1658
549 549 member Founding member - proposed Guild of Investment Managers Non-pecuniary interests e9002d25 James de Sausmarez 1658
550 550 member Member - London Diocese’s Non-Property Investment Advisory Group Non-pecuniary interests e9002d25 James de Sausmarez 1658

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