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

11 rows where category_id = "e9002d25" and member_id = 296

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ kind name category_id member_id
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");