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

12 rows where member_id = 392

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
1179 1179 member 133 Cromwell Tower, Barbican, EC2Y 8DD Land d9df90d8 John Tomlinson 392
1180 1180 partner 133 Cromwell Tower, Barbican, EC2Y 8DD Land d9df90d8 John Tomlinson 392
1181 1181 member Member - Barbican Association (General Council) Non-pecuniary interests e9002d25 John Tomlinson 392
1182 1182 member Member- Barbican Horticultural Society Non-pecuniary interests e9002d25 John Tomlinson 392
1183 1183 member Trustee - Cripplegate Foundation Non-pecuniary interests e9002d25 John Tomlinson 392
1184 1184 member Member - Cripplegate Ward Club Non-pecuniary interests e9002d25 John Tomlinson 392
1185 1185 member Chairman, Cromwell Tower House Group Non-pecuniary interests e9002d25 John Tomlinson 392
1186 1186 member Member - Guildhall Historical Association Non-pecuniary interests e9002d25 John Tomlinson 392
1187 1187 member Member - Guildhall Lodge Non-pecuniary interests e9002d25 John Tomlinson 392
1188 1188 member Member - Livery Lounge Party Non-pecuniary interests e9002d25 John Tomlinson 392
1189 1189 member Member - Royal Society of St George (City Branch) Non-pecuniary interests e9002d25 John Tomlinson 392
1190 1190 member Liveryman - Worshipful Company of Fletchers Non-pecuniary interests e9002d25 John Tomlinson 392

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