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 member_id = 375

View and edit SQL

Link rowid ▼ kind name category_id member_id
153 member Coordinator, Bart's Hospital Volunteers Non-pecuniary interests e9002d25 Wendy Mead 375
154 member Board of Management, Bart's Guild (League of Friends) Non-pecuniary interests e9002d25 Wendy Mead 375
155 member Friends of Bart's Great Hall and Archives Non-pecuniary interests e9002d25 Wendy Mead 375
156 member Trustee, Housing the Homeless Central Fund Non-pecuniary interests e9002d25 Wendy Mead 375
157 member Member, City Livery Club Non-pecuniary interests e9002d25 Wendy Mead 375
158 member Member, Aldersgate Ward Club Non-pecuniary interests e9002d25 Wendy Mead 375
159 member Member, Farringdon Ward Club Non-pecuniary interests e9002d25 Wendy Mead 375
160 member Member, London Historical Society Non-pecuniary interests e9002d25 Wendy Mead 375
161 member Associate Member, City of London 600 Squadron Association Non-pecuniary interests e9002d25 Wendy Mead 375
162 member Member, Sheriffs & Recorder's Fund Non-pecuniary interests e9002d25 Wendy Mead 375
163 member Member, City of London Heritage Society Non-pecuniary interests e9002d25 Wendy Mead 375

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