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

12 rows where member_id = 1939

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, category_id

Link rowid ▼ kind name category_id member_id
1010 1010 member CEO, Global Markets Consultants – 46-48 East Smithfield, London E1W 1AW Employment, office, trade, profession or vocation e938d3aa Prem Goyal 1939
1011 1011 member Institute of Directors, City of London Branch Employment, office, trade, profession or vocation e938d3aa Prem Goyal 1939
1012 1012 member Guild of Freemen Non-pecuniary interests e9002d25 Prem Goyal 1939
1013 1013 member United Wards Club Non-pecuniary interests e9002d25 Prem Goyal 1939
1014 1014 member Portsoken Ward Club Non-pecuniary interests e9002d25 Prem Goyal 1939
1015 1015 member Broad Street Ward Club Non-pecuniary interests e9002d25 Prem Goyal 1939
1016 1016 member Cripplegate Ward Club Non-pecuniary interests e9002d25 Prem Goyal 1939
1017 1017 member Aldgate Ward Club Non-pecuniary interests e9002d25 Prem Goyal 1939
1018 1018 member Bishopsgate Ward Club Non-pecuniary interests e9002d25 Prem Goyal 1939
1019 1019 member Worshipful Company of Plumbers Non-pecuniary interests e9002d25 Prem Goyal 1939
1020 1020 member Worshipful Company of World Traders Non-pecuniary interests e9002d25 Prem Goyal 1939
1021 1021 member Institute of Directors, City of London Branch Non-pecuniary interests e9002d25 Prem Goyal 1939

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