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

17 rows where member_id = 251

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
91 91 member Partner, Tower Bridge Consulting, Gainsford Street, SE1 Employment, office, trade, profession or vocation e938d3aa Tom Hoffman 251
92 92 member Trustee, Corporation of the Sons and Friends of the Clergy, London Non-pecuniary interests e9002d25 Tom Hoffman 251
93 93 member Chairman, Stour Festival Company Limited, Kent Non-pecuniary interests e9002d25 Tom Hoffman 251
94 94 member Hon. Auditor, John Mayne Charity, Biddenden Non-pecuniary interests e9002d25 Tom Hoffman 251
95 95 member Hon. Treasurer, Guildhall Historical Association Non-pecuniary interests e9002d25 Tom Hoffman 251
96 96 member Hon. Treasurer and Past Chairman, Cordwainer Ward Club Non-pecuniary interests e9002d25 Tom Hoffman 251
97 97 member Past Chairman, Vintry and Dowgate Wards Club Non-pecuniary interests e9002d25 Tom Hoffman 251
98 98 member Life Member, City Livery Club Non-pecuniary interests e9002d25 Tom Hoffman 251
99 99 member Life Member, Guild of Freemen of the City of London Non-pecuniary interests e9002d25 Tom Hoffman 251
100 100 member Past Master, Lodge of Antiquity, No. 2 in the United Grand Lodge of England Non-pecuniary interests e9002d25 Tom Hoffman 251
101 101 member Past Master, Worshipful Company of Tylers and Bricklayers Non-pecuniary interests e9002d25 Tom Hoffman 251
102 102 member Fellow of the Institute of Chartered Accountants in England and Wales Non-pecuniary interests e9002d25 Tom Hoffman 251
103 103 member Hon. Vice President, Portuguese Chamber of Commerce and Industry Non-pecuniary interests e9002d25 Tom Hoffman 251
104 104 member Governor, Guy's and St Thomas' NHS Foundation Trust Non-pecuniary interests e9002d25 Tom Hoffman 251
105 105 member Chairman, Caspian Sea Capital Limited Non-pecuniary interests e9002d25 Tom Hoffman 251
106 106 member Director, Tower Bridge Square Management Limited Non-pecuniary interests e9002d25 Tom Hoffman 251
107 107 member Partner, Tower Bridge consulting Non-pecuniary interests e9002d25 Tom Hoffman 251

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