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

15 rows where member_id = 1938

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, category_id

Link rowid ▼ kind name category_id member_id
1320 1320 member Member of the Bar of England & Wales in practice at 1 Pump Court Chambers, Elm Court, Temple, London EC4Y7AB Employment, office, trade, profession or vocation e938d3aa Ruby Sayed 1938
1321 1321 partner Nirvana Capital Ltd., 693 Charteris Road, London, NW6 7EY Employment, office, trade, profession or vocation e938d3aa Ruby Sayed 1938
1322 1322 member Nirvana Capital Ltd. - 698 Charters Road, London NW6 7EY Employment, office, trade, profession or vocation e938d3aa Ruby Sayed 1938
1323 1323 member Transition Finance (Lavenham) Ltd. - 698 Charters Road, London NW6 7EY Employment, office, trade, profession or vocation e938d3aa Ruby Sayed 1938
1324 1324 member Director, Thincats (Poland) Ltd. Newlands House, Berners Street, London W1 Employment, office, trade, profession or vocation e938d3aa Ruby Sayed 1938
1325 1325 member Gaia Re Developers Ltd. - 2nd Floor, 27 Gloucester Place, W1U 8HU Employment, office, trade, profession or vocation e938d3aa Ruby Sayed 1938
1326 1326 member Trustee & Chairperson of Asian Women's Resource Centre Non-pecuniary interests e9002d25 Ruby Sayed 1938
1327 1327 member Trustee of Bury St. Edmund's Women's Aid Non-pecuniary interests e9002d25 Ruby Sayed 1938
1328 1328 member The Honourable Society of The Inner Temple Non-pecuniary interests e9002d25 Ruby Sayed 1938
1329 1329 member Founder Member of Guild of Entrepeneurs Non-pecuniary interests e9002d25 Ruby Sayed 1938
1330 1330 member Independent/Temple & Farringdon Together Non-pecuniary interests e9002d25 Ruby Sayed 1938
1331 1331 member Member of the Bar of England & Wales Non-pecuniary interests e9002d25 Ruby Sayed 1938
1332 1332 member Director of Asian Women's Resource Centre Non-pecuniary interests e9002d25 Ruby Sayed 1938
1333 1333 member Director of Bury St. Edmund's Women's Aid Non-pecuniary interests e9002d25 Ruby Sayed 1938
1334 1334 member Trustee - Housing the Homeless Central Fund Non-pecuniary interests e9002d25 Ruby Sayed 1938

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