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

24 rows where member_id = 136

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: category_id

Link rowid ▼ kind name category_id member_id
1685 1685 member Chairman, Link Scheme Holdings Ltd Employment, office, trade, profession or vocation e938d3aa Sir Mark Boleat 136
1686 1686 member Occasional consultancy work Employment, office, trade, profession or vocation e938d3aa Sir Mark Boleat 136
1687 1687 member Albionrock Employment, office, trade, profession or vocation e938d3aa Sir Mark Boleat 136
1688 1688 member Centre for London - Director (unpaid) Contracts 32767bc8 Sir Mark Boleat 136
1689 1689 member Crossrail Art Foundation - Director (unpaid) Contracts 32767bc8 Sir Mark Boleat 136
1690 1690 member London Councils Pensions Collective Investment Vehicle Joint Committee (unpaid) Contracts 32767bc8 Sir Mark Boleat 136
1691 1691 member Tenancy of a flat at 172 Aldersgate Street, London Land d9df90d8 Sir Mark Boleat 136
1692 1692 member Ward of Cordwainer Club Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1693 1693 member Insurers' Livery Company Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1694 1694 member International Bankers Livery Company Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1695 1695 member Chartered Institute of Bankers Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1696 1696 member London Cycling Campaign Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1697 1697 member Society of Genealogists Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1698 1698 member Guildhall Historical Society Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1699 1699 member European Policy Forum Advisory Council Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1700 1700 member Centre for London Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1701 1701 member Crossrail Art Foundation Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1702 1702 member London Councils Pensions Collective Investment Vehicle Joint Committee Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1703 1703 member International Business and Development Exchange Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1704 1704 member Court of the City University Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1705 1705 member Franco-British Council Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1706 1706 member Housing & Finance Institute Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1707 1707 member Homes for Londoners Board Non-pecuniary interests e9002d25 Sir Mark Boleat 136
1708 1708 member City Music Foundation Non-pecuniary interests e9002d25 Sir Mark Boleat 136

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