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

16 rows where member_id = 131

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, name, category_id

Link rowid ▼ kind name category_id member_id
930 930 member Managing Director, George Abrahams Group, 217/218 Smithfield, London EC1A 9LH Employment, office, trade, profession or vocation e938d3aa George Christopher Abrahams 131
931 931 partner Baycrest Developments Ltd. Employment, office, trade, profession or vocation e938d3aa George Christopher Abrahams 131
932 932 member Baycrest Developments Ltd. Employment, office, trade, profession or vocation e938d3aa George Christopher Abrahams 131
933 933 partner Baycrest Properties Ltd. Employment, office, trade, profession or vocation e938d3aa George Christopher Abrahams 131
934 934 member Baycrest Properties Ltd. Employment, office, trade, profession or vocation e938d3aa George Christopher Abrahams 131
935 935 member GA International Food Services Employment, office, trade, profession or vocation e938d3aa George Christopher Abrahams 131
936 936 member Market Provisions (Smithfield) Ltd. Employment, office, trade, profession or vocation e938d3aa George Christopher Abrahams 131
937 937 member Corporation Tenant - 20, 22, 217-218 Central Markets, Smithfield, London EC1 Land d9df90d8 George Christopher Abrahams 131
938 938 member Corporation Tenant - 20, 22, 217-218 Central Markets, Smithfield, London EC1 Licences 613aec30 George Christopher Abrahams 131
939 939 member 20, 22, 217/218 Central Markets, Smithfield, EC1 Corporate Tenancies 8948e857 George Christopher Abrahams 131
940 940 member Corporation Tenant - 20, 22, 217-218 Central Markets, Smithfield, London EC1 Securities 4bd97394 George Christopher Abrahams 131
941 941 member Society of St George Non-pecuniary interests e9002d25 George Christopher Abrahams 131
942 942 member International Meat Traders Association (IMTA) Non-pecuniary interests e9002d25 George Christopher Abrahams 131
943 943 member International Meat Trades Association (IMTA) Non-pecuniary interests e9002d25 George Christopher Abrahams 131
944 944 member Butchers Company - Liveryman Non-pecuniary interests e9002d25 George Christopher Abrahams 131
945 945 member Smithfield Market Tenants Association (SMTA) Non-pecuniary interests e9002d25 George Christopher Abrahams 131

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