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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1516 1516 member CEO - Augmentum Capital GP - 2-4 Old Street, London, EC1V 9HL Employment, office, trade, profession or vocation e938d3aa Tim Levene 1944
1517 1517 member Director - Galmarley Ltd 12th Floor, Landmark House, Black Road, London W6 9DP Employment, office, trade, profession or vocation e938d3aa Tim Levene 1944
1518 1518 member Director - Zopa Ltd, 1st Floor Cottons Centre, Tooley Street, London SE1 2QG Employment, office, trade, profession or vocation e938d3aa Tim Levene 1944
1519 1519 member Director - Pheonix GSB, 171 Old Bakery Street, Valeta, Malta Employment, office, trade, profession or vocation e938d3aa Tim Levene 1944
1520 1520 member Director - Seeders Ltd - Churchill House, 142-146 Old Street, London EC1V 9BW Employment, office, trade, profession or vocation e938d3aa Tim Levene 1944
1521 1521 member Chair, Digital Board Royal Foundation of The Duke and Duchess of Cambridge and Prince Harry (NB role is advisory and not as a trustee) Non-pecuniary interests e9002d25 Tim Levene 1944
1522 1522 member Member of National Gallery Digital Advisory Board (NB role is advisory and not as a trustee) Non-pecuniary interests e9002d25 Tim Levene 1944
1523 1523 member John Carpenter Club (City of London School Old Boys Society) Non-pecuniary interests e9002d25 Tim Levene 1944
1524 1524 member Worshipful Company of Carmen Non-pecuniary interests e9002d25 Tim Levene 1944
1525 1525 member Member of the Bridge Ward Club Non-pecuniary interests e9002d25 Tim Levene 1944
1526 1526 member City of London Fintech Action Group Non-pecuniary interests e9002d25 Tim Levene 1944
1527 1527 member Forum of Young Global Leaders (World Economic Forum) Non-pecuniary interests e9002d25 Tim Levene 1944
1528 1528 member Global Ambassador Innovate Finance Non-pecuniary interests e9002d25 Tim Levene 1944
1529 1529 member Director 47 Queens Crescent (Management Company Ltd) - Dormant Company Non-pecuniary interests e9002d25 Tim Levene 1944
1530 1530 member Director Elmlea Consultants Ltd - Dormant Company Non-pecuniary interests e9002d25 Tim Levene 1944

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