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 kind = "member" and member_id = 296

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1100 1100 member Panel Chairman, Nursing and Midwifery Council, 23 Portland Place, London W1 Employment, office, trade, profession or vocation e938d3aa Ian David Luder 296
1102 1102 member Independent Member (External) Audit and Transparency Committee, Royal Borough of Kensington and Chelsea, Town Hall, Hornton Street, London W8 Employment, office, trade, profession or vocation e938d3aa Ian David Luder 296
1103 1103 member Registrant Panel Member of the Taxation Disciplinary Board, of PO Box 224, Rushlake Green, Heathfield, TN21 1DQ Employment, office, trade, profession or vocation e938d3aa Ian David Luder 296
1104 1104 member Andrewes House, Barbican, London. EC2Y 8AX Land d9df90d8 Ian David Luder 296
1106 1106 member Trustee - Castle Baynard Education Foundation Non-pecuniary interests e9002d25 Ian David Luder 296
1107 1107 member Trustee - Samuel Wilson Charity Non-pecuniary interests e9002d25 Ian David Luder 296
1108 1108 member Member, Marylebone Cricket Club Non-pecuniary interests e9002d25 Ian David Luder 296
1109 1109 member Member - United Grand Lodge of England and Guildhall Lodge Non-pecuniary interests e9002d25 Ian David Luder 296
1110 1110 member Member - Coleman Street and Farringdon Ward Clubs & President - Castle Baynard Ward Club Non-pecuniary interests e9002d25 Ian David Luder 296
1111 1111 member Court Member - Worshipful Companies of Coopers, Tax Advisors, Arts Scholars (Master 2014/2015) Non-pecuniary interests e9002d25 Ian David Luder 296
1112 1112 member Honorary Liveryman - Worshipful Company of Security Professionals Non-pecuniary interests e9002d25 Ian David Luder 296
1113 1113 member Fellow, Chartered Institute of Taxation Non-pecuniary interests e9002d25 Ian David Luder 296
1114 1114 member Member, Barbican Association, City Pickwick Club, Guild of Freeman, Royal Soceity of St George Non-pecuniary interests e9002d25 Ian David Luder 296
1115 1115 member Guildhall Manor of Southwark (2014-2015, Foreman) Non-pecuniary interests e9002d25 Ian David Luder 296
1116 1116 member Fellow, Institute of Chartered Accountants in England and Wales Non-pecuniary interests e9002d25 Ian David Luder 296

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