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 = 384

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1083 1083 member Leasehold Interest- Pemberton Row,EC4 Land d9df90d8 Jeremy Lewis Simons 384
1084 1084 member Part Freehold Interest- Pemberton Row, EC4 Land d9df90d8 Jeremy Lewis Simons 384
1085 1085 member One share of Pemberton Row Limited, EC4 Securities 4bd97394 Jeremy Lewis Simons 384
1086 1086 member Trustee - Castle Baynard Educational Foundation and Alderman Samuel Wilson Fund Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1087 1087 member Trustee - City of London Archaeological Trust Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1088 1088 member Trustee - Dr Johnson House Trust Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1089 1089 member Trustee - St Andrew Holborn and Stafford’s Charity Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1090 1090 member Trustee - The Tree Council Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1091 1091 member Trustee - Housing the Homeless Central Fund Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1092 1092 member Member - Castle Baynard Ward Club Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1093 1093 member Member - Guildhall Circle (Guildhall School Friends) Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1094 1094 member Worshipful Company of Scientific Instrument Makers Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1095 1095 member Member - Chartered Institute of Management Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1096 1096 member Member - Epping Forest Heritage Trust Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1097 1097 member Trustee, Thames 21 Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1098 1098 member Member, Friends of Heath Hands Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384
1099 1099 member Member, London Society Non-pecuniary interests e9002d25 Jeremy Lewis Simons 384

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