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

23 rows where member_id = 1217

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
966 966 member P J MARTINELLI LTD 25 LONDON CENTRAL MKTS SMITHFIELD MANAGING DIRECTOR Employment, office, trade, profession or vocation e938d3aa Paul Nicholas Martinelli 1217
967 967 partner DIRECTOR P J MARTINELLI LTD Employment, office, trade, profession or vocation e938d3aa Paul Nicholas Martinelli 1217
968 968 member 25 LCM, SMITHFIELD Land d9df90d8 Paul Nicholas Martinelli 1217
969 969 partner 25 LCM, SMITHFIELD Land d9df90d8 Paul Nicholas Martinelli 1217
970 970 member 2/4 LCM, SMITHFIELD Land d9df90d8 Paul Nicholas Martinelli 1217
971 971 partner 2/4 SMITHFIELD Land d9df90d8 Paul Nicholas Martinelli 1217
972 972 member 206 LONDON CENTRAL MARKETS Land d9df90d8 Paul Nicholas Martinelli 1217
973 973 partner 206 LONDON CENTRAL MARKETS Land d9df90d8 Paul Nicholas Martinelli 1217
974 974 member 210-213 LONDON CENTRAL MARKETS Land d9df90d8 Paul Nicholas Martinelli 1217
975 975 partner 210-213 LONDON CENTRAL MARKETS Land d9df90d8 Paul Nicholas Martinelli 1217
976 976 member 2/4 & 25 LONDON CENTRAL MARKETS SMITHFIELD Corporate Tenancies 8948e857 Paul Nicholas Martinelli 1217
977 977 partner 2/4 & 25 LONDON CENTRAL MARKETS SMITHFIELD Corporate Tenancies 8948e857 Paul Nicholas Martinelli 1217
978 978 member 225 LONDON CENTRAL MARKETS (TREASURER & TRUSTEE OF SMTA) Corporate Tenancies 8948e857 Paul Nicholas Martinelli 1217
979 979 partner 206 LONDON CENTRAL MARKETS SMITHFIELD Corporate Tenancies 8948e857 Paul Nicholas Martinelli 1217
980 980 partner 210 - 213 LONDON CENTRAL MARKETS SMITHFIELD Corporate Tenancies 8948e857 Paul Nicholas Martinelli 1217
981 981 member P. J MARTINELLI LTD Securities 4bd97394 Paul Nicholas Martinelli 1217
982 982 member Member, Farringdon Ward Club Non-pecuniary interests e9002d25 Paul Nicholas Martinelli 1217
983 983 member Liveryman, Worshipful Company of Butchers Non-pecuniary interests e9002d25 Paul Nicholas Martinelli 1217
984 984 member Treasurer, Smithfield Market Tenants' Association Non-pecuniary interests e9002d25 Paul Nicholas Martinelli 1217
985 985 member Governor, Museum of London Non-pecuniary interests e9002d25 Paul Nicholas Martinelli 1217
986 986 member Treasurer, Temple and Farringdon Together Non-pecuniary interests e9002d25 Paul Nicholas Martinelli 1217
987 987 member Member, City Bridge Trust Non-pecuniary interests e9002d25 Paul Nicholas Martinelli 1217
988 988 member CoLAT Management Committee, City of London Archaeological Society Non-pecuniary interests e9002d25 Paul Nicholas Martinelli 1217

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