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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1599 1599 member Chairman, Chartered Institute for Securities & Investment, 20 Fenchurch Street, London. EC3M 3BY Employment, office, trade, profession or vocation e938d3aa Sir Alan Colin Drake Yarrow 399
1600 1600 member Director, Arbuthnot Banking Group PLC, 7 Wilson Street, London. EC2M 2SN Employment, office, trade, profession or vocation e938d3aa Sir Alan Colin Drake Yarrow 399
1601 1601 member Chairman Turquoise Global Holdings Ltd, Paternoster Square, EC4 Employment, office, trade, profession or vocation e938d3aa Sir Alan Colin Drake Yarrow 399
1602 1602 member Director, Institutional Protection Services Limited, 1-3 Staple Inn, London. WC1V 7QH Employment, office, trade, profession or vocation e938d3aa Sir Alan Colin Drake Yarrow 399
1603 1603 member Independent Partnership Advisor, James Hambro Partners, 45 Pall Mall, London. SW1Y 5JG Employment, office, trade, profession or vocation e938d3aa Sir Alan Colin Drake Yarrow 399
1604 1604 member Advisory Board Member - Zeamo Incorporated (USA) Employment, office, trade, profession or vocation e938d3aa Sir Alan Colin Drake Yarrow 399
1605 1605 member Chartered Institute for Securities & Investment, Eastcheap, EC3 Corporate Tenancies 8948e857 Sir Alan Colin Drake Yarrow 399
1606 1606 member HM Lieutenant of the City of London Non-pecuniary interests e9002d25 Sir Alan Colin Drake Yarrow 399
1607 1607 member Royal Mencap Society (Vice President) Non-pecuniary interests e9002d25 Sir Alan Colin Drake Yarrow 399
1608 1608 member Bridge Ward Club Non-pecuniary interests e9002d25 Sir Alan Colin Drake Yarrow 399
1609 1609 member Member of Commonwealth Enterprise & Investment Council, Advisory Board Non-pecuniary interests e9002d25 Sir Alan Colin Drake Yarrow 399
1610 1610 member Livery Companies - Fishmongers, Glaziers, International Bankers, Honorary Member of Scientific Instruments Makers, Launderers and the Security Professionals. Non-pecuniary interests e9002d25 Sir Alan Colin Drake Yarrow 399
1611 1611 member Member, Takeover Appeal Board Non-pecuniary interests e9002d25 Sir Alan Colin Drake Yarrow 399
1612 1612 member Chartered Honorary Fellow, Chartered Institute for Securities & Investment Non-pecuniary interests e9002d25 Sir Alan Colin Drake Yarrow 399
1613 1613 member Honorary Fellow, Institute of Chartered Secretaries & Administrators Non-pecuniary interests e9002d25 Sir Alan Colin Drake Yarrow 399

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